ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20063 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054432 | 1054432 | 2021-02-22 | Gove | Kansas | 20063 | 376 | 22 |
1051185 | 1051185 | 2021-02-21 | Gove | Kansas | 20063 | 376 | 22 |
1047938 | 1047938 | 2021-02-20 | Gove | Kansas | 20063 | 376 | 22 |
1044693 | 1044693 | 2021-02-19 | Gove | Kansas | 20063 | 376 | 22 |
1041448 | 1041448 | 2021-02-18 | Gove | Kansas | 20063 | 375 | 22 |
1038203 | 1038203 | 2021-02-17 | Gove | Kansas | 20063 | 375 | 22 |
1034958 | 1034958 | 2021-02-16 | Gove | Kansas | 20063 | 374 | 22 |
1031712 | 1031712 | 2021-02-15 | Gove | Kansas | 20063 | 374 | 22 |
1028465 | 1028465 | 2021-02-14 | Gove | Kansas | 20063 | 374 | 22 |
1025220 | 1025220 | 2021-02-13 | Gove | Kansas | 20063 | 374 | 22 |
1021975 | 1021975 | 2021-02-12 | Gove | Kansas | 20063 | 374 | 22 |
1018730 | 1018730 | 2021-02-11 | Gove | Kansas | 20063 | 374 | 22 |
1015485 | 1015485 | 2021-02-10 | Gove | Kansas | 20063 | 374 | 22 |
1012240 | 1012240 | 2021-02-09 | Gove | Kansas | 20063 | 374 | 22 |
1008994 | 1008994 | 2021-02-08 | Gove | Kansas | 20063 | 374 | 22 |
1005748 | 1005748 | 2021-02-07 | Gove | Kansas | 20063 | 374 | 22 |
1002502 | 1002502 | 2021-02-06 | Gove | Kansas | 20063 | 374 | 22 |
999256 | 999256 | 2021-02-05 | Gove | Kansas | 20063 | 374 | 22 |
996010 | 996010 | 2021-02-04 | Gove | Kansas | 20063 | 374 | 22 |
992764 | 992764 | 2021-02-03 | Gove | Kansas | 20063 | 374 | 22 |
989518 | 989518 | 2021-02-02 | Gove | Kansas | 20063 | 372 | 22 |
986271 | 986271 | 2021-02-01 | Gove | Kansas | 20063 | 372 | 22 |
983024 | 983024 | 2021-01-31 | Gove | Kansas | 20063 | 370 | 22 |
979778 | 979778 | 2021-01-30 | Gove | Kansas | 20063 | 370 | 22 |
976532 | 976532 | 2021-01-29 | Gove | Kansas | 20063 | 370 | 22 |
973287 | 973287 | 2021-01-28 | Gove | Kansas | 20063 | 365 | 22 |
970042 | 970042 | 2021-01-27 | Gove | Kansas | 20063 | 365 | 22 |
966798 | 966798 | 2021-01-26 | Gove | Kansas | 20063 | 361 | 22 |
963553 | 963553 | 2021-01-25 | Gove | Kansas | 20063 | 361 | 22 |
960308 | 960308 | 2021-01-24 | Gove | Kansas | 20063 | 359 | 22 |
957062 | 957062 | 2021-01-23 | Gove | Kansas | 20063 | 359 | 22 |
953817 | 953817 | 2021-01-22 | Gove | Kansas | 20063 | 359 | 22 |
950572 | 950572 | 2021-01-21 | Gove | Kansas | 20063 | 357 | 22 |
947326 | 947326 | 2021-01-20 | Gove | Kansas | 20063 | 357 | 22 |
944079 | 944079 | 2021-01-19 | Gove | Kansas | 20063 | 355 | 22 |
940834 | 940834 | 2021-01-18 | Gove | Kansas | 20063 | 355 | 22 |
937589 | 937589 | 2021-01-17 | Gove | Kansas | 20063 | 356 | 22 |
934344 | 934344 | 2021-01-16 | Gove | Kansas | 20063 | 356 | 22 |
931099 | 931099 | 2021-01-15 | Gove | Kansas | 20063 | 356 | 22 |
927854 | 927854 | 2021-01-14 | Gove | Kansas | 20063 | 351 | 22 |
924608 | 924608 | 2021-01-13 | Gove | Kansas | 20063 | 351 | 22 |
921363 | 921363 | 2021-01-12 | Gove | Kansas | 20063 | 342 | 22 |
918118 | 918118 | 2021-01-11 | Gove | Kansas | 20063 | 342 | 22 |
914873 | 914873 | 2021-01-10 | Gove | Kansas | 20063 | 341 | 22 |
911628 | 911628 | 2021-01-09 | Gove | Kansas | 20063 | 341 | 22 |
908383 | 908383 | 2021-01-08 | Gove | Kansas | 20063 | 341 | 22 |
905137 | 905137 | 2021-01-07 | Gove | Kansas | 20063 | 337 | 22 |
901892 | 901892 | 2021-01-06 | Gove | Kansas | 20063 | 337 | 22 |
898647 | 898647 | 2021-01-05 | Gove | Kansas | 20063 | 335 | 22 |
895402 | 895402 | 2021-01-04 | Gove | Kansas | 20063 | 335 | 22 |
892155 | 892155 | 2021-01-03 | Gove | Kansas | 20063 | 335 | 20 |
888909 | 888909 | 2021-01-02 | Gove | Kansas | 20063 | 335 | 20 |
885663 | 885663 | 2021-01-01 | Gove | Kansas | 20063 | 335 | 20 |
882418 | 882418 | 2020-12-31 | Gove | Kansas | 20063 | 332 | 20 |
879173 | 879173 | 2020-12-30 | Gove | Kansas | 20063 | 332 | 20 |
875928 | 875928 | 2020-12-29 | Gove | Kansas | 20063 | 329 | 20 |
872683 | 872683 | 2020-12-28 | Gove | Kansas | 20063 | 329 | 20 |
869438 | 869438 | 2020-12-27 | Gove | Kansas | 20063 | 329 | 20 |
866193 | 866193 | 2020-12-26 | Gove | Kansas | 20063 | 329 | 20 |
862948 | 862948 | 2020-12-25 | Gove | Kansas | 20063 | 329 | 20 |
859703 | 859703 | 2020-12-24 | Gove | Kansas | 20063 | 329 | 20 |
856458 | 856458 | 2020-12-23 | Gove | Kansas | 20063 | 329 | 20 |
853213 | 853213 | 2020-12-22 | Gove | Kansas | 20063 | 326 | 20 |
849968 | 849968 | 2020-12-21 | Gove | Kansas | 20063 | 326 | 20 |
846723 | 846723 | 2020-12-20 | Gove | Kansas | 20063 | 325 | 20 |
843477 | 843477 | 2020-12-19 | Gove | Kansas | 20063 | 325 | 20 |
840232 | 840232 | 2020-12-18 | Gove | Kansas | 20063 | 325 | 20 |
836987 | 836987 | 2020-12-17 | Gove | Kansas | 20063 | 316 | 20 |
833741 | 833741 | 2020-12-16 | Gove | Kansas | 20063 | 316 | 20 |
830494 | 830494 | 2020-12-15 | Gove | Kansas | 20063 | 315 | 20 |
827248 | 827248 | 2020-12-14 | Gove | Kansas | 20063 | 315 | 20 |
824001 | 824001 | 2020-12-13 | Gove | Kansas | 20063 | 314 | 20 |
820755 | 820755 | 2020-12-12 | Gove | Kansas | 20063 | 314 | 20 |
817509 | 817509 | 2020-12-11 | Gove | Kansas | 20063 | 314 | 20 |
814263 | 814263 | 2020-12-10 | Gove | Kansas | 20063 | 313 | 20 |
811018 | 811018 | 2020-12-09 | Gove | Kansas | 20063 | 313 | 20 |
807773 | 807773 | 2020-12-08 | Gove | Kansas | 20063 | 312 | 20 |
804528 | 804528 | 2020-12-07 | Gove | Kansas | 20063 | 312 | 20 |
801283 | 801283 | 2020-12-06 | Gove | Kansas | 20063 | 309 | 20 |
798038 | 798038 | 2020-12-05 | Gove | Kansas | 20063 | 309 | 20 |
794793 | 794793 | 2020-12-04 | Gove | Kansas | 20063 | 309 | 20 |
791548 | 791548 | 2020-12-03 | Gove | Kansas | 20063 | 308 | 20 |
788303 | 788303 | 2020-12-02 | Gove | Kansas | 20063 | 308 | 20 |
785059 | 785059 | 2020-12-01 | Gove | Kansas | 20063 | 301 | 20 |
781814 | 781814 | 2020-11-30 | Gove | Kansas | 20063 | 301 | 20 |
778568 | 778568 | 2020-11-29 | Gove | Kansas | 20063 | 297 | 20 |
775323 | 775323 | 2020-11-28 | Gove | Kansas | 20063 | 297 | 20 |
772078 | 772078 | 2020-11-27 | Gove | Kansas | 20063 | 297 | 20 |
768833 | 768833 | 2020-11-26 | Gove | Kansas | 20063 | 294 | 20 |
765587 | 765587 | 2020-11-25 | Gove | Kansas | 20063 | 294 | 20 |
762342 | 762342 | 2020-11-24 | Gove | Kansas | 20063 | 278 | 19 |
759097 | 759097 | 2020-11-23 | Gove | Kansas | 20063 | 278 | 19 |
755850 | 755850 | 2020-11-22 | Gove | Kansas | 20063 | 272 | 19 |
752604 | 752604 | 2020-11-21 | Gove | Kansas | 20063 | 272 | 19 |
749358 | 749358 | 2020-11-20 | Gove | Kansas | 20063 | 272 | 19 |
746112 | 746112 | 2020-11-19 | Gove | Kansas | 20063 | 260 | 19 |
742865 | 742865 | 2020-11-18 | Gove | Kansas | 20063 | 260 | 19 |
739618 | 739618 | 2020-11-17 | Gove | Kansas | 20063 | 251 | 19 |
736374 | 736374 | 2020-11-16 | Gove | Kansas | 20063 | 251 | 19 |
733128 | 733128 | 2020-11-15 | Gove | Kansas | 20063 | 247 | 19 |
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);