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 |
---|---|---|---|---|---|---|---|
1050293 | 1050293 | 2021-02-21 | Houston | Alabama | 1069 | 10002 | 255 |
1047046 | 1047046 | 2021-02-20 | Houston | Alabama | 1069 | 9991 | 255 |
1043801 | 1043801 | 2021-02-19 | Houston | Alabama | 1069 | 9979 | 255 |
1040556 | 1040556 | 2021-02-18 | Houston | Alabama | 1069 | 9969 | 251 |
1037311 | 1037311 | 2021-02-17 | Houston | Alabama | 1069 | 9947 | 251 |
1034066 | 1034066 | 2021-02-16 | Houston | Alabama | 1069 | 9930 | 247 |
1030820 | 1030820 | 2021-02-15 | Houston | Alabama | 1069 | 9919 | 247 |
1027573 | 1027573 | 2021-02-14 | Houston | Alabama | 1069 | 9892 | 247 |
1024328 | 1024328 | 2021-02-13 | Houston | Alabama | 1069 | 9873 | 247 |
1021083 | 1021083 | 2021-02-12 | Houston | Alabama | 1069 | 9842 | 246 |
1017838 | 1017838 | 2021-02-11 | Houston | Alabama | 1069 | 9821 | 244 |
1014593 | 1014593 | 2021-02-10 | Houston | Alabama | 1069 | 9788 | 242 |
1011348 | 1011348 | 2021-02-09 | Houston | Alabama | 1069 | 9753 | 232 |
1008102 | 1008102 | 2021-02-08 | Houston | Alabama | 1069 | 9740 | 230 |
1004856 | 1004856 | 2021-02-07 | Houston | Alabama | 1069 | 9720 | 230 |
1001610 | 1001610 | 2021-02-06 | Houston | Alabama | 1069 | 9700 | 230 |
998364 | 998364 | 2021-02-05 | Houston | Alabama | 1069 | 9658 | 230 |
995118 | 995118 | 2021-02-04 | Houston | Alabama | 1069 | 9625 | 227 |
991872 | 991872 | 2021-02-03 | Houston | Alabama | 1069 | 9578 | 220 |
988626 | 988626 | 2021-02-02 | Houston | Alabama | 1069 | 9536 | 210 |
985379 | 985379 | 2021-02-01 | Houston | Alabama | 1069 | 9499 | 209 |
982132 | 982132 | 2021-01-31 | Houston | Alabama | 1069 | 9471 | 209 |
978886 | 978886 | 2021-01-30 | Houston | Alabama | 1069 | 9369 | 200 |
975641 | 975641 | 2021-01-29 | Houston | Alabama | 1069 | 9369 | 200 |
972396 | 972396 | 2021-01-28 | Houston | Alabama | 1069 | 9301 | 190 |
969151 | 969151 | 2021-01-27 | Houston | Alabama | 1069 | 9221 | 182 |
965907 | 965907 | 2021-01-26 | Houston | Alabama | 1069 | 9097 | 168 |
962662 | 962662 | 2021-01-25 | Houston | Alabama | 1069 | 9031 | 164 |
959417 | 959417 | 2021-01-24 | Houston | Alabama | 1069 | 9009 | 164 |
956171 | 956171 | 2021-01-23 | Houston | Alabama | 1069 | 8988 | 164 |
952926 | 952926 | 2021-01-22 | Houston | Alabama | 1069 | 8886 | 158 |
949681 | 949681 | 2021-01-21 | Houston | Alabama | 1069 | 8813 | 156 |
946435 | 946435 | 2021-01-20 | Houston | Alabama | 1069 | 8746 | 156 |
943188 | 943188 | 2021-01-19 | Houston | Alabama | 1069 | 8681 | 148 |
939943 | 939943 | 2021-01-18 | Houston | Alabama | 1069 | 8630 | 148 |
936698 | 936698 | 2021-01-17 | Houston | Alabama | 1069 | 8598 | 148 |
933453 | 933453 | 2021-01-16 | Houston | Alabama | 1069 | 8556 | 148 |
930208 | 930208 | 2021-01-15 | Houston | Alabama | 1069 | 8474 | 129 |
926963 | 926963 | 2021-01-14 | Houston | Alabama | 1069 | 8405 | 123 |
923717 | 923717 | 2021-01-13 | Houston | Alabama | 1069 | 8348 | 111 |
920472 | 920472 | 2021-01-12 | Houston | Alabama | 1069 | 8266 | 83 |
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 |
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);