ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 13774 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Wisconsin 6
- Illinois 4
- Virginia 4
- Mississippi 3
- Kansas 2
- Indiana 1
- New Jersey 1
- North Carolina 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493032 | 2493032 | 2022-05-10 | Waupaca | Wisconsin | 55135 | 13774 | 252 |
2424475 | 2424475 | 2022-04-19 | Washington | Virginia | 51191 | 13774 | 214 |
2347168 | 2347168 | 2022-03-27 | Boone | Illinois | 17007 | 13774 | 128 |
2343915 | 2343915 | 2022-03-26 | Boone | Illinois | 17007 | 13774 | 128 |
2340662 | 2340662 | 2022-03-25 | Boone | Illinois | 17007 | 13774 | 128 |
2058085 | 2058085 | 2021-12-28 | Reno | Kansas | 20155 | 13774 | 187 |
2054836 | 2054836 | 2021-12-27 | Reno | Kansas | 20155 | 13774 | 187 |
2043835 | 2043835 | 2021-12-23 | Frederick | Virginia | 51069 | 13774 | 178 |
1767670 | 1767670 | 2021-09-29 | Spotsylvania | Virginia | 51177 | 13774 | 140 |
1674312 | 1674312 | 2021-09-01 | LaSalle | Illinois | 17099 | 13774 | 321 |
1598890 | 1598890 | 2021-08-08 | La Crosse | Wisconsin | 55063 | 13774 | 93 |
1595641 | 1595641 | 2021-08-07 | La Crosse | Wisconsin | 55063 | 13774 | 93 |
1592392 | 1592392 | 2021-08-06 | La Crosse | Wisconsin | 55063 | 13774 | 93 |
1460766 | 1460766 | 2021-06-27 | Jackson | Mississippi | 28059 | 13774 | 250 |
1457521 | 1457521 | 2021-06-26 | Jackson | Mississippi | 28059 | 13774 | 250 |
1454276 | 1454276 | 2021-06-25 | Jackson | Mississippi | 28059 | 13774 | 250 |
1355388 | 1355388 | 2021-05-25 | Fond du Lac | Wisconsin | 55039 | 13774 | 123 |
1298830 | 1298830 | 2021-05-08 | Sussex | New Jersey | 34037 | 13774 | 297 |
1256886 | 1256886 | 2021-04-25 | Clark | Ohio | 39023 | 13774 | 294 |
1105402 | 1105402 | 2021-03-09 | Sheboygan | Wisconsin | 55117 | 13774 | 141 |
1020812 | 1020812 | 2021-02-11 | Norfolk city | Virginia | 51710 | 13774 | 149 |
993752 | 993752 | 2021-02-03 | Buncombe | North Carolina | 37021 | 13774 | 266 |
846581 | 846581 | 2020-12-20 | Vanderburgh | Indiana | 18163 | 13774 | 183 |
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);