ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where cases = 1814 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- Virginia 18
- Georgia 17
- Kansas 14
- Missouri 13
- Kentucky 12
- Louisiana 12
- Indiana 9
- South Carolina 9
- Mississippi 8
- North Carolina 8
- Florida 7
- Iowa 7
- Michigan 6
- Pennsylvania 6
- Puerto Rico 6
- Alabama 5
- Arkansas 5
- Illinois 5
- Montana 5
- New York 5
- Tennessee 5
- Colorado 4
- Minnesota 4
- Oklahoma 4
- West Virginia 4
- Wisconsin 4
- Ohio 3
- Wyoming 3
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447743 | 2447743 | 2022-04-27 | Lake | Colorado | 8065 | 1814 | 2 |
2433876 | 2433876 | 2022-04-22 | Delta | Texas | 48119 | 1814 | 25 |
2430620 | 2430620 | 2022-04-21 | Delta | Texas | 48119 | 1814 | 25 |
2427364 | 2427364 | 2022-04-20 | Delta | Texas | 48119 | 1814 | 25 |
2424108 | 2424108 | 2022-04-19 | Delta | Texas | 48119 | 1814 | 25 |
2420852 | 2420852 | 2022-04-18 | Delta | Texas | 48119 | 1814 | 25 |
2372346 | 2372346 | 2022-04-03 | Middlesex | Virginia | 51119 | 1814 | 45 |
2369093 | 2369093 | 2022-04-02 | Middlesex | Virginia | 51119 | 1814 | 45 |
2365840 | 2365840 | 2022-04-01 | Middlesex | Virginia | 51119 | 1814 | 45 |
2362587 | 2362587 | 2022-03-31 | Middlesex | Virginia | 51119 | 1814 | 45 |
2290355 | 2290355 | 2022-03-09 | Arroyo | Puerto Rico | 72015 | 1814 | |
2263535 | 2263535 | 2022-03-01 | Hickory | Missouri | 29085 | 1814 | 54 |
2260284 | 2260284 | 2022-02-28 | Hickory | Missouri | 29085 | 1814 | 54 |
2257033 | 2257033 | 2022-02-27 | Hickory | Missouri | 29085 | 1814 | 54 |
2253782 | 2253782 | 2022-02-26 | Hickory | Missouri | 29085 | 1814 | 54 |
2250531 | 2250531 | 2022-02-25 | Hickory | Missouri | 29085 | 1814 | 54 |
2247280 | 2247280 | 2022-02-24 | Hickory | Missouri | 29085 | 1814 | 54 |
2238803 | 2238803 | 2022-02-21 | Rains | Texas | 48379 | 1814 | 56 |
2198618 | 2198618 | 2022-02-09 | Powell | Montana | 30077 | 1814 | 27 |
2188237 | 2188237 | 2022-02-06 | Elliott | Kentucky | 21063 | 1814 | 15 |
2184984 | 2184984 | 2022-02-05 | Elliott | Kentucky | 21063 | 1814 | 15 |
2181732 | 2181732 | 2022-02-04 | Elliott | Kentucky | 21063 | 1814 | 15 |
2171914 | 2171914 | 2022-02-01 | Pratt | Kansas | 20151 | 1814 | 30 |
2168661 | 2168661 | 2022-01-31 | Pratt | Kansas | 20151 | 1814 | 30 |
2154120 | 2154120 | 2022-01-26 | Floyd | Texas | 48153 | 1814 | 42 |
2145195 | 2145195 | 2022-01-24 | Lincoln | Colorado | 8073 | 1814 | 9 |
2141154 | 2141154 | 2022-01-22 | Jim Hogg | Texas | 48247 | 1814 | 20 |
2110787 | 2110787 | 2022-01-13 | Rosebud | Montana | 30087 | 1814 | 58 |
2108842 | 2108842 | 2022-01-12 | Essex | Virginia | 51057 | 1814 | 22 |
2101115 | 2101115 | 2022-01-10 | Phelps | Nebraska | 31137 | 1814 | 11 |
2065587 | 2065587 | 2021-12-30 | Perquimans | North Carolina | 37143 | 1814 | 16 |
2062334 | 2062334 | 2021-12-29 | Pamlico | North Carolina | 37137 | 1814 | 26 |
2057592 | 2057592 | 2021-12-28 | Long | Georgia | 13183 | 1814 | 29 |
2053904 | 2053904 | 2021-12-27 | Lowndes | Alabama | 1085 | 1814 | 68 |
2051605 | 2051605 | 2021-12-26 | Thomas | Kansas | 20193 | 1814 | 23 |
2048355 | 2048355 | 2021-12-25 | Thomas | Kansas | 20193 | 1814 | 23 |
2045105 | 2045105 | 2021-12-24 | Thomas | Kansas | 20193 | 1814 | 23 |
2041856 | 2041856 | 2021-12-23 | Thomas | Kansas | 20193 | 1814 | 23 |
2038606 | 2038606 | 2021-12-22 | Thomas | Kansas | 20193 | 1814 | 23 |
2035949 | 2035949 | 2021-12-21 | Ralls | Missouri | 29173 | 1814 | 19 |
2023732 | 2023732 | 2021-12-17 | Juana Diaz | Puerto Rico | 72075 | 1814 | |
2020773 | 2020773 | 2021-12-16 | Childress | Texas | 48075 | 1814 | 22 |
2013901 | 2013901 | 2021-12-14 | Forest | Pennsylvania | 42053 | 1814 | 30 |
1989986 | 1989986 | 2021-12-07 | Catahoula | Louisiana | 22025 | 1814 | 48 |
1986736 | 1986736 | 2021-12-06 | Catahoula | Louisiana | 22025 | 1814 | 48 |
1960114 | 1960114 | 2021-11-28 | Screven | Georgia | 13251 | 1814 | 62 |
1956863 | 1956863 | 2021-11-27 | Screven | Georgia | 13251 | 1814 | 62 |
1953612 | 1953612 | 2021-11-26 | Screven | Georgia | 13251 | 1814 | 62 |
1950361 | 1950361 | 2021-11-25 | Screven | Georgia | 13251 | 1814 | 62 |
1947110 | 1947110 | 2021-11-24 | Screven | Georgia | 13251 | 1814 | 62 |
1944809 | 1944809 | 2021-11-23 | Montgomery | Mississippi | 28097 | 1814 | 57 |
1925877 | 1925877 | 2021-11-17 | Mercer | North Dakota | 38057 | 1814 | 17 |
1918847 | 1918847 | 2021-11-15 | Barton | Missouri | 29011 | 1814 | 29 |
1914760 | 1914760 | 2021-11-14 | Menard | Illinois | 17129 | 1814 | 18 |
1915347 | 1915347 | 2021-11-14 | Benzie | Michigan | 26019 | 1814 | 41 |
1915597 | 1915597 | 2021-11-14 | Barton | Missouri | 29011 | 1814 | 29 |
1917342 | 1917342 | 2021-11-14 | Washakie | Wyoming | 56043 | 1814 | 35 |
1911510 | 1911510 | 2021-11-13 | Menard | Illinois | 17129 | 1814 | 18 |
1912097 | 1912097 | 2021-11-13 | Benzie | Michigan | 26019 | 1814 | 41 |
1914092 | 1914092 | 2021-11-13 | Washakie | Wyoming | 56043 | 1814 | 35 |
1908261 | 1908261 | 2021-11-12 | Menard | Illinois | 17129 | 1814 | 18 |
1908847 | 1908847 | 2021-11-12 | Benzie | Michigan | 26019 | 1814 | 41 |
1909499 | 1909499 | 2021-11-12 | Yates | New York | 36123 | 1814 | 30 |
1910842 | 1910842 | 2021-11-12 | Washakie | Wyoming | 56043 | 1814 | 35 |
1862121 | 1862121 | 2021-10-29 | Coosa | Alabama | 1037 | 1814 | 40 |
1858259 | 1858259 | 2021-10-27 | Callahan | Texas | 48059 | 1814 | 53 |
1841452 | 1841452 | 2021-10-22 | Harrison | Ohio | 39067 | 1814 | 46 |
1836379 | 1836379 | 2021-10-21 | Gunnison | Colorado | 8051 | 1814 | 11 |
1782405 | 1782405 | 2021-10-04 | Dent | Missouri | 29065 | 1814 | 33 |
1779155 | 1779155 | 2021-10-03 | Dent | Missouri | 29065 | 1814 | 33 |
1767758 | 1767758 | 2021-09-29 | Morgan | West Virginia | 54065 | 1814 | 31 |
1739603 | 1739603 | 2021-09-21 | Osage | Kansas | 20139 | 1814 | 32 |
1736354 | 1736354 | 2021-09-20 | Osage | Kansas | 20139 | 1814 | 32 |
1738532 | 1738532 | 2021-09-20 | Taylor | West Virginia | 54091 | 1814 | 29 |
1733795 | 1733795 | 2021-09-19 | Roosevelt | Montana | 30085 | 1814 | 57 |
1730545 | 1730545 | 2021-09-18 | Roosevelt | Montana | 30085 | 1814 | 57 |
1727295 | 1727295 | 2021-09-17 | Roosevelt | Montana | 30085 | 1814 | 57 |
1725367 | 1725367 | 2021-09-16 | Grayson | Virginia | 51077 | 1814 | 40 |
1702658 | 1702658 | 2021-09-09 | Martinsville city | Virginia | 51690 | 1814 | 81 |
1689012 | 1689012 | 2021-09-05 | Cidra | Puerto Rico | 72041 | 1814 | |
1672649 | 1672649 | 2021-08-31 | Crook | Oregon | 41013 | 1814 | 32 |
1667636 | 1667636 | 2021-08-30 | Jasper | Georgia | 13159 | 1814 | 41 |
1651048 | 1651048 | 2021-08-25 | Chicot | Arkansas | 5017 | 1814 | 42 |
1651693 | 1651693 | 2021-08-25 | Parke | Indiana | 18121 | 1814 | 18 |
1648735 | 1648735 | 2021-08-24 | Jackson | Kentucky | 21109 | 1814 | 32 |
1644587 | 1644587 | 2021-08-23 | Marion | Arkansas | 5089 | 1814 | 45 |
1626827 | 1626827 | 2021-08-17 | Schoharie | New York | 36095 | 1814 | 19 |
1600776 | 1600776 | 2021-08-09 | Grant | New Mexico | 35017 | 1814 | 42 |
1576612 | 1576612 | 2021-08-02 | Brantley | Georgia | 13025 | 1814 | 41 |
1574873 | 1574873 | 2021-08-01 | Bertie | North Carolina | 37015 | 1814 | 45 |
1571625 | 1571625 | 2021-07-31 | Bertie | North Carolina | 37015 | 1814 | 45 |
1568377 | 1568377 | 2021-07-30 | Bertie | North Carolina | 37015 | 1814 | 45 |
1557402 | 1557402 | 2021-07-27 | Richland | Illinois | 17159 | 1814 | 49 |
1550405 | 1550405 | 2021-07-25 | Sharp | Arkansas | 5135 | 1814 | 48 |
1541634 | 1541634 | 2021-07-22 | LaSalle | Louisiana | 22059 | 1814 | 38 |
1541911 | 1541911 | 2021-07-22 | Clarke | Mississippi | 28023 | 1814 | 80 |
1531253 | 1531253 | 2021-07-19 | Rabun | Georgia | 13241 | 1814 | 50 |
1533302 | 1533302 | 2021-07-19 | Grundy | Tennessee | 47061 | 1814 | 35 |
1529953 | 1529953 | 2021-07-18 | Saluda | South Carolina | 45081 | 1814 | 48 |
1526706 | 1526706 | 2021-07-17 | Saluda | South Carolina | 45081 | 1814 | 48 |
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);