ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
131 rows where cases = 4323 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 16
- Georgia 9
- Illinois 9
- Texas 9
- Iowa 8
- North Carolina 7
- Wisconsin 6
- Arkansas 5
- Michigan 5
- Virginia 5
- California 4
- Louisiana 4
- Missouri 4
- West Virginia 4
- Colorado 3
- Idaho 3
- Kansas 3
- Kentucky 3
- Minnesota 3
- Mississippi 2
- New York 2
- Puerto Rico 2
- South Dakota 2
- Washington 2
- Alabama 1
- District of Columbia 1
- Florida 1
- Indiana 1
- Maine 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500475 | 2500475 | 2022-05-13 | Atchison | Kansas | 20005 | 4323 | 34 |
2392735 | 2392735 | 2022-04-10 | De Witt | Illinois | 17039 | 4323 | 44 |
2389479 | 2389479 | 2022-04-09 | De Witt | Illinois | 17039 | 4323 | 44 |
2386224 | 2386224 | 2022-04-08 | De Witt | Illinois | 17039 | 4323 | 44 |
2382953 | 2382953 | 2022-04-07 | Bond | Illinois | 17005 | 4323 | 37 |
2372489 | 2372489 | 2022-04-03 | Wetzel | West Virginia | 54103 | 4323 | 84 |
2369236 | 2369236 | 2022-04-02 | Wetzel | West Virginia | 54103 | 4323 | 84 |
2365983 | 2365983 | 2022-04-01 | Wetzel | West Virginia | 54103 | 4323 | 84 |
2324190 | 2324190 | 2022-03-20 | Ben Hill | Georgia | 13017 | 4323 | 119 |
2320936 | 2320936 | 2022-03-19 | Ben Hill | Georgia | 13017 | 4323 | 119 |
2317682 | 2317682 | 2022-03-18 | Ben Hill | Georgia | 13017 | 4323 | 119 |
2314429 | 2314429 | 2022-03-17 | Ben Hill | Georgia | 13017 | 4323 | 119 |
2311176 | 2311176 | 2022-03-16 | Ben Hill | Georgia | 13017 | 4323 | 118 |
2307923 | 2307923 | 2022-03-15 | Ben Hill | Georgia | 13017 | 4323 | 118 |
2287649 | 2287649 | 2022-03-08 | Duchesne | Utah | 49013 | 4323 | 25 |
2246415 | 2246415 | 2022-02-24 | Piatt | Illinois | 17147 | 4323 | 27 |
2236528 | 2236528 | 2022-02-21 | Washington | Georgia | 13303 | 4323 | 132 |
2220377 | 2220377 | 2022-02-16 | Johnson | Illinois | 17087 | 4323 | 45 |
2217775 | 2217775 | 2022-02-15 | Manistee | Michigan | 26101 | 4323 | 79 |
2214524 | 2214524 | 2022-02-14 | Manistee | Michigan | 26101 | 4323 | 79 |
2215916 | 2215916 | 2022-02-14 | Deaf Smith | Texas | 48117 | 4323 | 105 |
2212665 | 2212665 | 2022-02-13 | Deaf Smith | Texas | 48117 | 4323 | 105 |
2157013 | 2157013 | 2022-01-27 | Barranquitas | Puerto Rico | 72019 | 4323 | |
2132043 | 2132043 | 2022-01-20 | Lawrence | Arkansas | 5075 | 4323 | 64 |
2112501 | 2112501 | 2022-01-14 | Clark | Arkansas | 5019 | 4323 | 66 |
2105281 | 2105281 | 2022-01-11 | Calhoun | Texas | 48057 | 4323 | 40 |
2063417 | 2063417 | 2021-12-29 | Winchester city | Virginia | 51840 | 4323 | 58 |
2056576 | 2056576 | 2021-12-27 | Gray | Texas | 48179 | 4323 | 93 |
2040141 | 2040141 | 2021-12-22 | Yankton | South Dakota | 46135 | 4323 | 44 |
2012855 | 2012855 | 2021-12-14 | Alpena | Michigan | 26007 | 4323 | 95 |
2014833 | 2014833 | 2021-12-14 | Waushara | Wisconsin | 55137 | 4323 | 66 |
2009604 | 2009604 | 2021-12-13 | Alpena | Michigan | 26007 | 4323 | 95 |
1996815 | 1996815 | 2021-12-09 | Marion | Mississippi | 28091 | 4323 | 112 |
1985469 | 1985469 | 2021-12-05 | Jackson | West Virginia | 54035 | 4323 | 94 |
1974699 | 1974699 | 2021-12-02 | Henry | Ohio | 39069 | 4323 | 78 |
1969872 | 1969872 | 2021-12-01 | Sumter | Georgia | 13261 | 4323 | 138 |
1969051 | 1969051 | 2021-11-30 | Carroll | Virginia | 51035 | 4323 | 105 |
1937422 | 1937422 | 2021-11-21 | Elmore | Idaho | 16039 | 4323 | 50 |
1934172 | 1934172 | 2021-11-20 | Elmore | Idaho | 16039 | 4323 | 50 |
1924427 | 1924427 | 2021-11-17 | Jerome | Idaho | 16053 | 4323 | 53 |
1920597 | 1920597 | 2021-11-16 | Bibb | Alabama | 1007 | 4323 | 92 |
1897964 | 1897964 | 2021-11-09 | Carroll | Arkansas | 5015 | 4323 | 75 |
1883685 | 1883685 | 2021-11-04 | Gallia | Ohio | 39053 | 4323 | 72 |
1847389 | 1847389 | 2021-10-24 | Dunklin | Missouri | 29069 | 4323 | 61 |
1849045 | 1849045 | 2021-10-24 | Lincoln | Wisconsin | 55069 | 4323 | 109 |
1844139 | 1844139 | 2021-10-23 | Dunklin | Missouri | 29069 | 4323 | 61 |
1845795 | 1845795 | 2021-10-23 | Lincoln | Wisconsin | 55069 | 4323 | 109 |
1842545 | 1842545 | 2021-10-22 | Lincoln | Wisconsin | 55069 | 4323 | 109 |
1827035 | 1827035 | 2021-10-18 | Perry | Illinois | 17145 | 4323 | 84 |
1787300 | 1787300 | 2021-10-05 | Green | Wisconsin | 55045 | 4323 | 26 |
1770195 | 1770195 | 2021-09-30 | Snyder | Pennsylvania | 42109 | 4323 | 92 |
1720976 | 1720976 | 2021-09-15 | Rio Arriba | New Mexico | 35039 | 4323 | 83 |
1686946 | 1686946 | 2021-09-05 | Montrose | Colorado | 8085 | 4323 | 74 |
1683696 | 1683696 | 2021-09-04 | Montrose | Colorado | 8085 | 4323 | 74 |
1680445 | 1680445 | 2021-09-03 | Montrose | Colorado | 8085 | 4323 | 74 |
1631961 | 1631961 | 2021-08-19 | Toombs | Georgia | 13279 | 4323 | 124 |
1634243 | 1634243 | 2021-08-19 | Polk | Texas | 48373 | 4323 | 130 |
1626723 | 1626723 | 2021-08-17 | Grafton | New Hampshire | 33009 | 4323 | 29 |
1580264 | 1580264 | 2021-08-03 | Buena Vista | Iowa | 19021 | 4323 | 40 |
1577015 | 1577015 | 2021-08-02 | Buena Vista | Iowa | 19021 | 4323 | 40 |
1573767 | 1573767 | 2021-08-01 | Buena Vista | Iowa | 19021 | 4323 | 40 |
1570519 | 1570519 | 2021-07-31 | Buena Vista | Iowa | 19021 | 4323 | 40 |
1567271 | 1567271 | 2021-07-30 | Buena Vista | Iowa | 19021 | 4323 | 40 |
1564023 | 1564023 | 2021-07-29 | Buena Vista | Iowa | 19021 | 4323 | 40 |
1560775 | 1560775 | 2021-07-28 | Buena Vista | Iowa | 19021 | 4323 | 40 |
1558710 | 1558710 | 2021-07-27 | Stokes | North Carolina | 37169 | 4323 | 81 |
1553588 | 1553588 | 2021-07-26 | Baxter | Arkansas | 5005 | 4323 | 115 |
1539666 | 1539666 | 2021-07-21 | Chester | South Carolina | 45023 | 4323 | 77 |
1527031 | 1527031 | 2021-07-17 | Matagorda | Texas | 48321 | 4323 | 115 |
1523784 | 1523784 | 2021-07-16 | Matagorda | Texas | 48321 | 4323 | 115 |
1473675 | 1473675 | 2021-07-01 | McLeod | Minnesota | 27085 | 4323 | 61 |
1470429 | 1470429 | 2021-06-30 | McLeod | Minnesota | 27085 | 4323 | 61 |
1466764 | 1466764 | 2021-06-29 | Lyon | Kansas | 20111 | 4323 | 86 |
1463519 | 1463519 | 2021-06-28 | Lyon | Kansas | 20111 | 4323 | 86 |
1464646 | 1464646 | 2021-06-28 | Defiance | Ohio | 39039 | 4323 | 99 |
1461401 | 1461401 | 2021-06-27 | Defiance | Ohio | 39039 | 4323 | 99 |
1458156 | 1458156 | 2021-06-26 | Defiance | Ohio | 39039 | 4323 | 99 |
1454911 | 1454911 | 2021-06-25 | Defiance | Ohio | 39039 | 4323 | 99 |
1454917 | 1454917 | 2021-06-25 | Fulton | Ohio | 39051 | 4323 | 75 |
1451666 | 1451666 | 2021-06-24 | Defiance | Ohio | 39039 | 4323 | 99 |
1448420 | 1448420 | 2021-06-23 | Defiance | Ohio | 39039 | 4323 | 99 |
1445175 | 1445175 | 2021-06-22 | Defiance | Ohio | 39039 | 4323 | 99 |
1441930 | 1441930 | 2021-06-21 | Defiance | Ohio | 39039 | 4323 | 99 |
1438685 | 1438685 | 2021-06-20 | Defiance | Ohio | 39039 | 4323 | 99 |
1435438 | 1435438 | 2021-06-19 | Defiance | Ohio | 39039 | 4323 | 99 |
1432191 | 1432191 | 2021-06-18 | Defiance | Ohio | 39039 | 4323 | 99 |
1418171 | 1418171 | 2021-06-14 | Graves | Kentucky | 21083 | 4323 | 96 |
1402027 | 1402027 | 2021-06-09 | Avoyelles | Louisiana | 22009 | 4323 | 123 |
1375136 | 1375136 | 2021-06-01 | Humboldt | California | 6023 | 4323 | 43 |
1376834 | 1376834 | 2021-06-01 | Tompkins | New York | 36109 | 4323 | 52 |
1357591 | 1357591 | 2021-05-26 | Putnam | Ohio | 39137 | 4323 | 102 |
1329278 | 1329278 | 2021-05-17 | Shenandoah | Virginia | 51171 | 4323 | 133 |
1311877 | 1311877 | 2021-05-12 | Livingston | New York | 36051 | 4323 | 58 |
1313250 | 1313250 | 2021-05-12 | Sweetwater | Wyoming | 56037 | 4323 | 38 |
1266461 | 1266461 | 2021-04-28 | Alexander | North Carolina | 37003 | 4323 | 83 |
1252234 | 1252234 | 2021-04-24 | Monroe | Illinois | 17133 | 4323 | 90 |
1226216 | 1226216 | 2021-04-16 | Franklin | Illinois | 17055 | 4323 | 82 |
1218321 | 1218321 | 2021-04-13 | Codington | South Dakota | 46029 | 4323 | 80 |
1186826 | 1186826 | 2021-04-04 | Nevada | California | 6057 | 4323 | 74 |
1183579 | 1183579 | 2021-04-03 | Nevada | California | 6057 | 4323 | 74 |
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);