ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-06-30" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
287769 | 287769 | 2020-06-30 | Adams | Indiana | 18001 | 46 | 2 |
287770 | 287770 | 2020-06-30 | Allen | Indiana | 18003 | 2668 | 120 |
287771 | 287771 | 2020-06-30 | Bartholomew | Indiana | 18005 | 583 | 47 |
287772 | 287772 | 2020-06-30 | Benton | Indiana | 18007 | 47 | 0 |
287773 | 287773 | 2020-06-30 | Blackford | Indiana | 18009 | 38 | 2 |
287774 | 287774 | 2020-06-30 | Boone | Indiana | 18011 | 439 | 45 |
287775 | 287775 | 2020-06-30 | Brown | Indiana | 18013 | 38 | 1 |
287776 | 287776 | 2020-06-30 | Carroll | Indiana | 18015 | 108 | 2 |
287777 | 287777 | 2020-06-30 | Cass | Indiana | 18017 | 1639 | 10 |
287778 | 287778 | 2020-06-30 | Clark | Indiana | 18019 | 626 | 51 |
287779 | 287779 | 2020-06-30 | Clay | Indiana | 18021 | 59 | 4 |
287780 | 287780 | 2020-06-30 | Clinton | Indiana | 18023 | 280 | 3 |
287781 | 287781 | 2020-06-30 | Crawford | Indiana | 18025 | 30 | 1 |
287782 | 287782 | 2020-06-30 | Daviess | Indiana | 18027 | 140 | 18 |
287783 | 287783 | 2020-06-30 | DeKalb | Indiana | 18033 | 158 | 5 |
287784 | 287784 | 2020-06-30 | Dearborn | Indiana | 18029 | 204 | 23 |
287785 | 287785 | 2020-06-30 | Decatur | Indiana | 18031 | 258 | 35 |
287786 | 287786 | 2020-06-30 | Delaware | Indiana | 18035 | 427 | 49 |
287787 | 287787 | 2020-06-30 | Dubois | Indiana | 18037 | 259 | 6 |
287788 | 287788 | 2020-06-30 | Elkhart | Indiana | 18039 | 3101 | 46 |
287789 | 287789 | 2020-06-30 | Fayette | Indiana | 18041 | 145 | 7 |
287790 | 287790 | 2020-06-30 | Floyd | Indiana | 18043 | 364 | 46 |
287791 | 287791 | 2020-06-30 | Fountain | Indiana | 18045 | 28 | 2 |
287792 | 287792 | 2020-06-30 | Franklin | Indiana | 18047 | 131 | 9 |
287793 | 287793 | 2020-06-30 | Fulton | Indiana | 18049 | 66 | 1 |
287794 | 287794 | 2020-06-30 | Gibson | Indiana | 18051 | 41 | 2 |
287795 | 287795 | 2020-06-30 | Grant | Indiana | 18053 | 376 | 29 |
287796 | 287796 | 2020-06-30 | Greene | Indiana | 18055 | 189 | 34 |
287797 | 287797 | 2020-06-30 | Hamilton | Indiana | 18057 | 1478 | 105 |
287798 | 287798 | 2020-06-30 | Hancock | Indiana | 18059 | 423 | 36 |
287799 | 287799 | 2020-06-30 | Harrison | Indiana | 18061 | 210 | 24 |
287800 | 287800 | 2020-06-30 | Hendricks | Indiana | 18063 | 1390 | 115 |
287801 | 287801 | 2020-06-30 | Henry | Indiana | 18065 | 240 | 15 |
287802 | 287802 | 2020-06-30 | Howard | Indiana | 18067 | 547 | 59 |
287803 | 287803 | 2020-06-30 | Huntington | Indiana | 18069 | 70 | 2 |
287804 | 287804 | 2020-06-30 | Jackson | Indiana | 18071 | 458 | 4 |
287805 | 287805 | 2020-06-30 | Jasper | Indiana | 18073 | 108 | 2 |
287806 | 287806 | 2020-06-30 | Jay | Indiana | 18075 | 72 | 0 |
287807 | 287807 | 2020-06-30 | Jefferson | Indiana | 18077 | 65 | 1 |
287808 | 287808 | 2020-06-30 | Jennings | Indiana | 18079 | 171 | 12 |
287809 | 287809 | 2020-06-30 | Johnson | Indiana | 18081 | 1260 | 126 |
287810 | 287810 | 2020-06-30 | Knox | Indiana | 18083 | 63 | 0 |
287811 | 287811 | 2020-06-30 | Kosciusko | Indiana | 18085 | 488 | 3 |
287812 | 287812 | 2020-06-30 | LaGrange | Indiana | 18087 | 458 | 6 |
287813 | 287813 | 2020-06-30 | LaPorte | Indiana | 18091 | 536 | 25 |
287814 | 287814 | 2020-06-30 | Lake | Indiana | 18089 | 4884 | 255 |
287815 | 287815 | 2020-06-30 | Lawrence | Indiana | 18093 | 230 | 25 |
287816 | 287816 | 2020-06-30 | Madison | Indiana | 18095 | 652 | 73 |
287817 | 287817 | 2020-06-30 | Marion | Indiana | 18097 | 11451 | 726 |
287818 | 287818 | 2020-06-30 | Marshall | Indiana | 18099 | 409 | 3 |
287819 | 287819 | 2020-06-30 | Martin | Indiana | 18101 | 22 | 0 |
287820 | 287820 | 2020-06-30 | Miami | Indiana | 18103 | 183 | 2 |
287821 | 287821 | 2020-06-30 | Monroe | Indiana | 18105 | 246 | 30 |
287822 | 287822 | 2020-06-30 | Montgomery | Indiana | 18107 | 287 | 21 |
287823 | 287823 | 2020-06-30 | Morgan | Indiana | 18109 | 328 | 34 |
287824 | 287824 | 2020-06-30 | Newton | Indiana | 18111 | 95 | 11 |
287825 | 287825 | 2020-06-30 | Noble | Indiana | 18113 | 437 | 29 |
287826 | 287826 | 2020-06-30 | Ohio | Indiana | 18115 | 14 | 0 |
287827 | 287827 | 2020-06-30 | Orange | Indiana | 18117 | 135 | 25 |
287828 | 287828 | 2020-06-30 | Owen | Indiana | 18119 | 43 | 1 |
287829 | 287829 | 2020-06-30 | Parke | Indiana | 18121 | 27 | 0 |
287830 | 287830 | 2020-06-30 | Perry | Indiana | 18123 | 129 | 9 |
287831 | 287831 | 2020-06-30 | Pike | Indiana | 18125 | 6 | 0 |
287832 | 287832 | 2020-06-30 | Porter | Indiana | 18127 | 688 | 38 |
287833 | 287833 | 2020-06-30 | Posey | Indiana | 18129 | 32 | 0 |
287834 | 287834 | 2020-06-30 | Pulaski | Indiana | 18131 | 60 | 1 |
287835 | 287835 | 2020-06-30 | Putnam | Indiana | 18133 | 170 | 8 |
287836 | 287836 | 2020-06-30 | Randolph | Indiana | 18135 | 101 | 4 |
287837 | 287837 | 2020-06-30 | Ripley | Indiana | 18137 | 112 | 7 |
287838 | 287838 | 2020-06-30 | Rush | Indiana | 18139 | 80 | 3 |
287839 | 287839 | 2020-06-30 | Scott | Indiana | 18143 | 158 | 8 |
287840 | 287840 | 2020-06-30 | Shelby | Indiana | 18145 | 637 | 32 |
287841 | 287841 | 2020-06-30 | Spencer | Indiana | 18147 | 33 | 1 |
287842 | 287842 | 2020-06-30 | St. Joseph | Indiana | 18141 | 1840 | 70 |
287843 | 287843 | 2020-06-30 | Starke | Indiana | 18149 | 70 | 4 |
287844 | 287844 | 2020-06-30 | Steuben | Indiana | 18151 | 123 | 2 |
287845 | 287845 | 2020-06-30 | Sullivan | Indiana | 18153 | 47 | 1 |
287846 | 287846 | 2020-06-30 | Switzerland | Indiana | 18155 | 26 | 0 |
287847 | 287847 | 2020-06-30 | Tippecanoe | Indiana | 18157 | 636 | 9 |
287848 | 287848 | 2020-06-30 | Tipton | Indiana | 18159 | 31 | 2 |
287849 | 287849 | 2020-06-30 | Union | Indiana | 18161 | 29 | 0 |
287850 | 287850 | 2020-06-30 | Vanderburgh | Indiana | 18163 | 416 | 6 |
287851 | 287851 | 2020-06-30 | Vermillion | Indiana | 18165 | 14 | 0 |
287852 | 287852 | 2020-06-30 | Vigo | Indiana | 18167 | 223 | 9 |
287853 | 287853 | 2020-06-30 | Wabash | Indiana | 18169 | 109 | 2 |
287854 | 287854 | 2020-06-30 | Warren | Indiana | 18171 | 15 | 1 |
287855 | 287855 | 2020-06-30 | Warrick | Indiana | 18173 | 198 | 31 |
287856 | 287856 | 2020-06-30 | Washington | Indiana | 18175 | 64 | 1 |
287857 | 287857 | 2020-06-30 | Wayne | Indiana | 18177 | 305 | 6 |
287858 | 287858 | 2020-06-30 | Wells | Indiana | 18179 | 84 | 1 |
287859 | 287859 | 2020-06-30 | White | Indiana | 18181 | 257 | 10 |
287860 | 287860 | 2020-06-30 | Whitley | Indiana | 18183 | 79 | 4 |
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);