ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where deaths = 158 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Evangeline 13
- Vernon 11
- Webster 8
- Ascension 7
- Iberia 7
- St. John the Baptist 6
- Bossier 5
- Lafourche 5
- Livingston 4
- St. Martin 4
- Avoyelles 3
- East Feliciana 3
- Ouachita 3
- Rapides 3
- St. Tammany 3
- Lafayette 2
- Calcasieu 1
- Jefferson 1
- Terrebonne 1
- Vermilion 1
- Washington 1
state 1
- Louisiana · 92 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461631 | 2461631 | 2022-05-01 | Evangeline | Louisiana | 22039 | 8388 | 158 |
2458375 | 2458375 | 2022-04-30 | Evangeline | Louisiana | 22039 | 8388 | 158 |
2455119 | 2455119 | 2022-04-29 | Evangeline | Louisiana | 22039 | 8388 | 158 |
2451863 | 2451863 | 2022-04-28 | Evangeline | Louisiana | 22039 | 8388 | 158 |
2448607 | 2448607 | 2022-04-27 | Evangeline | Louisiana | 22039 | 8388 | 158 |
2445351 | 2445351 | 2022-04-26 | Evangeline | Louisiana | 22039 | 8388 | 158 |
2442095 | 2442095 | 2022-04-25 | Evangeline | Louisiana | 22039 | 8388 | 158 |
2438839 | 2438839 | 2022-04-24 | Evangeline | Louisiana | 22039 | 8387 | 158 |
2435583 | 2435583 | 2022-04-23 | Evangeline | Louisiana | 22039 | 8387 | 158 |
2432327 | 2432327 | 2022-04-22 | Evangeline | Louisiana | 22039 | 8387 | 158 |
2429071 | 2429071 | 2022-04-21 | Evangeline | Louisiana | 22039 | 8387 | 158 |
2425815 | 2425815 | 2022-04-20 | Evangeline | Louisiana | 22039 | 8385 | 158 |
2422559 | 2422559 | 2022-04-19 | Evangeline | Louisiana | 22039 | 8383 | 158 |
2191639 | 2191639 | 2022-02-07 | Webster | Louisiana | 22119 | 10792 | 158 |
2188386 | 2188386 | 2022-02-06 | Webster | Louisiana | 22119 | 10722 | 158 |
2185133 | 2185133 | 2022-02-05 | Webster | Louisiana | 22119 | 10722 | 158 |
2181881 | 2181881 | 2022-02-04 | Webster | Louisiana | 22119 | 10722 | 158 |
2178630 | 2178630 | 2022-02-03 | Webster | Louisiana | 22119 | 10692 | 158 |
2175335 | 2175335 | 2022-02-02 | East Feliciana | Louisiana | 22037 | 7071 | 158 |
2172082 | 2172082 | 2022-02-01 | East Feliciana | Louisiana | 22037 | 7052 | 158 |
2168829 | 2168829 | 2022-01-31 | East Feliciana | Louisiana | 22037 | 7037 | 158 |
2155852 | 2155852 | 2022-01-27 | Webster | Louisiana | 22119 | 10272 | 158 |
2152599 | 2152599 | 2022-01-26 | Webster | Louisiana | 22119 | 10196 | 158 |
2149347 | 2149347 | 2022-01-25 | Webster | Louisiana | 22119 | 9571 | 158 |
1804797 | 1804797 | 2021-10-11 | Vernon | Louisiana | 22115 | 6153 | 158 |
1801548 | 1801548 | 2021-10-10 | Vernon | Louisiana | 22115 | 6125 | 158 |
1798299 | 1798299 | 2021-10-09 | Vernon | Louisiana | 22115 | 6125 | 158 |
1795050 | 1795050 | 2021-10-08 | Vernon | Louisiana | 22115 | 6125 | 158 |
1791802 | 1791802 | 2021-10-07 | Vernon | Louisiana | 22115 | 6112 | 158 |
1788553 | 1788553 | 2021-10-06 | Vernon | Louisiana | 22115 | 6074 | 158 |
1785304 | 1785304 | 2021-10-05 | Vernon | Louisiana | 22115 | 6050 | 158 |
1782046 | 1782046 | 2021-10-04 | St. Martin | Louisiana | 22099 | 8240 | 158 |
1782055 | 1782055 | 2021-10-04 | Vernon | Louisiana | 22115 | 6044 | 158 |
1778796 | 1778796 | 2021-10-03 | St. Martin | Louisiana | 22099 | 8229 | 158 |
1778805 | 1778805 | 2021-10-03 | Vernon | Louisiana | 22115 | 6013 | 158 |
1775546 | 1775546 | 2021-10-02 | St. Martin | Louisiana | 22099 | 8229 | 158 |
1775555 | 1775555 | 2021-10-02 | Vernon | Louisiana | 22115 | 6013 | 158 |
1772296 | 1772296 | 2021-10-01 | St. Martin | Louisiana | 22099 | 8229 | 158 |
1772305 | 1772305 | 2021-10-01 | Vernon | Louisiana | 22115 | 6013 | 158 |
1759299 | 1759299 | 2021-09-27 | St. John the Baptist | Louisiana | 22095 | 6185 | 158 |
1756051 | 1756051 | 2021-09-26 | St. John the Baptist | Louisiana | 22095 | 6163 | 158 |
1752803 | 1752803 | 2021-09-25 | St. John the Baptist | Louisiana | 22095 | 6163 | 158 |
1749554 | 1749554 | 2021-09-24 | St. John the Baptist | Louisiana | 22095 | 6163 | 158 |
1746304 | 1746304 | 2021-09-23 | St. John the Baptist | Louisiana | 22095 | 6155 | 158 |
1743055 | 1743055 | 2021-09-22 | St. John the Baptist | Louisiana | 22095 | 6145 | 158 |
1710525 | 1710525 | 2021-09-12 | Avoyelles | Louisiana | 22009 | 6662 | 158 |
1707278 | 1707278 | 2021-09-11 | Avoyelles | Louisiana | 22009 | 6662 | 158 |
1704030 | 1704030 | 2021-09-10 | Avoyelles | Louisiana | 22009 | 6662 | 158 |
1694336 | 1694336 | 2021-09-07 | Vermilion | Louisiana | 22113 | 9372 | 158 |
1626119 | 1626119 | 2021-08-17 | Washington | Louisiana | 22117 | 6296 | 158 |
1402045 | 1402045 | 2021-06-09 | Iberia | Louisiana | 22045 | 7330 | 158 |
1398800 | 1398800 | 2021-06-08 | Iberia | Louisiana | 22045 | 7327 | 158 |
1395553 | 1395553 | 2021-06-07 | Iberia | Louisiana | 22045 | 7317 | 158 |
1392308 | 1392308 | 2021-06-06 | Iberia | Louisiana | 22045 | 7302 | 158 |
1389063 | 1389063 | 2021-06-05 | Iberia | Louisiana | 22045 | 7302 | 158 |
1385818 | 1385818 | 2021-06-04 | Iberia | Louisiana | 22045 | 7302 | 158 |
1382572 | 1382572 | 2021-06-03 | Iberia | Louisiana | 22045 | 7294 | 158 |
1165004 | 1165004 | 2021-03-28 | Ascension | Louisiana | 22005 | 11480 | 158 |
1161756 | 1161756 | 2021-03-27 | Ascension | Louisiana | 22005 | 11480 | 158 |
1158508 | 1158508 | 2021-03-26 | Ascension | Louisiana | 22005 | 11480 | 158 |
1155261 | 1155261 | 2021-03-25 | Ascension | Louisiana | 22005 | 11458 | 158 |
1152014 | 1152014 | 2021-03-24 | Ascension | Louisiana | 22005 | 11444 | 158 |
1148767 | 1148767 | 2021-03-23 | Ascension | Louisiana | 22005 | 11431 | 158 |
1145520 | 1145520 | 2021-03-22 | Ascension | Louisiana | 22005 | 11398 | 158 |
980004 | 980004 | 2021-01-30 | Livingston | Louisiana | 22063 | 11174 | 158 |
976758 | 976758 | 2021-01-29 | Livingston | Louisiana | 22063 | 11174 | 158 |
973513 | 973513 | 2021-01-28 | Livingston | Louisiana | 22063 | 11115 | 158 |
970268 | 970268 | 2021-01-27 | Livingston | Louisiana | 22063 | 11039 | 158 |
924857 | 924857 | 2021-01-13 | Terrebonne | Louisiana | 22109 | 7342 | 158 |
850192 | 850192 | 2020-12-21 | Lafourche | Louisiana | 22057 | 5742 | 158 |
846947 | 846947 | 2020-12-20 | Lafourche | Louisiana | 22057 | 5731 | 158 |
843701 | 843701 | 2020-12-19 | Lafourche | Louisiana | 22057 | 5638 | 158 |
840456 | 840456 | 2020-12-18 | Lafourche | Louisiana | 22057 | 5638 | 158 |
837211 | 837211 | 2020-12-17 | Lafourche | Louisiana | 22057 | 5587 | 158 |
804751 | 804751 | 2020-12-07 | Lafayette | Louisiana | 22055 | 13096 | 158 |
801485 | 801485 | 2020-12-06 | Bossier | Louisiana | 22015 | 6875 | 158 |
801506 | 801506 | 2020-12-06 | Lafayette | Louisiana | 22055 | 13054 | 158 |
798240 | 798240 | 2020-12-05 | Bossier | Louisiana | 22015 | 6734 | 158 |
794995 | 794995 | 2020-12-04 | Bossier | Louisiana | 22015 | 6734 | 158 |
791750 | 791750 | 2020-12-03 | Bossier | Louisiana | 22015 | 6596 | 158 |
788505 | 788505 | 2020-12-02 | Bossier | Louisiana | 22015 | 6528 | 158 |
678223 | 678223 | 2020-10-29 | Rapides | Louisiana | 22079 | 4731 | 158 |
674981 | 674981 | 2020-10-28 | Rapides | Louisiana | 22079 | 4715 | 158 |
671738 | 671738 | 2020-10-27 | Rapides | Louisiana | 22079 | 4715 | 158 |
642534 | 642534 | 2020-10-18 | Ouachita | Louisiana | 22073 | 6775 | 158 |
639287 | 639287 | 2020-10-17 | Ouachita | Louisiana | 22073 | 6714 | 158 |
636041 | 636041 | 2020-10-16 | Ouachita | Louisiana | 22073 | 6714 | 158 |
448268 | 448268 | 2020-08-19 | Calcasieu | Louisiana | 22019 | 7154 | 158 |
197978 | 197978 | 2020-06-01 | St. Tammany | Louisiana | 22103 | 1764 | 158 |
194907 | 194907 | 2020-05-31 | St. Tammany | Louisiana | 22103 | 1749 | 158 |
191839 | 191839 | 2020-05-30 | St. Tammany | Louisiana | 22103 | 1724 | 158 |
44173 | 44173 | 2020-04-09 | Jefferson | Louisiana | 22051 | 4480 | 158 |
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);