ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22007 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947524 | 947524 | 2021-01-20 | Assumption | Louisiana | 22007 | 1682 | 29 |
944277 | 944277 | 2021-01-19 | Assumption | Louisiana | 22007 | 1657 | 29 |
941032 | 941032 | 2021-01-18 | Assumption | Louisiana | 22007 | 1638 | 29 |
937787 | 937787 | 2021-01-17 | Assumption | Louisiana | 22007 | 1629 | 29 |
934542 | 934542 | 2021-01-16 | Assumption | Louisiana | 22007 | 1599 | 29 |
931297 | 931297 | 2021-01-15 | Assumption | Louisiana | 22007 | 1599 | 29 |
928052 | 928052 | 2021-01-14 | Assumption | Louisiana | 22007 | 1586 | 29 |
924806 | 924806 | 2021-01-13 | Assumption | Louisiana | 22007 | 1567 | 29 |
921561 | 921561 | 2021-01-12 | Assumption | Louisiana | 22007 | 1547 | 29 |
918316 | 918316 | 2021-01-11 | Assumption | Louisiana | 22007 | 1526 | 29 |
915071 | 915071 | 2021-01-10 | Assumption | Louisiana | 22007 | 1519 | 29 |
911826 | 911826 | 2021-01-09 | Assumption | Louisiana | 22007 | 1483 | 29 |
908581 | 908581 | 2021-01-08 | Assumption | Louisiana | 22007 | 1483 | 29 |
905335 | 905335 | 2021-01-07 | Assumption | Louisiana | 22007 | 1453 | 29 |
902090 | 902090 | 2021-01-06 | Assumption | Louisiana | 22007 | 1433 | 29 |
898845 | 898845 | 2021-01-05 | Assumption | Louisiana | 22007 | 1424 | 29 |
895600 | 895600 | 2021-01-04 | Assumption | Louisiana | 22007 | 1408 | 28 |
892353 | 892353 | 2021-01-03 | Assumption | Louisiana | 22007 | 1404 | 28 |
889107 | 889107 | 2021-01-02 | Assumption | Louisiana | 22007 | 1379 | 28 |
885861 | 885861 | 2021-01-01 | Assumption | Louisiana | 22007 | 1379 | 28 |
882616 | 882616 | 2020-12-31 | Assumption | Louisiana | 22007 | 1379 | 28 |
879371 | 879371 | 2020-12-30 | Assumption | Louisiana | 22007 | 1358 | 28 |
876126 | 876126 | 2020-12-29 | Assumption | Louisiana | 22007 | 1315 | 26 |
872881 | 872881 | 2020-12-28 | Assumption | Louisiana | 22007 | 1299 | 26 |
869636 | 869636 | 2020-12-27 | Assumption | Louisiana | 22007 | 1295 | 26 |
866391 | 866391 | 2020-12-26 | Assumption | Louisiana | 22007 | 1276 | 26 |
863146 | 863146 | 2020-12-25 | Assumption | Louisiana | 22007 | 1276 | 26 |
859901 | 859901 | 2020-12-24 | Assumption | Louisiana | 22007 | 1276 | 26 |
856656 | 856656 | 2020-12-23 | Assumption | Louisiana | 22007 | 1257 | 26 |
853411 | 853411 | 2020-12-22 | Assumption | Louisiana | 22007 | 1240 | 26 |
850166 | 850166 | 2020-12-21 | Assumption | Louisiana | 22007 | 1216 | 26 |
846921 | 846921 | 2020-12-20 | Assumption | Louisiana | 22007 | 1204 | 26 |
843675 | 843675 | 2020-12-19 | Assumption | Louisiana | 22007 | 1197 | 26 |
840430 | 840430 | 2020-12-18 | Assumption | Louisiana | 22007 | 1197 | 26 |
837185 | 837185 | 2020-12-17 | Assumption | Louisiana | 22007 | 1186 | 26 |
833939 | 833939 | 2020-12-16 | Assumption | Louisiana | 22007 | 1175 | 26 |
830692 | 830692 | 2020-12-15 | Assumption | Louisiana | 22007 | 1172 | 26 |
827446 | 827446 | 2020-12-14 | Assumption | Louisiana | 22007 | 1156 | 26 |
824199 | 824199 | 2020-12-13 | Assumption | Louisiana | 22007 | 1155 | 26 |
820953 | 820953 | 2020-12-12 | Assumption | Louisiana | 22007 | 1133 | 26 |
817707 | 817707 | 2020-12-11 | Assumption | Louisiana | 22007 | 1133 | 26 |
814461 | 814461 | 2020-12-10 | Assumption | Louisiana | 22007 | 1129 | 25 |
811216 | 811216 | 2020-12-09 | Assumption | Louisiana | 22007 | 1124 | 25 |
807971 | 807971 | 2020-12-08 | Assumption | Louisiana | 22007 | 1106 | 25 |
804726 | 804726 | 2020-12-07 | Assumption | Louisiana | 22007 | 1096 | 25 |
801481 | 801481 | 2020-12-06 | Assumption | Louisiana | 22007 | 1092 | 25 |
798236 | 798236 | 2020-12-05 | Assumption | Louisiana | 22007 | 1067 | 25 |
794991 | 794991 | 2020-12-04 | Assumption | Louisiana | 22007 | 1067 | 25 |
791746 | 791746 | 2020-12-03 | Assumption | Louisiana | 22007 | 1046 | 25 |
788501 | 788501 | 2020-12-02 | Assumption | Louisiana | 22007 | 1037 | 25 |
785257 | 785257 | 2020-12-01 | Assumption | Louisiana | 22007 | 1029 | 25 |
782012 | 782012 | 2020-11-30 | Assumption | Louisiana | 22007 | 1016 | 25 |
778766 | 778766 | 2020-11-29 | Assumption | Louisiana | 22007 | 1015 | 25 |
775521 | 775521 | 2020-11-28 | Assumption | Louisiana | 22007 | 1016 | 25 |
772276 | 772276 | 2020-11-27 | Assumption | Louisiana | 22007 | 1016 | 25 |
769031 | 769031 | 2020-11-26 | Assumption | Louisiana | 22007 | 1004 | 25 |
765785 | 765785 | 2020-11-25 | Assumption | Louisiana | 22007 | 1004 | 25 |
762540 | 762540 | 2020-11-24 | Assumption | Louisiana | 22007 | 1002 | 25 |
759295 | 759295 | 2020-11-23 | Assumption | Louisiana | 22007 | 984 | 25 |
756048 | 756048 | 2020-11-22 | Assumption | Louisiana | 22007 | 978 | 25 |
752802 | 752802 | 2020-11-21 | Assumption | Louisiana | 22007 | 972 | 25 |
749556 | 749556 | 2020-11-20 | Assumption | Louisiana | 22007 | 972 | 25 |
746310 | 746310 | 2020-11-19 | Assumption | Louisiana | 22007 | 951 | 25 |
743063 | 743063 | 2020-11-18 | Assumption | Louisiana | 22007 | 942 | 25 |
739816 | 739816 | 2020-11-17 | Assumption | Louisiana | 22007 | 936 | 25 |
736572 | 736572 | 2020-11-16 | Assumption | Louisiana | 22007 | 914 | 25 |
733326 | 733326 | 2020-11-15 | Assumption | Louisiana | 22007 | 913 | 25 |
730081 | 730081 | 2020-11-14 | Assumption | Louisiana | 22007 | 891 | 25 |
726838 | 726838 | 2020-11-13 | Assumption | Louisiana | 22007 | 891 | 25 |
723595 | 723595 | 2020-11-12 | Assumption | Louisiana | 22007 | 852 | 25 |
720352 | 720352 | 2020-11-11 | Assumption | Louisiana | 22007 | 841 | 24 |
717109 | 717109 | 2020-11-10 | Assumption | Louisiana | 22007 | 841 | 24 |
713865 | 713865 | 2020-11-09 | Assumption | Louisiana | 22007 | 836 | 24 |
710621 | 710621 | 2020-11-08 | Assumption | Louisiana | 22007 | 834 | 24 |
707377 | 707377 | 2020-11-07 | Assumption | Louisiana | 22007 | 828 | 24 |
704134 | 704134 | 2020-11-06 | Assumption | Louisiana | 22007 | 828 | 24 |
700892 | 700892 | 2020-11-05 | Assumption | Louisiana | 22007 | 822 | 24 |
697648 | 697648 | 2020-11-04 | Assumption | Louisiana | 22007 | 816 | 24 |
694405 | 694405 | 2020-11-03 | Assumption | Louisiana | 22007 | 814 | 24 |
691163 | 691163 | 2020-11-02 | Assumption | Louisiana | 22007 | 808 | 24 |
687918 | 687918 | 2020-11-01 | Assumption | Louisiana | 22007 | 813 | 24 |
684674 | 684674 | 2020-10-31 | Assumption | Louisiana | 22007 | 802 | 24 |
681431 | 681431 | 2020-10-30 | Assumption | Louisiana | 22007 | 802 | 24 |
678187 | 678187 | 2020-10-29 | Assumption | Louisiana | 22007 | 797 | 24 |
674945 | 674945 | 2020-10-28 | Assumption | Louisiana | 22007 | 801 | 24 |
671702 | 671702 | 2020-10-27 | Assumption | Louisiana | 22007 | 799 | 24 |
668460 | 668460 | 2020-10-26 | Assumption | Louisiana | 22007 | 796 | 24 |
665216 | 665216 | 2020-10-25 | Assumption | Louisiana | 22007 | 794 | 24 |
661971 | 661971 | 2020-10-24 | Assumption | Louisiana | 22007 | 793 | 24 |
658727 | 658727 | 2020-10-23 | Assumption | Louisiana | 22007 | 793 | 24 |
655482 | 655482 | 2020-10-22 | Assumption | Louisiana | 22007 | 794 | 24 |
652237 | 652237 | 2020-10-21 | Assumption | Louisiana | 22007 | 788 | 24 |
648992 | 648992 | 2020-10-20 | Assumption | Louisiana | 22007 | 782 | 24 |
645748 | 645748 | 2020-10-19 | Assumption | Louisiana | 22007 | 783 | 24 |
642501 | 642501 | 2020-10-18 | Assumption | Louisiana | 22007 | 784 | 24 |
639254 | 639254 | 2020-10-17 | Assumption | Louisiana | 22007 | 780 | 24 |
636008 | 636008 | 2020-10-16 | Assumption | Louisiana | 22007 | 780 | 24 |
632762 | 632762 | 2020-10-15 | Assumption | Louisiana | 22007 | 780 | 24 |
629518 | 629518 | 2020-10-14 | Assumption | Louisiana | 22007 | 778 | 24 |
626274 | 626274 | 2020-10-13 | Assumption | Louisiana | 22007 | 774 | 24 |
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);