ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-10-30" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
681010 | 681010 | 2020-10-30 | Adams | Indiana | 18001 | 653 | 9 |
681011 | 681011 | 2020-10-30 | Allen | Indiana | 18003 | 9310 | 246 |
681012 | 681012 | 2020-10-30 | Bartholomew | Indiana | 18005 | 1568 | 63 |
681013 | 681013 | 2020-10-30 | Benton | Indiana | 18007 | 120 | 0 |
681014 | 681014 | 2020-10-30 | Blackford | Indiana | 18009 | 287 | 6 |
681015 | 681015 | 2020-10-30 | Boone | Indiana | 18011 | 1397 | 53 |
681016 | 681016 | 2020-10-30 | Brown | Indiana | 18013 | 156 | 3 |
681017 | 681017 | 2020-10-30 | Carroll | Indiana | 18015 | 370 | 13 |
681018 | 681018 | 2020-10-30 | Cass | Indiana | 18017 | 2378 | 27 |
681019 | 681019 | 2020-10-30 | Clark | Indiana | 18019 | 3243 | 74 |
681020 | 681020 | 2020-10-30 | Clay | Indiana | 18021 | 513 | 7 |
681021 | 681021 | 2020-10-30 | Clinton | Indiana | 18023 | 1012 | 20 |
681022 | 681022 | 2020-10-30 | Crawford | Indiana | 18025 | 176 | 2 |
681023 | 681023 | 2020-10-30 | Daviess | Indiana | 18027 | 975 | 38 |
681024 | 681024 | 2020-10-30 | DeKalb | Indiana | 18033 | 869 | 14 |
681025 | 681025 | 2020-10-30 | Dearborn | Indiana | 18029 | 1117 | 30 |
681026 | 681026 | 2020-10-30 | Decatur | Indiana | 18031 | 612 | 42 |
681027 | 681027 | 2020-10-30 | Delaware | Indiana | 18035 | 3326 | 82 |
681028 | 681028 | 2020-10-30 | Dubois | Indiana | 18037 | 1588 | 27 |
681029 | 681029 | 2020-10-30 | Elkhart | Indiana | 18039 | 10057 | 152 |
681030 | 681030 | 2020-10-30 | Fayette | Indiana | 18041 | 998 | 22 |
681031 | 681031 | 2020-10-30 | Floyd | Indiana | 18043 | 1968 | 72 |
681032 | 681032 | 2020-10-30 | Fountain | Indiana | 18045 | 363 | 3 |
681033 | 681033 | 2020-10-30 | Franklin | Indiana | 18047 | 417 | 27 |
681034 | 681034 | 2020-10-30 | Fulton | Indiana | 18049 | 427 | 10 |
681035 | 681035 | 2020-10-30 | Gibson | Indiana | 18051 | 998 | 12 |
681036 | 681036 | 2020-10-30 | Grant | Indiana | 18053 | 1876 | 43 |
681037 | 681037 | 2020-10-30 | Greene | Indiana | 18055 | 617 | 41 |
681038 | 681038 | 2020-10-30 | Hamilton | Indiana | 18057 | 6832 | 131 |
681039 | 681039 | 2020-10-30 | Hancock | Indiana | 18059 | 1341 | 47 |
681040 | 681040 | 2020-10-30 | Harrison | Indiana | 18061 | 862 | 26 |
681041 | 681041 | 2020-10-30 | Hendricks | Indiana | 18063 | 3635 | 156 |
681042 | 681042 | 2020-10-30 | Henry | Indiana | 18065 | 1451 | 31 |
681043 | 681043 | 2020-10-30 | Howard | Indiana | 18067 | 1793 | 70 |
681044 | 681044 | 2020-10-30 | Huntington | Indiana | 18069 | 516 | 5 |
681045 | 681045 | 2020-10-30 | Jackson | Indiana | 18071 | 1273 | 21 |
681046 | 681046 | 2020-10-30 | Jasper | Indiana | 18073 | 768 | 6 |
681047 | 681047 | 2020-10-30 | Jay | Indiana | 18075 | 408 | 7 |
681048 | 681048 | 2020-10-30 | Jefferson | Indiana | 18077 | 424 | 5 |
681049 | 681049 | 2020-10-30 | Jennings | Indiana | 18079 | 412 | 15 |
681050 | 681050 | 2020-10-30 | Johnson | Indiana | 18081 | 3547 | 142 |
681051 | 681051 | 2020-10-30 | Knox | Indiana | 18083 | 911 | 10 |
681052 | 681052 | 2020-10-30 | Kosciusko | Indiana | 18085 | 2254 | 30 |
681053 | 681053 | 2020-10-30 | LaGrange | Indiana | 18087 | 865 | 16 |
681054 | 681054 | 2020-10-30 | LaPorte | Indiana | 18091 | 2566 | 67 |
681055 | 681055 | 2020-10-30 | Lake | Indiana | 18089 | 15411 | 390 |
681056 | 681056 | 2020-10-30 | Lawrence | Indiana | 18093 | 1064 | 40 |
681057 | 681057 | 2020-10-30 | Madison | Indiana | 18095 | 2776 | 110 |
681058 | 681058 | 2020-10-30 | Marion | Indiana | 18097 | 27279 | 850 |
681059 | 681059 | 2020-10-30 | Marshall | Indiana | 18099 | 1578 | 30 |
681060 | 681060 | 2020-10-30 | Martin | Indiana | 18101 | 211 | 0 |
681061 | 681061 | 2020-10-30 | Miami | Indiana | 18103 | 740 | 5 |
681062 | 681062 | 2020-10-30 | Monroe | Indiana | 18105 | 3520 | 42 |
681063 | 681063 | 2020-10-30 | Montgomery | Indiana | 18107 | 696 | 23 |
681064 | 681064 | 2020-10-30 | Morgan | Indiana | 18109 | 1073 | 43 |
681065 | 681065 | 2020-10-30 | Newton | Indiana | 18111 | 253 | 12 |
681066 | 681066 | 2020-10-30 | Noble | Indiana | 18113 | 1315 | 36 |
681067 | 681067 | 2020-10-30 | Ohio | Indiana | 18115 | 147 | 7 |
681068 | 681068 | 2020-10-30 | Orange | Indiana | 18117 | 443 | 27 |
681069 | 681069 | 2020-10-30 | Owen | Indiana | 18119 | 230 | 2 |
681070 | 681070 | 2020-10-30 | Parke | Indiana | 18121 | 288 | 4 |
681071 | 681071 | 2020-10-30 | Perry | Indiana | 18123 | 451 | 15 |
681072 | 681072 | 2020-10-30 | Pike | Indiana | 18125 | 376 | 18 |
681073 | 681073 | 2020-10-30 | Porter | Indiana | 18127 | 3809 | 55 |
681074 | 681074 | 2020-10-30 | Posey | Indiana | 18129 | 813 | 8 |
681075 | 681075 | 2020-10-30 | Pulaski | Indiana | 18131 | 190 | 4 |
681076 | 681076 | 2020-10-30 | Putnam | Indiana | 18133 | 824 | 17 |
681077 | 681077 | 2020-10-30 | Randolph | Indiana | 18135 | 528 | 11 |
681078 | 681078 | 2020-10-30 | Ripley | Indiana | 18137 | 534 | 8 |
681079 | 681079 | 2020-10-30 | Rush | Indiana | 18139 | 342 | 4 |
681080 | 681080 | 2020-10-30 | Scott | Indiana | 18143 | 593 | 18 |
681081 | 681081 | 2020-10-30 | Shelby | Indiana | 18145 | 1499 | 45 |
681082 | 681082 | 2020-10-30 | Spencer | Indiana | 18147 | 449 | 6 |
681083 | 681083 | 2020-10-30 | St. Joseph | Indiana | 18141 | 10274 | 186 |
681084 | 681084 | 2020-10-30 | Starke | Indiana | 18149 | 504 | 10 |
681085 | 681085 | 2020-10-30 | Steuben | Indiana | 18151 | 723 | 9 |
681086 | 681086 | 2020-10-30 | Sullivan | Indiana | 18153 | 496 | 14 |
681087 | 681087 | 2020-10-30 | Switzerland | Indiana | 18155 | 110 | 0 |
681088 | 681088 | 2020-10-30 | Tippecanoe | Indiana | 18157 | 4368 | 17 |
681089 | 681089 | 2020-10-30 | Tipton | Indiana | 18159 | 303 | 26 |
681090 | 681090 | 2020-10-30 | Union | Indiana | 18161 | 157 | 0 |
681091 | 681091 | 2020-10-30 | Vanderburgh | Indiana | 18163 | 6488 | 73 |
681092 | 681092 | 2020-10-30 | Vermillion | Indiana | 18165 | 296 | 1 |
681093 | 681093 | 2020-10-30 | Vigo | Indiana | 18167 | 2976 | 44 |
681094 | 681094 | 2020-10-30 | Wabash | Indiana | 18169 | 533 | 10 |
681095 | 681095 | 2020-10-30 | Warren | Indiana | 18171 | 109 | 1 |
681096 | 681096 | 2020-10-30 | Warrick | Indiana | 18173 | 2142 | 68 |
681097 | 681097 | 2020-10-30 | Washington | Indiana | 18175 | 422 | 3 |
681098 | 681098 | 2020-10-30 | Wayne | Indiana | 18177 | 2047 | 35 |
681099 | 681099 | 2020-10-30 | Wells | Indiana | 18179 | 541 | 14 |
681100 | 681100 | 2020-10-30 | White | Indiana | 18181 | 670 | 16 |
681101 | 681101 | 2020-10-30 | Whitley | Indiana | 18183 | 532 | 6 |
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);