ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 29083 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934956 | 934956 | 2021-01-16 | Henry | Missouri | 29083 | 1575 | 25 |
931711 | 931711 | 2021-01-15 | Henry | Missouri | 29083 | 1572 | 25 |
928466 | 928466 | 2021-01-14 | Henry | Missouri | 29083 | 1565 | 25 |
925220 | 925220 | 2021-01-13 | Henry | Missouri | 29083 | 1548 | 25 |
921975 | 921975 | 2021-01-12 | Henry | Missouri | 29083 | 1540 | 25 |
918730 | 918730 | 2021-01-11 | Henry | Missouri | 29083 | 1535 | 24 |
915485 | 915485 | 2021-01-10 | Henry | Missouri | 29083 | 1529 | 24 |
912240 | 912240 | 2021-01-09 | Henry | Missouri | 29083 | 1518 | 24 |
908995 | 908995 | 2021-01-08 | Henry | Missouri | 29083 | 1503 | 24 |
905749 | 905749 | 2021-01-07 | Henry | Missouri | 29083 | 1498 | 24 |
902504 | 902504 | 2021-01-06 | Henry | Missouri | 29083 | 1470 | 24 |
899259 | 899259 | 2021-01-05 | Henry | Missouri | 29083 | 1466 | 24 |
896014 | 896014 | 2021-01-04 | Henry | Missouri | 29083 | 1462 | 22 |
892767 | 892767 | 2021-01-03 | Henry | Missouri | 29083 | 1462 | 22 |
889521 | 889521 | 2021-01-02 | Henry | Missouri | 29083 | 1460 | 22 |
886275 | 886275 | 2021-01-01 | Henry | Missouri | 29083 | 1453 | 22 |
883030 | 883030 | 2020-12-31 | Henry | Missouri | 29083 | 1432 | 22 |
879785 | 879785 | 2020-12-30 | Henry | Missouri | 29083 | 1415 | 21 |
876540 | 876540 | 2020-12-29 | Henry | Missouri | 29083 | 1407 | 21 |
873295 | 873295 | 2020-12-28 | Henry | Missouri | 29083 | 1400 | 21 |
870050 | 870050 | 2020-12-27 | Henry | Missouri | 29083 | 1398 | 21 |
866805 | 866805 | 2020-12-26 | Henry | Missouri | 29083 | 1395 | 21 |
863560 | 863560 | 2020-12-25 | Henry | Missouri | 29083 | 1392 | 21 |
860315 | 860315 | 2020-12-24 | Henry | Missouri | 29083 | 1388 | 21 |
857070 | 857070 | 2020-12-23 | Henry | Missouri | 29083 | 1373 | 21 |
853825 | 853825 | 2020-12-22 | Henry | Missouri | 29083 | 1365 | 21 |
850580 | 850580 | 2020-12-21 | Henry | Missouri | 29083 | 1360 | 19 |
847335 | 847335 | 2020-12-20 | Henry | Missouri | 29083 | 1349 | 19 |
844089 | 844089 | 2020-12-19 | Henry | Missouri | 29083 | 1347 | 18 |
840844 | 840844 | 2020-12-18 | Henry | Missouri | 29083 | 1333 | 18 |
837599 | 837599 | 2020-12-17 | Henry | Missouri | 29083 | 1289 | 18 |
834353 | 834353 | 2020-12-16 | Henry | Missouri | 29083 | 1282 | 18 |
831106 | 831106 | 2020-12-15 | Henry | Missouri | 29083 | 1274 | 18 |
827860 | 827860 | 2020-12-14 | Henry | Missouri | 29083 | 1267 | 16 |
824613 | 824613 | 2020-12-13 | Henry | Missouri | 29083 | 1264 | 16 |
821367 | 821367 | 2020-12-12 | Henry | Missouri | 29083 | 1263 | 16 |
818121 | 818121 | 2020-12-11 | Henry | Missouri | 29083 | 1230 | 16 |
814875 | 814875 | 2020-12-10 | Henry | Missouri | 29083 | 1230 | 16 |
811630 | 811630 | 2020-12-09 | Henry | Missouri | 29083 | 1214 | 15 |
808385 | 808385 | 2020-12-08 | Henry | Missouri | 29083 | 1199 | 14 |
805140 | 805140 | 2020-12-07 | Henry | Missouri | 29083 | 1193 | 12 |
801895 | 801895 | 2020-12-06 | Henry | Missouri | 29083 | 1187 | 12 |
798650 | 798650 | 2020-12-05 | Henry | Missouri | 29083 | 1181 | 12 |
795405 | 795405 | 2020-12-04 | Henry | Missouri | 29083 | 1153 | 12 |
792160 | 792160 | 2020-12-03 | Henry | Missouri | 29083 | 1138 | 12 |
788915 | 788915 | 2020-12-02 | Henry | Missouri | 29083 | 1119 | 11 |
785670 | 785670 | 2020-12-01 | Henry | Missouri | 29083 | 1112 | 11 |
782426 | 782426 | 2020-11-30 | Henry | Missouri | 29083 | 1102 | 10 |
779180 | 779180 | 2020-11-29 | Henry | Missouri | 29083 | 1085 | 10 |
775935 | 775935 | 2020-11-28 | Henry | Missouri | 29083 | 1068 | 10 |
772690 | 772690 | 2020-11-27 | Henry | Missouri | 29083 | 1068 | 10 |
769445 | 769445 | 2020-11-26 | Henry | Missouri | 29083 | 1055 | 10 |
766199 | 766199 | 2020-11-25 | Henry | Missouri | 29083 | 1032 | 10 |
762954 | 762954 | 2020-11-24 | Henry | Missouri | 29083 | 1020 | 10 |
759709 | 759709 | 2020-11-23 | Henry | Missouri | 29083 | 998 | 9 |
756462 | 756462 | 2020-11-22 | Henry | Missouri | 29083 | 981 | 9 |
753216 | 753216 | 2020-11-21 | Henry | Missouri | 29083 | 964 | 9 |
749970 | 749970 | 2020-11-20 | Henry | Missouri | 29083 | 933 | 9 |
746724 | 746724 | 2020-11-19 | Henry | Missouri | 29083 | 928 | 9 |
743477 | 743477 | 2020-11-18 | Henry | Missouri | 29083 | 878 | 9 |
740230 | 740230 | 2020-11-17 | Henry | Missouri | 29083 | 866 | 9 |
736986 | 736986 | 2020-11-16 | Henry | Missouri | 29083 | 824 | 8 |
733740 | 733740 | 2020-11-15 | Henry | Missouri | 29083 | 791 | 8 |
730495 | 730495 | 2020-11-14 | Henry | Missouri | 29083 | 791 | 8 |
727252 | 727252 | 2020-11-13 | Henry | Missouri | 29083 | 740 | 8 |
724009 | 724009 | 2020-11-12 | Henry | Missouri | 29083 | 701 | 8 |
720766 | 720766 | 2020-11-11 | Henry | Missouri | 29083 | 645 | 8 |
717523 | 717523 | 2020-11-10 | Henry | Missouri | 29083 | 635 | 8 |
714279 | 714279 | 2020-11-09 | Henry | Missouri | 29083 | 616 | 8 |
711035 | 711035 | 2020-11-08 | Henry | Missouri | 29083 | 589 | 8 |
707791 | 707791 | 2020-11-07 | Henry | Missouri | 29083 | 561 | 8 |
704548 | 704548 | 2020-11-06 | Henry | Missouri | 29083 | 527 | 8 |
701306 | 701306 | 2020-11-05 | Henry | Missouri | 29083 | 508 | 8 |
698062 | 698062 | 2020-11-04 | Henry | Missouri | 29083 | 477 | 8 |
694819 | 694819 | 2020-11-03 | Henry | Missouri | 29083 | 469 | 8 |
691577 | 691577 | 2020-11-02 | Henry | Missouri | 29083 | 465 | 8 |
688332 | 688332 | 2020-11-01 | Henry | Missouri | 29083 | 444 | 8 |
685088 | 685088 | 2020-10-31 | Henry | Missouri | 29083 | 436 | 8 |
681845 | 681845 | 2020-10-30 | Henry | Missouri | 29083 | 418 | 7 |
678601 | 678601 | 2020-10-29 | Henry | Missouri | 29083 | 406 | 7 |
675359 | 675359 | 2020-10-28 | Henry | Missouri | 29083 | 386 | 7 |
672116 | 672116 | 2020-10-27 | Henry | Missouri | 29083 | 378 | 7 |
668874 | 668874 | 2020-10-26 | Henry | Missouri | 29083 | 377 | 7 |
665630 | 665630 | 2020-10-25 | Henry | Missouri | 29083 | 373 | 7 |
662385 | 662385 | 2020-10-24 | Henry | Missouri | 29083 | 370 | 6 |
659141 | 659141 | 2020-10-23 | Henry | Missouri | 29083 | 363 | 6 |
655896 | 655896 | 2020-10-22 | Henry | Missouri | 29083 | 352 | 5 |
652651 | 652651 | 2020-10-21 | Henry | Missouri | 29083 | 347 | 5 |
649406 | 649406 | 2020-10-20 | Henry | Missouri | 29083 | 345 | 5 |
646162 | 646162 | 2020-10-19 | Henry | Missouri | 29083 | 345 | 5 |
642916 | 642916 | 2020-10-18 | Henry | Missouri | 29083 | 343 | 5 |
639668 | 639668 | 2020-10-17 | Henry | Missouri | 29083 | 334 | 5 |
636422 | 636422 | 2020-10-16 | Henry | Missouri | 29083 | 328 | 5 |
633176 | 633176 | 2020-10-15 | Henry | Missouri | 29083 | 319 | 5 |
629931 | 629931 | 2020-10-14 | Henry | Missouri | 29083 | 308 | 5 |
626687 | 626687 | 2020-10-13 | Henry | Missouri | 29083 | 289 | 5 |
623445 | 623445 | 2020-10-12 | Henry | Missouri | 29083 | 289 | 5 |
620202 | 620202 | 2020-10-11 | Henry | Missouri | 29083 | 289 | 5 |
616960 | 616960 | 2020-10-10 | Henry | Missouri | 29083 | 289 | 5 |
613719 | 613719 | 2020-10-09 | Henry | Missouri | 29083 | 271 | 5 |
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);