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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 65
- 22051 796
- 22071 795
- 22017 794
- 22089 792
- 22103 792
- 22109 792
- 22015 791
- 22057 791
- 22095 791
- 22087 790
- 22005 789
- 22033 788
- 22117 788
- 22007 786
- 22019 786
- 22045 786
- 22047 786
- 22055 786
- 22063 786
- 22075 786
- 22093 786
- 22097 786
- 22119 786
- 22121 786
- - 786
- 22025 785
- 22031 785
- 22079 785
- 22105 785
- 22009 784
- 22011 784
- 22013 784
- 22027 784
- 22039 784
- 22073 784
- 22101 784
- 22001 783
- 22003 782
- 22043 782
- 22061 782
- 22069 782
- 22083 782
- 22099 782
- 22115 781
- 22049 780
- 22053 780
- 22067 780
- 22111 780
- 22127 780
- 22037 779
- 22059 779
- 22065 779
- 22077 779
- 22113 779
- 22125 778
- 22035 777
- 22041 777
- 22081 776
- 22085 776
- 22029 774
- 22091 774
- 22021 772
- 22123 768
- 22023 767
- 22107 763
county 65
- Jefferson 796
- Orleans 795
- Caddo 794
- St. Charles 792
- St. Tammany 792
- Terrebonne 792
- Bossier 791
- Lafourche 791
- St. John the Baptist 791
- St. Bernard 790
- Ascension 789
- East Baton Rouge 788
- Washington 788
- Assumption 786
- Calcasieu 786
- Iberia 786
- Iberville 786
- Lafayette 786
- Livingston 786
- Plaquemines 786
- St. James 786
- St. Landry 786
- Unknown 786
- Webster 786
- West Baton Rouge 786
- Catahoula 785
- De Soto 785
- Rapides 785
- Tangipahoa 785
- Avoyelles 784
- Beauregard 784
- Bienville 784
- Claiborne 784
- Evangeline 784
- Ouachita 784
- St. Mary 784
- Acadia 783
- Allen 782
- Grant 782
- Lincoln 782
- Natchitoches 782
- Richland 782
- St. Martin 782
- Vernon 781
- Jackson 780
- Jefferson Davis 780
- Morehouse 780
- Union 780
- Winn 780
- East Feliciana 779
- LaSalle 779
- Madison 779
- Pointe Coupee 779
- Vermilion 779
- West Feliciana 778
- East Carroll 777
- Franklin 777
- Red River 776
- Sabine 776
- Concordia 774
- St. Helena 774
- Caldwell 772
- West Carroll 768
- Cameron 767
- Tensas 763
state 1
- Louisiana · 50,902 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
924 | 924 | 2020-03-09 | Jefferson | Louisiana | 22051 | 1 | 0 |
1069 | 1069 | 2020-03-10 | Jefferson | Louisiana | 22051 | 1 | 0 |
1070 | 1070 | 2020-03-10 | Orleans | Louisiana | 22071 | 5 | 0 |
1247 | 1247 | 2020-03-11 | Caddo | Louisiana | 22017 | 1 | 0 |
1248 | 1248 | 2020-03-11 | Jefferson | Louisiana | 22051 | 1 | 0 |
1249 | 1249 | 2020-03-11 | Orleans | Louisiana | 22071 | 11 | 0 |
1464 | 1464 | 2020-03-12 | Caddo | Louisiana | 22017 | 1 | 0 |
1465 | 1465 | 2020-03-12 | Jefferson | Louisiana | 22051 | 1 | 0 |
1466 | 1466 | 2020-03-12 | Orleans | Louisiana | 22071 | 12 | 0 |
1737 | 1737 | 2020-03-13 | Caddo | Louisiana | 22017 | 1 | 0 |
1738 | 1738 | 2020-03-13 | Jefferson | Louisiana | 22051 | 3 | 0 |
1739 | 1739 | 2020-03-13 | Orleans | Louisiana | 22071 | 28 | 0 |
1740 | 1740 | 2020-03-13 | St. Charles | Louisiana | 22089 | 1 | 0 |
1741 | 1741 | 2020-03-13 | St. Tammany | Louisiana | 22103 | 2 | 0 |
1742 | 1742 | 2020-03-13 | Terrebonne | Louisiana | 22109 | 1 | 0 |
2074 | 2074 | 2020-03-14 | Bossier | Louisiana | 22015 | 1 | 0 |
2075 | 2075 | 2020-03-14 | Caddo | Louisiana | 22017 | 2 | 0 |
2076 | 2076 | 2020-03-14 | Jefferson | Louisiana | 22051 | 11 | 0 |
2077 | 2077 | 2020-03-14 | Lafourche | Louisiana | 22057 | 1 | 0 |
2079 | 2079 | 2020-03-14 | St. Charles | Louisiana | 22089 | 2 | 0 |
2080 | 2080 | 2020-03-14 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
2081 | 2081 | 2020-03-14 | St. Tammany | Louisiana | 22103 | 4 | 0 |
2082 | 2082 | 2020-03-14 | Terrebonne | Louisiana | 22109 | 2 | 0 |
2471 | 2471 | 2020-03-15 | Bossier | Louisiana | 22015 | 1 | 0 |
2472 | 2472 | 2020-03-15 | Caddo | Louisiana | 22017 | 2 | 0 |
2473 | 2473 | 2020-03-15 | Jefferson | Louisiana | 22051 | 14 | 0 |
2474 | 2474 | 2020-03-15 | Lafourche | Louisiana | 22057 | 1 | 0 |
2476 | 2476 | 2020-03-15 | St. Bernard | Louisiana | 22087 | 1 | 0 |
2477 | 2477 | 2020-03-15 | St. Charles | Louisiana | 22089 | 2 | 0 |
2478 | 2478 | 2020-03-15 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
2479 | 2479 | 2020-03-15 | St. Tammany | Louisiana | 22103 | 4 | 0 |
2480 | 2480 | 2020-03-15 | Terrebonne | Louisiana | 22109 | 2 | 0 |
2916 | 2916 | 2020-03-16 | Ascension | Louisiana | 22005 | 1 | 0 |
2917 | 2917 | 2020-03-16 | Bossier | Louisiana | 22015 | 1 | 0 |
2918 | 2918 | 2020-03-16 | Caddo | Louisiana | 22017 | 3 | 0 |
2919 | 2919 | 2020-03-16 | Jefferson | Louisiana | 22051 | 21 | 0 |
2920 | 2920 | 2020-03-16 | Lafourche | Louisiana | 22057 | 2 | 0 |
2922 | 2922 | 2020-03-16 | St. Bernard | Louisiana | 22087 | 2 | 0 |
2923 | 2923 | 2020-03-16 | St. Charles | Louisiana | 22089 | 3 | 0 |
2924 | 2924 | 2020-03-16 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
2925 | 2925 | 2020-03-16 | St. Tammany | Louisiana | 22103 | 6 | 0 |
2926 | 2926 | 2020-03-16 | Terrebonne | Louisiana | 22109 | 2 | 0 |
3412 | 3412 | 2020-03-17 | Ascension | Louisiana | 22005 | 1 | 0 |
3413 | 3413 | 2020-03-17 | Bossier | Louisiana | 22015 | 1 | 0 |
3414 | 3414 | 2020-03-17 | Caddo | Louisiana | 22017 | 4 | 0 |
3415 | 3415 | 2020-03-17 | East Baton Rouge | Louisiana | 22033 | 1 | 0 |
3416 | 3416 | 2020-03-17 | Jefferson | Louisiana | 22051 | 35 | 0 |
3417 | 3417 | 2020-03-17 | Lafourche | Louisiana | 22057 | 2 | 0 |
3419 | 3419 | 2020-03-17 | St. Bernard | Louisiana | 22087 | 2 | 0 |
3420 | 3420 | 2020-03-17 | St. Charles | Louisiana | 22089 | 3 | 0 |
3421 | 3421 | 2020-03-17 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
3422 | 3422 | 2020-03-17 | St. Tammany | Louisiana | 22103 | 6 | 0 |
3423 | 3423 | 2020-03-17 | Terrebonne | Louisiana | 22109 | 3 | 0 |
3424 | 3424 | 2020-03-17 | Washington | Louisiana | 22117 | 1 | 0 |
3992 | 3992 | 2020-03-18 | Ascension | Louisiana | 22005 | 1 | 0 |
3993 | 3993 | 2020-03-18 | Bossier | Louisiana | 22015 | 2 | 0 |
3994 | 3994 | 2020-03-18 | Caddo | Louisiana | 22017 | 6 | 0 |
3995 | 3995 | 2020-03-18 | East Baton Rouge | Louisiana | 22033 | 3 | 0 |
3997 | 3997 | 2020-03-18 | Lafourche | Louisiana | 22057 | 3 | 0 |
3999 | 3999 | 2020-03-18 | St. Bernard | Louisiana | 22087 | 3 | 0 |
4000 | 4000 | 2020-03-18 | St. Charles | Louisiana | 22089 | 3 | 0 |
4001 | 4001 | 2020-03-18 | St. John the Baptist | Louisiana | 22095 | 2 | 0 |
4002 | 4002 | 2020-03-18 | St. Tammany | Louisiana | 22103 | 10 | 0 |
4003 | 4003 | 2020-03-18 | Terrebonne | Louisiana | 22109 | 3 | 0 |
4004 | 4004 | 2020-03-18 | Unknown | Louisiana | 2 | 0 | |
4005 | 4005 | 2020-03-18 | Washington | Louisiana | 22117 | 1 | 0 |
4683 | 4683 | 2020-03-19 | Ascension | Louisiana | 22005 | 2 | 0 |
4684 | 4684 | 2020-03-19 | Assumption | Louisiana | 22007 | 1 | 0 |
4685 | 4685 | 2020-03-19 | Bossier | Louisiana | 22015 | 4 | 0 |
4686 | 4686 | 2020-03-19 | Caddo | Louisiana | 22017 | 10 | 0 |
4687 | 4687 | 2020-03-19 | Calcasieu | Louisiana | 22019 | 1 | 0 |
4688 | 4688 | 2020-03-19 | East Baton Rouge | Louisiana | 22033 | 6 | 0 |
4689 | 4689 | 2020-03-19 | Iberia | Louisiana | 22045 | 1 | 0 |
4690 | 4690 | 2020-03-19 | Iberville | Louisiana | 22047 | 1 | 0 |
4692 | 4692 | 2020-03-19 | Lafayette | Louisiana | 22055 | 3 | 0 |
4693 | 4693 | 2020-03-19 | Lafourche | Louisiana | 22057 | 4 | 0 |
4694 | 4694 | 2020-03-19 | Livingston | Louisiana | 22063 | 1 | 0 |
4696 | 4696 | 2020-03-19 | Plaquemines | Louisiana | 22075 | 1 | 0 |
4697 | 4697 | 2020-03-19 | St. Bernard | Louisiana | 22087 | 4 | 0 |
4698 | 4698 | 2020-03-19 | St. Charles | Louisiana | 22089 | 4 | 0 |
4700 | 4700 | 2020-03-19 | St. John the Baptist | Louisiana | 22095 | 3 | 0 |
4701 | 4701 | 2020-03-19 | St. Landry | Louisiana | 22097 | 2 | 0 |
4702 | 4702 | 2020-03-19 | St. Tammany | Louisiana | 22103 | 10 | 0 |
4703 | 4703 | 2020-03-19 | Terrebonne | Louisiana | 22109 | 4 | 0 |
4704 | 4704 | 2020-03-19 | Unknown | Louisiana | 3 | 0 | |
4705 | 4705 | 2020-03-19 | Washington | Louisiana | 22117 | 2 | 0 |
4706 | 4706 | 2020-03-19 | Webster | Louisiana | 22119 | 1 | 0 |
4707 | 4707 | 2020-03-19 | West Baton Rouge | Louisiana | 22121 | 2 | 0 |
5497 | 5497 | 2020-03-20 | Ascension | Louisiana | 22005 | 3 | 0 |
5498 | 5498 | 2020-03-20 | Assumption | Louisiana | 22007 | 1 | 0 |
5499 | 5499 | 2020-03-20 | Bossier | Louisiana | 22015 | 5 | 0 |
5500 | 5500 | 2020-03-20 | Caddo | Louisiana | 22017 | 12 | 0 |
5501 | 5501 | 2020-03-20 | Calcasieu | Louisiana | 22019 | 3 | 0 |
5502 | 5502 | 2020-03-20 | Catahoula | Louisiana | 22025 | 1 | 0 |
5503 | 5503 | 2020-03-20 | De Soto | Louisiana | 22031 | 2 | 0 |
5504 | 5504 | 2020-03-20 | East Baton Rouge | Louisiana | 22033 | 7 | 0 |
5505 | 5505 | 2020-03-20 | Iberia | Louisiana | 22045 | 2 | 0 |
5506 | 5506 | 2020-03-20 | Iberville | Louisiana | 22047 | 1 | 0 |
5508 | 5508 | 2020-03-20 | Lafayette | Louisiana | 22055 | 6 | 0 |
5509 | 5509 | 2020-03-20 | Lafourche | Louisiana | 22057 | 5 | 0 |
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);