Data available in Smart Care Intel

Published transactions 11 fields

• Authority and region
• Transaction and payment dates
• Transaction reference
• Original supplier and supplier reference
• Department and service area
• Expenditure and merchant categories
• Purpose/description
• Amount and credits
• VAT and unrecoverable VAT
• Gross/net/unspecified amount basis
• Procurement reference

Supplier and care evidence 7 fields

• Matched Companies House number
• CQC provider/location and group identifiers
• Supplier match method, confidence and review
• Care-related expenditure classification and reason
• Observed receipts and concentration
• Registered capacity snapshot and eligible receipts-per-bed context
• Linked court events and deregistrations

Coverage and provenance 8 fields

• Source authority and publication URL
• Publication period and status
• Retained file name, size and checksum
• Versioned parser and schema fingerprint
• Accepted/rejected row counts
• Source row number, worksheet and original values
• Import timestamp
• Source health and missing publication periods

CQC Data 3 groups

Data Points 11 fields

• Location ID
• Provider ID
• Location Name
• Provider Name
• Postcode
• Local Authority
• Region
• ICB
• Location Status
• Registration Date
• Last Updated Date

Change Tracking 5 fields

• Rating Changes
• Manager Changes
• Provider Changes
• Registration Changes
• Address Changes

Data Quality 4 fields

• Last Sync Date
• Missing Fields Flags
• Duplicate Detection
• Confidence Score

CQC Ratings 4 groups

Data Points 8 fields

• Overall Rating
• Safe
• Effective
• Caring
• Responsive
• Well-led
• Inspection Date
• Publication Date

History 4 fields

• Previous Ratings
• Change Dates
• Trend Direction
• Time Between Inspections

Derived Metrics 5 fields

• Numeric Score
• Volatility
• Improvement Score
• Downgrade Risk
• Consistency Index

Benchmarking 3 fields

• Local Authority Average
• Regional Average
• Peer Group Comparison

CQC Warnings 3 groups

Data Points 4 fields

• Warning Notices
• Restriction Notices
• Enforcement Actions
• Urgent Conditions

Timeline 4 fields

• Issue Date
• Resolution Date
• Status
• Duration Active

Risk Signals 3 fields

• Repeat Warnings
• Escalation Patterns
• Linked Inspection Outcomes

Provider Details 3 groups

Data Points 5 fields

• Provider Name
• Ownership Type
• Registration Status
• Provider Size (Locations)
• Legal Entity Type

Group Structure 4 fields

• Parent Company
• Subsidiaries
• Linked Providers
• Brand Names

Risk Indicators 3 fields

• Group Rating Spread
• Multi-location Failure Patterns
• Rapid Expansion Flags

Key Data Points 6 fields · 1 group

• Beds
• Service Types
• Registration Date
• Last Inspection Date
• Specialisms
• Client Groups

Operational Indicators 3 fields

• Capacity
• Service Mix
• Care Complexity Indicator

Rankings 4 fields

• Local Rank
• Regional Rank
• National Rank
• Percentile Score

HMRC / Companies House 6 groups

Company Profile 5 fields

• Company Number
• Status
• Incorporation Date
• Registered Address
• SIC Codes

Accounts 5 fields · 1 group

• Turnover
• Profit
• Assets
• Liabilities
• Net Worth

Trends 4 fields

• Year-on-Year
• Financial Stability
• Growth Rate
• Profit Margin

Directors 5 fields · 1 group

• Name
• DOB
• Appointments
• Nationality
• Occupation

Network Analysis 3 fields

• Other Companies
• Cross Links
• Director Risk Score

Charges 4 fields

• Amount
• Security
• Charge Holder
• Charge Status

Insolvency 4 fields

• Case Type
• Status
• Appointment Date
• Practitioner

Land Registry 2 groups

Ownership 3 fields

• Title Number
• Owner
• Tenure

Transactions 3 fields

• Sale Date
• Sale Price
• Transaction Type

