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 |
---|---|---|---|---|---|---|---|
1277748 | 1277748 | 2021-05-02 | Los Angeles | California | 6037 | 1234435 | 23946 |
1274501 | 1274501 | 2021-05-01 | Los Angeles | California | 6037 | 1234151 | 23919 |
1271254 | 1271254 | 2021-04-30 | Los Angeles | California | 6037 | 1233723 | 23899 |
1268007 | 1268007 | 2021-04-29 | Los Angeles | California | 6037 | 1233036 | 23858 |
1264760 | 1264760 | 2021-04-28 | Los Angeles | California | 6037 | 1233036 | 23831 |
1261513 | 1261513 | 2021-04-27 | Los Angeles | California | 6037 | 1232742 | 23802 |
1258266 | 1258266 | 2021-04-26 | Los Angeles | California | 6037 | 1232469 | 23799 |
1255019 | 1255019 | 2021-04-25 | Los Angeles | California | 6037 | 1232195 | 23802 |
1251772 | 1251772 | 2021-04-24 | Los Angeles | California | 6037 | 1231826 | 23785 |
1248525 | 1248525 | 2021-04-23 | Los Angeles | California | 6037 | 1231448 | 23762 |
1245278 | 1245278 | 2021-04-22 | Los Angeles | California | 6037 | 1231024 | 23736 |
1242031 | 1242031 | 2021-04-21 | Los Angeles | California | 6037 | 1230660 | 23702 |
1238784 | 1238784 | 2021-04-20 | Los Angeles | California | 6037 | 1230303 | 23668 |
1235537 | 1235537 | 2021-04-19 | Los Angeles | California | 6037 | 1229973 | 23648 |
1232290 | 1232290 | 2021-04-18 | Los Angeles | California | 6037 | 1229659 | 23653 |
1229041 | 1229041 | 2021-04-17 | Los Angeles | California | 6037 | 1229226 | 23627 |
1225793 | 1225793 | 2021-04-16 | Los Angeles | California | 6037 | 1228776 | 23601 |
1222546 | 1222546 | 2021-04-15 | Los Angeles | California | 6037 | 1228176 | 23579 |
1219298 | 1219298 | 2021-04-14 | Los Angeles | California | 6037 | 1227626 | 23553 |
1216050 | 1216050 | 2021-04-13 | Los Angeles | California | 6037 | 1227256 | 23505 |
1212803 | 1212803 | 2021-04-12 | Los Angeles | California | 6037 | 1226851 | 23503 |
1209555 | 1209555 | 2021-04-11 | Los Angeles | California | 6037 | 1226456 | 23493 |
1206306 | 1206306 | 2021-04-10 | Los Angeles | California | 6037 | 1225916 | 23467 |
1203058 | 1203058 | 2021-04-09 | Los Angeles | California | 6037 | 1225163 | 23431 |
1199810 | 1199810 | 2021-04-08 | Los Angeles | California | 6037 | 1224450 | 23388 |
1196561 | 1196561 | 2021-04-07 | Los Angeles | California | 6037 | 1223832 | 23340 |
1193313 | 1193313 | 2021-04-06 | Los Angeles | California | 6037 | 1223435 | 23302 |
1190063 | 1190063 | 2021-04-05 | Los Angeles | California | 6037 | 1223104 | 23301 |
1186816 | 1186816 | 2021-04-04 | Los Angeles | California | 6037 | 1222771 | 23301 |
1183569 | 1183569 | 2021-04-03 | Los Angeles | California | 6037 | 1222262 | 23274 |
1180322 | 1180322 | 2021-04-02 | Los Angeles | California | 6037 | 1221506 | 23235 |
1177075 | 1177075 | 2021-04-01 | Los Angeles | California | 6037 | 1220900 | 23189 |
1173828 | 1173828 | 2021-03-31 | Los Angeles | California | 6037 | 1220217 | 23143 |
1170581 | 1170581 | 2021-03-30 | Los Angeles | California | 6037 | 1219612 | 23110 |
1167333 | 1167333 | 2021-03-29 | Los Angeles | California | 6037 | 1219237 | 23101 |
1164085 | 1164085 | 2021-03-28 | Los Angeles | California | 6037 | 1218879 | 23103 |
1160837 | 1160837 | 2021-03-27 | Los Angeles | California | 6037 | 1218359 | 23080 |
1157589 | 1157589 | 2021-03-26 | Los Angeles | California | 6037 | 1217686 | 23055 |
1154342 | 1154342 | 2021-03-25 | Los Angeles | California | 6037 | 1216904 | 23020 |
1151095 | 1151095 | 2021-03-24 | Los Angeles | California | 6037 | 1216386 | 22960 |
1147848 | 1147848 | 2021-03-23 | Los Angeles | California | 6037 | 1215776 | 22871 |
1144601 | 1144601 | 2021-03-22 | Los Angeles | California | 6037 | 1215330 | 22834 |
1141354 | 1141354 | 2021-03-21 | Los Angeles | California | 6037 | 1214825 | 22810 |
1138108 | 1138108 | 2021-03-20 | Los Angeles | California | 6037 | 1214431 | 22777 |
1134862 | 1134862 | 2021-03-19 | Los Angeles | California | 6037 | 1213934 | 22722 |
1131615 | 1131615 | 2021-03-18 | Los Angeles | California | 6037 | 1213242 | 22664 |
1128367 | 1128367 | 2021-03-17 | Los Angeles | California | 6037 | 1212389 | 22580 |
1125121 | 1125121 | 2021-03-16 | Los Angeles | California | 6037 | 1211561 | 22519 |
1121875 | 1121875 | 2021-03-15 | Los Angeles | California | 6037 | 1211319 | 22476 |
1118628 | 1118628 | 2021-03-14 | Los Angeles | California | 6037 | 1210920 | 22474 |
1115381 | 1115381 | 2021-03-13 | Los Angeles | California | 6037 | 1210286 | 22446 |
1112135 | 1112135 | 2021-03-12 | Los Angeles | California | 6037 | 1208678 | 22304 |
1108889 | 1108889 | 2021-03-11 | Los Angeles | California | 6037 | 1208672 | 22304 |
1105643 | 1105643 | 2021-03-10 | Los Angeles | California | 6037 | 1207361 | 22213 |
1102397 | 1102397 | 2021-03-09 | Los Angeles | California | 6037 | 1205924 | 22099 |
1099151 | 1099151 | 2021-03-08 | Los Angeles | California | 6037 | 1204665 | 22041 |
1095903 | 1095903 | 2021-03-07 | Los Angeles | California | 6037 | 1203799 | 22029 |
1092657 | 1092657 | 2021-03-06 | Los Angeles | California | 6037 | 1202513 | 22008 |
1089411 | 1089411 | 2021-03-05 | Los Angeles | California | 6037 | 1200764 | 21910 |
1086166 | 1086166 | 2021-03-04 | Los Angeles | California | 6037 | 1198737 | 21778 |
1082920 | 1082920 | 2021-03-03 | Los Angeles | California | 6037 | 1196552 | 21669 |
1079674 | 1079674 | 2021-03-02 | Los Angeles | California | 6037 | 1194878 | 21554 |
1076429 | 1076429 | 2021-03-01 | Los Angeles | California | 6037 | 1193531 | 21467 |
1073183 | 1073183 | 2021-02-28 | Los Angeles | California | 6037 | 1192559 | 21435 |
1069937 | 1069937 | 2021-02-27 | Los Angeles | California | 6037 | 1191521 | 21328 |
1066692 | 1066692 | 2021-02-26 | Los Angeles | California | 6037 | 1189859 | 21241 |
1063447 | 1063447 | 2021-02-25 | Los Angeles | California | 6037 | 1188101 | 21102 |
1060202 | 1060202 | 2021-02-24 | Los Angeles | California | 6037 | 1186074 | 20987 |
1056956 | 1056956 | 2021-02-23 | Los Angeles | California | 6037 | 1183969 | 20057 |
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 |
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);