ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where cases = 24 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
418903 | 418903 | 2020-08-10 | Warren | Indiana | 18171 | 24 | 1 |
319457 | 319457 | 2020-07-10 | Martin | Indiana | 18101 | 24 | 0 |
284670 | 284670 | 2020-06-29 | Martin | Indiana | 18101 | 24 | 0 |
275256 | 275256 | 2020-06-26 | Switzerland | Indiana | 18155 | 24 | 0 |
272114 | 272114 | 2020-06-25 | Switzerland | Indiana | 18155 | 24 | 0 |
268922 | 268922 | 2020-06-24 | Fountain | Indiana | 18045 | 24 | 2 |
268977 | 268977 | 2020-06-24 | Switzerland | Indiana | 18155 | 24 | 0 |
265792 | 265792 | 2020-06-23 | Fountain | Indiana | 18045 | 24 | 2 |
265847 | 265847 | 2020-06-23 | Switzerland | Indiana | 18155 | 24 | 0 |
262664 | 262664 | 2020-06-22 | Fountain | Indiana | 18045 | 24 | 2 |
262719 | 262719 | 2020-06-22 | Switzerland | Indiana | 18155 | 24 | 0 |
259537 | 259537 | 2020-06-21 | Fountain | Indiana | 18045 | 24 | 2 |
259579 | 259579 | 2020-06-21 | Posey | Indiana | 18129 | 24 | 0 |
259592 | 259592 | 2020-06-21 | Switzerland | Indiana | 18155 | 24 | 0 |
256411 | 256411 | 2020-06-20 | Fountain | Indiana | 18045 | 24 | 2 |
256453 | 256453 | 2020-06-20 | Posey | Indiana | 18129 | 24 | 0 |
256466 | 256466 | 2020-06-20 | Switzerland | Indiana | 18155 | 24 | 0 |
253291 | 253291 | 2020-06-19 | Fountain | Indiana | 18045 | 24 | 2 |
253346 | 253346 | 2020-06-19 | Switzerland | Indiana | 18155 | 24 | 0 |
250176 | 250176 | 2020-06-18 | Fountain | Indiana | 18045 | 24 | 2 |
250179 | 250179 | 2020-06-18 | Gibson | Indiana | 18051 | 24 | 2 |
250231 | 250231 | 2020-06-18 | Switzerland | Indiana | 18155 | 24 | 0 |
247064 | 247064 | 2020-06-17 | Fountain | Indiana | 18045 | 24 | 2 |
247067 | 247067 | 2020-06-17 | Gibson | Indiana | 18051 | 24 | 2 |
247119 | 247119 | 2020-06-17 | Switzerland | Indiana | 18155 | 24 | 0 |
243951 | 243951 | 2020-06-16 | Fountain | Indiana | 18045 | 24 | 2 |
243954 | 243954 | 2020-06-16 | Gibson | Indiana | 18051 | 24 | 2 |
244006 | 244006 | 2020-06-16 | Switzerland | Indiana | 18155 | 24 | 0 |
240840 | 240840 | 2020-06-15 | Fountain | Indiana | 18045 | 24 | 2 |
240843 | 240843 | 2020-06-15 | Gibson | Indiana | 18051 | 24 | 2 |
240895 | 240895 | 2020-06-15 | Switzerland | Indiana | 18155 | 24 | 0 |
237732 | 237732 | 2020-06-14 | Fountain | Indiana | 18045 | 24 | 2 |
237787 | 237787 | 2020-06-14 | Switzerland | Indiana | 18155 | 24 | 0 |
234680 | 234680 | 2020-06-13 | Switzerland | Indiana | 18155 | 24 | 0 |
231497 | 231497 | 2020-06-12 | Adams | Indiana | 18001 | 24 | 1 |
231574 | 231574 | 2020-06-12 | Switzerland | Indiana | 18155 | 24 | 0 |
228394 | 228394 | 2020-06-11 | Adams | Indiana | 18001 | 24 | 1 |
228454 | 228454 | 2020-06-11 | Parke | Indiana | 18121 | 24 | 0 |
225292 | 225292 | 2020-06-10 | Adams | Indiana | 18001 | 24 | 1 |
225314 | 225314 | 2020-06-10 | Fountain | Indiana | 18045 | 24 | 2 |
225352 | 225352 | 2020-06-10 | Parke | Indiana | 18121 | 24 | 0 |
222257 | 222257 | 2020-06-09 | Parke | Indiana | 18121 | 24 | 0 |
213003 | 213003 | 2020-06-06 | Union | Indiana | 18161 | 24 | 0 |
206829 | 206829 | 2020-06-04 | Spencer | Indiana | 18147 | 24 | 1 |
203749 | 203749 | 2020-06-03 | Spencer | Indiana | 18147 | 24 | 1 |
200673 | 200673 | 2020-06-02 | Spencer | Indiana | 18147 | 24 | 1 |
185280 | 185280 | 2020-05-28 | Crawford | Indiana | 18025 | 24 | 1 |
182226 | 182226 | 2020-05-27 | Crawford | Indiana | 18025 | 24 | 1 |
179182 | 179182 | 2020-05-26 | Crawford | Indiana | 18025 | 24 | 1 |
179259 | 179259 | 2020-05-26 | Wells | Indiana | 18179 | 24 | 0 |
176138 | 176138 | 2020-05-25 | Crawford | Indiana | 18025 | 24 | 1 |
173085 | 173085 | 2020-05-24 | Benton | Indiana | 18007 | 24 | 0 |
173094 | 173094 | 2020-05-24 | Crawford | Indiana | 18025 | 24 | 1 |
170044 | 170044 | 2020-05-23 | Benton | Indiana | 18007 | 24 | 0 |
170053 | 170053 | 2020-05-23 | Crawford | Indiana | 18025 | 24 | 1 |
167007 | 167007 | 2020-05-22 | Benton | Indiana | 18007 | 24 | 0 |
167016 | 167016 | 2020-05-22 | Crawford | Indiana | 18025 | 24 | 1 |
167045 | 167045 | 2020-05-22 | Knox | Indiana | 18083 | 24 | 0 |
163974 | 163974 | 2020-05-21 | Benton | Indiana | 18007 | 24 | 0 |
164012 | 164012 | 2020-05-21 | Knox | Indiana | 18083 | 24 | 0 |
160946 | 160946 | 2020-05-20 | Benton | Indiana | 18007 | 24 | 0 |
160984 | 160984 | 2020-05-20 | Knox | Indiana | 18083 | 24 | 0 |
142913 | 142913 | 2020-05-14 | Jay | Indiana | 18075 | 24 | 0 |
142952 | 142952 | 2020-05-14 | Sullivan | Indiana | 18153 | 24 | 0 |
139890 | 139890 | 2020-05-13 | Clay | Indiana | 18021 | 24 | 1 |
136898 | 136898 | 2020-05-12 | Clay | Indiana | 18021 | 24 | 1 |
136962 | 136962 | 2020-05-12 | Starke | Indiana | 18149 | 24 | 2 |
133909 | 133909 | 2020-05-11 | Clay | Indiana | 18021 | 24 | 1 |
133913 | 133913 | 2020-05-11 | DeKalb | Indiana | 18033 | 24 | 2 |
130919 | 130919 | 2020-05-10 | Clay | Indiana | 18021 | 24 | 1 |
130923 | 130923 | 2020-05-10 | DeKalb | Indiana | 18033 | 24 | 2 |
130970 | 130970 | 2020-05-10 | Perry | Indiana | 18123 | 24 | 0 |
127928 | 127928 | 2020-05-09 | Clay | Indiana | 18021 | 24 | 1 |
127932 | 127932 | 2020-05-09 | DeKalb | Indiana | 18033 | 24 | 2 |
124941 | 124941 | 2020-05-08 | Clay | Indiana | 18021 | 24 | 1 |
124945 | 124945 | 2020-05-08 | DeKalb | Indiana | 18033 | 24 | 2 |
121965 | 121965 | 2020-05-07 | DeKalb | Indiana | 18033 | 24 | 2 |
122010 | 122010 | 2020-05-07 | Owen | Indiana | 18119 | 24 | 1 |
118995 | 118995 | 2020-05-06 | DeKalb | Indiana | 18033 | 24 | 2 |
119040 | 119040 | 2020-05-06 | Owen | Indiana | 18119 | 24 | 1 |
116080 | 116080 | 2020-05-05 | Owen | Indiana | 18119 | 24 | 1 |
110322 | 110322 | 2020-05-03 | Owen | Indiana | 18119 | 24 | 1 |
110330 | 110330 | 2020-05-03 | Randolph | Indiana | 18135 | 24 | 2 |
107411 | 107411 | 2020-05-02 | Dubois | Indiana | 18037 | 24 | 0 |
107452 | 107452 | 2020-05-02 | Owen | Indiana | 18119 | 24 | 1 |
104535 | 104535 | 2020-05-01 | Carroll | Indiana | 18015 | 24 | 1 |
98864 | 98864 | 2020-04-29 | LaGrange | Indiana | 18087 | 24 | 2 |
96020 | 96020 | 2020-04-28 | LaGrange | Indiana | 18087 | 24 | 2 |
79143 | 79143 | 2020-04-22 | Jasper | Indiana | 18073 | 24 | 1 |
79149 | 79149 | 2020-04-22 | Kosciusko | Indiana | 18085 | 24 | 2 |
76372 | 76372 | 2020-04-21 | Marshall | Indiana | 18099 | 24 | 0 |
73595 | 73595 | 2020-04-20 | Marshall | Indiana | 18099 | 24 | 0 |
73616 | 73616 | 2020-04-20 | Scott | Indiana | 18143 | 24 | 2 |
70845 | 70845 | 2020-04-19 | Scott | Indiana | 18143 | 24 | 2 |
65322 | 65322 | 2020-04-17 | Orange | Indiana | 18117 | 24 | 4 |
62543 | 62543 | 2020-04-16 | Daviess | Indiana | 18027 | 24 | 1 |
62562 | 62562 | 2020-04-16 | Henry | Indiana | 18065 | 24 | 1 |
49072 | 49072 | 2020-04-11 | Cass | Indiana | 18017 | 24 | 2 |
26705 | 26705 | 2020-04-02 | Jennings | Indiana | 18079 | 24 | 1 |
26732 | 26732 | 2020-04-02 | Shelby | Indiana | 18145 | 24 | 0 |
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);