ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Cumberland" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930791 | 930791 | 2021-01-15 | Cumberland | Illinois | 17035 | 1064 | 27 |
927546 | 927546 | 2021-01-14 | Cumberland | Illinois | 17035 | 1059 | 27 |
924300 | 924300 | 2021-01-13 | Cumberland | Illinois | 17035 | 1051 | 27 |
921055 | 921055 | 2021-01-12 | Cumberland | Illinois | 17035 | 1046 | 27 |
917810 | 917810 | 2021-01-11 | Cumberland | Illinois | 17035 | 1032 | 26 |
914565 | 914565 | 2021-01-10 | Cumberland | Illinois | 17035 | 1023 | 26 |
911320 | 911320 | 2021-01-09 | Cumberland | Illinois | 17035 | 1023 | 26 |
908075 | 908075 | 2021-01-08 | Cumberland | Illinois | 17035 | 1017 | 26 |
904829 | 904829 | 2021-01-07 | Cumberland | Illinois | 17035 | 1004 | 26 |
901584 | 901584 | 2021-01-06 | Cumberland | Illinois | 17035 | 996 | 26 |
898339 | 898339 | 2021-01-05 | Cumberland | Illinois | 17035 | 979 | 26 |
895094 | 895094 | 2021-01-04 | Cumberland | Illinois | 17035 | 960 | 24 |
891847 | 891847 | 2021-01-03 | Cumberland | Illinois | 17035 | 951 | 24 |
888600 | 888600 | 2021-01-02 | Cumberland | Illinois | 17035 | 949 | 24 |
885355 | 885355 | 2021-01-01 | Cumberland | Illinois | 17035 | 937 | 25 |
882110 | 882110 | 2020-12-31 | Cumberland | Illinois | 17035 | 937 | 25 |
878865 | 878865 | 2020-12-30 | Cumberland | Illinois | 17035 | 924 | 24 |
875620 | 875620 | 2020-12-29 | Cumberland | Illinois | 17035 | 919 | 23 |
872375 | 872375 | 2020-12-28 | Cumberland | Illinois | 17035 | 909 | 23 |
869130 | 869130 | 2020-12-27 | Cumberland | Illinois | 17035 | 906 | 23 |
865885 | 865885 | 2020-12-26 | Cumberland | Illinois | 17035 | 904 | 23 |
862640 | 862640 | 2020-12-25 | Cumberland | Illinois | 17035 | 904 | 23 |
859395 | 859395 | 2020-12-24 | Cumberland | Illinois | 17035 | 897 | 23 |
856150 | 856150 | 2020-12-23 | Cumberland | Illinois | 17035 | 888 | 23 |
852905 | 852905 | 2020-12-22 | Cumberland | Illinois | 17035 | 883 | 23 |
849660 | 849660 | 2020-12-21 | Cumberland | Illinois | 17035 | 875 | 23 |
846415 | 846415 | 2020-12-20 | Cumberland | Illinois | 17035 | 868 | 23 |
843169 | 843169 | 2020-12-19 | Cumberland | Illinois | 17035 | 862 | 24 |
839924 | 839924 | 2020-12-18 | Cumberland | Illinois | 17035 | 853 | 24 |
836679 | 836679 | 2020-12-17 | Cumberland | Illinois | 17035 | 847 | 23 |
833433 | 833433 | 2020-12-16 | Cumberland | Illinois | 17035 | 823 | 23 |
830186 | 830186 | 2020-12-15 | Cumberland | Illinois | 17035 | 814 | 22 |
826940 | 826940 | 2020-12-14 | Cumberland | Illinois | 17035 | 789 | 21 |
823693 | 823693 | 2020-12-13 | Cumberland | Illinois | 17035 | 784 | 21 |
820447 | 820447 | 2020-12-12 | Cumberland | Illinois | 17035 | 781 | 21 |
817201 | 817201 | 2020-12-11 | Cumberland | Illinois | 17035 | 776 | 21 |
813955 | 813955 | 2020-12-10 | Cumberland | Illinois | 17035 | 750 | 21 |
810710 | 810710 | 2020-12-09 | Cumberland | Illinois | 17035 | 746 | 21 |
807465 | 807465 | 2020-12-08 | Cumberland | Illinois | 17035 | 732 | 21 |
804220 | 804220 | 2020-12-07 | Cumberland | Illinois | 17035 | 728 | 21 |
800975 | 800975 | 2020-12-06 | Cumberland | Illinois | 17035 | 724 | 21 |
797730 | 797730 | 2020-12-05 | Cumberland | Illinois | 17035 | 713 | 21 |
794485 | 794485 | 2020-12-04 | Cumberland | Illinois | 17035 | 699 | 19 |
791240 | 791240 | 2020-12-03 | Cumberland | Illinois | 17035 | 683 | 19 |
787995 | 787995 | 2020-12-02 | Cumberland | Illinois | 17035 | 667 | 17 |
784751 | 784751 | 2020-12-01 | Cumberland | Illinois | 17035 | 631 | 16 |
781506 | 781506 | 2020-11-30 | Cumberland | Illinois | 17035 | 621 | 16 |
778260 | 778260 | 2020-11-29 | Cumberland | Illinois | 17035 | 614 | 16 |
775015 | 775015 | 2020-11-28 | Cumberland | Illinois | 17035 | 610 | 16 |
771770 | 771770 | 2020-11-27 | Cumberland | Illinois | 17035 | 609 | 16 |
768525 | 768525 | 2020-11-26 | Cumberland | Illinois | 17035 | 606 | 16 |
765279 | 765279 | 2020-11-25 | Cumberland | Illinois | 17035 | 594 | 16 |
762034 | 762034 | 2020-11-24 | Cumberland | Illinois | 17035 | 580 | 13 |
758789 | 758789 | 2020-11-23 | Cumberland | Illinois | 17035 | 567 | 13 |
755542 | 755542 | 2020-11-22 | Cumberland | Illinois | 17035 | 561 | 13 |
752296 | 752296 | 2020-11-21 | Cumberland | Illinois | 17035 | 555 | 13 |
749050 | 749050 | 2020-11-20 | Cumberland | Illinois | 17035 | 538 | 12 |
745804 | 745804 | 2020-11-19 | Cumberland | Illinois | 17035 | 516 | 12 |
742557 | 742557 | 2020-11-18 | Cumberland | Illinois | 17035 | 503 | 7 |
739310 | 739310 | 2020-11-17 | Cumberland | Illinois | 17035 | 496 | 7 |
736066 | 736066 | 2020-11-16 | Cumberland | Illinois | 17035 | 494 | 7 |
732820 | 732820 | 2020-11-15 | Cumberland | Illinois | 17035 | 482 | 7 |
729575 | 729575 | 2020-11-14 | Cumberland | Illinois | 17035 | 477 | 7 |
726332 | 726332 | 2020-11-13 | Cumberland | Illinois | 17035 | 467 | 6 |
723089 | 723089 | 2020-11-12 | Cumberland | Illinois | 17035 | 453 | 6 |
719846 | 719846 | 2020-11-11 | Cumberland | Illinois | 17035 | 450 | 6 |
716603 | 716603 | 2020-11-10 | Cumberland | Illinois | 17035 | 430 | 6 |
713359 | 713359 | 2020-11-09 | Cumberland | Illinois | 17035 | 418 | 6 |
710115 | 710115 | 2020-11-08 | Cumberland | Illinois | 17035 | 415 | 6 |
706871 | 706871 | 2020-11-07 | Cumberland | Illinois | 17035 | 410 | 6 |
703628 | 703628 | 2020-11-06 | Cumberland | Illinois | 17035 | 398 | 6 |
700385 | 700385 | 2020-11-05 | Cumberland | Illinois | 17035 | 345 | 6 |
697141 | 697141 | 2020-11-04 | Cumberland | Illinois | 17035 | 333 | 6 |
693899 | 693899 | 2020-11-03 | Cumberland | Illinois | 17035 | 330 | 6 |
690656 | 690656 | 2020-11-02 | Cumberland | Illinois | 17035 | 326 | 6 |
687411 | 687411 | 2020-11-01 | Cumberland | Illinois | 17035 | 323 | 6 |
684167 | 684167 | 2020-10-31 | Cumberland | Illinois | 17035 | 313 | 6 |
680924 | 680924 | 2020-10-30 | Cumberland | Illinois | 17035 | 313 | 6 |
677681 | 677681 | 2020-10-29 | Cumberland | Illinois | 17035 | 311 | 6 |
674438 | 674438 | 2020-10-28 | Cumberland | Illinois | 17035 | 308 | 6 |
671196 | 671196 | 2020-10-27 | Cumberland | Illinois | 17035 | 302 | 6 |
667953 | 667953 | 2020-10-26 | Cumberland | Illinois | 17035 | 294 | 6 |
664709 | 664709 | 2020-10-25 | Cumberland | Illinois | 17035 | 288 | 6 |
661464 | 661464 | 2020-10-24 | Cumberland | Illinois | 17035 | 281 | 6 |
658220 | 658220 | 2020-10-23 | Cumberland | Illinois | 17035 | 270 | 6 |
654975 | 654975 | 2020-10-22 | Cumberland | Illinois | 17035 | 262 | 6 |
651730 | 651730 | 2020-10-21 | Cumberland | Illinois | 17035 | 260 | 6 |
648486 | 648486 | 2020-10-20 | Cumberland | Illinois | 17035 | 258 | 6 |
645241 | 645241 | 2020-10-19 | Cumberland | Illinois | 17035 | 253 | 6 |
641994 | 641994 | 2020-10-18 | Cumberland | Illinois | 17035 | 249 | 6 |
638747 | 638747 | 2020-10-17 | Cumberland | Illinois | 17035 | 247 | 6 |
635501 | 635501 | 2020-10-16 | Cumberland | Illinois | 17035 | 246 | 5 |
632255 | 632255 | 2020-10-15 | Cumberland | Illinois | 17035 | 244 | 5 |
629011 | 629011 | 2020-10-14 | Cumberland | Illinois | 17035 | 241 | 5 |
625768 | 625768 | 2020-10-13 | Cumberland | Illinois | 17035 | 237 | 5 |
622526 | 622526 | 2020-10-12 | Cumberland | Illinois | 17035 | 234 | 5 |
619282 | 619282 | 2020-10-11 | Cumberland | Illinois | 17035 | 231 | 5 |
616040 | 616040 | 2020-10-10 | Cumberland | Illinois | 17035 | 231 | 5 |
612799 | 612799 | 2020-10-09 | Cumberland | Illinois | 17035 | 229 | 5 |
609557 | 609557 | 2020-10-08 | Cumberland | Illinois | 17035 | 226 | 5 |
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);