ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 860 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Missouri 21
- New Jersey 16
- Pennsylvania 14
- Illinois 12
- Texas 11
- South Carolina 10
- California 9
- Michigan 8
- Alabama 7
- Colorado 7
- Florida 7
- Tennessee 7
- Maryland 6
- Ohio 4
- Arizona 3
- Nevada 3
- North Carolina 3
- Georgia 2
- Kansas 2
- Minnesota 2
- Arkansas 1
- Indiana 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473736 | 2473736 | 2022-05-05 | San Francisco | California | 6075 | 140270 | 860 |
2470479 | 2470479 | 2022-05-04 | San Francisco | California | 6075 | 140270 | 860 |
2467223 | 2467223 | 2022-05-03 | San Francisco | California | 6075 | 140270 | 860 |
2463968 | 2463968 | 2022-05-02 | San Francisco | California | 6075 | 138912 | 860 |
2460712 | 2460712 | 2022-05-01 | San Francisco | California | 6075 | 138912 | 860 |
2457456 | 2457456 | 2022-04-30 | San Francisco | California | 6075 | 138912 | 860 |
2454200 | 2454200 | 2022-04-29 | San Francisco | California | 6075 | 138912 | 860 |
2369993 | 2369993 | 2022-04-03 | Madison | Illinois | 17119 | 70234 | 860 |
2366740 | 2366740 | 2022-04-02 | Madison | Illinois | 17119 | 70234 | 860 |
2363487 | 2363487 | 2022-04-01 | Madison | Illinois | 17119 | 70234 | 860 |
2360233 | 2360233 | 2022-03-31 | Madison | Illinois | 17119 | 70219 | 860 |
2353483 | 2353483 | 2022-03-29 | Chatham | Georgia | 13051 | 63549 | 860 |
2350231 | 2350231 | 2022-03-28 | Chatham | Georgia | 13051 | 63450 | 860 |
2352267 | 2352267 | 2022-03-28 | Lexington | South Carolina | 45063 | 95522 | 860 |
2349015 | 2349015 | 2022-03-27 | Lexington | South Carolina | 45063 | 95522 | 860 |
2345762 | 2345762 | 2022-03-26 | Lexington | South Carolina | 45063 | 95522 | 860 |
2342509 | 2342509 | 2022-03-25 | Lexington | South Carolina | 45063 | 95522 | 860 |
2339256 | 2339256 | 2022-03-24 | Lexington | South Carolina | 45063 | 95522 | 860 |
2336002 | 2336002 | 2022-03-23 | Lexington | South Carolina | 45063 | 95522 | 860 |
2332748 | 2332748 | 2022-03-22 | Lexington | South Carolina | 45063 | 95522 | 860 |
2308302 | 2308302 | 2022-03-15 | St. Joseph | Indiana | 18141 | 70399 | 860 |
2287367 | 2287367 | 2022-03-08 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2284115 | 2284115 | 2022-03-07 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2280863 | 2280863 | 2022-03-06 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2281130 | 2281130 | 2022-03-06 | Williamson | Texas | 48491 | 131380 | 860 |
2277610 | 2277610 | 2022-03-05 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2277877 | 2277877 | 2022-03-05 | Williamson | Texas | 48491 | 131380 | 860 |
2274357 | 2274357 | 2022-03-04 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2274624 | 2274624 | 2022-03-04 | Williamson | Texas | 48491 | 131380 | 860 |
2271104 | 2271104 | 2022-03-03 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2267852 | 2267852 | 2022-03-02 | Rutherford | Tennessee | 47149 | 95130 | 860 |
2258794 | 2258794 | 2022-02-28 | Montgomery | Alabama | 1101 | 54355 | 860 |
2261031 | 2261031 | 2022-02-28 | Cumberland | Pennsylvania | 42041 | 50413 | 860 |
2255543 | 2255543 | 2022-02-27 | Montgomery | Alabama | 1101 | 54348 | 860 |
2257780 | 2257780 | 2022-02-27 | Cumberland | Pennsylvania | 42041 | 50391 | 860 |
2252292 | 2252292 | 2022-02-26 | Montgomery | Alabama | 1101 | 54322 | 860 |
2254529 | 2254529 | 2022-02-26 | Cumberland | Pennsylvania | 42041 | 50376 | 860 |
2249041 | 2249041 | 2022-02-25 | Montgomery | Alabama | 1101 | 54301 | 860 |
2251278 | 2251278 | 2022-02-25 | Cumberland | Pennsylvania | 42041 | 50330 | 860 |
2237584 | 2237584 | 2022-02-21 | St. Charles | Missouri | 29183 | 100432 | 860 |
2234333 | 2234333 | 2022-02-20 | St. Charles | Missouri | 29183 | 100431 | 860 |
2231082 | 2231082 | 2022-02-19 | St. Charles | Missouri | 29183 | 100431 | 860 |
2227831 | 2227831 | 2022-02-18 | St. Charles | Missouri | 29183 | 100428 | 860 |
2223182 | 2223182 | 2022-02-17 | Imperial | California | 6025 | 64540 | 860 |
2224580 | 2224580 | 2022-02-17 | St. Charles | Missouri | 29183 | 100417 | 860 |
2221329 | 2221329 | 2022-02-16 | St. Charles | Missouri | 29183 | 100329 | 860 |
2218909 | 2218909 | 2022-02-15 | Charleston | South Carolina | 45019 | 109971 | 860 |
2215658 | 2215658 | 2022-02-14 | Charleston | South Carolina | 45019 | 109912 | 860 |
2154255 | 2154255 | 2022-01-26 | Smith | Texas | 48423 | 41431 | 860 |
2126924 | 2126924 | 2022-01-18 | Greene | Missouri | 29077 | 57664 | 860 |
2123672 | 2123672 | 2022-01-17 | Greene | Missouri | 29077 | 55590 | 860 |
2120420 | 2120420 | 2022-01-16 | Greene | Missouri | 29077 | 55590 | 860 |
2120677 | 2120677 | 2022-01-16 | Atlantic | New Jersey | 34001 | 61181 | 860 |
2117168 | 2117168 | 2022-01-15 | Greene | Missouri | 29077 | 55590 | 860 |
2117425 | 2117425 | 2022-01-15 | Atlantic | New Jersey | 34001 | 60570 | 860 |
2113917 | 2113917 | 2022-01-14 | Greene | Missouri | 29077 | 55590 | 860 |
2110665 | 2110665 | 2022-01-13 | Greene | Missouri | 29077 | 55114 | 860 |
2107414 | 2107414 | 2022-01-12 | Greene | Missouri | 29077 | 54436 | 860 |
2104163 | 2104163 | 2022-01-11 | Greene | Missouri | 29077 | 53971 | 860 |
2097330 | 2097330 | 2022-01-09 | Anne Arundel | Maryland | 24003 | 74644 | 860 |
2052157 | 2052157 | 2021-12-26 | Jackson | Missouri | 29095 | 65207 | 860 |
2048907 | 2048907 | 2021-12-25 | Jackson | Missouri | 29095 | 65207 | 860 |
2045657 | 2045657 | 2021-12-24 | Jackson | Missouri | 29095 | 65207 | 860 |
2042407 | 2042407 | 2021-12-23 | Jackson | Missouri | 29095 | 65207 | 860 |
2039158 | 2039158 | 2021-12-22 | Jackson | Missouri | 29095 | 64660 | 860 |
2014254 | 2014254 | 2021-12-14 | Brazoria | Texas | 48039 | 61656 | 860 |
2011003 | 2011003 | 2021-12-13 | Brazoria | Texas | 48039 | 61572 | 860 |
2007752 | 2007752 | 2021-12-12 | Brazoria | Texas | 48039 | 61491 | 860 |
2004501 | 2004501 | 2021-12-11 | Brazoria | Texas | 48039 | 61440 | 860 |
1831556 | 1831556 | 2021-10-19 | Guilford | North Carolina | 37081 | 66883 | 860 |
1828307 | 1828307 | 2021-10-18 | Guilford | North Carolina | 37081 | 66809 | 860 |
1809197 | 1809197 | 2021-10-12 | Westmoreland | Pennsylvania | 42129 | 42552 | 860 |
1805897 | 1805897 | 2021-10-11 | Chester | Pennsylvania | 42029 | 48897 | 860 |
1802148 | 1802148 | 2021-10-10 | Washoe | Nevada | 32031 | 62694 | 860 |
1802647 | 1802647 | 2021-10-10 | Chester | Pennsylvania | 42029 | 48817 | 860 |
1798899 | 1798899 | 2021-10-09 | Washoe | Nevada | 32031 | 62694 | 860 |
1799398 | 1799398 | 2021-10-09 | Chester | Pennsylvania | 42029 | 48725 | 860 |
1795650 | 1795650 | 2021-10-08 | Washoe | Nevada | 32031 | 62694 | 860 |
1796149 | 1796149 | 2021-10-08 | Chester | Pennsylvania | 42029 | 48574 | 860 |
1748723 | 1748723 | 2021-09-24 | Escambia | Florida | 12033 | 52171 | 860 |
1745473 | 1745473 | 2021-09-23 | Escambia | Florida | 12033 | 51382 | 860 |
1742161 | 1742161 | 2021-09-22 | Jefferson | Colorado | 8059 | 57046 | 860 |
1742224 | 1742224 | 2021-09-22 | Escambia | Florida | 12033 | 51382 | 860 |
1738807 | 1738807 | 2021-09-21 | Pulaski | Arkansas | 5119 | 56652 | 860 |
1738912 | 1738912 | 2021-09-21 | Jefferson | Colorado | 8059 | 56937 | 860 |
1738975 | 1738975 | 2021-09-21 | Escambia | Florida | 12033 | 51382 | 860 |
1735726 | 1735726 | 2021-09-20 | Escambia | Florida | 12033 | 51382 | 860 |
1732476 | 1732476 | 2021-09-19 | Escambia | Florida | 12033 | 51382 | 860 |
1729226 | 1729226 | 2021-09-18 | Escambia | Florida | 12033 | 51382 | 860 |
1716834 | 1716834 | 2021-09-14 | Johnson | Kansas | 20091 | 72152 | 860 |
1713588 | 1713588 | 2021-09-13 | Johnson | Kansas | 20091 | 72152 | 860 |
1712084 | 1712084 | 2021-09-12 | Denton | Texas | 48121 | 93227 | 860 |
1706399 | 1706399 | 2021-09-11 | Arapahoe | Colorado | 8005 | 71992 | 860 |
1707961 | 1707961 | 2021-09-11 | Somerset | New Jersey | 34035 | 32895 | 860 |
1708837 | 1708837 | 2021-09-11 | Denton | Texas | 48121 | 93227 | 860 |
1703151 | 1703151 | 2021-09-10 | Arapahoe | Colorado | 8005 | 71992 | 860 |
1704714 | 1704714 | 2021-09-10 | Somerset | New Jersey | 34035 | 32820 | 860 |
1699901 | 1699901 | 2021-09-09 | Arapahoe | Colorado | 8005 | 71986 | 860 |
1696652 | 1696652 | 2021-09-08 | Arapahoe | Colorado | 8005 | 71842 | 860 |
1693261 | 1693261 | 2021-09-07 | Mohave | Arizona | 4015 | 29050 | 860 |
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);