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)
fips >30
county >30
- Orleans 795
- Jefferson 792
- St. Tammany 792
- Caddo 791
- St. Charles 791
- Terrebonne 791
- Lafourche 789
- St. Bernard 789
- Bossier 787
- East Baton Rouge 787
- St. John the Baptist 787
- Ascension 786
- Lafayette 786
- St. Landry 786
- Unknown 786
- Washington 786
- West Baton Rouge 786
- Calcasieu 785
- De Soto 785
- Iberia 785
- Rapides 785
- Evangeline 784
- Livingston 784
- Ouachita 784
- Plaquemines 784
- Tangipahoa 784
- Allen 782
- Avoyelles 782
- Claiborne 782
- Iberville 782
- …
state 1
- Louisiana · 50,802 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
14677 | 14677 | 2020-03-27 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
14678 | 14678 | 2020-03-27 | LaSalle | Louisiana | 22059 | 1 | 0 |
14683 | 14683 | 2020-03-27 | Madison | Louisiana | 22065 | 1 | 0 |
14689 | 14689 | 2020-03-27 | Pointe Coupee | Louisiana | 22077 | 1 | 0 |
14709 | 14709 | 2020-03-27 | West Feliciana | Louisiana | 22125 | 1 | 0 |
14710 | 14710 | 2020-03-27 | Winn | Louisiana | 22127 | 1 | 0 |
16484 | 16484 | 2020-03-28 | Catahoula | Louisiana | 22025 | 1 | 1 |
16488 | 16488 | 2020-03-28 | East Carroll | Louisiana | 22035 | 1 | 0 |
16492 | 16492 | 2020-03-28 | Grant | Louisiana | 22043 | 1 | 0 |
16497 | 16497 | 2020-03-28 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
16503 | 16503 | 2020-03-28 | Madison | Louisiana | 22065 | 1 | 0 |
16530 | 16530 | 2020-03-28 | Winn | Louisiana | 22127 | 1 | 0 |
18396 | 18396 | 2020-03-29 | Catahoula | Louisiana | 22025 | 1 | 1 |
18400 | 18400 | 2020-03-29 | East Carroll | Louisiana | 22035 | 1 | 0 |
18415 | 18415 | 2020-03-29 | Madison | Louisiana | 22065 | 1 | 0 |
18423 | 18423 | 2020-03-29 | Red River | Louisiana | 22081 | 1 | 0 |
18425 | 18425 | 2020-03-29 | Sabine | Louisiana | 22085 | 1 | 0 |
18444 | 18444 | 2020-03-29 | Winn | Louisiana | 22127 | 1 | 0 |
20416 | 20416 | 2020-03-30 | East Carroll | Louisiana | 22035 | 1 | 0 |
20431 | 20431 | 2020-03-30 | Madison | Louisiana | 22065 | 1 | 0 |
20439 | 20439 | 2020-03-30 | Red River | Louisiana | 22081 | 1 | 0 |
20441 | 20441 | 2020-03-30 | Sabine | Louisiana | 22085 | 1 | 0 |
20460 | 20460 | 2020-03-30 | Winn | Louisiana | 22127 | 1 | 0 |
22524 | 22524 | 2020-03-31 | East Carroll | Louisiana | 22035 | 1 | 0 |
22539 | 22539 | 2020-03-31 | Madison | Louisiana | 22065 | 1 | 0 |
22547 | 22547 | 2020-03-31 | Red River | Louisiana | 22081 | 1 | 0 |
22552 | 22552 | 2020-03-31 | St. Helena | Louisiana | 22091 | 1 | 0 |
22569 | 22569 | 2020-03-31 | Winn | Louisiana | 22127 | 1 | 0 |
24700 | 24700 | 2020-04-01 | East Carroll | Louisiana | 22035 | 1 | 0 |
24715 | 24715 | 2020-04-01 | Madison | Louisiana | 22065 | 1 | 0 |
24723 | 24723 | 2020-04-01 | Red River | Louisiana | 22081 | 1 | 0 |
24728 | 24728 | 2020-04-01 | St. Helena | Louisiana | 22091 | 1 | 0 |
24745 | 24745 | 2020-04-01 | Winn | Louisiana | 22127 | 1 | 0 |
26945 | 26945 | 2020-04-02 | Caldwell | Louisiana | 22021 | 1 | 0 |
26951 | 26951 | 2020-04-02 | East Carroll | Louisiana | 22035 | 1 | 0 |
26966 | 26966 | 2020-04-02 | Madison | Louisiana | 22065 | 1 | 0 |
26974 | 26974 | 2020-04-02 | Red River | Louisiana | 22081 | 1 | 0 |
26979 | 26979 | 2020-04-02 | St. Helena | Louisiana | 22091 | 1 | 0 |
29262 | 29262 | 2020-04-03 | Caldwell | Louisiana | 22021 | 1 | 0 |
29268 | 29268 | 2020-04-03 | East Carroll | Louisiana | 22035 | 1 | 0 |
29283 | 29283 | 2020-04-03 | Madison | Louisiana | 22065 | 1 | 0 |
29296 | 29296 | 2020-04-03 | St. Helena | Louisiana | 22091 | 1 | 0 |
31646 | 31646 | 2020-04-04 | East Carroll | Louisiana | 22035 | 1 | 0 |
31653 | 31653 | 2020-04-04 | Jackson | Louisiana | 22049 | 1 | 0 |
31661 | 31661 | 2020-04-04 | Madison | Louisiana | 22065 | 1 | 0 |
34071 | 34071 | 2020-04-05 | East Carroll | Louisiana | 22035 | 1 | 0 |
34078 | 34078 | 2020-04-05 | Jackson | Louisiana | 22049 | 1 | 0 |
34086 | 34086 | 2020-04-05 | Madison | Louisiana | 22065 | 1 | 0 |
36529 | 36529 | 2020-04-06 | East Carroll | Louisiana | 22035 | 1 | 0 |
36544 | 36544 | 2020-04-06 | Madison | Louisiana | 22065 | 1 | 0 |
36573 | 36573 | 2020-04-06 | West Carroll | Louisiana | 22123 | 1 | 0 |
39031 | 39031 | 2020-04-07 | Cameron | Louisiana | 22023 | 1 | 0 |
39037 | 39037 | 2020-04-07 | East Carroll | Louisiana | 22035 | 1 | 0 |
39081 | 39081 | 2020-04-07 | West Carroll | Louisiana | 22123 | 1 | 0 |
41583 | 41583 | 2020-04-08 | Cameron | Louisiana | 22023 | 1 | 0 |
41589 | 41589 | 2020-04-08 | East Carroll | Louisiana | 22035 | 1 | 0 |
41633 | 41633 | 2020-04-08 | West Carroll | Louisiana | 22123 | 1 | 0 |
44159 | 44159 | 2020-04-09 | Cameron | Louisiana | 22023 | 1 | 0 |
44165 | 44165 | 2020-04-09 | East Carroll | Louisiana | 22035 | 1 | 0 |
44209 | 44209 | 2020-04-09 | West Carroll | Louisiana | 22123 | 1 | 0 |
46767 | 46767 | 2020-04-10 | Cameron | Louisiana | 22023 | 1 | 0 |
46773 | 46773 | 2020-04-10 | East Carroll | Louisiana | 22035 | 1 | 0 |
49414 | 49414 | 2020-04-11 | East Carroll | Louisiana | 22035 | 1 | 0 |
49450 | 49450 | 2020-04-11 | Tensas | Louisiana | 22107 | 1 | 0 |
52084 | 52084 | 2020-04-12 | East Carroll | Louisiana | 22035 | 1 | 0 |
52120 | 52120 | 2020-04-12 | Tensas | Louisiana | 22107 | 1 | 0 |
54765 | 54765 | 2020-04-13 | East Carroll | Louisiana | 22035 | 1 | 0 |
54801 | 54801 | 2020-04-13 | Tensas | Louisiana | 22107 | 1 | 0 |
57463 | 57463 | 2020-04-14 | East Carroll | Louisiana | 22035 | 1 | 0 |
57499 | 57499 | 2020-04-14 | Tensas | Louisiana | 22107 | 1 | 0 |
60171 | 60171 | 2020-04-15 | East Carroll | Louisiana | 22035 | 1 | 0 |
60207 | 60207 | 2020-04-15 | Tensas | Louisiana | 22107 | 1 | 0 |
62892 | 62892 | 2020-04-16 | East Carroll | Louisiana | 22035 | 1 | 0 |
62928 | 62928 | 2020-04-16 | Tensas | Louisiana | 22107 | 1 | 0 |
65631 | 65631 | 2020-04-17 | East Carroll | Louisiana | 22035 | 1 | 0 |
65667 | 65667 | 2020-04-17 | Tensas | Louisiana | 22107 | 1 | 0 |
68380 | 68380 | 2020-04-18 | East Carroll | Louisiana | 22035 | 1 | 0 |
68416 | 68416 | 2020-04-18 | Tensas | Louisiana | 22107 | 1 | 0 |
71143 | 71143 | 2020-04-19 | East Carroll | Louisiana | 22035 | 1 | 0 |
71179 | 71179 | 2020-04-19 | Tensas | Louisiana | 22107 | 1 | 0 |
73915 | 73915 | 2020-04-20 | East Carroll | Louisiana | 22035 | 1 | 0 |
73951 | 73951 | 2020-04-20 | Tensas | Louisiana | 22107 | 1 | 0 |
76695 | 76695 | 2020-04-21 | East Carroll | Louisiana | 22035 | 1 | 0 |
76731 | 76731 | 2020-04-21 | Tensas | Louisiana | 22107 | 1 | 0 |
79517 | 79517 | 2020-04-22 | Tensas | Louisiana | 22107 | 1 | 0 |
82313 | 82313 | 2020-04-23 | Tensas | Louisiana | 22107 | 1 | 0 |
85117 | 85117 | 2020-04-24 | Tensas | Louisiana | 22107 | 1 | 0 |
87926 | 87926 | 2020-04-25 | Tensas | Louisiana | 22107 | 1 | 0 |
90742 | 90742 | 2020-04-26 | Tensas | Louisiana | 22107 | 1 | 0 |
93563 | 93563 | 2020-04-27 | Tensas | Louisiana | 22107 | 1 | 0 |
96398 | 96398 | 2020-04-28 | Tensas | Louisiana | 22107 | 1 | 0 |
99244 | 99244 | 2020-04-29 | Tensas | Louisiana | 22107 | 1 | 0 |
102096 | 102096 | 2020-04-30 | Tensas | Louisiana | 22107 | 1 | 0 |
104957 | 104957 | 2020-05-01 | Tensas | Louisiana | 22107 | 1 | 0 |
1741 | 1741 | 2020-03-13 | St. Tammany | Louisiana | 22103 | 2 | 0 |
2075 | 2075 | 2020-03-14 | Caddo | Louisiana | 22017 | 2 | 0 |
2079 | 2079 | 2020-03-14 | St. Charles | Louisiana | 22089 | 2 | 0 |
2082 | 2082 | 2020-03-14 | Terrebonne | Louisiana | 22109 | 2 | 0 |
2472 | 2472 | 2020-03-15 | Caddo | Louisiana | 22017 | 2 | 0 |
2477 | 2477 | 2020-03-15 | St. Charles | Louisiana | 22089 | 2 | 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);