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 fips = "" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194657 | 1194657 | 2021-04-06 | Kansas City | Missouri | 42787 | 557 | |
1191408 | 1191408 | 2021-04-05 | Kansas City | Missouri | 42763 | 557 | |
1188160 | 1188160 | 2021-04-04 | Kansas City | Missouri | 42733 | 557 | |
1184913 | 1184913 | 2021-04-03 | Kansas City | Missouri | 42703 | 557 | |
1181667 | 1181667 | 2021-04-02 | Kansas City | Missouri | 42641 | 556 | |
1178420 | 1178420 | 2021-04-01 | Kansas City | Missouri | 42589 | 556 | |
1175173 | 1175173 | 2021-03-31 | Kansas City | Missouri | 42550 | 555 | |
1171926 | 1171926 | 2021-03-30 | Kansas City | Missouri | 42522 | 555 | |
1168678 | 1168678 | 2021-03-29 | Kansas City | Missouri | 42481 | 549 | |
1165430 | 1165430 | 2021-03-28 | Kansas City | Missouri | 42463 | 549 | |
1162182 | 1162182 | 2021-03-27 | Kansas City | Missouri | 42434 | 549 | |
1158934 | 1158934 | 2021-03-26 | Kansas City | Missouri | 42395 | 549 | |
1155687 | 1155687 | 2021-03-25 | Kansas City | Missouri | 42345 | 549 | |
1152440 | 1152440 | 2021-03-24 | Kansas City | Missouri | 42307 | 550 | |
1149193 | 1149193 | 2021-03-23 | Kansas City | Missouri | 42271 | 548 | |
1145946 | 1145946 | 2021-03-22 | Kansas City | Missouri | 42228 | 546 | |
1142699 | 1142699 | 2021-03-21 | Kansas City | Missouri | 42208 | 546 | |
1139452 | 1139452 | 2021-03-20 | Kansas City | Missouri | 42172 | 546 | |
1136206 | 1136206 | 2021-03-19 | Kansas City | Missouri | 42137 | 546 | |
1132960 | 1132960 | 2021-03-18 | Kansas City | Missouri | 42100 | 548 | |
1129712 | 1129712 | 2021-03-17 | Kansas City | Missouri | 42036 | 548 | |
1126465 | 1126465 | 2021-03-16 | Kansas City | Missouri | 41965 | 546 | |
1123219 | 1123219 | 2021-03-15 | Kansas City | Missouri | 41941 | 545 | |
1119972 | 1119972 | 2021-03-14 | Kansas City | Missouri | 41905 | 545 | |
1116725 | 1116725 | 2021-03-13 | Kansas City | Missouri | 41857 | 545 | |
1113479 | 1113479 | 2021-03-12 | Kansas City | Missouri | 41787 | 544 | |
1110233 | 1110233 | 2021-03-11 | Kansas City | Missouri | 41721 | 544 | |
1106987 | 1106987 | 2021-03-10 | Kansas City | Missouri | 41629 | 544 | |
1103741 | 1103741 | 2021-03-09 | Kansas City | Missouri | 41580 | 541 | |
1100495 | 1100495 | 2021-03-08 | Kansas City | Missouri | 41536 | 530 | |
1097248 | 1097248 | 2021-03-07 | Kansas City | Missouri | 36819 | 530 | |
1094001 | 1094001 | 2021-03-06 | Kansas City | Missouri | 36799 | 530 | |
1090755 | 1090755 | 2021-03-05 | Kansas City | Missouri | 36770 | 528 | |
1087510 | 1087510 | 2021-03-04 | Kansas City | Missouri | 36746 | 525 | |
1084265 | 1084265 | 2021-03-03 | Kansas City | Missouri | 36729 | 525 | |
1081019 | 1081019 | 2021-03-02 | Kansas City | Missouri | 36696 | 514 | |
1077773 | 1077773 | 2021-03-01 | Kansas City | Missouri | 36687 | 514 | |
1074527 | 1074527 | 2021-02-28 | Kansas City | Missouri | 36672 | 514 | |
1071281 | 1071281 | 2021-02-27 | Kansas City | Missouri | 36639 | 515 | |
1068036 | 1068036 | 2021-02-26 | Kansas City | Missouri | 36643 | 515 | |
1064791 | 1064791 | 2021-02-25 | Kansas City | Missouri | 36650 | 515 | |
1061547 | 1061547 | 2021-02-24 | Kansas City | Missouri | 36606 | 513 | |
1058301 | 1058301 | 2021-02-23 | Kansas City | Missouri | 36592 | 513 | |
1055055 | 1055055 | 2021-02-22 | Kansas City | Missouri | 36572 | 496 | |
1051808 | 1051808 | 2021-02-21 | Kansas City | Missouri | 36552 | 496 | |
1048561 | 1048561 | 2021-02-20 | Kansas City | Missouri | 36524 | 496 | |
1045315 | 1045315 | 2021-02-19 | Kansas City | Missouri | 36486 | 497 | |
1042070 | 1042070 | 2021-02-18 | Kansas City | Missouri | 36436 | 490 | |
1038825 | 1038825 | 2021-02-17 | Kansas City | Missouri | 36393 | 480 | |
1035580 | 1035580 | 2021-02-16 | Kansas City | Missouri | 36355 | 478 | |
1032335 | 1032335 | 2021-02-15 | Kansas City | Missouri | 36317 | 478 | |
1029088 | 1029088 | 2021-02-14 | Kansas City | Missouri | 36296 | 478 | |
1025842 | 1025842 | 2021-02-13 | Kansas City | Missouri | 36252 | 478 | |
1022597 | 1022597 | 2021-02-12 | Kansas City | Missouri | 36213 | 478 | |
1019352 | 1019352 | 2021-02-11 | Kansas City | Missouri | 36193 | 476 | |
1016107 | 1016107 | 2021-02-10 | Kansas City | Missouri | 36177 | 462 | |
1012862 | 1012862 | 2021-02-09 | Kansas City | Missouri | 36120 | 458 | |
1009617 | 1009617 | 2021-02-08 | Kansas City | Missouri | 36076 | 458 | |
1006370 | 1006370 | 2021-02-07 | Kansas City | Missouri | 36037 | 458 | |
1003124 | 1003124 | 2021-02-06 | Kansas City | Missouri | 35959 | 458 | |
999879 | 999879 | 2021-02-05 | Kansas City | Missouri | 35921 | 458 | |
996633 | 996633 | 2021-02-04 | Kansas City | Missouri | 35888 | 455 | |
993387 | 993387 | 2021-02-03 | Kansas City | Missouri | 35799 | 453 | |
990141 | 990141 | 2021-02-02 | Kansas City | Missouri | 35760 | 454 | |
986894 | 986894 | 2021-02-01 | Kansas City | Missouri | 35700 | 440 | |
983647 | 983647 | 2021-01-31 | Kansas City | Missouri | 35622 | 440 | |
980401 | 980401 | 2021-01-30 | Kansas City | Missouri | 35521 | 440 | |
977155 | 977155 | 2021-01-29 | Kansas City | Missouri | 35440 | 439 | |
973910 | 973910 | 2021-01-28 | Kansas City | Missouri | 35059 | 439 | |
970665 | 970665 | 2021-01-27 | Kansas City | Missouri | 34951 | 434 | |
967420 | 967420 | 2021-01-26 | Kansas City | Missouri | 34888 | 435 | |
964176 | 964176 | 2021-01-25 | Kansas City | Missouri | 34808 | 426 | |
960931 | 960931 | 2021-01-24 | Kansas City | Missouri | 34742 | 425 | |
957685 | 957685 | 2021-01-23 | Kansas City | Missouri | 34406 | 425 | |
954440 | 954440 | 2021-01-22 | Kansas City | Missouri | 34236 | 423 | |
951195 | 951195 | 2021-01-21 | Kansas City | Missouri | 34147 | 421 | |
947949 | 947949 | 2021-01-20 | Kansas City | Missouri | 34009 | 412 | |
944702 | 944702 | 2021-01-19 | Kansas City | Missouri | 33885 | 382 | |
941457 | 941457 | 2021-01-18 | Kansas City | Missouri | 33754 | 382 | |
938212 | 938212 | 2021-01-17 | Kansas City | Missouri | 33674 | 382 | |
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 |
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);