ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 1546 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- New York 7
- New Jersey 6
- California 4
- Tennessee 4
- Colorado 1
- Georgia 1
- Michigan 1
- Minnesota 1
- Pennsylvania 1
- South Carolina 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491611 | 2491611 | 2022-05-10 | Morris | New Jersey | 34027 | 124829 | 1546 |
2488353 | 2488353 | 2022-05-09 | Morris | New Jersey | 34027 | 124531 | 1546 |
2335425 | 2335425 | 2022-03-23 | Monroe | New York | 36055 | 150422 | 1546 |
2332171 | 2332171 | 2022-03-22 | Monroe | New York | 36055 | 150279 | 1546 |
2328918 | 2328918 | 2022-03-21 | Monroe | New York | 36055 | 150252 | 1546 |
2325666 | 2325666 | 2022-03-20 | Monroe | New York | 36055 | 150214 | 1546 |
2322413 | 2322413 | 2022-03-19 | Monroe | New York | 36055 | 150175 | 1546 |
2193976 | 2193976 | 2022-02-08 | El Paso | Colorado | 8041 | 173895 | 1546 |
2080053 | 2080053 | 2022-01-04 | Alameda | California | 6001 | 145735 | 1546 |
2076801 | 2076801 | 2022-01-03 | Alameda | California | 6001 | 137131 | 1546 |
2062634 | 2062634 | 2021-12-29 | Bucks | Pennsylvania | 42017 | 90050 | 1546 |
2018566 | 2018566 | 2021-12-16 | Gwinnett | Georgia | 13135 | 138827 | 1546 |
2020550 | 2020550 | 2021-12-16 | Greenville | South Carolina | 45045 | 109710 | 1546 |
1767821 | 1767821 | 2021-09-29 | Milwaukee | Wisconsin | 55079 | 142551 | 1546 |
1316328 | 1316328 | 2021-05-13 | King | Washington | 53033 | 106277 | 1546 |
1303702 | 1303702 | 2021-05-10 | Alameda | California | 6001 | 87658 | 1546 |
1150249 | 1150249 | 2021-03-23 | Shelby | Tennessee | 47157 | 90396 | 1546 |
1147002 | 1147002 | 2021-03-22 | Shelby | Tennessee | 47157 | 90311 | 1546 |
1143755 | 1143755 | 2021-03-21 | Shelby | Tennessee | 47157 | 90217 | 1546 |
1140508 | 1140508 | 2021-03-20 | Shelby | Tennessee | 47157 | 90110 | 1546 |
1029399 | 1029399 | 2021-02-14 | Erie | New York | 36029 | 61800 | 1546 |
999683 | 999683 | 2021-02-05 | Hennepin | Minnesota | 27053 | 96785 | 1546 |
917414 | 917414 | 2021-01-11 | San Bernardino | California | 6071 | 232171 | 1546 |
880057 | 880057 | 2020-12-30 | Union | New Jersey | 34039 | 36451 | 1546 |
850347 | 850347 | 2020-12-21 | Oakland | Michigan | 26125 | 58249 | 1546 |
824877 | 824877 | 2020-12-13 | Middlesex | New Jersey | 34023 | 36946 | 1546 |
737247 | 737247 | 2020-11-16 | Hudson | New Jersey | 34017 | 27208 | 1546 |
263780 | 263780 | 2020-06-22 | Westchester | New York | 36119 | 34556 | 1546 |
155891 | 155891 | 2020-05-18 | Essex | New Jersey | 34013 | 16600 | 1546 |
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);