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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- 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
- …
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 |
1247 | 1247 | 2020-03-11 | Caddo | Louisiana | 22017 | 1 | 0 |
1248 | 1248 | 2020-03-11 | Jefferson | Louisiana | 22051 | 1 | 0 |
1464 | 1464 | 2020-03-12 | Caddo | Louisiana | 22017 | 1 | 0 |
1465 | 1465 | 2020-03-12 | Jefferson | Louisiana | 22051 | 1 | 0 |
1737 | 1737 | 2020-03-13 | Caddo | Louisiana | 22017 | 1 | 0 |
1740 | 1740 | 2020-03-13 | St. Charles | Louisiana | 22089 | 1 | 0 |
1742 | 1742 | 2020-03-13 | Terrebonne | Louisiana | 22109 | 1 | 0 |
2074 | 2074 | 2020-03-14 | Bossier | Louisiana | 22015 | 1 | 0 |
2077 | 2077 | 2020-03-14 | Lafourche | Louisiana | 22057 | 1 | 0 |
2080 | 2080 | 2020-03-14 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
2471 | 2471 | 2020-03-15 | Bossier | Louisiana | 22015 | 1 | 0 |
2474 | 2474 | 2020-03-15 | Lafourche | Louisiana | 22057 | 1 | 0 |
2476 | 2476 | 2020-03-15 | St. Bernard | Louisiana | 22087 | 1 | 0 |
2478 | 2478 | 2020-03-15 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
2916 | 2916 | 2020-03-16 | Ascension | Louisiana | 22005 | 1 | 0 |
2917 | 2917 | 2020-03-16 | Bossier | Louisiana | 22015 | 1 | 0 |
2924 | 2924 | 2020-03-16 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
3412 | 3412 | 2020-03-17 | Ascension | Louisiana | 22005 | 1 | 0 |
3413 | 3413 | 2020-03-17 | Bossier | Louisiana | 22015 | 1 | 0 |
3415 | 3415 | 2020-03-17 | East Baton Rouge | Louisiana | 22033 | 1 | 0 |
3421 | 3421 | 2020-03-17 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
3424 | 3424 | 2020-03-17 | Washington | Louisiana | 22117 | 1 | 0 |
3992 | 3992 | 2020-03-18 | Ascension | Louisiana | 22005 | 1 | 0 |
4005 | 4005 | 2020-03-18 | Washington | Louisiana | 22117 | 1 | 0 |
4684 | 4684 | 2020-03-19 | Assumption | Louisiana | 22007 | 1 | 0 |
4687 | 4687 | 2020-03-19 | Calcasieu | Louisiana | 22019 | 1 | 0 |
4689 | 4689 | 2020-03-19 | Iberia | Louisiana | 22045 | 1 | 0 |
4690 | 4690 | 2020-03-19 | Iberville | Louisiana | 22047 | 1 | 0 |
4694 | 4694 | 2020-03-19 | Livingston | Louisiana | 22063 | 1 | 0 |
4696 | 4696 | 2020-03-19 | Plaquemines | Louisiana | 22075 | 1 | 0 |
4699 | 4699 | 2020-03-19 | St. James | Louisiana | 22093 | 1 | 1 |
4706 | 4706 | 2020-03-19 | Webster | Louisiana | 22119 | 1 | 0 |
5498 | 5498 | 2020-03-20 | Assumption | Louisiana | 22007 | 1 | 0 |
5502 | 5502 | 2020-03-20 | Catahoula | Louisiana | 22025 | 1 | 0 |
5506 | 5506 | 2020-03-20 | Iberville | Louisiana | 22047 | 1 | 0 |
5510 | 5510 | 2020-03-20 | Livingston | Louisiana | 22063 | 1 | 0 |
5512 | 5512 | 2020-03-20 | Plaquemines | Louisiana | 22075 | 1 | 0 |
5516 | 5516 | 2020-03-20 | St. James | Louisiana | 22093 | 1 | 1 |
5520 | 5520 | 2020-03-20 | Tangipahoa | Louisiana | 22105 | 1 | 0 |
5524 | 5524 | 2020-03-20 | Webster | Louisiana | 22119 | 1 | 0 |
6446 | 6446 | 2020-03-21 | Assumption | Louisiana | 22007 | 1 | 0 |
6447 | 6447 | 2020-03-21 | Avoyelles | Louisiana | 22009 | 1 | 0 |
6448 | 6448 | 2020-03-21 | Beauregard | Louisiana | 22011 | 1 | 0 |
6449 | 6449 | 2020-03-21 | Bienville | Louisiana | 22013 | 1 | 0 |
6453 | 6453 | 2020-03-21 | Catahoula | Louisiana | 22025 | 1 | 0 |
6454 | 6454 | 2020-03-21 | Claiborne | Louisiana | 22027 | 1 | 0 |
6459 | 6459 | 2020-03-21 | Iberville | Louisiana | 22047 | 1 | 0 |
6470 | 6470 | 2020-03-21 | St. James | Louisiana | 22093 | 1 | 1 |
6473 | 6473 | 2020-03-21 | St. Mary | Louisiana | 22101 | 1 | 0 |
6479 | 6479 | 2020-03-21 | Webster | Louisiana | 22119 | 1 | 0 |
7519 | 7519 | 2020-03-22 | Acadia | Louisiana | 22001 | 1 | 0 |
7521 | 7521 | 2020-03-22 | Assumption | Louisiana | 22007 | 1 | 0 |
7522 | 7522 | 2020-03-22 | Avoyelles | Louisiana | 22009 | 1 | 0 |
7523 | 7523 | 2020-03-22 | Beauregard | Louisiana | 22011 | 1 | 0 |
7524 | 7524 | 2020-03-22 | Bienville | Louisiana | 22013 | 1 | 0 |
7528 | 7528 | 2020-03-22 | Catahoula | Louisiana | 22025 | 1 | 1 |
7529 | 7529 | 2020-03-22 | Claiborne | Louisiana | 22027 | 1 | 0 |
7534 | 7534 | 2020-03-22 | Iberville | Louisiana | 22047 | 1 | 0 |
7545 | 7545 | 2020-03-22 | St. James | Louisiana | 22093 | 1 | 1 |
7548 | 7548 | 2020-03-22 | St. Mary | Louisiana | 22101 | 1 | 0 |
7554 | 7554 | 2020-03-22 | Webster | Louisiana | 22119 | 1 | 0 |
8682 | 8682 | 2020-03-23 | Acadia | Louisiana | 22001 | 1 | 0 |
8685 | 8685 | 2020-03-23 | Assumption | Louisiana | 22007 | 1 | 0 |
8687 | 8687 | 2020-03-23 | Beauregard | Louisiana | 22011 | 1 | 0 |
8688 | 8688 | 2020-03-23 | Bienville | Louisiana | 22013 | 1 | 0 |
8692 | 8692 | 2020-03-23 | Catahoula | Louisiana | 22025 | 1 | 1 |
8697 | 8697 | 2020-03-23 | Grant | Louisiana | 22043 | 1 | 0 |
8710 | 8710 | 2020-03-23 | Richland | Louisiana | 22083 | 1 | 0 |
8716 | 8716 | 2020-03-23 | St. Martin | Louisiana | 22099 | 1 | 0 |
8717 | 8717 | 2020-03-23 | St. Mary | Louisiana | 22101 | 1 | 0 |
9976 | 9976 | 2020-03-24 | Bienville | Louisiana | 22013 | 1 | 0 |
9980 | 9980 | 2020-03-24 | Catahoula | Louisiana | 22025 | 1 | 1 |
9985 | 9985 | 2020-03-24 | Grant | Louisiana | 22043 | 1 | 0 |
9998 | 9998 | 2020-03-24 | Richland | Louisiana | 22083 | 1 | 0 |
10004 | 10004 | 2020-03-24 | St. Martin | Louisiana | 22099 | 1 | 0 |
11380 | 11380 | 2020-03-25 | Bienville | Louisiana | 22013 | 1 | 1 |
11384 | 11384 | 2020-03-25 | Catahoula | Louisiana | 22025 | 1 | 1 |
11389 | 11389 | 2020-03-25 | Grant | Louisiana | 22043 | 1 | 0 |
11392 | 11392 | 2020-03-25 | Jackson | Louisiana | 22049 | 1 | 0 |
11394 | 11394 | 2020-03-25 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
11399 | 11399 | 2020-03-25 | Morehouse | Louisiana | 22067 | 1 | 0 |
11405 | 11405 | 2020-03-25 | Richland | Louisiana | 22083 | 1 | 0 |
11411 | 11411 | 2020-03-25 | St. Martin | Louisiana | 22099 | 1 | 0 |
11422 | 11422 | 2020-03-25 | Winn | Louisiana | 22127 | 1 | 0 |
12955 | 12955 | 2020-03-26 | Bienville | Louisiana | 22013 | 1 | 1 |
12959 | 12959 | 2020-03-26 | Catahoula | Louisiana | 22025 | 1 | 1 |
12965 | 12965 | 2020-03-26 | Grant | Louisiana | 22043 | 1 | 0 |
12968 | 12968 | 2020-03-26 | Jackson | Louisiana | 22049 | 1 | 0 |
12970 | 12970 | 2020-03-26 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
12971 | 12971 | 2020-03-26 | LaSalle | Louisiana | 22059 | 1 | 0 |
12976 | 12976 | 2020-03-26 | Madison | Louisiana | 22065 | 1 | 0 |
12982 | 12982 | 2020-03-26 | Pointe Coupee | Louisiana | 22077 | 1 | 0 |
12984 | 12984 | 2020-03-26 | Richland | Louisiana | 22083 | 1 | 0 |
12997 | 12997 | 2020-03-26 | Vermilion | Louisiana | 22113 | 1 | 0 |
13002 | 13002 | 2020-03-26 | Winn | Louisiana | 22127 | 1 | 0 |
14662 | 14662 | 2020-03-27 | Bienville | Louisiana | 22013 | 1 | 1 |
14666 | 14666 | 2020-03-27 | Catahoula | Louisiana | 22025 | 1 | 1 |
14672 | 14672 | 2020-03-27 | Grant | Louisiana | 22043 | 1 | 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);