ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
745 rows where county = "Cheyenne" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054412 | 1054412 | 2021-02-22 | Cheyenne | Kansas | 20023 | 346 | 10 |
1051165 | 1051165 | 2021-02-21 | Cheyenne | Kansas | 20023 | 344 | 10 |
1047918 | 1047918 | 2021-02-20 | Cheyenne | Kansas | 20023 | 344 | 10 |
1044673 | 1044673 | 2021-02-19 | Cheyenne | Kansas | 20023 | 344 | 10 |
1041428 | 1041428 | 2021-02-18 | Cheyenne | Kansas | 20023 | 344 | 10 |
1038183 | 1038183 | 2021-02-17 | Cheyenne | Kansas | 20023 | 344 | 10 |
1034938 | 1034938 | 2021-02-16 | Cheyenne | Kansas | 20023 | 343 | 10 |
1031692 | 1031692 | 2021-02-15 | Cheyenne | Kansas | 20023 | 343 | 10 |
1028445 | 1028445 | 2021-02-14 | Cheyenne | Kansas | 20023 | 342 | 10 |
1025200 | 1025200 | 2021-02-13 | Cheyenne | Kansas | 20023 | 342 | 10 |
1021955 | 1021955 | 2021-02-12 | Cheyenne | Kansas | 20023 | 342 | 10 |
1018710 | 1018710 | 2021-02-11 | Cheyenne | Kansas | 20023 | 342 | 10 |
1015465 | 1015465 | 2021-02-10 | Cheyenne | Kansas | 20023 | 342 | 10 |
1012220 | 1012220 | 2021-02-09 | Cheyenne | Kansas | 20023 | 341 | 10 |
1008974 | 1008974 | 2021-02-08 | Cheyenne | Kansas | 20023 | 341 | 10 |
1005728 | 1005728 | 2021-02-07 | Cheyenne | Kansas | 20023 | 341 | 10 |
1002482 | 1002482 | 2021-02-06 | Cheyenne | Kansas | 20023 | 341 | 10 |
999236 | 999236 | 2021-02-05 | Cheyenne | Kansas | 20023 | 341 | 10 |
995990 | 995990 | 2021-02-04 | Cheyenne | Kansas | 20023 | 340 | 10 |
992744 | 992744 | 2021-02-03 | Cheyenne | Kansas | 20023 | 340 | 10 |
989498 | 989498 | 2021-02-02 | Cheyenne | Kansas | 20023 | 338 | 10 |
986251 | 986251 | 2021-02-01 | Cheyenne | Kansas | 20023 | 338 | 10 |
983004 | 983004 | 2021-01-31 | Cheyenne | Kansas | 20023 | 337 | 10 |
979758 | 979758 | 2021-01-30 | Cheyenne | Kansas | 20023 | 337 | 10 |
976512 | 976512 | 2021-01-29 | Cheyenne | Kansas | 20023 | 337 | 10 |
973267 | 973267 | 2021-01-28 | Cheyenne | Kansas | 20023 | 335 | 10 |
970022 | 970022 | 2021-01-27 | Cheyenne | Kansas | 20023 | 335 | 10 |
966778 | 966778 | 2021-01-26 | Cheyenne | Kansas | 20023 | 335 | 10 |
963533 | 963533 | 2021-01-25 | Cheyenne | Kansas | 20023 | 335 | 10 |
960288 | 960288 | 2021-01-24 | Cheyenne | Kansas | 20023 | 333 | 10 |
957042 | 957042 | 2021-01-23 | Cheyenne | Kansas | 20023 | 333 | 10 |
953797 | 953797 | 2021-01-22 | Cheyenne | Kansas | 20023 | 333 | 10 |
950552 | 950552 | 2021-01-21 | Cheyenne | Kansas | 20023 | 332 | 10 |
947306 | 947306 | 2021-01-20 | Cheyenne | Kansas | 20023 | 332 | 10 |
944059 | 944059 | 2021-01-19 | Cheyenne | Kansas | 20023 | 330 | 10 |
940814 | 940814 | 2021-01-18 | Cheyenne | Kansas | 20023 | 330 | 10 |
937569 | 937569 | 2021-01-17 | Cheyenne | Kansas | 20023 | 327 | 10 |
934324 | 934324 | 2021-01-16 | Cheyenne | Kansas | 20023 | 327 | 10 |
931079 | 931079 | 2021-01-15 | Cheyenne | Kansas | 20023 | 327 | 10 |
927834 | 927834 | 2021-01-14 | Cheyenne | Kansas | 20023 | 327 | 10 |
924588 | 924588 | 2021-01-13 | Cheyenne | Kansas | 20023 | 327 | 10 |
921343 | 921343 | 2021-01-12 | Cheyenne | Kansas | 20023 | 321 | 10 |
918098 | 918098 | 2021-01-11 | Cheyenne | Kansas | 20023 | 321 | 10 |
914853 | 914853 | 2021-01-10 | Cheyenne | Kansas | 20023 | 312 | 10 |
911608 | 911608 | 2021-01-09 | Cheyenne | Kansas | 20023 | 312 | 10 |
908363 | 908363 | 2021-01-08 | Cheyenne | Kansas | 20023 | 312 | 10 |
905117 | 905117 | 2021-01-07 | Cheyenne | Kansas | 20023 | 300 | 10 |
901872 | 901872 | 2021-01-06 | Cheyenne | Kansas | 20023 | 300 | 10 |
898627 | 898627 | 2021-01-05 | Cheyenne | Kansas | 20023 | 289 | 10 |
895382 | 895382 | 2021-01-04 | Cheyenne | Kansas | 20023 | 289 | 10 |
892135 | 892135 | 2021-01-03 | Cheyenne | Kansas | 20023 | 284 | 10 |
888889 | 888889 | 2021-01-02 | Cheyenne | Kansas | 20023 | 284 | 10 |
885643 | 885643 | 2021-01-01 | Cheyenne | Kansas | 20023 | 284 | 10 |
882398 | 882398 | 2020-12-31 | Cheyenne | Kansas | 20023 | 275 | 10 |
879153 | 879153 | 2020-12-30 | Cheyenne | Kansas | 20023 | 275 | 10 |
875908 | 875908 | 2020-12-29 | Cheyenne | Kansas | 20023 | 271 | 10 |
872663 | 872663 | 2020-12-28 | Cheyenne | Kansas | 20023 | 271 | 10 |
869418 | 869418 | 2020-12-27 | Cheyenne | Kansas | 20023 | 266 | 10 |
866173 | 866173 | 2020-12-26 | Cheyenne | Kansas | 20023 | 266 | 10 |
862928 | 862928 | 2020-12-25 | Cheyenne | Kansas | 20023 | 266 | 10 |
859683 | 859683 | 2020-12-24 | Cheyenne | Kansas | 20023 | 266 | 10 |
856438 | 856438 | 2020-12-23 | Cheyenne | Kansas | 20023 | 266 | 10 |
853193 | 853193 | 2020-12-22 | Cheyenne | Kansas | 20023 | 260 | 10 |
849948 | 849948 | 2020-12-21 | Cheyenne | Kansas | 20023 | 260 | 10 |
846703 | 846703 | 2020-12-20 | Cheyenne | Kansas | 20023 | 253 | 10 |
843457 | 843457 | 2020-12-19 | Cheyenne | Kansas | 20023 | 253 | 10 |
840212 | 840212 | 2020-12-18 | Cheyenne | Kansas | 20023 | 253 | 10 |
836967 | 836967 | 2020-12-17 | Cheyenne | Kansas | 20023 | 243 | 10 |
833721 | 833721 | 2020-12-16 | Cheyenne | Kansas | 20023 | 243 | 10 |
830474 | 830474 | 2020-12-15 | Cheyenne | Kansas | 20023 | 235 | 10 |
827228 | 827228 | 2020-12-14 | Cheyenne | Kansas | 20023 | 235 | 10 |
823981 | 823981 | 2020-12-13 | Cheyenne | Kansas | 20023 | 231 | 9 |
820735 | 820735 | 2020-12-12 | Cheyenne | Kansas | 20023 | 231 | 9 |
817489 | 817489 | 2020-12-11 | Cheyenne | Kansas | 20023 | 231 | 9 |
814243 | 814243 | 2020-12-10 | Cheyenne | Kansas | 20023 | 229 | 9 |
810998 | 810998 | 2020-12-09 | Cheyenne | Kansas | 20023 | 229 | 9 |
807753 | 807753 | 2020-12-08 | Cheyenne | Kansas | 20023 | 226 | 9 |
804508 | 804508 | 2020-12-07 | Cheyenne | Kansas | 20023 | 226 | 9 |
801263 | 801263 | 2020-12-06 | Cheyenne | Kansas | 20023 | 223 | 9 |
798018 | 798018 | 2020-12-05 | Cheyenne | Kansas | 20023 | 223 | 9 |
794773 | 794773 | 2020-12-04 | Cheyenne | Kansas | 20023 | 223 | 9 |
791528 | 791528 | 2020-12-03 | Cheyenne | Kansas | 20023 | 218 | 9 |
788283 | 788283 | 2020-12-02 | Cheyenne | Kansas | 20023 | 218 | 9 |
785039 | 785039 | 2020-12-01 | Cheyenne | Kansas | 20023 | 208 | 9 |
781794 | 781794 | 2020-11-30 | Cheyenne | Kansas | 20023 | 208 | 9 |
778548 | 778548 | 2020-11-29 | Cheyenne | Kansas | 20023 | 207 | 9 |
775303 | 775303 | 2020-11-28 | Cheyenne | Kansas | 20023 | 207 | 9 |
772058 | 772058 | 2020-11-27 | Cheyenne | Kansas | 20023 | 207 | 9 |
768813 | 768813 | 2020-11-26 | Cheyenne | Kansas | 20023 | 206 | 9 |
765567 | 765567 | 2020-11-25 | Cheyenne | Kansas | 20023 | 206 | 9 |
762322 | 762322 | 2020-11-24 | Cheyenne | Kansas | 20023 | 202 | 9 |
759077 | 759077 | 2020-11-23 | Cheyenne | Kansas | 20023 | 202 | 9 |
755830 | 755830 | 2020-11-22 | Cheyenne | Kansas | 20023 | 199 | 8 |
752584 | 752584 | 2020-11-21 | Cheyenne | Kansas | 20023 | 199 | 8 |
749338 | 749338 | 2020-11-20 | Cheyenne | Kansas | 20023 | 199 | 8 |
746092 | 746092 | 2020-11-19 | Cheyenne | Kansas | 20023 | 189 | 8 |
742845 | 742845 | 2020-11-18 | Cheyenne | Kansas | 20023 | 189 | 8 |
739598 | 739598 | 2020-11-17 | Cheyenne | Kansas | 20023 | 183 | 8 |
736354 | 736354 | 2020-11-16 | Cheyenne | Kansas | 20023 | 183 | 7 |
733108 | 733108 | 2020-11-15 | Cheyenne | Kansas | 20023 | 176 | 7 |
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);