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 |
---|---|---|---|---|---|---|---|
1277881 | 1277881 | 2021-05-02 | Escambia | Florida | 12033 | 35984 | 679 |
1274634 | 1274634 | 2021-05-01 | Escambia | Florida | 12033 | 35962 | 679 |
1271387 | 1271387 | 2021-04-30 | Escambia | Florida | 12033 | 35929 | 678 |
1268140 | 1268140 | 2021-04-29 | Escambia | Florida | 12033 | 35890 | 678 |
1264893 | 1264893 | 2021-04-28 | Escambia | Florida | 12033 | 35837 | 678 |
1261646 | 1261646 | 2021-04-27 | Escambia | Florida | 12033 | 35790 | 677 |
1258399 | 1258399 | 2021-04-26 | Escambia | Florida | 12033 | 35755 | 675 |
1255152 | 1255152 | 2021-04-25 | Escambia | Florida | 12033 | 35730 | 675 |
1251905 | 1251905 | 2021-04-24 | Escambia | Florida | 12033 | 35704 | 675 |
1248658 | 1248658 | 2021-04-23 | Escambia | Florida | 12033 | 35658 | 675 |
1245411 | 1245411 | 2021-04-22 | Escambia | Florida | 12033 | 35605 | 675 |
1242164 | 1242164 | 2021-04-21 | Escambia | Florida | 12033 | 35565 | 675 |
1238917 | 1238917 | 2021-04-20 | Escambia | Florida | 12033 | 35509 | 675 |
1235670 | 1235670 | 2021-04-19 | Escambia | Florida | 12033 | 35472 | 675 |
1232423 | 1232423 | 2021-04-18 | Escambia | Florida | 12033 | 35457 | 675 |
1229174 | 1229174 | 2021-04-17 | Escambia | Florida | 12033 | 35419 | 675 |
1225926 | 1225926 | 2021-04-16 | Escambia | Florida | 12033 | 35392 | 674 |
1222679 | 1222679 | 2021-04-15 | Escambia | Florida | 12033 | 35361 | 674 |
1219431 | 1219431 | 2021-04-14 | Escambia | Florida | 12033 | 35294 | 675 |
1216183 | 1216183 | 2021-04-13 | Escambia | Florida | 12033 | 35243 | 675 |
1212936 | 1212936 | 2021-04-12 | Escambia | Florida | 12033 | 35202 | 672 |
1209688 | 1209688 | 2021-04-11 | Escambia | Florida | 12033 | 35189 | 672 |
1206439 | 1206439 | 2021-04-10 | Escambia | Florida | 12033 | 35152 | 671 |
1203191 | 1203191 | 2021-04-09 | Escambia | Florida | 12033 | 35100 | 671 |
1199943 | 1199943 | 2021-04-08 | Escambia | Florida | 12033 | 35067 | 670 |
1196694 | 1196694 | 2021-04-07 | Escambia | Florida | 12033 | 35027 | 670 |
1193446 | 1193446 | 2021-04-06 | Escambia | Florida | 12033 | 35002 | 669 |
1190196 | 1190196 | 2021-04-05 | Escambia | Florida | 12033 | 34990 | 669 |
1186949 | 1186949 | 2021-04-04 | Escambia | Florida | 12033 | 34969 | 669 |
1183702 | 1183702 | 2021-04-03 | Escambia | Florida | 12033 | 34950 | 669 |
1180455 | 1180455 | 2021-04-02 | Escambia | Florida | 12033 | 34926 | 666 |
1177208 | 1177208 | 2021-04-01 | Escambia | Florida | 12033 | 34879 | 664 |
1173961 | 1173961 | 2021-03-31 | Escambia | Florida | 12033 | 34845 | 664 |
1170714 | 1170714 | 2021-03-30 | Escambia | Florida | 12033 | 34810 | 664 |
1167466 | 1167466 | 2021-03-29 | Escambia | Florida | 12033 | 34782 | 664 |
1164218 | 1164218 | 2021-03-28 | Escambia | Florida | 12033 | 34779 | 664 |
1160970 | 1160970 | 2021-03-27 | Escambia | Florida | 12033 | 34749 | 664 |
1157722 | 1157722 | 2021-03-26 | Escambia | Florida | 12033 | 34689 | 663 |
1154475 | 1154475 | 2021-03-25 | Escambia | Florida | 12033 | 34658 | 658 |
1151228 | 1151228 | 2021-03-24 | Escambia | Florida | 12033 | 34624 | 658 |
1147981 | 1147981 | 2021-03-23 | Escambia | Florida | 12033 | 34590 | 658 |
1144734 | 1144734 | 2021-03-22 | Escambia | Florida | 12033 | 34566 | 657 |
1141487 | 1141487 | 2021-03-21 | Escambia | Florida | 12033 | 34558 | 657 |
1138241 | 1138241 | 2021-03-20 | Escambia | Florida | 12033 | 34537 | 657 |
1134995 | 1134995 | 2021-03-19 | Escambia | Florida | 12033 | 34521 | 657 |
1131748 | 1131748 | 2021-03-18 | Escambia | Florida | 12033 | 34492 | 659 |
1128500 | 1128500 | 2021-03-17 | Escambia | Florida | 12033 | 34465 | 654 |
1125254 | 1125254 | 2021-03-16 | Escambia | Florida | 12033 | 34441 | 654 |
1122008 | 1122008 | 2021-03-15 | Escambia | Florida | 12033 | 34418 | 652 |
1118761 | 1118761 | 2021-03-14 | Escambia | Florida | 12033 | 34408 | 652 |
1115514 | 1115514 | 2021-03-13 | Escambia | Florida | 12033 | 34377 | 652 |
1112268 | 1112268 | 2021-03-12 | Escambia | Florida | 12033 | 34336 | 649 |
1109022 | 1109022 | 2021-03-11 | Escambia | Florida | 12033 | 34292 | 646 |
1105776 | 1105776 | 2021-03-10 | Escambia | Florida | 12033 | 34268 | 645 |
1102530 | 1102530 | 2021-03-09 | Escambia | Florida | 12033 | 34219 | 646 |
1099284 | 1099284 | 2021-03-08 | Escambia | Florida | 12033 | 34172 | 638 |
1096036 | 1096036 | 2021-03-07 | Escambia | Florida | 12033 | 34134 | 637 |
1092790 | 1092790 | 2021-03-06 | Escambia | Florida | 12033 | 34088 | 637 |
1089544 | 1089544 | 2021-03-05 | Escambia | Florida | 12033 | 34019 | 638 |
1086299 | 1086299 | 2021-03-04 | Escambia | Florida | 12033 | 33959 | 635 |
1083053 | 1083053 | 2021-03-03 | Escambia | Florida | 12033 | 33894 | 633 |
1079807 | 1079807 | 2021-03-02 | Escambia | Florida | 12033 | 33804 | 632 |
1076562 | 1076562 | 2021-03-01 | Escambia | Florida | 12033 | 33713 | 631 |
1073316 | 1073316 | 2021-02-28 | Escambia | Florida | 12033 | 33681 | 629 |
1070070 | 1070070 | 2021-02-27 | Escambia | Florida | 12033 | 33629 | 629 |
1066825 | 1066825 | 2021-02-26 | Escambia | Florida | 12033 | 33556 | 628 |
1063580 | 1063580 | 2021-02-25 | Escambia | Florida | 12033 | 33474 | 622 |
1060335 | 1060335 | 2021-02-24 | Escambia | Florida | 12033 | 33391 | 618 |
1057089 | 1057089 | 2021-02-23 | Escambia | Florida | 12033 | 33304 | 620 |
1053843 | 1053843 | 2021-02-22 | Escambia | Florida | 12033 | 33242 | 608 |
1050596 | 1050596 | 2021-02-21 | Escambia | Florida | 12033 | 33210 | 608 |
1047349 | 1047349 | 2021-02-20 | Escambia | Florida | 12033 | 33158 | 608 |
1044104 | 1044104 | 2021-02-19 | Escambia | Florida | 12033 | 33047 | 607 |
1040859 | 1040859 | 2021-02-18 | Escambia | Florida | 12033 | 33007 | 604 |
1037614 | 1037614 | 2021-02-17 | Escambia | Florida | 12033 | 32958 | 598 |
1034369 | 1034369 | 2021-02-16 | Escambia | Florida | 12033 | 32890 | 598 |
1031123 | 1031123 | 2021-02-15 | Escambia | Florida | 12033 | 32788 | 594 |
1027876 | 1027876 | 2021-02-14 | Escambia | Florida | 12033 | 32743 | 593 |
1024631 | 1024631 | 2021-02-13 | Escambia | Florida | 12033 | 32681 | 593 |
1021386 | 1021386 | 2021-02-12 | Escambia | Florida | 12033 | 32590 | 585 |
1018141 | 1018141 | 2021-02-11 | Escambia | Florida | 12033 | 32484 | 582 |
1014896 | 1014896 | 2021-02-10 | Escambia | Florida | 12033 | 32332 | 580 |
1011651 | 1011651 | 2021-02-09 | Escambia | Florida | 12033 | 32208 | 569 |
1008405 | 1008405 | 2021-02-08 | Escambia | Florida | 12033 | 32101 | 563 |
1005159 | 1005159 | 2021-02-07 | Escambia | Florida | 12033 | 32016 | 563 |
1001913 | 1001913 | 2021-02-06 | Escambia | Florida | 12033 | 31919 | 562 |
998667 | 998667 | 2021-02-05 | Escambia | Florida | 12033 | 31794 | 550 |
995421 | 995421 | 2021-02-04 | Escambia | Florida | 12033 | 31579 | 541 |
992175 | 992175 | 2021-02-03 | Escambia | Florida | 12033 | 31410 | 538 |
988929 | 988929 | 2021-02-02 | Escambia | Florida | 12033 | 31195 | 536 |
985682 | 985682 | 2021-02-01 | Escambia | Florida | 12033 | 31029 | 528 |
982435 | 982435 | 2021-01-31 | Escambia | Florida | 12033 | 30942 | 528 |
979189 | 979189 | 2021-01-30 | Escambia | Florida | 12033 | 30783 | 528 |
975944 | 975944 | 2021-01-29 | Escambia | Florida | 12033 | 30381 | 518 |
972699 | 972699 | 2021-01-28 | Escambia | Florida | 12033 | 30195 | 513 |
969454 | 969454 | 2021-01-27 | Escambia | Florida | 12033 | 29903 | 506 |
966210 | 966210 | 2021-01-26 | Escambia | Florida | 12033 | 29597 | 501 |
962965 | 962965 | 2021-01-25 | Escambia | Florida | 12033 | 29363 | 488 |
959720 | 959720 | 2021-01-24 | Escambia | Florida | 12033 | 29228 | 488 |
956474 | 956474 | 2021-01-23 | Escambia | Florida | 12033 | 29045 | 487 |
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);