ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where cases = 6695 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 |
---|---|---|---|---|---|---|---|
2499450 | 2499450 | 2022-05-12 | Mason | West Virginia | 54053 | 6695 | 93 |
2379680 | 2379680 | 2022-04-06 | Latah | Idaho | 16057 | 6695 | 48 |
2324954 | 2324954 | 2022-03-20 | Richland | Louisiana | 22083 | 6695 | 95 |
2325087 | 2325087 | 2022-03-20 | Mason | Michigan | 26105 | 6695 | 89 |
2321700 | 2321700 | 2022-03-19 | Richland | Louisiana | 22083 | 6695 | 95 |
2321833 | 2321833 | 2022-03-19 | Mason | Michigan | 26105 | 6695 | 89 |
2318446 | 2318446 | 2022-03-18 | Richland | Louisiana | 22083 | 6695 | 95 |
2318579 | 2318579 | 2022-03-18 | Mason | Michigan | 26105 | 6695 | 89 |
2320026 | 2320026 | 2022-03-18 | Howard | Texas | 48227 | 6695 | 182 |
2320029 | 2320029 | 2022-03-18 | Hutchinson | Texas | 48233 | 6695 | 135 |
2237325 | 2237325 | 2022-02-21 | Cass | Minnesota | 27021 | 6695 | 75 |
2234074 | 2234074 | 2022-02-20 | Cass | Minnesota | 27021 | 6695 | 75 |
2230823 | 2230823 | 2022-02-19 | Cass | Minnesota | 27021 | 6695 | 75 |
2227572 | 2227572 | 2022-02-18 | Cass | Minnesota | 27021 | 6695 | 75 |
2195366 | 2195366 | 2022-02-08 | Ravalli | Montana | 30081 | 6695 | 134 |
2168910 | 2168910 | 2022-01-31 | Queen Anne's | Maryland | 24035 | 6695 | 105 |
2157408 | 2157408 | 2022-01-27 | Hopkins | Texas | 48223 | 6695 | 159 |
2129184 | 2129184 | 2022-01-19 | Wayne | Georgia | 13305 | 6695 | 182 |
1994979 | 1994979 | 2021-12-08 | Wood | Texas | 48499 | 6695 | 232 |
1976008 | 1976008 | 2021-12-03 | Miller | Arkansas | 5091 | 6695 | 149 |
1970815 | 1970815 | 2021-12-01 | Marshall | Mississippi | 28093 | 6695 | 142 |
1924999 | 1924999 | 2021-11-17 | Natchitoches | Louisiana | 22069 | 6695 | 135 |
1921776 | 1921776 | 2021-11-16 | Webster | Louisiana | 22119 | 6695 | 149 |
1906940 | 1906940 | 2021-11-11 | Obion | Tennessee | 47131 | 6695 | 111 |
1903691 | 1903691 | 2021-11-10 | Obion | Tennessee | 47131 | 6695 | 111 |
1832878 | 1832878 | 2021-10-20 | Covington | Alabama | 1039 | 6695 | 184 |
1803579 | 1803579 | 2021-10-10 | Shawano | Wisconsin | 55115 | 6695 | 90 |
1800330 | 1800330 | 2021-10-09 | Shawano | Wisconsin | 55115 | 6695 | 90 |
1797081 | 1797081 | 2021-10-08 | Shawano | Wisconsin | 55115 | 6695 | 90 |
1765367 | 1765367 | 2021-09-29 | Jackson | Indiana | 18071 | 6695 | 88 |
1634822 | 1634822 | 2021-08-20 | Hot Spring | Arkansas | 5059 | 6695 | 93 |
1557913 | 1557913 | 2021-07-27 | Kennebec | Maine | 23011 | 6695 | 82 |
1538598 | 1538598 | 2021-07-21 | Kandiyohi | Minnesota | 27067 | 6695 | 85 |
1535351 | 1535351 | 2021-07-20 | Kandiyohi | Minnesota | 27067 | 6695 | 85 |
1501211 | 1501211 | 2021-07-09 | Bedford | Virginia | 51019 | 6695 | 109 |
1497965 | 1497965 | 2021-07-08 | Bedford | Virginia | 51019 | 6695 | 109 |
1494718 | 1494718 | 2021-07-07 | Bedford | Virginia | 51019 | 6695 | 109 |
1374228 | 1374228 | 2021-05-31 | Carter | Tennessee | 47019 | 6695 | 158 |
1370983 | 1370983 | 2021-05-30 | Carter | Tennessee | 47019 | 6695 | 158 |
1367737 | 1367737 | 2021-05-29 | Carter | Tennessee | 47019 | 6695 | 158 |
1364491 | 1364491 | 2021-05-28 | Carter | Tennessee | 47019 | 6695 | 158 |
1361245 | 1361245 | 2021-05-27 | Carter | Tennessee | 47019 | 6695 | 158 |
1357999 | 1357999 | 2021-05-26 | Carter | Tennessee | 47019 | 6695 | 158 |
1305602 | 1305602 | 2021-05-10 | Geauga | Ohio | 39055 | 6695 | 148 |
1240217 | 1240217 | 2021-04-20 | Lewis and Clark | Montana | 30049 | 6695 | 86 |
1222707 | 1222707 | 2021-04-15 | Monroe | Florida | 12087 | 6695 | 50 |
1172919 | 1172919 | 2021-03-30 | Coffee | Tennessee | 47031 | 6695 | 120 |
1151906 | 1151906 | 2021-03-24 | Bullitt | Kentucky | 21029 | 6695 | 69 |
1148659 | 1148659 | 2021-03-23 | Bullitt | Kentucky | 21029 | 6695 | 69 |
927262 | 927262 | 2021-01-14 | Columbia | Florida | 12023 | 6695 | 129 |
787386 | 787386 | 2020-12-02 | Calhoun | Alabama | 1015 | 6695 | 121 |
647572 | 647572 | 2020-10-19 | Chesterfield | Virginia | 51041 | 6695 | 99 |
539200 | 539200 | 2020-09-16 | Jackson | Missouri | 29095 | 6695 | 89 |
512193 | 512193 | 2020-09-08 | Clayton | Georgia | 13063 | 6695 | 146 |
406362 | 406362 | 2020-08-06 | Calcasieu | Louisiana | 22019 | 6695 | 130 |
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);