ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where deaths = 668 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Washington 17
- Texas 14
- New York 11
- Georgia 10
- Pennsylvania 9
- Maryland 7
- Nevada 7
- Wisconsin 7
- Michigan 6
- New Hampshire 6
- Florida 5
- Indiana 5
- Massachusetts 5
- New Jersey 5
- Oregon 5
- Colorado 4
- Hawaii 4
- Missouri 4
- Alabama 3
- California 3
- North Carolina 3
- Utah 3
- Virginia 3
- Arkansas 2
- Illinois 2
- Arizona 1
- Louisiana 1
- Mississippi 1
- Oklahoma 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2360040 | 2360040 | 2022-03-31 | Henry | Georgia | 13151 | 57791 | 668 |
2360857 | 2360857 | 2022-03-31 | Kalamazoo | Michigan | 26077 | 58955 | 668 |
2357603 | 2357603 | 2022-03-30 | Kalamazoo | Michigan | 26077 | 58955 | 668 |
2333016 | 2333016 | 2022-03-22 | Gregg | Texas | 48183 | 23089 | 668 |
2329763 | 2329763 | 2022-03-21 | Gregg | Texas | 48183 | 23089 | 668 |
2326511 | 2326511 | 2022-03-20 | Gregg | Texas | 48183 | 23089 | 668 |
2323258 | 2323258 | 2022-03-19 | Gregg | Texas | 48183 | 23089 | 668 |
2314031 | 2314031 | 2022-03-17 | Baldwin | Alabama | 1003 | 55218 | 668 |
2317239 | 2317239 | 2022-03-17 | Racine | Wisconsin | 55101 | 56031 | 668 |
2310778 | 2310778 | 2022-03-16 | Baldwin | Alabama | 1003 | 55218 | 668 |
2311005 | 2311005 | 2022-03-16 | Santa Barbara | California | 6083 | 90167 | 668 |
2307525 | 2307525 | 2022-03-15 | Baldwin | Alabama | 1003 | 55196 | 668 |
2287016 | 2287016 | 2022-03-08 | Marion | Oregon | 41047 | 68482 | 668 |
2267541 | 2267541 | 2022-03-02 | Franklin | Pennsylvania | 42055 | 40091 | 668 |
2246969 | 2246969 | 2022-02-24 | Barnstable | Massachusetts | 25001 | 34285 | 668 |
2242052 | 2242052 | 2022-02-22 | Potter | Texas | 48375 | 35161 | 668 |
2199813 | 2199813 | 2022-02-09 | Taylor | Texas | 48441 | 32442 | 668 |
2167902 | 2167902 | 2022-01-31 | Monterey | California | 6053 | 81652 | 668 |
2169967 | 2169967 | 2022-01-31 | Cambria | Pennsylvania | 42021 | 32639 | 668 |
2160196 | 2160196 | 2022-01-28 | Beaver | Pennsylvania | 42007 | 37438 | 668 |
2145637 | 2145637 | 2022-01-24 | Elkhart | Indiana | 18039 | 51165 | 668 |
2146852 | 2146852 | 2022-01-24 | Forsyth | North Carolina | 37067 | 81738 | 668 |
2131744 | 2131744 | 2022-01-19 | Yakima | Washington | 53077 | 57893 | 668 |
2126828 | 2126828 | 2022-01-18 | Hinds | Mississippi | 28049 | 45953 | 668 |
2128490 | 2128490 | 2022-01-18 | Yakima | Washington | 53077 | 57300 | 668 |
2123737 | 2123737 | 2022-01-17 | St. Louis city | Missouri | 29510 | 49281 | 668 |
2125237 | 2125237 | 2022-01-17 | Yakima | Washington | 53077 | 54191 | 668 |
2120485 | 2120485 | 2022-01-16 | St. Louis city | Missouri | 29510 | 49281 | 668 |
2121985 | 2121985 | 2022-01-16 | Yakima | Washington | 53077 | 54191 | 668 |
2117233 | 2117233 | 2022-01-15 | St. Louis city | Missouri | 29510 | 49275 | 668 |
2118733 | 2118733 | 2022-01-15 | Yakima | Washington | 53077 | 54191 | 668 |
2113982 | 2113982 | 2022-01-14 | St. Louis city | Missouri | 29510 | 48502 | 668 |
2115481 | 2115481 | 2022-01-14 | Yakima | Washington | 53077 | 54191 | 668 |
2107819 | 2107819 | 2022-01-12 | Gaston | North Carolina | 37071 | 50612 | 668 |
2099030 | 2099030 | 2022-01-09 | Utah | Utah | 49049 | 152404 | 668 |
2095778 | 2095778 | 2022-01-08 | Utah | Utah | 49049 | 152404 | 668 |
2092526 | 2092526 | 2022-01-07 | Utah | Utah | 49049 | 152404 | 668 |
2054263 | 2054263 | 2021-12-27 | Bibb | Georgia | 13021 | 26958 | 668 |
2051013 | 2051013 | 2021-12-26 | Bibb | Georgia | 13021 | 26618 | 668 |
2047763 | 2047763 | 2021-12-25 | Bibb | Georgia | 13021 | 26618 | 668 |
2044513 | 2044513 | 2021-12-24 | Bibb | Georgia | 13021 | 26618 | 668 |
2034477 | 2034477 | 2021-12-21 | Benton | Arkansas | 5007 | 45300 | 668 |
2018605 | 2018605 | 2021-12-16 | Muscogee | Georgia | 13215 | 25032 | 668 |
2018797 | 2018797 | 2021-12-16 | St. Clair | Illinois | 17163 | 44930 | 668 |
2015355 | 2015355 | 2021-12-15 | Muscogee | Georgia | 13215 | 25012 | 668 |
2012104 | 2012104 | 2021-12-14 | Muscogee | Georgia | 13215 | 24993 | 668 |
2008853 | 2008853 | 2021-12-13 | Muscogee | Georgia | 13215 | 24954 | 668 |
2010236 | 2010236 | 2021-12-13 | Oneida | New York | 36065 | 35450 | 668 |
1987888 | 1987888 | 2021-12-06 | Cumberland | Pennsylvania | 42041 | 32367 | 668 |
1983130 | 1983130 | 2021-12-05 | St. Joseph | Indiana | 18141 | 49858 | 668 |
1979880 | 1979880 | 2021-12-04 | St. Joseph | Indiana | 18141 | 49858 | 668 |
1976630 | 1976630 | 2021-12-03 | St. Joseph | Indiana | 18141 | 49858 | 668 |
1943450 | 1943450 | 2021-11-23 | Navajo | Arizona | 4017 | 24022 | 668 |
1929655 | 1929655 | 2021-11-18 | Hamilton | Tennessee | 47065 | 64931 | 668 |
1856158 | 1856158 | 2021-10-27 | Honolulu | Hawaii | 15003 | 57647 | 668 |
1852909 | 1852909 | 2021-10-26 | Honolulu | Hawaii | 15003 | 57548 | 668 |
1849660 | 1849660 | 2021-10-25 | Honolulu | Hawaii | 15003 | 57512 | 668 |
1846410 | 1846410 | 2021-10-24 | Honolulu | Hawaii | 15003 | 57470 | 668 |
1836523 | 1836523 | 2021-10-21 | Chatham | Georgia | 13051 | 38470 | 668 |
1830926 | 1830926 | 2021-10-19 | Saginaw | Michigan | 26145 | 27627 | 668 |
1827677 | 1827677 | 2021-10-18 | Saginaw | Michigan | 26145 | 27627 | 668 |
1805404 | 1805404 | 2021-10-11 | Hillsborough | New Hampshire | 33011 | 43719 | 668 |
1805872 | 1805872 | 2021-10-11 | Multnomah | Oregon | 41051 | 54569 | 668 |
1802155 | 1802155 | 2021-10-10 | Hillsborough | New Hampshire | 33011 | 43332 | 668 |
1802622 | 1802622 | 2021-10-10 | Multnomah | Oregon | 41051 | 54202 | 668 |
1798906 | 1798906 | 2021-10-09 | Hillsborough | New Hampshire | 33011 | 43332 | 668 |
1799373 | 1799373 | 2021-10-09 | Multnomah | Oregon | 41051 | 54202 | 668 |
1795657 | 1795657 | 2021-10-08 | Hillsborough | New Hampshire | 33011 | 43332 | 668 |
1796124 | 1796124 | 2021-10-08 | Multnomah | Oregon | 41051 | 54202 | 668 |
1796578 | 1796578 | 2021-10-08 | Galveston | Texas | 48167 | 62797 | 668 |
1792408 | 1792408 | 2021-10-07 | Hillsborough | New Hampshire | 33011 | 43190 | 668 |
1789159 | 1789159 | 2021-10-06 | Hillsborough | New Hampshire | 33011 | 42979 | 668 |
1790157 | 1790157 | 2021-10-06 | McLennan | Texas | 48309 | 41149 | 668 |
1735124 | 1735124 | 2021-09-19 | Henrico | Virginia | 51087 | 31422 | 668 |
1731874 | 1731874 | 2021-09-18 | Henrico | Virginia | 51087 | 31422 | 668 |
1728624 | 1728624 | 2021-09-17 | Henrico | Virginia | 51087 | 31422 | 668 |
1718982 | 1718982 | 2021-09-14 | Snohomish | Washington | 53061 | 54850 | 668 |
1696378 | 1696378 | 2021-09-07 | Waukesha | Wisconsin | 55133 | 54571 | 668 |
1693130 | 1693130 | 2021-09-06 | Waukesha | Wisconsin | 55133 | 54571 | 668 |
1689881 | 1689881 | 2021-09-05 | Waukesha | Wisconsin | 55133 | 54431 | 668 |
1686631 | 1686631 | 2021-09-04 | Waukesha | Wisconsin | 55133 | 54431 | 668 |
1683381 | 1683381 | 2021-09-03 | Waukesha | Wisconsin | 55133 | 54431 | 668 |
1680130 | 1680130 | 2021-09-02 | Waukesha | Wisconsin | 55133 | 54292 | 668 |
1538442 | 1538442 | 2021-07-21 | Anne Arundel | Maryland | 24003 | 44225 | 668 |
1535195 | 1535195 | 2021-07-20 | Anne Arundel | Maryland | 24003 | 44204 | 668 |
1531947 | 1531947 | 2021-07-19 | Anne Arundel | Maryland | 24003 | 44192 | 668 |
1528700 | 1528700 | 2021-07-18 | Anne Arundel | Maryland | 24003 | 44184 | 668 |
1525453 | 1525453 | 2021-07-17 | Anne Arundel | Maryland | 24003 | 44173 | 668 |
1522206 | 1522206 | 2021-07-16 | Anne Arundel | Maryland | 24003 | 44140 | 668 |
1420217 | 1420217 | 2021-06-14 | Spokane | Washington | 53063 | 46833 | 668 |
1416972 | 1416972 | 2021-06-13 | Spokane | Washington | 53063 | 46696 | 668 |
1413726 | 1413726 | 2021-06-12 | Spokane | Washington | 53063 | 46696 | 668 |
1410481 | 1410481 | 2021-06-11 | Spokane | Washington | 53063 | 46696 | 668 |
1394580 | 1394580 | 2021-06-07 | Pulaski | Arkansas | 5119 | 40002 | 668 |
1326078 | 1326078 | 2021-05-16 | Pierce | Washington | 53053 | 52763 | 668 |
1322832 | 1322832 | 2021-05-15 | Pierce | Washington | 53053 | 52763 | 668 |
1319586 | 1319586 | 2021-05-14 | Pierce | Washington | 53053 | 52769 | 668 |
1313092 | 1313092 | 2021-05-12 | Pierce | Washington | 53053 | 51833 | 668 |
1306216 | 1306216 | 2021-05-10 | Fort Bend | Texas | 48157 | 67605 | 668 |
1302146 | 1302146 | 2021-05-09 | Onondaga | New York | 36067 | 37714 | 668 |
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);