ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Scott" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064223 | 1064223 | 2021-02-25 | Scott | Kansas | 20171 | 604 | 21 |
1060978 | 1060978 | 2021-02-24 | Scott | Kansas | 20171 | 604 | 21 |
1057732 | 1057732 | 2021-02-23 | Scott | Kansas | 20171 | 603 | 21 |
1054486 | 1054486 | 2021-02-22 | Scott | Kansas | 20171 | 603 | 21 |
1051239 | 1051239 | 2021-02-21 | Scott | Kansas | 20171 | 600 | 21 |
1047992 | 1047992 | 2021-02-20 | Scott | Kansas | 20171 | 600 | 21 |
1044747 | 1044747 | 2021-02-19 | Scott | Kansas | 20171 | 599 | 16 |
1041502 | 1041502 | 2021-02-18 | Scott | Kansas | 20171 | 599 | 16 |
1038257 | 1038257 | 2021-02-17 | Scott | Kansas | 20171 | 599 | 16 |
1035012 | 1035012 | 2021-02-16 | Scott | Kansas | 20171 | 597 | 16 |
1031766 | 1031766 | 2021-02-15 | Scott | Kansas | 20171 | 597 | 16 |
1028519 | 1028519 | 2021-02-14 | Scott | Kansas | 20171 | 597 | 16 |
1025274 | 1025274 | 2021-02-13 | Scott | Kansas | 20171 | 597 | 16 |
1022029 | 1022029 | 2021-02-12 | Scott | Kansas | 20171 | 597 | 16 |
1018784 | 1018784 | 2021-02-11 | Scott | Kansas | 20171 | 596 | 16 |
1015539 | 1015539 | 2021-02-10 | Scott | Kansas | 20171 | 596 | 16 |
1012294 | 1012294 | 2021-02-09 | Scott | Kansas | 20171 | 596 | 16 |
1009048 | 1009048 | 2021-02-08 | Scott | Kansas | 20171 | 596 | 16 |
1005802 | 1005802 | 2021-02-07 | Scott | Kansas | 20171 | 595 | 16 |
1002556 | 1002556 | 2021-02-06 | Scott | Kansas | 20171 | 595 | 16 |
999310 | 999310 | 2021-02-05 | Scott | Kansas | 20171 | 595 | 16 |
996064 | 996064 | 2021-02-04 | Scott | Kansas | 20171 | 592 | 16 |
992818 | 992818 | 2021-02-03 | Scott | Kansas | 20171 | 592 | 16 |
989572 | 989572 | 2021-02-02 | Scott | Kansas | 20171 | 589 | 16 |
986325 | 986325 | 2021-02-01 | Scott | Kansas | 20171 | 589 | 16 |
983078 | 983078 | 2021-01-31 | Scott | Kansas | 20171 | 588 | 16 |
979832 | 979832 | 2021-01-30 | Scott | Kansas | 20171 | 588 | 16 |
976586 | 976586 | 2021-01-29 | Scott | Kansas | 20171 | 588 | 16 |
973341 | 973341 | 2021-01-28 | Scott | Kansas | 20171 | 585 | 16 |
970096 | 970096 | 2021-01-27 | Scott | Kansas | 20171 | 585 | 16 |
966852 | 966852 | 2021-01-26 | Scott | Kansas | 20171 | 584 | 16 |
963607 | 963607 | 2021-01-25 | Scott | Kansas | 20171 | 584 | 16 |
960362 | 960362 | 2021-01-24 | Scott | Kansas | 20171 | 572 | 16 |
957116 | 957116 | 2021-01-23 | Scott | Kansas | 20171 | 572 | 16 |
953871 | 953871 | 2021-01-22 | Scott | Kansas | 20171 | 572 | 16 |
950626 | 950626 | 2021-01-21 | Scott | Kansas | 20171 | 576 | 16 |
947380 | 947380 | 2021-01-20 | Scott | Kansas | 20171 | 576 | 16 |
944133 | 944133 | 2021-01-19 | Scott | Kansas | 20171 | 575 | 16 |
940888 | 940888 | 2021-01-18 | Scott | Kansas | 20171 | 573 | 16 |
937643 | 937643 | 2021-01-17 | Scott | Kansas | 20171 | 570 | 16 |
934398 | 934398 | 2021-01-16 | Scott | Kansas | 20171 | 570 | 16 |
931153 | 931153 | 2021-01-15 | Scott | Kansas | 20171 | 570 | 16 |
927908 | 927908 | 2021-01-14 | Scott | Kansas | 20171 | 569 | 16 |
924662 | 924662 | 2021-01-13 | Scott | Kansas | 20171 | 567 | 16 |
921417 | 921417 | 2021-01-12 | Scott | Kansas | 20171 | 565 | 16 |
918172 | 918172 | 2021-01-11 | Scott | Kansas | 20171 | 561 | 16 |
914927 | 914927 | 2021-01-10 | Scott | Kansas | 20171 | 561 | 16 |
911682 | 911682 | 2021-01-09 | Scott | Kansas | 20171 | 561 | 16 |
908437 | 908437 | 2021-01-08 | Scott | Kansas | 20171 | 559 | 16 |
905191 | 905191 | 2021-01-07 | Scott | Kansas | 20171 | 559 | 16 |
901946 | 901946 | 2021-01-06 | Scott | Kansas | 20171 | 559 | 16 |
898701 | 898701 | 2021-01-05 | Scott | Kansas | 20171 | 555 | 16 |
895456 | 895456 | 2021-01-04 | Scott | Kansas | 20171 | 555 | 16 |
892209 | 892209 | 2021-01-03 | Scott | Kansas | 20171 | 552 | 16 |
888963 | 888963 | 2021-01-02 | Scott | Kansas | 20171 | 552 | 16 |
885717 | 885717 | 2021-01-01 | Scott | Kansas | 20171 | 552 | 16 |
882472 | 882472 | 2020-12-31 | Scott | Kansas | 20171 | 549 | 16 |
879227 | 879227 | 2020-12-30 | Scott | Kansas | 20171 | 549 | 16 |
875982 | 875982 | 2020-12-29 | Scott | Kansas | 20171 | 549 | 16 |
872737 | 872737 | 2020-12-28 | Scott | Kansas | 20171 | 549 | 16 |
869492 | 869492 | 2020-12-27 | Scott | Kansas | 20171 | 537 | 13 |
866247 | 866247 | 2020-12-26 | Scott | Kansas | 20171 | 537 | 13 |
863002 | 863002 | 2020-12-25 | Scott | Kansas | 20171 | 537 | 13 |
859757 | 859757 | 2020-12-24 | Scott | Kansas | 20171 | 537 | 13 |
856512 | 856512 | 2020-12-23 | Scott | Kansas | 20171 | 537 | 13 |
853267 | 853267 | 2020-12-22 | Scott | Kansas | 20171 | 537 | 13 |
850022 | 850022 | 2020-12-21 | Scott | Kansas | 20171 | 537 | 9 |
846777 | 846777 | 2020-12-20 | Scott | Kansas | 20171 | 535 | 9 |
843531 | 843531 | 2020-12-19 | Scott | Kansas | 20171 | 535 | 9 |
840286 | 840286 | 2020-12-18 | Scott | Kansas | 20171 | 535 | 9 |
837041 | 837041 | 2020-12-17 | Scott | Kansas | 20171 | 529 | 9 |
833795 | 833795 | 2020-12-16 | Scott | Kansas | 20171 | 528 | 9 |
830548 | 830548 | 2020-12-15 | Scott | Kansas | 20171 | 525 | 9 |
827302 | 827302 | 2020-12-14 | Scott | Kansas | 20171 | 523 | 9 |
824055 | 824055 | 2020-12-13 | Scott | Kansas | 20171 | 512 | 8 |
820809 | 820809 | 2020-12-12 | Scott | Kansas | 20171 | 512 | 8 |
817563 | 817563 | 2020-12-11 | Scott | Kansas | 20171 | 512 | 8 |
814317 | 814317 | 2020-12-10 | Scott | Kansas | 20171 | 505 | 8 |
811072 | 811072 | 2020-12-09 | Scott | Kansas | 20171 | 503 | 7 |
807827 | 807827 | 2020-12-08 | Scott | Kansas | 20171 | 497 | 7 |
804582 | 804582 | 2020-12-07 | Scott | Kansas | 20171 | 492 | 7 |
801337 | 801337 | 2020-12-06 | Scott | Kansas | 20171 | 482 | 5 |
798092 | 798092 | 2020-12-05 | Scott | Kansas | 20171 | 482 | 5 |
794847 | 794847 | 2020-12-04 | Scott | Kansas | 20171 | 482 | 5 |
791602 | 791602 | 2020-12-03 | Scott | Kansas | 20171 | 468 | 5 |
788357 | 788357 | 2020-12-02 | Scott | Kansas | 20171 | 468 | 5 |
785113 | 785113 | 2020-12-01 | Scott | Kansas | 20171 | 460 | 4 |
781868 | 781868 | 2020-11-30 | Scott | Kansas | 20171 | 456 | 3 |
778622 | 778622 | 2020-11-29 | Scott | Kansas | 20171 | 427 | 3 |
775377 | 775377 | 2020-11-28 | Scott | Kansas | 20171 | 427 | 3 |
772132 | 772132 | 2020-11-27 | Scott | Kansas | 20171 | 427 | 3 |
768887 | 768887 | 2020-11-26 | Scott | Kansas | 20171 | 427 | 3 |
765641 | 765641 | 2020-11-25 | Scott | Kansas | 20171 | 427 | 3 |
762396 | 762396 | 2020-11-24 | Scott | Kansas | 20171 | 420 | 3 |
759151 | 759151 | 2020-11-23 | Scott | Kansas | 20171 | 414 | 3 |
755904 | 755904 | 2020-11-22 | Scott | Kansas | 20171 | 394 | 3 |
752658 | 752658 | 2020-11-21 | Scott | Kansas | 20171 | 394 | 3 |
749412 | 749412 | 2020-11-20 | Scott | Kansas | 20171 | 394 | 3 |
746166 | 746166 | 2020-11-19 | Scott | Kansas | 20171 | 375 | 2 |
742919 | 742919 | 2020-11-18 | Scott | Kansas | 20171 | 375 | 2 |
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);