ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Union" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1068743 | 1068743 | 2021-02-26 | Union | Oregon | 41061 | 1281 | 19 |
1065498 | 1065498 | 2021-02-25 | Union | Oregon | 41061 | 1275 | 19 |
1062253 | 1062253 | 2021-02-24 | Union | Oregon | 41061 | 1271 | 19 |
1059008 | 1059008 | 2021-02-23 | Union | Oregon | 41061 | 1269 | 19 |
1055762 | 1055762 | 2021-02-22 | Union | Oregon | 41061 | 1265 | 19 |
1052516 | 1052516 | 2021-02-21 | Union | Oregon | 41061 | 1264 | 19 |
1049269 | 1049269 | 2021-02-20 | Union | Oregon | 41061 | 1264 | 19 |
1046022 | 1046022 | 2021-02-19 | Union | Oregon | 41061 | 1263 | 19 |
1042777 | 1042777 | 2021-02-18 | Union | Oregon | 41061 | 1259 | 19 |
1039532 | 1039532 | 2021-02-17 | Union | Oregon | 41061 | 1257 | 19 |
1036287 | 1036287 | 2021-02-16 | Union | Oregon | 41061 | 1249 | 19 |
1033042 | 1033042 | 2021-02-15 | Union | Oregon | 41061 | 1249 | 19 |
1029796 | 1029796 | 2021-02-14 | Union | Oregon | 41061 | 1244 | 19 |
1026549 | 1026549 | 2021-02-13 | Union | Oregon | 41061 | 1243 | 19 |
1023304 | 1023304 | 2021-02-12 | Union | Oregon | 41061 | 1238 | 19 |
1020059 | 1020059 | 2021-02-11 | Union | Oregon | 41061 | 1235 | 19 |
1016814 | 1016814 | 2021-02-10 | Union | Oregon | 41061 | 1231 | 19 |
1013569 | 1013569 | 2021-02-09 | Union | Oregon | 41061 | 1227 | 19 |
1010324 | 1010324 | 2021-02-08 | Union | Oregon | 41061 | 1222 | 18 |
1007078 | 1007078 | 2021-02-07 | Union | Oregon | 41061 | 1221 | 18 |
1003832 | 1003832 | 2021-02-06 | Union | Oregon | 41061 | 1220 | 18 |
1000586 | 1000586 | 2021-02-05 | Union | Oregon | 41061 | 1215 | 18 |
997340 | 997340 | 2021-02-04 | Union | Oregon | 41061 | 1203 | 18 |
994094 | 994094 | 2021-02-03 | Union | Oregon | 41061 | 1197 | 18 |
990848 | 990848 | 2021-02-02 | Union | Oregon | 41061 | 1190 | 18 |
987602 | 987602 | 2021-02-01 | Union | Oregon | 41061 | 1181 | 18 |
984355 | 984355 | 2021-01-31 | Union | Oregon | 41061 | 1173 | 18 |
981108 | 981108 | 2021-01-30 | Union | Oregon | 41061 | 1173 | 18 |
977862 | 977862 | 2021-01-29 | Union | Oregon | 41061 | 1168 | 17 |
974617 | 974617 | 2021-01-28 | Union | Oregon | 41061 | 1163 | 17 |
971372 | 971372 | 2021-01-27 | Union | Oregon | 41061 | 1161 | 17 |
968127 | 968127 | 2021-01-26 | Union | Oregon | 41061 | 1158 | 17 |
964883 | 964883 | 2021-01-25 | Union | Oregon | 41061 | 1154 | 17 |
961638 | 961638 | 2021-01-24 | Union | Oregon | 41061 | 1151 | 17 |
958393 | 958393 | 2021-01-23 | Union | Oregon | 41061 | 1146 | 17 |
955147 | 955147 | 2021-01-22 | Union | Oregon | 41061 | 1140 | 17 |
951902 | 951902 | 2021-01-21 | Union | Oregon | 41061 | 1131 | 16 |
948657 | 948657 | 2021-01-20 | Union | Oregon | 41061 | 1125 | 16 |
945411 | 945411 | 2021-01-19 | Union | Oregon | 41061 | 1118 | 16 |
942164 | 942164 | 2021-01-18 | Union | Oregon | 41061 | 1114 | 16 |
938919 | 938919 | 2021-01-17 | Union | Oregon | 41061 | 1114 | 16 |
935674 | 935674 | 2021-01-16 | Union | Oregon | 41061 | 1104 | 16 |
932429 | 932429 | 2021-01-15 | Union | Oregon | 41061 | 1095 | 16 |
929184 | 929184 | 2021-01-14 | Union | Oregon | 41061 | 1089 | 16 |
925939 | 925939 | 2021-01-13 | Union | Oregon | 41061 | 1070 | 16 |
922693 | 922693 | 2021-01-12 | Union | Oregon | 41061 | 1063 | 16 |
919448 | 919448 | 2021-01-11 | Union | Oregon | 41061 | 1060 | 16 |
916203 | 916203 | 2021-01-10 | Union | Oregon | 41061 | 1055 | 16 |
912958 | 912958 | 2021-01-09 | Union | Oregon | 41061 | 1049 | 16 |
909713 | 909713 | 2021-01-08 | Union | Oregon | 41061 | 1032 | 16 |
906468 | 906468 | 2021-01-07 | Union | Oregon | 41061 | 1012 | 16 |
903222 | 903222 | 2021-01-06 | Union | Oregon | 41061 | 998 | 16 |
899977 | 899977 | 2021-01-05 | Union | Oregon | 41061 | 995 | 16 |
896732 | 896732 | 2021-01-04 | Union | Oregon | 41061 | 992 | 15 |
893486 | 893486 | 2021-01-03 | Union | Oregon | 41061 | 988 | 15 |
890240 | 890240 | 2021-01-02 | Union | Oregon | 41061 | 982 | 14 |
886993 | 886993 | 2021-01-01 | Union | Oregon | 41061 | 982 | 14 |
883748 | 883748 | 2020-12-31 | Union | Oregon | 41061 | 980 | 14 |
880503 | 880503 | 2020-12-30 | Union | Oregon | 41061 | 977 | 14 |
877258 | 877258 | 2020-12-29 | Union | Oregon | 41061 | 975 | 13 |
874013 | 874013 | 2020-12-28 | Union | Oregon | 41061 | 971 | 13 |
870768 | 870768 | 2020-12-27 | Union | Oregon | 41061 | 970 | 13 |
867523 | 867523 | 2020-12-26 | Union | Oregon | 41061 | 967 | 13 |
864278 | 864278 | 2020-12-25 | Union | Oregon | 41061 | 967 | 13 |
861033 | 861033 | 2020-12-24 | Union | Oregon | 41061 | 965 | 13 |
857788 | 857788 | 2020-12-23 | Union | Oregon | 41061 | 958 | 13 |
854543 | 854543 | 2020-12-22 | Union | Oregon | 41061 | 958 | 13 |
851298 | 851298 | 2020-12-21 | Union | Oregon | 41061 | 947 | 13 |
848053 | 848053 | 2020-12-20 | Union | Oregon | 41061 | 946 | 13 |
844808 | 844808 | 2020-12-19 | Union | Oregon | 41061 | 943 | 13 |
841562 | 841562 | 2020-12-18 | Union | Oregon | 41061 | 935 | 12 |
838317 | 838317 | 2020-12-17 | Union | Oregon | 41061 | 934 | 12 |
835071 | 835071 | 2020-12-16 | Union | Oregon | 41061 | 921 | 12 |
831825 | 831825 | 2020-12-15 | Union | Oregon | 41061 | 912 | 11 |
828578 | 828578 | 2020-12-14 | Union | Oregon | 41061 | 907 | 10 |
825332 | 825332 | 2020-12-13 | Union | Oregon | 41061 | 903 | 10 |
822085 | 822085 | 2020-12-12 | Union | Oregon | 41061 | 901 | 10 |
818839 | 818839 | 2020-12-11 | Union | Oregon | 41061 | 883 | 9 |
815593 | 815593 | 2020-12-10 | Union | Oregon | 41061 | 872 | 9 |
812347 | 812347 | 2020-12-09 | Union | Oregon | 41061 | 870 | 8 |
809103 | 809103 | 2020-12-08 | Union | Oregon | 41061 | 863 | 8 |
805858 | 805858 | 2020-12-07 | Union | Oregon | 41061 | 854 | 8 |
802613 | 802613 | 2020-12-06 | Union | Oregon | 41061 | 847 | 8 |
799368 | 799368 | 2020-12-05 | Union | Oregon | 41061 | 844 | 8 |
796123 | 796123 | 2020-12-04 | Union | Oregon | 41061 | 836 | 8 |
792878 | 792878 | 2020-12-03 | Union | Oregon | 41061 | 815 | 8 |
789633 | 789633 | 2020-12-02 | Union | Oregon | 41061 | 809 | 8 |
786388 | 786388 | 2020-12-01 | Union | Oregon | 41061 | 797 | 8 |
783144 | 783144 | 2020-11-30 | Union | Oregon | 41061 | 788 | 6 |
779898 | 779898 | 2020-11-29 | Union | Oregon | 41061 | 782 | 6 |
776653 | 776653 | 2020-11-28 | Union | Oregon | 41061 | 779 | 6 |
773408 | 773408 | 2020-11-27 | Union | Oregon | 41061 | 771 | 5 |
770163 | 770163 | 2020-11-26 | Union | Oregon | 41061 | 749 | 4 |
766917 | 766917 | 2020-11-25 | Union | Oregon | 41061 | 746 | 3 |
763672 | 763672 | 2020-11-24 | Union | Oregon | 41061 | 723 | 3 |
760427 | 760427 | 2020-11-23 | Union | Oregon | 41061 | 717 | 2 |
757182 | 757182 | 2020-11-22 | Union | Oregon | 41061 | 691 | 2 |
753935 | 753935 | 2020-11-21 | Union | Oregon | 41061 | 686 | 2 |
750689 | 750689 | 2020-11-20 | Union | Oregon | 41061 | 655 | 2 |
747443 | 747443 | 2020-11-19 | Union | Oregon | 41061 | 638 | 2 |
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);