ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 6608 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Kansas 18
- Virginia 5
- Maine 3
- Ohio 3
- South Carolina 3
- Illinois 2
- Michigan 2
- Missouri 2
- Pennsylvania 2
- Alabama 1
- Arizona 1
- Colorado 1
- Georgia 1
- Indiana 1
- Iowa 1
- Kentucky 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- Montana 1
- New Jersey 1
- New Mexico 1
- New York 1
- Oklahoma 1
- Puerto Rico 1
- Tennessee 1
- Texas 1
- Utah 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500844 | 2500844 | 2022-05-13 | Emmet | Michigan | 26047 | 6608 | 87 |
2497586 | 2497586 | 2022-05-12 | Emmet | Michigan | 26047 | 6608 | 87 |
2451667 | 2451667 | 2022-04-28 | Labette | Kansas | 20099 | 6608 | 74 |
2448411 | 2448411 | 2022-04-27 | Labette | Kansas | 20099 | 6608 | 74 |
2445155 | 2445155 | 2022-04-26 | Labette | Kansas | 20099 | 6608 | 74 |
2441899 | 2441899 | 2022-04-25 | Labette | Kansas | 20099 | 6608 | 74 |
2438643 | 2438643 | 2022-04-24 | Labette | Kansas | 20099 | 6608 | 74 |
2435387 | 2435387 | 2022-04-23 | Labette | Kansas | 20099 | 6608 | 74 |
2432131 | 2432131 | 2022-04-22 | Labette | Kansas | 20099 | 6608 | 74 |
2360521 | 2360521 | 2022-03-31 | Labette | Kansas | 20099 | 6608 | 74 |
2357267 | 2357267 | 2022-03-30 | Labette | Kansas | 20099 | 6608 | 74 |
2354014 | 2354014 | 2022-03-29 | Labette | Kansas | 20099 | 6608 | 74 |
2350762 | 2350762 | 2022-03-28 | Labette | Kansas | 20099 | 6608 | 74 |
2347509 | 2347509 | 2022-03-27 | Labette | Kansas | 20099 | 6608 | 74 |
2344256 | 2344256 | 2022-03-26 | Labette | Kansas | 20099 | 6608 | 74 |
2341003 | 2341003 | 2022-03-25 | Labette | Kansas | 20099 | 6608 | 74 |
2326742 | 2326742 | 2022-03-20 | Carroll | Virginia | 51035 | 6608 | 141 |
2323489 | 2323489 | 2022-03-19 | Carroll | Virginia | 51035 | 6608 | 141 |
2320235 | 2320235 | 2022-03-18 | Carroll | Virginia | 51035 | 6608 | 141 |
2315533 | 2315533 | 2022-03-17 | Barry | Missouri | 29009 | 6608 | 127 |
2284253 | 2284253 | 2022-03-07 | Hutchinson | Texas | 48233 | 6608 | 133 |
2197416 | 2197416 | 2022-02-09 | Gilmer | Georgia | 13123 | 6608 | 155 |
2155592 | 2155592 | 2022-01-27 | Ellis | Kansas | 20051 | 6608 | 79 |
2152339 | 2152339 | 2022-01-26 | Ellis | Kansas | 20051 | 6608 | 79 |
2124530 | 2124530 | 2022-01-17 | Rio Grande | Puerto Rico | 72119 | 6608 | |
2082919 | 2082919 | 2022-01-04 | Warren | Virginia | 51187 | 6608 | 108 |
1998438 | 1998438 | 2021-12-09 | Mason | Washington | 53045 | 6608 | 85 |
1961698 | 1961698 | 2021-11-28 | Highland | Ohio | 39071 | 6608 | 117 |
1876568 | 1876568 | 2021-11-02 | Panola | Mississippi | 28107 | 6608 | 131 |
1832869 | 1832869 | 2021-10-20 | Chilton | Alabama | 1021 | 6608 | 161 |
1791537 | 1791537 | 2021-10-07 | Crawford | Kansas | 20037 | 6608 | 113 |
1788288 | 1788288 | 2021-10-06 | Crawford | Kansas | 20037 | 6608 | 113 |
1757310 | 1757310 | 2021-09-26 | Chesterfield | South Carolina | 45025 | 6608 | 127 |
1754062 | 1754062 | 2021-09-25 | Chesterfield | South Carolina | 45025 | 6608 | 127 |
1750814 | 1750814 | 2021-09-24 | Chesterfield | South Carolina | 45025 | 6608 | 127 |
1739286 | 1739286 | 2021-09-21 | Knox | Illinois | 17095 | 6608 | 195 |
1721273 | 1721273 | 2021-09-15 | Sandusky | Ohio | 39143 | 6608 | 132 |
1680131 | 1680131 | 2021-09-02 | Waupaca | Wisconsin | 55135 | 6608 | 170 |
1655983 | 1655983 | 2021-08-26 | Salem | New Jersey | 34033 | 6608 | 193 |
1614244 | 1614244 | 2021-08-13 | Indiana | Pennsylvania | 42063 | 6608 | 179 |
1585273 | 1585273 | 2021-08-04 | Hawkins | Tennessee | 47073 | 6608 | 117 |
1537506 | 1537506 | 2021-07-21 | Fremont | Colorado | 8043 | 6608 | 64 |
1476741 | 1476741 | 2021-07-02 | Kennebec | Maine | 23011 | 6608 | 74 |
1473495 | 1473495 | 2021-07-01 | Kennebec | Maine | 23011 | 6608 | 74 |
1470249 | 1470249 | 2021-06-30 | Kennebec | Maine | 23011 | 6608 | 74 |
1356822 | 1356822 | 2021-05-26 | Kandiyohi | Minnesota | 27067 | 6608 | 84 |
1249029 | 1249029 | 2021-04-23 | Boone | Indiana | 18011 | 6608 | 104 |
1211443 | 1211443 | 2021-04-11 | Hancock | Ohio | 39063 | 6608 | 123 |
1194746 | 1194746 | 2021-04-06 | Lewis and Clark | Montana | 30049 | 6608 | 81 |
1175505 | 1175505 | 2021-03-31 | Oswego | New York | 36075 | 6608 | 89 |
1139724 | 1139724 | 2021-03-20 | Eddy | New Mexico | 35015 | 6608 | 120 |
1091373 | 1091373 | 2021-03-05 | Creek | Oklahoma | 40037 | 6608 | 117 |
1049330 | 1049330 | 2021-02-20 | Somerset | Pennsylvania | 42111 | 6608 | 187 |
1005915 | 1005915 | 2021-02-07 | Oldham | Kentucky | 21185 | 6608 | 68 |
787482 | 787482 | 2020-12-02 | Mohave | Arizona | 4015 | 6608 | 264 |
632530 | 632530 | 2020-10-15 | Woodbury | Iowa | 19193 | 6608 | 83 |
628029 | 628029 | 2020-10-13 | Davis | Utah | 49011 | 6608 | 37 |
529548 | 529548 | 2020-09-13 | St. Louis city | Missouri | 29510 | 6608 | 196 |
281471 | 281471 | 2020-06-28 | Will | Illinois | 17197 | 6608 | 319 |
243027 | 243027 | 2020-06-15 | Prince William | Virginia | 51153 | 6608 | 122 |
119395 | 119395 | 2020-05-06 | Orleans | Louisiana | 22071 | 6608 | 464 |
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);