ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Douglas" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1042756 | 1042756 | 2021-02-18 | Douglas | Oregon | 41019 | 2272 | 51 |
1039511 | 1039511 | 2021-02-17 | Douglas | Oregon | 41019 | 2247 | 51 |
1036266 | 1036266 | 2021-02-16 | Douglas | Oregon | 41019 | 2207 | 51 |
1033021 | 1033021 | 2021-02-15 | Douglas | Oregon | 41019 | 2170 | 51 |
1029775 | 1029775 | 2021-02-14 | Douglas | Oregon | 41019 | 2157 | 51 |
1026528 | 1026528 | 2021-02-13 | Douglas | Oregon | 41019 | 2140 | 51 |
1023283 | 1023283 | 2021-02-12 | Douglas | Oregon | 41019 | 2116 | 51 |
1020038 | 1020038 | 2021-02-11 | Douglas | Oregon | 41019 | 2100 | 51 |
1016793 | 1016793 | 2021-02-10 | Douglas | Oregon | 41019 | 2054 | 51 |
1013548 | 1013548 | 2021-02-09 | Douglas | Oregon | 41019 | 2001 | 49 |
1010303 | 1010303 | 2021-02-08 | Douglas | Oregon | 41019 | 1985 | 49 |
1007057 | 1007057 | 2021-02-07 | Douglas | Oregon | 41019 | 1974 | 49 |
1003811 | 1003811 | 2021-02-06 | Douglas | Oregon | 41019 | 1964 | 49 |
1000565 | 1000565 | 2021-02-05 | Douglas | Oregon | 41019 | 1946 | 48 |
997319 | 997319 | 2021-02-04 | Douglas | Oregon | 41019 | 1919 | 48 |
994073 | 994073 | 2021-02-03 | Douglas | Oregon | 41019 | 1897 | 48 |
990827 | 990827 | 2021-02-02 | Douglas | Oregon | 41019 | 1878 | 48 |
987581 | 987581 | 2021-02-01 | Douglas | Oregon | 41019 | 1864 | 48 |
984334 | 984334 | 2021-01-31 | Douglas | Oregon | 41019 | 1850 | 48 |
981087 | 981087 | 2021-01-30 | Douglas | Oregon | 41019 | 1850 | 48 |
977841 | 977841 | 2021-01-29 | Douglas | Oregon | 41019 | 1843 | 48 |
974596 | 974596 | 2021-01-28 | Douglas | Oregon | 41019 | 1834 | 48 |
971351 | 971351 | 2021-01-27 | Douglas | Oregon | 41019 | 1814 | 47 |
968106 | 968106 | 2021-01-26 | Douglas | Oregon | 41019 | 1805 | 47 |
964862 | 964862 | 2021-01-25 | Douglas | Oregon | 41019 | 1785 | 45 |
961617 | 961617 | 2021-01-24 | Douglas | Oregon | 41019 | 1774 | 45 |
958372 | 958372 | 2021-01-23 | Douglas | Oregon | 41019 | 1759 | 44 |
955126 | 955126 | 2021-01-22 | Douglas | Oregon | 41019 | 1749 | 43 |
951881 | 951881 | 2021-01-21 | Douglas | Oregon | 41019 | 1731 | 43 |
948636 | 948636 | 2021-01-20 | Douglas | Oregon | 41019 | 1709 | 43 |
945390 | 945390 | 2021-01-19 | Douglas | Oregon | 41019 | 1692 | 43 |
942143 | 942143 | 2021-01-18 | Douglas | Oregon | 41019 | 1687 | 43 |
938898 | 938898 | 2021-01-17 | Douglas | Oregon | 41019 | 1677 | 43 |
935653 | 935653 | 2021-01-16 | Douglas | Oregon | 41019 | 1666 | 43 |
932408 | 932408 | 2021-01-15 | Douglas | Oregon | 41019 | 1650 | 43 |
929163 | 929163 | 2021-01-14 | Douglas | Oregon | 41019 | 1629 | 43 |
925918 | 925918 | 2021-01-13 | Douglas | Oregon | 41019 | 1614 | 43 |
922672 | 922672 | 2021-01-12 | Douglas | Oregon | 41019 | 1590 | 42 |
919427 | 919427 | 2021-01-11 | Douglas | Oregon | 41019 | 1570 | 42 |
916182 | 916182 | 2021-01-10 | Douglas | Oregon | 41019 | 1554 | 42 |
912937 | 912937 | 2021-01-09 | Douglas | Oregon | 41019 | 1542 | 42 |
909692 | 909692 | 2021-01-08 | Douglas | Oregon | 41019 | 1522 | 42 |
906447 | 906447 | 2021-01-07 | Douglas | Oregon | 41019 | 1495 | 42 |
903201 | 903201 | 2021-01-06 | Douglas | Oregon | 41019 | 1480 | 42 |
899956 | 899956 | 2021-01-05 | Douglas | Oregon | 41019 | 1474 | 41 |
896711 | 896711 | 2021-01-04 | Douglas | Oregon | 41019 | 1453 | 40 |
893465 | 893465 | 2021-01-03 | Douglas | Oregon | 41019 | 1439 | 40 |
890219 | 890219 | 2021-01-02 | Douglas | Oregon | 41019 | 1436 | 40 |
886972 | 886972 | 2021-01-01 | Douglas | Oregon | 41019 | 1426 | 39 |
883727 | 883727 | 2020-12-31 | Douglas | Oregon | 41019 | 1387 | 39 |
880482 | 880482 | 2020-12-30 | Douglas | Oregon | 41019 | 1366 | 38 |
877237 | 877237 | 2020-12-29 | Douglas | Oregon | 41019 | 1358 | 38 |
873992 | 873992 | 2020-12-28 | Douglas | Oregon | 41019 | 1358 | 37 |
870747 | 870747 | 2020-12-27 | Douglas | Oregon | 41019 | 1358 | 37 |
867502 | 867502 | 2020-12-26 | Douglas | Oregon | 41019 | 1351 | 37 |
864257 | 864257 | 2020-12-25 | Douglas | Oregon | 41019 | 1342 | 37 |
861012 | 861012 | 2020-12-24 | Douglas | Oregon | 41019 | 1328 | 37 |
857767 | 857767 | 2020-12-23 | Douglas | Oregon | 41019 | 1321 | 37 |
854522 | 854522 | 2020-12-22 | Douglas | Oregon | 41019 | 1313 | 37 |
851277 | 851277 | 2020-12-21 | Douglas | Oregon | 41019 | 1307 | 37 |
848032 | 848032 | 2020-12-20 | Douglas | Oregon | 41019 | 1280 | 36 |
844787 | 844787 | 2020-12-19 | Douglas | Oregon | 41019 | 1277 | 36 |
841541 | 841541 | 2020-12-18 | Douglas | Oregon | 41019 | 1253 | 36 |
838296 | 838296 | 2020-12-17 | Douglas | Oregon | 41019 | 1239 | 36 |
835050 | 835050 | 2020-12-16 | Douglas | Oregon | 41019 | 1228 | 35 |
831804 | 831804 | 2020-12-15 | Douglas | Oregon | 41019 | 1214 | 34 |
828557 | 828557 | 2020-12-14 | Douglas | Oregon | 41019 | 1204 | 30 |
825311 | 825311 | 2020-12-13 | Douglas | Oregon | 41019 | 1199 | 29 |
822064 | 822064 | 2020-12-12 | Douglas | Oregon | 41019 | 1179 | 29 |
818818 | 818818 | 2020-12-11 | Douglas | Oregon | 41019 | 1168 | 28 |
815572 | 815572 | 2020-12-10 | Douglas | Oregon | 41019 | 1152 | 27 |
812326 | 812326 | 2020-12-09 | Douglas | Oregon | 41019 | 1132 | 25 |
809082 | 809082 | 2020-12-08 | Douglas | Oregon | 41019 | 1105 | 25 |
805837 | 805837 | 2020-12-07 | Douglas | Oregon | 41019 | 1080 | 24 |
802592 | 802592 | 2020-12-06 | Douglas | Oregon | 41019 | 1069 | 24 |
799347 | 799347 | 2020-12-05 | Douglas | Oregon | 41019 | 1050 | 23 |
796102 | 796102 | 2020-12-04 | Douglas | Oregon | 41019 | 1026 | 20 |
792857 | 792857 | 2020-12-03 | Douglas | Oregon | 41019 | 998 | 19 |
789612 | 789612 | 2020-12-02 | Douglas | Oregon | 41019 | 981 | 19 |
786367 | 786367 | 2020-12-01 | Douglas | Oregon | 41019 | 967 | 18 |
783123 | 783123 | 2020-11-30 | Douglas | Oregon | 41019 | 961 | 18 |
779877 | 779877 | 2020-11-29 | Douglas | Oregon | 41019 | 930 | 18 |
776632 | 776632 | 2020-11-28 | Douglas | Oregon | 41019 | 921 | 18 |
773387 | 773387 | 2020-11-27 | Douglas | Oregon | 41019 | 912 | 17 |
770142 | 770142 | 2020-11-26 | Douglas | Oregon | 41019 | 900 | 17 |
766896 | 766896 | 2020-11-25 | Douglas | Oregon | 41019 | 882 | 17 |
763651 | 763651 | 2020-11-24 | Douglas | Oregon | 41019 | 840 | 17 |
760406 | 760406 | 2020-11-23 | Douglas | Oregon | 41019 | 822 | 15 |
757161 | 757161 | 2020-11-22 | Douglas | Oregon | 41019 | 804 | 15 |
753914 | 753914 | 2020-11-21 | Douglas | Oregon | 41019 | 793 | 15 |
750668 | 750668 | 2020-11-20 | Douglas | Oregon | 41019 | 756 | 14 |
747422 | 747422 | 2020-11-19 | Douglas | Oregon | 41019 | 718 | 13 |
744176 | 744176 | 2020-11-18 | Douglas | Oregon | 41019 | 697 | 12 |
740929 | 740929 | 2020-11-17 | Douglas | Oregon | 41019 | 665 | 11 |
737683 | 737683 | 2020-11-16 | Douglas | Oregon | 41019 | 628 | 10 |
734439 | 734439 | 2020-11-15 | Douglas | Oregon | 41019 | 619 | 10 |
731193 | 731193 | 2020-11-14 | Douglas | Oregon | 41019 | 603 | 10 |
727949 | 727949 | 2020-11-13 | Douglas | Oregon | 41019 | 581 | 10 |
724705 | 724705 | 2020-11-12 | Douglas | Oregon | 41019 | 556 | 10 |
721462 | 721462 | 2020-11-11 | Douglas | Oregon | 41019 | 542 | 10 |
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);