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 2021-01-23 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
956839 | 956839 | 2021-01-23 | Adams | Indiana | 18001 | 3010 | 37 |
956840 | 956840 | 2021-01-23 | Allen | Indiana | 18003 | 32852 | 571 |
956841 | 956841 | 2021-01-23 | Bartholomew | Indiana | 18005 | 6503 | 106 |
956842 | 956842 | 2021-01-23 | Benton | Indiana | 18007 | 866 | 10 |
956843 | 956843 | 2021-01-23 | Blackford | Indiana | 18009 | 1121 | 22 |
956844 | 956844 | 2021-01-23 | Boone | Indiana | 18011 | 5530 | 72 |
956845 | 956845 | 2021-01-23 | Brown | Indiana | 18013 | 880 | 35 |
956846 | 956846 | 2021-01-23 | Carroll | Indiana | 18015 | 1581 | 16 |
956847 | 956847 | 2021-01-23 | Cass | Indiana | 18017 | 4835 | 64 |
956848 | 956848 | 2021-01-23 | Clark | Indiana | 18019 | 10698 | 152 |
956849 | 956849 | 2021-01-23 | Clay | Indiana | 18021 | 2225 | 32 |
956850 | 956850 | 2021-01-23 | Clinton | Indiana | 18023 | 3734 | 47 |
956851 | 956851 | 2021-01-23 | Crawford | Indiana | 18025 | 801 | 10 |
956852 | 956852 | 2021-01-23 | Daviess | Indiana | 18027 | 2707 | 77 |
956853 | 956853 | 2021-01-23 | DeKalb | Indiana | 18033 | 3476 | 68 |
956854 | 956854 | 2021-01-23 | Dearborn | Indiana | 18029 | 4806 | 47 |
956855 | 956855 | 2021-01-23 | Decatur | Indiana | 18031 | 2528 | 87 |
956856 | 956856 | 2021-01-23 | Delaware | Indiana | 18035 | 9128 | 138 |
956857 | 956857 | 2021-01-23 | Dubois | Indiana | 18037 | 5556 | 80 |
956858 | 956858 | 2021-01-23 | Elkhart | Indiana | 18039 | 24502 | 357 |
956859 | 956859 | 2021-01-23 | Fayette | Indiana | 18041 | 2605 | 49 |
956860 | 956860 | 2021-01-23 | Floyd | Indiana | 18043 | 6439 | 115 |
956861 | 956861 | 2021-01-23 | Fountain | Indiana | 18045 | 1842 | 28 |
956862 | 956862 | 2021-01-23 | Franklin | Indiana | 18047 | 1500 | 34 |
956863 | 956863 | 2021-01-23 | Fulton | Indiana | 18049 | 1641 | 30 |
956864 | 956864 | 2021-01-23 | Gibson | Indiana | 18051 | 3707 | 61 |
956865 | 956865 | 2021-01-23 | Grant | Indiana | 18053 | 6401 | 120 |
956866 | 956866 | 2021-01-23 | Greene | Indiana | 18055 | 2406 | 65 |
956867 | 956867 | 2021-01-23 | Hamilton | Indiana | 18057 | 29436 | 330 |
956868 | 956868 | 2021-01-23 | Hancock | Indiana | 18059 | 6719 | 107 |
956869 | 956869 | 2021-01-23 | Harrison | Indiana | 18061 | 3484 | 46 |
956870 | 956870 | 2021-01-23 | Hendricks | Indiana | 18063 | 14454 | 268 |
956871 | 956871 | 2021-01-23 | Henry | Indiana | 18065 | 5092 | 65 |
956872 | 956872 | 2021-01-23 | Howard | Indiana | 18067 | 8246 | 147 |
956873 | 956873 | 2021-01-23 | Huntington | Indiana | 18069 | 2919 | 59 |
956874 | 956874 | 2021-01-23 | Jackson | Indiana | 18071 | 4254 | 48 |
956875 | 956875 | 2021-01-23 | Jasper | Indiana | 18073 | 2894 | 36 |
956876 | 956876 | 2021-01-23 | Jay | Indiana | 18075 | 1685 | 25 |
956877 | 956877 | 2021-01-23 | Jefferson | Indiana | 18077 | 2637 | 42 |
956878 | 956878 | 2021-01-23 | Jennings | Indiana | 18079 | 1993 | 38 |
956879 | 956879 | 2021-01-23 | Johnson | Indiana | 18081 | 15126 | 306 |
956880 | 956880 | 2021-01-23 | Knox | Indiana | 18083 | 3359 | 39 |
956881 | 956881 | 2021-01-23 | Kosciusko | Indiana | 18085 | 8088 | 86 |
956882 | 956882 | 2021-01-23 | LaGrange | Indiana | 18087 | 2293 | 63 |
956883 | 956883 | 2021-01-23 | LaPorte | Indiana | 18091 | 9074 | 166 |
956884 | 956884 | 2021-01-23 | Lake | Indiana | 18089 | 45419 | 712 |
956885 | 956885 | 2021-01-23 | Lawrence | Indiana | 18093 | 3913 | 82 |
956886 | 956886 | 2021-01-23 | Madison | Indiana | 18095 | 10993 | 238 |
956887 | 956887 | 2021-01-23 | Marion | Indiana | 18097 | 84245 | 1398 |
956888 | 956888 | 2021-01-23 | Marshall | Indiana | 18099 | 5041 | 84 |
956889 | 956889 | 2021-01-23 | Martin | Indiana | 18101 | 738 | 13 |
956890 | 956890 | 2021-01-23 | Miami | Indiana | 18103 | 3220 | 45 |
956891 | 956891 | 2021-01-23 | Monroe | Indiana | 18105 | 9388 | 114 |
956892 | 956892 | 2021-01-23 | Montgomery | Indiana | 18107 | 3459 | 55 |
956893 | 956893 | 2021-01-23 | Morgan | Indiana | 18109 | 5427 | 100 |
956894 | 956894 | 2021-01-23 | Newton | Indiana | 18111 | 911 | 23 |
956895 | 956895 | 2021-01-23 | Noble | Indiana | 18113 | 4734 | 62 |
956896 | 956896 | 2021-01-23 | Ohio | Indiana | 18115 | 490 | 7 |
956897 | 956897 | 2021-01-23 | Orange | Indiana | 18117 | 1598 | 36 |
956898 | 956898 | 2021-01-23 | Owen | Indiana | 18119 | 1660 | 39 |
956899 | 956899 | 2021-01-23 | Parke | Indiana | 18121 | 1321 | 8 |
956900 | 956900 | 2021-01-23 | Perry | Indiana | 18123 | 1552 | 30 |
956901 | 956901 | 2021-01-23 | Pike | Indiana | 18125 | 1171 | 28 |
956902 | 956902 | 2021-01-23 | Porter | Indiana | 18127 | 14806 | 182 |
956903 | 956903 | 2021-01-23 | Posey | Indiana | 18129 | 2393 | 28 |
956904 | 956904 | 2021-01-23 | Pulaski | Indiana | 18131 | 971 | 37 |
956905 | 956905 | 2021-01-23 | Putnam | Indiana | 18133 | 2977 | 50 |
956906 | 956906 | 2021-01-23 | Randolph | Indiana | 18135 | 2177 | 49 |
956907 | 956907 | 2021-01-23 | Ripley | Indiana | 18137 | 2986 | 45 |
956908 | 956908 | 2021-01-23 | Rush | Indiana | 18139 | 1612 | 18 |
956909 | 956909 | 2021-01-23 | Scott | Indiana | 18143 | 2260 | 41 |
956910 | 956910 | 2021-01-23 | Shelby | Indiana | 18145 | 5046 | 91 |
956911 | 956911 | 2021-01-23 | Spencer | Indiana | 18147 | 1916 | 21 |
956912 | 956912 | 2021-01-23 | St. Joseph | Indiana | 18141 | 27415 | 401 |
956913 | 956913 | 2021-01-23 | Starke | Indiana | 18149 | 1758 | 46 |
956914 | 956914 | 2021-01-23 | Steuben | Indiana | 18151 | 3142 | 46 |
956915 | 956915 | 2021-01-23 | Sullivan | Indiana | 18153 | 1927 | 33 |
956916 | 956916 | 2021-01-23 | Switzerland | Indiana | 18155 | 662 | 5 |
956917 | 956917 | 2021-01-23 | Tippecanoe | Indiana | 18157 | 17974 | 139 |
956918 | 956918 | 2021-01-23 | Tipton | Indiana | 18159 | 1328 | 35 |
956919 | 956919 | 2021-01-23 | Union | Indiana | 18161 | 655 | 7 |
956920 | 956920 | 2021-01-23 | Vanderburgh | Indiana | 18163 | 19419 | 253 |
956921 | 956921 | 2021-01-23 | Vermillion | Indiana | 18165 | 1492 | 34 |
956922 | 956922 | 2021-01-23 | Vigo | Indiana | 18167 | 10738 | 186 |
956923 | 956923 | 2021-01-23 | Wabash | Indiana | 18169 | 3037 | 51 |
956924 | 956924 | 2021-01-23 | Warren | Indiana | 18171 | 683 | 8 |
956925 | 956925 | 2021-01-23 | Warrick | Indiana | 18173 | 6731 | 101 |
956926 | 956926 | 2021-01-23 | Washington | Indiana | 18175 | 1864 | 23 |
956927 | 956927 | 2021-01-23 | Wayne | Indiana | 18177 | 6528 | 165 |
956928 | 956928 | 2021-01-23 | Wells | Indiana | 18179 | 2385 | 54 |
956929 | 956929 | 2021-01-23 | White | Indiana | 18181 | 2732 | 43 |
956930 | 956930 | 2021-01-23 | Whitley | Indiana | 18183 | 3073 | 26 |
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);