ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 8937 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Kansas 5
- Georgia 3
- Michigan 3
- North Carolina 2
- Colorado 1
- Indiana 1
- Massachusetts 1
- New Mexico 1
- Ohio 1
- Tennessee 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287940 | 2287940 | 2022-03-08 | Green | Wisconsin | 55045 | 8937 | 52 |
2236728 | 2236728 | 2022-02-21 | Jasper | Indiana | 18073 | 8937 | 143 |
2210905 | 2210905 | 2022-02-13 | Geary | Kansas | 20061 | 8937 | 68 |
2207652 | 2207652 | 2022-02-12 | Geary | Kansas | 20061 | 8937 | 68 |
2204399 | 2204399 | 2022-02-11 | Geary | Kansas | 20061 | 8937 | 68 |
2201146 | 2201146 | 2022-02-10 | Geary | Kansas | 20061 | 8937 | 68 |
2197892 | 2197892 | 2022-02-09 | Geary | Kansas | 20061 | 8937 | 68 |
1784601 | 1784601 | 2021-10-05 | Laurens | Georgia | 13175 | 8937 | 227 |
1778887 | 1778887 | 2021-10-03 | Clinton | Michigan | 26037 | 8937 | 103 |
1775637 | 1775637 | 2021-10-02 | Clinton | Michigan | 26037 | 8937 | 103 |
1772387 | 1772387 | 2021-10-01 | Clinton | Michigan | 26037 | 8937 | 103 |
1747714 | 1747714 | 2021-09-23 | Lawrence | Tennessee | 47099 | 8937 | 109 |
1651466 | 1651466 | 2021-08-25 | Walker | Georgia | 13295 | 8937 | 95 |
1269037 | 1269037 | 2021-04-29 | Hampshire | Massachusetts | 25015 | 8937 | 290 |
1146212 | 1146212 | 2021-03-22 | Chaves | New Mexico | 35005 | 8937 | 163 |
1032701 | 1032701 | 2021-02-15 | Burke | North Carolina | 37023 | 8937 | 125 |
901448 | 901448 | 2021-01-06 | Lowndes | Georgia | 13185 | 8937 | 139 |
838165 | 838165 | 2020-12-17 | Licking | Ohio | 39089 | 8937 | 102 |
832433 | 832433 | 2020-12-15 | Wichita | Texas | 48485 | 8937 | 175 |
679000 | 679000 | 2020-10-29 | Forsyth | North Carolina | 37067 | 8937 | 120 |
544378 | 544378 | 2020-09-18 | Arapahoe | Colorado | 8005 | 8937 | 370 |
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);