ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where cases = 2834 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 15
- Alabama 12
- Louisiana 10
- Virginia 10
- Oklahoma 9
- Tennessee 9
- Texas 9
- Arkansas 8
- Rhode Island 7
- Kentucky 6
- Michigan 6
- Mississippi 6
- Puerto Rico 6
- Idaho 5
- Indiana 5
- North Carolina 5
- Ohio 5
- Georgia 4
- Minnesota 4
- Oregon 4
- South Dakota 4
- Colorado 3
- Illinois 3
- New Mexico 3
- Pennsylvania 3
- West Virginia 3
- Wisconsin 3
- California 2
- Iowa 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484473 | 2484473 | 2022-05-08 | West Feliciana | Louisiana | 22125 | 2834 | 46 |
2481215 | 2481215 | 2022-05-07 | West Feliciana | Louisiana | 22125 | 2834 | 46 |
2477957 | 2477957 | 2022-05-06 | West Feliciana | Louisiana | 22125 | 2834 | 46 |
2474699 | 2474699 | 2022-05-05 | West Feliciana | Louisiana | 22125 | 2834 | 46 |
2471442 | 2471442 | 2022-05-04 | West Feliciana | Louisiana | 22125 | 2834 | 46 |
2417265 | 2417265 | 2022-04-17 | Comerio | Puerto Rico | 72045 | 2834 | |
2313167 | 2313167 | 2022-03-16 | Orocovis | Puerto Rico | 72107 | 2834 | |
2252259 | 2252259 | 2022-02-26 | Conecuh | Alabama | 1035 | 2834 | 66 |
2247188 | 2247188 | 2022-02-24 | Jefferson Davis | Mississippi | 28065 | 2834 | 50 |
2236568 | 2236568 | 2022-02-21 | Gooding | Idaho | 16047 | 2834 | 52 |
2233317 | 2233317 | 2022-02-20 | Gooding | Idaho | 16047 | 2834 | 52 |
2230066 | 2230066 | 2022-02-19 | Gooding | Idaho | 16047 | 2834 | 52 |
2199858 | 2199858 | 2022-02-09 | Juab | Utah | 49023 | 2834 | 22 |
2193918 | 2193918 | 2022-02-08 | Mariposa | California | 6043 | 2834 | 20 |
2190474 | 2190474 | 2022-02-07 | Coosa | Alabama | 1037 | 2834 | 53 |
2110417 | 2110417 | 2022-01-13 | Leelanau | Michigan | 26089 | 2834 | 42 |
2107166 | 2107166 | 2022-01-12 | Leelanau | Michigan | 26089 | 2834 | 42 |
2107910 | 2107910 | 2022-01-12 | McKenzie | North Dakota | 38053 | 2834 | 23 |
2089633 | 2089633 | 2022-01-07 | Clay | Alabama | 1027 | 2834 | 69 |
2092500 | 2092500 | 2022-01-07 | Zavala | Texas | 48507 | 2834 | 56 |
2082611 | 2082611 | 2022-01-04 | Jackson | Texas | 48239 | 2834 | 52 |
2077281 | 2077281 | 2022-01-03 | Mercer | Illinois | 17131 | 2834 | 38 |
2078094 | 2078094 | 2022-01-03 | Smith | Mississippi | 28129 | 2834 | 54 |
2056567 | 2056567 | 2021-12-27 | Freestone | Texas | 48161 | 2834 | 73 |
2035755 | 2035755 | 2021-12-21 | Renville | Minnesota | 27129 | 2834 | 52 |
2032259 | 2032259 | 2021-12-20 | Jackson | Louisiana | 22049 | 2834 | 64 |
2026225 | 2026225 | 2021-12-18 | Wright | Missouri | 29229 | 2834 | 66 |
2001517 | 2001517 | 2021-12-10 | Caledonia | Vermont | 50005 | 2834 | 21 |
1992713 | 1992713 | 2021-12-08 | Cass | Illinois | 17017 | 2834 | 40 |
1974646 | 1974646 | 2021-12-02 | Richland | North Dakota | 38077 | 2834 | 21 |
1968299 | 1968299 | 2021-11-30 | Marshall | Oklahoma | 40095 | 2834 | 28 |
1965048 | 1965048 | 2021-11-29 | Marshall | Oklahoma | 40095 | 2834 | 28 |
1961796 | 1961796 | 2021-11-28 | Marshall | Oklahoma | 40095 | 2834 | 28 |
1958545 | 1958545 | 2021-11-27 | Marshall | Oklahoma | 40095 | 2834 | 28 |
1955294 | 1955294 | 2021-11-26 | Marshall | Oklahoma | 40095 | 2834 | 28 |
1952043 | 1952043 | 2021-11-25 | Marshall | Oklahoma | 40095 | 2834 | 28 |
1948792 | 1948792 | 2021-11-24 | Marshall | Oklahoma | 40095 | 2834 | 28 |
1940341 | 1940341 | 2021-11-22 | Alamosa | Colorado | 8003 | 2834 | 47 |
1916056 | 1916056 | 2021-11-14 | Madison | North Carolina | 37115 | 2834 | 61 |
1912806 | 1912806 | 2021-11-13 | Madison | North Carolina | 37115 | 2834 | 61 |
1909556 | 1909556 | 2021-11-12 | Madison | North Carolina | 37115 | 2834 | 61 |
1895176 | 1895176 | 2021-11-08 | Gem | Idaho | 16045 | 2834 | 62 |
1897128 | 1897128 | 2021-11-08 | Benton | Tennessee | 47005 | 2834 | 54 |
1893878 | 1893878 | 2021-11-07 | Benton | Tennessee | 47005 | 2834 | 54 |
1890628 | 1890628 | 2021-11-06 | Benton | Tennessee | 47005 | 2834 | 54 |
1887378 | 1887378 | 2021-11-05 | Benton | Tennessee | 47005 | 2834 | 54 |
1834381 | 1834381 | 2021-10-20 | Clinton | Missouri | 29049 | 2834 | 77 |
1815859 | 1815859 | 2021-10-14 | Hughes | South Dakota | 46065 | 2834 | 44 |
1774403 | 1774403 | 2021-10-02 | Fayette | Alabama | 1057 | 2834 | 74 |
1769464 | 1769464 | 2021-09-30 | Ray | Missouri | 29177 | 2834 | 46 |
1761232 | 1761232 | 2021-09-27 | Brooke | West Virginia | 54009 | 2834 | 66 |
1757130 | 1757130 | 2021-09-26 | Lincoln | Oregon | 41041 | 2834 | 30 |
1752842 | 1752842 | 2021-09-25 | Caroline | Maryland | 24011 | 2834 | 39 |
1753882 | 1753882 | 2021-09-25 | Lincoln | Oregon | 41041 | 2834 | 30 |
1750634 | 1750634 | 2021-09-24 | Lincoln | Oregon | 41041 | 2834 | 30 |
1730466 | 1730466 | 2021-09-18 | Perry | Missouri | 29157 | 2834 | 32 |
1703096 | 1703096 | 2021-09-10 | Colusa | California | 6011 | 2834 | 18 |
1694379 | 1694379 | 2021-09-07 | Somerset | Maryland | 24039 | 2834 | 44 |
1695562 | 1695562 | 2021-09-07 | Vega Alta | Puerto Rico | 72143 | 2834 | |
1683572 | 1683572 | 2021-09-04 | Phillips | Arkansas | 5107 | 2834 | 59 |
1676235 | 1676235 | 2021-09-01 | Johnson | Tennessee | 47091 | 2834 | 40 |
1652004 | 1652004 | 2021-08-25 | Marion | Kentucky | 21155 | 2834 | 39 |
1626202 | 1626202 | 2021-08-17 | Dickinson | Michigan | 26043 | 2834 | 74 |
1622955 | 1622955 | 2021-08-16 | Dickinson | Michigan | 26043 | 2834 | 74 |
1620540 | 1620540 | 2021-08-15 | Henry | Ohio | 39069 | 2834 | 67 |
1604992 | 1604992 | 2021-08-10 | Milam | Texas | 48331 | 2834 | 53 |
1588315 | 1588315 | 2021-08-05 | Dorado | Puerto Rico | 72051 | 2834 | |
1561423 | 1561423 | 2021-07-28 | Leake | Mississippi | 28079 | 2834 | 75 |
1469234 | 1469234 | 2021-06-30 | Sevier | Arkansas | 5133 | 2834 | 24 |
1465989 | 1465989 | 2021-06-29 | Sevier | Arkansas | 5133 | 2834 | 24 |
1442830 | 1442830 | 2021-06-21 | Halifax | Virginia | 51083 | 2834 | 78 |
1436672 | 1436672 | 2021-06-20 | Winston | Alabama | 1133 | 2834 | 72 |
1439585 | 1439585 | 2021-06-20 | Halifax | Virginia | 51083 | 2834 | 78 |
1433425 | 1433425 | 2021-06-19 | Winston | Alabama | 1133 | 2834 | 72 |
1436338 | 1436338 | 2021-06-19 | Halifax | Virginia | 51083 | 2834 | 78 |
1430179 | 1430179 | 2021-06-18 | Winston | Alabama | 1133 | 2834 | 72 |
1429845 | 1429845 | 2021-06-17 | Halifax | Virginia | 51083 | 2834 | 78 |
1426600 | 1426600 | 2021-06-16 | Halifax | Virginia | 51083 | 2834 | 78 |
1423354 | 1423354 | 2021-06-15 | Halifax | Virginia | 51083 | 2834 | 78 |
1420107 | 1420107 | 2021-06-14 | Halifax | Virginia | 51083 | 2834 | 78 |
1420266 | 1420266 | 2021-06-14 | Randolph | West Virginia | 54083 | 2834 | 15 |
1416862 | 1416862 | 2021-06-13 | Halifax | Virginia | 51083 | 2834 | 78 |
1404214 | 1404214 | 2021-06-10 | Winston | Alabama | 1133 | 2834 | 73 |
1400969 | 1400969 | 2021-06-09 | Winston | Alabama | 1133 | 2834 | 73 |
1379520 | 1379520 | 2021-06-02 | Cass | Minnesota | 27021 | 2834 | 32 |
1361820 | 1361820 | 2021-05-27 | Hancock | West Virginia | 54029 | 2834 | 89 |
1346455 | 1346455 | 2021-05-23 | Greene | Indiana | 18055 | 2834 | 89 |
1347314 | 1347314 | 2021-05-23 | Saline | Missouri | 29195 | 2834 | 38 |
1344066 | 1344066 | 2021-05-22 | Saline | Missouri | 29195 | 2834 | 38 |
1340817 | 1340817 | 2021-05-21 | Saline | Missouri | 29195 | 2834 | 38 |
1337570 | 1337570 | 2021-05-20 | Saline | Missouri | 29195 | 2834 | 38 |
1333286 | 1333286 | 2021-05-19 | Hawaii | Hawaii | 15001 | 2834 | 53 |
1327829 | 1327829 | 2021-05-17 | Saline | Missouri | 29195 | 2834 | 38 |
1324148 | 1324148 | 2021-05-16 | Morehouse | Louisiana | 22067 | 2834 | 77 |
1324583 | 1324583 | 2021-05-16 | Saline | Missouri | 29195 | 2834 | 38 |
1320902 | 1320902 | 2021-05-15 | Morehouse | Louisiana | 22067 | 2834 | 77 |
1321337 | 1321337 | 2021-05-15 | Saline | Missouri | 29195 | 2834 | 38 |
1317549 | 1317549 | 2021-05-14 | Harlan | Kentucky | 21095 | 2834 | 83 |
1317655 | 1317655 | 2021-05-14 | Morehouse | Louisiana | 22067 | 2834 | 77 |
1312294 | 1312294 | 2021-05-12 | Elk | Pennsylvania | 42047 | 2834 | 39 |
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);