ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 8276 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Florida 7
- Minnesota 6
- Texas 5
- Indiana 4
- Michigan 4
- Alabama 3
- Connecticut 3
- North Carolina 3
- South Carolina 3
- Tennessee 3
- Georgia 2
- Kentucky 2
- Ohio 2
- Virginia 2
- West Virginia 2
- Arizona 1
- Illinois 1
- Kansas 1
- New Jersey 1
- New York 1
- Oklahoma 1
- Pennsylvania 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2355709 | 2355709 | 2022-03-29 | Bee | Texas | 48025 | 8276 | 152 |
2339590 | 2339590 | 2022-03-24 | Matagorda | Texas | 48321 | 8276 | 175 |
2311550 | 2311550 | 2022-03-16 | Ripley | Indiana | 18137 | 8276 | 138 |
2269571 | 2269571 | 2022-03-03 | Logan | Kentucky | 21141 | 8276 | 112 |
2262602 | 2262602 | 2022-03-01 | Bureau | Illinois | 17011 | 8276 | 139 |
2236010 | 2236010 | 2022-02-21 | Dallas | Alabama | 1047 | 8276 | 228 |
2155696 | 2155696 | 2022-01-27 | Clark | Kentucky | 21049 | 8276 | 50 |
2128147 | 2128147 | 2022-01-18 | Kerr | Texas | 48265 | 8276 | 145 |
2124021 | 2124021 | 2022-01-17 | Otsego | New York | 36077 | 8276 | 75 |
2080361 | 2080361 | 2022-01-04 | Murray | Georgia | 13213 | 8276 | 153 |
2027332 | 2027332 | 2021-12-18 | Hale | Texas | 48189 | 8276 | 201 |
2005857 | 2005857 | 2021-12-12 | Lawrence | Indiana | 18093 | 8276 | 191 |
2007662 | 2007662 | 2021-12-12 | Franklin | Tennessee | 47051 | 8276 | 108 |
2002606 | 2002606 | 2021-12-11 | Lawrence | Indiana | 18093 | 8276 | 191 |
2004411 | 2004411 | 2021-12-11 | Franklin | Tennessee | 47051 | 8276 | 108 |
1999356 | 1999356 | 2021-12-10 | Lawrence | Indiana | 18093 | 8276 | 191 |
2000670 | 2000670 | 2021-12-10 | Ashland | Ohio | 39005 | 8276 | 157 |
2001160 | 2001160 | 2021-12-10 | Franklin | Tennessee | 47051 | 8276 | 108 |
1996659 | 1996659 | 2021-12-09 | Newaygo | Michigan | 26123 | 8276 | 116 |
1993408 | 1993408 | 2021-12-08 | Newaygo | Michigan | 26123 | 8276 | 116 |
1994963 | 1994963 | 2021-12-08 | Van Zandt | Texas | 48467 | 8276 | 227 |
1792585 | 1792585 | 2021-10-07 | McDowell | North Carolina | 37111 | 8276 | 114 |
1695441 | 1695441 | 2021-09-07 | Crawford | Pennsylvania | 42039 | 8276 | 164 |
1624758 | 1624758 | 2021-08-16 | Cowlitz | Washington | 53015 | 8276 | 106 |
1610000 | 1610000 | 2021-08-12 | Montcalm | Michigan | 26117 | 8276 | 121 |
1611851 | 1611851 | 2021-08-12 | Wood | West Virginia | 54107 | 8276 | 177 |
1606752 | 1606752 | 2021-08-11 | Montcalm | Michigan | 26117 | 8276 | 121 |
1599061 | 1599061 | 2021-08-09 | Santa Cruz | Arizona | 4023 | 8276 | 182 |
1506107 | 1506107 | 2021-07-11 | Clay | Minnesota | 27027 | 8276 | 92 |
1502861 | 1502861 | 2021-07-10 | Clay | Minnesota | 27027 | 8276 | 92 |
1499615 | 1499615 | 2021-07-09 | Clay | Minnesota | 27027 | 8276 | 92 |
1496369 | 1496369 | 2021-07-08 | Clay | Minnesota | 27027 | 8276 | 92 |
1493122 | 1493122 | 2021-07-07 | Clay | Minnesota | 27027 | 8276 | 92 |
1489875 | 1489875 | 2021-07-06 | Clay | Minnesota | 27027 | 8276 | 92 |
1485023 | 1485023 | 2021-07-04 | Hanover | Virginia | 51085 | 8276 | 167 |
1427234 | 1427234 | 2021-06-17 | Nassau | Florida | 12089 | 8276 | 127 |
1423989 | 1423989 | 2021-06-16 | Nassau | Florida | 12089 | 8276 | 127 |
1420741 | 1420741 | 2021-06-15 | Nassau | Florida | 12089 | 8276 | 127 |
1417496 | 1417496 | 2021-06-14 | Nassau | Florida | 12089 | 8276 | 127 |
1414250 | 1414250 | 2021-06-13 | Nassau | Florida | 12089 | 8276 | 127 |
1411005 | 1411005 | 2021-06-12 | Nassau | Florida | 12089 | 8276 | 127 |
1407760 | 1407760 | 2021-06-11 | Nassau | Florida | 12089 | 8276 | 127 |
1375392 | 1375392 | 2021-06-01 | Gordon | Georgia | 13129 | 8276 | 117 |
1377376 | 1377376 | 2021-06-01 | Greenwood | South Carolina | 45047 | 8276 | 172 |
1374130 | 1374130 | 2021-05-31 | Greenwood | South Carolina | 45047 | 8276 | 172 |
1367639 | 1367639 | 2021-05-29 | Greenwood | South Carolina | 45047 | 8276 | 172 |
1345508 | 1345508 | 2021-05-22 | Roanoke | Virginia | 51161 | 8276 | 145 |
1141464 | 1141464 | 2021-03-21 | Tolland | Connecticut | 9013 | 8276 | 178 |
1138218 | 1138218 | 2021-03-20 | Tolland | Connecticut | 9013 | 8276 | 178 |
1134972 | 1134972 | 2021-03-19 | Tolland | Connecticut | 9013 | 8276 | 178 |
1118304 | 1118304 | 2021-03-13 | Monongalia | West Virginia | 54061 | 8276 | 81 |
1102180 | 1102180 | 2021-03-08 | Laramie | Wyoming | 56021 | 8276 | 109 |
1058753 | 1058753 | 2021-02-23 | Wilson | North Carolina | 37195 | 8276 | 145 |
1052467 | 1052467 | 2021-02-21 | Payne | Oklahoma | 40119 | 8276 | 46 |
1008092 | 1008092 | 2021-02-08 | DeKalb | Alabama | 1049 | 8276 | 149 |
996001 | 996001 | 2021-02-04 | Douglas | Kansas | 20045 | 8276 | 66 |
984045 | 984045 | 2021-01-31 | Harnett | North Carolina | 37085 | 8276 | 117 |
656426 | 656426 | 2020-10-22 | Butler | Ohio | 39017 | 8276 | 129 |
599258 | 599258 | 2020-10-05 | Madison | Alabama | 1089 | 8276 | 78 |
452159 | 452159 | 2020-08-20 | Mercer | New Jersey | 34021 | 8276 | 624 |
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);