ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Pasco" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063615 | 1063615 | 2021-02-25 | Pasco | Florida | 12101 | 33035 | 641 |
1060370 | 1060370 | 2021-02-24 | Pasco | Florida | 12101 | 32900 | 641 |
1057124 | 1057124 | 2021-02-23 | Pasco | Florida | 12101 | 32754 | 636 |
1053878 | 1053878 | 2021-02-22 | Pasco | Florida | 12101 | 32662 | 631 |
1050631 | 1050631 | 2021-02-21 | Pasco | Florida | 12101 | 32581 | 632 |
1047384 | 1047384 | 2021-02-20 | Pasco | Florida | 12101 | 32440 | 631 |
1044139 | 1044139 | 2021-02-19 | Pasco | Florida | 12101 | 32289 | 630 |
1040894 | 1040894 | 2021-02-18 | Pasco | Florida | 12101 | 32152 | 623 |
1037649 | 1037649 | 2021-02-17 | Pasco | Florida | 12101 | 32036 | 619 |
1034404 | 1034404 | 2021-02-16 | Pasco | Florida | 12101 | 31872 | 614 |
1031158 | 1031158 | 2021-02-15 | Pasco | Florida | 12101 | 31744 | 602 |
1027911 | 1027911 | 2021-02-14 | Pasco | Florida | 12101 | 31631 | 602 |
1024666 | 1024666 | 2021-02-13 | Pasco | Florida | 12101 | 31508 | 602 |
1021421 | 1021421 | 2021-02-12 | Pasco | Florida | 12101 | 31371 | 600 |
1018176 | 1018176 | 2021-02-11 | Pasco | Florida | 12101 | 31188 | 595 |
1014931 | 1014931 | 2021-02-10 | Pasco | Florida | 12101 | 31007 | 597 |
1011686 | 1011686 | 2021-02-09 | Pasco | Florida | 12101 | 30883 | 591 |
1008440 | 1008440 | 2021-02-08 | Pasco | Florida | 12101 | 30749 | 578 |
1005194 | 1005194 | 2021-02-07 | Pasco | Florida | 12101 | 30641 | 576 |
1001948 | 1001948 | 2021-02-06 | Pasco | Florida | 12101 | 30536 | 576 |
998702 | 998702 | 2021-02-05 | Pasco | Florida | 12101 | 30396 | 577 |
995456 | 995456 | 2021-02-04 | Pasco | Florida | 12101 | 30214 | 576 |
992210 | 992210 | 2021-02-03 | Pasco | Florida | 12101 | 30049 | 560 |
988964 | 988964 | 2021-02-02 | Pasco | Florida | 12101 | 29917 | 561 |
985717 | 985717 | 2021-02-01 | Pasco | Florida | 12101 | 29693 | 556 |
982470 | 982470 | 2021-01-31 | Pasco | Florida | 12101 | 29608 | 539 |
979224 | 979224 | 2021-01-30 | Pasco | Florida | 12101 | 29432 | 539 |
975979 | 975979 | 2021-01-29 | Pasco | Florida | 12101 | 29171 | 540 |
972734 | 972734 | 2021-01-28 | Pasco | Florida | 12101 | 29020 | 519 |
969489 | 969489 | 2021-01-27 | Pasco | Florida | 12101 | 28795 | 516 |
966245 | 966245 | 2021-01-26 | Pasco | Florida | 12101 | 28624 | 516 |
963000 | 963000 | 2021-01-25 | Pasco | Florida | 12101 | 28466 | 494 |
959755 | 959755 | 2021-01-24 | Pasco | Florida | 12101 | 28299 | 494 |
956509 | 956509 | 2021-01-23 | Pasco | Florida | 12101 | 28076 | 494 |
953264 | 953264 | 2021-01-22 | Pasco | Florida | 12101 | 27865 | 482 |
950019 | 950019 | 2021-01-21 | Pasco | Florida | 12101 | 27610 | 471 |
946773 | 946773 | 2021-01-20 | Pasco | Florida | 12101 | 27367 | 470 |
943526 | 943526 | 2021-01-19 | Pasco | Florida | 12101 | 27190 | 466 |
940281 | 940281 | 2021-01-18 | Pasco | Florida | 12101 | 27006 | 453 |
937036 | 937036 | 2021-01-17 | Pasco | Florida | 12101 | 26798 | 453 |
933791 | 933791 | 2021-01-16 | Pasco | Florida | 12101 | 26584 | 453 |
930546 | 930546 | 2021-01-15 | Pasco | Florida | 12101 | 26344 | 448 |
927301 | 927301 | 2021-01-14 | Pasco | Florida | 12101 | 26053 | 446 |
924055 | 924055 | 2021-01-13 | Pasco | Florida | 12101 | 25785 | 424 |
920810 | 920810 | 2021-01-12 | Pasco | Florida | 12101 | 25483 | 423 |
917565 | 917565 | 2021-01-11 | Pasco | Florida | 12101 | 25224 | 410 |
914320 | 914320 | 2021-01-10 | Pasco | Florida | 12101 | 24942 | 406 |
911075 | 911075 | 2021-01-09 | Pasco | Florida | 12101 | 24663 | 405 |
907830 | 907830 | 2021-01-08 | Pasco | Florida | 12101 | 24363 | 404 |
904584 | 904584 | 2021-01-07 | Pasco | Florida | 12101 | 23948 | 402 |
901339 | 901339 | 2021-01-06 | Pasco | Florida | 12101 | 23606 | 397 |
898094 | 898094 | 2021-01-05 | Pasco | Florida | 12101 | 23258 | 393 |
894849 | 894849 | 2021-01-04 | Pasco | Florida | 12101 | 23082 | 394 |
891602 | 891602 | 2021-01-03 | Pasco | Florida | 12101 | 22879 | 391 |
888355 | 888355 | 2021-01-02 | Pasco | Florida | 12101 | 22634 | 385 |
885110 | 885110 | 2021-01-01 | Pasco | Florida | 12101 | 21932 | 376 |
881865 | 881865 | 2020-12-31 | Pasco | Florida | 12101 | 21932 | 376 |
878620 | 878620 | 2020-12-30 | Pasco | Florida | 12101 | 21602 | 375 |
875375 | 875375 | 2020-12-29 | Pasco | Florida | 12101 | 21370 | 366 |
872130 | 872130 | 2020-12-28 | Pasco | Florida | 12101 | 21222 | 360 |
868885 | 868885 | 2020-12-27 | Pasco | Florida | 12101 | 21036 | 353 |
865640 | 865640 | 2020-12-26 | Pasco | Florida | 12101 | 20919 | 353 |
862395 | 862395 | 2020-12-25 | Pasco | Florida | 12101 | 20474 | 351 |
859150 | 859150 | 2020-12-24 | Pasco | Florida | 12101 | 20474 | 351 |
855905 | 855905 | 2020-12-23 | Pasco | Florida | 12101 | 20164 | 351 |
852660 | 852660 | 2020-12-22 | Pasco | Florida | 12101 | 19969 | 345 |
849415 | 849415 | 2020-12-21 | Pasco | Florida | 12101 | 19787 | 344 |
846170 | 846170 | 2020-12-20 | Pasco | Florida | 12101 | 19496 | 339 |
842924 | 842924 | 2020-12-19 | Pasco | Florida | 12101 | 19291 | 338 |
839679 | 839679 | 2020-12-18 | Pasco | Florida | 12101 | 19017 | 335 |
836434 | 836434 | 2020-12-17 | Pasco | Florida | 12101 | 18733 | 334 |
833188 | 833188 | 2020-12-16 | Pasco | Florida | 12101 | 18385 | 329 |
829941 | 829941 | 2020-12-15 | Pasco | Florida | 12101 | 18190 | 326 |
826695 | 826695 | 2020-12-14 | Pasco | Florida | 12101 | 17975 | 325 |
823448 | 823448 | 2020-12-13 | Pasco | Florida | 12101 | 17810 | 318 |
820202 | 820202 | 2020-12-12 | Pasco | Florida | 12101 | 17578 | 312 |
816956 | 816956 | 2020-12-11 | Pasco | Florida | 12101 | 17315 | 312 |
813710 | 813710 | 2020-12-10 | Pasco | Florida | 12101 | 16988 | 311 |
810466 | 810466 | 2020-12-09 | Pasco | Florida | 12101 | 16716 | 306 |
807221 | 807221 | 2020-12-08 | Pasco | Florida | 12101 | 16543 | 305 |
803976 | 803976 | 2020-12-07 | Pasco | Florida | 12101 | 16338 | 302 |
800731 | 800731 | 2020-12-06 | Pasco | Florida | 12101 | 16153 | 301 |
797486 | 797486 | 2020-12-05 | Pasco | Florida | 12101 | 15948 | 290 |
794241 | 794241 | 2020-12-04 | Pasco | Florida | 12101 | 15700 | 285 |
790996 | 790996 | 2020-12-03 | Pasco | Florida | 12101 | 15480 | 285 |
787751 | 787751 | 2020-12-02 | Pasco | Florida | 12101 | 15248 | 280 |
784507 | 784507 | 2020-12-01 | Pasco | Florida | 12101 | 15041 | 276 |
781262 | 781262 | 2020-11-30 | Pasco | Florida | 12101 | 14899 | 276 |
778016 | 778016 | 2020-11-29 | Pasco | Florida | 12101 | 14783 | 271 |
774771 | 774771 | 2020-11-28 | Pasco | Florida | 12101 | 14619 | 271 |
771526 | 771526 | 2020-11-27 | Pasco | Florida | 12101 | 14488 | 271 |
768281 | 768281 | 2020-11-26 | Pasco | Florida | 12101 | 14131 | 270 |
765035 | 765035 | 2020-11-25 | Pasco | Florida | 12101 | 14131 | 270 |
761790 | 761790 | 2020-11-24 | Pasco | Florida | 12101 | 13982 | 267 |
758545 | 758545 | 2020-11-23 | Pasco | Florida | 12101 | 13809 | 265 |
755298 | 755298 | 2020-11-22 | Pasco | Florida | 12101 | 13679 | 264 |
752052 | 752052 | 2020-11-21 | Pasco | Florida | 12101 | 13532 | 264 |
748806 | 748806 | 2020-11-20 | Pasco | Florida | 12101 | 13373 | 265 |
745560 | 745560 | 2020-11-19 | Pasco | Florida | 12101 | 13156 | 262 |
742313 | 742313 | 2020-11-18 | Pasco | Florida | 12101 | 12968 | 263 |
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);