ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where cases = 4227 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 20
- Tennessee 16
- Illinois 10
- Texas 9
- North Carolina 8
- Wisconsin 8
- Georgia 7
- Idaho 6
- California 4
- Indiana 4
- Louisiana 4
- Minnesota 4
- Missouri 4
- Puerto Rico 4
- Iowa 3
- Nebraska 3
- South Dakota 3
- Virginia 3
- Colorado 2
- Kansas 2
- Maryland 2
- Ohio 2
- West Virginia 2
- Alabama 1
- Arkansas 1
- Florida 1
- Hawaii 1
- Massachusetts 1
- Montana 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502118 | 2502118 | 2022-05-13 | Cannon | Tennessee | 47015 | 4227 | 63 |
2498860 | 2498860 | 2022-05-12 | Cannon | Tennessee | 47015 | 4227 | 63 |
2495402 | 2495402 | 2022-05-11 | Aibonito | Puerto Rico | 72009 | 4227 | |
2495602 | 2495602 | 2022-05-11 | Cannon | Tennessee | 47015 | 4227 | 63 |
2475020 | 2475020 | 2022-05-05 | Benton | Missouri | 29015 | 4227 | 106 |
2442362 | 2442362 | 2022-04-25 | Wadena | Minnesota | 27159 | 4227 | 55 |
2428640 | 2428640 | 2022-04-21 | Carroll | Indiana | 18015 | 4227 | 68 |
2430283 | 2430283 | 2022-04-21 | Catano | Puerto Rico | 72033 | 4227 | |
2425384 | 2425384 | 2022-04-20 | Carroll | Indiana | 18015 | 4227 | 68 |
2405727 | 2405727 | 2022-04-14 | Minidoka | Idaho | 16067 | 4227 | 62 |
2402472 | 2402472 | 2022-04-13 | Minidoka | Idaho | 16067 | 4227 | 62 |
2399217 | 2399217 | 2022-04-12 | Minidoka | Idaho | 16067 | 4227 | 62 |
2395962 | 2395962 | 2022-04-11 | Minidoka | Idaho | 16067 | 4227 | 62 |
2396799 | 2396799 | 2022-04-11 | Clarke | Mississippi | 28023 | 4227 | 108 |
2393544 | 2393544 | 2022-04-10 | Clarke | Mississippi | 28023 | 4227 | 108 |
2390288 | 2390288 | 2022-04-09 | Clarke | Mississippi | 28023 | 4227 | 108 |
2387032 | 2387032 | 2022-04-08 | Clarke | Mississippi | 28023 | 4227 | 108 |
2383777 | 2383777 | 2022-04-07 | Clarke | Mississippi | 28023 | 4227 | 108 |
2380522 | 2380522 | 2022-04-06 | Clarke | Mississippi | 28023 | 4227 | 108 |
2377267 | 2377267 | 2022-04-05 | Clarke | Mississippi | 28023 | 4227 | 108 |
2379010 | 2379010 | 2022-04-05 | Crawford | Wisconsin | 55023 | 4227 | 28 |
2374015 | 2374015 | 2022-04-04 | Clarke | Mississippi | 28023 | 4227 | 108 |
2375756 | 2375756 | 2022-04-04 | Crawford | Wisconsin | 55023 | 4227 | 28 |
2372504 | 2372504 | 2022-04-03 | Crawford | Wisconsin | 55023 | 4227 | 28 |
2369251 | 2369251 | 2022-04-02 | Crawford | Wisconsin | 55023 | 4227 | 28 |
2365998 | 2365998 | 2022-04-01 | Crawford | Wisconsin | 55023 | 4227 | 28 |
2362745 | 2362745 | 2022-03-31 | Crawford | Wisconsin | 55023 | 4227 | 28 |
2339939 | 2339939 | 2022-03-24 | Morgan | West Virginia | 54065 | 4227 | 68 |
2319697 | 2319697 | 2022-03-18 | Yabucoa | Puerto Rico | 72151 | 4227 | |
2301630 | 2301630 | 2022-03-13 | Carroll | Illinois | 17015 | 4227 | 48 |
2298378 | 2298378 | 2022-03-12 | Carroll | Illinois | 17015 | 4227 | 48 |
2295126 | 2295126 | 2022-03-11 | Carroll | Illinois | 17015 | 4227 | 48 |
2212475 | 2212475 | 2022-02-13 | Hughes | South Dakota | 46065 | 4227 | 57 |
2209222 | 2209222 | 2022-02-12 | Hughes | South Dakota | 46065 | 4227 | 57 |
2205969 | 2205969 | 2022-02-11 | Hughes | South Dakota | 46065 | 4227 | 57 |
2203107 | 2203107 | 2022-02-10 | Duchesne | Utah | 49013 | 4227 | 23 |
2199802 | 2199802 | 2022-02-09 | Shelby | Texas | 48419 | 4227 | 123 |
2144483 | 2144483 | 2022-01-23 | Robertson | Texas | 48395 | 4227 | 70 |
2123617 | 2123617 | 2022-01-17 | Stone | Mississippi | 28131 | 4227 | 67 |
2120365 | 2120365 | 2022-01-16 | Stone | Mississippi | 28131 | 4227 | 67 |
2117113 | 2117113 | 2022-01-15 | Stone | Mississippi | 28131 | 4227 | 67 |
2113862 | 2113862 | 2022-01-14 | Stone | Mississippi | 28131 | 4227 | 67 |
2101726 | 2101726 | 2022-01-10 | Cayey | Puerto Rico | 72035 | 4227 | |
2087856 | 2087856 | 2022-01-06 | Tishomingo | Mississippi | 28141 | 4227 | 99 |
2061575 | 2061575 | 2021-12-29 | Garrett | Maryland | 24023 | 4227 | 97 |
2053233 | 2053233 | 2021-12-26 | Wayne | Tennessee | 47181 | 4227 | 47 |
2049983 | 2049983 | 2021-12-25 | Wayne | Tennessee | 47181 | 4227 | 47 |
2046733 | 2046733 | 2021-12-24 | Wayne | Tennessee | 47181 | 4227 | 47 |
2043483 | 2043483 | 2021-12-23 | Wayne | Tennessee | 47181 | 4227 | 47 |
2031614 | 2031614 | 2021-12-20 | Peach | Georgia | 13225 | 4227 | 115 |
2030570 | 2030570 | 2021-12-19 | Frio | Texas | 48163 | 4227 | 78 |
2027319 | 2027319 | 2021-12-18 | Frio | Texas | 48163 | 4227 | 78 |
2020852 | 2020852 | 2021-12-16 | Hutchinson | Texas | 48233 | 4227 | 101 |
2021128 | 2021128 | 2021-12-16 | Orange | Virginia | 51137 | 4227 | 66 |
1991891 | 1991891 | 2021-12-07 | Russell | Virginia | 51167 | 4227 | 69 |
1961029 | 1961029 | 2021-11-28 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1957778 | 1957778 | 2021-11-27 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1958446 | 1958446 | 2021-11-27 | Henry | Ohio | 39069 | 4227 | 76 |
1954527 | 1954527 | 2021-11-26 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1951276 | 1951276 | 2021-11-25 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1948025 | 1948025 | 2021-11-24 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1944774 | 1944774 | 2021-11-23 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1941685 | 1941685 | 2021-11-22 | Saline | Missouri | 29195 | 4227 | 83 |
1898423 | 1898423 | 2021-11-09 | Elmore | Idaho | 16039 | 4227 | 47 |
1897145 | 1897145 | 2021-11-08 | DeKalb | Tennessee | 47041 | 4227 | 75 |
1891865 | 1891865 | 2021-11-07 | Sumter | Georgia | 13261 | 4227 | 135 |
1893895 | 1893895 | 2021-11-07 | DeKalb | Tennessee | 47041 | 4227 | 75 |
1888615 | 1888615 | 2021-11-06 | Sumter | Georgia | 13261 | 4227 | 135 |
1890645 | 1890645 | 2021-11-06 | DeKalb | Tennessee | 47041 | 4227 | 75 |
1885365 | 1885365 | 2021-11-05 | Sumter | Georgia | 13261 | 4227 | 135 |
1887395 | 1887395 | 2021-11-05 | DeKalb | Tennessee | 47041 | 4227 | 75 |
1830113 | 1830113 | 2021-10-19 | Pierce | Georgia | 13229 | 4227 | 101 |
1784710 | 1784710 | 2021-10-05 | Latah | Idaho | 16057 | 4227 | 25 |
1745368 | 1745368 | 2021-09-23 | Siskiyou | California | 6093 | 4227 | 51 |
1743853 | 1743853 | 2021-09-22 | Montgomery | North Carolina | 37123 | 4227 | 105 |
1678057 | 1678057 | 2021-09-02 | Jefferson Davis | Louisiana | 22053 | 4227 | 109 |
1647968 | 1647968 | 2021-08-24 | Montrose | Colorado | 8085 | 4227 | 72 |
1629585 | 1629585 | 2021-08-18 | Steele | Minnesota | 27147 | 4227 | 19 |
1610029 | 1610029 | 2021-08-12 | Beltrami | Minnesota | 27007 | 4227 | 65 |
1599607 | 1599607 | 2021-08-09 | Logan | Illinois | 17107 | 4227 | 79 |
1600613 | 1600613 | 2021-08-09 | Silver Bow | Montana | 30093 | 4227 | 87 |
1598261 | 1598261 | 2021-08-08 | Giles | Tennessee | 47055 | 4227 | 99 |
1595012 | 1595012 | 2021-08-07 | Giles | Tennessee | 47055 | 4227 | 99 |
1591763 | 1591763 | 2021-08-06 | Giles | Tennessee | 47055 | 4227 | 99 |
1535478 | 1535478 | 2021-07-20 | Union | Mississippi | 28145 | 4227 | 79 |
1518032 | 1518032 | 2021-07-15 | La Plata | Colorado | 8067 | 4227 | 41 |
1508493 | 1508493 | 2021-07-12 | Liberty | Georgia | 13179 | 4227 | 68 |
1459564 | 1459564 | 2021-06-27 | Tuolumne | California | 6109 | 4227 | 71 |
1456319 | 1456319 | 2021-06-26 | Tuolumne | California | 6109 | 4227 | 71 |
1453074 | 1453074 | 2021-06-25 | Tuolumne | California | 6109 | 4227 | 71 |
1445084 | 1445084 | 2021-06-22 | Stokes | North Carolina | 37169 | 4227 | 80 |
1441839 | 1441839 | 2021-06-21 | Stokes | North Carolina | 37169 | 4227 | 80 |
1439467 | 1439467 | 2021-06-20 | Washington | Texas | 48477 | 4227 | 94 |
1436220 | 1436220 | 2021-06-19 | Washington | Texas | 48477 | 4227 | 94 |
1421555 | 1421555 | 2021-06-15 | Webster | Louisiana | 22119 | 4227 | 113 |
1403484 | 1403484 | 2021-06-09 | Marshall | Tennessee | 47117 | 4227 | 59 |
1400239 | 1400239 | 2021-06-08 | Marshall | Tennessee | 47117 | 4227 | 59 |
1384209 | 1384209 | 2021-06-03 | Matagorda | Texas | 48321 | 4227 | 114 |
1376446 | 1376446 | 2021-06-01 | Butler | Missouri | 29023 | 4227 | 48 |
1373200 | 1373200 | 2021-05-31 | Butler | Missouri | 29023 | 4227 | 48 |
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);