ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walker" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917256 | 917256 | 2021-01-11 | Walker | Alabama | 1127 | 5758 | 170 |
914011 | 914011 | 2021-01-10 | Walker | Alabama | 1127 | 5734 | 170 |
910766 | 910766 | 2021-01-09 | Walker | Alabama | 1127 | 5714 | 170 |
907521 | 907521 | 2021-01-08 | Walker | Alabama | 1127 | 5648 | 170 |
904275 | 904275 | 2021-01-07 | Walker | Alabama | 1127 | 5537 | 170 |
901030 | 901030 | 2021-01-06 | Walker | Alabama | 1127 | 5464 | 139 |
897785 | 897785 | 2021-01-05 | Walker | Alabama | 1127 | 5421 | 138 |
894539 | 894539 | 2021-01-04 | Walker | Alabama | 1127 | 5377 | 138 |
891293 | 891293 | 2021-01-03 | Walker | Alabama | 1127 | 5374 | 138 |
888046 | 888046 | 2021-01-02 | Walker | Alabama | 1127 | 5357 | 138 |
884801 | 884801 | 2021-01-01 | Walker | Alabama | 1127 | 5296 | 138 |
881556 | 881556 | 2020-12-31 | Walker | Alabama | 1127 | 5259 | 138 |
878311 | 878311 | 2020-12-30 | Walker | Alabama | 1127 | 5185 | 137 |
875066 | 875066 | 2020-12-29 | Walker | Alabama | 1127 | 5069 | 136 |
871821 | 871821 | 2020-12-28 | Walker | Alabama | 1127 | 5046 | 133 |
868576 | 868576 | 2020-12-27 | Walker | Alabama | 1127 | 5036 | 133 |
865331 | 865331 | 2020-12-26 | Walker | Alabama | 1127 | 5022 | 133 |
862086 | 862086 | 2020-12-25 | Walker | Alabama | 1127 | 4994 | 133 |
858841 | 858841 | 2020-12-24 | Walker | Alabama | 1127 | 4933 | 133 |
855596 | 855596 | 2020-12-23 | Walker | Alabama | 1127 | 4882 | 132 |
852351 | 852351 | 2020-12-22 | Walker | Alabama | 1127 | 4825 | 132 |
849106 | 849106 | 2020-12-21 | Walker | Alabama | 1127 | 4741 | 131 |
845861 | 845861 | 2020-12-20 | Walker | Alabama | 1127 | 4720 | 131 |
842615 | 842615 | 2020-12-19 | Walker | Alabama | 1127 | 4699 | 131 |
839370 | 839370 | 2020-12-18 | Walker | Alabama | 1127 | 4648 | 130 |
836125 | 836125 | 2020-12-17 | Walker | Alabama | 1127 | 4568 | 125 |
832879 | 832879 | 2020-12-16 | Walker | Alabama | 1127 | 4512 | 123 |
829632 | 829632 | 2020-12-15 | Walker | Alabama | 1127 | 4479 | 116 |
826386 | 826386 | 2020-12-14 | Walker | Alabama | 1127 | 4445 | 113 |
823139 | 823139 | 2020-12-13 | Walker | Alabama | 1127 | 4424 | 113 |
819893 | 819893 | 2020-12-12 | Walker | Alabama | 1127 | 4396 | 113 |
816647 | 816647 | 2020-12-11 | Walker | Alabama | 1127 | 4355 | 113 |
813401 | 813401 | 2020-12-10 | Walker | Alabama | 1127 | 4293 | 113 |
810157 | 810157 | 2020-12-09 | Walker | Alabama | 1127 | 4190 | 113 |
806912 | 806912 | 2020-12-08 | Walker | Alabama | 1127 | 4128 | 113 |
803667 | 803667 | 2020-12-07 | Walker | Alabama | 1127 | 4002 | 113 |
800422 | 800422 | 2020-12-06 | Walker | Alabama | 1127 | 3983 | 112 |
797177 | 797177 | 2020-12-05 | Walker | Alabama | 1127 | 3950 | 112 |
793932 | 793932 | 2020-12-04 | Walker | Alabama | 1127 | 3914 | 112 |
790687 | 790687 | 2020-12-03 | Walker | Alabama | 1127 | 3861 | 112 |
787442 | 787442 | 2020-12-02 | Walker | Alabama | 1127 | 3818 | 111 |
784198 | 784198 | 2020-12-01 | Walker | Alabama | 1127 | 3735 | 111 |
780953 | 780953 | 2020-11-30 | Walker | Alabama | 1127 | 3710 | 111 |
777707 | 777707 | 2020-11-29 | Walker | Alabama | 1127 | 3689 | 111 |
774462 | 774462 | 2020-11-28 | Walker | Alabama | 1127 | 3657 | 111 |
771217 | 771217 | 2020-11-27 | Walker | Alabama | 1127 | 3634 | 111 |
767971 | 767971 | 2020-11-26 | Walker | Alabama | 1127 | 3620 | 111 |
764726 | 764726 | 2020-11-25 | Walker | Alabama | 1127 | 3588 | 108 |
761481 | 761481 | 2020-11-24 | Walker | Alabama | 1127 | 3561 | 99 |
758236 | 758236 | 2020-11-23 | Walker | Alabama | 1127 | 3490 | 96 |
754989 | 754989 | 2020-11-22 | Walker | Alabama | 1127 | 3480 | 96 |
751743 | 751743 | 2020-11-21 | Walker | Alabama | 1127 | 3458 | 96 |
748497 | 748497 | 2020-11-20 | Walker | Alabama | 1127 | 3424 | 96 |
745251 | 745251 | 2020-11-19 | Walker | Alabama | 1127 | 3399 | 96 |
742004 | 742004 | 2020-11-18 | Walker | Alabama | 1127 | 3377 | 96 |
738757 | 738757 | 2020-11-17 | Walker | Alabama | 1127 | 3326 | 96 |
735513 | 735513 | 2020-11-16 | Walker | Alabama | 1127 | 3307 | 96 |
732267 | 732267 | 2020-11-15 | Walker | Alabama | 1127 | 3294 | 96 |
729022 | 729022 | 2020-11-14 | Walker | Alabama | 1127 | 3278 | 96 |
725779 | 725779 | 2020-11-13 | Walker | Alabama | 1127 | 3252 | 96 |
722536 | 722536 | 2020-11-12 | Walker | Alabama | 1127 | 3203 | 96 |
719293 | 719293 | 2020-11-11 | Walker | Alabama | 1127 | 3176 | 96 |
716050 | 716050 | 2020-11-10 | Walker | Alabama | 1127 | 3155 | 96 |
712806 | 712806 | 2020-11-09 | Walker | Alabama | 1127 | 3152 | 96 |
709562 | 709562 | 2020-11-08 | Walker | Alabama | 1127 | 3141 | 96 |
706318 | 706318 | 2020-11-07 | Walker | Alabama | 1127 | 3129 | 96 |
703075 | 703075 | 2020-11-06 | Walker | Alabama | 1127 | 3109 | 96 |
699832 | 699832 | 2020-11-05 | Walker | Alabama | 1127 | 3083 | 95 |
696588 | 696588 | 2020-11-04 | Walker | Alabama | 1127 | 3056 | 95 |
693346 | 693346 | 2020-11-03 | Walker | Alabama | 1127 | 2992 | 95 |
690103 | 690103 | 2020-11-02 | Walker | Alabama | 1127 | 2985 | 95 |
686858 | 686858 | 2020-11-01 | Walker | Alabama | 1127 | 2966 | 95 |
683614 | 683614 | 2020-10-31 | Walker | Alabama | 1127 | 2949 | 95 |
680371 | 680371 | 2020-10-30 | Walker | Alabama | 1127 | 2902 | 93 |
677128 | 677128 | 2020-10-29 | Walker | Alabama | 1127 | 2874 | 93 |
673885 | 673885 | 2020-10-28 | Walker | Alabama | 1127 | 2855 | 93 |
670643 | 670643 | 2020-10-27 | Walker | Alabama | 1127 | 2837 | 93 |
667400 | 667400 | 2020-10-26 | Walker | Alabama | 1127 | 2823 | 92 |
664155 | 664155 | 2020-10-25 | Walker | Alabama | 1127 | 2794 | 92 |
660911 | 660911 | 2020-10-24 | Walker | Alabama | 1127 | 2772 | 92 |
657667 | 657667 | 2020-10-23 | Walker | Alabama | 1127 | 2755 | 93 |
654422 | 654422 | 2020-10-22 | Walker | Alabama | 1127 | 2722 | 93 |
651177 | 651177 | 2020-10-21 | Walker | Alabama | 1127 | 2699 | 93 |
647933 | 647933 | 2020-10-20 | Walker | Alabama | 1127 | 2688 | 92 |
644688 | 644688 | 2020-10-19 | Walker | Alabama | 1127 | 2680 | 92 |
641440 | 641440 | 2020-10-18 | Walker | Alabama | 1127 | 2641 | 92 |
638193 | 638193 | 2020-10-17 | Walker | Alabama | 1127 | 2627 | 92 |
634948 | 634948 | 2020-10-16 | Walker | Alabama | 1127 | 2615 | 92 |
631703 | 631703 | 2020-10-15 | Walker | Alabama | 1127 | 2602 | 91 |
628459 | 628459 | 2020-10-14 | Walker | Alabama | 1127 | 2590 | 91 |
625216 | 625216 | 2020-10-13 | Walker | Alabama | 1127 | 2586 | 91 |
621973 | 621973 | 2020-10-12 | Walker | Alabama | 1127 | 2539 | 91 |
618730 | 618730 | 2020-10-11 | Walker | Alabama | 1127 | 2533 | 91 |
615488 | 615488 | 2020-10-10 | Walker | Alabama | 1127 | 2527 | 91 |
612247 | 612247 | 2020-10-09 | Walker | Alabama | 1127 | 2513 | 90 |
609005 | 609005 | 2020-10-08 | Walker | Alabama | 1127 | 2493 | 89 |
605762 | 605762 | 2020-10-07 | Walker | Alabama | 1127 | 2472 | 89 |
602520 | 602520 | 2020-10-06 | Walker | Alabama | 1127 | 2448 | 89 |
599277 | 599277 | 2020-10-05 | Walker | Alabama | 1127 | 2436 | 88 |
596034 | 596034 | 2020-10-04 | Walker | Alabama | 1127 | 2424 | 88 |
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);