ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Santa Cruz" and state = "California" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
674 | 674 | 2020-03-07 | Santa Cruz | California | 6087 | 1 | 0 |
769 | 769 | 2020-03-08 | Santa Cruz | California | 6087 | 1 | 0 |
883 | 883 | 2020-03-09 | Santa Cruz | California | 6087 | 2 | 0 |
1016 | 1016 | 2020-03-10 | Santa Cruz | California | 6087 | 2 | 0 |
1182 | 1182 | 2020-03-11 | Santa Cruz | California | 6087 | 2 | 0 |
1388 | 1388 | 2020-03-12 | Santa Cruz | California | 6087 | 2 | 0 |
1649 | 1649 | 2020-03-13 | Santa Cruz | California | 6087 | 2 | 0 |
1967 | 1967 | 2020-03-14 | Santa Cruz | California | 6087 | 2 | 0 |
2348 | 2348 | 2020-03-15 | Santa Cruz | California | 6087 | 2 | 0 |
2783 | 2783 | 2020-03-16 | Santa Cruz | California | 6087 | 2 | 0 |
3265 | 3265 | 2020-03-17 | Santa Cruz | California | 6087 | 2 | 0 |
3819 | 3819 | 2020-03-18 | Santa Cruz | California | 6087 | 2 | 0 |
4479 | 4479 | 2020-03-19 | Santa Cruz | California | 6087 | 2 | 0 |
5254 | 5254 | 2020-03-20 | Santa Cruz | California | 6087 | 15 | 0 |
6175 | 6175 | 2020-03-21 | Santa Cruz | California | 6087 | 15 | 0 |
7209 | 7209 | 2020-03-22 | Santa Cruz | California | 6087 | 15 | 0 |
8352 | 8352 | 2020-03-23 | Santa Cruz | California | 6087 | 22 | 0 |
9595 | 9595 | 2020-03-24 | Santa Cruz | California | 6087 | 24 | 0 |
10967 | 10967 | 2020-03-25 | Santa Cruz | California | 6087 | 25 | 0 |
12512 | 12512 | 2020-03-26 | Santa Cruz | California | 6087 | 32 | 0 |
14178 | 14178 | 2020-03-27 | Santa Cruz | California | 6087 | 34 | 0 |
15960 | 15960 | 2020-03-28 | Santa Cruz | California | 6087 | 39 | 0 |
17849 | 17849 | 2020-03-29 | Santa Cruz | California | 6087 | 44 | 1 |
19826 | 19826 | 2020-03-30 | Santa Cruz | California | 6087 | 45 | 1 |
21901 | 21901 | 2020-03-31 | Santa Cruz | California | 6087 | 49 | 1 |
24059 | 24059 | 2020-04-01 | Santa Cruz | California | 6087 | 54 | 1 |
26288 | 26288 | 2020-04-02 | Santa Cruz | California | 6087 | 57 | 1 |
28587 | 28587 | 2020-04-03 | Santa Cruz | California | 6087 | 59 | 1 |
30945 | 30945 | 2020-04-04 | Santa Cruz | California | 6087 | 62 | 1 |
33351 | 33351 | 2020-04-05 | Santa Cruz | California | 6087 | 69 | 1 |
35796 | 35796 | 2020-04-06 | Santa Cruz | California | 6087 | 71 | 1 |
38285 | 38285 | 2020-04-07 | Santa Cruz | California | 6087 | 76 | 1 |
40829 | 40829 | 2020-04-08 | Santa Cruz | California | 6087 | 76 | 1 |
43401 | 43401 | 2020-04-09 | Santa Cruz | California | 6087 | 80 | 1 |
46001 | 46001 | 2020-04-10 | Santa Cruz | California | 6087 | 80 | 1 |
48631 | 48631 | 2020-04-11 | Santa Cruz | California | 6087 | 82 | 1 |
51293 | 51293 | 2020-04-12 | Santa Cruz | California | 6087 | 88 | 1 |
53972 | 53972 | 2020-04-13 | Santa Cruz | California | 6087 | 91 | 1 |
56664 | 56664 | 2020-04-14 | Santa Cruz | California | 6087 | 91 | 1 |
59372 | 59372 | 2020-04-15 | Santa Cruz | California | 6087 | 96 | 2 |
62091 | 62091 | 2020-04-16 | Santa Cruz | California | 6087 | 96 | 2 |
64824 | 64824 | 2020-04-17 | Santa Cruz | California | 6087 | 98 | 2 |
67572 | 67572 | 2020-04-18 | Santa Cruz | California | 6087 | 101 | 2 |
70334 | 70334 | 2020-04-19 | Santa Cruz | California | 6087 | 104 | 2 |
73103 | 73103 | 2020-04-20 | Santa Cruz | California | 6087 | 106 | 2 |
75879 | 75879 | 2020-04-21 | Santa Cruz | California | 6087 | 108 | 2 |
78663 | 78663 | 2020-04-22 | Santa Cruz | California | 6087 | 111 | 2 |
81457 | 81457 | 2020-04-23 | Santa Cruz | California | 6087 | 114 | 2 |
84257 | 84257 | 2020-04-24 | Santa Cruz | California | 6087 | 115 | 2 |
87065 | 87065 | 2020-04-25 | Santa Cruz | California | 6087 | 115 | 2 |
89882 | 89882 | 2020-04-26 | Santa Cruz | California | 6087 | 120 | 2 |
92700 | 92700 | 2020-04-27 | Santa Cruz | California | 6087 | 124 | 2 |
95532 | 95532 | 2020-04-28 | Santa Cruz | California | 6087 | 125 | 2 |
98377 | 98377 | 2020-04-29 | Santa Cruz | California | 6087 | 127 | 2 |
101227 | 101227 | 2020-04-30 | Santa Cruz | California | 6087 | 131 | 2 |
104082 | 104082 | 2020-05-01 | Santa Cruz | California | 6087 | 132 | 2 |
106947 | 106947 | 2020-05-02 | Santa Cruz | California | 6087 | 134 | 2 |
109816 | 109816 | 2020-05-03 | Santa Cruz | California | 6087 | 137 | 2 |
112691 | 112691 | 2020-05-04 | Santa Cruz | California | 6087 | 137 | 2 |
115574 | 115574 | 2020-05-05 | Santa Cruz | California | 6087 | 138 | 2 |
118533 | 118533 | 2020-05-06 | Santa Cruz | California | 6087 | 138 | 2 |
121500 | 121500 | 2020-05-07 | Santa Cruz | California | 6087 | 139 | 2 |
124480 | 124480 | 2020-05-08 | Santa Cruz | California | 6087 | 140 | 2 |
127465 | 127465 | 2020-05-09 | Santa Cruz | California | 6087 | 141 | 2 |
130455 | 130455 | 2020-05-10 | Santa Cruz | California | 6087 | 141 | 2 |
133445 | 133445 | 2020-05-11 | Santa Cruz | California | 6087 | 141 | 2 |
136435 | 136435 | 2020-05-12 | Santa Cruz | California | 6087 | 146 | 2 |
139426 | 139426 | 2020-05-13 | Santa Cruz | California | 6087 | 146 | 2 |
142422 | 142422 | 2020-05-14 | Santa Cruz | California | 6087 | 149 | 3 |
145421 | 145421 | 2020-05-15 | Santa Cruz | California | 6087 | 149 | 2 |
148425 | 148425 | 2020-05-16 | Santa Cruz | California | 6087 | 149 | 3 |
151434 | 151434 | 2020-05-17 | Santa Cruz | California | 6087 | 154 | 3 |
154446 | 154446 | 2020-05-18 | Santa Cruz | California | 6087 | 163 | 3 |
157462 | 157462 | 2020-05-19 | Santa Cruz | California | 6087 | 165 | 3 |
160488 | 160488 | 2020-05-20 | Santa Cruz | California | 6087 | 168 | 3 |
163516 | 163516 | 2020-05-21 | Santa Cruz | California | 6087 | 174 | 3 |
166548 | 166548 | 2020-05-22 | Santa Cruz | California | 6087 | 186 | 3 |
169585 | 169585 | 2020-05-23 | Santa Cruz | California | 6087 | 192 | 3 |
172626 | 172626 | 2020-05-24 | Santa Cruz | California | 6087 | 192 | 3 |
175670 | 175670 | 2020-05-25 | Santa Cruz | California | 6087 | 200 | 3 |
178714 | 178714 | 2020-05-26 | Santa Cruz | California | 6087 | 200 | 3 |
181758 | 181758 | 2020-05-27 | Santa Cruz | California | 6087 | 205 | 3 |
184812 | 184812 | 2020-05-28 | Santa Cruz | California | 6087 | 205 | 3 |
187868 | 187868 | 2020-05-29 | Santa Cruz | California | 6087 | 205 | 3 |
190933 | 190933 | 2020-05-30 | Santa Cruz | California | 6087 | 212 | 3 |
194000 | 194000 | 2020-05-31 | Santa Cruz | California | 6087 | 212 | 3 |
197070 | 197070 | 2020-06-01 | Santa Cruz | California | 6087 | 217 | 3 |
200143 | 200143 | 2020-06-02 | Santa Cruz | California | 6087 | 217 | 3 |
203219 | 203219 | 2020-06-03 | Santa Cruz | California | 6087 | 219 | 3 |
206299 | 206299 | 2020-06-04 | Santa Cruz | California | 6087 | 219 | 3 |
209380 | 209380 | 2020-06-05 | Santa Cruz | California | 6087 | 221 | 3 |
212465 | 212465 | 2020-06-06 | Santa Cruz | California | 6087 | 226 | 3 |
215552 | 215552 | 2020-06-07 | Santa Cruz | California | 6087 | 231 | 3 |
218643 | 218643 | 2020-06-08 | Santa Cruz | California | 6087 | 234 | 3 |
221738 | 221738 | 2020-06-09 | Santa Cruz | California | 6087 | 234 | 3 |
224833 | 224833 | 2020-06-10 | Santa Cruz | California | 6087 | 239 | 3 |
227935 | 227935 | 2020-06-11 | Santa Cruz | California | 6087 | 249 | 3 |
231038 | 231038 | 2020-06-12 | Santa Cruz | California | 6087 | 254 | 3 |
234144 | 234144 | 2020-06-13 | Santa Cruz | California | 6087 | 255 | 3 |
237251 | 237251 | 2020-06-14 | Santa Cruz | California | 6087 | 257 | 3 |
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);