ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 6113 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312605 | 312605 | 2020-07-08 | Yolo | California | 6113 | 760 | 28 |
309435 | 309435 | 2020-07-07 | Yolo | California | 6113 | 723 | 26 |
306267 | 306267 | 2020-07-06 | Yolo | California | 6113 | 705 | 26 |
303103 | 303103 | 2020-07-05 | Yolo | California | 6113 | 677 | 26 |
299939 | 299939 | 2020-07-04 | Yolo | California | 6113 | 645 | 25 |
296777 | 296777 | 2020-07-03 | Yolo | California | 6113 | 613 | 25 |
293621 | 293621 | 2020-07-02 | Yolo | California | 6113 | 583 | 24 |
290467 | 290467 | 2020-07-01 | Yolo | California | 6113 | 555 | 24 |
287316 | 287316 | 2020-06-30 | Yolo | California | 6113 | 526 | 24 |
284170 | 284170 | 2020-06-29 | Yolo | California | 6113 | 505 | 24 |
281024 | 281024 | 2020-06-28 | Yolo | California | 6113 | 479 | 24 |
277877 | 277877 | 2020-06-27 | Yolo | California | 6113 | 458 | 24 |
274729 | 274729 | 2020-06-26 | Yolo | California | 6113 | 438 | 24 |
271589 | 271589 | 2020-06-25 | Yolo | California | 6113 | 408 | 24 |
268454 | 268454 | 2020-06-24 | Yolo | California | 6113 | 386 | 24 |
265324 | 265324 | 2020-06-23 | Yolo | California | 6113 | 366 | 24 |
262196 | 262196 | 2020-06-22 | Yolo | California | 6113 | 347 | 24 |
259069 | 259069 | 2020-06-21 | Yolo | California | 6113 | 330 | 24 |
255942 | 255942 | 2020-06-20 | Yolo | California | 6113 | 321 | 24 |
252823 | 252823 | 2020-06-19 | Yolo | California | 6113 | 310 | 24 |
249708 | 249708 | 2020-06-18 | Yolo | California | 6113 | 302 | 24 |
246596 | 246596 | 2020-06-17 | Yolo | California | 6113 | 291 | 24 |
243483 | 243483 | 2020-06-16 | Yolo | California | 6113 | 265 | 24 |
240372 | 240372 | 2020-06-15 | Yolo | California | 6113 | 255 | 24 |
237264 | 237264 | 2020-06-14 | Yolo | California | 6113 | 253 | 24 |
234157 | 234157 | 2020-06-13 | Yolo | California | 6113 | 252 | 24 |
231051 | 231051 | 2020-06-12 | Yolo | California | 6113 | 248 | 24 |
227948 | 227948 | 2020-06-11 | Yolo | California | 6113 | 240 | 24 |
224846 | 224846 | 2020-06-10 | Yolo | California | 6113 | 227 | 24 |
221751 | 221751 | 2020-06-09 | Yolo | California | 6113 | 228 | 24 |
218656 | 218656 | 2020-06-08 | Yolo | California | 6113 | 225 | 24 |
215565 | 215565 | 2020-06-07 | Yolo | California | 6113 | 223 | 24 |
212478 | 212478 | 2020-06-06 | Yolo | California | 6113 | 221 | 24 |
209393 | 209393 | 2020-06-05 | Yolo | California | 6113 | 218 | 24 |
206312 | 206312 | 2020-06-04 | Yolo | California | 6113 | 216 | 24 |
203232 | 203232 | 2020-06-03 | Yolo | California | 6113 | 214 | 24 |
200156 | 200156 | 2020-06-02 | Yolo | California | 6113 | 213 | 24 |
197083 | 197083 | 2020-06-01 | Yolo | California | 6113 | 212 | 24 |
194013 | 194013 | 2020-05-31 | Yolo | California | 6113 | 211 | 24 |
190946 | 190946 | 2020-05-30 | Yolo | California | 6113 | 211 | 24 |
187881 | 187881 | 2020-05-29 | Yolo | California | 6113 | 210 | 24 |
184825 | 184825 | 2020-05-28 | Yolo | California | 6113 | 207 | 23 |
181771 | 181771 | 2020-05-27 | Yolo | California | 6113 | 205 | 22 |
178727 | 178727 | 2020-05-26 | Yolo | California | 6113 | 200 | 22 |
175683 | 175683 | 2020-05-25 | Yolo | California | 6113 | 198 | 22 |
172639 | 172639 | 2020-05-24 | Yolo | California | 6113 | 194 | 22 |
169598 | 169598 | 2020-05-23 | Yolo | California | 6113 | 190 | 22 |
166561 | 166561 | 2020-05-22 | Yolo | California | 6113 | 188 | 22 |
163528 | 163528 | 2020-05-21 | Yolo | California | 6113 | 186 | 22 |
160500 | 160500 | 2020-05-20 | Yolo | California | 6113 | 185 | 22 |
157474 | 157474 | 2020-05-19 | Yolo | California | 6113 | 185 | 22 |
154458 | 154458 | 2020-05-18 | Yolo | California | 6113 | 184 | 22 |
151446 | 151446 | 2020-05-17 | Yolo | California | 6113 | 184 | 22 |
148437 | 148437 | 2020-05-16 | Yolo | California | 6113 | 183 | 22 |
145434 | 145434 | 2020-05-15 | Yolo | California | 6113 | 182 | 22 |
142434 | 142434 | 2020-05-14 | Yolo | California | 6113 | 182 | 22 |
139438 | 139438 | 2020-05-13 | Yolo | California | 6113 | 179 | 22 |
136447 | 136447 | 2020-05-12 | Yolo | California | 6113 | 177 | 22 |
133458 | 133458 | 2020-05-11 | Yolo | California | 6113 | 174 | 20 |
130467 | 130467 | 2020-05-10 | Yolo | California | 6113 | 173 | 20 |
127477 | 127477 | 2020-05-09 | Yolo | California | 6113 | 172 | 20 |
124491 | 124491 | 2020-05-08 | Yolo | California | 6113 | 172 | 20 |
121511 | 121511 | 2020-05-07 | Yolo | California | 6113 | 172 | 20 |
118544 | 118544 | 2020-05-06 | Yolo | California | 6113 | 172 | 20 |
115585 | 115585 | 2020-05-05 | Yolo | California | 6113 | 172 | 19 |
112702 | 112702 | 2020-05-04 | Yolo | California | 6113 | 171 | 19 |
109827 | 109827 | 2020-05-03 | Yolo | California | 6113 | 171 | 18 |
106958 | 106958 | 2020-05-02 | Yolo | California | 6113 | 171 | 18 |
104093 | 104093 | 2020-05-01 | Yolo | California | 6113 | 169 | 16 |
101238 | 101238 | 2020-04-30 | Yolo | California | 6113 | 164 | 16 |
98388 | 98388 | 2020-04-29 | Yolo | California | 6113 | 163 | 16 |
95543 | 95543 | 2020-04-28 | Yolo | California | 6113 | 162 | 16 |
92711 | 92711 | 2020-04-27 | Yolo | California | 6113 | 161 | 16 |
89893 | 89893 | 2020-04-26 | Yolo | California | 6113 | 161 | 14 |
87076 | 87076 | 2020-04-25 | Yolo | California | 6113 | 158 | 13 |
84268 | 84268 | 2020-04-24 | Yolo | California | 6113 | 157 | 13 |
81468 | 81468 | 2020-04-23 | Yolo | California | 6113 | 155 | 12 |
78674 | 78674 | 2020-04-22 | Yolo | California | 6113 | 151 | 12 |
75890 | 75890 | 2020-04-21 | Yolo | California | 6113 | 146 | 10 |
73114 | 73114 | 2020-04-20 | Yolo | California | 6113 | 142 | 10 |
70345 | 70345 | 2020-04-19 | Yolo | California | 6113 | 137 | 9 |
67583 | 67583 | 2020-04-18 | Yolo | California | 6113 | 137 | 8 |
64835 | 64835 | 2020-04-17 | Yolo | California | 6113 | 126 | 8 |
62102 | 62102 | 2020-04-16 | Yolo | California | 6113 | 125 | 7 |
59383 | 59383 | 2020-04-15 | Yolo | California | 6113 | 116 | 7 |
56675 | 56675 | 2020-04-14 | Yolo | California | 6113 | 102 | 4 |
53983 | 53983 | 2020-04-13 | Yolo | California | 6113 | 101 | 4 |
51304 | 51304 | 2020-04-12 | Yolo | California | 6113 | 93 | 3 |
48642 | 48642 | 2020-04-11 | Yolo | California | 6113 | 88 | 3 |
46012 | 46012 | 2020-04-10 | Yolo | California | 6113 | 75 | 3 |
43412 | 43412 | 2020-04-09 | Yolo | California | 6113 | 71 | 3 |
40840 | 40840 | 2020-04-08 | Yolo | California | 6113 | 67 | 3 |
38297 | 38297 | 2020-04-07 | Yolo | California | 6113 | 56 | 2 |
35807 | 35807 | 2020-04-06 | Yolo | California | 6113 | 50 | 1 |
33362 | 33362 | 2020-04-05 | Yolo | California | 6113 | 37 | 1 |
30956 | 30956 | 2020-04-04 | Yolo | California | 6113 | 33 | 1 |
28599 | 28599 | 2020-04-03 | Yolo | California | 6113 | 33 | 1 |
26299 | 26299 | 2020-04-02 | Yolo | California | 6113 | 28 | 1 |
24070 | 24070 | 2020-04-01 | Yolo | California | 6113 | 28 | 1 |
21911 | 21911 | 2020-03-31 | Yolo | California | 6113 | 25 | 1 |
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);