ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5878 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 9
- Georgia 6
- Wisconsin 6
- Illinois 5
- Minnesota 4
- Missouri 4
- Ohio 4
- Arkansas 3
- Idaho 3
- Louisiana 3
- Mississippi 3
- North Carolina 3
- Puerto Rico 3
- Indiana 2
- Maryland 2
- Michigan 2
- New York 2
- Virginia 2
- Alabama 1
- Alaska 1
- California 1
- Colorado 1
- Florida 1
- Kentucky 1
- Massachusetts 1
- Nebraska 1
- New Mexico 1
- Oregon 1
- Pennsylvania 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475884 | 2475884 | 2022-05-05 | Hatillo | Puerto Rico | 72065 | 5878 | |
2444700 | 2444700 | 2022-04-26 | Monroe | Georgia | 13207 | 5878 | 172 |
2441444 | 2441444 | 2022-04-25 | Monroe | Georgia | 13207 | 5878 | 172 |
2415396 | 2415396 | 2022-04-17 | Monroe | Georgia | 13207 | 5878 | 172 |
2412140 | 2412140 | 2022-04-16 | Monroe | Georgia | 13207 | 5878 | 172 |
2408884 | 2408884 | 2022-04-15 | Monroe | Georgia | 13207 | 5878 | 172 |
2358704 | 2358704 | 2022-03-30 | Manati | Puerto Rico | 72091 | 5878 | |
2261273 | 2261273 | 2022-02-28 | Yankton | South Dakota | 46135 | 5878 | 56 |
2217947 | 2217947 | 2022-02-15 | Newton | Mississippi | 28101 | 5878 | 92 |
2188769 | 2188769 | 2022-02-06 | Miller | Missouri | 29131 | 5878 | 105 |
2148934 | 2148934 | 2022-01-25 | Posey | Indiana | 18129 | 5878 | 48 |
2137496 | 2137496 | 2022-01-21 | Canovanas | Puerto Rico | 72029 | 5878 | |
2132081 | 2132081 | 2022-01-20 | Yell | Arkansas | 5149 | 5878 | 92 |
2129367 | 2129367 | 2022-01-19 | Fayette | Indiana | 18041 | 5878 | 127 |
2123828 | 2123828 | 2022-01-17 | Dakota | Nebraska | 31043 | 5878 | 82 |
2099429 | 2099429 | 2022-01-10 | Pike | Alabama | 1109 | 5878 | 112 |
2075686 | 2075686 | 2022-01-02 | Susquehanna | Pennsylvania | 42115 | 5878 | 86 |
2036986 | 2036986 | 2021-12-21 | White | Tennessee | 47185 | 5878 | 104 |
2016937 | 2016937 | 2021-12-15 | Coshocton | Ohio | 39031 | 5878 | 115 |
2009025 | 2009025 | 2021-12-13 | Monroe | Illinois | 17133 | 5878 | 106 |
1994339 | 1994339 | 2021-12-08 | Coos | Oregon | 41011 | 5878 | 109 |
1992051 | 1992051 | 2021-12-07 | Oneida | Wisconsin | 55085 | 5878 | 101 |
1988800 | 1988800 | 2021-12-06 | Oneida | Wisconsin | 55085 | 5878 | 101 |
1985550 | 1985550 | 2021-12-05 | Oneida | Wisconsin | 55085 | 5878 | 101 |
1982300 | 1982300 | 2021-12-04 | Oneida | Wisconsin | 55085 | 5878 | 101 |
1979050 | 1979050 | 2021-12-03 | Oneida | Wisconsin | 55085 | 5878 | 101 |
1946200 | 1946200 | 2021-11-23 | Upshur | Texas | 48459 | 5878 | 154 |
1924023 | 1924023 | 2021-11-17 | Union | Arkansas | 5139 | 5878 | 141 |
1919241 | 1919241 | 2021-11-15 | Tioga | New York | 36107 | 5878 | 73 |
1915235 | 1915235 | 2021-11-14 | Evangeline | Louisiana | 22039 | 5878 | 141 |
1911985 | 1911985 | 2021-11-13 | Evangeline | Louisiana | 22039 | 5878 | 141 |
1908736 | 1908736 | 2021-11-12 | Evangeline | Louisiana | 22039 | 5878 | 141 |
1883069 | 1883069 | 2021-11-04 | Pike | Mississippi | 28113 | 5878 | 155 |
1859132 | 1859132 | 2021-10-28 | La Plata | Colorado | 8067 | 5878 | 54 |
1846547 | 1846547 | 2021-10-24 | Stephenson | Illinois | 17177 | 5878 | 112 |
1843297 | 1843297 | 2021-10-23 | Stephenson | Illinois | 17177 | 5878 | 112 |
1840047 | 1840047 | 2021-10-22 | Stephenson | Illinois | 17177 | 5878 | 112 |
1828235 | 1828235 | 2021-10-18 | Montgomery | New York | 36057 | 5878 | 138 |
1789487 | 1789487 | 2021-10-06 | Mercer | Ohio | 39107 | 5878 | 91 |
1755445 | 1755445 | 2021-09-26 | Bingham | Idaho | 16011 | 5878 | 90 |
1751776 | 1751776 | 2021-09-25 | Independence | Arkansas | 5063 | 5878 | 152 |
1752197 | 1752197 | 2021-09-25 | Bingham | Idaho | 16011 | 5878 | 90 |
1748948 | 1748948 | 2021-09-24 | Bingham | Idaho | 16011 | 5878 | 90 |
1743466 | 1743466 | 2021-09-22 | Phelps | Missouri | 29161 | 5878 | 171 |
1700292 | 1700292 | 2021-09-09 | Henry | Illinois | 17073 | 5878 | 100 |
1607553 | 1607553 | 2021-08-11 | Jefferson | Ohio | 39081 | 5878 | 162 |
1588684 | 1588684 | 2021-08-05 | Harrison | Texas | 48203 | 5878 | 112 |
1516647 | 1516647 | 2021-07-14 | Union | Ohio | 39159 | 5878 | 49 |
1513890 | 1513890 | 2021-07-13 | Atascosa | Texas | 48013 | 5878 | 151 |
1506149 | 1506149 | 2021-07-11 | Otter Tail | Minnesota | 27111 | 5878 | 87 |
1502903 | 1502903 | 2021-07-10 | Otter Tail | Minnesota | 27111 | 5878 | 87 |
1499657 | 1499657 | 2021-07-09 | Otter Tail | Minnesota | 27111 | 5878 | 87 |
1496411 | 1496411 | 2021-07-08 | Otter Tail | Minnesota | 27111 | 5878 | 87 |
1445725 | 1445725 | 2021-06-22 | Atascosa | Texas | 48013 | 5878 | 151 |
1442480 | 1442480 | 2021-06-21 | Atascosa | Texas | 48013 | 5878 | 151 |
1439235 | 1439235 | 2021-06-20 | Atascosa | Texas | 48013 | 5878 | 151 |
1435988 | 1435988 | 2021-06-19 | Atascosa | Texas | 48013 | 5878 | 151 |
1361471 | 1361471 | 2021-05-27 | Lamar | Texas | 48277 | 5878 | 156 |
1295329 | 1295329 | 2021-05-07 | Lincoln | Missouri | 29113 | 5878 | 41 |
1288504 | 1288504 | 2021-05-05 | St. Mary's | Maryland | 24037 | 5878 | 123 |
1279486 | 1279486 | 2021-05-02 | Granville | North Carolina | 37077 | 5878 | 80 |
1276239 | 1276239 | 2021-05-01 | Granville | North Carolina | 37077 | 5878 | 80 |
1272992 | 1272992 | 2021-04-30 | Granville | North Carolina | 37077 | 5878 | 80 |
1259379 | 1259379 | 2021-04-26 | Shiawassee | Michigan | 26155 | 5878 | 95 |
1196330 | 1196330 | 2021-04-06 | Waupaca | Wisconsin | 55135 | 5878 | 161 |
1180338 | 1180338 | 2021-04-02 | San Benito | California | 6069 | 5878 | 61 |
1174895 | 1174895 | 2021-03-31 | Gratiot | Michigan | 26057 | 5878 | 109 |
1083779 | 1083779 | 2021-03-03 | Laurel | Kentucky | 21125 | 5878 | 31 |
995158 | 995158 | 2021-02-04 | Fairbanks North Star Borough | Alaska | 2090 | 5878 | 26 |
992243 | 992243 | 2021-02-03 | Bulloch | Georgia | 13031 | 5878 | 78 |
950872 | 950872 | 2021-01-21 | Wicomico | Maryland | 24045 | 5878 | 112 |
951491 | 951491 | 2021-01-21 | Valencia | New Mexico | 35061 | 5878 | 75 |
946175 | 946175 | 2021-01-19 | Portsmouth city | Virginia | 51740 | 5878 | 94 |
554171 | 554171 | 2020-09-21 | Bay | Florida | 12005 | 5878 | 94 |
479186 | 479186 | 2020-08-28 | Loudoun | Virginia | 51107 | 5878 | 118 |
435672 | 435672 | 2020-08-15 | Hinds | Mississippi | 28049 | 5878 | 128 |
385554 | 385554 | 2020-07-30 | Webb | Texas | 48479 | 5878 | 122 |
263519 | 263519 | 2020-06-22 | St. Louis | Missouri | 29189 | 5878 | 551 |
185779 | 185779 | 2020-05-28 | Hampden | Massachusetts | 25013 | 5878 | 562 |
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);