ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29047 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934938 | 934938 | 2021-01-16 | Clay | Missouri | 29047 | 8179 | 118 |
931693 | 931693 | 2021-01-15 | Clay | Missouri | 29047 | 8179 | 118 |
928448 | 928448 | 2021-01-14 | Clay | Missouri | 29047 | 8129 | 118 |
925202 | 925202 | 2021-01-13 | Clay | Missouri | 29047 | 8088 | 118 |
921957 | 921957 | 2021-01-12 | Clay | Missouri | 29047 | 7927 | 117 |
918712 | 918712 | 2021-01-11 | Clay | Missouri | 29047 | 7872 | 113 |
915467 | 915467 | 2021-01-10 | Clay | Missouri | 29047 | 7671 | 113 |
912222 | 912222 | 2021-01-09 | Clay | Missouri | 29047 | 7671 | 113 |
908977 | 908977 | 2021-01-08 | Clay | Missouri | 29047 | 7671 | 113 |
905731 | 905731 | 2021-01-07 | Clay | Missouri | 29047 | 7609 | 112 |
902486 | 902486 | 2021-01-06 | Clay | Missouri | 29047 | 7473 | 107 |
899241 | 899241 | 2021-01-05 | Clay | Missouri | 29047 | 7398 | 103 |
895996 | 895996 | 2021-01-04 | Clay | Missouri | 29047 | 7340 | 98 |
892749 | 892749 | 2021-01-03 | Clay | Missouri | 29047 | 7134 | 98 |
889503 | 889503 | 2021-01-02 | Clay | Missouri | 29047 | 7134 | 98 |
886257 | 886257 | 2021-01-01 | Clay | Missouri | 29047 | 7134 | 98 |
883012 | 883012 | 2020-12-31 | Clay | Missouri | 29047 | 7134 | 98 |
879767 | 879767 | 2020-12-30 | Clay | Missouri | 29047 | 7108 | 98 |
876522 | 876522 | 2020-12-29 | Clay | Missouri | 29047 | 6882 | 97 |
873277 | 873277 | 2020-12-28 | Clay | Missouri | 29047 | 6828 | 95 |
870032 | 870032 | 2020-12-27 | Clay | Missouri | 29047 | 6644 | 94 |
866787 | 866787 | 2020-12-26 | Clay | Missouri | 29047 | 6644 | 93 |
863542 | 863542 | 2020-12-25 | Clay | Missouri | 29047 | 6644 | 93 |
860297 | 860297 | 2020-12-24 | Clay | Missouri | 29047 | 6644 | 93 |
857052 | 857052 | 2020-12-23 | Clay | Missouri | 29047 | 6644 | 91 |
853807 | 853807 | 2020-12-22 | Clay | Missouri | 29047 | 6587 | 91 |
850562 | 850562 | 2020-12-21 | Clay | Missouri | 29047 | 6503 | 90 |
847317 | 847317 | 2020-12-20 | Clay | Missouri | 29047 | 6360 | 87 |
844071 | 844071 | 2020-12-19 | Clay | Missouri | 29047 | 6360 | 87 |
840826 | 840826 | 2020-12-18 | Clay | Missouri | 29047 | 6360 | 87 |
837581 | 837581 | 2020-12-17 | Clay | Missouri | 29047 | 6305 | 87 |
834335 | 834335 | 2020-12-16 | Clay | Missouri | 29047 | 6246 | 86 |
831088 | 831088 | 2020-12-15 | Clay | Missouri | 29047 | 6067 | 86 |
827842 | 827842 | 2020-12-14 | Clay | Missouri | 29047 | 6018 | 84 |
824595 | 824595 | 2020-12-13 | Clay | Missouri | 29047 | 5915 | 84 |
821349 | 821349 | 2020-12-12 | Clay | Missouri | 29047 | 5915 | 84 |
818103 | 818103 | 2020-12-11 | Clay | Missouri | 29047 | 5915 | 84 |
814857 | 814857 | 2020-12-10 | Clay | Missouri | 29047 | 5851 | 84 |
811612 | 811612 | 2020-12-09 | Clay | Missouri | 29047 | 5745 | 84 |
808367 | 808367 | 2020-12-08 | Clay | Missouri | 29047 | 5581 | 84 |
805122 | 805122 | 2020-12-07 | Clay | Missouri | 29047 | 5528 | 84 |
801877 | 801877 | 2020-12-06 | Clay | Missouri | 29047 | 5390 | 84 |
798632 | 798632 | 2020-12-05 | Clay | Missouri | 29047 | 5390 | 84 |
795387 | 795387 | 2020-12-04 | Clay | Missouri | 29047 | 5390 | 84 |
792142 | 792142 | 2020-12-03 | Clay | Missouri | 29047 | 5108 | 76 |
788897 | 788897 | 2020-12-02 | Clay | Missouri | 29047 | 5048 | 77 |
785652 | 785652 | 2020-12-01 | Clay | Missouri | 29047 | 4959 | 73 |
782408 | 782408 | 2020-11-30 | Clay | Missouri | 29047 | 4921 | 69 |
779162 | 779162 | 2020-11-29 | Clay | Missouri | 29047 | 4583 | 69 |
775917 | 775917 | 2020-11-28 | Clay | Missouri | 29047 | 4553 | 68 |
772672 | 772672 | 2020-11-27 | Clay | Missouri | 29047 | 4511 | 68 |
769427 | 769427 | 2020-11-26 | Clay | Missouri | 29047 | 4472 | 68 |
766181 | 766181 | 2020-11-25 | Clay | Missouri | 29047 | 4472 | 66 |
762936 | 762936 | 2020-11-24 | Clay | Missouri | 29047 | 4425 | 66 |
759691 | 759691 | 2020-11-23 | Clay | Missouri | 29047 | 4347 | 66 |
756444 | 756444 | 2020-11-22 | Clay | Missouri | 29047 | 4314 | 66 |
753198 | 753198 | 2020-11-21 | Clay | Missouri | 29047 | 4213 | 66 |
749952 | 749952 | 2020-11-20 | Clay | Missouri | 29047 | 4204 | 66 |
746706 | 746706 | 2020-11-19 | Clay | Missouri | 29047 | 4095 | 60 |
743459 | 743459 | 2020-11-18 | Clay | Missouri | 29047 | 4028 | 60 |
740212 | 740212 | 2020-11-17 | Clay | Missouri | 29047 | 3937 | 58 |
736968 | 736968 | 2020-11-16 | Clay | Missouri | 29047 | 3796 | 58 |
733722 | 733722 | 2020-11-15 | Clay | Missouri | 29047 | 3652 | 58 |
730477 | 730477 | 2020-11-14 | Clay | Missouri | 29047 | 3652 | 58 |
727234 | 727234 | 2020-11-13 | Clay | Missouri | 29047 | 3644 | 57 |
723991 | 723991 | 2020-11-12 | Clay | Missouri | 29047 | 3508 | 63 |
720748 | 720748 | 2020-11-11 | Clay | Missouri | 29047 | 3410 | 64 |
717505 | 717505 | 2020-11-10 | Clay | Missouri | 29047 | 3410 | 64 |
714261 | 714261 | 2020-11-09 | Clay | Missouri | 29047 | 3332 | 61 |
711017 | 711017 | 2020-11-08 | Clay | Missouri | 29047 | 3130 | 60 |
707773 | 707773 | 2020-11-07 | Clay | Missouri | 29047 | 3097 | 60 |
704530 | 704530 | 2020-11-06 | Clay | Missouri | 29047 | 3086 | 60 |
701288 | 701288 | 2020-11-05 | Clay | Missouri | 29047 | 3039 | 60 |
698044 | 698044 | 2020-11-04 | Clay | Missouri | 29047 | 3008 | 60 |
694801 | 694801 | 2020-11-03 | Clay | Missouri | 29047 | 2928 | 60 |
691559 | 691559 | 2020-11-02 | Clay | Missouri | 29047 | 2884 | 60 |
688314 | 688314 | 2020-11-01 | Clay | Missouri | 29047 | 2761 | 61 |
685070 | 685070 | 2020-10-31 | Clay | Missouri | 29047 | 2726 | 61 |
681827 | 681827 | 2020-10-30 | Clay | Missouri | 29047 | 2726 | 61 |
678583 | 678583 | 2020-10-29 | Clay | Missouri | 29047 | 2662 | 57 |
675341 | 675341 | 2020-10-28 | Clay | Missouri | 29047 | 2622 | 56 |
672098 | 672098 | 2020-10-27 | Clay | Missouri | 29047 | 2573 | 54 |
668856 | 668856 | 2020-10-26 | Clay | Missouri | 29047 | 2529 | 52 |
665612 | 665612 | 2020-10-25 | Clay | Missouri | 29047 | 2491 | 52 |
662367 | 662367 | 2020-10-24 | Clay | Missouri | 29047 | 2477 | 52 |
659123 | 659123 | 2020-10-23 | Clay | Missouri | 29047 | 2465 | 52 |
655878 | 655878 | 2020-10-22 | Clay | Missouri | 29047 | 2412 | 51 |
652633 | 652633 | 2020-10-21 | Clay | Missouri | 29047 | 2387 | 51 |
649388 | 649388 | 2020-10-20 | Clay | Missouri | 29047 | 2325 | 51 |
646144 | 646144 | 2020-10-19 | Clay | Missouri | 29047 | 2300 | 51 |
642898 | 642898 | 2020-10-18 | Clay | Missouri | 29047 | 2300 | 50 |
639650 | 639650 | 2020-10-17 | Clay | Missouri | 29047 | 2283 | 50 |
636404 | 636404 | 2020-10-16 | Clay | Missouri | 29047 | 2257 | 50 |
633158 | 633158 | 2020-10-15 | Clay | Missouri | 29047 | 2225 | 50 |
629913 | 629913 | 2020-10-14 | Clay | Missouri | 29047 | 2198 | 47 |
626669 | 626669 | 2020-10-13 | Clay | Missouri | 29047 | 2134 | 44 |
623427 | 623427 | 2020-10-12 | Clay | Missouri | 29047 | 2005 | 44 |
620184 | 620184 | 2020-10-11 | Clay | Missouri | 29047 | 2005 | 44 |
616942 | 616942 | 2020-10-10 | Clay | Missouri | 29047 | 2005 | 44 |
613701 | 613701 | 2020-10-09 | Clay | Missouri | 29047 | 2005 | 44 |
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);