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 |
---|---|---|---|---|---|---|---|
534609 | 534609 | 2020-09-15 | Alameda | California | 6001 | 20118 | 356 |
531374 | 531374 | 2020-09-14 | Alameda | California | 6001 | 20043 | 332 |
528137 | 528137 | 2020-09-13 | Alameda | California | 6001 | 20012 | 332 |
524901 | 524901 | 2020-09-12 | Alameda | California | 6001 | 19858 | 320 |
521665 | 521665 | 2020-09-11 | Alameda | California | 6001 | 19840 | 320 |
518428 | 518428 | 2020-09-10 | Alameda | California | 6001 | 19731 | 303 |
515193 | 515193 | 2020-09-09 | Alameda | California | 6001 | 19617 | 303 |
511960 | 511960 | 2020-09-08 | Alameda | California | 6001 | 19517 | 303 |
508727 | 508727 | 2020-09-07 | Alameda | California | 6001 | 19371 | 300 |
505495 | 505495 | 2020-09-06 | Alameda | California | 6001 | 19152 | 299 |
502261 | 502261 | 2020-09-05 | Alameda | California | 6001 | 19152 | 299 |
499027 | 499027 | 2020-09-04 | Alameda | California | 6001 | 18998 | 296 |
495794 | 495794 | 2020-09-03 | Alameda | California | 6001 | 18873 | 295 |
492560 | 492560 | 2020-09-02 | Alameda | California | 6001 | 18716 | 274 |
489327 | 489327 | 2020-09-01 | Alameda | California | 6001 | 18466 | 257 |
486094 | 486094 | 2020-08-31 | Alameda | California | 6001 | 18208 | 257 |
482859 | 482859 | 2020-08-30 | Alameda | California | 6001 | 18061 | 258 |
479625 | 479625 | 2020-08-29 | Alameda | California | 6001 | 17868 | 247 |
476392 | 476392 | 2020-08-28 | Alameda | California | 6001 | 17868 | 247 |
473159 | 473159 | 2020-08-27 | Alameda | California | 6001 | 17642 | 244 |
469927 | 469927 | 2020-08-26 | Alameda | California | 6001 | 17406 | 243 |
466698 | 466698 | 2020-08-25 | Alameda | California | 6001 | 17296 | 240 |
463469 | 463469 | 2020-08-24 | Alameda | California | 6001 | 16807 | 234 |
460240 | 460240 | 2020-08-23 | Alameda | California | 6001 | 16744 | 234 |
457013 | 457013 | 2020-08-22 | Alameda | California | 6001 | 16714 | 234 |
453785 | 453785 | 2020-08-21 | Alameda | California | 6001 | 16490 | 234 |
450557 | 450557 | 2020-08-20 | Alameda | California | 6001 | 16205 | 231 |
447329 | 447329 | 2020-08-19 | Alameda | California | 6001 | 15857 | 228 |
444102 | 444102 | 2020-08-18 | Alameda | California | 6001 | 15475 | 224 |
440876 | 440876 | 2020-08-17 | Alameda | California | 6001 | 15359 | 221 |
437650 | 437650 | 2020-08-16 | Alameda | California | 6001 | 15186 | 221 |
434424 | 434424 | 2020-08-15 | Alameda | California | 6001 | 14930 | 219 |
431199 | 431199 | 2020-08-14 | Alameda | California | 6001 | 14579 | 219 |
427971 | 427971 | 2020-08-13 | Alameda | California | 6001 | 14250 | 216 |
424747 | 424747 | 2020-08-12 | Alameda | California | 6001 | 14120 | 212 |
421526 | 421526 | 2020-08-11 | Alameda | California | 6001 | 13685 | 205 |
418305 | 418305 | 2020-08-10 | Alameda | California | 6001 | 13262 | 193 |
415084 | 415084 | 2020-08-09 | Alameda | California | 6001 | 13108 | 193 |
411864 | 411864 | 2020-08-08 | Alameda | California | 6001 | 12826 | 193 |
408645 | 408645 | 2020-08-07 | Alameda | California | 6001 | 12161 | 193 |
405425 | 405425 | 2020-08-06 | Alameda | California | 6001 | 12161 | 193 |
402207 | 402207 | 2020-08-05 | Alameda | California | 6001 | 12157 | 193 |
398991 | 398991 | 2020-08-04 | Alameda | California | 6001 | 11930 | 192 |
395775 | 395775 | 2020-08-03 | Alameda | California | 6001 | 11867 | 189 |
392559 | 392559 | 2020-08-02 | Alameda | California | 6001 | 11611 | 189 |
389342 | 389342 | 2020-08-01 | Alameda | California | 6001 | 11505 | 189 |
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 |
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);