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 |
---|---|---|---|---|---|---|---|
1053756 | 1053756 | 2021-02-22 | Boulder | Colorado | 8013 | 18633 | 245 |
1050509 | 1050509 | 2021-02-21 | Boulder | Colorado | 8013 | 18599 | 245 |
1047262 | 1047262 | 2021-02-20 | Boulder | Colorado | 8013 | 18560 | 245 |
1044017 | 1044017 | 2021-02-19 | Boulder | Colorado | 8013 | 18508 | 245 |
1040772 | 1040772 | 2021-02-18 | Boulder | Colorado | 8013 | 18410 | 245 |
1037527 | 1037527 | 2021-02-17 | Boulder | Colorado | 8013 | 18359 | 245 |
1034282 | 1034282 | 2021-02-16 | Boulder | Colorado | 8013 | 18264 | 244 |
1031036 | 1031036 | 2021-02-15 | Boulder | Colorado | 8013 | 18228 | 242 |
1027789 | 1027789 | 2021-02-14 | Boulder | Colorado | 8013 | 18211 | 242 |
1024544 | 1024544 | 2021-02-13 | Boulder | Colorado | 8013 | 18188 | 242 |
1021299 | 1021299 | 2021-02-12 | Boulder | Colorado | 8013 | 18098 | 242 |
1018054 | 1018054 | 2021-02-11 | Boulder | Colorado | 8013 | 18042 | 236 |
1014809 | 1014809 | 2021-02-10 | Boulder | Colorado | 8013 | 17860 | 236 |
1011564 | 1011564 | 2021-02-09 | Boulder | Colorado | 8013 | 17860 | 234 |
1008318 | 1008318 | 2021-02-08 | Boulder | Colorado | 8013 | 17800 | 234 |
1005072 | 1005072 | 2021-02-07 | Boulder | Colorado | 8013 | 17759 | 234 |
1001826 | 1001826 | 2021-02-06 | Boulder | Colorado | 8013 | 17695 | 234 |
998580 | 998580 | 2021-02-05 | Boulder | Colorado | 8013 | 17638 | 234 |
995334 | 995334 | 2021-02-04 | Boulder | Colorado | 8013 | 17556 | 232 |
992088 | 992088 | 2021-02-03 | Boulder | Colorado | 8013 | 17497 | 232 |
988842 | 988842 | 2021-02-02 | Boulder | Colorado | 8013 | 17433 | 232 |
985595 | 985595 | 2021-02-01 | Boulder | Colorado | 8013 | 17376 | 232 |
982348 | 982348 | 2021-01-31 | Boulder | Colorado | 8013 | 17329 | 232 |
979102 | 979102 | 2021-01-30 | Boulder | Colorado | 8013 | 17279 | 232 |
975857 | 975857 | 2021-01-29 | Boulder | Colorado | 8013 | 17225 | 232 |
972612 | 972612 | 2021-01-28 | Boulder | Colorado | 8013 | 17148 | 231 |
969367 | 969367 | 2021-01-27 | Boulder | Colorado | 8013 | 17100 | 230 |
966123 | 966123 | 2021-01-26 | Boulder | Colorado | 8013 | 16956 | 229 |
962878 | 962878 | 2021-01-25 | Boulder | Colorado | 8013 | 16894 | 225 |
959633 | 959633 | 2021-01-24 | Boulder | Colorado | 8013 | 16848 | 219 |
956387 | 956387 | 2021-01-23 | Boulder | Colorado | 8013 | 16784 | 219 |
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 |
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);