ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
201 rows where deaths = 549 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- Pennsylvania 17
- Georgia 15
- Wisconsin 14
- Illinois 10
- Missouri 10
- Indiana 9
- Michigan 9
- Florida 8
- Delaware 7
- Louisiana 7
- Montana 7
- Ohio 7
- Virginia 7
- South Carolina 6
- New Jersey 5
- Arizona 4
- California 4
- North Carolina 4
- Oregon 4
- Tennessee 4
- Alabama 3
- Iowa 3
- West Virginia 3
- Idaho 2
- Maryland 2
- New York 2
- Washington 2
- Colorado 1
- Kansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465416 | 2465416 | 2022-05-02 | Yellowstone | Montana | 30111 | 42982 | 549 |
2466420 | 2466420 | 2022-05-02 | Comal | Texas | 48091 | 34462 | 549 |
2462161 | 2462161 | 2022-05-01 | Yellowstone | Montana | 30111 | 42966 | 549 |
2463165 | 2463165 | 2022-05-01 | Comal | Texas | 48091 | 34454 | 549 |
2458905 | 2458905 | 2022-04-30 | Yellowstone | Montana | 30111 | 42966 | 549 |
2459909 | 2459909 | 2022-04-30 | Comal | Texas | 48091 | 34452 | 549 |
2455649 | 2455649 | 2022-04-29 | Yellowstone | Montana | 30111 | 42966 | 549 |
2456653 | 2456653 | 2022-04-29 | Comal | Texas | 48091 | 34426 | 549 |
2452393 | 2452393 | 2022-04-28 | Yellowstone | Montana | 30111 | 42958 | 549 |
2453397 | 2453397 | 2022-04-28 | Comal | Texas | 48091 | 34402 | 549 |
2449137 | 2449137 | 2022-04-27 | Yellowstone | Montana | 30111 | 42955 | 549 |
2450141 | 2450141 | 2022-04-27 | Comal | Texas | 48091 | 34351 | 549 |
2445880 | 2445880 | 2022-04-26 | Yellowstone | Montana | 30111 | 42942 | 549 |
2424581 | 2424581 | 2022-04-19 | Brown | Wisconsin | 55009 | 84268 | 549 |
2421325 | 2421325 | 2022-04-18 | Brown | Wisconsin | 55009 | 84242 | 549 |
2418069 | 2418069 | 2022-04-17 | Brown | Wisconsin | 55009 | 84190 | 549 |
2414813 | 2414813 | 2022-04-16 | Brown | Wisconsin | 55009 | 84190 | 549 |
2411557 | 2411557 | 2022-04-15 | Brown | Wisconsin | 55009 | 84190 | 549 |
2408301 | 2408301 | 2022-04-14 | Brown | Wisconsin | 55009 | 84152 | 549 |
2403961 | 2403961 | 2022-04-13 | Clermont | Ohio | 39025 | 51283 | 549 |
2405045 | 2405045 | 2022-04-13 | Brown | Wisconsin | 55009 | 84125 | 549 |
2399882 | 2399882 | 2022-04-12 | Berrien | Michigan | 26021 | 34682 | 549 |
2400706 | 2400706 | 2022-04-12 | Clermont | Ohio | 39025 | 51283 | 549 |
2396626 | 2396626 | 2022-04-11 | Berrien | Michigan | 26021 | 34682 | 549 |
2397451 | 2397451 | 2022-04-11 | Clermont | Ohio | 39025 | 51283 | 549 |
2393371 | 2393371 | 2022-04-10 | Berrien | Michigan | 26021 | 34682 | 549 |
2394196 | 2394196 | 2022-04-10 | Clermont | Ohio | 39025 | 51283 | 549 |
2390115 | 2390115 | 2022-04-09 | Berrien | Michigan | 26021 | 34682 | 549 |
2390940 | 2390940 | 2022-04-09 | Clermont | Ohio | 39025 | 51283 | 549 |
2386859 | 2386859 | 2022-04-08 | Berrien | Michigan | 26021 | 34682 | 549 |
2387684 | 2387684 | 2022-04-08 | Clermont | Ohio | 39025 | 51283 | 549 |
2383604 | 2383604 | 2022-04-07 | Berrien | Michigan | 26021 | 34682 | 549 |
2384429 | 2384429 | 2022-04-07 | Clermont | Ohio | 39025 | 51283 | 549 |
2380349 | 2380349 | 2022-04-06 | Berrien | Michigan | 26021 | 34682 | 549 |
2352081 | 2352081 | 2022-03-28 | Washington | Oregon | 41067 | 84928 | 549 |
2305009 | 2305009 | 2022-03-14 | Hendricks | Indiana | 18063 | 40715 | 549 |
2303255 | 2303255 | 2022-03-13 | Clackamas | Oregon | 41005 | 59482 | 549 |
2300003 | 2300003 | 2022-03-12 | Clackamas | Oregon | 41005 | 59482 | 549 |
2296751 | 2296751 | 2022-03-11 | Clackamas | Oregon | 41005 | 59482 | 549 |
2292001 | 2292001 | 2022-03-10 | Hendricks | Indiana | 18063 | 40698 | 549 |
2288749 | 2288749 | 2022-03-09 | Hendricks | Indiana | 18063 | 40691 | 549 |
2285498 | 2285498 | 2022-03-08 | Hendricks | Indiana | 18063 | 40684 | 549 |
2239911 | 2239911 | 2022-02-22 | Peoria | Illinois | 17143 | 45776 | 549 |
2234721 | 2234721 | 2022-02-20 | Rowan | North Carolina | 37159 | 40449 | 549 |
2231470 | 2231470 | 2022-02-19 | Rowan | North Carolina | 37159 | 40449 | 549 |
2228219 | 2228219 | 2022-02-18 | Rowan | North Carolina | 37159 | 40449 | 549 |
2217066 | 2217066 | 2022-02-15 | Kootenai | Idaho | 16055 | 38304 | 549 |
2215107 | 2215107 | 2022-02-14 | Niagara | New York | 36063 | 46803 | 549 |
2210396 | 2210396 | 2022-02-13 | Cherokee | Georgia | 13057 | 62348 | 549 |
2207143 | 2207143 | 2022-02-12 | Cherokee | Georgia | 13057 | 62348 | 549 |
2203890 | 2203890 | 2022-02-11 | Cherokee | Georgia | 13057 | 62348 | 549 |
2201435 | 2201435 | 2022-02-10 | Harford | Maryland | 24025 | 36537 | 549 |
2179904 | 2179904 | 2022-02-03 | Pickens | South Carolina | 45077 | 43978 | 549 |
2155844 | 2155844 | 2022-01-27 | Tangipahoa | Louisiana | 22105 | 32427 | 549 |
2152591 | 2152591 | 2022-01-26 | Tangipahoa | Louisiana | 22105 | 32237 | 549 |
2148951 | 2148951 | 2022-01-25 | Vanderburgh | Indiana | 18163 | 51143 | 549 |
2147186 | 2147186 | 2022-01-24 | Blair | Pennsylvania | 42013 | 26668 | 549 |
2136945 | 2136945 | 2022-01-21 | Cumberland | New Jersey | 34011 | 34756 | 549 |
2137865 | 2137865 | 2022-01-21 | Grayson | Texas | 48181 | 23593 | 549 |
2133693 | 2133693 | 2022-01-20 | Cumberland | New Jersey | 34011 | 34359 | 549 |
2127717 | 2127717 | 2022-01-18 | Washington | Pennsylvania | 42125 | 44278 | 549 |
2112336 | 2112336 | 2022-01-13 | Racine | Wisconsin | 55101 | 48399 | 549 |
2106630 | 2106630 | 2022-01-12 | Madison | Indiana | 18095 | 26803 | 549 |
2109084 | 2109084 | 2022-01-12 | Racine | Wisconsin | 55101 | 47558 | 549 |
2099471 | 2099471 | 2022-01-10 | Apache | Arizona | 4001 | 17105 | 549 |
2096220 | 2096220 | 2022-01-09 | Apache | Arizona | 4001 | 17005 | 549 |
2079482 | 2079482 | 2022-01-03 | Wichita | Texas | 48485 | 23740 | 549 |
2065903 | 2065903 | 2021-12-30 | Franklin | Pennsylvania | 42055 | 29444 | 549 |
2056180 | 2056180 | 2021-12-27 | Schuylkill | Pennsylvania | 42107 | 25626 | 549 |
2052931 | 2052931 | 2021-12-26 | Schuylkill | Pennsylvania | 42107 | 25560 | 549 |
2049681 | 2049681 | 2021-12-25 | Schuylkill | Pennsylvania | 42107 | 25477 | 549 |
2046431 | 2046431 | 2021-12-24 | Schuylkill | Pennsylvania | 42107 | 25369 | 549 |
1992410 | 1992410 | 2021-12-08 | Weld | Colorado | 8123 | 54259 | 549 |
1985471 | 1985471 | 2021-12-05 | Kanawha | West Virginia | 54039 | 27019 | 549 |
1982221 | 1982221 | 2021-12-04 | Kanawha | West Virginia | 54039 | 26963 | 549 |
1978971 | 1978971 | 2021-12-03 | Kanawha | West Virginia | 54039 | 26878 | 549 |
1972989 | 1972989 | 2021-12-02 | Unknown | Florida | 8782 | 549 | |
1974902 | 1974902 | 2021-12-02 | Lackawanna | Pennsylvania | 42069 | 25733 | 549 |
1975668 | 1975668 | 2021-12-02 | Clark | Washington | 53011 | 45443 | 549 |
1971628 | 1971628 | 2021-12-01 | Butler | Pennsylvania | 42019 | 29058 | 549 |
1971653 | 1971653 | 2021-12-01 | Lackawanna | Pennsylvania | 42069 | 25592 | 549 |
1966331 | 1966331 | 2021-11-30 | Santa Barbara | California | 6083 | 47293 | 549 |
1963079 | 1963079 | 2021-11-29 | Santa Barbara | California | 6083 | 47268 | 549 |
1939282 | 1939282 | 2021-11-21 | Florence | South Carolina | 45041 | 26980 | 549 |
1936032 | 1936032 | 2021-11-20 | Florence | South Carolina | 45041 | 26980 | 549 |
1932782 | 1932782 | 2021-11-19 | Florence | South Carolina | 45041 | 26980 | 549 |
1927817 | 1927817 | 2021-11-18 | Elkhart | Indiana | 18039 | 38354 | 549 |
1929369 | 1929369 | 2021-11-18 | Cambria | Pennsylvania | 42021 | 21512 | 549 |
1929531 | 1929531 | 2021-11-18 | Florence | South Carolina | 45041 | 26943 | 549 |
1924567 | 1924567 | 2021-11-17 | Elkhart | Indiana | 18039 | 38145 | 549 |
1911415 | 1911415 | 2021-11-13 | Canyon | Idaho | 16027 | 42800 | 549 |
1913537 | 1913537 | 2021-11-13 | Ector | Texas | 48135 | 26127 | 549 |
1910287 | 1910287 | 2021-11-12 | Ector | Texas | 48135 | 25958 | 549 |
1896035 | 1896035 | 2021-11-08 | Harrison | Mississippi | 28047 | 34582 | 549 |
1897347 | 1897347 | 2021-11-08 | Johnson | Texas | 48251 | 28941 | 549 |
1894097 | 1894097 | 2021-11-07 | Johnson | Texas | 48251 | 28941 | 549 |
1890847 | 1890847 | 2021-11-06 | Johnson | Texas | 48251 | 28941 | 549 |
1874662 | 1874662 | 2021-11-01 | Potter | Texas | 48375 | 23546 | 549 |
1874802 | 1874802 | 2021-11-01 | Chesterfield | Virginia | 51041 | 39762 | 549 |
1861457 | 1861457 | 2021-10-28 | Rutherford | Tennessee | 47149 | 61863 | 549 |
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);