Managers / Nominated Individuals 4 fields · 2 groups

• Name
• Role
• Start Date
• Registration Status

History 3 fields

• Previous Managers
• Tenure
• Turnover Rate

Risk Indicators 2 fields

• Frequent Changes
• Short Tenure Flags

CQC Inspections SAF 2 groups

All SAF Text 5 fields

• Quality Statements
• Evidence
• Narratives
• Good Practice Examples
• Areas for Improvement

AI Analysis 4 fields

• Positive Signals
• Negative Signals
• Theme Extraction
• Improvement Suggestions

CQC Inspections KLOES 1 group

All KLOE Text 3 fields

• Inspector Commentary
• Evidence
• Key Findings

Related Locations 3 fields

• Shared Providers
• Group Links
• Geographic Clusters

Energy Certificates 3 groups

Data Points 5 fields

• EPC Rating
• Floor Area
• CO2
• Inspection Date
• Building Type

Derived Metrics 3 fields

• m² per Bed
• CO2 per Bed
• Energy Efficiency Score

Investment Indicators 3 fields

• Refurbishment Need
• Upgrade Potential
• Cost Pressure Indicator

MSIF 3 groups

Data Points 4 fields

• Funding Rates
• Local Authority Rates
• Care Home Rate (65+ Nursing)
• Care Home Rate (65+ Non-Nursing)

Trend Analysis 3 fields

• Year-on-Year
• Regional Variation
• Funding Growth Rate

Commercial Insights 2 fields

• Underfunding Indicator
• Margin Pressure Estimate

Scottish Care Inspectorate 1 group

Data Points 2 fields

• Ratings
• Reports

Welsh Care Inspectorate 1 group

Data Points 2 fields

• Ratings
• Reports

Land Registry (from 1995) 2 groups

Data Points 2 fields

• Ownership Records
• Transactions

Derived Insights 3 fields

• Property Ownership History
• Sale Value Trends
• Investment Patterns

Company Search 1 group

Data Points 2 fields

• 56M+ Directors
• 7M+ Companies

Charity Commission 1 group

Data Points 3 fields

• Charities
• Trustees
• Financials

Members of Parliament 11 fields

• Full and display name
• House
• Party
• Constituency
• Current-member status
• Membership start and end dates
• Official portrait
• Published email and contact details
• Official profile link
• Parliamentary positions
• Registered interests

Constituencies 8 fields

• Constituency name
• Nation
• Boundary version
• Current status
• ONS geography code
• Population
• Population year and source
• Mapped care locations and matching confidence

Parliamentary activity 11 fields

• Activity type
• Title
• Published text
• Activity date
• House
• Member
• Department
• Primary topic
• Topics
• Care-relevance score and reason
• Official source link

Questions, answers and debates 9 fields

• Question title and text
• Question type
• Reference
• Status
• Answer text and date
• Answering member
• House
• Department
• Published source link

Bills, legislation and votes 10 fields

• Bill title and long title
• Current stage
• Session
• Status
• Stage name and date
• Statutory instrument and treaty procedure
• Division number
• Aye and no totals
• Result
• Member vote, party and teller status

Committees, inquiries and publications 7 fields

• Committee title and type
• Current status
• Member and role
• Inquiry title and dates
• Inquiry status
• Publication title and type
• Committee and published source link

All-Party Parliamentary Groups 7 fields

• Group name
• Purpose
• Current status
• Register date
• Member name, party and role
• Member matching status
• Official register link

Consultations and opportunities 7 fields

• Opportunity type
• Title and description
• Organisation
• Status
• Opening and closing dates
• Care-relevance score and reason
• Published source link

Councils 11 fields

• Council and official name
• Authority type
• Country and region
• Government geography code
• Website and official members and meetings links
• Care-commissioning responsibility and dates
• Executive arrangements
• Administration and party composition
• Governance sources and interventions
• Councillor count
• Expected meetings, meetings attended and attendance percentage

Councillors 9 fields

