ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Polk", fips = 29167 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
912284 | 912284 | 2021-01-09 | Polk | Missouri | 29167 | 2789 | 36 |
909039 | 909039 | 2021-01-08 | Polk | Missouri | 29167 | 2789 | 36 |
905793 | 905793 | 2021-01-07 | Polk | Missouri | 29167 | 2754 | 36 |
902548 | 902548 | 2021-01-06 | Polk | Missouri | 29167 | 2716 | 36 |
899303 | 899303 | 2021-01-05 | Polk | Missouri | 29167 | 2685 | 36 |
896058 | 896058 | 2021-01-04 | Polk | Missouri | 29167 | 2642 | 36 |
892811 | 892811 | 2021-01-03 | Polk | Missouri | 29167 | 2576 | 36 |
889565 | 889565 | 2021-01-02 | Polk | Missouri | 29167 | 2576 | 36 |
886319 | 886319 | 2021-01-01 | Polk | Missouri | 29167 | 2576 | 36 |
883074 | 883074 | 2020-12-31 | Polk | Missouri | 29167 | 2576 | 36 |
879829 | 879829 | 2020-12-30 | Polk | Missouri | 29167 | 2505 | 36 |
876584 | 876584 | 2020-12-29 | Polk | Missouri | 29167 | 2483 | 36 |
873339 | 873339 | 2020-12-28 | Polk | Missouri | 29167 | 2450 | 36 |
870094 | 870094 | 2020-12-27 | Polk | Missouri | 29167 | 2377 | 36 |
866849 | 866849 | 2020-12-26 | Polk | Missouri | 29167 | 2377 | 36 |
863604 | 863604 | 2020-12-25 | Polk | Missouri | 29167 | 2377 | 36 |
860359 | 860359 | 2020-12-24 | Polk | Missouri | 29167 | 2377 | 36 |
857114 | 857114 | 2020-12-23 | Polk | Missouri | 29167 | 2377 | 36 |
853869 | 853869 | 2020-12-22 | Polk | Missouri | 29167 | 2361 | 36 |
850624 | 850624 | 2020-12-21 | Polk | Missouri | 29167 | 2332 | 36 |
847379 | 847379 | 2020-12-20 | Polk | Missouri | 29167 | 2281 | 36 |
844133 | 844133 | 2020-12-19 | Polk | Missouri | 29167 | 2281 | 36 |
840888 | 840888 | 2020-12-18 | Polk | Missouri | 29167 | 2281 | 36 |
837643 | 837643 | 2020-12-17 | Polk | Missouri | 29167 | 2262 | 34 |
834397 | 834397 | 2020-12-16 | Polk | Missouri | 29167 | 2231 | 34 |
831150 | 831150 | 2020-12-15 | Polk | Missouri | 29167 | 2206 | 34 |
827904 | 827904 | 2020-12-14 | Polk | Missouri | 29167 | 2163 | 34 |
824657 | 824657 | 2020-12-13 | Polk | Missouri | 29167 | 2125 | 34 |
821411 | 821411 | 2020-12-12 | Polk | Missouri | 29167 | 2125 | 34 |
818165 | 818165 | 2020-12-11 | Polk | Missouri | 29167 | 2100 | 34 |
814919 | 814919 | 2020-12-10 | Polk | Missouri | 29167 | 2100 | 34 |
811674 | 811674 | 2020-12-09 | Polk | Missouri | 29167 | 2080 | 34 |
808429 | 808429 | 2020-12-08 | Polk | Missouri | 29167 | 2058 | 34 |
805184 | 805184 | 2020-12-07 | Polk | Missouri | 29167 | 2014 | 34 |
801939 | 801939 | 2020-12-06 | Polk | Missouri | 29167 | 1959 | 34 |
798694 | 798694 | 2020-12-05 | Polk | Missouri | 29167 | 1959 | 34 |
795449 | 795449 | 2020-12-04 | Polk | Missouri | 29167 | 1959 | 34 |
792204 | 792204 | 2020-12-03 | Polk | Missouri | 29167 | 1903 | 34 |
788959 | 788959 | 2020-12-02 | Polk | Missouri | 29167 | 1888 | 32 |
785714 | 785714 | 2020-12-01 | Polk | Missouri | 29167 | 1871 | 32 |
782470 | 782470 | 2020-11-30 | Polk | Missouri | 29167 | 1842 | 29 |
779224 | 779224 | 2020-11-29 | Polk | Missouri | 29167 | 1729 | 23 |
775979 | 775979 | 2020-11-28 | Polk | Missouri | 29167 | 1729 | 23 |
772734 | 772734 | 2020-11-27 | Polk | Missouri | 29167 | 1729 | 23 |
769489 | 769489 | 2020-11-26 | Polk | Missouri | 29167 | 1729 | 23 |
766243 | 766243 | 2020-11-25 | Polk | Missouri | 29167 | 1729 | 23 |
762998 | 762998 | 2020-11-24 | Polk | Missouri | 29167 | 1694 | 23 |
759753 | 759753 | 2020-11-23 | Polk | Missouri | 29167 | 1672 | 23 |
756506 | 756506 | 2020-11-22 | Polk | Missouri | 29167 | 1622 | 22 |
753260 | 753260 | 2020-11-21 | Polk | Missouri | 29167 | 1622 | 22 |
750014 | 750014 | 2020-11-20 | Polk | Missouri | 29167 | 1622 | 22 |
746768 | 746768 | 2020-11-19 | Polk | Missouri | 29167 | 1608 | 22 |
743521 | 743521 | 2020-11-18 | Polk | Missouri | 29167 | 1595 | 21 |
740274 | 740274 | 2020-11-17 | Polk | Missouri | 29167 | 1575 | 21 |
737030 | 737030 | 2020-11-16 | Polk | Missouri | 29167 | 1545 | 21 |
733784 | 733784 | 2020-11-15 | Polk | Missouri | 29167 | 1457 | 19 |
730539 | 730539 | 2020-11-14 | Polk | Missouri | 29167 | 1457 | 19 |
727296 | 727296 | 2020-11-13 | Polk | Missouri | 29167 | 1457 | 19 |
724053 | 724053 | 2020-11-12 | Polk | Missouri | 29167 | 1457 | 19 |
720810 | 720810 | 2020-11-11 | Polk | Missouri | 29167 | 1415 | 19 |
717567 | 717567 | 2020-11-10 | Polk | Missouri | 29167 | 1415 | 19 |
714323 | 714323 | 2020-11-09 | Polk | Missouri | 29167 | 1386 | 19 |
711079 | 711079 | 2020-11-08 | Polk | Missouri | 29167 | 1335 | 19 |
707835 | 707835 | 2020-11-07 | Polk | Missouri | 29167 | 1335 | 19 |
704592 | 704592 | 2020-11-06 | Polk | Missouri | 29167 | 1335 | 19 |
701350 | 701350 | 2020-11-05 | Polk | Missouri | 29167 | 1315 | 19 |
698106 | 698106 | 2020-11-04 | Polk | Missouri | 29167 | 1297 | 19 |
694863 | 694863 | 2020-11-03 | Polk | Missouri | 29167 | 1284 | 19 |
691621 | 691621 | 2020-11-02 | Polk | Missouri | 29167 | 1265 | 19 |
688376 | 688376 | 2020-11-01 | Polk | Missouri | 29167 | 1232 | 19 |
685132 | 685132 | 2020-10-31 | Polk | Missouri | 29167 | 1232 | 19 |
681889 | 681889 | 2020-10-30 | Polk | Missouri | 29167 | 1232 | 19 |
678645 | 678645 | 2020-10-29 | Polk | Missouri | 29167 | 1217 | 19 |
675403 | 675403 | 2020-10-28 | Polk | Missouri | 29167 | 1203 | 19 |
672160 | 672160 | 2020-10-27 | Polk | Missouri | 29167 | 1184 | 19 |
668918 | 668918 | 2020-10-26 | Polk | Missouri | 29167 | 1178 | 19 |
665674 | 665674 | 2020-10-25 | Polk | Missouri | 29167 | 1140 | 19 |
662429 | 662429 | 2020-10-24 | Polk | Missouri | 29167 | 1140 | 19 |
659185 | 659185 | 2020-10-23 | Polk | Missouri | 29167 | 1140 | 19 |
655940 | 655940 | 2020-10-22 | Polk | Missouri | 29167 | 1130 | 19 |
652695 | 652695 | 2020-10-21 | Polk | Missouri | 29167 | 1119 | 19 |
649450 | 649450 | 2020-10-20 | Polk | Missouri | 29167 | 1106 | 19 |
646206 | 646206 | 2020-10-19 | Polk | Missouri | 29167 | 1079 | 19 |
642960 | 642960 | 2020-10-18 | Polk | Missouri | 29167 | 1039 | 19 |
639712 | 639712 | 2020-10-17 | Polk | Missouri | 29167 | 1039 | 19 |
636466 | 636466 | 2020-10-16 | Polk | Missouri | 29167 | 1039 | 19 |
633220 | 633220 | 2020-10-15 | Polk | Missouri | 29167 | 1008 | 19 |
629975 | 629975 | 2020-10-14 | Polk | Missouri | 29167 | 995 | 19 |
626731 | 626731 | 2020-10-13 | Polk | Missouri | 29167 | 973 | 19 |
623489 | 623489 | 2020-10-12 | Polk | Missouri | 29167 | 913 | 18 |
620246 | 620246 | 2020-10-11 | Polk | Missouri | 29167 | 913 | 18 |
617004 | 617004 | 2020-10-10 | Polk | Missouri | 29167 | 913 | 18 |
613763 | 613763 | 2020-10-09 | Polk | Missouri | 29167 | 913 | 18 |
610521 | 610521 | 2020-10-08 | Polk | Missouri | 29167 | 893 | 17 |
607279 | 607279 | 2020-10-07 | Polk | Missouri | 29167 | 874 | 17 |
604036 | 604036 | 2020-10-06 | Polk | Missouri | 29167 | 863 | 9 |
600794 | 600794 | 2020-10-05 | Polk | Missouri | 29167 | 850 | 9 |
597551 | 597551 | 2020-10-04 | Polk | Missouri | 29167 | 819 | 9 |
594310 | 594310 | 2020-10-03 | Polk | Missouri | 29167 | 819 | 9 |
591069 | 591069 | 2020-10-02 | Polk | Missouri | 29167 | 819 | 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);