ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Vanderburgh" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921221 | 921221 | 2021-01-12 | Vanderburgh | Indiana | 18163 | 17871 | 213 |
917976 | 917976 | 2021-01-11 | Vanderburgh | Indiana | 18163 | 17694 | 211 |
914731 | 914731 | 2021-01-10 | Vanderburgh | Indiana | 18163 | 17547 | 211 |
911486 | 911486 | 2021-01-09 | Vanderburgh | Indiana | 18163 | 17380 | 211 |
908241 | 908241 | 2021-01-08 | Vanderburgh | Indiana | 18163 | 17170 | 211 |
904995 | 904995 | 2021-01-07 | Vanderburgh | Indiana | 18163 | 16997 | 211 |
901750 | 901750 | 2021-01-06 | Vanderburgh | Indiana | 18163 | 16719 | 211 |
898505 | 898505 | 2021-01-05 | Vanderburgh | Indiana | 18163 | 16484 | 210 |
895260 | 895260 | 2021-01-04 | Vanderburgh | Indiana | 18163 | 16266 | 208 |
892013 | 892013 | 2021-01-03 | Vanderburgh | Indiana | 18163 | 16099 | 208 |
888767 | 888767 | 2021-01-02 | Vanderburgh | Indiana | 18163 | 16000 | 205 |
885521 | 885521 | 2021-01-01 | Vanderburgh | Indiana | 18163 | 15793 | 204 |
882276 | 882276 | 2020-12-31 | Vanderburgh | Indiana | 18163 | 15554 | 203 |
879031 | 879031 | 2020-12-30 | Vanderburgh | Indiana | 18163 | 15241 | 201 |
875786 | 875786 | 2020-12-29 | Vanderburgh | Indiana | 18163 | 15070 | 194 |
872541 | 872541 | 2020-12-28 | Vanderburgh | Indiana | 18163 | 14949 | 192 |
869296 | 869296 | 2020-12-27 | Vanderburgh | Indiana | 18163 | 14787 | 191 |
866051 | 866051 | 2020-12-26 | Vanderburgh | Indiana | 18163 | 14736 | 190 |
862806 | 862806 | 2020-12-25 | Vanderburgh | Indiana | 18163 | 14562 | 190 |
859561 | 859561 | 2020-12-24 | Vanderburgh | Indiana | 18163 | 14373 | 190 |
856316 | 856316 | 2020-12-23 | Vanderburgh | Indiana | 18163 | 14213 | 186 |
853071 | 853071 | 2020-12-22 | Vanderburgh | Indiana | 18163 | 13975 | 184 |
849826 | 849826 | 2020-12-21 | Vanderburgh | Indiana | 18163 | 13886 | 183 |
846581 | 846581 | 2020-12-20 | Vanderburgh | Indiana | 18163 | 13774 | 183 |
843335 | 843335 | 2020-12-19 | Vanderburgh | Indiana | 18163 | 13548 | 179 |
840090 | 840090 | 2020-12-18 | Vanderburgh | Indiana | 18163 | 13455 | 176 |
836845 | 836845 | 2020-12-17 | Vanderburgh | Indiana | 18163 | 13258 | 174 |
833599 | 833599 | 2020-12-16 | Vanderburgh | Indiana | 18163 | 13116 | 174 |
830352 | 830352 | 2020-12-15 | Vanderburgh | Indiana | 18163 | 12916 | 173 |
827106 | 827106 | 2020-12-14 | Vanderburgh | Indiana | 18163 | 12812 | 159 |
823859 | 823859 | 2020-12-13 | Vanderburgh | Indiana | 18163 | 12601 | 159 |
820613 | 820613 | 2020-12-12 | Vanderburgh | Indiana | 18163 | 12436 | 159 |
817367 | 817367 | 2020-12-11 | Vanderburgh | Indiana | 18163 | 12267 | 156 |
814121 | 814121 | 2020-12-10 | Vanderburgh | Indiana | 18163 | 12121 | 153 |
810876 | 810876 | 2020-12-09 | Vanderburgh | Indiana | 18163 | 12033 | 152 |
807631 | 807631 | 2020-12-08 | Vanderburgh | Indiana | 18163 | 11837 | 151 |
804386 | 804386 | 2020-12-07 | Vanderburgh | Indiana | 18163 | 11736 | 142 |
801141 | 801141 | 2020-12-06 | Vanderburgh | Indiana | 18163 | 11557 | 141 |
797896 | 797896 | 2020-12-05 | Vanderburgh | Indiana | 18163 | 11436 | 141 |
794651 | 794651 | 2020-12-04 | Vanderburgh | Indiana | 18163 | 11180 | 140 |
791406 | 791406 | 2020-12-03 | Vanderburgh | Indiana | 18163 | 10962 | 139 |
788161 | 788161 | 2020-12-02 | Vanderburgh | Indiana | 18163 | 10868 | 136 |
784917 | 784917 | 2020-12-01 | Vanderburgh | Indiana | 18163 | 10677 | 130 |
781672 | 781672 | 2020-11-30 | Vanderburgh | Indiana | 18163 | 10551 | 129 |
778426 | 778426 | 2020-11-29 | Vanderburgh | Indiana | 18163 | 10285 | 128 |
775181 | 775181 | 2020-11-28 | Vanderburgh | Indiana | 18163 | 10171 | 128 |
771936 | 771936 | 2020-11-27 | Vanderburgh | Indiana | 18163 | 10033 | 122 |
768691 | 768691 | 2020-11-26 | Vanderburgh | Indiana | 18163 | 9844 | 122 |
765445 | 765445 | 2020-11-25 | Vanderburgh | Indiana | 18163 | 9756 | 121 |
762200 | 762200 | 2020-11-24 | Vanderburgh | Indiana | 18163 | 9557 | 116 |
758955 | 758955 | 2020-11-23 | Vanderburgh | Indiana | 18163 | 9433 | 113 |
755708 | 755708 | 2020-11-22 | Vanderburgh | Indiana | 18163 | 9223 | 113 |
752462 | 752462 | 2020-11-21 | Vanderburgh | Indiana | 18163 | 9096 | 112 |
749216 | 749216 | 2020-11-20 | Vanderburgh | Indiana | 18163 | 8950 | 112 |
745970 | 745970 | 2020-11-19 | Vanderburgh | Indiana | 18163 | 8766 | 110 |
742723 | 742723 | 2020-11-18 | Vanderburgh | Indiana | 18163 | 8642 | 109 |
739476 | 739476 | 2020-11-17 | Vanderburgh | Indiana | 18163 | 8527 | 108 |
736232 | 736232 | 2020-11-16 | Vanderburgh | Indiana | 18163 | 8397 | 101 |
732986 | 732986 | 2020-11-15 | Vanderburgh | Indiana | 18163 | 8231 | 100 |
729741 | 729741 | 2020-11-14 | Vanderburgh | Indiana | 18163 | 8073 | 100 |
726498 | 726498 | 2020-11-13 | Vanderburgh | Indiana | 18163 | 7935 | 99 |
723255 | 723255 | 2020-11-12 | Vanderburgh | Indiana | 18163 | 7792 | 96 |
720012 | 720012 | 2020-11-11 | Vanderburgh | Indiana | 18163 | 7696 | 93 |
716769 | 716769 | 2020-11-10 | Vanderburgh | Indiana | 18163 | 7552 | 93 |
713525 | 713525 | 2020-11-09 | Vanderburgh | Indiana | 18163 | 7501 | 90 |
710281 | 710281 | 2020-11-08 | Vanderburgh | Indiana | 18163 | 7387 | 88 |
707037 | 707037 | 2020-11-07 | Vanderburgh | Indiana | 18163 | 7245 | 88 |
703794 | 703794 | 2020-11-06 | Vanderburgh | Indiana | 18163 | 7162 | 88 |
700552 | 700552 | 2020-11-05 | Vanderburgh | Indiana | 18163 | 6985 | 84 |
697308 | 697308 | 2020-11-04 | Vanderburgh | Indiana | 18163 | 6919 | 82 |
694066 | 694066 | 2020-11-03 | Vanderburgh | Indiana | 18163 | 6848 | 80 |
690823 | 690823 | 2020-11-02 | Vanderburgh | Indiana | 18163 | 6799 | 78 |
687578 | 687578 | 2020-11-01 | Vanderburgh | Indiana | 18163 | 6699 | 76 |
684334 | 684334 | 2020-10-31 | Vanderburgh | Indiana | 18163 | 6594 | 76 |
681091 | 681091 | 2020-10-30 | Vanderburgh | Indiana | 18163 | 6488 | 73 |
677848 | 677848 | 2020-10-29 | Vanderburgh | Indiana | 18163 | 6409 | 72 |
674605 | 674605 | 2020-10-28 | Vanderburgh | Indiana | 18163 | 6273 | 70 |
671363 | 671363 | 2020-10-27 | Vanderburgh | Indiana | 18163 | 6228 | 64 |
668120 | 668120 | 2020-10-26 | Vanderburgh | Indiana | 18163 | 6175 | 62 |
664876 | 664876 | 2020-10-25 | Vanderburgh | Indiana | 18163 | 6094 | 62 |
661631 | 661631 | 2020-10-24 | Vanderburgh | Indiana | 18163 | 6015 | 61 |
658387 | 658387 | 2020-10-23 | Vanderburgh | Indiana | 18163 | 5886 | 61 |
655142 | 655142 | 2020-10-22 | Vanderburgh | Indiana | 18163 | 5771 | 60 |
651897 | 651897 | 2020-10-21 | Vanderburgh | Indiana | 18163 | 5678 | 60 |
648653 | 648653 | 2020-10-20 | Vanderburgh | Indiana | 18163 | 5596 | 60 |
645408 | 645408 | 2020-10-19 | Vanderburgh | Indiana | 18163 | 5533 | 50 |
642161 | 642161 | 2020-10-18 | Vanderburgh | Indiana | 18163 | 5480 | 50 |
638914 | 638914 | 2020-10-17 | Vanderburgh | Indiana | 18163 | 5366 | 49 |
635668 | 635668 | 2020-10-16 | Vanderburgh | Indiana | 18163 | 5228 | 48 |
632422 | 632422 | 2020-10-15 | Vanderburgh | Indiana | 18163 | 5170 | 48 |
629178 | 629178 | 2020-10-14 | Vanderburgh | Indiana | 18163 | 5126 | 46 |
625935 | 625935 | 2020-10-13 | Vanderburgh | Indiana | 18163 | 5059 | 45 |
622693 | 622693 | 2020-10-12 | Vanderburgh | Indiana | 18163 | 4953 | 42 |
619449 | 619449 | 2020-10-11 | Vanderburgh | Indiana | 18163 | 4855 | 42 |
616207 | 616207 | 2020-10-10 | Vanderburgh | Indiana | 18163 | 4749 | 41 |
612966 | 612966 | 2020-10-09 | Vanderburgh | Indiana | 18163 | 4655 | 41 |
609724 | 609724 | 2020-10-08 | Vanderburgh | Indiana | 18163 | 4529 | 37 |
606481 | 606481 | 2020-10-07 | Vanderburgh | Indiana | 18163 | 4452 | 36 |
603239 | 603239 | 2020-10-06 | Vanderburgh | Indiana | 18163 | 4365 | 35 |
599996 | 599996 | 2020-10-05 | Vanderburgh | Indiana | 18163 | 4301 | 32 |
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);