ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 7690 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Iowa 7
- Wisconsin 5
- North Carolina 4
- Illinois 3
- Tennessee 3
- California 2
- Colorado 2
- Florida 2
- Indiana 2
- Missouri 2
- Texas 2
- Alabama 1
- Arkansas 1
- Georgia 1
- Kentucky 1
- Minnesota 1
- Mississippi 1
- New Mexico 1
- Puerto Rico 1
- South Dakota 1
- Virgin Islands 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333224 | 2333224 | 2022-03-22 | St. Croix | Virgin Islands | 78010 | 7690 | 46 |
2283328 | 2283328 | 2022-03-07 | Cibola | New Mexico | 35006 | 7690 | 178 |
2266799 | 2266799 | 2022-03-02 | Lafayette | Missouri | 29107 | 7690 | 123 |
2263548 | 2263548 | 2022-03-01 | Lafayette | Missouri | 29107 | 7690 | 123 |
2217333 | 2217333 | 2022-02-15 | Lee | Iowa | 19111 | 7690 | 128 |
2217525 | 2217525 | 2022-02-15 | Grayson | Kentucky | 21085 | 7690 | 117 |
2214082 | 2214082 | 2022-02-14 | Lee | Iowa | 19111 | 7690 | 128 |
2210830 | 2210830 | 2022-02-13 | Lee | Iowa | 19111 | 7690 | 128 |
2207577 | 2207577 | 2022-02-12 | Lee | Iowa | 19111 | 7690 | 128 |
2204324 | 2204324 | 2022-02-11 | Lee | Iowa | 19111 | 7690 | 128 |
2201071 | 2201071 | 2022-02-10 | Lee | Iowa | 19111 | 7690 | 128 |
2197817 | 2197817 | 2022-02-09 | Lee | Iowa | 19111 | 7690 | 128 |
2153886 | 2153886 | 2022-01-26 | Brookings | South Dakota | 46011 | 7690 | 41 |
2111512 | 2111512 | 2022-01-13 | Mayaguez | Puerto Rico | 72097 | 7690 | |
2095735 | 2095735 | 2022-01-08 | Waller | Texas | 48473 | 7690 | 88 |
2086674 | 2086674 | 2022-01-06 | Summit | Colorado | 8117 | 7690 | 12 |
2007651 | 2007651 | 2021-12-12 | Cocke | Tennessee | 47029 | 7690 | 122 |
2004400 | 2004400 | 2021-12-11 | Cocke | Tennessee | 47029 | 7690 | 122 |
2001149 | 2001149 | 2021-12-10 | Cocke | Tennessee | 47029 | 7690 | 122 |
1978724 | 1978724 | 2021-12-03 | Wilson | Texas | 48493 | 7690 | 142 |
1969982 | 1969982 | 2021-12-01 | Franklin | Illinois | 17055 | 7690 | 132 |
1940042 | 1940042 | 2021-11-21 | Oconto | Wisconsin | 55083 | 7690 | 77 |
1936792 | 1936792 | 2021-11-20 | Oconto | Wisconsin | 55083 | 7690 | 77 |
1933542 | 1933542 | 2021-11-19 | Oconto | Wisconsin | 55083 | 7690 | 77 |
1917565 | 1917565 | 2021-11-15 | San Benito | California | 6069 | 7690 | 77 |
1875025 | 1875025 | 2021-11-01 | Grant | Wisconsin | 55043 | 7690 | 117 |
1814803 | 1814803 | 2021-10-14 | Hancock | Mississippi | 28045 | 7690 | 126 |
1802312 | 1802312 | 2021-10-10 | Granville | North Carolina | 37077 | 7690 | 99 |
1799063 | 1799063 | 2021-10-09 | Granville | North Carolina | 37077 | 7690 | 99 |
1795814 | 1795814 | 2021-10-08 | Granville | North Carolina | 37077 | 7690 | 99 |
1492484 | 1492484 | 2021-07-07 | Williamson | Illinois | 17199 | 7690 | 148 |
1489266 | 1489266 | 2021-07-06 | Grant | Indiana | 18053 | 7690 | 187 |
1404124 | 1404124 | 2021-06-09 | Wood | Wisconsin | 55141 | 7690 | 100 |
1394847 | 1394847 | 2021-06-07 | Dougherty | Georgia | 13095 | 7690 | 308 |
1328222 | 1328222 | 2021-05-17 | Rockingham | North Carolina | 37157 | 7690 | 110 |
1213939 | 1213939 | 2021-04-12 | Clay | Minnesota | 27027 | 7690 | 89 |
1161338 | 1161338 | 2021-03-27 | Bartholomew | Indiana | 18005 | 7690 | 156 |
1157169 | 1157169 | 2021-03-25 | Roanoke | Virginia | 51161 | 7690 | 125 |
1063410 | 1063410 | 2021-02-25 | Pope | Arkansas | 5115 | 7690 | 101 |
1043647 | 1043647 | 2021-02-18 | Monongalia | West Virginia | 54061 | 7690 | 68 |
803655 | 803655 | 2020-12-07 | Morgan | Alabama | 1103 | 7690 | 58 |
735774 | 735774 | 2020-11-16 | Bay | Florida | 12005 | 7690 | 145 |
615688 | 615688 | 2020-10-10 | El Paso | Colorado | 8041 | 7690 | 184 |
596656 | 596656 | 2020-10-04 | St. Clair | Illinois | 17163 | 7690 | 196 |
466721 | 466721 | 2020-08-25 | Merced | California | 6047 | 7690 | 110 |
212559 | 212559 | 2020-06-06 | Broward | Florida | 12011 | 7690 | 334 |
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);