ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where cases = 4818 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wisconsin 9
- Georgia 8
- Missouri 8
- Oklahoma 8
- Illinois 7
- Alabama 5
- California 5
- Kansas 5
- Arkansas 4
- Indiana 4
- Minnesota 4
- North Carolina 4
- Pennsylvania 4
- Michigan 3
- New York 3
- Ohio 3
- Puerto Rico 3
- Virginia 3
- Colorado 2
- Iowa 2
- Kentucky 2
- South Dakota 2
- Texas 2
- West Virginia 2
- Wyoming 2
- Florida 1
- Louisiana 1
- Maryland 1
- Mississippi 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497842 | 2497842 | 2022-05-12 | Clinton | Missouri | 29049 | 4818 | 119 |
2494584 | 2494584 | 2022-05-11 | Clinton | Missouri | 29049 | 4818 | 119 |
2491326 | 2491326 | 2022-05-10 | Clinton | Missouri | 29049 | 4818 | 119 |
2488068 | 2488068 | 2022-05-09 | Clinton | Missouri | 29049 | 4818 | 119 |
2484811 | 2484811 | 2022-05-08 | Clinton | Missouri | 29049 | 4818 | 119 |
2481553 | 2481553 | 2022-05-07 | Clinton | Missouri | 29049 | 4818 | 119 |
2478295 | 2478295 | 2022-05-06 | Clinton | Missouri | 29049 | 4818 | 119 |
2466160 | 2466160 | 2022-05-02 | Yauco | Puerto Rico | 72153 | 4818 | |
2460652 | 2460652 | 2022-05-01 | Phillips | Arkansas | 5107 | 4818 | 99 |
2457396 | 2457396 | 2022-04-30 | Phillips | Arkansas | 5107 | 4818 | 99 |
2454140 | 2454140 | 2022-04-29 | Phillips | Arkansas | 5107 | 4818 | 99 |
2375805 | 2375805 | 2022-04-04 | Taylor | Wisconsin | 55119 | 4818 | 72 |
2372553 | 2372553 | 2022-04-03 | Taylor | Wisconsin | 55119 | 4818 | 72 |
2369300 | 2369300 | 2022-04-02 | Taylor | Wisconsin | 55119 | 4818 | 72 |
2366047 | 2366047 | 2022-04-01 | Taylor | Wisconsin | 55119 | 4818 | 72 |
2362794 | 2362794 | 2022-03-31 | Taylor | Wisconsin | 55119 | 4818 | 72 |
2359540 | 2359540 | 2022-03-30 | Taylor | Wisconsin | 55119 | 4818 | 72 |
2291878 | 2291878 | 2022-03-10 | Clark | Illinois | 17023 | 4818 | 60 |
2268273 | 2268273 | 2022-03-02 | Powhatan | Virginia | 51145 | 4818 | 52 |
2259278 | 2259278 | 2022-02-28 | Union | Georgia | 13291 | 4818 | 144 |
2236729 | 2236729 | 2022-02-21 | Jay | Indiana | 18075 | 4818 | 76 |
2199758 | 2199758 | 2022-02-09 | Milam | Texas | 48331 | 4818 | 94 |
2187604 | 2187604 | 2022-02-06 | Berrien | Georgia | 13019 | 4818 | 72 |
2184351 | 2184351 | 2022-02-05 | Berrien | Georgia | 13019 | 4818 | 72 |
2181099 | 2181099 | 2022-02-04 | Berrien | Georgia | 13019 | 4818 | 72 |
2173309 | 2173309 | 2022-02-01 | Hatillo | Puerto Rico | 72065 | 4818 | |
2170057 | 2170057 | 2022-01-31 | Hatillo | Puerto Rico | 72065 | 4818 | |
2126392 | 2126392 | 2022-01-18 | Anderson | Kentucky | 21005 | 4818 | 58 |
2087637 | 2087637 | 2022-01-06 | Emmet | Michigan | 26047 | 4818 | 63 |
2079539 | 2079539 | 2022-01-03 | St. Croix | Virgin Islands | 78010 | 4818 | 38 |
2039145 | 2039145 | 2021-12-22 | Dunklin | Missouri | 29069 | 4818 | 93 |
2031796 | 2031796 | 2021-12-20 | Saline | Illinois | 17165 | 4818 | 90 |
2029926 | 2029926 | 2021-12-19 | Adams | Ohio | 39001 | 4818 | 113 |
2019525 | 2019525 | 2021-12-16 | Adams | Mississippi | 28001 | 4818 | 125 |
2007032 | 2007032 | 2021-12-12 | Cherokee | North Carolina | 37039 | 4818 | 86 |
2003781 | 2003781 | 2021-12-11 | Cherokee | North Carolina | 37039 | 4818 | 86 |
2000530 | 2000530 | 2021-12-10 | Cherokee | North Carolina | 37039 | 4818 | 86 |
1992289 | 1992289 | 2021-12-08 | Yell | Arkansas | 5149 | 4818 | 84 |
1993251 | 1993251 | 2021-12-08 | Jefferson Davis | Louisiana | 22053 | 4818 | 130 |
1988172 | 1988172 | 2021-12-06 | Hickman | Tennessee | 47081 | 4818 | 78 |
1945211 | 1945211 | 2021-11-23 | Greene | New York | 36039 | 4818 | 88 |
1928367 | 1928367 | 2021-11-18 | Houghton | Michigan | 26061 | 4818 | 58 |
1925117 | 1925117 | 2021-11-17 | Houghton | Michigan | 26061 | 4818 | 58 |
1907607 | 1907607 | 2021-11-12 | Clarke | Alabama | 1025 | 4818 | 86 |
1898830 | 1898830 | 2021-11-09 | Seward | Kansas | 20175 | 4818 | 50 |
1895580 | 1895580 | 2021-11-08 | Seward | Kansas | 20175 | 4818 | 50 |
1892330 | 1892330 | 2021-11-07 | Seward | Kansas | 20175 | 4818 | 50 |
1889080 | 1889080 | 2021-11-06 | Seward | Kansas | 20175 | 4818 | 50 |
1885830 | 1885830 | 2021-11-05 | Seward | Kansas | 20175 | 4818 | 50 |
1881880 | 1881880 | 2021-11-04 | Logan | Colorado | 8075 | 4818 | 87 |
1875616 | 1875616 | 2021-11-02 | Stephens | Georgia | 13257 | 4818 | 109 |
1831761 | 1831761 | 2021-10-19 | Adair | Oklahoma | 40001 | 4818 | 57 |
1828512 | 1828512 | 2021-10-18 | Adair | Oklahoma | 40001 | 4818 | 57 |
1825263 | 1825263 | 2021-10-17 | Adair | Oklahoma | 40001 | 4818 | 57 |
1822014 | 1822014 | 2021-10-16 | Adair | Oklahoma | 40001 | 4818 | 57 |
1818765 | 1818765 | 2021-10-15 | Adair | Oklahoma | 40001 | 4818 | 57 |
1815516 | 1815516 | 2021-10-14 | Adair | Oklahoma | 40001 | 4818 | 57 |
1812268 | 1812268 | 2021-10-13 | Adair | Oklahoma | 40001 | 4818 | 57 |
1792008 | 1792008 | 2021-10-07 | Polk | Minnesota | 27119 | 4818 | 75 |
1768531 | 1768531 | 2021-09-30 | Logan | Illinois | 17107 | 4818 | 87 |
1758176 | 1758176 | 2021-09-27 | Marion | Alabama | 1093 | 4818 | 120 |
1741104 | 1741104 | 2021-09-21 | Brookings | South Dakota | 46011 | 4818 | 37 |
1698279 | 1698279 | 2021-09-08 | Montgomery | New York | 36057 | 4818 | 132 |
1676137 | 1676137 | 2021-09-01 | Codington | South Dakota | 46029 | 4818 | 82 |
1666029 | 1666029 | 2021-08-29 | Madison | Ohio | 39097 | 4818 | 65 |
1649037 | 1649037 | 2021-08-24 | Itasca | Minnesota | 27061 | 4818 | 69 |
1622407 | 1622407 | 2021-08-16 | Clinton | Indiana | 18023 | 4818 | 64 |
1607720 | 1607720 | 2021-08-11 | Bedford | Pennsylvania | 42009 | 4818 | 142 |
1591945 | 1591945 | 2021-08-06 | Howard | Texas | 48227 | 4818 | 103 |
1541012 | 1541012 | 2021-07-22 | Thomas | Georgia | 13275 | 4818 | 127 |
1537108 | 1537108 | 2021-07-20 | Jefferson | West Virginia | 54037 | 4818 | 60 |
1533860 | 1533860 | 2021-07-19 | Jefferson | West Virginia | 54037 | 4818 | 60 |
1514226 | 1514226 | 2021-07-13 | Fauquier | Virginia | 51061 | 4818 | 69 |
1492840 | 1492840 | 2021-07-07 | Jessamine | Kentucky | 21113 | 4818 | 72 |
1474283 | 1474283 | 2021-07-01 | Richmond | North Carolina | 37153 | 4818 | 98 |
1424311 | 1424311 | 2021-06-16 | Stephenson | Illinois | 17177 | 4818 | 104 |
1397611 | 1397611 | 2021-06-07 | Polk | Wisconsin | 55095 | 4818 | 61 |
1371908 | 1371908 | 2021-05-31 | Nevada | California | 6057 | 4818 | 75 |
1344331 | 1344331 | 2021-05-22 | Clinton | New York | 36019 | 4818 | 33 |
1327105 | 1327105 | 2021-05-17 | Muscatine | Iowa | 19139 | 4818 | 100 |
1299078 | 1299078 | 2021-05-08 | Williams | North Dakota | 38105 | 4818 | 38 |
1270853 | 1270853 | 2021-04-29 | Washington | Virginia | 51191 | 4818 | 106 |
1267782 | 1267782 | 2021-04-28 | Campbell | Wyoming | 56005 | 4818 | 60 |
1264535 | 1264535 | 2021-04-27 | Campbell | Wyoming | 56005 | 4818 | 60 |
1232624 | 1232624 | 2021-04-18 | Ware | Georgia | 13299 | 4818 | 171 |
1209877 | 1209877 | 2021-04-11 | Tift | Georgia | 13277 | 4818 | 124 |
1193056 | 1193056 | 2021-04-05 | Oconto | Wisconsin | 55083 | 4818 | 57 |
1189806 | 1189806 | 2021-04-04 | Oconto | Wisconsin | 55083 | 4818 | 57 |
1179141 | 1179141 | 2021-04-01 | Bradford | Pennsylvania | 42015 | 4818 | 83 |
1155469 | 1155469 | 2021-03-25 | Benton | Minnesota | 27009 | 4818 | 95 |
1077606 | 1077606 | 2021-03-01 | Otter Tail | Minnesota | 27111 | 4818 | 70 |
1059026 | 1059026 | 2021-02-23 | Carbon | Pennsylvania | 42025 | 4818 | 149 |
1052326 | 1052326 | 2021-02-21 | Belmont | Ohio | 39013 | 4818 | 85 |
1036240 | 1036240 | 2021-02-16 | Pontotoc | Oklahoma | 40123 | 4818 | 44 |
992508 | 992508 | 2021-02-03 | Ogle | Illinois | 17141 | 4818 | 75 |
986156 | 986156 | 2021-02-01 | Cerro Gordo | Iowa | 19033 | 4818 | 74 |
940152 | 940152 | 2021-01-18 | Yuba | California | 6115 | 4818 | 27 |
936907 | 936907 | 2021-01-17 | Yuba | California | 6115 | 4818 | 27 |
933662 | 933662 | 2021-01-16 | Yuba | California | 6115 | 4818 | 27 |
930417 | 930417 | 2021-01-15 | Yuba | California | 6115 | 4818 | 27 |
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);