ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 9915 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Mississippi 8
- Louisiana 7
- North Carolina 7
- Michigan 5
- South Carolina 5
- Tennessee 5
- Georgia 4
- California 2
- Virginia 2
- Alabama 1
- Arkansas 1
- Indiana 1
- Kentucky 1
- New Jersey 1
- New York 1
- North Dakota 1
- Ohio 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502732 | 2502732 | 2022-05-13 | Wayne | West Virginia | 54099 | 9915 | 125 |
2347827 | 2347827 | 2022-03-27 | Delta | Michigan | 26041 | 9915 | 155 |
2344574 | 2344574 | 2022-03-26 | Delta | Michigan | 26041 | 9915 | 155 |
2341321 | 2341321 | 2022-03-25 | Delta | Michigan | 26041 | 9915 | 155 |
2338068 | 2338068 | 2022-03-24 | Delta | Michigan | 26041 | 9915 | 155 |
2334814 | 2334814 | 2022-03-23 | Delta | Michigan | 26041 | 9915 | 155 |
2325208 | 2325208 | 2022-03-20 | Alcorn | Mississippi | 28003 | 9915 | 155 |
2321954 | 2321954 | 2022-03-19 | Alcorn | Mississippi | 28003 | 9915 | 155 |
2318700 | 2318700 | 2022-03-18 | Alcorn | Mississippi | 28003 | 9915 | 155 |
2315210 | 2315210 | 2022-03-17 | Vernon | Louisiana | 22115 | 9915 | 187 |
2315447 | 2315447 | 2022-03-17 | Alcorn | Mississippi | 28003 | 9915 | 155 |
2311957 | 2311957 | 2022-03-16 | Vernon | Louisiana | 22115 | 9915 | 187 |
2312194 | 2312194 | 2022-03-16 | Alcorn | Mississippi | 28003 | 9915 | 155 |
2308704 | 2308704 | 2022-03-15 | Vernon | Louisiana | 22115 | 9915 | 187 |
2308941 | 2308941 | 2022-03-15 | Alcorn | Mississippi | 28003 | 9915 | 155 |
2305453 | 2305453 | 2022-03-14 | Vernon | Louisiana | 22115 | 9915 | 187 |
2305690 | 2305690 | 2022-03-14 | Alcorn | Mississippi | 28003 | 9915 | 155 |
2306261 | 2306261 | 2022-03-14 | Scotland | North Carolina | 37165 | 9915 | 126 |
2226260 | 2226260 | 2022-02-18 | Escambia | Alabama | 1053 | 9915 | 155 |
2200677 | 2200677 | 2022-02-10 | Habersham | Georgia | 13137 | 9915 | 235 |
2179305 | 2179305 | 2022-02-03 | Cortland | New York | 36023 | 9915 | 108 |
2145323 | 2145323 | 2022-01-24 | Camden | Georgia | 13039 | 9915 | 101 |
1962191 | 1962191 | 2021-11-28 | Monroe | Tennessee | 47123 | 9915 | 128 |
1958940 | 1958940 | 2021-11-27 | Monroe | Tennessee | 47123 | 9915 | 128 |
1955689 | 1955689 | 2021-11-26 | Monroe | Tennessee | 47123 | 9915 | 128 |
1952438 | 1952438 | 2021-11-25 | Monroe | Tennessee | 47123 | 9915 | 128 |
1949187 | 1949187 | 2021-11-24 | Monroe | Tennessee | 47123 | 9915 | 128 |
1878586 | 1878586 | 2021-11-03 | Tehama | California | 6103 | 9915 | 116 |
1870694 | 1870694 | 2021-10-31 | Hancock | Ohio | 39063 | 9915 | 156 |
1832037 | 1832037 | 2021-10-19 | Cherokee | South Carolina | 45021 | 9915 | 234 |
1811211 | 1811211 | 2021-10-13 | Oldham | Kentucky | 21185 | 9915 | 91 |
1756883 | 1756883 | 2021-09-26 | Wilkes | North Carolina | 37193 | 9915 | 156 |
1753635 | 1753635 | 2021-09-25 | Wilkes | North Carolina | 37193 | 9915 | 156 |
1750387 | 1750387 | 2021-09-24 | Wilkes | North Carolina | 37193 | 9915 | 156 |
1725361 | 1725361 | 2021-09-16 | Frederick | Virginia | 51069 | 9915 | 113 |
1719267 | 1719267 | 2021-09-15 | Crawford | Arkansas | 5033 | 9915 | 155 |
1700361 | 1700361 | 2021-09-09 | Bartholomew | Indiana | 18005 | 9915 | 168 |
1692349 | 1692349 | 2021-09-06 | Greenwood | South Carolina | 45047 | 9915 | 177 |
1530981 | 1530981 | 2021-07-19 | Sutter | California | 6101 | 9915 | 114 |
1513713 | 1513713 | 2021-07-13 | Orangeburg | South Carolina | 45075 | 9915 | 255 |
1493582 | 1493582 | 2021-07-07 | Hunterdon | New Jersey | 34019 | 9915 | 176 |
1426072 | 1426072 | 2021-06-16 | Oconee | South Carolina | 45073 | 9915 | 138 |
1256763 | 1256763 | 2021-04-25 | Henderson | North Carolina | 37089 | 9915 | 157 |
1253516 | 1253516 | 2021-04-24 | Henderson | North Carolina | 37089 | 9915 | 157 |
1250269 | 1250269 | 2021-04-23 | Henderson | North Carolina | 37089 | 9915 | 157 |
1246528 | 1246528 | 2021-04-22 | Lee | Mississippi | 28081 | 9915 | 171 |
1210526 | 1210526 | 2021-04-11 | Terrebonne | Louisiana | 22109 | 9915 | 219 |
1207277 | 1207277 | 2021-04-10 | Terrebonne | Louisiana | 22109 | 9915 | 219 |
1204029 | 1204029 | 2021-04-09 | Terrebonne | Louisiana | 22109 | 9915 | 219 |
1140945 | 1140945 | 2021-03-20 | Stafford | Virginia | 51179 | 9915 | 68 |
1136678 | 1136678 | 2021-03-19 | Grand Forks | North Dakota | 38035 | 9915 | 76 |
1137114 | 1137114 | 2021-03-19 | Sumter | South Carolina | 45085 | 9915 | 187 |
810558 | 810558 | 2020-12-09 | Henry | Georgia | 13151 | 9915 | 143 |
758683 | 758683 | 2020-11-23 | Richmond | Georgia | 13245 | 9915 | 215 |
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);