ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
840 rows where fips = 6059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1517970 | 1517970 | 2021-07-15 | Orange | California | 6059 | 275358 | 5137 |
1514723 | 1514723 | 2021-07-14 | Orange | California | 6059 | 275358 | 5136 |
1511477 | 1511477 | 2021-07-13 | Orange | California | 6059 | 275358 | 5136 |
1508230 | 1508230 | 2021-07-12 | Orange | California | 6059 | 274132 | 5136 |
1504984 | 1504984 | 2021-07-11 | Orange | California | 6059 | 274132 | 5135 |
1501738 | 1501738 | 2021-07-10 | Orange | California | 6059 | 274132 | 5135 |
1498492 | 1498492 | 2021-07-09 | Orange | California | 6059 | 274132 | 5135 |
1495245 | 1495245 | 2021-07-08 | Orange | California | 6059 | 274132 | 5132 |
1491998 | 1491998 | 2021-07-07 | Orange | California | 6059 | 274132 | 5129 |
1488751 | 1488751 | 2021-07-06 | Orange | California | 6059 | 274132 | 5129 |
1485504 | 1485504 | 2021-07-05 | Orange | California | 6059 | 273738 | 5126 |
1482258 | 1482258 | 2021-07-04 | Orange | California | 6059 | 273738 | 5126 |
1479011 | 1479011 | 2021-07-03 | Orange | California | 6059 | 273738 | 5126 |
1475765 | 1475765 | 2021-07-02 | Orange | California | 6059 | 273738 | 5126 |
1472519 | 1472519 | 2021-07-01 | Orange | California | 6059 | 273636 | 5125 |
1469274 | 1469274 | 2021-06-30 | Orange | California | 6059 | 273561 | 5124 |
1466029 | 1466029 | 2021-06-29 | Orange | California | 6059 | 273482 | 5123 |
1462784 | 1462784 | 2021-06-28 | Orange | California | 6059 | 273427 | 5123 |
1459539 | 1459539 | 2021-06-27 | Orange | California | 6059 | 273225 | 5123 |
1456294 | 1456294 | 2021-06-26 | Orange | California | 6059 | 273225 | 5119 |
1453049 | 1453049 | 2021-06-25 | Orange | California | 6059 | 273225 | 5117 |
1449803 | 1449803 | 2021-06-24 | Orange | California | 6059 | 273170 | 5116 |
1446558 | 1446558 | 2021-06-23 | Orange | California | 6059 | 273128 | 5114 |
1443313 | 1443313 | 2021-06-22 | Orange | California | 6059 | 273105 | 5113 |
1440068 | 1440068 | 2021-06-21 | Orange | California | 6059 | 273057 | 5113 |
1436821 | 1436821 | 2021-06-20 | Orange | California | 6059 | 272922 | 5112 |
1433574 | 1433574 | 2021-06-19 | Orange | California | 6059 | 272922 | 5108 |
1430328 | 1430328 | 2021-06-18 | Orange | California | 6059 | 272922 | 5109 |
1427083 | 1427083 | 2021-06-17 | Orange | California | 6059 | 272877 | 5109 |
1423838 | 1423838 | 2021-06-16 | Orange | California | 6059 | 272827 | 5105 |
1420590 | 1420590 | 2021-06-15 | Orange | California | 6059 | 272787 | 5103 |
1417345 | 1417345 | 2021-06-14 | Orange | California | 6059 | 272745 | 5103 |
1414099 | 1414099 | 2021-06-13 | Orange | California | 6059 | 272650 | 5103 |
1410854 | 1410854 | 2021-06-12 | Orange | California | 6059 | 272650 | 5101 |
1407609 | 1407609 | 2021-06-11 | Orange | California | 6059 | 272650 | 5097 |
1404363 | 1404363 | 2021-06-10 | Orange | California | 6059 | 272617 | 5092 |
1401118 | 1401118 | 2021-06-09 | Orange | California | 6059 | 272552 | 5090 |
1397873 | 1397873 | 2021-06-08 | Orange | California | 6059 | 272504 | 5088 |
1394626 | 1394626 | 2021-06-07 | Orange | California | 6059 | 272447 | 5083 |
1391381 | 1391381 | 2021-06-06 | Orange | California | 6059 | 272426 | 5083 |
1388136 | 1388136 | 2021-06-05 | Orange | California | 6059 | 272361 | 5078 |
1384891 | 1384891 | 2021-06-04 | Orange | California | 6059 | 272298 | 5073 |
1381645 | 1381645 | 2021-06-03 | Orange | California | 6059 | 272242 | 5070 |
1378400 | 1378400 | 2021-06-02 | Orange | California | 6059 | 272210 | 5068 |
1375154 | 1375154 | 2021-06-01 | Orange | California | 6059 | 272156 | 5065 |
1371909 | 1371909 | 2021-05-31 | Orange | California | 6059 | 272094 | 5065 |
1368664 | 1368664 | 2021-05-30 | Orange | California | 6059 | 272094 | 5065 |
1365418 | 1365418 | 2021-05-29 | Orange | California | 6059 | 272059 | 5063 |
1362172 | 1362172 | 2021-05-28 | Orange | California | 6059 | 271936 | 5059 |
1358925 | 1358925 | 2021-05-27 | Orange | California | 6059 | 271851 | 5058 |
1355679 | 1355679 | 2021-05-26 | Orange | California | 6059 | 271766 | 5057 |
1352433 | 1352433 | 2021-05-25 | Orange | California | 6059 | 271725 | 5056 |
1349187 | 1349187 | 2021-05-24 | Orange | California | 6059 | 271673 | 5052 |
1345940 | 1345940 | 2021-05-23 | Orange | California | 6059 | 271646 | 5049 |
1342692 | 1342692 | 2021-05-22 | Orange | California | 6059 | 271589 | 5047 |
1339444 | 1339444 | 2021-05-21 | Orange | California | 6059 | 271537 | 5042 |
1336197 | 1336197 | 2021-05-20 | Orange | California | 6059 | 271496 | 5038 |
1332950 | 1332950 | 2021-05-19 | Orange | California | 6059 | 271421 | 5034 |
1329703 | 1329703 | 2021-05-18 | Orange | California | 6059 | 271352 | 5031 |
1326456 | 1326456 | 2021-05-17 | Orange | California | 6059 | 271296 | 5031 |
1323210 | 1323210 | 2021-05-16 | Orange | California | 6059 | 271251 | 5031 |
1319964 | 1319964 | 2021-05-15 | Orange | California | 6059 | 271194 | 5030 |
1316717 | 1316717 | 2021-05-14 | Orange | California | 6059 | 271134 | 5028 |
1313470 | 1313470 | 2021-05-13 | Orange | California | 6059 | 270983 | 5026 |
1310223 | 1310223 | 2021-05-12 | Orange | California | 6059 | 270940 | 5023 |
1306977 | 1306977 | 2021-05-11 | Orange | California | 6059 | 270883 | 5017 |
1303731 | 1303731 | 2021-05-10 | Orange | California | 6059 | 270800 | 5008 |
1300484 | 1300484 | 2021-05-09 | Orange | California | 6059 | 270744 | 5008 |
1297237 | 1297237 | 2021-05-08 | Orange | California | 6059 | 270705 | 5005 |
1293991 | 1293991 | 2021-05-07 | Orange | California | 6059 | 270625 | 5000 |
1290745 | 1290745 | 2021-05-06 | Orange | California | 6059 | 270569 | 4992 |
1287499 | 1287499 | 2021-05-05 | Orange | California | 6059 | 270507 | 4979 |
1284253 | 1284253 | 2021-05-04 | Orange | California | 6059 | 270444 | 4978 |
1281006 | 1281006 | 2021-05-03 | Orange | California | 6059 | 270345 | 4969 |
1277759 | 1277759 | 2021-05-02 | Orange | California | 6059 | 270284 | 4969 |
1274512 | 1274512 | 2021-05-01 | Orange | California | 6059 | 270194 | 4965 |
1271265 | 1271265 | 2021-04-30 | Orange | California | 6059 | 270101 | 4957 |
1268018 | 1268018 | 2021-04-29 | Orange | California | 6059 | 270014 | 4948 |
1264771 | 1264771 | 2021-04-28 | Orange | California | 6059 | 269949 | 4944 |
1261524 | 1261524 | 2021-04-27 | Orange | California | 6059 | 269838 | 4939 |
1258277 | 1258277 | 2021-04-26 | Orange | California | 6059 | 269724 | 4933 |
1255030 | 1255030 | 2021-04-25 | Orange | California | 6059 | 269633 | 4933 |
1251783 | 1251783 | 2021-04-24 | Orange | California | 6059 | 269549 | 4924 |
1248536 | 1248536 | 2021-04-23 | Orange | California | 6059 | 269433 | 4918 |
1245289 | 1245289 | 2021-04-22 | Orange | California | 6059 | 269352 | 4910 |
1242042 | 1242042 | 2021-04-21 | Orange | California | 6059 | 269258 | 4902 |
1238795 | 1238795 | 2021-04-20 | Orange | California | 6059 | 269176 | 4900 |
1235548 | 1235548 | 2021-04-19 | Orange | California | 6059 | 269036 | 4896 |
1232301 | 1232301 | 2021-04-18 | Orange | California | 6059 | 268962 | 4896 |
1229052 | 1229052 | 2021-04-17 | Orange | California | 6059 | 268869 | 4891 |
1225804 | 1225804 | 2021-04-16 | Orange | California | 6059 | 268762 | 4886 |
1222557 | 1222557 | 2021-04-15 | Orange | California | 6059 | 268622 | 4869 |
1219309 | 1219309 | 2021-04-14 | Orange | California | 6059 | 268521 | 4862 |
1216061 | 1216061 | 2021-04-13 | Orange | California | 6059 | 268414 | 4849 |
1212814 | 1212814 | 2021-04-12 | Orange | California | 6059 | 268304 | 4839 |
1209566 | 1209566 | 2021-04-11 | Orange | California | 6059 | 268175 | 4839 |
1206317 | 1206317 | 2021-04-10 | Orange | California | 6059 | 267957 | 4831 |
1203069 | 1203069 | 2021-04-09 | Orange | California | 6059 | 267492 | 4826 |
1199821 | 1199821 | 2021-04-08 | Orange | California | 6059 | 267383 | 4810 |
1196572 | 1196572 | 2021-04-07 | Orange | California | 6059 | 267253 | 4791 |
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);