ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Union" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053890 | 1053890 | 2021-02-22 | Union | Florida | 12125 | 1728 | 70 |
1050643 | 1050643 | 2021-02-21 | Union | Florida | 12125 | 1728 | 70 |
1047396 | 1047396 | 2021-02-20 | Union | Florida | 12125 | 1727 | 70 |
1044151 | 1044151 | 2021-02-19 | Union | Florida | 12125 | 1721 | 70 |
1040906 | 1040906 | 2021-02-18 | Union | Florida | 12125 | 1721 | 70 |
1037661 | 1037661 | 2021-02-17 | Union | Florida | 12125 | 1719 | 70 |
1034416 | 1034416 | 2021-02-16 | Union | Florida | 12125 | 1715 | 70 |
1031170 | 1031170 | 2021-02-15 | Union | Florida | 12125 | 1712 | 70 |
1027923 | 1027923 | 2021-02-14 | Union | Florida | 12125 | 1711 | 70 |
1024678 | 1024678 | 2021-02-13 | Union | Florida | 12125 | 1707 | 70 |
1021433 | 1021433 | 2021-02-12 | Union | Florida | 12125 | 1704 | 70 |
1018188 | 1018188 | 2021-02-11 | Union | Florida | 12125 | 1702 | 70 |
1014943 | 1014943 | 2021-02-10 | Union | Florida | 12125 | 1700 | 70 |
1011698 | 1011698 | 2021-02-09 | Union | Florida | 12125 | 1698 | 70 |
1008452 | 1008452 | 2021-02-08 | Union | Florida | 12125 | 1695 | 70 |
1005206 | 1005206 | 2021-02-07 | Union | Florida | 12125 | 1694 | 70 |
1001960 | 1001960 | 2021-02-06 | Union | Florida | 12125 | 1687 | 70 |
998714 | 998714 | 2021-02-05 | Union | Florida | 12125 | 1680 | 70 |
995468 | 995468 | 2021-02-04 | Union | Florida | 12125 | 1672 | 70 |
992222 | 992222 | 2021-02-03 | Union | Florida | 12125 | 1670 | 70 |
988976 | 988976 | 2021-02-02 | Union | Florida | 12125 | 1670 | 70 |
985729 | 985729 | 2021-02-01 | Union | Florida | 12125 | 1665 | 70 |
982482 | 982482 | 2021-01-31 | Union | Florida | 12125 | 1664 | 70 |
979236 | 979236 | 2021-01-30 | Union | Florida | 12125 | 1660 | 70 |
975991 | 975991 | 2021-01-29 | Union | Florida | 12125 | 1657 | 70 |
972746 | 972746 | 2021-01-28 | Union | Florida | 12125 | 1648 | 70 |
969501 | 969501 | 2021-01-27 | Union | Florida | 12125 | 1642 | 70 |
966257 | 966257 | 2021-01-26 | Union | Florida | 12125 | 1638 | 70 |
963012 | 963012 | 2021-01-25 | Union | Florida | 12125 | 1637 | 70 |
959767 | 959767 | 2021-01-24 | Union | Florida | 12125 | 1635 | 70 |
956521 | 956521 | 2021-01-23 | Union | Florida | 12125 | 1631 | 70 |
953276 | 953276 | 2021-01-22 | Union | Florida | 12125 | 1622 | 70 |
950031 | 950031 | 2021-01-21 | Union | Florida | 12125 | 1620 | 70 |
946785 | 946785 | 2021-01-20 | Union | Florida | 12125 | 1616 | 70 |
943538 | 943538 | 2021-01-19 | Union | Florida | 12125 | 1614 | 70 |
940293 | 940293 | 2021-01-18 | Union | Florida | 12125 | 1611 | 69 |
937048 | 937048 | 2021-01-17 | Union | Florida | 12125 | 1610 | 69 |
933803 | 933803 | 2021-01-16 | Union | Florida | 12125 | 1609 | 69 |
930558 | 930558 | 2021-01-15 | Union | Florida | 12125 | 1602 | 68 |
927313 | 927313 | 2021-01-14 | Union | Florida | 12125 | 1592 | 68 |
924067 | 924067 | 2021-01-13 | Union | Florida | 12125 | 1578 | 68 |
920822 | 920822 | 2021-01-12 | Union | Florida | 12125 | 1574 | 66 |
917577 | 917577 | 2021-01-11 | Union | Florida | 12125 | 1559 | 66 |
914332 | 914332 | 2021-01-10 | Union | Florida | 12125 | 1556 | 66 |
911087 | 911087 | 2021-01-09 | Union | Florida | 12125 | 1552 | 66 |
907842 | 907842 | 2021-01-08 | Union | Florida | 12125 | 1545 | 67 |
904596 | 904596 | 2021-01-07 | Union | Florida | 12125 | 1515 | 65 |
901351 | 901351 | 2021-01-06 | Union | Florida | 12125 | 1500 | 65 |
898106 | 898106 | 2021-01-05 | Union | Florida | 12125 | 1490 | 65 |
894861 | 894861 | 2021-01-04 | Union | Florida | 12125 | 1481 | 65 |
891614 | 891614 | 2021-01-03 | Union | Florida | 12125 | 1480 | 65 |
888367 | 888367 | 2021-01-02 | Union | Florida | 12125 | 1473 | 65 |
885122 | 885122 | 2021-01-01 | Union | Florida | 12125 | 1439 | 65 |
881877 | 881877 | 2020-12-31 | Union | Florida | 12125 | 1439 | 65 |
878632 | 878632 | 2020-12-30 | Union | Florida | 12125 | 1431 | 65 |
875387 | 875387 | 2020-12-29 | Union | Florida | 12125 | 1428 | 65 |
872142 | 872142 | 2020-12-28 | Union | Florida | 12125 | 1416 | 65 |
868897 | 868897 | 2020-12-27 | Union | Florida | 12125 | 1414 | 65 |
865652 | 865652 | 2020-12-26 | Union | Florida | 12125 | 1413 | 65 |
862407 | 862407 | 2020-12-25 | Union | Florida | 12125 | 1388 | 65 |
859162 | 859162 | 2020-12-24 | Union | Florida | 12125 | 1388 | 65 |
855917 | 855917 | 2020-12-23 | Union | Florida | 12125 | 1382 | 65 |
852672 | 852672 | 2020-12-22 | Union | Florida | 12125 | 1373 | 65 |
849427 | 849427 | 2020-12-21 | Union | Florida | 12125 | 1368 | 65 |
846182 | 846182 | 2020-12-20 | Union | Florida | 12125 | 1365 | 65 |
842936 | 842936 | 2020-12-19 | Union | Florida | 12125 | 1359 | 65 |
839691 | 839691 | 2020-12-18 | Union | Florida | 12125 | 1343 | 65 |
836446 | 836446 | 2020-12-17 | Union | Florida | 12125 | 1342 | 65 |
833200 | 833200 | 2020-12-16 | Union | Florida | 12125 | 1333 | 65 |
829953 | 829953 | 2020-12-15 | Union | Florida | 12125 | 1325 | 63 |
826707 | 826707 | 2020-12-14 | Union | Florida | 12125 | 1306 | 62 |
823460 | 823460 | 2020-12-13 | Union | Florida | 12125 | 1305 | 61 |
820214 | 820214 | 2020-12-12 | Union | Florida | 12125 | 1302 | 61 |
816968 | 816968 | 2020-12-11 | Union | Florida | 12125 | 1293 | 61 |
813722 | 813722 | 2020-12-10 | Union | Florida | 12125 | 1285 | 61 |
810478 | 810478 | 2020-12-09 | Union | Florida | 12125 | 1279 | 61 |
807233 | 807233 | 2020-12-08 | Union | Florida | 12125 | 1267 | 61 |
803988 | 803988 | 2020-12-07 | Union | Florida | 12125 | 1261 | 61 |
800743 | 800743 | 2020-12-06 | Union | Florida | 12125 | 1259 | 61 |
797498 | 797498 | 2020-12-05 | Union | Florida | 12125 | 1254 | 61 |
794253 | 794253 | 2020-12-04 | Union | Florida | 12125 | 1249 | 61 |
791008 | 791008 | 2020-12-03 | Union | Florida | 12125 | 1242 | 61 |
787763 | 787763 | 2020-12-02 | Union | Florida | 12125 | 1240 | 61 |
784519 | 784519 | 2020-12-01 | Union | Florida | 12125 | 1238 | 61 |
781274 | 781274 | 2020-11-30 | Union | Florida | 12125 | 1229 | 61 |
778028 | 778028 | 2020-11-29 | Union | Florida | 12125 | 1227 | 59 |
774783 | 774783 | 2020-11-28 | Union | Florida | 12125 | 1225 | 59 |
771538 | 771538 | 2020-11-27 | Union | Florida | 12125 | 1224 | 59 |
768293 | 768293 | 2020-11-26 | Union | Florida | 12125 | 1215 | 59 |
765047 | 765047 | 2020-11-25 | Union | Florida | 12125 | 1215 | 59 |
761802 | 761802 | 2020-11-24 | Union | Florida | 12125 | 1212 | 59 |
758557 | 758557 | 2020-11-23 | Union | Florida | 12125 | 1210 | 59 |
755310 | 755310 | 2020-11-22 | Union | Florida | 12125 | 1210 | 58 |
752064 | 752064 | 2020-11-21 | Union | Florida | 12125 | 1208 | 58 |
748818 | 748818 | 2020-11-20 | Union | Florida | 12125 | 1205 | 57 |
745572 | 745572 | 2020-11-19 | Union | Florida | 12125 | 1201 | 57 |
742325 | 742325 | 2020-11-18 | Union | Florida | 12125 | 1199 | 53 |
739078 | 739078 | 2020-11-17 | Union | Florida | 12125 | 1197 | 53 |
735834 | 735834 | 2020-11-16 | Union | Florida | 12125 | 1194 | 53 |
732588 | 732588 | 2020-11-15 | Union | Florida | 12125 | 1193 | 53 |
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);