ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 5587 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Mississippi 6
- Minnesota 4
- Ohio 4
- Puerto Rico 4
- South Dakota 4
- Texas 4
- California 3
- Florida 3
- Illinois 3
- Michigan 3
- Utah 3
- Virginia 3
- Wisconsin 3
- Arkansas 2
- Georgia 2
- Indiana 2
- Kentucky 2
- Louisiana 2
- North Carolina 2
- Tennessee 2
- Alabama 1
- Arizona 1
- Colorado 1
- Iowa 1
- Maryland 1
- New Hampshire 1
- New York 1
- Pennsylvania 1
- South Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500986 | 2500986 | 2022-05-13 | Waseca | Minnesota | 27161 | 5587 | 39 |
2419386 | 2419386 | 2022-04-18 | Talbot | Maryland | 24041 | 5587 | 86 |
2416330 | 2416330 | 2022-04-17 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2413074 | 2413074 | 2022-04-16 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2409818 | 2409818 | 2022-04-15 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2406562 | 2406562 | 2022-04-14 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2403306 | 2403306 | 2022-04-13 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2400052 | 2400052 | 2022-04-12 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2401427 | 2401427 | 2022-04-12 | Moore | Texas | 48341 | 5587 | 111 |
2398172 | 2398172 | 2022-04-11 | Moore | Texas | 48341 | 5587 | 111 |
2394917 | 2394917 | 2022-04-10 | Moore | Texas | 48341 | 5587 | 111 |
2391661 | 2391661 | 2022-04-09 | Moore | Texas | 48341 | 5587 | 111 |
2385373 | 2385373 | 2022-04-07 | Page | Virginia | 51139 | 5587 | 120 |
2382118 | 2382118 | 2022-04-06 | Page | Virginia | 51139 | 5587 | 120 |
2360822 | 2360822 | 2022-03-31 | Alpena | Michigan | 26007 | 5587 | 136 |
2357568 | 2357568 | 2022-03-30 | Alpena | Michigan | 26007 | 5587 | 136 |
2269846 | 2269846 | 2022-03-03 | Dodge | Minnesota | 27039 | 5587 | 21 |
2198911 | 2198911 | 2022-02-09 | Greene | North Carolina | 37079 | 5587 | 55 |
2166965 | 2166965 | 2022-01-30 | Yankton | South Dakota | 46135 | 5587 | 50 |
2163710 | 2163710 | 2022-01-29 | Yankton | South Dakota | 46135 | 5587 | 50 |
2160455 | 2160455 | 2022-01-28 | Yankton | South Dakota | 46135 | 5587 | 50 |
2146077 | 2146077 | 2022-01-24 | Sabine | Louisiana | 22085 | 5587 | 100 |
2115818 | 2115818 | 2022-01-15 | Yell | Arkansas | 5149 | 5587 | 92 |
2080908 | 2080908 | 2022-01-04 | Grant | Kentucky | 21081 | 5587 | 46 |
2041399 | 2041399 | 2021-12-23 | Upson | Georgia | 13293 | 5587 | 191 |
2013391 | 2013391 | 2021-12-14 | Carroll | New Hampshire | 33003 | 5587 | 26 |
1986938 | 1986938 | 2021-12-06 | Carlton | Minnesota | 27017 | 5587 | 78 |
1971208 | 1971208 | 2021-12-01 | Chenango | New York | 36017 | 5587 | 96 |
1971922 | 1971922 | 2021-12-01 | Henry | Tennessee | 47079 | 5587 | 94 |
1861330 | 1861330 | 2021-10-28 | Codington | South Dakota | 46029 | 5587 | 84 |
1809329 | 1809329 | 2021-10-12 | Williamsburg | South Carolina | 45089 | 5587 | 122 |
1773213 | 1773213 | 2021-10-01 | Fulton | Ohio | 39051 | 5587 | 87 |
1768566 | 1768566 | 2021-09-30 | Stephenson | Illinois | 17177 | 5587 | 110 |
1760210 | 1760210 | 2021-09-27 | Defiance | Ohio | 39039 | 5587 | 101 |
1718292 | 1718292 | 2021-09-14 | Toa Alta | Puerto Rico | 72135 | 5587 | |
1680214 | 1680214 | 2021-09-03 | Russell | Alabama | 1113 | 5587 | 51 |
1573176 | 1573176 | 2021-08-01 | Nevada | California | 6057 | 5587 | 75 |
1569928 | 1569928 | 2021-07-31 | Nevada | California | 6057 | 5587 | 75 |
1566680 | 1566680 | 2021-07-30 | Nevada | California | 6057 | 5587 | 75 |
1509988 | 1509988 | 2021-07-12 | Pender | North Carolina | 37141 | 5587 | 69 |
1500374 | 1500374 | 2021-07-09 | Huron | Ohio | 39077 | 5587 | 122 |
1435760 | 1435760 | 2021-06-19 | Unknown | Puerto Rico | 5587 | 2539 | |
1429267 | 1429267 | 2021-06-17 | Unknown | Puerto Rico | 5587 | 2539 | |
1413535 | 1413535 | 2021-06-12 | Summit | Utah | 49043 | 5587 | 13 |
1410290 | 1410290 | 2021-06-11 | Summit | Utah | 49043 | 5587 | 13 |
1403920 | 1403920 | 2021-06-09 | Pittsylvania | Virginia | 51143 | 5587 | 82 |
1400057 | 1400057 | 2021-06-08 | Unknown | Puerto Rico | 5587 | 2522 | |
1346542 | 1346542 | 2021-05-23 | Clinton | Iowa | 19045 | 5587 | 93 |
1327338 | 1327338 | 2021-05-17 | Pike | Kentucky | 21195 | 5587 | 98 |
1321851 | 1321851 | 2021-05-15 | Lawrence | Ohio | 39087 | 5587 | 102 |
1287760 | 1287760 | 2021-05-05 | Laurens | Georgia | 13175 | 5587 | 167 |
1261923 | 1261923 | 2021-04-27 | Coles | Illinois | 17029 | 5587 | 96 |
1264374 | 1264374 | 2021-04-27 | Cowlitz | Washington | 53015 | 5587 | 83 |
1228477 | 1228477 | 2021-04-16 | Iron | Utah | 49021 | 5587 | 32 |
1201882 | 1201882 | 2021-04-08 | Carbon | Pennsylvania | 42025 | 5587 | 159 |
1186527 | 1186527 | 2021-04-03 | Columbia | Wisconsin | 55021 | 5587 | 68 |
1148355 | 1148355 | 2021-03-23 | Cass | Indiana | 18017 | 5587 | 103 |
1104768 | 1104768 | 2021-03-09 | Lawrence | Tennessee | 47099 | 5587 | 84 |
1102100 | 1102100 | 2021-03-08 | Barron | Wisconsin | 55005 | 5587 | 76 |
1040495 | 1040495 | 2021-02-17 | Waupaca | Wisconsin | 55135 | 5587 | 156 |
963348 | 963348 | 2021-01-25 | Dubois | Indiana | 18037 | 5587 | 81 |
963987 | 963987 | 2021-01-25 | Kandiyohi | Minnesota | 27067 | 5587 | 72 |
950250 | 950250 | 2021-01-21 | Boone | Illinois | 17007 | 5587 | 78 |
895764 | 895764 | 2021-01-04 | Lenawee | Michigan | 26091 | 5587 | 70 |
837211 | 837211 | 2020-12-17 | Lafourche | Louisiana | 22057 | 5587 | 158 |
810226 | 810226 | 2020-12-09 | Faulkner | Arkansas | 5045 | 5587 | 63 |
434592 | 434592 | 2020-08-15 | Lake | Florida | 12069 | 5587 | 82 |
392698 | 392698 | 2020-08-02 | Brevard | Florida | 12009 | 5587 | 117 |
370105 | 370105 | 2020-07-26 | Adams | Colorado | 8001 | 5587 | 167 |
287427 | 287427 | 2020-06-30 | Lee | Florida | 12071 | 5587 | 158 |
262061 | 262061 | 2020-06-22 | Pima | Arizona | 4019 | 5587 | 242 |
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);