ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 3612 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Missouri 10
- Iowa 9
- Wisconsin 8
- Arkansas 7
- Kansas 6
- Louisiana 6
- Michigan 6
- North Carolina 6
- Virginia 6
- California 5
- Georgia 5
- Ohio 5
- Tennessee 4
- Indiana 3
- Kentucky 3
- New York 3
- Maine 2
- Minnesota 2
- Oregon 2
- Pennsylvania 2
- South Carolina 2
- Alabama 1
- Colorado 1
- Florida 1
- Maryland 1
- New Hampshire 1
- North Dakota 1
- Puerto Rico 1
- Vermont 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502662 | 2502662 | 2022-05-13 | Klickitat | Washington | 53039 | 3612 | 47 |
2468909 | 2468909 | 2022-05-03 | Yates | New York | 36123 | 3612 | 40 |
2453361 | 2453361 | 2022-04-28 | Bandera | Texas | 48019 | 3612 | 77 |
2294454 | 2294454 | 2022-03-10 | Lafayette | Wisconsin | 55065 | 3612 | 22 |
2277397 | 2277397 | 2022-03-05 | Quebradillas | Puerto Rico | 72115 | 3612 | |
2235730 | 2235730 | 2022-02-20 | King William | Virginia | 51101 | 3612 | 31 |
2232479 | 2232479 | 2022-02-19 | King William | Virginia | 51101 | 3612 | 31 |
2229228 | 2229228 | 2022-02-18 | King William | Virginia | 51101 | 3612 | 31 |
2170899 | 2170899 | 2022-01-31 | Richland | Wisconsin | 55103 | 3612 | 39 |
2163920 | 2163920 | 2022-01-29 | Houston | Texas | 48225 | 3612 | 96 |
2084617 | 2084617 | 2022-01-05 | Andrew | Missouri | 29003 | 3612 | 42 |
2084725 | 2084725 | 2022-01-05 | Texas | Missouri | 29215 | 3612 | 74 |
2078739 | 2078739 | 2022-01-03 | Paulding | Ohio | 39125 | 3612 | 61 |
2057222 | 2057222 | 2021-12-28 | Arkansas | Arkansas | 5001 | 3612 | 64 |
2035941 | 2035941 | 2021-12-21 | Perry | Missouri | 29157 | 3612 | 40 |
2018037 | 2018037 | 2021-12-15 | Green Lake | Wisconsin | 55047 | 3612 | 44 |
2008844 | 2008844 | 2021-12-13 | McDuffie | Georgia | 13189 | 3612 | 78 |
1994871 | 1994871 | 2021-12-08 | Lampasas | Texas | 48281 | 3612 | 70 |
1963901 | 1963901 | 2021-11-29 | Harrison | Kentucky | 21097 | 3612 | 50 |
1938113 | 1938113 | 2021-11-21 | Gladwin | Michigan | 26051 | 3612 | 80 |
1934863 | 1934863 | 2021-11-20 | Gladwin | Michigan | 26051 | 3612 | 80 |
1931613 | 1931613 | 2021-11-19 | Gladwin | Michigan | 26051 | 3612 | 80 |
1888098 | 1888098 | 2021-11-06 | Barbour | Alabama | 1005 | 3612 | 79 |
1875904 | 1875904 | 2021-11-02 | Bremer | Iowa | 19017 | 3612 | 68 |
1872655 | 1872655 | 2021-11-01 | Bremer | Iowa | 19017 | 3612 | 68 |
1873635 | 1873635 | 2021-11-01 | Coos | New Hampshire | 33007 | 3612 | 59 |
1869406 | 1869406 | 2021-10-31 | Bremer | Iowa | 19017 | 3612 | 68 |
1866157 | 1866157 | 2021-10-30 | Bremer | Iowa | 19017 | 3612 | 68 |
1862908 | 1862908 | 2021-10-29 | Bremer | Iowa | 19017 | 3612 | 68 |
1859659 | 1859659 | 2021-10-28 | Bremer | Iowa | 19017 | 3612 | 68 |
1856410 | 1856410 | 2021-10-27 | Bremer | Iowa | 19017 | 3612 | 68 |
1858789 | 1858789 | 2021-10-27 | Kewaunee | Wisconsin | 55061 | 3612 | 41 |
1837015 | 1837015 | 2021-10-21 | Cherokee | Kansas | 20021 | 3612 | 77 |
1833766 | 1833766 | 2021-10-20 | Cherokee | Kansas | 20021 | 3612 | 77 |
1816284 | 1816284 | 2021-10-14 | Rutland | Vermont | 50021 | 3612 | 27 |
1742036 | 1742036 | 2021-09-22 | Lincoln | Arkansas | 5079 | 3612 | 55 |
1738315 | 1738315 | 2021-09-20 | Accomack | Virginia | 51001 | 3612 | 63 |
1626904 | 1626904 | 2021-08-17 | Montgomery | North Carolina | 37123 | 3612 | 97 |
1622177 | 1622177 | 2021-08-16 | Madison | Georgia | 13195 | 3612 | 57 |
1595325 | 1595325 | 2021-08-07 | Willacy | Texas | 48489 | 3612 | 93 |
1542389 | 1542389 | 2021-07-22 | Wyoming | New York | 36121 | 3612 | 53 |
1500371 | 1500371 | 2021-07-09 | Highland | Ohio | 39071 | 3612 | 68 |
1497125 | 1497125 | 2021-07-08 | Highland | Ohio | 39071 | 3612 | 67 |
1454374 | 1454374 | 2021-06-25 | Howell | Missouri | 29091 | 3612 | 45 |
1454415 | 1454415 | 2021-06-25 | Pulaski | Missouri | 29169 | 3612 | 55 |
1429428 | 1429428 | 2021-06-17 | Hardin | Tennessee | 47071 | 3612 | 69 |
1426183 | 1426183 | 2021-06-16 | Hardin | Tennessee | 47071 | 3612 | 69 |
1422936 | 1422936 | 2021-06-15 | Hardin | Tennessee | 47071 | 3612 | 69 |
1418710 | 1418710 | 2021-06-14 | Polk | Missouri | 29167 | 3612 | 40 |
1394588 | 1394588 | 2021-06-07 | St. Francis | Arkansas | 5123 | 3612 | 44 |
1344375 | 1344375 | 2021-05-22 | Warren | New York | 36113 | 3612 | 57 |
1333276 | 1333276 | 2021-05-19 | Wayne | Georgia | 13305 | 3612 | 89 |
1324361 | 1324361 | 2021-05-16 | Lyon | Minnesota | 27083 | 3612 | 51 |
1318819 | 1318819 | 2021-05-14 | Snyder | Pennsylvania | 42109 | 3612 | 84 |
1314299 | 1314299 | 2021-05-13 | Greenup | Kentucky | 21089 | 3612 | 59 |
1314394 | 1314394 | 2021-05-13 | Evangeline | Louisiana | 22039 | 3612 | 93 |
1305944 | 1305944 | 2021-05-10 | Colleton | South Carolina | 45029 | 3612 | 127 |
1302698 | 1302698 | 2021-05-09 | Colleton | South Carolina | 45029 | 3612 | 127 |
1299326 | 1299326 | 2021-05-08 | McKean | Pennsylvania | 42083 | 3612 | 68 |
1286572 | 1286572 | 2021-05-04 | Carroll | Tennessee | 47017 | 3612 | 83 |
1281530 | 1281530 | 2021-05-03 | Jasper | Indiana | 18073 | 3612 | 49 |
1279797 | 1279797 | 2021-05-02 | Polk | Oregon | 41053 | 3612 | 52 |
1271454 | 1271454 | 2021-04-30 | Bryan | Georgia | 13029 | 3612 | 39 |
1253689 | 1253689 | 2021-04-24 | Ottawa | Ohio | 39123 | 3612 | 78 |
1251482 | 1251482 | 2021-04-23 | Clark | Wisconsin | 55019 | 3612 | 62 |
1248235 | 1248235 | 2021-04-22 | Clark | Wisconsin | 55019 | 3612 | 62 |
1222530 | 1222530 | 2021-04-15 | Amador | California | 6005 | 3612 | 46 |
1184925 | 1184925 | 2021-04-03 | Marion | Missouri | 29127 | 3612 | 43 |
1170855 | 1170855 | 2021-03-30 | Liberty | Georgia | 13179 | 3612 | 60 |
1173048 | 1173048 | 2021-03-30 | Cooke | Texas | 48097 | 3612 | 68 |
1162005 | 1162005 | 2021-03-27 | McLeod | Minnesota | 27085 | 3612 | 54 |
1142294 | 1142294 | 2021-03-21 | Iberville | Louisiana | 22047 | 3612 | 94 |
1139048 | 1139048 | 2021-03-20 | Iberville | Louisiana | 22047 | 3612 | 94 |
1135802 | 1135802 | 2021-03-19 | Iberville | Louisiana | 22047 | 3612 | 94 |
1132555 | 1132555 | 2021-03-18 | Iberville | Louisiana | 22047 | 3612 | 94 |
1110263 | 1110263 | 2021-03-11 | Phelps | Missouri | 29161 | 3612 | 123 |
1067679 | 1067679 | 2021-02-26 | Kennebec | Maine | 23011 | 3612 | 51 |
1065244 | 1065244 | 2021-02-25 | Yadkin | North Carolina | 37197 | 3612 | 46 |
1060112 | 1060112 | 2021-02-24 | Boone | Arkansas | 5009 | 3612 | 78 |
1061035 | 1061035 | 2021-02-24 | Franklin | Kentucky | 21073 | 3612 | 28 |
1050438 | 1050438 | 2021-02-21 | Union | Arkansas | 5139 | 3612 | 102 |
1047191 | 1047191 | 2021-02-20 | Union | Arkansas | 5139 | 3612 | 100 |
1048219 | 1048219 | 2021-02-20 | Calvert | Maryland | 24009 | 3612 | 67 |
1043946 | 1043946 | 2021-02-19 | Union | Arkansas | 5139 | 3612 | 100 |
1037528 | 1037528 | 2021-02-17 | Broomfield | Colorado | 8014 | 3612 | 73 |
1037611 | 1037611 | 2021-02-17 | DeSoto | Florida | 12027 | 3612 | 71 |
1028408 | 1028408 | 2021-02-14 | Plymouth | Iowa | 19149 | 3612 | 75 |
1030362 | 1030362 | 2021-02-14 | Rusk | Texas | 48401 | 3612 | 89 |
1030577 | 1030577 | 2021-02-14 | Shenandoah | Virginia | 51171 | 3612 | 101 |
1020064 | 1020064 | 2021-02-11 | Yamhill | Oregon | 41071 | 3612 | 60 |
1011522 | 1011522 | 2021-02-09 | Mendocino | California | 6045 | 3612 | 39 |
1008276 | 1008276 | 2021-02-08 | Mendocino | California | 6045 | 3612 | 39 |
937849 | 937849 | 2021-01-17 | Androscoggin | Maine | 23001 | 3612 | 51 |
921588 | 921588 | 2021-01-12 | Lincoln | Louisiana | 22061 | 3612 | 78 |
915909 | 915909 | 2021-01-10 | McDowell | North Carolina | 37111 | 3612 | 39 |
905193 | 905193 | 2021-01-07 | Seward | Kansas | 20175 | 3612 | 28 |
901948 | 901948 | 2021-01-06 | Seward | Kansas | 20175 | 3612 | 28 |
896031 | 896031 | 2021-01-04 | Lincoln | Missouri | 29113 | 3612 | 20 |
892784 | 892784 | 2021-01-03 | Lincoln | Missouri | 29113 | 3612 | 20 |
887935 | 887935 | 2021-01-01 | Pierce | Wisconsin | 55093 | 3612 | 35 |
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);