ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 3102 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 12
- Indiana 9
- Georgia 6
- Kentucky 6
- Illinois 5
- Minnesota 5
- Missouri 5
- New York 5
- Pennsylvania 5
- South Dakota 5
- North Carolina 4
- Tennessee 4
- Virginia 4
- Puerto Rico 3
- Texas 3
- Washington 3
- Arkansas 2
- Florida 2
- New Mexico 2
- Ohio 2
- West Virginia 2
- Wisconsin 2
- Alabama 1
- Idaho 1
- Maine 1
- Michigan 1
- Montana 1
- New Jersey 1
- North Dakota 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484627 | 2484627 | 2022-05-08 | Chippewa | Minnesota | 27023 | 3102 | 48 |
2481369 | 2481369 | 2022-05-07 | Chippewa | Minnesota | 27023 | 3102 | 48 |
2478111 | 2478111 | 2022-05-06 | Chippewa | Minnesota | 27023 | 3102 | 48 |
2469360 | 2469360 | 2022-05-03 | Comerio | Puerto Rico | 72045 | 3102 | |
2286607 | 2286607 | 2022-03-08 | Torrance | New Mexico | 35057 | 3102 | 51 |
2261888 | 2261888 | 2022-02-28 | Roane | West Virginia | 54087 | 3102 | 35 |
2256202 | 2256202 | 2022-02-27 | Blackford | Indiana | 18009 | 3102 | 68 |
2252951 | 2252951 | 2022-02-26 | Blackford | Indiana | 18009 | 3102 | 68 |
2249700 | 2249700 | 2022-02-25 | Blackford | Indiana | 18009 | 3102 | 68 |
2216463 | 2216463 | 2022-02-14 | Converse | Wyoming | 56009 | 3102 | 50 |
2205851 | 2205851 | 2022-02-11 | Loiza | Puerto Rico | 72087 | 3102 | |
2191471 | 2191471 | 2022-02-07 | Breathitt | Kentucky | 21025 | 3102 | 50 |
2159830 | 2159830 | 2022-01-28 | Yates | New York | 36123 | 3102 | 37 |
2157716 | 2157716 | 2022-01-27 | Southampton | Virginia | 51175 | 3102 | 75 |
2134371 | 2134371 | 2022-01-20 | Clay | South Dakota | 46027 | 3102 | 18 |
2126946 | 2126946 | 2022-01-18 | Livingston | Missouri | 29117 | 3102 | 83 |
2098169 | 2098169 | 2022-01-09 | Richland | North Dakota | 38077 | 3102 | 21 |
2014215 | 2014215 | 2021-12-14 | Sequatchie | Tennessee | 47153 | 3102 | 41 |
1995978 | 1995978 | 2021-12-09 | Edgar | Illinois | 17045 | 3102 | 71 |
1963866 | 1963866 | 2021-11-29 | Breckinridge | Kentucky | 21027 | 3102 | 40 |
1938268 | 1938268 | 2021-11-21 | Chickasaw | Mississippi | 28017 | 3102 | 67 |
1935018 | 1935018 | 2021-11-20 | Chickasaw | Mississippi | 28017 | 3102 | 67 |
1931768 | 1931768 | 2021-11-19 | Chickasaw | Mississippi | 28017 | 3102 | 67 |
1886454 | 1886454 | 2021-11-05 | Vernon | Missouri | 29217 | 3102 | 65 |
1856297 | 1856297 | 2021-10-27 | Union | Illinois | 17181 | 3102 | 52 |
1855270 | 1855270 | 2021-10-26 | Franklin | Vermont | 50011 | 3102 | 49 |
1829642 | 1829642 | 2021-10-19 | Hale | Alabama | 1065 | 3102 | 88 |
1814145 | 1814145 | 2021-10-14 | Starke | Indiana | 18149 | 3102 | 70 |
1758748 | 1758748 | 2021-09-27 | Crawford | Illinois | 17033 | 3102 | 46 |
1755965 | 1755965 | 2021-09-26 | Meade | Kentucky | 21163 | 3102 | 30 |
1752717 | 1752717 | 2021-09-25 | Meade | Kentucky | 21163 | 3102 | 30 |
1749468 | 1749468 | 2021-09-24 | Meade | Kentucky | 21163 | 3102 | 30 |
1742427 | 1742427 | 2021-09-22 | Washington | Georgia | 13303 | 3102 | 103 |
1744718 | 1744718 | 2021-09-22 | Scurry | Texas | 48415 | 3102 | 73 |
1740011 | 1740011 | 2021-09-21 | Meeker | Minnesota | 27093 | 3102 | 49 |
1738405 | 1738405 | 2021-09-20 | Orange | Virginia | 51137 | 3102 | 45 |
1732865 | 1732865 | 2021-09-19 | Fountain | Indiana | 18045 | 3102 | 55 |
1733584 | 1733584 | 2021-09-19 | Jasper | Mississippi | 28061 | 3102 | 62 |
1729615 | 1729615 | 2021-09-18 | Fountain | Indiana | 18045 | 3102 | 55 |
1730334 | 1730334 | 2021-09-18 | Jasper | Mississippi | 28061 | 3102 | 62 |
1726365 | 1726365 | 2021-09-17 | Fountain | Indiana | 18045 | 3102 | 55 |
1727084 | 1727084 | 2021-09-17 | Jasper | Mississippi | 28061 | 3102 | 62 |
1713120 | 1713120 | 2021-09-13 | Jones | Georgia | 13169 | 3102 | 70 |
1688948 | 1688948 | 2021-09-05 | Elk | Pennsylvania | 42047 | 3102 | 43 |
1670576 | 1670576 | 2021-08-31 | Ouachita | Arkansas | 5103 | 3102 | 68 |
1657120 | 1657120 | 2021-08-26 | Caroline | Virginia | 51033 | 3102 | 43 |
1652425 | 1652425 | 2021-08-25 | Adair | Missouri | 29001 | 3102 | 27 |
1649177 | 1649177 | 2021-08-24 | Adair | Missouri | 29001 | 3102 | 27 |
1585414 | 1585414 | 2021-08-04 | Frio | Texas | 48163 | 3102 | 54 |
1576791 | 1576791 | 2021-08-02 | Jefferson | Idaho | 16051 | 3102 | 33 |
1467227 | 1467227 | 2021-06-29 | Adams | Mississippi | 28001 | 3102 | 86 |
1351496 | 1351496 | 2021-05-24 | Yankton | South Dakota | 46135 | 3102 | 34 |
1348250 | 1348250 | 2021-05-23 | Yankton | South Dakota | 46135 | 3102 | 34 |
1345002 | 1345002 | 2021-05-22 | Yankton | South Dakota | 46135 | 3102 | 34 |
1341754 | 1341754 | 2021-05-21 | Yankton | South Dakota | 46135 | 3102 | 34 |
1337634 | 1337634 | 2021-05-20 | Ravalli | Montana | 30081 | 3102 | 44 |
1327512 | 1327512 | 2021-05-17 | Houghton | Michigan | 26061 | 3102 | 40 |
1288778 | 1288778 | 2021-05-05 | Yazoo | Mississippi | 28163 | 3102 | 69 |
1285532 | 1285532 | 2021-05-04 | Yazoo | Mississippi | 28163 | 3102 | 69 |
1282750 | 1282750 | 2021-05-03 | Macon | North Carolina | 37113 | 3102 | 38 |
1268148 | 1268148 | 2021-04-29 | Hardee | Florida | 12049 | 3102 | 42 |
1258578 | 1258578 | 2021-04-26 | Stephens | Georgia | 13257 | 3102 | 81 |
1255331 | 1255331 | 2021-04-25 | Stephens | Georgia | 13257 | 3102 | 81 |
1255608 | 1255608 | 2021-04-25 | White | Indiana | 18181 | 3102 | 55 |
1214481 | 1214481 | 2021-04-12 | Otsego | New York | 36077 | 3102 | 46 |
1196216 | 1196216 | 2021-04-06 | Fayette | West Virginia | 54019 | 3102 | 77 |
1169042 | 1169042 | 2021-03-29 | Bladen | North Carolina | 37017 | 3102 | 41 |
1158720 | 1158720 | 2021-03-26 | Carlton | Minnesota | 27017 | 3102 | 51 |
1134823 | 1134823 | 2021-03-19 | Poinsett | Arkansas | 5111 | 3102 | 76 |
1112967 | 1112967 | 2021-03-12 | Floyd | Kentucky | 21071 | 3102 | 45 |
1111259 | 1111259 | 2021-03-11 | Lauderdale | Tennessee | 47097 | 3102 | 44 |
1108013 | 1108013 | 2021-03-10 | Lauderdale | Tennessee | 47097 | 3102 | 44 |
1079409 | 1079409 | 2021-03-01 | Lincoln | Wisconsin | 55069 | 3102 | 75 |
1076164 | 1076164 | 2021-02-28 | Lincoln | Wisconsin | 55069 | 3102 | 75 |
1061854 | 1061854 | 2021-02-24 | Cortland | New York | 36023 | 3102 | 60 |
1055378 | 1055378 | 2021-02-22 | Montgomery | New York | 36057 | 3102 | 102 |
995853 | 995853 | 2021-02-04 | Putnam | Indiana | 18133 | 3102 | 57 |
980043 | 980043 | 2021-01-30 | Kennebec | Maine | 23011 | 3102 | 43 |
967857 | 967857 | 2021-01-26 | Scotland | North Carolina | 37165 | 3102 | 63 |
955858 | 955858 | 2021-01-22 | Franklin | Virginia | 51067 | 3102 | 31 |
955968 | 955968 | 2021-01-22 | Lewis | Washington | 53041 | 3102 | 36 |
935665 | 935665 | 2021-01-16 | Linn | Oregon | 41043 | 3102 | 46 |
903287 | 903287 | 2021-01-06 | Union | Pennsylvania | 42119 | 3102 | 47 |
893373 | 893373 | 2021-01-03 | Washington | Ohio | 39167 | 3102 | 39 |
888477 | 888477 | 2021-01-02 | Murray | Georgia | 13213 | 3102 | 42 |
887029 | 887029 | 2021-01-01 | Huntingdon | Pennsylvania | 42061 | 3102 | 87 |
876474 | 876474 | 2020-12-29 | Pontotoc | Mississippi | 28115 | 3102 | 40 |
859433 | 859433 | 2020-12-24 | Macoupin | Illinois | 17117 | 3102 | 63 |
853754 | 853754 | 2020-12-22 | Oktibbeha | Mississippi | 28105 | 3102 | 69 |
851173 | 851173 | 2020-12-21 | Sandusky | Ohio | 39143 | 3102 | 47 |
848890 | 848890 | 2020-12-20 | Whatcom | Washington | 53073 | 3102 | 52 |
845645 | 845645 | 2020-12-19 | Whatcom | Washington | 53073 | 3102 | 52 |
834370 | 834370 | 2020-12-16 | Lincoln | Missouri | 29113 | 3102 | 17 |
822264 | 822264 | 2020-12-12 | Georgetown | South Carolina | 45043 | 3102 | 70 |
802717 | 802717 | 2020-12-06 | Guaynabo | Puerto Rico | 72061 | 3102 | |
747452 | 747452 | 2020-11-19 | Beaver | Pennsylvania | 42007 | 3102 | 145 |
690728 | 690728 | 2020-11-02 | Tazewell | Illinois | 17179 | 3102 | 60 |
667689 | 667689 | 2020-10-26 | Jackson | Florida | 12063 | 3102 | 84 |
647154 | 647154 | 2020-10-19 | Blount | Tennessee | 47009 | 3102 | 31 |
582509 | 582509 | 2020-09-29 | Johnson | Texas | 48251 | 3102 | 50 |
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);