ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where deaths = 778 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Florida 15
- Pennsylvania 15
- Texas 13
- North Carolina 11
- Georgia 10
- New Jersey 9
- Colorado 8
- South Carolina 8
- Delaware 7
- Kansas 7
- Louisiana 6
- Minnesota 6
- Maryland 5
- New York 5
- Washington 5
- Massachusetts 4
- Michigan 4
- Ohio 4
- Oregon 3
- Alabama 2
- California 2
- Missouri 2
- Arizona 1
- Illinois 1
- New Mexico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475116 | 2475116 | 2022-05-05 | St. Louis city | Missouri | 29510 | 57216 | 778 |
2428224 | 2428224 | 2022-04-21 | Pueblo | Colorado | 8101 | 46743 | 778 |
2399027 | 2399027 | 2022-04-12 | Bibb | Georgia | 13021 | 37145 | 778 |
2395772 | 2395772 | 2022-04-11 | Bibb | Georgia | 13021 | 37134 | 778 |
2336458 | 2336458 | 2022-03-23 | Utah | Utah | 49049 | 201346 | 778 |
2317099 | 2317099 | 2022-03-17 | Clark | Washington | 53011 | 86869 | 778 |
2313846 | 2313846 | 2022-03-16 | Clark | Washington | 53011 | 86869 | 778 |
2285087 | 2285087 | 2022-03-08 | Bay | Florida | 12005 | 45503 | 778 |
2286640 | 2286640 | 2022-03-08 | Oneida | New York | 36065 | 52335 | 778 |
2281835 | 2281835 | 2022-03-07 | Bay | Florida | 12005 | 45503 | 778 |
2283388 | 2283388 | 2022-03-07 | Oneida | New York | 36065 | 52318 | 778 |
2278582 | 2278582 | 2022-03-06 | Bay | Florida | 12005 | 45503 | 778 |
2279586 | 2279586 | 2022-03-06 | Anoka | Minnesota | 27003 | 97536 | 778 |
2280136 | 2280136 | 2022-03-06 | Oneida | New York | 36065 | 52304 | 778 |
2275329 | 2275329 | 2022-03-05 | Bay | Florida | 12005 | 45503 | 778 |
2276333 | 2276333 | 2022-03-05 | Anoka | Minnesota | 27003 | 97536 | 778 |
2272076 | 2272076 | 2022-03-04 | Bay | Florida | 12005 | 45503 | 778 |
2273080 | 2273080 | 2022-03-04 | Anoka | Minnesota | 27003 | 97536 | 778 |
2268824 | 2268824 | 2022-03-03 | Bay | Florida | 12005 | 45434 | 778 |
2269828 | 2269828 | 2022-03-03 | Anoka | Minnesota | 27003 | 97493 | 778 |
2265571 | 2265571 | 2022-03-02 | Bay | Florida | 12005 | 45434 | 778 |
2266575 | 2266575 | 2022-03-02 | Anoka | Minnesota | 27003 | 97468 | 778 |
2236446 | 2236446 | 2022-02-21 | Hall | Georgia | 13139 | 53144 | 778 |
2216801 | 2216801 | 2022-02-15 | Sussex | Delaware | 10005 | 60089 | 778 |
2213550 | 2213550 | 2022-02-14 | Sussex | Delaware | 10005 | 60061 | 778 |
2214550 | 2214550 | 2022-02-14 | St. Clair | Michigan | 26147 | 39619 | 778 |
2210298 | 2210298 | 2022-02-13 | Sussex | Delaware | 10005 | 60018 | 778 |
2211298 | 2211298 | 2022-02-13 | St. Clair | Michigan | 26147 | 39600 | 778 |
2207045 | 2207045 | 2022-02-12 | Sussex | Delaware | 10005 | 59960 | 778 |
2208045 | 2208045 | 2022-02-12 | St. Clair | Michigan | 26147 | 39527 | 778 |
2204792 | 2204792 | 2022-02-11 | St. Clair | Michigan | 26147 | 39527 | 778 |
2194126 | 2194126 | 2022-02-08 | Chatham | Georgia | 13051 | 60093 | 778 |
2190872 | 2190872 | 2022-02-07 | Chatham | Georgia | 13051 | 60002 | 778 |
2189654 | 2189654 | 2022-02-06 | Lexington | South Carolina | 45063 | 91351 | 778 |
2186401 | 2186401 | 2022-02-05 | Lexington | South Carolina | 45063 | 91351 | 778 |
2183149 | 2183149 | 2022-02-04 | Lexington | South Carolina | 45063 | 91351 | 778 |
2178621 | 2178621 | 2022-02-03 | St. Tammany | Louisiana | 22103 | 69712 | 778 |
2154127 | 2154127 | 2022-01-26 | Galveston | Texas | 48167 | 88636 | 778 |
2098911 | 2098911 | 2022-01-09 | McLennan | Texas | 48309 | 47692 | 778 |
2055662 | 2055662 | 2021-12-27 | Gloucester | New Jersey | 34015 | 46845 | 778 |
2052412 | 2052412 | 2021-12-26 | Gloucester | New Jersey | 34015 | 46618 | 778 |
2049162 | 2049162 | 2021-12-25 | Gloucester | New Jersey | 34015 | 46334 | 778 |
1995775 | 1995775 | 2021-12-09 | Clayton | Georgia | 13063 | 40641 | 778 |
1992524 | 1992524 | 2021-12-08 | Clayton | Georgia | 13063 | 40578 | 778 |
1945802 | 1945802 | 2021-11-23 | Richland | South Carolina | 45079 | 70038 | 778 |
1942551 | 1942551 | 2021-11-22 | Richland | South Carolina | 45079 | 70016 | 778 |
1923014 | 1923014 | 2021-11-16 | Anderson | South Carolina | 45007 | 37129 | 778 |
1918549 | 1918549 | 2021-11-15 | Anne Arundel | Maryland | 24003 | 54200 | 778 |
1919415 | 1919415 | 2021-11-15 | Butler | Ohio | 39017 | 53841 | 778 |
1919765 | 1919765 | 2021-11-15 | Anderson | South Carolina | 45007 | 37110 | 778 |
1915299 | 1915299 | 2021-11-14 | Anne Arundel | Maryland | 24003 | 54122 | 778 |
1916165 | 1916165 | 2021-11-14 | Butler | Ohio | 39017 | 53773 | 778 |
1916349 | 1916349 | 2021-11-14 | Multnomah | Oregon | 41051 | 58525 | 778 |
1912049 | 1912049 | 2021-11-13 | Anne Arundel | Maryland | 24003 | 54037 | 778 |
1912915 | 1912915 | 2021-11-13 | Butler | Ohio | 39017 | 53666 | 778 |
1913099 | 1913099 | 2021-11-13 | Multnomah | Oregon | 41051 | 58525 | 778 |
1907645 | 1907645 | 2021-11-12 | Montgomery | Alabama | 1101 | 34356 | 778 |
1909665 | 1909665 | 2021-11-12 | Butler | Ohio | 39017 | 53564 | 778 |
1909849 | 1909849 | 2021-11-12 | Multnomah | Oregon | 41051 | 58525 | 778 |
1904396 | 1904396 | 2021-11-11 | Montgomery | Alabama | 1101 | 34337 | 778 |
1883390 | 1883390 | 2021-11-04 | Atlantic | New Jersey | 34001 | 39814 | 778 |
1880141 | 1880141 | 2021-11-03 | Atlantic | New Jersey | 34001 | 39755 | 778 |
1876892 | 1876892 | 2021-11-02 | Atlantic | New Jersey | 34001 | 39705 | 778 |
1876978 | 1876978 | 2021-11-02 | Onondaga | New York | 36067 | 53927 | 778 |
1825424 | 1825424 | 2021-10-17 | Northampton | Pennsylvania | 42095 | 43670 | 778 |
1822175 | 1822175 | 2021-10-16 | Northampton | Pennsylvania | 42095 | 43591 | 778 |
1818926 | 1818926 | 2021-10-15 | Northampton | Pennsylvania | 42095 | 43507 | 778 |
1815677 | 1815677 | 2021-10-14 | Northampton | Pennsylvania | 42095 | 43443 | 778 |
1793265 | 1793265 | 2021-10-07 | Brazoria | Texas | 48039 | 58020 | 778 |
1746685 | 1746685 | 2021-09-23 | Kansas City | Missouri | 60372 | 778 | |
1711344 | 1711344 | 2021-09-12 | Guilford | North Carolina | 37081 | 58331 | 778 |
1708097 | 1708097 | 2021-09-11 | Guilford | North Carolina | 37081 | 58331 | 778 |
1708945 | 1708945 | 2021-09-11 | Montgomery | Texas | 48339 | 78976 | 778 |
1704850 | 1704850 | 2021-09-10 | Guilford | North Carolina | 37081 | 58331 | 778 |
1701600 | 1701600 | 2021-09-09 | Guilford | North Carolina | 37081 | 58193 | 778 |
1698351 | 1698351 | 2021-09-08 | Guilford | North Carolina | 37081 | 58026 | 778 |
1695103 | 1695103 | 2021-09-07 | Guilford | North Carolina | 37081 | 57863 | 778 |
1691855 | 1691855 | 2021-09-06 | Guilford | North Carolina | 37081 | 56884 | 778 |
1688605 | 1688605 | 2021-09-05 | Guilford | North Carolina | 37081 | 56884 | 778 |
1685355 | 1685355 | 2021-09-04 | Guilford | North Carolina | 37081 | 56884 | 778 |
1682104 | 1682104 | 2021-09-03 | Guilford | North Carolina | 37081 | 56884 | 778 |
1669163 | 1669163 | 2021-08-30 | Wake | North Carolina | 37183 | 110072 | 778 |
1631678 | 1631678 | 2021-08-19 | Adams | Colorado | 8001 | 65490 | 778 |
1628431 | 1628431 | 2021-08-18 | Adams | Colorado | 8001 | 65490 | 778 |
1547085 | 1547085 | 2021-07-24 | Mohave | Arizona | 4015 | 25038 | 778 |
1541427 | 1541427 | 2021-07-22 | Johnson | Kansas | 20091 | 61655 | 778 |
1538180 | 1538180 | 2021-07-21 | Johnson | Kansas | 20091 | 61655 | 778 |
1534932 | 1534932 | 2021-07-20 | Johnson | Kansas | 20091 | 61305 | 778 |
1531685 | 1531685 | 2021-07-19 | Johnson | Kansas | 20091 | 61305 | 778 |
1528438 | 1528438 | 2021-07-18 | Johnson | Kansas | 20091 | 61138 | 778 |
1525191 | 1525191 | 2021-07-17 | Johnson | Kansas | 20091 | 61138 | 778 |
1521943 | 1521943 | 2021-07-16 | Johnson | Kansas | 20091 | 61138 | 778 |
1491220 | 1491220 | 2021-07-06 | Denton | Texas | 48121 | 77185 | 778 |
1487973 | 1487973 | 2021-07-05 | Denton | Texas | 48121 | 77111 | 778 |
1484726 | 1484726 | 2021-07-04 | Denton | Texas | 48121 | 77111 | 778 |
1481123 | 1481123 | 2021-07-03 | Westmoreland | Pennsylvania | 42129 | 34441 | 778 |
1481480 | 1481480 | 2021-07-03 | Denton | Texas | 48121 | 77111 | 778 |
1477876 | 1477876 | 2021-07-02 | Westmoreland | Pennsylvania | 42129 | 34434 | 778 |
1478233 | 1478233 | 2021-07-02 | Denton | Texas | 48121 | 77111 | 778 |
1474630 | 1474630 | 2021-07-01 | Westmoreland | Pennsylvania | 42129 | 34430 | 778 |
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);