ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Johnson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054446 | 1054446 | 2021-02-22 | Johnson | Kansas | 20091 | 53708 | 633 |
1051199 | 1051199 | 2021-02-21 | Johnson | Kansas | 20091 | 53652 | 632 |
1047952 | 1047952 | 2021-02-20 | Johnson | Kansas | 20091 | 53652 | 632 |
1044707 | 1044707 | 2021-02-19 | Johnson | Kansas | 20091 | 53652 | 627 |
1041462 | 1041462 | 2021-02-18 | Johnson | Kansas | 20091 | 52582 | 624 |
1038217 | 1038217 | 2021-02-17 | Johnson | Kansas | 20091 | 52582 | 619 |
1034972 | 1034972 | 2021-02-16 | Johnson | Kansas | 20091 | 52199 | 613 |
1031726 | 1031726 | 2021-02-15 | Johnson | Kansas | 20091 | 52199 | 613 |
1028479 | 1028479 | 2021-02-14 | Johnson | Kansas | 20091 | 51871 | 613 |
1025234 | 1025234 | 2021-02-13 | Johnson | Kansas | 20091 | 51871 | 613 |
1021989 | 1021989 | 2021-02-12 | Johnson | Kansas | 20091 | 51871 | 604 |
1018744 | 1018744 | 2021-02-11 | Johnson | Kansas | 20091 | 51608 | 604 |
1015499 | 1015499 | 2021-02-10 | Johnson | Kansas | 20091 | 51608 | 600 |
1012254 | 1012254 | 2021-02-09 | Johnson | Kansas | 20091 | 51150 | 598 |
1009008 | 1009008 | 2021-02-08 | Johnson | Kansas | 20091 | 51150 | 596 |
1005762 | 1005762 | 2021-02-07 | Johnson | Kansas | 20091 | 50922 | 594 |
1002516 | 1002516 | 2021-02-06 | Johnson | Kansas | 20091 | 50922 | 594 |
999270 | 999270 | 2021-02-05 | Johnson | Kansas | 20091 | 50922 | 590 |
996024 | 996024 | 2021-02-04 | Johnson | Kansas | 20091 | 50392 | 583 |
992778 | 992778 | 2021-02-03 | Johnson | Kansas | 20091 | 50392 | 580 |
989532 | 989532 | 2021-02-02 | Johnson | Kansas | 20091 | 50030 | 577 |
986285 | 986285 | 2021-02-01 | Johnson | Kansas | 20091 | 50030 | 573 |
983038 | 983038 | 2021-01-31 | Johnson | Kansas | 20091 | 49641 | 571 |
979792 | 979792 | 2021-01-30 | Johnson | Kansas | 20091 | 49641 | 569 |
976546 | 976546 | 2021-01-29 | Johnson | Kansas | 20091 | 49641 | 567 |
973301 | 973301 | 2021-01-28 | Johnson | Kansas | 20091 | 49248 | 564 |
970056 | 970056 | 2021-01-27 | Johnson | Kansas | 20091 | 49248 | 561 |
966812 | 966812 | 2021-01-26 | Johnson | Kansas | 20091 | 48309 | 559 |
963567 | 963567 | 2021-01-25 | Johnson | Kansas | 20091 | 48309 | 551 |
960322 | 960322 | 2021-01-24 | Johnson | Kansas | 20091 | 47897 | 551 |
957076 | 957076 | 2021-01-23 | Johnson | Kansas | 20091 | 47897 | 549 |
953831 | 953831 | 2021-01-22 | Johnson | Kansas | 20091 | 47897 | 543 |
950586 | 950586 | 2021-01-21 | Johnson | Kansas | 20091 | 47051 | 542 |
947340 | 947340 | 2021-01-20 | Johnson | Kansas | 20091 | 47051 | 540 |
944093 | 944093 | 2021-01-19 | Johnson | Kansas | 20091 | 46009 | 532 |
940848 | 940848 | 2021-01-18 | Johnson | Kansas | 20091 | 46009 | 533 |
937603 | 937603 | 2021-01-17 | Johnson | Kansas | 20091 | 44973 | 533 |
934358 | 934358 | 2021-01-16 | Johnson | Kansas | 20091 | 44973 | 533 |
931113 | 931113 | 2021-01-15 | Johnson | Kansas | 20091 | 44973 | 530 |
927868 | 927868 | 2021-01-14 | Johnson | Kansas | 20091 | 44346 | 524 |
924622 | 924622 | 2021-01-13 | Johnson | Kansas | 20091 | 44346 | 519 |
921377 | 921377 | 2021-01-12 | Johnson | Kansas | 20091 | 43450 | 509 |
918132 | 918132 | 2021-01-11 | Johnson | Kansas | 20091 | 43450 | 502 |
914887 | 914887 | 2021-01-10 | Johnson | Kansas | 20091 | 42456 | 501 |
911642 | 911642 | 2021-01-09 | Johnson | Kansas | 20091 | 42456 | 499 |
908397 | 908397 | 2021-01-08 | Johnson | Kansas | 20091 | 42456 | 492 |
905151 | 905151 | 2021-01-07 | Johnson | Kansas | 20091 | 41357 | 487 |
901906 | 901906 | 2021-01-06 | Johnson | Kansas | 20091 | 41357 | 478 |
898661 | 898661 | 2021-01-05 | Johnson | Kansas | 20091 | 40379 | 469 |
895416 | 895416 | 2021-01-04 | Johnson | Kansas | 20091 | 40379 | 456 |
892169 | 892169 | 2021-01-03 | Johnson | Kansas | 20091 | 39696 | 455 |
888923 | 888923 | 2021-01-02 | Johnson | Kansas | 20091 | 39696 | 455 |
885677 | 885677 | 2021-01-01 | Johnson | Kansas | 20091 | 39696 | 454 |
882432 | 882432 | 2020-12-31 | Johnson | Kansas | 20091 | 38865 | 452 |
879187 | 879187 | 2020-12-30 | Johnson | Kansas | 20091 | 38865 | 447 |
875942 | 875942 | 2020-12-29 | Johnson | Kansas | 20091 | 37875 | 435 |
872697 | 872697 | 2020-12-28 | Johnson | Kansas | 20091 | 37875 | 418 |
869452 | 869452 | 2020-12-27 | Johnson | Kansas | 20091 | 36727 | 413 |
866207 | 866207 | 2020-12-26 | Johnson | Kansas | 20091 | 36727 | 413 |
862962 | 862962 | 2020-12-25 | Johnson | Kansas | 20091 | 36727 | 413 |
859717 | 859717 | 2020-12-24 | Johnson | Kansas | 20091 | 36727 | 413 |
856472 | 856472 | 2020-12-23 | Johnson | Kansas | 20091 | 36727 | 410 |
853227 | 853227 | 2020-12-22 | Johnson | Kansas | 20091 | 35973 | 401 |
849982 | 849982 | 2020-12-21 | Johnson | Kansas | 20091 | 35973 | 390 |
846737 | 846737 | 2020-12-20 | Johnson | Kansas | 20091 | 35086 | 385 |
843491 | 843491 | 2020-12-19 | Johnson | Kansas | 20091 | 35086 | 385 |
840246 | 840246 | 2020-12-18 | Johnson | Kansas | 20091 | 35086 | 383 |
837001 | 837001 | 2020-12-17 | Johnson | Kansas | 20091 | 33964 | 381 |
833755 | 833755 | 2020-12-16 | Johnson | Kansas | 20091 | 33964 | 371 |
830508 | 830508 | 2020-12-15 | Johnson | Kansas | 20091 | 33144 | 357 |
827262 | 827262 | 2020-12-14 | Johnson | Kansas | 20091 | 33144 | 346 |
824015 | 824015 | 2020-12-13 | Johnson | Kansas | 20091 | 32163 | 339 |
820769 | 820769 | 2020-12-12 | Johnson | Kansas | 20091 | 32163 | 339 |
817523 | 817523 | 2020-12-11 | Johnson | Kansas | 20091 | 32163 | 338 |
814277 | 814277 | 2020-12-10 | Johnson | Kansas | 20091 | 31155 | 327 |
811032 | 811032 | 2020-12-09 | Johnson | Kansas | 20091 | 31155 | 321 |
807787 | 807787 | 2020-12-08 | Johnson | Kansas | 20091 | 30199 | 312 |
804542 | 804542 | 2020-12-07 | Johnson | Kansas | 20091 | 30199 | 309 |
801297 | 801297 | 2020-12-06 | Johnson | Kansas | 20091 | 29272 | 309 |
798052 | 798052 | 2020-12-05 | Johnson | Kansas | 20091 | 29272 | 304 |
794807 | 794807 | 2020-12-04 | Johnson | Kansas | 20091 | 29272 | 299 |
791562 | 791562 | 2020-12-03 | Johnson | Kansas | 20091 | 28078 | 294 |
788317 | 788317 | 2020-12-02 | Johnson | Kansas | 20091 | 28078 | 293 |
785073 | 785073 | 2020-12-01 | Johnson | Kansas | 20091 | 27420 | 289 |
781828 | 781828 | 2020-11-30 | Johnson | Kansas | 20091 | 27420 | 285 |
778582 | 778582 | 2020-11-29 | Johnson | Kansas | 20091 | 26731 | 285 |
775337 | 775337 | 2020-11-28 | Johnson | Kansas | 20091 | 26731 | 285 |
772092 | 772092 | 2020-11-27 | Johnson | Kansas | 20091 | 26731 | 285 |
768847 | 768847 | 2020-11-26 | Johnson | Kansas | 20091 | 25931 | 285 |
765601 | 765601 | 2020-11-25 | Johnson | Kansas | 20091 | 25931 | 284 |
762356 | 762356 | 2020-11-24 | Johnson | Kansas | 20091 | 25025 | 283 |
759111 | 759111 | 2020-11-23 | Johnson | Kansas | 20091 | 25025 | 274 |
755864 | 755864 | 2020-11-22 | Johnson | Kansas | 20091 | 23891 | 271 |
752618 | 752618 | 2020-11-21 | Johnson | Kansas | 20091 | 23891 | 271 |
749372 | 749372 | 2020-11-20 | Johnson | Kansas | 20091 | 23891 | 266 |
746126 | 746126 | 2020-11-19 | Johnson | Kansas | 20091 | 22826 | 260 |
742879 | 742879 | 2020-11-18 | Johnson | Kansas | 20091 | 22826 | 252 |
739632 | 739632 | 2020-11-17 | Johnson | Kansas | 20091 | 21981 | 253 |
736388 | 736388 | 2020-11-16 | Johnson | Kansas | 20091 | 21981 | 248 |
733142 | 733142 | 2020-11-15 | Johnson | Kansas | 20091 | 20946 | 244 |
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);