ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where deaths = 275 and fips = 34019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501381 | 2501381 | 2022-05-13 | Hunterdon | New Jersey | 34019 | 26017 | 275 |
2498123 | 2498123 | 2022-05-12 | Hunterdon | New Jersey | 34019 | 25907 | 275 |
2494865 | 2494865 | 2022-05-11 | Hunterdon | New Jersey | 34019 | 25817 | 275 |
2491607 | 2491607 | 2022-05-10 | Hunterdon | New Jersey | 34019 | 25758 | 275 |
2488349 | 2488349 | 2022-05-09 | Hunterdon | New Jersey | 34019 | 25694 | 275 |
2485092 | 2485092 | 2022-05-08 | Hunterdon | New Jersey | 34019 | 25683 | 275 |
2481834 | 2481834 | 2022-05-07 | Hunterdon | New Jersey | 34019 | 25638 | 275 |
2478576 | 2478576 | 2022-05-06 | Hunterdon | New Jersey | 34019 | 25584 | 275 |
2475318 | 2475318 | 2022-05-05 | Hunterdon | New Jersey | 34019 | 25524 | 275 |
2472061 | 2472061 | 2022-05-04 | Hunterdon | New Jersey | 34019 | 25467 | 275 |
2468805 | 2468805 | 2022-05-03 | Hunterdon | New Jersey | 34019 | 25420 | 275 |
2465549 | 2465549 | 2022-05-02 | Hunterdon | New Jersey | 34019 | 25386 | 275 |
2416710 | 2416710 | 2022-04-17 | Hunterdon | New Jersey | 34019 | 24917 | 275 |
2413454 | 2413454 | 2022-04-16 | Hunterdon | New Jersey | 34019 | 24902 | 275 |
2410198 | 2410198 | 2022-04-15 | Hunterdon | New Jersey | 34019 | 24841 | 275 |
2406942 | 2406942 | 2022-04-14 | Hunterdon | New Jersey | 34019 | 24841 | 275 |
2403686 | 2403686 | 2022-04-13 | Hunterdon | New Jersey | 34019 | 24806 | 275 |
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);