ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 12057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277893 | 1277893 | 2021-05-02 | Hillsborough | Florida | 12057 | 136014 | 1713 |
1274646 | 1274646 | 2021-05-01 | Hillsborough | Florida | 12057 | 135705 | 1711 |
1271399 | 1271399 | 2021-04-30 | Hillsborough | Florida | 12057 | 135278 | 1702 |
1268152 | 1268152 | 2021-04-29 | Hillsborough | Florida | 12057 | 134761 | 1696 |
1264905 | 1264905 | 2021-04-28 | Hillsborough | Florida | 12057 | 134284 | 1694 |
1261658 | 1261658 | 2021-04-27 | Hillsborough | Florida | 12057 | 133855 | 1682 |
1258411 | 1258411 | 2021-04-26 | Hillsborough | Florida | 12057 | 133429 | 1682 |
1255164 | 1255164 | 2021-04-25 | Hillsborough | Florida | 12057 | 133160 | 1680 |
1251917 | 1251917 | 2021-04-24 | Hillsborough | Florida | 12057 | 132836 | 1679 |
1248670 | 1248670 | 2021-04-23 | Hillsborough | Florida | 12057 | 132256 | 1673 |
1245423 | 1245423 | 2021-04-22 | Hillsborough | Florida | 12057 | 131831 | 1671 |
1242176 | 1242176 | 2021-04-21 | Hillsborough | Florida | 12057 | 131199 | 1667 |
1238929 | 1238929 | 2021-04-20 | Hillsborough | Florida | 12057 | 130797 | 1658 |
1235682 | 1235682 | 2021-04-19 | Hillsborough | Florida | 12057 | 130329 | 1660 |
1232435 | 1232435 | 2021-04-18 | Hillsborough | Florida | 12057 | 130034 | 1659 |
1229186 | 1229186 | 2021-04-17 | Hillsborough | Florida | 12057 | 129549 | 1659 |
1225938 | 1225938 | 2021-04-16 | Hillsborough | Florida | 12057 | 129041 | 1648 |
1222691 | 1222691 | 2021-04-15 | Hillsborough | Florida | 12057 | 128503 | 1648 |
1219443 | 1219443 | 2021-04-14 | Hillsborough | Florida | 12057 | 127969 | 1646 |
1216195 | 1216195 | 2021-04-13 | Hillsborough | Florida | 12057 | 127392 | 1645 |
1212948 | 1212948 | 2021-04-12 | Hillsborough | Florida | 12057 | 126721 | 1637 |
1209700 | 1209700 | 2021-04-11 | Hillsborough | Florida | 12057 | 126600 | 1637 |
1206451 | 1206451 | 2021-04-10 | Hillsborough | Florida | 12057 | 126165 | 1638 |
1203203 | 1203203 | 2021-04-09 | Hillsborough | Florida | 12057 | 125684 | 1634 |
1199955 | 1199955 | 2021-04-08 | Hillsborough | Florida | 12057 | 125180 | 1630 |
1196706 | 1196706 | 2021-04-07 | Hillsborough | Florida | 12057 | 124636 | 1623 |
1193458 | 1193458 | 2021-04-06 | Hillsborough | Florida | 12057 | 124167 | 1624 |
1190208 | 1190208 | 2021-04-05 | Hillsborough | Florida | 12057 | 123770 | 1621 |
1186961 | 1186961 | 2021-04-04 | Hillsborough | Florida | 12057 | 123479 | 1619 |
1183714 | 1183714 | 2021-04-03 | Hillsborough | Florida | 12057 | 123169 | 1619 |
1180467 | 1180467 | 2021-04-02 | Hillsborough | Florida | 12057 | 122713 | 1618 |
1177220 | 1177220 | 2021-04-01 | Hillsborough | Florida | 12057 | 122188 | 1615 |
1173973 | 1173973 | 2021-03-31 | Hillsborough | Florida | 12057 | 121553 | 1614 |
1170726 | 1170726 | 2021-03-30 | Hillsborough | Florida | 12057 | 121150 | 1611 |
1167478 | 1167478 | 2021-03-29 | Hillsborough | Florida | 12057 | 120893 | 1602 |
1164230 | 1164230 | 2021-03-28 | Hillsborough | Florida | 12057 | 120680 | 1602 |
1160982 | 1160982 | 2021-03-27 | Hillsborough | Florida | 12057 | 120274 | 1601 |
1157734 | 1157734 | 2021-03-26 | Hillsborough | Florida | 12057 | 119790 | 1601 |
1154487 | 1154487 | 2021-03-25 | Hillsborough | Florida | 12057 | 119339 | 1587 |
1151240 | 1151240 | 2021-03-24 | Hillsborough | Florida | 12057 | 118911 | 1582 |
1147993 | 1147993 | 2021-03-23 | Hillsborough | Florida | 12057 | 118558 | 1582 |
1144746 | 1144746 | 2021-03-22 | Hillsborough | Florida | 12057 | 118190 | 1582 |
1141499 | 1141499 | 2021-03-21 | Hillsborough | Florida | 12057 | 118061 | 1578 |
1138253 | 1138253 | 2021-03-20 | Hillsborough | Florida | 12057 | 117769 | 1577 |
1135007 | 1135007 | 2021-03-19 | Hillsborough | Florida | 12057 | 117406 | 1576 |
1131760 | 1131760 | 2021-03-18 | Hillsborough | Florida | 12057 | 117040 | 1573 |
1128512 | 1128512 | 2021-03-17 | Hillsborough | Florida | 12057 | 116691 | 1567 |
1125266 | 1125266 | 2021-03-16 | Hillsborough | Florida | 12057 | 116309 | 1566 |
1122020 | 1122020 | 2021-03-15 | Hillsborough | Florida | 12057 | 115912 | 1555 |
1118773 | 1118773 | 2021-03-14 | Hillsborough | Florida | 12057 | 115722 | 1555 |
1115526 | 1115526 | 2021-03-13 | Hillsborough | Florida | 12057 | 115482 | 1555 |
1112280 | 1112280 | 2021-03-12 | Hillsborough | Florida | 12057 | 115087 | 1551 |
1109034 | 1109034 | 2021-03-11 | Hillsborough | Florida | 12057 | 114724 | 1548 |
1105788 | 1105788 | 2021-03-10 | Hillsborough | Florida | 12057 | 114422 | 1545 |
1102542 | 1102542 | 2021-03-09 | Hillsborough | Florida | 12057 | 114061 | 1555 |
1099296 | 1099296 | 2021-03-08 | Hillsborough | Florida | 12057 | 113794 | 1535 |
1096048 | 1096048 | 2021-03-07 | Hillsborough | Florida | 12057 | 113623 | 1535 |
1092802 | 1092802 | 2021-03-06 | Hillsborough | Florida | 12057 | 113332 | 1535 |
1089556 | 1089556 | 2021-03-05 | Hillsborough | Florida | 12057 | 113045 | 1533 |
1086311 | 1086311 | 2021-03-04 | Hillsborough | Florida | 12057 | 112672 | 1523 |
1083065 | 1083065 | 2021-03-03 | Hillsborough | Florida | 12057 | 112267 | 1521 |
1079819 | 1079819 | 2021-03-02 | Hillsborough | Florida | 12057 | 111990 | 1518 |
1076574 | 1076574 | 2021-03-01 | Hillsborough | Florida | 12057 | 111550 | 1504 |
1073328 | 1073328 | 2021-02-28 | Hillsborough | Florida | 12057 | 111441 | 1502 |
1070082 | 1070082 | 2021-02-27 | Hillsborough | Florida | 12057 | 111141 | 1498 |
1066837 | 1066837 | 2021-02-26 | Hillsborough | Florida | 12057 | 110837 | 1484 |
1063592 | 1063592 | 2021-02-25 | Hillsborough | Florida | 12057 | 110485 | 1484 |
1060347 | 1060347 | 2021-02-24 | Hillsborough | Florida | 12057 | 110086 | 1470 |
1057101 | 1057101 | 2021-02-23 | Hillsborough | Florida | 12057 | 109527 | 1465 |
1053855 | 1053855 | 2021-02-22 | Hillsborough | Florida | 12057 | 109174 | 1455 |
1050608 | 1050608 | 2021-02-21 | Hillsborough | Florida | 12057 | 108964 | 1448 |
1047361 | 1047361 | 2021-02-20 | Hillsborough | Florida | 12057 | 108648 | 1448 |
1044116 | 1044116 | 2021-02-19 | Hillsborough | Florida | 12057 | 108218 | 1447 |
1040871 | 1040871 | 2021-02-18 | Hillsborough | Florida | 12057 | 107806 | 1438 |
1037626 | 1037626 | 2021-02-17 | Hillsborough | Florida | 12057 | 107513 | 1427 |
1034381 | 1034381 | 2021-02-16 | Hillsborough | Florida | 12057 | 106996 | 1418 |
1031135 | 1031135 | 2021-02-15 | Hillsborough | Florida | 12057 | 106661 | 1402 |
1027888 | 1027888 | 2021-02-14 | Hillsborough | Florida | 12057 | 106420 | 1397 |
1024643 | 1024643 | 2021-02-13 | Hillsborough | Florida | 12057 | 106060 | 1395 |
1021398 | 1021398 | 2021-02-12 | Hillsborough | Florida | 12057 | 105621 | 1395 |
1018153 | 1018153 | 2021-02-11 | Hillsborough | Florida | 12057 | 105142 | 1387 |
1014908 | 1014908 | 2021-02-10 | Hillsborough | Florida | 12057 | 104604 | 1377 |
1011663 | 1011663 | 2021-02-09 | Hillsborough | Florida | 12057 | 104210 | 1371 |
1008417 | 1008417 | 2021-02-08 | Hillsborough | Florida | 12057 | 103835 | 1358 |
1005171 | 1005171 | 2021-02-07 | Hillsborough | Florida | 12057 | 103599 | 1353 |
1001925 | 1001925 | 2021-02-06 | Hillsborough | Florida | 12057 | 103297 | 1350 |
998679 | 998679 | 2021-02-05 | Hillsborough | Florida | 12057 | 102944 | 1352 |
995433 | 995433 | 2021-02-04 | Hillsborough | Florida | 12057 | 102337 | 1342 |
992187 | 992187 | 2021-02-03 | Hillsborough | Florida | 12057 | 101910 | 1336 |
988941 | 988941 | 2021-02-02 | Hillsborough | Florida | 12057 | 101551 | 1317 |
985694 | 985694 | 2021-02-01 | Hillsborough | Florida | 12057 | 100990 | 1319 |
982447 | 982447 | 2021-01-31 | Hillsborough | Florida | 12057 | 100764 | 1293 |
979201 | 979201 | 2021-01-30 | Hillsborough | Florida | 12057 | 100334 | 1293 |
975956 | 975956 | 2021-01-29 | Hillsborough | Florida | 12057 | 99421 | 1293 |
972711 | 972711 | 2021-01-28 | Hillsborough | Florida | 12057 | 98900 | 1285 |
969466 | 969466 | 2021-01-27 | Hillsborough | Florida | 12057 | 98230 | 1270 |
966222 | 966222 | 2021-01-26 | Hillsborough | Florida | 12057 | 97809 | 1258 |
962977 | 962977 | 2021-01-25 | Hillsborough | Florida | 12057 | 97288 | 1250 |
959732 | 959732 | 2021-01-24 | Hillsborough | Florida | 12057 | 96795 | 1238 |
956486 | 956486 | 2021-01-23 | Hillsborough | Florida | 12057 | 96338 | 1233 |
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);