ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 9152 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Florida 7
- Iowa 7
- Kansas 3
- Minnesota 3
- New York 3
- Ohio 3
- Alabama 2
- Illinois 2
- Indiana 2
- Massachusetts 2
- Arkansas 1
- California 1
- Georgia 1
- Missouri 1
- Montana 1
- North Carolina 1
- Oklahoma 1
- South Carolina 1
- Virginia 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467825 | 2467825 | 2022-05-03 | Des Moines | Iowa | 19057 | 9152 | 138 |
2464570 | 2464570 | 2022-05-02 | Des Moines | Iowa | 19057 | 9152 | 138 |
2461314 | 2461314 | 2022-05-01 | Des Moines | Iowa | 19057 | 9152 | 138 |
2458058 | 2458058 | 2022-04-30 | Des Moines | Iowa | 19057 | 9152 | 138 |
2454802 | 2454802 | 2022-04-29 | Des Moines | Iowa | 19057 | 9152 | 138 |
2451546 | 2451546 | 2022-04-28 | Des Moines | Iowa | 19057 | 9152 | 138 |
2448290 | 2448290 | 2022-04-27 | Des Moines | Iowa | 19057 | 9152 | 138 |
2273607 | 2273607 | 2022-03-04 | Chenango | New York | 36017 | 9152 | 117 |
2270354 | 2270354 | 2022-03-03 | Chenango | New York | 36017 | 9152 | 117 |
2242351 | 2242351 | 2022-02-22 | Greenbrier | West Virginia | 54025 | 9152 | 138 |
2217237 | 2217237 | 2022-02-15 | Miami | Indiana | 18103 | 9152 | 149 |
2122560 | 2122560 | 2022-01-17 | Coffee | Georgia | 13069 | 9152 | 249 |
2101829 | 2101829 | 2022-01-10 | Newberry | South Carolina | 45071 | 9152 | 154 |
2054502 | 2054502 | 2021-12-27 | Jackson | Illinois | 17077 | 9152 | 112 |
2055942 | 2055942 | 2021-12-27 | Darke | Ohio | 39037 | 9152 | 185 |
2032969 | 2032969 | 2021-12-20 | Clinton | New York | 36019 | 9152 | 53 |
1927053 | 1927053 | 2021-11-17 | Sauk | Wisconsin | 55111 | 9152 | 74 |
1867441 | 1867441 | 2021-10-30 | Geauga | Ohio | 39055 | 9152 | 159 |
1836491 | 1836491 | 2021-10-21 | Suwannee | Florida | 12121 | 9152 | 163 |
1833242 | 1833242 | 2021-10-20 | Suwannee | Florida | 12121 | 9152 | 163 |
1829993 | 1829993 | 2021-10-19 | Suwannee | Florida | 12121 | 9152 | 163 |
1826744 | 1826744 | 2021-10-18 | Suwannee | Florida | 12121 | 9152 | 163 |
1823495 | 1823495 | 2021-10-17 | Suwannee | Florida | 12121 | 9152 | 166 |
1820246 | 1820246 | 2021-10-16 | Suwannee | Florida | 12121 | 9152 | 166 |
1816997 | 1816997 | 2021-10-15 | Suwannee | Florida | 12121 | 9152 | 166 |
1733479 | 1733479 | 2021-09-19 | Clay | Minnesota | 27027 | 9152 | 95 |
1730229 | 1730229 | 2021-09-18 | Clay | Minnesota | 27027 | 9152 | 95 |
1726979 | 1726979 | 2021-09-17 | Clay | Minnesota | 27027 | 9152 | 95 |
1610671 | 1610671 | 2021-08-12 | Orange | North Carolina | 37135 | 9152 | 101 |
1551825 | 1551825 | 2021-07-25 | St. Francois | Missouri | 29187 | 9152 | 117 |
1532819 | 1532819 | 2021-07-19 | Columbiana | Ohio | 39029 | 9152 | 236 |
1410413 | 1410413 | 2021-06-11 | Portsmouth city | Virginia | 51740 | 9152 | 201 |
1405382 | 1405382 | 2021-06-10 | Hampshire | Massachusetts | 25015 | 9152 | 298 |
1402136 | 1402136 | 2021-06-09 | Hampshire | Massachusetts | 25015 | 9152 | 298 |
1344121 | 1344121 | 2021-05-22 | Missoula | Montana | 30063 | 9152 | 94 |
1255732 | 1255732 | 2021-04-25 | Douglas | Kansas | 20045 | 9152 | 87 |
1252485 | 1252485 | 2021-04-24 | Douglas | Kansas | 20045 | 9152 | 87 |
1249238 | 1249238 | 2021-04-23 | Douglas | Kansas | 20045 | 9152 | 87 |
1110883 | 1110883 | 2021-03-11 | Muskogee | Oklahoma | 40101 | 9152 | 113 |
1024335 | 1024335 | 2021-02-13 | Limestone | Alabama | 1083 | 9152 | 125 |
1014694 | 1014694 | 2021-02-10 | Garland | Arkansas | 5051 | 9152 | 218 |
875788 | 875788 | 2020-12-29 | Vigo | Indiana | 18167 | 9152 | 150 |
677750 | 677750 | 2020-10-29 | St. Clair | Illinois | 17163 | 9152 | 223 |
612234 | 612234 | 2020-10-09 | Montgomery | Alabama | 1101 | 9152 | 188 |
473196 | 473196 | 2020-08-27 | San Francisco | California | 6075 | 9152 | 82 |
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);