ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Story" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921316 | 921316 | 2021-01-12 | Story | Iowa | 19169 | 8462 | 33 |
918071 | 918071 | 2021-01-11 | Story | Iowa | 19169 | 8436 | 32 |
914826 | 914826 | 2021-01-10 | Story | Iowa | 19169 | 8398 | 32 |
911581 | 911581 | 2021-01-09 | Story | Iowa | 19169 | 8385 | 32 |
908336 | 908336 | 2021-01-08 | Story | Iowa | 19169 | 8344 | 32 |
905090 | 905090 | 2021-01-07 | Story | Iowa | 19169 | 8308 | 32 |
901845 | 901845 | 2021-01-06 | Story | Iowa | 19169 | 8256 | 32 |
898600 | 898600 | 2021-01-05 | Story | Iowa | 19169 | 8194 | 31 |
895355 | 895355 | 2021-01-04 | Story | Iowa | 19169 | 8112 | 31 |
892108 | 892108 | 2021-01-03 | Story | Iowa | 19169 | 8070 | 31 |
888862 | 888862 | 2021-01-02 | Story | Iowa | 19169 | 8048 | 31 |
885616 | 885616 | 2021-01-01 | Story | Iowa | 19169 | 8033 | 31 |
882371 | 882371 | 2020-12-31 | Story | Iowa | 19169 | 8008 | 31 |
879126 | 879126 | 2020-12-30 | Story | Iowa | 19169 | 7981 | 29 |
875881 | 875881 | 2020-12-29 | Story | Iowa | 19169 | 7940 | 29 |
872636 | 872636 | 2020-12-28 | Story | Iowa | 19169 | 7903 | 29 |
869391 | 869391 | 2020-12-27 | Story | Iowa | 19169 | 7868 | 29 |
866146 | 866146 | 2020-12-26 | Story | Iowa | 19169 | 7862 | 29 |
862901 | 862901 | 2020-12-25 | Story | Iowa | 19169 | 7856 | 29 |
859656 | 859656 | 2020-12-24 | Story | Iowa | 19169 | 7842 | 29 |
856411 | 856411 | 2020-12-23 | Story | Iowa | 19169 | 7812 | 27 |
853166 | 853166 | 2020-12-22 | Story | Iowa | 19169 | 7780 | 27 |
849921 | 849921 | 2020-12-21 | Story | Iowa | 19169 | 7755 | 26 |
846676 | 846676 | 2020-12-20 | Story | Iowa | 19169 | 7710 | 26 |
843430 | 843430 | 2020-12-19 | Story | Iowa | 19169 | 7702 | 26 |
840185 | 840185 | 2020-12-18 | Story | Iowa | 19169 | 7642 | 24 |
836940 | 836940 | 2020-12-17 | Story | Iowa | 19169 | 7568 | 24 |
833694 | 833694 | 2020-12-16 | Story | Iowa | 19169 | 7520 | 23 |
830447 | 830447 | 2020-12-15 | Story | Iowa | 19169 | 7461 | 23 |
827201 | 827201 | 2020-12-14 | Story | Iowa | 19169 | 7424 | 23 |
823954 | 823954 | 2020-12-13 | Story | Iowa | 19169 | 7416 | 22 |
820708 | 820708 | 2020-12-12 | Story | Iowa | 19169 | 7379 | 22 |
817462 | 817462 | 2020-12-11 | Story | Iowa | 19169 | 7341 | 22 |
814216 | 814216 | 2020-12-10 | Story | Iowa | 19169 | 7283 | 21 |
810971 | 810971 | 2020-12-09 | Story | Iowa | 19169 | 7239 | 19 |
807726 | 807726 | 2020-12-08 | Story | Iowa | 19169 | 7176 | 18 |
804481 | 804481 | 2020-12-07 | Story | Iowa | 19169 | 7174 | 25 |
801236 | 801236 | 2020-12-06 | Story | Iowa | 19169 | 7140 | 25 |
797991 | 797991 | 2020-12-05 | Story | Iowa | 19169 | 7116 | 25 |
794746 | 794746 | 2020-12-04 | Story | Iowa | 19169 | 7076 | 25 |
791501 | 791501 | 2020-12-03 | Story | Iowa | 19169 | 7019 | 24 |
788256 | 788256 | 2020-12-02 | Story | Iowa | 19169 | 6983 | 23 |
785012 | 785012 | 2020-12-01 | Story | Iowa | 19169 | 6892 | 22 |
781767 | 781767 | 2020-11-30 | Story | Iowa | 19169 | 6844 | 22 |
778521 | 778521 | 2020-11-29 | Story | Iowa | 19169 | 6790 | 22 |
775276 | 775276 | 2020-11-28 | Story | Iowa | 19169 | 6775 | 21 |
772031 | 772031 | 2020-11-27 | Story | Iowa | 19169 | 6749 | 21 |
768786 | 768786 | 2020-11-26 | Story | Iowa | 19169 | 6697 | 21 |
765540 | 765540 | 2020-11-25 | Story | Iowa | 19169 | 6666 | 20 |
762295 | 762295 | 2020-11-24 | Story | Iowa | 19169 | 6566 | 19 |
759050 | 759050 | 2020-11-23 | Story | Iowa | 19169 | 6476 | 19 |
755803 | 755803 | 2020-11-22 | Story | Iowa | 19169 | 6378 | 19 |
752557 | 752557 | 2020-11-21 | Story | Iowa | 19169 | 6313 | 19 |
749311 | 749311 | 2020-11-20 | Story | Iowa | 19169 | 6170 | 19 |
746065 | 746065 | 2020-11-19 | Story | Iowa | 19169 | 6025 | 19 |
742818 | 742818 | 2020-11-18 | Story | Iowa | 19169 | 5905 | 19 |
739571 | 739571 | 2020-11-17 | Story | Iowa | 19169 | 5734 | 19 |
736327 | 736327 | 2020-11-16 | Story | Iowa | 19169 | 5605 | 19 |
733081 | 733081 | 2020-11-15 | Story | Iowa | 19169 | 5517 | 18 |
729836 | 729836 | 2020-11-14 | Story | Iowa | 19169 | 5490 | 18 |
726593 | 726593 | 2020-11-13 | Story | Iowa | 19169 | 5403 | 18 |
723350 | 723350 | 2020-11-12 | Story | Iowa | 19169 | 5288 | 18 |
720107 | 720107 | 2020-11-11 | Story | Iowa | 19169 | 5180 | 18 |
716864 | 716864 | 2020-11-10 | Story | Iowa | 19169 | 5065 | 18 |
713620 | 713620 | 2020-11-09 | Story | Iowa | 19169 | 4941 | 18 |
710376 | 710376 | 2020-11-08 | Story | Iowa | 19169 | 4821 | 18 |
707132 | 707132 | 2020-11-07 | Story | Iowa | 19169 | 4761 | 18 |
703889 | 703889 | 2020-11-06 | Story | Iowa | 19169 | 4670 | 18 |
700647 | 700647 | 2020-11-05 | Story | Iowa | 19169 | 4546 | 18 |
697403 | 697403 | 2020-11-04 | Story | Iowa | 19169 | 4419 | 18 |
694161 | 694161 | 2020-11-03 | Story | Iowa | 19169 | 4359 | 18 |
690918 | 690918 | 2020-11-02 | Story | Iowa | 19169 | 4306 | 18 |
687673 | 687673 | 2020-11-01 | Story | Iowa | 19169 | 4253 | 18 |
684429 | 684429 | 2020-10-31 | Story | Iowa | 19169 | 4218 | 18 |
681186 | 681186 | 2020-10-30 | Story | Iowa | 19169 | 4170 | 18 |
677943 | 677943 | 2020-10-29 | Story | Iowa | 19169 | 4118 | 18 |
674700 | 674700 | 2020-10-28 | Story | Iowa | 19169 | 4083 | 18 |
671458 | 671458 | 2020-10-27 | Story | Iowa | 19169 | 4044 | 18 |
668215 | 668215 | 2020-10-26 | Story | Iowa | 19169 | 4010 | 18 |
664971 | 664971 | 2020-10-25 | Story | Iowa | 19169 | 3989 | 18 |
661726 | 661726 | 2020-10-24 | Story | Iowa | 19169 | 3977 | 18 |
658482 | 658482 | 2020-10-23 | Story | Iowa | 19169 | 3951 | 18 |
655237 | 655237 | 2020-10-22 | Story | Iowa | 19169 | 3915 | 18 |
651992 | 651992 | 2020-10-21 | Story | Iowa | 19169 | 3902 | 18 |
648748 | 648748 | 2020-10-20 | Story | Iowa | 19169 | 3875 | 18 |
645503 | 645503 | 2020-10-19 | Story | Iowa | 19169 | 3854 | 17 |
642256 | 642256 | 2020-10-18 | Story | Iowa | 19169 | 3832 | 17 |
639009 | 639009 | 2020-10-17 | Story | Iowa | 19169 | 3825 | 17 |
635763 | 635763 | 2020-10-16 | Story | Iowa | 19169 | 3817 | 17 |
632517 | 632517 | 2020-10-15 | Story | Iowa | 19169 | 3778 | 17 |
629273 | 629273 | 2020-10-14 | Story | Iowa | 19169 | 3760 | 17 |
626030 | 626030 | 2020-10-13 | Story | Iowa | 19169 | 3737 | 17 |
622788 | 622788 | 2020-10-12 | Story | Iowa | 19169 | 3725 | 17 |
619544 | 619544 | 2020-10-11 | Story | Iowa | 19169 | 3712 | 17 |
616302 | 616302 | 2020-10-10 | Story | Iowa | 19169 | 3703 | 17 |
613061 | 613061 | 2020-10-09 | Story | Iowa | 19169 | 3673 | 17 |
609819 | 609819 | 2020-10-08 | Story | Iowa | 19169 | 3656 | 17 |
606576 | 606576 | 2020-10-07 | Story | Iowa | 19169 | 3631 | 17 |
603334 | 603334 | 2020-10-06 | Story | Iowa | 19169 | 3595 | 17 |
600091 | 600091 | 2020-10-05 | Story | Iowa | 19169 | 3576 | 17 |
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);