ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 5853 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Louisiana 11
- Oklahoma 7
- Ohio 4
- South Dakota 4
- Arkansas 3
- Indiana 3
- Michigan 3
- Minnesota 3
- South Carolina 3
- Texas 3
- Georgia 2
- Nevada 2
- New York 2
- Pennsylvania 2
- Virginia 2
- Alabama 1
- Arizona 1
- Colorado 1
- Iowa 1
- Kentucky 1
- Missouri 1
- North Carolina 1
- Oregon 1
- Puerto Rico 1
- Tennessee 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430641 | 2430641 | 2022-04-21 | Frio | Texas | 48163 | 5853 | 93 |
2396515 | 2396515 | 2022-04-11 | Grant | Louisiana | 22043 | 5853 | 94 |
2393260 | 2393260 | 2022-04-10 | Grant | Louisiana | 22043 | 5853 | 94 |
2390004 | 2390004 | 2022-04-09 | Grant | Louisiana | 22043 | 5853 | 94 |
2386748 | 2386748 | 2022-04-08 | Grant | Louisiana | 22043 | 5853 | 94 |
2383493 | 2383493 | 2022-04-07 | Grant | Louisiana | 22043 | 5853 | 94 |
2335444 | 2335444 | 2022-03-23 | Seneca | New York | 36099 | 5853 | 89 |
2332678 | 2332678 | 2022-03-22 | Manati | Puerto Rico | 72091 | 5853 | |
2167587 | 2167587 | 2022-01-30 | Upshur | West Virginia | 54097 | 5853 | 77 |
2145207 | 2145207 | 2022-01-24 | Pitkin | Colorado | 8097 | 5853 | 6 |
2131704 | 2131704 | 2022-01-19 | Wythe | Virginia | 51197 | 5853 | 121 |
2106056 | 2106056 | 2022-01-12 | St. Francis | Arkansas | 5123 | 5853 | 74 |
2104395 | 2104395 | 2022-01-11 | Douglas | Nevada | 32005 | 5853 | 75 |
2066072 | 2066072 | 2021-12-30 | Williamsburg | South Carolina | 45089 | 5853 | 131 |
1978716 | 1978716 | 2021-12-03 | Washington | Texas | 48477 | 5853 | 133 |
1915239 | 1915239 | 2021-11-14 | Iberville | Louisiana | 22047 | 5853 | 127 |
1911989 | 1911989 | 2021-11-13 | Iberville | Louisiana | 22047 | 5853 | 127 |
1908740 | 1908740 | 2021-11-12 | Iberville | Louisiana | 22047 | 5853 | 127 |
1887175 | 1887175 | 2021-11-05 | Wayne | Pennsylvania | 42127 | 5853 | 113 |
1876240 | 1876240 | 2021-11-02 | Evangeline | Louisiana | 22039 | 5853 | 140 |
1872991 | 1872991 | 2021-11-01 | Evangeline | Louisiana | 22039 | 5853 | 140 |
1869865 | 1869865 | 2021-10-31 | Delta | Michigan | 26041 | 5853 | 106 |
1866616 | 1866616 | 2021-10-30 | Delta | Michigan | 26041 | 5853 | 106 |
1863367 | 1863367 | 2021-10-29 | Delta | Michigan | 26041 | 5853 | 106 |
1854562 | 1854562 | 2021-10-26 | Okmulgee | Oklahoma | 40111 | 5853 | 138 |
1849878 | 1849878 | 2021-10-25 | Putnam | Indiana | 18133 | 5853 | 82 |
1851313 | 1851313 | 2021-10-25 | Okmulgee | Oklahoma | 40111 | 5853 | 138 |
1848063 | 1848063 | 2021-10-24 | Okmulgee | Oklahoma | 40111 | 5853 | 138 |
1844813 | 1844813 | 2021-10-23 | Okmulgee | Oklahoma | 40111 | 5853 | 138 |
1841563 | 1841563 | 2021-10-22 | Okmulgee | Oklahoma | 40111 | 5853 | 138 |
1838314 | 1838314 | 2021-10-21 | Okmulgee | Oklahoma | 40111 | 5853 | 138 |
1835065 | 1835065 | 2021-10-20 | Okmulgee | Oklahoma | 40111 | 5853 | 138 |
1782865 | 1782865 | 2021-10-04 | Stokes | North Carolina | 37169 | 5853 | 99 |
1692377 | 1692377 | 2021-09-06 | Brown | South Dakota | 46013 | 5853 | 95 |
1689128 | 1689128 | 2021-09-05 | Brown | South Dakota | 46013 | 5853 | 95 |
1685878 | 1685878 | 2021-09-04 | Brown | South Dakota | 46013 | 5853 | 95 |
1682627 | 1682627 | 2021-09-03 | Brown | South Dakota | 46013 | 5853 | 95 |
1571614 | 1571614 | 2021-07-31 | Wayne | New York | 36117 | 5853 | 73 |
1554805 | 1554805 | 2021-07-26 | Benton | Minnesota | 27009 | 5853 | 98 |
1524266 | 1524266 | 2021-07-17 | Coffee | Alabama | 1031 | 5853 | 130 |
1515672 | 1515672 | 2021-07-14 | St. Charles | Louisiana | 22089 | 5853 | 98 |
1476437 | 1476437 | 2021-07-02 | Warren | Iowa | 19181 | 5853 | 92 |
1464706 | 1464706 | 2021-06-28 | Union | Ohio | 39159 | 5853 | 49 |
1461461 | 1461461 | 2021-06-27 | Union | Ohio | 39159 | 5853 | 49 |
1458216 | 1458216 | 2021-06-26 | Union | Ohio | 39159 | 5853 | 49 |
1447946 | 1447946 | 2021-06-23 | Taney | Missouri | 29213 | 5853 | 99 |
1408774 | 1408774 | 2021-06-11 | Otter Tail | Minnesota | 27111 | 5853 | 84 |
1365041 | 1365041 | 2021-05-28 | Skagit | Washington | 53057 | 5853 | 73 |
1336700 | 1336700 | 2021-05-20 | Dearborn | Indiana | 18029 | 5853 | 81 |
1319664 | 1319664 | 2021-05-14 | Columbia | Wisconsin | 55021 | 5853 | 69 |
1297178 | 1297178 | 2021-05-08 | Mississippi | Arkansas | 5093 | 5853 | 107 |
1263631 | 1263631 | 2021-04-27 | Union | Pennsylvania | 42119 | 5853 | 86 |
1258814 | 1258814 | 2021-04-26 | Marshall | Indiana | 18099 | 5853 | 110 |
1160760 | 1160760 | 2021-03-27 | Crittenden | Arkansas | 5035 | 5853 | 95 |
1146976 | 1146976 | 2021-03-22 | Loudon | Tennessee | 47105 | 5853 | 68 |
1058515 | 1058515 | 2021-02-23 | Carson City | Nevada | 32510 | 5853 | 114 |
1055638 | 1055638 | 2021-02-22 | Scioto | Ohio | 39145 | 5853 | 104 |
1027326 | 1027326 | 2021-02-13 | Rockingham | Virginia | 51165 | 5853 | 76 |
915339 | 915339 | 2021-01-10 | Rice | Minnesota | 27131 | 5853 | 63 |
773380 | 773380 | 2020-11-27 | Clackamas | Oregon | 41005 | 5853 | 79 |
764766 | 764766 | 2020-11-25 | Mohave | Arizona | 4015 | 5853 | 253 |
754131 | 754131 | 2020-11-21 | Pickens | South Carolina | 45077 | 5853 | 81 |
744805 | 744805 | 2020-11-18 | Wichita | Texas | 48485 | 5853 | 93 |
710611 | 710611 | 2020-11-08 | Warren | Kentucky | 21227 | 5853 | 59 |
538058 | 538058 | 2020-09-16 | Bibb | Georgia | 13021 | 5853 | 154 |
494810 | 494810 | 2020-09-02 | Lexington | South Carolina | 45063 | 5853 | 139 |
473482 | 473482 | 2020-08-27 | Richmond | Georgia | 13245 | 5853 | 117 |
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);