ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,511 rows where fips = "" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934966 | 934966 | 2021-01-16 | Joplin | Missouri | 4335 | 88 | |
934967 | 934967 | 2021-01-16 | Kansas City | Missouri | 33556 | 382 | |
931721 | 931721 | 2021-01-15 | Joplin | Missouri | 4332 | 88 | |
931722 | 931722 | 2021-01-15 | Kansas City | Missouri | 33397 | 380 | |
928476 | 928476 | 2021-01-14 | Joplin | Missouri | 4300 | 85 | |
928477 | 928477 | 2021-01-14 | Kansas City | Missouri | 33229 | 380 | |
925230 | 925230 | 2021-01-13 | Joplin | Missouri | 4287 | 85 | |
925231 | 925231 | 2021-01-13 | Kansas City | Missouri | 33027 | 375 | |
921985 | 921985 | 2021-01-12 | Joplin | Missouri | 4255 | 82 | |
921986 | 921986 | 2021-01-12 | Kansas City | Missouri | 32910 | 375 | |
918740 | 918740 | 2021-01-11 | Joplin | Missouri | 4240 | 80 | |
918741 | 918741 | 2021-01-11 | Kansas City | Missouri | 32799 | 369 | |
915495 | 915495 | 2021-01-10 | Joplin | Missouri | 4237 | 80 | |
915496 | 915496 | 2021-01-10 | Kansas City | Missouri | 32740 | 369 | |
912250 | 912250 | 2021-01-09 | Joplin | Missouri | 4209 | 80 | |
912251 | 912251 | 2021-01-09 | Kansas City | Missouri | 32445 | 369 | |
909005 | 909005 | 2021-01-08 | Joplin | Missouri | 4182 | 80 | |
909006 | 909006 | 2021-01-08 | Kansas City | Missouri | 32048 | 369 | |
905759 | 905759 | 2021-01-07 | Joplin | Missouri | 4144 | 80 | |
905760 | 905760 | 2021-01-07 | Kansas City | Missouri | 31709 | 366 | |
902514 | 902514 | 2021-01-06 | Joplin | Missouri | 4120 | 80 | |
902515 | 902515 | 2021-01-06 | Kansas City | Missouri | 31386 | 363 | |
899269 | 899269 | 2021-01-05 | Joplin | Missouri | 4087 | 79 | |
899270 | 899270 | 2021-01-05 | Kansas City | Missouri | 31191 | 361 | |
896024 | 896024 | 2021-01-04 | Joplin | Missouri | 4073 | 77 | |
896025 | 896025 | 2021-01-04 | Kansas City | Missouri | 31010 | 356 | |
892777 | 892777 | 2021-01-03 | Joplin | Missouri | 4073 | 77 | |
892778 | 892778 | 2021-01-03 | Kansas City | Missouri | 31010 | 356 | |
889531 | 889531 | 2021-01-02 | Joplin | Missouri | 4059 | 77 | |
889532 | 889532 | 2021-01-02 | Kansas City | Missouri | 30682 | 354 | |
886285 | 886285 | 2021-01-01 | Joplin | Missouri | 4035 | 74 | |
886286 | 886286 | 2021-01-01 | Kansas City | Missouri | 30472 | 354 | |
883040 | 883040 | 2020-12-31 | Joplin | Missouri | 3975 | 74 | |
883041 | 883041 | 2020-12-31 | Kansas City | Missouri | 30039 | 352 | |
879795 | 879795 | 2020-12-30 | Joplin | Missouri | 3929 | 74 | |
879796 | 879796 | 2020-12-30 | Kansas City | Missouri | 29789 | 352 | |
876550 | 876550 | 2020-12-29 | Joplin | Missouri | 3889 | 73 | |
876551 | 876551 | 2020-12-29 | Kansas City | Missouri | 29643 | 350 | |
873305 | 873305 | 2020-12-28 | Joplin | Missouri | 3882 | 71 | |
873306 | 873306 | 2020-12-28 | Kansas City | Missouri | 29454 | 349 | |
870060 | 870060 | 2020-12-27 | Joplin | Missouri | 3862 | 71 | |
870061 | 870061 | 2020-12-27 | Kansas City | Missouri | 29319 | 349 | |
866815 | 866815 | 2020-12-26 | Joplin | Missouri | 3857 | 71 | |
866816 | 866816 | 2020-12-26 | Kansas City | Missouri | 29167 | 349 | |
863570 | 863570 | 2020-12-25 | Joplin | Missouri | 3849 | 71 | |
863571 | 863571 | 2020-12-25 | Kansas City | Missouri | 29001 | 349 | |
860325 | 860325 | 2020-12-24 | Joplin | Missouri | 3831 | 71 | |
860326 | 860326 | 2020-12-24 | Kansas City | Missouri | 28800 | 348 | |
857080 | 857080 | 2020-12-23 | Joplin | Missouri | 3797 | 71 | |
857081 | 857081 | 2020-12-23 | Kansas City | Missouri | 28545 | 347 | |
853835 | 853835 | 2020-12-22 | Joplin | Missouri | 3747 | 68 | |
853836 | 853836 | 2020-12-22 | Kansas City | Missouri | 28400 | 338 | |
850590 | 850590 | 2020-12-21 | Joplin | Missouri | 3747 | 65 | |
850591 | 850591 | 2020-12-21 | Kansas City | Missouri | 28263 | 328 | |
847345 | 847345 | 2020-12-20 | Joplin | Missouri | 3736 | 65 | |
847346 | 847346 | 2020-12-20 | Kansas City | Missouri | 28006 | 327 | |
844099 | 844099 | 2020-12-19 | Joplin | Missouri | 3726 | 64 | |
844100 | 844100 | 2020-12-19 | Kansas City | Missouri | 27850 | 327 | |
840854 | 840854 | 2020-12-18 | Joplin | Missouri | 3698 | 63 | |
840855 | 840855 | 2020-12-18 | Kansas City | Missouri | 27650 | 326 | |
837609 | 837609 | 2020-12-17 | Joplin | Missouri | 3677 | 60 | |
837610 | 837610 | 2020-12-17 | Kansas City | Missouri | 27447 | 326 | |
834363 | 834363 | 2020-12-16 | Joplin | Missouri | 3647 | 60 | |
834364 | 834364 | 2020-12-16 | Kansas City | Missouri | 27215 | 325 | |
831116 | 831116 | 2020-12-15 | Joplin | Missouri | 3628 | 57 | |
831117 | 831117 | 2020-12-15 | Kansas City | Missouri | 27067 | 324 | |
827870 | 827870 | 2020-12-14 | Joplin | Missouri | 3617 | 57 | |
827871 | 827871 | 2020-12-14 | Kansas City | Missouri | 26835 | 316 | |
824623 | 824623 | 2020-12-13 | Joplin | Missouri | 3607 | 57 | |
824624 | 824624 | 2020-12-13 | Kansas City | Missouri | 26637 | 316 | |
821377 | 821377 | 2020-12-12 | Joplin | Missouri | 3589 | 57 | |
821378 | 821378 | 2020-12-12 | Kansas City | Missouri | 26470 | 316 | |
818131 | 818131 | 2020-12-11 | Joplin | Missouri | 3546 | 56 | |
818132 | 818132 | 2020-12-11 | Kansas City | Missouri | 25983 | 313 | |
814885 | 814885 | 2020-12-10 | Joplin | Missouri | 3546 | 56 | |
814886 | 814886 | 2020-12-10 | Kansas City | Missouri | 25983 | 313 | |
811640 | 811640 | 2020-12-09 | Joplin | Missouri | 3533 | 56 | |
811641 | 811641 | 2020-12-09 | Kansas City | Missouri | 25728 | 313 | |
808395 | 808395 | 2020-12-08 | Joplin | Missouri | 3486 | 56 | |
808396 | 808396 | 2020-12-08 | Kansas City | Missouri | 25544 | 313 | |
805150 | 805150 | 2020-12-07 | Joplin | Missouri | 3443 | 53 | |
805151 | 805151 | 2020-12-07 | Kansas City | Missouri | 25335 | 304 | |
801905 | 801905 | 2020-12-06 | Joplin | Missouri | 3436 | 53 | |
801906 | 801906 | 2020-12-06 | Kansas City | Missouri | 25124 | 304 | |
798660 | 798660 | 2020-12-05 | Joplin | Missouri | 3419 | 51 | |
798661 | 798661 | 2020-12-05 | Kansas City | Missouri | 24770 | 303 | |
795415 | 795415 | 2020-12-04 | Joplin | Missouri | 3407 | 51 | |
795416 | 795416 | 2020-12-04 | Kansas City | Missouri | 24453 | 302 | |
792170 | 792170 | 2020-12-03 | Joplin | Missouri | 3377 | 51 | |
792171 | 792171 | 2020-12-03 | Kansas City | Missouri | 24115 | 301 | |
788925 | 788925 | 2020-12-02 | Joplin | Missouri | 3348 | 51 | |
788926 | 788926 | 2020-12-02 | Kansas City | Missouri | 23796 | 299 | |
785680 | 785680 | 2020-12-01 | Joplin | Missouri | 3299 | 51 | |
785681 | 785681 | 2020-12-01 | Kansas City | Missouri | 23715 | 290 | |
782436 | 782436 | 2020-11-30 | Joplin | Missouri | 3282 | 46 | |
782437 | 782437 | 2020-11-30 | Kansas City | Missouri | 23525 | 282 | |
779190 | 779190 | 2020-11-29 | Joplin | Missouri | 3267 | 46 | |
779191 | 779191 | 2020-11-29 | Kansas City | Missouri | 23210 | 281 | |
775945 | 775945 | 2020-11-28 | Joplin | Missouri | 3229 | 46 | |
775946 | 775946 | 2020-11-28 | Kansas City | Missouri | 22969 | 281 |
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);