• Full name
• Party as published and normalised party
• Ward or division
• Current role
• Published email, telephone and mobile number
• Photo
• Official profile link and social links
• Active status
• Expected meetings, meetings attended and attendance percentage

Councillor terms and roles 7 fields

• Council
• Ward or division
• Party
• Term start and end dates
• Current-term status
• Cabinet, leader, chair and committee roles
• Role source link

Council meetings 8 fields

• Meeting title
• Date and time
• Status
• Location
• Agenda
• Meeting documents
• Published meeting link
• Care-relevance flag and reason

Planning authorities and coverage 10 fields

• Planning authority name
• Region
• Official geography code
• Authority status and dates
• Website, planning register and search links
• Planning system type
• Political and upper-tier council context
• Source provider and source type
• Coverage status
• Date, geometry and document support

Planning applications and decisions 11 fields

• Application reference
• Description
• Address and postcode
• Applicant and agent
• Application, received and validated dates
• Decision date
• Application status and type
• Decision and decision type
• UPRN
• Latitude and longitude
• Official application and documents links

Care-development assessment 9 fields

• Care-related flag
• Care-development type
• Care relevance score
• Proposed beds
• Existing beds affected
• Net bed change
• Proposed units
• Net unit change
• Capacity confidence

Application documents, changes and matches 6 fields

• Document title, type, date and published link
• Event type and event date
• Previous and new status or decision value
• Matched entity type
• Match method and status
• Match evidence

Company register 7 fields

• Company number
• Company name
• Status
• Incorporation and cessation dates
• Registered office address
• SIC codes
• Previous names

Directors, officers and PSCs 7 fields

• Officer or director name
• Appointment and resignation dates
• Role
• Nationality and occupation where published
• Correspondence address
• Other appointments
• People with significant control

Accounts and financial statements 7 fields

• Accounts period
• Turnover
• Profit or loss
• Cash
• Assets and liabilities
• Net assets
• Employee costs and employee count where filed

Filings, charges and insolvency 7 fields

• Filing history and filing type
• Confirmation statements
• Charge status and secured details
• Persons entitled
• Insolvency cases, dates and practitioners
• Pre-insolvency signals
• Disqualified officers

Court cases 7 fields

• Court
• Case reference
• Case type and status
• Filed, hearing and event dates
• Parties
• Company reference where recorded
• Case events

Gazette notices 6 fields

• Notice type
• Publication date
• Court where published
• Company and party references
• Meetings
• Notice text and source link where available

Insolvency links 4 fields

• Company insolvency status
• Administration and liquidation events
• Practitioner details
• Recorded corporate and court references

Charity register 6 fields

• Organisation and charity registration numbers
• Name and registration status
• Legal form
• Contact details
• Areas of operation
• Activities and classifications

Governance and people 6 fields

• Trustees
• Other names
• Other regulators
• Governing documents
• Policies
• Trading-subsidiary information where reported

Returns and financial information 5 fields

• Annual-return periods and dates
• Income and expenditure
• Accounts-received date
• Qualified-accounts indicator
• Published reports

Land Registry price paid data 5 fields

• Transaction price
• Transfer date
• Property type
• New-build and tenure indicators
• Address and postcode

EPC certificates 6 fields

• Energy rating and score
• Certificate and inspection dates
• Floor area
• Property and building type
• CO2 emissions
• Recommendations

Care-home building metrics 4 fields

• Location-linked building measures
• Beds
• Floor-area and energy comparisons
• Location match confidence

Geography lookups 8 fields

• Postcodes
• Local authorities
• Wards
• Counties
• Regions
• ICBs and NHS regions
• Constituencies
• Travel-to-work areas

CQC geography links 3 fields

• CQC location identifier
• Postcode and UPRN links
• Local-authority, region, ICB and constituency codes

Population and self-funding 3 fields

• Population estimates by age and sex
• Reference year
• Local-authority self-funding statistics

Food hygiene records 6 fields

