ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 105 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths
county 11
- Concordia 5
- Caldwell 2
- Claiborne 2
- Acadia 1
- Assumption 1
- East Baton Rouge 1
- East Feliciana 1
- Lafourche 1
- Madison 1
- St. Mary 1
- West Carroll 1
state 1
- Louisiana · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294491 | 294491 | 2020-07-02 | Caldwell | Louisiana | 22021 | 105 | 1 |
291337 | 291337 | 2020-07-01 | Caldwell | Louisiana | 22021 | 105 | 1 |
272456 | 272456 | 2020-06-25 | Concordia | Louisiana | 22029 | 105 | 5 |
269320 | 269320 | 2020-06-24 | Concordia | Louisiana | 22029 | 105 | 5 |
266187 | 266187 | 2020-06-23 | Concordia | Louisiana | 22029 | 105 | 5 |
256804 | 256804 | 2020-06-20 | Claiborne | Louisiana | 22027 | 105 | 10 |
256853 | 256853 | 2020-06-20 | West Carroll | Louisiana | 22123 | 105 | 3 |
253684 | 253684 | 2020-06-19 | Claiborne | Louisiana | 22027 | 105 | 10 |
238125 | 238125 | 2020-06-14 | Concordia | Louisiana | 22029 | 105 | 5 |
235018 | 235018 | 2020-06-13 | Concordia | Louisiana | 22029 | 105 | 5 |
201031 | 201031 | 2020-06-02 | Madison | Louisiana | 22065 | 105 | 2 |
85082 | 85082 | 2020-04-24 | East Feliciana | Louisiana | 22037 | 105 | 10 |
60154 | 60154 | 2020-04-15 | Acadia | Louisiana | 22001 | 105 | 5 |
49447 | 49447 | 2020-04-11 | St. Mary | Louisiana | 22101 | 105 | 2 |
46759 | 46759 | 2020-04-10 | Assumption | Louisiana | 22007 | 105 | 1 |
24712 | 24712 | 2020-04-01 | Lafourche | Louisiana | 22057 | 105 | 4 |
12962 | 12962 | 2020-03-26 | East Baton Rouge | Louisiana | 22033 | 105 | 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);