ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Kansas City" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934967 | 934967 | 2021-01-16 | Kansas City | Missouri | 33556 | 382 | |
931722 | 931722 | 2021-01-15 | Kansas City | Missouri | 33397 | 380 | |
928477 | 928477 | 2021-01-14 | Kansas City | Missouri | 33229 | 380 | |
925231 | 925231 | 2021-01-13 | Kansas City | Missouri | 33027 | 375 | |
921986 | 921986 | 2021-01-12 | Kansas City | Missouri | 32910 | 375 | |
918741 | 918741 | 2021-01-11 | Kansas City | Missouri | 32799 | 369 | |
915496 | 915496 | 2021-01-10 | Kansas City | Missouri | 32740 | 369 | |
912251 | 912251 | 2021-01-09 | Kansas City | Missouri | 32445 | 369 | |
909006 | 909006 | 2021-01-08 | Kansas City | Missouri | 32048 | 369 | |
905760 | 905760 | 2021-01-07 | Kansas City | Missouri | 31709 | 366 | |
902515 | 902515 | 2021-01-06 | Kansas City | Missouri | 31386 | 363 | |
899270 | 899270 | 2021-01-05 | Kansas City | Missouri | 31191 | 361 | |
896025 | 896025 | 2021-01-04 | Kansas City | Missouri | 31010 | 356 | |
892778 | 892778 | 2021-01-03 | Kansas City | Missouri | 31010 | 356 | |
889532 | 889532 | 2021-01-02 | Kansas City | Missouri | 30682 | 354 | |
886286 | 886286 | 2021-01-01 | Kansas City | Missouri | 30472 | 354 | |
883041 | 883041 | 2020-12-31 | Kansas City | Missouri | 30039 | 352 | |
879796 | 879796 | 2020-12-30 | Kansas City | Missouri | 29789 | 352 | |
876551 | 876551 | 2020-12-29 | Kansas City | Missouri | 29643 | 350 | |
873306 | 873306 | 2020-12-28 | Kansas City | Missouri | 29454 | 349 | |
870061 | 870061 | 2020-12-27 | Kansas City | Missouri | 29319 | 349 | |
866816 | 866816 | 2020-12-26 | Kansas City | Missouri | 29167 | 349 | |
863571 | 863571 | 2020-12-25 | Kansas City | Missouri | 29001 | 349 | |
860326 | 860326 | 2020-12-24 | Kansas City | Missouri | 28800 | 348 | |
857081 | 857081 | 2020-12-23 | Kansas City | Missouri | 28545 | 347 | |
853836 | 853836 | 2020-12-22 | Kansas City | Missouri | 28400 | 338 | |
850591 | 850591 | 2020-12-21 | Kansas City | Missouri | 28263 | 328 | |
847346 | 847346 | 2020-12-20 | Kansas City | Missouri | 28006 | 327 | |
844100 | 844100 | 2020-12-19 | Kansas City | Missouri | 27850 | 327 | |
840855 | 840855 | 2020-12-18 | Kansas City | Missouri | 27650 | 326 | |
837610 | 837610 | 2020-12-17 | Kansas City | Missouri | 27447 | 326 | |
834364 | 834364 | 2020-12-16 | Kansas City | Missouri | 27215 | 325 | |
831117 | 831117 | 2020-12-15 | Kansas City | Missouri | 27067 | 324 | |
827871 | 827871 | 2020-12-14 | Kansas City | Missouri | 26835 | 316 | |
824624 | 824624 | 2020-12-13 | Kansas City | Missouri | 26637 | 316 | |
821378 | 821378 | 2020-12-12 | Kansas City | Missouri | 26470 | 316 | |
818132 | 818132 | 2020-12-11 | Kansas City | Missouri | 25983 | 313 | |
814886 | 814886 | 2020-12-10 | Kansas City | Missouri | 25983 | 313 | |
811641 | 811641 | 2020-12-09 | Kansas City | Missouri | 25728 | 313 | |
808396 | 808396 | 2020-12-08 | Kansas City | Missouri | 25544 | 313 | |
805151 | 805151 | 2020-12-07 | Kansas City | Missouri | 25335 | 304 | |
801906 | 801906 | 2020-12-06 | Kansas City | Missouri | 25124 | 304 | |
798661 | 798661 | 2020-12-05 | Kansas City | Missouri | 24770 | 303 | |
795416 | 795416 | 2020-12-04 | Kansas City | Missouri | 24453 | 302 | |
792171 | 792171 | 2020-12-03 | Kansas City | Missouri | 24115 | 301 | |
788926 | 788926 | 2020-12-02 | Kansas City | Missouri | 23796 | 299 | |
785681 | 785681 | 2020-12-01 | Kansas City | Missouri | 23715 | 290 | |
782437 | 782437 | 2020-11-30 | Kansas City | Missouri | 23525 | 282 | |
779191 | 779191 | 2020-11-29 | Kansas City | Missouri | 23210 | 281 | |
775946 | 775946 | 2020-11-28 | Kansas City | Missouri | 22969 | 281 | |
772701 | 772701 | 2020-11-27 | Kansas City | Missouri | 22741 | 280 | |
769456 | 769456 | 2020-11-26 | Kansas City | Missouri | 22420 | 280 | |
766210 | 766210 | 2020-11-25 | Kansas City | Missouri | 22183 | 276 | |
762965 | 762965 | 2020-11-24 | Kansas City | Missouri | 21884 | 269 | |
759720 | 759720 | 2020-11-23 | Kansas City | Missouri | 21608 | 255 | |
756473 | 756473 | 2020-11-22 | Kansas City | Missouri | 21420 | 255 | |
753227 | 753227 | 2020-11-21 | Kansas City | Missouri | 21042 | 255 | |
749981 | 749981 | 2020-11-20 | Kansas City | Missouri | 20658 | 253 | |
746735 | 746735 | 2020-11-19 | Kansas City | Missouri | 20337 | 250 | |
743488 | 743488 | 2020-11-18 | Kansas City | Missouri | 20045 | 249 | |
740241 | 740241 | 2020-11-17 | Kansas City | Missouri | 19645 | 249 | |
736997 | 736997 | 2020-11-16 | Kansas City | Missouri | 19360 | 244 | |
733751 | 733751 | 2020-11-15 | Kansas City | Missouri | 19083 | 244 | |
730506 | 730506 | 2020-11-14 | Kansas City | Missouri | 19083 | 244 | |
727263 | 727263 | 2020-11-13 | Kansas City | Missouri | 18367 | 244 | |
724020 | 724020 | 2020-11-12 | Kansas City | Missouri | 18068 | 241 | |
720777 | 720777 | 2020-11-11 | Kansas City | Missouri | 17845 | 241 | |
717534 | 717534 | 2020-11-10 | Kansas City | Missouri | 17564 | 236 | |
714290 | 714290 | 2020-11-09 | Kansas City | Missouri | 17226 | 227 | |
711046 | 711046 | 2020-11-08 | Kansas City | Missouri | 16915 | 227 | |
707802 | 707802 | 2020-11-07 | Kansas City | Missouri | 16633 | 227 | |
704559 | 704559 | 2020-11-06 | Kansas City | Missouri | 16410 | 227 | |
701317 | 701317 | 2020-11-05 | Kansas City | Missouri | 16159 | 224 | |
698073 | 698073 | 2020-11-04 | Kansas City | Missouri | 15892 | 222 | |
694830 | 694830 | 2020-11-03 | Kansas City | Missouri | 15738 | 222 | |
691588 | 691588 | 2020-11-02 | Kansas City | Missouri | 15593 | 213 | |
688343 | 688343 | 2020-11-01 | Kansas City | Missouri | 15372 | 213 | |
685099 | 685099 | 2020-10-31 | Kansas City | Missouri | 15245 | 213 | |
681856 | 681856 | 2020-10-30 | Kansas City | Missouri | 14986 | 208 | |
678612 | 678612 | 2020-10-29 | Kansas City | Missouri | 14777 | 202 | |
675370 | 675370 | 2020-10-28 | Kansas City | Missouri | 14583 | 200 | |
672127 | 672127 | 2020-10-27 | Kansas City | Missouri | 14435 | 196 | |
668885 | 668885 | 2020-10-26 | Kansas City | Missouri | 14313 | 195 | |
665641 | 665641 | 2020-10-25 | Kansas City | Missouri | 14229 | 195 | |
662396 | 662396 | 2020-10-24 | Kansas City | Missouri | 14117 | 195 | |
659152 | 659152 | 2020-10-23 | Kansas City | Missouri | 13989 | 184 | |
655907 | 655907 | 2020-10-22 | Kansas City | Missouri | 13904 | 177 | |
652662 | 652662 | 2020-10-21 | Kansas City | Missouri | 13869 | 175 | |
649417 | 649417 | 2020-10-20 | Kansas City | Missouri | 13733 | 164 | |
646173 | 646173 | 2020-10-19 | Kansas City | Missouri | 13733 | 164 | |
642927 | 642927 | 2020-10-18 | Kansas City | Missouri | 13614 | 163 | |
639679 | 639679 | 2020-10-17 | Kansas City | Missouri | 13499 | 162 | |
636433 | 636433 | 2020-10-16 | Kansas City | Missouri | 13263 | 159 | |
633187 | 633187 | 2020-10-15 | Kansas City | Missouri | 13101 | 158 | |
629942 | 629942 | 2020-10-14 | Kansas City | Missouri | 12934 | 173 | |
626698 | 626698 | 2020-10-13 | Kansas City | Missouri | 13077 | 168 | |
623456 | 623456 | 2020-10-12 | Kansas City | Missouri | 13077 | 168 | |
620213 | 620213 | 2020-10-11 | Kansas City | Missouri | 13077 | 168 | |
616971 | 616971 | 2020-10-10 | Kansas City | Missouri | 13077 | 168 | |
613730 | 613730 | 2020-10-09 | Kansas City | Missouri | 12743 | 166 |
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);