ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "St. Louis" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
935017 | 935017 | 2021-01-16 | St. Louis | Missouri | 29189 | 78024 | 1563 |
931772 | 931772 | 2021-01-15 | St. Louis | Missouri | 29189 | 77487 | 1554 |
928527 | 928527 | 2021-01-14 | St. Louis | Missouri | 29189 | 77057 | 1547 |
925281 | 925281 | 2021-01-13 | St. Louis | Missouri | 29189 | 76601 | 1530 |
922036 | 922036 | 2021-01-12 | St. Louis | Missouri | 29189 | 76107 | 1514 |
918791 | 918791 | 2021-01-11 | St. Louis | Missouri | 29189 | 75623 | 1476 |
915546 | 915546 | 2021-01-10 | St. Louis | Missouri | 29189 | 75200 | 1475 |
912301 | 912301 | 2021-01-09 | St. Louis | Missouri | 29189 | 74745 | 1475 |
909056 | 909056 | 2021-01-08 | St. Louis | Missouri | 29189 | 73847 | 1466 |
905810 | 905810 | 2021-01-07 | St. Louis | Missouri | 29189 | 73293 | 1456 |
902565 | 902565 | 2021-01-06 | St. Louis | Missouri | 29189 | 71901 | 1408 |
899320 | 899320 | 2021-01-05 | St. Louis | Missouri | 29189 | 71901 | 1406 |
896075 | 896075 | 2021-01-04 | St. Louis | Missouri | 29189 | 71447 | 1392 |
892828 | 892828 | 2021-01-03 | St. Louis | Missouri | 29189 | 70999 | 1392 |
889582 | 889582 | 2021-01-02 | St. Louis | Missouri | 29189 | 70402 | 1392 |
886336 | 886336 | 2021-01-01 | St. Louis | Missouri | 29189 | 69480 | 1391 |
883091 | 883091 | 2020-12-31 | St. Louis | Missouri | 29189 | 69480 | 1391 |
879846 | 879846 | 2020-12-30 | St. Louis | Missouri | 29189 | 68821 | 1384 |
876601 | 876601 | 2020-12-29 | St. Louis | Missouri | 29189 | 68226 | 1356 |
873356 | 873356 | 2020-12-28 | St. Louis | Missouri | 29189 | 67459 | 1342 |
870111 | 870111 | 2020-12-27 | St. Louis | Missouri | 29189 | 67120 | 1342 |
866866 | 866866 | 2020-12-26 | St. Louis | Missouri | 29189 | 66843 | 1342 |
863621 | 863621 | 2020-12-25 | St. Louis | Missouri | 29189 | 66284 | 1334 |
860376 | 860376 | 2020-12-24 | St. Louis | Missouri | 29189 | 66284 | 1334 |
857131 | 857131 | 2020-12-23 | St. Louis | Missouri | 29189 | 65794 | 1324 |
853886 | 853886 | 2020-12-22 | St. Louis | Missouri | 29189 | 65266 | 1312 |
850641 | 850641 | 2020-12-21 | St. Louis | Missouri | 29189 | 64879 | 1290 |
847396 | 847396 | 2020-12-20 | St. Louis | Missouri | 29189 | 64375 | 1281 |
844150 | 844150 | 2020-12-19 | St. Louis | Missouri | 29189 | 63872 | 1260 |
840905 | 840905 | 2020-12-18 | St. Louis | Missouri | 29189 | 63160 | 1223 |
837660 | 837660 | 2020-12-17 | St. Louis | Missouri | 29189 | 62531 | 1215 |
834414 | 834414 | 2020-12-16 | St. Louis | Missouri | 29189 | 61978 | 1199 |
831167 | 831167 | 2020-12-15 | St. Louis | Missouri | 29189 | 61500 | 1175 |
827921 | 827921 | 2020-12-14 | St. Louis | Missouri | 29189 | 60837 | 1153 |
824674 | 824674 | 2020-12-13 | St. Louis | Missouri | 29189 | 60065 | 1153 |
821428 | 821428 | 2020-12-12 | St. Louis | Missouri | 29189 | 59470 | 1152 |
818182 | 818182 | 2020-12-11 | St. Louis | Missouri | 29189 | 58921 | 1147 |
814936 | 814936 | 2020-12-10 | St. Louis | Missouri | 29189 | 58197 | 1143 |
811691 | 811691 | 2020-12-09 | St. Louis | Missouri | 29189 | 57538 | 1128 |
808446 | 808446 | 2020-12-08 | St. Louis | Missouri | 29189 | 57091 | 1109 |
805201 | 805201 | 2020-12-07 | St. Louis | Missouri | 29189 | 56500 | 1098 |
801956 | 801956 | 2020-12-06 | St. Louis | Missouri | 29189 | 55883 | 1098 |
798711 | 798711 | 2020-12-05 | St. Louis | Missouri | 29189 | 55278 | 1098 |
795466 | 795466 | 2020-12-04 | St. Louis | Missouri | 29189 | 54376 | 1084 |
792221 | 792221 | 2020-12-03 | St. Louis | Missouri | 29189 | 53688 | 1035 |
788976 | 788976 | 2020-12-02 | St. Louis | Missouri | 29189 | 52993 | 1008 |
785731 | 785731 | 2020-12-01 | St. Louis | Missouri | 29189 | 52421 | 990 |
782487 | 782487 | 2020-11-30 | St. Louis | Missouri | 29189 | 51819 | 980 |
779241 | 779241 | 2020-11-29 | St. Louis | Missouri | 29189 | 51324 | 976 |
775996 | 775996 | 2020-11-28 | St. Louis | Missouri | 29189 | 50729 | 976 |
772751 | 772751 | 2020-11-27 | St. Louis | Missouri | 29189 | 50033 | 976 |
769506 | 769506 | 2020-11-26 | St. Louis | Missouri | 29189 | 49567 | 976 |
766260 | 766260 | 2020-11-25 | St. Louis | Missouri | 29189 | 48786 | 971 |
763015 | 763015 | 2020-11-24 | St. Louis | Missouri | 29189 | 47884 | 965 |
759770 | 759770 | 2020-11-23 | St. Louis | Missouri | 29189 | 46954 | 944 |
756523 | 756523 | 2020-11-22 | St. Louis | Missouri | 29189 | 46357 | 944 |
753277 | 753277 | 2020-11-21 | St. Louis | Missouri | 29189 | 45635 | 944 |
750031 | 750031 | 2020-11-20 | St. Louis | Missouri | 29189 | 44897 | 943 |
746785 | 746785 | 2020-11-19 | St. Louis | Missouri | 29189 | 44194 | 927 |
743538 | 743538 | 2020-11-18 | St. Louis | Missouri | 29189 | 43581 | 921 |
740291 | 740291 | 2020-11-17 | St. Louis | Missouri | 29189 | 42841 | 922 |
737047 | 737047 | 2020-11-16 | St. Louis | Missouri | 29189 | 42043 | 917 |
733801 | 733801 | 2020-11-15 | St. Louis | Missouri | 29189 | 40982 | 914 |
730556 | 730556 | 2020-11-14 | St. Louis | Missouri | 29189 | 40359 | 914 |
727313 | 727313 | 2020-11-13 | St. Louis | Missouri | 29189 | 39554 | 912 |
724070 | 724070 | 2020-11-12 | St. Louis | Missouri | 29189 | 38620 | 911 |
720827 | 720827 | 2020-11-11 | St. Louis | Missouri | 29189 | 37658 | 904 |
717584 | 717584 | 2020-11-10 | St. Louis | Missouri | 29189 | 37016 | 900 |
714340 | 714340 | 2020-11-09 | St. Louis | Missouri | 29189 | 36172 | 897 |
711096 | 711096 | 2020-11-08 | St. Louis | Missouri | 29189 | 35624 | 897 |
707852 | 707852 | 2020-11-07 | St. Louis | Missouri | 29189 | 35219 | 897 |
704609 | 704609 | 2020-11-06 | St. Louis | Missouri | 29189 | 34593 | 895 |
701367 | 701367 | 2020-11-05 | St. Louis | Missouri | 29189 | 33920 | 895 |
698123 | 698123 | 2020-11-04 | St. Louis | Missouri | 29189 | 33375 | 895 |
694880 | 694880 | 2020-11-03 | St. Louis | Missouri | 29189 | 32801 | 894 |
691638 | 691638 | 2020-11-02 | St. Louis | Missouri | 29189 | 32500 | 891 |
688393 | 688393 | 2020-11-01 | St. Louis | Missouri | 29189 | 31992 | 891 |
685149 | 685149 | 2020-10-31 | St. Louis | Missouri | 29189 | 31585 | 892 |
681906 | 681906 | 2020-10-30 | St. Louis | Missouri | 29189 | 31357 | 889 |
678662 | 678662 | 2020-10-29 | St. Louis | Missouri | 29189 | 30852 | 890 |
675420 | 675420 | 2020-10-28 | St. Louis | Missouri | 29189 | 30566 | 886 |
672177 | 672177 | 2020-10-27 | St. Louis | Missouri | 29189 | 30135 | 885 |
668935 | 668935 | 2020-10-26 | St. Louis | Missouri | 29189 | 29962 | 870 |
665691 | 665691 | 2020-10-25 | St. Louis | Missouri | 29189 | 29588 | 870 |
662446 | 662446 | 2020-10-24 | St. Louis | Missouri | 29189 | 29396 | 871 |
659202 | 659202 | 2020-10-23 | St. Louis | Missouri | 29189 | 29143 | 867 |
655957 | 655957 | 2020-10-22 | St. Louis | Missouri | 29189 | 28842 | 865 |
652712 | 652712 | 2020-10-21 | St. Louis | Missouri | 29189 | 28626 | 860 |
649467 | 649467 | 2020-10-20 | St. Louis | Missouri | 29189 | 28380 | 860 |
646223 | 646223 | 2020-10-19 | St. Louis | Missouri | 29189 | 28239 | 857 |
642977 | 642977 | 2020-10-18 | St. Louis | Missouri | 29189 | 27900 | 857 |
639729 | 639729 | 2020-10-17 | St. Louis | Missouri | 29189 | 27603 | 857 |
636483 | 636483 | 2020-10-16 | St. Louis | Missouri | 29189 | 27472 | 854 |
633237 | 633237 | 2020-10-15 | St. Louis | Missouri | 29189 | 27050 | 854 |
629992 | 629992 | 2020-10-14 | St. Louis | Missouri | 29189 | 26881 | 872 |
626748 | 626748 | 2020-10-13 | St. Louis | Missouri | 29189 | 26675 | 839 |
623506 | 623506 | 2020-10-12 | St. Louis | Missouri | 29189 | 26517 | 839 |
620263 | 620263 | 2020-10-11 | St. Louis | Missouri | 29189 | 26342 | 839 |
617021 | 617021 | 2020-10-10 | St. Louis | Missouri | 29189 | 26134 | 839 |
613780 | 613780 | 2020-10-09 | St. Louis | Missouri | 29189 | 25937 | 835 |
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);