ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 9857 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Alabama 4
- Missouri 4
- Virginia 4
- Georgia 3
- Illinois 3
- Mississippi 3
- North Carolina 3
- California 2
- Kentucky 2
- Texas 2
- Arizona 1
- Hawaii 1
- New Jersey 1
- Ohio 1
- Pennsylvania 1
- Tennessee 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398655 | 2398655 | 2022-04-12 | Franklin | Alabama | 1059 | 9857 | 137 |
2395400 | 2395400 | 2022-04-11 | Franklin | Alabama | 1059 | 9857 | 137 |
2378766 | 2378766 | 2022-04-05 | Washington | Vermont | 50023 | 9857 | 47 |
2256032 | 2256032 | 2022-02-27 | Ware | Georgia | 13299 | 9857 | 268 |
2256955 | 2256955 | 2022-02-27 | Marshall | Mississippi | 28093 | 9857 | 171 |
2258544 | 2258544 | 2022-02-27 | Tazewell | Virginia | 51185 | 9857 | 154 |
2252781 | 2252781 | 2022-02-26 | Ware | Georgia | 13299 | 9857 | 268 |
2253704 | 2253704 | 2022-02-26 | Marshall | Mississippi | 28093 | 9857 | 171 |
2255293 | 2255293 | 2022-02-26 | Tazewell | Virginia | 51185 | 9857 | 154 |
2249530 | 2249530 | 2022-02-25 | Ware | Georgia | 13299 | 9857 | 268 |
2250453 | 2250453 | 2022-02-25 | Marshall | Mississippi | 28093 | 9857 | 171 |
2252042 | 2252042 | 2022-02-25 | Tazewell | Virginia | 51185 | 9857 | 154 |
2237567 | 2237567 | 2022-02-21 | Phelps | Missouri | 29161 | 9857 | 225 |
2234316 | 2234316 | 2022-02-20 | Phelps | Missouri | 29161 | 9857 | 225 |
2231065 | 2231065 | 2022-02-19 | Phelps | Missouri | 29161 | 9857 | 225 |
2227814 | 2227814 | 2022-02-18 | Phelps | Missouri | 29161 | 9857 | 225 |
2223613 | 2223613 | 2022-02-17 | Fulton | Illinois | 17057 | 9857 | 127 |
2176305 | 2176305 | 2022-02-02 | Logan | Ohio | 39091 | 9857 | 148 |
2161189 | 2161189 | 2022-01-29 | Chilton | Alabama | 1021 | 9857 | 183 |
2110181 | 2110181 | 2022-01-13 | Henderson | Kentucky | 21101 | 9857 | 135 |
2111762 | 2111762 | 2022-01-13 | Atascosa | Texas | 48013 | 9857 | 214 |
2099585 | 2099585 | 2022-01-10 | Mendocino | California | 6045 | 9857 | 106 |
2000889 | 2000889 | 2021-12-10 | Columbia | Pennsylvania | 42037 | 9857 | 171 |
1926434 | 1926434 | 2021-11-17 | Monroe | Tennessee | 47123 | 9857 | 126 |
1755434 | 1755434 | 2021-09-26 | Hawaii | Hawaii | 15001 | 9857 | 86 |
1702687 | 1702687 | 2021-09-09 | Roanoke | Virginia | 51161 | 9857 | 152 |
1574875 | 1574875 | 2021-08-01 | Brunswick | North Carolina | 37019 | 9857 | 159 |
1571627 | 1571627 | 2021-07-31 | Brunswick | North Carolina | 37019 | 9857 | 159 |
1568379 | 1568379 | 2021-07-30 | Brunswick | North Carolina | 37019 | 9857 | 159 |
1379231 | 1379231 | 2021-06-02 | Hardin | Kentucky | 21093 | 9857 | 167 |
1374960 | 1374960 | 2021-06-01 | Cullman | Alabama | 1043 | 9857 | 199 |
1352910 | 1352910 | 2021-05-25 | Vermilion | Illinois | 17183 | 9857 | 150 |
1318314 | 1318314 | 2021-05-14 | Warren | New Jersey | 34041 | 9857 | 235 |
923925 | 923925 | 2021-01-13 | Yolo | California | 6113 | 9857 | 131 |
842649 | 842649 | 2020-12-19 | Coconino | Arizona | 4005 | 9857 | 199 |
658304 | 658304 | 2020-10-23 | Winnebago | Illinois | 17201 | 9857 | 179 |
446758 | 446758 | 2020-08-18 | Webb | Texas | 48479 | 9857 | 207 |
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);