ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where fips = 8021 and state = "Colorado" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
121523 | 121523 | 2020-05-07 | Conejos | Colorado | 8021 | 1 | 0 |
124503 | 124503 | 2020-05-08 | Conejos | Colorado | 8021 | 1 | 0 |
127489 | 127489 | 2020-05-09 | Conejos | Colorado | 8021 | 1 | 0 |
130480 | 130480 | 2020-05-10 | Conejos | Colorado | 8021 | 1 | 0 |
133471 | 133471 | 2020-05-11 | Conejos | Colorado | 8021 | 1 | 0 |
136460 | 136460 | 2020-05-12 | Conejos | Colorado | 8021 | 1 | 0 |
139451 | 139451 | 2020-05-13 | Conejos | Colorado | 8021 | 1 | 0 |
142447 | 142447 | 2020-05-14 | Conejos | Colorado | 8021 | 1 | 0 |
145447 | 145447 | 2020-05-15 | Conejos | Colorado | 8021 | 1 | 0 |
148450 | 148450 | 2020-05-16 | Conejos | Colorado | 8021 | 1 | 0 |
151459 | 151459 | 2020-05-17 | Conejos | Colorado | 8021 | 1 | 0 |
154471 | 154471 | 2020-05-18 | Conejos | Colorado | 8021 | 1 | 0 |
157487 | 157487 | 2020-05-19 | Conejos | Colorado | 8021 | 1 | 0 |
160513 | 160513 | 2020-05-20 | Conejos | Colorado | 8021 | 1 | 0 |
163541 | 163541 | 2020-05-21 | Conejos | Colorado | 8021 | 1 | 0 |
166574 | 166574 | 2020-05-22 | Conejos | Colorado | 8021 | 1 | 0 |
169611 | 169611 | 2020-05-23 | Conejos | Colorado | 8021 | 1 | 0 |
172652 | 172652 | 2020-05-24 | Conejos | Colorado | 8021 | 1 | 0 |
175696 | 175696 | 2020-05-25 | Conejos | Colorado | 8021 | 1 | 0 |
178740 | 178740 | 2020-05-26 | Conejos | Colorado | 8021 | 1 | 0 |
181784 | 181784 | 2020-05-27 | Conejos | Colorado | 8021 | 1 | 0 |
184838 | 184838 | 2020-05-28 | Conejos | Colorado | 8021 | 1 | 0 |
187894 | 187894 | 2020-05-29 | Conejos | Colorado | 8021 | 1 | 0 |
190959 | 190959 | 2020-05-30 | Conejos | Colorado | 8021 | 1 | 0 |
194026 | 194026 | 2020-05-31 | Conejos | Colorado | 8021 | 2 | 0 |
197096 | 197096 | 2020-06-01 | Conejos | Colorado | 8021 | 2 | 0 |
200169 | 200169 | 2020-06-02 | Conejos | Colorado | 8021 | 2 | 0 |
203245 | 203245 | 2020-06-03 | Conejos | Colorado | 8021 | 2 | 0 |
206325 | 206325 | 2020-06-04 | Conejos | Colorado | 8021 | 3 | 0 |
209406 | 209406 | 2020-06-05 | Conejos | Colorado | 8021 | 4 | 0 |
212491 | 212491 | 2020-06-06 | Conejos | Colorado | 8021 | 4 | 0 |
215578 | 215578 | 2020-06-07 | Conejos | Colorado | 8021 | 5 | 0 |
218669 | 218669 | 2020-06-08 | Conejos | Colorado | 8021 | 5 | 0 |
221764 | 221764 | 2020-06-09 | Conejos | Colorado | 8021 | 5 | 0 |
224859 | 224859 | 2020-06-10 | Conejos | Colorado | 8021 | 5 | 0 |
227961 | 227961 | 2020-06-11 | Conejos | Colorado | 8021 | 5 | 0 |
231064 | 231064 | 2020-06-12 | Conejos | Colorado | 8021 | 5 | 0 |
234170 | 234170 | 2020-06-13 | Conejos | Colorado | 8021 | 5 | 0 |
237277 | 237277 | 2020-06-14 | Conejos | Colorado | 8021 | 5 | 0 |
240385 | 240385 | 2020-06-15 | Conejos | Colorado | 8021 | 5 | 0 |
243496 | 243496 | 2020-06-16 | Conejos | Colorado | 8021 | 7 | 0 |
246609 | 246609 | 2020-06-17 | Conejos | Colorado | 8021 | 7 | 0 |
249721 | 249721 | 2020-06-18 | Conejos | Colorado | 8021 | 7 | 0 |
252836 | 252836 | 2020-06-19 | Conejos | Colorado | 8021 | 10 | 0 |
255955 | 255955 | 2020-06-20 | Conejos | Colorado | 8021 | 12 | 0 |
259082 | 259082 | 2020-06-21 | Conejos | Colorado | 8021 | 12 | 0 |
262209 | 262209 | 2020-06-22 | Conejos | Colorado | 8021 | 12 | 0 |
265337 | 265337 | 2020-06-23 | Conejos | Colorado | 8021 | 12 | 0 |
268467 | 268467 | 2020-06-24 | Conejos | Colorado | 8021 | 12 | 0 |
271602 | 271602 | 2020-06-25 | Conejos | Colorado | 8021 | 12 | 0 |
274742 | 274742 | 2020-06-26 | Conejos | Colorado | 8021 | 12 | 0 |
277890 | 277890 | 2020-06-27 | Conejos | Colorado | 8021 | 13 | 0 |
281037 | 281037 | 2020-06-28 | Conejos | Colorado | 8021 | 13 | 0 |
284183 | 284183 | 2020-06-29 | Conejos | Colorado | 8021 | 13 | 0 |
287329 | 287329 | 2020-06-30 | Conejos | Colorado | 8021 | 13 | 0 |
290480 | 290480 | 2020-07-01 | Conejos | Colorado | 8021 | 13 | 0 |
293634 | 293634 | 2020-07-02 | Conejos | Colorado | 8021 | 15 | 0 |
296790 | 296790 | 2020-07-03 | Conejos | Colorado | 8021 | 15 | 0 |
299952 | 299952 | 2020-07-04 | Conejos | Colorado | 8021 | 15 | 0 |
303116 | 303116 | 2020-07-05 | Conejos | Colorado | 8021 | 15 | 0 |
306280 | 306280 | 2020-07-06 | Conejos | Colorado | 8021 | 15 | 0 |
309448 | 309448 | 2020-07-07 | Conejos | Colorado | 8021 | 15 | 0 |
312618 | 312618 | 2020-07-08 | Conejos | Colorado | 8021 | 15 | 0 |
315793 | 315793 | 2020-07-09 | Conejos | Colorado | 8021 | 15 | 0 |
318966 | 318966 | 2020-07-10 | Conejos | Colorado | 8021 | 17 | 0 |
322145 | 322145 | 2020-07-11 | Conejos | Colorado | 8021 | 18 | 0 |
325326 | 325326 | 2020-07-12 | Conejos | Colorado | 8021 | 18 | 0 |
328512 | 328512 | 2020-07-13 | Conejos | Colorado | 8021 | 18 | 0 |
331698 | 331698 | 2020-07-14 | Conejos | Colorado | 8021 | 18 | 0 |
334891 | 334891 | 2020-07-15 | Conejos | Colorado | 8021 | 18 | 0 |
338086 | 338086 | 2020-07-16 | Conejos | Colorado | 8021 | 19 | 0 |
341282 | 341282 | 2020-07-17 | Conejos | Colorado | 8021 | 20 | 0 |
344481 | 344481 | 2020-07-18 | Conejos | Colorado | 8021 | 20 | 0 |
347681 | 347681 | 2020-07-19 | Conejos | Colorado | 8021 | 21 | 0 |
350882 | 350882 | 2020-07-20 | Conejos | Colorado | 8021 | 21 | 0 |
354084 | 354084 | 2020-07-21 | Conejos | Colorado | 8021 | 21 | 0 |
357287 | 357287 | 2020-07-22 | Conejos | Colorado | 8021 | 21 | 0 |
360492 | 360492 | 2020-07-23 | Conejos | Colorado | 8021 | 21 | 0 |
363699 | 363699 | 2020-07-24 | Conejos | Colorado | 8021 | 22 | 0 |
366906 | 366906 | 2020-07-25 | Conejos | Colorado | 8021 | 22 | 0 |
370116 | 370116 | 2020-07-26 | Conejos | Colorado | 8021 | 21 | 0 |
373328 | 373328 | 2020-07-27 | Conejos | Colorado | 8021 | 21 | 0 |
376542 | 376542 | 2020-07-28 | Conejos | Colorado | 8021 | 21 | 0 |
379759 | 379759 | 2020-07-29 | Conejos | Colorado | 8021 | 21 | 0 |
382976 | 382976 | 2020-07-30 | Conejos | Colorado | 8021 | 23 | 0 |
386194 | 386194 | 2020-07-31 | Conejos | Colorado | 8021 | 23 | 0 |
389411 | 389411 | 2020-08-01 | Conejos | Colorado | 8021 | 23 | 0 |
392628 | 392628 | 2020-08-02 | Conejos | Colorado | 8021 | 23 | 0 |
395844 | 395844 | 2020-08-03 | Conejos | Colorado | 8021 | 23 | 0 |
399060 | 399060 | 2020-08-04 | Conejos | Colorado | 8021 | 23 | 0 |
402276 | 402276 | 2020-08-05 | Conejos | Colorado | 8021 | 23 | 0 |
405494 | 405494 | 2020-08-06 | Conejos | Colorado | 8021 | 23 | 0 |
408714 | 408714 | 2020-08-07 | Conejos | Colorado | 8021 | 23 | 0 |
411933 | 411933 | 2020-08-08 | Conejos | Colorado | 8021 | 23 | 0 |
415153 | 415153 | 2020-08-09 | Conejos | Colorado | 8021 | 23 | 0 |
418374 | 418374 | 2020-08-10 | Conejos | Colorado | 8021 | 23 | 0 |
421595 | 421595 | 2020-08-11 | Conejos | Colorado | 8021 | 23 | 0 |
424816 | 424816 | 2020-08-12 | Conejos | Colorado | 8021 | 23 | 0 |
428040 | 428040 | 2020-08-13 | Conejos | Colorado | 8021 | 26 | 0 |
431268 | 431268 | 2020-08-14 | Conejos | Colorado | 8021 | 27 | 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);