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 674
- Orleans 674
- Caddo 672
- St. Charles 671
- St. Tammany 671
- Terrebonne 671
- St. John the Baptist 670
- Bossier 669
- Lafourche 669
- St. Bernard 669
- Ascension 667
- Washington 667
- East Baton Rouge 666
- Plaquemines 665
- St. James 665
- St. Landry 665
- Unknown 665
- Webster 665
- West Baton Rouge 665
- Assumption 664
- Calcasieu 664
- Iberia 664
- Iberville 664
- Lafayette 664
- Livingston 664
- Rapides 664
- Tangipahoa 664
- Catahoula 663
- De Soto 663
- Ouachita 663
- …
state 1
- Louisiana · 43,002 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2107035 | 2107035 | 2022-01-12 | Orleans | Louisiana | 22071 | 70360 | 1019 |
2107036 | 2107036 | 2022-01-12 | Ouachita | Louisiana | 22073 | 37857 | 616 |
2107037 | 2107037 | 2022-01-12 | Plaquemines | Louisiana | 22075 | 5161 | 41 |
2107038 | 2107038 | 2022-01-12 | Pointe Coupee | Louisiana | 22077 | 4630 | 85 |
2107039 | 2107039 | 2022-01-12 | Rapides | Louisiana | 22079 | 25243 | 485 |
2107040 | 2107040 | 2022-01-12 | Red River | Louisiana | 22081 | 1713 | 49 |
2107041 | 2107041 | 2022-01-12 | Richland | Louisiana | 22083 | 4904 | 81 |
2107042 | 2107042 | 2022-01-12 | Sabine | Louisiana | 22085 | 5234 | 100 |
2107043 | 2107043 | 2022-01-12 | St. Bernard | Louisiana | 22087 | 9060 | 101 |
2107044 | 2107044 | 2022-01-12 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2107045 | 2107045 | 2022-01-12 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2107046 | 2107046 | 2022-01-12 | St. James | Louisiana | 22093 | 4408 | 71 |
2107047 | 2107047 | 2022-01-12 | St. John the Baptist | Louisiana | 22095 | 8329 | 173 |
2107048 | 2107048 | 2022-01-12 | St. Landry | Louisiana | 22097 | 16488 | 354 |
2107049 | 2107049 | 2022-01-12 | St. Martin | Louisiana | 22099 | 10068 | 164 |
2107050 | 2107050 | 2022-01-12 | St. Mary | Louisiana | 22101 | 10220 | 236 |
2107051 | 2107051 | 2022-01-12 | St. Tammany | Louisiana | 22103 | 55677 | 748 |
2107052 | 2107052 | 2022-01-12 | Tangipahoa | Louisiana | 22105 | 26921 | 538 |
2107053 | 2107053 | 2022-01-12 | Tensas | Louisiana | 22107 | 685 | 10 |
2107054 | 2107054 | 2022-01-12 | Terrebonne | Louisiana | 22109 | 23565 | 369 |
2107055 | 2107055 | 2022-01-12 | Union | Louisiana | 22111 | 5028 | 114 |
2107056 | 2107056 | 2022-01-12 | Unknown | Louisiana | 18306 | 0 | |
2107057 | 2107057 | 2022-01-12 | Vermilion | Louisiana | 22113 | 11951 | 196 |
2107058 | 2107058 | 2022-01-12 | Vernon | Louisiana | 22115 | 7327 | 168 |
2107059 | 2107059 | 2022-01-12 | Washington | Louisiana | 22117 | 9549 | 222 |
2107060 | 2107060 | 2022-01-12 | Webster | Louisiana | 22119 | 8196 | 155 |
2107061 | 2107061 | 2022-01-12 | West Baton Rouge | Louisiana | 22121 | 5558 | 79 |
2107062 | 2107062 | 2022-01-12 | West Carroll | Louisiana | 22123 | 2408 | 53 |
2107063 | 2107063 | 2022-01-12 | West Feliciana | Louisiana | 22125 | 1542 | 41 |
2107064 | 2107064 | 2022-01-12 | Winn | Louisiana | 22127 | 3127 | 58 |
2103749 | 2103749 | 2022-01-11 | Acadia | Louisiana | 22001 | 12312 | 258 |
2103750 | 2103750 | 2022-01-11 | Allen | Louisiana | 22003 | 5409 | 119 |
2103751 | 2103751 | 2022-01-11 | Ascension | Louisiana | 22005 | 27518 | 253 |
2103752 | 2103752 | 2022-01-11 | Assumption | Louisiana | 22007 | 4427 | 57 |
2103753 | 2103753 | 2022-01-11 | Avoyelles | Louisiana | 22009 | 8482 | 179 |
2103754 | 2103754 | 2022-01-11 | Beauregard | Louisiana | 22011 | 6857 | 129 |
2103755 | 2103755 | 2022-01-11 | Bienville | Louisiana | 22013 | 2968 | 100 |
2103756 | 2103756 | 2022-01-11 | Bossier | Louisiana | 22015 | 27522 | 416 |
2103757 | 2103757 | 2022-01-11 | Caddo | Louisiana | 22017 | 51919 | 1000 |
2103758 | 2103758 | 2022-01-11 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2103759 | 2103759 | 2022-01-11 | Caldwell | Louisiana | 22021 | 2490 | 43 |
2103760 | 2103760 | 2022-01-11 | Cameron | Louisiana | 22023 | 984 | 8 |
2103761 | 2103761 | 2022-01-11 | Catahoula | Louisiana | 22025 | 2042 | 49 |
2103762 | 2103762 | 2022-01-11 | Claiborne | Louisiana | 22027 | 2429 | 66 |
2103763 | 2103763 | 2022-01-11 | Concordia | Louisiana | 22029 | 3808 | 80 |
2103764 | 2103764 | 2022-01-11 | De Soto | Louisiana | 22031 | 5735 | 119 |
2103765 | 2103765 | 2022-01-11 | East Baton Rouge | Louisiana | 22033 | 83046 | 1188 |
2103766 | 2103766 | 2022-01-11 | East Carroll | Louisiana | 22035 | 1900 | 33 |
2103767 | 2103767 | 2022-01-11 | East Feliciana | Louisiana | 22037 | 5249 | 152 |
2103768 | 2103768 | 2022-01-11 | Evangeline | Louisiana | 22039 | 6681 | 144 |
2103769 | 2103769 | 2022-01-11 | Franklin | Louisiana | 22041 | 5345 | 144 |
2103770 | 2103770 | 2022-01-11 | Grant | Louisiana | 22043 | 4307 | 80 |
2103771 | 2103771 | 2022-01-11 | Iberia | Louisiana | 22045 | 15165 | 234 |
2103772 | 2103772 | 2022-01-11 | Iberville | Louisiana | 22047 | 7134 | 129 |
2103773 | 2103773 | 2022-01-11 | Jackson | Louisiana | 22049 | 3149 | 65 |
2103774 | 2103774 | 2022-01-11 | Jefferson | Louisiana | 22051 | 92879 | 1202 |
2103775 | 2103775 | 2022-01-11 | Jefferson Davis | Louisiana | 22053 | 5407 | 133 |
2103776 | 2103776 | 2022-01-11 | LaSalle | Louisiana | 22059 | 3087 | 46 |
2103777 | 2103777 | 2022-01-11 | Lafayette | Louisiana | 22055 | 47529 | 420 |
2103778 | 2103778 | 2022-01-11 | Lafourche | Louisiana | 22057 | 21140 | 321 |
2103779 | 2103779 | 2022-01-11 | Lincoln | Louisiana | 22061 | 8709 | 121 |
2103780 | 2103780 | 2022-01-11 | Livingston | Louisiana | 22063 | 28406 | 392 |
2103781 | 2103781 | 2022-01-11 | Madison | Louisiana | 22065 | 2646 | 55 |
2103782 | 2103782 | 2022-01-11 | Morehouse | Louisiana | 22067 | 5302 | 119 |
2103783 | 2103783 | 2022-01-11 | Natchitoches | Louisiana | 22069 | 8164 | 142 |
2103784 | 2103784 | 2022-01-11 | Orleans | Louisiana | 22071 | 70360 | 1017 |
2103785 | 2103785 | 2022-01-11 | Ouachita | Louisiana | 22073 | 37857 | 613 |
2103786 | 2103786 | 2022-01-11 | Plaquemines | Louisiana | 22075 | 5161 | 41 |
2103787 | 2103787 | 2022-01-11 | Pointe Coupee | Louisiana | 22077 | 4630 | 85 |
2103788 | 2103788 | 2022-01-11 | Rapides | Louisiana | 22079 | 25243 | 485 |
2103789 | 2103789 | 2022-01-11 | Red River | Louisiana | 22081 | 1713 | 49 |
2103790 | 2103790 | 2022-01-11 | Richland | Louisiana | 22083 | 4904 | 80 |
2103791 | 2103791 | 2022-01-11 | Sabine | Louisiana | 22085 | 5234 | 100 |
2103792 | 2103792 | 2022-01-11 | St. Bernard | Louisiana | 22087 | 9060 | 101 |
2103793 | 2103793 | 2022-01-11 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2103794 | 2103794 | 2022-01-11 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2103795 | 2103795 | 2022-01-11 | St. James | Louisiana | 22093 | 4408 | 71 |
2103796 | 2103796 | 2022-01-11 | St. John the Baptist | Louisiana | 22095 | 8329 | 173 |
2103797 | 2103797 | 2022-01-11 | St. Landry | Louisiana | 22097 | 16488 | 354 |
2103798 | 2103798 | 2022-01-11 | St. Martin | Louisiana | 22099 | 10068 | 164 |
2103799 | 2103799 | 2022-01-11 | St. Mary | Louisiana | 22101 | 10220 | 235 |
2103800 | 2103800 | 2022-01-11 | St. Tammany | Louisiana | 22103 | 55677 | 746 |
2103801 | 2103801 | 2022-01-11 | Tangipahoa | Louisiana | 22105 | 26921 | 537 |
2103802 | 2103802 | 2022-01-11 | Tensas | Louisiana | 22107 | 685 | 10 |
2103803 | 2103803 | 2022-01-11 | Terrebonne | Louisiana | 22109 | 23565 | 369 |
2103804 | 2103804 | 2022-01-11 | Union | Louisiana | 22111 | 5028 | 114 |
2103805 | 2103805 | 2022-01-11 | Unknown | Louisiana | 714 | 0 | |
2103806 | 2103806 | 2022-01-11 | Vermilion | Louisiana | 22113 | 11951 | 196 |
2103807 | 2103807 | 2022-01-11 | Vernon | Louisiana | 22115 | 7327 | 168 |
2103808 | 2103808 | 2022-01-11 | Washington | Louisiana | 22117 | 9549 | 222 |
2103809 | 2103809 | 2022-01-11 | Webster | Louisiana | 22119 | 8196 | 155 |
2103810 | 2103810 | 2022-01-11 | West Baton Rouge | Louisiana | 22121 | 5558 | 79 |
2103811 | 2103811 | 2022-01-11 | West Carroll | Louisiana | 22123 | 2408 | 53 |
2103812 | 2103812 | 2022-01-11 | West Feliciana | Louisiana | 22125 | 1542 | 41 |
2103813 | 2103813 | 2022-01-11 | Winn | Louisiana | 22127 | 3127 | 58 |
2100498 | 2100498 | 2022-01-10 | Acadia | Louisiana | 22001 | 12134 | 257 |
2100499 | 2100499 | 2022-01-10 | Allen | Louisiana | 22003 | 5285 | 119 |
2100500 | 2100500 | 2022-01-10 | Ascension | Louisiana | 22005 | 26963 | 252 |
2100501 | 2100501 | 2022-01-10 | Assumption | Louisiana | 22007 | 4391 | 57 |
2100502 | 2100502 | 2022-01-10 | Avoyelles | Louisiana | 22009 | 8332 | 179 |
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);