Number and Rate of Positive COVID-19 Cases in ...

URL: https://www.opendata.nhs.scot/dataset/9251a154-84b2-498d-b59c-646cab588e9f/resource/2dca5eb6-8d9f-4931-b72b-1bdd1366febc/download/case_rate_hb_20211006.csv

The rate of COVID-19 in pregnant women, by maternal NHS Board of residence and month, in Scotland. Based on COPS pregnancy database updated in mid-September 2021, and cases of COVID-19 with date of onset up to 31 August 2021.

Maternal NHS Board of residence is based on the woman's postcode at the time of the end of her pregnancy (or antenatal booking for ongoing pregnancies)

For any individual, the specimen date of their first positive viral PCR result is taken as the date of onset of their first episode of COVID-19.
Subsequent positive viral PCR results with specimen date within 90 days of their first positive result are discounted.
If the individual then has a positive viral PCR result with specimen date ≥90 days after their first positive result, this is taken as the date of onset of their second episode of COVID-19.
Subsequent positive viral PCR results with specimen date within 90 days of this second index date are then discounted as for the first episode of COVID, and so on. COVID-19 is defined as occurring in pregnancy if the date of onset for any episode of infection occurs at any point from the estimated date of conception (date the woman was 2+0 weeks gestation) up to and including the date the pregnancy ended.

Looking at the totals for all months combined, if a woman has two pregnancies during the period covered, with different maternal NHS Board of residence (due to moving house) assigned to the separate pregnancies she will be counted against the total for each relevant Board, but only once in the overall (all Boards) total. This means that the overall (all Boards) total may be slightly lower than the sum of the specific Board totals.

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

Column Type Label Description
Country text 9-digit country code for Scotland

Country codes

Month numeric Month of onset of COVID-19
HB text Maternal health board code

Hospital board labes

HBQF text Qualifier for HB

Qualifier information

HBName text Name of maternal health board

Hospital board labes

HBNameQF text Qualifier for HBName

Qualifier information

NumberOfPregnancies numeric Number of pregnancies during each month
NumberOfCasesInPregnancy numeric Number of positive cases of COVID-19 during pregnancy
RateOfCasesInPregnancy numeric Rate of positive cases of COVID-19 in pregnancy (per 100,000)

Additional Information

Field Value
Data last updated October 6, 2021
Metadata last updated October 6, 2021
Created October 6, 2021
Format text/csv
License UK Open Government Licence (OGL)
createdover 1 year ago
datastore activeTrue
formatCSV
has viewsTrue
id2dca5eb6-8d9f-4931-b72b-1bdd1366febc
last modifiedover 1 year ago
mimetypetext/csv
on same domainTrue
package id9251a154-84b2-498d-b59c-646cab588e9f
position6
revision idb3319b81-17e3-4cb7-b04d-e16e739f58c6
size17.7 KiB
stateactive
url typeupload