ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 10247 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Tennessee 5
- Massachusetts 4
- Ohio 3
- Washington 3
- California 2
- Illinois 2
- North Carolina 2
- Texas 2
- Florida 1
- Iowa 1
- Maryland 1
- Minnesota 1
- New York 1
- Oklahoma 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2425284 | 2425284 | 2022-04-20 | Christian | Illinois | 17021 | 10247 | 129 |
2256727 | 2256727 | 2022-02-27 | Franklin | Massachusetts | 25011 | 10247 | 167 |
2253476 | 2253476 | 2022-02-26 | Franklin | Massachusetts | 25011 | 10247 | 167 |
2250225 | 2250225 | 2022-02-25 | Franklin | Massachusetts | 25011 | 10247 | 167 |
2244347 | 2244347 | 2022-02-23 | Cortland | New York | 36023 | 10247 | 113 |
2167187 | 2167187 | 2022-01-30 | Jim Wells | Texas | 48249 | 10247 | 186 |
2137228 | 2137228 | 2022-01-21 | Crawford | Ohio | 39033 | 10247 | 178 |
2127457 | 2127457 | 2022-01-18 | Auglaize | Ohio | 39011 | 10247 | 142 |
2102547 | 2102547 | 2022-01-10 | Dunn | Wisconsin | 55033 | 10247 | 63 |
2039755 | 2039755 | 2021-12-22 | Union | Ohio | 39159 | 10247 | 78 |
1931548 | 1931548 | 2021-11-19 | Allegany | Maryland | 24001 | 10247 | 261 |
1895941 | 1895941 | 2021-11-08 | Crow Wing | Minnesota | 27035 | 10247 | 117 |
1874415 | 1874415 | 2021-11-01 | Hawkins | Tennessee | 47073 | 10247 | 167 |
1871166 | 1871166 | 2021-10-31 | Hawkins | Tennessee | 47073 | 10247 | 167 |
1867917 | 1867917 | 2021-10-30 | Hawkins | Tennessee | 47073 | 10247 | 167 |
1864668 | 1864668 | 2021-10-29 | Hawkins | Tennessee | 47073 | 10247 | 167 |
1793165 | 1793165 | 2021-10-07 | Coffee | Tennessee | 47031 | 10247 | 146 |
1789374 | 1789374 | 2021-10-06 | Wilkes | North Carolina | 37193 | 10247 | 167 |
1786347 | 1786347 | 2021-10-05 | Unknown | Oklahoma | 10247 | 0 | |
1560662 | 1560662 | 2021-07-28 | Vermilion | Illinois | 17183 | 10247 | 171 |
1396369 | 1396369 | 2021-06-07 | Lincoln | North Carolina | 37109 | 10247 | 86 |
1352412 | 1352412 | 2021-05-25 | El Dorado | California | 6017 | 10247 | 113 |
1349166 | 1349166 | 2021-05-24 | El Dorado | California | 6017 | 10247 | 113 |
1326064 | 1326064 | 2021-05-16 | Grant | Washington | 53025 | 10247 | 119 |
1322818 | 1322818 | 2021-05-15 | Grant | Washington | 53025 | 10247 | 119 |
1319572 | 1319572 | 2021-05-14 | Grant | Washington | 53025 | 10247 | 119 |
1270471 | 1270471 | 2021-04-29 | Comal | Texas | 48091 | 10247 | 317 |
1210230 | 1210230 | 2021-04-11 | Story | Iowa | 19169 | 10247 | 47 |
703389 | 703389 | 2020-11-06 | Sarasota | Florida | 12115 | 10247 | 350 |
574521 | 574521 | 2020-09-27 | Norfolk | Massachusetts | 25021 | 10247 | 1058 |
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);