ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054444 | 1054444 | 2021-02-22 | Jefferson | Kansas | 20087 | 1605 | 30 |
1051197 | 1051197 | 2021-02-21 | Jefferson | Kansas | 20087 | 1603 | 30 |
1047950 | 1047950 | 2021-02-20 | Jefferson | Kansas | 20087 | 1603 | 30 |
1044705 | 1044705 | 2021-02-19 | Jefferson | Kansas | 20087 | 1603 | 30 |
1041460 | 1041460 | 2021-02-18 | Jefferson | Kansas | 20087 | 1596 | 28 |
1038215 | 1038215 | 2021-02-17 | Jefferson | Kansas | 20087 | 1596 | 28 |
1034970 | 1034970 | 2021-02-16 | Jefferson | Kansas | 20087 | 1590 | 28 |
1031724 | 1031724 | 2021-02-15 | Jefferson | Kansas | 20087 | 1590 | 28 |
1028477 | 1028477 | 2021-02-14 | Jefferson | Kansas | 20087 | 1576 | 28 |
1025232 | 1025232 | 2021-02-13 | Jefferson | Kansas | 20087 | 1576 | 28 |
1021987 | 1021987 | 2021-02-12 | Jefferson | Kansas | 20087 | 1576 | 28 |
1018742 | 1018742 | 2021-02-11 | Jefferson | Kansas | 20087 | 1568 | 28 |
1015497 | 1015497 | 2021-02-10 | Jefferson | Kansas | 20087 | 1568 | 28 |
1012252 | 1012252 | 2021-02-09 | Jefferson | Kansas | 20087 | 1560 | 28 |
1009006 | 1009006 | 2021-02-08 | Jefferson | Kansas | 20087 | 1560 | 28 |
1005760 | 1005760 | 2021-02-07 | Jefferson | Kansas | 20087 | 1554 | 28 |
1002514 | 1002514 | 2021-02-06 | Jefferson | Kansas | 20087 | 1554 | 28 |
999268 | 999268 | 2021-02-05 | Jefferson | Kansas | 20087 | 1554 | 28 |
996022 | 996022 | 2021-02-04 | Jefferson | Kansas | 20087 | 1542 | 26 |
992776 | 992776 | 2021-02-03 | Jefferson | Kansas | 20087 | 1542 | 24 |
989530 | 989530 | 2021-02-02 | Jefferson | Kansas | 20087 | 1532 | 24 |
986283 | 986283 | 2021-02-01 | Jefferson | Kansas | 20087 | 1532 | 24 |
983036 | 983036 | 2021-01-31 | Jefferson | Kansas | 20087 | 1521 | 24 |
979790 | 979790 | 2021-01-30 | Jefferson | Kansas | 20087 | 1521 | 24 |
976544 | 976544 | 2021-01-29 | Jefferson | Kansas | 20087 | 1521 | 24 |
973299 | 973299 | 2021-01-28 | Jefferson | Kansas | 20087 | 1510 | 24 |
970054 | 970054 | 2021-01-27 | Jefferson | Kansas | 20087 | 1510 | 24 |
966810 | 966810 | 2021-01-26 | Jefferson | Kansas | 20087 | 1495 | 24 |
963565 | 963565 | 2021-01-25 | Jefferson | Kansas | 20087 | 1495 | 24 |
960320 | 960320 | 2021-01-24 | Jefferson | Kansas | 20087 | 1482 | 24 |
957074 | 957074 | 2021-01-23 | Jefferson | Kansas | 20087 | 1482 | 24 |
953829 | 953829 | 2021-01-22 | Jefferson | Kansas | 20087 | 1482 | 24 |
950584 | 950584 | 2021-01-21 | Jefferson | Kansas | 20087 | 1458 | 24 |
947338 | 947338 | 2021-01-20 | Jefferson | Kansas | 20087 | 1458 | 24 |
944091 | 944091 | 2021-01-19 | Jefferson | Kansas | 20087 | 1447 | 24 |
940846 | 940846 | 2021-01-18 | Jefferson | Kansas | 20087 | 1447 | 24 |
937601 | 937601 | 2021-01-17 | Jefferson | Kansas | 20087 | 1425 | 24 |
934356 | 934356 | 2021-01-16 | Jefferson | Kansas | 20087 | 1425 | 24 |
931111 | 931111 | 2021-01-15 | Jefferson | Kansas | 20087 | 1425 | 24 |
927866 | 927866 | 2021-01-14 | Jefferson | Kansas | 20087 | 1394 | 23 |
924620 | 924620 | 2021-01-13 | Jefferson | Kansas | 20087 | 1394 | 23 |
921375 | 921375 | 2021-01-12 | Jefferson | Kansas | 20087 | 1345 | 22 |
918130 | 918130 | 2021-01-11 | Jefferson | Kansas | 20087 | 1345 | 21 |
914885 | 914885 | 2021-01-10 | Jefferson | Kansas | 20087 | 1295 | 21 |
911640 | 911640 | 2021-01-09 | Jefferson | Kansas | 20087 | 1295 | 21 |
908395 | 908395 | 2021-01-08 | Jefferson | Kansas | 20087 | 1295 | 21 |
905149 | 905149 | 2021-01-07 | Jefferson | Kansas | 20087 | 1260 | 18 |
901904 | 901904 | 2021-01-06 | Jefferson | Kansas | 20087 | 1260 | 18 |
898659 | 898659 | 2021-01-05 | Jefferson | Kansas | 20087 | 1225 | 14 |
895414 | 895414 | 2021-01-04 | Jefferson | Kansas | 20087 | 1225 | 14 |
892167 | 892167 | 2021-01-03 | Jefferson | Kansas | 20087 | 1206 | 10 |
888921 | 888921 | 2021-01-02 | Jefferson | Kansas | 20087 | 1206 | 10 |
885675 | 885675 | 2021-01-01 | Jefferson | Kansas | 20087 | 1206 | 10 |
882430 | 882430 | 2020-12-31 | Jefferson | Kansas | 20087 | 1173 | 10 |
879185 | 879185 | 2020-12-30 | Jefferson | Kansas | 20087 | 1173 | 10 |
875940 | 875940 | 2020-12-29 | Jefferson | Kansas | 20087 | 1135 | 10 |
872695 | 872695 | 2020-12-28 | Jefferson | Kansas | 20087 | 1135 | 10 |
869450 | 869450 | 2020-12-27 | Jefferson | Kansas | 20087 | 1087 | 10 |
866205 | 866205 | 2020-12-26 | Jefferson | Kansas | 20087 | 1087 | 10 |
862960 | 862960 | 2020-12-25 | Jefferson | Kansas | 20087 | 1087 | 10 |
859715 | 859715 | 2020-12-24 | Jefferson | Kansas | 20087 | 1087 | 10 |
856470 | 856470 | 2020-12-23 | Jefferson | Kansas | 20087 | 1087 | 10 |
853225 | 853225 | 2020-12-22 | Jefferson | Kansas | 20087 | 1057 | 10 |
849980 | 849980 | 2020-12-21 | Jefferson | Kansas | 20087 | 1057 | 10 |
846735 | 846735 | 2020-12-20 | Jefferson | Kansas | 20087 | 1017 | 9 |
843489 | 843489 | 2020-12-19 | Jefferson | Kansas | 20087 | 1017 | 9 |
840244 | 840244 | 2020-12-18 | Jefferson | Kansas | 20087 | 1017 | 9 |
836999 | 836999 | 2020-12-17 | Jefferson | Kansas | 20087 | 962 | 9 |
833753 | 833753 | 2020-12-16 | Jefferson | Kansas | 20087 | 962 | 9 |
830506 | 830506 | 2020-12-15 | Jefferson | Kansas | 20087 | 926 | 9 |
827260 | 827260 | 2020-12-14 | Jefferson | Kansas | 20087 | 925 | 9 |
824013 | 824013 | 2020-12-13 | Jefferson | Kansas | 20087 | 906 | 9 |
820767 | 820767 | 2020-12-12 | Jefferson | Kansas | 20087 | 906 | 9 |
817521 | 817521 | 2020-12-11 | Jefferson | Kansas | 20087 | 906 | 9 |
814275 | 814275 | 2020-12-10 | Jefferson | Kansas | 20087 | 880 | 9 |
811030 | 811030 | 2020-12-09 | Jefferson | Kansas | 20087 | 871 | 9 |
807785 | 807785 | 2020-12-08 | Jefferson | Kansas | 20087 | 841 | 9 |
804540 | 804540 | 2020-12-07 | Jefferson | Kansas | 20087 | 841 | 8 |
801295 | 801295 | 2020-12-06 | Jefferson | Kansas | 20087 | 800 | 8 |
798050 | 798050 | 2020-12-05 | Jefferson | Kansas | 20087 | 800 | 8 |
794805 | 794805 | 2020-12-04 | Jefferson | Kansas | 20087 | 800 | 8 |
791560 | 791560 | 2020-12-03 | Jefferson | Kansas | 20087 | 784 | 8 |
788315 | 788315 | 2020-12-02 | Jefferson | Kansas | 20087 | 758 | 8 |
785071 | 785071 | 2020-12-01 | Jefferson | Kansas | 20087 | 742 | 8 |
781826 | 781826 | 2020-11-30 | Jefferson | Kansas | 20087 | 731 | 8 |
778580 | 778580 | 2020-11-29 | Jefferson | Kansas | 20087 | 703 | 7 |
775335 | 775335 | 2020-11-28 | Jefferson | Kansas | 20087 | 703 | 7 |
772090 | 772090 | 2020-11-27 | Jefferson | Kansas | 20087 | 703 | 7 |
768845 | 768845 | 2020-11-26 | Jefferson | Kansas | 20087 | 680 | 7 |
765599 | 765599 | 2020-11-25 | Jefferson | Kansas | 20087 | 680 | 7 |
762354 | 762354 | 2020-11-24 | Jefferson | Kansas | 20087 | 659 | 7 |
759109 | 759109 | 2020-11-23 | Jefferson | Kansas | 20087 | 647 | 7 |
755862 | 755862 | 2020-11-22 | Jefferson | Kansas | 20087 | 601 | 6 |
752616 | 752616 | 2020-11-21 | Jefferson | Kansas | 20087 | 601 | 6 |
749370 | 749370 | 2020-11-20 | Jefferson | Kansas | 20087 | 601 | 6 |
746124 | 746124 | 2020-11-19 | Jefferson | Kansas | 20087 | 586 | 6 |
742877 | 742877 | 2020-11-18 | Jefferson | Kansas | 20087 | 568 | 6 |
739630 | 739630 | 2020-11-17 | Jefferson | Kansas | 20087 | 550 | 6 |
736386 | 736386 | 2020-11-16 | Jefferson | Kansas | 20087 | 525 | 6 |
733140 | 733140 | 2020-11-15 | Jefferson | Kansas | 20087 | 476 | 6 |
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);