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
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 |
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 |
2078 | 2078 | 2020-03-14 | Orleans | Louisiana | 22071 | 53 | 1 |
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 |
2475 | 2475 | 2020-03-15 | Orleans | Louisiana | 22071 | 75 | 2 |
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 |
2921 | 2921 | 2020-03-16 | Orleans | Louisiana | 22071 | 95 | 3 |
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 |
3418 | 3418 | 2020-03-17 | Orleans | Louisiana | 22071 | 136 | 5 |
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 |
3996 | 3996 | 2020-03-18 | Jefferson | Louisiana | 22051 | 45 | 1 |
3997 | 3997 | 2020-03-18 | Lafourche | Louisiana | 22057 | 3 | 0 |
3998 | 3998 | 2020-03-18 | Orleans | Louisiana | 22071 | 196 | 6 |
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 |
4691 | 4691 | 2020-03-19 | Jefferson | Louisiana | 22051 | 69 | 1 |
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 |
4695 | 4695 | 2020-03-19 | Orleans | Louisiana | 22071 | 252 | 8 |
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 |
4699 | 4699 | 2020-03-19 | St. James | Louisiana | 22093 | 1 | 1 |
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 |
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);