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 |
---|---|---|---|---|---|---|---|
1277806 | 1277806 | 2021-05-02 | Douglas | Colorado | 8035 | 28493 | 253 |
1274559 | 1274559 | 2021-05-01 | Douglas | Colorado | 8035 | 28385 | 253 |
1271312 | 1271312 | 2021-04-30 | Douglas | Colorado | 8035 | 28385 | 253 |
1268065 | 1268065 | 2021-04-29 | Douglas | Colorado | 8035 | 28246 | 252 |
1264818 | 1264818 | 2021-04-28 | Douglas | Colorado | 8035 | 27976 | 252 |
1261571 | 1261571 | 2021-04-27 | Douglas | Colorado | 8035 | 27976 | 252 |
1258324 | 1258324 | 2021-04-26 | Douglas | Colorado | 8035 | 27810 | 252 |
1255077 | 1255077 | 2021-04-25 | Douglas | Colorado | 8035 | 27558 | 252 |
1251830 | 1251830 | 2021-04-24 | Douglas | Colorado | 8035 | 27372 | 251 |
1248583 | 1248583 | 2021-04-23 | Douglas | Colorado | 8035 | 27372 | 251 |
1245336 | 1245336 | 2021-04-22 | Douglas | Colorado | 8035 | 27207 | 251 |
1242089 | 1242089 | 2021-04-21 | Douglas | Colorado | 8035 | 27018 | 251 |
1238842 | 1238842 | 2021-04-20 | Douglas | Colorado | 8035 | 26934 | 251 |
1235595 | 1235595 | 2021-04-19 | Douglas | Colorado | 8035 | 26846 | 250 |
1232348 | 1232348 | 2021-04-18 | Douglas | Colorado | 8035 | 26488 | 250 |
1229099 | 1229099 | 2021-04-17 | Douglas | Colorado | 8035 | 26488 | 250 |
1225851 | 1225851 | 2021-04-16 | Douglas | Colorado | 8035 | 26488 | 250 |
1222604 | 1222604 | 2021-04-15 | Douglas | Colorado | 8035 | 26345 | 250 |
1219356 | 1219356 | 2021-04-14 | Douglas | Colorado | 8035 | 26083 | 249 |
1216108 | 1216108 | 2021-04-13 | Douglas | Colorado | 8035 | 25840 | 249 |
1212861 | 1212861 | 2021-04-12 | Douglas | Colorado | 8035 | 25764 | 235 |
1209613 | 1209613 | 2021-04-11 | Douglas | Colorado | 8035 | 25663 | 235 |
1206364 | 1206364 | 2021-04-10 | Douglas | Colorado | 8035 | 25418 | 235 |
1203116 | 1203116 | 2021-04-09 | Douglas | Colorado | 8035 | 25418 | 235 |
1199868 | 1199868 | 2021-04-08 | Douglas | Colorado | 8035 | 25287 | 235 |
1196619 | 1196619 | 2021-04-07 | Douglas | Colorado | 8035 | 25102 | 235 |
1193371 | 1193371 | 2021-04-06 | Douglas | Colorado | 8035 | 24993 | 235 |
1190121 | 1190121 | 2021-04-05 | Douglas | Colorado | 8035 | 24911 | 235 |
1186874 | 1186874 | 2021-04-04 | Douglas | Colorado | 8035 | 24827 | 235 |
1183627 | 1183627 | 2021-04-03 | Douglas | Colorado | 8035 | 24580 | 234 |
1180380 | 1180380 | 2021-04-02 | Douglas | Colorado | 8035 | 24580 | 234 |
1177133 | 1177133 | 2021-04-01 | Douglas | Colorado | 8035 | 24436 | 234 |
1173886 | 1173886 | 2021-03-31 | Douglas | Colorado | 8035 | 24288 | 234 |
1170639 | 1170639 | 2021-03-30 | Douglas | Colorado | 8035 | 24157 | 234 |
1167391 | 1167391 | 2021-03-29 | Douglas | Colorado | 8035 | 24111 | 234 |
1164143 | 1164143 | 2021-03-28 | Douglas | Colorado | 8035 | 23988 | 234 |
1160895 | 1160895 | 2021-03-27 | Douglas | Colorado | 8035 | 23988 | 234 |
1157647 | 1157647 | 2021-03-26 | Douglas | Colorado | 8035 | 23683 | 234 |
1154400 | 1154400 | 2021-03-25 | Douglas | Colorado | 8035 | 23683 | 234 |
1151153 | 1151153 | 2021-03-24 | Douglas | Colorado | 8035 | 23683 | 234 |
1147906 | 1147906 | 2021-03-23 | Douglas | Colorado | 8035 | 23331 | 234 |
1144659 | 1144659 | 2021-03-22 | Douglas | Colorado | 8035 | 23331 | 234 |
1141412 | 1141412 | 2021-03-21 | Douglas | Colorado | 8035 | 23331 | 234 |
1138166 | 1138166 | 2021-03-20 | Douglas | Colorado | 8035 | 23332 | 234 |
1134920 | 1134920 | 2021-03-19 | Douglas | Colorado | 8035 | 23138 | 233 |
1131673 | 1131673 | 2021-03-18 | Douglas | Colorado | 8035 | 23136 | 233 |
1128425 | 1128425 | 2021-03-17 | Douglas | Colorado | 8035 | 23059 | 233 |
1125179 | 1125179 | 2021-03-16 | Douglas | Colorado | 8035 | 23044 | 233 |
1121933 | 1121933 | 2021-03-15 | Douglas | Colorado | 8035 | 23034 | 233 |
1118686 | 1118686 | 2021-03-14 | Douglas | Colorado | 8035 | 22896 | 233 |
1115439 | 1115439 | 2021-03-13 | Douglas | Colorado | 8035 | 22896 | 233 |
1112193 | 1112193 | 2021-03-12 | Douglas | Colorado | 8035 | 22798 | 233 |
1108947 | 1108947 | 2021-03-11 | Douglas | Colorado | 8035 | 22713 | 233 |
1105701 | 1105701 | 2021-03-10 | Douglas | Colorado | 8035 | 22636 | 233 |
1102455 | 1102455 | 2021-03-09 | Douglas | Colorado | 8035 | 22578 | 233 |
1099209 | 1099209 | 2021-03-08 | Douglas | Colorado | 8035 | 22531 | 233 |
1095961 | 1095961 | 2021-03-07 | Douglas | Colorado | 8035 | 22252 | 231 |
1092715 | 1092715 | 2021-03-06 | Douglas | Colorado | 8035 | 22252 | 231 |
1089469 | 1089469 | 2021-03-05 | Douglas | Colorado | 8035 | 22252 | 231 |
1086224 | 1086224 | 2021-03-04 | Douglas | Colorado | 8035 | 22148 | 231 |
1082978 | 1082978 | 2021-03-03 | Douglas | Colorado | 8035 | 22046 | 231 |
1079732 | 1079732 | 2021-03-02 | Douglas | Colorado | 8035 | 21940 | 230 |
1076487 | 1076487 | 2021-03-01 | Douglas | Colorado | 8035 | 21894 | 230 |
1073241 | 1073241 | 2021-02-28 | Douglas | Colorado | 8035 | 21842 | 230 |
1069995 | 1069995 | 2021-02-27 | Douglas | Colorado | 8035 | 21771 | 230 |
1066750 | 1066750 | 2021-02-26 | Douglas | Colorado | 8035 | 21659 | 230 |
1063505 | 1063505 | 2021-02-25 | Douglas | Colorado | 8035 | 21550 | 230 |
1060260 | 1060260 | 2021-02-24 | Douglas | Colorado | 8035 | 21472 | 230 |
1057014 | 1057014 | 2021-02-23 | Douglas | Colorado | 8035 | 21405 | 230 |
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 |
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);