ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Greene" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917224 | 917224 | 2021-01-11 | Greene | Alabama | 1063 | 734 | 20 |
913979 | 913979 | 2021-01-10 | Greene | Alabama | 1063 | 731 | 20 |
910734 | 910734 | 2021-01-09 | Greene | Alabama | 1063 | 726 | 20 |
907489 | 907489 | 2021-01-08 | Greene | Alabama | 1063 | 723 | 20 |
904243 | 904243 | 2021-01-07 | Greene | Alabama | 1063 | 716 | 20 |
900998 | 900998 | 2021-01-06 | Greene | Alabama | 1063 | 709 | 20 |
897753 | 897753 | 2021-01-05 | Greene | Alabama | 1063 | 700 | 20 |
894507 | 894507 | 2021-01-04 | Greene | Alabama | 1063 | 696 | 20 |
891261 | 891261 | 2021-01-03 | Greene | Alabama | 1063 | 688 | 20 |
888014 | 888014 | 2021-01-02 | Greene | Alabama | 1063 | 682 | 20 |
884769 | 884769 | 2021-01-01 | Greene | Alabama | 1063 | 679 | 20 |
881524 | 881524 | 2020-12-31 | Greene | Alabama | 1063 | 672 | 20 |
878279 | 878279 | 2020-12-30 | Greene | Alabama | 1063 | 662 | 20 |
875034 | 875034 | 2020-12-29 | Greene | Alabama | 1063 | 650 | 20 |
871789 | 871789 | 2020-12-28 | Greene | Alabama | 1063 | 633 | 20 |
868544 | 868544 | 2020-12-27 | Greene | Alabama | 1063 | 632 | 20 |
865299 | 865299 | 2020-12-26 | Greene | Alabama | 1063 | 625 | 20 |
862054 | 862054 | 2020-12-25 | Greene | Alabama | 1063 | 623 | 20 |
858809 | 858809 | 2020-12-24 | Greene | Alabama | 1063 | 618 | 20 |
855564 | 855564 | 2020-12-23 | Greene | Alabama | 1063 | 604 | 20 |
852319 | 852319 | 2020-12-22 | Greene | Alabama | 1063 | 595 | 20 |
849074 | 849074 | 2020-12-21 | Greene | Alabama | 1063 | 586 | 20 |
845829 | 845829 | 2020-12-20 | Greene | Alabama | 1063 | 585 | 20 |
842583 | 842583 | 2020-12-19 | Greene | Alabama | 1063 | 583 | 20 |
839338 | 839338 | 2020-12-18 | Greene | Alabama | 1063 | 574 | 20 |
836093 | 836093 | 2020-12-17 | Greene | Alabama | 1063 | 565 | 20 |
832847 | 832847 | 2020-12-16 | Greene | Alabama | 1063 | 558 | 20 |
829600 | 829600 | 2020-12-15 | Greene | Alabama | 1063 | 552 | 20 |
826354 | 826354 | 2020-12-14 | Greene | Alabama | 1063 | 547 | 20 |
823107 | 823107 | 2020-12-13 | Greene | Alabama | 1063 | 546 | 20 |
819861 | 819861 | 2020-12-12 | Greene | Alabama | 1063 | 544 | 20 |
816615 | 816615 | 2020-12-11 | Greene | Alabama | 1063 | 528 | 19 |
813369 | 813369 | 2020-12-10 | Greene | Alabama | 1063 | 518 | 18 |
810125 | 810125 | 2020-12-09 | Greene | Alabama | 1063 | 499 | 18 |
806880 | 806880 | 2020-12-08 | Greene | Alabama | 1063 | 488 | 18 |
803635 | 803635 | 2020-12-07 | Greene | Alabama | 1063 | 477 | 18 |
800390 | 800390 | 2020-12-06 | Greene | Alabama | 1063 | 473 | 18 |
797145 | 797145 | 2020-12-05 | Greene | Alabama | 1063 | 466 | 18 |
793900 | 793900 | 2020-12-04 | Greene | Alabama | 1063 | 458 | 18 |
790655 | 790655 | 2020-12-03 | Greene | Alabama | 1063 | 445 | 18 |
787410 | 787410 | 2020-12-02 | Greene | Alabama | 1063 | 442 | 18 |
784166 | 784166 | 2020-12-01 | Greene | Alabama | 1063 | 435 | 18 |
780921 | 780921 | 2020-11-30 | Greene | Alabama | 1063 | 428 | 18 |
777675 | 777675 | 2020-11-29 | Greene | Alabama | 1063 | 427 | 18 |
774430 | 774430 | 2020-11-28 | Greene | Alabama | 1063 | 426 | 18 |
771185 | 771185 | 2020-11-27 | Greene | Alabama | 1063 | 424 | 18 |
767939 | 767939 | 2020-11-26 | Greene | Alabama | 1063 | 423 | 18 |
764694 | 764694 | 2020-11-25 | Greene | Alabama | 1063 | 414 | 18 |
761449 | 761449 | 2020-11-24 | Greene | Alabama | 1063 | 413 | 17 |
758204 | 758204 | 2020-11-23 | Greene | Alabama | 1063 | 402 | 17 |
754957 | 754957 | 2020-11-22 | Greene | Alabama | 1063 | 399 | 17 |
751711 | 751711 | 2020-11-21 | Greene | Alabama | 1063 | 396 | 17 |
748465 | 748465 | 2020-11-20 | Greene | Alabama | 1063 | 394 | 17 |
745219 | 745219 | 2020-11-19 | Greene | Alabama | 1063 | 389 | 17 |
741972 | 741972 | 2020-11-18 | Greene | Alabama | 1063 | 382 | 17 |
738725 | 738725 | 2020-11-17 | Greene | Alabama | 1063 | 379 | 17 |
735481 | 735481 | 2020-11-16 | Greene | Alabama | 1063 | 377 | 17 |
732235 | 732235 | 2020-11-15 | Greene | Alabama | 1063 | 375 | 17 |
728990 | 728990 | 2020-11-14 | Greene | Alabama | 1063 | 374 | 17 |
725747 | 725747 | 2020-11-13 | Greene | Alabama | 1063 | 369 | 17 |
722504 | 722504 | 2020-11-12 | Greene | Alabama | 1063 | 364 | 17 |
719261 | 719261 | 2020-11-11 | Greene | Alabama | 1063 | 362 | 17 |
716018 | 716018 | 2020-11-10 | Greene | Alabama | 1063 | 361 | 17 |
712774 | 712774 | 2020-11-09 | Greene | Alabama | 1063 | 362 | 17 |
709530 | 709530 | 2020-11-08 | Greene | Alabama | 1063 | 361 | 17 |
706286 | 706286 | 2020-11-07 | Greene | Alabama | 1063 | 358 | 17 |
703043 | 703043 | 2020-11-06 | Greene | Alabama | 1063 | 356 | 17 |
699800 | 699800 | 2020-11-05 | Greene | Alabama | 1063 | 354 | 17 |
696556 | 696556 | 2020-11-04 | Greene | Alabama | 1063 | 354 | 17 |
693314 | 693314 | 2020-11-03 | Greene | Alabama | 1063 | 351 | 17 |
690071 | 690071 | 2020-11-02 | Greene | Alabama | 1063 | 351 | 17 |
686826 | 686826 | 2020-11-01 | Greene | Alabama | 1063 | 351 | 17 |
683582 | 683582 | 2020-10-31 | Greene | Alabama | 1063 | 351 | 17 |
680339 | 680339 | 2020-10-30 | Greene | Alabama | 1063 | 346 | 16 |
677096 | 677096 | 2020-10-29 | Greene | Alabama | 1063 | 345 | 16 |
673853 | 673853 | 2020-10-28 | Greene | Alabama | 1063 | 346 | 16 |
670611 | 670611 | 2020-10-27 | Greene | Alabama | 1063 | 346 | 16 |
667368 | 667368 | 2020-10-26 | Greene | Alabama | 1063 | 346 | 16 |
664123 | 664123 | 2020-10-25 | Greene | Alabama | 1063 | 342 | 16 |
660879 | 660879 | 2020-10-24 | Greene | Alabama | 1063 | 342 | 16 |
657635 | 657635 | 2020-10-23 | Greene | Alabama | 1063 | 342 | 16 |
654390 | 654390 | 2020-10-22 | Greene | Alabama | 1063 | 342 | 16 |
651145 | 651145 | 2020-10-21 | Greene | Alabama | 1063 | 340 | 16 |
647901 | 647901 | 2020-10-20 | Greene | Alabama | 1063 | 339 | 16 |
644656 | 644656 | 2020-10-19 | Greene | Alabama | 1063 | 333 | 16 |
641408 | 641408 | 2020-10-18 | Greene | Alabama | 1063 | 333 | 16 |
638161 | 638161 | 2020-10-17 | Greene | Alabama | 1063 | 329 | 16 |
634916 | 634916 | 2020-10-16 | Greene | Alabama | 1063 | 329 | 16 |
631671 | 631671 | 2020-10-15 | Greene | Alabama | 1063 | 328 | 15 |
628427 | 628427 | 2020-10-14 | Greene | Alabama | 1063 | 329 | 15 |
625184 | 625184 | 2020-10-13 | Greene | Alabama | 1063 | 326 | 15 |
621941 | 621941 | 2020-10-12 | Greene | Alabama | 1063 | 326 | 15 |
618698 | 618698 | 2020-10-11 | Greene | Alabama | 1063 | 326 | 15 |
615456 | 615456 | 2020-10-10 | Greene | Alabama | 1063 | 326 | 15 |
612215 | 612215 | 2020-10-09 | Greene | Alabama | 1063 | 325 | 15 |
608973 | 608973 | 2020-10-08 | Greene | Alabama | 1063 | 313 | 15 |
605730 | 605730 | 2020-10-07 | Greene | Alabama | 1063 | 311 | 15 |
602488 | 602488 | 2020-10-06 | Greene | Alabama | 1063 | 310 | 15 |
599245 | 599245 | 2020-10-05 | Greene | Alabama | 1063 | 310 | 15 |
596002 | 596002 | 2020-10-04 | Greene | Alabama | 1063 | 308 | 15 |
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);