• Business name and address
• Food hygiene rating
• Inspection date
• Local authority
• Business type
• Scheme type

Location matching fields 4 fields

• CQC location identifier
• Business name
• Postcode
• Inspection date

CQC assessments and inspection narrative 5 fields

• Assessment date and status
• Quality statements and topic areas
• Rating evidence and narrative
• SAF trends and themes
• Legacy inspection report content

Scotland 4 fields

• Service register
• Service type and capacity
• Inspection events
• Grades and requirements

Wales 4 fields

• Service register
• Provider and responsible-person details
• Service ratings where published
• Service provision and registered-person records

MSIF provider fees and annual rates 5 fields

• Local-authority annual rates
• Provider fee submissions
• Service category
• Financial year
• Nursing and non-nursing rate fields

Adult social care funding context 10 fields

• Actual adult social care expenditure
• Published adult social care budgets
• Activity and demand
• Outcomes framework
• Core Spending Power settlements
• Deprivation and population context
• Population aged 65+ and 85+
• Population projections
• Spend per resident and care recipient
• CQC provider, location and registered-bed snapshots

Calculated market fields 10 fields

• Spend per resident aged 65+
• Spend per resident aged 85+
• Spend per care recipient
• Beds per 1,000 residents aged 85+
• Providers per 10,000 residents aged 85+
• Residential fee uplift
• Recipient growth
• Provider growth or decline
• Funding pressure index
• Market sustainability score

Workforce size · Source population 11 fields

• Total posts
• Filled posts
• Full-time equivalent posts
• FTE Ratio
• Employees
• Estimated filled posts
• CQC locations
• Annual percentage change (%)
• Monthly percentage change (%)
• International recruits
• Retention rate

Qualifications and Care Certificate · Source population 29 fields

• Filled posts for quals
• Care Certificate complete (%)
• Care Certificate in progress (%)
• Care Certificate not started (%)
• Care Certificate - Complete count
• Care Certificate - In progress / Partially complete count
• Care Certificate - Not started count
• Relevant social care qualification (%)
• No relevant social care qualification (%)
• Quals - Has relevant social care qualification count
• Quals - No relevant social care qualification count
• Quals - Entry (%)
• Quals - Level 1 (%)
• Quals - Level 2 (%)
• Quals - Level 3 (%)
• Quals - Level 4 (%)
• Quals - Level 5 (%)
• Quals - Level 6 (%)
• Quals - Level 7 (%)
• Quals - Level 8 plus (%)
• Quals - Entry count
• Quals - Level 1 count
• Quals - Level 2 count
• Quals - Level 3 count
• Quals - Level 4 count
• Quals - Level 5 count
• Quals - Level 6 count
• Quals - Level 7 count
• Quals - Level 8 plus count

Experience and retention · Source population 33 fields

• Turnover rate
• Leavers
• Average sector experience (years)
• Exp in Sector - Less than 1 year (%)
• Exp in Sector - 1 to 2 years (%)
• Exp in Sector - 3 to 4 years (%)
• Exp in Sector - 5 to 6 years (%)
• Exp in Sector - 7 to 9 years (%)
• Exp in Sector - 10 to 19 years (%)
• Exp in Sector - 20 years or more (%)
• Exp in Sector - Less than 1 year count
• Exp in Sector - 1 to 2 years count
• Exp in Sector - 3 to 4 years count
• Exp in Sector - 5 to 6 years count
• Exp in Sector - 7 to 9 years count
• Exp in Sector - 10 to 19 years count
• Exp in Sector - 20 years or more count
• Average role experience (years)
• Exp in Role - Less than 1 year (%)
• Exp in Role - 1 to 2 years (%)
• Exp in Role - 3 to 4 years (%)
• Exp in Role - 5 to 6 years (%)
• Exp in Role - 7 to 9 years (%)
• Exp in Role - 10 to 19 years (%)
• Exp in Role - 20 years or more (%)
• Exp in Role - Less than 1 year count
• Exp in Role - 1 to 2 years count
• Exp in Role - 3 to 4 years count
• Exp in Role - 5 to 6 years count
• Exp in Role - 7 to 9 years count
• Exp in Role - 10 to 19 years count
• Exp in Role - 20 years or more count
• Average sickness days

