ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where deaths = 74 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418447 | 2418447 | 2022-04-18 | Montezuma | Colorado | 8083 | 6182 | 74 |
2415191 | 2415191 | 2022-04-17 | Montezuma | Colorado | 8083 | 6182 | 74 |
2411935 | 2411935 | 2022-04-16 | Montezuma | Colorado | 8083 | 6182 | 74 |
2408679 | 2408679 | 2022-04-15 | Montezuma | Colorado | 8083 | 6182 | 74 |
2405423 | 2405423 | 2022-04-14 | Montezuma | Colorado | 8083 | 6182 | 74 |
2402168 | 2402168 | 2022-04-13 | Montezuma | Colorado | 8083 | 6178 | 74 |
2148443 | 2148443 | 2022-01-25 | La Plata | Colorado | 8067 | 11165 | 74 |
2145191 | 2145191 | 2022-01-24 | La Plata | Colorado | 8067 | 11076 | 74 |
1985870 | 1985870 | 2021-12-06 | Garfield | Colorado | 8045 | 8940 | 74 |
1768159 | 1768159 | 2021-09-30 | Logan | Colorado | 8075 | 4409 | 74 |
1768166 | 1768166 | 2021-09-30 | Otero | Colorado | 8089 | 2349 | 74 |
1764910 | 1764910 | 2021-09-29 | Logan | Colorado | 8075 | 4405 | 74 |
1764917 | 1764917 | 2021-09-29 | Otero | Colorado | 8089 | 2341 | 74 |
1761668 | 1761668 | 2021-09-28 | Otero | Colorado | 8089 | 2336 | 74 |
1696693 | 1696693 | 2021-09-08 | Montrose | Colorado | 8085 | 4369 | 74 |
1693445 | 1693445 | 2021-09-07 | Montrose | Colorado | 8085 | 4358 | 74 |
1690196 | 1690196 | 2021-09-06 | Montrose | Colorado | 8085 | 4341 | 74 |
1686946 | 1686946 | 2021-09-05 | Montrose | Colorado | 8085 | 4323 | 74 |
1683696 | 1683696 | 2021-09-04 | Montrose | Colorado | 8085 | 4323 | 74 |
1680445 | 1680445 | 2021-09-03 | Montrose | Colorado | 8085 | 4323 | 74 |
1677197 | 1677197 | 2021-09-02 | Montrose | Colorado | 8085 | 4296 | 74 |
1673950 | 1673950 | 2021-09-01 | Montrose | Colorado | 8085 | 4281 | 74 |
1670702 | 1670702 | 2021-08-31 | Montrose | Colorado | 8085 | 4273 | 74 |
1664208 | 1664208 | 2021-08-29 | Montrose | Colorado | 8085 | 4254 | 74 |
1660960 | 1660960 | 2021-08-28 | Montrose | Colorado | 8085 | 4254 | 74 |
1657712 | 1657712 | 2021-08-27 | Montrose | Colorado | 8085 | 4254 | 74 |
1602462 | 1602462 | 2021-08-10 | Delta | Colorado | 8029 | 3159 | 74 |
1203105 | 1203105 | 2021-04-09 | Broomfield | Colorado | 8014 | 4328 | 74 |
1199857 | 1199857 | 2021-04-08 | Broomfield | Colorado | 8014 | 4312 | 74 |
1196608 | 1196608 | 2021-04-07 | Broomfield | Colorado | 8014 | 4275 | 74 |
1193360 | 1193360 | 2021-04-06 | Broomfield | Colorado | 8014 | 4275 | 74 |
1190110 | 1190110 | 2021-04-05 | Broomfield | Colorado | 8014 | 4258 | 74 |
1186863 | 1186863 | 2021-04-04 | Broomfield | Colorado | 8014 | 4246 | 74 |
1183616 | 1183616 | 2021-04-03 | Broomfield | Colorado | 8014 | 4231 | 74 |
1180369 | 1180369 | 2021-04-02 | Broomfield | Colorado | 8014 | 4215 | 74 |
1177122 | 1177122 | 2021-04-01 | Broomfield | Colorado | 8014 | 4203 | 74 |
1173875 | 1173875 | 2021-03-31 | Broomfield | Colorado | 8014 | 4187 | 74 |
1170628 | 1170628 | 2021-03-30 | Broomfield | Colorado | 8014 | 4173 | 74 |
1167380 | 1167380 | 2021-03-29 | Broomfield | Colorado | 8014 | 4161 | 74 |
1164132 | 1164132 | 2021-03-28 | Broomfield | Colorado | 8014 | 4152 | 74 |
1160884 | 1160884 | 2021-03-27 | Broomfield | Colorado | 8014 | 4144 | 74 |
1157636 | 1157636 | 2021-03-26 | Broomfield | Colorado | 8014 | 4124 | 74 |
1154389 | 1154389 | 2021-03-25 | Broomfield | Colorado | 8014 | 4111 | 74 |
1151142 | 1151142 | 2021-03-24 | Broomfield | Colorado | 8014 | 4095 | 74 |
1147895 | 1147895 | 2021-03-23 | Broomfield | Colorado | 8014 | 4082 | 74 |
1144648 | 1144648 | 2021-03-22 | Broomfield | Colorado | 8014 | 4069 | 74 |
1141401 | 1141401 | 2021-03-21 | Broomfield | Colorado | 8014 | 4064 | 74 |
1138155 | 1138155 | 2021-03-20 | Broomfield | Colorado | 8014 | 4052 | 74 |
1134909 | 1134909 | 2021-03-19 | Broomfield | Colorado | 8014 | 4036 | 74 |
1131662 | 1131662 | 2021-03-18 | Broomfield | Colorado | 8014 | 4017 | 74 |
1128414 | 1128414 | 2021-03-17 | Broomfield | Colorado | 8014 | 3986 | 74 |
1125168 | 1125168 | 2021-03-16 | Broomfield | Colorado | 8014 | 3981 | 74 |
1121922 | 1121922 | 2021-03-15 | Broomfield | Colorado | 8014 | 3982 | 74 |
1118675 | 1118675 | 2021-03-14 | Broomfield | Colorado | 8014 | 3978 | 74 |
1115428 | 1115428 | 2021-03-13 | Broomfield | Colorado | 8014 | 3960 | 74 |
1112182 | 1112182 | 2021-03-12 | Broomfield | Colorado | 8014 | 3941 | 74 |
1108936 | 1108936 | 2021-03-11 | Broomfield | Colorado | 8014 | 3921 | 74 |
1105690 | 1105690 | 2021-03-10 | Broomfield | Colorado | 8014 | 3910 | 74 |
1102444 | 1102444 | 2021-03-09 | Broomfield | Colorado | 8014 | 3903 | 74 |
1099198 | 1099198 | 2021-03-08 | Broomfield | Colorado | 8014 | 3879 | 74 |
1095950 | 1095950 | 2021-03-07 | Broomfield | Colorado | 8014 | 3852 | 74 |
1092704 | 1092704 | 2021-03-06 | Broomfield | Colorado | 8014 | 3852 | 74 |
1089458 | 1089458 | 2021-03-05 | Broomfield | Colorado | 8014 | 3839 | 74 |
1086213 | 1086213 | 2021-03-04 | Broomfield | Colorado | 8014 | 3811 | 74 |
1082967 | 1082967 | 2021-03-03 | Broomfield | Colorado | 8014 | 3789 | 74 |
1079721 | 1079721 | 2021-03-02 | Broomfield | Colorado | 8014 | 3772 | 74 |
1076476 | 1076476 | 2021-03-01 | Broomfield | Colorado | 8014 | 3759 | 74 |
1073230 | 1073230 | 2021-02-28 | Broomfield | Colorado | 8014 | 3737 | 74 |
1069984 | 1069984 | 2021-02-27 | Broomfield | Colorado | 8014 | 3721 | 74 |
1066739 | 1066739 | 2021-02-26 | Broomfield | Colorado | 8014 | 3693 | 74 |
1063494 | 1063494 | 2021-02-25 | Broomfield | Colorado | 8014 | 3693 | 74 |
1060249 | 1060249 | 2021-02-24 | Broomfield | Colorado | 8014 | 3682 | 74 |
1057003 | 1057003 | 2021-02-23 | Broomfield | Colorado | 8014 | 3669 | 74 |
1053757 | 1053757 | 2021-02-22 | Broomfield | Colorado | 8014 | 3665 | 74 |
1050510 | 1050510 | 2021-02-21 | Broomfield | Colorado | 8014 | 3654 | 74 |
1047263 | 1047263 | 2021-02-20 | Broomfield | Colorado | 8014 | 3646 | 74 |
1044018 | 1044018 | 2021-02-19 | Broomfield | Colorado | 8014 | 3636 | 74 |
872046 | 872046 | 2020-12-28 | Morgan | Colorado | 8087 | 2094 | 74 |
868801 | 868801 | 2020-12-27 | Morgan | Colorado | 8087 | 2092 | 74 |
865556 | 865556 | 2020-12-26 | Morgan | Colorado | 8087 | 2085 | 74 |
774678 | 774678 | 2020-11-28 | Larimer | Colorado | 8069 | 9946 | 74 |
771433 | 771433 | 2020-11-27 | Larimer | Colorado | 8069 | 9726 | 74 |
418369 | 418369 | 2020-08-10 | Boulder | Colorado | 8013 | 2086 | 74 |
415148 | 415148 | 2020-08-09 | Boulder | Colorado | 8013 | 2070 | 74 |
411928 | 411928 | 2020-08-08 | Boulder | Colorado | 8013 | 2054 | 74 |
376537 | 376537 | 2020-07-28 | Boulder | Colorado | 8013 | 1825 | 74 |
373323 | 373323 | 2020-07-27 | Boulder | Colorado | 8013 | 1802 | 74 |
370111 | 370111 | 2020-07-26 | Boulder | Colorado | 8013 | 1787 | 74 |
366901 | 366901 | 2020-07-25 | Boulder | Colorado | 8013 | 1775 | 74 |
363694 | 363694 | 2020-07-24 | Boulder | Colorado | 8013 | 1757 | 74 |
360487 | 360487 | 2020-07-23 | Boulder | Colorado | 8013 | 1716 | 74 |
357282 | 357282 | 2020-07-22 | Boulder | Colorado | 8013 | 1702 | 74 |
354079 | 354079 | 2020-07-21 | Boulder | Colorado | 8013 | 1682 | 74 |
350877 | 350877 | 2020-07-20 | Boulder | Colorado | 8013 | 1669 | 74 |
347676 | 347676 | 2020-07-19 | Boulder | Colorado | 8013 | 1653 | 74 |
344476 | 344476 | 2020-07-18 | Boulder | Colorado | 8013 | 1643 | 74 |
341277 | 341277 | 2020-07-17 | Boulder | Colorado | 8013 | 1638 | 74 |
338081 | 338081 | 2020-07-16 | Boulder | Colorado | 8013 | 1618 | 74 |
334886 | 334886 | 2020-07-15 | Boulder | Colorado | 8013 | 1595 | 74 |
331693 | 331693 | 2020-07-14 | Boulder | Colorado | 8013 | 1572 | 74 |
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);