ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 85 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1758404 | 1758404 | 2021-09-27 | Jackson | Colorado | 8057 | 85 | 0 |
1654477 | 1654477 | 2021-08-26 | San Juan | Colorado | 8111 | 85 | 0 |
1651230 | 1651230 | 2021-08-25 | San Juan | Colorado | 8111 | 85 | 0 |
1647981 | 1647981 | 2021-08-24 | San Juan | Colorado | 8111 | 85 | 0 |
1644733 | 1644733 | 2021-08-23 | San Juan | Colorado | 8111 | 85 | 0 |
1307023 | 1307023 | 2021-05-11 | Dolores | Colorado | 8033 | 85 | 0 |
1151175 | 1151175 | 2021-03-24 | Mineral | Colorado | 8079 | 85 | 1 |
1147928 | 1147928 | 2021-03-23 | Mineral | Colorado | 8079 | 85 | 1 |
1144681 | 1144681 | 2021-03-22 | Mineral | Colorado | 8079 | 85 | 1 |
1141434 | 1141434 | 2021-03-21 | Mineral | Colorado | 8079 | 85 | 1 |
1138188 | 1138188 | 2021-03-20 | Mineral | Colorado | 8079 | 85 | 1 |
1112215 | 1112215 | 2021-03-12 | Mineral | Colorado | 8079 | 85 | 1 |
966148 | 966148 | 2021-01-26 | Kiowa | Colorado | 8061 | 85 | 3 |
962903 | 962903 | 2021-01-25 | Kiowa | Colorado | 8061 | 85 | 3 |
959658 | 959658 | 2021-01-24 | Kiowa | Colorado | 8061 | 85 | 3 |
956412 | 956412 | 2021-01-23 | Kiowa | Colorado | 8061 | 85 | 3 |
953167 | 953167 | 2021-01-22 | Kiowa | Colorado | 8061 | 85 | 2 |
836315 | 836315 | 2020-12-17 | Cheyenne | Colorado | 8017 | 85 | 3 |
833069 | 833069 | 2020-12-16 | Cheyenne | Colorado | 8017 | 85 | 3 |
829822 | 829822 | 2020-12-15 | Cheyenne | Colorado | 8017 | 85 | 3 |
826576 | 826576 | 2020-12-14 | Cheyenne | Colorado | 8017 | 85 | 3 |
823329 | 823329 | 2020-12-13 | Cheyenne | Colorado | 8017 | 85 | 3 |
790882 | 790882 | 2020-12-03 | Custer | Colorado | 8027 | 85 | 0 |
742243 | 742243 | 2020-11-18 | Sedgwick | Colorado | 8115 | 85 | 1 |
732485 | 732485 | 2020-11-15 | Lincoln | Colorado | 8073 | 85 | 0 |
703297 | 703297 | 2020-11-06 | Moffat | Colorado | 8081 | 85 | 1 |
696810 | 696810 | 2020-11-04 | Moffat | Colorado | 8081 | 85 | 1 |
687075 | 687075 | 2020-11-01 | Las Animas | Colorado | 8071 | 85 | 1 |
683831 | 683831 | 2020-10-31 | Las Animas | Colorado | 8071 | 85 | 1 |
657861 | 657861 | 2020-10-23 | Crowley | Colorado | 8025 | 85 | 1 |
657909 | 657909 | 2020-10-23 | Washington | Colorado | 8121 | 85 | 0 |
651405 | 651405 | 2020-10-21 | Park | Colorado | 8093 | 85 | 1 |
596239 | 596239 | 2020-10-04 | Grand | Colorado | 8049 | 85 | 1 |
521756 | 521756 | 2020-09-11 | Lake | Colorado | 8065 | 85 | 0 |
489434 | 489434 | 2020-09-01 | Prowers | Colorado | 8099 | 85 | 0 |
486201 | 486201 | 2020-08-31 | Prowers | Colorado | 8099 | 85 | 0 |
389421 | 389421 | 2020-08-01 | Elbert | Colorado | 8039 | 85 | 2 |
386204 | 386204 | 2020-07-31 | Elbert | Colorado | 8039 | 85 | 2 |
363710 | 363710 | 2020-07-24 | Fremont | Colorado | 8043 | 85 | 0 |
354132 | 354132 | 2020-07-21 | Teller | Colorado | 8119 | 85 | 2 |
341324 | 341324 | 2020-07-17 | Routt | Colorado | 8107 | 85 | 6 |
338115 | 338115 | 2020-07-16 | Montezuma | Colorado | 8083 | 85 | 3 |
268492 | 268492 | 2020-06-24 | Mesa | Colorado | 8077 | 85 | 0 |
265362 | 265362 | 2020-06-23 | Mesa | Colorado | 8077 | 85 | 0 |
265372 | 265372 | 2020-06-23 | Pitkin | Colorado | 8097 | 85 | 2 |
252855 | 252855 | 2020-06-19 | La Plata | Colorado | 8067 | 85 | 1 |
246628 | 246628 | 2020-06-17 | La Plata | Colorado | 8067 | 85 | 1 |
240404 | 240404 | 2020-06-15 | La Plata | Colorado | 8067 | 85 | 1 |
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);