ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Ascension" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947523 | 947523 | 2021-01-20 | Ascension | Louisiana | 22005 | 9607 | 134 |
944276 | 944276 | 2021-01-19 | Ascension | Louisiana | 22005 | 9570 | 132 |
941031 | 941031 | 2021-01-18 | Ascension | Louisiana | 22005 | 9498 | 128 |
937786 | 937786 | 2021-01-17 | Ascension | Louisiana | 22005 | 9469 | 126 |
934541 | 934541 | 2021-01-16 | Ascension | Louisiana | 22005 | 9357 | 124 |
931296 | 931296 | 2021-01-15 | Ascension | Louisiana | 22005 | 9357 | 124 |
928051 | 928051 | 2021-01-14 | Ascension | Louisiana | 22005 | 9246 | 124 |
924805 | 924805 | 2021-01-13 | Ascension | Louisiana | 22005 | 9041 | 124 |
921560 | 921560 | 2021-01-12 | Ascension | Louisiana | 22005 | 8918 | 124 |
918315 | 918315 | 2021-01-11 | Ascension | Louisiana | 22005 | 8745 | 123 |
915070 | 915070 | 2021-01-10 | Ascension | Louisiana | 22005 | 8719 | 123 |
911825 | 911825 | 2021-01-09 | Ascension | Louisiana | 22005 | 8573 | 122 |
908580 | 908580 | 2021-01-08 | Ascension | Louisiana | 22005 | 8573 | 122 |
905334 | 905334 | 2021-01-07 | Ascension | Louisiana | 22005 | 8495 | 121 |
902089 | 902089 | 2021-01-06 | Ascension | Louisiana | 22005 | 8388 | 121 |
898844 | 898844 | 2021-01-05 | Ascension | Louisiana | 22005 | 8144 | 120 |
895599 | 895599 | 2021-01-04 | Ascension | Louisiana | 22005 | 8059 | 118 |
892352 | 892352 | 2021-01-03 | Ascension | Louisiana | 22005 | 8033 | 117 |
889106 | 889106 | 2021-01-02 | Ascension | Louisiana | 22005 | 7849 | 117 |
885860 | 885860 | 2021-01-01 | Ascension | Louisiana | 22005 | 7849 | 117 |
882615 | 882615 | 2020-12-31 | Ascension | Louisiana | 22005 | 7849 | 117 |
879370 | 879370 | 2020-12-30 | Ascension | Louisiana | 22005 | 7779 | 116 |
876125 | 876125 | 2020-12-29 | Ascension | Louisiana | 22005 | 7704 | 116 |
872880 | 872880 | 2020-12-28 | Ascension | Louisiana | 22005 | 7519 | 115 |
869635 | 869635 | 2020-12-27 | Ascension | Louisiana | 22005 | 7499 | 115 |
866390 | 866390 | 2020-12-26 | Ascension | Louisiana | 22005 | 7395 | 114 |
863145 | 863145 | 2020-12-25 | Ascension | Louisiana | 22005 | 7395 | 114 |
859900 | 859900 | 2020-12-24 | Ascension | Louisiana | 22005 | 7395 | 114 |
856655 | 856655 | 2020-12-23 | Ascension | Louisiana | 22005 | 7327 | 114 |
853410 | 853410 | 2020-12-22 | Ascension | Louisiana | 22005 | 7231 | 114 |
850165 | 850165 | 2020-12-21 | Ascension | Louisiana | 22005 | 7160 | 114 |
846920 | 846920 | 2020-12-20 | Ascension | Louisiana | 22005 | 7140 | 113 |
843674 | 843674 | 2020-12-19 | Ascension | Louisiana | 22005 | 7048 | 113 |
840429 | 840429 | 2020-12-18 | Ascension | Louisiana | 22005 | 7048 | 113 |
837184 | 837184 | 2020-12-17 | Ascension | Louisiana | 22005 | 6991 | 113 |
833938 | 833938 | 2020-12-16 | Ascension | Louisiana | 22005 | 6885 | 113 |
830691 | 830691 | 2020-12-15 | Ascension | Louisiana | 22005 | 6786 | 114 |
827445 | 827445 | 2020-12-14 | Ascension | Louisiana | 22005 | 6761 | 111 |
824198 | 824198 | 2020-12-13 | Ascension | Louisiana | 22005 | 6734 | 111 |
820952 | 820952 | 2020-12-12 | Ascension | Louisiana | 22005 | 6605 | 111 |
817706 | 817706 | 2020-12-11 | Ascension | Louisiana | 22005 | 6605 | 111 |
814460 | 814460 | 2020-12-10 | Ascension | Louisiana | 22005 | 6550 | 110 |
811215 | 811215 | 2020-12-09 | Ascension | Louisiana | 22005 | 6500 | 110 |
807970 | 807970 | 2020-12-08 | Ascension | Louisiana | 22005 | 6263 | 109 |
804725 | 804725 | 2020-12-07 | Ascension | Louisiana | 22005 | 6215 | 109 |
801480 | 801480 | 2020-12-06 | Ascension | Louisiana | 22005 | 6174 | 109 |
798235 | 798235 | 2020-12-05 | Ascension | Louisiana | 22005 | 6074 | 109 |
794990 | 794990 | 2020-12-04 | Ascension | Louisiana | 22005 | 6074 | 109 |
791745 | 791745 | 2020-12-03 | Ascension | Louisiana | 22005 | 5927 | 108 |
788500 | 788500 | 2020-12-02 | Ascension | Louisiana | 22005 | 5896 | 108 |
785256 | 785256 | 2020-12-01 | Ascension | Louisiana | 22005 | 5837 | 108 |
782011 | 782011 | 2020-11-30 | Ascension | Louisiana | 22005 | 5655 | 108 |
778765 | 778765 | 2020-11-29 | Ascension | Louisiana | 22005 | 5651 | 108 |
775520 | 775520 | 2020-11-28 | Ascension | Louisiana | 22005 | 5614 | 107 |
772275 | 772275 | 2020-11-27 | Ascension | Louisiana | 22005 | 5614 | 107 |
769030 | 769030 | 2020-11-26 | Ascension | Louisiana | 22005 | 5527 | 107 |
765784 | 765784 | 2020-11-25 | Ascension | Louisiana | 22005 | 5527 | 107 |
762539 | 762539 | 2020-11-24 | Ascension | Louisiana | 22005 | 5518 | 107 |
759294 | 759294 | 2020-11-23 | Ascension | Louisiana | 22005 | 5406 | 106 |
756047 | 756047 | 2020-11-22 | Ascension | Louisiana | 22005 | 5388 | 106 |
752801 | 752801 | 2020-11-21 | Ascension | Louisiana | 22005 | 5325 | 106 |
749555 | 749555 | 2020-11-20 | Ascension | Louisiana | 22005 | 5325 | 106 |
746309 | 746309 | 2020-11-19 | Ascension | Louisiana | 22005 | 5228 | 105 |
743062 | 743062 | 2020-11-18 | Ascension | Louisiana | 22005 | 5173 | 104 |
739815 | 739815 | 2020-11-17 | Ascension | Louisiana | 22005 | 5068 | 103 |
736571 | 736571 | 2020-11-16 | Ascension | Louisiana | 22005 | 4994 | 103 |
733325 | 733325 | 2020-11-15 | Ascension | Louisiana | 22005 | 4991 | 103 |
730080 | 730080 | 2020-11-14 | Ascension | Louisiana | 22005 | 4881 | 103 |
726837 | 726837 | 2020-11-13 | Ascension | Louisiana | 22005 | 4881 | 103 |
723594 | 723594 | 2020-11-12 | Ascension | Louisiana | 22005 | 4600 | 100 |
720351 | 720351 | 2020-11-11 | Ascension | Louisiana | 22005 | 4493 | 100 |
717108 | 717108 | 2020-11-10 | Ascension | Louisiana | 22005 | 4493 | 100 |
713864 | 713864 | 2020-11-09 | Ascension | Louisiana | 22005 | 4466 | 100 |
710620 | 710620 | 2020-11-08 | Ascension | Louisiana | 22005 | 4460 | 100 |
707376 | 707376 | 2020-11-07 | Ascension | Louisiana | 22005 | 4405 | 100 |
704133 | 704133 | 2020-11-06 | Ascension | Louisiana | 22005 | 4405 | 100 |
700891 | 700891 | 2020-11-05 | Ascension | Louisiana | 22005 | 4382 | 100 |
697647 | 697647 | 2020-11-04 | Ascension | Louisiana | 22005 | 4352 | 100 |
694404 | 694404 | 2020-11-03 | Ascension | Louisiana | 22005 | 4338 | 100 |
691162 | 691162 | 2020-11-02 | Ascension | Louisiana | 22005 | 4308 | 100 |
687917 | 687917 | 2020-11-01 | Ascension | Louisiana | 22005 | 4299 | 100 |
684673 | 684673 | 2020-10-31 | Ascension | Louisiana | 22005 | 4212 | 100 |
681430 | 681430 | 2020-10-30 | Ascension | Louisiana | 22005 | 4212 | 100 |
678186 | 678186 | 2020-10-29 | Ascension | Louisiana | 22005 | 4186 | 100 |
674944 | 674944 | 2020-10-28 | Ascension | Louisiana | 22005 | 4169 | 99 |
671701 | 671701 | 2020-10-27 | Ascension | Louisiana | 22005 | 4146 | 99 |
668459 | 668459 | 2020-10-26 | Ascension | Louisiana | 22005 | 4075 | 99 |
665215 | 665215 | 2020-10-25 | Ascension | Louisiana | 22005 | 4073 | 98 |
661970 | 661970 | 2020-10-24 | Ascension | Louisiana | 22005 | 4043 | 98 |
658726 | 658726 | 2020-10-23 | Ascension | Louisiana | 22005 | 4043 | 98 |
655481 | 655481 | 2020-10-22 | Ascension | Louisiana | 22005 | 3998 | 98 |
652236 | 652236 | 2020-10-21 | Ascension | Louisiana | 22005 | 3992 | 98 |
648991 | 648991 | 2020-10-20 | Ascension | Louisiana | 22005 | 3955 | 98 |
645747 | 645747 | 2020-10-19 | Ascension | Louisiana | 22005 | 3945 | 98 |
642500 | 642500 | 2020-10-18 | Ascension | Louisiana | 22005 | 3950 | 98 |
639253 | 639253 | 2020-10-17 | Ascension | Louisiana | 22005 | 3921 | 98 |
636007 | 636007 | 2020-10-16 | Ascension | Louisiana | 22005 | 3921 | 98 |
632761 | 632761 | 2020-10-15 | Ascension | Louisiana | 22005 | 3885 | 98 |
629517 | 629517 | 2020-10-14 | Ascension | Louisiana | 22005 | 3876 | 98 |
626273 | 626273 | 2020-10-13 | Ascension | Louisiana | 22005 | 3882 | 98 |
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);