ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 1170 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Pennsylvania 8
- Ohio 7
- Illinois 6
- New Jersey 5
- Tennessee 5
- Texas 4
- Arkansas 3
- Massachusetts 3
- Michigan 3
- Virginia 3
- California 2
- Indiana 2
- Louisiana 2
- South Carolina 2
- Florida 1
- Georgia 1
- Maryland 1
- Minnesota 1
- New Mexico 1
- New York 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2372758 | 2372758 | 2022-04-04 | Pulaski | Arkansas | 5119 | 102930 | 1170 |
2369505 | 2369505 | 2022-04-03 | Pulaski | Arkansas | 5119 | 102919 | 1170 |
2366252 | 2366252 | 2022-04-02 | Pulaski | Arkansas | 5119 | 102907 | 1170 |
2334196 | 2334196 | 2022-03-23 | Kane | Illinois | 17089 | 125431 | 1170 |
2330942 | 2330942 | 2022-03-22 | Kane | Illinois | 17089 | 125365 | 1170 |
2311483 | 2311483 | 2022-03-16 | Allen | Indiana | 18003 | 103579 | 1170 |
2308230 | 2308230 | 2022-03-15 | Allen | Indiana | 18003 | 103563 | 1170 |
2260539 | 2260539 | 2022-02-28 | Burlington | New Jersey | 34005 | 100791 | 1170 |
2176501 | 2176501 | 2022-02-02 | Lehigh | Pennsylvania | 42077 | 87174 | 1170 |
2160614 | 2160614 | 2022-01-28 | Denton | Texas | 48121 | 160096 | 1170 |
2156473 | 2156473 | 2022-01-27 | Mercer | New Jersey | 34021 | 71604 | 1170 |
2137944 | 2137944 | 2022-01-21 | Montgomery | Texas | 48339 | 122130 | 1170 |
2108208 | 2108208 | 2022-01-12 | Westmoreland | Pennsylvania | 42129 | 65710 | 1170 |
1975270 | 1975270 | 2021-12-02 | Collin | Texas | 48085 | 133286 | 1170 |
1967241 | 1967241 | 2021-11-30 | East Baton Rouge | Louisiana | 22033 | 64608 | 1170 |
1967371 | 1967371 | 2021-11-30 | Genesee | Michigan | 26049 | 61265 | 1170 |
1963989 | 1963989 | 2021-11-29 | East Baton Rouge | Louisiana | 22033 | 64581 | 1170 |
1964119 | 1964119 | 2021-11-29 | Genesee | Michigan | 26049 | 61265 | 1170 |
1964990 | 1964990 | 2021-11-29 | Stark | Ohio | 39151 | 52584 | 1170 |
1961738 | 1961738 | 2021-11-28 | Stark | Ohio | 39151 | 52339 | 1170 |
1958487 | 1958487 | 2021-11-27 | Stark | Ohio | 39151 | 52161 | 1170 |
1955236 | 1955236 | 2021-11-26 | Stark | Ohio | 39151 | 52012 | 1170 |
1945160 | 1945160 | 2021-11-23 | Bernalillo | New Mexico | 35001 | 84858 | 1170 |
1904997 | 1904997 | 2021-11-11 | Lake | Illinois | 17097 | 82659 | 1170 |
1901747 | 1901747 | 2021-11-10 | Lake | Illinois | 17097 | 82659 | 1170 |
1898497 | 1898497 | 2021-11-09 | Lake | Illinois | 17097 | 82402 | 1170 |
1895247 | 1895247 | 2021-11-08 | Lake | Illinois | 17097 | 82302 | 1170 |
1897144 | 1897144 | 2021-11-08 | Davidson | Tennessee | 47037 | 133486 | 1170 |
1893894 | 1893894 | 2021-11-07 | Davidson | Tennessee | 47037 | 133249 | 1170 |
1890644 | 1890644 | 2021-11-06 | Davidson | Tennessee | 47037 | 133249 | 1170 |
1887394 | 1887394 | 2021-11-05 | Davidson | Tennessee | 47037 | 133249 | 1170 |
1884144 | 1884144 | 2021-11-04 | Davidson | Tennessee | 47037 | 133086 | 1170 |
1874746 | 1874746 | 2021-11-01 | Salt Lake | Utah | 49035 | 196671 | 1170 |
1855847 | 1855847 | 2021-10-27 | Ventura | California | 6111 | 101388 | 1170 |
1854814 | 1854814 | 2021-10-26 | Spartanburg | South Carolina | 45083 | 61540 | 1170 |
1851565 | 1851565 | 2021-10-25 | Spartanburg | South Carolina | 45083 | 61495 | 1170 |
1826076 | 1826076 | 2021-10-17 | Fairfax | Virginia | 51059 | 90382 | 1170 |
1822827 | 1822827 | 2021-10-16 | Fairfax | Virginia | 51059 | 90382 | 1170 |
1819578 | 1819578 | 2021-10-15 | Fairfax | Virginia | 51059 | 90382 | 1170 |
1757683 | 1757683 | 2021-09-26 | Nueces | Texas | 48355 | 59819 | 1170 |
1533043 | 1533043 | 2021-07-19 | Lancaster | Pennsylvania | 42071 | 55573 | 1170 |
1529796 | 1529796 | 2021-07-18 | Lancaster | Pennsylvania | 42071 | 55564 | 1170 |
1526549 | 1526549 | 2021-07-17 | Lancaster | Pennsylvania | 42071 | 55548 | 1170 |
1523302 | 1523302 | 2021-07-16 | Lancaster | Pennsylvania | 42071 | 55528 | 1170 |
1349428 | 1349428 | 2021-05-24 | Gwinnett | Georgia | 13135 | 102337 | 1170 |
1247164 | 1247164 | 2021-04-22 | Hamilton | Ohio | 39061 | 78646 | 1170 |
1243917 | 1243917 | 2021-04-21 | Hamilton | Ohio | 39061 | 78503 | 1170 |
1240670 | 1240670 | 2021-04-20 | Hamilton | Ohio | 39061 | 78409 | 1170 |
1162437 | 1162437 | 2021-03-27 | Morris | New Jersey | 34027 | 43968 | 1170 |
1153162 | 1153162 | 2021-03-24 | Bucks | Pennsylvania | 42017 | 49132 | 1170 |
1144597 | 1144597 | 2021-03-22 | Kern | California | 6029 | 105542 | 1170 |
1087755 | 1087755 | 2021-03-04 | Camden | New Jersey | 34007 | 44633 | 1170 |
974645 | 974645 | 2021-01-28 | Delaware | Pennsylvania | 42045 | 36636 | 1170 |
941127 | 941127 | 2021-01-18 | Prince George's | Maryland | 24033 | 63316 | 1170 |
808652 | 808652 | 2020-12-08 | Ocean | New Jersey | 34029 | 24615 | 1170 |
804955 | 804955 | 2020-12-07 | Hennepin | Minnesota | 27053 | 74735 | 1170 |
769145 | 769145 | 2020-11-26 | Norfolk | Massachusetts | 25021 | 15391 | 1170 |
765899 | 765899 | 2020-11-25 | Norfolk | Massachusetts | 25021 | 15391 | 1170 |
512144 | 512144 | 2020-09-08 | Palm Beach | Florida | 12099 | 43307 | 1170 |
500143 | 500143 | 2020-09-04 | Oakland | Michigan | 26125 | 18455 | 1170 |
377512 | 377512 | 2020-07-28 | Essex | Massachusetts | 25009 | 17033 | 1170 |
69020 | 69020 | 2020-04-18 | Unknown | New York | 0 | 1170 |
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);