From a 500-row sample across 9 columns.
sample_date| sample_date | test_date | wrrf_name | wrrf_abbreviation | copies_l | copies_l_x_average_flowrate | population_served | technology | annotation |
|---|---|---|---|---|---|---|---|---|
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | 26th Ward | 26W | 103000 | 52683003.44 | 318262 | dPCR-SC2 | — |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Bowery Bay | BB | 134000 | 55552522.77 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sample_date | datetime | Date sample was collected; The “sample” is a 24 hour composite of influent wastewater. The “sample date” is the date of start of collection. | 0% | 2023-02-21T00:00:00.0002024-02-20T00:00:00.0002022-11-20T00:00:00.000 |
test_date | datetime | Date sample was analyzed; This date is the date the analysis started (this is a three-days analysis protocol). | 0% | 2023-02-22T00:00:00.0002024-02-13T00:00:00.0002023-03-20T00:00:00.000 |
wrrf_name | categorical | Wastewater Resource Recovery Facility (waste water treatment plant) where sample was taken. Samples are taken from WRRF influent. | 0% | Rockaway26th WardNorth Riverof 14 |
wrrf_abbreviation |
GET /api/datasets/f7dc-2q9f GET /api/datasets/f7dc-2q9f/quality GET /api/datasets/f7dc-2q9f/related GET /api/columns?dataset=f7dc-2q9f
| 894311 |
| dPCR-SC2 |
| — |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Coney Island | CI | 65600 | 43346958.24 | 647635 | dPCR-SC2 | — |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Hunts Point | HP | 118000 | — | 781885 | dPCR-SC2 | This sample was analyzed in duplicate. |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Jamaica Bay | JA | 124000 | — | 735054 | dPCR-SC2 | This sample was analyzed in duplicate. |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Newtown Creek | NC | 125000 | — | 1227810 | dPCR-SC2 | This sample was analyzed in duplicate. |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | North River | NR | 56900 | — | 649549 | dPCR-SC2 | — |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Oakwood Beach | OB | 114000 | — | 243910 | dPCR-SC2 | — |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Owls Head | OH | 145000 | 50571908.45 | 923524 | dPCR-SC2 | — |
| 2026-09-29T00:00:00.000 | 2026-10-01T00:00:00.000 | Port Richmond | PR | 83600 | — | 224516 | dPCR-SC2 | — |
| categorical |
| WRRF Abbreviation; Two letter abbreviation for WRRF name. |
| 0% |
OBHPPRof 14 |
copies_l | integer | Concentration of the N1 target of SARS-CoV2 genetic material measured in wastewater influent. (please see attached data dictionary for added detail) | 3% | 114001200013400 |
copies_l_x_average_flowrate | integer | Normalized SARS-CoV-2 N gene concentration (taking into account average daily flow and total population); (please see attached data dictionary for added detail) | 4% | 104000001180000010900000 |
annotation | text | notes on sampling and testing | 72% | This sample was analyzed…Multiplex Overlap StudyThis sample was analyzed… |
population_served | categorical | Population of sewershed; Estimated from 2020 New York Department of City Planning population estimate model. | 0% | 457817257556243910of 14 |
technology | categorical | PCR technology used to generate copies/L | 0% | dPCR-SC2RT-qPCR - N1dPCR - N1of 3 |