ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 6599 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 5
- Indiana 4
- Nevada 4
- Illinois 3
- Kentucky 3
- California 2
- Louisiana 2
- Ohio 2
- West Virginia 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Colorado 1
- Florida 1
- Georgia 1
- Idaho 1
- Maine 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- Oklahoma 1
- Tennessee 1
- Vermont 1
- Virginia 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501344 | 2501344 | 2022-05-13 | Churchill | Nevada | 32001 | 6599 | 110 |
2498086 | 2498086 | 2022-05-12 | Churchill | Nevada | 32001 | 6599 | 110 |
2499243 | 2499243 | 2022-05-12 | Orleans | Vermont | 50019 | 6599 | 38 |
2494828 | 2494828 | 2022-05-11 | Churchill | Nevada | 32001 | 6599 | 110 |
2307222 | 2307222 | 2022-03-14 | Carroll | Virginia | 51035 | 6599 | 139 |
2271242 | 2271242 | 2022-03-03 | Hutchinson | Texas | 48233 | 6599 | 133 |
2263083 | 2263083 | 2022-03-01 | Montgomery | Kentucky | 21173 | 6599 | 87 |
2223569 | 2223569 | 2022-02-17 | Latah | Idaho | 16057 | 6599 | 48 |
2219636 | 2219636 | 2022-02-15 | Wyoming | West Virginia | 54109 | 6599 | 90 |
2195488 | 2195488 | 2022-02-08 | Nye | Nevada | 32023 | 6599 | 217 |
2178625 | 2178625 | 2022-02-03 | Union | Louisiana | 22111 | 6599 | 119 |
2163989 | 2163989 | 2022-01-29 | Palo Pinto | Texas | 48363 | 6599 | 138 |
2152044 | 2152044 | 2022-01-26 | Fayette | Illinois | 17051 | 6599 | 91 |
2009455 | 2009455 | 2021-12-13 | Perry | Kentucky | 21193 | 6599 | 127 |
1992757 | 1992757 | 2021-12-08 | Livingston | Illinois | 17105 | 6599 | 119 |
1857605 | 1857605 | 2021-10-27 | Watauga | North Carolina | 37189 | 6599 | 37 |
1758156 | 1758156 | 2021-09-27 | Escambia | Alabama | 1053 | 6599 | 121 |
1748311 | 1748311 | 2021-09-23 | Grant | Wisconsin | 55043 | 6599 | 103 |
1736936 | 1736936 | 2021-09-20 | Johnson | Missouri | 29101 | 6599 | 67 |
1716101 | 1716101 | 2021-09-14 | Mendocino | California | 6045 | 6599 | 69 |
1697531 | 1697531 | 2021-09-08 | Avoyelles | Louisiana | 22009 | 6599 | 153 |
1651665 | 1651665 | 2021-08-25 | Henry | Indiana | 18065 | 6599 | 119 |
1586221 | 1586221 | 2021-08-05 | Eagle | Colorado | 8037 | 6599 | 23 |
1543872 | 1543872 | 2021-07-23 | Greene | Arkansas | 5055 | 6599 | 80 |
1529630 | 1529630 | 2021-07-18 | Scioto | Ohio | 39145 | 6599 | 108 |
1473404 | 1473404 | 2021-07-01 | Pulaski | Kentucky | 21199 | 6599 | 118 |
1450778 | 1450778 | 2021-06-24 | Kennebec | Maine | 23011 | 6599 | 74 |
1406732 | 1406732 | 2021-06-10 | McMinn | Tennessee | 47107 | 6599 | 101 |
1387407 | 1387407 | 2021-06-04 | Hood | Texas | 48221 | 6599 | 131 |
1310765 | 1310765 | 2021-05-12 | Morgan | Indiana | 18109 | 6599 | 144 |
1304858 | 1304858 | 2021-05-10 | Crow Wing | Minnesota | 27035 | 6599 | 88 |
1289175 | 1289175 | 2021-05-05 | Steuben | New York | 36101 | 6599 | 143 |
1148049 | 1148049 | 2021-03-23 | Bulloch | Georgia | 13031 | 6599 | 103 |
1088601 | 1088601 | 2021-03-04 | Bowie | Texas | 48037 | 6599 | 185 |
992567 | 992567 | 2021-02-03 | Grant | Indiana | 18053 | 6599 | 128 |
935628 | 935628 | 2021-01-16 | Pottawatomie | Oklahoma | 40125 | 6599 | 44 |
929072 | 929072 | 2021-01-14 | Wayne | Ohio | 39169 | 6599 | 162 |
891921 | 891921 | 2021-01-03 | Vermilion | Illinois | 17183 | 6599 | 91 |
831407 | 831407 | 2020-12-15 | Santa Fe | New Mexico | 35049 | 6599 | 53 |
813207 | 813207 | 2020-12-09 | Kanawha | West Virginia | 54039 | 6599 | 160 |
683930 | 683930 | 2020-10-31 | St. Johns | Florida | 12109 | 6599 | 84 |
593432 | 593432 | 2020-10-03 | Allen | Indiana | 18003 | 6599 | 219 |
446983 | 446983 | 2020-08-18 | Snohomish | Washington | 53061 | 6599 | 217 |
306221 | 306221 | 2020-07-06 | Fresno | California | 6019 | 6599 | 78 |
244964 | 244964 | 2020-06-16 | Morris | New Jersey | 34027 | 6599 | 640 |
227318 | 227318 | 2020-06-10 | Tarrant | Texas | 48439 | 6599 | 189 |
142299 | 142299 | 2020-05-14 | Maricopa | Arizona | 4013 | 6599 | 292 |
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);