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 |
---|---|---|---|---|---|---|---|
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 |
953241 | 953241 | 2021-01-22 | Hillsborough | Florida | 12057 | 95477 | 1220 |
949996 | 949996 | 2021-01-21 | Hillsborough | Florida | 12057 | 94870 | 1215 |
946750 | 946750 | 2021-01-20 | Hillsborough | Florida | 12057 | 94012 | 1198 |
943503 | 943503 | 2021-01-19 | Hillsborough | Florida | 12057 | 93487 | 1197 |
940258 | 940258 | 2021-01-18 | Hillsborough | Florida | 12057 | 92891 | 1202 |
937013 | 937013 | 2021-01-17 | Hillsborough | Florida | 12057 | 92438 | 1175 |
933768 | 933768 | 2021-01-16 | Hillsborough | Florida | 12057 | 91632 | 1175 |
930523 | 930523 | 2021-01-15 | Hillsborough | Florida | 12057 | 90966 | 1173 |
927278 | 927278 | 2021-01-14 | Hillsborough | Florida | 12057 | 89989 | 1165 |
924032 | 924032 | 2021-01-13 | Hillsborough | Florida | 12057 | 89043 | 1153 |
920787 | 920787 | 2021-01-12 | Hillsborough | Florida | 12057 | 88217 | 1142 |
917542 | 917542 | 2021-01-11 | Hillsborough | Florida | 12057 | 87511 | 1142 |
914297 | 914297 | 2021-01-10 | Hillsborough | Florida | 12057 | 86509 | 1121 |
911052 | 911052 | 2021-01-09 | Hillsborough | Florida | 12057 | 85855 | 1121 |
907807 | 907807 | 2021-01-08 | Hillsborough | Florida | 12057 | 84714 | 1118 |
904561 | 904561 | 2021-01-07 | Hillsborough | Florida | 12057 | 83574 | 1110 |
901316 | 901316 | 2021-01-06 | Hillsborough | Florida | 12057 | 82257 | 1102 |
898071 | 898071 | 2021-01-05 | Hillsborough | Florida | 12057 | 81105 | 1093 |
894826 | 894826 | 2021-01-04 | Hillsborough | Florida | 12057 | 80586 | 1092 |
891579 | 891579 | 2021-01-03 | Hillsborough | Florida | 12057 | 80035 | 1090 |
888332 | 888332 | 2021-01-02 | Hillsborough | Florida | 12057 | 79472 | 1084 |
885087 | 885087 | 2021-01-01 | Hillsborough | Florida | 12057 | 77118 | 1071 |
881842 | 881842 | 2020-12-31 | Hillsborough | Florida | 12057 | 77118 | 1071 |
878597 | 878597 | 2020-12-30 | Hillsborough | Florida | 12057 | 76221 | 1068 |
875352 | 875352 | 2020-12-29 | Hillsborough | Florida | 12057 | 75547 | 1064 |
872107 | 872107 | 2020-12-28 | Hillsborough | Florida | 12057 | 74788 | 1064 |
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);