ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where deaths = 1519 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- New Jersey 9
- Michigan 7
- Georgia 6
- Colorado 4
- Ohio 4
- Pennsylvania 4
- California 3
- Florida 3
- Massachusetts 2
- New York 2
- Alabama 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422702 | 2422702 | 2022-04-19 | Kent | Michigan | 26081 | 166659 | 1519 |
2419446 | 2419446 | 2022-04-18 | Kent | Michigan | 26081 | 166659 | 1519 |
2416190 | 2416190 | 2022-04-17 | Kent | Michigan | 26081 | 166659 | 1519 |
2412934 | 2412934 | 2022-04-16 | Kent | Michigan | 26081 | 166659 | 1519 |
2409678 | 2409678 | 2022-04-15 | Kent | Michigan | 26081 | 166659 | 1519 |
2406422 | 2406422 | 2022-04-14 | Kent | Michigan | 26081 | 166659 | 1519 |
2403166 | 2403166 | 2022-04-13 | Kent | Michigan | 26081 | 166659 | 1519 |
2211852 | 2211852 | 2022-02-13 | Monroe | New York | 36055 | 148072 | 1519 |
2192730 | 2192730 | 2022-02-07 | Berks | Pennsylvania | 42011 | 100261 | 1519 |
2187469 | 2187469 | 2022-02-06 | El Paso | Colorado | 8041 | 172410 | 1519 |
2189476 | 2189476 | 2022-02-06 | Berks | Pennsylvania | 42011 | 100036 | 1519 |
2184216 | 2184216 | 2022-02-05 | El Paso | Colorado | 8041 | 172410 | 1519 |
2186223 | 2186223 | 2022-02-05 | Berks | Pennsylvania | 42011 | 99968 | 1519 |
2180964 | 2180964 | 2022-02-04 | El Paso | Colorado | 8041 | 172410 | 1519 |
2177713 | 2177713 | 2022-02-03 | El Paso | Colorado | 8041 | 171974 | 1519 |
2026886 | 2026886 | 2021-12-18 | Bucks | Pennsylvania | 42017 | 84914 | 1519 |
1960057 | 1960057 | 2021-11-28 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1956806 | 1956806 | 2021-11-27 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1953555 | 1953555 | 2021-11-26 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1950304 | 1950304 | 2021-11-25 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1947053 | 1947053 | 2021-11-24 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1853596 | 1853596 | 2021-10-26 | Plymouth | Massachusetts | 25023 | 59109 | 1519 |
1691995 | 1691995 | 2021-09-06 | Franklin | Ohio | 39049 | 142864 | 1519 |
1688746 | 1688746 | 2021-09-05 | Franklin | Ohio | 39049 | 142532 | 1519 |
1685496 | 1685496 | 2021-09-04 | Franklin | Ohio | 39049 | 142106 | 1519 |
1682245 | 1682245 | 2021-09-03 | Franklin | Ohio | 39049 | 141582 | 1519 |
1651379 | 1651379 | 2021-08-25 | Fulton | Georgia | 13121 | 114075 | 1519 |
1290566 | 1290566 | 2021-05-06 | Jefferson | Alabama | 1073 | 76359 | 1519 |
1280977 | 1280977 | 2021-05-03 | Alameda | California | 6001 | 86805 | 1519 |
1283865 | 1283865 | 2021-05-03 | King | Washington | 53033 | 103119 | 1519 |
1277730 | 1277730 | 2021-05-02 | Alameda | California | 6001 | 86725 | 1519 |
1108880 | 1108880 | 2021-03-11 | Fresno | California | 6019 | 96866 | 1519 |
957376 | 957376 | 2021-01-23 | Suffolk | Massachusetts | 25025 | 68226 | 1519 |
922243 | 922243 | 2021-01-12 | Passaic | New Jersey | 34031 | 46104 | 1519 |
657931 | 657931 | 2020-10-23 | Broward | Florida | 12011 | 82706 | 1519 |
654686 | 654686 | 2020-10-22 | Broward | Florida | 12011 | 82250 | 1519 |
651441 | 651441 | 2020-10-21 | Broward | Florida | 12011 | 81704 | 1519 |
626948 | 626948 | 2020-10-13 | Hudson | New Jersey | 34017 | 21445 | 1519 |
623706 | 623706 | 2020-10-12 | Hudson | New Jersey | 34017 | 21381 | 1519 |
620463 | 620463 | 2020-10-11 | Hudson | New Jersey | 34017 | 21342 | 1519 |
617221 | 617221 | 2020-10-10 | Hudson | New Jersey | 34017 | 21300 | 1519 |
604253 | 604253 | 2020-10-06 | Hudson | New Jersey | 34017 | 21114 | 1519 |
601011 | 601011 | 2020-10-05 | Hudson | New Jersey | 34017 | 21074 | 1519 |
597767 | 597767 | 2020-10-04 | Hudson | New Jersey | 34017 | 21057 | 1519 |
594525 | 594525 | 2020-10-03 | Hudson | New Jersey | 34017 | 21029 | 1519 |
210956 | 210956 | 2020-06-05 | Westchester | New York | 36119 | 33853 | 1519 |
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);