ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Escambia" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920775 | 920775 | 2021-01-12 | Escambia | Florida | 12033 | 25913 | 426 |
917530 | 917530 | 2021-01-11 | Escambia | Florida | 12033 | 25570 | 414 |
914285 | 914285 | 2021-01-10 | Escambia | Florida | 12033 | 25393 | 413 |
911040 | 911040 | 2021-01-09 | Escambia | Florida | 12033 | 25153 | 413 |
907795 | 907795 | 2021-01-08 | Escambia | Florida | 12033 | 24868 | 405 |
904549 | 904549 | 2021-01-07 | Escambia | Florida | 12033 | 24530 | 400 |
901304 | 901304 | 2021-01-06 | Escambia | Florida | 12033 | 24062 | 393 |
898059 | 898059 | 2021-01-05 | Escambia | Florida | 12033 | 23602 | 387 |
894814 | 894814 | 2021-01-04 | Escambia | Florida | 12033 | 23378 | 384 |
891567 | 891567 | 2021-01-03 | Escambia | Florida | 12033 | 23206 | 383 |
888320 | 888320 | 2021-01-02 | Escambia | Florida | 12033 | 23014 | 379 |
885075 | 885075 | 2021-01-01 | Escambia | Florida | 12033 | 22349 | 373 |
881830 | 881830 | 2020-12-31 | Escambia | Florida | 12033 | 22349 | 373 |
878585 | 878585 | 2020-12-30 | Escambia | Florida | 12033 | 22008 | 372 |
875340 | 875340 | 2020-12-29 | Escambia | Florida | 12033 | 21643 | 367 |
872095 | 872095 | 2020-12-28 | Escambia | Florida | 12033 | 21507 | 360 |
868850 | 868850 | 2020-12-27 | Escambia | Florida | 12033 | 21408 | 359 |
865605 | 865605 | 2020-12-26 | Escambia | Florida | 12033 | 21268 | 356 |
862360 | 862360 | 2020-12-25 | Escambia | Florida | 12033 | 20946 | 353 |
859115 | 859115 | 2020-12-24 | Escambia | Florida | 12033 | 20946 | 353 |
855870 | 855870 | 2020-12-23 | Escambia | Florida | 12033 | 20737 | 352 |
852625 | 852625 | 2020-12-22 | Escambia | Florida | 12033 | 20438 | 351 |
849380 | 849380 | 2020-12-21 | Escambia | Florida | 12033 | 20278 | 346 |
846135 | 846135 | 2020-12-20 | Escambia | Florida | 12033 | 20162 | 343 |
842889 | 842889 | 2020-12-19 | Escambia | Florida | 12033 | 20027 | 341 |
839644 | 839644 | 2020-12-18 | Escambia | Florida | 12033 | 19762 | 341 |
836399 | 836399 | 2020-12-17 | Escambia | Florida | 12033 | 19475 | 338 |
833153 | 833153 | 2020-12-16 | Escambia | Florida | 12033 | 19256 | 337 |
829906 | 829906 | 2020-12-15 | Escambia | Florida | 12033 | 18998 | 336 |
826660 | 826660 | 2020-12-14 | Escambia | Florida | 12033 | 18869 | 332 |
823413 | 823413 | 2020-12-13 | Escambia | Florida | 12033 | 18761 | 332 |
820167 | 820167 | 2020-12-12 | Escambia | Florida | 12033 | 18616 | 332 |
816921 | 816921 | 2020-12-11 | Escambia | Florida | 12033 | 18427 | 328 |
813675 | 813675 | 2020-12-10 | Escambia | Florida | 12033 | 18238 | 328 |
810431 | 810431 | 2020-12-09 | Escambia | Florida | 12033 | 17965 | 327 |
807186 | 807186 | 2020-12-08 | Escambia | Florida | 12033 | 17793 | 324 |
803941 | 803941 | 2020-12-07 | Escambia | Florida | 12033 | 17702 | 318 |
800696 | 800696 | 2020-12-06 | Escambia | Florida | 12033 | 17617 | 316 |
797451 | 797451 | 2020-12-05 | Escambia | Florida | 12033 | 17514 | 315 |
794206 | 794206 | 2020-12-04 | Escambia | Florida | 12033 | 17335 | 313 |
790961 | 790961 | 2020-12-03 | Escambia | Florida | 12033 | 17177 | 310 |
787716 | 787716 | 2020-12-02 | Escambia | Florida | 12033 | 17007 | 307 |
784472 | 784472 | 2020-12-01 | Escambia | Florida | 12033 | 16872 | 306 |
781227 | 781227 | 2020-11-30 | Escambia | Florida | 12033 | 16729 | 305 |
777981 | 777981 | 2020-11-29 | Escambia | Florida | 12033 | 16675 | 304 |
774736 | 774736 | 2020-11-28 | Escambia | Florida | 12033 | 16578 | 304 |
771491 | 771491 | 2020-11-27 | Escambia | Florida | 12033 | 16470 | 301 |
768246 | 768246 | 2020-11-26 | Escambia | Florida | 12033 | 16223 | 299 |
765000 | 765000 | 2020-11-25 | Escambia | Florida | 12033 | 16223 | 299 |
761755 | 761755 | 2020-11-24 | Escambia | Florida | 12033 | 16101 | 297 |
758510 | 758510 | 2020-11-23 | Escambia | Florida | 12033 | 15990 | 296 |
755263 | 755263 | 2020-11-22 | Escambia | Florida | 12033 | 15926 | 296 |
752017 | 752017 | 2020-11-21 | Escambia | Florida | 12033 | 15873 | 296 |
748771 | 748771 | 2020-11-20 | Escambia | Florida | 12033 | 15732 | 297 |
745525 | 745525 | 2020-11-19 | Escambia | Florida | 12033 | 15584 | 293 |
742278 | 742278 | 2020-11-18 | Escambia | Florida | 12033 | 15436 | 290 |
739031 | 739031 | 2020-11-17 | Escambia | Florida | 12033 | 15298 | 289 |
735787 | 735787 | 2020-11-16 | Escambia | Florida | 12033 | 15190 | 288 |
732541 | 732541 | 2020-11-15 | Escambia | Florida | 12033 | 15118 | 288 |
729296 | 729296 | 2020-11-14 | Escambia | Florida | 12033 | 14979 | 288 |
726053 | 726053 | 2020-11-13 | Escambia | Florida | 12033 | 14882 | 289 |
722810 | 722810 | 2020-11-12 | Escambia | Florida | 12033 | 14748 | 284 |
719567 | 719567 | 2020-11-11 | Escambia | Florida | 12033 | 14609 | 283 |
716324 | 716324 | 2020-11-10 | Escambia | Florida | 12033 | 14495 | 282 |
713080 | 713080 | 2020-11-09 | Escambia | Florida | 12033 | 14397 | 282 |
709836 | 709836 | 2020-11-08 | Escambia | Florida | 12033 | 14334 | 279 |
706592 | 706592 | 2020-11-07 | Escambia | Florida | 12033 | 14205 | 279 |
703349 | 703349 | 2020-11-06 | Escambia | Florida | 12033 | 14139 | 274 |
700106 | 700106 | 2020-11-05 | Escambia | Florida | 12033 | 14033 | 273 |
696862 | 696862 | 2020-11-04 | Escambia | Florida | 12033 | 13914 | 273 |
693620 | 693620 | 2020-11-03 | Escambia | Florida | 12033 | 13804 | 273 |
690377 | 690377 | 2020-11-02 | Escambia | Florida | 12033 | 13730 | 272 |
687132 | 687132 | 2020-11-01 | Escambia | Florida | 12033 | 13704 | 272 |
683888 | 683888 | 2020-10-31 | Escambia | Florida | 12033 | 13642 | 272 |
680645 | 680645 | 2020-10-30 | Escambia | Florida | 12033 | 13584 | 271 |
677402 | 677402 | 2020-10-29 | Escambia | Florida | 12033 | 13517 | 269 |
674159 | 674159 | 2020-10-28 | Escambia | Florida | 12033 | 13445 | 269 |
670917 | 670917 | 2020-10-27 | Escambia | Florida | 12033 | 13375 | 269 |
667674 | 667674 | 2020-10-26 | Escambia | Florida | 12033 | 13328 | 269 |
664429 | 664429 | 2020-10-25 | Escambia | Florida | 12033 | 13296 | 269 |
661185 | 661185 | 2020-10-24 | Escambia | Florida | 12033 | 13282 | 269 |
657941 | 657941 | 2020-10-23 | Escambia | Florida | 12033 | 13194 | 269 |
654696 | 654696 | 2020-10-22 | Escambia | Florida | 12033 | 13130 | 269 |
651451 | 651451 | 2020-10-21 | Escambia | Florida | 12033 | 13060 | 269 |
648207 | 648207 | 2020-10-20 | Escambia | Florida | 12033 | 13030 | 269 |
644962 | 644962 | 2020-10-19 | Escambia | Florida | 12033 | 12997 | 269 |
641714 | 641714 | 2020-10-18 | Escambia | Florida | 12033 | 12989 | 269 |
638467 | 638467 | 2020-10-17 | Escambia | Florida | 12033 | 12959 | 269 |
635222 | 635222 | 2020-10-16 | Escambia | Florida | 12033 | 12883 | 268 |
631976 | 631976 | 2020-10-15 | Escambia | Florida | 12033 | 12837 | 267 |
628732 | 628732 | 2020-10-14 | Escambia | Florida | 12033 | 12737 | 264 |
625489 | 625489 | 2020-10-13 | Escambia | Florida | 12033 | 12698 | 264 |
622246 | 622246 | 2020-10-12 | Escambia | Florida | 12033 | 12674 | 262 |
619003 | 619003 | 2020-10-11 | Escambia | Florida | 12033 | 12660 | 260 |
615761 | 615761 | 2020-10-10 | Escambia | Florida | 12033 | 12611 | 255 |
612520 | 612520 | 2020-10-09 | Escambia | Florida | 12033 | 12611 | 255 |
609278 | 609278 | 2020-10-08 | Escambia | Florida | 12033 | 12588 | 254 |
606035 | 606035 | 2020-10-07 | Escambia | Florida | 12033 | 12551 | 247 |
602793 | 602793 | 2020-10-06 | Escambia | Florida | 12033 | 12512 | 243 |
599550 | 599550 | 2020-10-05 | Escambia | Florida | 12033 | 12494 | 243 |
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);