ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2020-07-27 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
373771 | 373771 | 2020-07-27 | Adams | Indiana | 18001 | 72 | 2 |
373772 | 373772 | 2020-07-27 | Allen | Indiana | 18003 | 3401 | 162 |
373773 | 373773 | 2020-07-27 | Bartholomew | Indiana | 18005 | 695 | 48 |
373774 | 373774 | 2020-07-27 | Benton | Indiana | 18007 | 56 | 0 |
373775 | 373775 | 2020-07-27 | Blackford | Indiana | 18009 | 53 | 2 |
373776 | 373776 | 2020-07-27 | Boone | Indiana | 18011 | 602 | 48 |
373777 | 373777 | 2020-07-27 | Brown | Indiana | 18013 | 64 | 1 |
373778 | 373778 | 2020-07-27 | Carroll | Indiana | 18015 | 122 | 2 |
373779 | 373779 | 2020-07-27 | Cass | Indiana | 18017 | 1722 | 10 |
373780 | 373780 | 2020-07-27 | Clark | Indiana | 18019 | 939 | 52 |
373781 | 373781 | 2020-07-27 | Clay | Indiana | 18021 | 83 | 5 |
373782 | 373782 | 2020-07-27 | Clinton | Indiana | 18023 | 327 | 4 |
373783 | 373783 | 2020-07-27 | Crawford | Indiana | 18025 | 41 | 1 |
373784 | 373784 | 2020-07-27 | Daviess | Indiana | 18027 | 206 | 21 |
373785 | 373785 | 2020-07-27 | DeKalb | Indiana | 18033 | 199 | 5 |
373786 | 373786 | 2020-07-27 | Dearborn | Indiana | 18029 | 406 | 28 |
373787 | 373787 | 2020-07-27 | Decatur | Indiana | 18031 | 299 | 35 |
373788 | 373788 | 2020-07-27 | Delaware | Indiana | 18035 | 563 | 53 |
373789 | 373789 | 2020-07-27 | Dubois | Indiana | 18037 | 558 | 10 |
373790 | 373790 | 2020-07-27 | Elkhart | Indiana | 18039 | 4466 | 75 |
373791 | 373791 | 2020-07-27 | Fayette | Indiana | 18041 | 195 | 7 |
373792 | 373792 | 2020-07-27 | Floyd | Indiana | 18043 | 585 | 46 |
373793 | 373793 | 2020-07-27 | Fountain | Indiana | 18045 | 55 | 2 |
373794 | 373794 | 2020-07-27 | Franklin | Indiana | 18047 | 184 | 9 |
373795 | 373795 | 2020-07-27 | Fulton | Indiana | 18049 | 119 | 1 |
373796 | 373796 | 2020-07-27 | Gibson | Indiana | 18051 | 183 | 2 |
373797 | 373797 | 2020-07-27 | Grant | Indiana | 18053 | 657 | 32 |
373798 | 373798 | 2020-07-27 | Greene | Indiana | 18055 | 227 | 37 |
373799 | 373799 | 2020-07-27 | Hamilton | Indiana | 18057 | 2281 | 110 |
373800 | 373800 | 2020-07-27 | Hancock | Indiana | 18059 | 586 | 38 |
373801 | 373801 | 2020-07-27 | Harrison | Indiana | 18061 | 254 | 24 |
373802 | 373802 | 2020-07-27 | Hendricks | Indiana | 18063 | 1684 | 121 |
373803 | 373803 | 2020-07-27 | Henry | Indiana | 18065 | 350 | 18 |
373804 | 373804 | 2020-07-27 | Howard | Indiana | 18067 | 758 | 66 |
373805 | 373805 | 2020-07-27 | Huntington | Indiana | 18069 | 117 | 3 |
373806 | 373806 | 2020-07-27 | Jackson | Indiana | 18071 | 530 | 5 |
373807 | 373807 | 2020-07-27 | Jasper | Indiana | 18073 | 189 | 2 |
373808 | 373808 | 2020-07-27 | Jay | Indiana | 18075 | 80 | 0 |
373809 | 373809 | 2020-07-27 | Jefferson | Indiana | 18077 | 144 | 2 |
373810 | 373810 | 2020-07-27 | Jennings | Indiana | 18079 | 196 | 14 |
373811 | 373811 | 2020-07-27 | Johnson | Indiana | 18081 | 1587 | 126 |
373812 | 373812 | 2020-07-27 | Knox | Indiana | 18083 | 108 | 0 |
373813 | 373813 | 2020-07-27 | Kosciusko | Indiana | 18085 | 785 | 12 |
373814 | 373814 | 2020-07-27 | LaGrange | Indiana | 18087 | 526 | 10 |
373815 | 373815 | 2020-07-27 | LaPorte | Indiana | 18091 | 762 | 29 |
373816 | 373816 | 2020-07-27 | Lake | Indiana | 18089 | 6769 | 281 |
373817 | 373817 | 2020-07-27 | Lawrence | Indiana | 18093 | 298 | 28 |
373818 | 373818 | 2020-07-27 | Madison | Indiana | 18095 | 781 | 75 |
373819 | 373819 | 2020-07-27 | Marion | Indiana | 18097 | 13953 | 760 |
373820 | 373820 | 2020-07-27 | Marshall | Indiana | 18099 | 712 | 19 |
373821 | 373821 | 2020-07-27 | Martin | Indiana | 18101 | 39 | 0 |
373822 | 373822 | 2020-07-27 | Miami | Indiana | 18103 | 239 | 2 |
373823 | 373823 | 2020-07-27 | Monroe | Indiana | 18105 | 606 | 32 |
373824 | 373824 | 2020-07-27 | Montgomery | Indiana | 18107 | 321 | 22 |
373825 | 373825 | 2020-07-27 | Morgan | Indiana | 18109 | 405 | 34 |
373826 | 373826 | 2020-07-27 | Newton | Indiana | 18111 | 106 | 11 |
373827 | 373827 | 2020-07-27 | Noble | Indiana | 18113 | 606 | 29 |
373828 | 373828 | 2020-07-27 | Ohio | Indiana | 18115 | 36 | 3 |
373829 | 373829 | 2020-07-27 | Orange | Indiana | 18117 | 160 | 26 |
373830 | 373830 | 2020-07-27 | Owen | Indiana | 18119 | 70 | 1 |
373831 | 373831 | 2020-07-27 | Parke | Indiana | 18121 | 43 | 0 |
373832 | 373832 | 2020-07-27 | Perry | Indiana | 18123 | 174 | 13 |
373833 | 373833 | 2020-07-27 | Pike | Indiana | 18125 | 26 | 0 |
373834 | 373834 | 2020-07-27 | Porter | Indiana | 18127 | 1068 | 40 |
373835 | 373835 | 2020-07-27 | Posey | Indiana | 18129 | 145 | 0 |
373836 | 373836 | 2020-07-27 | Pulaski | Indiana | 18131 | 71 | 1 |
373837 | 373837 | 2020-07-27 | Putnam | Indiana | 18133 | 213 | 8 |
373838 | 373838 | 2020-07-27 | Randolph | Indiana | 18135 | 121 | 4 |
373839 | 373839 | 2020-07-27 | Ripley | Indiana | 18137 | 177 | 7 |
373840 | 373840 | 2020-07-27 | Rush | Indiana | 18139 | 105 | 4 |
373841 | 373841 | 2020-07-27 | Scott | Indiana | 18143 | 227 | 11 |
373842 | 373842 | 2020-07-27 | Shelby | Indiana | 18145 | 773 | 32 |
373843 | 373843 | 2020-07-27 | Spencer | Indiana | 18147 | 107 | 1 |
373844 | 373844 | 2020-07-27 | St. Joseph | Indiana | 18141 | 2841 | 81 |
373845 | 373845 | 2020-07-27 | Starke | Indiana | 18149 | 153 | 5 |
373846 | 373846 | 2020-07-27 | Steuben | Indiana | 18151 | 186 | 3 |
373847 | 373847 | 2020-07-27 | Sullivan | Indiana | 18153 | 69 | 1 |
373848 | 373848 | 2020-07-27 | Switzerland | Indiana | 18155 | 40 | 0 |
373849 | 373849 | 2020-07-27 | Tippecanoe | Indiana | 18157 | 982 | 12 |
373850 | 373850 | 2020-07-27 | Tipton | Indiana | 18159 | 84 | 3 |
373851 | 373851 | 2020-07-27 | Union | Indiana | 18161 | 46 | 0 |
373852 | 373852 | 2020-07-27 | Vanderburgh | Indiana | 18163 | 1461 | 7 |
373853 | 373853 | 2020-07-27 | Vermillion | Indiana | 18165 | 23 | 0 |
373854 | 373854 | 2020-07-27 | Vigo | Indiana | 18167 | 376 | 10 |
373855 | 373855 | 2020-07-27 | Wabash | Indiana | 18169 | 148 | 3 |
373856 | 373856 | 2020-07-27 | Warren | Indiana | 18171 | 20 | 1 |
373857 | 373857 | 2020-07-27 | Warrick | Indiana | 18173 | 433 | 31 |
373858 | 373858 | 2020-07-27 | Washington | Indiana | 18175 | 88 | 1 |
373859 | 373859 | 2020-07-27 | Wayne | Indiana | 18177 | 502 | 7 |
373860 | 373860 | 2020-07-27 | Wells | Indiana | 18179 | 134 | 1 |
373861 | 373861 | 2020-07-27 | White | Indiana | 18181 | 327 | 10 |
373862 | 373862 | 2020-07-27 | Whitley | Indiana | 18183 | 137 | 6 |
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);