ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 8058 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Florida 7
- Ohio 5
- Illinois 4
- New York 4
- Arkansas 3
- Tennessee 3
- Montana 2
- Virginia 2
- West Virginia 2
- Alabama 1
- Colorado 1
- Massachusetts 1
- Missouri 1
- North Carolina 1
- Puerto Rico 1
- South Carolina 1
- South Dakota 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472626 | 2472626 | 2022-05-04 | Gurabo | Puerto Rico | 72063 | 8058 | |
2452584 | 2452584 | 2022-04-28 | Delaware | New York | 36025 | 8058 | 72 |
2263547 | 2263547 | 2022-03-01 | Laclede | Missouri | 29105 | 8058 | 167 |
2261213 | 2261213 | 2022-02-28 | Brookings | South Dakota | 46011 | 8058 | 50 |
2164547 | 2164547 | 2022-01-30 | Baxter | Arkansas | 5005 | 8058 | 217 |
2161292 | 2161292 | 2022-01-29 | Baxter | Arkansas | 5005 | 8058 | 217 |
2158036 | 2158036 | 2022-01-28 | Baxter | Arkansas | 5005 | 8058 | 217 |
2154542 | 2154542 | 2022-01-26 | Logan | West Virginia | 54045 | 8058 | 156 |
2150047 | 2150047 | 2022-01-25 | Orleans | New York | 36073 | 8058 | 107 |
2150143 | 2150143 | 2022-01-25 | Person | North Carolina | 37145 | 8058 | 96 |
2089479 | 2089479 | 2022-01-06 | Fayette | West Virginia | 54019 | 8058 | 152 |
2066063 | 2066063 | 2021-12-30 | Newberry | South Carolina | 45071 | 8058 | 153 |
2041210 | 2041210 | 2021-12-23 | Hendry | Florida | 12051 | 8058 | 143 |
2042941 | 2042941 | 2021-12-23 | Crawford | Ohio | 39033 | 8058 | 158 |
2037960 | 2037960 | 2021-12-22 | Hendry | Florida | 12051 | 8058 | 143 |
2034710 | 2034710 | 2021-12-21 | Hendry | Florida | 12051 | 8058 | 143 |
2031460 | 2031460 | 2021-12-20 | Hendry | Florida | 12051 | 8058 | 143 |
2028209 | 2028209 | 2021-12-19 | Hendry | Florida | 12051 | 8058 | 143 |
2024958 | 2024958 | 2021-12-18 | Hendry | Florida | 12051 | 8058 | 143 |
2021707 | 2021707 | 2021-12-17 | Hendry | Florida | 12051 | 8058 | 143 |
2003754 | 2003754 | 2021-12-11 | Tompkins | New York | 36109 | 8058 | 65 |
1989501 | 1989501 | 2021-12-07 | Knox | Illinois | 17095 | 8058 | 209 |
1927019 | 1927019 | 2021-11-17 | Grant | Wisconsin | 55043 | 8058 | 119 |
1916649 | 1916649 | 2021-11-14 | Franklin | Tennessee | 47051 | 8058 | 102 |
1913399 | 1913399 | 2021-11-13 | Franklin | Tennessee | 47051 | 8058 | 102 |
1910149 | 1910149 | 2021-11-12 | Franklin | Tennessee | 47051 | 8058 | 102 |
1872455 | 1872455 | 2021-11-01 | Boone | Illinois | 17007 | 8058 | 96 |
1803881 | 1803881 | 2021-10-11 | Eagle | Colorado | 8037 | 8058 | 31 |
1744538 | 1744538 | 2021-09-22 | Caldwell | Texas | 48055 | 8058 | 131 |
1694796 | 1694796 | 2021-09-07 | Lewis and Clark | Montana | 30049 | 8058 | 96 |
1633314 | 1633314 | 2021-08-19 | Oswego | New York | 36075 | 8058 | 94 |
1448422 | 1448422 | 2021-06-23 | Erie | Ohio | 39043 | 8058 | 165 |
1445177 | 1445177 | 2021-06-22 | Erie | Ohio | 39043 | 8058 | 165 |
1368171 | 1368171 | 2021-05-29 | Frederick | Virginia | 51069 | 8058 | 102 |
1209410 | 1209410 | 2021-04-11 | Talladega | Alabama | 1121 | 8058 | 171 |
1145632 | 1145632 | 2021-03-22 | Hampshire | Massachusetts | 25015 | 8058 | 278 |
1135258 | 1135258 | 2021-03-19 | Adams | Illinois | 17001 | 8058 | 144 |
1132011 | 1132011 | 2021-03-18 | Adams | Illinois | 17001 | 8058 | 144 |
1042166 | 1042166 | 2021-02-18 | Missoula | Montana | 30063 | 8058 | 83 |
991633 | 991633 | 2021-02-02 | Stafford | Virginia | 51179 | 8058 | 50 |
844623 | 844623 | 2020-12-19 | Clark | Ohio | 39023 | 8058 | 172 |
643485 | 643485 | 2020-10-18 | Lucas | Ohio | 39095 | 8058 | 370 |
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);