Datenverzeichnis

Spalte Typ Bezeichnung Beschreibung
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.

Zusätzliche Informationen

Feld Wert
Daten wurden zuletzt aktualisiert 19. Mai 2023
Metadaten zuletzt aktualisiert 26. Mai 2023
Erstellt 21. April 2021
Format CSV
Lizenz 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