ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where cases = 17073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Georgia 3
- New Mexico 3
- Montana 2
- Arizona 1
- Illinois 1
- Minnesota 1
- New York 1
- North Carolina 1
- South Carolina 1
- Tennessee 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2413509 | 2413509 | 2022-04-16 | Clinton | New York | 36019 | 17073 | 87 |
2214869 | 2214869 | 2022-02-14 | Lewis and Clark | Montana | 30049 | 17073 | 165 |
2055483 | 2055483 | 2021-12-27 | Cascade | Montana | 30013 | 17073 | 282 |
1915934 | 1915934 | 2021-11-14 | Sandoval | New Mexico | 35043 | 17073 | 280 |
1912684 | 1912684 | 2021-11-13 | Sandoval | New Mexico | 35043 | 17073 | 280 |
1909434 | 1909434 | 2021-11-12 | Sandoval | New Mexico | 35043 | 17073 | 280 |
1770459 | 1770459 | 2021-09-30 | Madison | Tennessee | 47113 | 17073 | 291 |
1573362 | 1573362 | 2021-08-01 | Bibb | Georgia | 13021 | 17073 | 467 |
1570114 | 1570114 | 2021-07-31 | Bibb | Georgia | 13021 | 17073 | 467 |
1566866 | 1566866 | 2021-07-30 | Bibb | Georgia | 13021 | 17073 | 467 |
1383412 | 1383412 | 2021-06-03 | Rowan | North Carolina | 37159 | 17073 | 306 |
1383850 | 1383850 | 2021-06-03 | Beaufort | South Carolina | 45013 | 17073 | 209 |
1252965 | 1252965 | 2021-04-24 | St. Louis | Minnesota | 27137 | 17073 | 298 |
1170474 | 1170474 | 2021-03-30 | Coconino | Arizona | 4005 | 17073 | 324 |
1130973 | 1130973 | 2021-03-17 | Potter | Texas | 48375 | 17073 | 418 |
752379 | 752379 | 2020-11-21 | Winnebago | Illinois | 17201 | 17073 | 244 |
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);