ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 8035 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
729221 | 729221 | 2020-11-14 | Douglas | Colorado | 8035 | 7066 | 79 |
725978 | 725978 | 2020-11-13 | Douglas | Colorado | 8035 | 6783 | 78 |
722735 | 722735 | 2020-11-12 | Douglas | Colorado | 8035 | 6291 | 78 |
719492 | 719492 | 2020-11-11 | Douglas | Colorado | 8035 | 6080 | 77 |
716249 | 716249 | 2020-11-10 | Douglas | Colorado | 8035 | 5929 | 71 |
713005 | 713005 | 2020-11-09 | Douglas | Colorado | 8035 | 5820 | 68 |
709761 | 709761 | 2020-11-08 | Douglas | Colorado | 8035 | 5541 | 68 |
706517 | 706517 | 2020-11-07 | Douglas | Colorado | 8035 | 5394 | 69 |
703274 | 703274 | 2020-11-06 | Douglas | Colorado | 8035 | 5219 | 68 |
700031 | 700031 | 2020-11-05 | Douglas | Colorado | 8035 | 5061 | 68 |
696787 | 696787 | 2020-11-04 | Douglas | Colorado | 8035 | 4891 | 67 |
693545 | 693545 | 2020-11-03 | Douglas | Colorado | 8035 | 4687 | 65 |
690302 | 690302 | 2020-11-02 | Douglas | Colorado | 8035 | 4669 | 65 |
687057 | 687057 | 2020-11-01 | Douglas | Colorado | 8035 | 4545 | 65 |
683813 | 683813 | 2020-10-31 | Douglas | Colorado | 8035 | 4394 | 65 |
680570 | 680570 | 2020-10-30 | Douglas | Colorado | 8035 | 4225 | 65 |
677327 | 677327 | 2020-10-29 | Douglas | Colorado | 8035 | 4168 | 65 |
674084 | 674084 | 2020-10-28 | Douglas | Colorado | 8035 | 4080 | 64 |
670842 | 670842 | 2020-10-27 | Douglas | Colorado | 8035 | 4021 | 64 |
667599 | 667599 | 2020-10-26 | Douglas | Colorado | 8035 | 3940 | 64 |
664354 | 664354 | 2020-10-25 | Douglas | Colorado | 8035 | 3810 | 64 |
661110 | 661110 | 2020-10-24 | Douglas | Colorado | 8035 | 3719 | 64 |
657866 | 657866 | 2020-10-23 | Douglas | Colorado | 8035 | 3607 | 64 |
654621 | 654621 | 2020-10-22 | Douglas | Colorado | 8035 | 3554 | 64 |
651376 | 651376 | 2020-10-21 | Douglas | Colorado | 8035 | 3510 | 64 |
648132 | 648132 | 2020-10-20 | Douglas | Colorado | 8035 | 3485 | 63 |
644887 | 644887 | 2020-10-19 | Douglas | Colorado | 8035 | 3449 | 63 |
641639 | 641639 | 2020-10-18 | Douglas | Colorado | 8035 | 3421 | 63 |
638392 | 638392 | 2020-10-17 | Douglas | Colorado | 8035 | 3368 | 63 |
635147 | 635147 | 2020-10-16 | Douglas | Colorado | 8035 | 3335 | 63 |
631901 | 631901 | 2020-10-15 | Douglas | Colorado | 8035 | 3297 | 63 |
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);