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-13 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
823778 | 823778 | 2020-12-13 | Adams | Indiana | 18001 | 2267 | 29 |
823779 | 823779 | 2020-12-13 | Allen | Indiana | 18003 | 24059 | 410 |
823780 | 823780 | 2020-12-13 | Bartholomew | Indiana | 18005 | 4573 | 76 |
823781 | 823781 | 2020-12-13 | Benton | Indiana | 18007 | 616 | 3 |
823782 | 823782 | 2020-12-13 | Blackford | Indiana | 18009 | 783 | 20 |
823783 | 823783 | 2020-12-13 | Boone | Indiana | 18011 | 3510 | 59 |
823784 | 823784 | 2020-12-13 | Brown | Indiana | 18013 | 533 | 8 |
823785 | 823785 | 2020-12-13 | Carroll | Indiana | 18015 | 1040 | 14 |
823786 | 823786 | 2020-12-13 | Cass | Indiana | 18017 | 3630 | 37 |
823787 | 823787 | 2020-12-13 | Clark | Indiana | 18019 | 6842 | 99 |
823788 | 823788 | 2020-12-13 | Clay | Indiana | 18021 | 1596 | 27 |
823789 | 823789 | 2020-12-13 | Clinton | Indiana | 18023 | 2593 | 32 |
823790 | 823790 | 2020-12-13 | Crawford | Indiana | 18025 | 476 | 7 |
823791 | 823791 | 2020-12-13 | Daviess | Indiana | 18027 | 1997 | 62 |
823792 | 823792 | 2020-12-13 | DeKalb | Indiana | 18033 | 2518 | 42 |
823793 | 823793 | 2020-12-13 | Dearborn | Indiana | 18029 | 3100 | 39 |
823794 | 823794 | 2020-12-13 | Decatur | Indiana | 18031 | 1830 | 53 |
823795 | 823795 | 2020-12-13 | Delaware | Indiana | 18035 | 6467 | 122 |
823796 | 823796 | 2020-12-13 | Dubois | Indiana | 18037 | 3380 | 35 |
823797 | 823797 | 2020-12-13 | Elkhart | Indiana | 18039 | 20834 | 288 |
823798 | 823798 | 2020-12-13 | Fayette | Indiana | 18041 | 2010 | 42 |
823799 | 823799 | 2020-12-13 | Floyd | Indiana | 18043 | 4214 | 87 |
823800 | 823800 | 2020-12-13 | Fountain | Indiana | 18045 | 1245 | 15 |
823801 | 823801 | 2020-12-13 | Franklin | Indiana | 18047 | 992 | 29 |
823802 | 823802 | 2020-12-13 | Fulton | Indiana | 18049 | 1157 | 22 |
823803 | 823803 | 2020-12-13 | Gibson | Indiana | 18051 | 2568 | 45 |
823804 | 823804 | 2020-12-13 | Grant | Indiana | 18053 | 4449 | 66 |
823805 | 823805 | 2020-12-13 | Greene | Indiana | 18055 | 1522 | 57 |
823806 | 823806 | 2020-12-13 | Hamilton | Indiana | 18057 | 19048 | 223 |
823807 | 823807 | 2020-12-13 | Hancock | Indiana | 18059 | 4071 | 74 |
823808 | 823808 | 2020-12-13 | Harrison | Indiana | 18061 | 2038 | 30 |
823809 | 823809 | 2020-12-13 | Hendricks | Indiana | 18063 | 9037 | 201 |
823810 | 823810 | 2020-12-13 | Henry | Indiana | 18065 | 3381 | 47 |
823811 | 823811 | 2020-12-13 | Howard | Indiana | 18067 | 5352 | 91 |
823812 | 823812 | 2020-12-13 | Huntington | Indiana | 18069 | 1923 | 18 |
823813 | 823813 | 2020-12-13 | Jackson | Indiana | 18071 | 3183 | 42 |
823814 | 823814 | 2020-12-13 | Jasper | Indiana | 18073 | 2057 | 26 |
823815 | 823815 | 2020-12-13 | Jay | Indiana | 18075 | 1361 | 22 |
823816 | 823816 | 2020-12-13 | Jefferson | Indiana | 18077 | 1713 | 23 |
823817 | 823817 | 2020-12-13 | Jennings | Indiana | 18079 | 1399 | 25 |
823818 | 823818 | 2020-12-13 | Johnson | Indiana | 18081 | 9560 | 204 |
823819 | 823819 | 2020-12-13 | Knox | Indiana | 18083 | 2522 | 32 |
823820 | 823820 | 2020-12-13 | Kosciusko | Indiana | 18085 | 5955 | 60 |
823821 | 823821 | 2020-12-13 | LaGrange | Indiana | 18087 | 1812 | 41 |
823822 | 823822 | 2020-12-13 | LaPorte | Indiana | 18091 | 6133 | 117 |
823823 | 823823 | 2020-12-13 | Lake | Indiana | 18089 | 34821 | 548 |
823824 | 823824 | 2020-12-13 | Lawrence | Indiana | 18093 | 2531 | 57 |
823825 | 823825 | 2020-12-13 | Madison | Indiana | 18095 | 7188 | 153 |
823826 | 823826 | 2020-12-13 | Marion | Indiana | 18097 | 58276 | 1022 |
823827 | 823827 | 2020-12-13 | Marshall | Indiana | 18099 | 3974 | 61 |
823828 | 823828 | 2020-12-13 | Martin | Indiana | 18101 | 485 | 8 |
823829 | 823829 | 2020-12-13 | Miami | Indiana | 18103 | 2278 | 22 |
823830 | 823830 | 2020-12-13 | Monroe | Indiana | 18105 | 6937 | 72 |
823831 | 823831 | 2020-12-13 | Montgomery | Indiana | 18107 | 2204 | 35 |
823832 | 823832 | 2020-12-13 | Morgan | Indiana | 18109 | 3353 | 59 |
823833 | 823833 | 2020-12-13 | Newton | Indiana | 18111 | 732 | 19 |
823834 | 823834 | 2020-12-13 | Noble | Indiana | 18113 | 3401 | 53 |
823835 | 823835 | 2020-12-13 | Ohio | Indiana | 18115 | 293 | 7 |
823836 | 823836 | 2020-12-13 | Orange | Indiana | 18117 | 956 | 30 |
823837 | 823837 | 2020-12-13 | Owen | Indiana | 18119 | 1007 | 16 |
823838 | 823838 | 2020-12-13 | Parke | Indiana | 18121 | 1016 | 7 |
823839 | 823839 | 2020-12-13 | Perry | Indiana | 18123 | 1018 | 23 |
823840 | 823840 | 2020-12-13 | Pike | Indiana | 18125 | 708 | 23 |
823841 | 823841 | 2020-12-13 | Porter | Indiana | 18127 | 10716 | 122 |
823842 | 823842 | 2020-12-13 | Posey | Indiana | 18129 | 1557 | 22 |
823843 | 823843 | 2020-12-13 | Pulaski | Indiana | 18131 | 643 | 24 |
823844 | 823844 | 2020-12-13 | Putnam | Indiana | 18133 | 1905 | 33 |
823845 | 823845 | 2020-12-13 | Randolph | Indiana | 18135 | 1692 | 28 |
823846 | 823846 | 2020-12-13 | Ripley | Indiana | 18137 | 2032 | 32 |
823847 | 823847 | 2020-12-13 | Rush | Indiana | 18139 | 900 | 10 |
823848 | 823848 | 2020-12-13 | Scott | Indiana | 18143 | 1612 | 32 |
823849 | 823849 | 2020-12-13 | Shelby | Indiana | 18145 | 3494 | 76 |
823850 | 823850 | 2020-12-13 | Spencer | Indiana | 18147 | 1130 | 10 |
823851 | 823851 | 2020-12-13 | St. Joseph | Indiana | 18141 | 21668 | 304 |
823852 | 823852 | 2020-12-13 | Starke | Indiana | 18149 | 1297 | 31 |
823853 | 823853 | 2020-12-13 | Steuben | Indiana | 18151 | 2067 | 16 |
823854 | 823854 | 2020-12-13 | Sullivan | Indiana | 18153 | 1409 | 21 |
823855 | 823855 | 2020-12-13 | Switzerland | Indiana | 18155 | 385 | 5 |
823856 | 823856 | 2020-12-13 | Tippecanoe | Indiana | 18157 | 12256 | 51 |
823857 | 823857 | 2020-12-13 | Tipton | Indiana | 18159 | 847 | 32 |
823858 | 823858 | 2020-12-13 | Union | Indiana | 18161 | 390 | 2 |
823859 | 823859 | 2020-12-13 | Vanderburgh | Indiana | 18163 | 12601 | 159 |
823860 | 823860 | 2020-12-13 | Vermillion | Indiana | 18165 | 945 | 19 |
823861 | 823861 | 2020-12-13 | Vigo | Indiana | 18167 | 7866 | 128 |
823862 | 823862 | 2020-12-13 | Wabash | Indiana | 18169 | 2287 | 29 |
823863 | 823863 | 2020-12-13 | Warren | Indiana | 18171 | 379 | 7 |
823864 | 823864 | 2020-12-13 | Warrick | Indiana | 18173 | 4260 | 80 |
823865 | 823865 | 2020-12-13 | Washington | Indiana | 18175 | 1111 | 11 |
823866 | 823866 | 2020-12-13 | Wayne | Indiana | 18177 | 4754 | 119 |
823867 | 823867 | 2020-12-13 | Wells | Indiana | 18179 | 1697 | 45 |
823868 | 823868 | 2020-12-13 | White | Indiana | 18181 | 1830 | 24 |
823869 | 823869 | 2020-12-13 | Whitley | Indiana | 18183 | 2021 | 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);