ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Douglas" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053768 | 1053768 | 2021-02-22 | Douglas | Colorado | 8035 | 21347 | 230 |
1050521 | 1050521 | 2021-02-21 | Douglas | Colorado | 8035 | 21290 | 230 |
1047274 | 1047274 | 2021-02-20 | Douglas | Colorado | 8035 | 21225 | 230 |
1044029 | 1044029 | 2021-02-19 | Douglas | Colorado | 8035 | 21144 | 230 |
1040784 | 1040784 | 2021-02-18 | Douglas | Colorado | 8035 | 21061 | 230 |
1037539 | 1037539 | 2021-02-17 | Douglas | Colorado | 8035 | 20958 | 230 |
1034294 | 1034294 | 2021-02-16 | Douglas | Colorado | 8035 | 20879 | 230 |
1031048 | 1031048 | 2021-02-15 | Douglas | Colorado | 8035 | 20806 | 230 |
1027801 | 1027801 | 2021-02-14 | Douglas | Colorado | 8035 | 20613 | 230 |
1024556 | 1024556 | 2021-02-13 | Douglas | Colorado | 8035 | 20613 | 230 |
1021311 | 1021311 | 2021-02-12 | Douglas | Colorado | 8035 | 20560 | 230 |
1018066 | 1018066 | 2021-02-11 | Douglas | Colorado | 8035 | 20343 | 230 |
1014821 | 1014821 | 2021-02-10 | Douglas | Colorado | 8035 | 20336 | 230 |
1011576 | 1011576 | 2021-02-09 | Douglas | Colorado | 8035 | 20273 | 229 |
1008330 | 1008330 | 2021-02-08 | Douglas | Colorado | 8035 | 20206 | 229 |
1005084 | 1005084 | 2021-02-07 | Douglas | Colorado | 8035 | 20131 | 229 |
1001838 | 1001838 | 2021-02-06 | Douglas | Colorado | 8035 | 20027 | 229 |
998592 | 998592 | 2021-02-05 | Douglas | Colorado | 8035 | 19916 | 229 |
995346 | 995346 | 2021-02-04 | Douglas | Colorado | 8035 | 19751 | 228 |
992100 | 992100 | 2021-02-03 | Douglas | Colorado | 8035 | 19630 | 228 |
988854 | 988854 | 2021-02-02 | Douglas | Colorado | 8035 | 19551 | 228 |
985607 | 985607 | 2021-02-01 | Douglas | Colorado | 8035 | 19480 | 228 |
982360 | 982360 | 2021-01-31 | Douglas | Colorado | 8035 | 19371 | 227 |
979114 | 979114 | 2021-01-30 | Douglas | Colorado | 8035 | 19212 | 227 |
975869 | 975869 | 2021-01-29 | Douglas | Colorado | 8035 | 19212 | 227 |
972624 | 972624 | 2021-01-28 | Douglas | Colorado | 8035 | 19104 | 226 |
969379 | 969379 | 2021-01-27 | Douglas | Colorado | 8035 | 19010 | 226 |
966135 | 966135 | 2021-01-26 | Douglas | Colorado | 8035 | 18861 | 225 |
962890 | 962890 | 2021-01-25 | Douglas | Colorado | 8035 | 18862 | 225 |
959645 | 959645 | 2021-01-24 | Douglas | Colorado | 8035 | 18710 | 224 |
956399 | 956399 | 2021-01-23 | Douglas | Colorado | 8035 | 18602 | 224 |
953154 | 953154 | 2021-01-22 | Douglas | Colorado | 8035 | 18602 | 224 |
949909 | 949909 | 2021-01-21 | Douglas | Colorado | 8035 | 18411 | 222 |
946663 | 946663 | 2021-01-20 | Douglas | Colorado | 8035 | 18411 | 222 |
943416 | 943416 | 2021-01-19 | Douglas | Colorado | 8035 | 18351 | 222 |
940171 | 940171 | 2021-01-18 | Douglas | Colorado | 8035 | 18277 | 222 |
936926 | 936926 | 2021-01-17 | Douglas | Colorado | 8035 | 18196 | 222 |
933681 | 933681 | 2021-01-16 | Douglas | Colorado | 8035 | 18132 | 221 |
930436 | 930436 | 2021-01-15 | Douglas | Colorado | 8035 | 18024 | 217 |
927191 | 927191 | 2021-01-14 | Douglas | Colorado | 8035 | 17911 | 216 |
923945 | 923945 | 2021-01-13 | Douglas | Colorado | 8035 | 17720 | 215 |
920700 | 920700 | 2021-01-12 | Douglas | Colorado | 8035 | 17594 | 214 |
917455 | 917455 | 2021-01-11 | Douglas | Colorado | 8035 | 17520 | 212 |
914210 | 914210 | 2021-01-10 | Douglas | Colorado | 8035 | 17420 | 212 |
910965 | 910965 | 2021-01-09 | Douglas | Colorado | 8035 | 17264 | 211 |
907720 | 907720 | 2021-01-08 | Douglas | Colorado | 8035 | 16957 | 210 |
904474 | 904474 | 2021-01-07 | Douglas | Colorado | 8035 | 16957 | 210 |
901229 | 901229 | 2021-01-06 | Douglas | Colorado | 8035 | 16713 | 205 |
897984 | 897984 | 2021-01-05 | Douglas | Colorado | 8035 | 16599 | 203 |
894739 | 894739 | 2021-01-04 | Douglas | Colorado | 8035 | 16445 | 202 |
891492 | 891492 | 2021-01-03 | Douglas | Colorado | 8035 | 16271 | 201 |
888245 | 888245 | 2021-01-02 | Douglas | Colorado | 8035 | 16200 | 201 |
885000 | 885000 | 2021-01-01 | Douglas | Colorado | 8035 | 16085 | 200 |
881755 | 881755 | 2020-12-31 | Douglas | Colorado | 8035 | 15981 | 199 |
878510 | 878510 | 2020-12-30 | Douglas | Colorado | 8035 | 15782 | 196 |
875265 | 875265 | 2020-12-29 | Douglas | Colorado | 8035 | 15700 | 189 |
872020 | 872020 | 2020-12-28 | Douglas | Colorado | 8035 | 15593 | 188 |
868775 | 868775 | 2020-12-27 | Douglas | Colorado | 8035 | 15442 | 186 |
865530 | 865530 | 2020-12-26 | Douglas | Colorado | 8035 | 15381 | 186 |
862285 | 862285 | 2020-12-25 | Douglas | Colorado | 8035 | 15310 | 182 |
859040 | 859040 | 2020-12-24 | Douglas | Colorado | 8035 | 15196 | 181 |
855795 | 855795 | 2020-12-23 | Douglas | Colorado | 8035 | 15071 | 177 |
852550 | 852550 | 2020-12-22 | Douglas | Colorado | 8035 | 14946 | 174 |
849305 | 849305 | 2020-12-21 | Douglas | Colorado | 8035 | 14817 | 170 |
846060 | 846060 | 2020-12-20 | Douglas | Colorado | 8035 | 14702 | 170 |
842814 | 842814 | 2020-12-19 | Douglas | Colorado | 8035 | 14603 | 168 |
839569 | 839569 | 2020-12-18 | Douglas | Colorado | 8035 | 14456 | 161 |
836324 | 836324 | 2020-12-17 | Douglas | Colorado | 8035 | 14320 | 153 |
833078 | 833078 | 2020-12-16 | Douglas | Colorado | 8035 | 14168 | 150 |
829831 | 829831 | 2020-12-15 | Douglas | Colorado | 8035 | 14051 | 149 |
826585 | 826585 | 2020-12-14 | Douglas | Colorado | 8035 | 13939 | 146 |
823338 | 823338 | 2020-12-13 | Douglas | Colorado | 8035 | 13793 | 146 |
820092 | 820092 | 2020-12-12 | Douglas | Colorado | 8035 | 13654 | 143 |
816846 | 816846 | 2020-12-11 | Douglas | Colorado | 8035 | 13396 | 142 |
813600 | 813600 | 2020-12-10 | Douglas | Colorado | 8035 | 13225 | 139 |
810356 | 810356 | 2020-12-09 | Douglas | Colorado | 8035 | 13014 | 131 |
807111 | 807111 | 2020-12-08 | Douglas | Colorado | 8035 | 12809 | 125 |
803866 | 803866 | 2020-12-07 | Douglas | Colorado | 8035 | 12634 | 123 |
800621 | 800621 | 2020-12-06 | Douglas | Colorado | 8035 | 12462 | 123 |
797376 | 797376 | 2020-12-05 | Douglas | Colorado | 8035 | 12042 | 123 |
794131 | 794131 | 2020-12-04 | Douglas | Colorado | 8035 | 11876 | 122 |
790886 | 790886 | 2020-12-03 | Douglas | Colorado | 8035 | 11517 | 122 |
787641 | 787641 | 2020-12-02 | Douglas | Colorado | 8035 | 11401 | 114 |
784397 | 784397 | 2020-12-01 | Douglas | Colorado | 8035 | 11247 | 110 |
781152 | 781152 | 2020-11-30 | Douglas | Colorado | 8035 | 10974 | 102 |
777906 | 777906 | 2020-11-29 | Douglas | Colorado | 8035 | 10772 | 101 |
774661 | 774661 | 2020-11-28 | Douglas | Colorado | 8035 | 10585 | 100 |
771416 | 771416 | 2020-11-27 | Douglas | Colorado | 8035 | 10391 | 100 |
768171 | 768171 | 2020-11-26 | Douglas | Colorado | 8035 | 10140 | 101 |
764925 | 764925 | 2020-11-25 | Douglas | Colorado | 8035 | 9791 | 100 |
761680 | 761680 | 2020-11-24 | Douglas | Colorado | 8035 | 9593 | 98 |
758435 | 758435 | 2020-11-23 | Douglas | Colorado | 8035 | 9382 | 98 |
755188 | 755188 | 2020-11-22 | Douglas | Colorado | 8035 | 9080 | 98 |
751942 | 751942 | 2020-11-21 | Douglas | Colorado | 8035 | 8849 | 97 |
748696 | 748696 | 2020-11-20 | Douglas | Colorado | 8035 | 8555 | 93 |
745450 | 745450 | 2020-11-19 | Douglas | Colorado | 8035 | 8321 | 94 |
742203 | 742203 | 2020-11-18 | Douglas | Colorado | 8035 | 7950 | 91 |
738956 | 738956 | 2020-11-17 | Douglas | Colorado | 8035 | 7670 | 84 |
735712 | 735712 | 2020-11-16 | Douglas | Colorado | 8035 | 7465 | 83 |
732466 | 732466 | 2020-11-15 | Douglas | Colorado | 8035 | 7256 | 79 |
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);