ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 11346 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Florida 7
- Georgia 4
- Ohio 4
- Pennsylvania 3
- Michigan 1
- Montana 1
- New York 1
- North Carolina 1
- Oregon 1
- Tennessee 1
- Texas 1
- Virginia 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494922 | 2494922 | 2022-05-11 | Cortland | New York | 36023 | 11346 | 120 |
2294464 | 2294464 | 2022-03-10 | Oconto | Wisconsin | 55083 | 11346 | 109 |
2197492 | 2197492 | 2022-02-09 | Tift | Georgia | 13277 | 11346 | 203 |
2124873 | 2124873 | 2022-01-17 | Hood | Texas | 48221 | 11346 | 222 |
2023629 | 2023629 | 2021-12-17 | Armstrong | Pennsylvania | 42005 | 11346 | 257 |
1988649 | 1988649 | 2021-12-06 | Suffolk city | Virginia | 51800 | 11346 | 249 |
1951980 | 1951980 | 2021-11-25 | Ross | Ohio | 39141 | 11346 | 221 |
1948729 | 1948729 | 2021-11-24 | Ross | Ohio | 39141 | 11346 | 221 |
1838234 | 1838234 | 2021-10-21 | Pickaway | Ohio | 39129 | 11346 | 141 |
1805606 | 1805606 | 2021-10-11 | Stanly | North Carolina | 37167 | 11346 | 173 |
1654525 | 1654525 | 2021-08-26 | Highlands | Florida | 12055 | 11346 | 366 |
1651278 | 1651278 | 2021-08-25 | Highlands | Florida | 12055 | 11346 | 366 |
1648029 | 1648029 | 2021-08-24 | Highlands | Florida | 12055 | 11346 | 366 |
1644781 | 1644781 | 2021-08-23 | Highlands | Florida | 12055 | 11346 | 366 |
1641531 | 1641531 | 2021-08-22 | Highlands | Florida | 12055 | 11346 | 366 |
1638281 | 1638281 | 2021-08-21 | Highlands | Florida | 12055 | 11346 | 366 |
1635031 | 1635031 | 2021-08-20 | Highlands | Florida | 12055 | 11346 | 366 |
1404644 | 1404644 | 2021-06-10 | Newton | Georgia | 13217 | 11346 | 257 |
1284449 | 1284449 | 2021-05-04 | Carroll | Georgia | 13045 | 11346 | 240 |
1221341 | 1221341 | 2021-04-14 | Lane | Oregon | 41039 | 11346 | 144 |
1149272 | 1149272 | 2021-03-23 | Flathead | Montana | 30029 | 11346 | 82 |
1122117 | 1122117 | 2021-03-15 | Floyd | Georgia | 13115 | 11346 | 200 |
1033058 | 1033058 | 2021-02-15 | Cambria | Pennsylvania | 42021 | 11346 | 383 |
968454 | 968454 | 2021-01-26 | Maury | Tennessee | 47119 | 11346 | 133 |
902269 | 902269 | 2021-01-06 | Muskegon | Michigan | 26121 | 11346 | 277 |
744077 | 744077 | 2020-11-18 | Summit | Ohio | 39153 | 11346 | 299 |
507605 | 507605 | 2020-09-06 | Montgomery | Pennsylvania | 42091 | 11346 | 863 |
450220 | 450220 | 2020-08-19 | Yakima | Washington | 53077 | 11346 | 243 |
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);