ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 87 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1768177 | 1768177 | 2021-09-30 | San Juan | Colorado | 8111 | 87 | 1 |
1764928 | 1764928 | 2021-09-29 | San Juan | Colorado | 8111 | 87 | 1 |
1761679 | 1761679 | 2021-09-28 | San Juan | Colorado | 8111 | 87 | 1 |
1758431 | 1758431 | 2021-09-27 | San Juan | Colorado | 8111 | 87 | 1 |
1755183 | 1755183 | 2021-09-26 | San Juan | Colorado | 8111 | 87 | 1 |
1751935 | 1751935 | 2021-09-25 | San Juan | Colorado | 8111 | 87 | 1 |
1748686 | 1748686 | 2021-09-24 | San Juan | Colorado | 8111 | 87 | 1 |
1745436 | 1745436 | 2021-09-23 | San Juan | Colorado | 8111 | 87 | 1 |
1738938 | 1738938 | 2021-09-21 | San Juan | Colorado | 8111 | 87 | 1 |
1735689 | 1735689 | 2021-09-20 | San Juan | Colorado | 8111 | 87 | 1 |
1732439 | 1732439 | 2021-09-19 | San Juan | Colorado | 8111 | 87 | 1 |
1729189 | 1729189 | 2021-09-18 | San Juan | Colorado | 8111 | 87 | 1 |
1725939 | 1725939 | 2021-09-17 | San Juan | Colorado | 8111 | 87 | 1 |
1722690 | 1722690 | 2021-09-16 | San Juan | Colorado | 8111 | 87 | 1 |
1699955 | 1699955 | 2021-09-09 | San Juan | Colorado | 8111 | 87 | 0 |
1696706 | 1696706 | 2021-09-08 | San Juan | Colorado | 8111 | 87 | 0 |
1693458 | 1693458 | 2021-09-07 | San Juan | Colorado | 8111 | 87 | 0 |
1690209 | 1690209 | 2021-09-06 | San Juan | Colorado | 8111 | 87 | 0 |
1686959 | 1686959 | 2021-09-05 | San Juan | Colorado | 8111 | 87 | 0 |
1683709 | 1683709 | 2021-09-04 | San Juan | Colorado | 8111 | 87 | 0 |
1680458 | 1680458 | 2021-09-03 | San Juan | Colorado | 8111 | 87 | 0 |
1290814 | 1290814 | 2021-05-06 | Mineral | Colorado | 8079 | 87 | 1 |
1287568 | 1287568 | 2021-05-05 | Mineral | Colorado | 8079 | 87 | 1 |
1284322 | 1284322 | 2021-05-04 | Mineral | Colorado | 8079 | 87 | 1 |
1271334 | 1271334 | 2021-04-30 | Mineral | Colorado | 8079 | 87 | 1 |
969392 | 969392 | 2021-01-27 | Kiowa | Colorado | 8061 | 87 | 3 |
872011 | 872011 | 2020-12-28 | Cheyenne | Colorado | 8017 | 87 | 4 |
868766 | 868766 | 2020-12-27 | Cheyenne | Colorado | 8017 | 87 | 4 |
865521 | 865521 | 2020-12-26 | Cheyenne | Colorado | 8017 | 87 | 4 |
787647 | 787647 | 2020-12-02 | Gilpin | Colorado | 8047 | 87 | 1 |
784403 | 784403 | 2020-12-01 | Gilpin | Colorado | 8047 | 87 | 1 |
781158 | 781158 | 2020-11-30 | Gilpin | Colorado | 8047 | 87 | 0 |
777912 | 777912 | 2020-11-29 | Gilpin | Colorado | 8047 | 87 | 0 |
550915 | 550915 | 2020-09-20 | Yuma | Colorado | 8125 | 87 | 0 |
544420 | 544420 | 2020-09-18 | Otero | Colorado | 8089 | 87 | 6 |
537936 | 537936 | 2020-09-16 | Lake | Colorado | 8065 | 87 | 0 |
534700 | 534700 | 2020-09-15 | Lake | Colorado | 8065 | 87 | 0 |
531465 | 531465 | 2020-09-14 | Lake | Colorado | 8065 | 87 | 0 |
528228 | 528228 | 2020-09-13 | Lake | Colorado | 8065 | 87 | 0 |
495901 | 495901 | 2020-09-03 | Prowers | Colorado | 8099 | 87 | 0 |
492667 | 492667 | 2020-09-02 | Prowers | Colorado | 8099 | 87 | 0 |
399101 | 399101 | 2020-08-04 | Rio Grande | Colorado | 8105 | 87 | 2 |
395854 | 395854 | 2020-08-03 | Elbert | Colorado | 8039 | 87 | 2 |
395885 | 395885 | 2020-08-03 | Rio Grande | Colorado | 8105 | 87 | 2 |
392669 | 392669 | 2020-08-02 | Rio Grande | Colorado | 8105 | 87 | 2 |
389452 | 389452 | 2020-08-01 | Rio Grande | Colorado | 8105 | 87 | 2 |
386235 | 386235 | 2020-07-31 | Rio Grande | Colorado | 8105 | 87 | 2 |
383017 | 383017 | 2020-07-30 | Rio Grande | Colorado | 8105 | 87 | 2 |
379800 | 379800 | 2020-07-29 | Rio Grande | Colorado | 8105 | 87 | 2 |
376583 | 376583 | 2020-07-28 | Rio Grande | Colorado | 8105 | 87 | 2 |
373369 | 373369 | 2020-07-27 | Rio Grande | Colorado | 8105 | 87 | 2 |
370157 | 370157 | 2020-07-26 | Rio Grande | Colorado | 8105 | 87 | 2 |
366917 | 366917 | 2020-07-25 | Fremont | Colorado | 8043 | 87 | 0 |
366947 | 366947 | 2020-07-25 | Rio Grande | Colorado | 8105 | 87 | 2 |
357335 | 357335 | 2020-07-22 | Teller | Colorado | 8119 | 87 | 2 |
350924 | 350924 | 2020-07-20 | Routt | Colorado | 8107 | 87 | 6 |
347723 | 347723 | 2020-07-19 | Routt | Colorado | 8107 | 87 | 6 |
344523 | 344523 | 2020-07-18 | Routt | Colorado | 8107 | 87 | 6 |
271628 | 271628 | 2020-06-25 | Mesa | Colorado | 8077 | 87 | 0 |
209396 | 209396 | 2020-06-05 | Alamosa | Colorado | 8003 | 87 | 2 |
89914 | 89914 | 2020-04-26 | Garfield | Colorado | 8045 | 87 | 2 |
87115 | 87115 | 2020-04-25 | Montrose | Colorado | 8085 | 87 | 9 |
70392 | 70392 | 2020-04-19 | Pueblo | Colorado | 8101 | 87 | 7 |
11013 | 11013 | 2020-03-25 | Weld | Colorado | 8123 | 87 | 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);