ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 6037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
868717 | 868717 | 2020-12-27 | Los Angeles | California | 6037 | 720099 | 9482 |
865472 | 865472 | 2020-12-26 | Los Angeles | California | 6037 | 706712 | 9438 |
862227 | 862227 | 2020-12-25 | Los Angeles | California | 6037 | 677538 | 9299 |
858982 | 858982 | 2020-12-24 | Los Angeles | California | 6037 | 677538 | 9299 |
855737 | 855737 | 2020-12-23 | Los Angeles | California | 6037 | 664193 | 9153 |
852492 | 852492 | 2020-12-22 | Los Angeles | California | 6037 | 647766 | 9016 |
849247 | 849247 | 2020-12-21 | Los Angeles | California | 6037 | 635058 | 8931 |
846002 | 846002 | 2020-12-20 | Los Angeles | California | 6037 | 623875 | 8875 |
842756 | 842756 | 2020-12-19 | Los Angeles | California | 6037 | 610562 | 8817 |
839511 | 839511 | 2020-12-18 | Los Angeles | California | 6037 | 596910 | 8757 |
836266 | 836266 | 2020-12-17 | Los Angeles | California | 6037 | 580505 | 8664 |
833020 | 833020 | 2020-12-16 | Los Angeles | California | 6037 | 566185 | 8568 |
829773 | 829773 | 2020-12-15 | Los Angeles | California | 6037 | 543949 | 8431 |
826527 | 826527 | 2020-12-14 | Los Angeles | California | 6037 | 532895 | 8345 |
823280 | 823280 | 2020-12-13 | Los Angeles | California | 6037 | 525651 | 8298 |
820034 | 820034 | 2020-12-12 | Los Angeles | California | 6037 | 513029 | 8269 |
816788 | 816788 | 2020-12-11 | Los Angeles | California | 6037 | 501792 | 8199 |
813542 | 813542 | 2020-12-10 | Los Angeles | California | 6037 | 488055 | 8149 |
810298 | 810298 | 2020-12-09 | Los Angeles | California | 6037 | 475409 | 8075 |
807053 | 807053 | 2020-12-08 | Los Angeles | California | 6037 | 466459 | 8000 |
803808 | 803808 | 2020-12-07 | Los Angeles | California | 6037 | 458011 | 7936 |
800563 | 800563 | 2020-12-06 | Los Angeles | California | 6037 | 449982 | 7909 |
797318 | 797318 | 2020-12-05 | Los Angeles | California | 6037 | 439538 | 7886 |
794073 | 794073 | 2020-12-04 | Los Angeles | California | 6037 | 430713 | 7842 |
790828 | 790828 | 2020-12-03 | Los Angeles | California | 6037 | 422000 | 7782 |
787583 | 787583 | 2020-12-02 | Los Angeles | California | 6037 | 414304 | 7740 |
784339 | 784339 | 2020-12-01 | Los Angeles | California | 6037 | 408515 | 7700 |
781094 | 781094 | 2020-11-30 | Los Angeles | California | 6037 | 401034 | 7655 |
777848 | 777848 | 2020-11-29 | Los Angeles | California | 6037 | 395957 | 7639 |
774603 | 774603 | 2020-11-28 | Los Angeles | California | 6037 | 391004 | 7623 |
771358 | 771358 | 2020-11-27 | Los Angeles | California | 6037 | 387793 | 7604 |
768113 | 768113 | 2020-11-26 | Los Angeles | California | 6037 | 383373 | 7580 |
764867 | 764867 | 2020-11-25 | Los Angeles | California | 6037 | 378421 | 7543 |
761622 | 761622 | 2020-11-24 | Los Angeles | California | 6037 | 374231 | 7497 |
758377 | 758377 | 2020-11-23 | Los Angeles | California | 6037 | 370729 | 7446 |
755130 | 755130 | 2020-11-22 | Los Angeles | California | 6037 | 364613 | 7438 |
751884 | 751884 | 2020-11-21 | Los Angeles | California | 6037 | 361962 | 7429 |
748638 | 748638 | 2020-11-20 | Los Angeles | California | 6037 | 357541 | 7396 |
745392 | 745392 | 2020-11-19 | Los Angeles | California | 6037 | 353316 | 7363 |
742145 | 742145 | 2020-11-18 | Los Angeles | California | 6037 | 348420 | 7335 |
738898 | 738898 | 2020-11-17 | Los Angeles | California | 6037 | 344607 | 7299 |
735654 | 735654 | 2020-11-16 | Los Angeles | California | 6037 | 342425 | 7275 |
732408 | 732408 | 2020-11-15 | Los Angeles | California | 6037 | 339640 | 7269 |
729163 | 729163 | 2020-11-14 | Los Angeles | California | 6037 | 336630 | 7266 |
725920 | 725920 | 2020-11-13 | Los Angeles | California | 6037 | 332945 | 7246 |
722677 | 722677 | 2020-11-12 | Los Angeles | California | 6037 | 330528 | 7221 |
719434 | 719434 | 2020-11-11 | Los Angeles | California | 6037 | 328042 | 7216 |
716191 | 716191 | 2020-11-10 | Los Angeles | California | 6037 | 325951 | 7200 |
712947 | 712947 | 2020-11-09 | Los Angeles | California | 6037 | 323699 | 7177 |
709703 | 709703 | 2020-11-08 | Los Angeles | California | 6037 | 322281 | 7172 |
706459 | 706459 | 2020-11-07 | Los Angeles | California | 6037 | 320048 | 7170 |
703216 | 703216 | 2020-11-06 | Los Angeles | California | 6037 | 317727 | 7157 |
699973 | 699973 | 2020-11-05 | Los Angeles | California | 6037 | 315634 | 7140 |
696729 | 696729 | 2020-11-04 | Los Angeles | California | 6037 | 313526 | 7117 |
693487 | 693487 | 2020-11-03 | Los Angeles | California | 6037 | 311745 | 7097 |
690244 | 690244 | 2020-11-02 | Los Angeles | California | 6037 | 310595 | 7076 |
686999 | 686999 | 2020-11-01 | Los Angeles | California | 6037 | 309190 | 7074 |
683755 | 683755 | 2020-10-31 | Los Angeles | California | 6037 | 307618 | 7071 |
680512 | 680512 | 2020-10-30 | Los Angeles | California | 6037 | 306327 | 7056 |
677269 | 677269 | 2020-10-29 | Los Angeles | California | 6037 | 305070 | 7044 |
674026 | 674026 | 2020-10-28 | Los Angeles | California | 6037 | 303369 | 7040 |
670784 | 670784 | 2020-10-27 | Los Angeles | California | 6037 | 302077 | 7027 |
667541 | 667541 | 2020-10-26 | Los Angeles | California | 6037 | 300614 | 7000 |
664296 | 664296 | 2020-10-25 | Los Angeles | California | 6037 | 299760 | 6993 |
661052 | 661052 | 2020-10-24 | Los Angeles | California | 6037 | 298937 | 6989 |
657808 | 657808 | 2020-10-23 | Los Angeles | California | 6037 | 296821 | 6974 |
654563 | 654563 | 2020-10-22 | Los Angeles | California | 6037 | 294065 | 6956 |
651318 | 651318 | 2020-10-21 | Los Angeles | California | 6037 | 290486 | 6944 |
648074 | 648074 | 2020-10-20 | Los Angeles | California | 6037 | 290009 | 6912 |
644829 | 644829 | 2020-10-19 | Los Angeles | California | 6037 | 289366 | 6877 |
641581 | 641581 | 2020-10-18 | Los Angeles | California | 6037 | 288451 | 6876 |
638334 | 638334 | 2020-10-17 | Los Angeles | California | 6037 | 288136 | 6863 |
635089 | 635089 | 2020-10-16 | Los Angeles | California | 6037 | 287222 | 6855 |
631843 | 631843 | 2020-10-15 | Los Angeles | California | 6037 | 286183 | 6834 |
628599 | 628599 | 2020-10-14 | Los Angeles | California | 6037 | 285016 | 6812 |
625356 | 625356 | 2020-10-13 | Los Angeles | California | 6037 | 283750 | 6790 |
622113 | 622113 | 2020-10-12 | Los Angeles | California | 6037 | 282982 | 6773 |
618870 | 618870 | 2020-10-11 | Los Angeles | California | 6037 | 282135 | 6771 |
615628 | 615628 | 2020-10-10 | Los Angeles | California | 6037 | 281165 | 6768 |
612387 | 612387 | 2020-10-09 | Los Angeles | California | 6037 | 279909 | 6741 |
609145 | 609145 | 2020-10-08 | Los Angeles | California | 6037 | 278665 | 6726 |
605902 | 605902 | 2020-10-07 | Los Angeles | California | 6037 | 277445 | 6709 |
602660 | 602660 | 2020-10-06 | Los Angeles | California | 6037 | 275856 | 6681 |
599417 | 599417 | 2020-10-05 | Los Angeles | California | 6037 | 274942 | 6654 |
596174 | 596174 | 2020-10-04 | Los Angeles | California | 6037 | 274565 | 6647 |
592932 | 592932 | 2020-10-03 | Los Angeles | California | 6037 | 273638 | 6642 |
589692 | 589692 | 2020-10-02 | Los Angeles | California | 6037 | 272653 | 6626 |
586451 | 586451 | 2020-10-01 | Los Angeles | California | 6037 | 271371 | 6610 |
583211 | 583211 | 2020-09-30 | Los Angeles | California | 6037 | 270299 | 6576 |
579972 | 579972 | 2020-09-29 | Los Angeles | California | 6037 | 269284 | 6551 |
576731 | 576731 | 2020-09-28 | Los Angeles | California | 6037 | 268455 | 6515 |
573488 | 573488 | 2020-09-27 | Los Angeles | California | 6037 | 267801 | 6514 |
570246 | 570246 | 2020-09-26 | Los Angeles | California | 6037 | 266988 | 6504 |
567004 | 567004 | 2020-09-25 | Los Angeles | California | 6037 | 265775 | 6488 |
563764 | 563764 | 2020-09-24 | Los Angeles | California | 6037 | 264414 | 6455 |
560525 | 560525 | 2020-09-23 | Los Angeles | California | 6037 | 263333 | 6423 |
557289 | 557289 | 2020-09-22 | Los Angeles | California | 6037 | 262133 | 6401 |
554052 | 554052 | 2020-09-21 | Los Angeles | California | 6037 | 261446 | 6366 |
550813 | 550813 | 2020-09-20 | Los Angeles | California | 6037 | 260797 | 6353 |
547574 | 547574 | 2020-09-19 | Los Angeles | California | 6037 | 259817 | 6330 |
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);