ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Greene" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921268 | 921268 | 2021-01-12 | Greene | Iowa | 19073 | 674 | 7 |
918023 | 918023 | 2021-01-11 | Greene | Iowa | 19073 | 669 | 7 |
914778 | 914778 | 2021-01-10 | Greene | Iowa | 19073 | 668 | 7 |
911533 | 911533 | 2021-01-09 | Greene | Iowa | 19073 | 668 | 7 |
908288 | 908288 | 2021-01-08 | Greene | Iowa | 19073 | 666 | 7 |
905042 | 905042 | 2021-01-07 | Greene | Iowa | 19073 | 665 | 7 |
901797 | 901797 | 2021-01-06 | Greene | Iowa | 19073 | 662 | 7 |
898552 | 898552 | 2021-01-05 | Greene | Iowa | 19073 | 660 | 7 |
895307 | 895307 | 2021-01-04 | Greene | Iowa | 19073 | 655 | 7 |
892060 | 892060 | 2021-01-03 | Greene | Iowa | 19073 | 649 | 7 |
888814 | 888814 | 2021-01-02 | Greene | Iowa | 19073 | 648 | 7 |
885568 | 885568 | 2021-01-01 | Greene | Iowa | 19073 | 648 | 7 |
882323 | 882323 | 2020-12-31 | Greene | Iowa | 19073 | 648 | 7 |
879078 | 879078 | 2020-12-30 | Greene | Iowa | 19073 | 645 | 7 |
875833 | 875833 | 2020-12-29 | Greene | Iowa | 19073 | 644 | 7 |
872588 | 872588 | 2020-12-28 | Greene | Iowa | 19073 | 636 | 7 |
869343 | 869343 | 2020-12-27 | Greene | Iowa | 19073 | 634 | 7 |
866098 | 866098 | 2020-12-26 | Greene | Iowa | 19073 | 633 | 7 |
862853 | 862853 | 2020-12-25 | Greene | Iowa | 19073 | 632 | 7 |
859608 | 859608 | 2020-12-24 | Greene | Iowa | 19073 | 632 | 7 |
856363 | 856363 | 2020-12-23 | Greene | Iowa | 19073 | 631 | 7 |
853118 | 853118 | 2020-12-22 | Greene | Iowa | 19073 | 627 | 7 |
849873 | 849873 | 2020-12-21 | Greene | Iowa | 19073 | 618 | 7 |
846628 | 846628 | 2020-12-20 | Greene | Iowa | 19073 | 616 | 7 |
843382 | 843382 | 2020-12-19 | Greene | Iowa | 19073 | 616 | 7 |
840137 | 840137 | 2020-12-18 | Greene | Iowa | 19073 | 611 | 6 |
836892 | 836892 | 2020-12-17 | Greene | Iowa | 19073 | 603 | 6 |
833646 | 833646 | 2020-12-16 | Greene | Iowa | 19073 | 601 | 6 |
830399 | 830399 | 2020-12-15 | Greene | Iowa | 19073 | 597 | 6 |
827153 | 827153 | 2020-12-14 | Greene | Iowa | 19073 | 585 | 6 |
823906 | 823906 | 2020-12-13 | Greene | Iowa | 19073 | 582 | 6 |
820660 | 820660 | 2020-12-12 | Greene | Iowa | 19073 | 581 | 6 |
817414 | 817414 | 2020-12-11 | Greene | Iowa | 19073 | 577 | 6 |
814168 | 814168 | 2020-12-10 | Greene | Iowa | 19073 | 572 | 5 |
810923 | 810923 | 2020-12-09 | Greene | Iowa | 19073 | 569 | 3 |
807678 | 807678 | 2020-12-08 | Greene | Iowa | 19073 | 555 | 2 |
804433 | 804433 | 2020-12-07 | Greene | Iowa | 19073 | 555 | 2 |
801188 | 801188 | 2020-12-06 | Greene | Iowa | 19073 | 551 | 2 |
797943 | 797943 | 2020-12-05 | Greene | Iowa | 19073 | 550 | 2 |
794698 | 794698 | 2020-12-04 | Greene | Iowa | 19073 | 547 | 2 |
791453 | 791453 | 2020-12-03 | Greene | Iowa | 19073 | 542 | 2 |
788208 | 788208 | 2020-12-02 | Greene | Iowa | 19073 | 540 | 1 |
784964 | 784964 | 2020-12-01 | Greene | Iowa | 19073 | 538 | 1 |
781719 | 781719 | 2020-11-30 | Greene | Iowa | 19073 | 531 | 0 |
778473 | 778473 | 2020-11-29 | Greene | Iowa | 19073 | 525 | 0 |
775228 | 775228 | 2020-11-28 | Greene | Iowa | 19073 | 522 | 0 |
771983 | 771983 | 2020-11-27 | Greene | Iowa | 19073 | 517 | 0 |
768738 | 768738 | 2020-11-26 | Greene | Iowa | 19073 | 516 | 0 |
765492 | 765492 | 2020-11-25 | Greene | Iowa | 19073 | 514 | 0 |
762247 | 762247 | 2020-11-24 | Greene | Iowa | 19073 | 507 | 0 |
759002 | 759002 | 2020-11-23 | Greene | Iowa | 19073 | 498 | 0 |
755755 | 755755 | 2020-11-22 | Greene | Iowa | 19073 | 486 | 0 |
752509 | 752509 | 2020-11-21 | Greene | Iowa | 19073 | 479 | 0 |
749263 | 749263 | 2020-11-20 | Greene | Iowa | 19073 | 473 | 0 |
746017 | 746017 | 2020-11-19 | Greene | Iowa | 19073 | 456 | 0 |
742770 | 742770 | 2020-11-18 | Greene | Iowa | 19073 | 446 | 0 |
739523 | 739523 | 2020-11-17 | Greene | Iowa | 19073 | 428 | 0 |
736279 | 736279 | 2020-11-16 | Greene | Iowa | 19073 | 410 | 0 |
733033 | 733033 | 2020-11-15 | Greene | Iowa | 19073 | 398 | 0 |
729788 | 729788 | 2020-11-14 | Greene | Iowa | 19073 | 387 | 0 |
726545 | 726545 | 2020-11-13 | Greene | Iowa | 19073 | 380 | 0 |
723302 | 723302 | 2020-11-12 | Greene | Iowa | 19073 | 360 | 0 |
720059 | 720059 | 2020-11-11 | Greene | Iowa | 19073 | 343 | 0 |
716816 | 716816 | 2020-11-10 | Greene | Iowa | 19073 | 314 | 0 |
713572 | 713572 | 2020-11-09 | Greene | Iowa | 19073 | 303 | 0 |
710328 | 710328 | 2020-11-08 | Greene | Iowa | 19073 | 288 | 0 |
707084 | 707084 | 2020-11-07 | Greene | Iowa | 19073 | 267 | 0 |
703841 | 703841 | 2020-11-06 | Greene | Iowa | 19073 | 253 | 0 |
700599 | 700599 | 2020-11-05 | Greene | Iowa | 19073 | 237 | 0 |
697355 | 697355 | 2020-11-04 | Greene | Iowa | 19073 | 225 | 0 |
694113 | 694113 | 2020-11-03 | Greene | Iowa | 19073 | 218 | 0 |
690870 | 690870 | 2020-11-02 | Greene | Iowa | 19073 | 210 | 0 |
687625 | 687625 | 2020-11-01 | Greene | Iowa | 19073 | 209 | 0 |
684381 | 684381 | 2020-10-31 | Greene | Iowa | 19073 | 208 | 0 |
681138 | 681138 | 2020-10-30 | Greene | Iowa | 19073 | 199 | 0 |
677895 | 677895 | 2020-10-29 | Greene | Iowa | 19073 | 193 | 0 |
674652 | 674652 | 2020-10-28 | Greene | Iowa | 19073 | 190 | 0 |
671410 | 671410 | 2020-10-27 | Greene | Iowa | 19073 | 188 | 0 |
668167 | 668167 | 2020-10-26 | Greene | Iowa | 19073 | 187 | 0 |
664923 | 664923 | 2020-10-25 | Greene | Iowa | 19073 | 186 | 0 |
661678 | 661678 | 2020-10-24 | Greene | Iowa | 19073 | 184 | 0 |
658434 | 658434 | 2020-10-23 | Greene | Iowa | 19073 | 183 | 0 |
655189 | 655189 | 2020-10-22 | Greene | Iowa | 19073 | 182 | 0 |
651944 | 651944 | 2020-10-21 | Greene | Iowa | 19073 | 180 | 0 |
648700 | 648700 | 2020-10-20 | Greene | Iowa | 19073 | 174 | 0 |
645455 | 645455 | 2020-10-19 | Greene | Iowa | 19073 | 173 | 0 |
642208 | 642208 | 2020-10-18 | Greene | Iowa | 19073 | 171 | 0 |
638961 | 638961 | 2020-10-17 | Greene | Iowa | 19073 | 170 | 0 |
635715 | 635715 | 2020-10-16 | Greene | Iowa | 19073 | 168 | 0 |
632469 | 632469 | 2020-10-15 | Greene | Iowa | 19073 | 158 | 0 |
629225 | 629225 | 2020-10-14 | Greene | Iowa | 19073 | 157 | 0 |
625982 | 625982 | 2020-10-13 | Greene | Iowa | 19073 | 155 | 0 |
622740 | 622740 | 2020-10-12 | Greene | Iowa | 19073 | 152 | 0 |
619496 | 619496 | 2020-10-11 | Greene | Iowa | 19073 | 151 | 0 |
616254 | 616254 | 2020-10-10 | Greene | Iowa | 19073 | 151 | 0 |
613013 | 613013 | 2020-10-09 | Greene | Iowa | 19073 | 148 | 0 |
609771 | 609771 | 2020-10-08 | Greene | Iowa | 19073 | 145 | 0 |
606528 | 606528 | 2020-10-07 | Greene | Iowa | 19073 | 141 | 0 |
603286 | 603286 | 2020-10-06 | Greene | Iowa | 19073 | 136 | 0 |
600043 | 600043 | 2020-10-05 | Greene | Iowa | 19073 | 132 | 0 |
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);