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 |
---|---|---|---|---|---|---|---|
1053710 | 1053710 | 2021-02-22 | Los Angeles | California | 6037 | 1181994 | 19904 |
1050463 | 1050463 | 2021-02-21 | Los Angeles | California | 6037 | 1181060 | 19885 |
1047216 | 1047216 | 2021-02-20 | Los Angeles | California | 6037 | 1179633 | 19793 |
1043971 | 1043971 | 2021-02-19 | Los Angeles | California | 6037 | 1177340 | 19662 |
1040726 | 1040726 | 2021-02-18 | Los Angeles | California | 6037 | 1174897 | 19514 |
1037481 | 1037481 | 2021-02-17 | Los Angeles | California | 6037 | 1172221 | 19368 |
1034236 | 1034236 | 2021-02-16 | Los Angeles | California | 6037 | 1170100 | 19215 |
1030990 | 1030990 | 2021-02-15 | Los Angeles | California | 6037 | 1168904 | 19095 |
1027743 | 1027743 | 2021-02-14 | Los Angeles | California | 6037 | 1167074 | 19066 |
1024498 | 1024498 | 2021-02-13 | Los Angeles | California | 6037 | 1165294 | 18984 |
1021253 | 1021253 | 2021-02-12 | Los Angeles | California | 6037 | 1162294 | 18789 |
1018008 | 1018008 | 2021-02-11 | Los Angeles | California | 6037 | 1159135 | 18658 |
1014763 | 1014763 | 2021-02-10 | Los Angeles | California | 6037 | 1155821 | 18500 |
1011518 | 1011518 | 2021-02-09 | Los Angeles | California | 6037 | 1152740 | 18360 |
1008272 | 1008272 | 2021-02-08 | Los Angeles | California | 6037 | 1149565 | 18135 |
1005026 | 1005026 | 2021-02-07 | Los Angeles | California | 6037 | 1146951 | 18044 |
1001780 | 1001780 | 2021-02-06 | Los Angeles | California | 6037 | 1143917 | 17955 |
998534 | 998534 | 2021-02-05 | Los Angeles | California | 6037 | 1139256 | 17764 |
995288 | 995288 | 2021-02-04 | Los Angeles | California | 6037 | 1134820 | 17539 |
992042 | 992042 | 2021-02-03 | Los Angeles | California | 6037 | 1129957 | 17308 |
988796 | 988796 | 2021-02-02 | Los Angeles | California | 6037 | 1125034 | 17057 |
985549 | 985549 | 2021-02-01 | Los Angeles | California | 6037 | 1121349 | 16854 |
982302 | 982302 | 2021-01-31 | Los Angeles | California | 6037 | 1117346 | 16770 |
979056 | 979056 | 2021-01-30 | Los Angeles | California | 6037 | 1111543 | 16647 |
975811 | 975811 | 2021-01-29 | Los Angeles | California | 6037 | 1104843 | 16332 |
972566 | 972566 | 2021-01-28 | Los Angeles | California | 6037 | 1098363 | 16107 |
969321 | 969321 | 2021-01-27 | Los Angeles | California | 6037 | 1092134 | 15897 |
966077 | 966077 | 2021-01-26 | Los Angeles | California | 6037 | 1085466 | 15592 |
962832 | 962832 | 2021-01-25 | Los Angeles | California | 6037 | 1079818 | 15303 |
959587 | 959587 | 2021-01-24 | Los Angeles | California | 6037 | 1073533 | 15260 |
956341 | 956341 | 2021-01-23 | Los Angeles | California | 6037 | 1065309 | 15162 |
953096 | 953096 | 2021-01-22 | Los Angeles | California | 6037 | 1055214 | 14894 |
949851 | 949851 | 2021-01-21 | Los Angeles | California | 6037 | 1046424 | 14641 |
946605 | 946605 | 2021-01-20 | Los Angeles | California | 6037 | 1038495 | 14384 |
943358 | 943358 | 2021-01-19 | Los Angeles | California | 6037 | 1032277 | 14122 |
940113 | 940113 | 2021-01-18 | Los Angeles | California | 6037 | 1024592 | 13936 |
936868 | 936868 | 2021-01-17 | Los Angeles | California | 6037 | 1015063 | 13848 |
933623 | 933623 | 2021-01-16 | Los Angeles | California | 6037 | 1004322 | 13741 |
930378 | 930378 | 2021-01-15 | Los Angeles | California | 6037 | 990326 | 13489 |
927133 | 927133 | 2021-01-14 | Los Angeles | California | 6037 | 975693 | 13234 |
923887 | 923887 | 2021-01-13 | Los Angeles | California | 6037 | 958891 | 12955 |
920642 | 920642 | 2021-01-12 | Los Angeles | California | 6037 | 944713 | 12674 |
917397 | 917397 | 2021-01-11 | Los Angeles | California | 6037 | 933083 | 12387 |
914152 | 914152 | 2021-01-10 | Los Angeles | California | 6037 | 920560 | 12250 |
910907 | 910907 | 2021-01-09 | Los Angeles | California | 6037 | 906554 | 12084 |
907662 | 907662 | 2021-01-08 | Los Angeles | California | 6037 | 889787 | 11863 |
904416 | 904416 | 2021-01-07 | Los Angeles | California | 6037 | 871749 | 11545 |
901171 | 901171 | 2021-01-06 | Los Angeles | California | 6037 | 852510 | 11328 |
897926 | 897926 | 2021-01-05 | Los Angeles | California | 6037 | 840956 | 11071 |
894681 | 894681 | 2021-01-04 | Los Angeles | California | 6037 | 827843 | 10850 |
891434 | 891434 | 2021-01-03 | Los Angeles | California | 6037 | 818959 | 10773 |
888187 | 888187 | 2021-01-02 | Los Angeles | California | 6037 | 806523 | 10682 |
884942 | 884942 | 2021-01-01 | Los Angeles | California | 6037 | 790895 | 10552 |
881697 | 881697 | 2020-12-31 | Los Angeles | California | 6037 | 770915 | 10345 |
878452 | 878452 | 2020-12-30 | Los Angeles | California | 6037 | 756412 | 10056 |
875207 | 875207 | 2020-12-29 | Los Angeles | California | 6037 | 746381 | 9782 |
871962 | 871962 | 2020-12-28 | Los Angeles | California | 6037 | 733612 | 9555 |
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 |
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);