ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29047 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1191379 | 1191379 | 2021-04-05 | Clay | Missouri | 29047 | 9970 | 159 |
1188131 | 1188131 | 2021-04-04 | Clay | Missouri | 29047 | 9970 | 159 |
1184884 | 1184884 | 2021-04-03 | Clay | Missouri | 29047 | 9970 | 159 |
1181638 | 1181638 | 2021-04-02 | Clay | Missouri | 29047 | 9970 | 159 |
1178391 | 1178391 | 2021-04-01 | Clay | Missouri | 29047 | 9958 | 159 |
1175144 | 1175144 | 2021-03-31 | Clay | Missouri | 29047 | 9958 | 159 |
1171897 | 1171897 | 2021-03-30 | Clay | Missouri | 29047 | 9939 | 159 |
1168649 | 1168649 | 2021-03-29 | Clay | Missouri | 29047 | 9939 | 157 |
1165401 | 1165401 | 2021-03-28 | Clay | Missouri | 29047 | 9934 | 158 |
1162153 | 1162153 | 2021-03-27 | Clay | Missouri | 29047 | 9934 | 158 |
1158905 | 1158905 | 2021-03-26 | Clay | Missouri | 29047 | 9934 | 158 |
1155658 | 1155658 | 2021-03-25 | Clay | Missouri | 29047 | 9885 | 158 |
1152411 | 1152411 | 2021-03-24 | Clay | Missouri | 29047 | 9885 | 158 |
1149164 | 1149164 | 2021-03-23 | Clay | Missouri | 29047 | 9838 | 158 |
1145917 | 1145917 | 2021-03-22 | Clay | Missouri | 29047 | 9838 | 155 |
1142670 | 1142670 | 2021-03-21 | Clay | Missouri | 29047 | 9809 | 155 |
1139423 | 1139423 | 2021-03-20 | Clay | Missouri | 29047 | 9809 | 155 |
1136177 | 1136177 | 2021-03-19 | Clay | Missouri | 29047 | 9809 | 155 |
1132931 | 1132931 | 2021-03-18 | Clay | Missouri | 29047 | 9792 | 155 |
1129683 | 1129683 | 2021-03-17 | Clay | Missouri | 29047 | 9792 | 155 |
1126436 | 1126436 | 2021-03-16 | Clay | Missouri | 29047 | 9750 | 154 |
1123190 | 1123190 | 2021-03-15 | Clay | Missouri | 29047 | 9750 | 153 |
1119943 | 1119943 | 2021-03-14 | Clay | Missouri | 29047 | 9723 | 153 |
1116696 | 1116696 | 2021-03-13 | Clay | Missouri | 29047 | 9723 | 153 |
1113450 | 1113450 | 2021-03-12 | Clay | Missouri | 29047 | 9723 | 153 |
1110204 | 1110204 | 2021-03-11 | Clay | Missouri | 29047 | 9711 | 153 |
1106958 | 1106958 | 2021-03-10 | Clay | Missouri | 29047 | 9705 | 153 |
1103712 | 1103712 | 2021-03-09 | Clay | Missouri | 29047 | 9684 | 153 |
1100466 | 1100466 | 2021-03-08 | Clay | Missouri | 29047 | 9668 | 151 |
1097219 | 1097219 | 2021-03-07 | Clay | Missouri | 29047 | 9634 | 151 |
1093972 | 1093972 | 2021-03-06 | Clay | Missouri | 29047 | 9634 | 151 |
1090726 | 1090726 | 2021-03-05 | Clay | Missouri | 29047 | 9634 | 151 |
1087481 | 1087481 | 2021-03-04 | Clay | Missouri | 29047 | 9623 | 151 |
1084236 | 1084236 | 2021-03-03 | Clay | Missouri | 29047 | 9550 | 151 |
1080990 | 1080990 | 2021-03-02 | Clay | Missouri | 29047 | 9550 | 144 |
1077744 | 1077744 | 2021-03-01 | Clay | Missouri | 29047 | 9533 | 144 |
1074498 | 1074498 | 2021-02-28 | Clay | Missouri | 29047 | 9502 | 144 |
1071252 | 1071252 | 2021-02-27 | Clay | Missouri | 29047 | 9502 | 144 |
1068007 | 1068007 | 2021-02-26 | Clay | Missouri | 29047 | 9502 | 144 |
1064762 | 1064762 | 2021-02-25 | Clay | Missouri | 29047 | 9488 | 143 |
1061518 | 1061518 | 2021-02-24 | Clay | Missouri | 29047 | 9477 | 143 |
1058272 | 1058272 | 2021-02-23 | Clay | Missouri | 29047 | 9434 | 143 |
1055026 | 1055026 | 2021-02-22 | Clay | Missouri | 29047 | 9414 | 143 |
1051779 | 1051779 | 2021-02-21 | Clay | Missouri | 29047 | 9386 | 143 |
1048532 | 1048532 | 2021-02-20 | Clay | Missouri | 29047 | 9386 | 143 |
1045286 | 1045286 | 2021-02-19 | Clay | Missouri | 29047 | 9386 | 141 |
1042041 | 1042041 | 2021-02-18 | Clay | Missouri | 29047 | 9371 | 141 |
1038796 | 1038796 | 2021-02-17 | Clay | Missouri | 29047 | 9351 | 137 |
1035551 | 1035551 | 2021-02-16 | Clay | Missouri | 29047 | 9256 | 137 |
1032306 | 1032306 | 2021-02-15 | Clay | Missouri | 29047 | 9256 | 137 |
1029059 | 1029059 | 2021-02-14 | Clay | Missouri | 29047 | 9256 | 137 |
1025813 | 1025813 | 2021-02-13 | Clay | Missouri | 29047 | 9256 | 137 |
1022568 | 1022568 | 2021-02-12 | Clay | Missouri | 29047 | 9256 | 137 |
1019323 | 1019323 | 2021-02-11 | Clay | Missouri | 29047 | 9234 | 137 |
1016078 | 1016078 | 2021-02-10 | Clay | Missouri | 29047 | 9213 | 131 |
1012833 | 1012833 | 2021-02-09 | Clay | Missouri | 29047 | 9142 | 131 |
1009588 | 1009588 | 2021-02-08 | Clay | Missouri | 29047 | 9123 | 131 |
1006341 | 1006341 | 2021-02-07 | Clay | Missouri | 29047 | 9055 | 131 |
1003095 | 1003095 | 2021-02-06 | Clay | Missouri | 29047 | 9055 | 131 |
999850 | 999850 | 2021-02-05 | Clay | Missouri | 29047 | 9055 | 131 |
996604 | 996604 | 2021-02-04 | Clay | Missouri | 29047 | 9023 | 131 |
993358 | 993358 | 2021-02-03 | Clay | Missouri | 29047 | 8983 | 128 |
990112 | 990112 | 2021-02-02 | Clay | Missouri | 29047 | 8945 | 128 |
986865 | 986865 | 2021-02-01 | Clay | Missouri | 29047 | 8824 | 124 |
983618 | 983618 | 2021-01-31 | Clay | Missouri | 29047 | 8756 | 124 |
980372 | 980372 | 2021-01-30 | Clay | Missouri | 29047 | 8756 | 124 |
977126 | 977126 | 2021-01-29 | Clay | Missouri | 29047 | 8756 | 124 |
973881 | 973881 | 2021-01-28 | Clay | Missouri | 29047 | 8721 | 124 |
970636 | 970636 | 2021-01-27 | Clay | Missouri | 29047 | 8695 | 123 |
967391 | 967391 | 2021-01-26 | Clay | Missouri | 29047 | 8613 | 122 |
964147 | 964147 | 2021-01-25 | Clay | Missouri | 29047 | 8592 | 120 |
960902 | 960902 | 2021-01-24 | Clay | Missouri | 29047 | 8505 | 120 |
957656 | 957656 | 2021-01-23 | Clay | Missouri | 29047 | 8505 | 120 |
954411 | 954411 | 2021-01-22 | Clay | Missouri | 29047 | 8505 | 120 |
951166 | 951166 | 2021-01-21 | Clay | Missouri | 29047 | 8421 | 120 |
947920 | 947920 | 2021-01-20 | Clay | Missouri | 29047 | 8370 | 120 |
944673 | 944673 | 2021-01-19 | Clay | Missouri | 29047 | 8320 | 119 |
941428 | 941428 | 2021-01-18 | Clay | Missouri | 29047 | 8179 | 119 |
938183 | 938183 | 2021-01-17 | Clay | Missouri | 29047 | 8179 | 118 |
934938 | 934938 | 2021-01-16 | Clay | Missouri | 29047 | 8179 | 118 |
931693 | 931693 | 2021-01-15 | Clay | Missouri | 29047 | 8179 | 118 |
928448 | 928448 | 2021-01-14 | Clay | Missouri | 29047 | 8129 | 118 |
925202 | 925202 | 2021-01-13 | Clay | Missouri | 29047 | 8088 | 118 |
921957 | 921957 | 2021-01-12 | Clay | Missouri | 29047 | 7927 | 117 |
918712 | 918712 | 2021-01-11 | Clay | Missouri | 29047 | 7872 | 113 |
915467 | 915467 | 2021-01-10 | Clay | Missouri | 29047 | 7671 | 113 |
912222 | 912222 | 2021-01-09 | Clay | Missouri | 29047 | 7671 | 113 |
908977 | 908977 | 2021-01-08 | Clay | Missouri | 29047 | 7671 | 113 |
905731 | 905731 | 2021-01-07 | Clay | Missouri | 29047 | 7609 | 112 |
902486 | 902486 | 2021-01-06 | Clay | Missouri | 29047 | 7473 | 107 |
899241 | 899241 | 2021-01-05 | Clay | Missouri | 29047 | 7398 | 103 |
895996 | 895996 | 2021-01-04 | Clay | Missouri | 29047 | 7340 | 98 |
892749 | 892749 | 2021-01-03 | Clay | Missouri | 29047 | 7134 | 98 |
889503 | 889503 | 2021-01-02 | Clay | Missouri | 29047 | 7134 | 98 |
886257 | 886257 | 2021-01-01 | Clay | Missouri | 29047 | 7134 | 98 |
883012 | 883012 | 2020-12-31 | Clay | Missouri | 29047 | 7134 | 98 |
879767 | 879767 | 2020-12-30 | Clay | Missouri | 29047 | 7108 | 98 |
876522 | 876522 | 2020-12-29 | Clay | Missouri | 29047 | 6882 | 97 |
873277 | 873277 | 2020-12-28 | Clay | Missouri | 29047 | 6828 | 95 |
870032 | 870032 | 2020-12-27 | Clay | Missouri | 29047 | 6644 | 94 |
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);