ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8123 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635191 | 635191 | 2020-10-16 | Weld | Colorado | 8123 | 5307 | 155 |
631945 | 631945 | 2020-10-15 | Weld | Colorado | 8123 | 5264 | 155 |
628701 | 628701 | 2020-10-14 | Weld | Colorado | 8123 | 5227 | 155 |
625458 | 625458 | 2020-10-13 | Weld | Colorado | 8123 | 5197 | 155 |
622215 | 622215 | 2020-10-12 | Weld | Colorado | 8123 | 5167 | 153 |
618972 | 618972 | 2020-10-11 | Weld | Colorado | 8123 | 5151 | 153 |
615730 | 615730 | 2020-10-10 | Weld | Colorado | 8123 | 5117 | 153 |
612489 | 612489 | 2020-10-09 | Weld | Colorado | 8123 | 5083 | 152 |
609247 | 609247 | 2020-10-08 | Weld | Colorado | 8123 | 5055 | 152 |
606004 | 606004 | 2020-10-07 | Weld | Colorado | 8123 | 5024 | 151 |
602762 | 602762 | 2020-10-06 | Weld | Colorado | 8123 | 4987 | 151 |
599519 | 599519 | 2020-10-05 | Weld | Colorado | 8123 | 4962 | 151 |
596276 | 596276 | 2020-10-04 | Weld | Colorado | 8123 | 4949 | 151 |
593034 | 593034 | 2020-10-03 | Weld | Colorado | 8123 | 4909 | 151 |
589794 | 589794 | 2020-10-02 | Weld | Colorado | 8123 | 4874 | 151 |
586553 | 586553 | 2020-10-01 | Weld | Colorado | 8123 | 4834 | 151 |
583313 | 583313 | 2020-09-30 | Weld | Colorado | 8123 | 4784 | 151 |
580074 | 580074 | 2020-09-29 | Weld | Colorado | 8123 | 4763 | 150 |
576833 | 576833 | 2020-09-28 | Weld | Colorado | 8123 | 4741 | 150 |
573590 | 573590 | 2020-09-27 | Weld | Colorado | 8123 | 4712 | 149 |
570348 | 570348 | 2020-09-26 | Weld | Colorado | 8123 | 4682 | 149 |
567106 | 567106 | 2020-09-25 | Weld | Colorado | 8123 | 4655 | 149 |
563866 | 563866 | 2020-09-24 | Weld | Colorado | 8123 | 4624 | 149 |
560626 | 560626 | 2020-09-23 | Weld | Colorado | 8123 | 4597 | 149 |
557390 | 557390 | 2020-09-22 | Weld | Colorado | 8123 | 4576 | 149 |
554153 | 554153 | 2020-09-21 | Weld | Colorado | 8123 | 4540 | 149 |
550914 | 550914 | 2020-09-20 | Weld | Colorado | 8123 | 4507 | 149 |
547675 | 547675 | 2020-09-19 | Weld | Colorado | 8123 | 4492 | 149 |
544437 | 544437 | 2020-09-18 | Weld | Colorado | 8123 | 4451 | 149 |
541201 | 541201 | 2020-09-17 | Weld | Colorado | 8123 | 4428 | 149 |
537964 | 537964 | 2020-09-16 | Weld | Colorado | 8123 | 4401 | 149 |
534728 | 534728 | 2020-09-15 | Weld | Colorado | 8123 | 4356 | 149 |
531493 | 531493 | 2020-09-14 | Weld | Colorado | 8123 | 4326 | 149 |
528256 | 528256 | 2020-09-13 | Weld | Colorado | 8123 | 4304 | 149 |
525020 | 525020 | 2020-09-12 | Weld | Colorado | 8123 | 4285 | 149 |
521784 | 521784 | 2020-09-11 | Weld | Colorado | 8123 | 4257 | 149 |
518547 | 518547 | 2020-09-10 | Weld | Colorado | 8123 | 4245 | 149 |
515312 | 515312 | 2020-09-09 | Weld | Colorado | 8123 | 4233 | 149 |
512079 | 512079 | 2020-09-08 | Weld | Colorado | 8123 | 4219 | 148 |
508846 | 508846 | 2020-09-07 | Weld | Colorado | 8123 | 4198 | 148 |
505614 | 505614 | 2020-09-06 | Weld | Colorado | 8123 | 4178 | 148 |
502380 | 502380 | 2020-09-05 | Weld | Colorado | 8123 | 4157 | 148 |
499146 | 499146 | 2020-09-04 | Weld | Colorado | 8123 | 4136 | 147 |
495913 | 495913 | 2020-09-03 | Weld | Colorado | 8123 | 4113 | 146 |
492679 | 492679 | 2020-09-02 | Weld | Colorado | 8123 | 4098 | 146 |
489446 | 489446 | 2020-09-01 | Weld | Colorado | 8123 | 4085 | 146 |
486213 | 486213 | 2020-08-31 | Weld | Colorado | 8123 | 4060 | 146 |
482978 | 482978 | 2020-08-30 | Weld | Colorado | 8123 | 4051 | 146 |
479744 | 479744 | 2020-08-29 | Weld | Colorado | 8123 | 4040 | 146 |
476511 | 476511 | 2020-08-28 | Weld | Colorado | 8123 | 4029 | 146 |
473278 | 473278 | 2020-08-27 | Weld | Colorado | 8123 | 4001 | 146 |
470046 | 470046 | 2020-08-26 | Weld | Colorado | 8123 | 3979 | 146 |
466817 | 466817 | 2020-08-25 | Weld | Colorado | 8123 | 3965 | 146 |
463588 | 463588 | 2020-08-24 | Weld | Colorado | 8123 | 3956 | 146 |
460359 | 460359 | 2020-08-23 | Weld | Colorado | 8123 | 3938 | 146 |
457132 | 457132 | 2020-08-22 | Weld | Colorado | 8123 | 3919 | 146 |
453904 | 453904 | 2020-08-21 | Weld | Colorado | 8123 | 3896 | 145 |
450676 | 450676 | 2020-08-20 | Weld | Colorado | 8123 | 3887 | 145 |
447448 | 447448 | 2020-08-19 | Weld | Colorado | 8123 | 3865 | 145 |
444221 | 444221 | 2020-08-18 | Weld | Colorado | 8123 | 3861 | 145 |
440995 | 440995 | 2020-08-17 | Weld | Colorado | 8123 | 3844 | 145 |
437769 | 437769 | 2020-08-16 | Weld | Colorado | 8123 | 3825 | 145 |
434543 | 434543 | 2020-08-15 | Weld | Colorado | 8123 | 3801 | 145 |
431318 | 431318 | 2020-08-14 | Weld | Colorado | 8123 | 3800 | 145 |
428090 | 428090 | 2020-08-13 | Weld | Colorado | 8123 | 3787 | 145 |
424866 | 424866 | 2020-08-12 | Weld | Colorado | 8123 | 3763 | 145 |
421645 | 421645 | 2020-08-11 | Weld | Colorado | 8123 | 3743 | 145 |
418424 | 418424 | 2020-08-10 | Weld | Colorado | 8123 | 3743 | 145 |
415203 | 415203 | 2020-08-09 | Weld | Colorado | 8123 | 3709 | 143 |
411983 | 411983 | 2020-08-08 | Weld | Colorado | 8123 | 3696 | 143 |
408764 | 408764 | 2020-08-07 | Weld | Colorado | 8123 | 3680 | 142 |
405544 | 405544 | 2020-08-06 | Weld | Colorado | 8123 | 3635 | 142 |
402326 | 402326 | 2020-08-05 | Weld | Colorado | 8123 | 3627 | 142 |
399110 | 399110 | 2020-08-04 | Weld | Colorado | 8123 | 3597 | 142 |
395894 | 395894 | 2020-08-03 | Weld | Colorado | 8123 | 3578 | 141 |
392678 | 392678 | 2020-08-02 | Weld | Colorado | 8123 | 3546 | 141 |
389461 | 389461 | 2020-08-01 | Weld | Colorado | 8123 | 3525 | 141 |
386244 | 386244 | 2020-07-31 | Weld | Colorado | 8123 | 3523 | 141 |
383026 | 383026 | 2020-07-30 | Weld | Colorado | 8123 | 3491 | 141 |
379809 | 379809 | 2020-07-29 | Weld | Colorado | 8123 | 3478 | 141 |
376592 | 376592 | 2020-07-28 | Weld | Colorado | 8123 | 3462 | 139 |
373378 | 373378 | 2020-07-27 | Weld | Colorado | 8123 | 3448 | 139 |
370166 | 370166 | 2020-07-26 | Weld | Colorado | 8123 | 3408 | 139 |
366956 | 366956 | 2020-07-25 | Weld | Colorado | 8123 | 3386 | 139 |
363749 | 363749 | 2020-07-24 | Weld | Colorado | 8123 | 3353 | 139 |
360542 | 360542 | 2020-07-23 | Weld | Colorado | 8123 | 3345 | 139 |
357337 | 357337 | 2020-07-22 | Weld | Colorado | 8123 | 3308 | 139 |
354134 | 354134 | 2020-07-21 | Weld | Colorado | 8123 | 3281 | 139 |
350932 | 350932 | 2020-07-20 | Weld | Colorado | 8123 | 3257 | 139 |
347731 | 347731 | 2020-07-19 | Weld | Colorado | 8123 | 3210 | 139 |
344531 | 344531 | 2020-07-18 | Weld | Colorado | 8123 | 3189 | 139 |
341332 | 341332 | 2020-07-17 | Weld | Colorado | 8123 | 3184 | 139 |
338135 | 338135 | 2020-07-16 | Weld | Colorado | 8123 | 3155 | 139 |
334940 | 334940 | 2020-07-15 | Weld | Colorado | 8123 | 3105 | 138 |
331747 | 331747 | 2020-07-14 | Weld | Colorado | 8123 | 3070 | 138 |
328560 | 328560 | 2020-07-13 | Weld | Colorado | 8123 | 3041 | 138 |
325374 | 325374 | 2020-07-12 | Weld | Colorado | 8123 | 2999 | 138 |
322193 | 322193 | 2020-07-11 | Weld | Colorado | 8123 | 2988 | 138 |
319014 | 319014 | 2020-07-10 | Weld | Colorado | 8123 | 2987 | 138 |
315841 | 315841 | 2020-07-09 | Weld | Colorado | 8123 | 2961 | 138 |
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);