ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
834 rows where fips = 6085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
868741 | 868741 | 2020-12-27 | Santa Clara | California | 6085 | 64974 | 653 |
865496 | 865496 | 2020-12-26 | Santa Clara | California | 6085 | 63302 | 653 |
862251 | 862251 | 2020-12-25 | Santa Clara | California | 6085 | 61742 | 644 |
859006 | 859006 | 2020-12-24 | Santa Clara | California | 6085 | 61090 | 644 |
855761 | 855761 | 2020-12-23 | Santa Clara | California | 6085 | 59923 | 633 |
852516 | 852516 | 2020-12-22 | Santa Clara | California | 6085 | 58637 | 616 |
849271 | 849271 | 2020-12-21 | Santa Clara | California | 6085 | 57452 | 608 |
846026 | 846026 | 2020-12-20 | Santa Clara | California | 6085 | 56334 | 584 |
842780 | 842780 | 2020-12-19 | Santa Clara | California | 6085 | 54905 | 584 |
839535 | 839535 | 2020-12-18 | Santa Clara | California | 6085 | 53885 | 584 |
836290 | 836290 | 2020-12-17 | Santa Clara | California | 6085 | 52414 | 567 |
833044 | 833044 | 2020-12-16 | Santa Clara | California | 6085 | 51233 | 562 |
829797 | 829797 | 2020-12-15 | Santa Clara | California | 6085 | 50315 | 554 |
826551 | 826551 | 2020-12-14 | Santa Clara | California | 6085 | 49216 | 530 |
823304 | 823304 | 2020-12-13 | Santa Clara | California | 6085 | 48015 | 527 |
820058 | 820058 | 2020-12-12 | Santa Clara | California | 6085 | 45986 | 527 |
816812 | 816812 | 2020-12-11 | Santa Clara | California | 6085 | 45178 | 527 |
813566 | 813566 | 2020-12-10 | Santa Clara | California | 6085 | 44039 | 520 |
810322 | 810322 | 2020-12-09 | Santa Clara | California | 6085 | 43001 | 516 |
807077 | 807077 | 2020-12-08 | Santa Clara | California | 6085 | 41316 | 513 |
803832 | 803832 | 2020-12-07 | Santa Clara | California | 6085 | 40624 | 512 |
800587 | 800587 | 2020-12-06 | Santa Clara | California | 6085 | 39193 | 504 |
797342 | 797342 | 2020-12-05 | Santa Clara | California | 6085 | 38388 | 504 |
794097 | 794097 | 2020-12-04 | Santa Clara | California | 6085 | 37517 | 504 |
790852 | 790852 | 2020-12-03 | Santa Clara | California | 6085 | 36673 | 496 |
787607 | 787607 | 2020-12-02 | Santa Clara | California | 6085 | 35945 | 487 |
784363 | 784363 | 2020-12-01 | Santa Clara | California | 6085 | 35457 | 483 |
781118 | 781118 | 2020-11-30 | Santa Clara | California | 6085 | 35085 | 477 |
777872 | 777872 | 2020-11-29 | Santa Clara | California | 6085 | 34292 | 477 |
774627 | 774627 | 2020-11-28 | Santa Clara | California | 6085 | 33732 | 477 |
771382 | 771382 | 2020-11-27 | Santa Clara | California | 6085 | 32985 | 477 |
768137 | 768137 | 2020-11-26 | Santa Clara | California | 6085 | 32454 | 477 |
764891 | 764891 | 2020-11-25 | Santa Clara | California | 6085 | 32049 | 471 |
761646 | 761646 | 2020-11-24 | Santa Clara | California | 6085 | 31603 | 468 |
758401 | 758401 | 2020-11-23 | Santa Clara | California | 6085 | 31103 | 465 |
755154 | 755154 | 2020-11-22 | Santa Clara | California | 6085 | 30676 | 464 |
751908 | 751908 | 2020-11-21 | Santa Clara | California | 6085 | 30411 | 464 |
748662 | 748662 | 2020-11-20 | Santa Clara | California | 6085 | 30025 | 464 |
745416 | 745416 | 2020-11-19 | Santa Clara | California | 6085 | 29631 | 460 |
742169 | 742169 | 2020-11-18 | Santa Clara | California | 6085 | 29297 | 454 |
738922 | 738922 | 2020-11-17 | Santa Clara | California | 6085 | 29023 | 448 |
735678 | 735678 | 2020-11-16 | Santa Clara | California | 6085 | 28686 | 446 |
732432 | 732432 | 2020-11-15 | Santa Clara | California | 6085 | 28307 | 445 |
729187 | 729187 | 2020-11-14 | Santa Clara | California | 6085 | 27977 | 445 |
725944 | 725944 | 2020-11-13 | Santa Clara | California | 6085 | 27648 | 445 |
722701 | 722701 | 2020-11-12 | Santa Clara | California | 6085 | 27299 | 441 |
719458 | 719458 | 2020-11-11 | Santa Clara | California | 6085 | 27124 | 441 |
716215 | 716215 | 2020-11-10 | Santa Clara | California | 6085 | 26972 | 437 |
712971 | 712971 | 2020-11-09 | Santa Clara | California | 6085 | 26747 | 434 |
709727 | 709727 | 2020-11-08 | Santa Clara | California | 6085 | 26490 | 431 |
706483 | 706483 | 2020-11-07 | Santa Clara | California | 6085 | 26137 | 431 |
703240 | 703240 | 2020-11-06 | Santa Clara | California | 6085 | 25883 | 431 |
699997 | 699997 | 2020-11-05 | Santa Clara | California | 6085 | 25705 | 425 |
696753 | 696753 | 2020-11-04 | Santa Clara | California | 6085 | 25543 | 422 |
693511 | 693511 | 2020-11-03 | Santa Clara | California | 6085 | 25421 | 413 |
690268 | 690268 | 2020-11-02 | Santa Clara | California | 6085 | 25277 | 410 |
687023 | 687023 | 2020-11-01 | Santa Clara | California | 6085 | 25139 | 407 |
683779 | 683779 | 2020-10-31 | Santa Clara | California | 6085 | 24986 | 407 |
680536 | 680536 | 2020-10-30 | Santa Clara | California | 6085 | 24867 | 407 |
677293 | 677293 | 2020-10-29 | Santa Clara | California | 6085 | 24665 | 405 |
674050 | 674050 | 2020-10-28 | Santa Clara | California | 6085 | 24558 | 403 |
670808 | 670808 | 2020-10-27 | Santa Clara | California | 6085 | 24425 | 393 |
667565 | 667565 | 2020-10-26 | Santa Clara | California | 6085 | 24313 | 389 |
664320 | 664320 | 2020-10-25 | Santa Clara | California | 6085 | 24144 | 389 |
661076 | 661076 | 2020-10-24 | Santa Clara | California | 6085 | 24014 | 389 |
657832 | 657832 | 2020-10-23 | Santa Clara | California | 6085 | 23881 | 389 |
654587 | 654587 | 2020-10-22 | Santa Clara | California | 6085 | 23679 | 386 |
651342 | 651342 | 2020-10-21 | Santa Clara | California | 6085 | 23591 | 386 |
648098 | 648098 | 2020-10-20 | Santa Clara | California | 6085 | 23458 | 383 |
644853 | 644853 | 2020-10-19 | Santa Clara | California | 6085 | 23355 | 379 |
641605 | 641605 | 2020-10-18 | Santa Clara | California | 6085 | 23224 | 374 |
638358 | 638358 | 2020-10-17 | Santa Clara | California | 6085 | 23052 | 374 |
635113 | 635113 | 2020-10-16 | Santa Clara | California | 6085 | 22974 | 374 |
631867 | 631867 | 2020-10-15 | Santa Clara | California | 6085 | 22859 | 368 |
628623 | 628623 | 2020-10-14 | Santa Clara | California | 6085 | 22801 | 364 |
625380 | 625380 | 2020-10-13 | Santa Clara | California | 6085 | 22741 | 364 |
622137 | 622137 | 2020-10-12 | Santa Clara | California | 6085 | 22644 | 363 |
618894 | 618894 | 2020-10-11 | Santa Clara | California | 6085 | 22555 | 358 |
615652 | 615652 | 2020-10-10 | Santa Clara | California | 6085 | 22419 | 358 |
612411 | 612411 | 2020-10-09 | Santa Clara | California | 6085 | 22312 | 358 |
609169 | 609169 | 2020-10-08 | Santa Clara | California | 6085 | 22154 | 355 |
605926 | 605926 | 2020-10-07 | Santa Clara | California | 6085 | 22056 | 354 |
602684 | 602684 | 2020-10-06 | Santa Clara | California | 6085 | 21978 | 348 |
599441 | 599441 | 2020-10-05 | Santa Clara | California | 6085 | 21926 | 346 |
596198 | 596198 | 2020-10-04 | Santa Clara | California | 6085 | 21840 | 345 |
592956 | 592956 | 2020-10-03 | Santa Clara | California | 6085 | 21734 | 334 |
589716 | 589716 | 2020-10-02 | Santa Clara | California | 6085 | 21605 | 331 |
586475 | 586475 | 2020-10-01 | Santa Clara | California | 6085 | 21457 | 326 |
583235 | 583235 | 2020-09-30 | Santa Clara | California | 6085 | 21379 | 323 |
579996 | 579996 | 2020-09-29 | Santa Clara | California | 6085 | 21294 | 319 |
576755 | 576755 | 2020-09-28 | Santa Clara | California | 6085 | 21241 | 315 |
573512 | 573512 | 2020-09-27 | Santa Clara | California | 6085 | 21153 | 313 |
570270 | 570270 | 2020-09-26 | Santa Clara | California | 6085 | 21030 | 312 |
567028 | 567028 | 2020-09-25 | Santa Clara | California | 6085 | 20882 | 307 |
563788 | 563788 | 2020-09-24 | Santa Clara | California | 6085 | 20756 | 305 |
560549 | 560549 | 2020-09-23 | Santa Clara | California | 6085 | 20648 | 301 |
557313 | 557313 | 2020-09-22 | Santa Clara | California | 6085 | 20587 | 300 |
554076 | 554076 | 2020-09-21 | Santa Clara | California | 6085 | 20511 | 298 |
550837 | 550837 | 2020-09-20 | Santa Clara | California | 6085 | 20410 | 297 |
547598 | 547598 | 2020-09-19 | Santa Clara | California | 6085 | 20252 | 297 |
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);