ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 12101 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193481 | 1193481 | 2021-04-06 | Pasco | Florida | 12101 | 37136 | 696 |
1190231 | 1190231 | 2021-04-05 | Pasco | Florida | 12101 | 37013 | 697 |
1186984 | 1186984 | 2021-04-04 | Pasco | Florida | 12101 | 36906 | 697 |
1183737 | 1183737 | 2021-04-03 | Pasco | Florida | 12101 | 36787 | 697 |
1180490 | 1180490 | 2021-04-02 | Pasco | Florida | 12101 | 36645 | 697 |
1177243 | 1177243 | 2021-04-01 | Pasco | Florida | 12101 | 36511 | 693 |
1173996 | 1173996 | 2021-03-31 | Pasco | Florida | 12101 | 36391 | 692 |
1170749 | 1170749 | 2021-03-30 | Pasco | Florida | 12101 | 36265 | 692 |
1167501 | 1167501 | 2021-03-29 | Pasco | Florida | 12101 | 36147 | 687 |
1164253 | 1164253 | 2021-03-28 | Pasco | Florida | 12101 | 36074 | 687 |
1161005 | 1161005 | 2021-03-27 | Pasco | Florida | 12101 | 35990 | 687 |
1157757 | 1157757 | 2021-03-26 | Pasco | Florida | 12101 | 35863 | 687 |
1154510 | 1154510 | 2021-03-25 | Pasco | Florida | 12101 | 35730 | 682 |
1151263 | 1151263 | 2021-03-24 | Pasco | Florida | 12101 | 35583 | 681 |
1148016 | 1148016 | 2021-03-23 | Pasco | Florida | 12101 | 35492 | 680 |
1144769 | 1144769 | 2021-03-22 | Pasco | Florida | 12101 | 35373 | 681 |
1141522 | 1141522 | 2021-03-21 | Pasco | Florida | 12101 | 35336 | 681 |
1138276 | 1138276 | 2021-03-20 | Pasco | Florida | 12101 | 35248 | 680 |
1135030 | 1135030 | 2021-03-19 | Pasco | Florida | 12101 | 35136 | 680 |
1131783 | 1131783 | 2021-03-18 | Pasco | Florida | 12101 | 35039 | 679 |
1128535 | 1128535 | 2021-03-17 | Pasco | Florida | 12101 | 34961 | 676 |
1125289 | 1125289 | 2021-03-16 | Pasco | Florida | 12101 | 34868 | 671 |
1122043 | 1122043 | 2021-03-15 | Pasco | Florida | 12101 | 34778 | 671 |
1118796 | 1118796 | 2021-03-14 | Pasco | Florida | 12101 | 34720 | 672 |
1115549 | 1115549 | 2021-03-13 | Pasco | Florida | 12101 | 34631 | 671 |
1112303 | 1112303 | 2021-03-12 | Pasco | Florida | 12101 | 34495 | 668 |
1109057 | 1109057 | 2021-03-11 | Pasco | Florida | 12101 | 34391 | 668 |
1105811 | 1105811 | 2021-03-10 | Pasco | Florida | 12101 | 34271 | 667 |
1102565 | 1102565 | 2021-03-09 | Pasco | Florida | 12101 | 34178 | 667 |
1099319 | 1099319 | 2021-03-08 | Pasco | Florida | 12101 | 34098 | 665 |
1096071 | 1096071 | 2021-03-07 | Pasco | Florida | 12101 | 34054 | 664 |
1092825 | 1092825 | 2021-03-06 | Pasco | Florida | 12101 | 33975 | 664 |
1089579 | 1089579 | 2021-03-05 | Pasco | Florida | 12101 | 33888 | 664 |
1086334 | 1086334 | 2021-03-04 | Pasco | Florida | 12101 | 33778 | 664 |
1083088 | 1083088 | 2021-03-03 | Pasco | Florida | 12101 | 33658 | 661 |
1079842 | 1079842 | 2021-03-02 | Pasco | Florida | 12101 | 33551 | 658 |
1076597 | 1076597 | 2021-03-01 | Pasco | Florida | 12101 | 33426 | 649 |
1073351 | 1073351 | 2021-02-28 | Pasco | Florida | 12101 | 33377 | 649 |
1070105 | 1070105 | 2021-02-27 | Pasco | Florida | 12101 | 33265 | 647 |
1066860 | 1066860 | 2021-02-26 | Pasco | Florida | 12101 | 33139 | 646 |
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 |
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);