ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson", fips = 20087 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
729895 | 729895 | 2020-11-14 | Jefferson | Kansas | 20087 | 476 | 6 |
726652 | 726652 | 2020-11-13 | Jefferson | Kansas | 20087 | 476 | 6 |
723409 | 723409 | 2020-11-12 | Jefferson | Kansas | 20087 | 429 | 6 |
720166 | 720166 | 2020-11-11 | Jefferson | Kansas | 20087 | 429 | 6 |
716923 | 716923 | 2020-11-10 | Jefferson | Kansas | 20087 | 403 | 6 |
713679 | 713679 | 2020-11-09 | Jefferson | Kansas | 20087 | 398 | 6 |
710435 | 710435 | 2020-11-08 | Jefferson | Kansas | 20087 | 366 | 6 |
707191 | 707191 | 2020-11-07 | Jefferson | Kansas | 20087 | 366 | 6 |
703948 | 703948 | 2020-11-06 | Jefferson | Kansas | 20087 | 366 | 6 |
700706 | 700706 | 2020-11-05 | Jefferson | Kansas | 20087 | 341 | 6 |
697462 | 697462 | 2020-11-04 | Jefferson | Kansas | 20087 | 341 | 6 |
694220 | 694220 | 2020-11-03 | Jefferson | Kansas | 20087 | 325 | 6 |
690977 | 690977 | 2020-11-02 | Jefferson | Kansas | 20087 | 316 | 6 |
687732 | 687732 | 2020-11-01 | Jefferson | Kansas | 20087 | 299 | 6 |
684488 | 684488 | 2020-10-31 | Jefferson | Kansas | 20087 | 299 | 6 |
681245 | 681245 | 2020-10-30 | Jefferson | Kansas | 20087 | 299 | 6 |
678002 | 678002 | 2020-10-29 | Jefferson | Kansas | 20087 | 286 | 6 |
674759 | 674759 | 2020-10-28 | Jefferson | Kansas | 20087 | 281 | 6 |
671517 | 671517 | 2020-10-27 | Jefferson | Kansas | 20087 | 281 | 6 |
668274 | 668274 | 2020-10-26 | Jefferson | Kansas | 20087 | 271 | 4 |
665030 | 665030 | 2020-10-25 | Jefferson | Kansas | 20087 | 268 | 4 |
661785 | 661785 | 2020-10-24 | Jefferson | Kansas | 20087 | 268 | 4 |
658541 | 658541 | 2020-10-23 | Jefferson | Kansas | 20087 | 268 | 4 |
655296 | 655296 | 2020-10-22 | Jefferson | Kansas | 20087 | 265 | 4 |
652051 | 652051 | 2020-10-21 | Jefferson | Kansas | 20087 | 265 | 4 |
648807 | 648807 | 2020-10-20 | Jefferson | Kansas | 20087 | 255 | 4 |
645562 | 645562 | 2020-10-19 | Jefferson | Kansas | 20087 | 255 | 4 |
642315 | 642315 | 2020-10-18 | Jefferson | Kansas | 20087 | 253 | 4 |
639068 | 639068 | 2020-10-17 | Jefferson | Kansas | 20087 | 253 | 4 |
635822 | 635822 | 2020-10-16 | Jefferson | Kansas | 20087 | 248 | 4 |
632576 | 632576 | 2020-10-15 | Jefferson | Kansas | 20087 | 247 | 4 |
629332 | 629332 | 2020-10-14 | Jefferson | Kansas | 20087 | 238 | 4 |
626089 | 626089 | 2020-10-13 | Jefferson | Kansas | 20087 | 236 | 4 |
622847 | 622847 | 2020-10-12 | Jefferson | Kansas | 20087 | 233 | 4 |
619603 | 619603 | 2020-10-11 | Jefferson | Kansas | 20087 | 222 | 4 |
616361 | 616361 | 2020-10-10 | Jefferson | Kansas | 20087 | 222 | 4 |
613120 | 613120 | 2020-10-09 | Jefferson | Kansas | 20087 | 222 | 4 |
609878 | 609878 | 2020-10-08 | Jefferson | Kansas | 20087 | 221 | 4 |
606635 | 606635 | 2020-10-07 | Jefferson | Kansas | 20087 | 220 | 4 |
603393 | 603393 | 2020-10-06 | Jefferson | Kansas | 20087 | 219 | 4 |
600150 | 600150 | 2020-10-05 | Jefferson | Kansas | 20087 | 216 | 4 |
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);