ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 6261 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Florida 7
- Georgia 6
- Louisiana 5
- Minnesota 4
- North Carolina 4
- Pennsylvania 4
- Wisconsin 4
- California 3
- Missouri 3
- Ohio 3
- Texas 3
- Colorado 2
- Indiana 2
- Kentucky 2
- Michigan 2
- Mississippi 2
- South Carolina 2
- Washington 2
- Alabama 1
- Idaho 1
- Illinois 1
- Maryland 1
- Montana 1
- New Mexico 1
- Puerto Rico 1
- Tennessee 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2325383 | 2325383 | 2022-03-20 | Saline | Missouri | 29195 | 6261 | 101 |
2322129 | 2322129 | 2022-03-19 | Saline | Missouri | 29195 | 6261 | 101 |
2318875 | 2318875 | 2022-03-18 | Saline | Missouri | 29195 | 6261 | 101 |
2304567 | 2304567 | 2022-03-14 | Pitkin | Colorado | 8097 | 6261 | 6 |
2236504 | 2236504 | 2022-02-21 | Stephens | Georgia | 13257 | 6261 | 136 |
2226811 | 2226811 | 2022-02-18 | Elmore | Idaho | 16039 | 6261 | 63 |
2199336 | 2199336 | 2022-02-09 | Isabela | Puerto Rico | 72071 | 6261 | |
2188367 | 2188367 | 2022-02-06 | Richland | Louisiana | 22083 | 6261 | 85 |
2185114 | 2185114 | 2022-02-05 | Richland | Louisiana | 22083 | 6261 | 85 |
2181862 | 2181862 | 2022-02-04 | Richland | Louisiana | 22083 | 6261 | 85 |
2177838 | 2177838 | 2022-02-03 | Washington | Florida | 12133 | 6261 | 87 |
2174585 | 2174585 | 2022-02-02 | Washington | Florida | 12133 | 6261 | 87 |
2171332 | 2171332 | 2022-02-01 | Washington | Florida | 12133 | 6261 | 88 |
2168079 | 2168079 | 2022-01-31 | Washington | Florida | 12133 | 6261 | 88 |
2164824 | 2164824 | 2022-01-30 | Washington | Florida | 12133 | 6261 | 88 |
2161569 | 2161569 | 2022-01-29 | Washington | Florida | 12133 | 6261 | 88 |
2158313 | 2158313 | 2022-01-28 | Washington | Florida | 12133 | 6261 | 88 |
2148710 | 2148710 | 2022-01-25 | White | Georgia | 13311 | 6261 | 142 |
2108953 | 2108953 | 2022-01-12 | Island | Washington | 53029 | 6261 | 57 |
2102619 | 2102619 | 2022-01-10 | Sheridan | Wyoming | 56033 | 6261 | 63 |
2099289 | 2099289 | 2022-01-09 | Clark | Wisconsin | 55019 | 6261 | 109 |
2096038 | 2096038 | 2022-01-08 | Clark | Wisconsin | 55019 | 6261 | 109 |
2092786 | 2092786 | 2022-01-07 | Clark | Wisconsin | 55019 | 6261 | 109 |
1987263 | 1987263 | 2021-12-06 | Silver Bow | Montana | 30093 | 6261 | 113 |
1883688 | 1883688 | 2021-11-04 | Guernsey | Ohio | 39059 | 6261 | 73 |
1852761 | 1852761 | 2021-10-26 | Bryan | Georgia | 13029 | 6261 | 66 |
1849512 | 1849512 | 2021-10-25 | Bryan | Georgia | 13029 | 6261 | 67 |
1841435 | 1841435 | 2021-10-22 | Crawford | Ohio | 39033 | 6261 | 130 |
1837288 | 1837288 | 2021-10-21 | Vernon | Louisiana | 22115 | 6261 | 160 |
1838804 | 1838804 | 2021-10-21 | Erath | Texas | 48143 | 6261 | 100 |
1823168 | 1823168 | 2021-10-17 | Russell | Alabama | 1113 | 6261 | 58 |
1810522 | 1810522 | 2021-10-13 | Bryan | Georgia | 13029 | 6261 | 62 |
1805524 | 1805524 | 2021-10-11 | Alexander | North Carolina | 37003 | 6261 | 111 |
1783170 | 1783170 | 2021-10-04 | Huntingdon | Pennsylvania | 42061 | 6261 | 146 |
1765253 | 1765253 | 2021-09-29 | Effingham | Illinois | 17049 | 6261 | 93 |
1697448 | 1697448 | 2021-09-08 | Graves | Kentucky | 21083 | 6261 | 109 |
1669000 | 1669000 | 2021-08-30 | Otero | New Mexico | 35035 | 6261 | 91 |
1581526 | 1581526 | 2021-08-03 | Belmont | Ohio | 39013 | 6261 | 179 |
1535330 | 1535330 | 2021-07-20 | Chisago | Minnesota | 27025 | 6261 | 54 |
1504989 | 1504989 | 2021-07-11 | San Benito | California | 6069 | 6261 | 63 |
1501743 | 1501743 | 2021-07-10 | San Benito | California | 6069 | 6261 | 63 |
1498497 | 1498497 | 2021-07-09 | San Benito | California | 6069 | 6261 | 63 |
1478287 | 1478287 | 2021-07-02 | Hunt | Texas | 48231 | 6261 | 179 |
1448298 | 1448298 | 2021-06-23 | Lenoir | North Carolina | 37107 | 6261 | 124 |
1444416 | 1444416 | 2021-06-22 | St. Joseph | Michigan | 26149 | 6261 | 100 |
1376388 | 1376388 | 2021-06-01 | Lafayette | Mississippi | 28071 | 6261 | 119 |
1340437 | 1340437 | 2021-05-21 | Cecil | Maryland | 24015 | 6261 | 139 |
1328515 | 1328515 | 2021-05-17 | Carbon | Pennsylvania | 42025 | 6261 | 169 |
1317819 | 1317819 | 2021-05-14 | Shiawassee | Michigan | 26155 | 6261 | 102 |
1305449 | 1305449 | 2021-05-10 | Duplin | North Carolina | 37061 | 6261 | 133 |
1290793 | 1290793 | 2021-05-06 | Eagle | Colorado | 8037 | 6261 | 22 |
1291045 | 1291045 | 2021-05-06 | Spalding | Georgia | 13255 | 6261 | 188 |
1259161 | 1259161 | 2021-04-26 | Pulaski | Kentucky | 21199 | 6261 | 101 |
1207560 | 1207560 | 2021-04-10 | Lowndes | Mississippi | 28087 | 6261 | 144 |
1196269 | 1196269 | 2021-04-06 | Calumet | Wisconsin | 55015 | 6261 | 50 |
1115885 | 1115885 | 2021-03-13 | Boone | Indiana | 18011 | 6261 | 98 |
1104925 | 1104925 | 2021-03-09 | Hood | Texas | 48221 | 6261 | 119 |
1049294 | 1049294 | 2021-02-20 | Crawford | Pennsylvania | 42039 | 6261 | 136 |
972206 | 972206 | 2021-01-27 | Thurston | Washington | 53067 | 6261 | 65 |
934123 | 934123 | 2021-01-16 | Bartholomew | Indiana | 18005 | 6261 | 100 |
895816 | 895816 | 2021-01-04 | Clay | Minnesota | 27027 | 6261 | 78 |
786715 | 786715 | 2020-12-01 | Maury | Tennessee | 47119 | 6261 | 69 |
769288 | 769288 | 2020-11-26 | Olmsted | Minnesota | 27109 | 6261 | 34 |
766042 | 766042 | 2020-11-25 | Olmsted | Minnesota | 27109 | 6261 | 34 |
756846 | 756846 | 2020-11-22 | Catawba | North Carolina | 37035 | 6261 | 80 |
695700 | 695700 | 2020-11-03 | Beaufort | South Carolina | 45013 | 6261 | 93 |
543343 | 543343 | 2020-09-17 | Spartanburg | South Carolina | 45083 | 6261 | 187 |
504333 | 504333 | 2020-09-05 | Berks | Pennsylvania | 42011 | 6261 | 383 |
393495 | 393495 | 2020-08-02 | Caddo | Louisiana | 22017 | 6261 | 281 |
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);