ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where cases = 3291 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 10
- Tennessee 9
- Wisconsin 9
- Mississippi 7
- Texas 7
- Florida 6
- Illinois 6
- Indiana 6
- Louisiana 5
- Missouri 5
- Oregon 5
- Arkansas 4
- Massachusetts 4
- North Carolina 4
- Pennsylvania 4
- Wyoming 4
- Colorado 3
- Kansas 3
- Kentucky 3
- Minnesota 3
- Ohio 3
- Puerto Rico 3
- South Carolina 3
- Alabama 2
- California 2
- Idaho 2
- Maryland 2
- Montana 2
- Nevada 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474093 | 2474093 | 2022-05-05 | Gooding | Idaho | 16047 | 3291 | 54 |
2470836 | 2470836 | 2022-05-04 | Gooding | Idaho | 16047 | 3291 | 54 |
2401789 | 2401789 | 2022-04-12 | Bayfield | Wisconsin | 55007 | 3291 | 40 |
2382607 | 2382607 | 2022-04-07 | Crowley | Colorado | 8025 | 3291 | 28 |
2280496 | 2280496 | 2022-03-06 | Curry | Oregon | 41015 | 3291 | 44 |
2277243 | 2277243 | 2022-03-05 | Curry | Oregon | 41015 | 3291 | 44 |
2273990 | 2273990 | 2022-03-04 | Curry | Oregon | 41015 | 3291 | 44 |
2270065 | 2270065 | 2022-03-03 | Mississippi | Missouri | 29133 | 3291 | 56 |
2260649 | 2260649 | 2022-02-28 | Yates | New York | 36123 | 3291 | 39 |
2245895 | 2245895 | 2022-02-24 | Marion | Arkansas | 5089 | 3291 | 83 |
2221724 | 2221724 | 2022-02-16 | Swain | North Carolina | 37173 | 3291 | 34 |
2178465 | 2178465 | 2022-02-03 | Butler | Kentucky | 21031 | 3291 | 49 |
2176455 | 2176455 | 2022-02-02 | Tillamook | Oregon | 41057 | 3291 | 54 |
2174153 | 2174153 | 2022-02-01 | Rusk | Wisconsin | 55107 | 3291 | 45 |
2160044 | 2160044 | 2022-01-28 | Monroe | Ohio | 39111 | 3291 | 69 |
2131915 | 2131915 | 2022-01-20 | Crenshaw | Alabama | 1041 | 3291 | 80 |
2126868 | 2126868 | 2022-01-18 | Smith | Mississippi | 28129 | 3291 | 57 |
2121660 | 2121660 | 2022-01-16 | Llano | Texas | 48299 | 3291 | 87 |
2109098 | 2109098 | 2022-01-12 | Washburn | Wisconsin | 55129 | 3291 | 37 |
2065725 | 2065725 | 2021-12-30 | Meigs | Ohio | 39105 | 3291 | 67 |
2066580 | 2066580 | 2021-12-30 | Fluvanna | Virginia | 51065 | 3291 | 32 |
2053842 | 2053842 | 2021-12-26 | Carbon | Wyoming | 56007 | 3291 | 46 |
2050592 | 2050592 | 2021-12-25 | Carbon | Wyoming | 56007 | 3291 | 46 |
2047342 | 2047342 | 2021-12-24 | Carbon | Wyoming | 56007 | 3291 | 46 |
2044092 | 2044092 | 2021-12-23 | Carbon | Wyoming | 56007 | 3291 | 46 |
2018273 | 2018273 | 2021-12-16 | Phillips | Arkansas | 5107 | 3291 | 79 |
2008647 | 2008647 | 2021-12-13 | Otero | Colorado | 8089 | 3291 | 112 |
2005880 | 2005880 | 2021-12-12 | Rush | Indiana | 18139 | 3291 | 33 |
2002629 | 2002629 | 2021-12-11 | Rush | Indiana | 18139 | 3291 | 33 |
2003045 | 2003045 | 2021-12-11 | Franklin | Maine | 23007 | 3291 | 35 |
1999379 | 1999379 | 2021-12-10 | Rush | Indiana | 18139 | 3291 | 33 |
1997970 | 1997970 | 2021-12-09 | Unicoi | Tennessee | 47171 | 3291 | 69 |
1994719 | 1994719 | 2021-12-08 | Unicoi | Tennessee | 47171 | 3291 | 69 |
1970045 | 1970045 | 2021-12-01 | Union | Illinois | 17181 | 3291 | 54 |
1964459 | 1964459 | 2021-11-29 | Vernon | Missouri | 29217 | 3291 | 82 |
1933263 | 1933263 | 2021-11-19 | Orleans | Vermont | 50019 | 3291 | 22 |
1903747 | 1903747 | 2021-11-10 | Burleson | Texas | 48051 | 3291 | 60 |
1900239 | 1900239 | 2021-11-09 | Rio Grande | Puerto Rico | 72119 | 3291 | |
1900497 | 1900497 | 2021-11-09 | Burleson | Texas | 48051 | 3291 | 60 |
1894345 | 1894345 | 2021-11-07 | Louisa | Virginia | 51109 | 3291 | 49 |
1891095 | 1891095 | 2021-11-06 | Louisa | Virginia | 51109 | 3291 | 49 |
1887761 | 1887761 | 2021-11-05 | Franklin | Vermont | 50011 | 3291 | 51 |
1887845 | 1887845 | 2021-11-05 | Louisa | Virginia | 51109 | 3291 | 49 |
1861318 | 1861318 | 2021-10-28 | Beadle | South Dakota | 46005 | 3291 | 47 |
1857144 | 1857144 | 2021-10-27 | Henry | Missouri | 29083 | 3291 | 50 |
1813155 | 1813155 | 2021-10-13 | Salem city | Virginia | 51775 | 3291 | 57 |
1804851 | 1804851 | 2021-10-11 | Franklin | Massachusetts | 25011 | 3291 | 121 |
1801602 | 1801602 | 2021-10-10 | Franklin | Massachusetts | 25011 | 3291 | 121 |
1801787 | 1801787 | 2021-10-10 | Attala | Mississippi | 28007 | 3291 | 89 |
1798353 | 1798353 | 2021-10-09 | Franklin | Massachusetts | 25011 | 3291 | 121 |
1798538 | 1798538 | 2021-10-09 | Attala | Mississippi | 28007 | 3291 | 89 |
1795104 | 1795104 | 2021-10-08 | Franklin | Massachusetts | 25011 | 3291 | 121 |
1795289 | 1795289 | 2021-10-08 | Attala | Mississippi | 28007 | 3291 | 89 |
1720143 | 1720143 | 2021-09-15 | Allen | Kentucky | 21003 | 3291 | 58 |
1713180 | 1713180 | 2021-09-13 | Union | Georgia | 13291 | 3291 | 94 |
1705261 | 1705261 | 2021-09-10 | Dorado | Puerto Rico | 72051 | 3291 | |
1700992 | 1700992 | 2021-09-09 | Cass | Minnesota | 27021 | 3291 | 34 |
1692937 | 1692937 | 2021-09-06 | Pulaski | Virginia | 51155 | 3291 | 72 |
1679475 | 1679475 | 2021-09-02 | Haywood | Tennessee | 47075 | 3291 | 66 |
1671626 | 1671626 | 2021-08-31 | Dorchester | Maryland | 24019 | 3291 | 67 |
1628903 | 1628903 | 2021-08-18 | Daviess | Indiana | 18027 | 3291 | 103 |
1630664 | 1630664 | 2021-08-18 | Davison | South Dakota | 46035 | 3291 | 69 |
1617957 | 1617957 | 2021-08-14 | Kleberg | Texas | 48273 | 3291 | 97 |
1610466 | 1610466 | 2021-08-12 | Douglas | Nevada | 32005 | 3291 | 38 |
1589106 | 1589106 | 2021-08-05 | Wayne | West Virginia | 54099 | 3291 | 46 |
1584185 | 1584185 | 2021-08-04 | Simpson | Mississippi | 28127 | 3291 | 91 |
1574492 | 1574492 | 2021-08-01 | Dunklin | Missouri | 29069 | 3291 | 50 |
1560150 | 1560150 | 2021-07-28 | Unknown | Arkansas | 3291 | 0 | |
1552804 | 1552804 | 2021-07-25 | Lauderdale | Tennessee | 47097 | 3291 | 50 |
1553415 | 1553415 | 2021-07-25 | Lincoln | Wisconsin | 55069 | 3291 | 97 |
1549557 | 1549557 | 2021-07-24 | Lauderdale | Tennessee | 47097 | 3291 | 50 |
1550168 | 1550168 | 2021-07-24 | Lincoln | Wisconsin | 55069 | 3291 | 97 |
1546310 | 1546310 | 2021-07-23 | Lauderdale | Tennessee | 47097 | 3291 | 50 |
1546921 | 1546921 | 2021-07-23 | Lincoln | Wisconsin | 55069 | 3291 | 97 |
1537389 | 1537389 | 2021-07-21 | Lincoln | Arkansas | 5079 | 3291 | 49 |
1537179 | 1537179 | 2021-07-20 | Lincoln | Wisconsin | 55069 | 3291 | 97 |
1532158 | 1532158 | 2021-07-19 | Adams | Mississippi | 28001 | 3291 | 87 |
1532397 | 1532397 | 2021-07-19 | Ravalli | Montana | 30081 | 3291 | 51 |
1533931 | 1533931 | 2021-07-19 | Lincoln | Wisconsin | 55069 | 3291 | 96 |
1515686 | 1515686 | 2021-07-14 | Vernon | Louisiana | 22115 | 3291 | 107 |
1422146 | 1422146 | 2021-06-15 | Lyon | Nevada | 32019 | 3291 | 65 |
1338276 | 1338276 | 2021-05-20 | Jefferson | Pennsylvania | 42065 | 3291 | 98 |
1335586 | 1335586 | 2021-05-19 | Upshur | Texas | 48459 | 3291 | 75 |
1324377 | 1324377 | 2021-05-16 | Pine | Minnesota | 27115 | 3291 | 22 |
1321984 | 1321984 | 2021-05-15 | Douglas | Oregon | 41019 | 3291 | 71 |
1298571 | 1298571 | 2021-05-08 | Laclede | Missouri | 29105 | 3291 | 68 |
1269768 | 1269768 | 2021-04-29 | Montgomery | North Carolina | 37123 | 3291 | 93 |
1246027 | 1246027 | 2021-04-22 | McPherson | Kansas | 20113 | 3291 | 88 |
1242780 | 1242780 | 2021-04-21 | McPherson | Kansas | 20113 | 3291 | 88 |
1239533 | 1239533 | 2021-04-20 | McPherson | Kansas | 20113 | 3291 | 88 |
1227990 | 1227990 | 2021-04-16 | Trujillo Alto | Puerto Rico | 72139 | 3291 | |
1218151 | 1218151 | 2021-04-13 | McKean | Pennsylvania | 42083 | 3291 | 66 |
1179188 | 1179188 | 2021-04-01 | Snyder | Pennsylvania | 42109 | 3291 | 82 |
1179299 | 1179299 | 2021-04-01 | Clarendon | South Carolina | 45027 | 3291 | 105 |
1125688 | 1125688 | 2021-03-16 | Ripley | Indiana | 18137 | 3291 | 64 |
1114377 | 1114377 | 2021-03-12 | Marion | South Carolina | 45067 | 3291 | 101 |
1111113 | 1111113 | 2021-03-11 | Colleton | South Carolina | 45029 | 3291 | 117 |
1108456 | 1108456 | 2021-03-10 | Petersburg city | Virginia | 51730 | 3291 | 71 |
1103419 | 1103419 | 2021-03-09 | Worcester | Maryland | 24047 | 3291 | 92 |
1100996 | 1100996 | 2021-03-08 | Stutsman | North Dakota | 38093 | 3291 | 79 |
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);