Recruitment and vacancies · Source population 8 fields

• Vacancy rate
• Vacant posts
• Source of Rec - Within ASC (%)
• Source of Rec - Outside ASC (%)
• Source of Rec - Within ASC count
• Source of Rec - Outside ASC count
• Starters rate
• Starters

Employment and working hours · Source population 18 fields

• Permanent staff (%)
• Temporary staff (%)
• Bank or pool staff (%)
• Agency staff (%)
• Emp Stat - Other (%)
• Emp Stat - Permanent count
• Emp Stat - Temporary count
• Emp Stat - Bank or pool count
• Emp Stat - Agency count
• Emp Stat - Other count
• Full-time staff (%)
• Part-time staff (%)
• Working Time - Full time count
• Working Time - Part time count
• Zero-hours contracts (%)
• Zero Hour Contracts - No (%)
• Zero Hour Contracts - Yes count
• Zero Hour Contracts - No count

Gender, ethnicity and disability · Source population 18 fields

• Gender - Male (%)
• Gender - Female (%)
• Gender - Male count
• Gender - Female count
• Ethnicity - White (%)
• Ethnicity - Mixed (%)
• Ethnicity - Asian (%)
• Ethnicity - Black (%)
• Ethnicity - Other (%)
• Ethnicity - White count
• Ethnicity - Mixed count
• Ethnicity - Asian count
• Ethnicity - Black count
• Ethnicity - Other count
• Disability - Disabled (%)
• Disability - Not disabled (%)
• Disability - Disabled count
• Disability - Not disabled count

Age · Source population 31 fields

• Average age (years)
• Age - Under 18 (%)
• Age - 18 - 19 (%)
• Age - 20 - 24 (%)
• Age - 25 - 29 (%)
• Age - 30 - 34 (%)
• Age - 35 - 39 (%)
• Age - 40 - 44 (%)
• Age - 45 - 49 (%)
• Age - 50 - 54 (%)
• Age - 55 - 59 (%)
• Age - 60 - 64 (%)
• Age - 65 - 69 (%)
• Age - 70 and over (%)
• Age - Under 18 count
• Age - 18 - 19 count
• Age - 20 - 24 count
• Age - 25 - 29 count
• Age - 30 - 34 count
• Age - 35 - 39 count
• Age - 40 - 44 count
• Age - 45 - 49 count
• Age - 50 - 54 count
• Age - 55 - 59 count
• Age - 60 - 64 count
• Age - 65 - 69 count
• Age - 70 and over count
• Aged under 25 (count)
• Aged 25–39 (count)
• Aged 40–54 (count)
• Aged 55+ (count)

Nationality · Source population 6 fields

• British nationality (%)
• EU nationality (non-British) (%)
• Non-EU nationality (%)
• Nationality - British count
• Nationality - EU (non-British) count
• Nationality - Non-EU count

Pay · Source population 2 fields

• FTE Annual Pay
• Hourly pay

Workforce size · LA + IND only 11 fields

• Total posts
• Filled posts
• Full-time equivalent posts
• FTE Ratio
• Employees
• Country of Birth - UK born (%)
• Country of Birth - EU (non-UK) (%)
• Country of Birth - Non-EU (%)
• Country of Birth - UK born count
• Country of Birth - EU (non-UK) count
• Country of Birth - Non-EU count

Qualifications and Care Certificate · LA + IND only 29 fields

