ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 1249 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- New Jersey 7
- Maryland 4
- Massachusetts 3
- Texas 3
- California 2
- Utah 2
- Alabama 1
- Illinois 1
- Louisiana 1
- Michigan 1
- Nevada 1
- New York 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450174 | 2450174 | 2022-04-27 | Fort Bend | Texas | 48157 | 186006 | 1249 |
2446917 | 2446917 | 2022-04-26 | Fort Bend | Texas | 48157 | 185753 | 1249 |
2177688 | 2177688 | 2022-02-03 | Tulare | California | 6107 | 123244 | 1249 |
2172089 | 2172089 | 2022-02-01 | Jefferson | Louisiana | 22051 | 109613 | 1249 |
2173273 | 2173273 | 2022-02-01 | Westmoreland | Pennsylvania | 42129 | 75769 | 1249 |
1975499 | 1975499 | 2021-12-02 | Salt Lake | Utah | 49035 | 212365 | 1249 |
1972250 | 1972250 | 2021-12-01 | Salt Lake | Utah | 49035 | 211688 | 1249 |
1764675 | 1764675 | 2021-09-29 | Mobile | Alabama | 1097 | 71106 | 1249 |
1760568 | 1760568 | 2021-09-27 | Greenville | South Carolina | 45045 | 99354 | 1249 |
1467018 | 1467018 | 2021-06-29 | Baltimore city | Maryland | 24510 | 53158 | 1249 |
1463773 | 1463773 | 2021-06-28 | Baltimore city | Maryland | 24510 | 53157 | 1249 |
1460528 | 1460528 | 2021-06-27 | Baltimore city | Maryland | 24510 | 53153 | 1249 |
1457283 | 1457283 | 2021-06-26 | Baltimore city | Maryland | 24510 | 53149 | 1249 |
1240374 | 1240374 | 2021-04-20 | Camden | New Jersey | 34007 | 52591 | 1249 |
1037898 | 1037898 | 2021-02-17 | DuPage | Illinois | 17043 | 75281 | 1249 |
1035270 | 1035270 | 2021-02-16 | Plymouth | Massachusetts | 25023 | 38832 | 1249 |
899580 | 899580 | 2021-01-05 | Erie | New York | 36029 | 43816 | 1249 |
850280 | 850280 | 2020-12-21 | Norfolk | Massachusetts | 25021 | 23496 | 1249 |
818983 | 818983 | 2020-12-11 | Unknown | Puerto Rico | 3232 | 1249 | |
809538 | 809538 | 2020-12-08 | El Paso | Texas | 48141 | 90748 | 1249 |
704315 | 704315 | 2020-11-06 | Oakland | Michigan | 26125 | 29154 | 1249 |
579983 | 579983 | 2020-09-29 | Orange | California | 6059 | 55022 | 1249 |
532985 | 532985 | 2020-09-14 | Passaic | New Jersey | 34031 | 18816 | 1249 |
529749 | 529749 | 2020-09-13 | Passaic | New Jersey | 34031 | 18804 | 1249 |
526513 | 526513 | 2020-09-12 | Passaic | New Jersey | 34031 | 18783 | 1249 |
523237 | 523237 | 2020-09-11 | Clark | Nevada | 32003 | 62057 | 1249 |
523277 | 523277 | 2020-09-11 | Passaic | New Jersey | 34031 | 18751 | 1249 |
516805 | 516805 | 2020-09-09 | Passaic | New Jersey | 34031 | 18703 | 1249 |
500070 | 500070 | 2020-09-04 | Essex | Massachusetts | 25009 | 18249 | 1249 |
468305 | 468305 | 2020-08-25 | Passaic | New Jersey | 34031 | 18353 | 1249 |
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);