ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Elmore", fips = 1051 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917218 | 917218 | 2021-01-11 | Elmore | Alabama | 1051 | 7433 | 85 |
913973 | 913973 | 2021-01-10 | Elmore | Alabama | 1051 | 7390 | 85 |
910728 | 910728 | 2021-01-09 | Elmore | Alabama | 1051 | 7334 | 85 |
907483 | 907483 | 2021-01-08 | Elmore | Alabama | 1051 | 7238 | 85 |
904237 | 904237 | 2021-01-07 | Elmore | Alabama | 1051 | 7156 | 85 |
900992 | 900992 | 2021-01-06 | Elmore | Alabama | 1051 | 7059 | 86 |
897747 | 897747 | 2021-01-05 | Elmore | Alabama | 1051 | 6958 | 83 |
894501 | 894501 | 2021-01-04 | Elmore | Alabama | 1051 | 6710 | 83 |
891255 | 891255 | 2021-01-03 | Elmore | Alabama | 1051 | 6671 | 83 |
888008 | 888008 | 2021-01-02 | Elmore | Alabama | 1051 | 6625 | 83 |
884763 | 884763 | 2021-01-01 | Elmore | Alabama | 1051 | 6542 | 83 |
881518 | 881518 | 2020-12-31 | Elmore | Alabama | 1051 | 6435 | 83 |
878273 | 878273 | 2020-12-30 | Elmore | Alabama | 1051 | 6321 | 82 |
875028 | 875028 | 2020-12-29 | Elmore | Alabama | 1051 | 6187 | 81 |
871783 | 871783 | 2020-12-28 | Elmore | Alabama | 1051 | 6063 | 81 |
868538 | 868538 | 2020-12-27 | Elmore | Alabama | 1051 | 5994 | 81 |
865293 | 865293 | 2020-12-26 | Elmore | Alabama | 1051 | 5941 | 81 |
862048 | 862048 | 2020-12-25 | Elmore | Alabama | 1051 | 5934 | 81 |
858803 | 858803 | 2020-12-24 | Elmore | Alabama | 1051 | 5850 | 80 |
855558 | 855558 | 2020-12-23 | Elmore | Alabama | 1051 | 5773 | 80 |
852313 | 852313 | 2020-12-22 | Elmore | Alabama | 1051 | 5694 | 80 |
849068 | 849068 | 2020-12-21 | Elmore | Alabama | 1051 | 5579 | 80 |
845823 | 845823 | 2020-12-20 | Elmore | Alabama | 1051 | 5535 | 80 |
842577 | 842577 | 2020-12-19 | Elmore | Alabama | 1051 | 5472 | 80 |
839332 | 839332 | 2020-12-18 | Elmore | Alabama | 1051 | 5357 | 78 |
836087 | 836087 | 2020-12-17 | Elmore | Alabama | 1051 | 5239 | 78 |
832841 | 832841 | 2020-12-16 | Elmore | Alabama | 1051 | 5143 | 76 |
829594 | 829594 | 2020-12-15 | Elmore | Alabama | 1051 | 5076 | 74 |
826348 | 826348 | 2020-12-14 | Elmore | Alabama | 1051 | 4991 | 72 |
823101 | 823101 | 2020-12-13 | Elmore | Alabama | 1051 | 4959 | 72 |
819855 | 819855 | 2020-12-12 | Elmore | Alabama | 1051 | 4909 | 72 |
816609 | 816609 | 2020-12-11 | Elmore | Alabama | 1051 | 4870 | 72 |
813363 | 813363 | 2020-12-10 | Elmore | Alabama | 1051 | 4803 | 72 |
810119 | 810119 | 2020-12-09 | Elmore | Alabama | 1051 | 4690 | 70 |
806874 | 806874 | 2020-12-08 | Elmore | Alabama | 1051 | 4618 | 70 |
803629 | 803629 | 2020-12-07 | Elmore | Alabama | 1051 | 4511 | 70 |
800384 | 800384 | 2020-12-06 | Elmore | Alabama | 1051 | 4482 | 70 |
797139 | 797139 | 2020-12-05 | Elmore | Alabama | 1051 | 4446 | 70 |
793894 | 793894 | 2020-12-04 | Elmore | Alabama | 1051 | 4400 | 70 |
790649 | 790649 | 2020-12-03 | Elmore | Alabama | 1051 | 4325 | 67 |
787404 | 787404 | 2020-12-02 | Elmore | Alabama | 1051 | 4275 | 64 |
784160 | 784160 | 2020-12-01 | Elmore | Alabama | 1051 | 4211 | 64 |
780915 | 780915 | 2020-11-30 | Elmore | Alabama | 1051 | 4129 | 64 |
777669 | 777669 | 2020-11-29 | Elmore | Alabama | 1051 | 4094 | 64 |
774424 | 774424 | 2020-11-28 | Elmore | Alabama | 1051 | 4068 | 64 |
771179 | 771179 | 2020-11-27 | Elmore | Alabama | 1051 | 4045 | 64 |
767933 | 767933 | 2020-11-26 | Elmore | Alabama | 1051 | 4037 | 64 |
764688 | 764688 | 2020-11-25 | Elmore | Alabama | 1051 | 4007 | 62 |
761443 | 761443 | 2020-11-24 | Elmore | Alabama | 1051 | 3989 | 61 |
758198 | 758198 | 2020-11-23 | Elmore | Alabama | 1051 | 3939 | 61 |
754951 | 754951 | 2020-11-22 | Elmore | Alabama | 1051 | 3910 | 61 |
751705 | 751705 | 2020-11-21 | Elmore | Alabama | 1051 | 3885 | 61 |
748459 | 748459 | 2020-11-20 | Elmore | Alabama | 1051 | 3820 | 61 |
745213 | 745213 | 2020-11-19 | Elmore | Alabama | 1051 | 3797 | 61 |
741966 | 741966 | 2020-11-18 | Elmore | Alabama | 1051 | 3759 | 61 |
738719 | 738719 | 2020-11-17 | Elmore | Alabama | 1051 | 3720 | 61 |
735475 | 735475 | 2020-11-16 | Elmore | Alabama | 1051 | 3686 | 61 |
732229 | 732229 | 2020-11-15 | Elmore | Alabama | 1051 | 3648 | 61 |
728984 | 728984 | 2020-11-14 | Elmore | Alabama | 1051 | 3624 | 61 |
725741 | 725741 | 2020-11-13 | Elmore | Alabama | 1051 | 3587 | 61 |
722498 | 722498 | 2020-11-12 | Elmore | Alabama | 1051 | 3544 | 60 |
719255 | 719255 | 2020-11-11 | Elmore | Alabama | 1051 | 3522 | 60 |
716012 | 716012 | 2020-11-10 | Elmore | Alabama | 1051 | 3495 | 60 |
712768 | 712768 | 2020-11-09 | Elmore | Alabama | 1051 | 3477 | 59 |
709524 | 709524 | 2020-11-08 | Elmore | Alabama | 1051 | 3454 | 59 |
706280 | 706280 | 2020-11-07 | Elmore | Alabama | 1051 | 3438 | 59 |
703037 | 703037 | 2020-11-06 | Elmore | Alabama | 1051 | 3403 | 59 |
699794 | 699794 | 2020-11-05 | Elmore | Alabama | 1051 | 3379 | 59 |
696550 | 696550 | 2020-11-04 | Elmore | Alabama | 1051 | 3366 | 59 |
693308 | 693308 | 2020-11-03 | Elmore | Alabama | 1051 | 3342 | 59 |
690065 | 690065 | 2020-11-02 | Elmore | Alabama | 1051 | 3325 | 59 |
686820 | 686820 | 2020-11-01 | Elmore | Alabama | 1051 | 3314 | 59 |
683576 | 683576 | 2020-10-31 | Elmore | Alabama | 1051 | 3309 | 59 |
680333 | 680333 | 2020-10-30 | Elmore | Alabama | 1051 | 3292 | 58 |
677090 | 677090 | 2020-10-29 | Elmore | Alabama | 1051 | 3278 | 58 |
673847 | 673847 | 2020-10-28 | Elmore | Alabama | 1051 | 3265 | 58 |
670605 | 670605 | 2020-10-27 | Elmore | Alabama | 1051 | 3246 | 53 |
667362 | 667362 | 2020-10-26 | Elmore | Alabama | 1051 | 3227 | 53 |
664117 | 664117 | 2020-10-25 | Elmore | Alabama | 1051 | 3208 | 53 |
660873 | 660873 | 2020-10-24 | Elmore | Alabama | 1051 | 3200 | 53 |
657629 | 657629 | 2020-10-23 | Elmore | Alabama | 1051 | 3173 | 53 |
654384 | 654384 | 2020-10-22 | Elmore | Alabama | 1051 | 3148 | 52 |
651139 | 651139 | 2020-10-21 | Elmore | Alabama | 1051 | 3128 | 52 |
647895 | 647895 | 2020-10-20 | Elmore | Alabama | 1051 | 3107 | 52 |
644650 | 644650 | 2020-10-19 | Elmore | Alabama | 1051 | 3095 | 52 |
641402 | 641402 | 2020-10-18 | Elmore | Alabama | 1051 | 3081 | 52 |
638155 | 638155 | 2020-10-17 | Elmore | Alabama | 1051 | 3074 | 52 |
634910 | 634910 | 2020-10-16 | Elmore | Alabama | 1051 | 3045 | 52 |
631665 | 631665 | 2020-10-15 | Elmore | Alabama | 1051 | 3028 | 52 |
628421 | 628421 | 2020-10-14 | Elmore | Alabama | 1051 | 3009 | 51 |
625178 | 625178 | 2020-10-13 | Elmore | Alabama | 1051 | 2995 | 50 |
621935 | 621935 | 2020-10-12 | Elmore | Alabama | 1051 | 2967 | 50 |
618692 | 618692 | 2020-10-11 | Elmore | Alabama | 1051 | 2952 | 50 |
615450 | 615450 | 2020-10-10 | Elmore | Alabama | 1051 | 2945 | 50 |
612209 | 612209 | 2020-10-09 | Elmore | Alabama | 1051 | 2917 | 50 |
608967 | 608967 | 2020-10-08 | Elmore | Alabama | 1051 | 2889 | 50 |
605724 | 605724 | 2020-10-07 | Elmore | Alabama | 1051 | 2874 | 50 |
602482 | 602482 | 2020-10-06 | Elmore | Alabama | 1051 | 2844 | 50 |
599239 | 599239 | 2020-10-05 | Elmore | Alabama | 1051 | 2835 | 50 |
595996 | 595996 | 2020-10-04 | Elmore | Alabama | 1051 | 2826 | 50 |
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);