ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 8875 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Ohio 6
- North Carolina 5
- Wisconsin 5
- Alaska 3
- Georgia 3
- Kentucky 3
- Louisiana 3
- Idaho 2
- Pennsylvania 2
- Arkansas 1
- California 1
- Indiana 1
- Minnesota 1
- Mississippi 1
- New Jersey 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442341 | 2442341 | 2022-04-25 | Polk | Minnesota | 27119 | 8875 | 107 |
2428494 | 2428494 | 2022-04-21 | Bonner | Idaho | 16017 | 8875 | 186 |
2425238 | 2425238 | 2022-04-20 | Bonner | Idaho | 16017 | 8875 | 186 |
2233141 | 2233141 | 2022-02-20 | Bryan | Georgia | 13029 | 8875 | 81 |
2229890 | 2229890 | 2022-02-19 | Bryan | Georgia | 13029 | 8875 | 81 |
2226639 | 2226639 | 2022-02-18 | Bryan | Georgia | 13029 | 8875 | 81 |
2222016 | 2222016 | 2022-02-16 | Clinton | Pennsylvania | 42035 | 8875 | 121 |
2218631 | 2218631 | 2022-02-15 | Williams | Ohio | 39171 | 8875 | 152 |
2211934 | 2211934 | 2022-02-13 | Jackson | North Carolina | 37099 | 8875 | 83 |
2208681 | 2208681 | 2022-02-12 | Jackson | North Carolina | 37099 | 8875 | 83 |
2205428 | 2205428 | 2022-02-11 | Jackson | North Carolina | 37099 | 8875 | 83 |
2108919 | 2108919 | 2022-01-12 | Shenandoah | Virginia | 51171 | 8875 | 189 |
2081047 | 2081047 | 2022-01-04 | Washington | Louisiana | 22117 | 8875 | 222 |
2079812 | 2079812 | 2022-01-03 | Oconto | Wisconsin | 55083 | 8875 | 88 |
1951981 | 1951981 | 2021-11-25 | Sandusky | Ohio | 39143 | 8875 | 166 |
1948730 | 1948730 | 2021-11-24 | Sandusky | Ohio | 39143 | 8875 | 166 |
1904474 | 1904474 | 2021-11-11 | Crittenden | Arkansas | 5035 | 8875 | 179 |
1907507 | 1907507 | 2021-11-11 | Calumet | Wisconsin | 55015 | 8875 | 62 |
1896572 | 1896572 | 2021-11-08 | Pender | North Carolina | 37141 | 8875 | 101 |
1784362 | 1784362 | 2021-10-05 | Tehama | California | 6103 | 8875 | 95 |
1777702 | 1777702 | 2021-10-03 | Kenai Peninsula Borough | Alaska | 2122 | 8875 | 40 |
1774452 | 1774452 | 2021-10-02 | Kenai Peninsula Borough | Alaska | 2122 | 8875 | 40 |
1771202 | 1771202 | 2021-10-01 | Kenai Peninsula Borough | Alaska | 2122 | 8875 | 40 |
1724979 | 1724979 | 2021-09-16 | Monroe | Tennessee | 47123 | 8875 | 108 |
1649138 | 1649138 | 2021-08-24 | Lowndes | Mississippi | 28087 | 8875 | 159 |
1437624 | 1437624 | 2021-06-20 | Campbell | Kentucky | 21037 | 8875 | 84 |
1434377 | 1434377 | 2021-06-19 | Campbell | Kentucky | 21037 | 8875 | 84 |
1431131 | 1431131 | 2021-06-18 | Campbell | Kentucky | 21037 | 8875 | 84 |
1377057 | 1377057 | 2021-06-01 | Muskingum | Ohio | 39119 | 8875 | 135 |
1352158 | 1352158 | 2021-05-24 | Manitowoc | Wisconsin | 55071 | 8875 | 90 |
1348912 | 1348912 | 2021-05-23 | Manitowoc | Wisconsin | 55071 | 8875 | 90 |
1345664 | 1345664 | 2021-05-22 | Manitowoc | Wisconsin | 55071 | 8875 | 90 |
1325068 | 1325068 | 2021-05-16 | Columbiana | Ohio | 39029 | 8875 | 229 |
1312153 | 1312153 | 2021-05-12 | Wayne | Ohio | 39169 | 8875 | 211 |
1308727 | 1308727 | 2021-05-11 | Moore | North Carolina | 37125 | 8875 | 187 |
1015295 | 1015295 | 2021-02-10 | Howard | Indiana | 18067 | 8875 | 178 |
1007128 | 1007128 | 2021-02-07 | Monroe | Pennsylvania | 42089 | 8875 | 250 |
996259 | 996259 | 2021-02-04 | Terrebonne | Louisiana | 22109 | 8875 | 186 |
561467 | 561467 | 2020-09-23 | Lafayette | Louisiana | 22055 | 8875 | 126 |
442470 | 442470 | 2020-08-17 | Camden | New Jersey | 34007 | 8875 | 583 |
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);