ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 922 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 8
- Pennsylvania 7
- Tennessee 6
- Arizona 5
- Minnesota 4
- New Jersey 4
- Alabama 3
- Massachusetts 3
- California 2
- Colorado 2
- Maryland 2
- New York 2
- North Carolina 2
- Ohio 2
- South Carolina 2
- Texas 2
- Connecticut 1
- Michigan 1
- Missouri 1
- Nebraska 1
- New Mexico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333600 | 2333600 | 2022-03-23 | Montgomery | Alabama | 1101 | 54641 | 922 |
2330346 | 2330346 | 2022-03-22 | Montgomery | Alabama | 1101 | 54633 | 922 |
2304317 | 2304317 | 2022-03-14 | Madison | Alabama | 1089 | 88782 | 922 |
2189085 | 2189085 | 2022-02-06 | Orange | New York | 36071 | 103987 | 922 |
2171321 | 2171321 | 2022-02-01 | Seminole | Florida | 12117 | 96401 | 922 |
2168068 | 2168068 | 2022-01-31 | Seminole | Florida | 12117 | 96401 | 922 |
2164813 | 2164813 | 2022-01-30 | Seminole | Florida | 12117 | 96401 | 922 |
2161558 | 2161558 | 2022-01-29 | Seminole | Florida | 12117 | 96401 | 922 |
2158302 | 2158302 | 2022-01-28 | Seminole | Florida | 12117 | 96401 | 922 |
2155049 | 2155049 | 2022-01-27 | Seminole | Florida | 12117 | 92150 | 922 |
2151796 | 2151796 | 2022-01-26 | Seminole | Florida | 12117 | 92150 | 922 |
2124699 | 2124699 | 2022-01-17 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2121447 | 2121447 | 2022-01-16 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2117512 | 2117512 | 2022-01-15 | Onondaga | New York | 36067 | 91347 | 922 |
2118195 | 2118195 | 2022-01-15 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2114944 | 2114944 | 2022-01-14 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2081564 | 2081564 | 2022-01-04 | Douglas | Nebraska | 31055 | 106957 | 922 |
1927203 | 1927203 | 2021-11-18 | Yuma | Arizona | 4027 | 42296 | 922 |
1923953 | 1923953 | 2021-11-17 | Yuma | Arizona | 4027 | 42246 | 922 |
1901341 | 1901341 | 2021-11-10 | Adams | Colorado | 8001 | 80725 | 922 |
1861429 | 1861429 | 2021-10-28 | Knox | Tennessee | 47093 | 78642 | 922 |
1854660 | 1854660 | 2021-10-26 | Luzerne | Pennsylvania | 42079 | 40601 | 922 |
1825415 | 1825415 | 2021-10-17 | Lehigh | Pennsylvania | 42077 | 47612 | 922 |
1822166 | 1822166 | 2021-10-16 | Lehigh | Pennsylvania | 42077 | 47549 | 922 |
1818917 | 1818917 | 2021-10-15 | Lehigh | Pennsylvania | 42077 | 47461 | 922 |
1813627 | 1813627 | 2021-10-14 | Denver | Colorado | 8031 | 88667 | 922 |
1815668 | 1815668 | 2021-10-14 | Lehigh | Pennsylvania | 42077 | 47385 | 922 |
1766422 | 1766422 | 2021-09-29 | Burlington | New Jersey | 34005 | 51932 | 922 |
1767403 | 1767403 | 2021-09-29 | Lubbock | Texas | 48303 | 63640 | 922 |
1763173 | 1763173 | 2021-09-28 | Burlington | New Jersey | 34005 | 51810 | 922 |
1655563 | 1655563 | 2021-08-26 | Ramsey | Minnesota | 27123 | 55811 | 922 |
1652316 | 1652316 | 2021-08-25 | Ramsey | Minnesota | 27123 | 55657 | 922 |
1630987 | 1630987 | 2021-08-18 | Nueces | Texas | 48355 | 49207 | 922 |
1563324 | 1563324 | 2021-07-29 | Pinal | Arizona | 4021 | 56169 | 922 |
1560076 | 1560076 | 2021-07-28 | Pinal | Arizona | 4021 | 56001 | 922 |
1556829 | 1556829 | 2021-07-27 | Pinal | Arizona | 4021 | 55830 | 922 |
1497924 | 1497924 | 2021-07-08 | Salt Lake | Utah | 49035 | 154761 | 922 |
1243640 | 1243640 | 2021-04-21 | Bernalillo | New Mexico | 35001 | 56202 | 922 |
1221640 | 1221640 | 2021-04-14 | Davidson | Tennessee | 47037 | 96014 | 922 |
1204818 | 1204818 | 2021-04-09 | Mecklenburg | North Carolina | 37119 | 104865 | 922 |
1201570 | 1201570 | 2021-04-08 | Mecklenburg | North Carolina | 37119 | 104510 | 922 |
1135863 | 1135863 | 2021-03-19 | Baltimore city | Maryland | 24510 | 42439 | 922 |
1133848 | 1133848 | 2021-03-18 | Greenville | South Carolina | 45045 | 66812 | 922 |
1130600 | 1130600 | 2021-03-17 | Greenville | South Carolina | 45045 | 66633 | 922 |
1049149 | 1049149 | 2021-02-20 | Summit | Ohio | 39153 | 39304 | 922 |
1045902 | 1045902 | 2021-02-19 | Summit | Ohio | 39153 | 39209 | 922 |
834619 | 834619 | 2020-12-16 | Morris | New Jersey | 34027 | 17509 | 922 |
811331 | 811331 | 2020-12-09 | Plymouth | Massachusetts | 25023 | 17150 | 922 |
808650 | 808650 | 2020-12-08 | Monmouth | New Jersey | 34025 | 23616 | 922 |
794242 | 794242 | 2020-12-04 | Pinellas | Florida | 12103 | 34152 | 922 |
795101 | 795101 | 2020-12-04 | Hampden | Massachusetts | 25013 | 17551 | 922 |
757233 | 757233 | 2020-11-22 | Montgomery | Pennsylvania | 42091 | 19557 | 922 |
753986 | 753986 | 2020-11-21 | Montgomery | Pennsylvania | 42091 | 19213 | 922 |
749650 | 749650 | 2020-11-20 | Montgomery | Maryland | 24031 | 30621 | 922 |
740291 | 740291 | 2020-11-17 | St. Louis | Missouri | 29189 | 42841 | 922 |
567021 | 567021 | 2020-09-25 | San Bernardino | California | 6071 | 53669 | 922 |
555197 | 555197 | 2020-09-21 | Hennepin | Minnesota | 27053 | 26054 | 922 |
551959 | 551959 | 2020-09-20 | Hennepin | Minnesota | 27053 | 25857 | 922 |
450589 | 450589 | 2020-08-20 | Riverside | California | 6065 | 48956 | 922 |
294652 | 294652 | 2020-07-02 | Macomb | Michigan | 26099 | 7709 | 922 |
210357 | 210357 | 2020-06-05 | Suffolk | Massachusetts | 25025 | 18858 | 922 |
175749 | 175749 | 2020-05-25 | New Haven | Connecticut | 9009 | 11017 | 922 |
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);