ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6019 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
910898 | 910898 | 2021-01-09 | Fresno | California | 6019 | 73689 | 711 |
907653 | 907653 | 2021-01-08 | Fresno | California | 6019 | 72557 | 711 |
904407 | 904407 | 2021-01-07 | Fresno | California | 6019 | 71404 | 711 |
901162 | 901162 | 2021-01-06 | Fresno | California | 6019 | 70971 | 711 |
897917 | 897917 | 2021-01-05 | Fresno | California | 6019 | 69871 | 711 |
894672 | 894672 | 2021-01-04 | Fresno | California | 6019 | 69318 | 711 |
891425 | 891425 | 2021-01-03 | Fresno | California | 6019 | 68740 | 711 |
888178 | 888178 | 2021-01-02 | Fresno | California | 6019 | 67484 | 711 |
884933 | 884933 | 2021-01-01 | Fresno | California | 6019 | 66442 | 646 |
881688 | 881688 | 2020-12-31 | Fresno | California | 6019 | 65400 | 646 |
878443 | 878443 | 2020-12-30 | Fresno | California | 6019 | 65149 | 646 |
875198 | 875198 | 2020-12-29 | Fresno | California | 6019 | 64274 | 646 |
871953 | 871953 | 2020-12-28 | Fresno | California | 6019 | 63811 | 646 |
868708 | 868708 | 2020-12-27 | Fresno | California | 6019 | 63080 | 646 |
865463 | 865463 | 2020-12-26 | Fresno | California | 6019 | 62251 | 646 |
862218 | 862218 | 2020-12-25 | Fresno | California | 6019 | 61435 | 646 |
858973 | 858973 | 2020-12-24 | Fresno | California | 6019 | 60488 | 646 |
855728 | 855728 | 2020-12-23 | Fresno | California | 6019 | 59640 | 646 |
852483 | 852483 | 2020-12-22 | Fresno | California | 6019 | 58568 | 617 |
849238 | 849238 | 2020-12-21 | Fresno | California | 6019 | 57616 | 617 |
845993 | 845993 | 2020-12-20 | Fresno | California | 6019 | 55428 | 617 |
842747 | 842747 | 2020-12-19 | Fresno | California | 6019 | 52643 | 617 |
839502 | 839502 | 2020-12-18 | Fresno | California | 6019 | 49918 | 617 |
836257 | 836257 | 2020-12-17 | Fresno | California | 6019 | 49173 | 557 |
833011 | 833011 | 2020-12-16 | Fresno | California | 6019 | 47316 | 557 |
829764 | 829764 | 2020-12-15 | Fresno | California | 6019 | 44726 | 557 |
826518 | 826518 | 2020-12-14 | Fresno | California | 6019 | 44114 | 542 |
823271 | 823271 | 2020-12-13 | Fresno | California | 6019 | 43756 | 542 |
820025 | 820025 | 2020-12-12 | Fresno | California | 6019 | 43071 | 542 |
816779 | 816779 | 2020-12-11 | Fresno | California | 6019 | 42788 | 542 |
813533 | 813533 | 2020-12-10 | Fresno | California | 6019 | 41954 | 514 |
810289 | 810289 | 2020-12-09 | Fresno | California | 6019 | 41574 | 514 |
807044 | 807044 | 2020-12-08 | Fresno | California | 6019 | 41460 | 514 |
803799 | 803799 | 2020-12-07 | Fresno | California | 6019 | 40869 | 506 |
800554 | 800554 | 2020-12-06 | Fresno | California | 6019 | 40568 | 506 |
797309 | 797309 | 2020-12-05 | Fresno | California | 6019 | 40108 | 506 |
794064 | 794064 | 2020-12-04 | Fresno | California | 6019 | 40033 | 506 |
790819 | 790819 | 2020-12-03 | Fresno | California | 6019 | 39324 | 488 |
787574 | 787574 | 2020-12-02 | Fresno | California | 6019 | 39004 | 488 |
784330 | 784330 | 2020-12-01 | Fresno | California | 6019 | 38956 | 488 |
781085 | 781085 | 2020-11-30 | Fresno | California | 6019 | 38568 | 481 |
777839 | 777839 | 2020-11-29 | Fresno | California | 6019 | 38288 | 481 |
774594 | 774594 | 2020-11-28 | Fresno | California | 6019 | 37994 | 481 |
771349 | 771349 | 2020-11-27 | Fresno | California | 6019 | 37947 | 481 |
768104 | 768104 | 2020-11-26 | Fresno | California | 6019 | 37349 | 477 |
764858 | 764858 | 2020-11-25 | Fresno | California | 6019 | 37063 | 477 |
761613 | 761613 | 2020-11-24 | Fresno | California | 6019 | 37063 | 477 |
758368 | 758368 | 2020-11-23 | Fresno | California | 6019 | 36315 | 471 |
755121 | 755121 | 2020-11-22 | Fresno | California | 6019 | 35973 | 471 |
751875 | 751875 | 2020-11-21 | Fresno | California | 6019 | 35711 | 471 |
748629 | 748629 | 2020-11-20 | Fresno | California | 6019 | 35711 | 471 |
745383 | 745383 | 2020-11-19 | Fresno | California | 6019 | 34997 | 463 |
742136 | 742136 | 2020-11-18 | Fresno | California | 6019 | 34858 | 463 |
738889 | 738889 | 2020-11-17 | Fresno | California | 6019 | 34858 | 463 |
735645 | 735645 | 2020-11-16 | Fresno | California | 6019 | 34297 | 460 |
732399 | 732399 | 2020-11-15 | Fresno | California | 6019 | 33969 | 460 |
729154 | 729154 | 2020-11-14 | Fresno | California | 6019 | 33809 | 460 |
725911 | 725911 | 2020-11-13 | Fresno | California | 6019 | 33809 | 460 |
722668 | 722668 | 2020-11-12 | Fresno | California | 6019 | 33287 | 456 |
719425 | 719425 | 2020-11-11 | Fresno | California | 6019 | 33162 | 456 |
716182 | 716182 | 2020-11-10 | Fresno | California | 6019 | 33162 | 456 |
712938 | 712938 | 2020-11-09 | Fresno | California | 6019 | 32619 | 454 |
709694 | 709694 | 2020-11-08 | Fresno | California | 6019 | 32497 | 454 |
706450 | 706450 | 2020-11-07 | Fresno | California | 6019 | 32430 | 454 |
703207 | 703207 | 2020-11-06 | Fresno | California | 6019 | 32430 | 454 |
699964 | 699964 | 2020-11-05 | Fresno | California | 6019 | 32022 | 447 |
696720 | 696720 | 2020-11-04 | Fresno | California | 6019 | 32022 | 447 |
693478 | 693478 | 2020-11-03 | Fresno | California | 6019 | 32022 | 447 |
690235 | 690235 | 2020-11-02 | Fresno | California | 6019 | 31613 | 443 |
686990 | 686990 | 2020-11-01 | Fresno | California | 6019 | 31594 | 443 |
683746 | 683746 | 2020-10-31 | Fresno | California | 6019 | 31594 | 443 |
680503 | 680503 | 2020-10-30 | Fresno | California | 6019 | 31594 | 443 |
677260 | 677260 | 2020-10-29 | Fresno | California | 6019 | 31251 | 439 |
674017 | 674017 | 2020-10-28 | Fresno | California | 6019 | 31251 | 439 |
670775 | 670775 | 2020-10-27 | Fresno | California | 6019 | 31251 | 439 |
667532 | 667532 | 2020-10-26 | Fresno | California | 6019 | 30858 | 436 |
664287 | 664287 | 2020-10-25 | Fresno | California | 6019 | 30752 | 436 |
661043 | 661043 | 2020-10-24 | Fresno | California | 6019 | 30731 | 436 |
657799 | 657799 | 2020-10-23 | Fresno | California | 6019 | 30731 | 436 |
654554 | 654554 | 2020-10-22 | Fresno | California | 6019 | 30328 | 430 |
651309 | 651309 | 2020-10-21 | Fresno | California | 6019 | 30220 | 430 |
648065 | 648065 | 2020-10-20 | Fresno | California | 6019 | 30194 | 430 |
644820 | 644820 | 2020-10-19 | Fresno | California | 6019 | 30051 | 429 |
641572 | 641572 | 2020-10-18 | Fresno | California | 6019 | 29911 | 429 |
638325 | 638325 | 2020-10-17 | Fresno | California | 6019 | 29796 | 429 |
635080 | 635080 | 2020-10-16 | Fresno | California | 6019 | 29727 | 429 |
631834 | 631834 | 2020-10-15 | Fresno | California | 6019 | 29650 | 424 |
628590 | 628590 | 2020-10-14 | Fresno | California | 6019 | 29579 | 424 |
625347 | 625347 | 2020-10-13 | Fresno | California | 6019 | 29523 | 424 |
622104 | 622104 | 2020-10-12 | Fresno | California | 6019 | 29419 | 406 |
618861 | 618861 | 2020-10-11 | Fresno | California | 6019 | 29286 | 406 |
615619 | 615619 | 2020-10-10 | Fresno | California | 6019 | 29208 | 406 |
612378 | 612378 | 2020-10-09 | Fresno | California | 6019 | 29111 | 406 |
609136 | 609136 | 2020-10-08 | Fresno | California | 6019 | 29069 | 406 |
605893 | 605893 | 2020-10-07 | Fresno | California | 6019 | 29022 | 406 |
602651 | 602651 | 2020-10-06 | Fresno | California | 6019 | 29136 | 406 |
599408 | 599408 | 2020-10-05 | Fresno | California | 6019 | 29065 | 399 |
596165 | 596165 | 2020-10-04 | Fresno | California | 6019 | 28975 | 399 |
592923 | 592923 | 2020-10-03 | Fresno | California | 6019 | 28855 | 399 |
589683 | 589683 | 2020-10-02 | Fresno | California | 6019 | 28796 | 399 |
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);