• Filled posts for quals
• Care Certificate complete (%)
• Care Certificate in progress (%)
• Care Certificate not started (%)
• Care Certificate - Complete count
• Care Certificate - In progress / Partially complete count
• Care Certificate - Not started count
• Relevant social care qualification (%)
• No relevant social care qualification (%)
• Quals - Has relevant social care qualification count
• Quals - No relevant social care qualification count
• Quals - Entry (%)
• Quals - Level 1 (%)
• Quals - Level 2 (%)
• Quals - Level 3 (%)
• Quals - Level 4 (%)
• Quals - Level 5 (%)
• Quals - Level 6 (%)
• Quals - Level 7 (%)
• Quals - Level 8 plus (%)
• Quals - Entry count
• Quals - Level 1 count
• Quals - Level 2 count
• Quals - Level 3 count
• Quals - Level 4 count
• Quals - Level 5 count
• Quals - Level 6 count
• Quals - Level 7 count
• Quals - Level 8 plus count

Recruitment and vacancies · LA + IND only 8 fields

• Starters rate
• Starters
• Vacancy rate
• Vacant posts
• Source of Rec - Within ASC (%)
• Source of Rec - Outside ASC (%)
• Source of Rec - Within ASC count
• Source of Rec - Outside ASC count

Experience and retention · LA + IND only 33 fields

• Turnover rate
• Leavers
• Average sector experience (years)
• Exp in Sector - Less than 1 year (%)
• Exp in Sector - 1 to 2 years (%)
• Exp in Sector - 3 to 4 years (%)
• Exp in Sector - 5 to 6 years (%)
• Exp in Sector - 7 to 9 years (%)
• Exp in Sector - 10 to 19 years (%)
• Exp in Sector - 20 years or more (%)
• Exp in Sector - Less than 1 year count
• Exp in Sector - 1 to 2 years count
• Exp in Sector - 3 to 4 years count
• Exp in Sector - 5 to 6 years count
• Exp in Sector - 7 to 9 years count
• Exp in Sector - 10 to 19 years count
• Exp in Sector - 20 years or more count
• Average role experience (years)
• Exp in Role - Less than 1 year (%)
• Exp in Role - 1 to 2 years (%)
• Exp in Role - 3 to 4 years (%)
• Exp in Role - 5 to 6 years (%)
• Exp in Role - 7 to 9 years (%)
• Exp in Role - 10 to 19 years (%)
• Exp in Role - 20 years or more (%)
• Exp in Role - Less than 1 year count
• Exp in Role - 1 to 2 years count
• Exp in Role - 3 to 4 years count
• Exp in Role - 5 to 6 years count
• Exp in Role - 7 to 9 years count
• Exp in Role - 10 to 19 years count
• Exp in Role - 20 years or more count
• Average sickness days

Employment and working hours · LA + IND only 18 fields

• Permanent staff (%)
• Temporary staff (%)
• Bank or pool staff (%)
• Agency staff (%)
• Emp Stat - Other (%)
• Emp Stat - Permanent count
• Emp Stat - Temporary count
• Emp Stat - Bank or pool count
• Emp Stat - Agency count
• Emp Stat - Other count
• Full-time staff (%)
• Part-time staff (%)
• Working Time - Full time count
• Working Time - Part time count
• Zero-hours contracts (%)
• Zero Hour Contracts - No (%)
• Zero Hour Contracts - Yes count
• Zero Hour Contracts - No count

Gender, ethnicity and disability · LA + IND only 18 fields

• Gender - Male (%)
• Gender - Female (%)
• Gender - Male count
• Gender - Female count
• Ethnicity - White (%)
• Ethnicity - Mixed (%)
• Ethnicity - Asian (%)
• Ethnicity - Black (%)
• Ethnicity - Other (%)
• Ethnicity - White count
• Ethnicity - Mixed count
• Ethnicity - Asian count
• Ethnicity - Black count
• Ethnicity - Other count
• Disability - Disabled (%)
• Disability - Not disabled (%)
• Disability - Disabled count
• Disability - Not disabled count

Age · LA + IND only 31 fields

