ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 18179 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535213 | 535213 | 2020-09-15 | Wells | Indiana | 18179 | 252 | 2 |
531978 | 531978 | 2020-09-14 | Wells | Indiana | 18179 | 251 | 2 |
528741 | 528741 | 2020-09-13 | Wells | Indiana | 18179 | 248 | 2 |
525505 | 525505 | 2020-09-12 | Wells | Indiana | 18179 | 246 | 2 |
522269 | 522269 | 2020-09-11 | Wells | Indiana | 18179 | 246 | 2 |
519032 | 519032 | 2020-09-10 | Wells | Indiana | 18179 | 241 | 2 |
515797 | 515797 | 2020-09-09 | Wells | Indiana | 18179 | 239 | 2 |
512564 | 512564 | 2020-09-08 | Wells | Indiana | 18179 | 239 | 2 |
509331 | 509331 | 2020-09-07 | Wells | Indiana | 18179 | 238 | 2 |
506099 | 506099 | 2020-09-06 | Wells | Indiana | 18179 | 238 | 2 |
502865 | 502865 | 2020-09-05 | Wells | Indiana | 18179 | 233 | 2 |
499631 | 499631 | 2020-09-04 | Wells | Indiana | 18179 | 233 | 2 |
496398 | 496398 | 2020-09-03 | Wells | Indiana | 18179 | 233 | 2 |
493164 | 493164 | 2020-09-02 | Wells | Indiana | 18179 | 230 | 2 |
489931 | 489931 | 2020-09-01 | Wells | Indiana | 18179 | 228 | 2 |
486698 | 486698 | 2020-08-31 | Wells | Indiana | 18179 | 227 | 2 |
483463 | 483463 | 2020-08-30 | Wells | Indiana | 18179 | 225 | 2 |
480229 | 480229 | 2020-08-29 | Wells | Indiana | 18179 | 223 | 2 |
476996 | 476996 | 2020-08-28 | Wells | Indiana | 18179 | 222 | 2 |
473763 | 473763 | 2020-08-27 | Wells | Indiana | 18179 | 218 | 2 |
470531 | 470531 | 2020-08-26 | Wells | Indiana | 18179 | 218 | 2 |
467302 | 467302 | 2020-08-25 | Wells | Indiana | 18179 | 216 | 2 |
464073 | 464073 | 2020-08-24 | Wells | Indiana | 18179 | 211 | 2 |
460844 | 460844 | 2020-08-23 | Wells | Indiana | 18179 | 206 | 2 |
457617 | 457617 | 2020-08-22 | Wells | Indiana | 18179 | 205 | 2 |
454389 | 454389 | 2020-08-21 | Wells | Indiana | 18179 | 203 | 2 |
451161 | 451161 | 2020-08-20 | Wells | Indiana | 18179 | 201 | 2 |
447933 | 447933 | 2020-08-19 | Wells | Indiana | 18179 | 200 | 2 |
444706 | 444706 | 2020-08-18 | Wells | Indiana | 18179 | 200 | 2 |
441480 | 441480 | 2020-08-17 | Wells | Indiana | 18179 | 200 | 2 |
438254 | 438254 | 2020-08-16 | Wells | Indiana | 18179 | 198 | 2 |
435028 | 435028 | 2020-08-15 | Wells | Indiana | 18179 | 197 | 2 |
431803 | 431803 | 2020-08-14 | Wells | Indiana | 18179 | 197 | 2 |
428575 | 428575 | 2020-08-13 | Wells | Indiana | 18179 | 195 | 2 |
425351 | 425351 | 2020-08-12 | Wells | Indiana | 18179 | 195 | 2 |
422130 | 422130 | 2020-08-11 | Wells | Indiana | 18179 | 191 | 2 |
418907 | 418907 | 2020-08-10 | Wells | Indiana | 18179 | 188 | 2 |
415686 | 415686 | 2020-08-09 | Wells | Indiana | 18179 | 185 | 2 |
412466 | 412466 | 2020-08-08 | Wells | Indiana | 18179 | 179 | 2 |
409247 | 409247 | 2020-08-07 | Wells | Indiana | 18179 | 179 | 2 |
406027 | 406027 | 2020-08-06 | Wells | Indiana | 18179 | 171 | 2 |
402809 | 402809 | 2020-08-05 | Wells | Indiana | 18179 | 161 | 2 |
399593 | 399593 | 2020-08-04 | Wells | Indiana | 18179 | 151 | 2 |
396377 | 396377 | 2020-08-03 | Wells | Indiana | 18179 | 151 | 2 |
393161 | 393161 | 2020-08-02 | Wells | Indiana | 18179 | 148 | 2 |
389944 | 389944 | 2020-08-01 | Wells | Indiana | 18179 | 146 | 2 |
386727 | 386727 | 2020-07-31 | Wells | Indiana | 18179 | 141 | 2 |
383509 | 383509 | 2020-07-30 | Wells | Indiana | 18179 | 137 | 2 |
380292 | 380292 | 2020-07-29 | Wells | Indiana | 18179 | 134 | 2 |
377075 | 377075 | 2020-07-28 | Wells | Indiana | 18179 | 134 | 2 |
373860 | 373860 | 2020-07-27 | Wells | Indiana | 18179 | 134 | 1 |
370648 | 370648 | 2020-07-26 | Wells | Indiana | 18179 | 132 | 1 |
367438 | 367438 | 2020-07-25 | Wells | Indiana | 18179 | 127 | 1 |
364231 | 364231 | 2020-07-24 | Wells | Indiana | 18179 | 127 | 1 |
361024 | 361024 | 2020-07-23 | Wells | Indiana | 18179 | 123 | 1 |
357819 | 357819 | 2020-07-22 | Wells | Indiana | 18179 | 120 | 1 |
354617 | 354617 | 2020-07-21 | Wells | Indiana | 18179 | 118 | 1 |
351415 | 351415 | 2020-07-20 | Wells | Indiana | 18179 | 111 | 1 |
348215 | 348215 | 2020-07-19 | Wells | Indiana | 18179 | 111 | 1 |
345014 | 345014 | 2020-07-18 | Wells | Indiana | 18179 | 108 | 1 |
341814 | 341814 | 2020-07-17 | Wells | Indiana | 18179 | 106 | 1 |
338618 | 338618 | 2020-07-16 | Wells | Indiana | 18179 | 105 | 1 |
335422 | 335422 | 2020-07-15 | Wells | Indiana | 18179 | 102 | 1 |
332229 | 332229 | 2020-07-14 | Wells | Indiana | 18179 | 101 | 1 |
329042 | 329042 | 2020-07-13 | Wells | Indiana | 18179 | 100 | 1 |
325856 | 325856 | 2020-07-12 | Wells | Indiana | 18179 | 99 | 1 |
322675 | 322675 | 2020-07-11 | Wells | Indiana | 18179 | 99 | 1 |
319496 | 319496 | 2020-07-10 | Wells | Indiana | 18179 | 96 | 1 |
316323 | 316323 | 2020-07-09 | Wells | Indiana | 18179 | 96 | 1 |
313149 | 313149 | 2020-07-08 | Wells | Indiana | 18179 | 92 | 1 |
309979 | 309979 | 2020-07-07 | Wells | Indiana | 18179 | 92 | 1 |
306811 | 306811 | 2020-07-06 | Wells | Indiana | 18179 | 90 | 1 |
303646 | 303646 | 2020-07-05 | Wells | Indiana | 18179 | 89 | 1 |
300482 | 300482 | 2020-07-04 | Wells | Indiana | 18179 | 88 | 1 |
297320 | 297320 | 2020-07-03 | Wells | Indiana | 18179 | 88 | 1 |
294162 | 294162 | 2020-07-02 | Wells | Indiana | 18179 | 85 | 1 |
291008 | 291008 | 2020-07-01 | Wells | Indiana | 18179 | 85 | 1 |
287858 | 287858 | 2020-06-30 | Wells | Indiana | 18179 | 84 | 1 |
284709 | 284709 | 2020-06-29 | Wells | Indiana | 18179 | 84 | 1 |
281564 | 281564 | 2020-06-28 | Wells | Indiana | 18179 | 84 | 1 |
278416 | 278416 | 2020-06-27 | Wells | Indiana | 18179 | 83 | 1 |
275268 | 275268 | 2020-06-26 | Wells | Indiana | 18179 | 83 | 1 |
272126 | 272126 | 2020-06-25 | Wells | Indiana | 18179 | 83 | 1 |
268989 | 268989 | 2020-06-24 | Wells | Indiana | 18179 | 83 | 1 |
265859 | 265859 | 2020-06-23 | Wells | Indiana | 18179 | 75 | 1 |
262731 | 262731 | 2020-06-22 | Wells | Indiana | 18179 | 74 | 1 |
259604 | 259604 | 2020-06-21 | Wells | Indiana | 18179 | 72 | 1 |
256478 | 256478 | 2020-06-20 | Wells | Indiana | 18179 | 72 | 0 |
253358 | 253358 | 2020-06-19 | Wells | Indiana | 18179 | 65 | 0 |
250243 | 250243 | 2020-06-18 | Wells | Indiana | 18179 | 65 | 0 |
247131 | 247131 | 2020-06-17 | Wells | Indiana | 18179 | 63 | 0 |
244018 | 244018 | 2020-06-16 | Wells | Indiana | 18179 | 62 | 0 |
240907 | 240907 | 2020-06-15 | Wells | Indiana | 18179 | 56 | 0 |
237799 | 237799 | 2020-06-14 | Wells | Indiana | 18179 | 54 | 0 |
234692 | 234692 | 2020-06-13 | Wells | Indiana | 18179 | 53 | 0 |
231586 | 231586 | 2020-06-12 | Wells | Indiana | 18179 | 49 | 0 |
228483 | 228483 | 2020-06-11 | Wells | Indiana | 18179 | 47 | 0 |
225381 | 225381 | 2020-06-10 | Wells | Indiana | 18179 | 45 | 0 |
222286 | 222286 | 2020-06-09 | Wells | Indiana | 18179 | 43 | 0 |
219191 | 219191 | 2020-06-08 | Wells | Indiana | 18179 | 40 | 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);