ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where cases = 3108 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 9
- Georgia 7
- Kentucky 7
- Oklahoma 7
- Alabama 6
- Louisiana 6
- Nevada 6
- Kansas 5
- Virginia 5
- Arkansas 4
- Illinois 4
- Indiana 4
- North Carolina 4
- Tennessee 4
- Wisconsin 4
- Colorado 3
- Florida 3
- Iowa 3
- Michigan 3
- Missouri 3
- Ohio 3
- Oregon 3
- Pennsylvania 3
- Texas 3
- West Virginia 3
- Wyoming 3
- Idaho 2
- Mississippi 2
- Nebraska 2
- Puerto Rico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456369 | 2456369 | 2022-04-29 | Orocovis | Puerto Rico | 72107 | 3108 | |
2271643 | 2271643 | 2022-03-03 | Roane | West Virginia | 54087 | 3108 | 36 |
2211322 | 2211322 | 2022-02-13 | Cottonwood | Minnesota | 27033 | 3108 | 39 |
2208069 | 2208069 | 2022-02-12 | Cottonwood | Minnesota | 27033 | 3108 | 39 |
2209399 | 2209399 | 2022-02-12 | Comanche | Texas | 48093 | 3108 | 75 |
2204816 | 2204816 | 2022-02-11 | Cottonwood | Minnesota | 27033 | 3108 | 39 |
2177719 | 2177719 | 2022-02-03 | Gunnison | Colorado | 8051 | 3108 | 13 |
2180653 | 2180653 | 2022-02-03 | Price | Wisconsin | 55099 | 3108 | 28 |
2170609 | 2170609 | 2022-01-31 | Lamoille | Vermont | 50015 | 3108 | 12 |
2143050 | 2143050 | 2022-01-23 | Renville | Minnesota | 27129 | 3108 | 52 |
2139795 | 2139795 | 2022-01-22 | Renville | Minnesota | 27129 | 3108 | 52 |
2136539 | 2136539 | 2022-01-21 | Renville | Minnesota | 27129 | 3108 | 52 |
2127369 | 2127369 | 2022-01-18 | Polk | North Carolina | 37149 | 3108 | 49 |
2097239 | 2097239 | 2022-01-09 | Union | Kentucky | 21225 | 3108 | 47 |
2093987 | 2093987 | 2022-01-08 | Union | Kentucky | 21225 | 3108 | 47 |
2090735 | 2090735 | 2022-01-07 | Union | Kentucky | 21225 | 3108 | 47 |
2087272 | 2087272 | 2022-01-06 | Bourbon | Kansas | 20011 | 3108 | 44 |
2087394 | 2087394 | 2022-01-06 | Casey | Kentucky | 21045 | 3108 | 65 |
2084020 | 2084020 | 2022-01-05 | Bourbon | Kansas | 20011 | 3108 | 44 |
2082635 | 2082635 | 2022-01-04 | Lee | Texas | 48287 | 3108 | 54 |
2062271 | 2062271 | 2021-12-29 | Avery | North Carolina | 37011 | 3108 | 39 |
2014998 | 2014998 | 2021-12-15 | Hempstead | Arkansas | 5057 | 3108 | 44 |
2006307 | 2006307 | 2021-12-12 | Waldo | Maine | 23027 | 3108 | 36 |
1991883 | 1991883 | 2021-12-07 | Radford city | Virginia | 51750 | 3108 | 36 |
1986237 | 1986237 | 2021-12-06 | Hancock | Illinois | 17067 | 3108 | 45 |
1961372 | 1961372 | 2021-11-28 | Humboldt | Nevada | 32013 | 3108 | 39 |
1958121 | 1958121 | 2021-11-27 | Humboldt | Nevada | 32013 | 3108 | 39 |
1954870 | 1954870 | 2021-11-26 | Humboldt | Nevada | 32013 | 3108 | 39 |
1951619 | 1951619 | 2021-11-25 | Humboldt | Nevada | 32013 | 3108 | 39 |
1948368 | 1948368 | 2021-11-24 | Humboldt | Nevada | 32013 | 3108 | 39 |
1914658 | 1914658 | 2021-11-14 | Blaine | Idaho | 16013 | 3108 | 27 |
1911408 | 1911408 | 2021-11-13 | Blaine | Idaho | 16013 | 3108 | 27 |
1895146 | 1895146 | 2021-11-08 | Worth | Georgia | 13321 | 3108 | 91 |
1891896 | 1891896 | 2021-11-07 | Worth | Georgia | 13321 | 3108 | 91 |
1888646 | 1888646 | 2021-11-06 | Worth | Georgia | 13321 | 3108 | 91 |
1885396 | 1885396 | 2021-11-05 | Worth | Georgia | 13321 | 3108 | 91 |
1787803 | 1787803 | 2021-10-06 | Crisp | Georgia | 13081 | 3108 | 106 |
1768040 | 1768040 | 2021-09-30 | Phillips | Arkansas | 5107 | 3108 | 69 |
1753204 | 1753204 | 2021-09-25 | New Madrid | Missouri | 29143 | 3108 | 52 |
1742393 | 1742393 | 2021-09-22 | Putnam | Georgia | 13237 | 3108 | 72 |
1745070 | 1745070 | 2021-09-22 | Kewaunee | Wisconsin | 55061 | 3108 | 40 |
1736622 | 1736622 | 2021-09-20 | Franklin | Massachusetts | 25011 | 3108 | 115 |
1714877 | 1714877 | 2021-09-13 | Columbia | Oregon | 41009 | 3108 | 37 |
1715791 | 1715791 | 2021-09-13 | Upshur | West Virginia | 54097 | 3108 | 44 |
1711497 | 1711497 | 2021-09-12 | Holmes | Ohio | 39075 | 3108 | 103 |
1694576 | 1694576 | 2021-09-07 | Attala | Mississippi | 28007 | 3108 | 82 |
1647543 | 1647543 | 2021-08-23 | Greenbrier | West Virginia | 54025 | 3108 | 66 |
1611939 | 1611939 | 2021-08-12 | Park | Wyoming | 56029 | 3108 | 35 |
1596498 | 1596498 | 2021-08-08 | Wells | Indiana | 18179 | 3108 | 83 |
1593249 | 1593249 | 2021-08-07 | Wells | Indiana | 18179 | 3108 | 83 |
1590000 | 1590000 | 2021-08-06 | Wells | Indiana | 18179 | 3108 | 83 |
1587117 | 1587117 | 2021-08-05 | Pointe Coupee | Louisiana | 22077 | 3108 | 75 |
1561736 | 1561736 | 2021-07-28 | Douglas | Nevada | 32005 | 3108 | 37 |
1556982 | 1556982 | 2021-07-27 | Delta | Colorado | 8029 | 3108 | 70 |
1553735 | 1553735 | 2021-07-26 | Delta | Colorado | 8029 | 3108 | 70 |
1535173 | 1535173 | 2021-07-20 | West Baton Rouge | Louisiana | 22121 | 3108 | 63 |
1530925 | 1530925 | 2021-07-19 | Unknown | Arkansas | 3108 | 0 | |
1480327 | 1480327 | 2021-07-03 | Dunklin | Missouri | 29069 | 3108 | 50 |
1477080 | 1477080 | 2021-07-02 | Dunklin | Missouri | 29069 | 3108 | 50 |
1397697 | 1397697 | 2021-06-08 | Lawrence | Alabama | 1079 | 3108 | 100 |
1377463 | 1377463 | 2021-06-01 | Yankton | South Dakota | 46135 | 3108 | 34 |
1374217 | 1374217 | 2021-05-31 | Yankton | South Dakota | 46135 | 3108 | 34 |
1334006 | 1334006 | 2021-05-19 | Houghton | Michigan | 26061 | 3108 | 40 |
1331140 | 1331140 | 2021-05-18 | Ravalli | Montana | 30081 | 3108 | 44 |
1327419 | 1327419 | 2021-05-17 | Vernon | Louisiana | 22115 | 3108 | 102 |
1317508 | 1317508 | 2021-05-14 | Bell | Kentucky | 21013 | 3108 | 54 |
1318730 | 1318730 | 2021-05-14 | Benton | Oregon | 41003 | 3108 | 20 |
1309495 | 1309495 | 2021-05-11 | Hopkins | Texas | 48223 | 3108 | 109 |
1303570 | 1303570 | 2021-05-10 | Pike | Alabama | 1109 | 3108 | 77 |
1300323 | 1300323 | 2021-05-09 | Pike | Alabama | 1109 | 3108 | 77 |
1297076 | 1297076 | 2021-05-08 | Pike | Alabama | 1109 | 3108 | 77 |
1286218 | 1286218 | 2021-05-04 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1282972 | 1282972 | 2021-05-03 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1279725 | 1279725 | 2021-05-02 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1276478 | 1276478 | 2021-05-01 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1273231 | 1273231 | 2021-04-30 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1269984 | 1269984 | 2021-04-29 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1270858 | 1270858 | 2021-04-29 | Wise | Virginia | 51195 | 3108 | 96 |
1265072 | 1265072 | 2021-04-28 | Stephens | Georgia | 13257 | 3108 | 81 |
1266737 | 1266737 | 2021-04-28 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1263408 | 1263408 | 2021-04-27 | Jackson | Ohio | 39079 | 3108 | 51 |
1244409 | 1244409 | 2021-04-21 | Marion | Tennessee | 47115 | 3108 | 46 |
1222454 | 1222454 | 2021-04-15 | Baxter | Arkansas | 5005 | 3108 | 102 |
1217322 | 1217322 | 2021-04-13 | Scott | Mississippi | 28123 | 3108 | 72 |
1196982 | 1196982 | 2021-04-07 | Fayette | Illinois | 17051 | 3108 | 57 |
1193734 | 1193734 | 2021-04-06 | Fayette | Illinois | 17051 | 3108 | 57 |
1164553 | 1164553 | 2021-03-28 | Perry | Illinois | 17145 | 3108 | 68 |
1149956 | 1149956 | 2021-03-23 | Perry | Pennsylvania | 42099 | 3108 | 88 |
1146845 | 1146845 | 2021-03-22 | Marlboro | South Carolina | 45069 | 3108 | 51 |
1119349 | 1119349 | 2021-03-14 | Geary | Kansas | 20061 | 3108 | 25 |
1116102 | 1116102 | 2021-03-13 | Geary | Kansas | 20061 | 3108 | 25 |
1112856 | 1112856 | 2021-03-12 | Geary | Kansas | 20061 | 3108 | 25 |
1111112 | 1111112 | 2021-03-11 | Clarendon | South Carolina | 45027 | 3108 | 102 |
1103548 | 1103548 | 2021-03-09 | Isanti | Minnesota | 27059 | 3108 | 56 |
1104157 | 1104157 | 2021-03-09 | Montgomery | North Carolina | 37123 | 3108 | 88 |
1089146 | 1089146 | 2021-03-04 | Lincoln | Wisconsin | 55069 | 3108 | 75 |
1085901 | 1085901 | 2021-03-03 | Lincoln | Wisconsin | 55069 | 3108 | 75 |
1066259 | 1066259 | 2021-02-25 | Petersburg city | Virginia | 51730 | 3108 | 43 |
1044778 | 1044778 | 2021-02-19 | Boyle | Kentucky | 21021 | 3108 | 31 |
1045134 | 1045134 | 2021-02-19 | Lyon | Minnesota | 27083 | 3108 | 43 |
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);