ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 1246 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- New Jersey 13
- Michigan 5
- Georgia 4
- Pennsylvania 4
- Texas 4
- Delaware 3
- Florida 2
- Washington 2
- Connecticut 1
- Illinois 1
- Indiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501885 | 2501885 | 2022-05-13 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
2498627 | 2498627 | 2022-05-12 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
2495369 | 2495369 | 2022-05-11 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
2203314 | 2203314 | 2022-02-10 | Spokane | Washington | 53063 | 118688 | 1246 |
2200060 | 2200060 | 2022-02-09 | Spokane | Washington | 53063 | 118688 | 1246 |
2190776 | 2190776 | 2022-02-07 | New Castle | Delaware | 10003 | 142562 | 1246 |
2187523 | 2187523 | 2022-02-06 | New Castle | Delaware | 10003 | 142416 | 1246 |
2184270 | 2184270 | 2022-02-05 | New Castle | Delaware | 10003 | 142195 | 1246 |
2124805 | 2124805 | 2022-01-17 | Collin | Texas | 48085 | 171234 | 1246 |
2121553 | 2121553 | 2022-01-16 | Collin | Texas | 48085 | 168399 | 1246 |
2103278 | 2103278 | 2022-01-11 | Lake | Illinois | 17097 | 117448 | 1246 |
2101708 | 2101708 | 2022-01-10 | York | Pennsylvania | 42133 | 97191 | 1246 |
2074647 | 2074647 | 2022-01-02 | Kent | Michigan | 26081 | 122995 | 1246 |
2071396 | 2071396 | 2022-01-01 | Kent | Michigan | 26081 | 122995 | 1246 |
2068145 | 2068145 | 2021-12-31 | Kent | Michigan | 26081 | 122995 | 1246 |
2064894 | 2064894 | 2021-12-30 | Kent | Michigan | 26081 | 122995 | 1246 |
2061644 | 2061644 | 2021-12-29 | Kent | Michigan | 26081 | 122995 | 1246 |
1958222 | 1958222 | 2021-11-27 | Monroe | New York | 36055 | 96727 | 1246 |
1901846 | 1901846 | 2021-11-10 | Lake | Indiana | 18089 | 68289 | 1246 |
1664377 | 1664377 | 2021-08-29 | Gwinnett | Georgia | 13135 | 114427 | 1246 |
1661129 | 1661129 | 2021-08-28 | Gwinnett | Georgia | 13135 | 114427 | 1246 |
1657881 | 1657881 | 2021-08-27 | Gwinnett | Georgia | 13135 | 114427 | 1246 |
1636487 | 1636487 | 2021-08-20 | Morris | New Jersey | 34027 | 52436 | 1246 |
1633237 | 1633237 | 2021-08-19 | Morris | New Jersey | 34027 | 52309 | 1246 |
1629990 | 1629990 | 2021-08-18 | Morris | New Jersey | 34027 | 52234 | 1246 |
1581263 | 1581263 | 2021-08-03 | Morris | New Jersey | 34027 | 51227 | 1246 |
1233880 | 1233880 | 2021-04-18 | Camden | New Jersey | 34007 | 52289 | 1246 |
1230632 | 1230632 | 2021-04-17 | Camden | New Jersey | 34007 | 52121 | 1246 |
1151340 | 1151340 | 2021-03-24 | Fulton | Georgia | 13121 | 90853 | 1246 |
1122007 | 1122007 | 2021-03-15 | Duval | Florida | 12031 | 90716 | 1246 |
996303 | 996303 | 2021-02-04 | Prince George's | Maryland | 24033 | 68800 | 1246 |
949053 | 949053 | 2021-01-20 | Cameron | Texas | 48061 | 33304 | 1246 |
827675 | 827675 | 2020-12-14 | Hennepin | Minnesota | 27053 | 79756 | 1246 |
778882 | 778882 | 2020-11-29 | Suffolk | Massachusetts | 25025 | 36836 | 1246 |
553239 | 553239 | 2020-09-20 | Bexar | Texas | 48029 | 53353 | 1246 |
487705 | 487705 | 2020-08-31 | Passaic | New Jersey | 34031 | 18493 | 1246 |
465077 | 465077 | 2020-08-24 | Passaic | New Jersey | 34031 | 18334 | 1246 |
461847 | 461847 | 2020-08-23 | Passaic | New Jersey | 34031 | 18320 | 1246 |
458619 | 458619 | 2020-08-22 | Passaic | New Jersey | 34031 | 18291 | 1246 |
455392 | 455392 | 2020-08-21 | Passaic | New Jersey | 34031 | 18232 | 1246 |
378071 | 378071 | 2020-07-28 | Passaic | New Jersey | 34031 | 17504 | 1246 |
338193 | 338193 | 2020-07-16 | Miami-Dade | Florida | 12086 | 75424 | 1246 |
232525 | 232525 | 2020-06-12 | Hudson | New Jersey | 34017 | 18693 | 1246 |
184887 | 184887 | 2020-05-28 | Fairfield | Connecticut | 9001 | 15353 | 1246 |
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);