ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,556 rows where county = "Spencer" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
297303 | 297303 | 2020-07-03 | Spencer | Indiana | 18147 | 38 | 1 |
297626 | 297626 | 2020-07-03 | Spencer | Kentucky | 21215 | 38 | 0 |
294145 | 294145 | 2020-07-02 | Spencer | Indiana | 18147 | 36 | 1 |
294468 | 294468 | 2020-07-02 | Spencer | Kentucky | 21215 | 37 | 0 |
290991 | 290991 | 2020-07-01 | Spencer | Indiana | 18147 | 34 | 1 |
291314 | 291314 | 2020-07-01 | Spencer | Kentucky | 21215 | 37 | 0 |
287841 | 287841 | 2020-06-30 | Spencer | Indiana | 18147 | 33 | 1 |
288163 | 288163 | 2020-06-30 | Spencer | Kentucky | 21215 | 36 | 0 |
284692 | 284692 | 2020-06-29 | Spencer | Indiana | 18147 | 33 | 1 |
285014 | 285014 | 2020-06-29 | Spencer | Kentucky | 21215 | 36 | 0 |
281547 | 281547 | 2020-06-28 | Spencer | Indiana | 18147 | 33 | 1 |
281868 | 281868 | 2020-06-28 | Spencer | Kentucky | 21215 | 36 | 0 |
278399 | 278399 | 2020-06-27 | Spencer | Indiana | 18147 | 33 | 1 |
278720 | 278720 | 2020-06-27 | Spencer | Kentucky | 21215 | 36 | 0 |
275251 | 275251 | 2020-06-26 | Spencer | Indiana | 18147 | 31 | 1 |
275572 | 275572 | 2020-06-26 | Spencer | Kentucky | 21215 | 33 | 0 |
272109 | 272109 | 2020-06-25 | Spencer | Indiana | 18147 | 31 | 1 |
272429 | 272429 | 2020-06-25 | Spencer | Kentucky | 21215 | 33 | 0 |
268972 | 268972 | 2020-06-24 | Spencer | Indiana | 18147 | 30 | 1 |
269293 | 269293 | 2020-06-24 | Spencer | Kentucky | 21215 | 33 | 0 |
265842 | 265842 | 2020-06-23 | Spencer | Indiana | 18147 | 28 | 1 |
266160 | 266160 | 2020-06-23 | Spencer | Kentucky | 21215 | 31 | 0 |
262714 | 262714 | 2020-06-22 | Spencer | Indiana | 18147 | 28 | 1 |
263033 | 263033 | 2020-06-22 | Spencer | Kentucky | 21215 | 29 | 0 |
259587 | 259587 | 2020-06-21 | Spencer | Indiana | 18147 | 27 | 1 |
259904 | 259904 | 2020-06-21 | Spencer | Kentucky | 21215 | 29 | 0 |
256461 | 256461 | 2020-06-20 | Spencer | Indiana | 18147 | 27 | 1 |
256778 | 256778 | 2020-06-20 | Spencer | Kentucky | 21215 | 29 | 0 |
253341 | 253341 | 2020-06-19 | Spencer | Indiana | 18147 | 27 | 1 |
253658 | 253658 | 2020-06-19 | Spencer | Kentucky | 21215 | 28 | 0 |
250226 | 250226 | 2020-06-18 | Spencer | Indiana | 18147 | 26 | 1 |
250543 | 250543 | 2020-06-18 | Spencer | Kentucky | 21215 | 28 | 0 |
247114 | 247114 | 2020-06-17 | Spencer | Indiana | 18147 | 26 | 1 |
247431 | 247431 | 2020-06-17 | Spencer | Kentucky | 21215 | 26 | 0 |
244001 | 244001 | 2020-06-16 | Spencer | Indiana | 18147 | 26 | 1 |
244318 | 244318 | 2020-06-16 | Spencer | Kentucky | 21215 | 26 | 0 |
240890 | 240890 | 2020-06-15 | Spencer | Indiana | 18147 | 26 | 1 |
241207 | 241207 | 2020-06-15 | Spencer | Kentucky | 21215 | 26 | 0 |
237782 | 237782 | 2020-06-14 | Spencer | Indiana | 18147 | 26 | 1 |
238098 | 238098 | 2020-06-14 | Spencer | Kentucky | 21215 | 26 | 0 |
234675 | 234675 | 2020-06-13 | Spencer | Indiana | 18147 | 25 | 1 |
234991 | 234991 | 2020-06-13 | Spencer | Kentucky | 21215 | 26 | 0 |
231569 | 231569 | 2020-06-12 | Spencer | Indiana | 18147 | 25 | 1 |
231886 | 231886 | 2020-06-12 | Spencer | Kentucky | 21215 | 25 | 0 |
228466 | 228466 | 2020-06-11 | Spencer | Indiana | 18147 | 25 | 1 |
228782 | 228782 | 2020-06-11 | Spencer | Kentucky | 21215 | 25 | 0 |
225364 | 225364 | 2020-06-10 | Spencer | Indiana | 18147 | 25 | 1 |
225680 | 225680 | 2020-06-10 | Spencer | Kentucky | 21215 | 25 | 0 |
222269 | 222269 | 2020-06-09 | Spencer | Indiana | 18147 | 25 | 1 |
222584 | 222584 | 2020-06-09 | Spencer | Kentucky | 21215 | 25 | 0 |
219174 | 219174 | 2020-06-08 | Spencer | Indiana | 18147 | 25 | 1 |
219489 | 219489 | 2020-06-08 | Spencer | Kentucky | 21215 | 25 | 0 |
216082 | 216082 | 2020-06-07 | Spencer | Indiana | 18147 | 25 | 1 |
216397 | 216397 | 2020-06-07 | Spencer | Kentucky | 21215 | 25 | 0 |
212995 | 212995 | 2020-06-06 | Spencer | Indiana | 18147 | 25 | 1 |
213310 | 213310 | 2020-06-06 | Spencer | Kentucky | 21215 | 25 | 0 |
209910 | 209910 | 2020-06-05 | Spencer | Indiana | 18147 | 25 | 1 |
210225 | 210225 | 2020-06-05 | Spencer | Kentucky | 21215 | 24 | 0 |
206829 | 206829 | 2020-06-04 | Spencer | Indiana | 18147 | 24 | 1 |
207144 | 207144 | 2020-06-04 | Spencer | Kentucky | 21215 | 24 | 0 |
203749 | 203749 | 2020-06-03 | Spencer | Indiana | 18147 | 24 | 1 |
204063 | 204063 | 2020-06-03 | Spencer | Kentucky | 21215 | 24 | 0 |
200673 | 200673 | 2020-06-02 | Spencer | Indiana | 18147 | 24 | 1 |
200986 | 200986 | 2020-06-02 | Spencer | Kentucky | 21215 | 22 | 0 |
197600 | 197600 | 2020-06-01 | Spencer | Indiana | 18147 | 23 | 1 |
197914 | 197914 | 2020-06-01 | Spencer | Kentucky | 21215 | 22 | 0 |
194530 | 194530 | 2020-05-31 | Spencer | Indiana | 18147 | 23 | 1 |
194843 | 194843 | 2020-05-31 | Spencer | Kentucky | 21215 | 22 | 0 |
191463 | 191463 | 2020-05-30 | Spencer | Indiana | 18147 | 23 | 1 |
191775 | 191775 | 2020-05-30 | Spencer | Kentucky | 21215 | 22 | 0 |
188398 | 188398 | 2020-05-29 | Spencer | Indiana | 18147 | 22 | 1 |
188711 | 188711 | 2020-05-29 | Spencer | Kentucky | 21215 | 19 | 0 |
185340 | 185340 | 2020-05-28 | Spencer | Indiana | 18147 | 22 | 1 |
185653 | 185653 | 2020-05-28 | Spencer | Kentucky | 21215 | 19 | 0 |
182286 | 182286 | 2020-05-27 | Spencer | Indiana | 18147 | 20 | 1 |
182598 | 182598 | 2020-05-27 | Spencer | Kentucky | 21215 | 17 | 0 |
179242 | 179242 | 2020-05-26 | Spencer | Indiana | 18147 | 20 | 1 |
179553 | 179553 | 2020-05-26 | Spencer | Kentucky | 21215 | 17 | 0 |
176198 | 176198 | 2020-05-25 | Spencer | Indiana | 18147 | 19 | 1 |
176509 | 176509 | 2020-05-25 | Spencer | Kentucky | 21215 | 16 | 0 |
173154 | 173154 | 2020-05-24 | Spencer | Indiana | 18147 | 17 | 1 |
173465 | 173465 | 2020-05-24 | Spencer | Kentucky | 21215 | 16 | 0 |
170113 | 170113 | 2020-05-23 | Spencer | Indiana | 18147 | 17 | 1 |
170424 | 170424 | 2020-05-23 | Spencer | Kentucky | 21215 | 16 | 0 |
167076 | 167076 | 2020-05-22 | Spencer | Indiana | 18147 | 17 | 1 |
167386 | 167386 | 2020-05-22 | Spencer | Kentucky | 21215 | 16 | 0 |
164043 | 164043 | 2020-05-21 | Spencer | Indiana | 18147 | 16 | 1 |
164350 | 164350 | 2020-05-21 | Spencer | Kentucky | 21215 | 16 | 0 |
161015 | 161015 | 2020-05-20 | Spencer | Indiana | 18147 | 16 | 1 |
161321 | 161321 | 2020-05-20 | Spencer | Kentucky | 21215 | 16 | 0 |
157989 | 157989 | 2020-05-19 | Spencer | Indiana | 18147 | 15 | 1 |
158295 | 158295 | 2020-05-19 | Spencer | Kentucky | 21215 | 16 | 0 |
154973 | 154973 | 2020-05-18 | Spencer | Indiana | 18147 | 15 | 1 |
155278 | 155278 | 2020-05-18 | Spencer | Kentucky | 21215 | 16 | 0 |
151961 | 151961 | 2020-05-17 | Spencer | Indiana | 18147 | 14 | 1 |
152264 | 152264 | 2020-05-17 | Spencer | Kentucky | 21215 | 16 | 0 |
148952 | 148952 | 2020-05-16 | Spencer | Indiana | 18147 | 11 | 1 |
149253 | 149253 | 2020-05-16 | Spencer | Kentucky | 21215 | 16 | 0 |
145948 | 145948 | 2020-05-15 | Spencer | Indiana | 18147 | 10 | 1 |
146248 | 146248 | 2020-05-15 | Spencer | Kentucky | 21215 | 16 | 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);