ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Greene" and fips = 17061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921068 | 921068 | 2021-01-12 | Greene | Illinois | 17061 | 1221 | 42 |
917823 | 917823 | 2021-01-11 | Greene | Illinois | 17061 | 1218 | 41 |
914578 | 914578 | 2021-01-10 | Greene | Illinois | 17061 | 1205 | 41 |
911333 | 911333 | 2021-01-09 | Greene | Illinois | 17061 | 1201 | 41 |
908088 | 908088 | 2021-01-08 | Greene | Illinois | 17061 | 1195 | 41 |
904842 | 904842 | 2021-01-07 | Greene | Illinois | 17061 | 1181 | 41 |
901597 | 901597 | 2021-01-06 | Greene | Illinois | 17061 | 1178 | 41 |
898352 | 898352 | 2021-01-05 | Greene | Illinois | 17061 | 1167 | 41 |
895107 | 895107 | 2021-01-04 | Greene | Illinois | 17061 | 1151 | 41 |
891860 | 891860 | 2021-01-03 | Greene | Illinois | 17061 | 1138 | 41 |
888613 | 888613 | 2021-01-02 | Greene | Illinois | 17061 | 1130 | 41 |
885368 | 885368 | 2021-01-01 | Greene | Illinois | 17061 | 1115 | 41 |
882123 | 882123 | 2020-12-31 | Greene | Illinois | 17061 | 1115 | 41 |
878878 | 878878 | 2020-12-30 | Greene | Illinois | 17061 | 1109 | 41 |
875633 | 875633 | 2020-12-29 | Greene | Illinois | 17061 | 1104 | 41 |
872388 | 872388 | 2020-12-28 | Greene | Illinois | 17061 | 1096 | 41 |
869143 | 869143 | 2020-12-27 | Greene | Illinois | 17061 | 1095 | 41 |
865898 | 865898 | 2020-12-26 | Greene | Illinois | 17061 | 1090 | 41 |
862653 | 862653 | 2020-12-25 | Greene | Illinois | 17061 | 1090 | 41 |
859408 | 859408 | 2020-12-24 | Greene | Illinois | 17061 | 1084 | 41 |
856163 | 856163 | 2020-12-23 | Greene | Illinois | 17061 | 1077 | 41 |
852918 | 852918 | 2020-12-22 | Greene | Illinois | 17061 | 1072 | 41 |
849673 | 849673 | 2020-12-21 | Greene | Illinois | 17061 | 1065 | 41 |
846428 | 846428 | 2020-12-20 | Greene | Illinois | 17061 | 1065 | 40 |
843182 | 843182 | 2020-12-19 | Greene | Illinois | 17061 | 1055 | 40 |
839937 | 839937 | 2020-12-18 | Greene | Illinois | 17061 | 1053 | 40 |
836692 | 836692 | 2020-12-17 | Greene | Illinois | 17061 | 1047 | 39 |
833446 | 833446 | 2020-12-16 | Greene | Illinois | 17061 | 1035 | 39 |
830199 | 830199 | 2020-12-15 | Greene | Illinois | 17061 | 1021 | 38 |
826953 | 826953 | 2020-12-14 | Greene | Illinois | 17061 | 1007 | 38 |
823706 | 823706 | 2020-12-13 | Greene | Illinois | 17061 | 992 | 38 |
820460 | 820460 | 2020-12-12 | Greene | Illinois | 17061 | 989 | 37 |
817214 | 817214 | 2020-12-11 | Greene | Illinois | 17061 | 977 | 37 |
813968 | 813968 | 2020-12-10 | Greene | Illinois | 17061 | 972 | 37 |
810723 | 810723 | 2020-12-09 | Greene | Illinois | 17061 | 961 | 37 |
807478 | 807478 | 2020-12-08 | Greene | Illinois | 17061 | 951 | 36 |
804233 | 804233 | 2020-12-07 | Greene | Illinois | 17061 | 940 | 34 |
800988 | 800988 | 2020-12-06 | Greene | Illinois | 17061 | 929 | 34 |
797743 | 797743 | 2020-12-05 | Greene | Illinois | 17061 | 923 | 34 |
794498 | 794498 | 2020-12-04 | Greene | Illinois | 17061 | 915 | 34 |
791253 | 791253 | 2020-12-03 | Greene | Illinois | 17061 | 894 | 32 |
788008 | 788008 | 2020-12-02 | Greene | Illinois | 17061 | 872 | 32 |
784764 | 784764 | 2020-12-01 | Greene | Illinois | 17061 | 850 | 31 |
781519 | 781519 | 2020-11-30 | Greene | Illinois | 17061 | 829 | 31 |
778273 | 778273 | 2020-11-29 | Greene | Illinois | 17061 | 828 | 31 |
775028 | 775028 | 2020-11-28 | Greene | Illinois | 17061 | 821 | 31 |
771783 | 771783 | 2020-11-27 | Greene | Illinois | 17061 | 809 | 29 |
768538 | 768538 | 2020-11-26 | Greene | Illinois | 17061 | 807 | 28 |
765292 | 765292 | 2020-11-25 | Greene | Illinois | 17061 | 787 | 27 |
762047 | 762047 | 2020-11-24 | Greene | Illinois | 17061 | 774 | 26 |
758802 | 758802 | 2020-11-23 | Greene | Illinois | 17061 | 763 | 26 |
755555 | 755555 | 2020-11-22 | Greene | Illinois | 17061 | 754 | 26 |
752309 | 752309 | 2020-11-21 | Greene | Illinois | 17061 | 731 | 26 |
749063 | 749063 | 2020-11-20 | Greene | Illinois | 17061 | 724 | 26 |
745817 | 745817 | 2020-11-19 | Greene | Illinois | 17061 | 692 | 26 |
742570 | 742570 | 2020-11-18 | Greene | Illinois | 17061 | 678 | 22 |
739323 | 739323 | 2020-11-17 | Greene | Illinois | 17061 | 654 | 21 |
736079 | 736079 | 2020-11-16 | Greene | Illinois | 17061 | 637 | 20 |
732833 | 732833 | 2020-11-15 | Greene | Illinois | 17061 | 609 | 20 |
729588 | 729588 | 2020-11-14 | Greene | Illinois | 17061 | 601 | 20 |
726345 | 726345 | 2020-11-13 | Greene | Illinois | 17061 | 583 | 20 |
723102 | 723102 | 2020-11-12 | Greene | Illinois | 17061 | 567 | 19 |
719859 | 719859 | 2020-11-11 | Greene | Illinois | 17061 | 550 | 19 |
716616 | 716616 | 2020-11-10 | Greene | Illinois | 17061 | 529 | 19 |
713372 | 713372 | 2020-11-09 | Greene | Illinois | 17061 | 510 | 19 |
710128 | 710128 | 2020-11-08 | Greene | Illinois | 17061 | 495 | 19 |
706884 | 706884 | 2020-11-07 | Greene | Illinois | 17061 | 485 | 19 |
703641 | 703641 | 2020-11-06 | Greene | Illinois | 17061 | 457 | 19 |
700398 | 700398 | 2020-11-05 | Greene | Illinois | 17061 | 371 | 18 |
697154 | 697154 | 2020-11-04 | Greene | Illinois | 17061 | 365 | 18 |
693912 | 693912 | 2020-11-03 | Greene | Illinois | 17061 | 356 | 17 |
690669 | 690669 | 2020-11-02 | Greene | Illinois | 17061 | 349 | 17 |
687424 | 687424 | 2020-11-01 | Greene | Illinois | 17061 | 342 | 17 |
684180 | 684180 | 2020-10-31 | Greene | Illinois | 17061 | 329 | 17 |
680937 | 680937 | 2020-10-30 | Greene | Illinois | 17061 | 329 | 17 |
677694 | 677694 | 2020-10-29 | Greene | Illinois | 17061 | 316 | 15 |
674451 | 674451 | 2020-10-28 | Greene | Illinois | 17061 | 299 | 15 |
671209 | 671209 | 2020-10-27 | Greene | Illinois | 17061 | 295 | 15 |
667966 | 667966 | 2020-10-26 | Greene | Illinois | 17061 | 295 | 15 |
664722 | 664722 | 2020-10-25 | Greene | Illinois | 17061 | 290 | 15 |
661477 | 661477 | 2020-10-24 | Greene | Illinois | 17061 | 287 | 15 |
658233 | 658233 | 2020-10-23 | Greene | Illinois | 17061 | 281 | 15 |
654988 | 654988 | 2020-10-22 | Greene | Illinois | 17061 | 280 | 15 |
651743 | 651743 | 2020-10-21 | Greene | Illinois | 17061 | 276 | 15 |
648499 | 648499 | 2020-10-20 | Greene | Illinois | 17061 | 270 | 15 |
645254 | 645254 | 2020-10-19 | Greene | Illinois | 17061 | 269 | 15 |
642007 | 642007 | 2020-10-18 | Greene | Illinois | 17061 | 264 | 15 |
638760 | 638760 | 2020-10-17 | Greene | Illinois | 17061 | 261 | 15 |
635514 | 635514 | 2020-10-16 | Greene | Illinois | 17061 | 260 | 15 |
632268 | 632268 | 2020-10-15 | Greene | Illinois | 17061 | 253 | 15 |
629024 | 629024 | 2020-10-14 | Greene | Illinois | 17061 | 250 | 15 |
625781 | 625781 | 2020-10-13 | Greene | Illinois | 17061 | 248 | 15 |
622539 | 622539 | 2020-10-12 | Greene | Illinois | 17061 | 248 | 15 |
619295 | 619295 | 2020-10-11 | Greene | Illinois | 17061 | 247 | 15 |
616053 | 616053 | 2020-10-10 | Greene | Illinois | 17061 | 245 | 15 |
612812 | 612812 | 2020-10-09 | Greene | Illinois | 17061 | 242 | 15 |
609570 | 609570 | 2020-10-08 | Greene | Illinois | 17061 | 241 | 15 |
606327 | 606327 | 2020-10-07 | Greene | Illinois | 17061 | 241 | 14 |
603085 | 603085 | 2020-10-06 | Greene | Illinois | 17061 | 239 | 14 |
599842 | 599842 | 2020-10-05 | Greene | Illinois | 17061 | 239 | 14 |
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);