ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 8085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- North Carolina 5
- Georgia 4
- Texas 4
- Ohio 3
- Virginia 3
- Arizona 2
- Illinois 2
- Missouri 2
- New York 2
- Florida 1
- Kentucky 1
- Minnesota 1
- Nevada 1
- New Jersey 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- South Dakota 1
- Vermont 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2315583 | 2315583 | 2022-03-17 | Laclede | Missouri | 29105 | 8085 | 174 |
2313248 | 2313248 | 2022-03-16 | Brookings | South Dakota | 46011 | 8085 | 51 |
2198352 | 2198352 | 2022-02-09 | Polk | Minnesota | 27119 | 8085 | 95 |
2196628 | 2196628 | 2022-02-08 | Franklin | Vermont | 50011 | 8085 | 59 |
2105598 | 2105598 | 2022-01-11 | Franklin | Virginia | 51067 | 8085 | 133 |
2038272 | 2038272 | 2021-12-22 | Marion | Illinois | 17121 | 8085 | 164 |
2031751 | 2031751 | 2021-12-20 | Henry | Illinois | 17073 | 8085 | 122 |
1982762 | 1982762 | 2021-12-05 | Camden | Georgia | 13039 | 8085 | 97 |
1979512 | 1979512 | 2021-12-04 | Camden | Georgia | 13039 | 8085 | 97 |
1976262 | 1976262 | 2021-12-03 | Camden | Georgia | 13039 | 8085 | 97 |
1948464 | 1948464 | 2021-11-24 | Herkimer | New York | 36043 | 8085 | 141 |
1841503 | 1841503 | 2021-10-22 | Washington | Ohio | 39167 | 8085 | 144 |
1737153 | 1737153 | 2021-09-20 | Carson City | Nevada | 32510 | 8085 | 137 |
1707707 | 1707707 | 2021-09-11 | Lincoln | Missouri | 29113 | 8085 | 56 |
1603295 | 1603295 | 2021-08-10 | Oldham | Kentucky | 21185 | 8085 | 85 |
1558709 | 1558709 | 2021-07-27 | Stanly | North Carolina | 37167 | 8085 | 138 |
1516589 | 1516589 | 2021-07-14 | Erie | Ohio | 39043 | 8085 | 166 |
1503840 | 1503840 | 2021-07-10 | Somerset | Pennsylvania | 42111 | 8085 | 218 |
1469166 | 1469166 | 2021-06-30 | Santa Cruz | Arizona | 4023 | 8085 | 180 |
1465921 | 1465921 | 2021-06-29 | Santa Cruz | Arizona | 4023 | 8085 | 180 |
1448323 | 1448323 | 2021-06-23 | Rockingham | North Carolina | 37157 | 8085 | 151 |
1438588 | 1438588 | 2021-06-20 | Rockingham | North Carolina | 37157 | 8085 | 145 |
1435341 | 1435341 | 2021-06-19 | Rockingham | North Carolina | 37157 | 8085 | 145 |
1436329 | 1436329 | 2021-06-19 | Frederick | Virginia | 51069 | 8085 | 102 |
1432094 | 1432094 | 2021-06-18 | Rockingham | North Carolina | 37157 | 8085 | 145 |
1403871 | 1403871 | 2021-06-09 | Frederick | Virginia | 51069 | 8085 | 102 |
1355453 | 1355453 | 2021-05-25 | Natrona | Wyoming | 56025 | 8085 | 138 |
1222708 | 1222708 | 2021-04-15 | Nassau | Florida | 12089 | 8085 | 123 |
1169987 | 1169987 | 2021-03-29 | Victoria | Texas | 48469 | 8085 | 194 |
1166739 | 1166739 | 2021-03-28 | Victoria | Texas | 48469 | 8085 | 194 |
1163491 | 1163491 | 2021-03-27 | Victoria | Texas | 48469 | 8085 | 194 |
1160242 | 1160242 | 2021-03-26 | Victoria | Texas | 48469 | 8085 | 194 |
1127261 | 1127261 | 2021-03-16 | Carolina | Puerto Rico | 72031 | 8085 | |
1124772 | 1124772 | 2021-03-15 | Cabell | West Virginia | 54011 | 8085 | 167 |
1091330 | 1091330 | 2021-03-05 | Pickaway | Ohio | 39129 | 8085 | 111 |
1048896 | 1048896 | 2021-02-20 | Putnam | New York | 36079 | 8085 | 86 |
885135 | 885135 | 2021-01-01 | Bartow | Georgia | 13015 | 8085 | 130 |
835236 | 835236 | 2020-12-16 | Berkeley | South Carolina | 45015 | 8085 | 109 |
591289 | 591289 | 2020-10-02 | Morris | New Jersey | 34027 | 8085 | 830 |
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);