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 |
---|---|---|---|---|---|---|---|
1517959 | 1517959 | 2021-07-15 | Los Angeles | California | 6037 | 1263254 | 24578 |
1514712 | 1514712 | 2021-07-14 | Los Angeles | California | 6037 | 1261902 | 24569 |
1511466 | 1511466 | 2021-07-13 | Los Angeles | California | 6037 | 1260948 | 24559 |
1508219 | 1508219 | 2021-07-12 | Los Angeles | California | 6037 | 1259900 | 24558 |
1504973 | 1504973 | 2021-07-11 | Los Angeles | California | 6037 | 1258298 | 24542 |
1501727 | 1501727 | 2021-07-10 | Los Angeles | California | 6037 | 1257185 | 24542 |
1498481 | 1498481 | 2021-07-09 | Los Angeles | California | 6037 | 1256761 | 24542 |
1495234 | 1495234 | 2021-07-08 | Los Angeles | California | 6037 | 1256034 | 24531 |
1491987 | 1491987 | 2021-07-07 | Los Angeles | California | 6037 | 1254202 | 24525 |
1488740 | 1488740 | 2021-07-06 | Los Angeles | California | 6037 | 1253732 | 24522 |
1485493 | 1485493 | 2021-07-05 | Los Angeles | California | 6037 | 1253404 | 24506 |
1482247 | 1482247 | 2021-07-04 | Los Angeles | California | 6037 | 1252968 | 24506 |
1479000 | 1479000 | 2021-07-03 | Los Angeles | California | 6037 | 1252513 | 24506 |
1475754 | 1475754 | 2021-07-02 | Los Angeles | California | 6037 | 1251889 | 24506 |
1472508 | 1472508 | 2021-07-01 | Los Angeles | California | 6037 | 1251383 | 24499 |
1469263 | 1469263 | 2021-06-30 | Los Angeles | California | 6037 | 1250908 | 24498 |
1466018 | 1466018 | 2021-06-29 | Los Angeles | California | 6037 | 1250503 | 24496 |
1462773 | 1462773 | 2021-06-28 | Los Angeles | California | 6037 | 1250227 | 24493 |
1459528 | 1459528 | 2021-06-27 | Los Angeles | California | 6037 | 1249971 | 24490 |
1456283 | 1456283 | 2021-06-26 | Los Angeles | California | 6037 | 1249732 | 24483 |
1453038 | 1453038 | 2021-06-25 | Los Angeles | California | 6037 | 1249404 | 24480 |
1449792 | 1449792 | 2021-06-24 | Los Angeles | California | 6037 | 1249083 | 24472 |
1446547 | 1446547 | 2021-06-23 | Los Angeles | California | 6037 | 1248796 | 24461 |
1443302 | 1443302 | 2021-06-22 | Los Angeles | California | 6037 | 1248567 | 24459 |
1440057 | 1440057 | 2021-06-21 | Los Angeles | California | 6037 | 1248410 | 24456 |
1436810 | 1436810 | 2021-06-20 | Los Angeles | California | 6037 | 1248285 | 24454 |
1433563 | 1433563 | 2021-06-19 | Los Angeles | California | 6037 | 1248028 | 24451 |
1430317 | 1430317 | 2021-06-18 | Los Angeles | California | 6037 | 1247883 | 24444 |
1427072 | 1427072 | 2021-06-17 | Los Angeles | California | 6037 | 1247699 | 24439 |
1423827 | 1423827 | 2021-06-16 | Los Angeles | California | 6037 | 1247488 | 24435 |
1420579 | 1420579 | 2021-06-15 | Los Angeles | California | 6037 | 1247286 | 24434 |
1417334 | 1417334 | 2021-06-14 | Los Angeles | California | 6037 | 1247103 | 24433 |
1414088 | 1414088 | 2021-06-13 | Los Angeles | California | 6037 | 1246974 | 24434 |
1410843 | 1410843 | 2021-06-12 | Los Angeles | California | 6037 | 1246790 | 24434 |
1407598 | 1407598 | 2021-06-11 | Los Angeles | California | 6037 | 1246616 | 24440 |
1404352 | 1404352 | 2021-06-10 | Los Angeles | California | 6037 | 1246438 | 24432 |
1401107 | 1401107 | 2021-06-09 | Los Angeles | California | 6037 | 1246255 | 24426 |
1397862 | 1397862 | 2021-06-08 | Los Angeles | California | 6037 | 1246081 | 24413 |
1394615 | 1394615 | 2021-06-07 | Los Angeles | California | 6037 | 1245921 | 24410 |
1391370 | 1391370 | 2021-06-06 | Los Angeles | California | 6037 | 1245788 | 24411 |
1388125 | 1388125 | 2021-06-05 | Los Angeles | California | 6037 | 1245585 | 24400 |
1384880 | 1384880 | 2021-06-04 | Los Angeles | California | 6037 | 1245330 | 24386 |
1381634 | 1381634 | 2021-06-03 | Los Angeles | California | 6037 | 1245127 | 24375 |
1378389 | 1378389 | 2021-06-02 | Los Angeles | California | 6037 | 1244924 | 24367 |
1375143 | 1375143 | 2021-06-01 | Los Angeles | California | 6037 | 1244831 | 24364 |
1371898 | 1371898 | 2021-05-31 | Los Angeles | California | 6037 | 1244722 | 24360 |
1368653 | 1368653 | 2021-05-30 | Los Angeles | California | 6037 | 1244550 | 24359 |
1365407 | 1365407 | 2021-05-29 | Los Angeles | California | 6037 | 1244380 | 24357 |
1362161 | 1362161 | 2021-05-28 | Los Angeles | California | 6037 | 1244188 | 24348 |
1358914 | 1358914 | 2021-05-27 | Los Angeles | California | 6037 | 1243985 | 24321 |
1355668 | 1355668 | 2021-05-26 | Los Angeles | California | 6037 | 1239945 | 24212 |
1352422 | 1352422 | 2021-05-25 | Los Angeles | California | 6037 | 1239758 | 24201 |
1349176 | 1349176 | 2021-05-24 | Los Angeles | California | 6037 | 1239584 | 24197 |
1345929 | 1345929 | 2021-05-23 | Los Angeles | California | 6037 | 1239446 | 24192 |
1342681 | 1342681 | 2021-05-22 | Los Angeles | California | 6037 | 1239272 | 24180 |
1339433 | 1339433 | 2021-05-21 | Los Angeles | California | 6037 | 1239031 | 24168 |
1336186 | 1336186 | 2021-05-20 | Los Angeles | California | 6037 | 1238785 | 24143 |
1332939 | 1332939 | 2021-05-19 | Los Angeles | California | 6037 | 1238563 | 24133 |
1329692 | 1329692 | 2021-05-18 | Los Angeles | California | 6037 | 1238345 | 24123 |
1326445 | 1326445 | 2021-05-17 | Los Angeles | California | 6037 | 1238225 | 24120 |
1323199 | 1323199 | 2021-05-16 | Los Angeles | California | 6037 | 1238075 | 24115 |
1319953 | 1319953 | 2021-05-15 | Los Angeles | California | 6037 | 1237899 | 24101 |
1316706 | 1316706 | 2021-05-14 | Los Angeles | California | 6037 | 1237652 | 24083 |
1313459 | 1313459 | 2021-05-13 | Los Angeles | California | 6037 | 1237120 | 24067 |
1310212 | 1310212 | 2021-05-12 | Los Angeles | California | 6037 | 1236907 | 24048 |
1306966 | 1306966 | 2021-05-11 | Los Angeles | California | 6037 | 1236634 | 24030 |
1303720 | 1303720 | 2021-05-10 | Los Angeles | California | 6037 | 1236461 | 24026 |
1300473 | 1300473 | 2021-05-09 | Los Angeles | California | 6037 | 1236316 | 24022 |
1297226 | 1297226 | 2021-05-08 | Los Angeles | California | 6037 | 1236087 | 24008 |
1293980 | 1293980 | 2021-05-07 | Los Angeles | California | 6037 | 1235783 | 23991 |
1290734 | 1290734 | 2021-05-06 | Los Angeles | California | 6037 | 1235411 | 23977 |
1287488 | 1287488 | 2021-05-05 | Los Angeles | California | 6037 | 1235037 | 23957 |
1284242 | 1284242 | 2021-05-04 | Los Angeles | California | 6037 | 1234865 | 23942 |
1280995 | 1280995 | 2021-05-03 | Los Angeles | California | 6037 | 1234648 | 23943 |
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 |
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);