ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 1588 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Pennsylvania 7
- California 6
- Texas 5
- Colorado 3
- Connecticut 3
- Kentucky 3
- Florida 2
- Massachusetts 2
- New Jersey 2
- Maryland 1
- Minnesota 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2352089 | 2352089 | 2022-03-28 | Berks | Pennsylvania | 42011 | 102083 | 1588 |
2348837 | 2348837 | 2022-03-27 | Berks | Pennsylvania | 42011 | 102078 | 1588 |
2345584 | 2345584 | 2022-03-26 | Berks | Pennsylvania | 42011 | 102069 | 1588 |
2342331 | 2342331 | 2022-03-25 | Berks | Pennsylvania | 42011 | 102050 | 1588 |
2339078 | 2339078 | 2022-03-24 | Berks | Pennsylvania | 42011 | 102032 | 1588 |
2310424 | 2310424 | 2022-03-15 | Salt Lake | Utah | 49035 | 340399 | 1588 |
2265511 | 2265511 | 2022-03-02 | El Paso | Colorado | 8041 | 179033 | 1588 |
2262260 | 2262260 | 2022-03-01 | El Paso | Colorado | 8041 | 178907 | 1588 |
2259009 | 2259009 | 2022-02-28 | El Paso | Colorado | 8041 | 178781 | 1588 |
2210214 | 2210214 | 2022-02-13 | Stanislaus | California | 6099 | 131944 | 1588 |
2206961 | 2206961 | 2022-02-12 | Stanislaus | California | 6099 | 131944 | 1588 |
2203708 | 2203708 | 2022-02-11 | Stanislaus | California | 6099 | 131944 | 1588 |
2119071 | 2119071 | 2022-01-16 | Alameda | California | 6001 | 185120 | 1588 |
2115819 | 2115819 | 2022-01-15 | Alameda | California | 6001 | 185120 | 1588 |
2112568 | 2112568 | 2022-01-14 | Alameda | California | 6001 | 185120 | 1588 |
2082154 | 2082154 | 2022-01-04 | Delaware | Pennsylvania | 42045 | 84648 | 1588 |
1986842 | 1986842 | 2021-12-06 | Plymouth | Massachusetts | 25023 | 66892 | 1588 |
1892403 | 1892403 | 2021-11-07 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1889153 | 1889153 | 2021-11-06 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1885903 | 1885903 | 2021-11-05 | Jefferson | Kentucky | 21111 | 121482 | 1588 |
1421592 | 1421592 | 2021-06-15 | Prince George's | Maryland | 24033 | 85402 | 1588 |
1285840 | 1285840 | 2021-05-04 | Monmouth | New Jersey | 34025 | 74552 | 1588 |
1202260 | 1202260 | 2021-04-08 | Cameron | Texas | 48061 | 38980 | 1588 |
1199011 | 1199011 | 2021-04-07 | Cameron | Texas | 48061 | 38980 | 1588 |
1195762 | 1195762 | 2021-04-06 | Cameron | Texas | 48061 | 38937 | 1588 |
1192514 | 1192514 | 2021-04-05 | Cameron | Texas | 48061 | 38864 | 1588 |
1133719 | 1133719 | 2021-03-18 | Montgomery | Pennsylvania | 42091 | 56841 | 1588 |
1087314 | 1087314 | 2021-03-04 | Hennepin | Minnesota | 27053 | 101110 | 1588 |
999570 | 999570 | 2021-02-05 | Suffolk | Massachusetts | 25025 | 73016 | 1588 |
906612 | 906612 | 2021-01-07 | Unknown | Puerto Rico | 3933 | 1588 | |
823384 | 823384 | 2020-12-13 | Fairfield | Connecticut | 9001 | 46615 | 1588 |
820138 | 820138 | 2020-12-12 | Fairfield | Connecticut | 9001 | 46615 | 1588 |
816892 | 816892 | 2020-12-11 | Fairfield | Connecticut | 9001 | 46615 | 1588 |
687166 | 687166 | 2020-11-01 | Palm Beach | Florida | 12099 | 52777 | 1588 |
683922 | 683922 | 2020-10-31 | Palm Beach | Florida | 12099 | 52445 | 1588 |
563043 | 563043 | 2020-09-23 | Hidalgo | Texas | 48215 | 31102 | 1588 |
171039 | 171039 | 2020-05-23 | Essex | New Jersey | 34013 | 17065 | 1588 |
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);