Total Cases By Local Authority
New reported daily and cumulative counts and rates for positive COVID-19 cases, negative tests and deaths at Council area (local authority) level.
Please note that from 18 June, the data released includes testing results from the UK Government’s Regional Testing Centres, as well as data from NHS Laboratories, including historic test results.
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Date | numeric | Date of new reported cases (including historic cases) and deaths. | |
| CA | text | Council Area code, based on boundaries as at 1st April 2019. Council area (local authority) is assigned based on ECOSS postcode, if ECOSS postcode is missing we will then use the postcode on Community Health Index database, if the postcode is blank after the previous attempts, no council area is assigned. | |
| CAName | text | Name of the Council Area (Local authority) | |
| NewPositive | numeric | Number of new confirmed positive COVID-19 cases reported. | |
| TotalCases | numeric | Total number of positive cases reported to date. | |
| CrudeRatePositive | numeric | Crude rate of total positive cases per 100,000 population. | |
| NewDeaths | numeric | Number of new COVID-19 deaths reported. COVID-19 deaths are defined as the total number of individuals who die within 28 days of a laboratory confirmed report of COVID-19 infection and are registered with National Records for Scotland. | |
| TotalDeaths | numeric | Total number of COVID-19 deaths reported to date. COVID-19 deaths are defined as the total number of individuals who die within 28 days of a laboratory confirmed report of COVID-19 infection and are registered with National Records for Scotland. | |
| CrudeRateDeaths | numeric | Crude rate of total COVID-19 deaths per 100 000 population | |
| TotalNegative | numeric | Total number of negative COVID-19 tests reported to date. | |
| CrudeRateNegative | numeric | Crude rate of total negative cases per 100,000 population. |
Additional Information
| Field | Value |
|---|---|
| Data last updated | October 22, 2021 |
| Metadata last updated | April 22, 2020 |
| Created | April 22, 2020 |
| Format | text/csv |
| License | UK Open Government Licence (OGL) |
| created | over 1 year ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | e8454cf0-1152-4bcb-b9da-4343f625dfef |
| last modified | 13 hours ago |
| mimetype | text/csv |
| on same domain | True |
| package id | b318bddf-a4dc-4262-971f-0ba329e09b87 |
| position | 1 |
| revision id | 74eb432e-1285-4b14-a3e6-88e29eda72cf |
| size | 3.5 KiB |
| state | active |
| url type | upload |