ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 66 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 14
county 14
- Claiborne 9
- Bienville 3
- Evangeline 3
- Jefferson Davis 3
- Beauregard 2
- Sabine 2
- Allen 1
- Avoyelles 1
- LaSalle 1
- Red River 1
- Richland 1
- West Baton Rouge 1
- West Carroll 1
- Winn 1
state 1
- Louisiana · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
313510 | 313510 | 2020-07-08 | Red River | Louisiana | 22081 | 66 | 9 |
269348 | 269348 | 2020-06-24 | Sabine | Louisiana | 22085 | 66 | 1 |
266215 | 266215 | 2020-06-23 | Sabine | Louisiana | 22085 | 66 | 1 |
222624 | 222624 | 2020-06-09 | LaSalle | Louisiana | 22059 | 66 | 0 |
216423 | 216423 | 2020-06-07 | Claiborne | Louisiana | 22027 | 66 | 10 |
213336 | 213336 | 2020-06-06 | Claiborne | Louisiana | 22027 | 66 | 10 |
210251 | 210251 | 2020-06-05 | Claiborne | Louisiana | 22027 | 66 | 10 |
207170 | 207170 | 2020-06-04 | Claiborne | Louisiana | 22027 | 66 | 10 |
204089 | 204089 | 2020-06-03 | Claiborne | Louisiana | 22027 | 66 | 10 |
201012 | 201012 | 2020-06-02 | Claiborne | Louisiana | 22027 | 66 | 10 |
201061 | 201061 | 2020-06-02 | West Carroll | Louisiana | 22123 | 66 | 0 |
197940 | 197940 | 2020-06-01 | Claiborne | Louisiana | 22027 | 66 | 10 |
194861 | 194861 | 2020-05-31 | Beauregard | Louisiana | 22011 | 66 | 4 |
194869 | 194869 | 2020-05-31 | Claiborne | Louisiana | 22027 | 66 | 10 |
191793 | 191793 | 2020-05-30 | Beauregard | Louisiana | 22011 | 66 | 4 |
191801 | 191801 | 2020-05-30 | Claiborne | Louisiana | 22027 | 66 | 10 |
155309 | 155309 | 2020-05-18 | Evangeline | Louisiana | 22039 | 66 | 1 |
152295 | 152295 | 2020-05-17 | Evangeline | Louisiana | 22039 | 66 | 1 |
149284 | 149284 | 2020-05-16 | Evangeline | Louisiana | 22039 | 66 | 1 |
143324 | 143324 | 2020-05-14 | Winn | Louisiana | 22127 | 66 | 2 |
125339 | 125339 | 2020-05-08 | Jefferson Davis | Louisiana | 22053 | 66 | 6 |
122357 | 122357 | 2020-05-07 | Jefferson Davis | Louisiana | 22053 | 66 | 6 |
119386 | 119386 | 2020-05-06 | Jefferson Davis | Louisiana | 22053 | 66 | 6 |
104945 | 104945 | 2020-05-01 | Richland | Louisiana | 22083 | 66 | 0 |
76684 | 76684 | 2020-04-21 | Bienville | Louisiana | 22013 | 66 | 9 |
73904 | 73904 | 2020-04-20 | Bienville | Louisiana | 22013 | 66 | 9 |
71132 | 71132 | 2020-04-19 | Bienville | Louisiana | 22013 | 66 | 9 |
62879 | 62879 | 2020-04-16 | Avoyelles | Louisiana | 22009 | 66 | 3 |
49458 | 49458 | 2020-04-11 | West Baton Rouge | Louisiana | 22121 | 66 | 9 |
44149 | 44149 | 2020-04-09 | Allen | Louisiana | 22003 | 66 | 5 |
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);