ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 12451 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Wisconsin 5
- Louisiana 4
- Illinois 3
- Alabama 2
- Idaho 2
- Kentucky 2
- New York 2
- Arizona 1
- California 1
- Georgia 1
- Indiana 1
- Maryland 1
- Mississippi 1
- Missouri 1
- North Carolina 1
- Ohio 1
- South Carolina 1
- Texas 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2302193 | 2302193 | 2022-03-13 | St. Mary | Louisiana | 22101 | 12451 | 258 |
2298941 | 2298941 | 2022-03-12 | St. Mary | Louisiana | 22101 | 12451 | 258 |
2295689 | 2295689 | 2022-03-11 | St. Mary | Louisiana | 22101 | 12451 | 258 |
2235913 | 2235913 | 2022-02-20 | Grant | Wisconsin | 55043 | 12451 | 141 |
2232662 | 2232662 | 2022-02-19 | Grant | Wisconsin | 55043 | 12451 | 141 |
2229411 | 2229411 | 2022-02-18 | Grant | Wisconsin | 55043 | 12451 | 141 |
2210568 | 2210568 | 2022-02-13 | Madison | Idaho | 16065 | 12451 | 45 |
2207315 | 2207315 | 2022-02-12 | Madison | Idaho | 16065 | 12451 | 45 |
2164104 | 2164104 | 2022-01-29 | Unknown | Vermont | 12451 | 6 | |
2137216 | 2137216 | 2022-01-21 | Athens | Ohio | 39009 | 12451 | 107 |
2127817 | 2127817 | 2022-01-18 | Cherokee | South Carolina | 45021 | 12451 | 277 |
2085120 | 2085120 | 2022-01-05 | Wilkes | North Carolina | 37193 | 12451 | 205 |
2057065 | 2057065 | 2021-12-27 | Portage | Wisconsin | 55097 | 12451 | 125 |
2038714 | 2038714 | 2021-12-22 | Pulaski | Kentucky | 21199 | 12451 | 222 |
2035464 | 2035464 | 2021-12-21 | Pulaski | Kentucky | 21199 | 12451 | 222 |
2015585 | 2015585 | 2021-12-15 | Floyd | Indiana | 18043 | 12451 | 242 |
1937547 | 1937547 | 2021-11-21 | Williamson | Illinois | 17199 | 12451 | 194 |
1934297 | 1934297 | 2021-11-20 | Williamson | Illinois | 17199 | 12451 | 194 |
1931046 | 1931046 | 2021-11-19 | Williamson | Illinois | 17199 | 12451 | 194 |
1859998 | 1859998 | 2021-10-28 | Iberia | Louisiana | 22045 | 12451 | 224 |
1856042 | 1856042 | 2021-10-27 | Dougherty | Georgia | 13095 | 12451 | 409 |
1793894 | 1793894 | 2021-10-08 | DeKalb | Alabama | 1049 | 12451 | 252 |
1740160 | 1740160 | 2021-09-21 | Cole | Missouri | 29051 | 12451 | 165 |
1670436 | 1670436 | 2021-08-31 | Cullman | Alabama | 1043 | 12451 | 219 |
1586054 | 1586054 | 2021-08-05 | Cochise | Arizona | 4003 | 12451 | 298 |
1566040 | 1566040 | 2021-07-29 | Rockwall | Texas | 48397 | 12451 | 159 |
1196275 | 1196275 | 2021-04-06 | Dodge | Wisconsin | 55027 | 12451 | 182 |
1083941 | 1083941 | 2021-03-03 | Washington | Maryland | 24043 | 12451 | 255 |
1064686 | 1064686 | 2021-02-25 | Jackson | Mississippi | 28059 | 12451 | 217 |
643237 | 643237 | 2020-10-18 | Erie | New York | 36029 | 12451 | 641 |
440929 | 440929 | 2020-08-17 | Tulare | California | 6107 | 12451 | 206 |
131970 | 131970 | 2020-05-10 | Rockland | New York | 36087 | 12451 | 417 |
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);