ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
224 rows where deaths = 533 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 20
- Louisiana 19
- South Carolina 18
- Texas 18
- Missouri 15
- Arizona 14
- Alabama 13
- Florida 11
- New Mexico 11
- California 10
- Oregon 9
- Georgia 8
- Illinois 7
- Ohio 6
- Colorado 5
- Michigan 4
- North Carolina 4
- Kansas 3
- Montana 3
- New Jersey 3
- Tennessee 3
- Virginia 3
- Maryland 2
- Minnesota 2
- New York 2
- Arkansas 1
- Connecticut 1
- District of Columbia 1
- Idaho 1
- Indiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500976 | 2500976 | 2022-05-13 | St. Louis | Minnesota | 27137 | 48555 | 533 |
2495309 | 2495309 | 2022-05-11 | Jackson | Oregon | 41029 | 43463 | 533 |
2492051 | 2492051 | 2022-05-10 | Jackson | Oregon | 41029 | 43410 | 533 |
2488793 | 2488793 | 2022-05-09 | Jackson | Oregon | 41029 | 43372 | 533 |
2465998 | 2465998 | 2022-05-02 | Lane | Oregon | 41039 | 58544 | 533 |
2466063 | 2466063 | 2022-05-02 | Northumberland | Pennsylvania | 42097 | 22973 | 533 |
2462743 | 2462743 | 2022-05-01 | Lane | Oregon | 41039 | 58401 | 533 |
2462808 | 2462808 | 2022-05-01 | Northumberland | Pennsylvania | 42097 | 22969 | 533 |
2459487 | 2459487 | 2022-04-30 | Lane | Oregon | 41039 | 58401 | 533 |
2459552 | 2459552 | 2022-04-30 | Northumberland | Pennsylvania | 42097 | 22964 | 533 |
2456231 | 2456231 | 2022-04-29 | Lane | Oregon | 41039 | 58401 | 533 |
2456296 | 2456296 | 2022-04-29 | Northumberland | Pennsylvania | 42097 | 22952 | 533 |
2452975 | 2452975 | 2022-04-28 | Lane | Oregon | 41039 | 58326 | 533 |
2453040 | 2453040 | 2022-04-28 | Northumberland | Pennsylvania | 42097 | 22936 | 533 |
2449784 | 2449784 | 2022-04-27 | Northumberland | Pennsylvania | 42097 | 22919 | 533 |
2446527 | 2446527 | 2022-04-26 | Northumberland | Pennsylvania | 42097 | 22906 | 533 |
2443272 | 2443272 | 2022-04-25 | Northumberland | Pennsylvania | 42097 | 22893 | 533 |
2440016 | 2440016 | 2022-04-24 | Northumberland | Pennsylvania | 42097 | 22892 | 533 |
2436760 | 2436760 | 2022-04-23 | Northumberland | Pennsylvania | 42097 | 22889 | 533 |
2433504 | 2433504 | 2022-04-22 | Northumberland | Pennsylvania | 42097 | 22881 | 533 |
2430248 | 2430248 | 2022-04-21 | Northumberland | Pennsylvania | 42097 | 22877 | 533 |
2402165 | 2402165 | 2022-04-13 | Mesa | Colorado | 8077 | 42444 | 533 |
2336307 | 2336307 | 2022-03-23 | Kaufman | Texas | 48257 | 35125 | 533 |
2279927 | 2279927 | 2022-03-06 | Yellowstone | Montana | 30111 | 42611 | 533 |
2276674 | 2276674 | 2022-03-05 | Yellowstone | Montana | 30111 | 42611 | 533 |
2273421 | 2273421 | 2022-03-04 | Yellowstone | Montana | 30111 | 42611 | 533 |
2234652 | 2234652 | 2022-02-20 | Buncombe | North Carolina | 37021 | 49289 | 533 |
2231401 | 2231401 | 2022-02-19 | Buncombe | North Carolina | 37021 | 49289 | 533 |
2226331 | 2226331 | 2022-02-18 | Cochise | Arizona | 4003 | 30626 | 533 |
2228150 | 2228150 | 2022-02-18 | Buncombe | North Carolina | 37021 | 49289 | 533 |
2211139 | 2211139 | 2022-02-13 | Rapides | Louisiana | 22079 | 32225 | 533 |
2207886 | 2207886 | 2022-02-12 | Rapides | Louisiana | 22079 | 32225 | 533 |
2204633 | 2204633 | 2022-02-11 | Rapides | Louisiana | 22079 | 32225 | 533 |
2181925 | 2181925 | 2022-02-04 | Washington | Maryland | 24043 | 33054 | 533 |
2177665 | 2177665 | 2022-02-03 | Placer | California | 6061 | 65677 | 533 |
2177866 | 2177866 | 2022-02-03 | Cherokee | Georgia | 13057 | 61469 | 533 |
2175742 | 2175742 | 2022-02-02 | Jefferson | Missouri | 29099 | 51988 | 533 |
2172928 | 2172928 | 2022-02-01 | Rowan | North Carolina | 37159 | 38666 | 533 |
2148523 | 2148523 | 2022-01-25 | Leon | Florida | 12073 | 73928 | 533 |
2145271 | 2145271 | 2022-01-24 | Leon | Florida | 12073 | 73928 | 533 |
2142016 | 2142016 | 2022-01-23 | Leon | Florida | 12073 | 73928 | 533 |
2138761 | 2138761 | 2022-01-22 | Leon | Florida | 12073 | 73928 | 533 |
2135505 | 2135505 | 2022-01-21 | Leon | Florida | 12073 | 73928 | 533 |
2132253 | 2132253 | 2022-01-20 | Leon | Florida | 12073 | 68497 | 533 |
2128668 | 2128668 | 2022-01-19 | Etowah | Alabama | 1055 | 24230 | 533 |
2129000 | 2129000 | 2022-01-19 | Leon | Florida | 12073 | 68497 | 533 |
2125415 | 2125415 | 2022-01-18 | Etowah | Alabama | 1055 | 23805 | 533 |
2122163 | 2122163 | 2022-01-17 | Etowah | Alabama | 1055 | 23628 | 533 |
2118911 | 2118911 | 2022-01-16 | Etowah | Alabama | 1055 | 23514 | 533 |
2105833 | 2105833 | 2022-01-11 | Racine | Wisconsin | 55101 | 46684 | 533 |
2089627 | 2089627 | 2022-01-07 | Calhoun | Alabama | 1015 | 24507 | 533 |
2074537 | 2074537 | 2022-01-02 | Tangipahoa | Louisiana | 22105 | 24132 | 533 |
2071286 | 2071286 | 2022-01-01 | Tangipahoa | Louisiana | 22105 | 24132 | 533 |
2068035 | 2068035 | 2021-12-31 | Tangipahoa | Louisiana | 22105 | 24132 | 533 |
2064784 | 2064784 | 2021-12-30 | Tangipahoa | Louisiana | 22105 | 24132 | 533 |
2061534 | 2061534 | 2021-12-29 | Tangipahoa | Louisiana | 22105 | 23844 | 533 |
2062220 | 2062220 | 2021-12-29 | Dutchess | New York | 36027 | 44235 | 533 |
2062651 | 2062651 | 2021-12-29 | Fayette | Pennsylvania | 42051 | 22754 | 533 |
2058285 | 2058285 | 2021-12-28 | Tangipahoa | Louisiana | 22105 | 23575 | 533 |
2055036 | 2055036 | 2021-12-27 | Tangipahoa | Louisiana | 22105 | 23528 | 533 |
2051786 | 2051786 | 2021-12-26 | Tangipahoa | Louisiana | 22105 | 23382 | 533 |
2048536 | 2048536 | 2021-12-25 | Tangipahoa | Louisiana | 22105 | 23382 | 533 |
2045286 | 2045286 | 2021-12-24 | Tangipahoa | Louisiana | 22105 | 23382 | 533 |
2041328 | 2041328 | 2021-12-23 | Henry | Georgia | 13151 | 40860 | 533 |
2042037 | 2042037 | 2021-12-23 | Tangipahoa | Louisiana | 22105 | 23382 | 533 |
2042967 | 2042967 | 2021-12-23 | Lake | Ohio | 39085 | 37543 | 533 |
2038787 | 2038787 | 2021-12-22 | Tangipahoa | Louisiana | 22105 | 23335 | 533 |
2039718 | 2039718 | 2021-12-22 | Lake | Ohio | 39085 | 36964 | 533 |
2035537 | 2035537 | 2021-12-21 | Tangipahoa | Louisiana | 22105 | 23310 | 533 |
2036468 | 2036468 | 2021-12-21 | Lake | Ohio | 39085 | 36498 | 533 |
2032945 | 2032945 | 2021-12-20 | McKinley | New Mexico | 35031 | 17321 | 533 |
2033432 | 2033432 | 2021-12-20 | Schuylkill | Pennsylvania | 42107 | 24954 | 533 |
2030182 | 2030182 | 2021-12-19 | Schuylkill | Pennsylvania | 42107 | 24891 | 533 |
2026931 | 2026931 | 2021-12-18 | Schuylkill | Pennsylvania | 42107 | 24764 | 533 |
2007570 | 2007570 | 2021-12-12 | York | South Carolina | 45091 | 49084 | 533 |
2004319 | 2004319 | 2021-12-11 | York | South Carolina | 45091 | 49084 | 533 |
2001068 | 2001068 | 2021-12-10 | York | South Carolina | 45091 | 49084 | 533 |
1966410 | 1966410 | 2021-11-30 | Weld | Colorado | 8123 | 52884 | 533 |
1962468 | 1962468 | 2021-11-28 | Wichita | Texas | 48485 | 22236 | 533 |
1959217 | 1959217 | 2021-11-27 | Wichita | Texas | 48485 | 22236 | 533 |
1955966 | 1955966 | 2021-11-26 | Wichita | Texas | 48485 | 22236 | 533 |
1952715 | 1952715 | 2021-11-25 | Wichita | Texas | 48485 | 22236 | 533 |
1949464 | 1949464 | 2021-11-24 | Wichita | Texas | 48485 | 22236 | 533 |
1921914 | 1921914 | 2021-11-16 | St. Clair | Michigan | 26147 | 24298 | 533 |
1918664 | 1918664 | 2021-11-15 | St. Clair | Michigan | 26147 | 24084 | 533 |
1901324 | 1901324 | 2021-11-10 | Santa Barbara | California | 6083 | 46274 | 533 |
1877791 | 1877791 | 2021-11-02 | Ector | Texas | 48135 | 25822 | 533 |
1860200 | 1860200 | 2021-10-28 | Dakota | Minnesota | 27037 | 57930 | 533 |
1857427 | 1857427 | 2021-10-27 | Doña Ana | New Mexico | 35013 | 30395 | 533 |
1854178 | 1854178 | 2021-10-26 | Doña Ana | New Mexico | 35013 | 30346 | 533 |
1850929 | 1850929 | 2021-10-25 | Doña Ana | New Mexico | 35013 | 30278 | 533 |
1851857 | 1851857 | 2021-10-25 | Johnson | Texas | 48251 | 28219 | 533 |
1847679 | 1847679 | 2021-10-24 | Doña Ana | New Mexico | 35013 | 30015 | 533 |
1848607 | 1848607 | 2021-10-24 | Johnson | Texas | 48251 | 28219 | 533 |
1844429 | 1844429 | 2021-10-23 | Doña Ana | New Mexico | 35013 | 30015 | 533 |
1841179 | 1841179 | 2021-10-22 | Doña Ana | New Mexico | 35013 | 30015 | 533 |
1842073 | 1842073 | 2021-10-22 | Gregg | Texas | 48183 | 19123 | 533 |
1837930 | 1837930 | 2021-10-21 | Doña Ana | New Mexico | 35013 | 29916 | 533 |
1834681 | 1834681 | 2021-10-20 | Doña Ana | New Mexico | 35013 | 29818 | 533 |
1766465 | 1766465 | 2021-09-29 | San Juan | New Mexico | 35045 | 18352 | 533 |
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);