ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 4635 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Georgia 9
- Mississippi 9
- Arkansas 7
- Michigan 7
- Texas 7
- Virginia 7
- Missouri 6
- Wisconsin 6
- Illinois 5
- Indiana 4
- Montana 4
- Tennessee 4
- Colorado 3
- Kentucky 3
- Minnesota 3
- Alabama 2
- Iowa 2
- Louisiana 2
- Nebraska 2
- New York 2
- Ohio 2
- Oregon 2
- Pennsylvania 2
- South Carolina 2
- California 1
- Florida 1
- Oklahoma 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499144 | 2499144 | 2022-05-12 | Reeves | Texas | 48389 | 4635 | 74 |
2489301 | 2489301 | 2022-05-09 | Jones | Texas | 48253 | 4635 | 93 |
2486044 | 2486044 | 2022-05-08 | Jones | Texas | 48253 | 4635 | 93 |
2482786 | 2482786 | 2022-05-07 | Jones | Texas | 48253 | 4635 | 93 |
2468316 | 2468316 | 2022-05-03 | Roscommon | Michigan | 26143 | 4635 | 114 |
2463921 | 2463921 | 2022-05-02 | Sharp | Arkansas | 5135 | 4635 | 105 |
2465061 | 2465061 | 2022-05-02 | Roscommon | Michigan | 26143 | 4635 | 114 |
2460665 | 2460665 | 2022-05-01 | Sharp | Arkansas | 5135 | 4635 | 105 |
2461805 | 2461805 | 2022-05-01 | Roscommon | Michigan | 26143 | 4635 | 114 |
2457409 | 2457409 | 2022-04-30 | Sharp | Arkansas | 5135 | 4635 | 105 |
2458549 | 2458549 | 2022-04-30 | Roscommon | Michigan | 26143 | 4635 | 114 |
2454153 | 2454153 | 2022-04-29 | Sharp | Arkansas | 5135 | 4635 | 105 |
2455293 | 2455293 | 2022-04-29 | Roscommon | Michigan | 26143 | 4635 | 114 |
2450897 | 2450897 | 2022-04-28 | Sharp | Arkansas | 5135 | 4635 | 105 |
2452037 | 2452037 | 2022-04-28 | Roscommon | Michigan | 26143 | 4635 | 114 |
2448781 | 2448781 | 2022-04-27 | Roscommon | Michigan | 26143 | 4635 | 114 |
2421669 | 2421669 | 2022-04-19 | Chaffee | Colorado | 8015 | 4635 | 44 |
2424433 | 2424433 | 2022-04-19 | New Kent | Virginia | 51127 | 4635 | 32 |
2395276 | 2395276 | 2022-04-10 | Adams | Wisconsin | 55001 | 4635 | 61 |
2392020 | 2392020 | 2022-04-09 | Adams | Wisconsin | 55001 | 4635 | 61 |
2388764 | 2388764 | 2022-04-08 | Adams | Wisconsin | 55001 | 4635 | 61 |
2385509 | 2385509 | 2022-04-07 | Adams | Wisconsin | 55001 | 4635 | 61 |
2325213 | 2325213 | 2022-03-20 | Calhoun | Mississippi | 28013 | 4635 | 70 |
2321959 | 2321959 | 2022-03-19 | Calhoun | Mississippi | 28013 | 4635 | 70 |
2318705 | 2318705 | 2022-03-18 | Calhoun | Mississippi | 28013 | 4635 | 70 |
2315452 | 2315452 | 2022-03-17 | Calhoun | Mississippi | 28013 | 4635 | 70 |
2312199 | 2312199 | 2022-03-16 | Calhoun | Mississippi | 28013 | 4635 | 70 |
2308946 | 2308946 | 2022-03-15 | Calhoun | Mississippi | 28013 | 4635 | 70 |
2305695 | 2305695 | 2022-03-14 | Calhoun | Mississippi | 28013 | 4635 | 70 |
2270106 | 2270106 | 2022-03-03 | Texas | Missouri | 29215 | 4635 | 91 |
2256043 | 2256043 | 2022-02-27 | Worth | Georgia | 13321 | 4635 | 108 |
2257134 | 2257134 | 2022-02-27 | Lincoln | Montana | 30053 | 4635 | 81 |
2252792 | 2252792 | 2022-02-26 | Worth | Georgia | 13321 | 4635 | 108 |
2253883 | 2253883 | 2022-02-26 | Lincoln | Montana | 30053 | 4635 | 81 |
2249541 | 2249541 | 2022-02-25 | Worth | Georgia | 13321 | 4635 | 108 |
2250632 | 2250632 | 2022-02-25 | Lincoln | Montana | 30053 | 4635 | 81 |
2223015 | 2223015 | 2022-02-17 | Hale | Alabama | 1065 | 4635 | 97 |
2187368 | 2187368 | 2022-02-06 | Phillips | Arkansas | 5107 | 4635 | 84 |
2124890 | 2124890 | 2022-01-17 | Karnes | Texas | 48255 | 4635 | 58 |
2119388 | 2119388 | 2022-01-16 | Pike | Georgia | 13231 | 4635 | 76 |
2116136 | 2116136 | 2022-01-15 | Pike | Georgia | 13231 | 4635 | 76 |
2112885 | 2112885 | 2022-01-14 | Pike | Georgia | 13231 | 4635 | 76 |
2104200 | 2104200 | 2022-01-11 | Nodaway | Missouri | 29147 | 4635 | 40 |
2100949 | 2100949 | 2022-01-10 | Nodaway | Missouri | 29147 | 4635 | 39 |
2097698 | 2097698 | 2022-01-09 | Nodaway | Missouri | 29147 | 4635 | 39 |
2097808 | 2097808 | 2022-01-09 | Cass | Nebraska | 31025 | 4635 | 29 |
2094446 | 2094446 | 2022-01-08 | Nodaway | Missouri | 29147 | 4635 | 39 |
2021258 | 2021258 | 2021-12-16 | Upshur | West Virginia | 54097 | 4635 | 72 |
2016356 | 2016356 | 2021-12-15 | Yazoo | Mississippi | 28163 | 4635 | 93 |
1998749 | 1998749 | 2021-12-10 | Jackson | Arkansas | 5067 | 4635 | 47 |
1975592 | 1975592 | 2021-12-02 | Isle of Wight | Virginia | 51093 | 4635 | 92 |
1904953 | 1904953 | 2021-11-11 | Bureau | Illinois | 17011 | 4635 | 107 |
1901703 | 1901703 | 2021-11-10 | Bureau | Illinois | 17011 | 4635 | 107 |
1824967 | 1824967 | 2021-10-17 | Chenango | New York | 36017 | 4635 | 86 |
1785272 | 1785272 | 2021-10-05 | Jefferson Davis | Louisiana | 22053 | 4635 | 121 |
1770902 | 1770902 | 2021-09-30 | Prince George | Virginia | 51149 | 4635 | 35 |
1719675 | 1719675 | 2021-09-15 | Unknown | Georgia | 4635 | 12 | |
1714305 | 1714305 | 2021-09-13 | Silver Bow | Montana | 30093 | 4635 | 90 |
1672483 | 1672483 | 2021-08-31 | Brown | Ohio | 39015 | 4635 | 65 |
1647958 | 1647958 | 2021-08-24 | La Plata | Colorado | 8067 | 4635 | 45 |
1647280 | 1647280 | 2021-08-23 | Titus | Texas | 48449 | 4635 | 87 |
1630055 | 1630055 | 2021-08-18 | Livingston | New York | 36051 | 4635 | 60 |
1610954 | 1610954 | 2021-08-12 | Polk | Oregon | 41053 | 4635 | 60 |
1604802 | 1604802 | 2021-08-10 | Rhea | Tennessee | 47143 | 4635 | 83 |
1596439 | 1596439 | 2021-08-08 | Harrison | Indiana | 18061 | 4635 | 79 |
1593190 | 1593190 | 2021-08-07 | Harrison | Indiana | 18061 | 4635 | 79 |
1589941 | 1589941 | 2021-08-06 | Harrison | Indiana | 18061 | 4635 | 79 |
1587102 | 1587102 | 2021-08-05 | Iberville | Louisiana | 22047 | 4635 | 104 |
1551639 | 1551639 | 2021-07-25 | Winona | Minnesota | 27169 | 4635 | 52 |
1548392 | 1548392 | 2021-07-24 | Winona | Minnesota | 27169 | 4635 | 52 |
1545145 | 1545145 | 2021-07-23 | Winona | Minnesota | 27169 | 4635 | 52 |
1532204 | 1532204 | 2021-07-19 | Marshall | Mississippi | 28093 | 4635 | 106 |
1427921 | 1427921 | 2021-06-17 | Hopkins | Kentucky | 21107 | 4635 | 147 |
1373959 | 1373959 | 2021-05-31 | Bedford | Pennsylvania | 42009 | 4635 | 138 |
1361697 | 1361697 | 2021-05-27 | James City | Virginia | 51095 | 4635 | 72 |
1316209 | 1316209 | 2021-05-13 | Culpeper | Virginia | 51047 | 4635 | 63 |
1296740 | 1296740 | 2021-05-07 | Fauquier | Virginia | 51061 | 4635 | 65 |
1281005 | 1281005 | 2021-05-03 | Nevada | California | 6057 | 4635 | 75 |
1283527 | 1283527 | 2021-05-03 | Howard | Texas | 48227 | 4635 | 101 |
1243574 | 1243574 | 2021-04-21 | Scotts Bluff | Nebraska | 31157 | 4635 | 95 |
1221522 | 1221522 | 2021-04-14 | Chesterfield | South Carolina | 45025 | 4635 | 101 |
1209987 | 1209987 | 2021-04-11 | Henry | Illinois | 17073 | 4635 | 90 |
1206738 | 1206738 | 2021-04-10 | Henry | Illinois | 17073 | 4635 | 90 |
1165995 | 1165995 | 2021-03-28 | Mercer | Ohio | 39107 | 4635 | 84 |
1137743 | 1137743 | 2021-03-19 | Skagit | Washington | 53057 | 4635 | 63 |
1110277 | 1110277 | 2021-03-11 | Scott | Missouri | 29201 | 4635 | 79 |
1108606 | 1108606 | 2021-03-10 | Dunn | Wisconsin | 55033 | 4635 | 29 |
1101252 | 1101252 | 2021-03-08 | Mifflin | Pennsylvania | 42087 | 4635 | 170 |
1059301 | 1059301 | 2021-02-23 | Fayette | Tennessee | 47047 | 4635 | 71 |
1052476 | 1052476 | 2021-02-21 | Stephens | Oklahoma | 40137 | 4635 | 65 |
1044293 | 1044293 | 2021-02-19 | Tift | Georgia | 13277 | 4635 | 118 |
1011577 | 1011577 | 2021-02-09 | Eagle | Colorado | 8037 | 4635 | 20 |
986223 | 986223 | 2021-02-01 | Sioux | Iowa | 19167 | 4635 | 62 |
963040 | 963040 | 2021-01-25 | Catoosa | Georgia | 13047 | 4635 | 48 |
943912 | 943912 | 2021-01-19 | Noble | Indiana | 18113 | 4635 | 60 |
937474 | 937474 | 2021-01-17 | Cerro Gordo | Iowa | 19033 | 4635 | 68 |
922671 | 922671 | 2021-01-12 | Deschutes | Oregon | 41017 | 4635 | 31 |
911068 | 911068 | 2021-01-09 | Monroe | Florida | 12087 | 4635 | 36 |
890527 | 890527 | 2021-01-02 | Cumberland | Tennessee | 47035 | 4635 | 51 |
833419 | 833419 | 2020-12-16 | Boone | Illinois | 17007 | 4635 | 56 |
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);