ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22121 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947582 | 947582 | 2021-01-20 | West Baton Rouge | Louisiana | 22121 | 2182 | 50 |
944335 | 944335 | 2021-01-19 | West Baton Rouge | Louisiana | 22121 | 2177 | 50 |
941090 | 941090 | 2021-01-18 | West Baton Rouge | Louisiana | 22121 | 2161 | 50 |
937845 | 937845 | 2021-01-17 | West Baton Rouge | Louisiana | 22121 | 2153 | 50 |
934600 | 934600 | 2021-01-16 | West Baton Rouge | Louisiana | 22121 | 2124 | 50 |
931355 | 931355 | 2021-01-15 | West Baton Rouge | Louisiana | 22121 | 2124 | 50 |
928110 | 928110 | 2021-01-14 | West Baton Rouge | Louisiana | 22121 | 2107 | 50 |
924864 | 924864 | 2021-01-13 | West Baton Rouge | Louisiana | 22121 | 2047 | 50 |
921619 | 921619 | 2021-01-12 | West Baton Rouge | Louisiana | 22121 | 2026 | 50 |
918374 | 918374 | 2021-01-11 | West Baton Rouge | Louisiana | 22121 | 1996 | 49 |
915129 | 915129 | 2021-01-10 | West Baton Rouge | Louisiana | 22121 | 1974 | 49 |
911884 | 911884 | 2021-01-09 | West Baton Rouge | Louisiana | 22121 | 1959 | 49 |
908639 | 908639 | 2021-01-08 | West Baton Rouge | Louisiana | 22121 | 1959 | 49 |
905393 | 905393 | 2021-01-07 | West Baton Rouge | Louisiana | 22121 | 1938 | 49 |
902148 | 902148 | 2021-01-06 | West Baton Rouge | Louisiana | 22121 | 1914 | 49 |
898903 | 898903 | 2021-01-05 | West Baton Rouge | Louisiana | 22121 | 1874 | 48 |
895658 | 895658 | 2021-01-04 | West Baton Rouge | Louisiana | 22121 | 1864 | 48 |
892411 | 892411 | 2021-01-03 | West Baton Rouge | Louisiana | 22121 | 1861 | 48 |
889165 | 889165 | 2021-01-02 | West Baton Rouge | Louisiana | 22121 | 1836 | 48 |
885919 | 885919 | 2021-01-01 | West Baton Rouge | Louisiana | 22121 | 1836 | 48 |
882674 | 882674 | 2020-12-31 | West Baton Rouge | Louisiana | 22121 | 1836 | 48 |
879429 | 879429 | 2020-12-30 | West Baton Rouge | Louisiana | 22121 | 1812 | 48 |
876184 | 876184 | 2020-12-29 | West Baton Rouge | Louisiana | 22121 | 1778 | 47 |
872939 | 872939 | 2020-12-28 | West Baton Rouge | Louisiana | 22121 | 1746 | 47 |
869694 | 869694 | 2020-12-27 | West Baton Rouge | Louisiana | 22121 | 1741 | 47 |
866449 | 866449 | 2020-12-26 | West Baton Rouge | Louisiana | 22121 | 1730 | 47 |
863204 | 863204 | 2020-12-25 | West Baton Rouge | Louisiana | 22121 | 1730 | 47 |
859959 | 859959 | 2020-12-24 | West Baton Rouge | Louisiana | 22121 | 1730 | 47 |
856714 | 856714 | 2020-12-23 | West Baton Rouge | Louisiana | 22121 | 1712 | 47 |
853469 | 853469 | 2020-12-22 | West Baton Rouge | Louisiana | 22121 | 1695 | 47 |
850224 | 850224 | 2020-12-21 | West Baton Rouge | Louisiana | 22121 | 1662 | 47 |
846979 | 846979 | 2020-12-20 | West Baton Rouge | Louisiana | 22121 | 1660 | 47 |
843733 | 843733 | 2020-12-19 | West Baton Rouge | Louisiana | 22121 | 1641 | 47 |
840488 | 840488 | 2020-12-18 | West Baton Rouge | Louisiana | 22121 | 1641 | 47 |
837243 | 837243 | 2020-12-17 | West Baton Rouge | Louisiana | 22121 | 1619 | 46 |
833997 | 833997 | 2020-12-16 | West Baton Rouge | Louisiana | 22121 | 1602 | 46 |
830750 | 830750 | 2020-12-15 | West Baton Rouge | Louisiana | 22121 | 1590 | 46 |
827504 | 827504 | 2020-12-14 | West Baton Rouge | Louisiana | 22121 | 1576 | 46 |
824257 | 824257 | 2020-12-13 | West Baton Rouge | Louisiana | 22121 | 1569 | 46 |
821011 | 821011 | 2020-12-12 | West Baton Rouge | Louisiana | 22121 | 1546 | 46 |
817765 | 817765 | 2020-12-11 | West Baton Rouge | Louisiana | 22121 | 1546 | 46 |
814519 | 814519 | 2020-12-10 | West Baton Rouge | Louisiana | 22121 | 1521 | 46 |
811274 | 811274 | 2020-12-09 | West Baton Rouge | Louisiana | 22121 | 1508 | 46 |
808029 | 808029 | 2020-12-08 | West Baton Rouge | Louisiana | 22121 | 1457 | 46 |
804784 | 804784 | 2020-12-07 | West Baton Rouge | Louisiana | 22121 | 1452 | 45 |
801539 | 801539 | 2020-12-06 | West Baton Rouge | Louisiana | 22121 | 1451 | 45 |
798294 | 798294 | 2020-12-05 | West Baton Rouge | Louisiana | 22121 | 1425 | 44 |
795049 | 795049 | 2020-12-04 | West Baton Rouge | Louisiana | 22121 | 1425 | 44 |
791804 | 791804 | 2020-12-03 | West Baton Rouge | Louisiana | 22121 | 1419 | 43 |
788559 | 788559 | 2020-12-02 | West Baton Rouge | Louisiana | 22121 | 1403 | 43 |
785315 | 785315 | 2020-12-01 | West Baton Rouge | Louisiana | 22121 | 1389 | 43 |
782070 | 782070 | 2020-11-30 | West Baton Rouge | Louisiana | 22121 | 1331 | 43 |
778824 | 778824 | 2020-11-29 | West Baton Rouge | Louisiana | 22121 | 1328 | 43 |
775579 | 775579 | 2020-11-28 | West Baton Rouge | Louisiana | 22121 | 1324 | 43 |
772334 | 772334 | 2020-11-27 | West Baton Rouge | Louisiana | 22121 | 1324 | 43 |
769089 | 769089 | 2020-11-26 | West Baton Rouge | Louisiana | 22121 | 1293 | 43 |
765843 | 765843 | 2020-11-25 | West Baton Rouge | Louisiana | 22121 | 1293 | 43 |
762598 | 762598 | 2020-11-24 | West Baton Rouge | Louisiana | 22121 | 1289 | 43 |
759353 | 759353 | 2020-11-23 | West Baton Rouge | Louisiana | 22121 | 1262 | 43 |
756106 | 756106 | 2020-11-22 | West Baton Rouge | Louisiana | 22121 | 1260 | 43 |
752860 | 752860 | 2020-11-21 | West Baton Rouge | Louisiana | 22121 | 1228 | 43 |
749614 | 749614 | 2020-11-20 | West Baton Rouge | Louisiana | 22121 | 1228 | 43 |
746368 | 746368 | 2020-11-19 | West Baton Rouge | Louisiana | 22121 | 1201 | 43 |
743121 | 743121 | 2020-11-18 | West Baton Rouge | Louisiana | 22121 | 1195 | 43 |
739874 | 739874 | 2020-11-17 | West Baton Rouge | Louisiana | 22121 | 1170 | 43 |
736630 | 736630 | 2020-11-16 | West Baton Rouge | Louisiana | 22121 | 1155 | 43 |
733384 | 733384 | 2020-11-15 | West Baton Rouge | Louisiana | 22121 | 1156 | 43 |
730139 | 730139 | 2020-11-14 | West Baton Rouge | Louisiana | 22121 | 1138 | 43 |
726896 | 726896 | 2020-11-13 | West Baton Rouge | Louisiana | 22121 | 1138 | 43 |
723653 | 723653 | 2020-11-12 | West Baton Rouge | Louisiana | 22121 | 1037 | 42 |
720410 | 720410 | 2020-11-11 | West Baton Rouge | Louisiana | 22121 | 1022 | 42 |
717167 | 717167 | 2020-11-10 | West Baton Rouge | Louisiana | 22121 | 1022 | 42 |
713923 | 713923 | 2020-11-09 | West Baton Rouge | Louisiana | 22121 | 1025 | 42 |
710679 | 710679 | 2020-11-08 | West Baton Rouge | Louisiana | 22121 | 1018 | 42 |
707435 | 707435 | 2020-11-07 | West Baton Rouge | Louisiana | 22121 | 1012 | 42 |
704192 | 704192 | 2020-11-06 | West Baton Rouge | Louisiana | 22121 | 1012 | 42 |
700950 | 700950 | 2020-11-05 | West Baton Rouge | Louisiana | 22121 | 985 | 42 |
697706 | 697706 | 2020-11-04 | West Baton Rouge | Louisiana | 22121 | 979 | 42 |
694463 | 694463 | 2020-11-03 | West Baton Rouge | Louisiana | 22121 | 980 | 42 |
691221 | 691221 | 2020-11-02 | West Baton Rouge | Louisiana | 22121 | 972 | 42 |
687976 | 687976 | 2020-11-01 | West Baton Rouge | Louisiana | 22121 | 972 | 42 |
684732 | 684732 | 2020-10-31 | West Baton Rouge | Louisiana | 22121 | 964 | 42 |
681489 | 681489 | 2020-10-30 | West Baton Rouge | Louisiana | 22121 | 964 | 42 |
678245 | 678245 | 2020-10-29 | West Baton Rouge | Louisiana | 22121 | 963 | 42 |
675003 | 675003 | 2020-10-28 | West Baton Rouge | Louisiana | 22121 | 964 | 42 |
671760 | 671760 | 2020-10-27 | West Baton Rouge | Louisiana | 22121 | 970 | 42 |
668518 | 668518 | 2020-10-26 | West Baton Rouge | Louisiana | 22121 | 964 | 42 |
665274 | 665274 | 2020-10-25 | West Baton Rouge | Louisiana | 22121 | 960 | 42 |
662029 | 662029 | 2020-10-24 | West Baton Rouge | Louisiana | 22121 | 960 | 42 |
658785 | 658785 | 2020-10-23 | West Baton Rouge | Louisiana | 22121 | 960 | 42 |
655540 | 655540 | 2020-10-22 | West Baton Rouge | Louisiana | 22121 | 955 | 42 |
652295 | 652295 | 2020-10-21 | West Baton Rouge | Louisiana | 22121 | 957 | 42 |
649050 | 649050 | 2020-10-20 | West Baton Rouge | Louisiana | 22121 | 952 | 42 |
645806 | 645806 | 2020-10-19 | West Baton Rouge | Louisiana | 22121 | 944 | 42 |
642559 | 642559 | 2020-10-18 | West Baton Rouge | Louisiana | 22121 | 945 | 42 |
639312 | 639312 | 2020-10-17 | West Baton Rouge | Louisiana | 22121 | 942 | 42 |
636066 | 636066 | 2020-10-16 | West Baton Rouge | Louisiana | 22121 | 942 | 42 |
632820 | 632820 | 2020-10-15 | West Baton Rouge | Louisiana | 22121 | 941 | 42 |
629576 | 629576 | 2020-10-14 | West Baton Rouge | Louisiana | 22121 | 934 | 42 |
626332 | 626332 | 2020-10-13 | West Baton Rouge | Louisiana | 22121 | 936 | 42 |
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);