ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 20057 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194032 | 1194032 | 2021-04-06 | Ford | Kansas | 20057 | 5699 | 10 |
1190782 | 1190782 | 2021-04-05 | Ford | Kansas | 20057 | 5699 | 10 |
1187535 | 1187535 | 2021-04-04 | Ford | Kansas | 20057 | 5696 | 10 |
1184288 | 1184288 | 2021-04-03 | Ford | Kansas | 20057 | 5696 | 10 |
1181041 | 1181041 | 2021-04-02 | Ford | Kansas | 20057 | 5696 | 10 |
1177794 | 1177794 | 2021-04-01 | Ford | Kansas | 20057 | 5684 | 10 |
1174547 | 1174547 | 2021-03-31 | Ford | Kansas | 20057 | 5684 | 10 |
1171300 | 1171300 | 2021-03-30 | Ford | Kansas | 20057 | 5677 | 10 |
1168052 | 1168052 | 2021-03-29 | Ford | Kansas | 20057 | 5677 | 10 |
1164804 | 1164804 | 2021-03-28 | Ford | Kansas | 20057 | 5676 | 10 |
1161556 | 1161556 | 2021-03-27 | Ford | Kansas | 20057 | 5676 | 10 |
1158308 | 1158308 | 2021-03-26 | Ford | Kansas | 20057 | 5676 | 10 |
1155061 | 1155061 | 2021-03-25 | Ford | Kansas | 20057 | 5667 | 10 |
1151814 | 1151814 | 2021-03-24 | Ford | Kansas | 20057 | 5667 | 10 |
1148567 | 1148567 | 2021-03-23 | Ford | Kansas | 20057 | 5652 | 10 |
1145320 | 1145320 | 2021-03-22 | Ford | Kansas | 20057 | 5652 | 10 |
1142073 | 1142073 | 2021-03-21 | Ford | Kansas | 20057 | 5637 | 10 |
1138827 | 1138827 | 2021-03-20 | Ford | Kansas | 20057 | 5637 | 10 |
1135581 | 1135581 | 2021-03-19 | Ford | Kansas | 20057 | 5637 | 10 |
1132334 | 1132334 | 2021-03-18 | Ford | Kansas | 20057 | 5632 | 10 |
1129086 | 1129086 | 2021-03-17 | Ford | Kansas | 20057 | 5632 | 10 |
1125840 | 1125840 | 2021-03-16 | Ford | Kansas | 20057 | 5620 | 10 |
1122594 | 1122594 | 2021-03-15 | Ford | Kansas | 20057 | 5620 | 10 |
1119347 | 1119347 | 2021-03-14 | Ford | Kansas | 20057 | 5618 | 10 |
1116100 | 1116100 | 2021-03-13 | Ford | Kansas | 20057 | 5618 | 10 |
1112854 | 1112854 | 2021-03-12 | Ford | Kansas | 20057 | 5618 | 10 |
1109608 | 1109608 | 2021-03-11 | Ford | Kansas | 20057 | 5612 | 10 |
1106362 | 1106362 | 2021-03-10 | Ford | Kansas | 20057 | 5612 | 10 |
1103116 | 1103116 | 2021-03-09 | Ford | Kansas | 20057 | 5596 | 10 |
1099870 | 1099870 | 2021-03-08 | Ford | Kansas | 20057 | 5596 | 10 |
1096622 | 1096622 | 2021-03-07 | Ford | Kansas | 20057 | 5592 | 10 |
1093376 | 1093376 | 2021-03-06 | Ford | Kansas | 20057 | 5592 | 10 |
1090130 | 1090130 | 2021-03-05 | Ford | Kansas | 20057 | 5592 | 10 |
1086885 | 1086885 | 2021-03-04 | Ford | Kansas | 20057 | 5581 | 10 |
1083639 | 1083639 | 2021-03-03 | Ford | Kansas | 20057 | 5581 | 10 |
1080393 | 1080393 | 2021-03-02 | Ford | Kansas | 20057 | 5577 | 10 |
1077148 | 1077148 | 2021-03-01 | Ford | Kansas | 20057 | 5577 | 10 |
1073902 | 1073902 | 2021-02-28 | Ford | Kansas | 20057 | 5569 | 10 |
1070656 | 1070656 | 2021-02-27 | Ford | Kansas | 20057 | 5569 | 10 |
1067411 | 1067411 | 2021-02-26 | Ford | Kansas | 20057 | 5569 | 10 |
1064166 | 1064166 | 2021-02-25 | Ford | Kansas | 20057 | 5562 | 10 |
1060921 | 1060921 | 2021-02-24 | Ford | Kansas | 20057 | 5562 | 10 |
1057675 | 1057675 | 2021-02-23 | Ford | Kansas | 20057 | 5552 | 10 |
1054429 | 1054429 | 2021-02-22 | Ford | Kansas | 20057 | 5552 | 10 |
1051182 | 1051182 | 2021-02-21 | Ford | Kansas | 20057 | 5543 | 10 |
1047935 | 1047935 | 2021-02-20 | Ford | Kansas | 20057 | 5543 | 10 |
1044690 | 1044690 | 2021-02-19 | Ford | Kansas | 20057 | 5543 | 10 |
1041445 | 1041445 | 2021-02-18 | Ford | Kansas | 20057 | 5533 | 10 |
1038200 | 1038200 | 2021-02-17 | Ford | Kansas | 20057 | 5533 | 10 |
1034955 | 1034955 | 2021-02-16 | Ford | Kansas | 20057 | 5526 | 10 |
1031709 | 1031709 | 2021-02-15 | Ford | Kansas | 20057 | 5526 | 10 |
1028462 | 1028462 | 2021-02-14 | Ford | Kansas | 20057 | 5516 | 10 |
1025217 | 1025217 | 2021-02-13 | Ford | Kansas | 20057 | 5516 | 10 |
1021972 | 1021972 | 2021-02-12 | Ford | Kansas | 20057 | 5516 | 10 |
1018727 | 1018727 | 2021-02-11 | Ford | Kansas | 20057 | 5510 | 10 |
1015482 | 1015482 | 2021-02-10 | Ford | Kansas | 20057 | 5510 | 10 |
1012237 | 1012237 | 2021-02-09 | Ford | Kansas | 20057 | 5496 | 10 |
1008991 | 1008991 | 2021-02-08 | Ford | Kansas | 20057 | 5496 | 10 |
1005745 | 1005745 | 2021-02-07 | Ford | Kansas | 20057 | 5490 | 10 |
1002499 | 1002499 | 2021-02-06 | Ford | Kansas | 20057 | 5490 | 10 |
999253 | 999253 | 2021-02-05 | Ford | Kansas | 20057 | 5490 | 10 |
996007 | 996007 | 2021-02-04 | Ford | Kansas | 20057 | 5479 | 10 |
992761 | 992761 | 2021-02-03 | Ford | Kansas | 20057 | 5479 | 10 |
989515 | 989515 | 2021-02-02 | Ford | Kansas | 20057 | 5462 | 10 |
986268 | 986268 | 2021-02-01 | Ford | Kansas | 20057 | 5462 | 10 |
983021 | 983021 | 2021-01-31 | Ford | Kansas | 20057 | 5459 | 10 |
979775 | 979775 | 2021-01-30 | Ford | Kansas | 20057 | 5459 | 10 |
976529 | 976529 | 2021-01-29 | Ford | Kansas | 20057 | 5459 | 10 |
973284 | 973284 | 2021-01-28 | Ford | Kansas | 20057 | 5446 | 10 |
970039 | 970039 | 2021-01-27 | Ford | Kansas | 20057 | 5446 | 10 |
966795 | 966795 | 2021-01-26 | Ford | Kansas | 20057 | 5435 | 10 |
963550 | 963550 | 2021-01-25 | Ford | Kansas | 20057 | 5435 | 10 |
960305 | 960305 | 2021-01-24 | Ford | Kansas | 20057 | 5424 | 10 |
957059 | 957059 | 2021-01-23 | Ford | Kansas | 20057 | 5424 | 10 |
953814 | 953814 | 2021-01-22 | Ford | Kansas | 20057 | 5424 | 10 |
950569 | 950569 | 2021-01-21 | Ford | Kansas | 20057 | 5413 | 10 |
947323 | 947323 | 2021-01-20 | Ford | Kansas | 20057 | 5413 | 10 |
944076 | 944076 | 2021-01-19 | Ford | Kansas | 20057 | 5396 | 10 |
940831 | 940831 | 2021-01-18 | Ford | Kansas | 20057 | 5396 | 10 |
937586 | 937586 | 2021-01-17 | Ford | Kansas | 20057 | 5381 | 10 |
934341 | 934341 | 2021-01-16 | Ford | Kansas | 20057 | 5381 | 10 |
931096 | 931096 | 2021-01-15 | Ford | Kansas | 20057 | 5381 | 10 |
927851 | 927851 | 2021-01-14 | Ford | Kansas | 20057 | 5357 | 10 |
924605 | 924605 | 2021-01-13 | Ford | Kansas | 20057 | 5357 | 10 |
921360 | 921360 | 2021-01-12 | Ford | Kansas | 20057 | 5337 | 10 |
918115 | 918115 | 2021-01-11 | Ford | Kansas | 20057 | 5337 | 10 |
914870 | 914870 | 2021-01-10 | Ford | Kansas | 20057 | 5304 | 10 |
911625 | 911625 | 2021-01-09 | Ford | Kansas | 20057 | 5304 | 10 |
908380 | 908380 | 2021-01-08 | Ford | Kansas | 20057 | 5304 | 10 |
905134 | 905134 | 2021-01-07 | Ford | Kansas | 20057 | 5262 | 10 |
901889 | 901889 | 2021-01-06 | Ford | Kansas | 20057 | 5262 | 10 |
898644 | 898644 | 2021-01-05 | Ford | Kansas | 20057 | 5206 | 10 |
895399 | 895399 | 2021-01-04 | Ford | Kansas | 20057 | 5206 | 10 |
892152 | 892152 | 2021-01-03 | Ford | Kansas | 20057 | 5182 | 10 |
888906 | 888906 | 2021-01-02 | Ford | Kansas | 20057 | 5182 | 10 |
885660 | 885660 | 2021-01-01 | Ford | Kansas | 20057 | 5182 | 10 |
882415 | 882415 | 2020-12-31 | Ford | Kansas | 20057 | 5138 | 10 |
879170 | 879170 | 2020-12-30 | Ford | Kansas | 20057 | 5138 | 10 |
875925 | 875925 | 2020-12-29 | Ford | Kansas | 20057 | 5089 | 10 |
872680 | 872680 | 2020-12-28 | Ford | Kansas | 20057 | 5089 | 10 |
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);