ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 19013 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
765462 | 765462 | 2020-11-25 | Black Hawk | Iowa | 19013 | 10629 | 132 |
762217 | 762217 | 2020-11-24 | Black Hawk | Iowa | 19013 | 10541 | 131 |
758972 | 758972 | 2020-11-23 | Black Hawk | Iowa | 19013 | 10394 | 127 |
755725 | 755725 | 2020-11-22 | Black Hawk | Iowa | 19013 | 10209 | 126 |
752479 | 752479 | 2020-11-21 | Black Hawk | Iowa | 19013 | 10145 | 126 |
749233 | 749233 | 2020-11-20 | Black Hawk | Iowa | 19013 | 10006 | 125 |
745987 | 745987 | 2020-11-19 | Black Hawk | Iowa | 19013 | 9804 | 125 |
742740 | 742740 | 2020-11-18 | Black Hawk | Iowa | 19013 | 9616 | 124 |
739493 | 739493 | 2020-11-17 | Black Hawk | Iowa | 19013 | 9414 | 122 |
736249 | 736249 | 2020-11-16 | Black Hawk | Iowa | 19013 | 9272 | 118 |
733003 | 733003 | 2020-11-15 | Black Hawk | Iowa | 19013 | 9125 | 116 |
729758 | 729758 | 2020-11-14 | Black Hawk | Iowa | 19013 | 8967 | 115 |
726515 | 726515 | 2020-11-13 | Black Hawk | Iowa | 19013 | 8774 | 113 |
723272 | 723272 | 2020-11-12 | Black Hawk | Iowa | 19013 | 8571 | 112 |
720029 | 720029 | 2020-11-11 | Black Hawk | Iowa | 19013 | 8328 | 112 |
716786 | 716786 | 2020-11-10 | Black Hawk | Iowa | 19013 | 8103 | 110 |
713542 | 713542 | 2020-11-09 | Black Hawk | Iowa | 19013 | 7846 | 110 |
710298 | 710298 | 2020-11-08 | Black Hawk | Iowa | 19013 | 7648 | 108 |
707054 | 707054 | 2020-11-07 | Black Hawk | Iowa | 19013 | 7455 | 108 |
703811 | 703811 | 2020-11-06 | Black Hawk | Iowa | 19013 | 7253 | 107 |
700569 | 700569 | 2020-11-05 | Black Hawk | Iowa | 19013 | 7067 | 107 |
697325 | 697325 | 2020-11-04 | Black Hawk | Iowa | 19013 | 6797 | 106 |
694083 | 694083 | 2020-11-03 | Black Hawk | Iowa | 19013 | 6666 | 106 |
690840 | 690840 | 2020-11-02 | Black Hawk | Iowa | 19013 | 6525 | 104 |
687595 | 687595 | 2020-11-01 | Black Hawk | Iowa | 19013 | 6451 | 103 |
684351 | 684351 | 2020-10-31 | Black Hawk | Iowa | 19013 | 6352 | 102 |
681108 | 681108 | 2020-10-30 | Black Hawk | Iowa | 19013 | 6165 | 102 |
677865 | 677865 | 2020-10-29 | Black Hawk | Iowa | 19013 | 5982 | 102 |
674622 | 674622 | 2020-10-28 | Black Hawk | Iowa | 19013 | 5875 | 102 |
671380 | 671380 | 2020-10-27 | Black Hawk | Iowa | 19013 | 5737 | 101 |
668137 | 668137 | 2020-10-26 | Black Hawk | Iowa | 19013 | 5626 | 98 |
664893 | 664893 | 2020-10-25 | Black Hawk | Iowa | 19013 | 5574 | 98 |
661648 | 661648 | 2020-10-24 | Black Hawk | Iowa | 19013 | 5519 | 98 |
658404 | 658404 | 2020-10-23 | Black Hawk | Iowa | 19013 | 5448 | 98 |
655159 | 655159 | 2020-10-22 | Black Hawk | Iowa | 19013 | 5397 | 98 |
651914 | 651914 | 2020-10-21 | Black Hawk | Iowa | 19013 | 5307 | 98 |
648670 | 648670 | 2020-10-20 | Black Hawk | Iowa | 19013 | 5265 | 96 |
645425 | 645425 | 2020-10-19 | Black Hawk | Iowa | 19013 | 5191 | 96 |
642178 | 642178 | 2020-10-18 | Black Hawk | Iowa | 19013 | 5171 | 96 |
638931 | 638931 | 2020-10-17 | Black Hawk | Iowa | 19013 | 5155 | 96 |
635685 | 635685 | 2020-10-16 | Black Hawk | Iowa | 19013 | 5112 | 96 |
632439 | 632439 | 2020-10-15 | Black Hawk | Iowa | 19013 | 5052 | 96 |
629195 | 629195 | 2020-10-14 | Black Hawk | Iowa | 19013 | 5005 | 96 |
625952 | 625952 | 2020-10-13 | Black Hawk | Iowa | 19013 | 4965 | 96 |
622710 | 622710 | 2020-10-12 | Black Hawk | Iowa | 19013 | 4924 | 96 |
619466 | 619466 | 2020-10-11 | Black Hawk | Iowa | 19013 | 4916 | 96 |
616224 | 616224 | 2020-10-10 | Black Hawk | Iowa | 19013 | 4897 | 96 |
612983 | 612983 | 2020-10-09 | Black Hawk | Iowa | 19013 | 4832 | 96 |
609741 | 609741 | 2020-10-08 | Black Hawk | Iowa | 19013 | 4791 | 95 |
606498 | 606498 | 2020-10-07 | Black Hawk | Iowa | 19013 | 4739 | 95 |
603256 | 603256 | 2020-10-06 | Black Hawk | Iowa | 19013 | 4689 | 95 |
600013 | 600013 | 2020-10-05 | Black Hawk | Iowa | 19013 | 4663 | 94 |
596771 | 596771 | 2020-10-04 | Black Hawk | Iowa | 19013 | 4648 | 94 |
593529 | 593529 | 2020-10-03 | Black Hawk | Iowa | 19013 | 4641 | 93 |
590288 | 590288 | 2020-10-02 | Black Hawk | Iowa | 19013 | 4614 | 92 |
587047 | 587047 | 2020-10-01 | Black Hawk | Iowa | 19013 | 4590 | 92 |
583807 | 583807 | 2020-09-30 | Black Hawk | Iowa | 19013 | 4559 | 92 |
580568 | 580568 | 2020-09-29 | Black Hawk | Iowa | 19013 | 4541 | 92 |
577327 | 577327 | 2020-09-28 | Black Hawk | Iowa | 19013 | 4509 | 90 |
574085 | 574085 | 2020-09-27 | Black Hawk | Iowa | 19013 | 4500 | 90 |
570842 | 570842 | 2020-09-26 | Black Hawk | Iowa | 19013 | 4489 | 90 |
567600 | 567600 | 2020-09-25 | Black Hawk | Iowa | 19013 | 4472 | 90 |
564360 | 564360 | 2020-09-24 | Black Hawk | Iowa | 19013 | 4436 | 88 |
561120 | 561120 | 2020-09-23 | Black Hawk | Iowa | 19013 | 4421 | 88 |
557884 | 557884 | 2020-09-22 | Black Hawk | Iowa | 19013 | 4400 | 88 |
554647 | 554647 | 2020-09-21 | Black Hawk | Iowa | 19013 | 4375 | 86 |
551408 | 551408 | 2020-09-20 | Black Hawk | Iowa | 19013 | 4349 | 86 |
548169 | 548169 | 2020-09-19 | Black Hawk | Iowa | 19013 | 4336 | 86 |
544931 | 544931 | 2020-09-18 | Black Hawk | Iowa | 19013 | 4316 | 86 |
541695 | 541695 | 2020-09-17 | Black Hawk | Iowa | 19013 | 4284 | 85 |
538458 | 538458 | 2020-09-16 | Black Hawk | Iowa | 19013 | 4243 | 84 |
535222 | 535222 | 2020-09-15 | Black Hawk | Iowa | 19013 | 4218 | 83 |
531987 | 531987 | 2020-09-14 | Black Hawk | Iowa | 19013 | 4191 | 83 |
528750 | 528750 | 2020-09-13 | Black Hawk | Iowa | 19013 | 4179 | 82 |
525514 | 525514 | 2020-09-12 | Black Hawk | Iowa | 19013 | 4165 | 81 |
522278 | 522278 | 2020-09-11 | Black Hawk | Iowa | 19013 | 4145 | 81 |
519041 | 519041 | 2020-09-10 | Black Hawk | Iowa | 19013 | 4117 | 81 |
515806 | 515806 | 2020-09-09 | Black Hawk | Iowa | 19013 | 4077 | 81 |
512573 | 512573 | 2020-09-08 | Black Hawk | Iowa | 19013 | 4053 | 79 |
509340 | 509340 | 2020-09-07 | Black Hawk | Iowa | 19013 | 4037 | 79 |
506108 | 506108 | 2020-09-06 | Black Hawk | Iowa | 19013 | 4022 | 78 |
502874 | 502874 | 2020-09-05 | Black Hawk | Iowa | 19013 | 3993 | 78 |
499640 | 499640 | 2020-09-04 | Black Hawk | Iowa | 19013 | 3950 | 78 |
496407 | 496407 | 2020-09-03 | Black Hawk | Iowa | 19013 | 3902 | 76 |
493173 | 493173 | 2020-09-02 | Black Hawk | Iowa | 19013 | 3843 | 76 |
489940 | 489940 | 2020-09-01 | Black Hawk | Iowa | 19013 | 3830 | 76 |
486707 | 486707 | 2020-08-31 | Black Hawk | Iowa | 19013 | 3801 | 75 |
483472 | 483472 | 2020-08-30 | Black Hawk | Iowa | 19013 | 3787 | 74 |
480238 | 480238 | 2020-08-29 | Black Hawk | Iowa | 19013 | 3757 | 74 |
477005 | 477005 | 2020-08-28 | Black Hawk | Iowa | 19013 | 3704 | 74 |
473772 | 473772 | 2020-08-27 | Black Hawk | Iowa | 19013 | 3641 | 73 |
470540 | 470540 | 2020-08-26 | Black Hawk | Iowa | 19013 | 3580 | 72 |
467311 | 467311 | 2020-08-25 | Black Hawk | Iowa | 19013 | 3536 | 72 |
464082 | 464082 | 2020-08-24 | Black Hawk | Iowa | 19013 | 3523 | 71 |
460853 | 460853 | 2020-08-23 | Black Hawk | Iowa | 19013 | 3513 | 70 |
457626 | 457626 | 2020-08-22 | Black Hawk | Iowa | 19013 | 3501 | 69 |
454398 | 454398 | 2020-08-21 | Black Hawk | Iowa | 19013 | 3487 | 69 |
451170 | 451170 | 2020-08-20 | Black Hawk | Iowa | 19013 | 3433 | 67 |
447942 | 447942 | 2020-08-19 | Black Hawk | Iowa | 19013 | 3396 | 67 |
444715 | 444715 | 2020-08-18 | Black Hawk | Iowa | 19013 | 3343 | 67 |
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);