ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where deaths = 1105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Louisiana 12
- Florida 8
- Pennsylvania 7
- Virginia 7
- Delaware 4
- Illinois 4
- Indiana 4
- Colorado 3
- Iowa 3
- Massachusetts 3
- Ohio 3
- Washington 3
- California 2
- District of Columbia 2
- Georgia 2
- Texas 2
- Missouri 1
- Oregon 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500449 | 2500449 | 2022-05-13 | Polk | Iowa | 19153 | 126409 | 1105 |
2497191 | 2497191 | 2022-05-12 | Polk | Iowa | 19153 | 126409 | 1105 |
2493933 | 2493933 | 2022-05-11 | Polk | Iowa | 19153 | 126409 | 1105 |
2354225 | 2354225 | 2022-03-29 | Orleans | Louisiana | 22071 | 87313 | 1105 |
2350973 | 2350973 | 2022-03-28 | Orleans | Louisiana | 22071 | 87298 | 1105 |
2347720 | 2347720 | 2022-03-27 | Orleans | Louisiana | 22071 | 87265 | 1105 |
2344467 | 2344467 | 2022-03-26 | Orleans | Louisiana | 22071 | 87265 | 1105 |
2341214 | 2341214 | 2022-03-25 | Orleans | Louisiana | 22071 | 87265 | 1105 |
2337961 | 2337961 | 2022-03-24 | Orleans | Louisiana | 22071 | 87238 | 1105 |
2334707 | 2334707 | 2022-03-23 | Orleans | Louisiana | 22071 | 87226 | 1105 |
2331453 | 2331453 | 2022-03-22 | Orleans | Louisiana | 22071 | 87196 | 1105 |
2328201 | 2328201 | 2022-03-21 | Orleans | Louisiana | 22071 | 87165 | 1105 |
2313035 | 2313035 | 2022-03-16 | Multnomah | Oregon | 41051 | 112053 | 1105 |
2307895 | 2307895 | 2022-03-15 | Osceola | Florida | 12097 | 112755 | 1105 |
2304644 | 2304644 | 2022-03-14 | Osceola | Florida | 12097 | 112755 | 1105 |
2301392 | 2301392 | 2022-03-13 | Osceola | Florida | 12097 | 112755 | 1105 |
2298140 | 2298140 | 2022-03-12 | Osceola | Florida | 12097 | 112755 | 1105 |
2294888 | 2294888 | 2022-03-11 | Osceola | Florida | 12097 | 112755 | 1105 |
2291636 | 2291636 | 2022-03-10 | Osceola | Florida | 12097 | 112508 | 1105 |
2288384 | 2288384 | 2022-03-09 | Osceola | Florida | 12097 | 112508 | 1105 |
2279387 | 2279387 | 2022-03-06 | Caddo | Louisiana | 22017 | 67028 | 1105 |
2276134 | 2276134 | 2022-03-05 | Caddo | Louisiana | 22017 | 67028 | 1105 |
2272881 | 2272881 | 2022-03-04 | Caddo | Louisiana | 22017 | 67028 | 1105 |
2244034 | 2244034 | 2022-02-23 | Jackson | Missouri | 29095 | 95077 | 1105 |
2241519 | 2241519 | 2022-02-22 | Chester | Pennsylvania | 42029 | 90237 | 1105 |
2238268 | 2238268 | 2022-02-21 | Chester | Pennsylvania | 42029 | 90156 | 1105 |
2235017 | 2235017 | 2022-02-20 | Chester | Pennsylvania | 42029 | 90156 | 1105 |
2180152 | 2180152 | 2022-02-03 | Fort Bend | Texas | 48157 | 167288 | 1105 |
2176901 | 2176901 | 2022-02-02 | Fort Bend | Texas | 48157 | 166547 | 1105 |
2095178 | 2095178 | 2022-01-08 | Luzerne | Pennsylvania | 42079 | 58408 | 1105 |
2073638 | 2073638 | 2022-01-02 | Jefferson | Colorado | 8059 | 82540 | 1105 |
2070387 | 2070387 | 2022-01-01 | Jefferson | Colorado | 8059 | 82540 | 1105 |
2067136 | 2067136 | 2021-12-31 | Jefferson | Colorado | 8059 | 82540 | 1105 |
2054181 | 2054181 | 2021-12-27 | New Castle | Delaware | 10003 | 97915 | 1105 |
2050931 | 2050931 | 2021-12-26 | New Castle | Delaware | 10003 | 97631 | 1105 |
2047681 | 2047681 | 2021-12-25 | New Castle | Delaware | 10003 | 96862 | 1105 |
2044431 | 2044431 | 2021-12-24 | New Castle | Delaware | 10003 | 95970 | 1105 |
1985444 | 1985444 | 2021-12-05 | Spokane | Washington | 53063 | 78576 | 1105 |
1982194 | 1982194 | 2021-12-04 | Spokane | Washington | 53063 | 78576 | 1105 |
1978944 | 1978944 | 2021-12-03 | Spokane | Washington | 53063 | 78576 | 1105 |
1838246 | 1838246 | 2021-10-21 | Summit | Ohio | 39153 | 61497 | 1105 |
1834997 | 1834997 | 2021-10-20 | Summit | Ohio | 39153 | 61343 | 1105 |
1831748 | 1831748 | 2021-10-19 | Summit | Ohio | 39153 | 61200 | 1105 |
1809326 | 1809326 | 2021-10-12 | Spartanburg | South Carolina | 45083 | 60578 | 1105 |
1690658 | 1690658 | 2021-09-06 | Lake | Indiana | 18089 | 60627 | 1105 |
1687408 | 1687408 | 2021-09-05 | Lake | Indiana | 18089 | 60627 | 1105 |
1684158 | 1684158 | 2021-09-04 | Lake | Indiana | 18089 | 60627 | 1105 |
1680907 | 1680907 | 2021-09-03 | Lake | Indiana | 18089 | 60627 | 1105 |
1608936 | 1608936 | 2021-08-12 | Stanislaus | California | 6099 | 68390 | 1105 |
1453256 | 1453256 | 2021-06-25 | Cobb | Georgia | 13067 | 80505 | 1105 |
1437305 | 1437305 | 2021-06-20 | Will | Illinois | 17197 | 76918 | 1105 |
1434058 | 1434058 | 2021-06-19 | Will | Illinois | 17197 | 76918 | 1105 |
1430812 | 1430812 | 2021-06-18 | Will | Illinois | 17197 | 76918 | 1105 |
1416845 | 1416845 | 2021-06-13 | Fairfax | Virginia | 51059 | 77023 | 1105 |
1413599 | 1413599 | 2021-06-12 | Fairfax | Virginia | 51059 | 77026 | 1105 |
1410354 | 1410354 | 2021-06-11 | Fairfax | Virginia | 51059 | 77026 | 1105 |
1407109 | 1407109 | 2021-06-10 | Fairfax | Virginia | 51059 | 77027 | 1105 |
1403863 | 1403863 | 2021-06-09 | Fairfax | Virginia | 51059 | 77021 | 1105 |
1400618 | 1400618 | 2021-06-08 | Fairfax | Virginia | 51059 | 77028 | 1105 |
1397373 | 1397373 | 2021-06-07 | Fairfax | Virginia | 51059 | 77037 | 1105 |
1271371 | 1271371 | 2021-04-30 | District of Columbia | District of Columbia | 11001 | 47697 | 1105 |
1268124 | 1268124 | 2021-04-29 | District of Columbia | District of Columbia | 11001 | 47614 | 1105 |
1260360 | 1260360 | 2021-04-26 | Lancaster | Pennsylvania | 42071 | 52602 | 1105 |
1257113 | 1257113 | 2021-04-25 | Lancaster | Pennsylvania | 42071 | 52510 | 1105 |
1253866 | 1253866 | 2021-04-24 | Lancaster | Pennsylvania | 42071 | 52360 | 1105 |
1079839 | 1079839 | 2021-03-02 | Orange | Florida | 12095 | 114840 | 1105 |
1060447 | 1060447 | 2021-02-24 | Fulton | Georgia | 13121 | 84440 | 1105 |
918426 | 918426 | 2021-01-11 | Hampden | Massachusetts | 25013 | 30559 | 1105 |
911324 | 911324 | 2021-01-09 | DuPage | Illinois | 17043 | 65784 | 1105 |
668574 | 668574 | 2020-10-26 | Norfolk | Massachusetts | 25021 | 11591 | 1105 |
534638 | 534638 | 2020-09-15 | Orange | California | 6059 | 52316 | 1105 |
474210 | 474210 | 2020-08-27 | Suffolk | Massachusetts | 25025 | 23154 | 1105 |
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);