ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20079 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054440 | 1054440 | 2021-02-22 | Harvey | Kansas | 20079 | 3375 | 57 |
1051193 | 1051193 | 2021-02-21 | Harvey | Kansas | 20079 | 3365 | 56 |
1047946 | 1047946 | 2021-02-20 | Harvey | Kansas | 20079 | 3365 | 56 |
1044701 | 1044701 | 2021-02-19 | Harvey | Kansas | 20079 | 3365 | 56 |
1041456 | 1041456 | 2021-02-18 | Harvey | Kansas | 20079 | 3346 | 56 |
1038211 | 1038211 | 2021-02-17 | Harvey | Kansas | 20079 | 3346 | 55 |
1034966 | 1034966 | 2021-02-16 | Harvey | Kansas | 20079 | 3336 | 54 |
1031720 | 1031720 | 2021-02-15 | Harvey | Kansas | 20079 | 3336 | 52 |
1028473 | 1028473 | 2021-02-14 | Harvey | Kansas | 20079 | 3323 | 52 |
1025228 | 1025228 | 2021-02-13 | Harvey | Kansas | 20079 | 3323 | 52 |
1021983 | 1021983 | 2021-02-12 | Harvey | Kansas | 20079 | 3323 | 52 |
1018738 | 1018738 | 2021-02-11 | Harvey | Kansas | 20079 | 3307 | 52 |
1015493 | 1015493 | 2021-02-10 | Harvey | Kansas | 20079 | 3307 | 51 |
1012248 | 1012248 | 2021-02-09 | Harvey | Kansas | 20079 | 3294 | 50 |
1009002 | 1009002 | 2021-02-08 | Harvey | Kansas | 20079 | 3294 | 47 |
1005756 | 1005756 | 2021-02-07 | Harvey | Kansas | 20079 | 3278 | 41 |
1002510 | 1002510 | 2021-02-06 | Harvey | Kansas | 20079 | 3278 | 41 |
999264 | 999264 | 2021-02-05 | Harvey | Kansas | 20079 | 3278 | 41 |
996018 | 996018 | 2021-02-04 | Harvey | Kansas | 20079 | 3255 | 39 |
992772 | 992772 | 2021-02-03 | Harvey | Kansas | 20079 | 3255 | 38 |
989526 | 989526 | 2021-02-02 | Harvey | Kansas | 20079 | 3244 | 38 |
986279 | 986279 | 2021-02-01 | Harvey | Kansas | 20079 | 3244 | 38 |
983032 | 983032 | 2021-01-31 | Harvey | Kansas | 20079 | 3224 | 38 |
979786 | 979786 | 2021-01-30 | Harvey | Kansas | 20079 | 3224 | 38 |
976540 | 976540 | 2021-01-29 | Harvey | Kansas | 20079 | 3224 | 38 |
973295 | 973295 | 2021-01-28 | Harvey | Kansas | 20079 | 3202 | 38 |
970050 | 970050 | 2021-01-27 | Harvey | Kansas | 20079 | 3202 | 37 |
966806 | 966806 | 2021-01-26 | Harvey | Kansas | 20079 | 3166 | 37 |
963561 | 963561 | 2021-01-25 | Harvey | Kansas | 20079 | 3166 | 37 |
960316 | 960316 | 2021-01-24 | Harvey | Kansas | 20079 | 3133 | 37 |
957070 | 957070 | 2021-01-23 | Harvey | Kansas | 20079 | 3133 | 37 |
953825 | 953825 | 2021-01-22 | Harvey | Kansas | 20079 | 3133 | 37 |
950580 | 950580 | 2021-01-21 | Harvey | Kansas | 20079 | 3269 | 37 |
947334 | 947334 | 2021-01-20 | Harvey | Kansas | 20079 | 3269 | 36 |
944087 | 944087 | 2021-01-19 | Harvey | Kansas | 20079 | 3218 | 36 |
940842 | 940842 | 2021-01-18 | Harvey | Kansas | 20079 | 3218 | 33 |
937597 | 937597 | 2021-01-17 | Harvey | Kansas | 20079 | 3170 | 33 |
934352 | 934352 | 2021-01-16 | Harvey | Kansas | 20079 | 3170 | 30 |
931107 | 931107 | 2021-01-15 | Harvey | Kansas | 20079 | 3170 | 30 |
927862 | 927862 | 2021-01-14 | Harvey | Kansas | 20079 | 3110 | 30 |
924616 | 924616 | 2021-01-13 | Harvey | Kansas | 20079 | 3110 | 30 |
921371 | 921371 | 2021-01-12 | Harvey | Kansas | 20079 | 3041 | 30 |
918126 | 918126 | 2021-01-11 | Harvey | Kansas | 20079 | 3041 | 30 |
914881 | 914881 | 2021-01-10 | Harvey | Kansas | 20079 | 2952 | 29 |
911636 | 911636 | 2021-01-09 | Harvey | Kansas | 20079 | 2952 | 29 |
908391 | 908391 | 2021-01-08 | Harvey | Kansas | 20079 | 2952 | 29 |
905145 | 905145 | 2021-01-07 | Harvey | Kansas | 20079 | 2866 | 29 |
901900 | 901900 | 2021-01-06 | Harvey | Kansas | 20079 | 2866 | 29 |
898655 | 898655 | 2021-01-05 | Harvey | Kansas | 20079 | 2765 | 29 |
895410 | 895410 | 2021-01-04 | Harvey | Kansas | 20079 | 2765 | 27 |
892163 | 892163 | 2021-01-03 | Harvey | Kansas | 20079 | 2707 | 27 |
888917 | 888917 | 2021-01-02 | Harvey | Kansas | 20079 | 2707 | 27 |
885671 | 885671 | 2021-01-01 | Harvey | Kansas | 20079 | 2707 | 27 |
882426 | 882426 | 2020-12-31 | Harvey | Kansas | 20079 | 2623 | 27 |
879181 | 879181 | 2020-12-30 | Harvey | Kansas | 20079 | 2623 | 27 |
875936 | 875936 | 2020-12-29 | Harvey | Kansas | 20079 | 2523 | 27 |
872691 | 872691 | 2020-12-28 | Harvey | Kansas | 20079 | 2523 | 27 |
869446 | 869446 | 2020-12-27 | Harvey | Kansas | 20079 | 2444 | 26 |
866201 | 866201 | 2020-12-26 | Harvey | Kansas | 20079 | 2444 | 26 |
862956 | 862956 | 2020-12-25 | Harvey | Kansas | 20079 | 2444 | 26 |
859711 | 859711 | 2020-12-24 | Harvey | Kansas | 20079 | 2444 | 26 |
856466 | 856466 | 2020-12-23 | Harvey | Kansas | 20079 | 2444 | 26 |
853221 | 853221 | 2020-12-22 | Harvey | Kansas | 20079 | 2388 | 26 |
849976 | 849976 | 2020-12-21 | Harvey | Kansas | 20079 | 2388 | 26 |
846731 | 846731 | 2020-12-20 | Harvey | Kansas | 20079 | 2316 | 23 |
843485 | 843485 | 2020-12-19 | Harvey | Kansas | 20079 | 2316 | 23 |
840240 | 840240 | 2020-12-18 | Harvey | Kansas | 20079 | 2316 | 23 |
836995 | 836995 | 2020-12-17 | Harvey | Kansas | 20079 | 2226 | 23 |
833749 | 833749 | 2020-12-16 | Harvey | Kansas | 20079 | 2226 | 22 |
830502 | 830502 | 2020-12-15 | Harvey | Kansas | 20079 | 2186 | 22 |
827256 | 827256 | 2020-12-14 | Harvey | Kansas | 20079 | 2186 | 22 |
824009 | 824009 | 2020-12-13 | Harvey | Kansas | 20079 | 2161 | 19 |
820763 | 820763 | 2020-12-12 | Harvey | Kansas | 20079 | 2161 | 19 |
817517 | 817517 | 2020-12-11 | Harvey | Kansas | 20079 | 2161 | 19 |
814271 | 814271 | 2020-12-10 | Harvey | Kansas | 20079 | 2095 | 19 |
811026 | 811026 | 2020-12-09 | Harvey | Kansas | 20079 | 2095 | 19 |
807781 | 807781 | 2020-12-08 | Harvey | Kansas | 20079 | 2047 | 18 |
804536 | 804536 | 2020-12-07 | Harvey | Kansas | 20079 | 2047 | 18 |
801291 | 801291 | 2020-12-06 | Harvey | Kansas | 20079 | 1975 | 17 |
798046 | 798046 | 2020-12-05 | Harvey | Kansas | 20079 | 1975 | 17 |
794801 | 794801 | 2020-12-04 | Harvey | Kansas | 20079 | 1975 | 17 |
791556 | 791556 | 2020-12-03 | Harvey | Kansas | 20079 | 1911 | 17 |
788311 | 788311 | 2020-12-02 | Harvey | Kansas | 20079 | 1911 | 16 |
785067 | 785067 | 2020-12-01 | Harvey | Kansas | 20079 | 1842 | 16 |
781822 | 781822 | 2020-11-30 | Harvey | Kansas | 20079 | 1842 | 15 |
778576 | 778576 | 2020-11-29 | Harvey | Kansas | 20079 | 1796 | 15 |
775331 | 775331 | 2020-11-28 | Harvey | Kansas | 20079 | 1796 | 15 |
772086 | 772086 | 2020-11-27 | Harvey | Kansas | 20079 | 1796 | 15 |
768841 | 768841 | 2020-11-26 | Harvey | Kansas | 20079 | 1730 | 15 |
765595 | 765595 | 2020-11-25 | Harvey | Kansas | 20079 | 1730 | 15 |
762350 | 762350 | 2020-11-24 | Harvey | Kansas | 20079 | 1643 | 9 |
759105 | 759105 | 2020-11-23 | Harvey | Kansas | 20079 | 1643 | 9 |
755858 | 755858 | 2020-11-22 | Harvey | Kansas | 20079 | 1553 | 9 |
752612 | 752612 | 2020-11-21 | Harvey | Kansas | 20079 | 1553 | 9 |
749366 | 749366 | 2020-11-20 | Harvey | Kansas | 20079 | 1553 | 9 |
746120 | 746120 | 2020-11-19 | Harvey | Kansas | 20079 | 1482 | 9 |
742873 | 742873 | 2020-11-18 | Harvey | Kansas | 20079 | 1482 | 9 |
739626 | 739626 | 2020-11-17 | Harvey | Kansas | 20079 | 1373 | 9 |
736382 | 736382 | 2020-11-16 | Harvey | Kansas | 20079 | 1373 | 9 |
733136 | 733136 | 2020-11-15 | Harvey | Kansas | 20079 | 1274 | 9 |
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);