ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 22089 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947565 | 947565 | 2021-01-20 | St. Charles | Louisiana | 22089 | 4492 | 80 |
944318 | 944318 | 2021-01-19 | St. Charles | Louisiana | 22089 | 4438 | 80 |
941073 | 941073 | 2021-01-18 | St. Charles | Louisiana | 22089 | 4418 | 80 |
937828 | 937828 | 2021-01-17 | St. Charles | Louisiana | 22089 | 4399 | 80 |
934583 | 934583 | 2021-01-16 | St. Charles | Louisiana | 22089 | 4353 | 80 |
931338 | 931338 | 2021-01-15 | St. Charles | Louisiana | 22089 | 4353 | 80 |
928093 | 928093 | 2021-01-14 | St. Charles | Louisiana | 22089 | 4272 | 80 |
924847 | 924847 | 2021-01-13 | St. Charles | Louisiana | 22089 | 4161 | 80 |
921602 | 921602 | 2021-01-12 | St. Charles | Louisiana | 22089 | 4130 | 78 |
918357 | 918357 | 2021-01-11 | St. Charles | Louisiana | 22089 | 4078 | 78 |
915112 | 915112 | 2021-01-10 | St. Charles | Louisiana | 22089 | 4049 | 78 |
911867 | 911867 | 2021-01-09 | St. Charles | Louisiana | 22089 | 3967 | 78 |
908622 | 908622 | 2021-01-08 | St. Charles | Louisiana | 22089 | 3967 | 78 |
905376 | 905376 | 2021-01-07 | St. Charles | Louisiana | 22089 | 3910 | 78 |
902131 | 902131 | 2021-01-06 | St. Charles | Louisiana | 22089 | 3868 | 78 |
898886 | 898886 | 2021-01-05 | St. Charles | Louisiana | 22089 | 3806 | 74 |
895641 | 895641 | 2021-01-04 | St. Charles | Louisiana | 22089 | 3771 | 73 |
892394 | 892394 | 2021-01-03 | St. Charles | Louisiana | 22089 | 3743 | 73 |
889148 | 889148 | 2021-01-02 | St. Charles | Louisiana | 22089 | 3637 | 73 |
885902 | 885902 | 2021-01-01 | St. Charles | Louisiana | 22089 | 3637 | 73 |
882657 | 882657 | 2020-12-31 | St. Charles | Louisiana | 22089 | 3637 | 73 |
879412 | 879412 | 2020-12-30 | St. Charles | Louisiana | 22089 | 3590 | 73 |
876167 | 876167 | 2020-12-29 | St. Charles | Louisiana | 22089 | 3534 | 73 |
872922 | 872922 | 2020-12-28 | St. Charles | Louisiana | 22089 | 3494 | 73 |
869677 | 869677 | 2020-12-27 | St. Charles | Louisiana | 22089 | 3486 | 73 |
866432 | 866432 | 2020-12-26 | St. Charles | Louisiana | 22089 | 3391 | 73 |
863187 | 863187 | 2020-12-25 | St. Charles | Louisiana | 22089 | 3391 | 73 |
859942 | 859942 | 2020-12-24 | St. Charles | Louisiana | 22089 | 3391 | 73 |
856697 | 856697 | 2020-12-23 | St. Charles | Louisiana | 22089 | 3348 | 73 |
853452 | 853452 | 2020-12-22 | St. Charles | Louisiana | 22089 | 3324 | 73 |
850207 | 850207 | 2020-12-21 | St. Charles | Louisiana | 22089 | 3297 | 73 |
846962 | 846962 | 2020-12-20 | St. Charles | Louisiana | 22089 | 3277 | 73 |
843716 | 843716 | 2020-12-19 | St. Charles | Louisiana | 22089 | 3224 | 72 |
840471 | 840471 | 2020-12-18 | St. Charles | Louisiana | 22089 | 3224 | 72 |
837226 | 837226 | 2020-12-17 | St. Charles | Louisiana | 22089 | 3157 | 72 |
833980 | 833980 | 2020-12-16 | St. Charles | Louisiana | 22089 | 3067 | 72 |
830733 | 830733 | 2020-12-15 | St. Charles | Louisiana | 22089 | 3053 | 72 |
827487 | 827487 | 2020-12-14 | St. Charles | Louisiana | 22089 | 3021 | 72 |
824240 | 824240 | 2020-12-13 | St. Charles | Louisiana | 22089 | 2996 | 72 |
820994 | 820994 | 2020-12-12 | St. Charles | Louisiana | 22089 | 2964 | 71 |
817748 | 817748 | 2020-12-11 | St. Charles | Louisiana | 22089 | 2964 | 71 |
814502 | 814502 | 2020-12-10 | St. Charles | Louisiana | 22089 | 2936 | 71 |
811257 | 811257 | 2020-12-09 | St. Charles | Louisiana | 22089 | 2909 | 71 |
808012 | 808012 | 2020-12-08 | St. Charles | Louisiana | 22089 | 2884 | 70 |
804767 | 804767 | 2020-12-07 | St. Charles | Louisiana | 22089 | 2864 | 70 |
801522 | 801522 | 2020-12-06 | St. Charles | Louisiana | 22089 | 2848 | 70 |
798277 | 798277 | 2020-12-05 | St. Charles | Louisiana | 22089 | 2812 | 70 |
795032 | 795032 | 2020-12-04 | St. Charles | Louisiana | 22089 | 2812 | 70 |
791787 | 791787 | 2020-12-03 | St. Charles | Louisiana | 22089 | 2758 | 70 |
788542 | 788542 | 2020-12-02 | St. Charles | Louisiana | 22089 | 2709 | 70 |
785298 | 785298 | 2020-12-01 | St. Charles | Louisiana | 22089 | 2669 | 70 |
782053 | 782053 | 2020-11-30 | St. Charles | Louisiana | 22089 | 2618 | 70 |
778807 | 778807 | 2020-11-29 | St. Charles | Louisiana | 22089 | 2575 | 70 |
775562 | 775562 | 2020-11-28 | St. Charles | Louisiana | 22089 | 2562 | 70 |
772317 | 772317 | 2020-11-27 | St. Charles | Louisiana | 22089 | 2562 | 70 |
769072 | 769072 | 2020-11-26 | St. Charles | Louisiana | 22089 | 2480 | 70 |
765826 | 765826 | 2020-11-25 | St. Charles | Louisiana | 22089 | 2480 | 70 |
762581 | 762581 | 2020-11-24 | St. Charles | Louisiana | 22089 | 2476 | 70 |
759336 | 759336 | 2020-11-23 | St. Charles | Louisiana | 22089 | 2445 | 70 |
756089 | 756089 | 2020-11-22 | St. Charles | Louisiana | 22089 | 2423 | 70 |
752843 | 752843 | 2020-11-21 | St. Charles | Louisiana | 22089 | 2391 | 70 |
749597 | 749597 | 2020-11-20 | St. Charles | Louisiana | 22089 | 2391 | 70 |
746351 | 746351 | 2020-11-19 | St. Charles | Louisiana | 22089 | 2320 | 70 |
743104 | 743104 | 2020-11-18 | St. Charles | Louisiana | 22089 | 2312 | 70 |
739857 | 739857 | 2020-11-17 | St. Charles | Louisiana | 22089 | 2294 | 70 |
736613 | 736613 | 2020-11-16 | St. Charles | Louisiana | 22089 | 2265 | 70 |
733367 | 733367 | 2020-11-15 | St. Charles | Louisiana | 22089 | 2261 | 69 |
730122 | 730122 | 2020-11-14 | St. Charles | Louisiana | 22089 | 2221 | 67 |
726879 | 726879 | 2020-11-13 | St. Charles | Louisiana | 22089 | 2221 | 67 |
723636 | 723636 | 2020-11-12 | St. Charles | Louisiana | 22089 | 2011 | 65 |
720393 | 720393 | 2020-11-11 | St. Charles | Louisiana | 22089 | 2008 | 65 |
717150 | 717150 | 2020-11-10 | St. Charles | Louisiana | 22089 | 2008 | 65 |
713906 | 713906 | 2020-11-09 | St. Charles | Louisiana | 22089 | 1998 | 65 |
710662 | 710662 | 2020-11-08 | St. Charles | Louisiana | 22089 | 1999 | 65 |
707418 | 707418 | 2020-11-07 | St. Charles | Louisiana | 22089 | 1993 | 64 |
704175 | 704175 | 2020-11-06 | St. Charles | Louisiana | 22089 | 1993 | 64 |
700933 | 700933 | 2020-11-05 | St. Charles | Louisiana | 22089 | 1995 | 64 |
697689 | 697689 | 2020-11-04 | St. Charles | Louisiana | 22089 | 1972 | 64 |
694446 | 694446 | 2020-11-03 | St. Charles | Louisiana | 22089 | 1975 | 64 |
691204 | 691204 | 2020-11-02 | St. Charles | Louisiana | 22089 | 1968 | 63 |
687959 | 687959 | 2020-11-01 | St. Charles | Louisiana | 22089 | 1965 | 63 |
684715 | 684715 | 2020-10-31 | St. Charles | Louisiana | 22089 | 1964 | 63 |
681472 | 681472 | 2020-10-30 | St. Charles | Louisiana | 22089 | 1964 | 63 |
678228 | 678228 | 2020-10-29 | St. Charles | Louisiana | 22089 | 1954 | 63 |
674986 | 674986 | 2020-10-28 | St. Charles | Louisiana | 22089 | 1955 | 63 |
671743 | 671743 | 2020-10-27 | St. Charles | Louisiana | 22089 | 1956 | 63 |
668501 | 668501 | 2020-10-26 | St. Charles | Louisiana | 22089 | 1945 | 63 |
665257 | 665257 | 2020-10-25 | St. Charles | Louisiana | 22089 | 1941 | 63 |
662012 | 662012 | 2020-10-24 | St. Charles | Louisiana | 22089 | 1933 | 63 |
658768 | 658768 | 2020-10-23 | St. Charles | Louisiana | 22089 | 1933 | 63 |
655523 | 655523 | 2020-10-22 | St. Charles | Louisiana | 22089 | 1928 | 63 |
652278 | 652278 | 2020-10-21 | St. Charles | Louisiana | 22089 | 1920 | 63 |
649033 | 649033 | 2020-10-20 | St. Charles | Louisiana | 22089 | 1920 | 63 |
645789 | 645789 | 2020-10-19 | St. Charles | Louisiana | 22089 | 1912 | 63 |
642542 | 642542 | 2020-10-18 | St. Charles | Louisiana | 22089 | 1909 | 63 |
639295 | 639295 | 2020-10-17 | St. Charles | Louisiana | 22089 | 1896 | 63 |
636049 | 636049 | 2020-10-16 | St. Charles | Louisiana | 22089 | 1896 | 63 |
632803 | 632803 | 2020-10-15 | St. Charles | Louisiana | 22089 | 1893 | 63 |
629559 | 629559 | 2020-10-14 | St. Charles | Louisiana | 22089 | 1886 | 62 |
626315 | 626315 | 2020-10-13 | St. Charles | Louisiana | 22089 | 1889 | 62 |
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);