ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
538 rows where deaths = 3 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Caldwell 94
- Catahoula 82
- Tensas 68
- Cameron 42
- Richland 31
- Vernon 28
- Vermilion 20
- East Carroll 14
- Grant 12
- West Carroll 12
- Beauregard 11
- Franklin 8
- St. Martin 8
- West Feliciana 7
- Avoyelles 6
- Union 6
- Madison 5
- Sabine 5
- Winn 5
- Assumption 4
- Calcasieu 4
- Concordia 4
- Jackson 4
- Red River 4
- St. Helena 4
- St. James 4
- Allen 3
- Claiborne 3
- Iberia 3
- Jefferson Davis 3
- …
state 1
- Louisiana · 538 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921611 | 921611 | 2021-01-12 | Tensas | Louisiana | 22107 | 292 | 3 |
918366 | 918366 | 2021-01-11 | Tensas | Louisiana | 22107 | 289 | 3 |
915121 | 915121 | 2021-01-10 | Tensas | Louisiana | 22107 | 289 | 3 |
911876 | 911876 | 2021-01-09 | Tensas | Louisiana | 22107 | 289 | 3 |
908631 | 908631 | 2021-01-08 | Tensas | Louisiana | 22107 | 289 | 3 |
905385 | 905385 | 2021-01-07 | Tensas | Louisiana | 22107 | 285 | 3 |
902140 | 902140 | 2021-01-06 | Tensas | Louisiana | 22107 | 283 | 3 |
898895 | 898895 | 2021-01-05 | Tensas | Louisiana | 22107 | 279 | 3 |
895650 | 895650 | 2021-01-04 | Tensas | Louisiana | 22107 | 273 | 3 |
892403 | 892403 | 2021-01-03 | Tensas | Louisiana | 22107 | 273 | 3 |
889157 | 889157 | 2021-01-02 | Tensas | Louisiana | 22107 | 273 | 3 |
885911 | 885911 | 2021-01-01 | Tensas | Louisiana | 22107 | 273 | 3 |
882666 | 882666 | 2020-12-31 | Tensas | Louisiana | 22107 | 273 | 3 |
879421 | 879421 | 2020-12-30 | Tensas | Louisiana | 22107 | 267 | 3 |
876176 | 876176 | 2020-12-29 | Tensas | Louisiana | 22107 | 265 | 3 |
872931 | 872931 | 2020-12-28 | Tensas | Louisiana | 22107 | 264 | 3 |
869686 | 869686 | 2020-12-27 | Tensas | Louisiana | 22107 | 264 | 3 |
866441 | 866441 | 2020-12-26 | Tensas | Louisiana | 22107 | 263 | 3 |
863196 | 863196 | 2020-12-25 | Tensas | Louisiana | 22107 | 263 | 3 |
859951 | 859951 | 2020-12-24 | Tensas | Louisiana | 22107 | 263 | 3 |
856706 | 856706 | 2020-12-23 | Tensas | Louisiana | 22107 | 264 | 3 |
853461 | 853461 | 2020-12-22 | Tensas | Louisiana | 22107 | 263 | 3 |
850216 | 850216 | 2020-12-21 | Tensas | Louisiana | 22107 | 256 | 3 |
846971 | 846971 | 2020-12-20 | Tensas | Louisiana | 22107 | 257 | 3 |
843725 | 843725 | 2020-12-19 | Tensas | Louisiana | 22107 | 253 | 3 |
840480 | 840480 | 2020-12-18 | Tensas | Louisiana | 22107 | 253 | 3 |
837235 | 837235 | 2020-12-17 | Tensas | Louisiana | 22107 | 250 | 3 |
833989 | 833989 | 2020-12-16 | Tensas | Louisiana | 22107 | 247 | 3 |
830700 | 830700 | 2020-12-15 | Cameron | Louisiana | 22023 | 343 | 3 |
830742 | 830742 | 2020-12-15 | Tensas | Louisiana | 22107 | 245 | 3 |
827454 | 827454 | 2020-12-14 | Cameron | Louisiana | 22023 | 332 | 3 |
827496 | 827496 | 2020-12-14 | Tensas | Louisiana | 22107 | 239 | 3 |
824207 | 824207 | 2020-12-13 | Cameron | Louisiana | 22023 | 332 | 3 |
824249 | 824249 | 2020-12-13 | Tensas | Louisiana | 22107 | 240 | 3 |
820961 | 820961 | 2020-12-12 | Cameron | Louisiana | 22023 | 332 | 3 |
821003 | 821003 | 2020-12-12 | Tensas | Louisiana | 22107 | 234 | 3 |
817715 | 817715 | 2020-12-11 | Cameron | Louisiana | 22023 | 332 | 3 |
817757 | 817757 | 2020-12-11 | Tensas | Louisiana | 22107 | 234 | 3 |
814469 | 814469 | 2020-12-10 | Cameron | Louisiana | 22023 | 332 | 3 |
814511 | 814511 | 2020-12-10 | Tensas | Louisiana | 22107 | 231 | 3 |
811224 | 811224 | 2020-12-09 | Cameron | Louisiana | 22023 | 326 | 3 |
811266 | 811266 | 2020-12-09 | Tensas | Louisiana | 22107 | 231 | 3 |
807979 | 807979 | 2020-12-08 | Cameron | Louisiana | 22023 | 318 | 3 |
808021 | 808021 | 2020-12-08 | Tensas | Louisiana | 22107 | 228 | 3 |
804734 | 804734 | 2020-12-07 | Cameron | Louisiana | 22023 | 312 | 3 |
804776 | 804776 | 2020-12-07 | Tensas | Louisiana | 22107 | 223 | 3 |
801489 | 801489 | 2020-12-06 | Cameron | Louisiana | 22023 | 313 | 3 |
801531 | 801531 | 2020-12-06 | Tensas | Louisiana | 22107 | 224 | 3 |
798244 | 798244 | 2020-12-05 | Cameron | Louisiana | 22023 | 305 | 3 |
798286 | 798286 | 2020-12-05 | Tensas | Louisiana | 22107 | 221 | 3 |
794999 | 794999 | 2020-12-04 | Cameron | Louisiana | 22023 | 305 | 3 |
795041 | 795041 | 2020-12-04 | Tensas | Louisiana | 22107 | 221 | 3 |
791754 | 791754 | 2020-12-03 | Cameron | Louisiana | 22023 | 304 | 3 |
791796 | 791796 | 2020-12-03 | Tensas | Louisiana | 22107 | 221 | 3 |
788509 | 788509 | 2020-12-02 | Cameron | Louisiana | 22023 | 304 | 3 |
788551 | 788551 | 2020-12-02 | Tensas | Louisiana | 22107 | 220 | 3 |
785265 | 785265 | 2020-12-01 | Cameron | Louisiana | 22023 | 296 | 3 |
785307 | 785307 | 2020-12-01 | Tensas | Louisiana | 22107 | 221 | 3 |
782020 | 782020 | 2020-11-30 | Cameron | Louisiana | 22023 | 286 | 3 |
782062 | 782062 | 2020-11-30 | Tensas | Louisiana | 22107 | 215 | 3 |
778774 | 778774 | 2020-11-29 | Cameron | Louisiana | 22023 | 290 | 3 |
778816 | 778816 | 2020-11-29 | Tensas | Louisiana | 22107 | 215 | 3 |
775529 | 775529 | 2020-11-28 | Cameron | Louisiana | 22023 | 288 | 3 |
775571 | 775571 | 2020-11-28 | Tensas | Louisiana | 22107 | 216 | 3 |
772284 | 772284 | 2020-11-27 | Cameron | Louisiana | 22023 | 288 | 3 |
772326 | 772326 | 2020-11-27 | Tensas | Louisiana | 22107 | 216 | 3 |
769039 | 769039 | 2020-11-26 | Cameron | Louisiana | 22023 | 287 | 3 |
769081 | 769081 | 2020-11-26 | Tensas | Louisiana | 22107 | 212 | 3 |
765793 | 765793 | 2020-11-25 | Cameron | Louisiana | 22023 | 287 | 3 |
765835 | 765835 | 2020-11-25 | Tensas | Louisiana | 22107 | 212 | 3 |
762548 | 762548 | 2020-11-24 | Cameron | Louisiana | 22023 | 286 | 3 |
762590 | 762590 | 2020-11-24 | Tensas | Louisiana | 22107 | 212 | 3 |
759303 | 759303 | 2020-11-23 | Cameron | Louisiana | 22023 | 274 | 3 |
759345 | 759345 | 2020-11-23 | Tensas | Louisiana | 22107 | 206 | 3 |
756056 | 756056 | 2020-11-22 | Cameron | Louisiana | 22023 | 272 | 3 |
756098 | 756098 | 2020-11-22 | Tensas | Louisiana | 22107 | 206 | 3 |
752810 | 752810 | 2020-11-21 | Cameron | Louisiana | 22023 | 272 | 3 |
752852 | 752852 | 2020-11-21 | Tensas | Louisiana | 22107 | 205 | 3 |
749564 | 749564 | 2020-11-20 | Cameron | Louisiana | 22023 | 272 | 3 |
749606 | 749606 | 2020-11-20 | Tensas | Louisiana | 22107 | 205 | 3 |
746318 | 746318 | 2020-11-19 | Cameron | Louisiana | 22023 | 271 | 3 |
746360 | 746360 | 2020-11-19 | Tensas | Louisiana | 22107 | 203 | 3 |
743071 | 743071 | 2020-11-18 | Cameron | Louisiana | 22023 | 265 | 3 |
743113 | 743113 | 2020-11-18 | Tensas | Louisiana | 22107 | 203 | 3 |
739824 | 739824 | 2020-11-17 | Cameron | Louisiana | 22023 | 268 | 3 |
739866 | 739866 | 2020-11-17 | Tensas | Louisiana | 22107 | 202 | 3 |
736580 | 736580 | 2020-11-16 | Cameron | Louisiana | 22023 | 263 | 3 |
736622 | 736622 | 2020-11-16 | Tensas | Louisiana | 22107 | 196 | 3 |
733334 | 733334 | 2020-11-15 | Cameron | Louisiana | 22023 | 261 | 3 |
733376 | 733376 | 2020-11-15 | Tensas | Louisiana | 22107 | 196 | 3 |
730089 | 730089 | 2020-11-14 | Cameron | Louisiana | 22023 | 260 | 3 |
730131 | 730131 | 2020-11-14 | Tensas | Louisiana | 22107 | 193 | 3 |
726846 | 726846 | 2020-11-13 | Cameron | Louisiana | 22023 | 260 | 3 |
726888 | 726888 | 2020-11-13 | Tensas | Louisiana | 22107 | 193 | 3 |
723603 | 723603 | 2020-11-12 | Cameron | Louisiana | 22023 | 255 | 3 |
723645 | 723645 | 2020-11-12 | Tensas | Louisiana | 22107 | 192 | 3 |
720359 | 720359 | 2020-11-11 | Caldwell | Louisiana | 22021 | 408 | 3 |
720360 | 720360 | 2020-11-11 | Cameron | Louisiana | 22023 | 255 | 3 |
720402 | 720402 | 2020-11-11 | Tensas | Louisiana | 22107 | 191 | 3 |
717116 | 717116 | 2020-11-10 | Caldwell | Louisiana | 22021 | 408 | 3 |
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);