ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where deaths = 636 and fips = 34021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
626950 | 626950 | 2020-10-13 | Mercer | New Jersey | 34021 | 8885 | 636 |
623708 | 623708 | 2020-10-12 | Mercer | New Jersey | 34021 | 8864 | 636 |
620465 | 620465 | 2020-10-11 | Mercer | New Jersey | 34021 | 8855 | 636 |
617223 | 617223 | 2020-10-10 | Mercer | New Jersey | 34021 | 8848 | 636 |
613981 | 613981 | 2020-10-09 | Mercer | New Jersey | 34021 | 8830 | 636 |
610740 | 610740 | 2020-10-08 | Mercer | New Jersey | 34021 | 8808 | 636 |
607498 | 607498 | 2020-10-07 | Mercer | New Jersey | 34021 | 8787 | 636 |
604255 | 604255 | 2020-10-06 | Mercer | New Jersey | 34021 | 8777 | 636 |
601013 | 601013 | 2020-10-05 | Mercer | New Jersey | 34021 | 8767 | 636 |
597769 | 597769 | 2020-10-04 | Mercer | New Jersey | 34021 | 8756 | 636 |
594527 | 594527 | 2020-10-03 | Mercer | New Jersey | 34021 | 8746 | 636 |
591286 | 591286 | 2020-10-02 | Mercer | New Jersey | 34021 | 8721 | 636 |
588045 | 588045 | 2020-10-01 | Mercer | New Jersey | 34021 | 8710 | 636 |
584805 | 584805 | 2020-09-30 | Mercer | New Jersey | 34021 | 8698 | 636 |
578323 | 578323 | 2020-09-28 | Mercer | New Jersey | 34021 | 8679 | 636 |
575082 | 575082 | 2020-09-27 | Mercer | New Jersey | 34021 | 8673 | 636 |
555641 | 555641 | 2020-09-21 | Mercer | New Jersey | 34021 | 8612 | 636 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);