ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 10925 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Iowa 7
- Kentucky 3
- Ohio 3
- Tennessee 3
- Texas 3
- Florida 2
- Illinois 2
- Pennsylvania 2
- Arkansas 1
- Indiana 1
- Mississippi 1
- New York 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2260207 | 2260207 | 2022-02-28 | Monroe | Mississippi | 28095 | 10925 | 211 |
2212117 | 2212117 | 2022-02-13 | Shelby | Ohio | 39149 | 10925 | 172 |
2097136 | 2097136 | 2022-01-09 | Boyd | Kentucky | 21019 | 10925 | 134 |
2093884 | 2093884 | 2022-01-08 | Boyd | Kentucky | 21019 | 10925 | 134 |
2090632 | 2090632 | 2022-01-07 | Boyd | Kentucky | 21019 | 10925 | 134 |
2019961 | 2019961 | 2021-12-16 | Cattaraugus | New York | 36009 | 10925 | 174 |
1984897 | 1984897 | 2021-12-05 | Coffee | Tennessee | 47031 | 10925 | 168 |
1981647 | 1981647 | 2021-12-04 | Coffee | Tennessee | 47031 | 10925 | 168 |
1978397 | 1978397 | 2021-12-03 | Coffee | Tennessee | 47031 | 10925 | 168 |
1917471 | 1917471 | 2021-11-15 | Crawford | Arkansas | 5033 | 10925 | 179 |
1847940 | 1847940 | 2021-10-24 | Erie | Ohio | 39043 | 10925 | 184 |
1823002 | 1823002 | 2021-10-16 | Raleigh | West Virginia | 54081 | 10925 | 165 |
1783001 | 1783001 | 2021-10-04 | Pickaway | Ohio | 39129 | 10925 | 131 |
1632053 | 1632053 | 2021-08-19 | DeKalb | Illinois | 17037 | 10925 | 128 |
1628787 | 1628787 | 2021-08-18 | Adams | Illinois | 17001 | 10925 | 162 |
1580338 | 1580338 | 2021-08-03 | Story | Iowa | 19169 | 10925 | 48 |
1577089 | 1577089 | 2021-08-02 | Story | Iowa | 19169 | 10925 | 48 |
1573841 | 1573841 | 2021-08-01 | Story | Iowa | 19169 | 10925 | 48 |
1570593 | 1570593 | 2021-07-31 | Story | Iowa | 19169 | 10925 | 48 |
1567345 | 1567345 | 2021-07-30 | Story | Iowa | 19169 | 10925 | 48 |
1564097 | 1564097 | 2021-07-29 | Story | Iowa | 19169 | 10925 | 48 |
1560849 | 1560849 | 2021-07-28 | Story | Iowa | 19169 | 10925 | 48 |
1385396 | 1385396 | 2021-06-04 | Delaware | Indiana | 18035 | 10925 | 200 |
1199072 | 1199072 | 2021-04-07 | Gregg | Texas | 48183 | 10925 | 350 |
1195823 | 1195823 | 2021-04-06 | Gregg | Texas | 48183 | 10925 | 350 |
1192575 | 1192575 | 2021-04-05 | Gregg | Texas | 48183 | 10925 | 346 |
1063594 | 1063594 | 2021-02-25 | Indian River | Florida | 12061 | 10925 | 260 |
974636 | 974636 | 2021-01-28 | Centre | Pennsylvania | 42027 | 10925 | 191 |
971431 | 971431 | 2021-01-27 | Schuylkill | Pennsylvania | 42107 | 10925 | 326 |
599130 | 599130 | 2020-10-04 | Dane | Wisconsin | 55025 | 10925 | 43 |
84383 | 84383 | 2020-04-24 | Miami-Dade | Florida | 12086 | 10925 | 287 |
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);