ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 6099 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193344 | 1193344 | 2021-04-06 | Stanislaus | California | 6099 | 59536 | 1007 |
1190094 | 1190094 | 2021-04-05 | Stanislaus | California | 6099 | 59460 | 1004 |
1186847 | 1186847 | 2021-04-04 | Stanislaus | California | 6099 | 59342 | 1003 |
1183600 | 1183600 | 2021-04-03 | Stanislaus | California | 6099 | 59342 | 1003 |
1180353 | 1180353 | 2021-04-02 | Stanislaus | California | 6099 | 59271 | 1003 |
1177106 | 1177106 | 2021-04-01 | Stanislaus | California | 6099 | 59013 | 1001 |
1173859 | 1173859 | 2021-03-31 | Stanislaus | California | 6099 | 58969 | 1000 |
1170612 | 1170612 | 2021-03-30 | Stanislaus | California | 6099 | 58883 | 997 |
1167364 | 1167364 | 2021-03-29 | Stanislaus | California | 6099 | 58804 | 996 |
1164116 | 1164116 | 2021-03-28 | Stanislaus | California | 6099 | 58602 | 992 |
1160868 | 1160868 | 2021-03-27 | Stanislaus | California | 6099 | 58602 | 992 |
1157620 | 1157620 | 2021-03-26 | Stanislaus | California | 6099 | 58602 | 992 |
1154373 | 1154373 | 2021-03-25 | Stanislaus | California | 6099 | 58508 | 988 |
1151126 | 1151126 | 2021-03-24 | Stanislaus | California | 6099 | 58425 | 985 |
1147879 | 1147879 | 2021-03-23 | Stanislaus | California | 6099 | 58347 | 982 |
1144632 | 1144632 | 2021-03-22 | Stanislaus | California | 6099 | 58274 | 980 |
1141385 | 1141385 | 2021-03-21 | Stanislaus | California | 6099 | 58140 | 979 |
1138139 | 1138139 | 2021-03-20 | Stanislaus | California | 6099 | 58140 | 979 |
1134893 | 1134893 | 2021-03-19 | Stanislaus | California | 6099 | 58019 | 979 |
1131646 | 1131646 | 2021-03-18 | Stanislaus | California | 6099 | 57904 | 978 |
1128398 | 1128398 | 2021-03-17 | Stanislaus | California | 6099 | 57817 | 976 |
1125152 | 1125152 | 2021-03-16 | Stanislaus | California | 6099 | 57687 | 974 |
1121906 | 1121906 | 2021-03-15 | Stanislaus | California | 6099 | 57621 | 972 |
1118659 | 1118659 | 2021-03-14 | Stanislaus | California | 6099 | 57504 | 969 |
1115412 | 1115412 | 2021-03-13 | Stanislaus | California | 6099 | 57504 | 969 |
1112166 | 1112166 | 2021-03-12 | Stanislaus | California | 6099 | 57373 | 966 |
1108920 | 1108920 | 2021-03-11 | Stanislaus | California | 6099 | 57220 | 963 |
1105674 | 1105674 | 2021-03-10 | Stanislaus | California | 6099 | 57124 | 960 |
1102428 | 1102428 | 2021-03-09 | Stanislaus | California | 6099 | 56985 | 959 |
1099182 | 1099182 | 2021-03-08 | Stanislaus | California | 6099 | 56885 | 959 |
1095934 | 1095934 | 2021-03-07 | Stanislaus | California | 6099 | 56702 | 957 |
1092688 | 1092688 | 2021-03-06 | Stanislaus | California | 6099 | 56702 | 957 |
1089442 | 1089442 | 2021-03-05 | Stanislaus | California | 6099 | 56602 | 957 |
1086197 | 1086197 | 2021-03-04 | Stanislaus | California | 6099 | 56522 | 955 |
1082951 | 1082951 | 2021-03-03 | Stanislaus | California | 6099 | 56433 | 953 |
1079705 | 1079705 | 2021-03-02 | Stanislaus | California | 6099 | 56323 | 950 |
1076460 | 1076460 | 2021-03-01 | Stanislaus | California | 6099 | 56235 | 949 |
1073214 | 1073214 | 2021-02-28 | Stanislaus | California | 6099 | 56132 | 946 |
1069968 | 1069968 | 2021-02-27 | Stanislaus | California | 6099 | 56024 | 946 |
1066723 | 1066723 | 2021-02-26 | Stanislaus | California | 6099 | 55887 | 946 |
1063478 | 1063478 | 2021-02-25 | Stanislaus | California | 6099 | 55775 | 944 |
1060233 | 1060233 | 2021-02-24 | Stanislaus | California | 6099 | 55625 | 941 |
1056987 | 1056987 | 2021-02-23 | Stanislaus | California | 6099 | 55487 | 937 |
1053741 | 1053741 | 2021-02-22 | Stanislaus | California | 6099 | 55347 | 931 |
1050494 | 1050494 | 2021-02-21 | Stanislaus | California | 6099 | 55191 | 926 |
1047247 | 1047247 | 2021-02-20 | Stanislaus | California | 6099 | 55081 | 926 |
1044002 | 1044002 | 2021-02-19 | Stanislaus | California | 6099 | 54887 | 921 |
1040757 | 1040757 | 2021-02-18 | Stanislaus | California | 6099 | 54728 | 916 |
1037512 | 1037512 | 2021-02-17 | Stanislaus | California | 6099 | 54631 | 910 |
1034267 | 1034267 | 2021-02-16 | Stanislaus | California | 6099 | 54484 | 905 |
1031021 | 1031021 | 2021-02-15 | Stanislaus | California | 6099 | 54325 | 899 |
1027774 | 1027774 | 2021-02-14 | Stanislaus | California | 6099 | 54148 | 899 |
1024529 | 1024529 | 2021-02-13 | Stanislaus | California | 6099 | 54025 | 899 |
1021284 | 1021284 | 2021-02-12 | Stanislaus | California | 6099 | 53842 | 894 |
1018039 | 1018039 | 2021-02-11 | Stanislaus | California | 6099 | 53614 | 888 |
1014794 | 1014794 | 2021-02-10 | Stanislaus | California | 6099 | 53388 | 881 |
1011549 | 1011549 | 2021-02-09 | Stanislaus | California | 6099 | 53278 | 874 |
1008303 | 1008303 | 2021-02-08 | Stanislaus | California | 6099 | 52996 | 867 |
1005057 | 1005057 | 2021-02-07 | Stanislaus | California | 6099 | 52806 | 861 |
1001811 | 1001811 | 2021-02-06 | Stanislaus | California | 6099 | 52562 | 861 |
998565 | 998565 | 2021-02-05 | Stanislaus | California | 6099 | 52251 | 857 |
995319 | 995319 | 2021-02-04 | Stanislaus | California | 6099 | 51998 | 853 |
992073 | 992073 | 2021-02-03 | Stanislaus | California | 6099 | 51741 | 848 |
988827 | 988827 | 2021-02-02 | Stanislaus | California | 6099 | 51416 | 842 |
985580 | 985580 | 2021-02-01 | Stanislaus | California | 6099 | 51167 | 834 |
982333 | 982333 | 2021-01-31 | Stanislaus | California | 6099 | 50983 | 828 |
979087 | 979087 | 2021-01-30 | Stanislaus | California | 6099 | 50668 | 828 |
975842 | 975842 | 2021-01-29 | Stanislaus | California | 6099 | 50389 | 822 |
972597 | 972597 | 2021-01-28 | Stanislaus | California | 6099 | 50008 | 815 |
969352 | 969352 | 2021-01-27 | Stanislaus | California | 6099 | 49690 | 808 |
966108 | 966108 | 2021-01-26 | Stanislaus | California | 6099 | 49500 | 803 |
962863 | 962863 | 2021-01-25 | Stanislaus | California | 6099 | 49065 | 796 |
959618 | 959618 | 2021-01-24 | Stanislaus | California | 6099 | 48753 | 788 |
956372 | 956372 | 2021-01-23 | Stanislaus | California | 6099 | 48432 | 788 |
953127 | 953127 | 2021-01-22 | Stanislaus | California | 6099 | 48100 | 782 |
949882 | 949882 | 2021-01-21 | Stanislaus | California | 6099 | 47808 | 773 |
946636 | 946636 | 2021-01-20 | Stanislaus | California | 6099 | 47506 | 766 |
943389 | 943389 | 2021-01-19 | Stanislaus | California | 6099 | 47187 | 758 |
940144 | 940144 | 2021-01-18 | Stanislaus | California | 6099 | 46744 | 749 |
936899 | 936899 | 2021-01-17 | Stanislaus | California | 6099 | 46463 | 739 |
933654 | 933654 | 2021-01-16 | Stanislaus | California | 6099 | 46023 | 739 |
930409 | 930409 | 2021-01-15 | Stanislaus | California | 6099 | 45274 | 730 |
927164 | 927164 | 2021-01-14 | Stanislaus | California | 6099 | 44638 | 720 |
923918 | 923918 | 2021-01-13 | Stanislaus | California | 6099 | 44133 | 709 |
920673 | 920673 | 2021-01-12 | Stanislaus | California | 6099 | 43523 | 699 |
917428 | 917428 | 2021-01-11 | Stanislaus | California | 6099 | 42940 | 686 |
914183 | 914183 | 2021-01-10 | Stanislaus | California | 6099 | 42521 | 675 |
910938 | 910938 | 2021-01-09 | Stanislaus | California | 6099 | 42093 | 675 |
907693 | 907693 | 2021-01-08 | Stanislaus | California | 6099 | 41520 | 665 |
904447 | 904447 | 2021-01-07 | Stanislaus | California | 6099 | 40854 | 657 |
901202 | 901202 | 2021-01-06 | Stanislaus | California | 6099 | 40294 | 649 |
897957 | 897957 | 2021-01-05 | Stanislaus | California | 6099 | 39797 | 638 |
894712 | 894712 | 2021-01-04 | Stanislaus | California | 6099 | 39483 | 631 |
891465 | 891465 | 2021-01-03 | Stanislaus | California | 6099 | 38927 | 624 |
888218 | 888218 | 2021-01-02 | Stanislaus | California | 6099 | 38598 | 624 |
884973 | 884973 | 2021-01-01 | Stanislaus | California | 6099 | 37524 | 616 |
881728 | 881728 | 2020-12-31 | Stanislaus | California | 6099 | 37524 | 616 |
878483 | 878483 | 2020-12-30 | Stanislaus | California | 6099 | 37193 | 608 |
875238 | 875238 | 2020-12-29 | Stanislaus | California | 6099 | 36887 | 596 |
871993 | 871993 | 2020-12-28 | Stanislaus | California | 6099 | 36529 | 586 |
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);