ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where cases = 4012 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 15
- Illinois 12
- Texas 12
- South Dakota 10
- Iowa 9
- Kentucky 8
- Ohio 8
- Kansas 7
- Georgia 6
- Missouri 6
- Indiana 5
- Michigan 5
- Pennsylvania 5
- Louisiana 4
- Mississippi 4
- New York 4
- Washington 4
- California 3
- Maine 3
- Alabama 2
- Arkansas 2
- Colorado 2
- Minnesota 2
- Tennessee 2
- Arizona 1
- Idaho 1
- Maryland 1
- Nebraska 1
- New Hampshire 1
- North Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492333 | 2492333 | 2022-05-10 | Union | South Dakota | 46127 | 4012 | 52 |
2489075 | 2489075 | 2022-05-09 | Union | South Dakota | 46127 | 4012 | 52 |
2485818 | 2485818 | 2022-05-08 | Union | South Dakota | 46127 | 4012 | 52 |
2482560 | 2482560 | 2022-05-07 | Union | South Dakota | 46127 | 4012 | 52 |
2479302 | 2479302 | 2022-05-06 | Union | South Dakota | 46127 | 4012 | 52 |
2476044 | 2476044 | 2022-05-05 | Union | South Dakota | 46127 | 4012 | 52 |
2472787 | 2472787 | 2022-05-04 | Union | South Dakota | 46127 | 4012 | 52 |
2473241 | 2473241 | 2022-05-04 | Greene | Virginia | 51079 | 4012 | 61 |
2420502 | 2420502 | 2022-04-18 | Aguas Buenas | Puerto Rico | 72007 | 4012 | |
2415571 | 2415571 | 2022-04-17 | Mercer | Illinois | 17131 | 4012 | 47 |
2412315 | 2412315 | 2022-04-16 | Mercer | Illinois | 17131 | 4012 | 47 |
2409059 | 2409059 | 2022-04-15 | Mercer | Illinois | 17131 | 4012 | 47 |
2405803 | 2405803 | 2022-04-14 | Mercer | Illinois | 17131 | 4012 | 47 |
2267891 | 2267891 | 2022-03-02 | Bosque | Texas | 48035 | 4012 | 70 |
2251035 | 2251035 | 2022-02-25 | Richland | North Dakota | 38077 | 4012 | 21 |
2217152 | 2217152 | 2022-02-15 | Moultrie | Illinois | 17139 | 4012 | 51 |
2196977 | 2196977 | 2022-02-09 | Clay | Alabama | 1027 | 4012 | 73 |
2174485 | 2174485 | 2022-02-02 | Otero | Colorado | 8089 | 4012 | 123 |
2175284 | 2175284 | 2022-02-02 | Morgan | Kentucky | 21175 | 4012 | 17 |
2172523 | 2172523 | 2022-02-01 | Pike | Missouri | 29163 | 4012 | 55 |
2109827 | 2109827 | 2022-01-13 | Wayne | Illinois | 17191 | 4012 | 70 |
2111595 | 2111595 | 2022-01-13 | Beadle | South Dakota | 46005 | 4012 | 50 |
2106554 | 2106554 | 2022-01-12 | Pike | Illinois | 17149 | 4012 | 63 |
2088700 | 2088700 | 2022-01-06 | Wyoming | Pennsylvania | 42131 | 4012 | 91 |
2086093 | 2086093 | 2022-01-05 | Fredericksburg city | Virginia | 51630 | 4012 | 27 |
2051733 | 2051733 | 2021-12-26 | Woodford | Kentucky | 21239 | 4012 | 35 |
2048483 | 2048483 | 2021-12-25 | Woodford | Kentucky | 21239 | 4012 | 35 |
2045233 | 2045233 | 2021-12-24 | Woodford | Kentucky | 21239 | 4012 | 35 |
2041984 | 2041984 | 2021-12-23 | Woodford | Kentucky | 21239 | 4012 | 35 |
2038734 | 2038734 | 2021-12-22 | Woodford | Kentucky | 21239 | 4012 | 35 |
2006266 | 2006266 | 2021-12-12 | Pointe Coupee | Louisiana | 22077 | 4012 | 85 |
2003015 | 2003015 | 2021-12-11 | Pointe Coupee | Louisiana | 22077 | 4012 | 85 |
1999765 | 1999765 | 2021-12-10 | Pointe Coupee | Louisiana | 22077 | 4012 | 85 |
1993690 | 1993690 | 2021-12-08 | Randolph | Missouri | 29175 | 4012 | 80 |
1989425 | 1989425 | 2021-12-07 | Cassia | Idaho | 16031 | 4012 | 43 |
1988727 | 1988727 | 2021-12-06 | Mason | West Virginia | 54053 | 4012 | 62 |
1898686 | 1898686 | 2021-11-09 | Henry | Iowa | 19087 | 4012 | 51 |
1895436 | 1895436 | 2021-11-08 | Henry | Iowa | 19087 | 4012 | 51 |
1892186 | 1892186 | 2021-11-07 | Henry | Iowa | 19087 | 4012 | 51 |
1888936 | 1888936 | 2021-11-06 | Henry | Iowa | 19087 | 4012 | 51 |
1885686 | 1885686 | 2021-11-05 | Henry | Iowa | 19087 | 4012 | 51 |
1882437 | 1882437 | 2021-11-04 | Henry | Iowa | 19087 | 4012 | 51 |
1879188 | 1879188 | 2021-11-03 | Henry | Iowa | 19087 | 4012 | 51 |
1881267 | 1881267 | 2021-11-03 | Rutland | Vermont | 50021 | 4012 | 30 |
1838396 | 1838396 | 2021-10-21 | Elk | Pennsylvania | 42047 | 4012 | 56 |
1805680 | 1805680 | 2021-10-11 | Adams | Ohio | 39001 | 4012 | 82 |
1798982 | 1798982 | 2021-10-09 | Franklin | New York | 36033 | 4012 | 19 |
1769331 | 1769331 | 2021-09-30 | Leake | Mississippi | 28079 | 4012 | 86 |
1765342 | 1765342 | 2021-09-29 | Clay | Indiana | 18021 | 4012 | 58 |
1763880 | 1763880 | 2021-09-28 | Lawrence | South Dakota | 46081 | 4012 | 53 |
1757813 | 1757813 | 2021-09-26 | Amherst | Virginia | 51009 | 4012 | 48 |
1753499 | 1753499 | 2021-09-25 | Greene | New York | 36039 | 4012 | 83 |
1754565 | 1754565 | 2021-09-25 | Amherst | Virginia | 51009 | 4012 | 48 |
1751317 | 1751317 | 2021-09-24 | Amherst | Virginia | 51009 | 4012 | 48 |
1742083 | 1742083 | 2021-09-22 | Glenn | California | 6021 | 4012 | 34 |
1713840 | 1713840 | 2021-09-13 | Oxford | Maine | 23017 | 4012 | 71 |
1710594 | 1710594 | 2021-09-12 | Oxford | Maine | 23017 | 4012 | 71 |
1707347 | 1707347 | 2021-09-11 | Oxford | Maine | 23017 | 4012 | 71 |
1624140 | 1624140 | 2021-08-16 | Marion | South Carolina | 45067 | 4012 | 109 |
1561530 | 1561530 | 2021-07-28 | Marion | Missouri | 29127 | 4012 | 54 |
1489449 | 1489449 | 2021-07-06 | Cowley | Kansas | 20035 | 4012 | 108 |
1486202 | 1486202 | 2021-07-05 | Cowley | Kansas | 20035 | 4012 | 108 |
1482956 | 1482956 | 2021-07-04 | Cowley | Kansas | 20035 | 4012 | 108 |
1479709 | 1479709 | 2021-07-03 | Cowley | Kansas | 20035 | 4012 | 108 |
1476463 | 1476463 | 2021-07-02 | Cowley | Kansas | 20035 | 4012 | 108 |
1465414 | 1465414 | 2021-06-28 | Titus | Texas | 48449 | 4012 | 84 |
1462169 | 1462169 | 2021-06-27 | Titus | Texas | 48449 | 4012 | 84 |
1451044 | 1451044 | 2021-06-24 | Lincoln | Mississippi | 28085 | 4012 | 113 |
1444010 | 1444010 | 2021-06-22 | Cowley | Kansas | 20035 | 4012 | 108 |
1440765 | 1440765 | 2021-06-21 | Cowley | Kansas | 20035 | 4012 | 108 |
1385413 | 1385413 | 2021-06-04 | Huntington | Indiana | 18069 | 4012 | 83 |
1375348 | 1375348 | 2021-06-01 | Camden | Georgia | 13039 | 4012 | 37 |
1367277 | 1367277 | 2021-05-29 | Crawford | Ohio | 39033 | 4012 | 110 |
1368149 | 1368149 | 2021-05-29 | Charlottesville city | Virginia | 51540 | 4012 | 57 |
1364031 | 1364031 | 2021-05-28 | Crawford | Ohio | 39033 | 4012 | 110 |
1360785 | 1360785 | 2021-05-27 | Crawford | Ohio | 39033 | 4012 | 110 |
1352886 | 1352886 | 2021-05-25 | Morgan | Illinois | 17137 | 4012 | 104 |
1350755 | 1350755 | 2021-05-24 | Grafton | New Hampshire | 33009 | 4012 | 26 |
1351294 | 1351294 | 2021-05-24 | Venango | Pennsylvania | 42121 | 4012 | 96 |
1345425 | 1345425 | 2021-05-22 | Charlottesville city | Virginia | 51540 | 4012 | 57 |
1342177 | 1342177 | 2021-05-21 | Charlottesville city | Virginia | 51540 | 4012 | 57 |
1332435 | 1332435 | 2021-05-18 | Charlottesville city | Virginia | 51540 | 4012 | 57 |
1329188 | 1329188 | 2021-05-17 | Charlottesville city | Virginia | 51540 | 4012 | 57 |
1325942 | 1325942 | 2021-05-16 | Charlottesville city | Virginia | 51540 | 4012 | 57 |
1317371 | 1317371 | 2021-05-14 | Plymouth | Iowa | 19149 | 4012 | 80 |
1305517 | 1305517 | 2021-05-10 | Yadkin | North Carolina | 37197 | 4012 | 48 |
1285074 | 1285074 | 2021-05-04 | Franklin | Kentucky | 21073 | 4012 | 46 |
1280970 | 1280970 | 2021-05-03 | Union | Arkansas | 5139 | 4012 | 114 |
1281288 | 1281288 | 2021-05-03 | Oconee | Georgia | 13219 | 4012 | 72 |
1281827 | 1281827 | 2021-05-03 | Franklin | Kentucky | 21073 | 4012 | 46 |
1277245 | 1277245 | 2021-05-01 | Charlottesville city | Virginia | 51540 | 4012 | 55 |
1264170 | 1264170 | 2021-04-27 | Washington | Texas | 48477 | 4012 | 92 |
1239958 | 1239958 | 2021-04-20 | Nobles | Minnesota | 27105 | 4012 | 48 |
1218885 | 1218885 | 2021-04-13 | Shenandoah | Virginia | 51171 | 4012 | 129 |
1204940 | 1204940 | 2021-04-09 | Fulton | Ohio | 39051 | 4012 | 65 |
1191370 | 1191370 | 2021-04-05 | Camden | Missouri | 29029 | 4012 | 85 |
1188122 | 1188122 | 2021-04-04 | Camden | Missouri | 29029 | 4012 | 85 |
1184851 | 1184851 | 2021-04-03 | Union | Mississippi | 28145 | 4012 | 74 |
1172439 | 1172439 | 2021-03-30 | Ashland | Ohio | 39005 | 4012 | 86 |
1138660 | 1138660 | 2021-03-20 | Montgomery | Indiana | 18107 | 4012 | 85 |
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);