ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 6001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386125 | 386125 | 2020-07-31 | Alameda | California | 6001 | 11324 | 182 |
382907 | 382907 | 2020-07-30 | Alameda | California | 6001 | 11198 | 182 |
379690 | 379690 | 2020-07-29 | Alameda | California | 6001 | 10896 | 181 |
376474 | 376474 | 2020-07-28 | Alameda | California | 6001 | 10666 | 181 |
373260 | 373260 | 2020-07-27 | Alameda | California | 6001 | 10510 | 178 |
370048 | 370048 | 2020-07-26 | Alameda | California | 6001 | 10391 | 178 |
366838 | 366838 | 2020-07-25 | Alameda | California | 6001 | 10351 | 178 |
363631 | 363631 | 2020-07-24 | Alameda | California | 6001 | 10235 | 178 |
360424 | 360424 | 2020-07-23 | Alameda | California | 6001 | 9890 | 173 |
357219 | 357219 | 2020-07-22 | Alameda | California | 6001 | 9664 | 171 |
354016 | 354016 | 2020-07-21 | Alameda | California | 6001 | 9404 | 167 |
350814 | 350814 | 2020-07-20 | Alameda | California | 6001 | 9277 | 162 |
347613 | 347613 | 2020-07-19 | Alameda | California | 6001 | 9258 | 162 |
344413 | 344413 | 2020-07-18 | Alameda | California | 6001 | 9131 | 162 |
341214 | 341214 | 2020-07-17 | Alameda | California | 6001 | 8879 | 161 |
338018 | 338018 | 2020-07-16 | Alameda | California | 6001 | 8648 | 154 |
334823 | 334823 | 2020-07-15 | Alameda | California | 6001 | 8499 | 154 |
331630 | 331630 | 2020-07-14 | Alameda | California | 6001 | 8342 | 152 |
328444 | 328444 | 2020-07-13 | Alameda | California | 6001 | 8077 | 148 |
325258 | 325258 | 2020-07-12 | Alameda | California | 6001 | 7866 | 148 |
322077 | 322077 | 2020-07-11 | Alameda | California | 6001 | 7746 | 148 |
318898 | 318898 | 2020-07-10 | Alameda | California | 6001 | 7506 | 147 |
315725 | 315725 | 2020-07-09 | Alameda | California | 6001 | 7428 | 146 |
312550 | 312550 | 2020-07-08 | Alameda | California | 6001 | 7266 | 142 |
309380 | 309380 | 2020-07-07 | Alameda | California | 6001 | 6991 | 140 |
306212 | 306212 | 2020-07-06 | Alameda | California | 6001 | 6908 | 140 |
303048 | 303048 | 2020-07-05 | Alameda | California | 6001 | 6876 | 140 |
299884 | 299884 | 2020-07-04 | Alameda | California | 6001 | 6577 | 140 |
296722 | 296722 | 2020-07-03 | Alameda | California | 6001 | 6493 | 140 |
293566 | 293566 | 2020-07-02 | Alameda | California | 6001 | 6405 | 138 |
290412 | 290412 | 2020-07-01 | Alameda | California | 6001 | 6177 | 136 |
287261 | 287261 | 2020-06-30 | Alameda | California | 6001 | 5985 | 135 |
284115 | 284115 | 2020-06-29 | Alameda | California | 6001 | 5783 | 133 |
280969 | 280969 | 2020-06-28 | Alameda | California | 6001 | 5691 | 133 |
277822 | 277822 | 2020-06-27 | Alameda | California | 6001 | 5523 | 130 |
274674 | 274674 | 2020-06-26 | Alameda | California | 6001 | 5514 | 130 |
271534 | 271534 | 2020-06-25 | Alameda | California | 6001 | 5403 | 128 |
268399 | 268399 | 2020-06-24 | Alameda | California | 6001 | 5296 | 122 |
265269 | 265269 | 2020-06-23 | Alameda | California | 6001 | 5161 | 121 |
262141 | 262141 | 2020-06-22 | Alameda | California | 6001 | 5028 | 120 |
259014 | 259014 | 2020-06-21 | Alameda | California | 6001 | 4826 | 119 |
255887 | 255887 | 2020-06-20 | Alameda | California | 6001 | 4826 | 118 |
252768 | 252768 | 2020-06-19 | Alameda | California | 6001 | 4723 | 118 |
249653 | 249653 | 2020-06-18 | Alameda | California | 6001 | 4659 | 117 |
246541 | 246541 | 2020-06-17 | Alameda | California | 6001 | 4554 | 116 |
243428 | 243428 | 2020-06-16 | Alameda | California | 6001 | 4502 | 112 |
240317 | 240317 | 2020-06-15 | Alameda | California | 6001 | 4394 | 112 |
237209 | 237209 | 2020-06-14 | Alameda | California | 6001 | 4341 | 112 |
234102 | 234102 | 2020-06-13 | Alameda | California | 6001 | 4237 | 110 |
230996 | 230996 | 2020-06-12 | Alameda | California | 6001 | 4237 | 110 |
227893 | 227893 | 2020-06-11 | Alameda | California | 6001 | 4140 | 110 |
224791 | 224791 | 2020-06-10 | Alameda | California | 6001 | 4054 | 110 |
221696 | 221696 | 2020-06-09 | Alameda | California | 6001 | 4006 | 110 |
218601 | 218601 | 2020-06-08 | Alameda | California | 6001 | 3966 | 104 |
215510 | 215510 | 2020-06-07 | Alameda | California | 6001 | 3895 | 104 |
212423 | 212423 | 2020-06-06 | Alameda | California | 6001 | 3826 | 104 |
209338 | 209338 | 2020-06-05 | Alameda | California | 6001 | 3746 | 104 |
206257 | 206257 | 2020-06-04 | Alameda | California | 6001 | 3662 | 104 |
203177 | 203177 | 2020-06-03 | Alameda | California | 6001 | 3569 | 104 |
200101 | 200101 | 2020-06-02 | Alameda | California | 6001 | 3536 | 104 |
197028 | 197028 | 2020-06-01 | Alameda | California | 6001 | 3491 | 104 |
193958 | 193958 | 2020-05-31 | Alameda | California | 6001 | 3411 | 103 |
190891 | 190891 | 2020-05-30 | Alameda | California | 6001 | 3310 | 103 |
187826 | 187826 | 2020-05-29 | Alameda | California | 6001 | 3216 | 102 |
184770 | 184770 | 2020-05-28 | Alameda | California | 6001 | 3118 | 97 |
181716 | 181716 | 2020-05-27 | Alameda | California | 6001 | 3070 | 97 |
178672 | 178672 | 2020-05-26 | Alameda | California | 6001 | 3007 | 93 |
175628 | 175628 | 2020-05-25 | Alameda | California | 6001 | 2895 | 93 |
172584 | 172584 | 2020-05-24 | Alameda | California | 6001 | 2868 | 93 |
169543 | 169543 | 2020-05-23 | Alameda | California | 6001 | 2788 | 92 |
166507 | 166507 | 2020-05-22 | Alameda | California | 6001 | 2729 | 90 |
163475 | 163475 | 2020-05-21 | Alameda | California | 6001 | 2630 | 90 |
160447 | 160447 | 2020-05-20 | Alameda | California | 6001 | 2581 | 88 |
157421 | 157421 | 2020-05-19 | Alameda | California | 6001 | 2543 | 88 |
154405 | 154405 | 2020-05-18 | Alameda | California | 6001 | 2478 | 85 |
151393 | 151393 | 2020-05-17 | Alameda | California | 6001 | 2413 | 85 |
148384 | 148384 | 2020-05-16 | Alameda | California | 6001 | 2372 | 85 |
145380 | 145380 | 2020-05-15 | Alameda | California | 6001 | 2321 | 84 |
142381 | 142381 | 2020-05-14 | Alameda | California | 6001 | 2202 | 80 |
139385 | 139385 | 2020-05-13 | Alameda | California | 6001 | 2199 | 80 |
136394 | 136394 | 2020-05-12 | Alameda | California | 6001 | 2154 | 75 |
133404 | 133404 | 2020-05-11 | Alameda | California | 6001 | 2122 | 75 |
130414 | 130414 | 2020-05-10 | Alameda | California | 6001 | 2085 | 75 |
127424 | 127424 | 2020-05-09 | Alameda | California | 6001 | 2044 | 72 |
124439 | 124439 | 2020-05-08 | Alameda | California | 6001 | 1982 | 70 |
121459 | 121459 | 2020-05-07 | Alameda | California | 6001 | 1938 | 69 |
118492 | 118492 | 2020-05-06 | Alameda | California | 6001 | 1884 | 69 |
115533 | 115533 | 2020-05-05 | Alameda | California | 6001 | 1830 | 66 |
112650 | 112650 | 2020-05-04 | Alameda | California | 6001 | 1797 | 65 |
109775 | 109775 | 2020-05-03 | Alameda | California | 6001 | 1770 | 63 |
106906 | 106906 | 2020-05-02 | Alameda | California | 6001 | 1726 | 63 |
104041 | 104041 | 2020-05-01 | Alameda | California | 6001 | 1657 | 63 |
101186 | 101186 | 2020-04-30 | Alameda | California | 6001 | 1624 | 63 |
98336 | 98336 | 2020-04-29 | Alameda | California | 6001 | 1589 | 59 |
95491 | 95491 | 2020-04-28 | Alameda | California | 6001 | 1554 | 59 |
92660 | 92660 | 2020-04-27 | Alameda | California | 6001 | 1519 | 56 |
89842 | 89842 | 2020-04-26 | Alameda | California | 6001 | 1489 | 52 |
87025 | 87025 | 2020-04-25 | Alameda | California | 6001 | 1458 | 52 |
84217 | 84217 | 2020-04-24 | Alameda | California | 6001 | 1422 | 48 |
81417 | 81417 | 2020-04-23 | Alameda | California | 6001 | 1350 | 48 |
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);