ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Ford" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947323 | 947323 | 2021-01-20 | Ford | Kansas | 20057 | 5413 | 10 |
944076 | 944076 | 2021-01-19 | Ford | Kansas | 20057 | 5396 | 10 |
940831 | 940831 | 2021-01-18 | Ford | Kansas | 20057 | 5396 | 10 |
937586 | 937586 | 2021-01-17 | Ford | Kansas | 20057 | 5381 | 10 |
934341 | 934341 | 2021-01-16 | Ford | Kansas | 20057 | 5381 | 10 |
931096 | 931096 | 2021-01-15 | Ford | Kansas | 20057 | 5381 | 10 |
927851 | 927851 | 2021-01-14 | Ford | Kansas | 20057 | 5357 | 10 |
924605 | 924605 | 2021-01-13 | Ford | Kansas | 20057 | 5357 | 10 |
921360 | 921360 | 2021-01-12 | Ford | Kansas | 20057 | 5337 | 10 |
918115 | 918115 | 2021-01-11 | Ford | Kansas | 20057 | 5337 | 10 |
914870 | 914870 | 2021-01-10 | Ford | Kansas | 20057 | 5304 | 10 |
911625 | 911625 | 2021-01-09 | Ford | Kansas | 20057 | 5304 | 10 |
908380 | 908380 | 2021-01-08 | Ford | Kansas | 20057 | 5304 | 10 |
905134 | 905134 | 2021-01-07 | Ford | Kansas | 20057 | 5262 | 10 |
901889 | 901889 | 2021-01-06 | Ford | Kansas | 20057 | 5262 | 10 |
898644 | 898644 | 2021-01-05 | Ford | Kansas | 20057 | 5206 | 10 |
895399 | 895399 | 2021-01-04 | Ford | Kansas | 20057 | 5206 | 10 |
892152 | 892152 | 2021-01-03 | Ford | Kansas | 20057 | 5182 | 10 |
888906 | 888906 | 2021-01-02 | Ford | Kansas | 20057 | 5182 | 10 |
885660 | 885660 | 2021-01-01 | Ford | Kansas | 20057 | 5182 | 10 |
882415 | 882415 | 2020-12-31 | Ford | Kansas | 20057 | 5138 | 10 |
879170 | 879170 | 2020-12-30 | Ford | Kansas | 20057 | 5138 | 10 |
875925 | 875925 | 2020-12-29 | Ford | Kansas | 20057 | 5089 | 10 |
872680 | 872680 | 2020-12-28 | Ford | Kansas | 20057 | 5089 | 10 |
869435 | 869435 | 2020-12-27 | Ford | Kansas | 20057 | 5039 | 10 |
866190 | 866190 | 2020-12-26 | Ford | Kansas | 20057 | 5039 | 10 |
862945 | 862945 | 2020-12-25 | Ford | Kansas | 20057 | 5039 | 10 |
859700 | 859700 | 2020-12-24 | Ford | Kansas | 20057 | 5039 | 10 |
856455 | 856455 | 2020-12-23 | Ford | Kansas | 20057 | 5039 | 10 |
853210 | 853210 | 2020-12-22 | Ford | Kansas | 20057 | 5011 | 10 |
849965 | 849965 | 2020-12-21 | Ford | Kansas | 20057 | 5011 | 10 |
846720 | 846720 | 2020-12-20 | Ford | Kansas | 20057 | 4989 | 10 |
843474 | 843474 | 2020-12-19 | Ford | Kansas | 20057 | 4989 | 10 |
840229 | 840229 | 2020-12-18 | Ford | Kansas | 20057 | 4989 | 10 |
836984 | 836984 | 2020-12-17 | Ford | Kansas | 20057 | 4948 | 10 |
833738 | 833738 | 2020-12-16 | Ford | Kansas | 20057 | 4948 | 10 |
830491 | 830491 | 2020-12-15 | Ford | Kansas | 20057 | 4914 | 10 |
827245 | 827245 | 2020-12-14 | Ford | Kansas | 20057 | 4914 | 10 |
823998 | 823998 | 2020-12-13 | Ford | Kansas | 20057 | 4894 | 10 |
820752 | 820752 | 2020-12-12 | Ford | Kansas | 20057 | 4894 | 10 |
817506 | 817506 | 2020-12-11 | Ford | Kansas | 20057 | 4894 | 10 |
814260 | 814260 | 2020-12-10 | Ford | Kansas | 20057 | 4864 | 10 |
811015 | 811015 | 2020-12-09 | Ford | Kansas | 20057 | 4864 | 10 |
807770 | 807770 | 2020-12-08 | Ford | Kansas | 20057 | 4807 | 10 |
804525 | 804525 | 2020-12-07 | Ford | Kansas | 20057 | 4807 | 10 |
801280 | 801280 | 2020-12-06 | Ford | Kansas | 20057 | 4747 | 10 |
798035 | 798035 | 2020-12-05 | Ford | Kansas | 20057 | 4747 | 10 |
794790 | 794790 | 2020-12-04 | Ford | Kansas | 20057 | 4747 | 10 |
791545 | 791545 | 2020-12-03 | Ford | Kansas | 20057 | 4693 | 10 |
788300 | 788300 | 2020-12-02 | Ford | Kansas | 20057 | 4693 | 10 |
785056 | 785056 | 2020-12-01 | Ford | Kansas | 20057 | 4650 | 10 |
781811 | 781811 | 2020-11-30 | Ford | Kansas | 20057 | 4650 | 10 |
778565 | 778565 | 2020-11-29 | Ford | Kansas | 20057 | 4598 | 10 |
775320 | 775320 | 2020-11-28 | Ford | Kansas | 20057 | 4598 | 10 |
772075 | 772075 | 2020-11-27 | Ford | Kansas | 20057 | 4598 | 10 |
768830 | 768830 | 2020-11-26 | Ford | Kansas | 20057 | 4552 | 10 |
765584 | 765584 | 2020-11-25 | Ford | Kansas | 20057 | 4552 | 10 |
762339 | 762339 | 2020-11-24 | Ford | Kansas | 20057 | 4496 | 10 |
759094 | 759094 | 2020-11-23 | Ford | Kansas | 20057 | 4496 | 10 |
755847 | 755847 | 2020-11-22 | Ford | Kansas | 20057 | 4421 | 10 |
752601 | 752601 | 2020-11-21 | Ford | Kansas | 20057 | 4421 | 10 |
749355 | 749355 | 2020-11-20 | Ford | Kansas | 20057 | 4421 | 10 |
746109 | 746109 | 2020-11-19 | Ford | Kansas | 20057 | 4336 | 10 |
742862 | 742862 | 2020-11-18 | Ford | Kansas | 20057 | 4336 | 10 |
739615 | 739615 | 2020-11-17 | Ford | Kansas | 20057 | 4225 | 10 |
736371 | 736371 | 2020-11-16 | Ford | Kansas | 20057 | 4225 | 10 |
733125 | 733125 | 2020-11-15 | Ford | Kansas | 20057 | 4128 | 10 |
729880 | 729880 | 2020-11-14 | Ford | Kansas | 20057 | 4128 | 10 |
726637 | 726637 | 2020-11-13 | Ford | Kansas | 20057 | 4128 | 10 |
723394 | 723394 | 2020-11-12 | Ford | Kansas | 20057 | 4022 | 10 |
720151 | 720151 | 2020-11-11 | Ford | Kansas | 20057 | 4022 | 10 |
716908 | 716908 | 2020-11-10 | Ford | Kansas | 20057 | 3915 | 10 |
713664 | 713664 | 2020-11-09 | Ford | Kansas | 20057 | 3915 | 10 |
710420 | 710420 | 2020-11-08 | Ford | Kansas | 20057 | 3781 | 10 |
707176 | 707176 | 2020-11-07 | Ford | Kansas | 20057 | 3781 | 10 |
703933 | 703933 | 2020-11-06 | Ford | Kansas | 20057 | 3781 | 10 |
700691 | 700691 | 2020-11-05 | Ford | Kansas | 20057 | 3635 | 10 |
697447 | 697447 | 2020-11-04 | Ford | Kansas | 20057 | 3635 | 10 |
694205 | 694205 | 2020-11-03 | Ford | Kansas | 20057 | 3548 | 10 |
690962 | 690962 | 2020-11-02 | Ford | Kansas | 20057 | 3548 | 10 |
687717 | 687717 | 2020-11-01 | Ford | Kansas | 20057 | 3491 | 10 |
684473 | 684473 | 2020-10-31 | Ford | Kansas | 20057 | 3491 | 10 |
681230 | 681230 | 2020-10-30 | Ford | Kansas | 20057 | 3491 | 10 |
677987 | 677987 | 2020-10-29 | Ford | Kansas | 20057 | 3448 | 10 |
674744 | 674744 | 2020-10-28 | Ford | Kansas | 20057 | 3448 | 10 |
671502 | 671502 | 2020-10-27 | Ford | Kansas | 20057 | 3371 | 10 |
668259 | 668259 | 2020-10-26 | Ford | Kansas | 20057 | 3371 | 10 |
665015 | 665015 | 2020-10-25 | Ford | Kansas | 20057 | 3343 | 10 |
661770 | 661770 | 2020-10-24 | Ford | Kansas | 20057 | 3343 | 10 |
658526 | 658526 | 2020-10-23 | Ford | Kansas | 20057 | 3343 | 10 |
655281 | 655281 | 2020-10-22 | Ford | Kansas | 20057 | 3313 | 10 |
652036 | 652036 | 2020-10-21 | Ford | Kansas | 20057 | 3313 | 10 |
648792 | 648792 | 2020-10-20 | Ford | Kansas | 20057 | 3268 | 10 |
645547 | 645547 | 2020-10-19 | Ford | Kansas | 20057 | 3268 | 10 |
642300 | 642300 | 2020-10-18 | Ford | Kansas | 20057 | 3240 | 10 |
639053 | 639053 | 2020-10-17 | Ford | Kansas | 20057 | 3240 | 10 |
635807 | 635807 | 2020-10-16 | Ford | Kansas | 20057 | 3240 | 10 |
632561 | 632561 | 2020-10-15 | Ford | Kansas | 20057 | 3203 | 10 |
629317 | 629317 | 2020-10-14 | Ford | Kansas | 20057 | 3203 | 10 |
626074 | 626074 | 2020-10-13 | Ford | Kansas | 20057 | 3174 | 10 |
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);