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-04-15 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
59809 | 59809 | 2020-04-15 | Adams | Indiana | 18001 | 6 | 1 |
59810 | 59810 | 2020-04-15 | Allen | Indiana | 18003 | 182 | 17 |
59811 | 59811 | 2020-04-15 | Bartholomew | Indiana | 18005 | 115 | 6 |
59812 | 59812 | 2020-04-15 | Benton | Indiana | 18007 | 3 | 0 |
59813 | 59813 | 2020-04-15 | Blackford | Indiana | 18009 | 6 | 1 |
59814 | 59814 | 2020-04-15 | Boone | Indiana | 18011 | 130 | 5 |
59815 | 59815 | 2020-04-15 | Brown | Indiana | 18013 | 14 | 1 |
59816 | 59816 | 2020-04-15 | Carroll | Indiana | 18015 | 6 | 1 |
59817 | 59817 | 2020-04-15 | Cass | Indiana | 18017 | 34 | 2 |
59818 | 59818 | 2020-04-15 | Clark | Indiana | 18019 | 138 | 10 |
59819 | 59819 | 2020-04-15 | Clay | Indiana | 18021 | 13 | 0 |
59820 | 59820 | 2020-04-15 | Clinton | Indiana | 18023 | 14 | 2 |
59821 | 59821 | 2020-04-15 | Crawford | Indiana | 18025 | 13 | 1 |
59822 | 59822 | 2020-04-15 | Daviess | Indiana | 18027 | 21 | 1 |
59823 | 59823 | 2020-04-15 | DeKalb | Indiana | 18033 | 6 | 1 |
59824 | 59824 | 2020-04-15 | Dearborn | Indiana | 18029 | 61 | 4 |
59825 | 59825 | 2020-04-15 | Decatur | Indiana | 18031 | 158 | 16 |
59826 | 59826 | 2020-04-15 | Delaware | Indiana | 18035 | 77 | 4 |
59827 | 59827 | 2020-04-15 | Dubois | Indiana | 18037 | 14 | 0 |
59828 | 59828 | 2020-04-15 | Elkhart | Indiana | 18039 | 105 | 3 |
59829 | 59829 | 2020-04-15 | Fayette | Indiana | 18041 | 20 | 3 |
59830 | 59830 | 2020-04-15 | Floyd | Indiana | 18043 | 116 | 5 |
59831 | 59831 | 2020-04-15 | Fountain | Indiana | 18045 | 3 | 1 |
59832 | 59832 | 2020-04-15 | Franklin | Indiana | 18047 | 75 | 7 |
59833 | 59833 | 2020-04-15 | Fulton | Indiana | 18049 | 3 | 0 |
59834 | 59834 | 2020-04-15 | Gibson | Indiana | 18051 | 4 | 0 |
59835 | 59835 | 2020-04-15 | Grant | Indiana | 18053 | 42 | 3 |
59836 | 59836 | 2020-04-15 | Greene | Indiana | 18055 | 29 | 3 |
59837 | 59837 | 2020-04-15 | Hamilton | Indiana | 18057 | 511 | 28 |
59838 | 59838 | 2020-04-15 | Hancock | Indiana | 18059 | 130 | 7 |
59839 | 59839 | 2020-04-15 | Harrison | Indiana | 18061 | 59 | 2 |
59840 | 59840 | 2020-04-15 | Hendricks | Indiana | 18063 | 367 | 19 |
59841 | 59841 | 2020-04-15 | Henry | Indiana | 18065 | 23 | 1 |
59842 | 59842 | 2020-04-15 | Howard | Indiana | 18067 | 61 | 5 |
59843 | 59843 | 2020-04-15 | Huntington | Indiana | 18069 | 6 | 1 |
59844 | 59844 | 2020-04-15 | Jackson | Indiana | 18071 | 74 | 0 |
59845 | 59845 | 2020-04-15 | Jasper | Indiana | 18073 | 19 | 1 |
59846 | 59846 | 2020-04-15 | Jay | Indiana | 18075 | 7 | 0 |
59847 | 59847 | 2020-04-15 | Jefferson | Indiana | 18077 | 15 | 0 |
59848 | 59848 | 2020-04-15 | Jennings | Indiana | 18079 | 62 | 2 |
59849 | 59849 | 2020-04-15 | Johnson | Indiana | 18081 | 349 | 27 |
59850 | 59850 | 2020-04-15 | Knox | Indiana | 18083 | 16 | 0 |
59851 | 59851 | 2020-04-15 | Kosciusko | Indiana | 18085 | 19 | 1 |
59852 | 59852 | 2020-04-15 | LaGrange | Indiana | 18087 | 14 | 1 |
59853 | 59853 | 2020-04-15 | LaPorte | Indiana | 18091 | 42 | 4 |
59854 | 59854 | 2020-04-15 | Lake | Indiana | 18089 | 880 | 37 |
59855 | 59855 | 2020-04-15 | Lawrence | Indiana | 18093 | 74 | 10 |
59856 | 59856 | 2020-04-15 | Madison | Indiana | 18095 | 281 | 32 |
59857 | 59857 | 2020-04-15 | Marion | Indiana | 18097 | 3224 | 175 |
59858 | 59858 | 2020-04-15 | Marshall | Indiana | 18099 | 19 | 0 |
59859 | 59859 | 2020-04-15 | Martin | Indiana | 18101 | 5 | 0 |
59860 | 59860 | 2020-04-15 | Miami | Indiana | 18103 | 17 | 0 |
59861 | 59861 | 2020-04-15 | Monroe | Indiana | 18105 | 95 | 2 |
59862 | 59862 | 2020-04-15 | Montgomery | Indiana | 18107 | 25 | 0 |
59863 | 59863 | 2020-04-15 | Morgan | Indiana | 18109 | 106 | 4 |
59864 | 59864 | 2020-04-15 | Newton | Indiana | 18111 | 30 | 3 |
59865 | 59865 | 2020-04-15 | Noble | Indiana | 18113 | 25 | 1 |
59866 | 59866 | 2020-04-15 | Ohio | Indiana | 18115 | 1 | 0 |
59867 | 59867 | 2020-04-15 | Orange | Indiana | 18117 | 19 | 3 |
59868 | 59868 | 2020-04-15 | Owen | Indiana | 18119 | 19 | 1 |
59869 | 59869 | 2020-04-15 | Parke | Indiana | 18121 | 7 | 0 |
59870 | 59870 | 2020-04-15 | Perry | Indiana | 18123 | 4 | 0 |
59871 | 59871 | 2020-04-15 | Pike | Indiana | 18125 | 1 | 0 |
59872 | 59872 | 2020-04-15 | Porter | Indiana | 18127 | 131 | 3 |
59873 | 59873 | 2020-04-15 | Posey | Indiana | 18129 | 6 | 0 |
59874 | 59874 | 2020-04-15 | Pulaski | Indiana | 18131 | 1 | 0 |
59875 | 59875 | 2020-04-15 | Putnam | Indiana | 18133 | 42 | 3 |
59876 | 59876 | 2020-04-15 | Randolph | Indiana | 18135 | 11 | 1 |
59877 | 59877 | 2020-04-15 | Ripley | Indiana | 18137 | 88 | 3 |
59878 | 59878 | 2020-04-15 | Rush | Indiana | 18139 | 17 | 1 |
59879 | 59879 | 2020-04-15 | Scott | Indiana | 18143 | 17 | 2 |
59880 | 59880 | 2020-04-15 | Shelby | Indiana | 18145 | 85 | 9 |
59881 | 59881 | 2020-04-15 | Spencer | Indiana | 18147 | 4 | 0 |
59882 | 59882 | 2020-04-15 | St. Joseph | Indiana | 18141 | 276 | 8 |
59883 | 59883 | 2020-04-15 | Starke | Indiana | 18149 | 10 | 1 |
59884 | 59884 | 2020-04-15 | Steuben | Indiana | 18151 | 13 | 1 |
59885 | 59885 | 2020-04-15 | Sullivan | Indiana | 18153 | 6 | 0 |
59886 | 59886 | 2020-04-15 | Switzerland | Indiana | 18155 | 12 | 0 |
59887 | 59887 | 2020-04-15 | Tippecanoe | Indiana | 18157 | 46 | 2 |
59888 | 59888 | 2020-04-15 | Tipton | Indiana | 18159 | 10 | 0 |
59889 | 59889 | 2020-04-15 | Union | Indiana | 18161 | 6 | 0 |
59890 | 59890 | 2020-04-15 | Vanderburgh | Indiana | 18163 | 65 | 1 |
59891 | 59891 | 2020-04-15 | Vermillion | Indiana | 18165 | 4 | 0 |
59892 | 59892 | 2020-04-15 | Vigo | Indiana | 18167 | 44 | 4 |
59893 | 59893 | 2020-04-15 | Wabash | Indiana | 18169 | 7 | 0 |
59894 | 59894 | 2020-04-15 | Warren | Indiana | 18171 | 3 | 1 |
59895 | 59895 | 2020-04-15 | Warrick | Indiana | 18173 | 42 | 4 |
59896 | 59896 | 2020-04-15 | Washington | Indiana | 18175 | 27 | 0 |
59897 | 59897 | 2020-04-15 | Wayne | Indiana | 18177 | 20 | 1 |
59898 | 59898 | 2020-04-15 | Wells | Indiana | 18179 | 4 | 0 |
59899 | 59899 | 2020-04-15 | White | Indiana | 18181 | 5 | 0 |
59900 | 59900 | 2020-04-15 | Whitley | Indiana | 18183 | 14 | 1 |
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);