ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Palm Beach" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063614 | 1063614 | 2021-02-25 | Palm Beach | Florida | 12099 | 119371 | 2443 |
1060369 | 1060369 | 2021-02-24 | Palm Beach | Florida | 12099 | 118851 | 2428 |
1057123 | 1057123 | 2021-02-23 | Palm Beach | Florida | 12099 | 118149 | 2414 |
1053877 | 1053877 | 2021-02-22 | Palm Beach | Florida | 12099 | 117840 | 2412 |
1050630 | 1050630 | 2021-02-21 | Palm Beach | Florida | 12099 | 117557 | 2394 |
1047383 | 1047383 | 2021-02-20 | Palm Beach | Florida | 12099 | 117229 | 2394 |
1044138 | 1044138 | 2021-02-19 | Palm Beach | Florida | 12099 | 116683 | 2394 |
1040893 | 1040893 | 2021-02-18 | Palm Beach | Florida | 12099 | 116207 | 2383 |
1037648 | 1037648 | 2021-02-17 | Palm Beach | Florida | 12099 | 115792 | 2362 |
1034403 | 1034403 | 2021-02-16 | Palm Beach | Florida | 12099 | 115143 | 2355 |
1031157 | 1031157 | 2021-02-15 | Palm Beach | Florida | 12099 | 114798 | 2349 |
1027910 | 1027910 | 2021-02-14 | Palm Beach | Florida | 12099 | 114465 | 2322 |
1024665 | 1024665 | 2021-02-13 | Palm Beach | Florida | 12099 | 114081 | 2322 |
1021420 | 1021420 | 2021-02-12 | Palm Beach | Florida | 12099 | 113455 | 2315 |
1018175 | 1018175 | 2021-02-11 | Palm Beach | Florida | 12099 | 112962 | 2302 |
1014930 | 1014930 | 2021-02-10 | Palm Beach | Florida | 12099 | 112365 | 2294 |
1011685 | 1011685 | 2021-02-09 | Palm Beach | Florida | 12099 | 111814 | 2277 |
1008439 | 1008439 | 2021-02-08 | Palm Beach | Florida | 12099 | 111435 | 2269 |
1005193 | 1005193 | 2021-02-07 | Palm Beach | Florida | 12099 | 111022 | 2250 |
1001947 | 1001947 | 2021-02-06 | Palm Beach | Florida | 12099 | 110637 | 2249 |
998701 | 998701 | 2021-02-05 | Palm Beach | Florida | 12099 | 110106 | 2249 |
995455 | 995455 | 2021-02-04 | Palm Beach | Florida | 12099 | 109217 | 2238 |
992209 | 992209 | 2021-02-03 | Palm Beach | Florida | 12099 | 108583 | 2212 |
988963 | 988963 | 2021-02-02 | Palm Beach | Florida | 12099 | 108171 | 2199 |
985716 | 985716 | 2021-02-01 | Palm Beach | Florida | 12099 | 107617 | 2167 |
982469 | 982469 | 2021-01-31 | Palm Beach | Florida | 12099 | 107240 | 2166 |
979223 | 979223 | 2021-01-30 | Palm Beach | Florida | 12099 | 106689 | 2166 |
975978 | 975978 | 2021-01-29 | Palm Beach | Florida | 12099 | 105538 | 2166 |
972733 | 972733 | 2021-01-28 | Palm Beach | Florida | 12099 | 104691 | 2152 |
969488 | 969488 | 2021-01-27 | Palm Beach | Florida | 12099 | 103860 | 2139 |
966244 | 966244 | 2021-01-26 | Palm Beach | Florida | 12099 | 103493 | 2125 |
962999 | 962999 | 2021-01-25 | Palm Beach | Florida | 12099 | 102966 | 2123 |
959754 | 959754 | 2021-01-24 | Palm Beach | Florida | 12099 | 102365 | 2098 |
956508 | 956508 | 2021-01-23 | Palm Beach | Florida | 12099 | 101829 | 2093 |
953263 | 953263 | 2021-01-22 | Palm Beach | Florida | 12099 | 101017 | 2083 |
950018 | 950018 | 2021-01-21 | Palm Beach | Florida | 12099 | 100206 | 2066 |
946772 | 946772 | 2021-01-20 | Palm Beach | Florida | 12099 | 99377 | 2061 |
943525 | 943525 | 2021-01-19 | Palm Beach | Florida | 12099 | 98690 | 2059 |
940280 | 940280 | 2021-01-18 | Palm Beach | Florida | 12099 | 98065 | 2037 |
937035 | 937035 | 2021-01-17 | Palm Beach | Florida | 12099 | 97540 | 2036 |
933790 | 933790 | 2021-01-16 | Palm Beach | Florida | 12099 | 96741 | 2033 |
930545 | 930545 | 2021-01-15 | Palm Beach | Florida | 12099 | 96083 | 2018 |
927300 | 927300 | 2021-01-14 | Palm Beach | Florida | 12099 | 94870 | 2009 |
924054 | 924054 | 2021-01-13 | Palm Beach | Florida | 12099 | 93992 | 1983 |
920809 | 920809 | 2021-01-12 | Palm Beach | Florida | 12099 | 93293 | 1975 |
917564 | 917564 | 2021-01-11 | Palm Beach | Florida | 12099 | 92540 | 1972 |
914319 | 914319 | 2021-01-10 | Palm Beach | Florida | 12099 | 91709 | 1955 |
911074 | 911074 | 2021-01-09 | Palm Beach | Florida | 12099 | 91047 | 1955 |
907829 | 907829 | 2021-01-08 | Palm Beach | Florida | 12099 | 90056 | 1943 |
904583 | 904583 | 2021-01-07 | Palm Beach | Florida | 12099 | 88850 | 1933 |
901338 | 901338 | 2021-01-06 | Palm Beach | Florida | 12099 | 87681 | 1923 |
898093 | 898093 | 2021-01-05 | Palm Beach | Florida | 12099 | 86837 | 1923 |
894848 | 894848 | 2021-01-04 | Palm Beach | Florida | 12099 | 86273 | 1921 |
891601 | 891601 | 2021-01-03 | Palm Beach | Florida | 12099 | 85477 | 1909 |
888354 | 888354 | 2021-01-02 | Palm Beach | Florida | 12099 | 84970 | 1908 |
885109 | 885109 | 2021-01-01 | Palm Beach | Florida | 12099 | 82888 | 1895 |
881864 | 881864 | 2020-12-31 | Palm Beach | Florida | 12099 | 82888 | 1895 |
878619 | 878619 | 2020-12-30 | Palm Beach | Florida | 12099 | 81897 | 1881 |
875374 | 875374 | 2020-12-29 | Palm Beach | Florida | 12099 | 81388 | 1873 |
872129 | 872129 | 2020-12-28 | Palm Beach | Florida | 12099 | 80863 | 1866 |
868884 | 868884 | 2020-12-27 | Palm Beach | Florida | 12099 | 80237 | 1860 |
865639 | 865639 | 2020-12-26 | Palm Beach | Florida | 12099 | 79828 | 1860 |
862394 | 862394 | 2020-12-25 | Palm Beach | Florida | 12099 | 78850 | 1858 |
859149 | 859149 | 2020-12-24 | Palm Beach | Florida | 12099 | 78850 | 1858 |
855904 | 855904 | 2020-12-23 | Palm Beach | Florida | 12099 | 78185 | 1842 |
852659 | 852659 | 2020-12-22 | Palm Beach | Florida | 12099 | 77741 | 1835 |
849414 | 849414 | 2020-12-21 | Palm Beach | Florida | 12099 | 77239 | 1835 |
846169 | 846169 | 2020-12-20 | Palm Beach | Florida | 12099 | 76600 | 1819 |
842923 | 842923 | 2020-12-19 | Palm Beach | Florida | 12099 | 76141 | 1816 |
839678 | 839678 | 2020-12-18 | Palm Beach | Florida | 12099 | 75570 | 1816 |
836433 | 836433 | 2020-12-17 | Palm Beach | Florida | 12099 | 74787 | 1804 |
833187 | 833187 | 2020-12-16 | Palm Beach | Florida | 12099 | 73996 | 1796 |
829940 | 829940 | 2020-12-15 | Palm Beach | Florida | 12099 | 73540 | 1785 |
826694 | 826694 | 2020-12-14 | Palm Beach | Florida | 12099 | 73077 | 1774 |
823447 | 823447 | 2020-12-13 | Palm Beach | Florida | 12099 | 72706 | 1768 |
820201 | 820201 | 2020-12-12 | Palm Beach | Florida | 12099 | 72245 | 1766 |
816955 | 816955 | 2020-12-11 | Palm Beach | Florida | 12099 | 71689 | 1766 |
813709 | 813709 | 2020-12-10 | Palm Beach | Florida | 12099 | 70964 | 1756 |
810465 | 810465 | 2020-12-09 | Palm Beach | Florida | 12099 | 70312 | 1745 |
807220 | 807220 | 2020-12-08 | Palm Beach | Florida | 12099 | 69853 | 1739 |
803975 | 803975 | 2020-12-07 | Palm Beach | Florida | 12099 | 69329 | 1731 |
800730 | 800730 | 2020-12-06 | Palm Beach | Florida | 12099 | 68910 | 1725 |
797485 | 797485 | 2020-12-05 | Palm Beach | Florida | 12099 | 68379 | 1724 |
794240 | 794240 | 2020-12-04 | Palm Beach | Florida | 12099 | 67734 | 1719 |
790995 | 790995 | 2020-12-03 | Palm Beach | Florida | 12099 | 67104 | 1709 |
787750 | 787750 | 2020-12-02 | Palm Beach | Florida | 12099 | 66425 | 1699 |
784506 | 784506 | 2020-12-01 | Palm Beach | Florida | 12099 | 65934 | 1697 |
781261 | 781261 | 2020-11-30 | Palm Beach | Florida | 12099 | 65370 | 1694 |
778015 | 778015 | 2020-11-29 | Palm Beach | Florida | 12099 | 65009 | 1678 |
774770 | 774770 | 2020-11-28 | Palm Beach | Florida | 12099 | 64668 | 1678 |
771525 | 771525 | 2020-11-27 | Palm Beach | Florida | 12099 | 64298 | 1676 |
768280 | 768280 | 2020-11-26 | Palm Beach | Florida | 12099 | 63144 | 1670 |
765034 | 765034 | 2020-11-25 | Palm Beach | Florida | 12099 | 63144 | 1670 |
761789 | 761789 | 2020-11-24 | Palm Beach | Florida | 12099 | 62695 | 1663 |
758544 | 758544 | 2020-11-23 | Palm Beach | Florida | 12099 | 62276 | 1659 |
755297 | 755297 | 2020-11-22 | Palm Beach | Florida | 12099 | 61774 | 1648 |
752051 | 752051 | 2020-11-21 | Palm Beach | Florida | 12099 | 61303 | 1648 |
748805 | 748805 | 2020-11-20 | Palm Beach | Florida | 12099 | 60727 | 1647 |
745559 | 745559 | 2020-11-19 | Palm Beach | Florida | 12099 | 60217 | 1644 |
742312 | 742312 | 2020-11-18 | Palm Beach | Florida | 12099 | 59654 | 1641 |
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);