ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
126 rows where cases = 3293 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 11
- Minnesota 10
- Michigan 7
- Mississippi 7
- Texas 7
- Florida 5
- Georgia 5
- Idaho 5
- Louisiana 5
- Missouri 5
- Puerto Rico 5
- Tennessee 5
- Washington 5
- West Virginia 5
- Indiana 4
- Kentucky 4
- Ohio 3
- Pennsylvania 3
- Wisconsin 3
- Alabama 2
- California 2
- Colorado 2
- Kansas 2
- New York 2
- North Carolina 2
- Oregon 2
- Hawaii 1
- Illinois 1
- Montana 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483867 | 2483867 | 2022-05-08 | Gooding | Idaho | 16047 | 3293 | 54 |
2480609 | 2480609 | 2022-05-07 | Gooding | Idaho | 16047 | 3293 | 54 |
2477351 | 2477351 | 2022-05-06 | Gooding | Idaho | 16047 | 3293 | 54 |
2423799 | 2423799 | 2022-04-19 | Loiza | Puerto Rico | 72087 | 3293 | |
2420543 | 2420543 | 2022-04-18 | Loiza | Puerto Rico | 72087 | 3293 | |
2387994 | 2387994 | 2022-04-08 | Naguabo | Puerto Rico | 72103 | 3293 | |
2368490 | 2368490 | 2022-04-02 | Utuado | Puerto Rico | 72141 | 3293 | |
2352823 | 2352823 | 2022-03-28 | Martinsville city | Virginia | 51690 | 3293 | 115 |
2335365 | 2335365 | 2022-03-23 | Unknown | New Jersey | 3293 | 0 | |
2336225 | 2336225 | 2022-03-23 | Comanche | Texas | 48093 | 3293 | 78 |
2247274 | 2247274 | 2022-02-24 | Gasconade | Missouri | 29073 | 3293 | 93 |
2240191 | 2240191 | 2022-02-22 | Marion | Kansas | 20115 | 3293 | 39 |
2236940 | 2236940 | 2022-02-21 | Marion | Kansas | 20115 | 3293 | 39 |
2201264 | 2201264 | 2022-02-10 | Green | Kentucky | 21087 | 3293 | 40 |
2200128 | 2200128 | 2022-02-09 | Buffalo | Wisconsin | 55011 | 3293 | 11 |
2188602 | 2188602 | 2022-02-06 | Sibley | Minnesota | 27143 | 3293 | 23 |
2185349 | 2185349 | 2022-02-05 | Sibley | Minnesota | 27143 | 3293 | 23 |
2182097 | 2182097 | 2022-02-04 | Sibley | Minnesota | 27143 | 3293 | 23 |
2177850 | 2177850 | 2022-02-03 | Bleckley | Georgia | 13023 | 3293 | 85 |
2144640 | 2144640 | 2022-01-23 | Goochland | Virginia | 51075 | 3293 | 36 |
2141385 | 2141385 | 2022-01-22 | Goochland | Virginia | 51075 | 3293 | 36 |
2138129 | 2138129 | 2022-01-21 | Goochland | Virginia | 51075 | 3293 | 36 |
2105393 | 2105393 | 2022-01-11 | Lamb | Texas | 48279 | 3293 | 100 |
2102491 | 2102491 | 2022-01-10 | Hardy | West Virginia | 54031 | 3293 | 41 |
2081390 | 2081390 | 2022-01-04 | Cooper | Missouri | 29053 | 3293 | 62 |
2060759 | 2060759 | 2021-12-29 | Ben Hill | Georgia | 13017 | 3293 | 111 |
2034954 | 2034954 | 2021-12-21 | Minidoka | Idaho | 16067 | 3293 | 52 |
2009752 | 2009752 | 2021-12-13 | Roseau | Minnesota | 27135 | 3293 | 33 |
2006242 | 2006242 | 2021-12-12 | Concordia | Louisiana | 22029 | 3293 | 80 |
2002991 | 2002991 | 2021-12-11 | Concordia | Louisiana | 22029 | 3293 | 80 |
1999741 | 1999741 | 2021-12-10 | Concordia | Louisiana | 22029 | 3293 | 80 |
1998476 | 1998476 | 2021-12-09 | Lincoln | West Virginia | 54043 | 3293 | 54 |
1971245 | 1971245 | 2021-12-01 | Seneca | New York | 36099 | 3293 | 68 |
1967711 | 1967711 | 2021-11-30 | Vernon | Missouri | 29217 | 3293 | 82 |
1925672 | 1925672 | 2021-11-17 | Lincoln | New Mexico | 35027 | 3293 | 38 |
1927061 | 1927061 | 2021-11-17 | Vilas | Wisconsin | 55125 | 3293 | 60 |
1836889 | 1836889 | 2021-10-21 | Sullivan | Indiana | 18153 | 3293 | 54 |
1832628 | 1832628 | 2021-10-19 | Page | Virginia | 51139 | 3293 | 74 |
1787418 | 1787418 | 2021-10-06 | Marengo | Alabama | 1091 | 3293 | 89 |
1781652 | 1781652 | 2021-10-04 | Spencer | Indiana | 18147 | 3293 | 37 |
1782973 | 1782973 | 2021-10-04 | Hocking | Ohio | 39073 | 3293 | 72 |
1760455 | 1760455 | 2021-09-27 | Warren | Pennsylvania | 42123 | 3293 | 115 |
1760924 | 1760924 | 2021-09-27 | Moore | Texas | 48341 | 3293 | 79 |
1757676 | 1757676 | 2021-09-26 | Moore | Texas | 48341 | 3293 | 79 |
1757876 | 1757876 | 2021-09-26 | Lee | Virginia | 51105 | 3293 | 52 |
1754428 | 1754428 | 2021-09-25 | Moore | Texas | 48341 | 3293 | 79 |
1754628 | 1754628 | 2021-09-25 | Lee | Virginia | 51105 | 3293 | 52 |
1751380 | 1751380 | 2021-09-24 | Lee | Virginia | 51105 | 3293 | 52 |
1745054 | 1745054 | 2021-09-22 | Door | Wisconsin | 55029 | 3293 | 38 |
1733243 | 1733243 | 2021-09-19 | Russell | Kentucky | 21207 | 3293 | 53 |
1729993 | 1729993 | 2021-09-18 | Russell | Kentucky | 21207 | 3293 | 53 |
1700227 | 1700227 | 2021-09-09 | Cassia | Idaho | 16031 | 3293 | 29 |
1699351 | 1699351 | 2021-09-08 | Caroline | Virginia | 51033 | 3293 | 43 |
1678346 | 1678346 | 2021-09-02 | Grenada | Mississippi | 28043 | 3293 | 96 |
1665193 | 1665193 | 2021-08-29 | Houghton | Michigan | 26061 | 3293 | 44 |
1666467 | 1666467 | 2021-08-29 | DeKalb | Tennessee | 47041 | 3293 | 58 |
1661945 | 1661945 | 2021-08-28 | Houghton | Michigan | 26061 | 3293 | 44 |
1662281 | 1662281 | 2021-08-28 | Washington | Missouri | 29221 | 3293 | 56 |
1663219 | 1663219 | 2021-08-28 | DeKalb | Tennessee | 47041 | 3293 | 58 |
1658697 | 1658697 | 2021-08-27 | Houghton | Michigan | 26061 | 3293 | 44 |
1659971 | 1659971 | 2021-08-27 | DeKalb | Tennessee | 47041 | 3293 | 58 |
1633911 | 1633911 | 2021-08-19 | Davison | South Dakota | 46035 | 3293 | 69 |
1626234 | 1626234 | 2021-08-17 | Mecosta | Michigan | 26107 | 3293 | 38 |
1627218 | 1627218 | 2021-08-17 | Clarion | Pennsylvania | 42031 | 3293 | 96 |
1622987 | 1622987 | 2021-08-16 | Mecosta | Michigan | 26107 | 3293 | 38 |
1621526 | 1621526 | 2021-08-15 | Mason | Washington | 53045 | 3293 | 40 |
1618278 | 1618278 | 2021-08-14 | Mason | Washington | 53045 | 3293 | 40 |
1615030 | 1615030 | 2021-08-13 | Mason | Washington | 53045 | 3293 | 40 |
1607552 | 1607552 | 2021-08-11 | Jackson | Ohio | 39079 | 3293 | 54 |
1602004 | 1602004 | 2021-08-09 | Warren | Virginia | 51187 | 3293 | 63 |
1538892 | 1538892 | 2021-07-21 | Ravalli | Montana | 30081 | 3293 | 51 |
1496168 | 1496168 | 2021-07-08 | East Feliciana | Louisiana | 22037 | 3293 | 115 |
1493390 | 1493390 | 2021-07-07 | Warren | Missouri | 29219 | 3293 | 39 |
1485841 | 1485841 | 2021-07-05 | Hawaii | Hawaii | 15001 | 3293 | 55 |
1468931 | 1468931 | 2021-06-29 | Logan | West Virginia | 54045 | 3293 | 96 |
1370739 | 1370739 | 2021-05-30 | Greene | Pennsylvania | 42059 | 3293 | 40 |
1353594 | 1353594 | 2021-05-25 | Nicollet | Minnesota | 27103 | 3293 | 44 |
1350348 | 1350348 | 2021-05-24 | Nicollet | Minnesota | 27103 | 3293 | 44 |
1327623 | 1327623 | 2021-05-17 | Pine | Minnesota | 27115 | 3293 | 22 |
1297763 | 1297763 | 2021-05-08 | Jefferson | Indiana | 18077 | 3293 | 82 |
1284423 | 1284423 | 2021-05-04 | Unknown | Florida | 3293 | 0 | |
1276701 | 1276701 | 2021-05-01 | Vega Baja | Puerto Rico | 72145 | 3293 | |
1244933 | 1244933 | 2021-04-21 | Fayette | West Virginia | 54019 | 3293 | 78 |
1230172 | 1230172 | 2021-04-17 | Carlton | Minnesota | 27017 | 3293 | 52 |
1226625 | 1226625 | 2021-04-16 | Floyd | Kentucky | 21071 | 3293 | 62 |
1214080 | 1214080 | 2021-04-12 | Sunflower | Mississippi | 28133 | 3293 | 89 |
1210832 | 1210832 | 2021-04-11 | Sunflower | Mississippi | 28133 | 3293 | 89 |
1207583 | 1207583 | 2021-04-10 | Sunflower | Mississippi | 28133 | 3293 | 89 |
1204639 | 1204639 | 2021-04-09 | Grafton | New Hampshire | 33009 | 3293 | 21 |
1131698 | 1131698 | 2021-03-18 | Montrose | Colorado | 8085 | 3293 | 56 |
1128450 | 1128450 | 2021-03-17 | Montrose | Colorado | 8085 | 3293 | 54 |
1108504 | 1108504 | 2021-03-10 | Douglas | Washington | 53017 | 3293 | 22 |
1097020 | 1097020 | 2021-03-07 | Tuscola | Michigan | 26157 | 3293 | 138 |
1093773 | 1093773 | 2021-03-06 | Tuscola | Michigan | 26157 | 3293 | 138 |
1070056 | 1070056 | 2021-02-27 | Baker | Florida | 12003 | 3293 | 55 |
1063067 | 1063067 | 2021-02-24 | Grays Harbor | Washington | 53027 | 3293 | 45 |
1000578 | 1000578 | 2021-02-05 | Malheur | Oregon | 41045 | 3293 | 56 |
969001 | 969001 | 2021-01-26 | Ohio | West Virginia | 54069 | 3293 | 59 |
962836 | 962836 | 2021-01-25 | Mendocino | California | 6045 | 3293 | 36 |
956522 | 956522 | 2021-01-23 | Unknown | Florida | 3293 | 0 |
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);