ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 6373 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Illinois 7
- Kentucky 7
- Arkansas 6
- Wisconsin 6
- Michigan 5
- North Carolina 5
- Indiana 4
- Mississippi 4
- Ohio 4
- South Carolina 4
- Maine 3
- New York 3
- Texas 3
- Virginia 3
- Washington 3
- Georgia 2
- Louisiana 2
- Pennsylvania 2
- Colorado 1
- Idaho 1
- Iowa 1
- Maryland 1
- Missouri 1
- Montana 1
- Puerto Rico 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470062 | 2470062 | 2022-05-03 | Winchester city | Virginia | 51840 | 6373 | 80 |
2393187 | 2393187 | 2022-04-10 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2389931 | 2389931 | 2022-04-09 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2386675 | 2386675 | 2022-04-08 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2383420 | 2383420 | 2022-04-07 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2380165 | 2380165 | 2022-04-06 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2380362 | 2380362 | 2022-04-06 | Emmet | Michigan | 26047 | 6373 | 86 |
2376910 | 2376910 | 2022-04-05 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2377107 | 2377107 | 2022-04-05 | Emmet | Michigan | 26047 | 6373 | 86 |
2373658 | 2373658 | 2022-04-04 | Lincoln | Kentucky | 21137 | 6373 | 127 |
2371248 | 2371248 | 2022-04-03 | Ashe | North Carolina | 37009 | 6373 | 73 |
2367995 | 2367995 | 2022-04-02 | Ashe | North Carolina | 37009 | 6373 | 73 |
2364742 | 2364742 | 2022-04-01 | Ashe | North Carolina | 37009 | 6373 | 73 |
2279712 | 2279712 | 2022-03-06 | Leake | Mississippi | 28079 | 6373 | 115 |
2276459 | 2276459 | 2022-03-05 | Leake | Mississippi | 28079 | 6373 | 115 |
2273206 | 2273206 | 2022-03-04 | Leake | Mississippi | 28079 | 6373 | 115 |
2265368 | 2265368 | 2022-03-02 | Cleburne | Arkansas | 5023 | 6373 | 120 |
2245489 | 2245489 | 2022-02-23 | Louisa | Virginia | 51109 | 6373 | 69 |
2228604 | 2228604 | 2022-02-18 | Isabela | Puerto Rico | 72071 | 6373 | |
2222417 | 2222417 | 2022-02-16 | DeWitt | Texas | 48123 | 6373 | 92 |
2200627 | 2200627 | 2022-02-10 | Butts | Georgia | 13035 | 6373 | 140 |
2197734 | 2197734 | 2022-02-09 | Posey | Indiana | 18129 | 6373 | 52 |
2194480 | 2194480 | 2022-02-08 | Posey | Indiana | 18129 | 6373 | 52 |
2033394 | 2033394 | 2021-12-20 | Clarion | Pennsylvania | 42031 | 6373 | 168 |
1997213 | 1997213 | 2021-12-09 | Cortland | New York | 36023 | 6373 | 89 |
1966807 | 1966807 | 2021-11-30 | Woodford | Illinois | 17203 | 6373 | 105 |
1964020 | 1964020 | 2021-11-29 | St. John the Baptist | Louisiana | 22095 | 6373 | 173 |
1933710 | 1933710 | 2021-11-20 | Boone | Arkansas | 5009 | 6373 | 130 |
1862245 | 1862245 | 2021-10-29 | Independence | Arkansas | 5063 | 6373 | 159 |
1833598 | 1833598 | 2021-10-20 | Huntington | Indiana | 18069 | 6373 | 101 |
1804259 | 1804259 | 2021-10-11 | Jefferson | Illinois | 17081 | 6373 | 140 |
1801010 | 1801010 | 2021-10-10 | Jefferson | Illinois | 17081 | 6373 | 140 |
1797761 | 1797761 | 2021-10-09 | Jefferson | Illinois | 17081 | 6373 | 140 |
1794512 | 1794512 | 2021-10-08 | Jefferson | Illinois | 17081 | 6373 | 140 |
1644405 | 1644405 | 2021-08-22 | Waupaca | Wisconsin | 55135 | 6373 | 169 |
1641155 | 1641155 | 2021-08-21 | Waupaca | Wisconsin | 55135 | 6373 | 169 |
1637905 | 1637905 | 2021-08-20 | Waupaca | Wisconsin | 55135 | 6373 | 169 |
1597025 | 1597025 | 2021-08-08 | St. Joseph | Michigan | 26149 | 6373 | 104 |
1593776 | 1593776 | 2021-08-07 | St. Joseph | Michigan | 26149 | 6373 | 104 |
1590527 | 1590527 | 2021-08-06 | St. Joseph | Michigan | 26149 | 6373 | 104 |
1575388 | 1575388 | 2021-08-01 | Cherokee | South Carolina | 45021 | 6373 | 159 |
1572140 | 1572140 | 2021-07-31 | Cherokee | South Carolina | 45021 | 6373 | 159 |
1568892 | 1568892 | 2021-07-30 | Cherokee | South Carolina | 45021 | 6373 | 159 |
1565175 | 1565175 | 2021-07-29 | Lenoir | North Carolina | 37107 | 6373 | 128 |
1532594 | 1532594 | 2021-07-19 | Cayuga | New York | 36011 | 6373 | 92 |
1529347 | 1529347 | 2021-07-18 | Cayuga | New York | 36011 | 6373 | 92 |
1509209 | 1509209 | 2021-07-12 | Penobscot | Maine | 23019 | 6373 | 100 |
1505963 | 1505963 | 2021-07-11 | Penobscot | Maine | 23019 | 6373 | 100 |
1502717 | 1502717 | 2021-07-10 | Penobscot | Maine | 23019 | 6373 | 100 |
1502731 | 1502731 | 2021-07-10 | Cecil | Maryland | 24015 | 6373 | 153 |
1464501 | 1464501 | 2021-06-28 | Duplin | North Carolina | 37061 | 6373 | 139 |
1451038 | 1451038 | 2021-06-24 | Lamar | Mississippi | 28073 | 6373 | 88 |
1422973 | 1422973 | 2021-06-15 | Roane | Tennessee | 47145 | 6373 | 106 |
1279676 | 1279676 | 2021-05-02 | Scioto | Ohio | 39145 | 6373 | 101 |
1276429 | 1276429 | 2021-05-01 | Scioto | Ohio | 39145 | 6373 | 101 |
1254727 | 1254727 | 2021-04-24 | Calumet | Wisconsin | 55015 | 6373 | 50 |
1216603 | 1216603 | 2021-04-13 | Morgan | Indiana | 18109 | 6373 | 143 |
1188699 | 1188699 | 2021-04-04 | Geauga | Ohio | 39055 | 6373 | 144 |
1185452 | 1185452 | 2021-04-03 | Geauga | Ohio | 39055 | 6373 | 144 |
1183152 | 1183152 | 2021-04-02 | Rockingham | Virginia | 51165 | 6373 | 103 |
1171075 | 1171075 | 2021-03-30 | Whiteside | Illinois | 17195 | 6373 | 200 |
1150377 | 1150377 | 2021-03-23 | Hood | Texas | 48221 | 6373 | 122 |
1144211 | 1144211 | 2021-03-21 | Chelan | Washington | 53007 | 6373 | 64 |
1140964 | 1140964 | 2021-03-20 | Chelan | Washington | 53007 | 6373 | 64 |
1137718 | 1137718 | 2021-03-19 | Chelan | Washington | 53007 | 6373 | 64 |
1080058 | 1080058 | 2021-03-02 | Madison | Idaho | 16065 | 6373 | 22 |
963327 | 963327 | 2021-01-25 | Williamson | Illinois | 17199 | 6373 | 119 |
923659 | 923659 | 2021-01-12 | Wood | Wisconsin | 55141 | 6373 | 70 |
900023 | 900023 | 2021-01-05 | Lycoming | Pennsylvania | 42081 | 6373 | 127 |
855677 | 855677 | 2020-12-23 | Jefferson | Arkansas | 5069 | 6373 | 125 |
850662 | 850662 | 2020-12-21 | Cascade | Montana | 30013 | 6373 | 90 |
832987 | 832987 | 2020-12-16 | Saline | Arkansas | 5125 | 6373 | 83 |
778461 | 778461 | 2020-11-29 | Dallas | Iowa | 19049 | 6373 | 57 |
768334 | 768334 | 2020-11-26 | Columbia | Georgia | 13073 | 6373 | 75 |
754113 | 754113 | 2020-11-21 | Florence | South Carolina | 45041 | 6373 | 211 |
685056 | 685056 | 2020-10-31 | Boone | Missouri | 29019 | 6373 | 16 |
676508 | 676508 | 2020-10-28 | Ector | Texas | 48135 | 6373 | 119 |
509711 | 509711 | 2020-09-07 | St. Tammany | Louisiana | 22103 | 6373 | 245 |
508514 | 508514 | 2020-09-06 | Waukesha | Wisconsin | 55133 | 6373 | 78 |
427967 | 427967 | 2020-08-13 | Washington | Arkansas | 5143 | 6373 | 53 |
363690 | 363690 | 2020-07-24 | Arapahoe | Colorado | 8005 | 6373 | 360 |
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);