ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
412 rows where deaths = 4 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- St. Helena 105
- Cameron 43
- Beauregard 35
- Webster 29
- East Carroll 21
- Concordia 18
- Morehouse 16
- Richland 13
- Rapides 9
- Vermilion 9
- LaSalle 7
- Red River 7
- Franklin 6
- Claiborne 5
- Jackson 5
- Madison 5
- Natchitoches 5
- St. Landry 5
- Catahoula 4
- Lincoln 4
- Sabine 4
- St. James 4
- St. Martin 4
- Tensas 4
- East Baton Rouge 3
- Lafourche 3
- Plaquemines 3
- Union 3
- Unknown 3
- Vernon 3
- …
state 1
- Louisiana · 412 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
970248 | 970248 | 2021-01-27 | Cameron | Louisiana | 22023 | 484 | 4 |
967004 | 967004 | 2021-01-26 | Cameron | Louisiana | 22023 | 473 | 4 |
963759 | 963759 | 2021-01-25 | Cameron | Louisiana | 22023 | 467 | 4 |
960514 | 960514 | 2021-01-24 | Cameron | Louisiana | 22023 | 466 | 4 |
957268 | 957268 | 2021-01-23 | Cameron | Louisiana | 22023 | 459 | 4 |
954023 | 954023 | 2021-01-22 | Cameron | Louisiana | 22023 | 459 | 4 |
950778 | 950778 | 2021-01-21 | Cameron | Louisiana | 22023 | 465 | 4 |
947532 | 947532 | 2021-01-20 | Cameron | Louisiana | 22023 | 458 | 4 |
944285 | 944285 | 2021-01-19 | Cameron | Louisiana | 22023 | 453 | 4 |
941040 | 941040 | 2021-01-18 | Cameron | Louisiana | 22023 | 440 | 4 |
937795 | 937795 | 2021-01-17 | Cameron | Louisiana | 22023 | 444 | 4 |
934550 | 934550 | 2021-01-16 | Cameron | Louisiana | 22023 | 438 | 4 |
934592 | 934592 | 2021-01-16 | Tensas | Louisiana | 22107 | 315 | 4 |
931305 | 931305 | 2021-01-15 | Cameron | Louisiana | 22023 | 438 | 4 |
931347 | 931347 | 2021-01-15 | Tensas | Louisiana | 22107 | 315 | 4 |
928060 | 928060 | 2021-01-14 | Cameron | Louisiana | 22023 | 436 | 4 |
928102 | 928102 | 2021-01-14 | Tensas | Louisiana | 22107 | 303 | 4 |
924814 | 924814 | 2021-01-13 | Cameron | Louisiana | 22023 | 428 | 4 |
924856 | 924856 | 2021-01-13 | Tensas | Louisiana | 22107 | 295 | 4 |
921569 | 921569 | 2021-01-12 | Cameron | Louisiana | 22023 | 433 | 4 |
918324 | 918324 | 2021-01-11 | Cameron | Louisiana | 22023 | 416 | 4 |
915079 | 915079 | 2021-01-10 | Cameron | Louisiana | 22023 | 412 | 4 |
911834 | 911834 | 2021-01-09 | Cameron | Louisiana | 22023 | 418 | 4 |
908589 | 908589 | 2021-01-08 | Cameron | Louisiana | 22023 | 418 | 4 |
905343 | 905343 | 2021-01-07 | Cameron | Louisiana | 22023 | 407 | 4 |
902098 | 902098 | 2021-01-06 | Cameron | Louisiana | 22023 | 413 | 4 |
898853 | 898853 | 2021-01-05 | Cameron | Louisiana | 22023 | 396 | 4 |
895608 | 895608 | 2021-01-04 | Cameron | Louisiana | 22023 | 388 | 4 |
892361 | 892361 | 2021-01-03 | Cameron | Louisiana | 22023 | 387 | 4 |
889115 | 889115 | 2021-01-02 | Cameron | Louisiana | 22023 | 381 | 4 |
885869 | 885869 | 2021-01-01 | Cameron | Louisiana | 22023 | 381 | 4 |
882624 | 882624 | 2020-12-31 | Cameron | Louisiana | 22023 | 381 | 4 |
879379 | 879379 | 2020-12-30 | Cameron | Louisiana | 22023 | 380 | 4 |
876134 | 876134 | 2020-12-29 | Cameron | Louisiana | 22023 | 376 | 4 |
872889 | 872889 | 2020-12-28 | Cameron | Louisiana | 22023 | 370 | 4 |
872923 | 872923 | 2020-12-28 | St. Helena | Louisiana | 22091 | 668 | 4 |
869644 | 869644 | 2020-12-27 | Cameron | Louisiana | 22023 | 367 | 4 |
869678 | 869678 | 2020-12-27 | St. Helena | Louisiana | 22091 | 666 | 4 |
866399 | 866399 | 2020-12-26 | Cameron | Louisiana | 22023 | 366 | 4 |
866433 | 866433 | 2020-12-26 | St. Helena | Louisiana | 22091 | 666 | 4 |
863154 | 863154 | 2020-12-25 | Cameron | Louisiana | 22023 | 366 | 4 |
863188 | 863188 | 2020-12-25 | St. Helena | Louisiana | 22091 | 666 | 4 |
859909 | 859909 | 2020-12-24 | Cameron | Louisiana | 22023 | 366 | 4 |
859943 | 859943 | 2020-12-24 | St. Helena | Louisiana | 22091 | 666 | 4 |
856664 | 856664 | 2020-12-23 | Cameron | Louisiana | 22023 | 368 | 4 |
856698 | 856698 | 2020-12-23 | St. Helena | Louisiana | 22091 | 661 | 4 |
853419 | 853419 | 2020-12-22 | Cameron | Louisiana | 22023 | 367 | 4 |
853453 | 853453 | 2020-12-22 | St. Helena | Louisiana | 22091 | 659 | 4 |
850174 | 850174 | 2020-12-21 | Cameron | Louisiana | 22023 | 350 | 4 |
850208 | 850208 | 2020-12-21 | St. Helena | Louisiana | 22091 | 644 | 4 |
846929 | 846929 | 2020-12-20 | Cameron | Louisiana | 22023 | 350 | 4 |
846963 | 846963 | 2020-12-20 | St. Helena | Louisiana | 22091 | 646 | 4 |
843683 | 843683 | 2020-12-19 | Cameron | Louisiana | 22023 | 345 | 4 |
843717 | 843717 | 2020-12-19 | St. Helena | Louisiana | 22091 | 637 | 4 |
840438 | 840438 | 2020-12-18 | Cameron | Louisiana | 22023 | 345 | 4 |
840472 | 840472 | 2020-12-18 | St. Helena | Louisiana | 22091 | 637 | 4 |
837193 | 837193 | 2020-12-17 | Cameron | Louisiana | 22023 | 348 | 4 |
837227 | 837227 | 2020-12-17 | St. Helena | Louisiana | 22091 | 633 | 4 |
833947 | 833947 | 2020-12-16 | Cameron | Louisiana | 22023 | 339 | 4 |
833981 | 833981 | 2020-12-16 | St. Helena | Louisiana | 22091 | 621 | 4 |
830734 | 830734 | 2020-12-15 | St. Helena | Louisiana | 22091 | 611 | 4 |
827488 | 827488 | 2020-12-14 | St. Helena | Louisiana | 22091 | 596 | 4 |
824241 | 824241 | 2020-12-13 | St. Helena | Louisiana | 22091 | 597 | 4 |
820995 | 820995 | 2020-12-12 | St. Helena | Louisiana | 22091 | 593 | 4 |
817749 | 817749 | 2020-12-11 | St. Helena | Louisiana | 22091 | 593 | 4 |
814503 | 814503 | 2020-12-10 | St. Helena | Louisiana | 22091 | 587 | 4 |
811258 | 811258 | 2020-12-09 | St. Helena | Louisiana | 22091 | 584 | 4 |
808013 | 808013 | 2020-12-08 | St. Helena | Louisiana | 22091 | 562 | 4 |
804768 | 804768 | 2020-12-07 | St. Helena | Louisiana | 22091 | 560 | 4 |
801523 | 801523 | 2020-12-06 | St. Helena | Louisiana | 22091 | 562 | 4 |
798278 | 798278 | 2020-12-05 | St. Helena | Louisiana | 22091 | 556 | 4 |
795033 | 795033 | 2020-12-04 | St. Helena | Louisiana | 22091 | 556 | 4 |
791788 | 791788 | 2020-12-03 | St. Helena | Louisiana | 22091 | 549 | 4 |
788543 | 788543 | 2020-12-02 | St. Helena | Louisiana | 22091 | 527 | 4 |
785299 | 785299 | 2020-12-01 | St. Helena | Louisiana | 22091 | 515 | 4 |
782054 | 782054 | 2020-11-30 | St. Helena | Louisiana | 22091 | 512 | 4 |
778808 | 778808 | 2020-11-29 | St. Helena | Louisiana | 22091 | 514 | 4 |
775563 | 775563 | 2020-11-28 | St. Helena | Louisiana | 22091 | 512 | 4 |
772318 | 772318 | 2020-11-27 | St. Helena | Louisiana | 22091 | 512 | 4 |
769073 | 769073 | 2020-11-26 | St. Helena | Louisiana | 22091 | 509 | 4 |
765827 | 765827 | 2020-11-25 | St. Helena | Louisiana | 22091 | 509 | 4 |
762582 | 762582 | 2020-11-24 | St. Helena | Louisiana | 22091 | 506 | 4 |
759337 | 759337 | 2020-11-23 | St. Helena | Louisiana | 22091 | 502 | 4 |
756090 | 756090 | 2020-11-22 | St. Helena | Louisiana | 22091 | 501 | 4 |
752844 | 752844 | 2020-11-21 | St. Helena | Louisiana | 22091 | 501 | 4 |
749598 | 749598 | 2020-11-20 | St. Helena | Louisiana | 22091 | 501 | 4 |
746352 | 746352 | 2020-11-19 | St. Helena | Louisiana | 22091 | 489 | 4 |
743105 | 743105 | 2020-11-18 | St. Helena | Louisiana | 22091 | 494 | 4 |
739858 | 739858 | 2020-11-17 | St. Helena | Louisiana | 22091 | 496 | 4 |
736614 | 736614 | 2020-11-16 | St. Helena | Louisiana | 22091 | 491 | 4 |
733368 | 733368 | 2020-11-15 | St. Helena | Louisiana | 22091 | 488 | 4 |
730123 | 730123 | 2020-11-14 | St. Helena | Louisiana | 22091 | 490 | 4 |
726880 | 726880 | 2020-11-13 | St. Helena | Louisiana | 22091 | 490 | 4 |
723602 | 723602 | 2020-11-12 | Caldwell | Louisiana | 22021 | 423 | 4 |
723637 | 723637 | 2020-11-12 | St. Helena | Louisiana | 22091 | 448 | 4 |
720394 | 720394 | 2020-11-11 | St. Helena | Louisiana | 22091 | 446 | 4 |
717151 | 717151 | 2020-11-10 | St. Helena | Louisiana | 22091 | 446 | 4 |
713907 | 713907 | 2020-11-09 | St. Helena | Louisiana | 22091 | 446 | 4 |
710663 | 710663 | 2020-11-08 | St. Helena | Louisiana | 22091 | 447 | 4 |
707419 | 707419 | 2020-11-07 | St. Helena | Louisiana | 22091 | 446 | 4 |
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);