ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 5384 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Georgia 10
- Texas 8
- Oklahoma 7
- Kentucky 6
- Michigan 4
- Missouri 4
- Ohio 4
- South Carolina 4
- Virginia 4
- Louisiana 3
- Minnesota 3
- Alabama 2
- Colorado 2
- Illinois 2
- Kansas 2
- Mississippi 2
- North Carolina 2
- Tennessee 2
- Florida 1
- Indiana 1
- Maryland 1
- Montana 1
- New Hampshire 1
- New York 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500686 | 2500686 | 2022-05-13 | Spencer | Kentucky | 21215 | 5384 | 59 |
2497428 | 2497428 | 2022-05-12 | Spencer | Kentucky | 21215 | 5384 | 59 |
2494170 | 2494170 | 2022-05-11 | Spencer | Kentucky | 21215 | 5384 | 59 |
2490912 | 2490912 | 2022-05-10 | Spencer | Kentucky | 21215 | 5384 | 59 |
2487655 | 2487655 | 2022-05-09 | Spencer | Kentucky | 21215 | 5384 | 59 |
2464436 | 2464436 | 2022-05-02 | Union | Illinois | 17181 | 5384 | 68 |
2466723 | 2466723 | 2022-05-02 | Fredericksburg city | Virginia | 51630 | 5384 | 42 |
2424133 | 2424133 | 2022-04-19 | Gillespie | Texas | 48171 | 5384 | 109 |
2348089 | 2348089 | 2022-03-27 | Crawford | Missouri | 29055 | 5384 | 101 |
2344836 | 2344836 | 2022-03-26 | Crawford | Missouri | 29055 | 5384 | 101 |
2341583 | 2341583 | 2022-03-25 | Crawford | Missouri | 29055 | 5384 | 101 |
2310356 | 2310356 | 2022-03-15 | San Jacinto | Texas | 48407 | 5384 | 100 |
2223444 | 2223444 | 2022-02-17 | Haralson | Georgia | 13143 | 5384 | 154 |
2211225 | 2211225 | 2022-02-13 | Alpena | Michigan | 26007 | 5384 | 127 |
2207972 | 2207972 | 2022-02-12 | Alpena | Michigan | 26007 | 5384 | 127 |
2204719 | 2204719 | 2022-02-11 | Alpena | Michigan | 26007 | 5384 | 127 |
2173314 | 2173314 | 2022-02-01 | Juana Diaz | Puerto Rico | 72075 | 5384 | |
2164721 | 2164721 | 2022-01-30 | Montezuma | Colorado | 8083 | 5384 | 60 |
2158210 | 2158210 | 2022-01-28 | Montezuma | Colorado | 8083 | 5384 | 60 |
2148783 | 2148783 | 2022-01-25 | Crawford | Illinois | 17033 | 5384 | 53 |
2104058 | 2104058 | 2022-01-11 | Covington | Mississippi | 28031 | 5384 | 98 |
2039699 | 2039699 | 2021-12-22 | Fayette | Ohio | 39047 | 5384 | 76 |
2037081 | 2037081 | 2021-12-21 | Grimes | Texas | 48185 | 5384 | 109 |
2019976 | 2019976 | 2021-12-16 | Greene | New York | 36039 | 5384 | 94 |
1935718 | 1935718 | 2021-11-20 | Ottawa | Ohio | 39123 | 5384 | 98 |
1856654 | 1856654 | 2021-10-27 | Harlan | Kentucky | 21095 | 5384 | 128 |
1825561 | 1825561 | 2021-10-17 | Marion | South Carolina | 45067 | 5384 | 136 |
1822312 | 1822312 | 2021-10-16 | Marion | South Carolina | 45067 | 5384 | 136 |
1819063 | 1819063 | 2021-10-15 | Marion | South Carolina | 45067 | 5384 | 136 |
1809450 | 1809450 | 2021-10-12 | Macon | Tennessee | 47111 | 5384 | 88 |
1801725 | 1801725 | 2021-10-10 | Isanti | Minnesota | 27059 | 5384 | 72 |
1798476 | 1798476 | 2021-10-09 | Isanti | Minnesota | 27059 | 5384 | 72 |
1795227 | 1795227 | 2021-10-08 | Isanti | Minnesota | 27059 | 5384 | 72 |
1763160 | 1763160 | 2021-09-28 | Belknap | New Hampshire | 33001 | 5384 | 116 |
1755298 | 1755298 | 2021-09-26 | Chattahoochee | Georgia | 13053 | 5384 | 17 |
1755380 | 1755380 | 2021-09-26 | Oconee | Georgia | 13219 | 5384 | 78 |
1752050 | 1752050 | 2021-09-25 | Chattahoochee | Georgia | 13053 | 5384 | 17 |
1752132 | 1752132 | 2021-09-25 | Oconee | Georgia | 13219 | 5384 | 78 |
1748801 | 1748801 | 2021-09-24 | Chattahoochee | Georgia | 13053 | 5384 | 17 |
1748883 | 1748883 | 2021-09-24 | Oconee | Georgia | 13219 | 5384 | 78 |
1747597 | 1747597 | 2021-09-23 | Williamsburg | South Carolina | 45089 | 5384 | 115 |
1676783 | 1676783 | 2021-09-01 | Marion | West Virginia | 54049 | 5384 | 60 |
1669923 | 1669923 | 2021-08-30 | Kerr | Texas | 48265 | 5384 | 102 |
1642364 | 1642364 | 2021-08-22 | Webster | Louisiana | 22119 | 5384 | 119 |
1639114 | 1639114 | 2021-08-21 | Webster | Louisiana | 22119 | 5384 | 119 |
1635864 | 1635864 | 2021-08-20 | Webster | Louisiana | 22119 | 5384 | 119 |
1632852 | 1632852 | 2021-08-19 | Bolivar | Mississippi | 28011 | 5384 | 138 |
1631130 | 1631130 | 2021-08-18 | Campbell | Virginia | 51031 | 5384 | 109 |
1561932 | 1561932 | 2021-07-28 | McDowell | North Carolina | 37111 | 5384 | 63 |
1536216 | 1536216 | 2021-07-20 | Washington | Oklahoma | 40147 | 5384 | 119 |
1532968 | 1532968 | 2021-07-19 | Washington | Oklahoma | 40147 | 5384 | 119 |
1529721 | 1529721 | 2021-07-18 | Washington | Oklahoma | 40147 | 5384 | 119 |
1526474 | 1526474 | 2021-07-17 | Washington | Oklahoma | 40147 | 5384 | 119 |
1523227 | 1523227 | 2021-07-16 | Washington | Oklahoma | 40147 | 5384 | 119 |
1519979 | 1519979 | 2021-07-15 | Washington | Oklahoma | 40147 | 5384 | 119 |
1516731 | 1516731 | 2021-07-14 | Washington | Oklahoma | 40147 | 5384 | 119 |
1512838 | 1512838 | 2021-07-13 | Pettis | Missouri | 29159 | 5384 | 77 |
1469482 | 1469482 | 2021-06-30 | Coffee | Georgia | 13069 | 5384 | 178 |
1383677 | 1383677 | 2021-06-03 | Linn | Oregon | 41043 | 5384 | 77 |
1367507 | 1367507 | 2021-05-29 | Mifflin | Pennsylvania | 42087 | 5384 | 178 |
1359092 | 1359092 | 2021-05-27 | Suwannee | Florida | 12121 | 5384 | 139 |
1269901 | 1269901 | 2021-04-29 | Huron | Ohio | 39077 | 5384 | 117 |
1215618 | 1215618 | 2021-04-12 | Pittsylvania | Virginia | 51143 | 5384 | 77 |
1212371 | 1212371 | 2021-04-11 | Pittsylvania | Virginia | 51143 | 5384 | 77 |
1173639 | 1173639 | 2021-03-31 | Coffee | Alabama | 1031 | 5384 | 110 |
1118928 | 1118928 | 2021-03-14 | Polk | Georgia | 13233 | 5384 | 83 |
1115103 | 1115103 | 2021-03-12 | Grant | Wisconsin | 55043 | 5384 | 87 |
947701 | 947701 | 2021-01-20 | Montcalm | Michigan | 26117 | 5384 | 84 |
946025 | 946025 | 2021-01-19 | Wise | Texas | 48497 | 5384 | 84 |
942778 | 942778 | 2021-01-18 | Wise | Texas | 48497 | 5384 | 82 |
939533 | 939533 | 2021-01-17 | Wise | Texas | 48497 | 5384 | 82 |
936288 | 936288 | 2021-01-16 | Wise | Texas | 48497 | 5384 | 82 |
921412 | 921412 | 2021-01-12 | Riley | Kansas | 20161 | 5384 | 22 |
918167 | 918167 | 2021-01-11 | Riley | Kansas | 20161 | 5384 | 22 |
877003 | 877003 | 2020-12-29 | Wilson | North Carolina | 37195 | 5384 | 103 |
840517 | 840517 | 2020-12-18 | Charles | Maryland | 24017 | 5384 | 116 |
799715 | 799715 | 2020-12-05 | Sevier | Tennessee | 47155 | 5384 | 39 |
794614 | 794614 | 2020-12-04 | LaPorte | Indiana | 18091 | 5384 | 107 |
763498 | 763498 | 2020-11-24 | Fairfield | Ohio | 39045 | 5384 | 64 |
738741 | 738741 | 2020-11-17 | Marshall | Alabama | 1095 | 5384 | 53 |
652782 | 652782 | 2020-10-21 | Yellowstone | Montana | 30111 | 5384 | 82 |
473467 | 473467 | 2020-08-27 | Muscogee | Georgia | 13215 | 5384 | 126 |
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);