Data Dictionary

Column Type Label Description
test_type text Test Type

Classification of viral test that checks for the presence of SARS-CoV-2.

Possible values: PCR, Antigen.

test_result text Test Result

Outcome of viral test.

Possible values: Positive, Negative, Inconclusive, Null.

specimen_collected_date timestamp Specimen Collection Date

Date of service for COVID-19 viral test.

test_report_date timestamp Test Report Date

The date for when viral test result was reported to the state.

age_bucket text Age Bucket

Gives the age range at report_date for an individual with all those over the age of 70 are put into a single bucket. When not available in the PA-NEDSS information, the values in the Allegheny County data warehouse are used.

Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70+.

race text Race

Race of the individual. When not available in the PA-NEDSS information, the values in the Allegheny County data warehouse are used.

Possible values: White, Black, Asian American, Indian/Pacific Islander, Other, Unknown.

sex text Legal Sex

Legal sex of the individual. When not available in the PA-NEDSS information, the values in the Allegheny County data warehouse are used.

Possible values: F (Female), M (Male), U (Unknown).

ethnicity text Ethnicity

Ethnicity of the individual. When not available in the PA-NEDSS information, the values in the Allegheny County data warehouse are used.

Possible values: Hispanic, Not Hispanic, Unknown.

test_report_year numeric Test Report Year
test_report_quarter numeric Test Report Quarter
update_date timestamp Update Date

Date of most recent update to the dataset.

Additional Information

Field Value
Data last updated May 19, 2023
Metadata last updated May 26, 2023
Created April 21, 2021
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Hash7b6d900684c0c328004d678a53a855ae
Idec9ced6e-9d5e-4982-a591-459252725937
Mimetypetext/csv
Package id80e0ca5d-c88a-4b1a-bf5d-51d0aaeeac86
Partial downloadFalse
Position1
PreviewTrue
Preview rows3,996,511
Size323.4 MiB
Stateactive
Total record count3,996,511
Url typeupload