ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
768128 | 768128 | 2020-11-26 | Sacramento | California | 6067 | 35738 | 566 |
764882 | 764882 | 2020-11-25 | Sacramento | California | 6067 | 35738 | 566 |
761637 | 761637 | 2020-11-24 | Sacramento | California | 6067 | 35142 | 557 |
758392 | 758392 | 2020-11-23 | Sacramento | California | 6067 | 34185 | 550 |
755145 | 755145 | 2020-11-22 | Sacramento | California | 6067 | 33132 | 546 |
751899 | 751899 | 2020-11-21 | Sacramento | California | 6067 | 32864 | 546 |
748653 | 748653 | 2020-11-20 | Sacramento | California | 6067 | 32864 | 546 |
745407 | 745407 | 2020-11-19 | Sacramento | California | 6067 | 32410 | 544 |
742160 | 742160 | 2020-11-18 | Sacramento | California | 6067 | 31851 | 536 |
738913 | 738913 | 2020-11-17 | Sacramento | California | 6067 | 31386 | 533 |
735669 | 735669 | 2020-11-16 | Sacramento | California | 6067 | 30998 | 527 |
732423 | 732423 | 2020-11-15 | Sacramento | California | 6067 | 30297 | 520 |
729178 | 729178 | 2020-11-14 | Sacramento | California | 6067 | 29836 | 520 |
725935 | 725935 | 2020-11-13 | Sacramento | California | 6067 | 29836 | 520 |
722692 | 722692 | 2020-11-12 | Sacramento | California | 6067 | 29509 | 517 |
719449 | 719449 | 2020-11-11 | Sacramento | California | 6067 | 29013 | 514 |
716206 | 716206 | 2020-11-10 | Sacramento | California | 6067 | 28720 | 514 |
712962 | 712962 | 2020-11-09 | Sacramento | California | 6067 | 28236 | 513 |
709718 | 709718 | 2020-11-08 | Sacramento | California | 6067 | 27772 | 508 |
706474 | 706474 | 2020-11-07 | Sacramento | California | 6067 | 27529 | 508 |
703231 | 703231 | 2020-11-06 | Sacramento | California | 6067 | 27529 | 508 |
699988 | 699988 | 2020-11-05 | Sacramento | California | 6067 | 27277 | 506 |
696744 | 696744 | 2020-11-04 | Sacramento | California | 6067 | 27042 | 506 |
693502 | 693502 | 2020-11-03 | Sacramento | California | 6067 | 26883 | 504 |
690259 | 690259 | 2020-11-02 | Sacramento | California | 6067 | 26715 | 502 |
687014 | 687014 | 2020-11-01 | Sacramento | California | 6067 | 26315 | 500 |
683770 | 683770 | 2020-10-31 | Sacramento | California | 6067 | 26184 | 500 |
680527 | 680527 | 2020-10-30 | Sacramento | California | 6067 | 26184 | 500 |
677284 | 677284 | 2020-10-29 | Sacramento | California | 6067 | 26017 | 500 |
674041 | 674041 | 2020-10-28 | Sacramento | California | 6067 | 25881 | 499 |
670799 | 670799 | 2020-10-27 | Sacramento | California | 6067 | 25749 | 496 |
667556 | 667556 | 2020-10-26 | Sacramento | California | 6067 | 25600 | 491 |
664311 | 664311 | 2020-10-25 | Sacramento | California | 6067 | 25371 | 484 |
661067 | 661067 | 2020-10-24 | Sacramento | California | 6067 | 25263 | 484 |
657823 | 657823 | 2020-10-23 | Sacramento | California | 6067 | 25263 | 484 |
654578 | 654578 | 2020-10-22 | Sacramento | California | 6067 | 25093 | 482 |
651333 | 651333 | 2020-10-21 | Sacramento | California | 6067 | 24956 | 480 |
648089 | 648089 | 2020-10-20 | Sacramento | California | 6067 | 24810 | 474 |
644844 | 644844 | 2020-10-19 | Sacramento | California | 6067 | 24581 | 471 |
641596 | 641596 | 2020-10-18 | Sacramento | California | 6067 | 24303 | 468 |
638349 | 638349 | 2020-10-17 | Sacramento | California | 6067 | 24191 | 468 |
635104 | 635104 | 2020-10-16 | Sacramento | California | 6067 | 24191 | 468 |
631858 | 631858 | 2020-10-15 | Sacramento | California | 6067 | 24101 | 464 |
628614 | 628614 | 2020-10-14 | Sacramento | California | 6067 | 24059 | 462 |
625371 | 625371 | 2020-10-13 | Sacramento | California | 6067 | 23968 | 458 |
622128 | 622128 | 2020-10-12 | Sacramento | California | 6067 | 23849 | 458 |
618885 | 618885 | 2020-10-11 | Sacramento | California | 6067 | 23688 | 450 |
615643 | 615643 | 2020-10-10 | Sacramento | California | 6067 | 23648 | 450 |
612402 | 612402 | 2020-10-09 | Sacramento | California | 6067 | 23648 | 450 |
609160 | 609160 | 2020-10-08 | Sacramento | California | 6067 | 23522 | 447 |
605917 | 605917 | 2020-10-07 | Sacramento | California | 6067 | 23419 | 445 |
602675 | 602675 | 2020-10-06 | Sacramento | California | 6067 | 23362 | 437 |
599432 | 599432 | 2020-10-05 | Sacramento | California | 6067 | 23244 | 432 |
596189 | 596189 | 2020-10-04 | Sacramento | California | 6067 | 23075 | 430 |
592947 | 592947 | 2020-10-03 | Sacramento | California | 6067 | 22854 | 430 |
589707 | 589707 | 2020-10-02 | Sacramento | California | 6067 | 22854 | 430 |
586466 | 586466 | 2020-10-01 | Sacramento | California | 6067 | 22754 | 426 |
583226 | 583226 | 2020-09-30 | Sacramento | California | 6067 | 22653 | 420 |
579987 | 579987 | 2020-09-29 | Sacramento | California | 6067 | 22589 | 416 |
576746 | 576746 | 2020-09-28 | Sacramento | California | 6067 | 22437 | 412 |
573503 | 573503 | 2020-09-27 | Sacramento | California | 6067 | 22268 | 406 |
570261 | 570261 | 2020-09-26 | Sacramento | California | 6067 | 22182 | 406 |
567019 | 567019 | 2020-09-25 | Sacramento | California | 6067 | 22182 | 406 |
563779 | 563779 | 2020-09-24 | Sacramento | California | 6067 | 22025 | 402 |
560540 | 560540 | 2020-09-23 | Sacramento | California | 6067 | 21871 | 399 |
557304 | 557304 | 2020-09-22 | Sacramento | California | 6067 | 21799 | 393 |
554067 | 554067 | 2020-09-21 | Sacramento | California | 6067 | 21627 | 383 |
550828 | 550828 | 2020-09-20 | Sacramento | California | 6067 | 21296 | 375 |
547589 | 547589 | 2020-09-19 | Sacramento | California | 6067 | 21170 | 375 |
544351 | 544351 | 2020-09-18 | Sacramento | California | 6067 | 21170 | 375 |
541115 | 541115 | 2020-09-17 | Sacramento | California | 6067 | 20960 | 371 |
537878 | 537878 | 2020-09-16 | Sacramento | California | 6067 | 20659 | 364 |
534642 | 534642 | 2020-09-15 | Sacramento | California | 6067 | 20544 | 358 |
531407 | 531407 | 2020-09-14 | Sacramento | California | 6067 | 20434 | 356 |
528170 | 528170 | 2020-09-13 | Sacramento | California | 6067 | 20183 | 350 |
524934 | 524934 | 2020-09-12 | Sacramento | California | 6067 | 20062 | 350 |
521698 | 521698 | 2020-09-11 | Sacramento | California | 6067 | 20062 | 350 |
518461 | 518461 | 2020-09-10 | Sacramento | California | 6067 | 19668 | 346 |
515226 | 515226 | 2020-09-09 | Sacramento | California | 6067 | 19523 | 339 |
511993 | 511993 | 2020-09-08 | Sacramento | California | 6067 | 19459 | 334 |
508760 | 508760 | 2020-09-07 | Sacramento | California | 6067 | 19345 | 332 |
505528 | 505528 | 2020-09-06 | Sacramento | California | 6067 | 18954 | 327 |
502294 | 502294 | 2020-09-05 | Sacramento | California | 6067 | 18812 | 327 |
499060 | 499060 | 2020-09-04 | Sacramento | California | 6067 | 18812 | 327 |
495827 | 495827 | 2020-09-03 | Sacramento | California | 6067 | 18606 | 317 |
492593 | 492593 | 2020-09-02 | Sacramento | California | 6067 | 18412 | 304 |
489360 | 489360 | 2020-09-01 | Sacramento | California | 6067 | 18285 | 296 |
486127 | 486127 | 2020-08-31 | Sacramento | California | 6067 | 18051 | 293 |
482892 | 482892 | 2020-08-30 | Sacramento | California | 6067 | 17587 | 274 |
479658 | 479658 | 2020-08-29 | Sacramento | California | 6067 | 17149 | 274 |
476425 | 476425 | 2020-08-28 | Sacramento | California | 6067 | 17149 | 274 |
473192 | 473192 | 2020-08-27 | Sacramento | California | 6067 | 16908 | 265 |
469960 | 469960 | 2020-08-26 | Sacramento | California | 6067 | 16741 | 259 |
466731 | 466731 | 2020-08-25 | Sacramento | California | 6067 | 16622 | 252 |
463502 | 463502 | 2020-08-24 | Sacramento | California | 6067 | 16330 | 246 |
460273 | 460273 | 2020-08-23 | Sacramento | California | 6067 | 15515 | 234 |
457046 | 457046 | 2020-08-22 | Sacramento | California | 6067 | 15246 | 234 |
453818 | 453818 | 2020-08-21 | Sacramento | California | 6067 | 15245 | 234 |
450590 | 450590 | 2020-08-20 | Sacramento | California | 6067 | 14983 | 230 |
447362 | 447362 | 2020-08-19 | Sacramento | California | 6067 | 14759 | 230 |
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);