ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Hamilton" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635615 | 635615 | 2020-10-16 | Hamilton | Indiana | 18057 | 5791 | 121 |
632369 | 632369 | 2020-10-15 | Hamilton | Indiana | 18057 | 5691 | 121 |
629125 | 629125 | 2020-10-14 | Hamilton | Indiana | 18057 | 5635 | 121 |
625882 | 625882 | 2020-10-13 | Hamilton | Indiana | 18057 | 5593 | 121 |
622640 | 622640 | 2020-10-12 | Hamilton | Indiana | 18057 | 5561 | 119 |
619396 | 619396 | 2020-10-11 | Hamilton | Indiana | 18057 | 5508 | 119 |
616154 | 616154 | 2020-10-10 | Hamilton | Indiana | 18057 | 5473 | 119 |
612913 | 612913 | 2020-10-09 | Hamilton | Indiana | 18057 | 5414 | 119 |
609671 | 609671 | 2020-10-08 | Hamilton | Indiana | 18057 | 5357 | 119 |
606428 | 606428 | 2020-10-07 | Hamilton | Indiana | 18057 | 5317 | 119 |
603186 | 603186 | 2020-10-06 | Hamilton | Indiana | 18057 | 5277 | 120 |
599943 | 599943 | 2020-10-05 | Hamilton | Indiana | 18057 | 5257 | 119 |
596701 | 596701 | 2020-10-04 | Hamilton | Indiana | 18057 | 5231 | 119 |
593459 | 593459 | 2020-10-03 | Hamilton | Indiana | 18057 | 5182 | 119 |
590218 | 590218 | 2020-10-02 | Hamilton | Indiana | 18057 | 5142 | 119 |
586977 | 586977 | 2020-10-01 | Hamilton | Indiana | 18057 | 5062 | 118 |
583737 | 583737 | 2020-09-30 | Hamilton | Indiana | 18057 | 5029 | 119 |
580498 | 580498 | 2020-09-29 | Hamilton | Indiana | 18057 | 4997 | 118 |
577257 | 577257 | 2020-09-28 | Hamilton | Indiana | 18057 | 4970 | 118 |
574015 | 574015 | 2020-09-27 | Hamilton | Indiana | 18057 | 4941 | 118 |
570772 | 570772 | 2020-09-26 | Hamilton | Indiana | 18057 | 4925 | 118 |
567530 | 567530 | 2020-09-25 | Hamilton | Indiana | 18057 | 4880 | 118 |
564290 | 564290 | 2020-09-24 | Hamilton | Indiana | 18057 | 4835 | 118 |
561050 | 561050 | 2020-09-23 | Hamilton | Indiana | 18057 | 4793 | 118 |
557814 | 557814 | 2020-09-22 | Hamilton | Indiana | 18057 | 4756 | 118 |
554577 | 554577 | 2020-09-21 | Hamilton | Indiana | 18057 | 4727 | 118 |
551338 | 551338 | 2020-09-20 | Hamilton | Indiana | 18057 | 4708 | 118 |
548099 | 548099 | 2020-09-19 | Hamilton | Indiana | 18057 | 4678 | 118 |
544861 | 544861 | 2020-09-18 | Hamilton | Indiana | 18057 | 4621 | 118 |
541625 | 541625 | 2020-09-17 | Hamilton | Indiana | 18057 | 4632 | 118 |
538388 | 538388 | 2020-09-16 | Hamilton | Indiana | 18057 | 4597 | 118 |
535152 | 535152 | 2020-09-15 | Hamilton | Indiana | 18057 | 4578 | 118 |
531917 | 531917 | 2020-09-14 | Hamilton | Indiana | 18057 | 4568 | 117 |
528680 | 528680 | 2020-09-13 | Hamilton | Indiana | 18057 | 4546 | 117 |
525444 | 525444 | 2020-09-12 | Hamilton | Indiana | 18057 | 4457 | 117 |
522208 | 522208 | 2020-09-11 | Hamilton | Indiana | 18057 | 4401 | 116 |
518971 | 518971 | 2020-09-10 | Hamilton | Indiana | 18057 | 4339 | 116 |
515736 | 515736 | 2020-09-09 | Hamilton | Indiana | 18057 | 4290 | 116 |
512503 | 512503 | 2020-09-08 | Hamilton | Indiana | 18057 | 4272 | 116 |
509270 | 509270 | 2020-09-07 | Hamilton | Indiana | 18057 | 4254 | 116 |
506038 | 506038 | 2020-09-06 | Hamilton | Indiana | 18057 | 4232 | 116 |
502804 | 502804 | 2020-09-05 | Hamilton | Indiana | 18057 | 4184 | 116 |
499570 | 499570 | 2020-09-04 | Hamilton | Indiana | 18057 | 4132 | 116 |
496337 | 496337 | 2020-09-03 | Hamilton | Indiana | 18057 | 4087 | 116 |
493103 | 493103 | 2020-09-02 | Hamilton | Indiana | 18057 | 4029 | 116 |
489870 | 489870 | 2020-09-01 | Hamilton | Indiana | 18057 | 3988 | 116 |
486637 | 486637 | 2020-08-31 | Hamilton | Indiana | 18057 | 3945 | 116 |
483402 | 483402 | 2020-08-30 | Hamilton | Indiana | 18057 | 3883 | 116 |
480168 | 480168 | 2020-08-29 | Hamilton | Indiana | 18057 | 3842 | 116 |
476935 | 476935 | 2020-08-28 | Hamilton | Indiana | 18057 | 3771 | 116 |
473702 | 473702 | 2020-08-27 | Hamilton | Indiana | 18057 | 3723 | 116 |
470470 | 470470 | 2020-08-26 | Hamilton | Indiana | 18057 | 3670 | 116 |
467241 | 467241 | 2020-08-25 | Hamilton | Indiana | 18057 | 3619 | 115 |
464012 | 464012 | 2020-08-24 | Hamilton | Indiana | 18057 | 3560 | 115 |
460783 | 460783 | 2020-08-23 | Hamilton | Indiana | 18057 | 3454 | 115 |
457556 | 457556 | 2020-08-22 | Hamilton | Indiana | 18057 | 3430 | 115 |
454328 | 454328 | 2020-08-21 | Hamilton | Indiana | 18057 | 3374 | 115 |
451100 | 451100 | 2020-08-20 | Hamilton | Indiana | 18057 | 3339 | 115 |
447872 | 447872 | 2020-08-19 | Hamilton | Indiana | 18057 | 3296 | 115 |
444645 | 444645 | 2020-08-18 | Hamilton | Indiana | 18057 | 3262 | 115 |
441419 | 441419 | 2020-08-17 | Hamilton | Indiana | 18057 | 3200 | 114 |
438193 | 438193 | 2020-08-16 | Hamilton | Indiana | 18057 | 3175 | 114 |
434967 | 434967 | 2020-08-15 | Hamilton | Indiana | 18057 | 3134 | 114 |
431742 | 431742 | 2020-08-14 | Hamilton | Indiana | 18057 | 3064 | 113 |
428514 | 428514 | 2020-08-13 | Hamilton | Indiana | 18057 | 2972 | 113 |
425290 | 425290 | 2020-08-12 | Hamilton | Indiana | 18057 | 2918 | 113 |
422069 | 422069 | 2020-08-11 | Hamilton | Indiana | 18057 | 2860 | 113 |
418846 | 418846 | 2020-08-10 | Hamilton | Indiana | 18057 | 2833 | 113 |
415625 | 415625 | 2020-08-09 | Hamilton | Indiana | 18057 | 2793 | 113 |
412405 | 412405 | 2020-08-08 | Hamilton | Indiana | 18057 | 2752 | 112 |
409186 | 409186 | 2020-08-07 | Hamilton | Indiana | 18057 | 2697 | 113 |
405966 | 405966 | 2020-08-06 | Hamilton | Indiana | 18057 | 2639 | 112 |
402748 | 402748 | 2020-08-05 | Hamilton | Indiana | 18057 | 2601 | 112 |
399532 | 399532 | 2020-08-04 | Hamilton | Indiana | 18057 | 2573 | 112 |
396316 | 396316 | 2020-08-03 | Hamilton | Indiana | 18057 | 2542 | 112 |
393100 | 393100 | 2020-08-02 | Hamilton | Indiana | 18057 | 2518 | 112 |
389883 | 389883 | 2020-08-01 | Hamilton | Indiana | 18057 | 2475 | 112 |
386666 | 386666 | 2020-07-31 | Hamilton | Indiana | 18057 | 2439 | 112 |
383448 | 383448 | 2020-07-30 | Hamilton | Indiana | 18057 | 2395 | 112 |
380231 | 380231 | 2020-07-29 | Hamilton | Indiana | 18057 | 2345 | 110 |
377014 | 377014 | 2020-07-28 | Hamilton | Indiana | 18057 | 2317 | 110 |
373799 | 373799 | 2020-07-27 | Hamilton | Indiana | 18057 | 2281 | 110 |
370587 | 370587 | 2020-07-26 | Hamilton | Indiana | 18057 | 2257 | 110 |
367377 | 367377 | 2020-07-25 | Hamilton | Indiana | 18057 | 2209 | 110 |
364170 | 364170 | 2020-07-24 | Hamilton | Indiana | 18057 | 2161 | 110 |
360963 | 360963 | 2020-07-23 | Hamilton | Indiana | 18057 | 2109 | 110 |
357758 | 357758 | 2020-07-22 | Hamilton | Indiana | 18057 | 2059 | 109 |
354556 | 354556 | 2020-07-21 | Hamilton | Indiana | 18057 | 2017 | 108 |
351354 | 351354 | 2020-07-20 | Hamilton | Indiana | 18057 | 1978 | 107 |
348154 | 348154 | 2020-07-19 | Hamilton | Indiana | 18057 | 1958 | 107 |
344953 | 344953 | 2020-07-18 | Hamilton | Indiana | 18057 | 1913 | 107 |
341753 | 341753 | 2020-07-17 | Hamilton | Indiana | 18057 | 1868 | 107 |
338557 | 338557 | 2020-07-16 | Hamilton | Indiana | 18057 | 1851 | 107 |
335361 | 335361 | 2020-07-15 | Hamilton | Indiana | 18057 | 1822 | 107 |
332168 | 332168 | 2020-07-14 | Hamilton | Indiana | 18057 | 1801 | 107 |
328981 | 328981 | 2020-07-13 | Hamilton | Indiana | 18057 | 1757 | 107 |
325795 | 325795 | 2020-07-12 | Hamilton | Indiana | 18057 | 1730 | 107 |
322614 | 322614 | 2020-07-11 | Hamilton | Indiana | 18057 | 1713 | 107 |
319435 | 319435 | 2020-07-10 | Hamilton | Indiana | 18057 | 1688 | 107 |
316262 | 316262 | 2020-07-09 | Hamilton | Indiana | 18057 | 1652 | 107 |
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);