ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Jefferson" and fips = 8059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946675 | 946675 | 2021-01-20 | Jefferson | Colorado | 8059 | 33216 | 671 |
943428 | 943428 | 2021-01-19 | Jefferson | Colorado | 8059 | 33123 | 660 |
940183 | 940183 | 2021-01-18 | Jefferson | Colorado | 8059 | 32952 | 661 |
936938 | 936938 | 2021-01-17 | Jefferson | Colorado | 8059 | 32832 | 660 |
933693 | 933693 | 2021-01-16 | Jefferson | Colorado | 8059 | 32728 | 659 |
930448 | 930448 | 2021-01-15 | Jefferson | Colorado | 8059 | 32613 | 660 |
927203 | 927203 | 2021-01-14 | Jefferson | Colorado | 8059 | 32441 | 658 |
923957 | 923957 | 2021-01-13 | Jefferson | Colorado | 8059 | 32191 | 655 |
920712 | 920712 | 2021-01-12 | Jefferson | Colorado | 8059 | 31950 | 651 |
917467 | 917467 | 2021-01-11 | Jefferson | Colorado | 8059 | 31837 | 648 |
914222 | 914222 | 2021-01-10 | Jefferson | Colorado | 8059 | 31685 | 648 |
910977 | 910977 | 2021-01-09 | Jefferson | Colorado | 8059 | 31516 | 646 |
907732 | 907732 | 2021-01-08 | Jefferson | Colorado | 8059 | 31305 | 644 |
904486 | 904486 | 2021-01-07 | Jefferson | Colorado | 8059 | 31096 | 639 |
901241 | 901241 | 2021-01-06 | Jefferson | Colorado | 8059 | 30649 | 634 |
897996 | 897996 | 2021-01-05 | Jefferson | Colorado | 8059 | 30649 | 634 |
894751 | 894751 | 2021-01-04 | Jefferson | Colorado | 8059 | 30268 | 620 |
891504 | 891504 | 2021-01-03 | Jefferson | Colorado | 8059 | 30122 | 620 |
888257 | 888257 | 2021-01-02 | Jefferson | Colorado | 8059 | 29915 | 620 |
885012 | 885012 | 2021-01-01 | Jefferson | Colorado | 8059 | 29776 | 617 |
881767 | 881767 | 2020-12-31 | Jefferson | Colorado | 8059 | 29565 | 612 |
878522 | 878522 | 2020-12-30 | Jefferson | Colorado | 8059 | 29295 | 609 |
875277 | 875277 | 2020-12-29 | Jefferson | Colorado | 8059 | 29109 | 606 |
872032 | 872032 | 2020-12-28 | Jefferson | Colorado | 8059 | 28964 | 597 |
868787 | 868787 | 2020-12-27 | Jefferson | Colorado | 8059 | 28828 | 596 |
865542 | 865542 | 2020-12-26 | Jefferson | Colorado | 8059 | 28695 | 595 |
862297 | 862297 | 2020-12-25 | Jefferson | Colorado | 8059 | 28559 | 594 |
859052 | 859052 | 2020-12-24 | Jefferson | Colorado | 8059 | 28357 | 591 |
855807 | 855807 | 2020-12-23 | Jefferson | Colorado | 8059 | 28098 | 577 |
852562 | 852562 | 2020-12-22 | Jefferson | Colorado | 8059 | 27885 | 573 |
849317 | 849317 | 2020-12-21 | Jefferson | Colorado | 8059 | 27673 | 590 |
846072 | 846072 | 2020-12-20 | Jefferson | Colorado | 8059 | 27481 | 589 |
842826 | 842826 | 2020-12-19 | Jefferson | Colorado | 8059 | 27254 | 588 |
839581 | 839581 | 2020-12-18 | Jefferson | Colorado | 8059 | 27074 | 581 |
836336 | 836336 | 2020-12-17 | Jefferson | Colorado | 8059 | 26831 | 593 |
833090 | 833090 | 2020-12-16 | Jefferson | Colorado | 8059 | 26471 | 585 |
829843 | 829843 | 2020-12-15 | Jefferson | Colorado | 8059 | 26117 | 572 |
826597 | 826597 | 2020-12-14 | Jefferson | Colorado | 8059 | 25748 | 552 |
823350 | 823350 | 2020-12-13 | Jefferson | Colorado | 8059 | 25748 | 552 |
820104 | 820104 | 2020-12-12 | Jefferson | Colorado | 8059 | 25496 | 544 |
816858 | 816858 | 2020-12-11 | Jefferson | Colorado | 8059 | 25137 | 543 |
813612 | 813612 | 2020-12-10 | Jefferson | Colorado | 8059 | 24779 | 538 |
810368 | 810368 | 2020-12-09 | Jefferson | Colorado | 8059 | 24443 | 525 |
807123 | 807123 | 2020-12-08 | Jefferson | Colorado | 8059 | 24203 | 494 |
803878 | 803878 | 2020-12-07 | Jefferson | Colorado | 8059 | 23842 | 494 |
800633 | 800633 | 2020-12-06 | Jefferson | Colorado | 8059 | 23132 | 494 |
797388 | 797388 | 2020-12-05 | Jefferson | Colorado | 8059 | 22830 | 494 |
794143 | 794143 | 2020-12-04 | Jefferson | Colorado | 8059 | 22352 | 493 |
790898 | 790898 | 2020-12-03 | Jefferson | Colorado | 8059 | 21922 | 490 |
787653 | 787653 | 2020-12-02 | Jefferson | Colorado | 8059 | 21476 | 477 |
784409 | 784409 | 2020-12-01 | Jefferson | Colorado | 8059 | 21156 | 455 |
781164 | 781164 | 2020-11-30 | Jefferson | Colorado | 8059 | 20710 | 440 |
777918 | 777918 | 2020-11-29 | Jefferson | Colorado | 8059 | 20358 | 440 |
774673 | 774673 | 2020-11-28 | Jefferson | Colorado | 8059 | 20106 | 439 |
771428 | 771428 | 2020-11-27 | Jefferson | Colorado | 8059 | 19704 | 436 |
768183 | 768183 | 2020-11-26 | Jefferson | Colorado | 8059 | 19348 | 433 |
764937 | 764937 | 2020-11-25 | Jefferson | Colorado | 8059 | 18779 | 427 |
761692 | 761692 | 2020-11-24 | Jefferson | Colorado | 8059 | 18369 | 425 |
758447 | 758447 | 2020-11-23 | Jefferson | Colorado | 8059 | 18001 | 416 |
755200 | 755200 | 2020-11-22 | Jefferson | Colorado | 8059 | 17684 | 415 |
751954 | 751954 | 2020-11-21 | Jefferson | Colorado | 8059 | 17333 | 412 |
748708 | 748708 | 2020-11-20 | Jefferson | Colorado | 8059 | 16811 | 408 |
745462 | 745462 | 2020-11-19 | Jefferson | Colorado | 8059 | 16299 | 404 |
742215 | 742215 | 2020-11-18 | Jefferson | Colorado | 8059 | 15717 | 393 |
738968 | 738968 | 2020-11-17 | Jefferson | Colorado | 8059 | 15287 | 388 |
735724 | 735724 | 2020-11-16 | Jefferson | Colorado | 8059 | 14876 | 384 |
732478 | 732478 | 2020-11-15 | Jefferson | Colorado | 8059 | 14580 | 383 |
729233 | 729233 | 2020-11-14 | Jefferson | Colorado | 8059 | 14159 | 374 |
725990 | 725990 | 2020-11-13 | Jefferson | Colorado | 8059 | 13667 | 372 |
722747 | 722747 | 2020-11-12 | Jefferson | Colorado | 8059 | 13145 | 361 |
719504 | 719504 | 2020-11-11 | Jefferson | Colorado | 8059 | 12664 | 355 |
716261 | 716261 | 2020-11-10 | Jefferson | Colorado | 8059 | 12300 | 356 |
713017 | 713017 | 2020-11-09 | Jefferson | Colorado | 8059 | 11918 | 347 |
709773 | 709773 | 2020-11-08 | Jefferson | Colorado | 8059 | 11562 | 346 |
706529 | 706529 | 2020-11-07 | Jefferson | Colorado | 8059 | 11268 | 345 |
703286 | 703286 | 2020-11-06 | Jefferson | Colorado | 8059 | 10944 | 343 |
700043 | 700043 | 2020-11-05 | Jefferson | Colorado | 8059 | 10607 | 336 |
696799 | 696799 | 2020-11-04 | Jefferson | Colorado | 8059 | 10298 | 334 |
693557 | 693557 | 2020-11-03 | Jefferson | Colorado | 8059 | 10018 | 327 |
690314 | 690314 | 2020-11-02 | Jefferson | Colorado | 8059 | 9779 | 319 |
687069 | 687069 | 2020-11-01 | Jefferson | Colorado | 8059 | 9533 | 319 |
683825 | 683825 | 2020-10-31 | Jefferson | Colorado | 8059 | 9303 | 318 |
680582 | 680582 | 2020-10-30 | Jefferson | Colorado | 8059 | 9007 | 317 |
677339 | 677339 | 2020-10-29 | Jefferson | Colorado | 8059 | 8783 | 314 |
674096 | 674096 | 2020-10-28 | Jefferson | Colorado | 8059 | 8608 | 311 |
670854 | 670854 | 2020-10-27 | Jefferson | Colorado | 8059 | 8464 | 309 |
667611 | 667611 | 2020-10-26 | Jefferson | Colorado | 8059 | 8333 | 307 |
664366 | 664366 | 2020-10-25 | Jefferson | Colorado | 8059 | 8071 | 307 |
661122 | 661122 | 2020-10-24 | Jefferson | Colorado | 8059 | 7903 | 307 |
657878 | 657878 | 2020-10-23 | Jefferson | Colorado | 8059 | 7721 | 305 |
654633 | 654633 | 2020-10-22 | Jefferson | Colorado | 8059 | 7599 | 301 |
651388 | 651388 | 2020-10-21 | Jefferson | Colorado | 8059 | 7492 | 301 |
648144 | 648144 | 2020-10-20 | Jefferson | Colorado | 8059 | 7404 | 299 |
644899 | 644899 | 2020-10-19 | Jefferson | Colorado | 8059 | 7252 | 299 |
641651 | 641651 | 2020-10-18 | Jefferson | Colorado | 8059 | 7168 | 299 |
638404 | 638404 | 2020-10-17 | Jefferson | Colorado | 8059 | 7076 | 299 |
635159 | 635159 | 2020-10-16 | Jefferson | Colorado | 8059 | 6991 | 298 |
631913 | 631913 | 2020-10-15 | Jefferson | Colorado | 8059 | 6887 | 296 |
628669 | 628669 | 2020-10-14 | Jefferson | Colorado | 8059 | 6806 | 296 |
625426 | 625426 | 2020-10-13 | Jefferson | Colorado | 8059 | 6754 | 295 |
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);