ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 1458 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- California 7
- Illinois 5
- New Jersey 4
- Kentucky 2
- Massachusetts 2
- Pennsylvania 2
- Tennessee 2
- Texas 2
- Wisconsin 2
- Georgia 1
- Nevada 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460728 | 2460728 | 2022-05-01 | Tulare | California | 6107 | 135763 | 1458 |
2457472 | 2457472 | 2022-04-30 | Tulare | California | 6107 | 135763 | 1458 |
2454216 | 2454216 | 2022-04-29 | Tulare | California | 6107 | 135763 | 1458 |
2444859 | 2444859 | 2022-04-26 | Lake | Illinois | 17097 | 152964 | 1458 |
2441603 | 2441603 | 2022-04-25 | Lake | Illinois | 17097 | 152827 | 1458 |
2438347 | 2438347 | 2022-04-24 | Lake | Illinois | 17097 | 152248 | 1458 |
2435091 | 2435091 | 2022-04-23 | Lake | Illinois | 17097 | 152248 | 1458 |
2431835 | 2431835 | 2022-04-22 | Lake | Illinois | 17097 | 152248 | 1458 |
2267580 | 2267580 | 2022-03-02 | York | Pennsylvania | 42133 | 117864 | 1458 |
2173491 | 2173491 | 2022-02-01 | Davidson | Tennessee | 47037 | 196376 | 1458 |
2170239 | 2170239 | 2022-01-31 | Davidson | Tennessee | 47037 | 196376 | 1458 |
1913696 | 1913696 | 2021-11-13 | Travis | Texas | 48453 | 120940 | 1458 |
1902892 | 1902892 | 2021-11-10 | Camden | New Jersey | 34007 | 69210 | 1458 |
1899642 | 1899642 | 2021-11-09 | Camden | New Jersey | 34007 | 69110 | 1458 |
1872307 | 1872307 | 2021-11-01 | Gwinnett | Georgia | 13135 | 133407 | 1458 |
1766914 | 1766914 | 2021-09-29 | Delaware | Pennsylvania | 42045 | 59037 | 1458 |
1733195 | 1733195 | 2021-09-19 | Jefferson | Kentucky | 21111 | 106392 | 1458 |
1729945 | 1729945 | 2021-09-18 | Jefferson | Kentucky | 21111 | 106044 | 1458 |
1664121 | 1664121 | 2021-08-29 | Kern | California | 6029 | 122950 | 1458 |
1660873 | 1660873 | 2021-08-28 | Kern | California | 6029 | 122950 | 1458 |
1657625 | 1657625 | 2021-08-27 | Kern | California | 6029 | 122950 | 1458 |
1634627 | 1634627 | 2021-08-19 | Milwaukee | Wisconsin | 55079 | 127131 | 1458 |
1631379 | 1631379 | 2021-08-18 | Milwaukee | Wisconsin | 55079 | 126840 | 1458 |
1191093 | 1191093 | 2021-04-05 | Hampden | Massachusetts | 25013 | 46719 | 1458 |
1086157 | 1086157 | 2021-03-04 | Fresno | California | 6019 | 95893 | 1458 |
973599 | 973599 | 2021-01-28 | Norfolk | Massachusetts | 25021 | 39481 | 1458 |
883298 | 883298 | 2020-12-31 | Passaic | New Jersey | 34031 | 40033 | 1458 |
744577 | 744577 | 2020-11-18 | Bexar | Texas | 48029 | 70906 | 1458 |
717786 | 717786 | 2020-11-10 | Middlesex | New Jersey | 34023 | 24555 | 1458 |
630159 | 630159 | 2020-10-14 | Clark | Nevada | 32003 | 72742 | 1458 |
607598 | 607598 | 2020-10-07 | Westchester | New York | 36119 | 38627 | 1458 |
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);