ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 6021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467563 | 2467563 | 2022-05-03 | Blaine | Idaho | 16013 | 6021 | 30 |
2464308 | 2464308 | 2022-05-02 | Blaine | Idaho | 16013 | 6021 | 30 |
2442420 | 2442420 | 2022-04-25 | Newton | Mississippi | 28101 | 6021 | 98 |
2443311 | 2443311 | 2022-04-25 | Cidra | Puerto Rico | 72041 | 6021 | |
2439164 | 2439164 | 2022-04-24 | Newton | Mississippi | 28101 | 6021 | 98 |
2435908 | 2435908 | 2022-04-23 | Newton | Mississippi | 28101 | 6021 | 98 |
2432652 | 2432652 | 2022-04-22 | Newton | Mississippi | 28101 | 6021 | 98 |
2429396 | 2429396 | 2022-04-21 | Newton | Mississippi | 28101 | 6021 | 98 |
2426140 | 2426140 | 2022-04-20 | Newton | Mississippi | 28101 | 6021 | 98 |
2422884 | 2422884 | 2022-04-19 | Newton | Mississippi | 28101 | 6021 | 98 |
2419628 | 2419628 | 2022-04-18 | Newton | Mississippi | 28101 | 6021 | 98 |
2409587 | 2409587 | 2022-04-15 | Knox | Maine | 23013 | 6021 | 34 |
2377041 | 2377041 | 2022-04-05 | Waldo | Maine | 23027 | 6021 | 57 |
2357895 | 2357895 | 2022-03-30 | Nodaway | Missouri | 29147 | 6021 | 44 |
2306510 | 2306510 | 2022-03-14 | Crook | Oregon | 41013 | 6021 | 77 |
2259206 | 2259206 | 2022-02-28 | Harris | Georgia | 13145 | 6021 | 106 |
2238703 | 2238703 | 2022-02-21 | Gray | Texas | 48179 | 6021 | 122 |
2235143 | 2235143 | 2022-02-20 | Vega Alta | Puerto Rico | 72143 | 6021 | |
2235452 | 2235452 | 2022-02-20 | Gray | Texas | 48179 | 6021 | 122 |
2224548 | 2224548 | 2022-02-17 | Miller | Missouri | 29131 | 6021 | 113 |
2168956 | 2168956 | 2022-01-31 | Emmet | Michigan | 26047 | 6021 | 66 |
2170749 | 2170749 | 2022-01-31 | Winchester city | Virginia | 51840 | 6021 | 61 |
2167663 | 2167663 | 2022-01-30 | Waushara | Wisconsin | 55137 | 6021 | 76 |
2164408 | 2164408 | 2022-01-29 | Waushara | Wisconsin | 55137 | 6021 | 76 |
2161153 | 2161153 | 2022-01-28 | Waushara | Wisconsin | 55137 | 6021 | 76 |
2141941 | 2141941 | 2022-01-23 | Logan | Colorado | 8075 | 6021 | 101 |
2142066 | 2142066 | 2022-01-23 | Butts | Georgia | 13035 | 6021 | 128 |
2138686 | 2138686 | 2022-01-22 | Logan | Colorado | 8075 | 6021 | 101 |
2138811 | 2138811 | 2022-01-22 | Butts | Georgia | 13035 | 6021 | 128 |
2135430 | 2135430 | 2022-01-21 | Logan | Colorado | 8075 | 6021 | 101 |
2135555 | 2135555 | 2022-01-21 | Butts | Georgia | 13035 | 6021 | 128 |
2127206 | 2127206 | 2022-01-18 | Cibola | New Mexico | 35006 | 6021 | 163 |
2108271 | 2108271 | 2022-01-12 | Rio Grande | Puerto Rico | 72119 | 6021 | |
2089643 | 2089643 | 2022-01-07 | Dallas | Alabama | 1047 | 6021 | 212 |
2084701 | 2084701 | 2022-01-05 | Polk | Missouri | 29167 | 6021 | 83 |
2079353 | 2079353 | 2022-01-03 | Howard | Texas | 48227 | 6021 | 153 |
2061912 | 2061912 | 2021-12-29 | Laclede | Missouri | 29105 | 6021 | 153 |
2059715 | 2059715 | 2021-12-28 | Scott | Tennessee | 47151 | 6021 | 89 |
2053197 | 2053197 | 2021-12-26 | Marion | Tennessee | 47115 | 6021 | 107 |
2049947 | 2049947 | 2021-12-25 | Marion | Tennessee | 47115 | 6021 | 107 |
2046697 | 2046697 | 2021-12-24 | Marion | Tennessee | 47115 | 6021 | 107 |
2043447 | 2043447 | 2021-12-23 | Marion | Tennessee | 47115 | 6021 | 107 |
2033968 | 2033968 | 2021-12-20 | Upshur | Texas | 48459 | 6021 | 156 |
2030718 | 2030718 | 2021-12-19 | Upshur | Texas | 48459 | 6021 | 156 |
1767991 | 1767991 | 2021-09-30 | Boone | Arkansas | 5009 | 6021 | 114 |
1650580 | 1650580 | 2021-08-24 | Summit | Utah | 49043 | 6021 | 16 |
1612146 | 1612146 | 2021-08-13 | Humboldt | California | 6023 | 6021 | 58 |
1614231 | 1614231 | 2021-08-13 | Columbia | Pennsylvania | 42037 | 6021 | 136 |
1609339 | 1609339 | 2021-08-12 | Jackson | Illinois | 17077 | 6021 | 78 |
1595942 | 1595942 | 2021-08-08 | Tehama | California | 6103 | 6021 | 66 |
1586572 | 1586572 | 2021-08-05 | Clinton | Illinois | 17027 | 6021 | 102 |
1588838 | 1588838 | 2021-08-05 | Box Elder | Utah | 49003 | 6021 | 59 |
1557441 | 1557441 | 2021-07-27 | Dearborn | Indiana | 18029 | 6021 | 81 |
1540643 | 1540643 | 2021-07-22 | Mississippi | Arkansas | 5093 | 6021 | 110 |
1437317 | 1437317 | 2021-06-20 | Cass | Indiana | 18017 | 6021 | 112 |
1434070 | 1434070 | 2021-06-19 | Cass | Indiana | 18017 | 6021 | 112 |
1369669 | 1369669 | 2021-05-30 | St. Mary's | Maryland | 24037 | 6021 | 130 |
1271177 | 1271177 | 2021-04-30 | Crittenden | Arkansas | 5035 | 6021 | 96 |
1268023 | 1268023 | 2021-04-29 | San Benito | California | 6069 | 6021 | 63 |
1186855 | 1186855 | 2021-04-04 | Yuba | California | 6115 | 6021 | 43 |
1188504 | 1188504 | 2021-04-04 | Steuben | New York | 36101 | 6021 | 140 |
1183608 | 1183608 | 2021-04-03 | Yuba | California | 6115 | 6021 | 44 |
1180255 | 1180255 | 2021-04-02 | Greene | Arkansas | 5055 | 6021 | 75 |
1180361 | 1180361 | 2021-04-02 | Yuba | California | 6115 | 6021 | 44 |
1161354 | 1161354 | 2021-03-27 | Dubois | Indiana | 18037 | 6021 | 115 |
1141502 | 1141502 | 2021-03-21 | Jackson | Florida | 12063 | 6021 | 154 |
1135261 | 1135261 | 2021-03-19 | Boone | Illinois | 17007 | 6021 | 83 |
1104324 | 1104324 | 2021-03-09 | Scioto | Ohio | 39145 | 6021 | 90 |
1091297 | 1091297 | 2021-03-05 | Hancock | Ohio | 39063 | 6021 | 121 |
1074436 | 1074436 | 2021-02-28 | Lowndes | Mississippi | 28087 | 6021 | 137 |
1065864 | 1065864 | 2021-02-25 | Anderson | Texas | 48001 | 6021 | 107 |
1059374 | 1059374 | 2021-02-23 | Anderson | Texas | 48001 | 6021 | 104 |
1051380 | 1051380 | 2021-02-21 | Acadia | Louisiana | 22001 | 6021 | 181 |
1043771 | 1043771 | 2021-02-19 | Blount | Alabama | 1009 | 6021 | 125 |
960658 | 960658 | 2021-01-24 | Ionia | Michigan | 26067 | 6021 | 63 |
957412 | 957412 | 2021-01-23 | Ionia | Michigan | 26067 | 6021 | 63 |
826670 | 826670 | 2020-12-14 | Hernando | Florida | 12053 | 6021 | 244 |
826942 | 826942 | 2020-12-14 | DeKalb | Illinois | 17037 | 6021 | 60 |
687171 | 687171 | 2020-11-01 | Santa Rosa | Florida | 12113 | 6021 | 88 |
573701 | 573701 | 2020-09-27 | Cherokee | Georgia | 13057 | 6021 | 92 |
469942 | 469942 | 2020-08-26 | Kings | California | 6031 | 6021 | 72 |
68543 | 68543 | 2020-04-18 | Oakland | Michigan | 26125 | 6021 | 458 |
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);