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-12-05 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
797815 | 797815 | 2020-12-05 | Adams | Indiana | 18001 | 2031 | 26 |
797816 | 797816 | 2020-12-05 | Allen | Indiana | 18003 | 21567 | 366 |
797817 | 797817 | 2020-12-05 | Bartholomew | Indiana | 18005 | 4024 | 73 |
797818 | 797818 | 2020-12-05 | Benton | Indiana | 18007 | 488 | 3 |
797819 | 797819 | 2020-12-05 | Blackford | Indiana | 18009 | 696 | 18 |
797820 | 797820 | 2020-12-05 | Boone | Indiana | 18011 | 2961 | 59 |
797821 | 797821 | 2020-12-05 | Brown | Indiana | 18013 | 451 | 6 |
797822 | 797822 | 2020-12-05 | Carroll | Indiana | 18015 | 851 | 13 |
797823 | 797823 | 2020-12-05 | Cass | Indiana | 18017 | 3321 | 33 |
797824 | 797824 | 2020-12-05 | Clark | Indiana | 18019 | 6014 | 94 |
797825 | 797825 | 2020-12-05 | Clay | Indiana | 18021 | 1450 | 26 |
797826 | 797826 | 2020-12-05 | Clinton | Indiana | 18023 | 2187 | 29 |
797827 | 797827 | 2020-12-05 | Crawford | Indiana | 18025 | 380 | 3 |
797828 | 797828 | 2020-12-05 | Daviess | Indiana | 18027 | 1837 | 56 |
797829 | 797829 | 2020-12-05 | DeKalb | Indiana | 18033 | 2213 | 40 |
797830 | 797830 | 2020-12-05 | Dearborn | Indiana | 18029 | 2671 | 35 |
797831 | 797831 | 2020-12-05 | Decatur | Indiana | 18031 | 1570 | 49 |
797832 | 797832 | 2020-12-05 | Delaware | Indiana | 18035 | 5779 | 113 |
797833 | 797833 | 2020-12-05 | Dubois | Indiana | 18037 | 2912 | 35 |
797834 | 797834 | 2020-12-05 | Elkhart | Indiana | 18039 | 19326 | 261 |
797835 | 797835 | 2020-12-05 | Fayette | Indiana | 18041 | 1822 | 41 |
797836 | 797836 | 2020-12-05 | Floyd | Indiana | 18043 | 3742 | 84 |
797837 | 797837 | 2020-12-05 | Fountain | Indiana | 18045 | 1051 | 9 |
797838 | 797838 | 2020-12-05 | Franklin | Indiana | 18047 | 857 | 29 |
797839 | 797839 | 2020-12-05 | Fulton | Indiana | 18049 | 1021 | 20 |
797840 | 797840 | 2020-12-05 | Gibson | Indiana | 18051 | 2339 | 34 |
797841 | 797841 | 2020-12-05 | Grant | Indiana | 18053 | 3867 | 60 |
797842 | 797842 | 2020-12-05 | Greene | Indiana | 18055 | 1300 | 57 |
797843 | 797843 | 2020-12-05 | Hamilton | Indiana | 18057 | 16325 | 196 |
797844 | 797844 | 2020-12-05 | Hancock | Indiana | 18059 | 3414 | 69 |
797845 | 797845 | 2020-12-05 | Harrison | Indiana | 18061 | 1758 | 28 |
797846 | 797846 | 2020-12-05 | Hendricks | Indiana | 18063 | 7765 | 183 |
797847 | 797847 | 2020-12-05 | Henry | Indiana | 18065 | 2947 | 42 |
797848 | 797848 | 2020-12-05 | Howard | Indiana | 18067 | 4442 | 85 |
797849 | 797849 | 2020-12-05 | Huntington | Indiana | 18069 | 1631 | 12 |
797850 | 797850 | 2020-12-05 | Jackson | Indiana | 18071 | 2777 | 39 |
797851 | 797851 | 2020-12-05 | Jasper | Indiana | 18073 | 1802 | 19 |
797852 | 797852 | 2020-12-05 | Jay | Indiana | 18075 | 1222 | 20 |
797853 | 797853 | 2020-12-05 | Jefferson | Indiana | 18077 | 1466 | 20 |
797854 | 797854 | 2020-12-05 | Jennings | Indiana | 18079 | 1141 | 20 |
797855 | 797855 | 2020-12-05 | Johnson | Indiana | 18081 | 8176 | 188 |
797856 | 797856 | 2020-12-05 | Knox | Indiana | 18083 | 2223 | 24 |
797857 | 797857 | 2020-12-05 | Kosciusko | Indiana | 18085 | 5289 | 53 |
797858 | 797858 | 2020-12-05 | LaGrange | Indiana | 18087 | 1663 | 36 |
797859 | 797859 | 2020-12-05 | LaPorte | Indiana | 18091 | 5465 | 109 |
797860 | 797860 | 2020-12-05 | Lake | Indiana | 18089 | 31603 | 514 |
797861 | 797861 | 2020-12-05 | Lawrence | Indiana | 18093 | 2148 | 54 |
797862 | 797862 | 2020-12-05 | Madison | Indiana | 18095 | 6113 | 141 |
797863 | 797863 | 2020-12-05 | Marion | Indiana | 18097 | 51069 | 967 |
797864 | 797864 | 2020-12-05 | Marshall | Indiana | 18099 | 3566 | 52 |
797865 | 797865 | 2020-12-05 | Martin | Indiana | 18101 | 420 | 6 |
797866 | 797866 | 2020-12-05 | Miami | Indiana | 18103 | 2011 | 19 |
797867 | 797867 | 2020-12-05 | Monroe | Indiana | 18105 | 6242 | 62 |
797868 | 797868 | 2020-12-05 | Montgomery | Indiana | 18107 | 1847 | 31 |
797869 | 797869 | 2020-12-05 | Morgan | Indiana | 18109 | 2750 | 50 |
797870 | 797870 | 2020-12-05 | Newton | Indiana | 18111 | 659 | 18 |
797871 | 797871 | 2020-12-05 | Noble | Indiana | 18113 | 3043 | 52 |
797872 | 797872 | 2020-12-05 | Ohio | Indiana | 18115 | 260 | 7 |
797873 | 797873 | 2020-12-05 | Orange | Indiana | 18117 | 820 | 30 |
797874 | 797874 | 2020-12-05 | Owen | Indiana | 18119 | 780 | 13 |
797875 | 797875 | 2020-12-05 | Parke | Indiana | 18121 | 779 | 6 |
797876 | 797876 | 2020-12-05 | Perry | Indiana | 18123 | 934 | 23 |
797877 | 797877 | 2020-12-05 | Pike | Indiana | 18125 | 624 | 21 |
797878 | 797878 | 2020-12-05 | Porter | Indiana | 18127 | 9730 | 106 |
797879 | 797879 | 2020-12-05 | Posey | Indiana | 18129 | 1400 | 22 |
797880 | 797880 | 2020-12-05 | Pulaski | Indiana | 18131 | 537 | 21 |
797881 | 797881 | 2020-12-05 | Putnam | Indiana | 18133 | 1566 | 32 |
797882 | 797882 | 2020-12-05 | Randolph | Indiana | 18135 | 1512 | 25 |
797883 | 797883 | 2020-12-05 | Ripley | Indiana | 18137 | 1768 | 26 |
797884 | 797884 | 2020-12-05 | Rush | Indiana | 18139 | 748 | 8 |
797885 | 797885 | 2020-12-05 | Scott | Indiana | 18143 | 1377 | 29 |
797886 | 797886 | 2020-12-05 | Shelby | Indiana | 18145 | 2982 | 71 |
797887 | 797887 | 2020-12-05 | Spencer | Indiana | 18147 | 1006 | 8 |
797888 | 797888 | 2020-12-05 | St. Joseph | Indiana | 18141 | 19749 | 270 |
797889 | 797889 | 2020-12-05 | Starke | Indiana | 18149 | 1115 | 30 |
797890 | 797890 | 2020-12-05 | Steuben | Indiana | 18151 | 1767 | 16 |
797891 | 797891 | 2020-12-05 | Sullivan | Indiana | 18153 | 1181 | 18 |
797892 | 797892 | 2020-12-05 | Switzerland | Indiana | 18155 | 304 | 5 |
797893 | 797893 | 2020-12-05 | Tippecanoe | Indiana | 18157 | 10688 | 38 |
797894 | 797894 | 2020-12-05 | Tipton | Indiana | 18159 | 710 | 30 |
797895 | 797895 | 2020-12-05 | Union | Indiana | 18161 | 343 | 2 |
797896 | 797896 | 2020-12-05 | Vanderburgh | Indiana | 18163 | 11436 | 141 |
797897 | 797897 | 2020-12-05 | Vermillion | Indiana | 18165 | 816 | 14 |
797898 | 797898 | 2020-12-05 | Vigo | Indiana | 18167 | 7010 | 114 |
797899 | 797899 | 2020-12-05 | Wabash | Indiana | 18169 | 2055 | 27 |
797900 | 797900 | 2020-12-05 | Warren | Indiana | 18171 | 313 | 4 |
797901 | 797901 | 2020-12-05 | Warrick | Indiana | 18173 | 3806 | 78 |
797902 | 797902 | 2020-12-05 | Washington | Indiana | 18175 | 940 | 9 |
797903 | 797903 | 2020-12-05 | Wayne | Indiana | 18177 | 4186 | 101 |
797904 | 797904 | 2020-12-05 | Wells | Indiana | 18179 | 1544 | 40 |
797905 | 797905 | 2020-12-05 | White | Indiana | 18181 | 1593 | 24 |
797906 | 797906 | 2020-12-05 | Whitley | Indiana | 18183 | 1706 | 17 |
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);