ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Boulder" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953142 | 953142 | 2021-01-22 | Boulder | Colorado | 8013 | 16729 | 219 |
949897 | 949897 | 2021-01-21 | Boulder | Colorado | 8013 | 16649 | 217 |
946651 | 946651 | 2021-01-20 | Boulder | Colorado | 8013 | 16546 | 217 |
943404 | 943404 | 2021-01-19 | Boulder | Colorado | 8013 | 16479 | 217 |
940159 | 940159 | 2021-01-18 | Boulder | Colorado | 8013 | 16390 | 207 |
936914 | 936914 | 2021-01-17 | Boulder | Colorado | 8013 | 16375 | 207 |
933669 | 933669 | 2021-01-16 | Boulder | Colorado | 8013 | 16301 | 207 |
930424 | 930424 | 2021-01-15 | Boulder | Colorado | 8013 | 16212 | 207 |
927179 | 927179 | 2021-01-14 | Boulder | Colorado | 8013 | 16138 | 204 |
923933 | 923933 | 2021-01-13 | Boulder | Colorado | 8013 | 16060 | 203 |
920688 | 920688 | 2021-01-12 | Boulder | Colorado | 8013 | 15955 | 203 |
917443 | 917443 | 2021-01-11 | Boulder | Colorado | 8013 | 15908 | 201 |
914198 | 914198 | 2021-01-10 | Boulder | Colorado | 8013 | 15857 | 198 |
910953 | 910953 | 2021-01-09 | Boulder | Colorado | 8013 | 15762 | 198 |
907708 | 907708 | 2021-01-08 | Boulder | Colorado | 8013 | 15674 | 198 |
904462 | 904462 | 2021-01-07 | Boulder | Colorado | 8013 | 15538 | 184 |
901217 | 901217 | 2021-01-06 | Boulder | Colorado | 8013 | 15433 | 184 |
897972 | 897972 | 2021-01-05 | Boulder | Colorado | 8013 | 15333 | 184 |
894727 | 894727 | 2021-01-04 | Boulder | Colorado | 8013 | 15151 | 184 |
891480 | 891480 | 2021-01-03 | Boulder | Colorado | 8013 | 14996 | 182 |
888233 | 888233 | 2021-01-02 | Boulder | Colorado | 8013 | 14889 | 182 |
884988 | 884988 | 2021-01-01 | Boulder | Colorado | 8013 | 14729 | 182 |
881743 | 881743 | 2020-12-31 | Boulder | Colorado | 8013 | 14706 | 182 |
878498 | 878498 | 2020-12-30 | Boulder | Colorado | 8013 | 14614 | 182 |
875253 | 875253 | 2020-12-29 | Boulder | Colorado | 8013 | 14515 | 180 |
872008 | 872008 | 2020-12-28 | Boulder | Colorado | 8013 | 14476 | 179 |
868763 | 868763 | 2020-12-27 | Boulder | Colorado | 8013 | 14339 | 174 |
865518 | 865518 | 2020-12-26 | Boulder | Colorado | 8013 | 14299 | 174 |
862273 | 862273 | 2020-12-25 | Boulder | Colorado | 8013 | 14125 | 174 |
859028 | 859028 | 2020-12-24 | Boulder | Colorado | 8013 | 14110 | 174 |
855783 | 855783 | 2020-12-23 | Boulder | Colorado | 8013 | 14045 | 174 |
852538 | 852538 | 2020-12-22 | Boulder | Colorado | 8013 | 13941 | 171 |
849293 | 849293 | 2020-12-21 | Boulder | Colorado | 8013 | 13846 | 167 |
846048 | 846048 | 2020-12-20 | Boulder | Colorado | 8013 | 13775 | 166 |
842802 | 842802 | 2020-12-19 | Boulder | Colorado | 8013 | 13698 | 166 |
839557 | 839557 | 2020-12-18 | Boulder | Colorado | 8013 | 13616 | 166 |
836312 | 836312 | 2020-12-17 | Boulder | Colorado | 8013 | 13487 | 163 |
833066 | 833066 | 2020-12-16 | Boulder | Colorado | 8013 | 13378 | 160 |
829819 | 829819 | 2020-12-15 | Boulder | Colorado | 8013 | 13249 | 159 |
826573 | 826573 | 2020-12-14 | Boulder | Colorado | 8013 | 13155 | 154 |
823326 | 823326 | 2020-12-13 | Boulder | Colorado | 8013 | 13073 | 148 |
820080 | 820080 | 2020-12-12 | Boulder | Colorado | 8013 | 13003 | 143 |
816834 | 816834 | 2020-12-11 | Boulder | Colorado | 8013 | 12865 | 141 |
813588 | 813588 | 2020-12-10 | Boulder | Colorado | 8013 | 12719 | 142 |
810344 | 810344 | 2020-12-09 | Boulder | Colorado | 8013 | 12572 | 141 |
807099 | 807099 | 2020-12-08 | Boulder | Colorado | 8013 | 12464 | 140 |
803854 | 803854 | 2020-12-07 | Boulder | Colorado | 8013 | 12327 | 140 |
800609 | 800609 | 2020-12-06 | Boulder | Colorado | 8013 | 12154 | 135 |
797364 | 797364 | 2020-12-05 | Boulder | Colorado | 8013 | 12074 | 135 |
794119 | 794119 | 2020-12-04 | Boulder | Colorado | 8013 | 11950 | 135 |
790874 | 790874 | 2020-12-03 | Boulder | Colorado | 8013 | 11799 | 129 |
787629 | 787629 | 2020-12-02 | Boulder | Colorado | 8013 | 11642 | 125 |
784385 | 784385 | 2020-12-01 | Boulder | Colorado | 8013 | 11433 | 124 |
781140 | 781140 | 2020-11-30 | Boulder | Colorado | 8013 | 11266 | 122 |
777894 | 777894 | 2020-11-29 | Boulder | Colorado | 8013 | 10974 | 122 |
774649 | 774649 | 2020-11-28 | Boulder | Colorado | 8013 | 10887 | 122 |
771404 | 771404 | 2020-11-27 | Boulder | Colorado | 8013 | 10728 | 118 |
768159 | 768159 | 2020-11-26 | Boulder | Colorado | 8013 | 10585 | 117 |
764913 | 764913 | 2020-11-25 | Boulder | Colorado | 8013 | 10450 | 117 |
761668 | 761668 | 2020-11-24 | Boulder | Colorado | 8013 | 10282 | 117 |
758423 | 758423 | 2020-11-23 | Boulder | Colorado | 8013 | 10130 | 115 |
755176 | 755176 | 2020-11-22 | Boulder | Colorado | 8013 | 9973 | 115 |
751930 | 751930 | 2020-11-21 | Boulder | Colorado | 8013 | 9814 | 113 |
748684 | 748684 | 2020-11-20 | Boulder | Colorado | 8013 | 9660 | 112 |
745438 | 745438 | 2020-11-19 | Boulder | Colorado | 8013 | 9362 | 112 |
742191 | 742191 | 2020-11-18 | Boulder | Colorado | 8013 | 9146 | 111 |
738944 | 738944 | 2020-11-17 | Boulder | Colorado | 8013 | 8910 | 108 |
735700 | 735700 | 2020-11-16 | Boulder | Colorado | 8013 | 8702 | 108 |
732454 | 732454 | 2020-11-15 | Boulder | Colorado | 8013 | 8553 | 106 |
729209 | 729209 | 2020-11-14 | Boulder | Colorado | 8013 | 8445 | 104 |
725966 | 725966 | 2020-11-13 | Boulder | Colorado | 8013 | 8124 | 104 |
722723 | 722723 | 2020-11-12 | Boulder | Colorado | 8013 | 7857 | 102 |
719480 | 719480 | 2020-11-11 | Boulder | Colorado | 8013 | 7606 | 99 |
716237 | 716237 | 2020-11-10 | Boulder | Colorado | 8013 | 7316 | 99 |
712993 | 712993 | 2020-11-09 | Boulder | Colorado | 8013 | 7096 | 99 |
709749 | 709749 | 2020-11-08 | Boulder | Colorado | 8013 | 6888 | 98 |
706505 | 706505 | 2020-11-07 | Boulder | Colorado | 8013 | 6801 | 97 |
703262 | 703262 | 2020-11-06 | Boulder | Colorado | 8013 | 6705 | 97 |
700019 | 700019 | 2020-11-05 | Boulder | Colorado | 8013 | 6590 | 95 |
696775 | 696775 | 2020-11-04 | Boulder | Colorado | 8013 | 6298 | 93 |
693533 | 693533 | 2020-11-03 | Boulder | Colorado | 8013 | 6225 | 92 |
690290 | 690290 | 2020-11-02 | Boulder | Colorado | 8013 | 6130 | 89 |
687045 | 687045 | 2020-11-01 | Boulder | Colorado | 8013 | 6083 | 88 |
683801 | 683801 | 2020-10-31 | Boulder | Colorado | 8013 | 5937 | 88 |
680558 | 680558 | 2020-10-30 | Boulder | Colorado | 8013 | 5797 | 86 |
677315 | 677315 | 2020-10-29 | Boulder | Colorado | 8013 | 5680 | 85 |
674072 | 674072 | 2020-10-28 | Boulder | Colorado | 8013 | 5651 | 85 |
670830 | 670830 | 2020-10-27 | Boulder | Colorado | 8013 | 5544 | 85 |
667587 | 667587 | 2020-10-26 | Boulder | Colorado | 8013 | 5509 | 85 |
664342 | 664342 | 2020-10-25 | Boulder | Colorado | 8013 | 5441 | 85 |
661098 | 661098 | 2020-10-24 | Boulder | Colorado | 8013 | 5403 | 85 |
657854 | 657854 | 2020-10-23 | Boulder | Colorado | 8013 | 5310 | 85 |
654609 | 654609 | 2020-10-22 | Boulder | Colorado | 8013 | 5229 | 85 |
651364 | 651364 | 2020-10-21 | Boulder | Colorado | 8013 | 5189 | 85 |
648120 | 648120 | 2020-10-20 | Boulder | Colorado | 8013 | 5151 | 85 |
644875 | 644875 | 2020-10-19 | Boulder | Colorado | 8013 | 5108 | 84 |
641627 | 641627 | 2020-10-18 | Boulder | Colorado | 8013 | 5078 | 84 |
638380 | 638380 | 2020-10-17 | Boulder | Colorado | 8013 | 5043 | 84 |
635135 | 635135 | 2020-10-16 | Boulder | Colorado | 8013 | 4998 | 84 |
631889 | 631889 | 2020-10-15 | Boulder | Colorado | 8013 | 4954 | 83 |
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);