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 |
---|---|---|---|---|---|---|---|
1277794 | 1277794 | 2021-05-02 | Boulder | Colorado | 8013 | 23068 | 254 |
1274547 | 1274547 | 2021-05-01 | Boulder | Colorado | 8013 | 23037 | 254 |
1271300 | 1271300 | 2021-04-30 | Boulder | Colorado | 8013 | 22979 | 254 |
1268053 | 1268053 | 2021-04-29 | Boulder | Colorado | 8013 | 22908 | 253 |
1264806 | 1264806 | 2021-04-28 | Boulder | Colorado | 8013 | 22806 | 253 |
1261559 | 1261559 | 2021-04-27 | Boulder | Colorado | 8013 | 22764 | 253 |
1258312 | 1258312 | 2021-04-26 | Boulder | Colorado | 8013 | 22706 | 251 |
1255065 | 1255065 | 2021-04-25 | Boulder | Colorado | 8013 | 22656 | 251 |
1251818 | 1251818 | 2021-04-24 | Boulder | Colorado | 8013 | 22600 | 251 |
1248571 | 1248571 | 2021-04-23 | Boulder | Colorado | 8013 | 22511 | 251 |
1245324 | 1245324 | 2021-04-22 | Boulder | Colorado | 8013 | 22430 | 251 |
1242077 | 1242077 | 2021-04-21 | Boulder | Colorado | 8013 | 22342 | 251 |
1238830 | 1238830 | 2021-04-20 | Boulder | Colorado | 8013 | 22257 | 251 |
1235583 | 1235583 | 2021-04-19 | Boulder | Colorado | 8013 | 22190 | 251 |
1232336 | 1232336 | 2021-04-18 | Boulder | Colorado | 8013 | 22116 | 251 |
1229087 | 1229087 | 2021-04-17 | Boulder | Colorado | 8013 | 22083 | 251 |
1225839 | 1225839 | 2021-04-16 | Boulder | Colorado | 8013 | 22017 | 251 |
1222592 | 1222592 | 2021-04-15 | Boulder | Colorado | 8013 | 21912 | 250 |
1219344 | 1219344 | 2021-04-14 | Boulder | Colorado | 8013 | 21831 | 250 |
1216096 | 1216096 | 2021-04-13 | Boulder | Colorado | 8013 | 21765 | 250 |
1212849 | 1212849 | 2021-04-12 | Boulder | Colorado | 8013 | 21652 | 250 |
1209601 | 1209601 | 2021-04-11 | Boulder | Colorado | 8013 | 21595 | 250 |
1206352 | 1206352 | 2021-04-10 | Boulder | Colorado | 8013 | 21540 | 250 |
1203104 | 1203104 | 2021-04-09 | Boulder | Colorado | 8013 | 21495 | 250 |
1199856 | 1199856 | 2021-04-08 | Boulder | Colorado | 8013 | 21398 | 250 |
1196607 | 1196607 | 2021-04-07 | Boulder | Colorado | 8013 | 21304 | 250 |
1193359 | 1193359 | 2021-04-06 | Boulder | Colorado | 8013 | 21177 | 250 |
1190109 | 1190109 | 2021-04-05 | Boulder | Colorado | 8013 | 21145 | 250 |
1186862 | 1186862 | 2021-04-04 | Boulder | Colorado | 8013 | 21069 | 250 |
1183615 | 1183615 | 2021-04-03 | Boulder | Colorado | 8013 | 20981 | 250 |
1180368 | 1180368 | 2021-04-02 | Boulder | Colorado | 8013 | 20888 | 250 |
1177121 | 1177121 | 2021-04-01 | Boulder | Colorado | 8013 | 20787 | 250 |
1173874 | 1173874 | 2021-03-31 | Boulder | Colorado | 8013 | 20708 | 250 |
1170627 | 1170627 | 2021-03-30 | Boulder | Colorado | 8013 | 20608 | 250 |
1167379 | 1167379 | 2021-03-29 | Boulder | Colorado | 8013 | 20538 | 250 |
1164131 | 1164131 | 2021-03-28 | Boulder | Colorado | 8013 | 20472 | 250 |
1160883 | 1160883 | 2021-03-27 | Boulder | Colorado | 8013 | 20402 | 250 |
1157635 | 1157635 | 2021-03-26 | Boulder | Colorado | 8013 | 20335 | 250 |
1154388 | 1154388 | 2021-03-25 | Boulder | Colorado | 8013 | 20273 | 250 |
1151141 | 1151141 | 2021-03-24 | Boulder | Colorado | 8013 | 20198 | 250 |
1147894 | 1147894 | 2021-03-23 | Boulder | Colorado | 8013 | 20137 | 250 |
1144647 | 1144647 | 2021-03-22 | Boulder | Colorado | 8013 | 20068 | 250 |
1141400 | 1141400 | 2021-03-21 | Boulder | Colorado | 8013 | 20054 | 250 |
1138154 | 1138154 | 2021-03-20 | Boulder | Colorado | 8013 | 20033 | 250 |
1134908 | 1134908 | 2021-03-19 | Boulder | Colorado | 8013 | 19953 | 250 |
1131661 | 1131661 | 2021-03-18 | Boulder | Colorado | 8013 | 19856 | 250 |
1128413 | 1128413 | 2021-03-17 | Boulder | Colorado | 8013 | 19762 | 250 |
1125167 | 1125167 | 2021-03-16 | Boulder | Colorado | 8013 | 19696 | 250 |
1121921 | 1121921 | 2021-03-15 | Boulder | Colorado | 8013 | 19680 | 250 |
1118674 | 1118674 | 2021-03-14 | Boulder | Colorado | 8013 | 19675 | 250 |
1115427 | 1115427 | 2021-03-13 | Boulder | Colorado | 8013 | 19630 | 250 |
1112181 | 1112181 | 2021-03-12 | Boulder | Colorado | 8013 | 19514 | 249 |
1108935 | 1108935 | 2021-03-11 | Boulder | Colorado | 8013 | 19445 | 248 |
1105689 | 1105689 | 2021-03-10 | Boulder | Colorado | 8013 | 19395 | 248 |
1102443 | 1102443 | 2021-03-09 | Boulder | Colorado | 8013 | 19344 | 248 |
1099197 | 1099197 | 2021-03-08 | Boulder | Colorado | 8013 | 19304 | 248 |
1095949 | 1095949 | 2021-03-07 | Boulder | Colorado | 8013 | 19283 | 248 |
1092703 | 1092703 | 2021-03-06 | Boulder | Colorado | 8013 | 19246 | 248 |
1089457 | 1089457 | 2021-03-05 | Boulder | Colorado | 8013 | 19188 | 248 |
1086212 | 1086212 | 2021-03-04 | Boulder | Colorado | 8013 | 19132 | 247 |
1082966 | 1082966 | 2021-03-03 | Boulder | Colorado | 8013 | 19082 | 247 |
1079720 | 1079720 | 2021-03-02 | Boulder | Colorado | 8013 | 19003 | 247 |
1076475 | 1076475 | 2021-03-01 | Boulder | Colorado | 8013 | 18965 | 246 |
1073229 | 1073229 | 2021-02-28 | Boulder | Colorado | 8013 | 18945 | 246 |
1069983 | 1069983 | 2021-02-27 | Boulder | Colorado | 8013 | 18893 | 246 |
1066738 | 1066738 | 2021-02-26 | Boulder | Colorado | 8013 | 18842 | 246 |
1063493 | 1063493 | 2021-02-25 | Boulder | Colorado | 8013 | 18779 | 246 |
1060248 | 1060248 | 2021-02-24 | Boulder | Colorado | 8013 | 18723 | 246 |
1057002 | 1057002 | 2021-02-23 | Boulder | Colorado | 8013 | 18659 | 246 |
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 |
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);