ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 6128 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Mississippi 9
- Nebraska 7
- Arkansas 5
- Illinois 5
- North Carolina 5
- Georgia 4
- Ohio 4
- Virginia 4
- Michigan 3
- Pennsylvania 3
- Colorado 2
- Indiana 2
- New Jersey 2
- Puerto Rico 2
- West Virginia 2
- Alabama 1
- Florida 1
- Minnesota 1
- Missouri 1
- New Hampshire 1
- New York 1
- South Carolina 1
- Tennessee 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489919 | 2489919 | 2022-05-10 | Carroll | Arkansas | 5015 | 6128 | 102 |
2486282 | 2486282 | 2022-05-08 | Hopewell city | Virginia | 51670 | 6128 | 119 |
2483024 | 2483024 | 2022-05-07 | Hopewell city | Virginia | 51670 | 6128 | 119 |
2479766 | 2479766 | 2022-05-06 | Hopewell city | Virginia | 51670 | 6128 | 119 |
2419845 | 2419845 | 2022-04-18 | Cass | Nebraska | 31025 | 6128 | 42 |
2416590 | 2416590 | 2022-04-17 | Cass | Nebraska | 31025 | 6128 | 42 |
2413334 | 2413334 | 2022-04-16 | Cass | Nebraska | 31025 | 6128 | 42 |
2410078 | 2410078 | 2022-04-15 | Cass | Nebraska | 31025 | 6128 | 42 |
2405396 | 2405396 | 2022-04-14 | Delta | Colorado | 8029 | 6128 | 134 |
2406822 | 2406822 | 2022-04-14 | Cass | Nebraska | 31025 | 6128 | 42 |
2403566 | 2403566 | 2022-04-13 | Cass | Nebraska | 31025 | 6128 | 42 |
2378243 | 2378243 | 2022-04-05 | San Sebastian | Puerto Rico | 72131 | 6128 | |
2374989 | 2374989 | 2022-04-04 | San Sebastian | Puerto Rico | 72131 | 6128 | |
2358005 | 2358005 | 2022-03-30 | Cass | Nebraska | 31025 | 6128 | 40 |
2325277 | 2325277 | 2022-03-20 | Tishomingo | Mississippi | 28141 | 6128 | 122 |
2322023 | 2322023 | 2022-03-19 | Tishomingo | Mississippi | 28141 | 6128 | 122 |
2318769 | 2318769 | 2022-03-18 | Tishomingo | Mississippi | 28141 | 6128 | 122 |
2315516 | 2315516 | 2022-03-17 | Tishomingo | Mississippi | 28141 | 6128 | 122 |
2312263 | 2312263 | 2022-03-16 | Tishomingo | Mississippi | 28141 | 6128 | 122 |
2309010 | 2309010 | 2022-03-15 | Tishomingo | Mississippi | 28141 | 6128 | 122 |
2305759 | 2305759 | 2022-03-14 | Tishomingo | Mississippi | 28141 | 6128 | 122 |
2242788 | 2242788 | 2022-02-23 | Routt | Colorado | 8107 | 6128 | 24 |
2239925 | 2239925 | 2022-02-22 | Shelby | Illinois | 17173 | 6128 | 72 |
2187055 | 2187055 | 2022-02-05 | Boone | West Virginia | 54005 | 6128 | 64 |
2142136 | 2142136 | 2022-01-23 | Lee | Georgia | 13177 | 6128 | 90 |
2138881 | 2138881 | 2022-01-22 | Lee | Georgia | 13177 | 6128 | 90 |
2135625 | 2135625 | 2022-01-21 | Lee | Georgia | 13177 | 6128 | 90 |
2119062 | 2119062 | 2022-01-16 | St. Francis | Arkansas | 5123 | 6128 | 74 |
2079348 | 2079348 | 2022-01-03 | Hill | Texas | 48217 | 6128 | 177 |
2058902 | 2058902 | 2021-12-28 | Sullivan | New Hampshire | 33019 | 6128 | 52 |
2032464 | 2032464 | 2021-12-20 | Freeborn | Minnesota | 27047 | 6128 | 51 |
2029818 | 2029818 | 2021-12-19 | Jackson | North Carolina | 37099 | 6128 | 74 |
2026567 | 2026567 | 2021-12-18 | Jackson | North Carolina | 37099 | 6128 | 74 |
2023316 | 2023316 | 2021-12-17 | Jackson | North Carolina | 37099 | 6128 | 74 |
2012905 | 2012905 | 2021-12-14 | Mecosta | Michigan | 26107 | 6128 | 76 |
2009654 | 2009654 | 2021-12-13 | Mecosta | Michigan | 26107 | 6128 | 76 |
1962964 | 1962964 | 2021-11-29 | Baxter | Arkansas | 5005 | 6128 | 188 |
1926400 | 1926400 | 2021-11-17 | Giles | Tennessee | 47055 | 6128 | 127 |
1922922 | 1922922 | 2021-11-16 | Wayne | Pennsylvania | 42127 | 6128 | 119 |
1894625 | 1894625 | 2021-11-08 | Franklin | Alabama | 1059 | 6128 | 107 |
1876587 | 1876587 | 2021-11-02 | Union | Mississippi | 28145 | 6128 | 94 |
1838223 | 1838223 | 2021-10-21 | Mercer | Ohio | 39107 | 6128 | 93 |
1821443 | 1821443 | 2021-10-16 | Phelps | Missouri | 29161 | 6128 | 178 |
1815443 | 1815443 | 2021-10-14 | Crawford | Ohio | 39033 | 6128 | 127 |
1810063 | 1810063 | 2021-10-12 | Monroe | Wisconsin | 55081 | 6128 | 54 |
1755508 | 1755508 | 2021-09-26 | Effingham | Illinois | 17049 | 6128 | 93 |
1752260 | 1752260 | 2021-09-25 | Effingham | Illinois | 17049 | 6128 | 93 |
1749011 | 1749011 | 2021-09-24 | Effingham | Illinois | 17049 | 6128 | 93 |
1739367 | 1739367 | 2021-09-21 | Gibson | Indiana | 18051 | 6128 | 109 |
1609315 | 1609315 | 2021-08-12 | Coles | Illinois | 17029 | 6128 | 103 |
1599713 | 1599713 | 2021-08-09 | Noble | Indiana | 18113 | 6128 | 94 |
1594561 | 1594561 | 2021-08-07 | Lawrence | Ohio | 39087 | 6128 | 106 |
1569870 | 1569870 | 2021-07-31 | Mississippi | Arkansas | 5093 | 6128 | 111 |
1500082 | 1500082 | 2021-07-09 | Salem | New Jersey | 34033 | 6128 | 188 |
1420241 | 1420241 | 2021-06-14 | Harrison | West Virginia | 54033 | 6128 | 80 |
1412504 | 1412504 | 2021-06-12 | Jefferson | New York | 36045 | 6128 | 68 |
1406103 | 1406103 | 2021-06-10 | Lee | North Carolina | 37105 | 6128 | 81 |
1386740 | 1386740 | 2021-06-04 | Belmont | Ohio | 39013 | 6128 | 174 |
1380505 | 1380505 | 2021-06-02 | Union | Pennsylvania | 42119 | 6128 | 88 |
1374014 | 1374014 | 2021-05-31 | Union | Pennsylvania | 42119 | 6128 | 87 |
1313392 | 1313392 | 2021-05-13 | Greene | Arkansas | 5055 | 6128 | 77 |
1291846 | 1291846 | 2021-05-06 | Shiawassee | Michigan | 26155 | 6128 | 99 |
1243761 | 1243761 | 2021-04-21 | Duplin | North Carolina | 37061 | 6128 | 132 |
964079 | 964079 | 2021-01-25 | Lauderdale | Mississippi | 28075 | 6128 | 192 |
930540 | 930540 | 2021-01-15 | Nassau | Florida | 12089 | 6128 | 73 |
721018 | 721018 | 2020-11-11 | Atlantic | New Jersey | 34001 | 6128 | 271 |
676241 | 676241 | 2020-10-28 | Berkeley | South Carolina | 45015 | 6128 | 94 |
593128 | 593128 | 2020-10-03 | Bibb | Georgia | 13021 | 6128 | 177 |
498641 | 498641 | 2020-09-03 | Virginia Beach city | Virginia | 51810 | 6128 | 70 |
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);