ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 6511 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- North Carolina 6
- Ohio 6
- Indiana 5
- Wisconsin 5
- Pennsylvania 4
- South Carolina 4
- South Dakota 4
- Georgia 3
- Louisiana 3
- Nevada 3
- Virginia 3
- Alabama 2
- Colorado 2
- Florida 2
- Kentucky 2
- Michigan 2
- Minnesota 2
- Puerto Rico 2
- Arizona 1
- Arkansas 1
- Idaho 1
- Iowa 1
- Maryland 1
- Mississippi 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500370 | 2500370 | 2022-05-13 | Wells | Indiana | 18179 | 6511 | 132 |
2420513 | 2420513 | 2022-04-18 | Canovanas | Puerto Rico | 72029 | 6511 | |
2312112 | 2312112 | 2022-03-16 | Brown | Minnesota | 27015 | 6511 | 79 |
2282304 | 2282304 | 2022-03-07 | Wells | Indiana | 18179 | 6511 | 132 |
2279026 | 2279026 | 2022-03-06 | Posey | Indiana | 18129 | 6511 | 55 |
2275773 | 2275773 | 2022-03-05 | Posey | Indiana | 18129 | 6511 | 55 |
2272520 | 2272520 | 2022-03-04 | Posey | Indiana | 18129 | 6511 | 55 |
2254342 | 2254342 | 2022-02-26 | Hocking | Ohio | 39073 | 6511 | 114 |
2238491 | 2238491 | 2022-02-21 | Lawrence | South Dakota | 46081 | 6511 | 82 |
2235240 | 2235240 | 2022-02-20 | Lawrence | South Dakota | 46081 | 6511 | 82 |
2231989 | 2231989 | 2022-02-19 | Lawrence | South Dakota | 46081 | 6511 | 82 |
2228738 | 2228738 | 2022-02-18 | Lawrence | South Dakota | 46081 | 6511 | 82 |
2225128 | 2225128 | 2022-02-17 | Van Wert | Ohio | 39161 | 6511 | 133 |
2172327 | 2172327 | 2022-02-01 | Pine | Minnesota | 27115 | 6511 | 58 |
2151902 | 2151902 | 2022-01-26 | Madison | Georgia | 13195 | 6511 | 85 |
2127840 | 2127840 | 2022-01-18 | Marlboro | South Carolina | 45069 | 6511 | 87 |
2118001 | 2118001 | 2022-01-15 | Humacao | Puerto Rico | 72069 | 6511 | |
2015451 | 2015451 | 2021-12-15 | Nez Perce | Idaho | 16069 | 6511 | 108 |
2007237 | 2007237 | 2021-12-12 | Preble | Ohio | 39135 | 6511 | 142 |
1942192 | 1942192 | 2021-11-22 | Highland | Ohio | 39071 | 6511 | 113 |
1923702 | 1923702 | 2021-11-16 | Fayette | West Virginia | 54019 | 6511 | 133 |
1881549 | 1881549 | 2021-11-03 | Pierce | Wisconsin | 55093 | 6511 | 47 |
1834328 | 1834328 | 2021-10-20 | Panola | Mississippi | 28107 | 6511 | 131 |
1716935 | 1716935 | 2021-09-14 | Graves | Kentucky | 21083 | 6511 | 112 |
1705176 | 1705176 | 2021-09-10 | Bradford | Pennsylvania | 42015 | 6511 | 101 |
1700909 | 1700909 | 2021-09-09 | Branch | Michigan | 26023 | 6511 | 127 |
1696505 | 1696505 | 2021-09-08 | Graham | Arizona | 4009 | 6511 | 96 |
1697660 | 1697660 | 2021-09-08 | Branch | Michigan | 26023 | 6511 | 127 |
1685512 | 1685512 | 2021-09-04 | Jefferson | Ohio | 39081 | 6511 | 166 |
1675599 | 1675599 | 2021-09-01 | Edgecombe | North Carolina | 37065 | 6511 | 115 |
1673342 | 1673342 | 2021-08-31 | Albemarle | Virginia | 51003 | 6511 | 85 |
1667141 | 1667141 | 2021-08-29 | Waupaca | Wisconsin | 55135 | 6511 | 169 |
1663893 | 1663893 | 2021-08-28 | Waupaca | Wisconsin | 55135 | 6511 | 169 |
1660645 | 1660645 | 2021-08-27 | Waupaca | Wisconsin | 55135 | 6511 | 169 |
1634513 | 1634513 | 2021-08-19 | Lewis | Washington | 53041 | 6511 | 85 |
1597982 | 1597982 | 2021-08-08 | Carbon | Pennsylvania | 42025 | 6511 | 176 |
1598132 | 1598132 | 2021-08-08 | Cherokee | South Carolina | 45021 | 6511 | 159 |
1594733 | 1594733 | 2021-08-07 | Carbon | Pennsylvania | 42025 | 6511 | 176 |
1594883 | 1594883 | 2021-08-07 | Cherokee | South Carolina | 45021 | 6511 | 159 |
1591634 | 1591634 | 2021-08-06 | Cherokee | South Carolina | 45021 | 6511 | 159 |
1586225 | 1586225 | 2021-08-05 | Garfield | Colorado | 8045 | 6511 | 55 |
1581754 | 1581754 | 2021-08-03 | Indiana | Pennsylvania | 42063 | 6511 | 179 |
1427134 | 1427134 | 2021-06-17 | Fremont | Colorado | 8043 | 6511 | 63 |
1413619 | 1413619 | 2021-06-12 | Harrisonburg city | Virginia | 51660 | 6511 | 95 |
1361644 | 1361644 | 2021-05-27 | Bedford | Virginia | 51019 | 6511 | 103 |
1347488 | 1347488 | 2021-05-23 | Carson City | Nevada | 32510 | 6511 | 123 |
1344240 | 1344240 | 2021-05-22 | Carson City | Nevada | 32510 | 6511 | 123 |
1340992 | 1340992 | 2021-05-21 | Carson City | Nevada | 32510 | 6511 | 123 |
1316914 | 1316914 | 2021-05-14 | Catoosa | Georgia | 13047 | 6511 | 70 |
1301389 | 1301389 | 2021-05-09 | Acadia | Louisiana | 22001 | 6511 | 192 |
1298142 | 1298142 | 2021-05-08 | Acadia | Louisiana | 22001 | 6511 | 192 |
1294896 | 1294896 | 2021-05-07 | Acadia | Louisiana | 22001 | 6511 | 192 |
1234149 | 1234149 | 2021-04-18 | Ashtabula | Ohio | 39007 | 6511 | 165 |
1222346 | 1222346 | 2021-04-15 | Blount | Alabama | 1009 | 6511 | 134 |
1171580 | 1171580 | 2021-03-30 | Allegany | Maryland | 24001 | 6511 | 202 |
925684 | 925684 | 2021-01-13 | Wilson | North Carolina | 37195 | 6511 | 119 |
868554 | 868554 | 2020-12-27 | Limestone | Alabama | 1083 | 6511 | 55 |
865412 | 865412 | 2020-12-26 | Jefferson | Arkansas | 5069 | 6511 | 125 |
804661 | 804661 | 2020-12-07 | Kenton | Kentucky | 21117 | 6511 | 64 |
787860 | 787860 | 2020-12-02 | Lowndes | Georgia | 13185 | 6511 | 127 |
769828 | 769828 | 2020-11-26 | Catawba | North Carolina | 37035 | 6511 | 85 |
766582 | 766582 | 2020-11-25 | Catawba | North Carolina | 37035 | 6511 | 85 |
711478 | 711478 | 2020-11-08 | Robeson | North Carolina | 37155 | 6511 | 101 |
684401 | 684401 | 2020-10-31 | Linn | Iowa | 19113 | 6511 | 134 |
520172 | 520172 | 2020-09-10 | Forsyth | North Carolina | 37067 | 6511 | 84 |
521452 | 521452 | 2020-09-10 | Waukesha | Wisconsin | 55133 | 6511 | 81 |
437789 | 437789 | 2020-08-16 | Brevard | Florida | 12009 | 6511 | 178 |
415259 | 415259 | 2020-08-09 | Marion | Florida | 12083 | 6511 | 89 |
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);