ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-01-31" 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 |
---|---|---|---|---|---|---|---|
982801 | 982801 | 2021-01-31 | Adams | Indiana | 18001 | 3087 | 38 |
982802 | 982802 | 2021-01-31 | Allen | Indiana | 18003 | 33740 | 588 |
982803 | 982803 | 2021-01-31 | Bartholomew | Indiana | 18005 | 6855 | 110 |
982804 | 982804 | 2021-01-31 | Benton | Indiana | 18007 | 888 | 10 |
982805 | 982805 | 2021-01-31 | Blackford | Indiana | 18009 | 1151 | 23 |
982806 | 982806 | 2021-01-31 | Boone | Indiana | 18011 | 5731 | 73 |
982807 | 982807 | 2021-01-31 | Brown | Indiana | 18013 | 905 | 35 |
982808 | 982808 | 2021-01-31 | Carroll | Indiana | 18015 | 1660 | 17 |
982809 | 982809 | 2021-01-31 | Cass | Indiana | 18017 | 5034 | 65 |
982810 | 982810 | 2021-01-31 | Clark | Indiana | 18019 | 11177 | 157 |
982811 | 982811 | 2021-01-31 | Clay | Indiana | 18021 | 2285 | 32 |
982812 | 982812 | 2021-01-31 | Clinton | Indiana | 18023 | 3819 | 49 |
982813 | 982813 | 2021-01-31 | Crawford | Indiana | 18025 | 834 | 10 |
982814 | 982814 | 2021-01-31 | Daviess | Indiana | 18027 | 2765 | 79 |
982815 | 982815 | 2021-01-31 | DeKalb | Indiana | 18033 | 3595 | 69 |
982816 | 982816 | 2021-01-31 | Dearborn | Indiana | 18029 | 5042 | 49 |
982817 | 982817 | 2021-01-31 | Decatur | Indiana | 18031 | 2599 | 87 |
982818 | 982818 | 2021-01-31 | Delaware | Indiana | 18035 | 9407 | 140 |
982819 | 982819 | 2021-01-31 | Dubois | Indiana | 18037 | 5665 | 83 |
982820 | 982820 | 2021-01-31 | Elkhart | Indiana | 18039 | 24783 | 361 |
982821 | 982821 | 2021-01-31 | Fayette | Indiana | 18041 | 2689 | 51 |
982822 | 982822 | 2021-01-31 | Floyd | Indiana | 18043 | 6692 | 123 |
982823 | 982823 | 2021-01-31 | Fountain | Indiana | 18045 | 1903 | 28 |
982824 | 982824 | 2021-01-31 | Franklin | Indiana | 18047 | 1551 | 34 |
982825 | 982825 | 2021-01-31 | Fulton | Indiana | 18049 | 1683 | 30 |
982826 | 982826 | 2021-01-31 | Gibson | Indiana | 18051 | 3861 | 62 |
982827 | 982827 | 2021-01-31 | Grant | Indiana | 18053 | 6562 | 128 |
982828 | 982828 | 2021-01-31 | Greene | Indiana | 18055 | 2487 | 67 |
982829 | 982829 | 2021-01-31 | Hamilton | Indiana | 18057 | 30330 | 338 |
982830 | 982830 | 2021-01-31 | Hancock | Indiana | 18059 | 6991 | 111 |
982831 | 982831 | 2021-01-31 | Harrison | Indiana | 18061 | 3659 | 50 |
982832 | 982832 | 2021-01-31 | Hendricks | Indiana | 18063 | 14946 | 280 |
982833 | 982833 | 2021-01-31 | Henry | Indiana | 18065 | 5222 | 68 |
982834 | 982834 | 2021-01-31 | Howard | Indiana | 18067 | 8589 | 156 |
982835 | 982835 | 2021-01-31 | Huntington | Indiana | 18069 | 3065 | 63 |
982836 | 982836 | 2021-01-31 | Jackson | Indiana | 18071 | 4389 | 49 |
982837 | 982837 | 2021-01-31 | Jasper | Indiana | 18073 | 2989 | 37 |
982838 | 982838 | 2021-01-31 | Jay | Indiana | 18075 | 1730 | 25 |
982839 | 982839 | 2021-01-31 | Jefferson | Indiana | 18077 | 2753 | 42 |
982840 | 982840 | 2021-01-31 | Jennings | Indiana | 18079 | 2048 | 40 |
982841 | 982841 | 2021-01-31 | Johnson | Indiana | 18081 | 15600 | 309 |
982842 | 982842 | 2021-01-31 | Knox | Indiana | 18083 | 3433 | 39 |
982843 | 982843 | 2021-01-31 | Kosciusko | Indiana | 18085 | 8222 | 88 |
982844 | 982844 | 2021-01-31 | LaGrange | Indiana | 18087 | 2350 | 64 |
982845 | 982845 | 2021-01-31 | LaPorte | Indiana | 18091 | 9376 | 173 |
982846 | 982846 | 2021-01-31 | Lake | Indiana | 18089 | 46513 | 727 |
982847 | 982847 | 2021-01-31 | Lawrence | Indiana | 18093 | 4015 | 84 |
982848 | 982848 | 2021-01-31 | Madison | Indiana | 18095 | 11301 | 247 |
982849 | 982849 | 2021-01-31 | Marion | Indiana | 18097 | 86603 | 1423 |
982850 | 982850 | 2021-01-31 | Marshall | Indiana | 18099 | 5172 | 84 |
982851 | 982851 | 2021-01-31 | Martin | Indiana | 18101 | 769 | 13 |
982852 | 982852 | 2021-01-31 | Miami | Indiana | 18103 | 3345 | 48 |
982853 | 982853 | 2021-01-31 | Monroe | Indiana | 18105 | 9690 | 119 |
982854 | 982854 | 2021-01-31 | Montgomery | Indiana | 18107 | 3582 | 57 |
982855 | 982855 | 2021-01-31 | Morgan | Indiana | 18109 | 5681 | 105 |
982856 | 982856 | 2021-01-31 | Newton | Indiana | 18111 | 947 | 23 |
982857 | 982857 | 2021-01-31 | Noble | Indiana | 18113 | 4835 | 62 |
982858 | 982858 | 2021-01-31 | Ohio | Indiana | 18115 | 506 | 7 |
982859 | 982859 | 2021-01-31 | Orange | Indiana | 18117 | 1662 | 37 |
982860 | 982860 | 2021-01-31 | Owen | Indiana | 18119 | 1735 | 40 |
982861 | 982861 | 2021-01-31 | Parke | Indiana | 18121 | 1350 | 9 |
982862 | 982862 | 2021-01-31 | Perry | Indiana | 18123 | 1649 | 34 |
982863 | 982863 | 2021-01-31 | Pike | Indiana | 18125 | 1228 | 28 |
982864 | 982864 | 2021-01-31 | Porter | Indiana | 18127 | 15208 | 189 |
982865 | 982865 | 2021-01-31 | Posey | Indiana | 18129 | 2465 | 28 |
982866 | 982866 | 2021-01-31 | Pulaski | Indiana | 18131 | 1000 | 38 |
982867 | 982867 | 2021-01-31 | Putnam | Indiana | 18133 | 3051 | 54 |
982868 | 982868 | 2021-01-31 | Randolph | Indiana | 18135 | 2223 | 49 |
982869 | 982869 | 2021-01-31 | Ripley | Indiana | 18137 | 3075 | 48 |
982870 | 982870 | 2021-01-31 | Rush | Indiana | 18139 | 1650 | 18 |
982871 | 982871 | 2021-01-31 | Scott | Indiana | 18143 | 2335 | 43 |
982872 | 982872 | 2021-01-31 | Shelby | Indiana | 18145 | 5216 | 92 |
982873 | 982873 | 2021-01-31 | Spencer | Indiana | 18147 | 2015 | 25 |
982874 | 982874 | 2021-01-31 | St. Joseph | Indiana | 18141 | 27992 | 412 |
982875 | 982875 | 2021-01-31 | Starke | Indiana | 18149 | 1807 | 47 |
982876 | 982876 | 2021-01-31 | Steuben | Indiana | 18151 | 3193 | 47 |
982877 | 982877 | 2021-01-31 | Sullivan | Indiana | 18153 | 1969 | 33 |
982878 | 982878 | 2021-01-31 | Switzerland | Indiana | 18155 | 700 | 5 |
982879 | 982879 | 2021-01-31 | Tippecanoe | Indiana | 18157 | 18513 | 151 |
982880 | 982880 | 2021-01-31 | Tipton | Indiana | 18159 | 1382 | 36 |
982881 | 982881 | 2021-01-31 | Union | Indiana | 18161 | 663 | 7 |
982882 | 982882 | 2021-01-31 | Vanderburgh | Indiana | 18163 | 20131 | 264 |
982883 | 982883 | 2021-01-31 | Vermillion | Indiana | 18165 | 1532 | 35 |
982884 | 982884 | 2021-01-31 | Vigo | Indiana | 18167 | 11021 | 193 |
982885 | 982885 | 2021-01-31 | Wabash | Indiana | 18169 | 3131 | 51 |
982886 | 982886 | 2021-01-31 | Warren | Indiana | 18171 | 706 | 8 |
982887 | 982887 | 2021-01-31 | Warrick | Indiana | 18173 | 6993 | 106 |
982888 | 982888 | 2021-01-31 | Washington | Indiana | 18175 | 1947 | 23 |
982889 | 982889 | 2021-01-31 | Wayne | Indiana | 18177 | 6713 | 170 |
982890 | 982890 | 2021-01-31 | Wells | Indiana | 18179 | 2423 | 56 |
982891 | 982891 | 2021-01-31 | White | Indiana | 18181 | 2795 | 43 |
982892 | 982892 | 2021-01-31 | Whitley | Indiana | 18183 | 3219 | 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);