ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 7461 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Virginia 6
- Colorado 4
- Minnesota 4
- Georgia 3
- Michigan 3
- Texas 3
- South Carolina 2
- Arkansas 1
- California 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kentucky 1
- Missouri 1
- New York 1
- North Carolina 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- Tennessee 1
- Utah 1
- Vermont 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395061 | 2395061 | 2022-04-10 | Botetourt | Virginia | 51023 | 7461 | 96 |
2391805 | 2391805 | 2022-04-09 | Botetourt | Virginia | 51023 | 7461 | 96 |
2388549 | 2388549 | 2022-04-08 | Botetourt | Virginia | 51023 | 7461 | 96 |
2336613 | 2336613 | 2022-03-23 | Wythe | Virginia | 51197 | 7461 | 139 |
2105061 | 2105061 | 2022-01-11 | Dillon | South Carolina | 45033 | 7461 | 122 |
1975593 | 1975593 | 2021-12-02 | James City | Virginia | 51095 | 7461 | 98 |
1941133 | 1941133 | 2021-11-22 | Franklin | Kentucky | 21073 | 7461 | 95 |
1913496 | 1913496 | 2021-11-13 | Burnet | Texas | 48053 | 7461 | 129 |
1910246 | 1910246 | 2021-11-12 | Burnet | Texas | 48053 | 7461 | 129 |
1830068 | 1830068 | 2021-10-19 | Habersham | Georgia | 13137 | 7461 | 197 |
1800636 | 1800636 | 2021-10-10 | Garfield | Colorado | 8045 | 7461 | 60 |
1797387 | 1797387 | 2021-10-09 | Garfield | Colorado | 8045 | 7461 | 60 |
1794138 | 1794138 | 2021-10-08 | Garfield | Colorado | 8045 | 7461 | 60 |
1784549 | 1784549 | 2021-10-05 | Colquitt | Georgia | 13071 | 7461 | 167 |
1746415 | 1746415 | 2021-09-23 | Isabella | Michigan | 26073 | 7461 | 104 |
1743166 | 1743166 | 2021-09-22 | Isabella | Michigan | 26073 | 7461 | 104 |
1589025 | 1589025 | 2021-08-05 | Cowlitz | Washington | 53015 | 7461 | 103 |
1381082 | 1381082 | 2021-06-02 | Tooele | Utah | 49045 | 7461 | 44 |
1362109 | 1362109 | 2021-05-28 | Lonoke | Arkansas | 5085 | 7461 | 121 |
1332397 | 1332397 | 2021-05-18 | Chittenden | Vermont | 50007 | 7461 | 103 |
1328121 | 1328121 | 2021-05-17 | Oswego | New York | 36075 | 7461 | 90 |
1308093 | 1308093 | 2021-05-11 | Blue Earth | Minnesota | 27013 | 7461 | 41 |
1296217 | 1296217 | 2021-05-07 | Kershaw | South Carolina | 45055 | 7461 | 140 |
1265856 | 1265856 | 2021-04-28 | Montcalm | Michigan | 26117 | 7461 | 105 |
1255251 | 1255251 | 2021-04-25 | Dougherty | Georgia | 13095 | 7461 | 300 |
1214680 | 1214680 | 2021-04-12 | Erie | Ohio | 39043 | 7461 | 153 |
1187951 | 1187951 | 2021-04-04 | Clay | Minnesota | 27027 | 7461 | 89 |
1184704 | 1184704 | 2021-04-03 | Clay | Minnesota | 27027 | 7461 | 89 |
1107427 | 1107427 | 2021-03-10 | Surry | North Carolina | 37171 | 7461 | 140 |
1101977 | 1101977 | 2021-03-08 | Roanoke | Virginia | 51161 | 7461 | 135 |
1097244 | 1097244 | 2021-03-07 | Jasper | Missouri | 29097 | 7461 | 123 |
1070438 | 1070438 | 2021-02-27 | Bartholomew | Indiana | 18005 | 7461 | 153 |
1033041 | 1033041 | 2021-02-15 | Umatilla | Oregon | 41059 | 7461 | 79 |
1013623 | 1013623 | 2021-02-09 | Northumberland | Pennsylvania | 42097 | 7461 | 306 |
830447 | 830447 | 2020-12-15 | Story | Iowa | 19169 | 7461 | 23 |
797330 | 797330 | 2020-12-05 | Placer | California | 6061 | 7461 | 74 |
775810 | 775810 | 2020-11-28 | Wright | Minnesota | 27171 | 7461 | 39 |
462640 | 462640 | 2020-08-23 | Rutherford | Tennessee | 47149 | 7461 | 64 |
428031 | 428031 | 2020-08-13 | Arapahoe | Colorado | 8005 | 7461 | 363 |
308652 | 308652 | 2020-07-06 | El Paso | Texas | 48141 | 7461 | 135 |
259457 | 259457 | 2020-06-21 | Kane | Illinois | 17089 | 7461 | 251 |
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);