ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
199 rows where deaths = 542 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- California 28
- Texas 20
- Florida 19
- Pennsylvania 16
- Arizona 13
- Michigan 12
- South Carolina 11
- Montana 10
- New Mexico 10
- Georgia 7
- Virginia 7
- Massachusetts 4
- Hawaii 3
- Louisiana 3
- Mississippi 3
- New Hampshire 3
- New Jersey 3
- New York 3
- Alabama 2
- Illinois 2
- Indiana 2
- Maryland 2
- North Carolina 2
- Ohio 2
- Washington 2
- Arkansas 1
- Colorado 1
- Iowa 1
- Kansas 1
- Minnesota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501368 | 2501368 | 2022-05-13 | Rockingham | New Hampshire | 33015 | 70405 | 542 |
2348234 | 2348234 | 2022-03-27 | Yellowstone | Montana | 30111 | 42775 | 542 |
2344981 | 2344981 | 2022-03-26 | Yellowstone | Montana | 30111 | 42775 | 542 |
2341728 | 2341728 | 2022-03-25 | Yellowstone | Montana | 30111 | 42775 | 542 |
2338058 | 2338058 | 2022-03-24 | Berrien | Michigan | 26021 | 34571 | 542 |
2338475 | 2338475 | 2022-03-24 | Yellowstone | Montana | 30111 | 42769 | 542 |
2334804 | 2334804 | 2022-03-23 | Berrien | Michigan | 26021 | 34571 | 542 |
2335221 | 2335221 | 2022-03-23 | Yellowstone | Montana | 30111 | 42763 | 542 |
2331967 | 2331967 | 2022-03-22 | Yellowstone | Montana | 30111 | 42756 | 542 |
2328714 | 2328714 | 2022-03-21 | Yellowstone | Montana | 30111 | 42756 | 542 |
2325462 | 2325462 | 2022-03-20 | Yellowstone | Montana | 30111 | 42748 | 542 |
2322208 | 2322208 | 2022-03-19 | Yellowstone | Montana | 30111 | 42748 | 542 |
2318954 | 2318954 | 2022-03-18 | Yellowstone | Montana | 30111 | 42748 | 542 |
2316704 | 2316704 | 2022-03-17 | Comal | Texas | 48091 | 33185 | 542 |
2313451 | 2313451 | 2022-03-16 | Comal | Texas | 48091 | 33044 | 542 |
2247656 | 2247656 | 2022-02-24 | Buncombe | North Carolina | 37021 | 50004 | 542 |
2244405 | 2244405 | 2022-02-23 | Buncombe | North Carolina | 37021 | 49828 | 542 |
2230741 | 2230741 | 2022-02-19 | Calhoun | Michigan | 26025 | 33299 | 542 |
2227490 | 2227490 | 2022-02-18 | Calhoun | Michigan | 26025 | 33299 | 542 |
2224239 | 2224239 | 2022-02-17 | Calhoun | Michigan | 26025 | 33299 | 542 |
2220988 | 2220988 | 2022-02-16 | Calhoun | Michigan | 26025 | 33299 | 542 |
2194129 | 2194129 | 2022-02-08 | Cherokee | Georgia | 13057 | 62075 | 542 |
2189081 | 2189081 | 2022-02-06 | Niagara | New York | 36063 | 46384 | 542 |
2185828 | 2185828 | 2022-02-05 | Niagara | New York | 36063 | 46337 | 542 |
2176653 | 2176653 | 2022-02-02 | Pickens | South Carolina | 45077 | 43775 | 542 |
2173399 | 2173399 | 2022-02-01 | Pickens | South Carolina | 45077 | 43678 | 542 |
2131902 | 2131902 | 2022-01-20 | Calhoun | Alabama | 1015 | 27449 | 542 |
2129816 | 2129816 | 2022-01-19 | Tangipahoa | Louisiana | 22105 | 29205 | 542 |
2122881 | 2122881 | 2022-01-17 | Johnson | Indiana | 18081 | 37200 | 542 |
2117430 | 2117430 | 2022-01-15 | Cumberland | New Jersey | 34011 | 32368 | 542 |
2114710 | 2114710 | 2022-01-14 | Washington | Pennsylvania | 42125 | 42251 | 542 |
2110961 | 2110961 | 2022-01-13 | McKinley | New Mexico | 35031 | 19496 | 542 |
2111458 | 2111458 | 2022-01-13 | Washington | Pennsylvania | 42125 | 41803 | 542 |
2108206 | 2108206 | 2022-01-12 | Washington | Pennsylvania | 42125 | 41145 | 542 |
2105343 | 2105343 | 2022-01-11 | Grayson | Texas | 48181 | 19513 | 542 |
2102092 | 2102092 | 2022-01-10 | Grayson | Texas | 48181 | 19001 | 542 |
2098841 | 2098841 | 2022-01-09 | Grayson | Texas | 48181 | 18875 | 542 |
2095589 | 2095589 | 2022-01-08 | Grayson | Texas | 48181 | 18690 | 542 |
2085409 | 2085409 | 2022-01-05 | Fayette | Pennsylvania | 42051 | 23710 | 542 |
2076709 | 2076709 | 2022-01-03 | Apache | Arizona | 4001 | 16392 | 542 |
2073458 | 2073458 | 2022-01-02 | Apache | Arizona | 4001 | 16324 | 542 |
2070207 | 2070207 | 2022-01-01 | Apache | Arizona | 4001 | 16324 | 542 |
2066956 | 2066956 | 2021-12-31 | Apache | Arizona | 4001 | 16261 | 542 |
2063706 | 2063706 | 2021-12-30 | Apache | Arizona | 4001 | 16196 | 542 |
2056729 | 2056729 | 2021-12-27 | Wichita | Texas | 48485 | 23104 | 542 |
2036616 | 2036616 | 2021-12-21 | Marion | Oregon | 41047 | 41266 | 542 |
2016088 | 2016088 | 2021-12-15 | Barnstable | Massachusetts | 25001 | 21624 | 542 |
1965919 | 1965919 | 2021-11-29 | Clark | Washington | 53011 | 44887 | 542 |
1948896 | 1948896 | 2021-11-24 | Lackawanna | Pennsylvania | 42069 | 24908 | 542 |
1927321 | 1927321 | 2021-11-18 | Santa Barbara | California | 6083 | 46717 | 542 |
1925665 | 1925665 | 2021-11-17 | Doña Ana | New Mexico | 35013 | 33934 | 542 |
1920890 | 1920890 | 2021-11-16 | Pueblo | Colorado | 8101 | 28175 | 542 |
1922416 | 1922416 | 2021-11-16 | Doña Ana | New Mexico | 35013 | 33699 | 542 |
1919166 | 1919166 | 2021-11-15 | Doña Ana | New Mexico | 35013 | 33526 | 542 |
1915916 | 1915916 | 2021-11-14 | Doña Ana | New Mexico | 35013 | 32966 | 542 |
1912666 | 1912666 | 2021-11-13 | Doña Ana | New Mexico | 35013 | 32966 | 542 |
1909416 | 1909416 | 2021-11-12 | Doña Ana | New Mexico | 35013 | 32966 | 542 |
1906783 | 1906783 | 2021-11-11 | Florence | South Carolina | 45041 | 26800 | 542 |
1903534 | 1903534 | 2021-11-10 | Florence | South Carolina | 45041 | 26800 | 542 |
1900284 | 1900284 | 2021-11-09 | Florence | South Carolina | 45041 | 26795 | 542 |
1897034 | 1897034 | 2021-11-08 | Florence | South Carolina | 45041 | 26789 | 542 |
1879694 | 1879694 | 2021-11-03 | Dakota | Minnesota | 27037 | 59586 | 542 |
1877849 | 1877849 | 2021-11-02 | Johnson | Texas | 48251 | 28849 | 542 |
1870040 | 1870040 | 2021-10-31 | Harrison | Mississippi | 28047 | 34446 | 542 |
1866791 | 1866791 | 2021-10-30 | Harrison | Mississippi | 28047 | 34446 | 542 |
1863542 | 1863542 | 2021-10-29 | Harrison | Mississippi | 28047 | 34446 | 542 |
1851952 | 1851952 | 2021-10-25 | Taylor | Texas | 48441 | 22839 | 542 |
1852059 | 1852059 | 2021-10-25 | Chesterfield | Virginia | 51041 | 39360 | 542 |
1846225 | 1846225 | 2021-10-24 | Okaloosa | Florida | 12091 | 34287 | 542 |
1848702 | 1848702 | 2021-10-24 | Taylor | Texas | 48441 | 22777 | 542 |
1848907 | 1848907 | 2021-10-24 | Virginia Beach city | Virginia | 51810 | 49353 | 542 |
1842975 | 1842975 | 2021-10-23 | Okaloosa | Florida | 12091 | 34287 | 542 |
1845657 | 1845657 | 2021-10-23 | Virginia Beach city | Virginia | 51810 | 49353 | 542 |
1839725 | 1839725 | 2021-10-22 | Okaloosa | Florida | 12091 | 34287 | 542 |
1842407 | 1842407 | 2021-10-22 | Virginia Beach city | Virginia | 51810 | 49353 | 542 |
1836476 | 1836476 | 2021-10-21 | Okaloosa | Florida | 12091 | 34174 | 542 |
1833227 | 1833227 | 2021-10-20 | Okaloosa | Florida | 12091 | 34174 | 542 |
1829978 | 1829978 | 2021-10-19 | Okaloosa | Florida | 12091 | 34174 | 542 |
1826729 | 1826729 | 2021-10-18 | Okaloosa | Florida | 12091 | 34174 | 542 |
1824950 | 1824950 | 2021-10-17 | San Juan | New Mexico | 35045 | 20008 | 542 |
1821701 | 1821701 | 2021-10-16 | San Juan | New Mexico | 35045 | 20008 | 542 |
1818452 | 1818452 | 2021-10-15 | San Juan | New Mexico | 35045 | 20008 | 542 |
1816177 | 1816177 | 2021-10-14 | Potter | Texas | 48375 | 23015 | 542 |
1739190 | 1739190 | 2021-09-21 | Honolulu | Hawaii | 15003 | 53133 | 542 |
1735941 | 1735941 | 2021-09-20 | Honolulu | Hawaii | 15003 | 52936 | 542 |
1732691 | 1732691 | 2021-09-19 | Honolulu | Hawaii | 15003 | 52646 | 542 |
1716307 | 1716307 | 2021-09-14 | Chatham | Georgia | 13051 | 36065 | 542 |
1709513 | 1709513 | 2021-09-12 | Benton | Arkansas | 5007 | 39211 | 542 |
1692617 | 1692617 | 2021-09-06 | Galveston | Texas | 48167 | 56239 | 542 |
1686048 | 1686048 | 2021-09-04 | Bell | Texas | 48027 | 33029 | 542 |
1677122 | 1677122 | 2021-09-02 | Monterey | California | 6053 | 48187 | 542 |
1673875 | 1673875 | 2021-09-01 | Monterey | California | 6053 | 48005 | 542 |
1670627 | 1670627 | 2021-08-31 | Monterey | California | 6053 | 47918 | 542 |
1667380 | 1667380 | 2021-08-30 | Monterey | California | 6053 | 47879 | 542 |
1669451 | 1669451 | 2021-08-30 | Cumberland | Pennsylvania | 42041 | 22284 | 542 |
1664133 | 1664133 | 2021-08-29 | Monterey | California | 6053 | 47849 | 542 |
1666204 | 1666204 | 2021-08-29 | Cumberland | Pennsylvania | 42041 | 22239 | 542 |
1660885 | 1660885 | 2021-08-28 | Monterey | California | 6053 | 47792 | 542 |
1662956 | 1662956 | 2021-08-28 | Cumberland | Pennsylvania | 42041 | 22138 | 542 |
1657637 | 1657637 | 2021-08-27 | Monterey | California | 6053 | 47720 | 542 |
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);