DOHMH COVID-19 Antibody-by-Week

cqhz-kkvduncategorised5 columns

This dataset contains information on antibody testing for COVID-19: the number of people who received a test, the number of people with positive results, the percentage of people tested who tested positive, and the rate of testing per 100,000 people, stratified by week of testing. These data can also be accessed here: https://github.com/nychealth/coronavirus-data/blob/master/trends/antibody-by-week.csv Exposure to COVID-19 can be detected by measuring antibodies to the disease in a person’s blood, which can indicate that a person may have had an immune response to the virus. Antibodies are proteins produced by the body’s immune system that can be found in the blood. People can test positive for antibodies after they have been exposed, sometimes when they no longer test positive for the virus itself. It is important to note that the science around COVID-19 antibody tests is evolving rapidly and there is still much uncertainty about what individual antibody test results mean for a single person and what population-level antibody test results mean for understanding the epidemiology of COVID-19 at a population level. These data only provide information on people tested. People receiving an antibody test do not reflect all people in New York City; therefore, these data may not reflect antibody prevalence among all New Yorkers. Increasing instances of screening programs further impact the generalizability of these data, as screening programs influence who and how many people are tested over time. Examples of screening programs in NYC include: employers screening their workers (e.g., hospitals), and long-term care facilities screening their residents. In addition, there may be potential biases toward people receiving an antibody test who have a positive result because people who were previously ill are preferentially seeking testing, in addition to the testing of persons with higher exposure (e.g., health care workers, first responders.) Rates were calculated using interpolated intercensal population estimates updated in 2019. These rates differ from previously reported rates based on the 2000 Census or previous versions of population estimates. The Health Department produced these population estimates based on estimates from the U.S. Census Bureau and NYC Department of City Planning. Antibody tests are categorized based on the date of specimen collection and are aggregated by full weeks starting each Sunday and ending on Saturday. For example, a person whose blood was collected for antibody testing on Wednesday, May 6 would be categorized as tested during the week ending May 9. A person tested twice in one week would only be counted once in that week. This dataset includes testing data beginning April 5, 2020. Data are updated daily, and the dataset preserves historical records and source data changes, so each extract date reflects the current copy of the data as of that date. For example, an extract date of 11/04/2020 and extract date of 11/03/2020 will both contain all records as they were as of that extract date. Without filtering or grouping by extract date, an analysis will almost certainly be miscalculating or counting the same values multiple times. To analyze the most current data, only use the latest extract date. Antibody tests that are missing dates are not included in the dataset; as dates are identified, these events are added. Lags between occurrence and report of cases and tests can be assessed by comparing counts and rates across multiple data extract dates. For further details, visit: • https://www1.nyc.gov/site/doh/covid/covid-19-data.page • https://github.com/nychealth/coronavirus-data

View on NYC Open Data

Quality

D69.8 / 100

From a 116-row sample across 5 columns.

completeness80/ 25% weight

consistency50/ 20% weight

accuracy95/ 20% weight

timeliness24/ 15% weight

usability85/ 20% weight

· No obvious temporal column — limits time-series joins

Related datasets

Sample rows

week_ending	num_peop_test	num_peop_pos	percent_positive
2020-04-11T00:00:00.000	1153	705	0.611
2020-04-18T00:00:00.000	3819	1674	0.438
2020-04-25T00:00:00.000	33322	10977	0.329
2020-05-02T00:00:00.000	92455	29906	0.323
2020-05-09T00:00:00.000	110031

Columns

5 queryable · 5 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`week_ending`	datetime	Week-ending date. Full weeks start each Sunday and end on Saturday	0%	`2020-09-19T00:00:00.0002020-07-11T00:00:00.0002021-10-09T00:00:00.000`
`num_peop_test`	integer	Count of people tested with an antibody test by week (weekdate)	0%	`8885528553145227`
`num_peop_pos`	integer	Count of people with a positive result on an antibody test by week (weekdate). People are considered positive if they received a positive antibody result, regardless of whether they have received negative results as well	0%	`130111380613213`
`percent_positive`	float	Percentage of people with a positive COVID-19 antibody test by week (weekdate)

Query this from your own app

GET /api/datasets/cqhz-kkvd
GET /api/datasets/cqhz-kkvd/quality
GET /api/datasets/cqhz-kkvd/related
GET /api/columns?dataset=cqhz-kkvd