ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 12955 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Louisiana 4
- Tennessee 3
- Georgia 2
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Indiana 1
- Minnesota 1
- Missouri 1
- North Carolina 1
- South Carolina 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448637 | 2448637 | 2022-04-27 | St. Martin | Louisiana | 22099 | 12955 | 187 |
2445391 | 2445391 | 2022-04-26 | Washington | Louisiana | 22117 | 12955 | 248 |
2442135 | 2442135 | 2022-04-25 | Washington | Louisiana | 22117 | 12955 | 248 |
2223744 | 2223744 | 2022-02-17 | Noble | Indiana | 18113 | 12955 | 152 |
2215684 | 2215684 | 2022-02-14 | Newberry | South Carolina | 45071 | 12955 | 168 |
2115813 | 2115813 | 2022-01-15 | Unknown | Arkansas | 12955 | 0 | |
2038954 | 2038954 | 2021-12-22 | Clay | Minnesota | 27027 | 12955 | 111 |
1741982 | 1741982 | 2021-09-22 | Apache | Arizona | 4001 | 12955 | 464 |
1725875 | 1725875 | 2021-09-17 | Sutter | California | 6101 | 12955 | 152 |
1697951 | 1697951 | 2021-09-08 | Jasper | Missouri | 29097 | 12955 | 171 |
1625436 | 1625436 | 2021-08-17 | Newton | Georgia | 13217 | 12955 | 267 |
1585378 | 1585378 | 2021-08-04 | Comal | Texas | 48091 | 12955 | 341 |
1200758 | 1200758 | 2021-04-08 | Livingston | Louisiana | 22063 | 12955 | 202 |
1121041 | 1121041 | 2021-03-14 | Washington | Tennessee | 47179 | 12955 | 234 |
1117794 | 1117794 | 2021-03-13 | Washington | Tennessee | 47179 | 12955 | 234 |
1114547 | 1114547 | 2021-03-12 | Washington | Tennessee | 47179 | 12955 | 234 |
914395 | 914395 | 2021-01-10 | Forsyth | Georgia | 13117 | 12955 | 84 |
912679 | 912679 | 2021-01-09 | Pitt | North Carolina | 37147 | 12955 | 69 |
872053 | 872053 | 2020-12-28 | Pueblo | Colorado | 8101 | 12955 | 297 |
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);