ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where deaths = 2739 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- Florida 7
- Texas 6
- California 5
- Missouri 3
- New York 2
- Arizona 1
- Massachusetts 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451955 | 2451955 | 2022-04-28 | Essex | Massachusetts | 25009 | 209340 | 2739 |
2418356 | 2418356 | 2022-04-18 | Fresno | California | 6019 | 254590 | 2739 |
2415100 | 2415100 | 2022-04-17 | Fresno | California | 6019 | 254590 | 2739 |
2411844 | 2411844 | 2022-04-16 | Fresno | California | 6019 | 254590 | 2739 |
2408588 | 2408588 | 2022-04-15 | Fresno | California | 6019 | 254590 | 2739 |
2239613 | 2239613 | 2022-02-22 | Polk | Florida | 12105 | 197390 | 2739 |
2236362 | 2236362 | 2022-02-21 | Polk | Florida | 12105 | 197390 | 2739 |
2233111 | 2233111 | 2022-02-20 | Polk | Florida | 12105 | 197390 | 2739 |
2229860 | 2229860 | 2022-02-19 | Polk | Florida | 12105 | 197390 | 2739 |
2226609 | 2226609 | 2022-02-18 | Polk | Florida | 12105 | 197390 | 2739 |
2223358 | 2223358 | 2022-02-17 | Polk | Florida | 12105 | 195864 | 2739 |
2220107 | 2220107 | 2022-02-16 | Polk | Florida | 12105 | 195864 | 2739 |
2082133 | 2082133 | 2022-01-04 | Allegheny | Pennsylvania | 42003 | 186760 | 2739 |
2071712 | 2071712 | 2022-01-01 | St. Louis | Missouri | 29189 | 154468 | 2739 |
2068461 | 2068461 | 2021-12-31 | St. Louis | Missouri | 29189 | 154468 | 2739 |
2065210 | 2065210 | 2021-12-30 | St. Louis | Missouri | 29189 | 154468 | 2739 |
1474995 | 1474995 | 2021-07-01 | El Paso | Texas | 48141 | 136643 | 2739 |
1471749 | 1471749 | 2021-06-30 | El Paso | Texas | 48141 | 136622 | 2739 |
1468504 | 1468504 | 2021-06-29 | El Paso | Texas | 48141 | 136611 | 2739 |
1465259 | 1465259 | 2021-06-28 | El Paso | Texas | 48141 | 136578 | 2739 |
1462014 | 1462014 | 2021-06-27 | El Paso | Texas | 48141 | 136571 | 2739 |
1458769 | 1458769 | 2021-06-26 | El Paso | Texas | 48141 | 136555 | 2739 |
1003449 | 1003449 | 2021-02-06 | Nassau | New York | 36059 | 133357 | 2739 |
971009 | 971009 | 2021-01-27 | Suffolk | New York | 36103 | 138812 | 2739 |
949865 | 949865 | 2021-01-21 | Riverside | California | 6065 | 255808 | 2739 |
450473 | 450473 | 2020-08-20 | Maricopa | Arizona | 4013 | 130800 | 2739 |
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);