ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
131 rows where cases = 3676 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 18
- Georgia 11
- Kentucky 11
- Michigan 9
- Oklahoma 8
- Virginia 8
- Mississippi 6
- Arkansas 4
- Minnesota 4
- Missouri 4
- Ohio 4
- Pennsylvania 4
- Tennessee 4
- Indiana 3
- Maine 3
- Wisconsin 3
- California 2
- Colorado 2
- Idaho 2
- Iowa 2
- Maryland 2
- Nebraska 2
- New York 2
- Puerto Rico 2
- South Carolina 2
- West Virginia 2
- Florida 1
- Louisiana 1
- Montana 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490381 | 2490381 | 2022-05-10 | Gem | Idaho | 16045 | 3676 | 79 |
2487124 | 2487124 | 2022-05-09 | Gem | Idaho | 16045 | 3676 | 79 |
2453398 | 2453398 | 2022-04-28 | Comanche | Texas | 48093 | 3676 | 78 |
2438205 | 2438205 | 2022-04-24 | Rabun | Georgia | 13241 | 3676 | 97 |
2434949 | 2434949 | 2022-04-23 | Rabun | Georgia | 13241 | 3676 | 97 |
2431693 | 2431693 | 2022-04-22 | Rabun | Georgia | 13241 | 3676 | 97 |
2428437 | 2428437 | 2022-04-21 | Rabun | Georgia | 13241 | 3676 | 97 |
2425181 | 2425181 | 2022-04-20 | Rabun | Georgia | 13241 | 3676 | 97 |
2417788 | 2417788 | 2022-04-17 | Zapata | Texas | 48505 | 3676 | 55 |
2414532 | 2414532 | 2022-04-16 | Zapata | Texas | 48505 | 3676 | 55 |
2411276 | 2411276 | 2022-04-15 | Zapata | Texas | 48505 | 3676 | 55 |
2408020 | 2408020 | 2022-04-14 | Zapata | Texas | 48505 | 3676 | 55 |
2404764 | 2404764 | 2022-04-13 | Zapata | Texas | 48505 | 3676 | 55 |
2401509 | 2401509 | 2022-04-12 | Zapata | Texas | 48505 | 3676 | 55 |
2398254 | 2398254 | 2022-04-11 | Zapata | Texas | 48505 | 3676 | 55 |
2358716 | 2358716 | 2022-03-30 | Quebradillas | Puerto Rico | 72115 | 3676 | |
2281262 | 2281262 | 2022-03-06 | Manassas Park city | Virginia | 51685 | 3676 | 25 |
2278009 | 2278009 | 2022-03-05 | Manassas Park city | Virginia | 51685 | 3676 | 25 |
2274756 | 2274756 | 2022-03-04 | Manassas Park city | Virginia | 51685 | 3676 | 25 |
2268251 | 2268251 | 2022-03-02 | Manassas Park city | Virginia | 51685 | 3676 | 25 |
2244047 | 2244047 | 2022-02-23 | Livingston | Missouri | 29117 | 3676 | 88 |
2216343 | 2216343 | 2022-02-14 | Grant | West Virginia | 54023 | 3676 | 52 |
2191475 | 2191475 | 2022-02-07 | Caldwell | Kentucky | 21033 | 3676 | 57 |
2169337 | 2169337 | 2022-01-31 | Park | Montana | 30067 | 3676 | 34 |
2160570 | 2160570 | 2022-01-28 | Bosque | Texas | 48035 | 3676 | 61 |
2100479 | 2100479 | 2022-01-10 | Rockcastle | Kentucky | 21203 | 3676 | 48 |
2100983 | 2100983 | 2022-01-10 | Texas | Missouri | 29215 | 3676 | 74 |
2084537 | 2084537 | 2022-01-05 | Attala | Mississippi | 28007 | 3676 | 90 |
2074622 | 2074622 | 2022-01-02 | Cheboygan | Michigan | 26031 | 3676 | 80 |
2071371 | 2071371 | 2022-01-01 | Cheboygan | Michigan | 26031 | 3676 | 80 |
2068120 | 2068120 | 2021-12-31 | Cheboygan | Michigan | 26031 | 3676 | 80 |
2064869 | 2064869 | 2021-12-30 | Cheboygan | Michigan | 26031 | 3676 | 80 |
2061619 | 2061619 | 2021-12-29 | Cheboygan | Michigan | 26031 | 3676 | 80 |
2051099 | 2051099 | 2021-12-26 | McDuffie | Georgia | 13189 | 3676 | 79 |
2051720 | 2051720 | 2021-12-26 | Simpson | Kentucky | 21213 | 3676 | 71 |
2047849 | 2047849 | 2021-12-25 | McDuffie | Georgia | 13189 | 3676 | 79 |
2048470 | 2048470 | 2021-12-25 | Simpson | Kentucky | 21213 | 3676 | 71 |
2044599 | 2044599 | 2021-12-24 | McDuffie | Georgia | 13189 | 3676 | 79 |
2045220 | 2045220 | 2021-12-24 | Simpson | Kentucky | 21213 | 3676 | 71 |
2041971 | 2041971 | 2021-12-23 | Simpson | Kentucky | 21213 | 3676 | 71 |
2038721 | 2038721 | 2021-12-22 | Simpson | Kentucky | 21213 | 3676 | 71 |
2029343 | 2029343 | 2021-12-19 | Stone | Mississippi | 28131 | 3676 | 66 |
2026092 | 2026092 | 2021-12-18 | Stone | Mississippi | 28131 | 3676 | 66 |
2022841 | 2022841 | 2021-12-17 | Stone | Mississippi | 28131 | 3676 | 66 |
2024061 | 2024061 | 2021-12-17 | Fayette | Texas | 48149 | 3676 | 94 |
2018644 | 2018644 | 2021-12-16 | Unknown | Georgia | 3676 | 6 | |
2014528 | 2014528 | 2021-12-14 | Orleans | Vermont | 50019 | 3676 | 27 |
1991872 | 1991872 | 2021-12-07 | Page | Virginia | 51139 | 3676 | 89 |
1972125 | 1972125 | 2021-12-01 | Limestone | Texas | 48293 | 3676 | 111 |
1953248 | 1953248 | 2021-11-26 | Lincoln | Arkansas | 5079 | 3676 | 57 |
1949997 | 1949997 | 2021-11-25 | Lincoln | Arkansas | 5079 | 3676 | 57 |
1941309 | 1941309 | 2021-11-22 | Garrett | Maryland | 24023 | 3676 | 86 |
1923582 | 1923582 | 2021-11-16 | Hopewell city | Virginia | 51670 | 3676 | 88 |
1915361 | 1915361 | 2021-11-14 | Emmet | Michigan | 26047 | 3676 | 53 |
1912111 | 1912111 | 2021-11-13 | Emmet | Michigan | 26047 | 3676 | 53 |
1908861 | 1908861 | 2021-11-12 | Emmet | Michigan | 26047 | 3676 | 53 |
1896094 | 1896094 | 2021-11-08 | Adair | Missouri | 29001 | 3676 | 35 |
1897585 | 1897585 | 2021-11-08 | Hopewell city | Virginia | 51670 | 3676 | 89 |
1869705 | 1869705 | 2021-10-31 | Rowan | Kentucky | 21205 | 3676 | 28 |
1866456 | 1866456 | 2021-10-30 | Rowan | Kentucky | 21205 | 3676 | 28 |
1863207 | 1863207 | 2021-10-29 | Rowan | Kentucky | 21205 | 3676 | 28 |
1839103 | 1839103 | 2021-10-21 | Lee | Virginia | 51105 | 3676 | 59 |
1833053 | 1833053 | 2021-10-20 | Del Norte | California | 6015 | 3676 | 42 |
1810579 | 1810579 | 2021-10-13 | Harris | Georgia | 13145 | 3676 | 83 |
1730973 | 1730973 | 2021-09-18 | Fayette | Ohio | 39047 | 3676 | 52 |
1695282 | 1695282 | 2021-09-07 | Perry | Ohio | 39127 | 3676 | 50 |
1669032 | 1669032 | 2021-08-30 | Greene | New York | 36039 | 3676 | 82 |
1654320 | 1654320 | 2021-08-26 | Jackson | Arkansas | 5067 | 3676 | 41 |
1653468 | 1653468 | 2021-08-25 | Claiborne | Tennessee | 47025 | 3676 | 79 |
1649583 | 1649583 | 2021-08-24 | Wyoming | New York | 36121 | 3676 | 53 |
1650221 | 1650221 | 2021-08-24 | Claiborne | Tennessee | 47025 | 3676 | 79 |
1642517 | 1642517 | 2021-08-22 | Carlton | Minnesota | 27017 | 3676 | 59 |
1639267 | 1639267 | 2021-08-21 | Carlton | Minnesota | 27017 | 3676 | 59 |
1636017 | 1636017 | 2021-08-20 | Carlton | Minnesota | 27017 | 3676 | 59 |
1631918 | 1631918 | 2021-08-19 | Madison | Georgia | 13195 | 3676 | 57 |
1622464 | 1622464 | 2021-08-16 | Ripley | Indiana | 18137 | 3676 | 72 |
1608149 | 1608149 | 2021-08-11 | Fannin | Texas | 48147 | 3676 | 111 |
1580914 | 1580914 | 2021-08-03 | Leflore | Mississippi | 28083 | 3676 | 125 |
1582021 | 1582021 | 2021-08-03 | Hardeman | Tennessee | 47069 | 3676 | 64 |
1554669 | 1554669 | 2021-07-26 | Oxford | Maine | 23017 | 3676 | 70 |
1551422 | 1551422 | 2021-07-25 | Oxford | Maine | 23017 | 3676 | 70 |
1553442 | 1553442 | 2021-07-25 | Trempealeau | Wisconsin | 55121 | 3676 | 48 |
1548175 | 1548175 | 2021-07-24 | Oxford | Maine | 23017 | 3676 | 70 |
1550195 | 1550195 | 2021-07-24 | Trempealeau | Wisconsin | 55121 | 3676 | 48 |
1546948 | 1546948 | 2021-07-23 | Trempealeau | Wisconsin | 55121 | 3676 | 48 |
1517088 | 1517088 | 2021-07-14 | Macon | Tennessee | 47111 | 3676 | 78 |
1448658 | 1448658 | 2021-06-23 | Snyder | Pennsylvania | 42109 | 3676 | 85 |
1438923 | 1438923 | 2021-06-20 | Snyder | Pennsylvania | 42109 | 3676 | 85 |
1424762 | 1424762 | 2021-06-16 | Evangeline | Louisiana | 22039 | 3676 | 95 |
1401947 | 1401947 | 2021-06-09 | Greenup | Kentucky | 21089 | 3676 | 63 |
1387103 | 1387103 | 2021-06-04 | Colleton | South Carolina | 45029 | 3676 | 129 |
1376549 | 1376549 | 2021-06-01 | Webster | Missouri | 29225 | 3676 | 54 |
1280259 | 1280259 | 2021-05-02 | Grimes | Texas | 48185 | 3676 | 69 |
1274600 | 1274600 | 2021-05-01 | Summit | Colorado | 8117 | 3676 | 7 |
1277012 | 1277012 | 2021-05-01 | Grimes | Texas | 48185 | 3676 | 69 |
1266629 | 1266629 | 2021-04-28 | Clinton | Ohio | 39027 | 3676 | 60 |
1238404 | 1238404 | 2021-04-19 | Grays Harbor | Washington | 53027 | 3676 | 60 |
1234412 | 1234412 | 2021-04-18 | Wayne | Pennsylvania | 42127 | 3676 | 76 |
1195313 | 1195313 | 2021-04-06 | Okmulgee | Oklahoma | 40111 | 3676 | 53 |
1192065 | 1192065 | 2021-04-05 | Okmulgee | Oklahoma | 40111 | 3676 | 53 |
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);