• Average age (years)
• Age - Under 18 (%)
• Age - 18 - 19 (%)
• Age - 20 - 24 (%)
• Age - 25 - 29 (%)
• Age - 30 - 34 (%)
• Age - 35 - 39 (%)
• Age - 40 - 44 (%)
• Age - 45 - 49 (%)
• Age - 50 - 54 (%)
• Age - 55 - 59 (%)
• Age - 60 - 64 (%)
• Age - 65 - 69 (%)
• Age - 70 and over (%)
• Age - Under 18 count
• Age - 18 - 19 count
• Age - 20 - 24 count
• Age - 25 - 29 count
• Age - 30 - 34 count
• Age - 35 - 39 count
• Age - 40 - 44 count
• Age - 45 - 49 count
• Age - 50 - 54 count
• Age - 55 - 59 count
• Age - 60 - 64 count
• Age - 65 - 69 count
• Age - 70 and over count
• Aged under 25 (count)
• Aged 25–39 (count)
• Aged 40–54 (count)
• Aged 55+ (count)

Nationality · LA + IND only 6 fields

• British nationality (%)
• EU nationality (non-British) (%)
• Non-EU nationality (%)
• Nationality - British count
• Nationality - EU (non-British) count
• Nationality - Non-EU count

Pay · LA + IND only 2 fields

• FTE Annual Pay
• Hourly pay

Workforce and care capacity comparisons 5 fields

• Providers and locations
• Care homes and known registered beds
• Share of England filled posts and known beds
• Filled posts per 100 beds for compatible care-home populations
• Local-authority and regional comparisons

Reporting and geography fields 14 fields

• Reporting year
• Reporting period
• Area code
• Area name
• Area level
• Region
• Employer sector
• Service type
• Job role group
• Job role
• Source publication
• Source URL
• Import date
• Suppressed measures

Care-home occupancy and beds 5 fields

• Occupancy rate
• Reported and occupied beds
• Vacant beds available for admission
• Vacant beds unavailable for admission
• Bed counts and percentages by published category

People receiving care and provider context 6 fields

• Care-home residents
• Residents in older-adult and younger-adult care homes
• People receiving domiciliary care
• Provider response rates
• Visiting, workforce and vaccination measures where published
• Digital social care record adoption

Reporting and geography fields 14 fields

• Reporting date
• Reporting year
• Reporting month
• Release date
• Area code
• Area name
• Area level
• Region
• Service type
• Provider type
• Age group
• Source publication
• Source URL
• Suppressed measures

Requests, assessments and support 6 fields

• Requests for support
• Route of access
• Outcome after request, including detailed no-further-action categories
• People receiving assessments during the month
• People receiving long-term support at month end
• Short-term support episodes and outcomes

Reviews, outcomes and breakdowns 7 fields

• People whose long-term care plans were reviewed
• Planned and unplanned reviews
• Employment and accommodation status
• Age bands
• Support setting and primary support reason
• Published population rates where supplied
• England, regional and local-authority comparisons

Reporting and geography fields 17 fields

• Reporting period
• Reporting date
• Financial year
• Frequency
• Publication date
• Revision date
• Geography code
• Geography name
• Geography level
• Region code
• Region
• Council social services code
• Source table
• Source view
• Aggregation level
• Unit
• Value status

Concerns, enquiries and people 5 fields

• Safeguarding concerns
• Section 42 enquiries
• Other safeguarding enquiries
• Individuals involved
• Age, sex, ethnicity, support reason and health-condition breakdowns

Risks, locations and outcomes 6 fields

• Type and location of risk
• Source of risk
• Risk assessment and enquiry outcomes
• Mental capacity and advocacy categories
• Published annual figures and previous-year changes
• Local-authority comparisons and maps

Reporting and geography fields 19 fields

• Reporting year
• Geographic granularity
• Area code
• Area name
• Council type
• ONS code
• Local authority code
• Local authority name
• Region code
• Region name
• Source table reference
• Enquiry type
• Category
• Subcategory
• Value
• Value status
• Current record flag
• Publication date
• Revision date

Court activity linked to care companies 5 fields

