ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where deaths = 170 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 22
county 22
- East Feliciana 53
- St. John the Baptist 9
- Unknown 7
- Bossier 6
- St. Tammany 5
- Tangipahoa 5
- Vermilion 4
- Acadia 3
- Ascension 3
- Iberia 3
- Avoyelles 2
- Franklin 2
- Lafourche 2
- St. Landry 2
- St. Martin 2
- Vernon 2
- East Baton Rouge 1
- Jefferson 1
- Livingston 1
- St. Mary 1
- Washington 1
- Webster 1
state 1
- Louisiana · 116 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500717 | 2500717 | 2022-05-13 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2497459 | 2497459 | 2022-05-12 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2494201 | 2494201 | 2022-05-11 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2490943 | 2490943 | 2022-05-10 | East Feliciana | Louisiana | 22037 | 7322 | 170 |
2487686 | 2487686 | 2022-05-09 | East Feliciana | Louisiana | 22037 | 7321 | 170 |
2484428 | 2484428 | 2022-05-08 | East Feliciana | Louisiana | 22037 | 7320 | 170 |
2481170 | 2481170 | 2022-05-07 | East Feliciana | Louisiana | 22037 | 7320 | 170 |
2477912 | 2477912 | 2022-05-06 | East Feliciana | Louisiana | 22037 | 7320 | 170 |
2474654 | 2474654 | 2022-05-05 | East Feliciana | Louisiana | 22037 | 7319 | 170 |
2471397 | 2471397 | 2022-05-04 | East Feliciana | Louisiana | 22037 | 7318 | 170 |
2468141 | 2468141 | 2022-05-03 | East Feliciana | Louisiana | 22037 | 7318 | 170 |
2464886 | 2464886 | 2022-05-02 | East Feliciana | Louisiana | 22037 | 7315 | 170 |
2461630 | 2461630 | 2022-05-01 | East Feliciana | Louisiana | 22037 | 7314 | 170 |
2458374 | 2458374 | 2022-04-30 | East Feliciana | Louisiana | 22037 | 7314 | 170 |
2455118 | 2455118 | 2022-04-29 | East Feliciana | Louisiana | 22037 | 7314 | 170 |
2451862 | 2451862 | 2022-04-28 | East Feliciana | Louisiana | 22037 | 7312 | 170 |
2448606 | 2448606 | 2022-04-27 | East Feliciana | Louisiana | 22037 | 7309 | 170 |
2445350 | 2445350 | 2022-04-26 | East Feliciana | Louisiana | 22037 | 7308 | 170 |
2442094 | 2442094 | 2022-04-25 | East Feliciana | Louisiana | 22037 | 7308 | 170 |
2438838 | 2438838 | 2022-04-24 | East Feliciana | Louisiana | 22037 | 7307 | 170 |
2435582 | 2435582 | 2022-04-23 | East Feliciana | Louisiana | 22037 | 7307 | 170 |
2432326 | 2432326 | 2022-04-22 | East Feliciana | Louisiana | 22037 | 7307 | 170 |
2429070 | 2429070 | 2022-04-21 | East Feliciana | Louisiana | 22037 | 7307 | 170 |
2425814 | 2425814 | 2022-04-20 | East Feliciana | Louisiana | 22037 | 7307 | 170 |
2422558 | 2422558 | 2022-04-19 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2419302 | 2419302 | 2022-04-18 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2416046 | 2416046 | 2022-04-17 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2412790 | 2412790 | 2022-04-16 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2409534 | 2409534 | 2022-04-15 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2406278 | 2406278 | 2022-04-14 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2403022 | 2403022 | 2022-04-13 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2399768 | 2399768 | 2022-04-12 | East Feliciana | Louisiana | 22037 | 7303 | 170 |
2396512 | 2396512 | 2022-04-11 | East Feliciana | Louisiana | 22037 | 7302 | 170 |
2393257 | 2393257 | 2022-04-10 | East Feliciana | Louisiana | 22037 | 7301 | 170 |
2390001 | 2390001 | 2022-04-09 | East Feliciana | Louisiana | 22037 | 7301 | 170 |
2386745 | 2386745 | 2022-04-08 | East Feliciana | Louisiana | 22037 | 7301 | 170 |
2383490 | 2383490 | 2022-04-07 | East Feliciana | Louisiana | 22037 | 7301 | 170 |
2380235 | 2380235 | 2022-04-06 | East Feliciana | Louisiana | 22037 | 7301 | 170 |
2376980 | 2376980 | 2022-04-05 | East Feliciana | Louisiana | 22037 | 7300 | 170 |
2373728 | 2373728 | 2022-04-04 | East Feliciana | Louisiana | 22037 | 7300 | 170 |
2370475 | 2370475 | 2022-04-03 | East Feliciana | Louisiana | 22037 | 7300 | 170 |
2367222 | 2367222 | 2022-04-02 | East Feliciana | Louisiana | 22037 | 7300 | 170 |
2363969 | 2363969 | 2022-04-01 | East Feliciana | Louisiana | 22037 | 7300 | 170 |
2360715 | 2360715 | 2022-03-31 | East Feliciana | Louisiana | 22037 | 7300 | 170 |
2357461 | 2357461 | 2022-03-30 | East Feliciana | Louisiana | 22037 | 7300 | 170 |
2354208 | 2354208 | 2022-03-29 | East Feliciana | Louisiana | 22037 | 7299 | 170 |
2350956 | 2350956 | 2022-03-28 | East Feliciana | Louisiana | 22037 | 7297 | 170 |
2347703 | 2347703 | 2022-03-27 | East Feliciana | Louisiana | 22037 | 7296 | 170 |
2344450 | 2344450 | 2022-03-26 | East Feliciana | Louisiana | 22037 | 7296 | 170 |
2341197 | 2341197 | 2022-03-25 | East Feliciana | Louisiana | 22037 | 7296 | 170 |
2337944 | 2337944 | 2022-03-24 | East Feliciana | Louisiana | 22037 | 7295 | 170 |
2334690 | 2334690 | 2022-03-23 | East Feliciana | Louisiana | 22037 | 7295 | 170 |
2331436 | 2331436 | 2022-03-22 | East Feliciana | Louisiana | 22037 | 7293 | 170 |
2266428 | 2266428 | 2022-03-02 | Webster | Louisiana | 22119 | 11061 | 170 |
2246882 | 2246882 | 2022-02-24 | Franklin | Louisiana | 22041 | 7269 | 170 |
2243631 | 2243631 | 2022-02-23 | Franklin | Louisiana | 22041 | 7264 | 170 |
2155841 | 2155841 | 2022-01-27 | St. Martin | Louisiana | 22099 | 11992 | 170 |
2152588 | 2152588 | 2022-01-26 | St. Martin | Louisiana | 22099 | 11930 | 170 |
2149345 | 2149345 | 2022-01-25 | Vernon | Louisiana | 22115 | 8331 | 170 |
2146093 | 2146093 | 2022-01-24 | Vernon | Louisiana | 22115 | 8257 | 170 |
1856774 | 1856774 | 2021-10-27 | St. John the Baptist | Louisiana | 22095 | 6298 | 170 |
1853525 | 1853525 | 2021-10-26 | St. John the Baptist | Louisiana | 22095 | 6296 | 170 |
1850276 | 1850276 | 2021-10-25 | St. John the Baptist | Louisiana | 22095 | 6293 | 170 |
1847026 | 1847026 | 2021-10-24 | St. John the Baptist | Louisiana | 22095 | 6288 | 170 |
1843776 | 1843776 | 2021-10-23 | St. John the Baptist | Louisiana | 22095 | 6288 | 170 |
1840526 | 1840526 | 2021-10-22 | St. John the Baptist | Louisiana | 22095 | 6288 | 170 |
1837277 | 1837277 | 2021-10-21 | St. John the Baptist | Louisiana | 22095 | 6285 | 170 |
1834028 | 1834028 | 2021-10-20 | St. John the Baptist | Louisiana | 22095 | 6279 | 170 |
1830779 | 1830779 | 2021-10-19 | St. John the Baptist | Louisiana | 22095 | 6279 | 170 |
1746261 | 1746261 | 2021-09-23 | Avoyelles | Louisiana | 22009 | 6893 | 170 |
1743012 | 1743012 | 2021-09-22 | Avoyelles | Louisiana | 22009 | 6880 | 170 |
1736567 | 1736567 | 2021-09-20 | Vermilion | Louisiana | 22113 | 9783 | 170 |
1733317 | 1733317 | 2021-09-19 | Vermilion | Louisiana | 22113 | 9739 | 170 |
1730067 | 1730067 | 2021-09-18 | Vermilion | Louisiana | 22113 | 9739 | 170 |
1726817 | 1726817 | 2021-09-17 | Vermilion | Louisiana | 22113 | 9739 | 170 |
1652109 | 1652109 | 2021-08-25 | Washington | Louisiana | 22117 | 6877 | 170 |
1632604 | 1632604 | 2021-08-19 | St. Mary | Louisiana | 22101 | 7418 | 170 |
1596848 | 1596848 | 2021-08-08 | Iberia | Louisiana | 22045 | 9246 | 170 |
1593599 | 1593599 | 2021-08-07 | Iberia | Louisiana | 22045 | 9246 | 170 |
1590350 | 1590350 | 2021-08-06 | Iberia | Louisiana | 22045 | 9246 | 170 |
1551351 | 1551351 | 2021-07-25 | Ascension | Louisiana | 22005 | 14324 | 170 |
1548104 | 1548104 | 2021-07-24 | Ascension | Louisiana | 22005 | 14324 | 170 |
1544857 | 1544857 | 2021-07-23 | Ascension | Louisiana | 22005 | 14324 | 170 |
1018956 | 1018956 | 2021-02-11 | Livingston | Louisiana | 22063 | 11832 | 170 |
944303 | 944303 | 2021-01-19 | Lafourche | Louisiana | 22057 | 7480 | 170 |
941058 | 941058 | 2021-01-18 | Lafourche | Louisiana | 22057 | 7416 | 170 |
934539 | 934539 | 2021-01-16 | Acadia | Louisiana | 22001 | 5542 | 170 |
931294 | 931294 | 2021-01-15 | Acadia | Louisiana | 22001 | 5542 | 170 |
928049 | 928049 | 2021-01-14 | Acadia | Louisiana | 22001 | 5527 | 170 |
872930 | 872930 | 2020-12-28 | Tangipahoa | Louisiana | 22105 | 8662 | 170 |
869685 | 869685 | 2020-12-27 | Tangipahoa | Louisiana | 22105 | 8660 | 170 |
866440 | 866440 | 2020-12-26 | Tangipahoa | Louisiana | 22105 | 8598 | 170 |
863195 | 863195 | 2020-12-25 | Tangipahoa | Louisiana | 22105 | 8598 | 170 |
859950 | 859950 | 2020-12-24 | Tangipahoa | Louisiana | 22105 | 8598 | 170 |
843679 | 843679 | 2020-12-19 | Bossier | Louisiana | 22015 | 7801 | 170 |
840434 | 840434 | 2020-12-18 | Bossier | Louisiana | 22015 | 7801 | 170 |
837189 | 837189 | 2020-12-17 | Bossier | Louisiana | 22015 | 7712 | 170 |
833943 | 833943 | 2020-12-16 | Bossier | Louisiana | 22015 | 7569 | 170 |
830696 | 830696 | 2020-12-15 | Bossier | Louisiana | 22015 | 7455 | 170 |
827450 | 827450 | 2020-12-14 | Bossier | Louisiana | 22015 | 7394 | 170 |
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);