ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 9107 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Tennessee 8
- Wisconsin 4
- Alabama 3
- North Carolina 3
- Arizona 2
- Arkansas 2
- Indiana 2
- New Jersey 2
- Florida 1
- Georgia 1
- Idaho 1
- Iowa 1
- Louisiana 1
- Maine 1
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Ohio 1
- Pennsylvania 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422794 | 2422794 | 2022-04-19 | Morrison | Minnesota | 27097 | 9107 | 104 |
2378412 | 2378412 | 2022-04-05 | Henderson | Tennessee | 47077 | 9107 | 154 |
2375158 | 2375158 | 2022-04-04 | Henderson | Tennessee | 47077 | 9107 | 154 |
2371906 | 2371906 | 2022-04-03 | Henderson | Tennessee | 47077 | 9107 | 154 |
2372515 | 2372515 | 2022-04-03 | Green | Wisconsin | 55045 | 9107 | 53 |
2368653 | 2368653 | 2022-04-02 | Henderson | Tennessee | 47077 | 9107 | 154 |
2369262 | 2369262 | 2022-04-02 | Green | Wisconsin | 55045 | 9107 | 53 |
2365400 | 2365400 | 2022-04-01 | Henderson | Tennessee | 47077 | 9107 | 154 |
2366009 | 2366009 | 2022-04-01 | Green | Wisconsin | 55045 | 9107 | 53 |
2362147 | 2362147 | 2022-03-31 | Henderson | Tennessee | 47077 | 9107 | 154 |
2356726 | 2356726 | 2022-03-30 | Bryan | Georgia | 13029 | 9107 | 90 |
2358893 | 2358893 | 2022-03-30 | Henderson | Tennessee | 47077 | 9107 | 154 |
2244444 | 2244444 | 2022-02-23 | Jackson | North Carolina | 37099 | 9107 | 83 |
2200237 | 2200237 | 2022-02-10 | Covington | Alabama | 1039 | 9107 | 212 |
2148961 | 2148961 | 2022-01-25 | Whitley | Indiana | 18183 | 9107 | 73 |
2146378 | 2146378 | 2022-01-24 | Neshoba | Mississippi | 28099 | 9107 | 211 |
2138428 | 2138428 | 2022-01-22 | Escambia | Alabama | 1053 | 9107 | 151 |
2059419 | 2059419 | 2021-12-28 | Mifflin | Pennsylvania | 42087 | 9107 | 236 |
2011736 | 2011736 | 2021-12-14 | Crittenden | Arkansas | 5035 | 9107 | 185 |
1989572 | 1989572 | 2021-12-07 | Dearborn | Indiana | 18029 | 9107 | 109 |
1871958 | 1871958 | 2021-11-01 | Santa Cruz | Arizona | 4023 | 9107 | 191 |
1764315 | 1764315 | 2021-09-28 | Bedford | Virginia | 51019 | 9107 | 125 |
1652916 | 1652916 | 2021-08-25 | Stanly | North Carolina | 37167 | 9107 | 147 |
1605392 | 1605392 | 2021-08-10 | Manitowoc | Wisconsin | 55071 | 9107 | 96 |
1588487 | 1588487 | 2021-08-05 | Anderson | Tennessee | 47001 | 9107 | 179 |
1513226 | 1513226 | 2021-07-13 | Moore | North Carolina | 37125 | 9107 | 195 |
1406292 | 1406292 | 2021-06-10 | Wayne | Ohio | 39169 | 9107 | 221 |
1035233 | 1035233 | 2021-02-16 | York | Maine | 23031 | 9107 | 110 |
963446 | 963446 | 2021-01-25 | Dallas | Iowa | 19049 | 9107 | 72 |
921944 | 921944 | 2021-01-12 | Buchanan | Missouri | 29021 | 9107 | 145 |
845923 | 845923 | 2020-12-20 | Craighead | Arkansas | 5031 | 9107 | 120 |
807431 | 807431 | 2020-12-08 | Kootenai | Idaho | 16055 | 9107 | 90 |
779450 | 779450 | 2020-11-29 | Somerset | New Jersey | 34035 | 9107 | 609 |
659403 | 659403 | 2020-10-23 | Mercer | New Jersey | 34021 | 9107 | 639 |
608992 | 608992 | 2020-10-08 | Montgomery | Alabama | 1101 | 9107 | 188 |
610068 | 610068 | 2020-10-08 | Caddo | Louisiana | 22017 | 9107 | 370 |
586625 | 586625 | 2020-10-01 | Seminole | Florida | 12117 | 9107 | 216 |
453705 | 453705 | 2020-08-21 | Pinal | Arizona | 4021 | 9107 | 176 |
390388 | 390388 | 2020-08-01 | Plymouth | Massachusetts | 25023 | 9107 | 711 |
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);