ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
354 rows where fips = 6037 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923967 | 923967 | 2021-01-13 | Los Angeles | California | 6037 | 958891 | 12955 |
920722 | 920722 | 2021-01-12 | Los Angeles | California | 6037 | 944713 | 12674 |
917477 | 917477 | 2021-01-11 | Los Angeles | California | 6037 | 933083 | 12387 |
914232 | 914232 | 2021-01-10 | Los Angeles | California | 6037 | 920560 | 12250 |
910987 | 910987 | 2021-01-09 | Los Angeles | California | 6037 | 906554 | 12084 |
907742 | 907742 | 2021-01-08 | Los Angeles | California | 6037 | 889787 | 11863 |
904496 | 904496 | 2021-01-07 | Los Angeles | California | 6037 | 871749 | 11545 |
901251 | 901251 | 2021-01-06 | Los Angeles | California | 6037 | 852510 | 11328 |
898006 | 898006 | 2021-01-05 | Los Angeles | California | 6037 | 840956 | 11071 |
894761 | 894761 | 2021-01-04 | Los Angeles | California | 6037 | 827843 | 10850 |
891514 | 891514 | 2021-01-03 | Los Angeles | California | 6037 | 818959 | 10773 |
888267 | 888267 | 2021-01-02 | Los Angeles | California | 6037 | 806523 | 10682 |
885022 | 885022 | 2021-01-01 | Los Angeles | California | 6037 | 790895 | 10552 |
881777 | 881777 | 2020-12-31 | Los Angeles | California | 6037 | 770915 | 10345 |
878532 | 878532 | 2020-12-30 | Los Angeles | California | 6037 | 756412 | 10056 |
875287 | 875287 | 2020-12-29 | Los Angeles | California | 6037 | 746381 | 9782 |
872042 | 872042 | 2020-12-28 | Los Angeles | California | 6037 | 733612 | 9555 |
868797 | 868797 | 2020-12-27 | Los Angeles | California | 6037 | 720099 | 9482 |
865552 | 865552 | 2020-12-26 | Los Angeles | California | 6037 | 706712 | 9438 |
862307 | 862307 | 2020-12-25 | Los Angeles | California | 6037 | 677538 | 9299 |
859062 | 859062 | 2020-12-24 | Los Angeles | California | 6037 | 677538 | 9299 |
855817 | 855817 | 2020-12-23 | Los Angeles | California | 6037 | 664193 | 9153 |
852572 | 852572 | 2020-12-22 | Los Angeles | California | 6037 | 647766 | 9016 |
849327 | 849327 | 2020-12-21 | Los Angeles | California | 6037 | 635058 | 8931 |
846082 | 846082 | 2020-12-20 | Los Angeles | California | 6037 | 623875 | 8875 |
842836 | 842836 | 2020-12-19 | Los Angeles | California | 6037 | 610562 | 8817 |
839591 | 839591 | 2020-12-18 | Los Angeles | California | 6037 | 596910 | 8757 |
836346 | 836346 | 2020-12-17 | Los Angeles | California | 6037 | 580505 | 8664 |
833100 | 833100 | 2020-12-16 | Los Angeles | California | 6037 | 566185 | 8568 |
829853 | 829853 | 2020-12-15 | Los Angeles | California | 6037 | 543949 | 8431 |
826607 | 826607 | 2020-12-14 | Los Angeles | California | 6037 | 532895 | 8345 |
823360 | 823360 | 2020-12-13 | Los Angeles | California | 6037 | 525651 | 8298 |
820114 | 820114 | 2020-12-12 | Los Angeles | California | 6037 | 513029 | 8269 |
816868 | 816868 | 2020-12-11 | Los Angeles | California | 6037 | 501792 | 8199 |
813622 | 813622 | 2020-12-10 | Los Angeles | California | 6037 | 488055 | 8149 |
810378 | 810378 | 2020-12-09 | Los Angeles | California | 6037 | 475409 | 8075 |
807133 | 807133 | 2020-12-08 | Los Angeles | California | 6037 | 466459 | 8000 |
803888 | 803888 | 2020-12-07 | Los Angeles | California | 6037 | 458011 | 7936 |
800642 | 800642 | 2020-12-06 | Los Angeles | California | 6037 | 449982 | 7909 |
797396 | 797396 | 2020-12-05 | Los Angeles | California | 6037 | 439538 | 7886 |
794151 | 794151 | 2020-12-04 | Los Angeles | California | 6037 | 430713 | 7842 |
790905 | 790905 | 2020-12-03 | Los Angeles | California | 6037 | 422000 | 7782 |
787659 | 787659 | 2020-12-02 | Los Angeles | California | 6037 | 414304 | 7740 |
784415 | 784415 | 2020-12-01 | Los Angeles | California | 6037 | 408515 | 7700 |
781170 | 781170 | 2020-11-30 | Los Angeles | California | 6037 | 401034 | 7655 |
777924 | 777924 | 2020-11-29 | Los Angeles | California | 6037 | 395957 | 7639 |
774678 | 774678 | 2020-11-28 | Los Angeles | California | 6037 | 391004 | 7623 |
771433 | 771433 | 2020-11-27 | Los Angeles | California | 6037 | 387793 | 7604 |
768187 | 768187 | 2020-11-26 | Los Angeles | California | 6037 | 383373 | 7580 |
764940 | 764940 | 2020-11-25 | Los Angeles | California | 6037 | 378421 | 7543 |
761694 | 761694 | 2020-11-24 | Los Angeles | California | 6037 | 374231 | 7497 |
758448 | 758448 | 2020-11-23 | Los Angeles | California | 6037 | 370729 | 7446 |
755201 | 755201 | 2020-11-22 | Los Angeles | California | 6037 | 364613 | 7438 |
751954 | 751954 | 2020-11-21 | Los Angeles | California | 6037 | 361962 | 7429 |
748707 | 748707 | 2020-11-20 | Los Angeles | California | 6037 | 357541 | 7396 |
745460 | 745460 | 2020-11-19 | Los Angeles | California | 6037 | 353316 | 7363 |
742213 | 742213 | 2020-11-18 | Los Angeles | California | 6037 | 348420 | 7335 |
738966 | 738966 | 2020-11-17 | Los Angeles | California | 6037 | 344607 | 7299 |
735721 | 735721 | 2020-11-16 | Los Angeles | California | 6037 | 342425 | 7275 |
732475 | 732475 | 2020-11-15 | Los Angeles | California | 6037 | 339640 | 7269 |
729230 | 729230 | 2020-11-14 | Los Angeles | California | 6037 | 336630 | 7266 |
725986 | 725986 | 2020-11-13 | Los Angeles | California | 6037 | 332945 | 7246 |
722742 | 722742 | 2020-11-12 | Los Angeles | California | 6037 | 330528 | 7221 |
719498 | 719498 | 2020-11-11 | Los Angeles | California | 6037 | 328042 | 7216 |
716254 | 716254 | 2020-11-10 | Los Angeles | California | 6037 | 325951 | 7200 |
713010 | 713010 | 2020-11-09 | Los Angeles | California | 6037 | 323699 | 7177 |
709766 | 709766 | 2020-11-08 | Los Angeles | California | 6037 | 322281 | 7172 |
706522 | 706522 | 2020-11-07 | Los Angeles | California | 6037 | 320048 | 7170 |
703279 | 703279 | 2020-11-06 | Los Angeles | California | 6037 | 317727 | 7157 |
700035 | 700035 | 2020-11-05 | Los Angeles | California | 6037 | 315634 | 7140 |
696790 | 696790 | 2020-11-04 | Los Angeles | California | 6037 | 313526 | 7117 |
693547 | 693547 | 2020-11-03 | Los Angeles | California | 6037 | 311745 | 7097 |
690304 | 690304 | 2020-11-02 | Los Angeles | California | 6037 | 310595 | 7076 |
687059 | 687059 | 2020-11-01 | Los Angeles | California | 6037 | 309190 | 7074 |
683814 | 683814 | 2020-10-31 | Los Angeles | California | 6037 | 307618 | 7071 |
680570 | 680570 | 2020-10-30 | Los Angeles | California | 6037 | 306327 | 7056 |
677327 | 677327 | 2020-10-29 | Los Angeles | California | 6037 | 305070 | 7044 |
674083 | 674083 | 2020-10-28 | Los Angeles | California | 6037 | 303369 | 7040 |
670841 | 670841 | 2020-10-27 | Los Angeles | California | 6037 | 302077 | 7027 |
667598 | 667598 | 2020-10-26 | Los Angeles | California | 6037 | 300614 | 7000 |
664352 | 664352 | 2020-10-25 | Los Angeles | California | 6037 | 299760 | 6993 |
661107 | 661107 | 2020-10-24 | Los Angeles | California | 6037 | 298937 | 6989 |
657863 | 657863 | 2020-10-23 | Los Angeles | California | 6037 | 296821 | 6974 |
654618 | 654618 | 2020-10-22 | Los Angeles | California | 6037 | 294065 | 6956 |
651373 | 651373 | 2020-10-21 | Los Angeles | California | 6037 | 290486 | 6944 |
648129 | 648129 | 2020-10-20 | Los Angeles | California | 6037 | 290009 | 6912 |
644884 | 644884 | 2020-10-19 | Los Angeles | California | 6037 | 289366 | 6877 |
641636 | 641636 | 2020-10-18 | Los Angeles | California | 6037 | 288451 | 6876 |
638389 | 638389 | 2020-10-17 | Los Angeles | California | 6037 | 288136 | 6863 |
635144 | 635144 | 2020-10-16 | Los Angeles | California | 6037 | 287222 | 6855 |
631898 | 631898 | 2020-10-15 | Los Angeles | California | 6037 | 286183 | 6834 |
628654 | 628654 | 2020-10-14 | Los Angeles | California | 6037 | 285016 | 6812 |
625411 | 625411 | 2020-10-13 | Los Angeles | California | 6037 | 283750 | 6790 |
622168 | 622168 | 2020-10-12 | Los Angeles | California | 6037 | 282982 | 6773 |
618925 | 618925 | 2020-10-11 | Los Angeles | California | 6037 | 282135 | 6771 |
615683 | 615683 | 2020-10-10 | Los Angeles | California | 6037 | 281165 | 6768 |
612442 | 612442 | 2020-10-09 | Los Angeles | California | 6037 | 279909 | 6741 |
609200 | 609200 | 2020-10-08 | Los Angeles | California | 6037 | 278665 | 6726 |
605957 | 605957 | 2020-10-07 | Los Angeles | California | 6037 | 277445 | 6709 |
602715 | 602715 | 2020-10-06 | Los Angeles | California | 6037 | 275856 | 6681 |
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]);