ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 9394 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Alabama 3
- Alaska 3
- Missouri 3
- Georgia 2
- Illinois 2
- Michigan 2
- New York 2
- Virginia 2
- Arkansas 1
- California 1
- Florida 1
- Kentucky 1
- Maryland 1
- New Mexico 1
- North Carolina 1
- North Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2288668 | 2288668 | 2022-03-09 | Logan | Illinois | 17107 | 9394 | 97 |
2278413 | 2278413 | 2022-03-06 | Miller | Arkansas | 5091 | 9394 | 161 |
2099903 | 2099903 | 2022-01-10 | Tift | Georgia | 13277 | 9394 | 189 |
2101247 | 2101247 | 2022-01-10 | Livingston | New York | 36051 | 9394 | 96 |
2010223 | 2010223 | 2021-12-13 | Genesee | New York | 36037 | 9394 | 150 |
1905664 | 1905664 | 2021-11-11 | Shiawassee | Michigan | 26155 | 9394 | 134 |
1902415 | 1902415 | 2021-11-10 | Shiawassee | Michigan | 26155 | 9394 | 134 |
1872065 | 1872065 | 2021-11-01 | Nevada | California | 6057 | 9394 | 91 |
1566225 | 1566225 | 2021-07-29 | Montgomery | Virginia | 51121 | 9394 | 81 |
1558537 | 1558537 | 2021-07-27 | Chaves | New Mexico | 35005 | 9394 | 172 |
1338987 | 1338987 | 2021-05-20 | Montgomery | Virginia | 51121 | 9394 | 96 |
1282335 | 1282335 | 2021-05-03 | Jasper | Missouri | 29097 | 9394 | 127 |
1279088 | 1279088 | 2021-05-02 | Jasper | Missouri | 29097 | 9394 | 127 |
1216893 | 1216893 | 2021-04-13 | Hardin | Kentucky | 21093 | 9394 | 147 |
1201565 | 1201565 | 2021-04-08 | Lincoln | North Carolina | 37109 | 9394 | 80 |
1196415 | 1196415 | 2021-04-07 | St. Clair | Alabama | 1115 | 9394 | 234 |
1197902 | 1197902 | 2021-04-07 | Jasper | Missouri | 29097 | 9394 | 126 |
1185420 | 1185420 | 2021-04-03 | Ward | North Dakota | 38101 | 9394 | 192 |
1180139 | 1180139 | 2021-04-02 | Cullman | Alabama | 1043 | 9394 | 186 |
1141231 | 1141231 | 2021-03-21 | Matanuska-Susitna Borough | Alaska | 2170 | 9394 | 34 |
1137985 | 1137985 | 2021-03-20 | Matanuska-Susitna Borough | Alaska | 2170 | 9394 | 34 |
1134739 | 1134739 | 2021-03-19 | Matanuska-Susitna Borough | Alaska | 2170 | 9394 | 34 |
849461 | 849461 | 2020-12-21 | Clarke | Georgia | 13059 | 9394 | 61 |
817799 | 817799 | 2020-12-11 | Howard | Maryland | 24027 | 9394 | 163 |
804266 | 804266 | 2020-12-07 | McLean | Illinois | 17113 | 9394 | 61 |
667381 | 667381 | 2020-10-26 | Madison | Alabama | 1089 | 9394 | 96 |
538015 | 538015 | 2020-09-16 | Leon | Florida | 12073 | 9394 | 46 |
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);