ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
752 rows where county = "Carroll" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1051772 | 1051772 | 2021-02-21 | Carroll | Missouri | 29033 | 832 | 22 |
1048525 | 1048525 | 2021-02-20 | Carroll | Missouri | 29033 | 832 | 22 |
1045279 | 1045279 | 2021-02-19 | Carroll | Missouri | 29033 | 832 | 22 |
1042034 | 1042034 | 2021-02-18 | Carroll | Missouri | 29033 | 832 | 22 |
1038789 | 1038789 | 2021-02-17 | Carroll | Missouri | 29033 | 831 | 21 |
1035544 | 1035544 | 2021-02-16 | Carroll | Missouri | 29033 | 829 | 21 |
1032299 | 1032299 | 2021-02-15 | Carroll | Missouri | 29033 | 827 | 21 |
1029052 | 1029052 | 2021-02-14 | Carroll | Missouri | 29033 | 825 | 21 |
1025806 | 1025806 | 2021-02-13 | Carroll | Missouri | 29033 | 825 | 21 |
1022561 | 1022561 | 2021-02-12 | Carroll | Missouri | 29033 | 825 | 21 |
1019316 | 1019316 | 2021-02-11 | Carroll | Missouri | 29033 | 824 | 21 |
1016071 | 1016071 | 2021-02-10 | Carroll | Missouri | 29033 | 821 | 21 |
1012826 | 1012826 | 2021-02-09 | Carroll | Missouri | 29033 | 820 | 21 |
1009581 | 1009581 | 2021-02-08 | Carroll | Missouri | 29033 | 820 | 21 |
1006334 | 1006334 | 2021-02-07 | Carroll | Missouri | 29033 | 818 | 21 |
1003088 | 1003088 | 2021-02-06 | Carroll | Missouri | 29033 | 814 | 21 |
999843 | 999843 | 2021-02-05 | Carroll | Missouri | 29033 | 811 | 21 |
996597 | 996597 | 2021-02-04 | Carroll | Missouri | 29033 | 806 | 21 |
993351 | 993351 | 2021-02-03 | Carroll | Missouri | 29033 | 798 | 21 |
990105 | 990105 | 2021-02-02 | Carroll | Missouri | 29033 | 798 | 21 |
986858 | 986858 | 2021-02-01 | Carroll | Missouri | 29033 | 796 | 18 |
983611 | 983611 | 2021-01-31 | Carroll | Missouri | 29033 | 790 | 18 |
980365 | 980365 | 2021-01-30 | Carroll | Missouri | 29033 | 786 | 18 |
977119 | 977119 | 2021-01-29 | Carroll | Missouri | 29033 | 783 | 18 |
973874 | 973874 | 2021-01-28 | Carroll | Missouri | 29033 | 781 | 18 |
970629 | 970629 | 2021-01-27 | Carroll | Missouri | 29033 | 773 | 18 |
967384 | 967384 | 2021-01-26 | Carroll | Missouri | 29033 | 773 | 18 |
964140 | 964140 | 2021-01-25 | Carroll | Missouri | 29033 | 773 | 18 |
960895 | 960895 | 2021-01-24 | Carroll | Missouri | 29033 | 765 | 18 |
957649 | 957649 | 2021-01-23 | Carroll | Missouri | 29033 | 753 | 18 |
954404 | 954404 | 2021-01-22 | Carroll | Missouri | 29033 | 751 | 18 |
951159 | 951159 | 2021-01-21 | Carroll | Missouri | 29033 | 745 | 18 |
947913 | 947913 | 2021-01-20 | Carroll | Missouri | 29033 | 740 | 18 |
944666 | 944666 | 2021-01-19 | Carroll | Missouri | 29033 | 738 | 18 |
941421 | 941421 | 2021-01-18 | Carroll | Missouri | 29033 | 737 | 18 |
938176 | 938176 | 2021-01-17 | Carroll | Missouri | 29033 | 733 | 18 |
934931 | 934931 | 2021-01-16 | Carroll | Missouri | 29033 | 730 | 18 |
931686 | 931686 | 2021-01-15 | Carroll | Missouri | 29033 | 728 | 18 |
928441 | 928441 | 2021-01-14 | Carroll | Missouri | 29033 | 726 | 18 |
925195 | 925195 | 2021-01-13 | Carroll | Missouri | 29033 | 718 | 18 |
921950 | 921950 | 2021-01-12 | Carroll | Missouri | 29033 | 717 | 18 |
918705 | 918705 | 2021-01-11 | Carroll | Missouri | 29033 | 715 | 18 |
915460 | 915460 | 2021-01-10 | Carroll | Missouri | 29033 | 709 | 18 |
912215 | 912215 | 2021-01-09 | Carroll | Missouri | 29033 | 704 | 18 |
908970 | 908970 | 2021-01-08 | Carroll | Missouri | 29033 | 695 | 18 |
905724 | 905724 | 2021-01-07 | Carroll | Missouri | 29033 | 688 | 18 |
902479 | 902479 | 2021-01-06 | Carroll | Missouri | 29033 | 682 | 18 |
899234 | 899234 | 2021-01-05 | Carroll | Missouri | 29033 | 679 | 18 |
895989 | 895989 | 2021-01-04 | Carroll | Missouri | 29033 | 677 | 18 |
892742 | 892742 | 2021-01-03 | Carroll | Missouri | 29033 | 677 | 18 |
889496 | 889496 | 2021-01-02 | Carroll | Missouri | 29033 | 667 | 18 |
886250 | 886250 | 2021-01-01 | Carroll | Missouri | 29033 | 661 | 18 |
883005 | 883005 | 2020-12-31 | Carroll | Missouri | 29033 | 650 | 18 |
879760 | 879760 | 2020-12-30 | Carroll | Missouri | 29033 | 645 | 18 |
876515 | 876515 | 2020-12-29 | Carroll | Missouri | 29033 | 642 | 15 |
873270 | 873270 | 2020-12-28 | Carroll | Missouri | 29033 | 641 | 14 |
870025 | 870025 | 2020-12-27 | Carroll | Missouri | 29033 | 638 | 14 |
866780 | 866780 | 2020-12-26 | Carroll | Missouri | 29033 | 636 | 14 |
863535 | 863535 | 2020-12-25 | Carroll | Missouri | 29033 | 634 | 14 |
860290 | 860290 | 2020-12-24 | Carroll | Missouri | 29033 | 631 | 14 |
857045 | 857045 | 2020-12-23 | Carroll | Missouri | 29033 | 616 | 14 |
853800 | 853800 | 2020-12-22 | Carroll | Missouri | 29033 | 612 | 9 |
850555 | 850555 | 2020-12-21 | Carroll | Missouri | 29033 | 609 | 9 |
847310 | 847310 | 2020-12-20 | Carroll | Missouri | 29033 | 593 | 9 |
844064 | 844064 | 2020-12-19 | Carroll | Missouri | 29033 | 592 | 9 |
840819 | 840819 | 2020-12-18 | Carroll | Missouri | 29033 | 585 | 8 |
837574 | 837574 | 2020-12-17 | Carroll | Missouri | 29033 | 574 | 8 |
834328 | 834328 | 2020-12-16 | Carroll | Missouri | 29033 | 566 | 8 |
831081 | 831081 | 2020-12-15 | Carroll | Missouri | 29033 | 565 | 8 |
827835 | 827835 | 2020-12-14 | Carroll | Missouri | 29033 | 560 | 8 |
824588 | 824588 | 2020-12-13 | Carroll | Missouri | 29033 | 547 | 8 |
821342 | 821342 | 2020-12-12 | Carroll | Missouri | 29033 | 541 | 8 |
818096 | 818096 | 2020-12-11 | Carroll | Missouri | 29033 | 518 | 8 |
814850 | 814850 | 2020-12-10 | Carroll | Missouri | 29033 | 518 | 8 |
811605 | 811605 | 2020-12-09 | Carroll | Missouri | 29033 | 508 | 8 |
808360 | 808360 | 2020-12-08 | Carroll | Missouri | 29033 | 506 | 8 |
805115 | 805115 | 2020-12-07 | Carroll | Missouri | 29033 | 496 | 7 |
801870 | 801870 | 2020-12-06 | Carroll | Missouri | 29033 | 490 | 7 |
798625 | 798625 | 2020-12-05 | Carroll | Missouri | 29033 | 469 | 7 |
795380 | 795380 | 2020-12-04 | Carroll | Missouri | 29033 | 460 | 6 |
792135 | 792135 | 2020-12-03 | Carroll | Missouri | 29033 | 450 | 6 |
788890 | 788890 | 2020-12-02 | Carroll | Missouri | 29033 | 442 | 6 |
785645 | 785645 | 2020-12-01 | Carroll | Missouri | 29033 | 442 | 6 |
782401 | 782401 | 2020-11-30 | Carroll | Missouri | 29033 | 441 | 6 |
779155 | 779155 | 2020-11-29 | Carroll | Missouri | 29033 | 432 | 6 |
775910 | 775910 | 2020-11-28 | Carroll | Missouri | 29033 | 419 | 6 |
772665 | 772665 | 2020-11-27 | Carroll | Missouri | 29033 | 415 | 6 |
769420 | 769420 | 2020-11-26 | Carroll | Missouri | 29033 | 413 | 6 |
766174 | 766174 | 2020-11-25 | Carroll | Missouri | 29033 | 409 | 6 |
762929 | 762929 | 2020-11-24 | Carroll | Missouri | 29033 | 403 | 5 |
759684 | 759684 | 2020-11-23 | Carroll | Missouri | 29033 | 391 | 5 |
756437 | 756437 | 2020-11-22 | Carroll | Missouri | 29033 | 376 | 5 |
753191 | 753191 | 2020-11-21 | Carroll | Missouri | 29033 | 368 | 5 |
749945 | 749945 | 2020-11-20 | Carroll | Missouri | 29033 | 353 | 5 |
746699 | 746699 | 2020-11-19 | Carroll | Missouri | 29033 | 345 | 4 |
743452 | 743452 | 2020-11-18 | Carroll | Missouri | 29033 | 337 | 4 |
740205 | 740205 | 2020-11-17 | Carroll | Missouri | 29033 | 331 | 4 |
736961 | 736961 | 2020-11-16 | Carroll | Missouri | 29033 | 318 | 4 |
733715 | 733715 | 2020-11-15 | Carroll | Missouri | 29033 | 316 | 4 |
730470 | 730470 | 2020-11-14 | Carroll | Missouri | 29033 | 316 | 4 |
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);