ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 8321 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Illinois 4
- Texas 4
- Utah 4
- Kansas 3
- Virginia 3
- California 2
- North Carolina 2
- Arkansas 1
- Colorado 1
- Florida 1
- Louisiana 1
- Massachusetts 1
- New Hampshire 1
- New Jersey 1
- New York 1
- Ohio 1
- Oregon 1
- Puerto Rico 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456350 | 2456350 | 2022-04-29 | Humacao | Puerto Rico | 72069 | 8321 | |
2327651 | 2327651 | 2022-03-21 | Bureau | Illinois | 17011 | 8321 | 140 |
2294166 | 2294166 | 2022-03-10 | Sanpete | Utah | 49039 | 8321 | 53 |
2290914 | 2290914 | 2022-03-09 | Sanpete | Utah | 49039 | 8321 | 53 |
2224124 | 2224124 | 2022-02-17 | Evangeline | Louisiana | 22039 | 8321 | 151 |
2024187 | 2024187 | 2021-12-17 | Rusk | Texas | 48401 | 8321 | 190 |
2001464 | 2001464 | 2021-12-10 | Van Zandt | Texas | 48467 | 8321 | 228 |
1922697 | 1922697 | 2021-11-16 | Knox | Ohio | 39083 | 8321 | 163 |
1920366 | 1920366 | 2021-11-15 | Pittsylvania | Virginia | 51143 | 8321 | 126 |
1880199 | 1880199 | 2021-11-03 | Cattaraugus | New York | 36009 | 8321 | 128 |
1865509 | 1865509 | 2021-10-30 | Mississippi | Arkansas | 5093 | 8321 | 138 |
1838988 | 1838988 | 2021-10-21 | Box Elder | Utah | 49003 | 8321 | 75 |
1835739 | 1835739 | 2021-10-20 | Box Elder | Utah | 49003 | 8321 | 75 |
1810817 | 1810817 | 2021-10-13 | Whiteside | Illinois | 17195 | 8321 | 222 |
1807568 | 1807568 | 2021-10-12 | Whiteside | Illinois | 17195 | 8321 | 222 |
1627612 | 1627612 | 2021-08-17 | Coryell | Texas | 48099 | 8321 | 95 |
1533981 | 1533981 | 2021-07-19 | Natrona | Wyoming | 56025 | 8321 | 140 |
1354206 | 1354206 | 2021-05-25 | Surry | North Carolina | 37171 | 8321 | 164 |
1264341 | 1264341 | 2021-04-27 | Roanoke city | Virginia | 51770 | 8321 | 189 |
1194897 | 1194897 | 2021-04-06 | Strafford | New Hampshire | 33017 | 8321 | 76 |
1119396 | 1119396 | 2021-03-14 | Reno | Kansas | 20155 | 8321 | 126 |
1116149 | 1116149 | 2021-03-13 | Reno | Kansas | 20155 | 8321 | 126 |
1112903 | 1112903 | 2021-03-12 | Reno | Kansas | 20155 | 8321 | 126 |
1059938 | 1059938 | 2021-02-23 | Manitowoc | Wisconsin | 55071 | 8321 | 80 |
1054125 | 1054125 | 2021-02-22 | DeKalb | Illinois | 17037 | 8321 | 116 |
786858 | 786858 | 2020-12-01 | Hays | Texas | 48209 | 8321 | 104 |
757175 | 757175 | 2020-11-22 | Marion | Oregon | 41047 | 8321 | 127 |
745450 | 745450 | 2020-11-19 | Douglas | Colorado | 8035 | 8321 | 94 |
711436 | 711436 | 2020-11-08 | Gaston | North Carolina | 37071 | 8321 | 145 |
669128 | 669128 | 2020-10-26 | Burlington | New Jersey | 34005 | 8321 | 513 |
476567 | 476567 | 2020-08-28 | Marion | Florida | 12083 | 8321 | 169 |
363224 | 363224 | 2020-07-23 | Prince William | Virginia | 51153 | 8321 | 165 |
357260 | 357260 | 2020-07-22 | Santa Clara | California | 6085 | 8321 | 181 |
350851 | 350851 | 2020-07-20 | San Joaquin | California | 6077 | 8321 | 94 |
304074 | 304074 | 2020-07-05 | Bristol | Massachusetts | 25005 | 8321 | 590 |
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);