ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8113 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635186 | 635186 | 2020-10-16 | San Miguel | Colorado | 8113 | 99 | 0 |
631940 | 631940 | 2020-10-15 | San Miguel | Colorado | 8113 | 99 | 0 |
628696 | 628696 | 2020-10-14 | San Miguel | Colorado | 8113 | 97 | 0 |
625453 | 625453 | 2020-10-13 | San Miguel | Colorado | 8113 | 97 | 0 |
622210 | 622210 | 2020-10-12 | San Miguel | Colorado | 8113 | 97 | 0 |
618967 | 618967 | 2020-10-11 | San Miguel | Colorado | 8113 | 97 | 0 |
615725 | 615725 | 2020-10-10 | San Miguel | Colorado | 8113 | 98 | 0 |
612484 | 612484 | 2020-10-09 | San Miguel | Colorado | 8113 | 98 | 0 |
609242 | 609242 | 2020-10-08 | San Miguel | Colorado | 8113 | 96 | 0 |
605999 | 605999 | 2020-10-07 | San Miguel | Colorado | 8113 | 95 | 0 |
602757 | 602757 | 2020-10-06 | San Miguel | Colorado | 8113 | 95 | 0 |
599514 | 599514 | 2020-10-05 | San Miguel | Colorado | 8113 | 95 | 0 |
596271 | 596271 | 2020-10-04 | San Miguel | Colorado | 8113 | 94 | 0 |
593029 | 593029 | 2020-10-03 | San Miguel | Colorado | 8113 | 94 | 0 |
589789 | 589789 | 2020-10-02 | San Miguel | Colorado | 8113 | 94 | 0 |
586548 | 586548 | 2020-10-01 | San Miguel | Colorado | 8113 | 94 | 0 |
583308 | 583308 | 2020-09-30 | San Miguel | Colorado | 8113 | 94 | 0 |
580069 | 580069 | 2020-09-29 | San Miguel | Colorado | 8113 | 97 | 0 |
576828 | 576828 | 2020-09-28 | San Miguel | Colorado | 8113 | 97 | 0 |
573585 | 573585 | 2020-09-27 | San Miguel | Colorado | 8113 | 97 | 0 |
570343 | 570343 | 2020-09-26 | San Miguel | Colorado | 8113 | 97 | 0 |
567101 | 567101 | 2020-09-25 | San Miguel | Colorado | 8113 | 96 | 0 |
563861 | 563861 | 2020-09-24 | San Miguel | Colorado | 8113 | 96 | 0 |
560621 | 560621 | 2020-09-23 | San Miguel | Colorado | 8113 | 96 | 0 |
557385 | 557385 | 2020-09-22 | San Miguel | Colorado | 8113 | 95 | 0 |
554148 | 554148 | 2020-09-21 | San Miguel | Colorado | 8113 | 95 | 0 |
550909 | 550909 | 2020-09-20 | San Miguel | Colorado | 8113 | 95 | 0 |
547670 | 547670 | 2020-09-19 | San Miguel | Colorado | 8113 | 95 | 0 |
544432 | 544432 | 2020-09-18 | San Miguel | Colorado | 8113 | 95 | 0 |
541196 | 541196 | 2020-09-17 | San Miguel | Colorado | 8113 | 95 | 0 |
537959 | 537959 | 2020-09-16 | San Miguel | Colorado | 8113 | 94 | 0 |
534723 | 534723 | 2020-09-15 | San Miguel | Colorado | 8113 | 93 | 0 |
531488 | 531488 | 2020-09-14 | San Miguel | Colorado | 8113 | 93 | 0 |
528251 | 528251 | 2020-09-13 | San Miguel | Colorado | 8113 | 93 | 0 |
525015 | 525015 | 2020-09-12 | San Miguel | Colorado | 8113 | 93 | 0 |
521779 | 521779 | 2020-09-11 | San Miguel | Colorado | 8113 | 93 | 0 |
518542 | 518542 | 2020-09-10 | San Miguel | Colorado | 8113 | 93 | 0 |
515307 | 515307 | 2020-09-09 | San Miguel | Colorado | 8113 | 94 | 0 |
512074 | 512074 | 2020-09-08 | San Miguel | Colorado | 8113 | 94 | 0 |
508841 | 508841 | 2020-09-07 | San Miguel | Colorado | 8113 | 94 | 0 |
505609 | 505609 | 2020-09-06 | San Miguel | Colorado | 8113 | 94 | 0 |
502375 | 502375 | 2020-09-05 | San Miguel | Colorado | 8113 | 94 | 0 |
499141 | 499141 | 2020-09-04 | San Miguel | Colorado | 8113 | 94 | 0 |
495908 | 495908 | 2020-09-03 | San Miguel | Colorado | 8113 | 93 | 0 |
492674 | 492674 | 2020-09-02 | San Miguel | Colorado | 8113 | 93 | 0 |
489441 | 489441 | 2020-09-01 | San Miguel | Colorado | 8113 | 93 | 0 |
486208 | 486208 | 2020-08-31 | San Miguel | Colorado | 8113 | 93 | 0 |
482973 | 482973 | 2020-08-30 | San Miguel | Colorado | 8113 | 93 | 0 |
479739 | 479739 | 2020-08-29 | San Miguel | Colorado | 8113 | 93 | 0 |
476506 | 476506 | 2020-08-28 | San Miguel | Colorado | 8113 | 93 | 0 |
473273 | 473273 | 2020-08-27 | San Miguel | Colorado | 8113 | 94 | 0 |
470041 | 470041 | 2020-08-26 | San Miguel | Colorado | 8113 | 93 | 0 |
466812 | 466812 | 2020-08-25 | San Miguel | Colorado | 8113 | 93 | 0 |
463583 | 463583 | 2020-08-24 | San Miguel | Colorado | 8113 | 93 | 0 |
460354 | 460354 | 2020-08-23 | San Miguel | Colorado | 8113 | 93 | 0 |
457127 | 457127 | 2020-08-22 | San Miguel | Colorado | 8113 | 93 | 0 |
453899 | 453899 | 2020-08-21 | San Miguel | Colorado | 8113 | 93 | 0 |
450671 | 450671 | 2020-08-20 | San Miguel | Colorado | 8113 | 93 | 0 |
447443 | 447443 | 2020-08-19 | San Miguel | Colorado | 8113 | 93 | 0 |
444216 | 444216 | 2020-08-18 | San Miguel | Colorado | 8113 | 93 | 0 |
440990 | 440990 | 2020-08-17 | San Miguel | Colorado | 8113 | 93 | 0 |
437764 | 437764 | 2020-08-16 | San Miguel | Colorado | 8113 | 93 | 0 |
434538 | 434538 | 2020-08-15 | San Miguel | Colorado | 8113 | 93 | 0 |
431313 | 431313 | 2020-08-14 | San Miguel | Colorado | 8113 | 92 | 0 |
428085 | 428085 | 2020-08-13 | San Miguel | Colorado | 8113 | 92 | 0 |
424861 | 424861 | 2020-08-12 | San Miguel | Colorado | 8113 | 91 | 0 |
421640 | 421640 | 2020-08-11 | San Miguel | Colorado | 8113 | 90 | 0 |
418419 | 418419 | 2020-08-10 | San Miguel | Colorado | 8113 | 89 | 0 |
415198 | 415198 | 2020-08-09 | San Miguel | Colorado | 8113 | 89 | 0 |
411978 | 411978 | 2020-08-08 | San Miguel | Colorado | 8113 | 88 | 0 |
408759 | 408759 | 2020-08-07 | San Miguel | Colorado | 8113 | 82 | 0 |
405539 | 405539 | 2020-08-06 | San Miguel | Colorado | 8113 | 80 | 0 |
402321 | 402321 | 2020-08-05 | San Miguel | Colorado | 8113 | 80 | 0 |
399105 | 399105 | 2020-08-04 | San Miguel | Colorado | 8113 | 80 | 0 |
395889 | 395889 | 2020-08-03 | San Miguel | Colorado | 8113 | 76 | 0 |
392673 | 392673 | 2020-08-02 | San Miguel | Colorado | 8113 | 76 | 0 |
389456 | 389456 | 2020-08-01 | San Miguel | Colorado | 8113 | 76 | 0 |
386239 | 386239 | 2020-07-31 | San Miguel | Colorado | 8113 | 73 | 0 |
383021 | 383021 | 2020-07-30 | San Miguel | Colorado | 8113 | 73 | 0 |
379804 | 379804 | 2020-07-29 | San Miguel | Colorado | 8113 | 73 | 0 |
376587 | 376587 | 2020-07-28 | San Miguel | Colorado | 8113 | 73 | 0 |
373373 | 373373 | 2020-07-27 | San Miguel | Colorado | 8113 | 73 | 0 |
370161 | 370161 | 2020-07-26 | San Miguel | Colorado | 8113 | 73 | 0 |
366951 | 366951 | 2020-07-25 | San Miguel | Colorado | 8113 | 73 | 0 |
363744 | 363744 | 2020-07-24 | San Miguel | Colorado | 8113 | 70 | 0 |
360537 | 360537 | 2020-07-23 | San Miguel | Colorado | 8113 | 70 | 0 |
357332 | 357332 | 2020-07-22 | San Miguel | Colorado | 8113 | 69 | 0 |
354129 | 354129 | 2020-07-21 | San Miguel | Colorado | 8113 | 68 | 0 |
350927 | 350927 | 2020-07-20 | San Miguel | Colorado | 8113 | 67 | 0 |
347726 | 347726 | 2020-07-19 | San Miguel | Colorado | 8113 | 66 | 0 |
344526 | 344526 | 2020-07-18 | San Miguel | Colorado | 8113 | 64 | 0 |
341327 | 341327 | 2020-07-17 | San Miguel | Colorado | 8113 | 64 | 0 |
338130 | 338130 | 2020-07-16 | San Miguel | Colorado | 8113 | 60 | 0 |
334935 | 334935 | 2020-07-15 | San Miguel | Colorado | 8113 | 57 | 0 |
331742 | 331742 | 2020-07-14 | San Miguel | Colorado | 8113 | 50 | 0 |
328556 | 328556 | 2020-07-13 | San Miguel | Colorado | 8113 | 50 | 0 |
325370 | 325370 | 2020-07-12 | San Miguel | Colorado | 8113 | 49 | 0 |
322189 | 322189 | 2020-07-11 | San Miguel | Colorado | 8113 | 48 | 0 |
319010 | 319010 | 2020-07-10 | San Miguel | Colorado | 8113 | 45 | 0 |
315837 | 315837 | 2020-07-09 | San Miguel | Colorado | 8113 | 43 | 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);