ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50,902 rows where state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jefferson 553
- Orleans 553
- Caddo 551
- St. Charles 550
- St. Tammany 550
- Terrebonne 550
- St. John the Baptist 549
- Bossier 548
- Lafourche 548
- St. Bernard 548
- Ascension 546
- Washington 546
- East Baton Rouge 545
- Plaquemines 544
- St. James 544
- St. Landry 544
- Unknown 544
- Webster 544
- West Baton Rouge 544
- Assumption 543
- Calcasieu 543
- Iberia 543
- Iberville 543
- Lafayette 543
- Livingston 543
- Rapides 543
- Tangipahoa 543
- Catahoula 542
- De Soto 542
- Ouachita 542
- …
state 1
- Louisiana · 35,137 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1713803 | 1713803 | 2021-09-13 | Orleans | Louisiana | 22071 | 44662 | 929 |
1713804 | 1713804 | 2021-09-13 | Ouachita | Louisiana | 22073 | 28915 | 527 |
1713805 | 1713805 | 2021-09-13 | Plaquemines | Louisiana | 22075 | 3666 | 35 |
1713806 | 1713806 | 2021-09-13 | Pointe Coupee | Louisiana | 22077 | 3666 | 81 |
1713807 | 1713807 | 2021-09-13 | Rapides | Louisiana | 22079 | 20033 | 414 |
1713808 | 1713808 | 2021-09-13 | Red River | Louisiana | 22081 | 1293 | 42 |
1713809 | 1713809 | 2021-09-13 | Richland | Louisiana | 22083 | 3958 | 72 |
1713810 | 1713810 | 2021-09-13 | Sabine | Louisiana | 22085 | 4153 | 70 |
1713811 | 1713811 | 2021-09-13 | St. Bernard | Louisiana | 22087 | 6594 | 86 |
1713812 | 1713812 | 2021-09-13 | St. Charles | Louisiana | 22089 | 8549 | 117 |
1713813 | 1713813 | 2021-09-13 | St. Helena | Louisiana | 22091 | 1245 | 12 |
1713814 | 1713814 | 2021-09-13 | St. James | Louisiana | 22093 | 3285 | 62 |
1713815 | 1713815 | 2021-09-13 | St. John the Baptist | Louisiana | 22095 | 6041 | 156 |
1713816 | 1713816 | 2021-09-13 | St. Landry | Louisiana | 22097 | 13208 | 313 |
1713817 | 1713817 | 2021-09-13 | St. Martin | Louisiana | 22099 | 8021 | 148 |
1713818 | 1713818 | 2021-09-13 | St. Mary | Louisiana | 22101 | 8121 | 196 |
1713819 | 1713819 | 2021-09-13 | St. Tammany | Louisiana | 22103 | 41389 | 644 |
1713820 | 1713820 | 2021-09-13 | Tangipahoa | Louisiana | 22105 | 21663 | 447 |
1713821 | 1713821 | 2021-09-13 | Tensas | Louisiana | 22107 | 468 | 8 |
1713822 | 1713822 | 2021-09-13 | Terrebonne | Louisiana | 22109 | 18522 | 279 |
1713823 | 1713823 | 2021-09-13 | Union | Louisiana | 22111 | 3682 | 93 |
1713824 | 1713824 | 2021-09-13 | Vermilion | Louisiana | 22113 | 9616 | 162 |
1713825 | 1713825 | 2021-09-13 | Vernon | Louisiana | 22115 | 5531 | 140 |
1713826 | 1713826 | 2021-09-13 | Washington | Louisiana | 22117 | 7576 | 186 |
1713827 | 1713827 | 2021-09-13 | Webster | Louisiana | 22119 | 6057 | 135 |
1713828 | 1713828 | 2021-09-13 | West Baton Rouge | Louisiana | 22121 | 4243 | 71 |
1713829 | 1713829 | 2021-09-13 | West Carroll | Louisiana | 22123 | 1787 | 46 |
1713830 | 1713830 | 2021-09-13 | West Feliciana | Louisiana | 22125 | 1417 | 39 |
1713831 | 1713831 | 2021-09-13 | Winn | Louisiana | 22127 | 2489 | 54 |
1710521 | 1710521 | 2021-09-12 | Acadia | Louisiana | 22001 | 9885 | 232 |
1710522 | 1710522 | 2021-09-12 | Allen | Louisiana | 22003 | 4380 | 102 |
1710523 | 1710523 | 2021-09-12 | Ascension | Louisiana | 22005 | 20747 | 218 |
1710524 | 1710524 | 2021-09-12 | Assumption | Louisiana | 22007 | 3455 | 52 |
1710525 | 1710525 | 2021-09-12 | Avoyelles | Louisiana | 22009 | 6662 | 158 |
1710526 | 1710526 | 2021-09-12 | Beauregard | Louisiana | 22011 | 5517 | 103 |
1710527 | 1710527 | 2021-09-12 | Bienville | Louisiana | 22013 | 2307 | 87 |
1710528 | 1710528 | 2021-09-12 | Bossier | Louisiana | 22015 | 20195 | 360 |
1710529 | 1710529 | 2021-09-12 | Caddo | Louisiana | 22017 | 36741 | 866 |
1710530 | 1710530 | 2021-09-12 | Calcasieu | Louisiana | 22019 | 32113 | 537 |
1710531 | 1710531 | 2021-09-12 | Caldwell | Louisiana | 22021 | 1800 | 33 |
1710532 | 1710532 | 2021-09-12 | Cameron | Louisiana | 22023 | 826 | 7 |
1710533 | 1710533 | 2021-09-12 | Catahoula | Louisiana | 22025 | 1659 | 45 |
1710534 | 1710534 | 2021-09-12 | Claiborne | Louisiana | 22027 | 1909 | 58 |
1710535 | 1710535 | 2021-09-12 | Concordia | Louisiana | 22029 | 2950 | 69 |
1710536 | 1710536 | 2021-09-12 | De Soto | Louisiana | 22031 | 4414 | 100 |
1710537 | 1710537 | 2021-09-12 | East Baton Rouge | Louisiana | 22033 | 60736 | 1067 |
1710538 | 1710538 | 2021-09-12 | East Carroll | Louisiana | 22035 | 1463 | 29 |
1710539 | 1710539 | 2021-09-12 | East Feliciana | Louisiana | 22037 | 4344 | 133 |
1710540 | 1710540 | 2021-09-12 | Evangeline | Louisiana | 22039 | 5398 | 113 |
1710541 | 1710541 | 2021-09-12 | Franklin | Louisiana | 22041 | 3975 | 129 |
1710542 | 1710542 | 2021-09-12 | Grant | Louisiana | 22043 | 3564 | 71 |
1710543 | 1710543 | 2021-09-12 | Iberia | Louisiana | 22045 | 11862 | 205 |
1710544 | 1710544 | 2021-09-12 | Iberville | Louisiana | 22047 | 5607 | 120 |
1710545 | 1710545 | 2021-09-12 | Jackson | Louisiana | 22049 | 2579 | 58 |
1710546 | 1710546 | 2021-09-12 | Jefferson | Louisiana | 22051 | 66764 | 1067 |
1710547 | 1710547 | 2021-09-12 | Jefferson Davis | Louisiana | 22053 | 4390 | 114 |
1710548 | 1710548 | 2021-09-12 | LaSalle | Louisiana | 22059 | 2507 | 41 |
1710549 | 1710549 | 2021-09-12 | Lafayette | Louisiana | 22055 | 36583 | 371 |
1710550 | 1710550 | 2021-09-12 | Lafourche | Louisiana | 22057 | 16933 | 266 |
1710551 | 1710551 | 2021-09-12 | Lincoln | Louisiana | 22061 | 6417 | 106 |
1710552 | 1710552 | 2021-09-12 | Livingston | Louisiana | 22063 | 23282 | 330 |
1710553 | 1710553 | 2021-09-12 | Madison | Louisiana | 22065 | 2067 | 49 |
1710554 | 1710554 | 2021-09-12 | Morehouse | Louisiana | 22067 | 4189 | 98 |
1710555 | 1710555 | 2021-09-12 | Natchitoches | Louisiana | 22069 | 5934 | 114 |
1710556 | 1710556 | 2021-09-12 | Orleans | Louisiana | 22071 | 44464 | 925 |
1710557 | 1710557 | 2021-09-12 | Ouachita | Louisiana | 22073 | 28681 | 527 |
1710558 | 1710558 | 2021-09-12 | Plaquemines | Louisiana | 22075 | 3651 | 35 |
1710559 | 1710559 | 2021-09-12 | Pointe Coupee | Louisiana | 22077 | 3653 | 81 |
1710560 | 1710560 | 2021-09-12 | Rapides | Louisiana | 22079 | 19900 | 409 |
1710561 | 1710561 | 2021-09-12 | Red River | Louisiana | 22081 | 1277 | 42 |
1710562 | 1710562 | 2021-09-12 | Richland | Louisiana | 22083 | 3917 | 72 |
1710563 | 1710563 | 2021-09-12 | Sabine | Louisiana | 22085 | 4107 | 70 |
1710564 | 1710564 | 2021-09-12 | St. Bernard | Louisiana | 22087 | 6547 | 86 |
1710565 | 1710565 | 2021-09-12 | St. Charles | Louisiana | 22089 | 8507 | 117 |
1710566 | 1710566 | 2021-09-12 | St. Helena | Louisiana | 22091 | 1244 | 12 |
1710567 | 1710567 | 2021-09-12 | St. James | Louisiana | 22093 | 3257 | 62 |
1710568 | 1710568 | 2021-09-12 | St. John the Baptist | Louisiana | 22095 | 6018 | 156 |
1710569 | 1710569 | 2021-09-12 | St. Landry | Louisiana | 22097 | 13083 | 313 |
1710570 | 1710570 | 2021-09-12 | St. Martin | Louisiana | 22099 | 7986 | 148 |
1710571 | 1710571 | 2021-09-12 | St. Mary | Louisiana | 22101 | 8071 | 195 |
1710572 | 1710572 | 2021-09-12 | St. Tammany | Louisiana | 22103 | 41120 | 644 |
1710573 | 1710573 | 2021-09-12 | Tangipahoa | Louisiana | 22105 | 21568 | 447 |
1710574 | 1710574 | 2021-09-12 | Tensas | Louisiana | 22107 | 463 | 8 |
1710575 | 1710575 | 2021-09-12 | Terrebonne | Louisiana | 22109 | 18379 | 278 |
1710576 | 1710576 | 2021-09-12 | Union | Louisiana | 22111 | 3638 | 92 |
1710577 | 1710577 | 2021-09-12 | Unknown | Louisiana | 517 | 0 | |
1710578 | 1710578 | 2021-09-12 | Vermilion | Louisiana | 22113 | 9549 | 162 |
1710579 | 1710579 | 2021-09-12 | Vernon | Louisiana | 22115 | 5442 | 139 |
1710580 | 1710580 | 2021-09-12 | Washington | Louisiana | 22117 | 7499 | 185 |
1710581 | 1710581 | 2021-09-12 | Webster | Louisiana | 22119 | 6001 | 133 |
1710582 | 1710582 | 2021-09-12 | West Baton Rouge | Louisiana | 22121 | 4237 | 71 |
1710583 | 1710583 | 2021-09-12 | West Carroll | Louisiana | 22123 | 1761 | 46 |
1710584 | 1710584 | 2021-09-12 | West Feliciana | Louisiana | 22125 | 1417 | 39 |
1710585 | 1710585 | 2021-09-12 | Winn | Louisiana | 22127 | 2466 | 54 |
1707274 | 1707274 | 2021-09-11 | Acadia | Louisiana | 22001 | 9885 | 232 |
1707275 | 1707275 | 2021-09-11 | Allen | Louisiana | 22003 | 4380 | 102 |
1707276 | 1707276 | 2021-09-11 | Ascension | Louisiana | 22005 | 20747 | 218 |
1707277 | 1707277 | 2021-09-11 | Assumption | Louisiana | 22007 | 3455 | 52 |
1707278 | 1707278 | 2021-09-11 | Avoyelles | Louisiana | 22009 | 6662 | 158 |
1707279 | 1707279 | 2021-09-11 | Beauregard | Louisiana | 22011 | 5517 | 103 |
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);