ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 9588 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Indiana 5
- California 4
- North Carolina 4
- Kentucky 3
- Ohio 3
- Tennessee 3
- Missouri 2
- New York 2
- Arkansas 1
- Georgia 1
- Hawaii 1
- Iowa 1
- Louisiana 1
- Massachusetts 1
- Minnesota 1
- Montana 1
- New Mexico 1
- Puerto Rico 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470411 | 2470411 | 2022-05-04 | Miller | Arkansas | 5091 | 9588 | 181 |
2246520 | 2246520 | 2022-02-24 | Steuben | Indiana | 18151 | 9588 | 119 |
2223779 | 2223779 | 2022-02-17 | Whitley | Indiana | 18183 | 9588 | 79 |
2220528 | 2220528 | 2022-02-16 | Whitley | Indiana | 18183 | 9588 | 79 |
2222136 | 2222136 | 2022-02-16 | Trujillo Alto | Puerto Rico | 72139 | 9588 | |
2218317 | 2218317 | 2022-02-15 | Rio Arriba | New Mexico | 35039 | 9588 | 114 |
2125629 | 2125629 | 2022-01-18 | Tuolumne | California | 6109 | 9588 | 153 |
2039749 | 2039749 | 2021-12-22 | Seneca | Ohio | 39147 | 9588 | 172 |
2009963 | 2009963 | 2021-12-13 | Taney | Missouri | 29213 | 9588 | 173 |
2007689 | 2007689 | 2021-12-12 | Loudon | Tennessee | 47105 | 9588 | 108 |
2004438 | 2004438 | 2021-12-11 | Loudon | Tennessee | 47105 | 9588 | 108 |
2001187 | 2001187 | 2021-12-10 | Loudon | Tennessee | 47105 | 9588 | 108 |
1967999 | 1967999 | 2021-11-30 | Sullivan | New York | 36105 | 9588 | 90 |
1964953 | 1964953 | 2021-11-29 | Huron | Ohio | 39077 | 9588 | 155 |
1944706 | 1944706 | 2021-11-23 | Kandiyohi | Minnesota | 27067 | 9588 | 104 |
1778705 | 1778705 | 2021-10-03 | McCracken | Kentucky | 21145 | 9588 | 158 |
1775455 | 1775455 | 2021-10-02 | McCracken | Kentucky | 21145 | 9588 | 158 |
1772205 | 1772205 | 2021-10-01 | McCracken | Kentucky | 21145 | 9588 | 158 |
1742438 | 1742438 | 2021-09-22 | Hawaii | Hawaii | 15001 | 9588 | 80 |
1740520 | 1740520 | 2021-09-21 | Oswego | New York | 36075 | 9588 | 101 |
1552141 | 1552141 | 2021-07-25 | Brunswick | North Carolina | 37019 | 9588 | 156 |
1548894 | 1548894 | 2021-07-24 | Brunswick | North Carolina | 37019 | 9588 | 156 |
1545647 | 1545647 | 2021-07-23 | Brunswick | North Carolina | 37019 | 9588 | 156 |
1512880 | 1512880 | 2021-07-13 | Cascade | Montana | 30013 | 9588 | 188 |
1477064 | 1477064 | 2021-07-02 | Cass | Missouri | 29037 | 9588 | 116 |
1372439 | 1372439 | 2021-05-31 | Kosciusko | Indiana | 18085 | 9588 | 122 |
1369194 | 1369194 | 2021-05-30 | Kosciusko | Indiana | 18085 | 9588 | 122 |
1291679 | 1291679 | 2021-05-06 | Lafourche | Louisiana | 22057 | 9588 | 204 |
1216040 | 1216040 | 2021-04-13 | El Dorado | California | 6017 | 9588 | 108 |
1193576 | 1193576 | 2021-04-06 | Jackson | Georgia | 13157 | 9588 | 144 |
1081912 | 1081912 | 2021-03-02 | Lancaster | South Carolina | 45057 | 9588 | 146 |
1021921 | 1021921 | 2021-02-12 | Pottawattamie | Iowa | 19155 | 9588 | 139 |
997198 | 997198 | 2021-02-04 | Miami | Ohio | 39109 | 9588 | 78 |
774370 | 774370 | 2020-11-27 | Washington | Wisconsin | 55131 | 9588 | 74 |
701702 | 701702 | 2020-11-05 | Durham | North Carolina | 37063 | 9588 | 104 |
674031 | 674031 | 2020-10-28 | Merced | California | 6047 | 9588 | 155 |
641604 | 641604 | 2020-10-18 | Santa Barbara | California | 6083 | 9588 | 119 |
339060 | 339060 | 2020-07-16 | Norfolk | Massachusetts | 25021 | 9588 | 962 |
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);