ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Houston" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917227 | 917227 | 2021-01-11 | Houston | Alabama | 1069 | 8203 | 72 |
913982 | 913982 | 2021-01-10 | Houston | Alabama | 1069 | 8167 | 72 |
910737 | 910737 | 2021-01-09 | Houston | Alabama | 1069 | 8112 | 72 |
907492 | 907492 | 2021-01-08 | Houston | Alabama | 1069 | 8013 | 72 |
904246 | 904246 | 2021-01-07 | Houston | Alabama | 1069 | 7906 | 70 |
901001 | 901001 | 2021-01-06 | Houston | Alabama | 1069 | 7801 | 70 |
897756 | 897756 | 2021-01-05 | Houston | Alabama | 1069 | 7698 | 64 |
894510 | 894510 | 2021-01-04 | Houston | Alabama | 1069 | 7584 | 64 |
891264 | 891264 | 2021-01-03 | Houston | Alabama | 1069 | 7525 | 64 |
888017 | 888017 | 2021-01-02 | Houston | Alabama | 1069 | 7454 | 64 |
884772 | 884772 | 2021-01-01 | Houston | Alabama | 1069 | 7371 | 64 |
881527 | 881527 | 2020-12-31 | Houston | Alabama | 1069 | 7279 | 64 |
878282 | 878282 | 2020-12-30 | Houston | Alabama | 1069 | 7157 | 63 |
875037 | 875037 | 2020-12-29 | Houston | Alabama | 1069 | 7035 | 63 |
871792 | 871792 | 2020-12-28 | Houston | Alabama | 1069 | 6949 | 63 |
868547 | 868547 | 2020-12-27 | Houston | Alabama | 1069 | 6895 | 63 |
865302 | 865302 | 2020-12-26 | Houston | Alabama | 1069 | 6871 | 63 |
862057 | 862057 | 2020-12-25 | Houston | Alabama | 1069 | 6852 | 63 |
858812 | 858812 | 2020-12-24 | Houston | Alabama | 1069 | 6809 | 63 |
855567 | 855567 | 2020-12-23 | Houston | Alabama | 1069 | 6734 | 57 |
852322 | 852322 | 2020-12-22 | Houston | Alabama | 1069 | 6659 | 53 |
849077 | 849077 | 2020-12-21 | Houston | Alabama | 1069 | 6589 | 53 |
845832 | 845832 | 2020-12-20 | Houston | Alabama | 1069 | 6570 | 53 |
842586 | 842586 | 2020-12-19 | Houston | Alabama | 1069 | 6527 | 53 |
839341 | 839341 | 2020-12-18 | Houston | Alabama | 1069 | 6455 | 51 |
836096 | 836096 | 2020-12-17 | Houston | Alabama | 1069 | 6310 | 51 |
832850 | 832850 | 2020-12-16 | Houston | Alabama | 1069 | 6211 | 51 |
829603 | 829603 | 2020-12-15 | Houston | Alabama | 1069 | 6155 | 51 |
826357 | 826357 | 2020-12-14 | Houston | Alabama | 1069 | 6111 | 52 |
823110 | 823110 | 2020-12-13 | Houston | Alabama | 1069 | 6062 | 52 |
819864 | 819864 | 2020-12-12 | Houston | Alabama | 1069 | 6024 | 52 |
816618 | 816618 | 2020-12-11 | Houston | Alabama | 1069 | 5970 | 51 |
813372 | 813372 | 2020-12-10 | Houston | Alabama | 1069 | 5907 | 46 |
810128 | 810128 | 2020-12-09 | Houston | Alabama | 1069 | 5839 | 46 |
806883 | 806883 | 2020-12-08 | Houston | Alabama | 1069 | 5771 | 46 |
803638 | 803638 | 2020-12-07 | Houston | Alabama | 1069 | 5705 | 43 |
800393 | 800393 | 2020-12-06 | Houston | Alabama | 1069 | 5674 | 43 |
797148 | 797148 | 2020-12-05 | Houston | Alabama | 1069 | 5650 | 42 |
793903 | 793903 | 2020-12-04 | Houston | Alabama | 1069 | 5591 | 40 |
790658 | 790658 | 2020-12-03 | Houston | Alabama | 1069 | 5527 | 39 |
787413 | 787413 | 2020-12-02 | Houston | Alabama | 1069 | 5482 | 39 |
784169 | 784169 | 2020-12-01 | Houston | Alabama | 1069 | 5410 | 38 |
780924 | 780924 | 2020-11-30 | Houston | Alabama | 1069 | 5377 | 38 |
777678 | 777678 | 2020-11-29 | Houston | Alabama | 1069 | 5323 | 38 |
774433 | 774433 | 2020-11-28 | Houston | Alabama | 1069 | 5256 | 38 |
771188 | 771188 | 2020-11-27 | Houston | Alabama | 1069 | 5230 | 38 |
767942 | 767942 | 2020-11-26 | Houston | Alabama | 1069 | 5224 | 38 |
764697 | 764697 | 2020-11-25 | Houston | Alabama | 1069 | 5170 | 38 |
761452 | 761452 | 2020-11-24 | Houston | Alabama | 1069 | 5108 | 38 |
758207 | 758207 | 2020-11-23 | Houston | Alabama | 1069 | 5070 | 38 |
754960 | 754960 | 2020-11-22 | Houston | Alabama | 1069 | 5033 | 38 |
751714 | 751714 | 2020-11-21 | Houston | Alabama | 1069 | 4995 | 38 |
748468 | 748468 | 2020-11-20 | Houston | Alabama | 1069 | 4945 | 38 |
745222 | 745222 | 2020-11-19 | Houston | Alabama | 1069 | 4907 | 38 |
741975 | 741975 | 2020-11-18 | Houston | Alabama | 1069 | 4856 | 37 |
738728 | 738728 | 2020-11-17 | Houston | Alabama | 1069 | 4800 | 37 |
735484 | 735484 | 2020-11-16 | Houston | Alabama | 1069 | 4791 | 37 |
732238 | 732238 | 2020-11-15 | Houston | Alabama | 1069 | 4761 | 37 |
728993 | 728993 | 2020-11-14 | Houston | Alabama | 1069 | 4713 | 37 |
725750 | 725750 | 2020-11-13 | Houston | Alabama | 1069 | 4688 | 37 |
722507 | 722507 | 2020-11-12 | Houston | Alabama | 1069 | 4631 | 36 |
719264 | 719264 | 2020-11-11 | Houston | Alabama | 1069 | 4597 | 36 |
716021 | 716021 | 2020-11-10 | Houston | Alabama | 1069 | 4543 | 36 |
712777 | 712777 | 2020-11-09 | Houston | Alabama | 1069 | 4516 | 36 |
709533 | 709533 | 2020-11-08 | Houston | Alabama | 1069 | 4485 | 36 |
706289 | 706289 | 2020-11-07 | Houston | Alabama | 1069 | 4472 | 36 |
703046 | 703046 | 2020-11-06 | Houston | Alabama | 1069 | 4436 | 36 |
699803 | 699803 | 2020-11-05 | Houston | Alabama | 1069 | 4408 | 35 |
696559 | 696559 | 2020-11-04 | Houston | Alabama | 1069 | 4377 | 35 |
693317 | 693317 | 2020-11-03 | Houston | Alabama | 1069 | 4341 | 35 |
690074 | 690074 | 2020-11-02 | Houston | Alabama | 1069 | 4341 | 35 |
686829 | 686829 | 2020-11-01 | Houston | Alabama | 1069 | 4320 | 35 |
683585 | 683585 | 2020-10-31 | Houston | Alabama | 1069 | 4300 | 35 |
680342 | 680342 | 2020-10-30 | Houston | Alabama | 1069 | 4265 | 35 |
677099 | 677099 | 2020-10-29 | Houston | Alabama | 1069 | 4239 | 34 |
673856 | 673856 | 2020-10-28 | Houston | Alabama | 1069 | 4212 | 34 |
670614 | 670614 | 2020-10-27 | Houston | Alabama | 1069 | 4193 | 34 |
667371 | 667371 | 2020-10-26 | Houston | Alabama | 1069 | 4180 | 34 |
664126 | 664126 | 2020-10-25 | Houston | Alabama | 1069 | 4170 | 34 |
660882 | 660882 | 2020-10-24 | Houston | Alabama | 1069 | 4148 | 34 |
657638 | 657638 | 2020-10-23 | Houston | Alabama | 1069 | 3717 | 34 |
654393 | 654393 | 2020-10-22 | Houston | Alabama | 1069 | 3692 | 32 |
651148 | 651148 | 2020-10-21 | Houston | Alabama | 1069 | 3655 | 32 |
647904 | 647904 | 2020-10-20 | Houston | Alabama | 1069 | 3646 | 32 |
644659 | 644659 | 2020-10-19 | Houston | Alabama | 1069 | 3631 | 32 |
641411 | 641411 | 2020-10-18 | Houston | Alabama | 1069 | 3623 | 32 |
638164 | 638164 | 2020-10-17 | Houston | Alabama | 1069 | 3599 | 32 |
634919 | 634919 | 2020-10-16 | Houston | Alabama | 1069 | 3582 | 32 |
631674 | 631674 | 2020-10-15 | Houston | Alabama | 1069 | 3559 | 29 |
628430 | 628430 | 2020-10-14 | Houston | Alabama | 1069 | 3537 | 25 |
625187 | 625187 | 2020-10-13 | Houston | Alabama | 1069 | 3515 | 25 |
621944 | 621944 | 2020-10-12 | Houston | Alabama | 1069 | 3511 | 25 |
618701 | 618701 | 2020-10-11 | Houston | Alabama | 1069 | 3494 | 25 |
615459 | 615459 | 2020-10-10 | Houston | Alabama | 1069 | 3482 | 25 |
612218 | 612218 | 2020-10-09 | Houston | Alabama | 1069 | 3466 | 25 |
608976 | 608976 | 2020-10-08 | Houston | Alabama | 1069 | 3428 | 25 |
605733 | 605733 | 2020-10-07 | Houston | Alabama | 1069 | 3412 | 25 |
602491 | 602491 | 2020-10-06 | Houston | Alabama | 1069 | 3384 | 23 |
599248 | 599248 | 2020-10-05 | Houston | Alabama | 1069 | 3368 | 23 |
596005 | 596005 | 2020-10-04 | Houston | Alabama | 1069 | 3347 | 23 |
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);