ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 38 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1628458 | 1628458 | 2021-08-18 | Hinsdale | Colorado | 8053 | 38 | 0 |
1625211 | 1625211 | 2021-08-17 | Hinsdale | Colorado | 8053 | 38 | 0 |
1621964 | 1621964 | 2021-08-16 | Hinsdale | Colorado | 8053 | 38 | 0 |
855817 | 855817 | 2020-12-23 | Mineral | Colorado | 8079 | 38 | 1 |
852572 | 852572 | 2020-12-22 | Mineral | Colorado | 8079 | 38 | 1 |
849327 | 849327 | 2020-12-21 | Mineral | Colorado | 8079 | 38 | 1 |
846082 | 846082 | 2020-12-20 | Mineral | Colorado | 8079 | 38 | 1 |
842836 | 842836 | 2020-12-19 | Mineral | Colorado | 8079 | 38 | 1 |
839591 | 839591 | 2020-12-18 | Mineral | Colorado | 8079 | 38 | 1 |
836346 | 836346 | 2020-12-17 | Mineral | Colorado | 8079 | 38 | 1 |
833100 | 833100 | 2020-12-16 | Mineral | Colorado | 8079 | 38 | 1 |
813599 | 813599 | 2020-12-10 | Dolores | Colorado | 8033 | 38 | 0 |
807124 | 807124 | 2020-12-08 | Kiowa | Colorado | 8061 | 38 | 0 |
709795 | 709795 | 2020-11-08 | Rio Blanco | Colorado | 8103 | 38 | 0 |
696773 | 696773 | 2020-11-04 | Baca | Colorado | 8009 | 38 | 0 |
693531 | 693531 | 2020-11-03 | Baca | Colorado | 8009 | 38 | 0 |
690312 | 690312 | 2020-11-02 | Huerfano | Colorado | 8055 | 38 | 2 |
687067 | 687067 | 2020-11-01 | Huerfano | Colorado | 8055 | 38 | 2 |
683807 | 683807 | 2020-10-31 | Costilla | Colorado | 8023 | 38 | 1 |
680564 | 680564 | 2020-10-30 | Costilla | Colorado | 8023 | 38 | 1 |
674112 | 674112 | 2020-10-28 | Ouray | Colorado | 8091 | 38 | 2 |
667627 | 667627 | 2020-10-26 | Ouray | Colorado | 8091 | 38 | 2 |
657906 | 657906 | 2020-10-23 | Sedgwick | Colorado | 8115 | 38 | 1 |
654661 | 654661 | 2020-10-22 | Sedgwick | Colorado | 8115 | 38 | 1 |
612438 | 612438 | 2020-10-09 | Conejos | Colorado | 8021 | 38 | 0 |
609196 | 609196 | 2020-10-08 | Conejos | Colorado | 8021 | 38 | 0 |
554132 | 554132 | 2020-09-21 | Moffat | Colorado | 8081 | 38 | 1 |
550893 | 550893 | 2020-09-20 | Moffat | Colorado | 8081 | 38 | 1 |
547654 | 547654 | 2020-09-19 | Moffat | Colorado | 8081 | 38 | 1 |
544416 | 544416 | 2020-09-18 | Moffat | Colorado | 8081 | 38 | 1 |
541180 | 541180 | 2020-09-17 | Moffat | Colorado | 8081 | 38 | 1 |
534707 | 534707 | 2020-09-15 | Moffat | Colorado | 8081 | 38 | 1 |
424808 | 424808 | 2020-08-12 | Archuleta | Colorado | 8007 | 38 | 0 |
373361 | 373361 | 2020-07-27 | Otero | Colorado | 8089 | 38 | 3 |
370149 | 370149 | 2020-07-26 | Otero | Colorado | 8089 | 38 | 3 |
331735 | 331735 | 2020-07-14 | Prowers | Colorado | 8099 | 38 | 0 |
328549 | 328549 | 2020-07-13 | Prowers | Colorado | 8099 | 38 | 0 |
296800 | 296800 | 2020-07-03 | Fremont | Colorado | 8043 | 38 | 0 |
293644 | 293644 | 2020-07-02 | Fremont | Colorado | 8043 | 38 | 0 |
240430 | 240430 | 2020-06-15 | Teller | Colorado | 8119 | 38 | 2 |
237322 | 237322 | 2020-06-14 | Teller | Colorado | 8119 | 38 | 2 |
234190 | 234190 | 2020-06-13 | Lake | Colorado | 8065 | 38 | 0 |
234215 | 234215 | 2020-06-13 | Teller | Colorado | 8119 | 38 | 2 |
231084 | 231084 | 2020-06-12 | Lake | Colorado | 8065 | 38 | 0 |
231109 | 231109 | 2020-06-12 | Teller | Colorado | 8119 | 38 | 2 |
227981 | 227981 | 2020-06-11 | Lake | Colorado | 8065 | 38 | 0 |
224879 | 224879 | 2020-06-10 | Lake | Colorado | 8065 | 38 | 0 |
221784 | 221784 | 2020-06-09 | Lake | Colorado | 8065 | 38 | 0 |
218689 | 218689 | 2020-06-08 | Lake | Colorado | 8065 | 38 | 0 |
206364 | 206364 | 2020-06-04 | Rio Grande | Colorado | 8105 | 38 | 0 |
145437 | 145437 | 2020-05-15 | Alamosa | Colorado | 8003 | 38 | 2 |
89928 | 89928 | 2020-04-26 | Mesa | Colorado | 8077 | 38 | 0 |
87111 | 87111 | 2020-04-25 | Mesa | Colorado | 8077 | 38 | 0 |
75899 | 75899 | 2020-04-21 | Chaffee | Colorado | 8015 | 38 | 4 |
73123 | 73123 | 2020-04-20 | Chaffee | Colorado | 8015 | 38 | 4 |
70354 | 70354 | 2020-04-19 | Chaffee | Colorado | 8015 | 38 | 4 |
46051 | 46051 | 2020-04-10 | Montrose | Colorado | 8085 | 38 | 3 |
43451 | 43451 | 2020-04-09 | Montrose | Colorado | 8085 | 38 | 3 |
33406 | 33406 | 2020-04-05 | Pitkin | Colorado | 8097 | 38 | 2 |
31000 | 31000 | 2020-04-04 | Pitkin | Colorado | 8097 | 38 | 2 |
28642 | 28642 | 2020-04-03 | Pitkin | Colorado | 8097 | 38 | 2 |
10978 | 10978 | 2020-03-25 | Adams | Colorado | 8001 | 38 | 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);