ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Marion" and fips = 19125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921294 | 921294 | 2021-01-12 | Marion | Iowa | 19125 | 2951 | 52 |
918049 | 918049 | 2021-01-11 | Marion | Iowa | 19125 | 2934 | 51 |
914804 | 914804 | 2021-01-10 | Marion | Iowa | 19125 | 2912 | 51 |
911559 | 911559 | 2021-01-09 | Marion | Iowa | 19125 | 2907 | 51 |
908314 | 908314 | 2021-01-08 | Marion | Iowa | 19125 | 2898 | 51 |
905068 | 905068 | 2021-01-07 | Marion | Iowa | 19125 | 2887 | 50 |
901823 | 901823 | 2021-01-06 | Marion | Iowa | 19125 | 2858 | 50 |
898578 | 898578 | 2021-01-05 | Marion | Iowa | 19125 | 2829 | 49 |
895333 | 895333 | 2021-01-04 | Marion | Iowa | 19125 | 2773 | 49 |
892086 | 892086 | 2021-01-03 | Marion | Iowa | 19125 | 2741 | 49 |
888840 | 888840 | 2021-01-02 | Marion | Iowa | 19125 | 2730 | 49 |
885594 | 885594 | 2021-01-01 | Marion | Iowa | 19125 | 2716 | 47 |
882349 | 882349 | 2020-12-31 | Marion | Iowa | 19125 | 2713 | 47 |
879104 | 879104 | 2020-12-30 | Marion | Iowa | 19125 | 2701 | 47 |
875859 | 875859 | 2020-12-29 | Marion | Iowa | 19125 | 2674 | 47 |
872614 | 872614 | 2020-12-28 | Marion | Iowa | 19125 | 2654 | 46 |
869369 | 869369 | 2020-12-27 | Marion | Iowa | 19125 | 2623 | 46 |
866124 | 866124 | 2020-12-26 | Marion | Iowa | 19125 | 2617 | 46 |
862879 | 862879 | 2020-12-25 | Marion | Iowa | 19125 | 2603 | 46 |
859634 | 859634 | 2020-12-24 | Marion | Iowa | 19125 | 2596 | 46 |
856389 | 856389 | 2020-12-23 | Marion | Iowa | 19125 | 2582 | 40 |
853144 | 853144 | 2020-12-22 | Marion | Iowa | 19125 | 2554 | 40 |
849899 | 849899 | 2020-12-21 | Marion | Iowa | 19125 | 2530 | 40 |
846654 | 846654 | 2020-12-20 | Marion | Iowa | 19125 | 2498 | 40 |
843408 | 843408 | 2020-12-19 | Marion | Iowa | 19125 | 2494 | 37 |
840163 | 840163 | 2020-12-18 | Marion | Iowa | 19125 | 2459 | 34 |
836918 | 836918 | 2020-12-17 | Marion | Iowa | 19125 | 2413 | 34 |
833672 | 833672 | 2020-12-16 | Marion | Iowa | 19125 | 2390 | 34 |
830425 | 830425 | 2020-12-15 | Marion | Iowa | 19125 | 2359 | 34 |
827179 | 827179 | 2020-12-14 | Marion | Iowa | 19125 | 2324 | 33 |
823932 | 823932 | 2020-12-13 | Marion | Iowa | 19125 | 2314 | 32 |
820686 | 820686 | 2020-12-12 | Marion | Iowa | 19125 | 2299 | 32 |
817440 | 817440 | 2020-12-11 | Marion | Iowa | 19125 | 2280 | 32 |
814194 | 814194 | 2020-12-10 | Marion | Iowa | 19125 | 2253 | 27 |
810949 | 810949 | 2020-12-09 | Marion | Iowa | 19125 | 2222 | 26 |
807704 | 807704 | 2020-12-08 | Marion | Iowa | 19125 | 2202 | 25 |
804459 | 804459 | 2020-12-07 | Marion | Iowa | 19125 | 2201 | 25 |
801214 | 801214 | 2020-12-06 | Marion | Iowa | 19125 | 2176 | 25 |
797969 | 797969 | 2020-12-05 | Marion | Iowa | 19125 | 2167 | 25 |
794724 | 794724 | 2020-12-04 | Marion | Iowa | 19125 | 2153 | 24 |
791479 | 791479 | 2020-12-03 | Marion | Iowa | 19125 | 2119 | 22 |
788234 | 788234 | 2020-12-02 | Marion | Iowa | 19125 | 2102 | 22 |
784990 | 784990 | 2020-12-01 | Marion | Iowa | 19125 | 2083 | 22 |
781745 | 781745 | 2020-11-30 | Marion | Iowa | 19125 | 2068 | 21 |
778499 | 778499 | 2020-11-29 | Marion | Iowa | 19125 | 2053 | 20 |
775254 | 775254 | 2020-11-28 | Marion | Iowa | 19125 | 2043 | 20 |
772009 | 772009 | 2020-11-27 | Marion | Iowa | 19125 | 2029 | 19 |
768764 | 768764 | 2020-11-26 | Marion | Iowa | 19125 | 2017 | 19 |
765518 | 765518 | 2020-11-25 | Marion | Iowa | 19125 | 2000 | 19 |
762273 | 762273 | 2020-11-24 | Marion | Iowa | 19125 | 1967 | 19 |
759028 | 759028 | 2020-11-23 | Marion | Iowa | 19125 | 1944 | 18 |
755781 | 755781 | 2020-11-22 | Marion | Iowa | 19125 | 1915 | 18 |
752535 | 752535 | 2020-11-21 | Marion | Iowa | 19125 | 1889 | 18 |
749289 | 749289 | 2020-11-20 | Marion | Iowa | 19125 | 1860 | 18 |
746043 | 746043 | 2020-11-19 | Marion | Iowa | 19125 | 1812 | 17 |
742796 | 742796 | 2020-11-18 | Marion | Iowa | 19125 | 1763 | 17 |
739549 | 739549 | 2020-11-17 | Marion | Iowa | 19125 | 1714 | 17 |
736305 | 736305 | 2020-11-16 | Marion | Iowa | 19125 | 1681 | 17 |
733059 | 733059 | 2020-11-15 | Marion | Iowa | 19125 | 1646 | 16 |
729814 | 729814 | 2020-11-14 | Marion | Iowa | 19125 | 1597 | 16 |
726571 | 726571 | 2020-11-13 | Marion | Iowa | 19125 | 1562 | 15 |
723328 | 723328 | 2020-11-12 | Marion | Iowa | 19125 | 1503 | 15 |
720085 | 720085 | 2020-11-11 | Marion | Iowa | 19125 | 1482 | 14 |
716842 | 716842 | 2020-11-10 | Marion | Iowa | 19125 | 1451 | 14 |
713598 | 713598 | 2020-11-09 | Marion | Iowa | 19125 | 1417 | 13 |
710354 | 710354 | 2020-11-08 | Marion | Iowa | 19125 | 1402 | 13 |
707110 | 707110 | 2020-11-07 | Marion | Iowa | 19125 | 1335 | 13 |
703867 | 703867 | 2020-11-06 | Marion | Iowa | 19125 | 1292 | 13 |
700625 | 700625 | 2020-11-05 | Marion | Iowa | 19125 | 1269 | 12 |
697381 | 697381 | 2020-11-04 | Marion | Iowa | 19125 | 1211 | 12 |
694139 | 694139 | 2020-11-03 | Marion | Iowa | 19125 | 1180 | 12 |
690896 | 690896 | 2020-11-02 | Marion | Iowa | 19125 | 1169 | 11 |
687651 | 687651 | 2020-11-01 | Marion | Iowa | 19125 | 1154 | 11 |
684407 | 684407 | 2020-10-31 | Marion | Iowa | 19125 | 1120 | 11 |
681164 | 681164 | 2020-10-30 | Marion | Iowa | 19125 | 1094 | 11 |
677921 | 677921 | 2020-10-29 | Marion | Iowa | 19125 | 1070 | 11 |
674678 | 674678 | 2020-10-28 | Marion | Iowa | 19125 | 1052 | 11 |
671436 | 671436 | 2020-10-27 | Marion | Iowa | 19125 | 1034 | 11 |
668193 | 668193 | 2020-10-26 | Marion | Iowa | 19125 | 1018 | 10 |
664949 | 664949 | 2020-10-25 | Marion | Iowa | 19125 | 1007 | 10 |
661704 | 661704 | 2020-10-24 | Marion | Iowa | 19125 | 983 | 10 |
658460 | 658460 | 2020-10-23 | Marion | Iowa | 19125 | 965 | 10 |
655215 | 655215 | 2020-10-22 | Marion | Iowa | 19125 | 960 | 10 |
651970 | 651970 | 2020-10-21 | Marion | Iowa | 19125 | 950 | 10 |
648726 | 648726 | 2020-10-20 | Marion | Iowa | 19125 | 935 | 10 |
645481 | 645481 | 2020-10-19 | Marion | Iowa | 19125 | 924 | 10 |
642234 | 642234 | 2020-10-18 | Marion | Iowa | 19125 | 920 | 10 |
638987 | 638987 | 2020-10-17 | Marion | Iowa | 19125 | 913 | 10 |
635741 | 635741 | 2020-10-16 | Marion | Iowa | 19125 | 907 | 10 |
632495 | 632495 | 2020-10-15 | Marion | Iowa | 19125 | 895 | 10 |
629251 | 629251 | 2020-10-14 | Marion | Iowa | 19125 | 887 | 10 |
626008 | 626008 | 2020-10-13 | Marion | Iowa | 19125 | 879 | 9 |
622766 | 622766 | 2020-10-12 | Marion | Iowa | 19125 | 874 | 9 |
619522 | 619522 | 2020-10-11 | Marion | Iowa | 19125 | 872 | 9 |
616280 | 616280 | 2020-10-10 | Marion | Iowa | 19125 | 858 | 9 |
613039 | 613039 | 2020-10-09 | Marion | Iowa | 19125 | 851 | 9 |
609797 | 609797 | 2020-10-08 | Marion | Iowa | 19125 | 842 | 9 |
606554 | 606554 | 2020-10-07 | Marion | Iowa | 19125 | 820 | 9 |
603312 | 603312 | 2020-10-06 | Marion | Iowa | 19125 | 817 | 9 |
600069 | 600069 | 2020-10-05 | Marion | Iowa | 19125 | 807 | 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);