ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22009 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947525 | 947525 | 2021-01-20 | Avoyelles | Louisiana | 22009 | 3262 | 100 |
944278 | 944278 | 2021-01-19 | Avoyelles | Louisiana | 22009 | 3225 | 100 |
941033 | 941033 | 2021-01-18 | Avoyelles | Louisiana | 22009 | 3196 | 100 |
937788 | 937788 | 2021-01-17 | Avoyelles | Louisiana | 22009 | 3197 | 100 |
934543 | 934543 | 2021-01-16 | Avoyelles | Louisiana | 22009 | 3137 | 98 |
931298 | 931298 | 2021-01-15 | Avoyelles | Louisiana | 22009 | 3137 | 98 |
928053 | 928053 | 2021-01-14 | Avoyelles | Louisiana | 22009 | 3118 | 98 |
924807 | 924807 | 2021-01-13 | Avoyelles | Louisiana | 22009 | 3081 | 98 |
921562 | 921562 | 2021-01-12 | Avoyelles | Louisiana | 22009 | 3070 | 96 |
918317 | 918317 | 2021-01-11 | Avoyelles | Louisiana | 22009 | 3005 | 96 |
915072 | 915072 | 2021-01-10 | Avoyelles | Louisiana | 22009 | 3000 | 96 |
911827 | 911827 | 2021-01-09 | Avoyelles | Louisiana | 22009 | 2954 | 95 |
908582 | 908582 | 2021-01-08 | Avoyelles | Louisiana | 22009 | 2954 | 95 |
905336 | 905336 | 2021-01-07 | Avoyelles | Louisiana | 22009 | 2930 | 94 |
902091 | 902091 | 2021-01-06 | Avoyelles | Louisiana | 22009 | 2857 | 92 |
898846 | 898846 | 2021-01-05 | Avoyelles | Louisiana | 22009 | 2809 | 90 |
895601 | 895601 | 2021-01-04 | Avoyelles | Louisiana | 22009 | 2721 | 90 |
892354 | 892354 | 2021-01-03 | Avoyelles | Louisiana | 22009 | 2719 | 90 |
889108 | 889108 | 2021-01-02 | Avoyelles | Louisiana | 22009 | 2695 | 90 |
885862 | 885862 | 2021-01-01 | Avoyelles | Louisiana | 22009 | 2695 | 90 |
882617 | 882617 | 2020-12-31 | Avoyelles | Louisiana | 22009 | 2695 | 90 |
879372 | 879372 | 2020-12-30 | Avoyelles | Louisiana | 22009 | 2656 | 90 |
876127 | 876127 | 2020-12-29 | Avoyelles | Louisiana | 22009 | 2577 | 86 |
872882 | 872882 | 2020-12-28 | Avoyelles | Louisiana | 22009 | 2557 | 85 |
869637 | 869637 | 2020-12-27 | Avoyelles | Louisiana | 22009 | 2553 | 85 |
866392 | 866392 | 2020-12-26 | Avoyelles | Louisiana | 22009 | 2546 | 85 |
863147 | 863147 | 2020-12-25 | Avoyelles | Louisiana | 22009 | 2546 | 85 |
859902 | 859902 | 2020-12-24 | Avoyelles | Louisiana | 22009 | 2546 | 85 |
856657 | 856657 | 2020-12-23 | Avoyelles | Louisiana | 22009 | 2524 | 85 |
853412 | 853412 | 2020-12-22 | Avoyelles | Louisiana | 22009 | 2508 | 84 |
850167 | 850167 | 2020-12-21 | Avoyelles | Louisiana | 22009 | 2467 | 83 |
846922 | 846922 | 2020-12-20 | Avoyelles | Louisiana | 22009 | 2465 | 83 |
843676 | 843676 | 2020-12-19 | Avoyelles | Louisiana | 22009 | 2443 | 81 |
840431 | 840431 | 2020-12-18 | Avoyelles | Louisiana | 22009 | 2443 | 81 |
837186 | 837186 | 2020-12-17 | Avoyelles | Louisiana | 22009 | 2425 | 78 |
833940 | 833940 | 2020-12-16 | Avoyelles | Louisiana | 22009 | 2398 | 77 |
830693 | 830693 | 2020-12-15 | Avoyelles | Louisiana | 22009 | 2370 | 76 |
827447 | 827447 | 2020-12-14 | Avoyelles | Louisiana | 22009 | 2353 | 76 |
824200 | 824200 | 2020-12-13 | Avoyelles | Louisiana | 22009 | 2352 | 74 |
820954 | 820954 | 2020-12-12 | Avoyelles | Louisiana | 22009 | 2325 | 73 |
817708 | 817708 | 2020-12-11 | Avoyelles | Louisiana | 22009 | 2325 | 73 |
814462 | 814462 | 2020-12-10 | Avoyelles | Louisiana | 22009 | 2295 | 72 |
811217 | 811217 | 2020-12-09 | Avoyelles | Louisiana | 22009 | 2272 | 70 |
807972 | 807972 | 2020-12-08 | Avoyelles | Louisiana | 22009 | 2284 | 70 |
804727 | 804727 | 2020-12-07 | Avoyelles | Louisiana | 22009 | 2253 | 70 |
801482 | 801482 | 2020-12-06 | Avoyelles | Louisiana | 22009 | 2249 | 70 |
798237 | 798237 | 2020-12-05 | Avoyelles | Louisiana | 22009 | 2220 | 70 |
794992 | 794992 | 2020-12-04 | Avoyelles | Louisiana | 22009 | 2220 | 70 |
791747 | 791747 | 2020-12-03 | Avoyelles | Louisiana | 22009 | 2196 | 70 |
788502 | 788502 | 2020-12-02 | Avoyelles | Louisiana | 22009 | 2171 | 68 |
785258 | 785258 | 2020-12-01 | Avoyelles | Louisiana | 22009 | 2142 | 68 |
782013 | 782013 | 2020-11-30 | Avoyelles | Louisiana | 22009 | 2081 | 68 |
778767 | 778767 | 2020-11-29 | Avoyelles | Louisiana | 22009 | 2077 | 68 |
775522 | 775522 | 2020-11-28 | Avoyelles | Louisiana | 22009 | 2069 | 68 |
772277 | 772277 | 2020-11-27 | Avoyelles | Louisiana | 22009 | 2069 | 68 |
769032 | 769032 | 2020-11-26 | Avoyelles | Louisiana | 22009 | 2052 | 68 |
765786 | 765786 | 2020-11-25 | Avoyelles | Louisiana | 22009 | 2052 | 68 |
762541 | 762541 | 2020-11-24 | Avoyelles | Louisiana | 22009 | 2044 | 67 |
759296 | 759296 | 2020-11-23 | Avoyelles | Louisiana | 22009 | 2018 | 67 |
756049 | 756049 | 2020-11-22 | Avoyelles | Louisiana | 22009 | 2019 | 67 |
752803 | 752803 | 2020-11-21 | Avoyelles | Louisiana | 22009 | 1997 | 67 |
749557 | 749557 | 2020-11-20 | Avoyelles | Louisiana | 22009 | 1997 | 67 |
746311 | 746311 | 2020-11-19 | Avoyelles | Louisiana | 22009 | 1961 | 67 |
743064 | 743064 | 2020-11-18 | Avoyelles | Louisiana | 22009 | 1952 | 67 |
739817 | 739817 | 2020-11-17 | Avoyelles | Louisiana | 22009 | 1942 | 67 |
736573 | 736573 | 2020-11-16 | Avoyelles | Louisiana | 22009 | 1920 | 67 |
733327 | 733327 | 2020-11-15 | Avoyelles | Louisiana | 22009 | 1914 | 67 |
730082 | 730082 | 2020-11-14 | Avoyelles | Louisiana | 22009 | 1901 | 67 |
726839 | 726839 | 2020-11-13 | Avoyelles | Louisiana | 22009 | 1901 | 67 |
723596 | 723596 | 2020-11-12 | Avoyelles | Louisiana | 22009 | 1823 | 65 |
720353 | 720353 | 2020-11-11 | Avoyelles | Louisiana | 22009 | 1815 | 65 |
717110 | 717110 | 2020-11-10 | Avoyelles | Louisiana | 22009 | 1815 | 65 |
713866 | 713866 | 2020-11-09 | Avoyelles | Louisiana | 22009 | 1799 | 65 |
710622 | 710622 | 2020-11-08 | Avoyelles | Louisiana | 22009 | 1801 | 65 |
707378 | 707378 | 2020-11-07 | Avoyelles | Louisiana | 22009 | 1788 | 63 |
704135 | 704135 | 2020-11-06 | Avoyelles | Louisiana | 22009 | 1788 | 63 |
700893 | 700893 | 2020-11-05 | Avoyelles | Louisiana | 22009 | 1785 | 63 |
697649 | 697649 | 2020-11-04 | Avoyelles | Louisiana | 22009 | 1774 | 62 |
694406 | 694406 | 2020-11-03 | Avoyelles | Louisiana | 22009 | 1774 | 62 |
691164 | 691164 | 2020-11-02 | Avoyelles | Louisiana | 22009 | 1756 | 62 |
687919 | 687919 | 2020-11-01 | Avoyelles | Louisiana | 22009 | 1757 | 62 |
684675 | 684675 | 2020-10-31 | Avoyelles | Louisiana | 22009 | 1757 | 62 |
681432 | 681432 | 2020-10-30 | Avoyelles | Louisiana | 22009 | 1757 | 62 |
678188 | 678188 | 2020-10-29 | Avoyelles | Louisiana | 22009 | 1754 | 62 |
674946 | 674946 | 2020-10-28 | Avoyelles | Louisiana | 22009 | 1743 | 62 |
671703 | 671703 | 2020-10-27 | Avoyelles | Louisiana | 22009 | 1737 | 62 |
668461 | 668461 | 2020-10-26 | Avoyelles | Louisiana | 22009 | 1708 | 62 |
665217 | 665217 | 2020-10-25 | Avoyelles | Louisiana | 22009 | 1707 | 62 |
661972 | 661972 | 2020-10-24 | Avoyelles | Louisiana | 22009 | 1700 | 62 |
658728 | 658728 | 2020-10-23 | Avoyelles | Louisiana | 22009 | 1700 | 62 |
655483 | 655483 | 2020-10-22 | Avoyelles | Louisiana | 22009 | 1692 | 62 |
652238 | 652238 | 2020-10-21 | Avoyelles | Louisiana | 22009 | 1679 | 62 |
648993 | 648993 | 2020-10-20 | Avoyelles | Louisiana | 22009 | 1676 | 62 |
645749 | 645749 | 2020-10-19 | Avoyelles | Louisiana | 22009 | 1667 | 62 |
642502 | 642502 | 2020-10-18 | Avoyelles | Louisiana | 22009 | 1664 | 62 |
639255 | 639255 | 2020-10-17 | Avoyelles | Louisiana | 22009 | 1656 | 62 |
636009 | 636009 | 2020-10-16 | Avoyelles | Louisiana | 22009 | 1656 | 62 |
632763 | 632763 | 2020-10-15 | Avoyelles | Louisiana | 22009 | 1652 | 62 |
629519 | 629519 | 2020-10-14 | Avoyelles | Louisiana | 22009 | 1646 | 62 |
626275 | 626275 | 2020-10-13 | Avoyelles | Louisiana | 22009 | 1631 | 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);