ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
278 rows where cases = 2048 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 33
- Puerto Rico 21
- Texas 20
- Oklahoma 16
- Georgia 13
- West Virginia 13
- Mississippi 12
- Kentucky 11
- Arkansas 10
- Louisiana 9
- Illinois 8
- Michigan 8
- Missouri 8
- Virginia 8
- North Carolina 7
- Alabama 6
- Colorado 5
- Florida 5
- Indiana 5
- New York 5
- South Carolina 5
- Tennessee 5
- Wisconsin 5
- Minnesota 4
- Montana 4
- New Hampshire 4
- Ohio 4
- Pennsylvania 4
- Maryland 3
- North Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500446 | 2500446 | 2022-05-13 | Palo Alto | Iowa | 19147 | 2048 | 38 |
2501421 | 2501421 | 2022-05-13 | Sierra | New Mexico | 35051 | 2048 | 73 |
2497188 | 2497188 | 2022-05-12 | Palo Alto | Iowa | 19147 | 2048 | 38 |
2493930 | 2493930 | 2022-05-11 | Palo Alto | Iowa | 19147 | 2048 | 38 |
2380715 | 2380715 | 2022-04-06 | Carbon | Montana | 30009 | 2048 | 28 |
2375851 | 2375851 | 2022-04-05 | Choctaw | Alabama | 1023 | 2048 | 36 |
2376690 | 2376690 | 2022-04-05 | Keokuk | Iowa | 19107 | 2048 | 48 |
2373438 | 2373438 | 2022-04-04 | Keokuk | Iowa | 19107 | 2048 | 48 |
2370185 | 2370185 | 2022-04-03 | Keokuk | Iowa | 19107 | 2048 | 48 |
2366932 | 2366932 | 2022-04-02 | Keokuk | Iowa | 19107 | 2048 | 48 |
2363679 | 2363679 | 2022-04-01 | Keokuk | Iowa | 19107 | 2048 | 48 |
2365195 | 2365195 | 2022-04-01 | Guayanilla | Puerto Rico | 72059 | 2048 | |
2360425 | 2360425 | 2022-03-31 | Keokuk | Iowa | 19107 | 2048 | 48 |
2357171 | 2357171 | 2022-03-30 | Keokuk | Iowa | 19107 | 2048 | 48 |
2353918 | 2353918 | 2022-03-29 | Keokuk | Iowa | 19107 | 2048 | 48 |
2350666 | 2350666 | 2022-03-28 | Keokuk | Iowa | 19107 | 2048 | 48 |
2347413 | 2347413 | 2022-03-27 | Keokuk | Iowa | 19107 | 2048 | 48 |
2344160 | 2344160 | 2022-03-26 | Keokuk | Iowa | 19107 | 2048 | 48 |
2340907 | 2340907 | 2022-03-25 | Keokuk | Iowa | 19107 | 2048 | 48 |
2337654 | 2337654 | 2022-03-24 | Keokuk | Iowa | 19107 | 2048 | 48 |
2334400 | 2334400 | 2022-03-23 | Keokuk | Iowa | 19107 | 2048 | 48 |
2259166 | 2259166 | 2022-02-28 | Clinch | Georgia | 13065 | 2048 | 38 |
2238408 | 2238408 | 2022-02-21 | Allendale | South Carolina | 45005 | 2048 | 24 |
2239098 | 2239098 | 2022-02-21 | Gilmer | West Virginia | 54021 | 2048 | 18 |
2235157 | 2235157 | 2022-02-20 | Allendale | South Carolina | 45005 | 2048 | 24 |
2231906 | 2231906 | 2022-02-19 | Allendale | South Carolina | 45005 | 2048 | 24 |
2228655 | 2228655 | 2022-02-18 | Allendale | South Carolina | 45005 | 2048 | 24 |
2175730 | 2175730 | 2022-02-02 | Gentry | Missouri | 29075 | 2048 | 28 |
2176589 | 2176589 | 2022-02-02 | Rincon | Puerto Rico | 72117 | 2048 | |
2154562 | 2154562 | 2022-01-26 | Ritchie | West Virginia | 54085 | 2048 | 27 |
2149791 | 2149791 | 2022-01-25 | Deer Lodge | Montana | 30023 | 2048 | 29 |
2141215 | 2141215 | 2022-01-22 | Parmer | Texas | 48369 | 2048 | 46 |
2094379 | 2094379 | 2022-01-08 | Bollinger | Missouri | 29017 | 2048 | 36 |
2076745 | 2076745 | 2022-01-03 | Desha | Arkansas | 5041 | 2048 | 36 |
2057329 | 2057329 | 2021-12-28 | Plumas | California | 6063 | 2048 | 12 |
2053189 | 2053189 | 2021-12-26 | Lake | Tennessee | 47095 | 2048 | 34 |
2049939 | 2049939 | 2021-12-25 | Lake | Tennessee | 47095 | 2048 | 34 |
2046689 | 2046689 | 2021-12-24 | Lake | Tennessee | 47095 | 2048 | 34 |
2043439 | 2043439 | 2021-12-23 | Lake | Tennessee | 47095 | 2048 | 34 |
2037226 | 2037226 | 2021-12-21 | Ward | Texas | 48475 | 2048 | 35 |
2027978 | 2027978 | 2021-12-19 | Bradley | Arkansas | 5011 | 2048 | 42 |
2021479 | 2021479 | 2021-12-17 | Chicot | Arkansas | 5017 | 2048 | 47 |
2018228 | 2018228 | 2021-12-16 | Chicot | Arkansas | 5017 | 2048 | 47 |
2014978 | 2014978 | 2021-12-15 | Chicot | Arkansas | 5017 | 2048 | 47 |
2012561 | 2012561 | 2021-12-14 | Marion | Kansas | 20115 | 2048 | 35 |
2009310 | 2009310 | 2021-12-13 | Marion | Kansas | 20115 | 2048 | 35 |
1990744 | 1990744 | 2021-12-07 | Schuyler | New York | 36097 | 2048 | 20 |
1960900 | 1960900 | 2021-11-28 | Missaukee | Michigan | 26113 | 2048 | 41 |
1961633 | 1961633 | 2021-11-28 | McLean | North Dakota | 38055 | 2048 | 43 |
1957649 | 1957649 | 2021-11-27 | Missaukee | Michigan | 26113 | 2048 | 41 |
1954398 | 1954398 | 2021-11-26 | Missaukee | Michigan | 26113 | 2048 | 41 |
1951147 | 1951147 | 2021-11-25 | Missaukee | Michigan | 26113 | 2048 | 41 |
1947896 | 1947896 | 2021-11-24 | Missaukee | Michigan | 26113 | 2048 | 41 |
1907236 | 1907236 | 2021-11-11 | Juab | Utah | 49023 | 2048 | 18 |
1882957 | 1882957 | 2021-11-04 | Kanabec | Minnesota | 27065 | 2048 | 30 |
1875946 | 1875946 | 2021-11-02 | Jefferson | Iowa | 19101 | 2048 | 40 |
1872697 | 1872697 | 2021-11-01 | Jefferson | Iowa | 19101 | 2048 | 40 |
1869448 | 1869448 | 2021-10-31 | Jefferson | Iowa | 19101 | 2048 | 40 |
1866199 | 1866199 | 2021-10-30 | Jefferson | Iowa | 19101 | 2048 | 40 |
1862950 | 1862950 | 2021-10-29 | Jefferson | Iowa | 19101 | 2048 | 40 |
1859701 | 1859701 | 2021-10-28 | Jefferson | Iowa | 19101 | 2048 | 40 |
1856452 | 1856452 | 2021-10-27 | Jefferson | Iowa | 19101 | 2048 | 40 |
1835990 | 1835990 | 2021-10-20 | Morgan | West Virginia | 54065 | 2048 | 40 |
1826993 | 1826993 | 2021-10-18 | Greene | Illinois | 17061 | 2048 | 53 |
1827832 | 1827832 | 2021-10-18 | Perry | Mississippi | 28111 | 2048 | 55 |
1823049 | 1823049 | 2021-10-16 | Lafayette | Wisconsin | 55065 | 2048 | 12 |
1819800 | 1819800 | 2021-10-15 | Lafayette | Wisconsin | 55065 | 2048 | 12 |
1816551 | 1816551 | 2021-10-14 | Lafayette | Wisconsin | 55065 | 2048 | 12 |
1802661 | 1802661 | 2021-10-10 | Fulton | Pennsylvania | 42057 | 2048 | 26 |
1797014 | 1797014 | 2021-10-08 | Taylor | West Virginia | 54091 | 2048 | 35 |
1783582 | 1783582 | 2021-10-04 | Gaines | Texas | 48165 | 2048 | 54 |
1780333 | 1780333 | 2021-10-03 | Gaines | Texas | 48165 | 2048 | 54 |
1777083 | 1777083 | 2021-10-02 | Gaines | Texas | 48165 | 2048 | 54 |
1773833 | 1773833 | 2021-10-01 | Gaines | Texas | 48165 | 2048 | 54 |
1770583 | 1770583 | 2021-09-30 | Gaines | Texas | 48165 | 2048 | 54 |
1767334 | 1767334 | 2021-09-29 | Gaines | Texas | 48165 | 2048 | 54 |
1764085 | 1764085 | 2021-09-28 | Gaines | Texas | 48165 | 2048 | 54 |
1747557 | 1747557 | 2021-09-23 | Bamberg | South Carolina | 45009 | 2048 | 61 |
1742931 | 1742931 | 2021-09-22 | Green | Kentucky | 21087 | 2048 | 27 |
1738883 | 1738883 | 2021-09-21 | Alamosa | Colorado | 8003 | 2048 | 42 |
1716563 | 1716563 | 2021-09-14 | Moultrie | Illinois | 17139 | 2048 | 38 |
1717207 | 1717207 | 2021-09-14 | Roscommon | Michigan | 26143 | 2048 | 57 |
1713959 | 1713959 | 2021-09-13 | Roscommon | Michigan | 26143 | 2048 | 57 |
1696148 | 1696148 | 2021-09-07 | King George | Virginia | 51099 | 2048 | 21 |
1683422 | 1683422 | 2021-09-04 | Clay | Alabama | 1027 | 2048 | 60 |
1677323 | 1677323 | 2021-09-02 | Charlton | Georgia | 13049 | 2048 | 42 |
1679267 | 1679267 | 2021-09-02 | Fajardo | Puerto Rico | 72053 | 2048 | |
1674286 | 1674286 | 2021-09-01 | Edgar | Illinois | 17045 | 2048 | 62 |
1671242 | 1671242 | 2021-08-31 | Fayette | Iowa | 19065 | 2048 | 43 |
1667995 | 1667995 | 2021-08-30 | Fayette | Iowa | 19065 | 2048 | 43 |
1669079 | 1669079 | 2021-08-30 | Bertie | North Carolina | 37015 | 2048 | 46 |
1664748 | 1664748 | 2021-08-29 | Fayette | Iowa | 19065 | 2048 | 43 |
1661500 | 1661500 | 2021-08-28 | Fayette | Iowa | 19065 | 2048 | 43 |
1658252 | 1658252 | 2021-08-27 | Fayette | Iowa | 19065 | 2048 | 43 |
1655004 | 1655004 | 2021-08-26 | Fayette | Iowa | 19065 | 2048 | 43 |
1651757 | 1651757 | 2021-08-25 | Fayette | Iowa | 19065 | 2048 | 43 |
1646221 | 1646221 | 2021-08-23 | Sullivan | New Hampshire | 33019 | 2048 | 28 |
1633743 | 1633743 | 2021-08-19 | Montour | Pennsylvania | 42093 | 2048 | 67 |
1606599 | 1606599 | 2021-08-11 | LaSalle | Louisiana | 22059 | 2048 | 39 |
1607494 | 1607494 | 2021-08-11 | Richland | North Dakota | 38077 | 2048 | 17 |
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);