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 |
---|---|---|---|---|---|---|---|
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 |
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 |
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);