ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12115 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193486 | 1193486 | 2021-04-06 | Sarasota | Florida | 12115 | 29929 | 793 |
1190236 | 1190236 | 2021-04-05 | Sarasota | Florida | 12115 | 29846 | 791 |
1186989 | 1186989 | 2021-04-04 | Sarasota | Florida | 12115 | 29766 | 791 |
1183742 | 1183742 | 2021-04-03 | Sarasota | Florida | 12115 | 29679 | 791 |
1180495 | 1180495 | 2021-04-02 | Sarasota | Florida | 12115 | 29584 | 791 |
1177248 | 1177248 | 2021-04-01 | Sarasota | Florida | 12115 | 29465 | 787 |
1174001 | 1174001 | 2021-03-31 | Sarasota | Florida | 12115 | 29359 | 787 |
1170754 | 1170754 | 2021-03-30 | Sarasota | Florida | 12115 | 29248 | 785 |
1167506 | 1167506 | 2021-03-29 | Sarasota | Florida | 12115 | 29178 | 785 |
1164258 | 1164258 | 2021-03-28 | Sarasota | Florida | 12115 | 29096 | 785 |
1161010 | 1161010 | 2021-03-27 | Sarasota | Florida | 12115 | 28997 | 785 |
1157762 | 1157762 | 2021-03-26 | Sarasota | Florida | 12115 | 28913 | 785 |
1154515 | 1154515 | 2021-03-25 | Sarasota | Florida | 12115 | 28799 | 776 |
1151268 | 1151268 | 2021-03-24 | Sarasota | Florida | 12115 | 28684 | 776 |
1148021 | 1148021 | 2021-03-23 | Sarasota | Florida | 12115 | 28592 | 776 |
1144774 | 1144774 | 2021-03-22 | Sarasota | Florida | 12115 | 28515 | 777 |
1141527 | 1141527 | 2021-03-21 | Sarasota | Florida | 12115 | 28455 | 776 |
1138281 | 1138281 | 2021-03-20 | Sarasota | Florida | 12115 | 28399 | 775 |
1135035 | 1135035 | 2021-03-19 | Sarasota | Florida | 12115 | 28325 | 751 |
1131788 | 1131788 | 2021-03-18 | Sarasota | Florida | 12115 | 28254 | 751 |
1128540 | 1128540 | 2021-03-17 | Sarasota | Florida | 12115 | 28175 | 751 |
1125294 | 1125294 | 2021-03-16 | Sarasota | Florida | 12115 | 28092 | 751 |
1122048 | 1122048 | 2021-03-15 | Sarasota | Florida | 12115 | 28025 | 751 |
1118801 | 1118801 | 2021-03-14 | Sarasota | Florida | 12115 | 27973 | 751 |
1115554 | 1115554 | 2021-03-13 | Sarasota | Florida | 12115 | 27928 | 751 |
1112308 | 1112308 | 2021-03-12 | Sarasota | Florida | 12115 | 27863 | 751 |
1109062 | 1109062 | 2021-03-11 | Sarasota | Florida | 12115 | 27793 | 751 |
1105816 | 1105816 | 2021-03-10 | Sarasota | Florida | 12115 | 27728 | 751 |
1102570 | 1102570 | 2021-03-09 | Sarasota | Florida | 12115 | 27654 | 750 |
1099324 | 1099324 | 2021-03-08 | Sarasota | Florida | 12115 | 27572 | 750 |
1096076 | 1096076 | 2021-03-07 | Sarasota | Florida | 12115 | 27472 | 750 |
1092830 | 1092830 | 2021-03-06 | Sarasota | Florida | 12115 | 27440 | 750 |
1089584 | 1089584 | 2021-03-05 | Sarasota | Florida | 12115 | 27376 | 749 |
1086339 | 1086339 | 2021-03-04 | Sarasota | Florida | 12115 | 27301 | 749 |
1083093 | 1083093 | 2021-03-03 | Sarasota | Florida | 12115 | 27220 | 747 |
1079847 | 1079847 | 2021-03-02 | Sarasota | Florida | 12115 | 27122 | 743 |
1076602 | 1076602 | 2021-03-01 | Sarasota | Florida | 12115 | 27065 | 742 |
1073356 | 1073356 | 2021-02-28 | Sarasota | Florida | 12115 | 27038 | 742 |
1070110 | 1070110 | 2021-02-27 | Sarasota | Florida | 12115 | 26939 | 742 |
1066865 | 1066865 | 2021-02-26 | Sarasota | Florida | 12115 | 26882 | 730 |
1063620 | 1063620 | 2021-02-25 | Sarasota | Florida | 12115 | 26804 | 730 |
1060375 | 1060375 | 2021-02-24 | Sarasota | Florida | 12115 | 26714 | 724 |
1057129 | 1057129 | 2021-02-23 | Sarasota | Florida | 12115 | 26622 | 725 |
1053883 | 1053883 | 2021-02-22 | Sarasota | Florida | 12115 | 26573 | 718 |
1050636 | 1050636 | 2021-02-21 | Sarasota | Florida | 12115 | 26488 | 715 |
1047389 | 1047389 | 2021-02-20 | Sarasota | Florida | 12115 | 26454 | 715 |
1044144 | 1044144 | 2021-02-19 | Sarasota | Florida | 12115 | 26352 | 704 |
1040899 | 1040899 | 2021-02-18 | Sarasota | Florida | 12115 | 26229 | 701 |
1037654 | 1037654 | 2021-02-17 | Sarasota | Florida | 12115 | 26193 | 700 |
1034409 | 1034409 | 2021-02-16 | Sarasota | Florida | 12115 | 26071 | 701 |
1031163 | 1031163 | 2021-02-15 | Sarasota | Florida | 12115 | 26011 | 676 |
1027916 | 1027916 | 2021-02-14 | Sarasota | Florida | 12115 | 25982 | 676 |
1024671 | 1024671 | 2021-02-13 | Sarasota | Florida | 12115 | 25948 | 676 |
1021426 | 1021426 | 2021-02-12 | Sarasota | Florida | 12115 | 25878 | 676 |
1018181 | 1018181 | 2021-02-11 | Sarasota | Florida | 12115 | 25801 | 676 |
1014936 | 1014936 | 2021-02-10 | Sarasota | Florida | 12115 | 25700 | 674 |
1011691 | 1011691 | 2021-02-09 | Sarasota | Florida | 12115 | 25572 | 671 |
1008445 | 1008445 | 2021-02-08 | Sarasota | Florida | 12115 | 25510 | 650 |
1005199 | 1005199 | 2021-02-07 | Sarasota | Florida | 12115 | 25449 | 650 |
1001953 | 1001953 | 2021-02-06 | Sarasota | Florida | 12115 | 25363 | 650 |
998707 | 998707 | 2021-02-05 | Sarasota | Florida | 12115 | 25251 | 651 |
995461 | 995461 | 2021-02-04 | Sarasota | Florida | 12115 | 25158 | 651 |
992215 | 992215 | 2021-02-03 | Sarasota | Florida | 12115 | 25064 | 638 |
988969 | 988969 | 2021-02-02 | Sarasota | Florida | 12115 | 25015 | 625 |
985722 | 985722 | 2021-02-01 | Sarasota | Florida | 12115 | 24833 | 624 |
982475 | 982475 | 2021-01-31 | Sarasota | Florida | 12115 | 24759 | 624 |
979229 | 979229 | 2021-01-30 | Sarasota | Florida | 12115 | 24645 | 624 |
975984 | 975984 | 2021-01-29 | Sarasota | Florida | 12115 | 24353 | 628 |
972739 | 972739 | 2021-01-28 | Sarasota | Florida | 12115 | 24119 | 615 |
969494 | 969494 | 2021-01-27 | Sarasota | Florida | 12115 | 24042 | 610 |
966250 | 966250 | 2021-01-26 | Sarasota | Florida | 12115 | 23963 | 606 |
963005 | 963005 | 2021-01-25 | Sarasota | Florida | 12115 | 23878 | 606 |
959760 | 959760 | 2021-01-24 | Sarasota | Florida | 12115 | 23806 | 605 |
956514 | 956514 | 2021-01-23 | Sarasota | Florida | 12115 | 23718 | 602 |
953269 | 953269 | 2021-01-22 | Sarasota | Florida | 12115 | 23603 | 604 |
950024 | 950024 | 2021-01-21 | Sarasota | Florida | 12115 | 23227 | 563 |
946778 | 946778 | 2021-01-20 | Sarasota | Florida | 12115 | 23037 | 563 |
943531 | 943531 | 2021-01-19 | Sarasota | Florida | 12115 | 22895 | 563 |
940286 | 940286 | 2021-01-18 | Sarasota | Florida | 12115 | 22705 | 563 |
937041 | 937041 | 2021-01-17 | Sarasota | Florida | 12115 | 22609 | 563 |
933796 | 933796 | 2021-01-16 | Sarasota | Florida | 12115 | 22518 | 560 |
930551 | 930551 | 2021-01-15 | Sarasota | Florida | 12115 | 22393 | 557 |
927306 | 927306 | 2021-01-14 | Sarasota | Florida | 12115 | 22021 | 556 |
924060 | 924060 | 2021-01-13 | Sarasota | Florida | 12115 | 21898 | 544 |
920815 | 920815 | 2021-01-12 | Sarasota | Florida | 12115 | 21626 | 544 |
917570 | 917570 | 2021-01-11 | Sarasota | Florida | 12115 | 21328 | 541 |
914325 | 914325 | 2021-01-10 | Sarasota | Florida | 12115 | 21223 | 541 |
911080 | 911080 | 2021-01-09 | Sarasota | Florida | 12115 | 21017 | 539 |
907835 | 907835 | 2021-01-08 | Sarasota | Florida | 12115 | 20774 | 539 |
904589 | 904589 | 2021-01-07 | Sarasota | Florida | 12115 | 20512 | 514 |
901344 | 901344 | 2021-01-06 | Sarasota | Florida | 12115 | 20190 | 514 |
898099 | 898099 | 2021-01-05 | Sarasota | Florida | 12115 | 19787 | 514 |
894854 | 894854 | 2021-01-04 | Sarasota | Florida | 12115 | 19409 | 512 |
891607 | 891607 | 2021-01-03 | Sarasota | Florida | 12115 | 19271 | 512 |
888360 | 888360 | 2021-01-02 | Sarasota | Florida | 12115 | 19035 | 512 |
885115 | 885115 | 2021-01-01 | Sarasota | Florida | 12115 | 18607 | 509 |
881870 | 881870 | 2020-12-31 | Sarasota | Florida | 12115 | 18607 | 509 |
878625 | 878625 | 2020-12-30 | Sarasota | Florida | 12115 | 18371 | 507 |
875380 | 875380 | 2020-12-29 | Sarasota | Florida | 12115 | 18144 | 502 |
872135 | 872135 | 2020-12-28 | Sarasota | Florida | 12115 | 17916 | 502 |
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);