ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8019 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635139 | 635139 | 2020-10-16 | Clear Creek | Colorado | 8019 | 61 | 1 |
631893 | 631893 | 2020-10-15 | Clear Creek | Colorado | 8019 | 61 | 1 |
628649 | 628649 | 2020-10-14 | Clear Creek | Colorado | 8019 | 61 | 1 |
625406 | 625406 | 2020-10-13 | Clear Creek | Colorado | 8019 | 59 | 1 |
622163 | 622163 | 2020-10-12 | Clear Creek | Colorado | 8019 | 59 | 1 |
618920 | 618920 | 2020-10-11 | Clear Creek | Colorado | 8019 | 58 | 1 |
615678 | 615678 | 2020-10-10 | Clear Creek | Colorado | 8019 | 58 | 1 |
612437 | 612437 | 2020-10-09 | Clear Creek | Colorado | 8019 | 54 | 1 |
609195 | 609195 | 2020-10-08 | Clear Creek | Colorado | 8019 | 51 | 1 |
605952 | 605952 | 2020-10-07 | Clear Creek | Colorado | 8019 | 50 | 1 |
602710 | 602710 | 2020-10-06 | Clear Creek | Colorado | 8019 | 47 | 1 |
599467 | 599467 | 2020-10-05 | Clear Creek | Colorado | 8019 | 47 | 1 |
596224 | 596224 | 2020-10-04 | Clear Creek | Colorado | 8019 | 47 | 1 |
592982 | 592982 | 2020-10-03 | Clear Creek | Colorado | 8019 | 47 | 1 |
589742 | 589742 | 2020-10-02 | Clear Creek | Colorado | 8019 | 43 | 1 |
586501 | 586501 | 2020-10-01 | Clear Creek | Colorado | 8019 | 40 | 1 |
583261 | 583261 | 2020-09-30 | Clear Creek | Colorado | 8019 | 40 | 1 |
580022 | 580022 | 2020-09-29 | Clear Creek | Colorado | 8019 | 39 | 1 |
576781 | 576781 | 2020-09-28 | Clear Creek | Colorado | 8019 | 39 | 1 |
573538 | 573538 | 2020-09-27 | Clear Creek | Colorado | 8019 | 39 | 1 |
570296 | 570296 | 2020-09-26 | Clear Creek | Colorado | 8019 | 37 | 1 |
567054 | 567054 | 2020-09-25 | Clear Creek | Colorado | 8019 | 37 | 1 |
563814 | 563814 | 2020-09-24 | Clear Creek | Colorado | 8019 | 37 | 1 |
560575 | 560575 | 2020-09-23 | Clear Creek | Colorado | 8019 | 37 | 1 |
557339 | 557339 | 2020-09-22 | Clear Creek | Colorado | 8019 | 37 | 1 |
554102 | 554102 | 2020-09-21 | Clear Creek | Colorado | 8019 | 37 | 1 |
550863 | 550863 | 2020-09-20 | Clear Creek | Colorado | 8019 | 37 | 1 |
547624 | 547624 | 2020-09-19 | Clear Creek | Colorado | 8019 | 37 | 1 |
544386 | 544386 | 2020-09-18 | Clear Creek | Colorado | 8019 | 36 | 1 |
541150 | 541150 | 2020-09-17 | Clear Creek | Colorado | 8019 | 36 | 1 |
537913 | 537913 | 2020-09-16 | Clear Creek | Colorado | 8019 | 36 | 1 |
534677 | 534677 | 2020-09-15 | Clear Creek | Colorado | 8019 | 36 | 1 |
531442 | 531442 | 2020-09-14 | Clear Creek | Colorado | 8019 | 36 | 1 |
528205 | 528205 | 2020-09-13 | Clear Creek | Colorado | 8019 | 36 | 1 |
524969 | 524969 | 2020-09-12 | Clear Creek | Colorado | 8019 | 36 | 1 |
521733 | 521733 | 2020-09-11 | Clear Creek | Colorado | 8019 | 36 | 1 |
518496 | 518496 | 2020-09-10 | Clear Creek | Colorado | 8019 | 36 | 1 |
515261 | 515261 | 2020-09-09 | Clear Creek | Colorado | 8019 | 36 | 1 |
512028 | 512028 | 2020-09-08 | Clear Creek | Colorado | 8019 | 36 | 1 |
508795 | 508795 | 2020-09-07 | Clear Creek | Colorado | 8019 | 36 | 1 |
505563 | 505563 | 2020-09-06 | Clear Creek | Colorado | 8019 | 36 | 1 |
502329 | 502329 | 2020-09-05 | Clear Creek | Colorado | 8019 | 36 | 1 |
499095 | 499095 | 2020-09-04 | Clear Creek | Colorado | 8019 | 36 | 1 |
495862 | 495862 | 2020-09-03 | Clear Creek | Colorado | 8019 | 36 | 1 |
492628 | 492628 | 2020-09-02 | Clear Creek | Colorado | 8019 | 35 | 1 |
489395 | 489395 | 2020-09-01 | Clear Creek | Colorado | 8019 | 35 | 1 |
486162 | 486162 | 2020-08-31 | Clear Creek | Colorado | 8019 | 35 | 1 |
482927 | 482927 | 2020-08-30 | Clear Creek | Colorado | 8019 | 35 | 1 |
479693 | 479693 | 2020-08-29 | Clear Creek | Colorado | 8019 | 35 | 1 |
476460 | 476460 | 2020-08-28 | Clear Creek | Colorado | 8019 | 34 | 1 |
473227 | 473227 | 2020-08-27 | Clear Creek | Colorado | 8019 | 34 | 1 |
469995 | 469995 | 2020-08-26 | Clear Creek | Colorado | 8019 | 34 | 1 |
466766 | 466766 | 2020-08-25 | Clear Creek | Colorado | 8019 | 34 | 1 |
463537 | 463537 | 2020-08-24 | Clear Creek | Colorado | 8019 | 34 | 1 |
460308 | 460308 | 2020-08-23 | Clear Creek | Colorado | 8019 | 34 | 1 |
457081 | 457081 | 2020-08-22 | Clear Creek | Colorado | 8019 | 34 | 1 |
453853 | 453853 | 2020-08-21 | Clear Creek | Colorado | 8019 | 31 | 1 |
450625 | 450625 | 2020-08-20 | Clear Creek | Colorado | 8019 | 31 | 1 |
447397 | 447397 | 2020-08-19 | Clear Creek | Colorado | 8019 | 31 | 1 |
444170 | 444170 | 2020-08-18 | Clear Creek | Colorado | 8019 | 31 | 1 |
440944 | 440944 | 2020-08-17 | Clear Creek | Colorado | 8019 | 31 | 1 |
437718 | 437718 | 2020-08-16 | Clear Creek | Colorado | 8019 | 31 | 1 |
434492 | 434492 | 2020-08-15 | Clear Creek | Colorado | 8019 | 31 | 1 |
431267 | 431267 | 2020-08-14 | Clear Creek | Colorado | 8019 | 31 | 1 |
428039 | 428039 | 2020-08-13 | Clear Creek | Colorado | 8019 | 31 | 1 |
424815 | 424815 | 2020-08-12 | Clear Creek | Colorado | 8019 | 30 | 1 |
421594 | 421594 | 2020-08-11 | Clear Creek | Colorado | 8019 | 30 | 1 |
418373 | 418373 | 2020-08-10 | Clear Creek | Colorado | 8019 | 30 | 1 |
415152 | 415152 | 2020-08-09 | Clear Creek | Colorado | 8019 | 30 | 1 |
411932 | 411932 | 2020-08-08 | Clear Creek | Colorado | 8019 | 30 | 1 |
408713 | 408713 | 2020-08-07 | Clear Creek | Colorado | 8019 | 30 | 1 |
405493 | 405493 | 2020-08-06 | Clear Creek | Colorado | 8019 | 29 | 1 |
402275 | 402275 | 2020-08-05 | Clear Creek | Colorado | 8019 | 28 | 1 |
399059 | 399059 | 2020-08-04 | Clear Creek | Colorado | 8019 | 28 | 1 |
395843 | 395843 | 2020-08-03 | Clear Creek | Colorado | 8019 | 27 | 1 |
392627 | 392627 | 2020-08-02 | Clear Creek | Colorado | 8019 | 27 | 1 |
389410 | 389410 | 2020-08-01 | Clear Creek | Colorado | 8019 | 27 | 1 |
386193 | 386193 | 2020-07-31 | Clear Creek | Colorado | 8019 | 26 | 1 |
382975 | 382975 | 2020-07-30 | Clear Creek | Colorado | 8019 | 26 | 1 |
379758 | 379758 | 2020-07-29 | Clear Creek | Colorado | 8019 | 26 | 1 |
376541 | 376541 | 2020-07-28 | Clear Creek | Colorado | 8019 | 26 | 1 |
373327 | 373327 | 2020-07-27 | Clear Creek | Colorado | 8019 | 26 | 1 |
370115 | 370115 | 2020-07-26 | Clear Creek | Colorado | 8019 | 26 | 1 |
366905 | 366905 | 2020-07-25 | Clear Creek | Colorado | 8019 | 25 | 1 |
363698 | 363698 | 2020-07-24 | Clear Creek | Colorado | 8019 | 24 | 1 |
360491 | 360491 | 2020-07-23 | Clear Creek | Colorado | 8019 | 24 | 1 |
357286 | 357286 | 2020-07-22 | Clear Creek | Colorado | 8019 | 24 | 1 |
354083 | 354083 | 2020-07-21 | Clear Creek | Colorado | 8019 | 24 | 1 |
350881 | 350881 | 2020-07-20 | Clear Creek | Colorado | 8019 | 24 | 1 |
347680 | 347680 | 2020-07-19 | Clear Creek | Colorado | 8019 | 23 | 1 |
344480 | 344480 | 2020-07-18 | Clear Creek | Colorado | 8019 | 23 | 1 |
341281 | 341281 | 2020-07-17 | Clear Creek | Colorado | 8019 | 23 | 1 |
338085 | 338085 | 2020-07-16 | Clear Creek | Colorado | 8019 | 23 | 1 |
334890 | 334890 | 2020-07-15 | Clear Creek | Colorado | 8019 | 21 | 1 |
331697 | 331697 | 2020-07-14 | Clear Creek | Colorado | 8019 | 21 | 1 |
328511 | 328511 | 2020-07-13 | Clear Creek | Colorado | 8019 | 21 | 1 |
325325 | 325325 | 2020-07-12 | Clear Creek | Colorado | 8019 | 21 | 1 |
322144 | 322144 | 2020-07-11 | Clear Creek | Colorado | 8019 | 21 | 1 |
318965 | 318965 | 2020-07-10 | Clear Creek | Colorado | 8019 | 21 | 1 |
315792 | 315792 | 2020-07-09 | Clear Creek | Colorado | 8019 | 21 | 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);