ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where deaths = 195 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Vermilion 31
- Acadia 24
- Avoyelles 6
- Lafourche 4
- St. Mary 4
- Livingston 1
- Rapides 1
- St. Tammany 1
state 1
- Louisiana · 72 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2220858 | 2220858 | 2022-02-16 | Avoyelles | Louisiana | 22009 | 11483 | 195 |
2217607 | 2217607 | 2022-02-15 | Avoyelles | Louisiana | 22009 | 11468 | 195 |
2214356 | 2214356 | 2022-02-14 | Avoyelles | Louisiana | 22009 | 11458 | 195 |
2211104 | 2211104 | 2022-02-13 | Avoyelles | Louisiana | 22009 | 11428 | 195 |
2207851 | 2207851 | 2022-02-12 | Avoyelles | Louisiana | 22009 | 11428 | 195 |
2204598 | 2204598 | 2022-02-11 | Avoyelles | Louisiana | 22009 | 11428 | 195 |
2097304 | 2097304 | 2022-01-09 | Vermilion | Louisiana | 22113 | 11527 | 195 |
2094052 | 2094052 | 2022-01-08 | Vermilion | Louisiana | 22113 | 11527 | 195 |
2090800 | 2090800 | 2022-01-07 | Vermilion | Louisiana | 22113 | 11527 | 195 |
2087549 | 2087549 | 2022-01-06 | Vermilion | Louisiana | 22113 | 11452 | 195 |
2084297 | 2084297 | 2022-01-05 | Vermilion | Louisiana | 22113 | 11306 | 195 |
2081045 | 2081045 | 2022-01-04 | Vermilion | Louisiana | 22113 | 11173 | 195 |
2077793 | 2077793 | 2022-01-03 | Vermilion | Louisiana | 22113 | 11066 | 195 |
2074542 | 2074542 | 2022-01-02 | Vermilion | Louisiana | 22113 | 10869 | 195 |
2071291 | 2071291 | 2022-01-01 | Vermilion | Louisiana | 22113 | 10869 | 195 |
2068040 | 2068040 | 2021-12-31 | Vermilion | Louisiana | 22113 | 10869 | 195 |
2064789 | 2064789 | 2021-12-30 | Vermilion | Louisiana | 22113 | 10869 | 195 |
2061539 | 2061539 | 2021-12-29 | Vermilion | Louisiana | 22113 | 10773 | 195 |
2058290 | 2058290 | 2021-12-28 | Vermilion | Louisiana | 22113 | 10659 | 195 |
2055041 | 2055041 | 2021-12-27 | Vermilion | Louisiana | 22113 | 10630 | 195 |
2051791 | 2051791 | 2021-12-26 | Vermilion | Louisiana | 22113 | 10555 | 195 |
2048541 | 2048541 | 2021-12-25 | Vermilion | Louisiana | 22113 | 10555 | 195 |
2045291 | 2045291 | 2021-12-24 | Vermilion | Louisiana | 22113 | 10555 | 195 |
2042042 | 2042042 | 2021-12-23 | Vermilion | Louisiana | 22113 | 10555 | 195 |
2038792 | 2038792 | 2021-12-22 | Vermilion | Louisiana | 22113 | 10545 | 195 |
2035542 | 2035542 | 2021-12-21 | Vermilion | Louisiana | 22113 | 10507 | 195 |
2032292 | 2032292 | 2021-12-20 | Vermilion | Louisiana | 22113 | 10494 | 195 |
2029041 | 2029041 | 2021-12-19 | Vermilion | Louisiana | 22113 | 10472 | 195 |
2025790 | 2025790 | 2021-12-18 | Vermilion | Louisiana | 22113 | 10472 | 195 |
2022539 | 2022539 | 2021-12-17 | Vermilion | Louisiana | 22113 | 10472 | 195 |
2019288 | 2019288 | 2021-12-16 | Vermilion | Louisiana | 22113 | 10459 | 195 |
2016038 | 2016038 | 2021-12-15 | Vermilion | Louisiana | 22113 | 10456 | 195 |
2012787 | 2012787 | 2021-12-14 | Vermilion | Louisiana | 22113 | 10449 | 195 |
2009536 | 2009536 | 2021-12-13 | Vermilion | Louisiana | 22113 | 10437 | 195 |
2006285 | 2006285 | 2021-12-12 | Vermilion | Louisiana | 22113 | 10429 | 195 |
2003034 | 2003034 | 2021-12-11 | Vermilion | Louisiana | 22113 | 10429 | 195 |
1999784 | 1999784 | 2021-12-10 | Vermilion | Louisiana | 22113 | 10429 | 195 |
1710571 | 1710571 | 2021-09-12 | St. Mary | Louisiana | 22101 | 8071 | 195 |
1707324 | 1707324 | 2021-09-11 | St. Mary | Louisiana | 22101 | 8071 | 195 |
1704076 | 1704076 | 2021-09-10 | St. Mary | Louisiana | 22101 | 8071 | 195 |
1700826 | 1700826 | 2021-09-09 | St. Mary | Louisiana | 22101 | 8055 | 195 |
1427988 | 1427988 | 2021-06-17 | Acadia | Louisiana | 22001 | 6755 | 195 |
1424743 | 1424743 | 2021-06-16 | Acadia | Louisiana | 22001 | 6753 | 195 |
1421495 | 1421495 | 2021-06-15 | Acadia | Louisiana | 22001 | 6753 | 195 |
1418250 | 1418250 | 2021-06-14 | Acadia | Louisiana | 22001 | 6738 | 195 |
1415004 | 1415004 | 2021-06-13 | Acadia | Louisiana | 22001 | 6737 | 195 |
1411759 | 1411759 | 2021-06-12 | Acadia | Louisiana | 22001 | 6737 | 195 |
1408514 | 1408514 | 2021-06-11 | Acadia | Louisiana | 22001 | 6737 | 195 |
1405268 | 1405268 | 2021-06-10 | Acadia | Louisiana | 22001 | 6734 | 195 |
1402023 | 1402023 | 2021-06-09 | Acadia | Louisiana | 22001 | 6729 | 195 |
1398778 | 1398778 | 2021-06-08 | Acadia | Louisiana | 22001 | 6723 | 195 |
1395531 | 1395531 | 2021-06-07 | Acadia | Louisiana | 22001 | 6727 | 195 |
1392286 | 1392286 | 2021-06-06 | Acadia | Louisiana | 22001 | 6713 | 195 |
1389041 | 1389041 | 2021-06-05 | Acadia | Louisiana | 22001 | 6713 | 195 |
1385796 | 1385796 | 2021-06-04 | Acadia | Louisiana | 22001 | 6713 | 195 |
1382550 | 1382550 | 2021-06-03 | Acadia | Louisiana | 22001 | 6703 | 195 |
1379305 | 1379305 | 2021-06-02 | Acadia | Louisiana | 22001 | 6693 | 195 |
1376059 | 1376059 | 2021-06-01 | Acadia | Louisiana | 22001 | 6669 | 195 |
1372814 | 1372814 | 2021-05-31 | Acadia | Louisiana | 22001 | 6639 | 195 |
1369569 | 1369569 | 2021-05-30 | Acadia | Louisiana | 22001 | 6639 | 195 |
1366323 | 1366323 | 2021-05-29 | Acadia | Louisiana | 22001 | 6639 | 195 |
1363077 | 1363077 | 2021-05-28 | Acadia | Louisiana | 22001 | 6639 | 195 |
1359830 | 1359830 | 2021-05-27 | Acadia | Louisiana | 22001 | 6650 | 195 |
1356584 | 1356584 | 2021-05-26 | Acadia | Louisiana | 22001 | 6647 | 195 |
1353338 | 1353338 | 2021-05-25 | Acadia | Louisiana | 22001 | 6622 | 195 |
1152043 | 1152043 | 2021-03-24 | Livingston | Louisiana | 22063 | 12771 | 195 |
1061148 | 1061148 | 2021-02-24 | Lafourche | Louisiana | 22057 | 9068 | 195 |
1057902 | 1057902 | 2021-02-23 | Lafourche | Louisiana | 22057 | 9053 | 195 |
1054656 | 1054656 | 2021-02-22 | Lafourche | Louisiana | 22057 | 8996 | 195 |
1051409 | 1051409 | 2021-02-21 | Lafourche | Louisiana | 22057 | 8985 | 195 |
801517 | 801517 | 2020-12-06 | Rapides | Louisiana | 22079 | 6624 | 195 |
374237 | 374237 | 2020-07-27 | St. Tammany | Louisiana | 22103 | 4375 | 195 |
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);