ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 12195 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Oregon 4
- Illinois 3
- Pennsylvania 3
- Virginia 3
- Florida 2
- Arkansas 1
- Connecticut 1
- Idaho 1
- Kentucky 1
- Louisiana 1
- Massachusetts 1
- Minnesota 1
- New Mexico 1
- Ohio 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2246369 | 2246369 | 2022-02-24 | Franklin | Illinois | 17055 | 12195 | 172 |
2175302 | 2175302 | 2022-02-02 | Shelby | Kentucky | 21211 | 12195 | 137 |
2171575 | 2171575 | 2022-02-01 | Grundy | Illinois | 17063 | 12195 | 127 |
2094942 | 2094942 | 2022-01-08 | Belmont | Ohio | 39013 | 12195 | 246 |
1917128 | 1917128 | 2021-11-14 | Roanoke | Virginia | 51161 | 12195 | 180 |
1913878 | 1913878 | 2021-11-13 | Roanoke | Virginia | 51161 | 12195 | 180 |
1910628 | 1910628 | 2021-11-12 | Roanoke | Virginia | 51161 | 12195 | 180 |
1677508 | 1677508 | 2021-09-02 | Twin Falls | Idaho | 16083 | 12195 | 149 |
1614253 | 1614253 | 2021-08-13 | Lycoming | Pennsylvania | 42081 | 12195 | 300 |
1577605 | 1577605 | 2021-08-02 | Sherburne | Minnesota | 27141 | 12195 | 96 |
1552470 | 1552470 | 2021-07-25 | Jackson | Oregon | 41029 | 12195 | 151 |
1549223 | 1549223 | 2021-07-24 | Jackson | Oregon | 41029 | 12195 | 151 |
1545976 | 1545976 | 2021-07-23 | Jackson | Oregon | 41029 | 12195 | 151 |
1425459 | 1425459 | 2021-06-16 | Sandoval | New Mexico | 35043 | 12195 | 241 |
1311167 | 1311167 | 2021-05-12 | Rapides | Louisiana | 22079 | 12195 | 316 |
1266802 | 1266802 | 2021-04-28 | Lane | Oregon | 41039 | 12195 | 144 |
1235684 | 1235684 | 2021-04-19 | Indian River | Florida | 12061 | 12195 | 290 |
1173756 | 1173756 | 2021-03-31 | Faulkner | Arkansas | 5045 | 12195 | 157 |
1147954 | 1147954 | 2021-03-23 | Litchfield | Connecticut | 9005 | 12195 | 282 |
1026568 | 1026568 | 2021-02-13 | Centre | Pennsylvania | 42027 | 12195 | 204 |
960063 | 960063 | 2021-01-24 | Rock Island | Illinois | 17161 | 12195 | 308 |
958408 | 958408 | 2021-01-23 | Butler | Pennsylvania | 42019 | 12195 | 308 |
955641 | 955641 | 2021-01-22 | Kaufman | Texas | 48257 | 12195 | 163 |
949571 | 949571 | 2021-01-20 | Fond du Lac | Wisconsin | 55039 | 12195 | 83 |
710736 | 710736 | 2020-11-08 | Plymouth | Massachusetts | 25023 | 12195 | 851 |
696851 | 696851 | 2020-11-04 | Brevard | Florida | 12009 | 12195 | 384 |
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);