ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 8924 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Texas 6
- West Virginia 5
- Wisconsin 5
- Pennsylvania 4
- Georgia 2
- Illinois 2
- New York 2
- North Carolina 2
- North Dakota 2
- Missouri 1
- New Mexico 1
- Oregon 1
- Puerto Rico 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424156 | 2424156 | 2022-04-19 | Hill | Texas | 48217 | 8924 | 192 |
2349690 | 2349690 | 2022-03-27 | Marshall | West Virginia | 54051 | 8924 | 154 |
2346437 | 2346437 | 2022-03-26 | Marshall | West Virginia | 54051 | 8924 | 154 |
2343184 | 2343184 | 2022-03-25 | Marshall | West Virginia | 54051 | 8924 | 154 |
2209869 | 2209869 | 2022-02-12 | Randolph | West Virginia | 54083 | 8924 | 66 |
2154206 | 2154206 | 2022-01-26 | Medina | Texas | 48325 | 8924 | 177 |
2146422 | 2146422 | 2022-01-24 | Butler | Missouri | 29023 | 8924 | 139 |
2124544 | 2124544 | 2022-01-17 | Vega Baja | Puerto Rico | 72145 | 8924 | |
2118743 | 2118743 | 2022-01-15 | Fayette | West Virginia | 54019 | 8924 | 153 |
2078870 | 2078870 | 2022-01-03 | Polk | Oregon | 41053 | 8924 | 111 |
2058931 | 2058931 | 2021-12-28 | Curry | New Mexico | 35009 | 8924 | 135 |
2007157 | 2007157 | 2021-12-12 | Stark | North Dakota | 38089 | 8924 | 77 |
2007768 | 2007768 | 2021-12-12 | Chambers | Texas | 48071 | 8924 | 102 |
2004517 | 2004517 | 2021-12-11 | Chambers | Texas | 48071 | 8924 | 102 |
2001266 | 2001266 | 2021-12-10 | Chambers | Texas | 48071 | 8924 | 102 |
1992775 | 1992775 | 2021-12-08 | Ogle | Illinois | 17141 | 8924 | 108 |
1901075 | 1901075 | 2021-11-09 | Campbell | Wyoming | 56005 | 8924 | 111 |
1841226 | 1841226 | 2021-10-22 | Jefferson | New York | 36045 | 8924 | 76 |
1781352 | 1781352 | 2021-10-04 | Laurens | Georgia | 13175 | 8924 | 223 |
1620725 | 1620725 | 2021-08-15 | Clearfield | Pennsylvania | 42033 | 8924 | 160 |
1439793 | 1439793 | 2021-06-20 | Manitowoc | Wisconsin | 55071 | 8924 | 92 |
1436546 | 1436546 | 2021-06-19 | Manitowoc | Wisconsin | 55071 | 8924 | 92 |
1433299 | 1433299 | 2021-06-18 | Manitowoc | Wisconsin | 55071 | 8924 | 92 |
1430053 | 1430053 | 2021-06-17 | Manitowoc | Wisconsin | 55071 | 8924 | 92 |
1386525 | 1386525 | 2021-06-04 | Chautauqua | New York | 36013 | 8924 | 143 |
1337947 | 1337947 | 2021-05-20 | Moore | North Carolina | 37125 | 8924 | 188 |
1087909 | 1087909 | 2021-03-04 | Henderson | North Carolina | 37089 | 8924 | 149 |
932888 | 932888 | 2021-01-15 | Guadalupe | Texas | 48187 | 8924 | 123 |
893519 | 893519 | 2021-01-03 | Franklin | Pennsylvania | 42055 | 8924 | 236 |
856028 | 856028 | 2020-12-23 | Muscogee | Georgia | 13215 | 8924 | 204 |
848079 | 848079 | 2020-12-20 | Cumberland | Pennsylvania | 42041 | 8924 | 252 |
821850 | 821850 | 2020-12-12 | Grand Forks | North Dakota | 38035 | 8924 | 55 |
741882 | 741882 | 2020-11-17 | Marathon | Wisconsin | 55073 | 8924 | 111 |
666358 | 666358 | 2020-10-25 | Berks | Pennsylvania | 42011 | 8924 | 419 |
225239 | 225239 | 2020-06-10 | Lake | Illinois | 17097 | 8924 | 362 |
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);