ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
215 rows where deaths = 540 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- South Carolina 20
- Pennsylvania 15
- Arizona 12
- Florida 12
- Illinois 10
- Michigan 10
- New Mexico 10
- Alabama 9
- Oregon 9
- Indiana 8
- Mississippi 7
- Missouri 7
- North Carolina 7
- Ohio 7
- Oklahoma 7
- Louisiana 5
- Maryland 5
- Georgia 3
- Kentucky 3
- New Jersey 3
- New York 3
- Colorado 2
- Montana 2
- Tennessee 2
- Virginia 2
- Arkansas 1
- Delaware 1
- Idaho 1
- Kansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498572 | 2498572 | 2022-05-12 | Lane | Oregon | 41039 | 59691 | 540 |
2494852 | 2494852 | 2022-05-11 | Rockingham | New Hampshire | 33015 | 70065 | 540 |
2495314 | 2495314 | 2022-05-11 | Lane | Oregon | 41039 | 59524 | 540 |
2492056 | 2492056 | 2022-05-10 | Lane | Oregon | 41039 | 59436 | 540 |
2488798 | 2488798 | 2022-05-09 | Lane | Oregon | 41039 | 59275 | 540 |
2400386 | 2400386 | 2022-04-12 | Unknown | Nebraska | 2861 | 540 | |
2335816 | 2335816 | 2022-03-23 | Washington | Oregon | 41067 | 84952 | 540 |
2315701 | 2315701 | 2022-03-17 | Yellowstone | Montana | 30111 | 42742 | 540 |
2312448 | 2312448 | 2022-03-16 | Yellowstone | Montana | 30111 | 42731 | 540 |
2310198 | 2310198 | 2022-03-15 | Comal | Texas | 48091 | 33027 | 540 |
2306945 | 2306945 | 2022-03-14 | Comal | Texas | 48091 | 33003 | 540 |
2302453 | 2302453 | 2022-03-13 | DeSoto | Mississippi | 28033 | 49914 | 540 |
2303694 | 2303694 | 2022-03-13 | Comal | Texas | 48091 | 32999 | 540 |
2299201 | 2299201 | 2022-03-12 | DeSoto | Mississippi | 28033 | 49914 | 540 |
2300442 | 2300442 | 2022-03-12 | Comal | Texas | 48091 | 32994 | 540 |
2295949 | 2295949 | 2022-03-11 | DeSoto | Mississippi | 28033 | 49914 | 540 |
2297190 | 2297190 | 2022-03-11 | Comal | Texas | 48091 | 32976 | 540 |
2292697 | 2292697 | 2022-03-10 | DeSoto | Mississippi | 28033 | 49914 | 540 |
2293938 | 2293938 | 2022-03-10 | Comal | Texas | 48091 | 32701 | 540 |
2289445 | 2289445 | 2022-03-09 | DeSoto | Mississippi | 28033 | 49914 | 540 |
2286194 | 2286194 | 2022-03-08 | DeSoto | Mississippi | 28033 | 49914 | 540 |
2239335 | 2239335 | 2022-02-22 | Cochise | Arizona | 4003 | 30783 | 540 |
2241154 | 2241154 | 2022-02-22 | Buncombe | North Carolina | 37021 | 49706 | 540 |
2237903 | 2237903 | 2022-02-21 | Buncombe | North Carolina | 37021 | 49595 | 540 |
2233771 | 2233771 | 2022-02-20 | Fayette | Kentucky | 21067 | 91535 | 540 |
2230520 | 2230520 | 2022-02-19 | Fayette | Kentucky | 21067 | 91535 | 540 |
2227269 | 2227269 | 2022-02-18 | Fayette | Kentucky | 21067 | 91535 | 540 |
2220893 | 2220893 | 2022-02-16 | Rapides | Louisiana | 22079 | 32387 | 540 |
2212676 | 2212676 | 2022-02-13 | Ellis | Texas | 48139 | 47624 | 540 |
2202205 | 2202205 | 2022-02-10 | Rowan | North Carolina | 37159 | 39822 | 540 |
2198951 | 2198951 | 2022-02-09 | Rowan | North Carolina | 37159 | 39687 | 540 |
2194963 | 2194963 | 2022-02-08 | Bay | Michigan | 26017 | 26159 | 540 |
2191673 | 2191673 | 2022-02-07 | Harford | Maryland | 24025 | 36390 | 540 |
2191709 | 2191709 | 2022-02-07 | Bay | Michigan | 26017 | 26159 | 540 |
2188420 | 2188420 | 2022-02-06 | Harford | Maryland | 24025 | 36357 | 540 |
2188456 | 2188456 | 2022-02-06 | Bay | Michigan | 26017 | 26025 | 540 |
2185167 | 2185167 | 2022-02-05 | Harford | Maryland | 24025 | 36322 | 540 |
2185203 | 2185203 | 2022-02-05 | Bay | Michigan | 26017 | 26025 | 540 |
2181951 | 2181951 | 2022-02-04 | Bay | Michigan | 26017 | 26025 | 540 |
2171300 | 2171300 | 2022-02-01 | Leon | Florida | 12073 | 78130 | 540 |
2168047 | 2168047 | 2022-01-31 | Leon | Florida | 12073 | 78130 | 540 |
2170147 | 2170147 | 2022-01-31 | Pickens | South Carolina | 45077 | 43533 | 540 |
2164792 | 2164792 | 2022-01-30 | Leon | Florida | 12073 | 78130 | 540 |
2161537 | 2161537 | 2022-01-29 | Leon | Florida | 12073 | 78130 | 540 |
2158281 | 2158281 | 2022-01-28 | Leon | Florida | 12073 | 78130 | 540 |
2155028 | 2155028 | 2022-01-27 | Leon | Florida | 12073 | 73928 | 540 |
2151775 | 2151775 | 2022-01-26 | Leon | Florida | 12073 | 73928 | 540 |
2126562 | 2126562 | 2022-01-18 | Tangipahoa | Louisiana | 22105 | 28878 | 540 |
2119629 | 2119629 | 2022-01-16 | Johnson | Indiana | 18081 | 36113 | 540 |
2116377 | 2116377 | 2022-01-15 | Johnson | Indiana | 18081 | 36113 | 540 |
2113126 | 2113126 | 2022-01-14 | Johnson | Indiana | 18081 | 36113 | 540 |
2107710 | 2107710 | 2022-01-12 | McKinley | New Mexico | 35031 | 19250 | 540 |
2104459 | 2104459 | 2022-01-11 | McKinley | New Mexico | 35031 | 18996 | 540 |
2104955 | 2104955 | 2022-01-11 | Washington | Pennsylvania | 42125 | 40451 | 540 |
2058393 | 2058393 | 2021-12-28 | Kalamazoo | Michigan | 26077 | 39376 | 540 |
2059573 | 2059573 | 2021-12-28 | York | South Carolina | 45091 | 50178 | 540 |
2053958 | 2053958 | 2021-12-27 | Apache | Arizona | 4001 | 16070 | 540 |
2055144 | 2055144 | 2021-12-27 | Kalamazoo | Michigan | 26077 | 39376 | 540 |
2056324 | 2056324 | 2021-12-27 | York | South Carolina | 45091 | 50178 | 540 |
2050708 | 2050708 | 2021-12-26 | Apache | Arizona | 4001 | 16035 | 540 |
2053075 | 2053075 | 2021-12-26 | York | South Carolina | 45091 | 50178 | 540 |
2047458 | 2047458 | 2021-12-25 | Apache | Arizona | 4001 | 16035 | 540 |
2049825 | 2049825 | 2021-12-25 | York | South Carolina | 45091 | 50178 | 540 |
2044208 | 2044208 | 2021-12-24 | Apache | Arizona | 4001 | 16012 | 540 |
2046575 | 2046575 | 2021-12-24 | York | South Carolina | 45091 | 50178 | 540 |
2043325 | 2043325 | 2021-12-23 | York | South Carolina | 45091 | 50178 | 540 |
2040076 | 2040076 | 2021-12-22 | York | South Carolina | 45091 | 50083 | 540 |
2036826 | 2036826 | 2021-12-21 | York | South Carolina | 45091 | 50009 | 540 |
2033366 | 2033366 | 2021-12-20 | Marion | Oregon | 41047 | 41153 | 540 |
2033981 | 2033981 | 2021-12-20 | Wichita | Texas | 48485 | 22862 | 540 |
2030116 | 2030116 | 2021-12-19 | Marion | Oregon | 41047 | 41026 | 540 |
2030731 | 2030731 | 2021-12-19 | Wichita | Texas | 48485 | 22862 | 540 |
2026865 | 2026865 | 2021-12-18 | Marion | Oregon | 41047 | 41026 | 540 |
2027480 | 2027480 | 2021-12-18 | Wichita | Texas | 48485 | 22862 | 540 |
2023614 | 2023614 | 2021-12-17 | Marion | Oregon | 41047 | 41026 | 540 |
2012837 | 2012837 | 2021-12-14 | Barnstable | Massachusetts | 25001 | 21463 | 540 |
1976159 | 1976159 | 2021-12-03 | Weld | Colorado | 8123 | 53443 | 540 |
1972910 | 1972910 | 2021-12-02 | Weld | Colorado | 8123 | 53273 | 540 |
1961890 | 1961890 | 2021-11-28 | Erie | Pennsylvania | 42049 | 35493 | 540 |
1906167 | 1906167 | 2021-11-11 | Doña Ana | New Mexico | 35013 | 32507 | 540 |
1902918 | 1902918 | 2021-11-10 | Doña Ana | New Mexico | 35013 | 32507 | 540 |
1899668 | 1899668 | 2021-11-09 | Doña Ana | New Mexico | 35013 | 32295 | 540 |
1895167 | 1895167 | 2021-11-08 | Canyon | Idaho | 16027 | 42576 | 540 |
1896418 | 1896418 | 2021-11-08 | Doña Ana | New Mexico | 35013 | 32208 | 540 |
1892070 | 1892070 | 2021-11-07 | Elkhart | Indiana | 18039 | 36867 | 540 |
1893168 | 1893168 | 2021-11-07 | Doña Ana | New Mexico | 35013 | 31649 | 540 |
1893784 | 1893784 | 2021-11-07 | Florence | South Carolina | 45041 | 26748 | 540 |
1888820 | 1888820 | 2021-11-06 | Elkhart | Indiana | 18039 | 36867 | 540 |
1889918 | 1889918 | 2021-11-06 | Doña Ana | New Mexico | 35013 | 31649 | 540 |
1890534 | 1890534 | 2021-11-06 | Florence | South Carolina | 45041 | 26748 | 540 |
1885570 | 1885570 | 2021-11-05 | Elkhart | Indiana | 18039 | 36867 | 540 |
1886668 | 1886668 | 2021-11-05 | Doña Ana | New Mexico | 35013 | 31649 | 540 |
1887284 | 1887284 | 2021-11-05 | Florence | South Carolina | 45041 | 26748 | 540 |
1887539 | 1887539 | 2021-11-05 | Ector | Texas | 48135 | 25897 | 540 |
1882321 | 1882321 | 2021-11-04 | Elkhart | Indiana | 18039 | 36756 | 540 |
1883419 | 1883419 | 2021-11-04 | Doña Ana | New Mexico | 35013 | 31437 | 540 |
1874600 | 1874600 | 2021-11-01 | Johnson | Texas | 48251 | 28547 | 540 |
1871351 | 1871351 | 2021-10-31 | Johnson | Texas | 48251 | 28547 | 540 |
1868102 | 1868102 | 2021-10-30 | Johnson | Texas | 48251 | 28547 | 540 |
1864853 | 1864853 | 2021-10-29 | Johnson | Texas | 48251 | 28488 | 540 |
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);