ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 8995 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Minnesota 4
- Missouri 4
- North Carolina 4
- Pennsylvania 4
- Texas 4
- California 2
- Kentucky 2
- Louisiana 2
- Wisconsin 2
- Arkansas 1
- New Jersey 1
- New Mexico 1
- Ohio 1
- Puerto Rico 1
- Utah 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445355 | 2445355 | 2022-04-26 | Iberville | Louisiana | 22047 | 8995 | 153 |
2442099 | 2442099 | 2022-04-25 | Iberville | Louisiana | 22047 | 8995 | 153 |
2371636 | 2371636 | 2022-04-03 | Jefferson | Pennsylvania | 42065 | 8995 | 229 |
2368383 | 2368383 | 2022-04-02 | Jefferson | Pennsylvania | 42065 | 8995 | 229 |
2365130 | 2365130 | 2022-04-01 | Jefferson | Pennsylvania | 42065 | 8995 | 229 |
2290298 | 2290298 | 2022-03-09 | Clinton | Pennsylvania | 42035 | 8995 | 124 |
2192372 | 2192372 | 2022-02-07 | Bladen | North Carolina | 37017 | 8995 | 110 |
2131050 | 2131050 | 2022-01-19 | Vega Baja | Puerto Rico | 72145 | 8995 | |
2123494 | 2123494 | 2022-01-17 | Itasca | Minnesota | 27061 | 8995 | 123 |
2120242 | 2120242 | 2022-01-16 | Itasca | Minnesota | 27061 | 8995 | 123 |
2116990 | 2116990 | 2022-01-15 | Itasca | Minnesota | 27061 | 8995 | 123 |
2113739 | 2113739 | 2022-01-14 | Itasca | Minnesota | 27061 | 8995 | 123 |
2053273 | 2053273 | 2021-12-26 | Chambers | Texas | 48071 | 8995 | 102 |
2050023 | 2050023 | 2021-12-25 | Chambers | Texas | 48071 | 8995 | 102 |
2046773 | 2046773 | 2021-12-24 | Chambers | Texas | 48071 | 8995 | 102 |
2041072 | 2041072 | 2021-12-23 | Mendocino | California | 6045 | 8995 | 105 |
2043523 | 2043523 | 2021-12-23 | Chambers | Texas | 48071 | 8995 | 102 |
2037292 | 2037292 | 2021-12-21 | Albemarle | Virginia | 51003 | 8995 | 114 |
2018062 | 2018062 | 2021-12-15 | Polk | Wisconsin | 55095 | 8995 | 104 |
1970408 | 1970408 | 2021-12-01 | Hopkins | Kentucky | 21107 | 8995 | 214 |
1897723 | 1897723 | 2021-11-08 | Mercer | West Virginia | 54055 | 8995 | 180 |
1884477 | 1884477 | 2021-11-04 | Box Elder | Utah | 49003 | 8995 | 88 |
1706290 | 1706290 | 2021-09-11 | Greene | Arkansas | 5055 | 8995 | 99 |
1402867 | 1402867 | 2021-06-09 | Moore | North Carolina | 37125 | 8995 | 192 |
1386748 | 1386748 | 2021-06-04 | Columbiana | Ohio | 39029 | 8995 | 229 |
1324511 | 1324511 | 2021-05-16 | Christian | Missouri | 29043 | 8995 | 91 |
1321265 | 1321265 | 2021-05-15 | Christian | Missouri | 29043 | 8995 | 91 |
1318019 | 1318019 | 2021-05-14 | Christian | Missouri | 29043 | 8995 | 91 |
1214411 | 1214411 | 2021-04-12 | Warren | New Jersey | 34041 | 8995 | 229 |
1201422 | 1201422 | 2021-04-08 | Chaves | New Mexico | 35005 | 8995 | 166 |
1106486 | 1106486 | 2021-03-10 | Hardin | Kentucky | 21093 | 8995 | 101 |
1097648 | 1097648 | 2021-03-07 | Henderson | North Carolina | 37089 | 8995 | 149 |
1094400 | 1094400 | 2021-03-06 | Henderson | North Carolina | 37089 | 8995 | 149 |
849248 | 849248 | 2020-12-21 | Madera | California | 6039 | 8995 | 111 |
670555 | 670555 | 2020-10-26 | Winnebago | Wisconsin | 55139 | 8995 | 57 |
477752 | 477752 | 2020-08-28 | Kansas City | Missouri | 8995 | 96 |
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);