ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 1687 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Florida 8
- California 7
- Ohio 7
- Georgia 3
- Massachusetts 3
- New Jersey 3
- Alabama 2
- Pennsylvania 2
- Illinois 1
- Maryland 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369768 | 2369768 | 2022-04-03 | DeKalb | Georgia | 13089 | 149674 | 1687 |
2366515 | 2366515 | 2022-04-02 | DeKalb | Georgia | 13089 | 149674 | 1687 |
2363262 | 2363262 | 2022-04-01 | DeKalb | Georgia | 13089 | 149674 | 1687 |
2335691 | 2335691 | 2022-03-23 | Stark | Ohio | 39151 | 79566 | 1687 |
2332437 | 2332437 | 2022-03-22 | Stark | Ohio | 39151 | 79566 | 1687 |
2329184 | 2329184 | 2022-03-21 | Stark | Ohio | 39151 | 79566 | 1687 |
2325932 | 2325932 | 2022-03-20 | Stark | Ohio | 39151 | 79566 | 1687 |
2322679 | 2322679 | 2022-03-19 | Stark | Ohio | 39151 | 79566 | 1687 |
2319425 | 2319425 | 2022-03-18 | Stark | Ohio | 39151 | 79566 | 1687 |
2316171 | 2316171 | 2022-03-17 | Stark | Ohio | 39151 | 79566 | 1687 |
2294119 | 2294119 | 2022-03-10 | Travis | Texas | 48453 | 219497 | 1687 |
2284998 | 2284998 | 2022-03-08 | Stanislaus | California | 6099 | 136243 | 1687 |
2213417 | 2213417 | 2022-02-14 | Alameda | California | 6001 | 258530 | 1687 |
2210165 | 2210165 | 2022-02-13 | Alameda | California | 6001 | 256986 | 1687 |
2194084 | 2194084 | 2022-02-08 | Pasco | Florida | 12101 | 116068 | 1687 |
2190830 | 2190830 | 2022-02-07 | Pasco | Florida | 12101 | 116068 | 1687 |
2187577 | 2187577 | 2022-02-06 | Pasco | Florida | 12101 | 116068 | 1687 |
2184324 | 2184324 | 2022-02-05 | Pasco | Florida | 12101 | 116068 | 1687 |
2181072 | 2181072 | 2022-02-04 | Pasco | Florida | 12101 | 116068 | 1687 |
2177821 | 2177821 | 2022-02-03 | Pasco | Florida | 12101 | 112390 | 1687 |
2174568 | 2174568 | 2022-02-02 | Pasco | Florida | 12101 | 112390 | 1687 |
2155363 | 2155363 | 2022-01-27 | Unknown | Illinois | 0 | 1687 | |
2150467 | 2150467 | 2022-01-25 | Lancaster | Pennsylvania | 42071 | 114058 | 1687 |
1921829 | 1921829 | 2021-11-16 | Hampden | Massachusetts | 25013 | 67825 | 1687 |
1807093 | 1807093 | 2021-10-12 | San Joaquin | California | 6077 | 101376 | 1687 |
1803842 | 1803842 | 2021-10-11 | San Joaquin | California | 6077 | 101308 | 1687 |
1702941 | 1702941 | 2021-09-10 | Jefferson | Alabama | 1073 | 106362 | 1687 |
1699691 | 1699691 | 2021-09-09 | Jefferson | Alabama | 1073 | 105851 | 1687 |
1512465 | 1512465 | 2021-07-13 | Baltimore | Maryland | 24005 | 66115 | 1687 |
1381616 | 1381616 | 2021-06-03 | Alameda | California | 6001 | 89046 | 1687 |
1316697 | 1316697 | 2021-05-14 | Fresno | California | 6019 | 101862 | 1687 |
1312316 | 1312316 | 2021-05-12 | Montgomery | Pennsylvania | 42091 | 69198 | 1687 |
1259291 | 1259291 | 2021-04-26 | Bristol | Massachusetts | 25005 | 64233 | 1687 |
1074784 | 1074784 | 2021-02-28 | Passaic | New Jersey | 34031 | 56840 | 1687 |
1067727 | 1067727 | 2021-02-26 | Suffolk | Massachusetts | 25025 | 77831 | 1687 |
876801 | 876801 | 2020-12-29 | Hudson | New Jersey | 34017 | 43088 | 1687 |
790951 | 790951 | 2020-12-03 | Broward | Florida | 12011 | 110517 | 1687 |
204691 | 204691 | 2020-06-03 | Essex | New Jersey | 34013 | 17811 | 1687 |
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);