ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where cases = 4068 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 13
- Louisiana 8
- New York 8
- Georgia 7
- Illinois 6
- Kentucky 6
- Puerto Rico 6
- Tennessee 6
- Virginia 6
- Arkansas 5
- Alabama 4
- Minnesota 4
- Mississippi 4
- Texas 4
- Missouri 3
- New Hampshire 3
- North Carolina 3
- West Virginia 3
- Wisconsin 3
- Wyoming 3
- California 2
- Florida 2
- Michigan 2
- Alaska 1
- Arizona 1
- Colorado 1
- Connecticut 1
- Idaho 1
- Iowa 1
- Ohio 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496287 | 2496287 | 2022-05-11 | Washburn | Wisconsin | 55129 | 4068 | 46 |
2474156 | 2474156 | 2022-05-05 | Jo Daviess | Illinois | 17085 | 4068 | 39 |
2469343 | 2469343 | 2022-05-03 | Anasco | Puerto Rico | 72011 | 4068 | |
2453702 | 2453702 | 2022-04-28 | Giles | Virginia | 51071 | 4068 | 50 |
2360362 | 2360362 | 2022-03-31 | Vermillion | Indiana | 18165 | 4068 | 74 |
2357108 | 2357108 | 2022-03-30 | Vermillion | Indiana | 18165 | 4068 | 74 |
2350603 | 2350603 | 2022-03-28 | Vermillion | Indiana | 18165 | 4068 | 74 |
2347350 | 2347350 | 2022-03-27 | Vermillion | Indiana | 18165 | 4068 | 74 |
2344097 | 2344097 | 2022-03-26 | Vermillion | Indiana | 18165 | 4068 | 74 |
2340844 | 2340844 | 2022-03-25 | Vermillion | Indiana | 18165 | 4068 | 74 |
2337591 | 2337591 | 2022-03-24 | Vermillion | Indiana | 18165 | 4068 | 74 |
2284883 | 2284883 | 2022-03-08 | Clay | Arkansas | 5021 | 4068 | 90 |
2258911 | 2258911 | 2022-02-28 | Polk | Arkansas | 5113 | 4068 | 134 |
2255896 | 2255896 | 2022-02-27 | Brantley | Georgia | 13025 | 4068 | 101 |
2252645 | 2252645 | 2022-02-26 | Brantley | Georgia | 13025 | 4068 | 101 |
2249394 | 2249394 | 2022-02-25 | Brantley | Georgia | 13025 | 4068 | 101 |
2247220 | 2247220 | 2022-02-24 | Smith | Mississippi | 28129 | 4068 | 66 |
2241650 | 2241650 | 2022-02-22 | Yauco | Puerto Rico | 72153 | 4068 | |
2237395 | 2237395 | 2022-02-21 | Wadena | Minnesota | 27159 | 4068 | 51 |
2238399 | 2238399 | 2022-02-21 | Yauco | Puerto Rico | 72153 | 4068 | |
2234144 | 2234144 | 2022-02-20 | Wadena | Minnesota | 27159 | 4068 | 51 |
2235148 | 2235148 | 2022-02-20 | Yauco | Puerto Rico | 72153 | 4068 | |
2230893 | 2230893 | 2022-02-19 | Wadena | Minnesota | 27159 | 4068 | 51 |
2227642 | 2227642 | 2022-02-18 | Wadena | Minnesota | 27159 | 4068 | 51 |
2221658 | 2221658 | 2022-02-16 | Chowan | North Carolina | 37041 | 4068 | 50 |
2195292 | 2195292 | 2022-02-08 | Pike | Missouri | 29163 | 4068 | 56 |
2141171 | 2141171 | 2022-01-22 | Lamb | Texas | 48279 | 4068 | 102 |
2105460 | 2105460 | 2022-01-11 | Scurry | Texas | 48415 | 4068 | 95 |
2099496 | 2099496 | 2022-01-10 | Clark | Arkansas | 5019 | 4068 | 66 |
2080439 | 2080439 | 2022-01-04 | Cassia | Idaho | 16031 | 4068 | 46 |
2060821 | 2060821 | 2021-12-29 | Haralson | Georgia | 13143 | 4068 | 131 |
2056455 | 2056455 | 2021-12-27 | Morgan | Tennessee | 47129 | 4068 | 57 |
2009516 | 2009516 | 2021-12-13 | Plaquemines | Louisiana | 22075 | 4068 | 40 |
2005793 | 2005793 | 2021-12-12 | Shelby | Illinois | 17173 | 4068 | 57 |
2002542 | 2002542 | 2021-12-11 | Shelby | Illinois | 17173 | 4068 | 57 |
1999292 | 1999292 | 2021-12-10 | Shelby | Illinois | 17173 | 4068 | 57 |
1986051 | 1986051 | 2021-12-06 | Franklin | Georgia | 13119 | 4068 | 84 |
1953274 | 1953274 | 2021-11-26 | Sevier | Arkansas | 5133 | 4068 | 60 |
1937913 | 1937913 | 2021-11-21 | Letcher | Kentucky | 21133 | 4068 | 73 |
1939785 | 1939785 | 2021-11-21 | Botetourt | Virginia | 51023 | 4068 | 54 |
1934663 | 1934663 | 2021-11-20 | Letcher | Kentucky | 21133 | 4068 | 73 |
1936535 | 1936535 | 2021-11-20 | Botetourt | Virginia | 51023 | 4068 | 54 |
1931412 | 1931412 | 2021-11-19 | Letcher | Kentucky | 21133 | 4068 | 73 |
1933285 | 1933285 | 2021-11-19 | Botetourt | Virginia | 51023 | 4068 | 54 |
1900080 | 1900080 | 2021-11-09 | Columbia | Oregon | 41009 | 4068 | 49 |
1808323 | 1808323 | 2021-10-12 | Leake | Mississippi | 28079 | 4068 | 87 |
1784839 | 1784839 | 2021-10-05 | Clay | Indiana | 18021 | 4068 | 60 |
1754760 | 1754760 | 2021-09-25 | Mineral | West Virginia | 54057 | 4068 | 101 |
1717747 | 1717747 | 2021-09-14 | Chenango | New York | 36017 | 4068 | 85 |
1717817 | 1717817 | 2021-09-14 | Cherokee | North Carolina | 37039 | 4068 | 54 |
1711993 | 1711993 | 2021-09-12 | Overton | Tennessee | 47133 | 4068 | 65 |
1708746 | 1708746 | 2021-09-11 | Overton | Tennessee | 47133 | 4068 | 65 |
1705499 | 1705499 | 2021-09-10 | Overton | Tennessee | 47133 | 4068 | 65 |
1677981 | 1677981 | 2021-09-02 | Logan | Kentucky | 21141 | 4068 | 77 |
1670289 | 1670289 | 2021-08-30 | Marshall | West Virginia | 54051 | 4068 | 85 |
1659761 | 1659761 | 2021-08-27 | Arecibo | Puerto Rico | 72013 | 4068 | |
1621689 | 1621689 | 2021-08-15 | Teton | Wyoming | 56039 | 4068 | 11 |
1618441 | 1618441 | 2021-08-14 | Teton | Wyoming | 56039 | 4068 | 11 |
1614802 | 1614802 | 2021-08-13 | Upshur | Texas | 48459 | 4068 | 78 |
1615193 | 1615193 | 2021-08-13 | Teton | Wyoming | 56039 | 4068 | 11 |
1603247 | 1603247 | 2021-08-10 | Greenup | Kentucky | 21089 | 4068 | 63 |
1604769 | 1604769 | 2021-08-10 | Henderson | Tennessee | 47077 | 4068 | 79 |
1586569 | 1586569 | 2021-08-05 | Christian | Illinois | 17021 | 4068 | 94 |
1511999 | 1511999 | 2021-07-13 | Huntington | Indiana | 18069 | 4068 | 83 |
1501805 | 1501805 | 2021-07-10 | Logan | Colorado | 8075 | 4068 | 69 |
1490114 | 1490114 | 2021-07-06 | Phelps | Missouri | 29161 | 4068 | 134 |
1450382 | 1450382 | 2021-06-24 | Whitley | Indiana | 18183 | 4068 | 44 |
1448196 | 1448196 | 2021-06-23 | Columbia | New York | 36021 | 4068 | 104 |
1444951 | 1444951 | 2021-06-22 | Columbia | New York | 36021 | 4068 | 104 |
1441706 | 1441706 | 2021-06-21 | Columbia | New York | 36021 | 4068 | 104 |
1438389 | 1438389 | 2021-06-20 | Grafton | New Hampshire | 33009 | 4068 | 26 |
1438461 | 1438461 | 2021-06-20 | Columbia | New York | 36021 | 4068 | 104 |
1435142 | 1435142 | 2021-06-19 | Grafton | New Hampshire | 33009 | 4068 | 26 |
1435214 | 1435214 | 2021-06-19 | Columbia | New York | 36021 | 4068 | 104 |
1430522 | 1430522 | 2021-06-18 | Camden | Georgia | 13039 | 4068 | 38 |
1431895 | 1431895 | 2021-06-18 | Grafton | New Hampshire | 33009 | 4068 | 26 |
1372857 | 1372857 | 2021-05-31 | St. Bernard | Louisiana | 22087 | 4068 | 52 |
1369612 | 1369612 | 2021-05-30 | St. Bernard | Louisiana | 22087 | 4068 | 52 |
1366366 | 1366366 | 2021-05-29 | St. Bernard | Louisiana | 22087 | 4068 | 52 |
1363120 | 1363120 | 2021-05-28 | St. Bernard | Louisiana | 22087 | 4068 | 52 |
1359873 | 1359873 | 2021-05-27 | St. Bernard | Louisiana | 22087 | 4068 | 52 |
1353490 | 1353490 | 2021-05-25 | Huron | Michigan | 26063 | 4068 | 77 |
1323363 | 1323363 | 2021-05-16 | Okeechobee | Florida | 12093 | 4068 | 89 |
1312467 | 1312467 | 2021-05-12 | Williamsburg | South Carolina | 45089 | 4068 | 99 |
1267419 | 1267419 | 2021-04-28 | Wharton | Texas | 48481 | 4068 | 114 |
1259572 | 1259572 | 2021-04-26 | Camden | Missouri | 29029 | 4068 | 87 |
1236636 | 1236636 | 2021-04-19 | Newaygo | Michigan | 26123 | 4068 | 57 |
1228856 | 1228856 | 2021-04-17 | Covington | Alabama | 1039 | 4068 | 115 |
1200284 | 1200284 | 2021-04-08 | Randolph | Illinois | 17157 | 4068 | 90 |
1154215 | 1154215 | 2021-03-25 | Kenai Peninsula Borough | Alaska | 2122 | 4068 | 19 |
1118377 | 1118377 | 2021-03-13 | Polk | Wisconsin | 55095 | 4068 | 48 |
1109418 | 1109418 | 2021-03-11 | Harrison | Indiana | 18061 | 4068 | 68 |
1054677 | 1054677 | 2021-02-22 | St. Mary | Louisiana | 22101 | 4068 | 120 |
1051430 | 1051430 | 2021-02-21 | St. Mary | Louisiana | 22101 | 4068 | 119 |
1024171 | 1024171 | 2021-02-12 | Mercer | West Virginia | 54055 | 4068 | 99 |
1012420 | 1012420 | 2021-02-09 | Shelby | Kentucky | 21211 | 4068 | 35 |
1002325 | 1002325 | 2021-02-06 | Lawrence | Indiana | 18093 | 4068 | 110 |
996552 | 996552 | 2021-02-04 | Panola | Mississippi | 28107 | 4068 | 88 |
981754 | 981754 | 2021-01-30 | Wasatch | Utah | 49051 | 4068 | 16 |
977749 | 977749 | 2021-01-29 | Washington | Ohio | 39167 | 4068 | 47 |
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);