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-09 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
810795 | 810795 | 2020-12-09 | Adams | Indiana | 18001 | 2144 | 28 |
810796 | 810796 | 2020-12-09 | Allen | Indiana | 18003 | 22780 | 395 |
810797 | 810797 | 2020-12-09 | Bartholomew | Indiana | 18005 | 4271 | 73 |
810798 | 810798 | 2020-12-09 | Benton | Indiana | 18007 | 535 | 3 |
810799 | 810799 | 2020-12-09 | Blackford | Indiana | 18009 | 723 | 19 |
810800 | 810800 | 2020-12-09 | Boone | Indiana | 18011 | 3236 | 59 |
810801 | 810801 | 2020-12-09 | Brown | Indiana | 18013 | 485 | 8 |
810802 | 810802 | 2020-12-09 | Carroll | Indiana | 18015 | 935 | 13 |
810803 | 810803 | 2020-12-09 | Cass | Indiana | 18017 | 3466 | 35 |
810804 | 810804 | 2020-12-09 | Clark | Indiana | 18019 | 6393 | 98 |
810805 | 810805 | 2020-12-09 | Clay | Indiana | 18021 | 1525 | 27 |
810806 | 810806 | 2020-12-09 | Clinton | Indiana | 18023 | 2350 | 31 |
810807 | 810807 | 2020-12-09 | Crawford | Indiana | 18025 | 423 | 7 |
810808 | 810808 | 2020-12-09 | Daviess | Indiana | 18027 | 1911 | 59 |
810809 | 810809 | 2020-12-09 | DeKalb | Indiana | 18033 | 2368 | 41 |
810810 | 810810 | 2020-12-09 | Dearborn | Indiana | 18029 | 2883 | 39 |
810811 | 810811 | 2020-12-09 | Decatur | Indiana | 18031 | 1674 | 49 |
810812 | 810812 | 2020-12-09 | Delaware | Indiana | 18035 | 6094 | 114 |
810813 | 810813 | 2020-12-09 | Dubois | Indiana | 18037 | 3067 | 35 |
810814 | 810814 | 2020-12-09 | Elkhart | Indiana | 18039 | 20004 | 279 |
810815 | 810815 | 2020-12-09 | Fayette | Indiana | 18041 | 1924 | 42 |
810816 | 810816 | 2020-12-09 | Floyd | Indiana | 18043 | 3956 | 85 |
810817 | 810817 | 2020-12-09 | Fountain | Indiana | 18045 | 1120 | 11 |
810818 | 810818 | 2020-12-09 | Franklin | Indiana | 18047 | 926 | 29 |
810819 | 810819 | 2020-12-09 | Fulton | Indiana | 18049 | 1078 | 21 |
810820 | 810820 | 2020-12-09 | Gibson | Indiana | 18051 | 2435 | 39 |
810821 | 810821 | 2020-12-09 | Grant | Indiana | 18053 | 4128 | 64 |
810822 | 810822 | 2020-12-09 | Greene | Indiana | 18055 | 1412 | 57 |
810823 | 810823 | 2020-12-09 | Hamilton | Indiana | 18057 | 17542 | 211 |
810824 | 810824 | 2020-12-09 | Hancock | Indiana | 18059 | 3683 | 72 |
810825 | 810825 | 2020-12-09 | Harrison | Indiana | 18061 | 1906 | 30 |
810826 | 810826 | 2020-12-09 | Hendricks | Indiana | 18063 | 8292 | 188 |
810827 | 810827 | 2020-12-09 | Henry | Indiana | 18065 | 3109 | 43 |
810828 | 810828 | 2020-12-09 | Howard | Indiana | 18067 | 4851 | 89 |
810829 | 810829 | 2020-12-09 | Huntington | Indiana | 18069 | 1741 | 15 |
810830 | 810830 | 2020-12-09 | Jackson | Indiana | 18071 | 2985 | 42 |
810831 | 810831 | 2020-12-09 | Jasper | Indiana | 18073 | 1932 | 22 |
810832 | 810832 | 2020-12-09 | Jay | Indiana | 18075 | 1291 | 21 |
810833 | 810833 | 2020-12-09 | Jefferson | Indiana | 18077 | 1555 | 20 |
810834 | 810834 | 2020-12-09 | Jennings | Indiana | 18079 | 1248 | 24 |
810835 | 810835 | 2020-12-09 | Johnson | Indiana | 18081 | 8822 | 194 |
810836 | 810836 | 2020-12-09 | Knox | Indiana | 18083 | 2339 | 29 |
810837 | 810837 | 2020-12-09 | Kosciusko | Indiana | 18085 | 5649 | 57 |
810838 | 810838 | 2020-12-09 | LaGrange | Indiana | 18087 | 1730 | 40 |
810839 | 810839 | 2020-12-09 | LaPorte | Indiana | 18091 | 5789 | 112 |
810840 | 810840 | 2020-12-09 | Lake | Indiana | 18089 | 33140 | 528 |
810841 | 810841 | 2020-12-09 | Lawrence | Indiana | 18093 | 2321 | 56 |
810842 | 810842 | 2020-12-09 | Madison | Indiana | 18095 | 6642 | 144 |
810843 | 810843 | 2020-12-09 | Marion | Indiana | 18097 | 54387 | 990 |
810844 | 810844 | 2020-12-09 | Marshall | Indiana | 18099 | 3730 | 57 |
810845 | 810845 | 2020-12-09 | Martin | Indiana | 18101 | 439 | 7 |
810846 | 810846 | 2020-12-09 | Miami | Indiana | 18103 | 2140 | 21 |
810847 | 810847 | 2020-12-09 | Monroe | Indiana | 18105 | 6591 | 66 |
810848 | 810848 | 2020-12-09 | Montgomery | Indiana | 18107 | 1984 | 33 |
810849 | 810849 | 2020-12-09 | Morgan | Indiana | 18109 | 3025 | 54 |
810850 | 810850 | 2020-12-09 | Newton | Indiana | 18111 | 676 | 18 |
810851 | 810851 | 2020-12-09 | Noble | Indiana | 18113 | 3243 | 53 |
810852 | 810852 | 2020-12-09 | Ohio | Indiana | 18115 | 274 | 7 |
810853 | 810853 | 2020-12-09 | Orange | Indiana | 18117 | 873 | 30 |
810854 | 810854 | 2020-12-09 | Owen | Indiana | 18119 | 883 | 15 |
810855 | 810855 | 2020-12-09 | Parke | Indiana | 18121 | 902 | 6 |
810856 | 810856 | 2020-12-09 | Perry | Indiana | 18123 | 969 | 23 |
810857 | 810857 | 2020-12-09 | Pike | Indiana | 18125 | 661 | 21 |
810858 | 810858 | 2020-12-09 | Porter | Indiana | 18127 | 10215 | 112 |
810859 | 810859 | 2020-12-09 | Posey | Indiana | 18129 | 1494 | 22 |
810860 | 810860 | 2020-12-09 | Pulaski | Indiana | 18131 | 586 | 24 |
810861 | 810861 | 2020-12-09 | Putnam | Indiana | 18133 | 1718 | 33 |
810862 | 810862 | 2020-12-09 | Randolph | Indiana | 18135 | 1602 | 27 |
810863 | 810863 | 2020-12-09 | Ripley | Indiana | 18137 | 1897 | 27 |
810864 | 810864 | 2020-12-09 | Rush | Indiana | 18139 | 801 | 8 |
810865 | 810865 | 2020-12-09 | Scott | Indiana | 18143 | 1484 | 31 |
810866 | 810866 | 2020-12-09 | Shelby | Indiana | 18145 | 3215 | 74 |
810867 | 810867 | 2020-12-09 | Spencer | Indiana | 18147 | 1061 | 9 |
810868 | 810868 | 2020-12-09 | St. Joseph | Indiana | 18141 | 20636 | 287 |
810869 | 810869 | 2020-12-09 | Starke | Indiana | 18149 | 1204 | 30 |
810870 | 810870 | 2020-12-09 | Steuben | Indiana | 18151 | 1924 | 16 |
810871 | 810871 | 2020-12-09 | Sullivan | Indiana | 18153 | 1311 | 21 |
810872 | 810872 | 2020-12-09 | Switzerland | Indiana | 18155 | 331 | 5 |
810873 | 810873 | 2020-12-09 | Tippecanoe | Indiana | 18157 | 11441 | 42 |
810874 | 810874 | 2020-12-09 | Tipton | Indiana | 18159 | 760 | 32 |
810875 | 810875 | 2020-12-09 | Union | Indiana | 18161 | 356 | 2 |
810876 | 810876 | 2020-12-09 | Vanderburgh | Indiana | 18163 | 12033 | 152 |
810877 | 810877 | 2020-12-09 | Vermillion | Indiana | 18165 | 864 | 18 |
810878 | 810878 | 2020-12-09 | Vigo | Indiana | 18167 | 7481 | 122 |
810879 | 810879 | 2020-12-09 | Wabash | Indiana | 18169 | 2166 | 28 |
810880 | 810880 | 2020-12-09 | Warren | Indiana | 18171 | 341 | 4 |
810881 | 810881 | 2020-12-09 | Warrick | Indiana | 18173 | 4031 | 79 |
810882 | 810882 | 2020-12-09 | Washington | Indiana | 18175 | 1023 | 10 |
810883 | 810883 | 2020-12-09 | Wayne | Indiana | 18177 | 4456 | 110 |
810884 | 810884 | 2020-12-09 | Wells | Indiana | 18179 | 1624 | 42 |
810885 | 810885 | 2020-12-09 | White | Indiana | 18181 | 1723 | 24 |
810886 | 810886 | 2020-12-09 | Whitley | Indiana | 18183 | 1851 | 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);