ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 20091 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278484 | 1278484 | 2021-05-02 | Johnson | Kansas | 20091 | 57888 | 750 |
1275237 | 1275237 | 2021-05-01 | Johnson | Kansas | 20091 | 57888 | 750 |
1271990 | 1271990 | 2021-04-30 | Johnson | Kansas | 20091 | 57888 | 750 |
1268743 | 1268743 | 2021-04-29 | Johnson | Kansas | 20091 | 57707 | 747 |
1265496 | 1265496 | 2021-04-28 | Johnson | Kansas | 20091 | 57707 | 747 |
1262249 | 1262249 | 2021-04-27 | Johnson | Kansas | 20091 | 57558 | 746 |
1259002 | 1259002 | 2021-04-26 | Johnson | Kansas | 20091 | 57558 | 746 |
1255755 | 1255755 | 2021-04-25 | Johnson | Kansas | 20091 | 57435 | 746 |
1252508 | 1252508 | 2021-04-24 | Johnson | Kansas | 20091 | 57435 | 746 |
1249261 | 1249261 | 2021-04-23 | Johnson | Kansas | 20091 | 57435 | 746 |
1246014 | 1246014 | 2021-04-22 | Johnson | Kansas | 20091 | 57317 | 744 |
1242767 | 1242767 | 2021-04-21 | Johnson | Kansas | 20091 | 57317 | 744 |
1239520 | 1239520 | 2021-04-20 | Johnson | Kansas | 20091 | 57136 | 741 |
1236273 | 1236273 | 2021-04-19 | Johnson | Kansas | 20091 | 57136 | 741 |
1233026 | 1233026 | 2021-04-18 | Johnson | Kansas | 20091 | 57068 | 739 |
1229777 | 1229777 | 2021-04-17 | Johnson | Kansas | 20091 | 57068 | 640 |
1226529 | 1226529 | 2021-04-16 | Johnson | Kansas | 20091 | 57068 | 640 |
1223282 | 1223282 | 2021-04-15 | Johnson | Kansas | 20091 | 56962 | 641 |
1220034 | 1220034 | 2021-04-14 | Johnson | Kansas | 20091 | 56962 | 641 |
1216786 | 1216786 | 2021-04-13 | Johnson | Kansas | 20091 | 56806 | 641 |
1213539 | 1213539 | 2021-04-12 | Johnson | Kansas | 20091 | 56806 | 642 |
1210291 | 1210291 | 2021-04-11 | Johnson | Kansas | 20091 | 56694 | 642 |
1207042 | 1207042 | 2021-04-10 | Johnson | Kansas | 20091 | 56694 | 642 |
1203794 | 1203794 | 2021-04-09 | Johnson | Kansas | 20091 | 56694 | 642 |
1200546 | 1200546 | 2021-04-08 | Johnson | Kansas | 20091 | 56566 | 642 |
1197297 | 1197297 | 2021-04-07 | Johnson | Kansas | 20091 | 56566 | 642 |
1194049 | 1194049 | 2021-04-06 | Johnson | Kansas | 20091 | 56398 | 642 |
1190799 | 1190799 | 2021-04-05 | Johnson | Kansas | 20091 | 56398 | 641 |
1187552 | 1187552 | 2021-04-04 | Johnson | Kansas | 20091 | 56299 | 643 |
1184305 | 1184305 | 2021-04-03 | Johnson | Kansas | 20091 | 56299 | 643 |
1181058 | 1181058 | 2021-04-02 | Johnson | Kansas | 20091 | 56299 | 643 |
1177811 | 1177811 | 2021-04-01 | Johnson | Kansas | 20091 | 56159 | 642 |
1174564 | 1174564 | 2021-03-31 | Johnson | Kansas | 20091 | 56159 | 641 |
1171317 | 1171317 | 2021-03-30 | Johnson | Kansas | 20091 | 56029 | 641 |
1168069 | 1168069 | 2021-03-29 | Johnson | Kansas | 20091 | 56029 | 641 |
1164821 | 1164821 | 2021-03-28 | Johnson | Kansas | 20091 | 55914 | 640 |
1161573 | 1161573 | 2021-03-27 | Johnson | Kansas | 20091 | 55914 | 640 |
1158325 | 1158325 | 2021-03-26 | Johnson | Kansas | 20091 | 55914 | 640 |
1155078 | 1155078 | 2021-03-25 | Johnson | Kansas | 20091 | 55825 | 639 |
1151831 | 1151831 | 2021-03-24 | Johnson | Kansas | 20091 | 55825 | 638 |
1148584 | 1148584 | 2021-03-23 | Johnson | Kansas | 20091 | 55679 | 638 |
1145337 | 1145337 | 2021-03-22 | Johnson | Kansas | 20091 | 55679 | 638 |
1142090 | 1142090 | 2021-03-21 | Johnson | Kansas | 20091 | 55557 | 638 |
1138844 | 1138844 | 2021-03-20 | Johnson | Kansas | 20091 | 55557 | 644 |
1135598 | 1135598 | 2021-03-19 | Johnson | Kansas | 20091 | 55557 | 644 |
1132351 | 1132351 | 2021-03-18 | Johnson | Kansas | 20091 | 55457 | 644 |
1129103 | 1129103 | 2021-03-17 | Johnson | Kansas | 20091 | 55457 | 644 |
1125857 | 1125857 | 2021-03-16 | Johnson | Kansas | 20091 | 55287 | 644 |
1122611 | 1122611 | 2021-03-15 | Johnson | Kansas | 20091 | 55287 | 644 |
1119364 | 1119364 | 2021-03-14 | Johnson | Kansas | 20091 | 55185 | 644 |
1116117 | 1116117 | 2021-03-13 | Johnson | Kansas | 20091 | 55185 | 644 |
1112871 | 1112871 | 2021-03-12 | Johnson | Kansas | 20091 | 55185 | 644 |
1109625 | 1109625 | 2021-03-11 | Johnson | Kansas | 20091 | 55084 | 644 |
1106379 | 1106379 | 2021-03-10 | Johnson | Kansas | 20091 | 55084 | 644 |
1103133 | 1103133 | 2021-03-09 | Johnson | Kansas | 20091 | 54889 | 644 |
1099887 | 1099887 | 2021-03-08 | Johnson | Kansas | 20091 | 54889 | 644 |
1096639 | 1096639 | 2021-03-07 | Johnson | Kansas | 20091 | 54730 | 640 |
1093393 | 1093393 | 2021-03-06 | Johnson | Kansas | 20091 | 54730 | 640 |
1090147 | 1090147 | 2021-03-05 | Johnson | Kansas | 20091 | 54730 | 640 |
1086902 | 1086902 | 2021-03-04 | Johnson | Kansas | 20091 | 54533 | 646 |
1083656 | 1083656 | 2021-03-03 | Johnson | Kansas | 20091 | 54533 | 644 |
1080410 | 1080410 | 2021-03-02 | Johnson | Kansas | 20091 | 54370 | 644 |
1077165 | 1077165 | 2021-03-01 | Johnson | Kansas | 20091 | 54370 | 639 |
1073919 | 1073919 | 2021-02-28 | Johnson | Kansas | 20091 | 54224 | 638 |
1070673 | 1070673 | 2021-02-27 | Johnson | Kansas | 20091 | 54224 | 638 |
1067428 | 1067428 | 2021-02-26 | Johnson | Kansas | 20091 | 54224 | 638 |
1064183 | 1064183 | 2021-02-25 | Johnson | Kansas | 20091 | 54002 | 636 |
1060938 | 1060938 | 2021-02-24 | Johnson | Kansas | 20091 | 54002 | 636 |
1057692 | 1057692 | 2021-02-23 | Johnson | Kansas | 20091 | 53708 | 635 |
1054446 | 1054446 | 2021-02-22 | Johnson | Kansas | 20091 | 53708 | 633 |
1051199 | 1051199 | 2021-02-21 | Johnson | Kansas | 20091 | 53652 | 632 |
1047952 | 1047952 | 2021-02-20 | Johnson | Kansas | 20091 | 53652 | 632 |
1044707 | 1044707 | 2021-02-19 | Johnson | Kansas | 20091 | 53652 | 627 |
1041462 | 1041462 | 2021-02-18 | Johnson | Kansas | 20091 | 52582 | 624 |
1038217 | 1038217 | 2021-02-17 | Johnson | Kansas | 20091 | 52582 | 619 |
1034972 | 1034972 | 2021-02-16 | Johnson | Kansas | 20091 | 52199 | 613 |
1031726 | 1031726 | 2021-02-15 | Johnson | Kansas | 20091 | 52199 | 613 |
1028479 | 1028479 | 2021-02-14 | Johnson | Kansas | 20091 | 51871 | 613 |
1025234 | 1025234 | 2021-02-13 | Johnson | Kansas | 20091 | 51871 | 613 |
1021989 | 1021989 | 2021-02-12 | Johnson | Kansas | 20091 | 51871 | 604 |
1018744 | 1018744 | 2021-02-11 | Johnson | Kansas | 20091 | 51608 | 604 |
1015499 | 1015499 | 2021-02-10 | Johnson | Kansas | 20091 | 51608 | 600 |
1012254 | 1012254 | 2021-02-09 | Johnson | Kansas | 20091 | 51150 | 598 |
1009008 | 1009008 | 2021-02-08 | Johnson | Kansas | 20091 | 51150 | 596 |
1005762 | 1005762 | 2021-02-07 | Johnson | Kansas | 20091 | 50922 | 594 |
1002516 | 1002516 | 2021-02-06 | Johnson | Kansas | 20091 | 50922 | 594 |
999270 | 999270 | 2021-02-05 | Johnson | Kansas | 20091 | 50922 | 590 |
996024 | 996024 | 2021-02-04 | Johnson | Kansas | 20091 | 50392 | 583 |
992778 | 992778 | 2021-02-03 | Johnson | Kansas | 20091 | 50392 | 580 |
989532 | 989532 | 2021-02-02 | Johnson | Kansas | 20091 | 50030 | 577 |
986285 | 986285 | 2021-02-01 | Johnson | Kansas | 20091 | 50030 | 573 |
983038 | 983038 | 2021-01-31 | Johnson | Kansas | 20091 | 49641 | 571 |
979792 | 979792 | 2021-01-30 | Johnson | Kansas | 20091 | 49641 | 569 |
976546 | 976546 | 2021-01-29 | Johnson | Kansas | 20091 | 49641 | 567 |
973301 | 973301 | 2021-01-28 | Johnson | Kansas | 20091 | 49248 | 564 |
970056 | 970056 | 2021-01-27 | Johnson | Kansas | 20091 | 49248 | 561 |
966812 | 966812 | 2021-01-26 | Johnson | Kansas | 20091 | 48309 | 559 |
963567 | 963567 | 2021-01-25 | Johnson | Kansas | 20091 | 48309 | 551 |
960322 | 960322 | 2021-01-24 | Johnson | Kansas | 20091 | 47897 | 551 |
957076 | 957076 | 2021-01-23 | Johnson | Kansas | 20091 | 47897 | 549 |
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);