ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "St. Tammany" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947572 | 947572 | 2021-01-20 | St. Tammany | Louisiana | 22103 | 19676 | 407 |
944325 | 944325 | 2021-01-19 | St. Tammany | Louisiana | 22103 | 19538 | 403 |
941080 | 941080 | 2021-01-18 | St. Tammany | Louisiana | 22103 | 19404 | 400 |
937835 | 937835 | 2021-01-17 | St. Tammany | Louisiana | 22103 | 19309 | 396 |
934590 | 934590 | 2021-01-16 | St. Tammany | Louisiana | 22103 | 18989 | 384 |
931345 | 931345 | 2021-01-15 | St. Tammany | Louisiana | 22103 | 18989 | 384 |
928100 | 928100 | 2021-01-14 | St. Tammany | Louisiana | 22103 | 18481 | 384 |
924854 | 924854 | 2021-01-13 | St. Tammany | Louisiana | 22103 | 17756 | 379 |
921609 | 921609 | 2021-01-12 | St. Tammany | Louisiana | 22103 | 17601 | 376 |
918364 | 918364 | 2021-01-11 | St. Tammany | Louisiana | 22103 | 17336 | 373 |
915119 | 915119 | 2021-01-10 | St. Tammany | Louisiana | 22103 | 17215 | 369 |
911874 | 911874 | 2021-01-09 | St. Tammany | Louisiana | 22103 | 16910 | 368 |
908629 | 908629 | 2021-01-08 | St. Tammany | Louisiana | 22103 | 16910 | 368 |
905383 | 905383 | 2021-01-07 | St. Tammany | Louisiana | 22103 | 16699 | 360 |
902138 | 902138 | 2021-01-06 | St. Tammany | Louisiana | 22103 | 16425 | 358 |
898893 | 898893 | 2021-01-05 | St. Tammany | Louisiana | 22103 | 16099 | 354 |
895648 | 895648 | 2021-01-04 | St. Tammany | Louisiana | 22103 | 15838 | 351 |
892401 | 892401 | 2021-01-03 | St. Tammany | Louisiana | 22103 | 15735 | 348 |
889155 | 889155 | 2021-01-02 | St. Tammany | Louisiana | 22103 | 15312 | 345 |
885909 | 885909 | 2021-01-01 | St. Tammany | Louisiana | 22103 | 15312 | 345 |
882664 | 882664 | 2020-12-31 | St. Tammany | Louisiana | 22103 | 15312 | 345 |
879419 | 879419 | 2020-12-30 | St. Tammany | Louisiana | 22103 | 15033 | 342 |
876174 | 876174 | 2020-12-29 | St. Tammany | Louisiana | 22103 | 14686 | 339 |
872929 | 872929 | 2020-12-28 | St. Tammany | Louisiana | 22103 | 14462 | 335 |
869684 | 869684 | 2020-12-27 | St. Tammany | Louisiana | 22103 | 14401 | 326 |
866439 | 866439 | 2020-12-26 | St. Tammany | Louisiana | 22103 | 14111 | 326 |
863194 | 863194 | 2020-12-25 | St. Tammany | Louisiana | 22103 | 14111 | 326 |
859949 | 859949 | 2020-12-24 | St. Tammany | Louisiana | 22103 | 14111 | 326 |
856704 | 856704 | 2020-12-23 | St. Tammany | Louisiana | 22103 | 13944 | 324 |
853459 | 853459 | 2020-12-22 | St. Tammany | Louisiana | 22103 | 13701 | 322 |
850214 | 850214 | 2020-12-21 | St. Tammany | Louisiana | 22103 | 13551 | 321 |
846969 | 846969 | 2020-12-20 | St. Tammany | Louisiana | 22103 | 13443 | 320 |
843723 | 843723 | 2020-12-19 | St. Tammany | Louisiana | 22103 | 13258 | 318 |
840478 | 840478 | 2020-12-18 | St. Tammany | Louisiana | 22103 | 13258 | 318 |
837233 | 837233 | 2020-12-17 | St. Tammany | Louisiana | 22103 | 13106 | 316 |
833987 | 833987 | 2020-12-16 | St. Tammany | Louisiana | 22103 | 12904 | 310 |
830740 | 830740 | 2020-12-15 | St. Tammany | Louisiana | 22103 | 12622 | 308 |
827494 | 827494 | 2020-12-14 | St. Tammany | Louisiana | 22103 | 12334 | 307 |
824247 | 824247 | 2020-12-13 | St. Tammany | Louisiana | 22103 | 12257 | 306 |
821001 | 821001 | 2020-12-12 | St. Tammany | Louisiana | 22103 | 12029 | 305 |
817755 | 817755 | 2020-12-11 | St. Tammany | Louisiana | 22103 | 12029 | 305 |
814509 | 814509 | 2020-12-10 | St. Tammany | Louisiana | 22103 | 11920 | 302 |
811264 | 811264 | 2020-12-09 | St. Tammany | Louisiana | 22103 | 11780 | 302 |
808019 | 808019 | 2020-12-08 | St. Tammany | Louisiana | 22103 | 11502 | 301 |
804774 | 804774 | 2020-12-07 | St. Tammany | Louisiana | 22103 | 11365 | 300 |
801529 | 801529 | 2020-12-06 | St. Tammany | Louisiana | 22103 | 11305 | 300 |
798284 | 798284 | 2020-12-05 | St. Tammany | Louisiana | 22103 | 11128 | 298 |
795039 | 795039 | 2020-12-04 | St. Tammany | Louisiana | 22103 | 11128 | 298 |
791794 | 791794 | 2020-12-03 | St. Tammany | Louisiana | 22103 | 10983 | 296 |
788549 | 788549 | 2020-12-02 | St. Tammany | Louisiana | 22103 | 10878 | 296 |
785305 | 785305 | 2020-12-01 | St. Tammany | Louisiana | 22103 | 10678 | 294 |
782060 | 782060 | 2020-11-30 | St. Tammany | Louisiana | 22103 | 10379 | 292 |
778814 | 778814 | 2020-11-29 | St. Tammany | Louisiana | 22103 | 10383 | 291 |
775569 | 775569 | 2020-11-28 | St. Tammany | Louisiana | 22103 | 10283 | 291 |
772324 | 772324 | 2020-11-27 | St. Tammany | Louisiana | 22103 | 10283 | 291 |
769079 | 769079 | 2020-11-26 | St. Tammany | Louisiana | 22103 | 9931 | 290 |
765833 | 765833 | 2020-11-25 | St. Tammany | Louisiana | 22103 | 9931 | 290 |
762588 | 762588 | 2020-11-24 | St. Tammany | Louisiana | 22103 | 9896 | 289 |
759343 | 759343 | 2020-11-23 | St. Tammany | Louisiana | 22103 | 9730 | 289 |
756096 | 756096 | 2020-11-22 | St. Tammany | Louisiana | 22103 | 9672 | 288 |
752850 | 752850 | 2020-11-21 | St. Tammany | Louisiana | 22103 | 9514 | 288 |
749604 | 749604 | 2020-11-20 | St. Tammany | Louisiana | 22103 | 9514 | 288 |
746358 | 746358 | 2020-11-19 | St. Tammany | Louisiana | 22103 | 9255 | 287 |
743111 | 743111 | 2020-11-18 | St. Tammany | Louisiana | 22103 | 9193 | 285 |
739864 | 739864 | 2020-11-17 | St. Tammany | Louisiana | 22103 | 9020 | 284 |
736620 | 736620 | 2020-11-16 | St. Tammany | Louisiana | 22103 | 8931 | 284 |
733374 | 733374 | 2020-11-15 | St. Tammany | Louisiana | 22103 | 8908 | 283 |
730129 | 730129 | 2020-11-14 | St. Tammany | Louisiana | 22103 | 8829 | 283 |
726886 | 726886 | 2020-11-13 | St. Tammany | Louisiana | 22103 | 8829 | 283 |
723643 | 723643 | 2020-11-12 | St. Tammany | Louisiana | 22103 | 8116 | 277 |
720400 | 720400 | 2020-11-11 | St. Tammany | Louisiana | 22103 | 8048 | 277 |
717157 | 717157 | 2020-11-10 | St. Tammany | Louisiana | 22103 | 8048 | 277 |
713913 | 713913 | 2020-11-09 | St. Tammany | Louisiana | 22103 | 8002 | 277 |
710669 | 710669 | 2020-11-08 | St. Tammany | Louisiana | 22103 | 7982 | 275 |
707425 | 707425 | 2020-11-07 | St. Tammany | Louisiana | 22103 | 7940 | 274 |
704182 | 704182 | 2020-11-06 | St. Tammany | Louisiana | 22103 | 7940 | 274 |
700940 | 700940 | 2020-11-05 | St. Tammany | Louisiana | 22103 | 7889 | 273 |
697696 | 697696 | 2020-11-04 | St. Tammany | Louisiana | 22103 | 7860 | 272 |
694453 | 694453 | 2020-11-03 | St. Tammany | Louisiana | 22103 | 7849 | 272 |
691211 | 691211 | 2020-11-02 | St. Tammany | Louisiana | 22103 | 7813 | 272 |
687966 | 687966 | 2020-11-01 | St. Tammany | Louisiana | 22103 | 7803 | 271 |
684722 | 684722 | 2020-10-31 | St. Tammany | Louisiana | 22103 | 7764 | 271 |
681479 | 681479 | 2020-10-30 | St. Tammany | Louisiana | 22103 | 7764 | 271 |
678235 | 678235 | 2020-10-29 | St. Tammany | Louisiana | 22103 | 7765 | 271 |
674993 | 674993 | 2020-10-28 | St. Tammany | Louisiana | 22103 | 7749 | 270 |
671750 | 671750 | 2020-10-27 | St. Tammany | Louisiana | 22103 | 7727 | 270 |
668508 | 668508 | 2020-10-26 | St. Tammany | Louisiana | 22103 | 7689 | 270 |
665264 | 665264 | 2020-10-25 | St. Tammany | Louisiana | 22103 | 7679 | 270 |
662019 | 662019 | 2020-10-24 | St. Tammany | Louisiana | 22103 | 7640 | 269 |
658775 | 658775 | 2020-10-23 | St. Tammany | Louisiana | 22103 | 7640 | 269 |
655530 | 655530 | 2020-10-22 | St. Tammany | Louisiana | 22103 | 7602 | 269 |
652285 | 652285 | 2020-10-21 | St. Tammany | Louisiana | 22103 | 7580 | 269 |
649040 | 649040 | 2020-10-20 | St. Tammany | Louisiana | 22103 | 7559 | 269 |
645796 | 645796 | 2020-10-19 | St. Tammany | Louisiana | 22103 | 7534 | 269 |
642549 | 642549 | 2020-10-18 | St. Tammany | Louisiana | 22103 | 7516 | 269 |
639302 | 639302 | 2020-10-17 | St. Tammany | Louisiana | 22103 | 7479 | 269 |
636056 | 636056 | 2020-10-16 | St. Tammany | Louisiana | 22103 | 7479 | 269 |
632810 | 632810 | 2020-10-15 | St. Tammany | Louisiana | 22103 | 7456 | 269 |
629566 | 629566 | 2020-10-14 | St. Tammany | Louisiana | 22103 | 7451 | 269 |
626322 | 626322 | 2020-10-13 | St. Tammany | Louisiana | 22103 | 7446 | 269 |
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);