ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 10713 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- California 6
- Ohio 3
- Georgia 2
- Iowa 2
- Louisiana 2
- Washington 2
- Alabama 1
- Hawaii 1
- Illinois 1
- Indiana 1
- Massachusetts 1
- Mississippi 1
- Missouri 1
- Montana 1
- New York 1
- North Dakota 1
- Pennsylvania 1
- Texas 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369539 | 2369539 | 2022-04-03 | Lassen | California | 6035 | 10713 | 69 |
2366286 | 2366286 | 2022-04-02 | Lassen | California | 6035 | 10713 | 69 |
2363033 | 2363033 | 2022-04-01 | Lassen | California | 6035 | 10713 | 69 |
2359779 | 2359779 | 2022-03-31 | Lassen | California | 6035 | 10713 | 69 |
2356525 | 2356525 | 2022-03-30 | Lassen | California | 6035 | 10713 | 69 |
2353272 | 2353272 | 2022-03-29 | Lassen | California | 6035 | 10713 | 69 |
2236522 | 2236522 | 2022-02-21 | Unknown | Georgia | 10713 | 23 | |
2155389 | 2155389 | 2022-01-27 | DeKalb | Indiana | 18033 | 10713 | 137 |
2155796 | 2155796 | 2022-01-27 | Avoyelles | Louisiana | 22009 | 10713 | 186 |
2120950 | 2120950 | 2022-01-16 | Ashland | Ohio | 39005 | 10713 | 174 |
1993225 | 1993225 | 2021-12-08 | Acadia | Louisiana | 22001 | 10713 | 251 |
1987054 | 1987054 | 2021-12-06 | Lamar | Mississippi | 28073 | 10713 | 140 |
1835533 | 1835533 | 2021-10-20 | Coryell | Texas | 48099 | 10713 | 154 |
1826913 | 1826913 | 2021-10-18 | Hawaii | Hawaii | 15001 | 10713 | 112 |
1713052 | 1713052 | 2021-09-13 | Bulloch | Georgia | 13031 | 10713 | 148 |
1670475 | 1670475 | 2021-08-31 | Talladega | Alabama | 1121 | 10713 | 194 |
1449321 | 1449321 | 2021-06-23 | Hampton city | Virginia | 51650 | 10713 | 181 |
1432133 | 1432133 | 2021-06-18 | Grand Forks | North Dakota | 38035 | 10713 | 79 |
1427747 | 1427747 | 2021-06-17 | Story | Iowa | 19169 | 10713 | 48 |
1416974 | 1416974 | 2021-06-13 | Thurston | Washington | 53067 | 10713 | 109 |
1413728 | 1413728 | 2021-06-12 | Thurston | Washington | 53067 | 10713 | 109 |
1328354 | 1328354 | 2021-05-17 | Miami | Ohio | 39109 | 10713 | 220 |
1226461 | 1226461 | 2021-04-16 | Pottawattamie | Iowa | 19155 | 10713 | 162 |
1011960 | 1011960 | 2021-02-09 | Kendall | Illinois | 17093 | 10713 | 90 |
938292 | 938292 | 2021-01-17 | Gallatin | Montana | 30031 | 10713 | 41 |
858696 | 858696 | 2020-12-23 | Dodge | Wisconsin | 55027 | 10713 | 126 |
733802 | 733802 | 2020-11-15 | St. Louis city | Missouri | 29510 | 10713 | 230 |
462347 | 462347 | 2020-08-23 | Montgomery | Pennsylvania | 42091 | 10713 | 861 |
352673 | 352673 | 2020-07-20 | Cuyahoga | Ohio | 39035 | 10713 | 424 |
276305 | 276305 | 2020-06-26 | Orange | New York | 36071 | 10713 | 398 |
185787 | 185787 | 2020-05-28 | Worcester | Massachusetts | 25027 | 10713 | 738 |
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);