ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Pinellas" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277917 | 1277917 | 2021-05-02 | Pinellas | Florida | 12103 | 79072 | 1609 |
1274670 | 1274670 | 2021-05-01 | Pinellas | Florida | 12103 | 78971 | 1609 |
1271423 | 1271423 | 2021-04-30 | Pinellas | Florida | 12103 | 78803 | 1608 |
1268176 | 1268176 | 2021-04-29 | Pinellas | Florida | 12103 | 78647 | 1600 |
1264929 | 1264929 | 2021-04-28 | Pinellas | Florida | 12103 | 78420 | 1598 |
1261682 | 1261682 | 2021-04-27 | Pinellas | Florida | 12103 | 78241 | 1596 |
1258435 | 1258435 | 2021-04-26 | Pinellas | Florida | 12103 | 78084 | 1596 |
1255188 | 1255188 | 2021-04-25 | Pinellas | Florida | 12103 | 77954 | 1592 |
1251941 | 1251941 | 2021-04-24 | Pinellas | Florida | 12103 | 77813 | 1592 |
1248694 | 1248694 | 2021-04-23 | Pinellas | Florida | 12103 | 77582 | 1589 |
1245447 | 1245447 | 2021-04-22 | Pinellas | Florida | 12103 | 77394 | 1587 |
1242200 | 1242200 | 2021-04-21 | Pinellas | Florida | 12103 | 77141 | 1587 |
1238953 | 1238953 | 2021-04-20 | Pinellas | Florida | 12103 | 76960 | 1580 |
1235706 | 1235706 | 2021-04-19 | Pinellas | Florida | 12103 | 76792 | 1579 |
1232459 | 1232459 | 2021-04-18 | Pinellas | Florida | 12103 | 76637 | 1578 |
1229210 | 1229210 | 2021-04-17 | Pinellas | Florida | 12103 | 76425 | 1578 |
1225962 | 1225962 | 2021-04-16 | Pinellas | Florida | 12103 | 76172 | 1575 |
1222715 | 1222715 | 2021-04-15 | Pinellas | Florida | 12103 | 75873 | 1576 |
1219467 | 1219467 | 2021-04-14 | Pinellas | Florida | 12103 | 75615 | 1569 |
1216219 | 1216219 | 2021-04-13 | Pinellas | Florida | 12103 | 75419 | 1570 |
1212972 | 1212972 | 2021-04-12 | Pinellas | Florida | 12103 | 75108 | 1565 |
1209724 | 1209724 | 2021-04-11 | Pinellas | Florida | 12103 | 75056 | 1563 |
1206475 | 1206475 | 2021-04-10 | Pinellas | Florida | 12103 | 74799 | 1565 |
1203227 | 1203227 | 2021-04-09 | Pinellas | Florida | 12103 | 74455 | 1565 |
1199979 | 1199979 | 2021-04-08 | Pinellas | Florida | 12103 | 74155 | 1559 |
1196730 | 1196730 | 2021-04-07 | Pinellas | Florida | 12103 | 73828 | 1559 |
1193482 | 1193482 | 2021-04-06 | Pinellas | Florida | 12103 | 73591 | 1559 |
1190232 | 1190232 | 2021-04-05 | Pinellas | Florida | 12103 | 73429 | 1560 |
1186985 | 1186985 | 2021-04-04 | Pinellas | Florida | 12103 | 73290 | 1557 |
1183738 | 1183738 | 2021-04-03 | Pinellas | Florida | 12103 | 73080 | 1557 |
1180491 | 1180491 | 2021-04-02 | Pinellas | Florida | 12103 | 72844 | 1555 |
1177244 | 1177244 | 2021-04-01 | Pinellas | Florida | 12103 | 72557 | 1555 |
1173997 | 1173997 | 2021-03-31 | Pinellas | Florida | 12103 | 72243 | 1554 |
1170750 | 1170750 | 2021-03-30 | Pinellas | Florida | 12103 | 72005 | 1553 |
1167502 | 1167502 | 2021-03-29 | Pinellas | Florida | 12103 | 71839 | 1554 |
1164254 | 1164254 | 2021-03-28 | Pinellas | Florida | 12103 | 71696 | 1543 |
1161006 | 1161006 | 2021-03-27 | Pinellas | Florida | 12103 | 71499 | 1543 |
1157758 | 1157758 | 2021-03-26 | Pinellas | Florida | 12103 | 71265 | 1561 |
1154511 | 1154511 | 2021-03-25 | Pinellas | Florida | 12103 | 71011 | 1536 |
1151264 | 1151264 | 2021-03-24 | Pinellas | Florida | 12103 | 70708 | 1531 |
1148017 | 1148017 | 2021-03-23 | Pinellas | Florida | 12103 | 70580 | 1529 |
1144770 | 1144770 | 2021-03-22 | Pinellas | Florida | 12103 | 70382 | 1526 |
1141523 | 1141523 | 2021-03-21 | Pinellas | Florida | 12103 | 70251 | 1524 |
1138277 | 1138277 | 2021-03-20 | Pinellas | Florida | 12103 | 70089 | 1524 |
1135031 | 1135031 | 2021-03-19 | Pinellas | Florida | 12103 | 69829 | 1524 |
1131784 | 1131784 | 2021-03-18 | Pinellas | Florida | 12103 | 69667 | 1522 |
1128536 | 1128536 | 2021-03-17 | Pinellas | Florida | 12103 | 69468 | 1522 |
1125290 | 1125290 | 2021-03-16 | Pinellas | Florida | 12103 | 69334 | 1520 |
1122044 | 1122044 | 2021-03-15 | Pinellas | Florida | 12103 | 69192 | 1510 |
1118797 | 1118797 | 2021-03-14 | Pinellas | Florida | 12103 | 69063 | 1501 |
1115550 | 1115550 | 2021-03-13 | Pinellas | Florida | 12103 | 68912 | 1501 |
1112304 | 1112304 | 2021-03-12 | Pinellas | Florida | 12103 | 68744 | 1487 |
1109058 | 1109058 | 2021-03-11 | Pinellas | Florida | 12103 | 68494 | 1481 |
1105812 | 1105812 | 2021-03-10 | Pinellas | Florida | 12103 | 68258 | 1481 |
1102566 | 1102566 | 2021-03-09 | Pinellas | Florida | 12103 | 68085 | 1482 |
1099320 | 1099320 | 2021-03-08 | Pinellas | Florida | 12103 | 67961 | 1481 |
1096072 | 1096072 | 2021-03-07 | Pinellas | Florida | 12103 | 67844 | 1480 |
1092826 | 1092826 | 2021-03-06 | Pinellas | Florida | 12103 | 67717 | 1474 |
1089580 | 1089580 | 2021-03-05 | Pinellas | Florida | 12103 | 67554 | 1472 |
1086335 | 1086335 | 2021-03-04 | Pinellas | Florida | 12103 | 67359 | 1465 |
1083089 | 1083089 | 2021-03-03 | Pinellas | Florida | 12103 | 67061 | 1463 |
1079843 | 1079843 | 2021-03-02 | Pinellas | Florida | 12103 | 66894 | 1456 |
1076598 | 1076598 | 2021-03-01 | Pinellas | Florida | 12103 | 66646 | 1451 |
1073352 | 1073352 | 2021-02-28 | Pinellas | Florida | 12103 | 66571 | 1441 |
1070106 | 1070106 | 2021-02-27 | Pinellas | Florida | 12103 | 66412 | 1440 |
1066861 | 1066861 | 2021-02-26 | Pinellas | Florida | 12103 | 66205 | 1438 |
1063616 | 1063616 | 2021-02-25 | Pinellas | Florida | 12103 | 65937 | 1433 |
1060371 | 1060371 | 2021-02-24 | Pinellas | Florida | 12103 | 65623 | 1432 |
1057125 | 1057125 | 2021-02-23 | Pinellas | Florida | 12103 | 65375 | 1430 |
1053879 | 1053879 | 2021-02-22 | Pinellas | Florida | 12103 | 65191 | 1429 |
1050632 | 1050632 | 2021-02-21 | Pinellas | Florida | 12103 | 64951 | 1414 |
1047385 | 1047385 | 2021-02-20 | Pinellas | Florida | 12103 | 64785 | 1414 |
1044140 | 1044140 | 2021-02-19 | Pinellas | Florida | 12103 | 64466 | 1411 |
1040895 | 1040895 | 2021-02-18 | Pinellas | Florida | 12103 | 64099 | 1397 |
1037650 | 1037650 | 2021-02-17 | Pinellas | Florida | 12103 | 63871 | 1385 |
1034405 | 1034405 | 2021-02-16 | Pinellas | Florida | 12103 | 63568 | 1384 |
1031159 | 1031159 | 2021-02-15 | Pinellas | Florida | 12103 | 63326 | 1372 |
1027912 | 1027912 | 2021-02-14 | Pinellas | Florida | 12103 | 63171 | 1371 |
1024667 | 1024667 | 2021-02-13 | Pinellas | Florida | 12103 | 63023 | 1371 |
1021422 | 1021422 | 2021-02-12 | Pinellas | Florida | 12103 | 62788 | 1372 |
1018177 | 1018177 | 2021-02-11 | Pinellas | Florida | 12103 | 62499 | 1372 |
1014932 | 1014932 | 2021-02-10 | Pinellas | Florida | 12103 | 62132 | 1357 |
1011687 | 1011687 | 2021-02-09 | Pinellas | Florida | 12103 | 61950 | 1344 |
1008441 | 1008441 | 2021-02-08 | Pinellas | Florida | 12103 | 61730 | 1345 |
1005195 | 1005195 | 2021-02-07 | Pinellas | Florida | 12103 | 61546 | 1335 |
1001949 | 1001949 | 2021-02-06 | Pinellas | Florida | 12103 | 61344 | 1331 |
998703 | 998703 | 2021-02-05 | Pinellas | Florida | 12103 | 61001 | 1330 |
995457 | 995457 | 2021-02-04 | Pinellas | Florida | 12103 | 60623 | 1312 |
992211 | 992211 | 2021-02-03 | Pinellas | Florida | 12103 | 60322 | 1307 |
988965 | 988965 | 2021-02-02 | Pinellas | Florida | 12103 | 60130 | 1305 |
985718 | 985718 | 2021-02-01 | Pinellas | Florida | 12103 | 59716 | 1304 |
982471 | 982471 | 2021-01-31 | Pinellas | Florida | 12103 | 59475 | 1289 |
979225 | 979225 | 2021-01-30 | Pinellas | Florida | 12103 | 59207 | 1288 |
975980 | 975980 | 2021-01-29 | Pinellas | Florida | 12103 | 58591 | 1290 |
972735 | 972735 | 2021-01-28 | Pinellas | Florida | 12103 | 58125 | 1276 |
969490 | 969490 | 2021-01-27 | Pinellas | Florida | 12103 | 57774 | 1269 |
966246 | 966246 | 2021-01-26 | Pinellas | Florida | 12103 | 57493 | 1263 |
963001 | 963001 | 2021-01-25 | Pinellas | Florida | 12103 | 57197 | 1252 |
959756 | 959756 | 2021-01-24 | Pinellas | Florida | 12103 | 56935 | 1224 |
956510 | 956510 | 2021-01-23 | Pinellas | Florida | 12103 | 56564 | 1220 |
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);