ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 7876 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 8
- Louisiana 7
- Rhode Island 7
- Illinois 6
- Kansas 5
- North Carolina 3
- Florida 2
- Missouri 2
- South Carolina 2
- Alabama 1
- Arkansas 1
- California 1
- Colorado 1
- Georgia 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Minnesota 1
- Montana 1
- Nebraska 1
- New Mexico 1
- New York 1
- Ohio 1
- Pennsylvania 1
- Tennessee 1
- Virginia 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484411 | 2484411 | 2022-05-08 | Allen | Louisiana | 22003 | 7876 | 140 |
2481153 | 2481153 | 2022-05-07 | Allen | Louisiana | 22003 | 7876 | 140 |
2477895 | 2477895 | 2022-05-06 | Allen | Louisiana | 22003 | 7876 | 140 |
2474637 | 2474637 | 2022-05-05 | Allen | Louisiana | 22003 | 7876 | 140 |
2471380 | 2471380 | 2022-05-04 | Allen | Louisiana | 22003 | 7876 | 140 |
2468124 | 2468124 | 2022-05-03 | Allen | Louisiana | 22003 | 7876 | 140 |
2456794 | 2456794 | 2022-04-29 | Polk | Texas | 48373 | 7876 | 247 |
2421021 | 2421021 | 2022-04-18 | Upshur | Texas | 48459 | 7876 | 183 |
2415587 | 2415587 | 2022-04-17 | Saline | Illinois | 17165 | 7876 | 110 |
2412331 | 2412331 | 2022-04-16 | Saline | Illinois | 17165 | 7876 | 110 |
2409075 | 2409075 | 2022-04-15 | Saline | Illinois | 17165 | 7876 | 110 |
2188756 | 2188756 | 2022-02-06 | Laclede | Missouri | 29105 | 7876 | 161 |
2161041 | 2161041 | 2022-01-28 | Greenbrier | West Virginia | 54025 | 7876 | 125 |
2157538 | 2157538 | 2022-01-27 | Wharton | Texas | 48481 | 7876 | 195 |
2111559 | 2111559 | 2022-01-13 | Chester | South Carolina | 45023 | 7876 | 125 |
2074278 | 2074278 | 2022-01-02 | Crawford | Kansas | 20037 | 7876 | 117 |
2071027 | 2071027 | 2022-01-01 | Crawford | Kansas | 20037 | 7876 | 117 |
2067776 | 2067776 | 2021-12-31 | Crawford | Kansas | 20037 | 7876 | 117 |
2064525 | 2064525 | 2021-12-30 | Crawford | Kansas | 20037 | 7876 | 117 |
2061275 | 2061275 | 2021-12-29 | Crawford | Kansas | 20037 | 7876 | 117 |
2040043 | 2040043 | 2021-12-22 | Chesterfield | South Carolina | 45025 | 7876 | 154 |
1971302 | 1971302 | 2021-12-01 | Haywood | North Carolina | 37087 | 7876 | 153 |
1942893 | 1942893 | 2021-11-22 | Nacogdoches | Texas | 48347 | 7876 | 233 |
1939643 | 1939643 | 2021-11-21 | Nacogdoches | Texas | 48347 | 7876 | 233 |
1936393 | 1936393 | 2021-11-20 | Nacogdoches | Texas | 48347 | 7876 | 233 |
1922166 | 1922166 | 2021-11-16 | Newton | Missouri | 29145 | 7876 | 129 |
1867418 | 1867418 | 2021-10-30 | Athens | Ohio | 39009 | 7876 | 88 |
1857552 | 1857552 | 2021-10-27 | Halifax | North Carolina | 37083 | 7876 | 139 |
1849375 | 1849375 | 2021-10-25 | Garfield | Colorado | 8045 | 7876 | 60 |
1778265 | 1778265 | 2021-10-03 | Jackson | Illinois | 17077 | 7876 | 102 |
1775015 | 1775015 | 2021-10-02 | Jackson | Illinois | 17077 | 7876 | 102 |
1771765 | 1771765 | 2021-10-01 | Jackson | Illinois | 17077 | 7876 | 102 |
1765746 | 1765746 | 2021-09-29 | Whitley | Kentucky | 21235 | 7876 | 73 |
1760680 | 1760680 | 2021-09-27 | Dyer | Tennessee | 47045 | 7876 | 132 |
1717868 | 1717868 | 2021-09-14 | Pender | North Carolina | 37141 | 7876 | 81 |
1718305 | 1718305 | 2021-09-14 | Newport | Rhode Island | 44005 | 7876 | 45 |
1715057 | 1715057 | 2021-09-13 | Newport | Rhode Island | 44005 | 7876 | 45 |
1711811 | 1711811 | 2021-09-12 | Newport | Rhode Island | 44005 | 7876 | 45 |
1708564 | 1708564 | 2021-09-11 | Newport | Rhode Island | 44005 | 7876 | 45 |
1705317 | 1705317 | 2021-09-10 | Newport | Rhode Island | 44005 | 7876 | 45 |
1702067 | 1702067 | 2021-09-09 | Newport | Rhode Island | 44005 | 7876 | 45 |
1698818 | 1698818 | 2021-09-08 | Newport | Rhode Island | 44005 | 7876 | 45 |
1587811 | 1587811 | 2021-08-05 | Chemung | New York | 36015 | 7876 | 137 |
1570939 | 1570939 | 2021-07-31 | Wicomico | Maryland | 24045 | 7876 | 175 |
1463358 | 1463358 | 2021-06-28 | Warrick | Indiana | 18173 | 7876 | 159 |
1430624 | 1430624 | 2021-06-18 | Rockdale | Georgia | 13247 | 7876 | 176 |
1316022 | 1316022 | 2021-05-13 | Liberty | Texas | 48291 | 7876 | 185 |
1225578 | 1225578 | 2021-04-15 | Natrona | Wyoming | 56025 | 7876 | 135 |
1190026 | 1190026 | 2021-04-05 | Pope | Arkansas | 5115 | 7876 | 107 |
1125283 | 1125283 | 2021-03-16 | Nassau | Florida | 12089 | 7876 | 118 |
1093788 | 1093788 | 2021-03-06 | Carver | Minnesota | 27019 | 7876 | 41 |
962686 | 962686 | 2021-01-25 | St. Clair | Alabama | 1115 | 7876 | 130 |
950821 | 950821 | 2021-01-21 | Terrebonne | Louisiana | 22109 | 7876 | 166 |
926503 | 926503 | 2021-01-13 | Rockwall | Texas | 48397 | 7876 | 64 |
808677 | 808677 | 2020-12-08 | McKinley | New Mexico | 35031 | 7876 | 297 |
711166 | 711166 | 2020-11-08 | Yellowstone | Montana | 30111 | 7876 | 97 |
676812 | 676812 | 2020-10-28 | Loudoun | Virginia | 51107 | 7876 | 130 |
666367 | 666367 | 2020-10-25 | Chester | Pennsylvania | 42029 | 7876 | 378 |
415283 | 415283 | 2020-08-09 | Volusia | Florida | 12127 | 7876 | 135 |
360476 | 360476 | 2020-07-23 | Tulare | California | 6107 | 7876 | 168 |
317198 | 317198 | 2020-07-09 | Douglas | Nebraska | 31055 | 7876 | 102 |
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);