ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 8069 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277823 | 1277823 | 2021-05-02 | Larimer | Colorado | 8069 | 25579 | 233 |
1274576 | 1274576 | 2021-05-01 | Larimer | Colorado | 8069 | 25541 | 233 |
1271329 | 1271329 | 2021-04-30 | Larimer | Colorado | 8069 | 25434 | 233 |
1268082 | 1268082 | 2021-04-29 | Larimer | Colorado | 8069 | 25350 | 233 |
1264835 | 1264835 | 2021-04-28 | Larimer | Colorado | 8069 | 25211 | 233 |
1261588 | 1261588 | 2021-04-27 | Larimer | Colorado | 8069 | 25127 | 232 |
1258341 | 1258341 | 2021-04-26 | Larimer | Colorado | 8069 | 24969 | 231 |
1255094 | 1255094 | 2021-04-25 | Larimer | Colorado | 8069 | 24969 | 231 |
1251847 | 1251847 | 2021-04-24 | Larimer | Colorado | 8069 | 24899 | 231 |
1248600 | 1248600 | 2021-04-23 | Larimer | Colorado | 8069 | 24786 | 231 |
1245353 | 1245353 | 2021-04-22 | Larimer | Colorado | 8069 | 24685 | 231 |
1242106 | 1242106 | 2021-04-21 | Larimer | Colorado | 8069 | 24546 | 231 |
1238859 | 1238859 | 2021-04-20 | Larimer | Colorado | 8069 | 24409 | 231 |
1235612 | 1235612 | 2021-04-19 | Larimer | Colorado | 8069 | 24304 | 231 |
1232365 | 1232365 | 2021-04-18 | Larimer | Colorado | 8069 | 24239 | 231 |
1229116 | 1229116 | 2021-04-17 | Larimer | Colorado | 8069 | 24165 | 231 |
1225868 | 1225868 | 2021-04-16 | Larimer | Colorado | 8069 | 24062 | 231 |
1222621 | 1222621 | 2021-04-15 | Larimer | Colorado | 8069 | 23929 | 231 |
1219373 | 1219373 | 2021-04-14 | Larimer | Colorado | 8069 | 23863 | 231 |
1216125 | 1216125 | 2021-04-13 | Larimer | Colorado | 8069 | 23757 | 231 |
1212878 | 1212878 | 2021-04-12 | Larimer | Colorado | 8069 | 23647 | 230 |
1209630 | 1209630 | 2021-04-11 | Larimer | Colorado | 8069 | 23576 | 230 |
1206381 | 1206381 | 2021-04-10 | Larimer | Colorado | 8069 | 23477 | 230 |
1203133 | 1203133 | 2021-04-09 | Larimer | Colorado | 8069 | 23307 | 230 |
1199885 | 1199885 | 2021-04-08 | Larimer | Colorado | 8069 | 23158 | 230 |
1196636 | 1196636 | 2021-04-07 | Larimer | Colorado | 8069 | 22892 | 229 |
1193388 | 1193388 | 2021-04-06 | Larimer | Colorado | 8069 | 22892 | 229 |
1190138 | 1190138 | 2021-04-05 | Larimer | Colorado | 8069 | 22805 | 229 |
1186891 | 1186891 | 2021-04-04 | Larimer | Colorado | 8069 | 22740 | 229 |
1183644 | 1183644 | 2021-04-03 | Larimer | Colorado | 8069 | 22665 | 229 |
1180397 | 1180397 | 2021-04-02 | Larimer | Colorado | 8069 | 22535 | 229 |
1177150 | 1177150 | 2021-04-01 | Larimer | Colorado | 8069 | 22407 | 228 |
1173903 | 1173903 | 2021-03-31 | Larimer | Colorado | 8069 | 22286 | 227 |
1170656 | 1170656 | 2021-03-30 | Larimer | Colorado | 8069 | 22157 | 227 |
1167408 | 1167408 | 2021-03-29 | Larimer | Colorado | 8069 | 22109 | 227 |
1164160 | 1164160 | 2021-03-28 | Larimer | Colorado | 8069 | 22016 | 227 |
1160912 | 1160912 | 2021-03-27 | Larimer | Colorado | 8069 | 21939 | 227 |
1157664 | 1157664 | 2021-03-26 | Larimer | Colorado | 8069 | 21842 | 227 |
1154417 | 1154417 | 2021-03-25 | Larimer | Colorado | 8069 | 21729 | 226 |
1151170 | 1151170 | 2021-03-24 | Larimer | Colorado | 8069 | 21636 | 226 |
1147923 | 1147923 | 2021-03-23 | Larimer | Colorado | 8069 | 21554 | 226 |
1144676 | 1144676 | 2021-03-22 | Larimer | Colorado | 8069 | 21465 | 226 |
1141429 | 1141429 | 2021-03-21 | Larimer | Colorado | 8069 | 21443 | 226 |
1138183 | 1138183 | 2021-03-20 | Larimer | Colorado | 8069 | 21400 | 227 |
1134937 | 1134937 | 2021-03-19 | Larimer | Colorado | 8069 | 21298 | 227 |
1131690 | 1131690 | 2021-03-18 | Larimer | Colorado | 8069 | 21139 | 227 |
1128442 | 1128442 | 2021-03-17 | Larimer | Colorado | 8069 | 21096 | 227 |
1125196 | 1125196 | 2021-03-16 | Larimer | Colorado | 8069 | 21080 | 227 |
1121950 | 1121950 | 2021-03-15 | Larimer | Colorado | 8069 | 21075 | 227 |
1118703 | 1118703 | 2021-03-14 | Larimer | Colorado | 8069 | 21041 | 227 |
1115456 | 1115456 | 2021-03-13 | Larimer | Colorado | 8069 | 20990 | 227 |
1112210 | 1112210 | 2021-03-12 | Larimer | Colorado | 8069 | 20889 | 227 |
1108964 | 1108964 | 2021-03-11 | Larimer | Colorado | 8069 | 20798 | 227 |
1105718 | 1105718 | 2021-03-10 | Larimer | Colorado | 8069 | 20750 | 227 |
1102472 | 1102472 | 2021-03-09 | Larimer | Colorado | 8069 | 20673 | 225 |
1099226 | 1099226 | 2021-03-08 | Larimer | Colorado | 8069 | 20628 | 224 |
1095978 | 1095978 | 2021-03-07 | Larimer | Colorado | 8069 | 20524 | 224 |
1092732 | 1092732 | 2021-03-06 | Larimer | Colorado | 8069 | 20524 | 224 |
1089486 | 1089486 | 2021-03-05 | Larimer | Colorado | 8069 | 20441 | 225 |
1086241 | 1086241 | 2021-03-04 | Larimer | Colorado | 8069 | 20370 | 224 |
1082995 | 1082995 | 2021-03-03 | Larimer | Colorado | 8069 | 20300 | 224 |
1079749 | 1079749 | 2021-03-02 | Larimer | Colorado | 8069 | 20234 | 222 |
1076504 | 1076504 | 2021-03-01 | Larimer | Colorado | 8069 | 20153 | 222 |
1073258 | 1073258 | 2021-02-28 | Larimer | Colorado | 8069 | 20072 | 222 |
1070012 | 1070012 | 2021-02-27 | Larimer | Colorado | 8069 | 19999 | 222 |
1066767 | 1066767 | 2021-02-26 | Larimer | Colorado | 8069 | 19811 | 222 |
1063522 | 1063522 | 2021-02-25 | Larimer | Colorado | 8069 | 19811 | 222 |
1060277 | 1060277 | 2021-02-24 | Larimer | Colorado | 8069 | 19745 | 222 |
1057031 | 1057031 | 2021-02-23 | Larimer | Colorado | 8069 | 19663 | 221 |
1053785 | 1053785 | 2021-02-22 | Larimer | Colorado | 8069 | 19594 | 219 |
1050538 | 1050538 | 2021-02-21 | Larimer | Colorado | 8069 | 19532 | 219 |
1047291 | 1047291 | 2021-02-20 | Larimer | Colorado | 8069 | 19494 | 218 |
1044046 | 1044046 | 2021-02-19 | Larimer | Colorado | 8069 | 19382 | 218 |
1040801 | 1040801 | 2021-02-18 | Larimer | Colorado | 8069 | 19312 | 217 |
1037556 | 1037556 | 2021-02-17 | Larimer | Colorado | 8069 | 19204 | 215 |
1034311 | 1034311 | 2021-02-16 | Larimer | Colorado | 8069 | 19120 | 214 |
1031065 | 1031065 | 2021-02-15 | Larimer | Colorado | 8069 | 19066 | 214 |
1027818 | 1027818 | 2021-02-14 | Larimer | Colorado | 8069 | 19003 | 214 |
1024573 | 1024573 | 2021-02-13 | Larimer | Colorado | 8069 | 18961 | 213 |
1021328 | 1021328 | 2021-02-12 | Larimer | Colorado | 8069 | 18877 | 212 |
1018083 | 1018083 | 2021-02-11 | Larimer | Colorado | 8069 | 18781 | 212 |
1014838 | 1014838 | 2021-02-10 | Larimer | Colorado | 8069 | 18719 | 209 |
1011593 | 1011593 | 2021-02-09 | Larimer | Colorado | 8069 | 18669 | 208 |
1008347 | 1008347 | 2021-02-08 | Larimer | Colorado | 8069 | 18622 | 208 |
1005101 | 1005101 | 2021-02-07 | Larimer | Colorado | 8069 | 18564 | 208 |
1001855 | 1001855 | 2021-02-06 | Larimer | Colorado | 8069 | 18516 | 208 |
998609 | 998609 | 2021-02-05 | Larimer | Colorado | 8069 | 18443 | 204 |
995363 | 995363 | 2021-02-04 | Larimer | Colorado | 8069 | 18341 | 201 |
992117 | 992117 | 2021-02-03 | Larimer | Colorado | 8069 | 18246 | 199 |
988871 | 988871 | 2021-02-02 | Larimer | Colorado | 8069 | 18160 | 198 |
985624 | 985624 | 2021-02-01 | Larimer | Colorado | 8069 | 18115 | 196 |
982377 | 982377 | 2021-01-31 | Larimer | Colorado | 8069 | 17914 | 192 |
979131 | 979131 | 2021-01-30 | Larimer | Colorado | 8069 | 17914 | 192 |
975886 | 975886 | 2021-01-29 | Larimer | Colorado | 8069 | 17914 | 192 |
972641 | 972641 | 2021-01-28 | Larimer | Colorado | 8069 | 17834 | 189 |
969396 | 969396 | 2021-01-27 | Larimer | Colorado | 8069 | 17743 | 186 |
966152 | 966152 | 2021-01-26 | Larimer | Colorado | 8069 | 17637 | 182 |
962907 | 962907 | 2021-01-25 | Larimer | Colorado | 8069 | 17517 | 182 |
959662 | 959662 | 2021-01-24 | Larimer | Colorado | 8069 | 17517 | 182 |
956416 | 956416 | 2021-01-23 | Larimer | Colorado | 8069 | 17454 | 181 |
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);