ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rapides" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947560 | 947560 | 2021-01-20 | Rapides | Louisiana | 22079 | 10022 | 237 |
944313 | 944313 | 2021-01-19 | Rapides | Louisiana | 22079 | 9987 | 237 |
941068 | 941068 | 2021-01-18 | Rapides | Louisiana | 22079 | 9865 | 233 |
937823 | 937823 | 2021-01-17 | Rapides | Louisiana | 22079 | 9847 | 231 |
934578 | 934578 | 2021-01-16 | Rapides | Louisiana | 22079 | 9742 | 226 |
931333 | 931333 | 2021-01-15 | Rapides | Louisiana | 22079 | 9742 | 226 |
928088 | 928088 | 2021-01-14 | Rapides | Louisiana | 22079 | 9670 | 226 |
924842 | 924842 | 2021-01-13 | Rapides | Louisiana | 22079 | 9584 | 226 |
921597 | 921597 | 2021-01-12 | Rapides | Louisiana | 22079 | 9521 | 225 |
918352 | 918352 | 2021-01-11 | Rapides | Louisiana | 22079 | 9281 | 221 |
915107 | 915107 | 2021-01-10 | Rapides | Louisiana | 22079 | 9272 | 218 |
911862 | 911862 | 2021-01-09 | Rapides | Louisiana | 22079 | 9117 | 218 |
908617 | 908617 | 2021-01-08 | Rapides | Louisiana | 22079 | 9117 | 218 |
905371 | 905371 | 2021-01-07 | Rapides | Louisiana | 22079 | 9006 | 215 |
902126 | 902126 | 2021-01-06 | Rapides | Louisiana | 22079 | 8899 | 214 |
898881 | 898881 | 2021-01-05 | Rapides | Louisiana | 22079 | 8504 | 213 |
895636 | 895636 | 2021-01-04 | Rapides | Louisiana | 22079 | 8393 | 213 |
892389 | 892389 | 2021-01-03 | Rapides | Louisiana | 22079 | 8386 | 213 |
889143 | 889143 | 2021-01-02 | Rapides | Louisiana | 22079 | 8258 | 212 |
885897 | 885897 | 2021-01-01 | Rapides | Louisiana | 22079 | 8258 | 212 |
882652 | 882652 | 2020-12-31 | Rapides | Louisiana | 22079 | 8258 | 212 |
879407 | 879407 | 2020-12-30 | Rapides | Louisiana | 22079 | 8162 | 212 |
876162 | 876162 | 2020-12-29 | Rapides | Louisiana | 22079 | 7905 | 210 |
872917 | 872917 | 2020-12-28 | Rapides | Louisiana | 22079 | 7747 | 210 |
869672 | 869672 | 2020-12-27 | Rapides | Louisiana | 22079 | 7737 | 209 |
866427 | 866427 | 2020-12-26 | Rapides | Louisiana | 22079 | 7721 | 208 |
863182 | 863182 | 2020-12-25 | Rapides | Louisiana | 22079 | 7721 | 208 |
859937 | 859937 | 2020-12-24 | Rapides | Louisiana | 22079 | 7721 | 208 |
856692 | 856692 | 2020-12-23 | Rapides | Louisiana | 22079 | 7676 | 208 |
853447 | 853447 | 2020-12-22 | Rapides | Louisiana | 22079 | 7624 | 208 |
850202 | 850202 | 2020-12-21 | Rapides | Louisiana | 22079 | 7487 | 206 |
846957 | 846957 | 2020-12-20 | Rapides | Louisiana | 22079 | 7476 | 204 |
843711 | 843711 | 2020-12-19 | Rapides | Louisiana | 22079 | 7396 | 204 |
840466 | 840466 | 2020-12-18 | Rapides | Louisiana | 22079 | 7396 | 204 |
837221 | 837221 | 2020-12-17 | Rapides | Louisiana | 22079 | 7348 | 204 |
833975 | 833975 | 2020-12-16 | Rapides | Louisiana | 22079 | 7302 | 203 |
830728 | 830728 | 2020-12-15 | Rapides | Louisiana | 22079 | 7186 | 202 |
827482 | 827482 | 2020-12-14 | Rapides | Louisiana | 22079 | 7108 | 203 |
824235 | 824235 | 2020-12-13 | Rapides | Louisiana | 22079 | 7101 | 201 |
820989 | 820989 | 2020-12-12 | Rapides | Louisiana | 22079 | 7007 | 199 |
817743 | 817743 | 2020-12-11 | Rapides | Louisiana | 22079 | 7007 | 199 |
814497 | 814497 | 2020-12-10 | Rapides | Louisiana | 22079 | 6923 | 198 |
811252 | 811252 | 2020-12-09 | Rapides | Louisiana | 22079 | 6891 | 197 |
808007 | 808007 | 2020-12-08 | Rapides | Louisiana | 22079 | 6709 | 196 |
804762 | 804762 | 2020-12-07 | Rapides | Louisiana | 22079 | 6650 | 196 |
801517 | 801517 | 2020-12-06 | Rapides | Louisiana | 22079 | 6624 | 195 |
798272 | 798272 | 2020-12-05 | Rapides | Louisiana | 22079 | 6562 | 194 |
795027 | 795027 | 2020-12-04 | Rapides | Louisiana | 22079 | 6562 | 194 |
791782 | 791782 | 2020-12-03 | Rapides | Louisiana | 22079 | 6528 | 193 |
788537 | 788537 | 2020-12-02 | Rapides | Louisiana | 22079 | 6454 | 190 |
785293 | 785293 | 2020-12-01 | Rapides | Louisiana | 22079 | 6425 | 189 |
782048 | 782048 | 2020-11-30 | Rapides | Louisiana | 22079 | 6274 | 188 |
778802 | 778802 | 2020-11-29 | Rapides | Louisiana | 22079 | 6277 | 188 |
775557 | 775557 | 2020-11-28 | Rapides | Louisiana | 22079 | 6252 | 188 |
772312 | 772312 | 2020-11-27 | Rapides | Louisiana | 22079 | 6252 | 188 |
769067 | 769067 | 2020-11-26 | Rapides | Louisiana | 22079 | 6167 | 188 |
765821 | 765821 | 2020-11-25 | Rapides | Louisiana | 22079 | 6167 | 188 |
762576 | 762576 | 2020-11-24 | Rapides | Louisiana | 22079 | 6140 | 188 |
759331 | 759331 | 2020-11-23 | Rapides | Louisiana | 22079 | 6019 | 187 |
756084 | 756084 | 2020-11-22 | Rapides | Louisiana | 22079 | 5996 | 185 |
752838 | 752838 | 2020-11-21 | Rapides | Louisiana | 22079 | 5948 | 182 |
749592 | 749592 | 2020-11-20 | Rapides | Louisiana | 22079 | 5948 | 182 |
746346 | 746346 | 2020-11-19 | Rapides | Louisiana | 22079 | 5825 | 180 |
743099 | 743099 | 2020-11-18 | Rapides | Louisiana | 22079 | 5780 | 180 |
739852 | 739852 | 2020-11-17 | Rapides | Louisiana | 22079 | 5699 | 179 |
736608 | 736608 | 2020-11-16 | Rapides | Louisiana | 22079 | 5573 | 177 |
733362 | 733362 | 2020-11-15 | Rapides | Louisiana | 22079 | 5558 | 176 |
730117 | 730117 | 2020-11-14 | Rapides | Louisiana | 22079 | 5466 | 175 |
726874 | 726874 | 2020-11-13 | Rapides | Louisiana | 22079 | 5466 | 175 |
723631 | 723631 | 2020-11-12 | Rapides | Louisiana | 22079 | 5001 | 169 |
720388 | 720388 | 2020-11-11 | Rapides | Louisiana | 22079 | 4934 | 165 |
717145 | 717145 | 2020-11-10 | Rapides | Louisiana | 22079 | 4934 | 165 |
713901 | 713901 | 2020-11-09 | Rapides | Louisiana | 22079 | 4916 | 165 |
710657 | 710657 | 2020-11-08 | Rapides | Louisiana | 22079 | 4915 | 164 |
707413 | 707413 | 2020-11-07 | Rapides | Louisiana | 22079 | 4873 | 163 |
704170 | 704170 | 2020-11-06 | Rapides | Louisiana | 22079 | 4873 | 163 |
700928 | 700928 | 2020-11-05 | Rapides | Louisiana | 22079 | 4850 | 162 |
697684 | 697684 | 2020-11-04 | Rapides | Louisiana | 22079 | 4850 | 161 |
694441 | 694441 | 2020-11-03 | Rapides | Louisiana | 22079 | 4828 | 161 |
691199 | 691199 | 2020-11-02 | Rapides | Louisiana | 22079 | 4812 | 161 |
687954 | 687954 | 2020-11-01 | Rapides | Louisiana | 22079 | 4800 | 161 |
684710 | 684710 | 2020-10-31 | Rapides | Louisiana | 22079 | 4749 | 160 |
681467 | 681467 | 2020-10-30 | Rapides | Louisiana | 22079 | 4749 | 160 |
678223 | 678223 | 2020-10-29 | Rapides | Louisiana | 22079 | 4731 | 158 |
674981 | 674981 | 2020-10-28 | Rapides | Louisiana | 22079 | 4715 | 158 |
671738 | 671738 | 2020-10-27 | Rapides | Louisiana | 22079 | 4715 | 158 |
668496 | 668496 | 2020-10-26 | Rapides | Louisiana | 22079 | 4680 | 156 |
665252 | 665252 | 2020-10-25 | Rapides | Louisiana | 22079 | 4677 | 154 |
662007 | 662007 | 2020-10-24 | Rapides | Louisiana | 22079 | 4646 | 154 |
658763 | 658763 | 2020-10-23 | Rapides | Louisiana | 22079 | 4646 | 154 |
655518 | 655518 | 2020-10-22 | Rapides | Louisiana | 22079 | 4624 | 154 |
652273 | 652273 | 2020-10-21 | Rapides | Louisiana | 22079 | 4593 | 154 |
649028 | 649028 | 2020-10-20 | Rapides | Louisiana | 22079 | 4561 | 153 |
645784 | 645784 | 2020-10-19 | Rapides | Louisiana | 22079 | 4566 | 153 |
642537 | 642537 | 2020-10-18 | Rapides | Louisiana | 22079 | 4556 | 153 |
639290 | 639290 | 2020-10-17 | Rapides | Louisiana | 22079 | 4514 | 153 |
636044 | 636044 | 2020-10-16 | Rapides | Louisiana | 22079 | 4514 | 153 |
632798 | 632798 | 2020-10-15 | Rapides | Louisiana | 22079 | 4474 | 152 |
629554 | 629554 | 2020-10-14 | Rapides | Louisiana | 22079 | 4460 | 152 |
626310 | 626310 | 2020-10-13 | Rapides | Louisiana | 22079 | 4458 | 151 |
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);