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-04-02 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1180821 | 1180821 | 2021-04-02 | Adams | Indiana | 18001 | 3413 | 53 |
1180822 | 1180822 | 2021-04-02 | Allen | Indiana | 18003 | 38005 | 685 |
1180823 | 1180823 | 2021-04-02 | Bartholomew | Indiana | 18005 | 7744 | 157 |
1180824 | 1180824 | 2021-04-02 | Benton | Indiana | 18007 | 933 | 13 |
1180825 | 1180825 | 2021-04-02 | Blackford | Indiana | 18009 | 1315 | 29 |
1180826 | 1180826 | 2021-04-02 | Boone | Indiana | 18011 | 6399 | 103 |
1180827 | 1180827 | 2021-04-02 | Brown | Indiana | 18013 | 972 | 40 |
1180828 | 1180828 | 2021-04-02 | Carroll | Indiana | 18015 | 1820 | 22 |
1180829 | 1180829 | 2021-04-02 | Cass | Indiana | 18017 | 5631 | 103 |
1180830 | 1180830 | 2021-04-02 | Clark | Indiana | 18019 | 12476 | 196 |
1180831 | 1180831 | 2021-04-02 | Clay | Indiana | 18021 | 2475 | 44 |
1180832 | 1180832 | 2021-04-02 | Clinton | Indiana | 18023 | 4081 | 58 |
1180833 | 1180833 | 2021-04-02 | Crawford | Indiana | 18025 | 966 | 14 |
1180834 | 1180834 | 2021-04-02 | Daviess | Indiana | 18027 | 2879 | 100 |
1180835 | 1180835 | 2021-04-02 | DeKalb | Indiana | 18033 | 3990 | 85 |
1180836 | 1180836 | 2021-04-02 | Dearborn | Indiana | 18029 | 5614 | 76 |
1180837 | 1180837 | 2021-04-02 | Decatur | Indiana | 18031 | 2823 | 96 |
1180838 | 1180838 | 2021-04-02 | Delaware | Indiana | 18035 | 10165 | 188 |
1180839 | 1180839 | 2021-04-02 | Dubois | Indiana | 18037 | 6037 | 117 |
1180840 | 1180840 | 2021-04-02 | Elkhart | Indiana | 18039 | 26533 | 443 |
1180841 | 1180841 | 2021-04-02 | Fayette | Indiana | 18041 | 2891 | 62 |
1180842 | 1180842 | 2021-04-02 | Floyd | Indiana | 18043 | 7456 | 179 |
1180843 | 1180843 | 2021-04-02 | Fountain | Indiana | 18045 | 2065 | 45 |
1180844 | 1180844 | 2021-04-02 | Franklin | Indiana | 18047 | 1653 | 36 |
1180845 | 1180845 | 2021-04-02 | Fulton | Indiana | 18049 | 1869 | 39 |
1180846 | 1180846 | 2021-04-02 | Gibson | Indiana | 18051 | 4231 | 90 |
1180847 | 1180847 | 2021-04-02 | Grant | Indiana | 18053 | 7074 | 173 |
1180848 | 1180848 | 2021-04-02 | Greene | Indiana | 18055 | 2682 | 89 |
1180849 | 1180849 | 2021-04-02 | Hamilton | Indiana | 18057 | 33635 | 422 |
1180850 | 1180850 | 2021-04-02 | Hancock | Indiana | 18059 | 7747 | 140 |
1180851 | 1180851 | 2021-04-02 | Harrison | Indiana | 18061 | 4223 | 72 |
1180852 | 1180852 | 2021-04-02 | Hendricks | Indiana | 18063 | 16476 | 327 |
1180853 | 1180853 | 2021-04-02 | Henry | Indiana | 18065 | 5532 | 101 |
1180854 | 1180854 | 2021-04-02 | Howard | Indiana | 18067 | 9478 | 215 |
1180855 | 1180855 | 2021-04-02 | Huntington | Indiana | 18069 | 3689 | 82 |
1180856 | 1180856 | 2021-04-02 | Jackson | Indiana | 18071 | 4840 | 70 |
1180857 | 1180857 | 2021-04-02 | Jasper | Indiana | 18073 | 3351 | 48 |
1180858 | 1180858 | 2021-04-02 | Jay | Indiana | 18075 | 1842 | 30 |
1180859 | 1180859 | 2021-04-02 | Jefferson | Indiana | 18077 | 3021 | 79 |
1180860 | 1180860 | 2021-04-02 | Jennings | Indiana | 18079 | 2233 | 48 |
1180861 | 1180861 | 2021-04-02 | Johnson | Indiana | 18081 | 17182 | 385 |
1180862 | 1180862 | 2021-04-02 | Knox | Indiana | 18083 | 3611 | 88 |
1180863 | 1180863 | 2021-04-02 | Kosciusko | Indiana | 18085 | 8901 | 116 |
1180864 | 1180864 | 2021-04-02 | LaGrange | Indiana | 18087 | 2473 | 72 |
1180865 | 1180865 | 2021-04-02 | LaPorte | Indiana | 18091 | 10345 | 206 |
1180866 | 1180866 | 2021-04-02 | Lake | Indiana | 18089 | 50220 | 960 |
1180867 | 1180867 | 2021-04-02 | Lawrence | Indiana | 18093 | 4261 | 120 |
1180868 | 1180868 | 2021-04-02 | Madison | Indiana | 18095 | 12131 | 353 |
1180869 | 1180869 | 2021-04-02 | Marion | Indiana | 18097 | 94013 | 1763 |
1180870 | 1180870 | 2021-04-02 | Marshall | Indiana | 18099 | 5640 | 109 |
1180871 | 1180871 | 2021-04-02 | Martin | Indiana | 18101 | 818 | 15 |
1180872 | 1180872 | 2021-04-02 | Miami | Indiana | 18103 | 3695 | 66 |
1180873 | 1180873 | 2021-04-02 | Monroe | Indiana | 18105 | 10981 | 168 |
1180874 | 1180874 | 2021-04-02 | Montgomery | Indiana | 18107 | 4100 | 87 |
1180875 | 1180875 | 2021-04-02 | Morgan | Indiana | 18109 | 6311 | 139 |
1180876 | 1180876 | 2021-04-02 | Newton | Indiana | 18111 | 1007 | 35 |
1180877 | 1180877 | 2021-04-02 | Noble | Indiana | 18113 | 5267 | 84 |
1180878 | 1180878 | 2021-04-02 | Ohio | Indiana | 18115 | 549 | 11 |
1180879 | 1180879 | 2021-04-02 | Orange | Indiana | 18117 | 1747 | 55 |
1180880 | 1180880 | 2021-04-02 | Owen | Indiana | 18119 | 1885 | 58 |
1180881 | 1180881 | 2021-04-02 | Parke | Indiana | 18121 | 1442 | 16 |
1180882 | 1180882 | 2021-04-02 | Perry | Indiana | 18123 | 1788 | 37 |
1180883 | 1180883 | 2021-04-02 | Pike | Indiana | 18125 | 1291 | 34 |
1180884 | 1180884 | 2021-04-02 | Porter | Indiana | 18127 | 16708 | 304 |
1180885 | 1180885 | 2021-04-02 | Posey | Indiana | 18129 | 2666 | 33 |
1180886 | 1180886 | 2021-04-02 | Pulaski | Indiana | 18131 | 1109 | 45 |
1180887 | 1180887 | 2021-04-02 | Putnam | Indiana | 18133 | 3493 | 60 |
1180888 | 1180888 | 2021-04-02 | Randolph | Indiana | 18135 | 2356 | 80 |
1180889 | 1180889 | 2021-04-02 | Ripley | Indiana | 18137 | 3314 | 67 |
1180890 | 1180890 | 2021-04-02 | Rush | Indiana | 18139 | 1745 | 24 |
1180891 | 1180891 | 2021-04-02 | Scott | Indiana | 18143 | 2569 | 55 |
1180892 | 1180892 | 2021-04-02 | Shelby | Indiana | 18145 | 5671 | 105 |
1180893 | 1180893 | 2021-04-02 | Spencer | Indiana | 18147 | 2260 | 31 |
1180894 | 1180894 | 2021-04-02 | St. Joseph | Indiana | 18141 | 32509 | 547 |
1180895 | 1180895 | 2021-04-02 | Starke | Indiana | 18149 | 1962 | 54 |
1180896 | 1180896 | 2021-04-02 | Steuben | Indiana | 18151 | 3530 | 59 |
1180897 | 1180897 | 2021-04-02 | Sullivan | Indiana | 18153 | 2068 | 41 |
1180898 | 1180898 | 2021-04-02 | Switzerland | Indiana | 18155 | 765 | 8 |
1180899 | 1180899 | 2021-04-02 | Tippecanoe | Indiana | 18157 | 21035 | 213 |
1180900 | 1180900 | 2021-04-02 | Tipton | Indiana | 18159 | 1589 | 45 |
1180901 | 1180901 | 2021-04-02 | Union | Indiana | 18161 | 719 | 11 |
1180902 | 1180902 | 2021-04-02 | Vanderburgh | Indiana | 18163 | 21805 | 396 |
1180903 | 1180903 | 2021-04-02 | Vermillion | Indiana | 18165 | 1641 | 43 |
1180904 | 1180904 | 2021-04-02 | Vigo | Indiana | 18167 | 12019 | 246 |
1180905 | 1180905 | 2021-04-02 | Wabash | Indiana | 18169 | 3427 | 77 |
1180906 | 1180906 | 2021-04-02 | Warren | Indiana | 18171 | 777 | 16 |
1180907 | 1180907 | 2021-04-02 | Warrick | Indiana | 18173 | 7616 | 158 |
1180908 | 1180908 | 2021-04-02 | Washington | Indiana | 18175 | 2241 | 29 |
1180909 | 1180909 | 2021-04-02 | Wayne | Indiana | 18177 | 7185 | 200 |
1180910 | 1180910 | 2021-04-02 | Wells | Indiana | 18179 | 2812 | 82 |
1180911 | 1180911 | 2021-04-02 | White | Indiana | 18181 | 3038 | 55 |
1180912 | 1180912 | 2021-04-02 | Whitley | Indiana | 18183 | 3661 | 39 |
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);