ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Hancock" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535153 | 535153 | 2020-09-15 | Hancock | Indiana | 18059 | 896 | 45 |
531918 | 531918 | 2020-09-14 | Hancock | Indiana | 18059 | 892 | 45 |
528681 | 528681 | 2020-09-13 | Hancock | Indiana | 18059 | 895 | 45 |
525445 | 525445 | 2020-09-12 | Hancock | Indiana | 18059 | 873 | 45 |
522209 | 522209 | 2020-09-11 | Hancock | Indiana | 18059 | 873 | 45 |
518972 | 518972 | 2020-09-10 | Hancock | Indiana | 18059 | 871 | 45 |
515737 | 515737 | 2020-09-09 | Hancock | Indiana | 18059 | 865 | 45 |
512504 | 512504 | 2020-09-08 | Hancock | Indiana | 18059 | 864 | 45 |
509271 | 509271 | 2020-09-07 | Hancock | Indiana | 18059 | 861 | 45 |
506039 | 506039 | 2020-09-06 | Hancock | Indiana | 18059 | 861 | 45 |
502805 | 502805 | 2020-09-05 | Hancock | Indiana | 18059 | 855 | 45 |
499571 | 499571 | 2020-09-04 | Hancock | Indiana | 18059 | 851 | 44 |
496338 | 496338 | 2020-09-03 | Hancock | Indiana | 18059 | 843 | 44 |
493104 | 493104 | 2020-09-02 | Hancock | Indiana | 18059 | 839 | 44 |
489871 | 489871 | 2020-09-01 | Hancock | Indiana | 18059 | 835 | 44 |
486638 | 486638 | 2020-08-31 | Hancock | Indiana | 18059 | 837 | 44 |
483403 | 483403 | 2020-08-30 | Hancock | Indiana | 18059 | 832 | 44 |
480169 | 480169 | 2020-08-29 | Hancock | Indiana | 18059 | 826 | 44 |
476936 | 476936 | 2020-08-28 | Hancock | Indiana | 18059 | 817 | 44 |
473703 | 473703 | 2020-08-27 | Hancock | Indiana | 18059 | 806 | 44 |
470471 | 470471 | 2020-08-26 | Hancock | Indiana | 18059 | 799 | 44 |
467242 | 467242 | 2020-08-25 | Hancock | Indiana | 18059 | 793 | 44 |
464013 | 464013 | 2020-08-24 | Hancock | Indiana | 18059 | 790 | 44 |
460784 | 460784 | 2020-08-23 | Hancock | Indiana | 18059 | 763 | 44 |
457557 | 457557 | 2020-08-22 | Hancock | Indiana | 18059 | 761 | 44 |
454329 | 454329 | 2020-08-21 | Hancock | Indiana | 18059 | 750 | 44 |
451101 | 451101 | 2020-08-20 | Hancock | Indiana | 18059 | 747 | 43 |
447873 | 447873 | 2020-08-19 | Hancock | Indiana | 18059 | 741 | 43 |
444646 | 444646 | 2020-08-18 | Hancock | Indiana | 18059 | 734 | 42 |
441420 | 441420 | 2020-08-17 | Hancock | Indiana | 18059 | 730 | 42 |
438194 | 438194 | 2020-08-16 | Hancock | Indiana | 18059 | 728 | 41 |
434968 | 434968 | 2020-08-15 | Hancock | Indiana | 18059 | 720 | 41 |
431743 | 431743 | 2020-08-14 | Hancock | Indiana | 18059 | 711 | 40 |
428515 | 428515 | 2020-08-13 | Hancock | Indiana | 18059 | 703 | 40 |
425291 | 425291 | 2020-08-12 | Hancock | Indiana | 18059 | 697 | 40 |
422070 | 422070 | 2020-08-11 | Hancock | Indiana | 18059 | 692 | 40 |
418847 | 418847 | 2020-08-10 | Hancock | Indiana | 18059 | 678 | 39 |
415626 | 415626 | 2020-08-09 | Hancock | Indiana | 18059 | 668 | 39 |
412406 | 412406 | 2020-08-08 | Hancock | Indiana | 18059 | 655 | 39 |
409187 | 409187 | 2020-08-07 | Hancock | Indiana | 18059 | 648 | 39 |
405967 | 405967 | 2020-08-06 | Hancock | Indiana | 18059 | 644 | 39 |
402749 | 402749 | 2020-08-05 | Hancock | Indiana | 18059 | 640 | 39 |
399533 | 399533 | 2020-08-04 | Hancock | Indiana | 18059 | 634 | 39 |
396317 | 396317 | 2020-08-03 | Hancock | Indiana | 18059 | 629 | 38 |
393101 | 393101 | 2020-08-02 | Hancock | Indiana | 18059 | 622 | 38 |
389884 | 389884 | 2020-08-01 | Hancock | Indiana | 18059 | 614 | 38 |
386667 | 386667 | 2020-07-31 | Hancock | Indiana | 18059 | 603 | 38 |
383449 | 383449 | 2020-07-30 | Hancock | Indiana | 18059 | 597 | 38 |
380232 | 380232 | 2020-07-29 | Hancock | Indiana | 18059 | 593 | 38 |
377015 | 377015 | 2020-07-28 | Hancock | Indiana | 18059 | 585 | 38 |
373800 | 373800 | 2020-07-27 | Hancock | Indiana | 18059 | 586 | 38 |
370588 | 370588 | 2020-07-26 | Hancock | Indiana | 18059 | 576 | 38 |
367378 | 367378 | 2020-07-25 | Hancock | Indiana | 18059 | 574 | 38 |
364171 | 364171 | 2020-07-24 | Hancock | Indiana | 18059 | 551 | 38 |
360964 | 360964 | 2020-07-23 | Hancock | Indiana | 18059 | 535 | 38 |
357759 | 357759 | 2020-07-22 | Hancock | Indiana | 18059 | 533 | 37 |
354557 | 354557 | 2020-07-21 | Hancock | Indiana | 18059 | 524 | 37 |
351355 | 351355 | 2020-07-20 | Hancock | Indiana | 18059 | 516 | 37 |
348155 | 348155 | 2020-07-19 | Hancock | Indiana | 18059 | 511 | 37 |
344954 | 344954 | 2020-07-18 | Hancock | Indiana | 18059 | 503 | 37 |
341754 | 341754 | 2020-07-17 | Hancock | Indiana | 18059 | 489 | 37 |
338558 | 338558 | 2020-07-16 | Hancock | Indiana | 18059 | 485 | 37 |
335362 | 335362 | 2020-07-15 | Hancock | Indiana | 18059 | 481 | 37 |
332169 | 332169 | 2020-07-14 | Hancock | Indiana | 18059 | 477 | 37 |
328982 | 328982 | 2020-07-13 | Hancock | Indiana | 18059 | 479 | 37 |
325796 | 325796 | 2020-07-12 | Hancock | Indiana | 18059 | 473 | 37 |
322615 | 322615 | 2020-07-11 | Hancock | Indiana | 18059 | 472 | 37 |
319436 | 319436 | 2020-07-10 | Hancock | Indiana | 18059 | 465 | 37 |
316263 | 316263 | 2020-07-09 | Hancock | Indiana | 18059 | 462 | 37 |
313089 | 313089 | 2020-07-08 | Hancock | Indiana | 18059 | 457 | 37 |
309919 | 309919 | 2020-07-07 | Hancock | Indiana | 18059 | 454 | 36 |
306751 | 306751 | 2020-07-06 | Hancock | Indiana | 18059 | 455 | 36 |
303586 | 303586 | 2020-07-05 | Hancock | Indiana | 18059 | 453 | 36 |
300422 | 300422 | 2020-07-04 | Hancock | Indiana | 18059 | 445 | 36 |
297260 | 297260 | 2020-07-03 | Hancock | Indiana | 18059 | 442 | 36 |
294102 | 294102 | 2020-07-02 | Hancock | Indiana | 18059 | 431 | 36 |
290948 | 290948 | 2020-07-01 | Hancock | Indiana | 18059 | 434 | 36 |
287798 | 287798 | 2020-06-30 | Hancock | Indiana | 18059 | 423 | 36 |
284649 | 284649 | 2020-06-29 | Hancock | Indiana | 18059 | 418 | 36 |
281504 | 281504 | 2020-06-28 | Hancock | Indiana | 18059 | 413 | 36 |
278356 | 278356 | 2020-06-27 | Hancock | Indiana | 18059 | 409 | 36 |
275208 | 275208 | 2020-06-26 | Hancock | Indiana | 18059 | 402 | 36 |
272066 | 272066 | 2020-06-25 | Hancock | Indiana | 18059 | 402 | 36 |
268929 | 268929 | 2020-06-24 | Hancock | Indiana | 18059 | 399 | 35 |
265799 | 265799 | 2020-06-23 | Hancock | Indiana | 18059 | 397 | 35 |
262671 | 262671 | 2020-06-22 | Hancock | Indiana | 18059 | 397 | 34 |
259544 | 259544 | 2020-06-21 | Hancock | Indiana | 18059 | 395 | 34 |
256418 | 256418 | 2020-06-20 | Hancock | Indiana | 18059 | 392 | 33 |
253298 | 253298 | 2020-06-19 | Hancock | Indiana | 18059 | 389 | 32 |
250183 | 250183 | 2020-06-18 | Hancock | Indiana | 18059 | 386 | 31 |
247071 | 247071 | 2020-06-17 | Hancock | Indiana | 18059 | 386 | 31 |
243958 | 243958 | 2020-06-16 | Hancock | Indiana | 18059 | 385 | 30 |
240847 | 240847 | 2020-06-15 | Hancock | Indiana | 18059 | 390 | 30 |
237739 | 237739 | 2020-06-14 | Hancock | Indiana | 18059 | 383 | 30 |
234632 | 234632 | 2020-06-13 | Hancock | Indiana | 18059 | 378 | 30 |
231526 | 231526 | 2020-06-12 | Hancock | Indiana | 18059 | 375 | 29 |
228423 | 228423 | 2020-06-11 | Hancock | Indiana | 18059 | 371 | 29 |
225321 | 225321 | 2020-06-10 | Hancock | Indiana | 18059 | 371 | 29 |
222226 | 222226 | 2020-06-09 | Hancock | Indiana | 18059 | 371 | 29 |
219131 | 219131 | 2020-06-08 | Hancock | Indiana | 18059 | 370 | 28 |
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);