ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where county = "Smith" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947386 | 947386 | 2021-01-20 | Smith | Kansas | 20183 | 245 | 2 |
944139 | 944139 | 2021-01-19 | Smith | Kansas | 20183 | 245 | 2 |
940894 | 940894 | 2021-01-18 | Smith | Kansas | 20183 | 245 | 2 |
937649 | 937649 | 2021-01-17 | Smith | Kansas | 20183 | 245 | 2 |
934404 | 934404 | 2021-01-16 | Smith | Kansas | 20183 | 245 | 2 |
931159 | 931159 | 2021-01-15 | Smith | Kansas | 20183 | 245 | 2 |
927914 | 927914 | 2021-01-14 | Smith | Kansas | 20183 | 245 | 2 |
924668 | 924668 | 2021-01-13 | Smith | Kansas | 20183 | 245 | 2 |
921423 | 921423 | 2021-01-12 | Smith | Kansas | 20183 | 243 | 1 |
918178 | 918178 | 2021-01-11 | Smith | Kansas | 20183 | 243 | 1 |
914933 | 914933 | 2021-01-10 | Smith | Kansas | 20183 | 240 | 1 |
911688 | 911688 | 2021-01-09 | Smith | Kansas | 20183 | 240 | 1 |
908443 | 908443 | 2021-01-08 | Smith | Kansas | 20183 | 237 | 1 |
905197 | 905197 | 2021-01-07 | Smith | Kansas | 20183 | 237 | 1 |
901952 | 901952 | 2021-01-06 | Smith | Kansas | 20183 | 229 | 1 |
898707 | 898707 | 2021-01-05 | Smith | Kansas | 20183 | 224 | 1 |
895462 | 895462 | 2021-01-04 | Smith | Kansas | 20183 | 224 | 1 |
892215 | 892215 | 2021-01-03 | Smith | Kansas | 20183 | 224 | 1 |
888969 | 888969 | 2021-01-02 | Smith | Kansas | 20183 | 224 | 1 |
885723 | 885723 | 2021-01-01 | Smith | Kansas | 20183 | 224 | 1 |
882478 | 882478 | 2020-12-31 | Smith | Kansas | 20183 | 209 | 1 |
879233 | 879233 | 2020-12-30 | Smith | Kansas | 20183 | 209 | 1 |
875988 | 875988 | 2020-12-29 | Smith | Kansas | 20183 | 209 | 1 |
872743 | 872743 | 2020-12-28 | Smith | Kansas | 20183 | 209 | 1 |
869498 | 869498 | 2020-12-27 | Smith | Kansas | 20183 | 199 | 1 |
866253 | 866253 | 2020-12-26 | Smith | Kansas | 20183 | 199 | 1 |
863008 | 863008 | 2020-12-25 | Smith | Kansas | 20183 | 199 | 1 |
859763 | 859763 | 2020-12-24 | Smith | Kansas | 20183 | 199 | 1 |
856518 | 856518 | 2020-12-23 | Smith | Kansas | 20183 | 199 | 1 |
853273 | 853273 | 2020-12-22 | Smith | Kansas | 20183 | 199 | 1 |
850028 | 850028 | 2020-12-21 | Smith | Kansas | 20183 | 196 | 1 |
846783 | 846783 | 2020-12-20 | Smith | Kansas | 20183 | 196 | 1 |
843537 | 843537 | 2020-12-19 | Smith | Kansas | 20183 | 193 | 1 |
840292 | 840292 | 2020-12-18 | Smith | Kansas | 20183 | 193 | 1 |
837047 | 837047 | 2020-12-17 | Smith | Kansas | 20183 | 192 | 1 |
833801 | 833801 | 2020-12-16 | Smith | Kansas | 20183 | 192 | 1 |
830554 | 830554 | 2020-12-15 | Smith | Kansas | 20183 | 192 | 1 |
827308 | 827308 | 2020-12-14 | Smith | Kansas | 20183 | 192 | 1 |
824061 | 824061 | 2020-12-13 | Smith | Kansas | 20183 | 195 | 1 |
820815 | 820815 | 2020-12-12 | Smith | Kansas | 20183 | 191 | 1 |
817569 | 817569 | 2020-12-11 | Smith | Kansas | 20183 | 191 | 1 |
814323 | 814323 | 2020-12-10 | Smith | Kansas | 20183 | 186 | 1 |
811078 | 811078 | 2020-12-09 | Smith | Kansas | 20183 | 186 | 1 |
807833 | 807833 | 2020-12-08 | Smith | Kansas | 20183 | 189 | 1 |
804588 | 804588 | 2020-12-07 | Smith | Kansas | 20183 | 189 | 1 |
801343 | 801343 | 2020-12-06 | Smith | Kansas | 20183 | 185 | 1 |
798098 | 798098 | 2020-12-05 | Smith | Kansas | 20183 | 185 | 1 |
794853 | 794853 | 2020-12-04 | Smith | Kansas | 20183 | 185 | 1 |
791608 | 791608 | 2020-12-03 | Smith | Kansas | 20183 | 160 | 1 |
788363 | 788363 | 2020-12-02 | Smith | Kansas | 20183 | 160 | 1 |
785119 | 785119 | 2020-12-01 | Smith | Kansas | 20183 | 158 | 1 |
781874 | 781874 | 2020-11-30 | Smith | Kansas | 20183 | 158 | 1 |
778628 | 778628 | 2020-11-29 | Smith | Kansas | 20183 | 158 | 1 |
775383 | 775383 | 2020-11-28 | Smith | Kansas | 20183 | 158 | 1 |
772138 | 772138 | 2020-11-27 | Smith | Kansas | 20183 | 158 | 1 |
768893 | 768893 | 2020-11-26 | Smith | Kansas | 20183 | 132 | 1 |
765647 | 765647 | 2020-11-25 | Smith | Kansas | 20183 | 132 | 1 |
762402 | 762402 | 2020-11-24 | Smith | Kansas | 20183 | 128 | 1 |
759157 | 759157 | 2020-11-23 | Smith | Kansas | 20183 | 128 | 1 |
755910 | 755910 | 2020-11-22 | Smith | Kansas | 20183 | 108 | 1 |
752664 | 752664 | 2020-11-21 | Smith | Kansas | 20183 | 108 | 1 |
749418 | 749418 | 2020-11-20 | Smith | Kansas | 20183 | 108 | 1 |
746172 | 746172 | 2020-11-19 | Smith | Kansas | 20183 | 95 | 1 |
742925 | 742925 | 2020-11-18 | Smith | Kansas | 20183 | 95 | 1 |
739678 | 739678 | 2020-11-17 | Smith | Kansas | 20183 | 86 | 0 |
736434 | 736434 | 2020-11-16 | Smith | Kansas | 20183 | 86 | 0 |
733188 | 733188 | 2020-11-15 | Smith | Kansas | 20183 | 80 | 0 |
729943 | 729943 | 2020-11-14 | Smith | Kansas | 20183 | 80 | 0 |
726700 | 726700 | 2020-11-13 | Smith | Kansas | 20183 | 72 | 0 |
723457 | 723457 | 2020-11-12 | Smith | Kansas | 20183 | 63 | 0 |
720214 | 720214 | 2020-11-11 | Smith | Kansas | 20183 | 63 | 0 |
716971 | 716971 | 2020-11-10 | Smith | Kansas | 20183 | 59 | 0 |
713727 | 713727 | 2020-11-09 | Smith | Kansas | 20183 | 59 | 0 |
710483 | 710483 | 2020-11-08 | Smith | Kansas | 20183 | 55 | 0 |
707239 | 707239 | 2020-11-07 | Smith | Kansas | 20183 | 53 | 0 |
703996 | 703996 | 2020-11-06 | Smith | Kansas | 20183 | 53 | 0 |
700754 | 700754 | 2020-11-05 | Smith | Kansas | 20183 | 45 | 0 |
697510 | 697510 | 2020-11-04 | Smith | Kansas | 20183 | 45 | 0 |
694268 | 694268 | 2020-11-03 | Smith | Kansas | 20183 | 34 | 0 |
691025 | 691025 | 2020-11-02 | Smith | Kansas | 20183 | 34 | 0 |
687780 | 687780 | 2020-11-01 | Smith | Kansas | 20183 | 28 | 0 |
684536 | 684536 | 2020-10-31 | Smith | Kansas | 20183 | 28 | 0 |
681293 | 681293 | 2020-10-30 | Smith | Kansas | 20183 | 28 | 0 |
678050 | 678050 | 2020-10-29 | Smith | Kansas | 20183 | 24 | 0 |
674807 | 674807 | 2020-10-28 | Smith | Kansas | 20183 | 24 | 0 |
671565 | 671565 | 2020-10-27 | Smith | Kansas | 20183 | 22 | 0 |
668322 | 668322 | 2020-10-26 | Smith | Kansas | 20183 | 22 | 0 |
665078 | 665078 | 2020-10-25 | Smith | Kansas | 20183 | 22 | 0 |
661833 | 661833 | 2020-10-24 | Smith | Kansas | 20183 | 22 | 0 |
658589 | 658589 | 2020-10-23 | Smith | Kansas | 20183 | 22 | 0 |
655344 | 655344 | 2020-10-22 | Smith | Kansas | 20183 | 19 | 0 |
652099 | 652099 | 2020-10-21 | Smith | Kansas | 20183 | 19 | 0 |
648855 | 648855 | 2020-10-20 | Smith | Kansas | 20183 | 19 | 0 |
645610 | 645610 | 2020-10-19 | Smith | Kansas | 20183 | 19 | 0 |
642363 | 642363 | 2020-10-18 | Smith | Kansas | 20183 | 19 | 0 |
639116 | 639116 | 2020-10-17 | Smith | Kansas | 20183 | 19 | 0 |
635870 | 635870 | 2020-10-16 | Smith | Kansas | 20183 | 19 | 0 |
632624 | 632624 | 2020-10-15 | Smith | Kansas | 20183 | 19 | 0 |
629380 | 629380 | 2020-10-14 | Smith | Kansas | 20183 | 19 | 0 |
626137 | 626137 | 2020-10-13 | Smith | Kansas | 20183 | 19 | 0 |
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);