ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 6271 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Kansas 9
- Louisiana 8
- Michigan 8
- Illinois 6
- Indiana 6
- Missouri 4
- North Carolina 4
- New Mexico 3
- Ohio 3
- Pennsylvania 3
- South Carolina 3
- Texas 3
- Georgia 2
- Alabama 1
- Florida 1
- Maine 1
- Minnesota 1
- Mississippi 1
- New York 1
- Oklahoma 1
- Tennessee 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416066 | 2416066 | 2022-04-17 | Pointe Coupee | Louisiana | 22077 | 6271 | 93 |
2412810 | 2412810 | 2022-04-16 | Pointe Coupee | Louisiana | 22077 | 6271 | 93 |
2409554 | 2409554 | 2022-04-15 | Pointe Coupee | Louisiana | 22077 | 6271 | 93 |
2406298 | 2406298 | 2022-04-14 | Pointe Coupee | Louisiana | 22077 | 6271 | 93 |
2286069 | 2286069 | 2022-03-08 | Oceana | Michigan | 26127 | 6271 | 89 |
2282817 | 2282817 | 2022-03-07 | Oceana | Michigan | 26127 | 6271 | 89 |
2209853 | 2209853 | 2022-02-12 | Mason | West Virginia | 54053 | 6271 | 86 |
2174964 | 2174964 | 2022-02-02 | Posey | Indiana | 18129 | 6271 | 50 |
2170109 | 2170109 | 2022-01-31 | Abbeville | South Carolina | 45001 | 6271 | 59 |
2142332 | 2142332 | 2022-01-23 | Perry | Illinois | 17145 | 6271 | 97 |
2139077 | 2139077 | 2022-01-22 | Perry | Illinois | 17145 | 6271 | 97 |
2135821 | 2135821 | 2022-01-21 | Perry | Illinois | 17145 | 6271 | 97 |
2125180 | 2125180 | 2022-01-17 | Smyth | Virginia | 51173 | 6271 | 141 |
2075351 | 2075351 | 2022-01-02 | Scotland | North Carolina | 37165 | 6271 | 110 |
2072100 | 2072100 | 2022-01-01 | Scotland | North Carolina | 37165 | 6271 | 110 |
2068849 | 2068849 | 2021-12-31 | Scotland | North Carolina | 37165 | 6271 | 110 |
2058238 | 2058238 | 2021-12-28 | Beauregard | Louisiana | 22011 | 6271 | 129 |
2058947 | 2058947 | 2021-12-28 | Rio Arriba | New Mexico | 35039 | 6271 | 94 |
2000920 | 2000920 | 2021-12-10 | Perry | Pennsylvania | 42099 | 6271 | 135 |
1967433 | 1967433 | 2021-11-30 | Becker | Minnesota | 27005 | 6271 | 74 |
1883177 | 1883177 | 2021-11-04 | Phelps | Missouri | 29161 | 6271 | 184 |
1826766 | 1826766 | 2021-10-18 | Bryan | Georgia | 13029 | 6271 | 64 |
1823858 | 1823858 | 2021-10-17 | Knox | Indiana | 18083 | 6271 | 105 |
1820609 | 1820609 | 2021-10-16 | Knox | Indiana | 18083 | 6271 | 105 |
1817360 | 1817360 | 2021-10-15 | Knox | Indiana | 18083 | 6271 | 105 |
1788834 | 1788834 | 2021-10-06 | Marshall | Mississippi | 28093 | 6271 | 130 |
1756064 | 1756064 | 2021-09-26 | Webster | Louisiana | 22119 | 6271 | 142 |
1752816 | 1752816 | 2021-09-25 | Webster | Louisiana | 22119 | 6271 | 142 |
1749567 | 1749567 | 2021-09-24 | Webster | Louisiana | 22119 | 6271 | 142 |
1716287 | 1716287 | 2021-09-14 | Baldwin | Georgia | 13009 | 6271 | 157 |
1698551 | 1698551 | 2021-09-08 | Washington | Ohio | 39167 | 6271 | 111 |
1679361 | 1679361 | 2021-09-02 | Newberry | South Carolina | 45071 | 6271 | 119 |
1672247 | 1672247 | 2021-08-31 | Otero | New Mexico | 35035 | 6271 | 91 |
1655100 | 1655100 | 2021-08-26 | Ford | Kansas | 20057 | 6271 | 84 |
1651853 | 1651853 | 2021-08-25 | Ford | Kansas | 20057 | 6271 | 84 |
1641797 | 1641797 | 2021-08-22 | Clinton | Illinois | 17027 | 6271 | 102 |
1638547 | 1638547 | 2021-08-21 | Clinton | Illinois | 17027 | 6271 | 102 |
1640256 | 1640256 | 2021-08-21 | Union | Pennsylvania | 42119 | 6271 | 90 |
1635297 | 1635297 | 2021-08-20 | Clinton | Illinois | 17027 | 6271 | 102 |
1554197 | 1554197 | 2021-07-26 | Dubois | Indiana | 18037 | 6271 | 119 |
1533368 | 1533368 | 2021-07-19 | Anderson | Texas | 48001 | 6271 | 133 |
1530121 | 1530121 | 2021-07-18 | Anderson | Texas | 48001 | 6271 | 133 |
1526874 | 1526874 | 2021-07-17 | Anderson | Texas | 48001 | 6271 | 133 |
1519073 | 1519073 | 2021-07-15 | St. Joseph | Michigan | 26149 | 6271 | 101 |
1515826 | 1515826 | 2021-07-14 | St. Joseph | Michigan | 26149 | 6271 | 101 |
1512580 | 1512580 | 2021-07-13 | St. Joseph | Michigan | 26149 | 6271 | 101 |
1412185 | 1412185 | 2021-06-12 | Joplin | Missouri | 6271 | 109 | |
1408588 | 1408588 | 2021-06-11 | Penobscot | Maine | 23019 | 6271 | 94 |
1342829 | 1342829 | 2021-05-22 | Jackson | Florida | 12063 | 6271 | 158 |
1335009 | 1335009 | 2021-05-19 | Carbon | Pennsylvania | 42025 | 6271 | 170 |
1324311 | 1324311 | 2021-05-16 | Shiawassee | Michigan | 26155 | 6271 | 102 |
1321065 | 1321065 | 2021-05-15 | Shiawassee | Michigan | 26155 | 6271 | 102 |
1295044 | 1295044 | 2021-05-07 | Grand Traverse | Michigan | 26055 | 6271 | 91 |
1269730 | 1269730 | 2021-04-29 | Columbus | North Carolina | 37047 | 6271 | 150 |
1264572 | 1264572 | 2021-04-28 | Colbert | Alabama | 1033 | 6271 | 134 |
1221227 | 1221227 | 2021-04-14 | Scioto | Ohio | 39145 | 6271 | 100 |
1148619 | 1148619 | 2021-03-23 | Riley | Kansas | 20161 | 6271 | 35 |
1145372 | 1145372 | 2021-03-22 | Riley | Kansas | 20161 | 6271 | 35 |
1142125 | 1142125 | 2021-03-21 | Riley | Kansas | 20161 | 6271 | 35 |
1138879 | 1138879 | 2021-03-20 | Riley | Kansas | 20161 | 6271 | 35 |
1135633 | 1135633 | 2021-03-19 | Riley | Kansas | 20161 | 6271 | 35 |
1132386 | 1132386 | 2021-03-18 | Riley | Kansas | 20161 | 6271 | 35 |
1129138 | 1129138 | 2021-03-17 | Riley | Kansas | 20161 | 6271 | 35 |
1125625 | 1125625 | 2021-03-16 | Boone | Indiana | 18011 | 6271 | 99 |
1126797 | 1126797 | 2021-03-16 | Oswego | New York | 36075 | 6271 | 89 |
1048833 | 1048833 | 2021-02-20 | Eddy | New Mexico | 35015 | 6271 | 114 |
863554 | 863554 | 2020-12-25 | Franklin | Missouri | 29071 | 6271 | 109 |
782968 | 782968 | 2020-11-30 | Delaware | Ohio | 39041 | 6271 | 37 |
767249 | 767249 | 2020-11-25 | Montgomery | Tennessee | 47125 | 6271 | 83 |
744375 | 744375 | 2020-11-18 | Florence | South Carolina | 45041 | 6271 | 209 |
493971 | 493971 | 2020-09-02 | St. Louis city | Missouri | 29510 | 6271 | 188 |
349595 | 349595 | 2020-07-19 | Oklahoma | Oklahoma | 40109 | 6271 | 77 |
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);