ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
312 rows where cases = 1878 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 28
- Iowa 26
- Oklahoma 18
- Minnesota 15
- Texas 14
- Missouri 12
- Virginia 12
- Arkansas 11
- Wisconsin 11
- Georgia 10
- Tennessee 10
- Florida 9
- Indiana 9
- Kentucky 9
- Alabama 8
- California 8
- Illinois 7
- Mississippi 6
- Nebraska 6
- North Carolina 6
- Oregon 6
- Pennsylvania 6
- Puerto Rico 6
- South Carolina 6
- West Virginia 6
- Ohio 5
- Louisiana 4
- Nevada 4
- Utah 4
- Alaska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466855 | 2466855 | 2022-05-02 | Calhoun | West Virginia | 54013 | 1878 | 14 |
2451701 | 2451701 | 2022-04-28 | Russell | Kansas | 20167 | 1878 | 37 |
2448445 | 2448445 | 2022-04-27 | Russell | Kansas | 20167 | 1878 | 37 |
2445189 | 2445189 | 2022-04-26 | Russell | Kansas | 20167 | 1878 | 37 |
2441933 | 2441933 | 2022-04-25 | Russell | Kansas | 20167 | 1878 | 37 |
2438677 | 2438677 | 2022-04-24 | Russell | Kansas | 20167 | 1878 | 37 |
2435421 | 2435421 | 2022-04-23 | Russell | Kansas | 20167 | 1878 | 37 |
2432165 | 2432165 | 2022-04-22 | Russell | Kansas | 20167 | 1878 | 37 |
2406117 | 2406117 | 2022-04-14 | Russell | Kansas | 20167 | 1878 | 37 |
2402861 | 2402861 | 2022-04-13 | Russell | Kansas | 20167 | 1878 | 37 |
2399607 | 2399607 | 2022-04-12 | Russell | Kansas | 20167 | 1878 | 37 |
2396351 | 2396351 | 2022-04-11 | Russell | Kansas | 20167 | 1878 | 37 |
2393096 | 2393096 | 2022-04-10 | Russell | Kansas | 20167 | 1878 | 37 |
2389840 | 2389840 | 2022-04-09 | Russell | Kansas | 20167 | 1878 | 37 |
2386584 | 2386584 | 2022-04-08 | Russell | Kansas | 20167 | 1878 | 37 |
2383330 | 2383330 | 2022-04-07 | Russell | Kansas | 20167 | 1878 | 37 |
2380075 | 2380075 | 2022-04-06 | Russell | Kansas | 20167 | 1878 | 37 |
2376820 | 2376820 | 2022-04-05 | Russell | Kansas | 20167 | 1878 | 37 |
2373568 | 2373568 | 2022-04-04 | Russell | Kansas | 20167 | 1878 | 37 |
2370315 | 2370315 | 2022-04-03 | Russell | Kansas | 20167 | 1878 | 37 |
2367062 | 2367062 | 2022-04-02 | Russell | Kansas | 20167 | 1878 | 37 |
2363809 | 2363809 | 2022-04-01 | Russell | Kansas | 20167 | 1878 | 37 |
2354048 | 2354048 | 2022-03-29 | Russell | Kansas | 20167 | 1878 | 37 |
2350796 | 2350796 | 2022-03-28 | Russell | Kansas | 20167 | 1878 | 37 |
2311641 | 2311641 | 2022-03-16 | Monroe | Iowa | 19135 | 1878 | 48 |
2308388 | 2308388 | 2022-03-15 | Monroe | Iowa | 19135 | 1878 | 48 |
2305137 | 2305137 | 2022-03-14 | Monroe | Iowa | 19135 | 1878 | 48 |
2301885 | 2301885 | 2022-03-13 | Monroe | Iowa | 19135 | 1878 | 48 |
2298633 | 2298633 | 2022-03-12 | Monroe | Iowa | 19135 | 1878 | 48 |
2295381 | 2295381 | 2022-03-11 | Monroe | Iowa | 19135 | 1878 | 48 |
2292129 | 2292129 | 2022-03-10 | Monroe | Iowa | 19135 | 1878 | 48 |
2288877 | 2288877 | 2022-03-09 | Monroe | Iowa | 19135 | 1878 | 48 |
2279349 | 2279349 | 2022-03-06 | Nicholas | Kentucky | 21181 | 1878 | 30 |
2276096 | 2276096 | 2022-03-05 | Nicholas | Kentucky | 21181 | 1878 | 30 |
2272843 | 2272843 | 2022-03-04 | Nicholas | Kentucky | 21181 | 1878 | 30 |
2245684 | 2245684 | 2022-02-23 | Menominee | Wisconsin | 55078 | 1878 | 13 |
2216075 | 2216075 | 2022-02-14 | Swisher | Texas | 48437 | 1878 | 32 |
2212824 | 2212824 | 2022-02-13 | Swisher | Texas | 48437 | 1878 | 32 |
2200105 | 2200105 | 2022-02-09 | Pocahontas | West Virginia | 54075 | 1878 | 25 |
2163570 | 2163570 | 2022-01-29 | Patillas | Puerto Rico | 72109 | 1878 | |
2164294 | 2164294 | 2022-01-29 | Gilmer | West Virginia | 54021 | 1878 | 17 |
2150691 | 2150691 | 2022-01-25 | Turner | South Dakota | 46125 | 1878 | 62 |
2105514 | 2105514 | 2022-01-11 | Emery | Utah | 49015 | 1878 | 25 |
2098922 | 2098922 | 2022-01-09 | Morris | Texas | 48343 | 1878 | 58 |
2088661 | 2088661 | 2022-01-06 | Forest | Pennsylvania | 42053 | 1878 | 31 |
2082271 | 2082271 | 2022-01-04 | Utuado | Puerto Rico | 72141 | 1878 | |
2079040 | 2079040 | 2022-01-03 | Calhoun | South Carolina | 45017 | 1878 | 54 |
2075789 | 2075789 | 2022-01-02 | Calhoun | South Carolina | 45017 | 1878 | 54 |
2072538 | 2072538 | 2022-01-01 | Calhoun | South Carolina | 45017 | 1878 | 54 |
2069287 | 2069287 | 2021-12-31 | Calhoun | South Carolina | 45017 | 1878 | 54 |
2055326 | 2055326 | 2021-12-27 | Montgomery | Mississippi | 28097 | 1878 | 57 |
2038254 | 2038254 | 2021-12-22 | Jasper | Illinois | 17079 | 1878 | 23 |
2032741 | 2032741 | 2021-12-20 | Fergus | Montana | 30027 | 1878 | 51 |
2014551 | 2014551 | 2021-12-14 | Brunswick | Virginia | 51025 | 1878 | 35 |
2000160 | 2000160 | 2021-12-10 | Lewis | Missouri | 29111 | 1878 | 30 |
1966315 | 1966315 | 2021-11-30 | Mono | California | 6051 | 1878 | 4 |
1959691 | 1959691 | 2021-11-28 | Valdez-Cordova Census Area | Alaska | 2261 | 1878 | 9 |
1956440 | 1956440 | 2021-11-27 | Valdez-Cordova Census Area | Alaska | 2261 | 1878 | 9 |
1953189 | 1953189 | 2021-11-26 | Valdez-Cordova Census Area | Alaska | 2261 | 1878 | 9 |
1945916 | 1945916 | 2021-11-23 | Houston | Tennessee | 47083 | 1878 | 45 |
1940274 | 1940274 | 2021-11-22 | Stone | Arkansas | 5137 | 1878 | 44 |
1940003 | 1940003 | 2021-11-21 | Bayfield | Wisconsin | 55007 | 1878 | 25 |
1936753 | 1936753 | 2021-11-20 | Bayfield | Wisconsin | 55007 | 1878 | 25 |
1933503 | 1933503 | 2021-11-19 | Bayfield | Wisconsin | 55007 | 1878 | 25 |
1920812 | 1920812 | 2021-11-16 | Plumas | California | 6063 | 1878 | 8 |
1917562 | 1917562 | 2021-11-15 | Plumas | California | 6063 | 1878 | 8 |
1883692 | 1883692 | 2021-11-04 | Harrison | Ohio | 39067 | 1878 | 48 |
1872620 | 1872620 | 2021-11-01 | Pulaski | Indiana | 18131 | 1878 | 57 |
1870854 | 1870854 | 2021-10-31 | Morrow | Oregon | 41049 | 1878 | 23 |
1867605 | 1867605 | 2021-10-30 | Morrow | Oregon | 41049 | 1878 | 23 |
1864356 | 1864356 | 2021-10-29 | Morrow | Oregon | 41049 | 1878 | 23 |
1830696 | 1830696 | 2021-10-19 | Metcalfe | Kentucky | 21169 | 1878 | 42 |
1815607 | 1815607 | 2021-10-14 | Hood River | Oregon | 41027 | 1878 | 37 |
1807487 | 1807487 | 2021-10-12 | Cumberland | Illinois | 17035 | 1878 | 38 |
1772315 | 1772315 | 2021-10-01 | Franklin | Maine | 23007 | 1878 | 18 |
1766979 | 1766979 | 2021-09-29 | Cidra | Puerto Rico | 72041 | 1878 | |
1760422 | 1760422 | 2021-09-27 | Fulton | Pennsylvania | 42057 | 1878 | 23 |
1744229 | 1744229 | 2021-09-22 | Cabo Rojo | Puerto Rico | 72023 | 1878 | |
1744890 | 1744890 | 2021-09-22 | Martinsville city | Virginia | 51690 | 1878 | 85 |
1728925 | 1728925 | 2021-09-18 | Lamar | Alabama | 1075 | 1878 | 39 |
1727986 | 1727986 | 2021-09-17 | Catano | Puerto Rico | 72033 | 1878 | |
1670429 | 1670429 | 2021-08-31 | Cleburne | Alabama | 1029 | 1878 | 46 |
1652282 | 1652282 | 2021-08-25 | Houston | Minnesota | 27055 | 1878 | 16 |
1652461 | 1652461 | 2021-08-25 | Gasconade | Missouri | 29073 | 1878 | 47 |
1653476 | 1653476 | 2021-08-25 | Decatur | Tennessee | 47039 | 1878 | 39 |
1650229 | 1650229 | 2021-08-24 | Decatur | Tennessee | 47039 | 1878 | 39 |
1625837 | 1625837 | 2021-08-17 | Atchison | Kansas | 20005 | 1878 | 20 |
1622590 | 1622590 | 2021-08-16 | Atchison | Kansas | 20005 | 1878 | 20 |
1614825 | 1614825 | 2021-08-13 | Zapata | Texas | 48505 | 1878 | 38 |
1607025 | 1607025 | 2021-08-11 | Osage | Missouri | 29151 | 1878 | 18 |
1577735 | 1577735 | 2021-08-02 | Dallas | Missouri | 29059 | 1878 | 34 |
1566427 | 1566427 | 2021-07-29 | Sawyer | Wisconsin | 55113 | 1878 | 29 |
1563179 | 1563179 | 2021-07-28 | Sawyer | Wisconsin | 55113 | 1878 | 29 |
1559931 | 1559931 | 2021-07-27 | Sawyer | Wisconsin | 55113 | 1878 | 29 |
1534819 | 1534819 | 2021-07-20 | Fayette | Iowa | 19065 | 1878 | 43 |
1531323 | 1531323 | 2021-07-19 | Gem | Idaho | 16045 | 1878 | 42 |
1531572 | 1531572 | 2021-07-19 | Fayette | Iowa | 19065 | 1878 | 43 |
1528325 | 1528325 | 2021-07-18 | Fayette | Iowa | 19065 | 1878 | 43 |
1525078 | 1525078 | 2021-07-17 | Fayette | Iowa | 19065 | 1878 | 43 |
1521830 | 1521830 | 2021-07-16 | Fayette | Iowa | 19065 | 1878 | 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);