ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8101 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635180 | 635180 | 2020-10-16 | Pueblo | Colorado | 8101 | 1514 | 40 |
631934 | 631934 | 2020-10-15 | Pueblo | Colorado | 8101 | 1492 | 39 |
628690 | 628690 | 2020-10-14 | Pueblo | Colorado | 8101 | 1439 | 39 |
625447 | 625447 | 2020-10-13 | Pueblo | Colorado | 8101 | 1406 | 38 |
622204 | 622204 | 2020-10-12 | Pueblo | Colorado | 8101 | 1369 | 37 |
618961 | 618961 | 2020-10-11 | Pueblo | Colorado | 8101 | 1370 | 37 |
615719 | 615719 | 2020-10-10 | Pueblo | Colorado | 8101 | 1332 | 37 |
612478 | 612478 | 2020-10-09 | Pueblo | Colorado | 8101 | 1317 | 37 |
609236 | 609236 | 2020-10-08 | Pueblo | Colorado | 8101 | 1284 | 37 |
605993 | 605993 | 2020-10-07 | Pueblo | Colorado | 8101 | 1259 | 37 |
602751 | 602751 | 2020-10-06 | Pueblo | Colorado | 8101 | 1217 | 37 |
599508 | 599508 | 2020-10-05 | Pueblo | Colorado | 8101 | 1213 | 37 |
596265 | 596265 | 2020-10-04 | Pueblo | Colorado | 8101 | 1197 | 37 |
593023 | 593023 | 2020-10-03 | Pueblo | Colorado | 8101 | 1176 | 37 |
589783 | 589783 | 2020-10-02 | Pueblo | Colorado | 8101 | 1159 | 37 |
586542 | 586542 | 2020-10-01 | Pueblo | Colorado | 8101 | 1146 | 37 |
583302 | 583302 | 2020-09-30 | Pueblo | Colorado | 8101 | 1129 | 37 |
580063 | 580063 | 2020-09-29 | Pueblo | Colorado | 8101 | 1114 | 37 |
576822 | 576822 | 2020-09-28 | Pueblo | Colorado | 8101 | 1091 | 37 |
573579 | 573579 | 2020-09-27 | Pueblo | Colorado | 8101 | 1090 | 37 |
570337 | 570337 | 2020-09-26 | Pueblo | Colorado | 8101 | 1079 | 37 |
567095 | 567095 | 2020-09-25 | Pueblo | Colorado | 8101 | 1072 | 37 |
563855 | 563855 | 2020-09-24 | Pueblo | Colorado | 8101 | 1060 | 37 |
560615 | 560615 | 2020-09-23 | Pueblo | Colorado | 8101 | 1052 | 37 |
557379 | 557379 | 2020-09-22 | Pueblo | Colorado | 8101 | 1037 | 37 |
554142 | 554142 | 2020-09-21 | Pueblo | Colorado | 8101 | 1041 | 36 |
550903 | 550903 | 2020-09-20 | Pueblo | Colorado | 8101 | 1035 | 34 |
547664 | 547664 | 2020-09-19 | Pueblo | Colorado | 8101 | 1024 | 34 |
544426 | 544426 | 2020-09-18 | Pueblo | Colorado | 8101 | 1014 | 34 |
541190 | 541190 | 2020-09-17 | Pueblo | Colorado | 8101 | 1003 | 34 |
537953 | 537953 | 2020-09-16 | Pueblo | Colorado | 8101 | 1001 | 34 |
534717 | 534717 | 2020-09-15 | Pueblo | Colorado | 8101 | 989 | 34 |
531482 | 531482 | 2020-09-14 | Pueblo | Colorado | 8101 | 980 | 34 |
528245 | 528245 | 2020-09-13 | Pueblo | Colorado | 8101 | 974 | 34 |
525009 | 525009 | 2020-09-12 | Pueblo | Colorado | 8101 | 969 | 34 |
521773 | 521773 | 2020-09-11 | Pueblo | Colorado | 8101 | 965 | 34 |
518536 | 518536 | 2020-09-10 | Pueblo | Colorado | 8101 | 960 | 34 |
515301 | 515301 | 2020-09-09 | Pueblo | Colorado | 8101 | 951 | 34 |
512068 | 512068 | 2020-09-08 | Pueblo | Colorado | 8101 | 936 | 34 |
508835 | 508835 | 2020-09-07 | Pueblo | Colorado | 8101 | 929 | 34 |
505603 | 505603 | 2020-09-06 | Pueblo | Colorado | 8101 | 928 | 34 |
502369 | 502369 | 2020-09-05 | Pueblo | Colorado | 8101 | 920 | 34 |
499135 | 499135 | 2020-09-04 | Pueblo | Colorado | 8101 | 905 | 34 |
495902 | 495902 | 2020-09-03 | Pueblo | Colorado | 8101 | 895 | 34 |
492668 | 492668 | 2020-09-02 | Pueblo | Colorado | 8101 | 886 | 34 |
489435 | 489435 | 2020-09-01 | Pueblo | Colorado | 8101 | 875 | 34 |
486202 | 486202 | 2020-08-31 | Pueblo | Colorado | 8101 | 868 | 34 |
482967 | 482967 | 2020-08-30 | Pueblo | Colorado | 8101 | 866 | 34 |
479733 | 479733 | 2020-08-29 | Pueblo | Colorado | 8101 | 865 | 34 |
476500 | 476500 | 2020-08-28 | Pueblo | Colorado | 8101 | 859 | 34 |
473267 | 473267 | 2020-08-27 | Pueblo | Colorado | 8101 | 841 | 34 |
470035 | 470035 | 2020-08-26 | Pueblo | Colorado | 8101 | 821 | 34 |
466806 | 466806 | 2020-08-25 | Pueblo | Colorado | 8101 | 806 | 34 |
463577 | 463577 | 2020-08-24 | Pueblo | Colorado | 8101 | 802 | 34 |
460348 | 460348 | 2020-08-23 | Pueblo | Colorado | 8101 | 798 | 34 |
457121 | 457121 | 2020-08-22 | Pueblo | Colorado | 8101 | 798 | 34 |
453893 | 453893 | 2020-08-21 | Pueblo | Colorado | 8101 | 789 | 34 |
450665 | 450665 | 2020-08-20 | Pueblo | Colorado | 8101 | 779 | 34 |
447437 | 447437 | 2020-08-19 | Pueblo | Colorado | 8101 | 770 | 34 |
444210 | 444210 | 2020-08-18 | Pueblo | Colorado | 8101 | 760 | 34 |
440984 | 440984 | 2020-08-17 | Pueblo | Colorado | 8101 | 757 | 34 |
437758 | 437758 | 2020-08-16 | Pueblo | Colorado | 8101 | 754 | 34 |
434532 | 434532 | 2020-08-15 | Pueblo | Colorado | 8101 | 750 | 34 |
431307 | 431307 | 2020-08-14 | Pueblo | Colorado | 8101 | 729 | 34 |
428079 | 428079 | 2020-08-13 | Pueblo | Colorado | 8101 | 723 | 34 |
424855 | 424855 | 2020-08-12 | Pueblo | Colorado | 8101 | 711 | 34 |
421634 | 421634 | 2020-08-11 | Pueblo | Colorado | 8101 | 709 | 34 |
418413 | 418413 | 2020-08-10 | Pueblo | Colorado | 8101 | 699 | 34 |
415192 | 415192 | 2020-08-09 | Pueblo | Colorado | 8101 | 693 | 34 |
411972 | 411972 | 2020-08-08 | Pueblo | Colorado | 8101 | 687 | 34 |
408753 | 408753 | 2020-08-07 | Pueblo | Colorado | 8101 | 674 | 34 |
405533 | 405533 | 2020-08-06 | Pueblo | Colorado | 8101 | 660 | 34 |
402315 | 402315 | 2020-08-05 | Pueblo | Colorado | 8101 | 645 | 34 |
399099 | 399099 | 2020-08-04 | Pueblo | Colorado | 8101 | 617 | 34 |
395883 | 395883 | 2020-08-03 | Pueblo | Colorado | 8101 | 615 | 34 |
392667 | 392667 | 2020-08-02 | Pueblo | Colorado | 8101 | 613 | 34 |
389450 | 389450 | 2020-08-01 | Pueblo | Colorado | 8101 | 611 | 34 |
386233 | 386233 | 2020-07-31 | Pueblo | Colorado | 8101 | 597 | 34 |
383015 | 383015 | 2020-07-30 | Pueblo | Colorado | 8101 | 590 | 34 |
379798 | 379798 | 2020-07-29 | Pueblo | Colorado | 8101 | 577 | 34 |
376581 | 376581 | 2020-07-28 | Pueblo | Colorado | 8101 | 575 | 34 |
373367 | 373367 | 2020-07-27 | Pueblo | Colorado | 8101 | 563 | 34 |
370155 | 370155 | 2020-07-26 | Pueblo | Colorado | 8101 | 559 | 33 |
366945 | 366945 | 2020-07-25 | Pueblo | Colorado | 8101 | 552 | 33 |
363738 | 363738 | 2020-07-24 | Pueblo | Colorado | 8101 | 548 | 33 |
360531 | 360531 | 2020-07-23 | Pueblo | Colorado | 8101 | 538 | 33 |
357326 | 357326 | 2020-07-22 | Pueblo | Colorado | 8101 | 535 | 33 |
354123 | 354123 | 2020-07-21 | Pueblo | Colorado | 8101 | 524 | 33 |
350921 | 350921 | 2020-07-20 | Pueblo | Colorado | 8101 | 502 | 32 |
347720 | 347720 | 2020-07-19 | Pueblo | Colorado | 8101 | 483 | 32 |
344520 | 344520 | 2020-07-18 | Pueblo | Colorado | 8101 | 482 | 32 |
341321 | 341321 | 2020-07-17 | Pueblo | Colorado | 8101 | 479 | 32 |
338124 | 338124 | 2020-07-16 | Pueblo | Colorado | 8101 | 469 | 32 |
334929 | 334929 | 2020-07-15 | Pueblo | Colorado | 8101 | 458 | 32 |
331736 | 331736 | 2020-07-14 | Pueblo | Colorado | 8101 | 450 | 32 |
328550 | 328550 | 2020-07-13 | Pueblo | Colorado | 8101 | 444 | 31 |
325364 | 325364 | 2020-07-12 | Pueblo | Colorado | 8101 | 432 | 31 |
322183 | 322183 | 2020-07-11 | Pueblo | Colorado | 8101 | 430 | 31 |
319004 | 319004 | 2020-07-10 | Pueblo | Colorado | 8101 | 422 | 31 |
315831 | 315831 | 2020-07-09 | Pueblo | Colorado | 8101 | 417 | 30 |
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);