ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-11-03" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
693985 | 693985 | 2020-11-03 | Adams | Indiana | 18001 | 745 | 10 |
693986 | 693986 | 2020-11-03 | Allen | Indiana | 18003 | 9954 | 251 |
693987 | 693987 | 2020-11-03 | Bartholomew | Indiana | 18005 | 1671 | 63 |
693988 | 693988 | 2020-11-03 | Benton | Indiana | 18007 | 127 | 1 |
693989 | 693989 | 2020-11-03 | Blackford | Indiana | 18009 | 301 | 6 |
693990 | 693990 | 2020-11-03 | Boone | Indiana | 18011 | 1477 | 54 |
693991 | 693991 | 2020-11-03 | Brown | Indiana | 18013 | 166 | 3 |
693992 | 693992 | 2020-11-03 | Carroll | Indiana | 18015 | 408 | 13 |
693993 | 693993 | 2020-11-03 | Cass | Indiana | 18017 | 2427 | 27 |
693994 | 693994 | 2020-11-03 | Clark | Indiana | 18019 | 3400 | 74 |
693995 | 693995 | 2020-11-03 | Clay | Indiana | 18021 | 573 | 12 |
693996 | 693996 | 2020-11-03 | Clinton | Indiana | 18023 | 1105 | 20 |
693997 | 693997 | 2020-11-03 | Crawford | Indiana | 18025 | 182 | 2 |
693998 | 693998 | 2020-11-03 | Daviess | Indiana | 18027 | 1046 | 38 |
693999 | 693999 | 2020-11-03 | DeKalb | Indiana | 18033 | 960 | 14 |
694000 | 694000 | 2020-11-03 | Dearborn | Indiana | 18029 | 1194 | 30 |
694001 | 694001 | 2020-11-03 | Decatur | Indiana | 18031 | 673 | 42 |
694002 | 694002 | 2020-11-03 | Delaware | Indiana | 18035 | 3464 | 86 |
694003 | 694003 | 2020-11-03 | Dubois | Indiana | 18037 | 1675 | 28 |
694004 | 694004 | 2020-11-03 | Elkhart | Indiana | 18039 | 10833 | 162 |
694005 | 694005 | 2020-11-03 | Fayette | Indiana | 18041 | 1094 | 25 |
694006 | 694006 | 2020-11-03 | Floyd | Indiana | 18043 | 2082 | 72 |
694007 | 694007 | 2020-11-03 | Fountain | Indiana | 18045 | 425 | 3 |
694008 | 694008 | 2020-11-03 | Franklin | Indiana | 18047 | 428 | 27 |
694009 | 694009 | 2020-11-03 | Fulton | Indiana | 18049 | 454 | 12 |
694010 | 694010 | 2020-11-03 | Gibson | Indiana | 18051 | 1068 | 12 |
694011 | 694011 | 2020-11-03 | Grant | Indiana | 18053 | 1941 | 45 |
694012 | 694012 | 2020-11-03 | Greene | Indiana | 18055 | 660 | 43 |
694013 | 694013 | 2020-11-03 | Hamilton | Indiana | 18057 | 7316 | 140 |
694014 | 694014 | 2020-11-03 | Hancock | Indiana | 18059 | 1426 | 48 |
694015 | 694015 | 2020-11-03 | Harrison | Indiana | 18061 | 916 | 26 |
694016 | 694016 | 2020-11-03 | Hendricks | Indiana | 18063 | 3792 | 159 |
694017 | 694017 | 2020-11-03 | Henry | Indiana | 18065 | 1589 | 31 |
694018 | 694018 | 2020-11-03 | Howard | Indiana | 18067 | 1878 | 72 |
694019 | 694019 | 2020-11-03 | Huntington | Indiana | 18069 | 580 | 6 |
694020 | 694020 | 2020-11-03 | Jackson | Indiana | 18071 | 1354 | 21 |
694021 | 694021 | 2020-11-03 | Jasper | Indiana | 18073 | 862 | 6 |
694022 | 694022 | 2020-11-03 | Jay | Indiana | 18075 | 460 | 8 |
694023 | 694023 | 2020-11-03 | Jefferson | Indiana | 18077 | 480 | 6 |
694024 | 694024 | 2020-11-03 | Jennings | Indiana | 18079 | 470 | 15 |
694025 | 694025 | 2020-11-03 | Johnson | Indiana | 18081 | 3750 | 159 |
694026 | 694026 | 2020-11-03 | Knox | Indiana | 18083 | 992 | 10 |
694027 | 694027 | 2020-11-03 | Kosciusko | Indiana | 18085 | 2516 | 31 |
694028 | 694028 | 2020-11-03 | LaGrange | Indiana | 18087 | 919 | 17 |
694029 | 694029 | 2020-11-03 | LaPorte | Indiana | 18091 | 2749 | 68 |
694030 | 694030 | 2020-11-03 | Lake | Indiana | 18089 | 16809 | 401 |
694031 | 694031 | 2020-11-03 | Lawrence | Indiana | 18093 | 1125 | 42 |
694032 | 694032 | 2020-11-03 | Madison | Indiana | 18095 | 2944 | 113 |
694033 | 694033 | 2020-11-03 | Marion | Indiana | 18097 | 28446 | 850 |
694034 | 694034 | 2020-11-03 | Marshall | Indiana | 18099 | 1723 | 31 |
694035 | 694035 | 2020-11-03 | Martin | Indiana | 18101 | 218 | 0 |
694036 | 694036 | 2020-11-03 | Miami | Indiana | 18103 | 814 | 5 |
694037 | 694037 | 2020-11-03 | Monroe | Indiana | 18105 | 3623 | 44 |
694038 | 694038 | 2020-11-03 | Montgomery | Indiana | 18107 | 767 | 23 |
694039 | 694039 | 2020-11-03 | Morgan | Indiana | 18109 | 1161 | 45 |
694040 | 694040 | 2020-11-03 | Newton | Indiana | 18111 | 295 | 13 |
694041 | 694041 | 2020-11-03 | Noble | Indiana | 18113 | 1423 | 36 |
694042 | 694042 | 2020-11-03 | Ohio | Indiana | 18115 | 155 | 7 |
694043 | 694043 | 2020-11-03 | Orange | Indiana | 18117 | 466 | 27 |
694044 | 694044 | 2020-11-03 | Owen | Indiana | 18119 | 271 | 2 |
694045 | 694045 | 2020-11-03 | Parke | Indiana | 18121 | 306 | 4 |
694046 | 694046 | 2020-11-03 | Perry | Indiana | 18123 | 544 | 16 |
694047 | 694047 | 2020-11-03 | Pike | Indiana | 18125 | 393 | 18 |
694048 | 694048 | 2020-11-03 | Porter | Indiana | 18127 | 4323 | 61 |
694049 | 694049 | 2020-11-03 | Posey | Indiana | 18129 | 877 | 11 |
694050 | 694050 | 2020-11-03 | Pulaski | Indiana | 18131 | 214 | 6 |
694051 | 694051 | 2020-11-03 | Putnam | Indiana | 18133 | 865 | 18 |
694052 | 694052 | 2020-11-03 | Randolph | Indiana | 18135 | 583 | 12 |
694053 | 694053 | 2020-11-03 | Ripley | Indiana | 18137 | 589 | 9 |
694054 | 694054 | 2020-11-03 | Rush | Indiana | 18139 | 361 | 5 |
694055 | 694055 | 2020-11-03 | Scott | Indiana | 18143 | 623 | 18 |
694056 | 694056 | 2020-11-03 | Shelby | Indiana | 18145 | 1578 | 50 |
694057 | 694057 | 2020-11-03 | Spencer | Indiana | 18147 | 483 | 6 |
694058 | 694058 | 2020-11-03 | St. Joseph | Indiana | 18141 | 10946 | 191 |
694059 | 694059 | 2020-11-03 | Starke | Indiana | 18149 | 560 | 12 |
694060 | 694060 | 2020-11-03 | Steuben | Indiana | 18151 | 781 | 10 |
694061 | 694061 | 2020-11-03 | Sullivan | Indiana | 18153 | 508 | 14 |
694062 | 694062 | 2020-11-03 | Switzerland | Indiana | 18155 | 116 | 0 |
694063 | 694063 | 2020-11-03 | Tippecanoe | Indiana | 18157 | 4691 | 18 |
694064 | 694064 | 2020-11-03 | Tipton | Indiana | 18159 | 318 | 26 |
694065 | 694065 | 2020-11-03 | Union | Indiana | 18161 | 164 | 0 |
694066 | 694066 | 2020-11-03 | Vanderburgh | Indiana | 18163 | 6848 | 80 |
694067 | 694067 | 2020-11-03 | Vermillion | Indiana | 18165 | 319 | 2 |
694068 | 694068 | 2020-11-03 | Vigo | Indiana | 18167 | 3208 | 53 |
694069 | 694069 | 2020-11-03 | Wabash | Indiana | 18169 | 637 | 12 |
694070 | 694070 | 2020-11-03 | Warren | Indiana | 18171 | 124 | 1 |
694071 | 694071 | 2020-11-03 | Warrick | Indiana | 18173 | 2257 | 69 |
694072 | 694072 | 2020-11-03 | Washington | Indiana | 18175 | 438 | 3 |
694073 | 694073 | 2020-11-03 | Wayne | Indiana | 18177 | 2175 | 39 |
694074 | 694074 | 2020-11-03 | Wells | Indiana | 18179 | 597 | 16 |
694075 | 694075 | 2020-11-03 | White | Indiana | 18181 | 711 | 16 |
694076 | 694076 | 2020-11-03 | Whitley | Indiana | 18183 | 596 | 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);