ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8053 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277815 | 1277815 | 2021-05-02 | Hinsdale | Colorado | 8053 | 17 | 0 |
1274568 | 1274568 | 2021-05-01 | Hinsdale | Colorado | 8053 | 18 | 0 |
1271321 | 1271321 | 2021-04-30 | Hinsdale | Colorado | 8053 | 17 | 0 |
1268074 | 1268074 | 2021-04-29 | Hinsdale | Colorado | 8053 | 18 | 0 |
1264827 | 1264827 | 2021-04-28 | Hinsdale | Colorado | 8053 | 18 | 0 |
1261580 | 1261580 | 2021-04-27 | Hinsdale | Colorado | 8053 | 19 | 0 |
1258333 | 1258333 | 2021-04-26 | Hinsdale | Colorado | 8053 | 18 | 0 |
1255086 | 1255086 | 2021-04-25 | Hinsdale | Colorado | 8053 | 18 | 0 |
1251839 | 1251839 | 2021-04-24 | Hinsdale | Colorado | 8053 | 19 | 0 |
1248592 | 1248592 | 2021-04-23 | Hinsdale | Colorado | 8053 | 17 | 0 |
1245345 | 1245345 | 2021-04-22 | Hinsdale | Colorado | 8053 | 17 | 0 |
1242098 | 1242098 | 2021-04-21 | Hinsdale | Colorado | 8053 | 17 | 0 |
1238851 | 1238851 | 2021-04-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1235604 | 1235604 | 2021-04-19 | Hinsdale | Colorado | 8053 | 17 | 0 |
1232357 | 1232357 | 2021-04-18 | Hinsdale | Colorado | 8053 | 18 | 0 |
1229108 | 1229108 | 2021-04-17 | Hinsdale | Colorado | 8053 | 17 | 0 |
1225860 | 1225860 | 2021-04-16 | Hinsdale | Colorado | 8053 | 17 | 0 |
1222613 | 1222613 | 2021-04-15 | Hinsdale | Colorado | 8053 | 17 | 0 |
1219365 | 1219365 | 2021-04-14 | Hinsdale | Colorado | 8053 | 18 | 0 |
1216117 | 1216117 | 2021-04-13 | Hinsdale | Colorado | 8053 | 17 | 0 |
1212870 | 1212870 | 2021-04-12 | Hinsdale | Colorado | 8053 | 18 | 0 |
1209622 | 1209622 | 2021-04-11 | Hinsdale | Colorado | 8053 | 17 | 0 |
1206373 | 1206373 | 2021-04-10 | Hinsdale | Colorado | 8053 | 17 | 0 |
1203125 | 1203125 | 2021-04-09 | Hinsdale | Colorado | 8053 | 17 | 0 |
1199877 | 1199877 | 2021-04-08 | Hinsdale | Colorado | 8053 | 18 | 0 |
1196628 | 1196628 | 2021-04-07 | Hinsdale | Colorado | 8053 | 17 | 0 |
1193380 | 1193380 | 2021-04-06 | Hinsdale | Colorado | 8053 | 17 | 0 |
1190130 | 1190130 | 2021-04-05 | Hinsdale | Colorado | 8053 | 18 | 0 |
1186883 | 1186883 | 2021-04-04 | Hinsdale | Colorado | 8053 | 17 | 0 |
1183636 | 1183636 | 2021-04-03 | Hinsdale | Colorado | 8053 | 18 | 0 |
1180389 | 1180389 | 2021-04-02 | Hinsdale | Colorado | 8053 | 16 | 0 |
1177142 | 1177142 | 2021-04-01 | Hinsdale | Colorado | 8053 | 16 | 0 |
1173895 | 1173895 | 2021-03-31 | Hinsdale | Colorado | 8053 | 17 | 0 |
1170648 | 1170648 | 2021-03-30 | Hinsdale | Colorado | 8053 | 16 | 0 |
1167400 | 1167400 | 2021-03-29 | Hinsdale | Colorado | 8053 | 17 | 0 |
1164152 | 1164152 | 2021-03-28 | Hinsdale | Colorado | 8053 | 16 | 0 |
1160904 | 1160904 | 2021-03-27 | Hinsdale | Colorado | 8053 | 17 | 0 |
1157656 | 1157656 | 2021-03-26 | Hinsdale | Colorado | 8053 | 17 | 0 |
1154409 | 1154409 | 2021-03-25 | Hinsdale | Colorado | 8053 | 17 | 0 |
1151162 | 1151162 | 2021-03-24 | Hinsdale | Colorado | 8053 | 17 | 0 |
1147915 | 1147915 | 2021-03-23 | Hinsdale | Colorado | 8053 | 17 | 0 |
1144668 | 1144668 | 2021-03-22 | Hinsdale | Colorado | 8053 | 16 | 0 |
1141421 | 1141421 | 2021-03-21 | Hinsdale | Colorado | 8053 | 17 | 0 |
1138175 | 1138175 | 2021-03-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1134929 | 1134929 | 2021-03-19 | Hinsdale | Colorado | 8053 | 17 | 0 |
1131682 | 1131682 | 2021-03-18 | Hinsdale | Colorado | 8053 | 16 | 0 |
1128434 | 1128434 | 2021-03-17 | Hinsdale | Colorado | 8053 | 16 | 0 |
1125188 | 1125188 | 2021-03-16 | Hinsdale | Colorado | 8053 | 16 | 0 |
1121942 | 1121942 | 2021-03-15 | Hinsdale | Colorado | 8053 | 16 | 0 |
1118695 | 1118695 | 2021-03-14 | Hinsdale | Colorado | 8053 | 17 | 0 |
1115448 | 1115448 | 2021-03-13 | Hinsdale | Colorado | 8053 | 17 | 0 |
1112202 | 1112202 | 2021-03-12 | Hinsdale | Colorado | 8053 | 17 | 0 |
1108956 | 1108956 | 2021-03-11 | Hinsdale | Colorado | 8053 | 16 | 0 |
1105710 | 1105710 | 2021-03-10 | Hinsdale | Colorado | 8053 | 16 | 0 |
1102464 | 1102464 | 2021-03-09 | Hinsdale | Colorado | 8053 | 16 | 0 |
1099218 | 1099218 | 2021-03-08 | Hinsdale | Colorado | 8053 | 17 | 0 |
1095970 | 1095970 | 2021-03-07 | Hinsdale | Colorado | 8053 | 16 | 0 |
1092724 | 1092724 | 2021-03-06 | Hinsdale | Colorado | 8053 | 16 | 0 |
1089478 | 1089478 | 2021-03-05 | Hinsdale | Colorado | 8053 | 16 | 0 |
1086233 | 1086233 | 2021-03-04 | Hinsdale | Colorado | 8053 | 16 | 0 |
1082987 | 1082987 | 2021-03-03 | Hinsdale | Colorado | 8053 | 17 | 0 |
1079741 | 1079741 | 2021-03-02 | Hinsdale | Colorado | 8053 | 16 | 0 |
1076496 | 1076496 | 2021-03-01 | Hinsdale | Colorado | 8053 | 17 | 0 |
1073250 | 1073250 | 2021-02-28 | Hinsdale | Colorado | 8053 | 17 | 0 |
1070004 | 1070004 | 2021-02-27 | Hinsdale | Colorado | 8053 | 17 | 0 |
1066759 | 1066759 | 2021-02-26 | Hinsdale | Colorado | 8053 | 17 | 0 |
1063514 | 1063514 | 2021-02-25 | Hinsdale | Colorado | 8053 | 17 | 0 |
1060269 | 1060269 | 2021-02-24 | Hinsdale | Colorado | 8053 | 17 | 0 |
1057023 | 1057023 | 2021-02-23 | Hinsdale | Colorado | 8053 | 16 | 0 |
1053777 | 1053777 | 2021-02-22 | Hinsdale | Colorado | 8053 | 16 | 0 |
1050530 | 1050530 | 2021-02-21 | Hinsdale | Colorado | 8053 | 16 | 0 |
1047283 | 1047283 | 2021-02-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1044038 | 1044038 | 2021-02-19 | Hinsdale | Colorado | 8053 | 17 | 0 |
1040793 | 1040793 | 2021-02-18 | Hinsdale | Colorado | 8053 | 17 | 0 |
1037548 | 1037548 | 2021-02-17 | Hinsdale | Colorado | 8053 | 16 | 0 |
1034303 | 1034303 | 2021-02-16 | Hinsdale | Colorado | 8053 | 16 | 0 |
1031057 | 1031057 | 2021-02-15 | Hinsdale | Colorado | 8053 | 17 | 0 |
1027810 | 1027810 | 2021-02-14 | Hinsdale | Colorado | 8053 | 16 | 0 |
1024565 | 1024565 | 2021-02-13 | Hinsdale | Colorado | 8053 | 16 | 0 |
1021320 | 1021320 | 2021-02-12 | Hinsdale | Colorado | 8053 | 16 | 0 |
1018075 | 1018075 | 2021-02-11 | Hinsdale | Colorado | 8053 | 16 | 0 |
1014830 | 1014830 | 2021-02-10 | Hinsdale | Colorado | 8053 | 17 | 0 |
1011585 | 1011585 | 2021-02-09 | Hinsdale | Colorado | 8053 | 16 | 0 |
1008339 | 1008339 | 2021-02-08 | Hinsdale | Colorado | 8053 | 15 | 0 |
1005093 | 1005093 | 2021-02-07 | Hinsdale | Colorado | 8053 | 16 | 0 |
1001847 | 1001847 | 2021-02-06 | Hinsdale | Colorado | 8053 | 15 | 0 |
998601 | 998601 | 2021-02-05 | Hinsdale | Colorado | 8053 | 15 | 0 |
995355 | 995355 | 2021-02-04 | Hinsdale | Colorado | 8053 | 16 | 0 |
992109 | 992109 | 2021-02-03 | Hinsdale | Colorado | 8053 | 15 | 0 |
988863 | 988863 | 2021-02-02 | Hinsdale | Colorado | 8053 | 16 | 0 |
985616 | 985616 | 2021-02-01 | Hinsdale | Colorado | 8053 | 15 | 0 |
982369 | 982369 | 2021-01-31 | Hinsdale | Colorado | 8053 | 16 | 0 |
979123 | 979123 | 2021-01-30 | Hinsdale | Colorado | 8053 | 16 | 0 |
975878 | 975878 | 2021-01-29 | Hinsdale | Colorado | 8053 | 16 | 0 |
972633 | 972633 | 2021-01-28 | Hinsdale | Colorado | 8053 | 15 | 0 |
969388 | 969388 | 2021-01-27 | Hinsdale | Colorado | 8053 | 16 | 0 |
966144 | 966144 | 2021-01-26 | Hinsdale | Colorado | 8053 | 15 | 0 |
962899 | 962899 | 2021-01-25 | Hinsdale | Colorado | 8053 | 15 | 0 |
959654 | 959654 | 2021-01-24 | Hinsdale | Colorado | 8053 | 15 | 0 |
956408 | 956408 | 2021-01-23 | Hinsdale | Colorado | 8053 | 16 | 0 |
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);