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-02-16 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1034735 | 1034735 | 2021-02-16 | Adams | Indiana | 18001 | 3177 | 50 |
1034736 | 1034736 | 2021-02-16 | Allen | Indiana | 18003 | 35181 | 649 |
1034737 | 1034737 | 2021-02-16 | Bartholomew | Indiana | 18005 | 7247 | 151 |
1034738 | 1034738 | 2021-02-16 | Benton | Indiana | 18007 | 907 | 12 |
1034739 | 1034739 | 2021-02-16 | Blackford | Indiana | 18009 | 1207 | 27 |
1034740 | 1034740 | 2021-02-16 | Boone | Indiana | 18011 | 5997 | 93 |
1034741 | 1034741 | 2021-02-16 | Brown | Indiana | 18013 | 936 | 39 |
1034742 | 1034742 | 2021-02-16 | Carroll | Indiana | 18015 | 1742 | 20 |
1034743 | 1034743 | 2021-02-16 | Cass | Indiana | 18017 | 5245 | 96 |
1034744 | 1034744 | 2021-02-16 | Clark | Indiana | 18019 | 11723 | 185 |
1034745 | 1034745 | 2021-02-16 | Clay | Indiana | 18021 | 2367 | 42 |
1034746 | 1034746 | 2021-02-16 | Clinton | Indiana | 18023 | 3896 | 57 |
1034747 | 1034747 | 2021-02-16 | Crawford | Indiana | 18025 | 895 | 14 |
1034748 | 1034748 | 2021-02-16 | Daviess | Indiana | 18027 | 2832 | 95 |
1034749 | 1034749 | 2021-02-16 | DeKalb | Indiana | 18033 | 3774 | 81 |
1034750 | 1034750 | 2021-02-16 | Dearborn | Indiana | 18029 | 5321 | 65 |
1034751 | 1034751 | 2021-02-16 | Decatur | Indiana | 18031 | 2734 | 92 |
1034752 | 1034752 | 2021-02-16 | Delaware | Indiana | 18035 | 9752 | 181 |
1034753 | 1034753 | 2021-02-16 | Dubois | Indiana | 18037 | 5836 | 107 |
1034754 | 1034754 | 2021-02-16 | Elkhart | Indiana | 18039 | 25196 | 422 |
1034755 | 1034755 | 2021-02-16 | Fayette | Indiana | 18041 | 2811 | 55 |
1034756 | 1034756 | 2021-02-16 | Floyd | Indiana | 18043 | 7065 | 166 |
1034757 | 1034757 | 2021-02-16 | Fountain | Indiana | 18045 | 1979 | 40 |
1034758 | 1034758 | 2021-02-16 | Franklin | Indiana | 18047 | 1596 | 36 |
1034759 | 1034759 | 2021-02-16 | Fulton | Indiana | 18049 | 1753 | 38 |
1034760 | 1034760 | 2021-02-16 | Gibson | Indiana | 18051 | 3983 | 84 |
1034761 | 1034761 | 2021-02-16 | Grant | Indiana | 18053 | 6771 | 161 |
1034762 | 1034762 | 2021-02-16 | Greene | Indiana | 18055 | 2588 | 82 |
1034763 | 1034763 | 2021-02-16 | Hamilton | Indiana | 18057 | 31450 | 391 |
1034764 | 1034764 | 2021-02-16 | Hancock | Indiana | 18059 | 7344 | 131 |
1034765 | 1034765 | 2021-02-16 | Harrison | Indiana | 18061 | 3900 | 62 |
1034766 | 1034766 | 2021-02-16 | Hendricks | Indiana | 18063 | 15610 | 309 |
1034767 | 1034767 | 2021-02-16 | Henry | Indiana | 18065 | 5374 | 90 |
1034768 | 1034768 | 2021-02-16 | Howard | Indiana | 18067 | 8985 | 190 |
1034769 | 1034769 | 2021-02-16 | Huntington | Indiana | 18069 | 3302 | 77 |
1034770 | 1034770 | 2021-02-16 | Jackson | Indiana | 18071 | 4591 | 61 |
1034771 | 1034771 | 2021-02-16 | Jasper | Indiana | 18073 | 3104 | 44 |
1034772 | 1034772 | 2021-02-16 | Jay | Indiana | 18075 | 1776 | 30 |
1034773 | 1034773 | 2021-02-16 | Jefferson | Indiana | 18077 | 2898 | 69 |
1034774 | 1034774 | 2021-02-16 | Jennings | Indiana | 18079 | 2121 | 46 |
1034775 | 1034775 | 2021-02-16 | Johnson | Indiana | 18081 | 16179 | 358 |
1034776 | 1034776 | 2021-02-16 | Knox | Indiana | 18083 | 3539 | 82 |
1034777 | 1034777 | 2021-02-16 | Kosciusko | Indiana | 18085 | 8466 | 110 |
1034778 | 1034778 | 2021-02-16 | LaGrange | Indiana | 18087 | 2394 | 71 |
1034779 | 1034779 | 2021-02-16 | LaPorte | Indiana | 18091 | 9609 | 196 |
1034780 | 1034780 | 2021-02-16 | Lake | Indiana | 18089 | 47827 | 883 |
1034781 | 1034781 | 2021-02-16 | Lawrence | Indiana | 18093 | 4131 | 114 |
1034782 | 1034782 | 2021-02-16 | Madison | Indiana | 18095 | 11644 | 327 |
1034783 | 1034783 | 2021-02-16 | Marion | Indiana | 18097 | 89611 | 1681 |
1034784 | 1034784 | 2021-02-16 | Marshall | Indiana | 18099 | 5355 | 104 |
1034785 | 1034785 | 2021-02-16 | Martin | Indiana | 18101 | 799 | 15 |
1034786 | 1034786 | 2021-02-16 | Miami | Indiana | 18103 | 3508 | 61 |
1034787 | 1034787 | 2021-02-16 | Monroe | Indiana | 18105 | 10136 | 160 |
1034788 | 1034788 | 2021-02-16 | Montgomery | Indiana | 18107 | 3761 | 83 |
1034789 | 1034789 | 2021-02-16 | Morgan | Indiana | 18109 | 5967 | 129 |
1034790 | 1034790 | 2021-02-16 | Newton | Indiana | 18111 | 966 | 33 |
1034791 | 1034791 | 2021-02-16 | Noble | Indiana | 18113 | 5016 | 78 |
1034792 | 1034792 | 2021-02-16 | Ohio | Indiana | 18115 | 521 | 11 |
1034793 | 1034793 | 2021-02-16 | Orange | Indiana | 18117 | 1707 | 53 |
1034794 | 1034794 | 2021-02-16 | Owen | Indiana | 18119 | 1813 | 54 |
1034795 | 1034795 | 2021-02-16 | Parke | Indiana | 18121 | 1385 | 15 |
1034796 | 1034796 | 2021-02-16 | Perry | Indiana | 18123 | 1720 | 36 |
1034797 | 1034797 | 2021-02-16 | Pike | Indiana | 18125 | 1264 | 32 |
1034798 | 1034798 | 2021-02-16 | Porter | Indiana | 18127 | 15704 | 274 |
1034799 | 1034799 | 2021-02-16 | Posey | Indiana | 18129 | 2566 | 31 |
1034800 | 1034800 | 2021-02-16 | Pulaski | Indiana | 18131 | 1043 | 41 |
1034801 | 1034801 | 2021-02-16 | Putnam | Indiana | 18133 | 3228 | 58 |
1034802 | 1034802 | 2021-02-16 | Randolph | Indiana | 18135 | 2283 | 73 |
1034803 | 1034803 | 2021-02-16 | Ripley | Indiana | 18137 | 3220 | 59 |
1034804 | 1034804 | 2021-02-16 | Rush | Indiana | 18139 | 1686 | 22 |
1034805 | 1034805 | 2021-02-16 | Scott | Indiana | 18143 | 2447 | 48 |
1034806 | 1034806 | 2021-02-16 | Shelby | Indiana | 18145 | 5458 | 98 |
1034807 | 1034807 | 2021-02-16 | Spencer | Indiana | 18147 | 2138 | 28 |
1034808 | 1034808 | 2021-02-16 | St. Joseph | Indiana | 18141 | 29039 | 519 |
1034809 | 1034809 | 2021-02-16 | Starke | Indiana | 18149 | 1848 | 53 |
1034810 | 1034810 | 2021-02-16 | Steuben | Indiana | 18151 | 3330 | 57 |
1034811 | 1034811 | 2021-02-16 | Sullivan | Indiana | 18153 | 2015 | 38 |
1034812 | 1034812 | 2021-02-16 | Switzerland | Indiana | 18155 | 746 | 7 |
1034813 | 1034813 | 2021-02-16 | Tippecanoe | Indiana | 18157 | 19459 | 193 |
1034814 | 1034814 | 2021-02-16 | Tipton | Indiana | 18159 | 1453 | 43 |
1034815 | 1034815 | 2021-02-16 | Union | Indiana | 18161 | 690 | 10 |
1034816 | 1034816 | 2021-02-16 | Vanderburgh | Indiana | 18163 | 20955 | 375 |
1034817 | 1034817 | 2021-02-16 | Vermillion | Indiana | 18165 | 1572 | 40 |
1034818 | 1034818 | 2021-02-16 | Vigo | Indiana | 18167 | 11420 | 232 |
1034819 | 1034819 | 2021-02-16 | Wabash | Indiana | 18169 | 3261 | 74 |
1034820 | 1034820 | 2021-02-16 | Warren | Indiana | 18171 | 736 | 13 |
1034821 | 1034821 | 2021-02-16 | Warrick | Indiana | 18173 | 7295 | 143 |
1034822 | 1034822 | 2021-02-16 | Washington | Indiana | 18175 | 2039 | 25 |
1034823 | 1034823 | 2021-02-16 | Wayne | Indiana | 18177 | 6934 | 188 |
1034824 | 1034824 | 2021-02-16 | Wells | Indiana | 18179 | 2535 | 77 |
1034825 | 1034825 | 2021-02-16 | White | Indiana | 18181 | 2919 | 51 |
1034826 | 1034826 | 2021-02-16 | Whitley | Indiana | 18183 | 3410 | 35 |
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);