ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 86 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
fips 15
county 15
- LaSalle 4
- Concordia 3
- St. Helena 3
- Caldwell 2
- Acadia 1
- Catahoula 1
- Grant 1
- Natchitoches 1
- Plaquemines 1
- Pointe Coupee 1
- Richland 1
- St. James 1
- St. Landry 1
- West Baton Rouge 1
- West Carroll 1
state 1
- Louisiana · 23 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
291348 | 291348 | 2020-07-01 | Grant | Louisiana | 22043 | 86 | 1 |
263073 | 263073 | 2020-06-22 | LaSalle | Louisiana | 22059 | 86 | 0 |
263091 | 263091 | 2020-06-22 | St. Helena | Louisiana | 22091 | 86 | 1 |
259944 | 259944 | 2020-06-21 | LaSalle | Louisiana | 22059 | 86 | 0 |
259962 | 259962 | 2020-06-21 | St. Helena | Louisiana | 22091 | 86 | 1 |
256818 | 256818 | 2020-06-20 | LaSalle | Louisiana | 22059 | 86 | 0 |
256836 | 256836 | 2020-06-20 | St. Helena | Louisiana | 22091 | 86 | 1 |
253698 | 253698 | 2020-06-19 | LaSalle | Louisiana | 22059 | 86 | 0 |
250566 | 250566 | 2020-06-18 | Caldwell | Louisiana | 22021 | 86 | 1 |
247454 | 247454 | 2020-06-17 | Caldwell | Louisiana | 22021 | 86 | 1 |
219564 | 219564 | 2020-06-08 | West Carroll | Louisiana | 22123 | 86 | 1 |
188738 | 188738 | 2020-05-29 | Concordia | Louisiana | 22029 | 86 | 5 |
185680 | 185680 | 2020-05-28 | Concordia | Louisiana | 22029 | 86 | 5 |
182625 | 182625 | 2020-05-27 | Concordia | Louisiana | 22029 | 86 | 5 |
137283 | 137283 | 2020-05-12 | Catahoula | Louisiana | 22025 | 86 | 3 |
119401 | 119401 | 2020-05-06 | Richland | Louisiana | 22083 | 86 | 1 |
104938 | 104938 | 2020-05-01 | Natchitoches | Louisiana | 22069 | 86 | 4 |
82298 | 82298 | 2020-04-23 | Pointe Coupee | Louisiana | 22077 | 86 | 11 |
68424 | 68424 | 2020-04-18 | West Baton Rouge | Louisiana | 22121 | 86 | 10 |
41572 | 41572 | 2020-04-08 | Acadia | Louisiana | 22001 | 86 | 2 |
41620 | 41620 | 2020-04-08 | St. Landry | Louisiana | 22097 | 86 | 4 |
31666 | 31666 | 2020-04-04 | Plaquemines | Louisiana | 22075 | 86 | 4 |
24729 | 24729 | 2020-04-01 | St. James | Louisiana | 22093 | 86 | 4 |
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);