ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where county = "Napa" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053719 | 1053719 | 2021-02-22 | Napa | California | 6055 | 8930 | 67 |
1050472 | 1050472 | 2021-02-21 | Napa | California | 6055 | 8911 | 67 |
1047225 | 1047225 | 2021-02-20 | Napa | California | 6055 | 8900 | 67 |
1043980 | 1043980 | 2021-02-19 | Napa | California | 6055 | 8878 | 67 |
1040735 | 1040735 | 2021-02-18 | Napa | California | 6055 | 8866 | 65 |
1037490 | 1037490 | 2021-02-17 | Napa | California | 6055 | 8855 | 64 |
1034245 | 1034245 | 2021-02-16 | Napa | California | 6055 | 8838 | 62 |
1030999 | 1030999 | 2021-02-15 | Napa | California | 6055 | 8827 | 62 |
1027752 | 1027752 | 2021-02-14 | Napa | California | 6055 | 8810 | 62 |
1024507 | 1024507 | 2021-02-13 | Napa | California | 6055 | 8786 | 62 |
1021262 | 1021262 | 2021-02-12 | Napa | California | 6055 | 8778 | 62 |
1018017 | 1018017 | 2021-02-11 | Napa | California | 6055 | 8770 | 61 |
1014772 | 1014772 | 2021-02-10 | Napa | California | 6055 | 8750 | 59 |
1011527 | 1011527 | 2021-02-09 | Napa | California | 6055 | 8720 | 59 |
1008281 | 1008281 | 2021-02-08 | Napa | California | 6055 | 8702 | 58 |
1005035 | 1005035 | 2021-02-07 | Napa | California | 6055 | 8640 | 58 |
1001789 | 1001789 | 2021-02-06 | Napa | California | 6055 | 8599 | 58 |
998543 | 998543 | 2021-02-05 | Napa | California | 6055 | 8574 | 58 |
995297 | 995297 | 2021-02-04 | Napa | California | 6055 | 8535 | 58 |
992051 | 992051 | 2021-02-03 | Napa | California | 6055 | 8506 | 57 |
988805 | 988805 | 2021-02-02 | Napa | California | 6055 | 8450 | 55 |
985558 | 985558 | 2021-02-01 | Napa | California | 6055 | 8405 | 54 |
982311 | 982311 | 2021-01-31 | Napa | California | 6055 | 8343 | 54 |
979065 | 979065 | 2021-01-30 | Napa | California | 6055 | 8277 | 54 |
975820 | 975820 | 2021-01-29 | Napa | California | 6055 | 8234 | 52 |
972575 | 972575 | 2021-01-28 | Napa | California | 6055 | 8188 | 52 |
969330 | 969330 | 2021-01-27 | Napa | California | 6055 | 8146 | 52 |
966086 | 966086 | 2021-01-26 | Napa | California | 6055 | 8071 | 50 |
962841 | 962841 | 2021-01-25 | Napa | California | 6055 | 8006 | 48 |
959596 | 959596 | 2021-01-24 | Napa | California | 6055 | 7894 | 47 |
956350 | 956350 | 2021-01-23 | Napa | California | 6055 | 7829 | 47 |
953105 | 953105 | 2021-01-22 | Napa | California | 6055 | 7775 | 46 |
949860 | 949860 | 2021-01-21 | Napa | California | 6055 | 7732 | 45 |
946614 | 946614 | 2021-01-20 | Napa | California | 6055 | 7673 | 44 |
943367 | 943367 | 2021-01-19 | Napa | California | 6055 | 7602 | 40 |
940122 | 940122 | 2021-01-18 | Napa | California | 6055 | 7522 | 39 |
936877 | 936877 | 2021-01-17 | Napa | California | 6055 | 7357 | 39 |
933632 | 933632 | 2021-01-16 | Napa | California | 6055 | 7232 | 39 |
930387 | 930387 | 2021-01-15 | Napa | California | 6055 | 7158 | 38 |
927142 | 927142 | 2021-01-14 | Napa | California | 6055 | 7040 | 38 |
923896 | 923896 | 2021-01-13 | Napa | California | 6055 | 6943 | 37 |
920651 | 920651 | 2021-01-12 | Napa | California | 6055 | 6881 | 36 |
917406 | 917406 | 2021-01-11 | Napa | California | 6055 | 6702 | 36 |
914161 | 914161 | 2021-01-10 | Napa | California | 6055 | 6595 | 36 |
910916 | 910916 | 2021-01-09 | Napa | California | 6055 | 6545 | 36 |
907671 | 907671 | 2021-01-08 | Napa | California | 6055 | 6477 | 35 |
904425 | 904425 | 2021-01-07 | Napa | California | 6055 | 6343 | 33 |
901180 | 901180 | 2021-01-06 | Napa | California | 6055 | 6283 | 32 |
897935 | 897935 | 2021-01-05 | Napa | California | 6055 | 6199 | 30 |
894690 | 894690 | 2021-01-04 | Napa | California | 6055 | 6095 | 29 |
891443 | 891443 | 2021-01-03 | Napa | California | 6055 | 5995 | 29 |
888196 | 888196 | 2021-01-02 | Napa | California | 6055 | 5900 | 29 |
884951 | 884951 | 2021-01-01 | Napa | California | 6055 | 5802 | 29 |
881706 | 881706 | 2020-12-31 | Napa | California | 6055 | 5742 | 28 |
878461 | 878461 | 2020-12-30 | Napa | California | 6055 | 5665 | 27 |
875216 | 875216 | 2020-12-29 | Napa | California | 6055 | 5616 | 27 |
871971 | 871971 | 2020-12-28 | Napa | California | 6055 | 5497 | 27 |
868726 | 868726 | 2020-12-27 | Napa | California | 6055 | 5428 | 27 |
865481 | 865481 | 2020-12-26 | Napa | California | 6055 | 5352 | 27 |
862236 | 862236 | 2020-12-25 | Napa | California | 6055 | 5266 | 27 |
858991 | 858991 | 2020-12-24 | Napa | California | 6055 | 5173 | 27 |
855746 | 855746 | 2020-12-23 | Napa | California | 6055 | 5092 | 26 |
852501 | 852501 | 2020-12-22 | Napa | California | 6055 | 4966 | 25 |
849256 | 849256 | 2020-12-21 | Napa | California | 6055 | 4866 | 24 |
846011 | 846011 | 2020-12-20 | Napa | California | 6055 | 4773 | 24 |
842765 | 842765 | 2020-12-19 | Napa | California | 6055 | 4689 | 24 |
839520 | 839520 | 2020-12-18 | Napa | California | 6055 | 4647 | 24 |
836275 | 836275 | 2020-12-17 | Napa | California | 6055 | 4545 | 24 |
833029 | 833029 | 2020-12-16 | Napa | California | 6055 | 4456 | 24 |
829782 | 829782 | 2020-12-15 | Napa | California | 6055 | 4384 | 24 |
826536 | 826536 | 2020-12-14 | Napa | California | 6055 | 4248 | 23 |
823289 | 823289 | 2020-12-13 | Napa | California | 6055 | 4114 | 23 |
820043 | 820043 | 2020-12-12 | Napa | California | 6055 | 4055 | 23 |
816797 | 816797 | 2020-12-11 | Napa | California | 6055 | 4014 | 23 |
813551 | 813551 | 2020-12-10 | Napa | California | 6055 | 3936 | 23 |
810307 | 810307 | 2020-12-09 | Napa | California | 6055 | 3814 | 22 |
807062 | 807062 | 2020-12-08 | Napa | California | 6055 | 3734 | 21 |
803817 | 803817 | 2020-12-07 | Napa | California | 6055 | 3651 | 20 |
800572 | 800572 | 2020-12-06 | Napa | California | 6055 | 3566 | 19 |
797327 | 797327 | 2020-12-05 | Napa | California | 6055 | 3433 | 19 |
794082 | 794082 | 2020-12-04 | Napa | California | 6055 | 3389 | 18 |
790837 | 790837 | 2020-12-03 | Napa | California | 6055 | 3299 | 18 |
787592 | 787592 | 2020-12-02 | Napa | California | 6055 | 3227 | 18 |
784348 | 784348 | 2020-12-01 | Napa | California | 6055 | 3096 | 18 |
781103 | 781103 | 2020-11-30 | Napa | California | 6055 | 3091 | 17 |
777857 | 777857 | 2020-11-29 | Napa | California | 6055 | 3034 | 17 |
774612 | 774612 | 2020-11-28 | Napa | California | 6055 | 2989 | 17 |
771367 | 771367 | 2020-11-27 | Napa | California | 6055 | 2989 | 17 |
768122 | 768122 | 2020-11-26 | Napa | California | 6055 | 2946 | 17 |
764876 | 764876 | 2020-11-25 | Napa | California | 6055 | 2932 | 17 |
761631 | 761631 | 2020-11-24 | Napa | California | 6055 | 2885 | 17 |
758386 | 758386 | 2020-11-23 | Napa | California | 6055 | 2788 | 17 |
755139 | 755139 | 2020-11-22 | Napa | California | 6055 | 2758 | 17 |
751893 | 751893 | 2020-11-21 | Napa | California | 6055 | 2719 | 17 |
748647 | 748647 | 2020-11-20 | Napa | California | 6055 | 2696 | 17 |
745401 | 745401 | 2020-11-19 | Napa | California | 6055 | 2624 | 17 |
742154 | 742154 | 2020-11-18 | Napa | California | 6055 | 2591 | 17 |
738907 | 738907 | 2020-11-17 | Napa | California | 6055 | 2554 | 17 |
735663 | 735663 | 2020-11-16 | Napa | California | 6055 | 2522 | 17 |
732417 | 732417 | 2020-11-15 | Napa | California | 6055 | 2474 | 17 |
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);