ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where fips = 20179 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054490 | 1054490 | 2021-02-22 | Sheridan | Kansas | 20179 | 426 | 0 |
1051243 | 1051243 | 2021-02-21 | Sheridan | Kansas | 20179 | 426 | 0 |
1047996 | 1047996 | 2021-02-20 | Sheridan | Kansas | 20179 | 426 | 0 |
1044751 | 1044751 | 2021-02-19 | Sheridan | Kansas | 20179 | 426 | 0 |
1041506 | 1041506 | 2021-02-18 | Sheridan | Kansas | 20179 | 426 | 0 |
1038261 | 1038261 | 2021-02-17 | Sheridan | Kansas | 20179 | 426 | 0 |
1035016 | 1035016 | 2021-02-16 | Sheridan | Kansas | 20179 | 426 | 0 |
1031770 | 1031770 | 2021-02-15 | Sheridan | Kansas | 20179 | 426 | 0 |
1028523 | 1028523 | 2021-02-14 | Sheridan | Kansas | 20179 | 424 | 0 |
1025278 | 1025278 | 2021-02-13 | Sheridan | Kansas | 20179 | 424 | 0 |
1022033 | 1022033 | 2021-02-12 | Sheridan | Kansas | 20179 | 424 | 0 |
1018788 | 1018788 | 2021-02-11 | Sheridan | Kansas | 20179 | 422 | 0 |
1015543 | 1015543 | 2021-02-10 | Sheridan | Kansas | 20179 | 422 | 0 |
1012298 | 1012298 | 2021-02-09 | Sheridan | Kansas | 20179 | 422 | 0 |
1009052 | 1009052 | 2021-02-08 | Sheridan | Kansas | 20179 | 422 | 0 |
1005806 | 1005806 | 2021-02-07 | Sheridan | Kansas | 20179 | 422 | 0 |
1002560 | 1002560 | 2021-02-06 | Sheridan | Kansas | 20179 | 422 | 0 |
999314 | 999314 | 2021-02-05 | Sheridan | Kansas | 20179 | 422 | 0 |
996068 | 996068 | 2021-02-04 | Sheridan | Kansas | 20179 | 422 | 0 |
992822 | 992822 | 2021-02-03 | Sheridan | Kansas | 20179 | 422 | 0 |
989576 | 989576 | 2021-02-02 | Sheridan | Kansas | 20179 | 422 | 0 |
986329 | 986329 | 2021-02-01 | Sheridan | Kansas | 20179 | 422 | 0 |
983082 | 983082 | 2021-01-31 | Sheridan | Kansas | 20179 | 422 | 0 |
979836 | 979836 | 2021-01-30 | Sheridan | Kansas | 20179 | 422 | 0 |
976590 | 976590 | 2021-01-29 | Sheridan | Kansas | 20179 | 422 | 0 |
973345 | 973345 | 2021-01-28 | Sheridan | Kansas | 20179 | 419 | 0 |
970100 | 970100 | 2021-01-27 | Sheridan | Kansas | 20179 | 419 | 0 |
966856 | 966856 | 2021-01-26 | Sheridan | Kansas | 20179 | 419 | 0 |
963611 | 963611 | 2021-01-25 | Sheridan | Kansas | 20179 | 419 | 0 |
960366 | 960366 | 2021-01-24 | Sheridan | Kansas | 20179 | 419 | 0 |
957120 | 957120 | 2021-01-23 | Sheridan | Kansas | 20179 | 419 | 0 |
953875 | 953875 | 2021-01-22 | Sheridan | Kansas | 20179 | 419 | 0 |
950630 | 950630 | 2021-01-21 | Sheridan | Kansas | 20179 | 415 | 0 |
947384 | 947384 | 2021-01-20 | Sheridan | Kansas | 20179 | 415 | 0 |
944137 | 944137 | 2021-01-19 | Sheridan | Kansas | 20179 | 408 | 0 |
940892 | 940892 | 2021-01-18 | Sheridan | Kansas | 20179 | 408 | 0 |
937647 | 937647 | 2021-01-17 | Sheridan | Kansas | 20179 | 406 | 0 |
934402 | 934402 | 2021-01-16 | Sheridan | Kansas | 20179 | 406 | 0 |
931157 | 931157 | 2021-01-15 | Sheridan | Kansas | 20179 | 406 | 0 |
927912 | 927912 | 2021-01-14 | Sheridan | Kansas | 20179 | 405 | 0 |
924666 | 924666 | 2021-01-13 | Sheridan | Kansas | 20179 | 405 | 0 |
921421 | 921421 | 2021-01-12 | Sheridan | Kansas | 20179 | 399 | 0 |
918176 | 918176 | 2021-01-11 | Sheridan | Kansas | 20179 | 399 | 0 |
914931 | 914931 | 2021-01-10 | Sheridan | Kansas | 20179 | 394 | 0 |
911686 | 911686 | 2021-01-09 | Sheridan | Kansas | 20179 | 394 | 0 |
908441 | 908441 | 2021-01-08 | Sheridan | Kansas | 20179 | 394 | 0 |
905195 | 905195 | 2021-01-07 | Sheridan | Kansas | 20179 | 394 | 0 |
901950 | 901950 | 2021-01-06 | Sheridan | Kansas | 20179 | 394 | 0 |
898705 | 898705 | 2021-01-05 | Sheridan | Kansas | 20179 | 388 | 0 |
895460 | 895460 | 2021-01-04 | Sheridan | Kansas | 20179 | 388 | 0 |
892213 | 892213 | 2021-01-03 | Sheridan | Kansas | 20179 | 388 | 0 |
888967 | 888967 | 2021-01-02 | Sheridan | Kansas | 20179 | 388 | 0 |
885721 | 885721 | 2021-01-01 | Sheridan | Kansas | 20179 | 388 | 0 |
882476 | 882476 | 2020-12-31 | Sheridan | Kansas | 20179 | 383 | 0 |
879231 | 879231 | 2020-12-30 | Sheridan | Kansas | 20179 | 383 | 0 |
875986 | 875986 | 2020-12-29 | Sheridan | Kansas | 20179 | 376 | 0 |
872741 | 872741 | 2020-12-28 | Sheridan | Kansas | 20179 | 376 | 0 |
869496 | 869496 | 2020-12-27 | Sheridan | Kansas | 20179 | 370 | 0 |
866251 | 866251 | 2020-12-26 | Sheridan | Kansas | 20179 | 370 | 0 |
863006 | 863006 | 2020-12-25 | Sheridan | Kansas | 20179 | 370 | 0 |
859761 | 859761 | 2020-12-24 | Sheridan | Kansas | 20179 | 370 | 0 |
856516 | 856516 | 2020-12-23 | Sheridan | Kansas | 20179 | 370 | 0 |
853271 | 853271 | 2020-12-22 | Sheridan | Kansas | 20179 | 362 | 0 |
850026 | 850026 | 2020-12-21 | Sheridan | Kansas | 20179 | 362 | 0 |
846781 | 846781 | 2020-12-20 | Sheridan | Kansas | 20179 | 360 | 0 |
843535 | 843535 | 2020-12-19 | Sheridan | Kansas | 20179 | 360 | 0 |
840290 | 840290 | 2020-12-18 | Sheridan | Kansas | 20179 | 360 | 0 |
837045 | 837045 | 2020-12-17 | Sheridan | Kansas | 20179 | 352 | 0 |
833799 | 833799 | 2020-12-16 | Sheridan | Kansas | 20179 | 352 | 0 |
830552 | 830552 | 2020-12-15 | Sheridan | Kansas | 20179 | 349 | 0 |
827306 | 827306 | 2020-12-14 | Sheridan | Kansas | 20179 | 349 | 0 |
824059 | 824059 | 2020-12-13 | Sheridan | Kansas | 20179 | 349 | 0 |
820813 | 820813 | 2020-12-12 | Sheridan | Kansas | 20179 | 349 | 0 |
817567 | 817567 | 2020-12-11 | Sheridan | Kansas | 20179 | 349 | 0 |
814321 | 814321 | 2020-12-10 | Sheridan | Kansas | 20179 | 337 | 0 |
811076 | 811076 | 2020-12-09 | Sheridan | Kansas | 20179 | 337 | 0 |
807831 | 807831 | 2020-12-08 | Sheridan | Kansas | 20179 | 333 | 0 |
804586 | 804586 | 2020-12-07 | Sheridan | Kansas | 20179 | 333 | 0 |
801341 | 801341 | 2020-12-06 | Sheridan | Kansas | 20179 | 330 | 0 |
798096 | 798096 | 2020-12-05 | Sheridan | Kansas | 20179 | 330 | 0 |
794851 | 794851 | 2020-12-04 | Sheridan | Kansas | 20179 | 330 | 0 |
791606 | 791606 | 2020-12-03 | Sheridan | Kansas | 20179 | 325 | 0 |
788361 | 788361 | 2020-12-02 | Sheridan | Kansas | 20179 | 325 | 0 |
785117 | 785117 | 2020-12-01 | Sheridan | Kansas | 20179 | 320 | 0 |
781872 | 781872 | 2020-11-30 | Sheridan | Kansas | 20179 | 320 | 0 |
778626 | 778626 | 2020-11-29 | Sheridan | Kansas | 20179 | 314 | 0 |
775381 | 775381 | 2020-11-28 | Sheridan | Kansas | 20179 | 314 | 0 |
772136 | 772136 | 2020-11-27 | Sheridan | Kansas | 20179 | 314 | 0 |
768891 | 768891 | 2020-11-26 | Sheridan | Kansas | 20179 | 311 | 0 |
765645 | 765645 | 2020-11-25 | Sheridan | Kansas | 20179 | 311 | 0 |
762400 | 762400 | 2020-11-24 | Sheridan | Kansas | 20179 | 298 | 0 |
759155 | 759155 | 2020-11-23 | Sheridan | Kansas | 20179 | 298 | 0 |
755908 | 755908 | 2020-11-22 | Sheridan | Kansas | 20179 | 288 | 0 |
752662 | 752662 | 2020-11-21 | Sheridan | Kansas | 20179 | 288 | 0 |
749416 | 749416 | 2020-11-20 | Sheridan | Kansas | 20179 | 288 | 0 |
746170 | 746170 | 2020-11-19 | Sheridan | Kansas | 20179 | 283 | 0 |
742923 | 742923 | 2020-11-18 | Sheridan | Kansas | 20179 | 283 | 0 |
739676 | 739676 | 2020-11-17 | Sheridan | Kansas | 20179 | 274 | 0 |
736432 | 736432 | 2020-11-16 | Sheridan | Kansas | 20179 | 274 | 0 |
733186 | 733186 | 2020-11-15 | Sheridan | Kansas | 20179 | 268 | 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);