ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
131 rows where cases = 3002 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 10
- Kentucky 10
- Indiana 9
- Virginia 9
- Georgia 7
- Arkansas 6
- Minnesota 6
- Texas 6
- Ohio 5
- Tennessee 5
- Colorado 4
- Idaho 4
- North Carolina 4
- Puerto Rico 4
- Iowa 3
- Louisiana 3
- Michigan 3
- Mississippi 3
- New York 3
- West Virginia 3
- California 2
- Illinois 2
- Missouri 2
- Montana 2
- New Hampshire 2
- Wisconsin 2
- Florida 1
- Maryland 1
- Massachusetts 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2293265 | 2293265 | 2022-03-10 | Washington | North Carolina | 37187 | 3002 | 50 |
2281924 | 2281924 | 2022-03-07 | Charlton | Georgia | 13049 | 3002 | 62 |
2262126 | 2262126 | 2022-03-01 | Desha | Arkansas | 5041 | 3002 | 38 |
2240577 | 2240577 | 2022-02-22 | Chippewa | Minnesota | 27023 | 3002 | 47 |
2145184 | 2145184 | 2022-01-24 | Gunnison | Colorado | 8051 | 3002 | 13 |
2144705 | 2144705 | 2022-01-23 | Southampton | Virginia | 51175 | 3002 | 75 |
2141450 | 2141450 | 2022-01-22 | Southampton | Virginia | 51175 | 3002 | 75 |
2138194 | 2138194 | 2022-01-21 | Southampton | Virginia | 51175 | 3002 | 75 |
2127507 | 2127507 | 2022-01-18 | Monroe | Ohio | 39111 | 3002 | 68 |
2122017 | 2122017 | 2022-01-16 | Monroe | West Virginia | 54063 | 3002 | 33 |
2115645 | 2115645 | 2022-01-15 | Clay | Alabama | 1027 | 3002 | 70 |
2112393 | 2112393 | 2022-01-14 | Clay | Alabama | 1027 | 3002 | 70 |
2109141 | 2109141 | 2022-01-13 | Clay | Alabama | 1027 | 3002 | 70 |
2109913 | 2109913 | 2022-01-13 | Tipton | Indiana | 18159 | 3002 | 77 |
2105890 | 2105890 | 2022-01-12 | Clay | Alabama | 1027 | 3002 | 70 |
2062311 | 2062311 | 2021-12-29 | Hertford | North Carolina | 37091 | 3002 | 73 |
1940262 | 1940262 | 2021-11-22 | Polk | Arkansas | 5113 | 3002 | 112 |
1928202 | 1928202 | 2021-11-18 | Spencer | Kentucky | 21215 | 3002 | 35 |
1920884 | 1920884 | 2021-11-16 | Otero | Colorado | 8089 | 3002 | 89 |
1906717 | 1906717 | 2021-11-11 | Juncos | Puerto Rico | 72077 | 3002 | |
1901838 | 1901838 | 2021-11-10 | Jay | Indiana | 18075 | 3002 | 52 |
1904222 | 1904222 | 2021-11-10 | McDowell | West Virginia | 54047 | 3002 | 50 |
1849671 | 1849671 | 2021-10-25 | Blaine | Idaho | 16013 | 3002 | 26 |
1810309 | 1810309 | 2021-10-13 | Colusa | California | 6011 | 3002 | 18 |
1802735 | 1802735 | 2021-10-10 | Humacao | Puerto Rico | 72069 | 3002 | |
1799486 | 1799486 | 2021-10-09 | Humacao | Puerto Rico | 72069 | 3002 | |
1787045 | 1787045 | 2021-10-05 | Washington | Vermont | 50023 | 3002 | 18 |
1768170 | 1768170 | 2021-09-30 | Pitkin | Colorado | 8097 | 3002 | 5 |
1731234 | 1731234 | 2021-09-18 | Canovanas | Puerto Rico | 72029 | 3002 | |
1716514 | 1716514 | 2021-09-14 | Douglas | Illinois | 17041 | 3002 | 42 |
1717126 | 1717126 | 2021-09-14 | Franklin | Massachusetts | 25011 | 3002 | 115 |
1696896 | 1696896 | 2021-09-08 | Mitchell | Georgia | 13205 | 3002 | 91 |
1698937 | 1698937 | 2021-09-08 | Bledsoe | Tennessee | 47007 | 3002 | 13 |
1685279 | 1685279 | 2021-09-04 | Lewis | New York | 36049 | 3002 | 36 |
1657343 | 1657343 | 2021-08-26 | Door | Wisconsin | 55029 | 3002 | 37 |
1647802 | 1647802 | 2021-08-24 | Cleburne | Arkansas | 5023 | 3002 | 79 |
1647842 | 1647842 | 2021-08-24 | Ouachita | Arkansas | 5103 | 3002 | 67 |
1642519 | 1642519 | 2021-08-22 | Cass | Minnesota | 27021 | 3002 | 33 |
1639269 | 1639269 | 2021-08-21 | Cass | Minnesota | 27021 | 3002 | 33 |
1636019 | 1636019 | 2021-08-20 | Cass | Minnesota | 27021 | 3002 | 33 |
1621052 | 1621052 | 2021-08-15 | Smith | Tennessee | 47159 | 3002 | 40 |
1617804 | 1617804 | 2021-08-14 | Smith | Tennessee | 47159 | 3002 | 40 |
1613472 | 1613472 | 2021-08-13 | Crawford | Missouri | 29055 | 3002 | 41 |
1614556 | 1614556 | 2021-08-13 | Smith | Tennessee | 47159 | 3002 | 40 |
1609201 | 1609201 | 2021-08-12 | Peach | Georgia | 13225 | 3002 | 72 |
1605340 | 1605340 | 2021-08-10 | Preston | West Virginia | 54077 | 3002 | 47 |
1574120 | 1574120 | 2021-08-01 | Pointe Coupee | Louisiana | 22077 | 3002 | 75 |
1570872 | 1570872 | 2021-07-31 | Pointe Coupee | Louisiana | 22077 | 3002 | 75 |
1567624 | 1567624 | 2021-07-30 | Pointe Coupee | Louisiana | 22077 | 3002 | 75 |
1569149 | 1569149 | 2021-07-30 | Deaf Smith | Texas | 48117 | 3002 | 68 |
1563634 | 1563634 | 2021-07-29 | Chattooga | Georgia | 13055 | 3002 | 76 |
1560693 | 1560693 | 2021-07-28 | Fayette | Indiana | 18041 | 3002 | 66 |
1551276 | 1551276 | 2021-07-25 | Harlan | Kentucky | 21095 | 3002 | 93 |
1548029 | 1548029 | 2021-07-24 | Harlan | Kentucky | 21095 | 3002 | 93 |
1544782 | 1544782 | 2021-07-23 | Harlan | Kentucky | 21095 | 3002 | 93 |
1517438 | 1517438 | 2021-07-14 | Amherst | Virginia | 51009 | 3002 | 40 |
1511379 | 1511379 | 2021-07-13 | Carroll | Arkansas | 5015 | 3002 | 47 |
1492576 | 1492576 | 2021-07-07 | Wells | Indiana | 18179 | 3002 | 83 |
1489329 | 1489329 | 2021-07-06 | Wells | Indiana | 18179 | 3002 | 83 |
1441626 | 1441626 | 2021-06-21 | Nye | Nevada | 32023 | 3002 | 108 |
1408418 | 1408418 | 2021-06-11 | Clark | Kentucky | 21049 | 3002 | 32 |
1395630 | 1395630 | 2021-06-07 | Queen Anne's | Maryland | 24035 | 3002 | 51 |
1359557 | 1359557 | 2021-05-27 | Jones | Iowa | 19105 | 3002 | 57 |
1356311 | 1356311 | 2021-05-26 | Jones | Iowa | 19105 | 3002 | 57 |
1353306 | 1353306 | 2021-05-25 | Muhlenberg | Kentucky | 21177 | 3002 | 66 |
1322797 | 1322797 | 2021-05-15 | Warren | Virginia | 51187 | 3002 | 57 |
1307343 | 1307343 | 2021-05-11 | Jefferson | Idaho | 16051 | 3002 | 28 |
1303555 | 1303555 | 2021-05-10 | Lawrence | Alabama | 1079 | 3002 | 98 |
1300308 | 1300308 | 2021-05-09 | Lawrence | Alabama | 1079 | 3002 | 98 |
1297061 | 1297061 | 2021-05-08 | Lawrence | Alabama | 1079 | 3002 | 98 |
1259715 | 1259715 | 2021-04-26 | Ravalli | Montana | 30081 | 3002 | 31 |
1253221 | 1253221 | 2021-04-24 | Ravalli | Montana | 30081 | 3002 | 31 |
1243099 | 1243099 | 2021-04-21 | Houghton | Michigan | 26061 | 3002 | 40 |
1230389 | 1230389 | 2021-04-17 | Lafayette | Missouri | 29107 | 3002 | 56 |
1196165 | 1196165 | 2021-04-06 | Wise | Virginia | 51195 | 3002 | 93 |
1155922 | 1155922 | 2021-03-25 | Grafton | New Hampshire | 33009 | 3002 | 20 |
1146179 | 1146179 | 2021-03-22 | Cheshire | New Hampshire | 33005 | 3002 | 30 |
1115970 | 1115970 | 2021-03-13 | White | Indiana | 18181 | 3002 | 55 |
1109988 | 1109988 | 2021-03-11 | Newaygo | Michigan | 26123 | 3002 | 52 |
1103254 | 1103254 | 2021-03-09 | Knox | Kentucky | 21121 | 3002 | 14 |
1089771 | 1089771 | 2021-03-05 | Bonner | Idaho | 16017 | 3002 | 33 |
1090541 | 1090541 | 2021-03-05 | Carlton | Minnesota | 27017 | 3002 | 49 |
1086526 | 1086526 | 2021-03-04 | Bonner | Idaho | 16017 | 3002 | 33 |
1083232 | 1083232 | 2021-03-03 | Stephens | Georgia | 13257 | 3002 | 73 |
1063236 | 1063236 | 2021-02-24 | Sheridan | Wyoming | 56033 | 3002 | 27 |
1055694 | 1055694 | 2021-02-22 | Lincoln | Oklahoma | 40081 | 3002 | 54 |
1035903 | 1035903 | 2021-02-16 | Montgomery | New York | 36057 | 3002 | 97 |
1021251 | 1021251 | 2021-02-12 | Lake | California | 6033 | 3002 | 36 |
1001741 | 1001741 | 2021-02-06 | Poinsett | Arkansas | 5111 | 3002 | 74 |
1004755 | 1004755 | 2021-02-06 | Juneau | Wisconsin | 55057 | 3002 | 19 |
999341 | 999341 | 2021-02-05 | Boyle | Kentucky | 21021 | 3002 | 28 |
995471 | 995471 | 2021-02-04 | Wakulla | Florida | 12129 | 3002 | 41 |
984957 | 984957 | 2021-01-31 | Waller | Texas | 48473 | 3002 | 32 |
981431 | 981431 | 2021-01-30 | Macon | Tennessee | 47111 | 3002 | 56 |
976232 | 976232 | 2021-01-29 | Fayette | Illinois | 17051 | 3002 | 54 |
976643 | 976643 | 2021-01-29 | Franklin | Kentucky | 21073 | 3002 | 24 |
959395 | 959395 | 2021-01-24 | Clarke | Alabama | 1025 | 3002 | 36 |
960153 | 960153 | 2021-01-24 | Ripley | Indiana | 18137 | 3002 | 46 |
955759 | 955759 | 2021-01-22 | Wilson | Texas | 48493 | 3002 | 43 |
950433 | 950433 | 2021-01-21 | Wabash | Indiana | 18169 | 3002 | 47 |
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);