ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Sarasota" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
868890 | 868890 | 2020-12-27 | Sarasota | Florida | 12115 | 17834 | 500 |
865645 | 865645 | 2020-12-26 | Sarasota | Florida | 12115 | 17748 | 499 |
862400 | 862400 | 2020-12-25 | Sarasota | Florida | 12115 | 17475 | 488 |
859155 | 859155 | 2020-12-24 | Sarasota | Florida | 12115 | 17475 | 488 |
855910 | 855910 | 2020-12-23 | Sarasota | Florida | 12115 | 17299 | 466 |
852665 | 852665 | 2020-12-22 | Sarasota | Florida | 12115 | 17110 | 468 |
849420 | 849420 | 2020-12-21 | Sarasota | Florida | 12115 | 16975 | 468 |
846175 | 846175 | 2020-12-20 | Sarasota | Florida | 12115 | 16817 | 467 |
842929 | 842929 | 2020-12-19 | Sarasota | Florida | 12115 | 16689 | 466 |
839684 | 839684 | 2020-12-18 | Sarasota | Florida | 12115 | 16537 | 465 |
836439 | 836439 | 2020-12-17 | Sarasota | Florida | 12115 | 16389 | 454 |
833193 | 833193 | 2020-12-16 | Sarasota | Florida | 12115 | 16189 | 450 |
829946 | 829946 | 2020-12-15 | Sarasota | Florida | 12115 | 16031 | 445 |
826700 | 826700 | 2020-12-14 | Sarasota | Florida | 12115 | 15915 | 441 |
823453 | 823453 | 2020-12-13 | Sarasota | Florida | 12115 | 15793 | 428 |
820207 | 820207 | 2020-12-12 | Sarasota | Florida | 12115 | 15659 | 427 |
816961 | 816961 | 2020-12-11 | Sarasota | Florida | 12115 | 15527 | 427 |
813715 | 813715 | 2020-12-10 | Sarasota | Florida | 12115 | 15342 | 421 |
810471 | 810471 | 2020-12-09 | Sarasota | Florida | 12115 | 15168 | 416 |
807226 | 807226 | 2020-12-08 | Sarasota | Florida | 12115 | 15024 | 415 |
803981 | 803981 | 2020-12-07 | Sarasota | Florida | 12115 | 14862 | 399 |
800736 | 800736 | 2020-12-06 | Sarasota | Florida | 12115 | 14753 | 398 |
797491 | 797491 | 2020-12-05 | Sarasota | Florida | 12115 | 14575 | 398 |
794246 | 794246 | 2020-12-04 | Sarasota | Florida | 12115 | 14384 | 399 |
791001 | 791001 | 2020-12-03 | Sarasota | Florida | 12115 | 14257 | 391 |
787756 | 787756 | 2020-12-02 | Sarasota | Florida | 12115 | 14093 | 393 |
784512 | 784512 | 2020-12-01 | Sarasota | Florida | 12115 | 13917 | 393 |
781267 | 781267 | 2020-11-30 | Sarasota | Florida | 12115 | 13763 | 389 |
778021 | 778021 | 2020-11-29 | Sarasota | Florida | 12115 | 13647 | 389 |
774776 | 774776 | 2020-11-28 | Sarasota | Florida | 12115 | 13453 | 388 |
771531 | 771531 | 2020-11-27 | Sarasota | Florida | 12115 | 13375 | 388 |
768286 | 768286 | 2020-11-26 | Sarasota | Florida | 12115 | 12920 | 387 |
765040 | 765040 | 2020-11-25 | Sarasota | Florida | 12115 | 12920 | 387 |
761795 | 761795 | 2020-11-24 | Sarasota | Florida | 12115 | 12757 | 382 |
758550 | 758550 | 2020-11-23 | Sarasota | Florida | 12115 | 12567 | 371 |
755303 | 755303 | 2020-11-22 | Sarasota | Florida | 12115 | 12419 | 371 |
752057 | 752057 | 2020-11-21 | Sarasota | Florida | 12115 | 12319 | 371 |
748811 | 748811 | 2020-11-20 | Sarasota | Florida | 12115 | 12121 | 371 |
745565 | 745565 | 2020-11-19 | Sarasota | Florida | 12115 | 11905 | 371 |
742318 | 742318 | 2020-11-18 | Sarasota | Florida | 12115 | 11620 | 364 |
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);