ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 12366 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Ohio 7
- Kansas 5
- Missouri 3
- Arkansas 2
- Indiana 2
- Tennessee 2
- California 1
- Connecticut 1
- New York 1
- North Carolina 1
- Oregon 1
- Texas 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381180 | 2381180 | 2022-04-06 | Darke | Ohio | 39037 | 12366 | 236 |
2377925 | 2377925 | 2022-04-05 | Darke | Ohio | 39037 | 12366 | 236 |
2374671 | 2374671 | 2022-04-04 | Darke | Ohio | 39037 | 12366 | 236 |
2371419 | 2371419 | 2022-04-03 | Darke | Ohio | 39037 | 12366 | 236 |
2368166 | 2368166 | 2022-04-02 | Darke | Ohio | 39037 | 12366 | 236 |
2364913 | 2364913 | 2022-04-01 | Darke | Ohio | 39037 | 12366 | 236 |
2361660 | 2361660 | 2022-03-31 | Darke | Ohio | 39037 | 12366 | 236 |
1985917 | 1985917 | 2021-12-06 | Tolland | Connecticut | 9013 | 12366 | 204 |
1965993 | 1965993 | 2021-11-29 | Raleigh | West Virginia | 54081 | 12366 | 194 |
1960574 | 1960574 | 2021-11-28 | Reno | Kansas | 20155 | 12366 | 173 |
1957323 | 1957323 | 2021-11-27 | Reno | Kansas | 20155 | 12366 | 173 |
1954072 | 1954072 | 2021-11-26 | Reno | Kansas | 20155 | 12366 | 173 |
1950821 | 1950821 | 2021-11-25 | Reno | Kansas | 20155 | 12366 | 173 |
1947570 | 1947570 | 2021-11-24 | Reno | Kansas | 20155 | 12366 | 173 |
1756394 | 1756394 | 2021-09-26 | Cape Girardeau | Missouri | 29031 | 12366 | 151 |
1753146 | 1753146 | 2021-09-25 | Cape Girardeau | Missouri | 29031 | 12366 | 151 |
1749898 | 1749898 | 2021-09-24 | Cape Girardeau | Missouri | 29031 | 12366 | 151 |
1722573 | 1722573 | 2021-09-16 | White | Arkansas | 5145 | 12366 | 175 |
1718150 | 1718150 | 2021-09-14 | Umatilla | Oregon | 41059 | 12366 | 120 |
1589051 | 1589051 | 2021-08-05 | Thurston | Washington | 53067 | 12366 | 123 |
1427039 | 1427039 | 2021-06-17 | Saline | Arkansas | 5125 | 12366 | 173 |
1395158 | 1395158 | 2021-06-07 | LaPorte | Indiana | 18091 | 12366 | 221 |
1017273 | 1017273 | 2021-02-10 | Guadalupe | Texas | 48187 | 12366 | 167 |
978222 | 978222 | 2021-01-29 | Washington | Tennessee | 47179 | 12366 | 213 |
974209 | 974209 | 2021-01-28 | Broome | New York | 36007 | 12366 | 289 |
961912 | 961912 | 2021-01-24 | Blount | Tennessee | 47009 | 12366 | 134 |
932077 | 932077 | 2021-01-15 | Alamance | North Carolina | 37001 | 12366 | 169 |
885480 | 885480 | 2021-01-01 | Johnson | Indiana | 18081 | 12366 | 252 |
712955 | 712955 | 2020-11-09 | Monterey | California | 6053 | 12366 | 101 |
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);