ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6087 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193338 | 1193338 | 2021-04-06 | Santa Cruz | California | 6087 | 15264 | 202 |
1190088 | 1190088 | 2021-04-05 | Santa Cruz | California | 6087 | 15247 | 201 |
1186841 | 1186841 | 2021-04-04 | Santa Cruz | California | 6087 | 15363 | 201 |
1183594 | 1183594 | 2021-04-03 | Santa Cruz | California | 6087 | 15363 | 202 |
1180347 | 1180347 | 2021-04-02 | Santa Cruz | California | 6087 | 15363 | 202 |
1177100 | 1177100 | 2021-04-01 | Santa Cruz | California | 6087 | 15363 | 201 |
1173853 | 1173853 | 2021-03-31 | Santa Cruz | California | 6087 | 15363 | 201 |
1170606 | 1170606 | 2021-03-30 | Santa Cruz | California | 6087 | 15363 | 201 |
1167358 | 1167358 | 2021-03-29 | Santa Cruz | California | 6087 | 15354 | 201 |
1164110 | 1164110 | 2021-03-28 | Santa Cruz | California | 6087 | 15306 | 201 |
1160862 | 1160862 | 2021-03-27 | Santa Cruz | California | 6087 | 15306 | 201 |
1157614 | 1157614 | 2021-03-26 | Santa Cruz | California | 6087 | 15306 | 201 |
1154367 | 1154367 | 2021-03-25 | Santa Cruz | California | 6087 | 15264 | 202 |
1151120 | 1151120 | 2021-03-24 | Santa Cruz | California | 6087 | 15258 | 201 |
1147873 | 1147873 | 2021-03-23 | Santa Cruz | California | 6087 | 15240 | 201 |
1144626 | 1144626 | 2021-03-22 | Santa Cruz | California | 6087 | 15225 | 199 |
1141379 | 1141379 | 2021-03-21 | Santa Cruz | California | 6087 | 15196 | 199 |
1138133 | 1138133 | 2021-03-20 | Santa Cruz | California | 6087 | 15196 | 199 |
1134887 | 1134887 | 2021-03-19 | Santa Cruz | California | 6087 | 15196 | 198 |
1131640 | 1131640 | 2021-03-18 | Santa Cruz | California | 6087 | 15169 | 199 |
1128392 | 1128392 | 2021-03-17 | Santa Cruz | California | 6087 | 15137 | 199 |
1125146 | 1125146 | 2021-03-16 | Santa Cruz | California | 6087 | 15101 | 200 |
1121900 | 1121900 | 2021-03-15 | Santa Cruz | California | 6087 | 15080 | 200 |
1118653 | 1118653 | 2021-03-14 | Santa Cruz | California | 6087 | 15023 | 199 |
1115406 | 1115406 | 2021-03-13 | Santa Cruz | California | 6087 | 15023 | 195 |
1112160 | 1112160 | 2021-03-12 | Santa Cruz | California | 6087 | 15023 | 193 |
1108914 | 1108914 | 2021-03-11 | Santa Cruz | California | 6087 | 14982 | 192 |
1105668 | 1105668 | 2021-03-10 | Santa Cruz | California | 6087 | 14937 | 191 |
1102422 | 1102422 | 2021-03-09 | Santa Cruz | California | 6087 | 14908 | 187 |
1099176 | 1099176 | 2021-03-08 | Santa Cruz | California | 6087 | 14863 | 187 |
1095928 | 1095928 | 2021-03-07 | Santa Cruz | California | 6087 | 14790 | 187 |
1092682 | 1092682 | 2021-03-06 | Santa Cruz | California | 6087 | 14790 | 187 |
1089436 | 1089436 | 2021-03-05 | Santa Cruz | California | 6087 | 14790 | 187 |
1086191 | 1086191 | 2021-03-04 | Santa Cruz | California | 6087 | 14760 | 187 |
1082945 | 1082945 | 2021-03-03 | Santa Cruz | California | 6087 | 14736 | 183 |
1079699 | 1079699 | 2021-03-02 | Santa Cruz | California | 6087 | 14700 | 183 |
1076454 | 1076454 | 2021-03-01 | Santa Cruz | California | 6087 | 14671 | 183 |
1073208 | 1073208 | 2021-02-28 | Santa Cruz | California | 6087 | 14628 | 183 |
1069962 | 1069962 | 2021-02-27 | Santa Cruz | California | 6087 | 14628 | 183 |
1066717 | 1066717 | 2021-02-26 | Santa Cruz | California | 6087 | 14628 | 183 |
1063472 | 1063472 | 2021-02-25 | Santa Cruz | California | 6087 | 14588 | 183 |
1060227 | 1060227 | 2021-02-24 | Santa Cruz | California | 6087 | 14561 | 181 |
1056981 | 1056981 | 2021-02-23 | Santa Cruz | California | 6087 | 14516 | 174 |
1053735 | 1053735 | 2021-02-22 | Santa Cruz | California | 6087 | 14495 | 172 |
1050488 | 1050488 | 2021-02-21 | Santa Cruz | California | 6087 | 14438 | 172 |
1047241 | 1047241 | 2021-02-20 | Santa Cruz | California | 6087 | 14438 | 172 |
1043996 | 1043996 | 2021-02-19 | Santa Cruz | California | 6087 | 14438 | 172 |
1040751 | 1040751 | 2021-02-18 | Santa Cruz | California | 6087 | 14394 | 172 |
1037506 | 1037506 | 2021-02-17 | Santa Cruz | California | 6087 | 14359 | 170 |
1034261 | 1034261 | 2021-02-16 | Santa Cruz | California | 6087 | 14344 | 170 |
1031015 | 1031015 | 2021-02-15 | Santa Cruz | California | 6087 | 14232 | 168 |
1027768 | 1027768 | 2021-02-14 | Santa Cruz | California | 6087 | 14232 | 168 |
1024523 | 1024523 | 2021-02-13 | Santa Cruz | California | 6087 | 14232 | 168 |
1021278 | 1021278 | 2021-02-12 | Santa Cruz | California | 6087 | 14232 | 168 |
1018033 | 1018033 | 2021-02-11 | Santa Cruz | California | 6087 | 14163 | 166 |
1014788 | 1014788 | 2021-02-10 | Santa Cruz | California | 6087 | 14092 | 162 |
1011543 | 1011543 | 2021-02-09 | Santa Cruz | California | 6087 | 14055 | 160 |
1008297 | 1008297 | 2021-02-08 | Santa Cruz | California | 6087 | 14011 | 159 |
1005051 | 1005051 | 2021-02-07 | Santa Cruz | California | 6087 | 13915 | 159 |
1001805 | 1001805 | 2021-02-06 | Santa Cruz | California | 6087 | 13915 | 159 |
998559 | 998559 | 2021-02-05 | Santa Cruz | California | 6087 | 13790 | 155 |
995313 | 995313 | 2021-02-04 | Santa Cruz | California | 6087 | 13790 | 155 |
992067 | 992067 | 2021-02-03 | Santa Cruz | California | 6087 | 13683 | 153 |
988821 | 988821 | 2021-02-02 | Santa Cruz | California | 6087 | 13648 | 149 |
985574 | 985574 | 2021-02-01 | Santa Cruz | California | 6087 | 13606 | 148 |
982327 | 982327 | 2021-01-31 | Santa Cruz | California | 6087 | 13383 | 148 |
979081 | 979081 | 2021-01-30 | Santa Cruz | California | 6087 | 13321 | 148 |
975836 | 975836 | 2021-01-29 | Santa Cruz | California | 6087 | 13321 | 148 |
972591 | 972591 | 2021-01-28 | Santa Cruz | California | 6087 | 13235 | 146 |
969346 | 969346 | 2021-01-27 | Santa Cruz | California | 6087 | 13147 | 143 |
966102 | 966102 | 2021-01-26 | Santa Cruz | California | 6087 | 13088 | 136 |
962857 | 962857 | 2021-01-25 | Santa Cruz | California | 6087 | 13009 | 135 |
959612 | 959612 | 2021-01-24 | Santa Cruz | California | 6087 | 12771 | 130 |
956366 | 956366 | 2021-01-23 | Santa Cruz | California | 6087 | 12687 | 130 |
953121 | 953121 | 2021-01-22 | Santa Cruz | California | 6087 | 12649 | 130 |
949876 | 949876 | 2021-01-21 | Santa Cruz | California | 6087 | 12533 | 120 |
946630 | 946630 | 2021-01-20 | Santa Cruz | California | 6087 | 12461 | 113 |
943383 | 943383 | 2021-01-19 | Santa Cruz | California | 6087 | 12298 | 113 |
940138 | 940138 | 2021-01-18 | Santa Cruz | California | 6087 | 12196 | 113 |
936893 | 936893 | 2021-01-17 | Santa Cruz | California | 6087 | 12026 | 113 |
933648 | 933648 | 2021-01-16 | Santa Cruz | California | 6087 | 11776 | 113 |
930403 | 930403 | 2021-01-15 | Santa Cruz | California | 6087 | 11715 | 113 |
927158 | 927158 | 2021-01-14 | Santa Cruz | California | 6087 | 11447 | 111 |
923912 | 923912 | 2021-01-13 | Santa Cruz | California | 6087 | 11275 | 111 |
920667 | 920667 | 2021-01-12 | Santa Cruz | California | 6087 | 11093 | 111 |
917422 | 917422 | 2021-01-11 | Santa Cruz | California | 6087 | 10951 | 106 |
914177 | 914177 | 2021-01-10 | Santa Cruz | California | 6087 | 10717 | 104 |
910932 | 910932 | 2021-01-09 | Santa Cruz | California | 6087 | 10486 | 104 |
907687 | 907687 | 2021-01-08 | Santa Cruz | California | 6087 | 10228 | 104 |
904441 | 904441 | 2021-01-07 | Santa Cruz | California | 6087 | 10108 | 104 |
901196 | 901196 | 2021-01-06 | Santa Cruz | California | 6087 | 9891 | 97 |
897951 | 897951 | 2021-01-05 | Santa Cruz | California | 6087 | 9700 | 93 |
894706 | 894706 | 2021-01-04 | Santa Cruz | California | 6087 | 9579 | 83 |
891459 | 891459 | 2021-01-03 | Santa Cruz | California | 6087 | 9340 | 83 |
888212 | 888212 | 2021-01-02 | Santa Cruz | California | 6087 | 9146 | 83 |
884967 | 884967 | 2021-01-01 | Santa Cruz | California | 6087 | 8909 | 83 |
881722 | 881722 | 2020-12-31 | Santa Cruz | California | 6087 | 8749 | 83 |
878477 | 878477 | 2020-12-30 | Santa Cruz | California | 6087 | 8492 | 83 |
875232 | 875232 | 2020-12-29 | Santa Cruz | California | 6087 | 8310 | 83 |
871987 | 871987 | 2020-12-28 | Santa Cruz | California | 6087 | 8234 | 83 |
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);