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 county
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 |
---|---|---|---|---|---|---|---|
7519 | 7519 | 2020-03-22 | Acadia | Louisiana | 22001 | 1 | 0 |
8682 | 8682 | 2020-03-23 | Acadia | Louisiana | 22001 | 1 | 0 |
9970 | 9970 | 2020-03-24 | Acadia | Louisiana | 22001 | 2 | 0 |
11374 | 11374 | 2020-03-25 | Acadia | Louisiana | 22001 | 2 | 0 |
12949 | 12949 | 2020-03-26 | Acadia | Louisiana | 22001 | 3 | 0 |
14656 | 14656 | 2020-03-27 | Acadia | Louisiana | 22001 | 8 | 1 |
16474 | 16474 | 2020-03-28 | Acadia | Louisiana | 22001 | 9 | 1 |
18386 | 18386 | 2020-03-29 | Acadia | Louisiana | 22001 | 9 | 1 |
20402 | 20402 | 2020-03-30 | Acadia | Louisiana | 22001 | 11 | 1 |
22509 | 22509 | 2020-03-31 | Acadia | Louisiana | 22001 | 39 | 1 |
24685 | 24685 | 2020-04-01 | Acadia | Louisiana | 22001 | 47 | 1 |
26935 | 26935 | 2020-04-02 | Acadia | Louisiana | 22001 | 61 | 1 |
29252 | 29252 | 2020-04-03 | Acadia | Louisiana | 22001 | 72 | 1 |
31630 | 31630 | 2020-04-04 | Acadia | Louisiana | 22001 | 65 | 2 |
34055 | 34055 | 2020-04-05 | Acadia | Louisiana | 22001 | 75 | 2 |
36513 | 36513 | 2020-04-06 | Acadia | Louisiana | 22001 | 79 | 2 |
39020 | 39020 | 2020-04-07 | Acadia | Louisiana | 22001 | 82 | 2 |
41572 | 41572 | 2020-04-08 | Acadia | Louisiana | 22001 | 86 | 2 |
44148 | 44148 | 2020-04-09 | Acadia | Louisiana | 22001 | 89 | 3 |
46756 | 46756 | 2020-04-10 | Acadia | Louisiana | 22001 | 94 | 4 |
49397 | 49397 | 2020-04-11 | Acadia | Louisiana | 22001 | 98 | 4 |
52067 | 52067 | 2020-04-12 | Acadia | Louisiana | 22001 | 99 | 5 |
54748 | 54748 | 2020-04-13 | Acadia | Louisiana | 22001 | 101 | 5 |
57446 | 57446 | 2020-04-14 | Acadia | Louisiana | 22001 | 104 | 5 |
60154 | 60154 | 2020-04-15 | Acadia | Louisiana | 22001 | 105 | 5 |
62875 | 62875 | 2020-04-16 | Acadia | Louisiana | 22001 | 108 | 6 |
65614 | 65614 | 2020-04-17 | Acadia | Louisiana | 22001 | 110 | 6 |
68363 | 68363 | 2020-04-18 | Acadia | Louisiana | 22001 | 110 | 7 |
71126 | 71126 | 2020-04-19 | Acadia | Louisiana | 22001 | 110 | 7 |
73898 | 73898 | 2020-04-20 | Acadia | Louisiana | 22001 | 114 | 7 |
76678 | 76678 | 2020-04-21 | Acadia | Louisiana | 22001 | 114 | 7 |
79464 | 79464 | 2020-04-22 | Acadia | Louisiana | 22001 | 117 | 7 |
82260 | 82260 | 2020-04-23 | Acadia | Louisiana | 22001 | 117 | 7 |
85064 | 85064 | 2020-04-24 | Acadia | Louisiana | 22001 | 129 | 7 |
87873 | 87873 | 2020-04-25 | Acadia | Louisiana | 22001 | 130 | 7 |
90689 | 90689 | 2020-04-26 | Acadia | Louisiana | 22001 | 130 | 7 |
93510 | 93510 | 2020-04-27 | Acadia | Louisiana | 22001 | 130 | 9 |
96345 | 96345 | 2020-04-28 | Acadia | Louisiana | 22001 | 130 | 9 |
99191 | 99191 | 2020-04-29 | Acadia | Louisiana | 22001 | 130 | 9 |
102043 | 102043 | 2020-04-30 | Acadia | Louisiana | 22001 | 130 | 10 |
104904 | 104904 | 2020-05-01 | Acadia | Louisiana | 22001 | 133 | 10 |
107768 | 107768 | 2020-05-02 | Acadia | Louisiana | 22001 | 133 | 10 |
110640 | 110640 | 2020-05-03 | Acadia | Louisiana | 22001 | 134 | 10 |
113517 | 113517 | 2020-05-04 | Acadia | Louisiana | 22001 | 134 | 10 |
116399 | 116399 | 2020-05-05 | Acadia | Louisiana | 22001 | 136 | 10 |
119360 | 119360 | 2020-05-06 | Acadia | Louisiana | 22001 | 140 | 10 |
122331 | 122331 | 2020-05-07 | Acadia | Louisiana | 22001 | 142 | 11 |
125313 | 125313 | 2020-05-08 | Acadia | Louisiana | 22001 | 142 | 11 |
128300 | 128300 | 2020-05-09 | Acadia | Louisiana | 22001 | 151 | 11 |
131290 | 131290 | 2020-05-10 | Acadia | Louisiana | 22001 | 148 | 11 |
134281 | 134281 | 2020-05-11 | Acadia | Louisiana | 22001 | 152 | 11 |
137271 | 137271 | 2020-05-12 | Acadia | Louisiana | 22001 | 152 | 11 |
140265 | 140265 | 2020-05-13 | Acadia | Louisiana | 22001 | 151 | 11 |
143260 | 143260 | 2020-05-14 | Acadia | Louisiana | 22001 | 159 | 11 |
146260 | 146260 | 2020-05-15 | Acadia | Louisiana | 22001 | 189 | 11 |
149265 | 149265 | 2020-05-16 | Acadia | Louisiana | 22001 | 192 | 11 |
152276 | 152276 | 2020-05-17 | Acadia | Louisiana | 22001 | 198 | 12 |
155290 | 155290 | 2020-05-18 | Acadia | Louisiana | 22001 | 257 | 12 |
158308 | 158308 | 2020-05-19 | Acadia | Louisiana | 22001 | 262 | 12 |
161334 | 161334 | 2020-05-20 | Acadia | Louisiana | 22001 | 262 | 12 |
164363 | 164363 | 2020-05-21 | Acadia | Louisiana | 22001 | 269 | 15 |
167399 | 167399 | 2020-05-22 | Acadia | Louisiana | 22001 | 289 | 15 |
170437 | 170437 | 2020-05-23 | Acadia | Louisiana | 22001 | 290 | 17 |
173478 | 173478 | 2020-05-24 | Acadia | Louisiana | 22001 | 291 | 17 |
176522 | 176522 | 2020-05-25 | Acadia | Louisiana | 22001 | 299 | 17 |
179566 | 179566 | 2020-05-26 | Acadia | Louisiana | 22001 | 395 | 18 |
182611 | 182611 | 2020-05-27 | Acadia | Louisiana | 22001 | 397 | 18 |
185666 | 185666 | 2020-05-28 | Acadia | Louisiana | 22001 | 401 | 22 |
188724 | 188724 | 2020-05-29 | Acadia | Louisiana | 22001 | 401 | 23 |
191788 | 191788 | 2020-05-30 | Acadia | Louisiana | 22001 | 412 | 23 |
194856 | 194856 | 2020-05-31 | Acadia | Louisiana | 22001 | 418 | 23 |
197927 | 197927 | 2020-06-01 | Acadia | Louisiana | 22001 | 422 | 23 |
200999 | 200999 | 2020-06-02 | Acadia | Louisiana | 22001 | 428 | 24 |
204076 | 204076 | 2020-06-03 | Acadia | Louisiana | 22001 | 446 | 26 |
207157 | 207157 | 2020-06-04 | Acadia | Louisiana | 22001 | 462 | 26 |
210238 | 210238 | 2020-06-05 | Acadia | Louisiana | 22001 | 467 | 26 |
213323 | 213323 | 2020-06-06 | Acadia | Louisiana | 22001 | 500 | 27 |
216410 | 216410 | 2020-06-07 | Acadia | Louisiana | 22001 | 502 | 28 |
219502 | 219502 | 2020-06-08 | Acadia | Louisiana | 22001 | 513 | 29 |
222597 | 222597 | 2020-06-09 | Acadia | Louisiana | 22001 | 517 | 29 |
225693 | 225693 | 2020-06-10 | Acadia | Louisiana | 22001 | 520 | 29 |
228795 | 228795 | 2020-06-11 | Acadia | Louisiana | 22001 | 529 | 31 |
231899 | 231899 | 2020-06-12 | Acadia | Louisiana | 22001 | 535 | 31 |
235004 | 235004 | 2020-06-13 | Acadia | Louisiana | 22001 | 577 | 31 |
238111 | 238111 | 2020-06-14 | Acadia | Louisiana | 22001 | 583 | 31 |
241220 | 241220 | 2020-06-15 | Acadia | Louisiana | 22001 | 597 | 31 |
244331 | 244331 | 2020-06-16 | Acadia | Louisiana | 22001 | 604 | 32 |
247444 | 247444 | 2020-06-17 | Acadia | Louisiana | 22001 | 625 | 32 |
250556 | 250556 | 2020-06-18 | Acadia | Louisiana | 22001 | 625 | 32 |
253671 | 253671 | 2020-06-19 | Acadia | Louisiana | 22001 | 639 | 32 |
256791 | 256791 | 2020-06-20 | Acadia | Louisiana | 22001 | 646 | 32 |
259917 | 259917 | 2020-06-21 | Acadia | Louisiana | 22001 | 654 | 32 |
263046 | 263046 | 2020-06-22 | Acadia | Louisiana | 22001 | 669 | 34 |
266173 | 266173 | 2020-06-23 | Acadia | Louisiana | 22001 | 705 | 34 |
269306 | 269306 | 2020-06-24 | Acadia | Louisiana | 22001 | 726 | 35 |
272442 | 272442 | 2020-06-25 | Acadia | Louisiana | 22001 | 745 | 35 |
275585 | 275585 | 2020-06-26 | Acadia | Louisiana | 22001 | 783 | 36 |
278733 | 278733 | 2020-06-27 | Acadia | Louisiana | 22001 | 783 | 36 |
281881 | 281881 | 2020-06-28 | Acadia | Louisiana | 22001 | 812 | 36 |
285027 | 285027 | 2020-06-29 | Acadia | Louisiana | 22001 | 850 | 37 |
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);