ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "St. Charles" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090372 | 1090372 | 2021-03-05 | St. Charles | Louisiana | 22089 | 5150 | 88 |
1087127 | 1087127 | 2021-03-04 | St. Charles | Louisiana | 22089 | 5144 | 88 |
1083881 | 1083881 | 2021-03-03 | St. Charles | Louisiana | 22089 | 5133 | 88 |
1080635 | 1080635 | 2021-03-02 | St. Charles | Louisiana | 22089 | 5127 | 88 |
1077390 | 1077390 | 2021-03-01 | St. Charles | Louisiana | 22089 | 5122 | 88 |
1074144 | 1074144 | 2021-02-28 | St. Charles | Louisiana | 22089 | 5107 | 88 |
1070898 | 1070898 | 2021-02-27 | St. Charles | Louisiana | 22089 | 5078 | 88 |
1067653 | 1067653 | 2021-02-26 | St. Charles | Louisiana | 22089 | 5078 | 88 |
1064408 | 1064408 | 2021-02-25 | St. Charles | Louisiana | 22089 | 5066 | 88 |
1061163 | 1061163 | 2021-02-24 | St. Charles | Louisiana | 22089 | 5060 | 88 |
1057917 | 1057917 | 2021-02-23 | St. Charles | Louisiana | 22089 | 5049 | 88 |
1054671 | 1054671 | 2021-02-22 | St. Charles | Louisiana | 22089 | 5052 | 88 |
1051424 | 1051424 | 2021-02-21 | St. Charles | Louisiana | 22089 | 5047 | 88 |
1048177 | 1048177 | 2021-02-20 | St. Charles | Louisiana | 22089 | 5023 | 88 |
1044932 | 1044932 | 2021-02-19 | St. Charles | Louisiana | 22089 | 5023 | 88 |
1041687 | 1041687 | 2021-02-18 | St. Charles | Louisiana | 22089 | 5011 | 88 |
1038442 | 1038442 | 2021-02-17 | St. Charles | Louisiana | 22089 | 5015 | 88 |
1035197 | 1035197 | 2021-02-16 | St. Charles | Louisiana | 22089 | 4998 | 88 |
1031951 | 1031951 | 2021-02-15 | St. Charles | Louisiana | 22089 | 4998 | 88 |
1028704 | 1028704 | 2021-02-14 | St. Charles | Louisiana | 22089 | 5002 | 88 |
1025459 | 1025459 | 2021-02-13 | St. Charles | Louisiana | 22089 | 4970 | 88 |
1022214 | 1022214 | 2021-02-12 | St. Charles | Louisiana | 22089 | 4970 | 88 |
1018969 | 1018969 | 2021-02-11 | St. Charles | Louisiana | 22089 | 4949 | 88 |
1015724 | 1015724 | 2021-02-10 | St. Charles | Louisiana | 22089 | 4923 | 88 |
1012479 | 1012479 | 2021-02-09 | St. Charles | Louisiana | 22089 | 4915 | 88 |
1009233 | 1009233 | 2021-02-08 | St. Charles | Louisiana | 22089 | 4901 | 88 |
1005987 | 1005987 | 2021-02-07 | St. Charles | Louisiana | 22089 | 4878 | 88 |
1002741 | 1002741 | 2021-02-06 | St. Charles | Louisiana | 22089 | 4859 | 88 |
999495 | 999495 | 2021-02-05 | St. Charles | Louisiana | 22089 | 4859 | 88 |
996249 | 996249 | 2021-02-04 | St. Charles | Louisiana | 22089 | 4858 | 88 |
993003 | 993003 | 2021-02-03 | St. Charles | Louisiana | 22089 | 4837 | 88 |
989757 | 989757 | 2021-02-02 | St. Charles | Louisiana | 22089 | 4814 | 87 |
986510 | 986510 | 2021-02-01 | St. Charles | Louisiana | 22089 | 4788 | 87 |
983263 | 983263 | 2021-01-31 | St. Charles | Louisiana | 22089 | 4782 | 87 |
980017 | 980017 | 2021-01-30 | St. Charles | Louisiana | 22089 | 4752 | 87 |
976771 | 976771 | 2021-01-29 | St. Charles | Louisiana | 22089 | 4752 | 87 |
973526 | 973526 | 2021-01-28 | St. Charles | Louisiana | 22089 | 4720 | 86 |
970281 | 970281 | 2021-01-27 | St. Charles | Louisiana | 22089 | 4691 | 83 |
967037 | 967037 | 2021-01-26 | St. Charles | Louisiana | 22089 | 4658 | 83 |
963792 | 963792 | 2021-01-25 | St. Charles | Louisiana | 22089 | 4629 | 82 |
960547 | 960547 | 2021-01-24 | St. Charles | Louisiana | 22089 | 4608 | 81 |
957301 | 957301 | 2021-01-23 | St. Charles | Louisiana | 22089 | 4577 | 80 |
954056 | 954056 | 2021-01-22 | St. Charles | Louisiana | 22089 | 4577 | 80 |
950811 | 950811 | 2021-01-21 | St. Charles | Louisiana | 22089 | 4566 | 80 |
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 |
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);