ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "St. Martin" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947570 | 947570 | 2021-01-20 | St. Martin | Louisiana | 22099 | 4409 | 99 |
944323 | 944323 | 2021-01-19 | St. Martin | Louisiana | 22099 | 4388 | 98 |
941078 | 941078 | 2021-01-18 | St. Martin | Louisiana | 22099 | 4331 | 95 |
937833 | 937833 | 2021-01-17 | St. Martin | Louisiana | 22099 | 4321 | 95 |
934588 | 934588 | 2021-01-16 | St. Martin | Louisiana | 22099 | 4269 | 94 |
931343 | 931343 | 2021-01-15 | St. Martin | Louisiana | 22099 | 4269 | 94 |
928098 | 928098 | 2021-01-14 | St. Martin | Louisiana | 22099 | 4268 | 94 |
924852 | 924852 | 2021-01-13 | St. Martin | Louisiana | 22099 | 4212 | 93 |
921607 | 921607 | 2021-01-12 | St. Martin | Louisiana | 22099 | 4187 | 93 |
918362 | 918362 | 2021-01-11 | St. Martin | Louisiana | 22099 | 4101 | 92 |
915117 | 915117 | 2021-01-10 | St. Martin | Louisiana | 22099 | 4095 | 92 |
911872 | 911872 | 2021-01-09 | St. Martin | Louisiana | 22099 | 4047 | 90 |
908627 | 908627 | 2021-01-08 | St. Martin | Louisiana | 22099 | 4047 | 90 |
905381 | 905381 | 2021-01-07 | St. Martin | Louisiana | 22099 | 4028 | 87 |
902136 | 902136 | 2021-01-06 | St. Martin | Louisiana | 22099 | 3973 | 87 |
898891 | 898891 | 2021-01-05 | St. Martin | Louisiana | 22099 | 3906 | 86 |
895646 | 895646 | 2021-01-04 | St. Martin | Louisiana | 22099 | 3851 | 85 |
892399 | 892399 | 2021-01-03 | St. Martin | Louisiana | 22099 | 3837 | 83 |
889153 | 889153 | 2021-01-02 | St. Martin | Louisiana | 22099 | 3804 | 82 |
885907 | 885907 | 2021-01-01 | St. Martin | Louisiana | 22099 | 3804 | 82 |
882662 | 882662 | 2020-12-31 | St. Martin | Louisiana | 22099 | 3804 | 82 |
879417 | 879417 | 2020-12-30 | St. Martin | Louisiana | 22099 | 3750 | 82 |
876172 | 876172 | 2020-12-29 | St. Martin | Louisiana | 22099 | 3695 | 82 |
872927 | 872927 | 2020-12-28 | St. Martin | Louisiana | 22099 | 3608 | 81 |
869682 | 869682 | 2020-12-27 | St. Martin | Louisiana | 22099 | 3605 | 81 |
866437 | 866437 | 2020-12-26 | St. Martin | Louisiana | 22099 | 3588 | 81 |
863192 | 863192 | 2020-12-25 | St. Martin | Louisiana | 22099 | 3588 | 81 |
859947 | 859947 | 2020-12-24 | St. Martin | Louisiana | 22099 | 3588 | 81 |
856702 | 856702 | 2020-12-23 | St. Martin | Louisiana | 22099 | 3519 | 80 |
853457 | 853457 | 2020-12-22 | St. Martin | Louisiana | 22099 | 3482 | 80 |
850212 | 850212 | 2020-12-21 | St. Martin | Louisiana | 22099 | 3416 | 79 |
846967 | 846967 | 2020-12-20 | St. Martin | Louisiana | 22099 | 3407 | 78 |
843721 | 843721 | 2020-12-19 | St. Martin | Louisiana | 22099 | 3367 | 78 |
840476 | 840476 | 2020-12-18 | St. Martin | Louisiana | 22099 | 3367 | 78 |
837231 | 837231 | 2020-12-17 | St. Martin | Louisiana | 22099 | 3330 | 78 |
833985 | 833985 | 2020-12-16 | St. Martin | Louisiana | 22099 | 3294 | 78 |
830738 | 830738 | 2020-12-15 | St. Martin | Louisiana | 22099 | 3243 | 78 |
827492 | 827492 | 2020-12-14 | St. Martin | Louisiana | 22099 | 3185 | 75 |
824245 | 824245 | 2020-12-13 | St. Martin | Louisiana | 22099 | 3182 | 75 |
820999 | 820999 | 2020-12-12 | St. Martin | Louisiana | 22099 | 3131 | 75 |
817753 | 817753 | 2020-12-11 | St. Martin | Louisiana | 22099 | 3131 | 75 |
814507 | 814507 | 2020-12-10 | St. Martin | Louisiana | 22099 | 3105 | 75 |
811262 | 811262 | 2020-12-09 | St. Martin | Louisiana | 22099 | 3084 | 75 |
808017 | 808017 | 2020-12-08 | St. Martin | Louisiana | 22099 | 2961 | 75 |
804772 | 804772 | 2020-12-07 | St. Martin | Louisiana | 22099 | 2935 | 74 |
801527 | 801527 | 2020-12-06 | St. Martin | Louisiana | 22099 | 2924 | 74 |
798282 | 798282 | 2020-12-05 | St. Martin | Louisiana | 22099 | 2879 | 73 |
795037 | 795037 | 2020-12-04 | St. Martin | Louisiana | 22099 | 2879 | 73 |
791792 | 791792 | 2020-12-03 | St. Martin | Louisiana | 22099 | 2845 | 73 |
788547 | 788547 | 2020-12-02 | St. Martin | Louisiana | 22099 | 2812 | 73 |
785303 | 785303 | 2020-12-01 | St. Martin | Louisiana | 22099 | 2796 | 72 |
782058 | 782058 | 2020-11-30 | St. Martin | Louisiana | 22099 | 2721 | 71 |
778812 | 778812 | 2020-11-29 | St. Martin | Louisiana | 22099 | 2719 | 71 |
775567 | 775567 | 2020-11-28 | St. Martin | Louisiana | 22099 | 2704 | 71 |
772322 | 772322 | 2020-11-27 | St. Martin | Louisiana | 22099 | 2704 | 71 |
769077 | 769077 | 2020-11-26 | St. Martin | Louisiana | 22099 | 2669 | 71 |
765831 | 765831 | 2020-11-25 | St. Martin | Louisiana | 22099 | 2669 | 71 |
762586 | 762586 | 2020-11-24 | St. Martin | Louisiana | 22099 | 2653 | 71 |
759341 | 759341 | 2020-11-23 | St. Martin | Louisiana | 22099 | 2580 | 70 |
756094 | 756094 | 2020-11-22 | St. Martin | Louisiana | 22099 | 2590 | 70 |
752848 | 752848 | 2020-11-21 | St. Martin | Louisiana | 22099 | 2545 | 70 |
749602 | 749602 | 2020-11-20 | St. Martin | Louisiana | 22099 | 2545 | 70 |
746356 | 746356 | 2020-11-19 | St. Martin | Louisiana | 22099 | 2528 | 70 |
743109 | 743109 | 2020-11-18 | St. Martin | Louisiana | 22099 | 2513 | 70 |
739862 | 739862 | 2020-11-17 | St. Martin | Louisiana | 22099 | 2496 | 70 |
736618 | 736618 | 2020-11-16 | St. Martin | Louisiana | 22099 | 2452 | 70 |
733372 | 733372 | 2020-11-15 | St. Martin | Louisiana | 22099 | 2443 | 70 |
730127 | 730127 | 2020-11-14 | St. Martin | Louisiana | 22099 | 2407 | 70 |
726884 | 726884 | 2020-11-13 | St. Martin | Louisiana | 22099 | 2407 | 70 |
723641 | 723641 | 2020-11-12 | St. Martin | Louisiana | 22099 | 2343 | 65 |
720398 | 720398 | 2020-11-11 | St. Martin | Louisiana | 22099 | 2328 | 65 |
717155 | 717155 | 2020-11-10 | St. Martin | Louisiana | 22099 | 2328 | 65 |
713911 | 713911 | 2020-11-09 | St. Martin | Louisiana | 22099 | 2302 | 65 |
710667 | 710667 | 2020-11-08 | St. Martin | Louisiana | 22099 | 2302 | 65 |
707423 | 707423 | 2020-11-07 | St. Martin | Louisiana | 22099 | 2295 | 64 |
704180 | 704180 | 2020-11-06 | St. Martin | Louisiana | 22099 | 2295 | 64 |
700938 | 700938 | 2020-11-05 | St. Martin | Louisiana | 22099 | 2276 | 64 |
697694 | 697694 | 2020-11-04 | St. Martin | Louisiana | 22099 | 2273 | 64 |
694451 | 694451 | 2020-11-03 | St. Martin | Louisiana | 22099 | 2283 | 64 |
691209 | 691209 | 2020-11-02 | St. Martin | Louisiana | 22099 | 2271 | 64 |
687964 | 687964 | 2020-11-01 | St. Martin | Louisiana | 22099 | 2259 | 64 |
684720 | 684720 | 2020-10-31 | St. Martin | Louisiana | 22099 | 2237 | 64 |
681477 | 681477 | 2020-10-30 | St. Martin | Louisiana | 22099 | 2237 | 64 |
678233 | 678233 | 2020-10-29 | St. Martin | Louisiana | 22099 | 2230 | 64 |
674991 | 674991 | 2020-10-28 | St. Martin | Louisiana | 22099 | 2230 | 64 |
671748 | 671748 | 2020-10-27 | St. Martin | Louisiana | 22099 | 2218 | 63 |
668506 | 668506 | 2020-10-26 | St. Martin | Louisiana | 22099 | 2215 | 63 |
665262 | 665262 | 2020-10-25 | St. Martin | Louisiana | 22099 | 2208 | 63 |
662017 | 662017 | 2020-10-24 | St. Martin | Louisiana | 22099 | 2201 | 63 |
658773 | 658773 | 2020-10-23 | St. Martin | Louisiana | 22099 | 2201 | 63 |
655528 | 655528 | 2020-10-22 | St. Martin | Louisiana | 22099 | 2191 | 63 |
652283 | 652283 | 2020-10-21 | St. Martin | Louisiana | 22099 | 2183 | 63 |
649038 | 649038 | 2020-10-20 | St. Martin | Louisiana | 22099 | 2183 | 63 |
645794 | 645794 | 2020-10-19 | St. Martin | Louisiana | 22099 | 2162 | 62 |
642547 | 642547 | 2020-10-18 | St. Martin | Louisiana | 22099 | 2162 | 62 |
639300 | 639300 | 2020-10-17 | St. Martin | Louisiana | 22099 | 2152 | 61 |
636054 | 636054 | 2020-10-16 | St. Martin | Louisiana | 22099 | 2152 | 61 |
632808 | 632808 | 2020-10-15 | St. Martin | Louisiana | 22099 | 2142 | 61 |
629564 | 629564 | 2020-10-14 | St. Martin | Louisiana | 22099 | 2149 | 61 |
626320 | 626320 | 2020-10-13 | St. Martin | Louisiana | 22099 | 2140 | 61 |
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);