ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 6057 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917407 | 917407 | 2021-01-11 | Nevada | California | 6057 | 2978 | 70 |
914162 | 914162 | 2021-01-10 | Nevada | California | 6057 | 2932 | 50 |
910917 | 910917 | 2021-01-09 | Nevada | California | 6057 | 2888 | 50 |
907672 | 907672 | 2021-01-08 | Nevada | California | 6057 | 2888 | 50 |
904426 | 904426 | 2021-01-07 | Nevada | California | 6057 | 2854 | 50 |
901181 | 901181 | 2021-01-06 | Nevada | California | 6057 | 2808 | 50 |
897936 | 897936 | 2021-01-05 | Nevada | California | 6057 | 2774 | 50 |
894691 | 894691 | 2021-01-04 | Nevada | California | 6057 | 2742 | 50 |
891444 | 891444 | 2021-01-03 | Nevada | California | 6057 | 2706 | 50 |
888197 | 888197 | 2021-01-02 | Nevada | California | 6057 | 2663 | 50 |
884952 | 884952 | 2021-01-01 | Nevada | California | 6057 | 2619 | 50 |
881707 | 881707 | 2020-12-31 | Nevada | California | 6057 | 2609 | 50 |
878462 | 878462 | 2020-12-30 | Nevada | California | 6057 | 2565 | 50 |
875217 | 875217 | 2020-12-29 | Nevada | California | 6057 | 2548 | 50 |
871972 | 871972 | 2020-12-28 | Nevada | California | 6057 | 2519 | 49 |
868727 | 868727 | 2020-12-27 | Nevada | California | 6057 | 2480 | 44 |
865482 | 865482 | 2020-12-26 | Nevada | California | 6057 | 2458 | 44 |
862237 | 862237 | 2020-12-25 | Nevada | California | 6057 | 2429 | 44 |
858992 | 858992 | 2020-12-24 | Nevada | California | 6057 | 2415 | 44 |
855747 | 855747 | 2020-12-23 | Nevada | California | 6057 | 2388 | 44 |
852502 | 852502 | 2020-12-22 | Nevada | California | 6057 | 2361 | 42 |
849257 | 849257 | 2020-12-21 | Nevada | California | 6057 | 2327 | 42 |
846012 | 846012 | 2020-12-20 | Nevada | California | 6057 | 2260 | 39 |
842766 | 842766 | 2020-12-19 | Nevada | California | 6057 | 2220 | 39 |
839521 | 839521 | 2020-12-18 | Nevada | California | 6057 | 2203 | 39 |
836276 | 836276 | 2020-12-17 | Nevada | California | 6057 | 2173 | 38 |
833030 | 833030 | 2020-12-16 | Nevada | California | 6057 | 2149 | 34 |
829783 | 829783 | 2020-12-15 | Nevada | California | 6057 | 2123 | 32 |
826537 | 826537 | 2020-12-14 | Nevada | California | 6057 | 2067 | 30 |
823290 | 823290 | 2020-12-13 | Nevada | California | 6057 | 1981 | 21 |
820044 | 820044 | 2020-12-12 | Nevada | California | 6057 | 1962 | 21 |
816798 | 816798 | 2020-12-11 | Nevada | California | 6057 | 1962 | 21 |
813552 | 813552 | 2020-12-10 | Nevada | California | 6057 | 1922 | 21 |
810308 | 810308 | 2020-12-09 | Nevada | California | 6057 | 1895 | 19 |
807063 | 807063 | 2020-12-08 | Nevada | California | 6057 | 1811 | 19 |
803818 | 803818 | 2020-12-07 | Nevada | California | 6057 | 1776 | 17 |
800573 | 800573 | 2020-12-06 | Nevada | California | 6057 | 1642 | 16 |
797328 | 797328 | 2020-12-05 | Nevada | California | 6057 | 1569 | 16 |
794083 | 794083 | 2020-12-04 | Nevada | California | 6057 | 1569 | 16 |
790838 | 790838 | 2020-12-03 | Nevada | California | 6057 | 1517 | 15 |
787593 | 787593 | 2020-12-02 | Nevada | California | 6057 | 1455 | 10 |
784349 | 784349 | 2020-12-01 | Nevada | California | 6057 | 1414 | 10 |
781104 | 781104 | 2020-11-30 | Nevada | California | 6057 | 1348 | 9 |
777858 | 777858 | 2020-11-29 | Nevada | California | 6057 | 1272 | 9 |
774613 | 774613 | 2020-11-28 | Nevada | California | 6057 | 1184 | 9 |
771368 | 771368 | 2020-11-27 | Nevada | California | 6057 | 1184 | 9 |
768123 | 768123 | 2020-11-26 | Nevada | California | 6057 | 1183 | 9 |
764877 | 764877 | 2020-11-25 | Nevada | California | 6057 | 1183 | 9 |
761632 | 761632 | 2020-11-24 | Nevada | California | 6057 | 1163 | 9 |
758387 | 758387 | 2020-11-23 | Nevada | California | 6057 | 1131 | 9 |
755140 | 755140 | 2020-11-22 | Nevada | California | 6057 | 1018 | 9 |
751894 | 751894 | 2020-11-21 | Nevada | California | 6057 | 1015 | 9 |
748648 | 748648 | 2020-11-20 | Nevada | California | 6057 | 1015 | 9 |
745402 | 745402 | 2020-11-19 | Nevada | California | 6057 | 948 | 9 |
742155 | 742155 | 2020-11-18 | Nevada | California | 6057 | 934 | 9 |
738908 | 738908 | 2020-11-17 | Nevada | California | 6057 | 929 | 9 |
735664 | 735664 | 2020-11-16 | Nevada | California | 6057 | 901 | 9 |
732418 | 732418 | 2020-11-15 | Nevada | California | 6057 | 835 | 9 |
729173 | 729173 | 2020-11-14 | Nevada | California | 6057 | 822 | 9 |
725930 | 725930 | 2020-11-13 | Nevada | California | 6057 | 822 | 9 |
722687 | 722687 | 2020-11-12 | Nevada | California | 6057 | 779 | 9 |
719444 | 719444 | 2020-11-11 | Nevada | California | 6057 | 734 | 9 |
716201 | 716201 | 2020-11-10 | Nevada | California | 6057 | 733 | 9 |
712957 | 712957 | 2020-11-09 | Nevada | California | 6057 | 726 | 9 |
709713 | 709713 | 2020-11-08 | Nevada | California | 6057 | 702 | 9 |
706469 | 706469 | 2020-11-07 | Nevada | California | 6057 | 699 | 9 |
703226 | 703226 | 2020-11-06 | Nevada | California | 6057 | 699 | 9 |
699983 | 699983 | 2020-11-05 | Nevada | California | 6057 | 688 | 9 |
696739 | 696739 | 2020-11-04 | Nevada | California | 6057 | 681 | 9 |
693497 | 693497 | 2020-11-03 | Nevada | California | 6057 | 672 | 9 |
690254 | 690254 | 2020-11-02 | Nevada | California | 6057 | 664 | 9 |
687009 | 687009 | 2020-11-01 | Nevada | California | 6057 | 644 | 9 |
683765 | 683765 | 2020-10-31 | Nevada | California | 6057 | 642 | 9 |
680522 | 680522 | 2020-10-30 | Nevada | California | 6057 | 642 | 9 |
677279 | 677279 | 2020-10-29 | Nevada | California | 6057 | 635 | 8 |
674036 | 674036 | 2020-10-28 | Nevada | California | 6057 | 632 | 8 |
670794 | 670794 | 2020-10-27 | Nevada | California | 6057 | 628 | 8 |
667551 | 667551 | 2020-10-26 | Nevada | California | 6057 | 623 | 8 |
664306 | 664306 | 2020-10-25 | Nevada | California | 6057 | 608 | 8 |
661062 | 661062 | 2020-10-24 | Nevada | California | 6057 | 608 | 8 |
657818 | 657818 | 2020-10-23 | Nevada | California | 6057 | 608 | 8 |
654573 | 654573 | 2020-10-22 | Nevada | California | 6057 | 603 | 8 |
651328 | 651328 | 2020-10-21 | Nevada | California | 6057 | 601 | 8 |
648084 | 648084 | 2020-10-20 | Nevada | California | 6057 | 598 | 8 |
644839 | 644839 | 2020-10-19 | Nevada | California | 6057 | 590 | 8 |
641591 | 641591 | 2020-10-18 | Nevada | California | 6057 | 581 | 8 |
638344 | 638344 | 2020-10-17 | Nevada | California | 6057 | 581 | 8 |
635099 | 635099 | 2020-10-16 | Nevada | California | 6057 | 581 | 8 |
631853 | 631853 | 2020-10-15 | Nevada | California | 6057 | 579 | 8 |
628609 | 628609 | 2020-10-14 | Nevada | California | 6057 | 576 | 8 |
625366 | 625366 | 2020-10-13 | Nevada | California | 6057 | 573 | 8 |
622123 | 622123 | 2020-10-12 | Nevada | California | 6057 | 569 | 8 |
618880 | 618880 | 2020-10-11 | Nevada | California | 6057 | 564 | 8 |
615638 | 615638 | 2020-10-10 | Nevada | California | 6057 | 562 | 8 |
612397 | 612397 | 2020-10-09 | Nevada | California | 6057 | 562 | 8 |
609155 | 609155 | 2020-10-08 | Nevada | California | 6057 | 557 | 8 |
605912 | 605912 | 2020-10-07 | Nevada | California | 6057 | 554 | 7 |
602670 | 602670 | 2020-10-06 | Nevada | California | 6057 | 553 | 7 |
599427 | 599427 | 2020-10-05 | Nevada | California | 6057 | 550 | 7 |
596184 | 596184 | 2020-10-04 | Nevada | California | 6057 | 544 | 7 |
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);