ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 7486 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Indiana 9
- Ohio 5
- New York 4
- Georgia 3
- California 2
- Illinois 2
- Minnesota 2
- Texas 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Florida 1
- Louisiana 1
- Mississippi 1
- North Carolina 1
- North Dakota 1
- Puerto Rico 1
- South Dakota 1
- Tennessee 1
- Virginia 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499991 | 2499991 | 2022-05-13 | Chattahoochee | Georgia | 13053 | 7486 | 22 |
2496733 | 2496733 | 2022-05-12 | Chattahoochee | Georgia | 13053 | 7486 | 22 |
2493475 | 2493475 | 2022-05-11 | Chattahoochee | Georgia | 13053 | 7486 | 22 |
2332667 | 2332667 | 2022-03-22 | Humacao | Puerto Rico | 72069 | 7486 | |
2226273 | 2226273 | 2022-02-18 | Lawrence | Alabama | 1079 | 7486 | 145 |
2169812 | 2169812 | 2022-01-31 | Morrow | Ohio | 39117 | 7486 | 86 |
2128755 | 2128755 | 2022-01-19 | Baxter | Arkansas | 5005 | 7486 | 211 |
2096866 | 2096866 | 2022-01-09 | Jasper | Indiana | 18073 | 7486 | 113 |
2093614 | 2093614 | 2022-01-08 | Jasper | Indiana | 18073 | 7486 | 113 |
2090362 | 2090362 | 2022-01-07 | Jasper | Indiana | 18073 | 7486 | 113 |
2085229 | 2085229 | 2022-01-05 | Madison | Ohio | 39097 | 7486 | 102 |
2080662 | 2080662 | 2022-01-04 | Whitley | Indiana | 18183 | 7486 | 71 |
2081035 | 2081035 | 2022-01-04 | St. John the Baptist | Louisiana | 22095 | 7486 | 173 |
2028592 | 2028592 | 2021-12-19 | Gibson | Indiana | 18051 | 7486 | 125 |
2025341 | 2025341 | 2021-12-18 | Gibson | Indiana | 18051 | 7486 | 125 |
2022090 | 2022090 | 2021-12-17 | Gibson | Indiana | 18051 | 7486 | 125 |
1951205 | 1951205 | 2021-11-25 | Itasca | Minnesota | 27061 | 7486 | 94 |
1947954 | 1947954 | 2021-11-24 | Itasca | Minnesota | 27061 | 7486 | 94 |
1935458 | 1935458 | 2021-11-20 | Fulton | New York | 36035 | 7486 | 109 |
1875748 | 1875748 | 2021-11-02 | Knox | Illinois | 17095 | 7486 | 203 |
1873341 | 1873341 | 2021-11-01 | Washington | Mississippi | 28151 | 7486 | 163 |
1842706 | 1842706 | 2021-10-23 | Graham | Arizona | 4009 | 7486 | 115 |
1789274 | 1789274 | 2021-10-06 | Wayne | New York | 36117 | 7486 | 80 |
1766565 | 1766565 | 2021-09-29 | Edgecombe | North Carolina | 37065 | 7486 | 117 |
1352918 | 1352918 | 2021-05-25 | Williamson | Illinois | 17199 | 7486 | 144 |
1308613 | 1308613 | 2021-05-11 | Chemung | New York | 36015 | 7486 | 135 |
1264469 | 1264469 | 2021-04-27 | Chippewa | Wisconsin | 55017 | 7486 | 96 |
1208871 | 1208871 | 2021-04-10 | Liberty | Texas | 48291 | 7486 | 173 |
1107289 | 1107289 | 2021-03-10 | Chautauqua | New York | 36013 | 7486 | 128 |
1093185 | 1093185 | 2021-03-06 | Hancock | Indiana | 18059 | 7486 | 138 |
1080175 | 1080175 | 2021-03-02 | Bartholomew | Indiana | 18005 | 7486 | 153 |
1001370 | 1001370 | 2021-02-05 | Spotsylvania | Virginia | 51177 | 7486 | 87 |
994338 | 994338 | 2021-02-03 | Lincoln | South Dakota | 46083 | 7486 | 74 |
964737 | 964737 | 2021-01-25 | Marion | Ohio | 39101 | 7486 | 113 |
920261 | 920261 | 2021-01-11 | Grant | Washington | 53025 | 7486 | 90 |
890110 | 890110 | 2021-01-02 | Portage | Ohio | 39133 | 7486 | 98 |
799184 | 799184 | 2020-12-05 | Clermont | Ohio | 39025 | 7486 | 56 |
688805 | 688805 | 2020-11-01 | Burleigh | North Dakota | 38015 | 7486 | 79 |
515383 | 515383 | 2020-09-09 | Sarasota | Florida | 12115 | 7486 | 221 |
465869 | 465869 | 2020-08-24 | Rutherford | Tennessee | 47149 | 7486 | 64 |
366063 | 366063 | 2020-07-24 | Cameron | Texas | 48061 | 7486 | 169 |
190922 | 190922 | 2020-05-30 | Riverside | California | 6065 | 7486 | 339 |
187857 | 187857 | 2020-05-29 | Riverside | California | 6065 | 7486 | 331 |
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);