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 |
---|---|---|---|---|---|---|---|
768095 | 768095 | 2020-11-26 | Alameda | California | 6001 | 28399 | 502 |
764849 | 764849 | 2020-11-25 | Alameda | California | 6001 | 28246 | 502 |
761604 | 761604 | 2020-11-24 | Alameda | California | 6001 | 27878 | 499 |
758359 | 758359 | 2020-11-23 | Alameda | California | 6001 | 27643 | 499 |
755112 | 755112 | 2020-11-22 | Alameda | California | 6001 | 27506 | 499 |
751866 | 751866 | 2020-11-21 | Alameda | California | 6001 | 27456 | 499 |
748620 | 748620 | 2020-11-20 | Alameda | California | 6001 | 27244 | 499 |
745374 | 745374 | 2020-11-19 | Alameda | California | 6001 | 26948 | 495 |
742127 | 742127 | 2020-11-18 | Alameda | California | 6001 | 26676 | 494 |
738880 | 738880 | 2020-11-17 | Alameda | California | 6001 | 26481 | 493 |
735636 | 735636 | 2020-11-16 | Alameda | California | 6001 | 26068 | 490 |
732390 | 732390 | 2020-11-15 | Alameda | California | 6001 | 25893 | 490 |
729145 | 729145 | 2020-11-14 | Alameda | California | 6001 | 25781 | 489 |
725902 | 725902 | 2020-11-13 | Alameda | California | 6001 | 25620 | 486 |
722659 | 722659 | 2020-11-12 | Alameda | California | 6001 | 25421 | 486 |
719416 | 719416 | 2020-11-11 | Alameda | California | 6001 | 25270 | 483 |
716173 | 716173 | 2020-11-10 | Alameda | California | 6001 | 25131 | 475 |
712929 | 712929 | 2020-11-09 | Alameda | California | 6001 | 25022 | 475 |
709685 | 709685 | 2020-11-08 | Alameda | California | 6001 | 24872 | 475 |
706441 | 706441 | 2020-11-07 | Alameda | California | 6001 | 24685 | 475 |
703198 | 703198 | 2020-11-06 | Alameda | California | 6001 | 24439 | 471 |
699955 | 699955 | 2020-11-05 | Alameda | California | 6001 | 24391 | 465 |
696711 | 696711 | 2020-11-04 | Alameda | California | 6001 | 24254 | 466 |
693469 | 693469 | 2020-11-03 | Alameda | California | 6001 | 24183 | 466 |
690226 | 690226 | 2020-11-02 | Alameda | California | 6001 | 24116 | 464 |
686981 | 686981 | 2020-11-01 | Alameda | California | 6001 | 24015 | 464 |
683737 | 683737 | 2020-10-31 | Alameda | California | 6001 | 23897 | 464 |
680494 | 680494 | 2020-10-30 | Alameda | California | 6001 | 23796 | 463 |
677251 | 677251 | 2020-10-29 | Alameda | California | 6001 | 23657 | 463 |
674008 | 674008 | 2020-10-28 | Alameda | California | 6001 | 23597 | 462 |
670766 | 670766 | 2020-10-27 | Alameda | California | 6001 | 23492 | 462 |
667523 | 667523 | 2020-10-26 | Alameda | California | 6001 | 23412 | 461 |
664278 | 664278 | 2020-10-25 | Alameda | California | 6001 | 23333 | 461 |
661034 | 661034 | 2020-10-24 | Alameda | California | 6001 | 23236 | 460 |
657790 | 657790 | 2020-10-23 | Alameda | California | 6001 | 23154 | 456 |
654545 | 654545 | 2020-10-22 | Alameda | California | 6001 | 23022 | 456 |
651300 | 651300 | 2020-10-21 | Alameda | California | 6001 | 22953 | 435 |
648056 | 648056 | 2020-10-20 | Alameda | California | 6001 | 22828 | 433 |
644811 | 644811 | 2020-10-19 | Alameda | California | 6001 | 22759 | 433 |
641563 | 641563 | 2020-10-18 | Alameda | California | 6001 | 22657 | 442 |
638316 | 638316 | 2020-10-17 | Alameda | California | 6001 | 22480 | 442 |
635071 | 635071 | 2020-10-16 | Alameda | California | 6001 | 22429 | 439 |
631825 | 631825 | 2020-10-15 | Alameda | California | 6001 | 22391 | 442 |
628581 | 628581 | 2020-10-14 | Alameda | California | 6001 | 22346 | 442 |
625338 | 625338 | 2020-10-13 | Alameda | California | 6001 | 22300 | 431 |
622095 | 622095 | 2020-10-12 | Alameda | California | 6001 | 22237 | 436 |
618852 | 618852 | 2020-10-11 | Alameda | California | 6001 | 22170 | 441 |
615610 | 615610 | 2020-10-10 | Alameda | California | 6001 | 22093 | 441 |
612369 | 612369 | 2020-10-09 | Alameda | California | 6001 | 21963 | 440 |
609127 | 609127 | 2020-10-08 | Alameda | California | 6001 | 21959 | 440 |
605884 | 605884 | 2020-10-07 | Alameda | California | 6001 | 21866 | 440 |
602642 | 602642 | 2020-10-06 | Alameda | California | 6001 | 21830 | 427 |
599399 | 599399 | 2020-10-05 | Alameda | California | 6001 | 21767 | 425 |
596156 | 596156 | 2020-10-04 | Alameda | California | 6001 | 21729 | 426 |
592914 | 592914 | 2020-10-03 | Alameda | California | 6001 | 21642 | 426 |
589674 | 589674 | 2020-10-02 | Alameda | California | 6001 | 21529 | 420 |
586433 | 586433 | 2020-10-01 | Alameda | California | 6001 | 21479 | 420 |
583193 | 583193 | 2020-09-30 | Alameda | California | 6001 | 21404 | 412 |
579954 | 579954 | 2020-09-29 | Alameda | California | 6001 | 21344 | 408 |
576713 | 576713 | 2020-09-28 | Alameda | California | 6001 | 21261 | 406 |
573470 | 573470 | 2020-09-27 | Alameda | California | 6001 | 21210 | 406 |
570228 | 570228 | 2020-09-26 | Alameda | California | 6001 | 21157 | 406 |
566986 | 566986 | 2020-09-25 | Alameda | California | 6001 | 21049 | 404 |
563746 | 563746 | 2020-09-24 | Alameda | California | 6001 | 20972 | 397 |
560507 | 560507 | 2020-09-23 | Alameda | California | 6001 | 20860 | 395 |
557271 | 557271 | 2020-09-22 | Alameda | California | 6001 | 20769 | 390 |
554034 | 554034 | 2020-09-21 | Alameda | California | 6001 | 20662 | 374 |
550795 | 550795 | 2020-09-20 | Alameda | California | 6001 | 20579 | 374 |
547556 | 547556 | 2020-09-19 | Alameda | California | 6001 | 20515 | 374 |
544318 | 544318 | 2020-09-18 | Alameda | California | 6001 | 20385 | 370 |
541082 | 541082 | 2020-09-17 | Alameda | California | 6001 | 20183 | 365 |
537845 | 537845 | 2020-09-16 | Alameda | California | 6001 | 20118 | 356 |
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 |
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);