ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Nevada" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053720 | 1053720 | 2021-02-22 | Nevada | California | 6057 | 3899 | 74 |
1050473 | 1050473 | 2021-02-21 | Nevada | California | 6057 | 3887 | 74 |
1047226 | 1047226 | 2021-02-20 | Nevada | California | 6057 | 3863 | 74 |
1043981 | 1043981 | 2021-02-19 | Nevada | California | 6057 | 3852 | 74 |
1040736 | 1040736 | 2021-02-18 | Nevada | California | 6057 | 3832 | 74 |
1037491 | 1037491 | 2021-02-17 | Nevada | California | 6057 | 3813 | 74 |
1034246 | 1034246 | 2021-02-16 | Nevada | California | 6057 | 3774 | 74 |
1031000 | 1031000 | 2021-02-15 | Nevada | California | 6057 | 3761 | 74 |
1027753 | 1027753 | 2021-02-14 | Nevada | California | 6057 | 3742 | 74 |
1024508 | 1024508 | 2021-02-13 | Nevada | California | 6057 | 3729 | 74 |
1021263 | 1021263 | 2021-02-12 | Nevada | California | 6057 | 3729 | 74 |
1018018 | 1018018 | 2021-02-11 | Nevada | California | 6057 | 3723 | 74 |
1014773 | 1014773 | 2021-02-10 | Nevada | California | 6057 | 3696 | 74 |
1011528 | 1011528 | 2021-02-09 | Nevada | California | 6057 | 3694 | 74 |
1008282 | 1008282 | 2021-02-08 | Nevada | California | 6057 | 3676 | 74 |
1005036 | 1005036 | 2021-02-07 | Nevada | California | 6057 | 3624 | 74 |
1001790 | 1001790 | 2021-02-06 | Nevada | California | 6057 | 3621 | 74 |
998544 | 998544 | 2021-02-05 | Nevada | California | 6057 | 3621 | 74 |
995298 | 995298 | 2021-02-04 | Nevada | California | 6057 | 3598 | 74 |
992052 | 992052 | 2021-02-03 | Nevada | California | 6057 | 3577 | 74 |
988806 | 988806 | 2021-02-02 | Nevada | California | 6057 | 3540 | 74 |
985559 | 985559 | 2021-02-01 | Nevada | California | 6057 | 3528 | 74 |
982312 | 982312 | 2021-01-31 | Nevada | California | 6057 | 3499 | 74 |
979066 | 979066 | 2021-01-30 | Nevada | California | 6057 | 3487 | 74 |
975821 | 975821 | 2021-01-29 | Nevada | California | 6057 | 3454 | 74 |
972576 | 972576 | 2021-01-28 | Nevada | California | 6057 | 3439 | 73 |
969331 | 969331 | 2021-01-27 | Nevada | California | 6057 | 3420 | 73 |
966087 | 966087 | 2021-01-26 | Nevada | California | 6057 | 3394 | 73 |
962842 | 962842 | 2021-01-25 | Nevada | California | 6057 | 3355 | 74 |
959597 | 959597 | 2021-01-24 | Nevada | California | 6057 | 3332 | 74 |
956351 | 956351 | 2021-01-23 | Nevada | California | 6057 | 3296 | 74 |
953106 | 953106 | 2021-01-22 | Nevada | California | 6057 | 3292 | 74 |
949861 | 949861 | 2021-01-21 | Nevada | California | 6057 | 3257 | 74 |
946615 | 946615 | 2021-01-20 | Nevada | California | 6057 | 3234 | 74 |
943368 | 943368 | 2021-01-19 | Nevada | California | 6057 | 3206 | 73 |
940123 | 940123 | 2021-01-18 | Nevada | California | 6057 | 3176 | 73 |
936878 | 936878 | 2021-01-17 | Nevada | California | 6057 | 3144 | 73 |
933633 | 933633 | 2021-01-16 | Nevada | California | 6057 | 3099 | 73 |
930388 | 930388 | 2021-01-15 | Nevada | California | 6057 | 3099 | 73 |
927143 | 927143 | 2021-01-14 | Nevada | California | 6057 | 3072 | 71 |
923897 | 923897 | 2021-01-13 | Nevada | California | 6057 | 3030 | 70 |
920652 | 920652 | 2021-01-12 | Nevada | California | 6057 | 3013 | 70 |
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 |
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);