ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 981 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- North Carolina 7
- Colorado 5
- Louisiana 5
- Delaware 4
- Illinois 4
- Missouri 4
- New Jersey 4
- Washington 4
- Kansas 3
- Michigan 3
- Pennsylvania 3
- Texas 3
- Florida 2
- Georgia 2
- New Mexico 2
- Ohio 2
- Arizona 1
- California 1
- Maryland 1
- Minnesota 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501690 | 2501690 | 2022-05-13 | Lorain | Ohio | 39093 | 68382 | 981 |
2498432 | 2498432 | 2022-05-12 | Lorain | Ohio | 39093 | 68382 | 981 |
2401276 | 2401276 | 2022-04-12 | Brazoria | Texas | 48039 | 93447 | 981 |
2211976 | 2211976 | 2022-02-13 | Wake | North Carolina | 37183 | 278746 | 981 |
2208723 | 2208723 | 2022-02-12 | Wake | North Carolina | 37183 | 278746 | 981 |
2205470 | 2205470 | 2022-02-11 | Wake | North Carolina | 37183 | 278746 | 981 |
2202217 | 2202217 | 2022-02-10 | Wake | North Carolina | 37183 | 277817 | 981 |
2157233 | 2157233 | 2022-01-27 | Hamilton | Tennessee | 47065 | 87645 | 981 |
2146458 | 2146458 | 2022-01-24 | Jackson | Missouri | 29095 | 86236 | 981 |
2143203 | 2143203 | 2022-01-23 | Jackson | Missouri | 29095 | 85856 | 981 |
2139948 | 2139948 | 2022-01-22 | Jackson | Missouri | 29095 | 85252 | 981 |
2136692 | 2136692 | 2022-01-21 | Jackson | Missouri | 29095 | 84541 | 981 |
2086479 | 2086479 | 2022-01-06 | Yavapai | Arizona | 4025 | 37245 | 981 |
2018755 | 2018755 | 2021-12-16 | Kane | Illinois | 17089 | 78353 | 981 |
2006048 | 2006048 | 2021-12-12 | Johnson | Kansas | 20091 | 86028 | 981 |
2002797 | 2002797 | 2021-12-11 | Johnson | Kansas | 20091 | 86028 | 981 |
1999547 | 1999547 | 2021-12-10 | Johnson | Kansas | 20091 | 86028 | 981 |
1995191 | 1995191 | 2021-12-08 | Pierce | Washington | 53053 | 100720 | 981 |
1989545 | 1989545 | 2021-12-07 | Unknown | Illinois | 0 | 981 | |
1989982 | 1989982 | 2021-12-07 | Caddo | Louisiana | 22017 | 40319 | 981 |
1991157 | 1991157 | 2021-12-07 | Lehigh | Pennsylvania | 42077 | 54835 | 981 |
1986732 | 1986732 | 2021-12-06 | Caddo | Louisiana | 22017 | 40281 | 981 |
1983482 | 1983482 | 2021-12-05 | Caddo | Louisiana | 22017 | 40205 | 981 |
1984147 | 1984147 | 2021-12-05 | Burlington | New Jersey | 34005 | 59967 | 981 |
1980232 | 1980232 | 2021-12-04 | Caddo | Louisiana | 22017 | 40205 | 981 |
1980897 | 1980897 | 2021-12-04 | Burlington | New Jersey | 34005 | 59682 | 981 |
1976982 | 1976982 | 2021-12-03 | Caddo | Louisiana | 22017 | 40205 | 981 |
1959875 | 1959875 | 2021-11-28 | Jefferson | Colorado | 8059 | 72064 | 981 |
1956624 | 1956624 | 2021-11-27 | Jefferson | Colorado | 8059 | 71935 | 981 |
1953373 | 1953373 | 2021-11-26 | Jefferson | Colorado | 8059 | 71935 | 981 |
1950122 | 1950122 | 2021-11-25 | Jefferson | Colorado | 8059 | 71935 | 981 |
1937092 | 1937092 | 2021-11-21 | Arapahoe | Colorado | 8005 | 88566 | 981 |
1877430 | 1877430 | 2021-11-02 | York | Pennsylvania | 42133 | 63225 | 981 |
1848948 | 1848948 | 2021-10-24 | Spokane | Washington | 53063 | 71290 | 981 |
1845698 | 1845698 | 2021-10-23 | Spokane | Washington | 53063 | 71290 | 981 |
1842448 | 1842448 | 2021-10-22 | Spokane | Washington | 53063 | 71290 | 981 |
1832296 | 1832296 | 2021-10-19 | Denton | Texas | 48121 | 105739 | 981 |
1803936 | 1803936 | 2021-10-11 | New Castle | Delaware | 10003 | 78856 | 981 |
1800687 | 1800687 | 2021-10-10 | New Castle | Delaware | 10003 | 78643 | 981 |
1797438 | 1797438 | 2021-10-09 | New Castle | Delaware | 10003 | 78539 | 981 |
1794189 | 1794189 | 2021-10-08 | New Castle | Delaware | 10003 | 78233 | 981 |
1587225 | 1587225 | 2021-08-05 | Genesee | Michigan | 26049 | 42189 | 981 |
1583974 | 1583974 | 2021-08-04 | Genesee | Michigan | 26049 | 42189 | 981 |
1580725 | 1580725 | 2021-08-03 | Genesee | Michigan | 26049 | 42189 | 981 |
1581272 | 1581272 | 2021-08-03 | Bernalillo | New Mexico | 35001 | 61093 | 981 |
1578023 | 1578023 | 2021-08-02 | Bernalillo | New Mexico | 35001 | 60961 | 981 |
1516470 | 1516470 | 2021-07-14 | Mecklenburg | North Carolina | 37119 | 115501 | 981 |
1513223 | 1513223 | 2021-07-13 | Mecklenburg | North Carolina | 37119 | 115389 | 981 |
1509977 | 1509977 | 2021-07-12 | Mecklenburg | North Carolina | 37119 | 115309 | 981 |
1313611 | 1313611 | 2021-05-13 | Lee | Florida | 12071 | 71730 | 981 |
1255247 | 1255247 | 2021-04-25 | DeKalb | Georgia | 13089 | 64806 | 981 |
1252000 | 1252000 | 2021-04-24 | DeKalb | Georgia | 13089 | 64734 | 981 |
1173865 | 1173865 | 2021-03-31 | Ventura | California | 6111 | 79668 | 981 |
1041171 | 1041171 | 2021-02-18 | Lake | Illinois | 17097 | 58393 | 981 |
992207 | 992207 | 2021-02-03 | Orange | Florida | 12095 | 104620 | 981 |
905416 | 905416 | 2021-01-07 | Baltimore | Maryland | 24005 | 40788 | 981 |
902770 | 902770 | 2021-01-06 | Morris | New Jersey | 34027 | 24804 | 981 |
862644 | 862644 | 2020-12-25 | DuPage | Illinois | 17043 | 59577 | 981 |
812398 | 812398 | 2020-12-09 | Montgomery | Pennsylvania | 42091 | 26123 | 981 |
658956 | 658956 | 2020-10-23 | Hennepin | Minnesota | 27053 | 33310 | 981 |
456220 | 456220 | 2020-08-21 | Bexar | Texas | 48029 | 44653 | 981 |
137868 | 137868 | 2020-05-12 | Hudson | New Jersey | 34017 | 16975 | 981 |
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);