ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 8097 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277837 | 1277837 | 2021-05-02 | Pitkin | Colorado | 8097 | 2579 | 4 |
1274590 | 1274590 | 2021-05-01 | Pitkin | Colorado | 8097 | 2579 | 4 |
1271343 | 1271343 | 2021-04-30 | Pitkin | Colorado | 8097 | 2579 | 4 |
1268096 | 1268096 | 2021-04-29 | Pitkin | Colorado | 8097 | 2579 | 4 |
1264849 | 1264849 | 2021-04-28 | Pitkin | Colorado | 8097 | 2579 | 4 |
1261602 | 1261602 | 2021-04-27 | Pitkin | Colorado | 8097 | 2580 | 4 |
1258355 | 1258355 | 2021-04-26 | Pitkin | Colorado | 8097 | 2575 | 4 |
1255108 | 1255108 | 2021-04-25 | Pitkin | Colorado | 8097 | 2575 | 4 |
1251861 | 1251861 | 2021-04-24 | Pitkin | Colorado | 8097 | 2571 | 4 |
1248614 | 1248614 | 2021-04-23 | Pitkin | Colorado | 8097 | 2570 | 4 |
1245367 | 1245367 | 2021-04-22 | Pitkin | Colorado | 8097 | 2561 | 4 |
1242120 | 1242120 | 2021-04-21 | Pitkin | Colorado | 8097 | 2561 | 4 |
1238873 | 1238873 | 2021-04-20 | Pitkin | Colorado | 8097 | 2559 | 4 |
1235626 | 1235626 | 2021-04-19 | Pitkin | Colorado | 8097 | 2558 | 4 |
1232379 | 1232379 | 2021-04-18 | Pitkin | Colorado | 8097 | 2558 | 4 |
1229130 | 1229130 | 2021-04-17 | Pitkin | Colorado | 8097 | 2558 | 4 |
1225882 | 1225882 | 2021-04-16 | Pitkin | Colorado | 8097 | 2557 | 4 |
1222635 | 1222635 | 2021-04-15 | Pitkin | Colorado | 8097 | 2551 | 4 |
1219387 | 1219387 | 2021-04-14 | Pitkin | Colorado | 8097 | 2548 | 4 |
1216139 | 1216139 | 2021-04-13 | Pitkin | Colorado | 8097 | 2544 | 4 |
1212892 | 1212892 | 2021-04-12 | Pitkin | Colorado | 8097 | 2538 | 4 |
1209644 | 1209644 | 2021-04-11 | Pitkin | Colorado | 8097 | 2535 | 4 |
1206395 | 1206395 | 2021-04-10 | Pitkin | Colorado | 8097 | 2525 | 4 |
1203147 | 1203147 | 2021-04-09 | Pitkin | Colorado | 8097 | 2525 | 4 |
1199899 | 1199899 | 2021-04-08 | Pitkin | Colorado | 8097 | 2499 | 4 |
1196650 | 1196650 | 2021-04-07 | Pitkin | Colorado | 8097 | 2493 | 4 |
1193402 | 1193402 | 2021-04-06 | Pitkin | Colorado | 8097 | 2493 | 4 |
1190152 | 1190152 | 2021-04-05 | Pitkin | Colorado | 8097 | 2488 | 4 |
1186905 | 1186905 | 2021-04-04 | Pitkin | Colorado | 8097 | 2481 | 4 |
1183658 | 1183658 | 2021-04-03 | Pitkin | Colorado | 8097 | 2474 | 4 |
1180411 | 1180411 | 2021-04-02 | Pitkin | Colorado | 8097 | 2465 | 4 |
1177164 | 1177164 | 2021-04-01 | Pitkin | Colorado | 8097 | 2456 | 4 |
1173917 | 1173917 | 2021-03-31 | Pitkin | Colorado | 8097 | 2432 | 4 |
1170670 | 1170670 | 2021-03-30 | Pitkin | Colorado | 8097 | 2414 | 4 |
1167422 | 1167422 | 2021-03-29 | Pitkin | Colorado | 8097 | 2399 | 4 |
1164174 | 1164174 | 2021-03-28 | Pitkin | Colorado | 8097 | 2394 | 4 |
1160926 | 1160926 | 2021-03-27 | Pitkin | Colorado | 8097 | 2385 | 4 |
1157678 | 1157678 | 2021-03-26 | Pitkin | Colorado | 8097 | 2370 | 4 |
1154431 | 1154431 | 2021-03-25 | Pitkin | Colorado | 8097 | 2324 | 4 |
1151184 | 1151184 | 2021-03-24 | Pitkin | Colorado | 8097 | 2310 | 4 |
1147937 | 1147937 | 2021-03-23 | Pitkin | Colorado | 8097 | 2298 | 4 |
1144690 | 1144690 | 2021-03-22 | Pitkin | Colorado | 8097 | 2277 | 4 |
1141443 | 1141443 | 2021-03-21 | Pitkin | Colorado | 8097 | 2275 | 4 |
1138197 | 1138197 | 2021-03-20 | Pitkin | Colorado | 8097 | 2259 | 4 |
1134951 | 1134951 | 2021-03-19 | Pitkin | Colorado | 8097 | 2242 | 4 |
1131704 | 1131704 | 2021-03-18 | Pitkin | Colorado | 8097 | 2230 | 4 |
1128456 | 1128456 | 2021-03-17 | Pitkin | Colorado | 8097 | 2213 | 4 |
1125210 | 1125210 | 2021-03-16 | Pitkin | Colorado | 8097 | 2202 | 4 |
1121964 | 1121964 | 2021-03-15 | Pitkin | Colorado | 8097 | 2179 | 4 |
1118717 | 1118717 | 2021-03-14 | Pitkin | Colorado | 8097 | 2165 | 4 |
1115470 | 1115470 | 2021-03-13 | Pitkin | Colorado | 8097 | 2152 | 4 |
1112224 | 1112224 | 2021-03-12 | Pitkin | Colorado | 8097 | 2138 | 4 |
1108978 | 1108978 | 2021-03-11 | Pitkin | Colorado | 8097 | 2123 | 4 |
1105732 | 1105732 | 2021-03-10 | Pitkin | Colorado | 8097 | 2107 | 4 |
1102486 | 1102486 | 2021-03-09 | Pitkin | Colorado | 8097 | 2097 | 4 |
1099240 | 1099240 | 2021-03-08 | Pitkin | Colorado | 8097 | 2091 | 4 |
1095992 | 1095992 | 2021-03-07 | Pitkin | Colorado | 8097 | 2084 | 4 |
1092746 | 1092746 | 2021-03-06 | Pitkin | Colorado | 8097 | 2084 | 4 |
1089500 | 1089500 | 2021-03-05 | Pitkin | Colorado | 8097 | 2071 | 4 |
1086255 | 1086255 | 2021-03-04 | Pitkin | Colorado | 8097 | 2059 | 4 |
1083009 | 1083009 | 2021-03-03 | Pitkin | Colorado | 8097 | 2034 | 4 |
1079763 | 1079763 | 2021-03-02 | Pitkin | Colorado | 8097 | 2031 | 4 |
1076518 | 1076518 | 2021-03-01 | Pitkin | Colorado | 8097 | 2018 | 4 |
1073272 | 1073272 | 2021-02-28 | Pitkin | Colorado | 8097 | 2010 | 4 |
1070026 | 1070026 | 2021-02-27 | Pitkin | Colorado | 8097 | 1997 | 4 |
1066781 | 1066781 | 2021-02-26 | Pitkin | Colorado | 8097 | 1962 | 4 |
1063536 | 1063536 | 2021-02-25 | Pitkin | Colorado | 8097 | 1962 | 4 |
1060291 | 1060291 | 2021-02-24 | Pitkin | Colorado | 8097 | 1957 | 4 |
1057045 | 1057045 | 2021-02-23 | Pitkin | Colorado | 8097 | 1951 | 4 |
1053799 | 1053799 | 2021-02-22 | Pitkin | Colorado | 8097 | 1947 | 4 |
1050552 | 1050552 | 2021-02-21 | Pitkin | Colorado | 8097 | 1941 | 4 |
1047305 | 1047305 | 2021-02-20 | Pitkin | Colorado | 8097 | 1939 | 4 |
1044060 | 1044060 | 2021-02-19 | Pitkin | Colorado | 8097 | 1932 | 4 |
1040815 | 1040815 | 2021-02-18 | Pitkin | Colorado | 8097 | 1923 | 4 |
1037570 | 1037570 | 2021-02-17 | Pitkin | Colorado | 8097 | 1920 | 4 |
1034325 | 1034325 | 2021-02-16 | Pitkin | Colorado | 8097 | 1919 | 4 |
1031079 | 1031079 | 2021-02-15 | Pitkin | Colorado | 8097 | 1914 | 4 |
1027832 | 1027832 | 2021-02-14 | Pitkin | Colorado | 8097 | 1907 | 4 |
1024587 | 1024587 | 2021-02-13 | Pitkin | Colorado | 8097 | 1905 | 4 |
1021342 | 1021342 | 2021-02-12 | Pitkin | Colorado | 8097 | 1904 | 4 |
1018097 | 1018097 | 2021-02-11 | Pitkin | Colorado | 8097 | 1895 | 4 |
1014852 | 1014852 | 2021-02-10 | Pitkin | Colorado | 8097 | 1886 | 4 |
1011607 | 1011607 | 2021-02-09 | Pitkin | Colorado | 8097 | 1883 | 4 |
1008361 | 1008361 | 2021-02-08 | Pitkin | Colorado | 8097 | 1881 | 4 |
1005115 | 1005115 | 2021-02-07 | Pitkin | Colorado | 8097 | 1879 | 4 |
1001869 | 1001869 | 2021-02-06 | Pitkin | Colorado | 8097 | 1875 | 4 |
998623 | 998623 | 2021-02-05 | Pitkin | Colorado | 8097 | 1865 | 4 |
995377 | 995377 | 2021-02-04 | Pitkin | Colorado | 8097 | 1855 | 4 |
992131 | 992131 | 2021-02-03 | Pitkin | Colorado | 8097 | 1846 | 4 |
988885 | 988885 | 2021-02-02 | Pitkin | Colorado | 8097 | 1845 | 4 |
985638 | 985638 | 2021-02-01 | Pitkin | Colorado | 8097 | 1834 | 4 |
982391 | 982391 | 2021-01-31 | Pitkin | Colorado | 8097 | 1818 | 4 |
979145 | 979145 | 2021-01-30 | Pitkin | Colorado | 8097 | 1818 | 4 |
975900 | 975900 | 2021-01-29 | Pitkin | Colorado | 8097 | 1818 | 4 |
972655 | 972655 | 2021-01-28 | Pitkin | Colorado | 8097 | 1812 | 4 |
969410 | 969410 | 2021-01-27 | Pitkin | Colorado | 8097 | 1809 | 4 |
966166 | 966166 | 2021-01-26 | Pitkin | Colorado | 8097 | 1795 | 4 |
962921 | 962921 | 2021-01-25 | Pitkin | Colorado | 8097 | 1761 | 4 |
959676 | 959676 | 2021-01-24 | Pitkin | Colorado | 8097 | 1761 | 4 |
956430 | 956430 | 2021-01-23 | Pitkin | Colorado | 8097 | 1755 | 4 |
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);