ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 12009 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920764 | 920764 | 2021-01-12 | Brevard | Florida | 12009 | 24594 | 559 |
917519 | 917519 | 2021-01-11 | Brevard | Florida | 12009 | 24314 | 558 |
914274 | 914274 | 2021-01-10 | Brevard | Florida | 12009 | 23944 | 557 |
911029 | 911029 | 2021-01-09 | Brevard | Florida | 12009 | 23827 | 549 |
907784 | 907784 | 2021-01-08 | Brevard | Florida | 12009 | 23513 | 540 |
904538 | 904538 | 2021-01-07 | Brevard | Florida | 12009 | 23103 | 535 |
901293 | 901293 | 2021-01-06 | Brevard | Florida | 12009 | 22669 | 526 |
898048 | 898048 | 2021-01-05 | Brevard | Florida | 12009 | 22364 | 525 |
894803 | 894803 | 2021-01-04 | Brevard | Florida | 12009 | 22037 | 525 |
891556 | 891556 | 2021-01-03 | Brevard | Florida | 12009 | 21640 | 525 |
888309 | 888309 | 2021-01-02 | Brevard | Florida | 12009 | 21541 | 525 |
885064 | 885064 | 2021-01-01 | Brevard | Florida | 12009 | 21034 | 523 |
881819 | 881819 | 2020-12-31 | Brevard | Florida | 12009 | 21034 | 523 |
878574 | 878574 | 2020-12-30 | Brevard | Florida | 12009 | 20778 | 515 |
875329 | 875329 | 2020-12-29 | Brevard | Florida | 12009 | 20522 | 513 |
872084 | 872084 | 2020-12-28 | Brevard | Florida | 12009 | 20355 | 513 |
868839 | 868839 | 2020-12-27 | Brevard | Florida | 12009 | 20145 | 513 |
865594 | 865594 | 2020-12-26 | Brevard | Florida | 12009 | 20050 | 513 |
862349 | 862349 | 2020-12-25 | Brevard | Florida | 12009 | 19789 | 511 |
859104 | 859104 | 2020-12-24 | Brevard | Florida | 12009 | 19789 | 511 |
855859 | 855859 | 2020-12-23 | Brevard | Florida | 12009 | 19535 | 499 |
852614 | 852614 | 2020-12-22 | Brevard | Florida | 12009 | 19344 | 501 |
849369 | 849369 | 2020-12-21 | Brevard | Florida | 12009 | 19178 | 501 |
846124 | 846124 | 2020-12-20 | Brevard | Florida | 12009 | 19022 | 501 |
842878 | 842878 | 2020-12-19 | Brevard | Florida | 12009 | 18903 | 499 |
839633 | 839633 | 2020-12-18 | Brevard | Florida | 12009 | 18729 | 494 |
836388 | 836388 | 2020-12-17 | Brevard | Florida | 12009 | 18511 | 490 |
833142 | 833142 | 2020-12-16 | Brevard | Florida | 12009 | 18301 | 486 |
829895 | 829895 | 2020-12-15 | Brevard | Florida | 12009 | 18081 | 484 |
826649 | 826649 | 2020-12-14 | Brevard | Florida | 12009 | 17897 | 482 |
823402 | 823402 | 2020-12-13 | Brevard | Florida | 12009 | 17730 | 477 |
820156 | 820156 | 2020-12-12 | Brevard | Florida | 12009 | 17631 | 477 |
816910 | 816910 | 2020-12-11 | Brevard | Florida | 12009 | 17444 | 473 |
813664 | 813664 | 2020-12-10 | Brevard | Florida | 12009 | 17233 | 465 |
810420 | 810420 | 2020-12-09 | Brevard | Florida | 12009 | 17077 | 464 |
807175 | 807175 | 2020-12-08 | Brevard | Florida | 12009 | 16879 | 462 |
803930 | 803930 | 2020-12-07 | Brevard | Florida | 12009 | 16721 | 457 |
800685 | 800685 | 2020-12-06 | Brevard | Florida | 12009 | 16626 | 456 |
797440 | 797440 | 2020-12-05 | Brevard | Florida | 12009 | 16529 | 456 |
794195 | 794195 | 2020-12-04 | Brevard | Florida | 12009 | 16376 | 452 |
790950 | 790950 | 2020-12-03 | Brevard | Florida | 12009 | 16208 | 451 |
787705 | 787705 | 2020-12-02 | Brevard | Florida | 12009 | 15953 | 445 |
784461 | 784461 | 2020-12-01 | Brevard | Florida | 12009 | 15744 | 444 |
781216 | 781216 | 2020-11-30 | Brevard | Florida | 12009 | 15556 | 444 |
777970 | 777970 | 2020-11-29 | Brevard | Florida | 12009 | 15494 | 444 |
774725 | 774725 | 2020-11-28 | Brevard | Florida | 12009 | 15361 | 438 |
771480 | 771480 | 2020-11-27 | Brevard | Florida | 12009 | 15259 | 436 |
768235 | 768235 | 2020-11-26 | Brevard | Florida | 12009 | 14981 | 434 |
764989 | 764989 | 2020-11-25 | Brevard | Florida | 12009 | 14981 | 434 |
761744 | 761744 | 2020-11-24 | Brevard | Florida | 12009 | 14811 | 432 |
758499 | 758499 | 2020-11-23 | Brevard | Florida | 12009 | 14650 | 431 |
755252 | 755252 | 2020-11-22 | Brevard | Florida | 12009 | 14564 | 428 |
752006 | 752006 | 2020-11-21 | Brevard | Florida | 12009 | 14464 | 424 |
748760 | 748760 | 2020-11-20 | Brevard | Florida | 12009 | 14301 | 422 |
745514 | 745514 | 2020-11-19 | Brevard | Florida | 12009 | 14112 | 418 |
742267 | 742267 | 2020-11-18 | Brevard | Florida | 12009 | 13948 | 416 |
739020 | 739020 | 2020-11-17 | Brevard | Florida | 12009 | 13802 | 413 |
735776 | 735776 | 2020-11-16 | Brevard | Florida | 12009 | 13652 | 409 |
732530 | 732530 | 2020-11-15 | Brevard | Florida | 12009 | 13602 | 409 |
729285 | 729285 | 2020-11-14 | Brevard | Florida | 12009 | 13452 | 409 |
726042 | 726042 | 2020-11-13 | Brevard | Florida | 12009 | 13312 | 407 |
722799 | 722799 | 2020-11-12 | Brevard | Florida | 12009 | 13167 | 400 |
719556 | 719556 | 2020-11-11 | Brevard | Florida | 12009 | 13092 | 400 |
716313 | 716313 | 2020-11-10 | Brevard | Florida | 12009 | 12925 | 399 |
713069 | 713069 | 2020-11-09 | Brevard | Florida | 12009 | 12780 | 392 |
709825 | 709825 | 2020-11-08 | Brevard | Florida | 12009 | 12680 | 392 |
706581 | 706581 | 2020-11-07 | Brevard | Florida | 12009 | 12572 | 391 |
703338 | 703338 | 2020-11-06 | Brevard | Florida | 12009 | 12429 | 385 |
700095 | 700095 | 2020-11-05 | Brevard | Florida | 12009 | 12318 | 384 |
696851 | 696851 | 2020-11-04 | Brevard | Florida | 12009 | 12195 | 384 |
693609 | 693609 | 2020-11-03 | Brevard | Florida | 12009 | 12034 | 378 |
690366 | 690366 | 2020-11-02 | Brevard | Florida | 12009 | 11888 | 375 |
687121 | 687121 | 2020-11-01 | Brevard | Florida | 12009 | 11780 | 375 |
683877 | 683877 | 2020-10-31 | Brevard | Florida | 12009 | 11743 | 375 |
680634 | 680634 | 2020-10-30 | Brevard | Florida | 12009 | 11637 | 375 |
677391 | 677391 | 2020-10-29 | Brevard | Florida | 12009 | 11502 | 370 |
674148 | 674148 | 2020-10-28 | Brevard | Florida | 12009 | 11318 | 368 |
670906 | 670906 | 2020-10-27 | Brevard | Florida | 12009 | 11249 | 368 |
667663 | 667663 | 2020-10-26 | Brevard | Florida | 12009 | 11083 | 366 |
664418 | 664418 | 2020-10-25 | Brevard | Florida | 12009 | 11055 | 366 |
661174 | 661174 | 2020-10-24 | Brevard | Florida | 12009 | 10999 | 366 |
657930 | 657930 | 2020-10-23 | Brevard | Florida | 12009 | 10849 | 367 |
654685 | 654685 | 2020-10-22 | Brevard | Florida | 12009 | 10747 | 352 |
651440 | 651440 | 2020-10-21 | Brevard | Florida | 12009 | 10596 | 352 |
648196 | 648196 | 2020-10-20 | Brevard | Florida | 12009 | 10521 | 350 |
644951 | 644951 | 2020-10-19 | Brevard | Florida | 12009 | 10427 | 347 |
641703 | 641703 | 2020-10-18 | Brevard | Florida | 12009 | 10397 | 345 |
638456 | 638456 | 2020-10-17 | Brevard | Florida | 12009 | 10349 | 345 |
635211 | 635211 | 2020-10-16 | Brevard | Florida | 12009 | 10268 | 342 |
631965 | 631965 | 2020-10-15 | Brevard | Florida | 12009 | 10183 | 337 |
628721 | 628721 | 2020-10-14 | Brevard | Florida | 12009 | 10110 | 331 |
625478 | 625478 | 2020-10-13 | Brevard | Florida | 12009 | 10025 | 329 |
622235 | 622235 | 2020-10-12 | Brevard | Florida | 12009 | 9936 | 325 |
618992 | 618992 | 2020-10-11 | Brevard | Florida | 12009 | 9913 | 323 |
615750 | 615750 | 2020-10-10 | Brevard | Florida | 12009 | 9777 | 317 |
612509 | 612509 | 2020-10-09 | Brevard | Florida | 12009 | 9777 | 317 |
609267 | 609267 | 2020-10-08 | Brevard | Florida | 12009 | 9657 | 315 |
606024 | 606024 | 2020-10-07 | Brevard | Florida | 12009 | 9568 | 311 |
602782 | 602782 | 2020-10-06 | Brevard | Florida | 12009 | 9511 | 309 |
599539 | 599539 | 2020-10-05 | Brevard | Florida | 12009 | 9399 | 308 |
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);