ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 8049 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635154 | 635154 | 2020-10-16 | Grand | Colorado | 8049 | 127 | 1 |
631908 | 631908 | 2020-10-15 | Grand | Colorado | 8049 | 123 | 1 |
628664 | 628664 | 2020-10-14 | Grand | Colorado | 8049 | 118 | 1 |
625421 | 625421 | 2020-10-13 | Grand | Colorado | 8049 | 116 | 1 |
622178 | 622178 | 2020-10-12 | Grand | Colorado | 8049 | 116 | 1 |
618935 | 618935 | 2020-10-11 | Grand | Colorado | 8049 | 117 | 1 |
615693 | 615693 | 2020-10-10 | Grand | Colorado | 8049 | 114 | 1 |
612452 | 612452 | 2020-10-09 | Grand | Colorado | 8049 | 111 | 1 |
609210 | 609210 | 2020-10-08 | Grand | Colorado | 8049 | 108 | 1 |
605967 | 605967 | 2020-10-07 | Grand | Colorado | 8049 | 106 | 1 |
602725 | 602725 | 2020-10-06 | Grand | Colorado | 8049 | 100 | 1 |
599482 | 599482 | 2020-10-05 | Grand | Colorado | 8049 | 96 | 1 |
596239 | 596239 | 2020-10-04 | Grand | Colorado | 8049 | 85 | 1 |
592997 | 592997 | 2020-10-03 | Grand | Colorado | 8049 | 83 | 1 |
589757 | 589757 | 2020-10-02 | Grand | Colorado | 8049 | 83 | 1 |
586516 | 586516 | 2020-10-01 | Grand | Colorado | 8049 | 83 | 1 |
583276 | 583276 | 2020-09-30 | Grand | Colorado | 8049 | 76 | 1 |
580037 | 580037 | 2020-09-29 | Grand | Colorado | 8049 | 74 | 1 |
576796 | 576796 | 2020-09-28 | Grand | Colorado | 8049 | 74 | 1 |
573553 | 573553 | 2020-09-27 | Grand | Colorado | 8049 | 74 | 1 |
570311 | 570311 | 2020-09-26 | Grand | Colorado | 8049 | 74 | 1 |
567069 | 567069 | 2020-09-25 | Grand | Colorado | 8049 | 72 | 1 |
563829 | 563829 | 2020-09-24 | Grand | Colorado | 8049 | 72 | 1 |
560590 | 560590 | 2020-09-23 | Grand | Colorado | 8049 | 71 | 1 |
557354 | 557354 | 2020-09-22 | Grand | Colorado | 8049 | 71 | 1 |
554117 | 554117 | 2020-09-21 | Grand | Colorado | 8049 | 71 | 1 |
550878 | 550878 | 2020-09-20 | Grand | Colorado | 8049 | 71 | 1 |
547639 | 547639 | 2020-09-19 | Grand | Colorado | 8049 | 71 | 1 |
544401 | 544401 | 2020-09-18 | Grand | Colorado | 8049 | 71 | 1 |
541165 | 541165 | 2020-09-17 | Grand | Colorado | 8049 | 71 | 1 |
537928 | 537928 | 2020-09-16 | Grand | Colorado | 8049 | 71 | 1 |
534692 | 534692 | 2020-09-15 | Grand | Colorado | 8049 | 69 | 1 |
531457 | 531457 | 2020-09-14 | Grand | Colorado | 8049 | 69 | 1 |
528220 | 528220 | 2020-09-13 | Grand | Colorado | 8049 | 69 | 1 |
524984 | 524984 | 2020-09-12 | Grand | Colorado | 8049 | 69 | 1 |
521748 | 521748 | 2020-09-11 | Grand | Colorado | 8049 | 69 | 1 |
518511 | 518511 | 2020-09-10 | Grand | Colorado | 8049 | 69 | 1 |
515276 | 515276 | 2020-09-09 | Grand | Colorado | 8049 | 69 | 1 |
512043 | 512043 | 2020-09-08 | Grand | Colorado | 8049 | 67 | 1 |
508810 | 508810 | 2020-09-07 | Grand | Colorado | 8049 | 67 | 1 |
505578 | 505578 | 2020-09-06 | Grand | Colorado | 8049 | 66 | 1 |
502344 | 502344 | 2020-09-05 | Grand | Colorado | 8049 | 66 | 1 |
499110 | 499110 | 2020-09-04 | Grand | Colorado | 8049 | 66 | 1 |
495877 | 495877 | 2020-09-03 | Grand | Colorado | 8049 | 66 | 1 |
492643 | 492643 | 2020-09-02 | Grand | Colorado | 8049 | 66 | 1 |
489410 | 489410 | 2020-09-01 | Grand | Colorado | 8049 | 66 | 1 |
486177 | 486177 | 2020-08-31 | Grand | Colorado | 8049 | 63 | 1 |
482942 | 482942 | 2020-08-30 | Grand | Colorado | 8049 | 62 | 1 |
479708 | 479708 | 2020-08-29 | Grand | Colorado | 8049 | 62 | 1 |
476475 | 476475 | 2020-08-28 | Grand | Colorado | 8049 | 62 | 1 |
473242 | 473242 | 2020-08-27 | Grand | Colorado | 8049 | 62 | 1 |
470010 | 470010 | 2020-08-26 | Grand | Colorado | 8049 | 60 | 1 |
466781 | 466781 | 2020-08-25 | Grand | Colorado | 8049 | 57 | 1 |
463552 | 463552 | 2020-08-24 | Grand | Colorado | 8049 | 56 | 1 |
460323 | 460323 | 2020-08-23 | Grand | Colorado | 8049 | 56 | 1 |
457096 | 457096 | 2020-08-22 | Grand | Colorado | 8049 | 56 | 1 |
453868 | 453868 | 2020-08-21 | Grand | Colorado | 8049 | 56 | 1 |
450640 | 450640 | 2020-08-20 | Grand | Colorado | 8049 | 56 | 1 |
447412 | 447412 | 2020-08-19 | Grand | Colorado | 8049 | 56 | 1 |
444185 | 444185 | 2020-08-18 | Grand | Colorado | 8049 | 55 | 1 |
440959 | 440959 | 2020-08-17 | Grand | Colorado | 8049 | 54 | 1 |
437733 | 437733 | 2020-08-16 | Grand | Colorado | 8049 | 54 | 1 |
434507 | 434507 | 2020-08-15 | Grand | Colorado | 8049 | 54 | 1 |
431282 | 431282 | 2020-08-14 | Grand | Colorado | 8049 | 54 | 1 |
428054 | 428054 | 2020-08-13 | Grand | Colorado | 8049 | 54 | 1 |
424830 | 424830 | 2020-08-12 | Grand | Colorado | 8049 | 53 | 1 |
421609 | 421609 | 2020-08-11 | Grand | Colorado | 8049 | 51 | 1 |
418388 | 418388 | 2020-08-10 | Grand | Colorado | 8049 | 46 | 1 |
415167 | 415167 | 2020-08-09 | Grand | Colorado | 8049 | 46 | 1 |
411947 | 411947 | 2020-08-08 | Grand | Colorado | 8049 | 46 | 1 |
408728 | 408728 | 2020-08-07 | Grand | Colorado | 8049 | 46 | 1 |
405508 | 405508 | 2020-08-06 | Grand | Colorado | 8049 | 45 | 1 |
402290 | 402290 | 2020-08-05 | Grand | Colorado | 8049 | 44 | 1 |
399074 | 399074 | 2020-08-04 | Grand | Colorado | 8049 | 44 | 1 |
395858 | 395858 | 2020-08-03 | Grand | Colorado | 8049 | 44 | 1 |
392642 | 392642 | 2020-08-02 | Grand | Colorado | 8049 | 43 | 1 |
389425 | 389425 | 2020-08-01 | Grand | Colorado | 8049 | 43 | 1 |
386208 | 386208 | 2020-07-31 | Grand | Colorado | 8049 | 42 | 1 |
382990 | 382990 | 2020-07-30 | Grand | Colorado | 8049 | 41 | 1 |
379773 | 379773 | 2020-07-29 | Grand | Colorado | 8049 | 41 | 1 |
376556 | 376556 | 2020-07-28 | Grand | Colorado | 8049 | 40 | 1 |
373342 | 373342 | 2020-07-27 | Grand | Colorado | 8049 | 39 | 1 |
370130 | 370130 | 2020-07-26 | Grand | Colorado | 8049 | 39 | 1 |
366920 | 366920 | 2020-07-25 | Grand | Colorado | 8049 | 40 | 1 |
363713 | 363713 | 2020-07-24 | Grand | Colorado | 8049 | 39 | 1 |
360506 | 360506 | 2020-07-23 | Grand | Colorado | 8049 | 39 | 1 |
357301 | 357301 | 2020-07-22 | Grand | Colorado | 8049 | 39 | 1 |
354098 | 354098 | 2020-07-21 | Grand | Colorado | 8049 | 37 | 1 |
350896 | 350896 | 2020-07-20 | Grand | Colorado | 8049 | 37 | 1 |
347695 | 347695 | 2020-07-19 | Grand | Colorado | 8049 | 35 | 1 |
344495 | 344495 | 2020-07-18 | Grand | Colorado | 8049 | 35 | 1 |
341296 | 341296 | 2020-07-17 | Grand | Colorado | 8049 | 34 | 1 |
338099 | 338099 | 2020-07-16 | Grand | Colorado | 8049 | 32 | 1 |
334904 | 334904 | 2020-07-15 | Grand | Colorado | 8049 | 29 | 1 |
331711 | 331711 | 2020-07-14 | Grand | Colorado | 8049 | 29 | 1 |
328525 | 328525 | 2020-07-13 | Grand | Colorado | 8049 | 29 | 1 |
325339 | 325339 | 2020-07-12 | Grand | Colorado | 8049 | 28 | 1 |
322158 | 322158 | 2020-07-11 | Grand | Colorado | 8049 | 27 | 1 |
318979 | 318979 | 2020-07-10 | Grand | Colorado | 8049 | 26 | 1 |
315806 | 315806 | 2020-07-09 | Grand | Colorado | 8049 | 23 | 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);