• Care companies associated with court notifications
• Court case reference, event type, date and recorded status
• First observed and repeat-event companies
• Company and provider names
• Geographic and care-service breakdowns

Care capacity and subsequent outcomes 6 fields

• Locations and known beds potentially exposed
• CQC snapshots around court events
• Subsequent location closures and known beds lost
• Company status and cessation dates
• Time between court events and recorded closures
• Underlying case and location records

Reporting and matching fields 14 fields

• Court event date
• Court case type
• Court status
• Company number
• CQC location identifier
• CQC provider identifier
• Snapshot month
• Local authority
• Region
• Service category
• Company status
• Company cessation date
• Location closure date
• Source URL

Assessment evidence and themes 6 fields

• Assessment evidence excerpts
• Quality statements and themes
• Positive signals and concerns
• Provider, location and assessment context
• Evidence review status
• Analysed-evidence summaries and downloads

Classification validation 4 fields

• Human-reviewed benchmark labels
• Classifier results compared with human review
• Positive and negative classifications by theme
• Misclassifications and run completion status

Evidence and classification fields 12 fields

• Location identifier
• Location name
• Local authority
• Service type
• Assessment publication date
• Quality statement
• Theme
• Evidence excerpt
• Classification label
• Human review label
• Review status
• Benchmark run status

News monitoring 5 fields

• Article title
• Source and source URL
• Publication date
• Summary and tags
• Deal metadata where available

Prevention of Future Deaths reports 4 fields

• Report reference
• Publication date
• Court and coroner information where published
• Named organisations and linked report source

FCA mutuals and societies 1 field

• Society registration fields (no verified records)

Expenditure and income 11 fields

• Gross current expenditure
• Net current expenditure
• Long-term care expenditure
• Short-term care expenditure
• Other care expenditure
• Client contributions
• NHS income
• Joint-arrangement income
• Other income
• Capital expenditure
• Grants to voluntary organisations

Services and unit costs 12 fields

• Nursing care
• Residential care
• Supported accommodation
• Direct payments
• Homecare
• Supported living
• Other community care
• Weekly nursing unit cost
• Weekly residential unit cost
• Homecare hourly cost
• In-house provision
• External provision

Dimensions and source fields 18 fields

• Financial year
• England / region / local authority
• ONS geography code
• Age band
• Primary support reason
• Care type
• Finance type
• Provision type
• Mandatory / voluntary data
• Official UUID
• Source table
• Published value
• Suppression / availability
• Publication date
• Official revision date
• File SHA-256
• Import date
• Quality warnings

Outcome measures 25 fields

• Social care-related quality of life
• Adjusted quality of life: impact of social care
• Carer-reported quality of life
• Satisfaction with care and support
• Carer satisfaction with social services
• Reablement without further ongoing support request
• Residential/nursing admissions, ages 18–64
• Residential/nursing admissions, ages 65+
• In the community within 12 weeks after hospital discharge into reablement, ages 65+
• Hospital discharges receiving reablement, ages 65+
• Living at home or with family: learning disability, ages 18–64
• Living at home or with family, ages 18–64
• Living at home or with family, ages 65+
• Control over daily life
• Carers included in discussions about care
• Ease of finding information about services
• Carers finding information about support
• People receiving self-directed support
• Care users receiving direct payments
• People using services who feel safe
• Safeguarding enquiries with identified risk reduced or removed
• People using services with desired social contact
• Carers with desired social contact
• Care workforce leaving their role
• Care homes rated good or outstanding

Breakdowns and uncertainty 9 fields

• Age band
• Sex
• Care-home rating category
• Outcome value
• Numerator
• Denominator
• Survey response base
• Published margin of error
• Suppression / availability

Geography, periods and provenance 13 fields

• Financial year
• Carer survey reference year
• England / region / local authority / council type
• ONS geography code
• ASCOF metric code
• Objective
• Source collection
• Methodology / comparability group
• Publication date
• Official revision date
• File SHA-256
• Import date
• Council quality warnings