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 |
---|---|---|---|---|---|---|---|
1277915 | 1277915 | 2021-05-02 | Palm Beach | Florida | 12099 | 143707 | 2770 |
1274668 | 1274668 | 2021-05-01 | Palm Beach | Florida | 12099 | 143469 | 2770 |
1271421 | 1271421 | 2021-04-30 | Palm Beach | Florida | 12099 | 143127 | 2770 |
1268174 | 1268174 | 2021-04-29 | Palm Beach | Florida | 12099 | 142827 | 2767 |
1264927 | 1264927 | 2021-04-28 | Palm Beach | Florida | 12099 | 142454 | 2760 |
1261680 | 1261680 | 2021-04-27 | Palm Beach | Florida | 12099 | 142051 | 2755 |
1258433 | 1258433 | 2021-04-26 | Palm Beach | Florida | 12099 | 141745 | 2751 |
1255186 | 1255186 | 2021-04-25 | Palm Beach | Florida | 12099 | 141556 | 2742 |
1251939 | 1251939 | 2021-04-24 | Palm Beach | Florida | 12099 | 141248 | 2742 |
1248692 | 1248692 | 2021-04-23 | Palm Beach | Florida | 12099 | 140691 | 2740 |
1245445 | 1245445 | 2021-04-22 | Palm Beach | Florida | 12099 | 140372 | 2738 |
1242198 | 1242198 | 2021-04-21 | Palm Beach | Florida | 12099 | 139844 | 2732 |
1238951 | 1238951 | 2021-04-20 | Palm Beach | Florida | 12099 | 139477 | 2725 |
1235704 | 1235704 | 2021-04-19 | Palm Beach | Florida | 12099 | 139197 | 2723 |
1232457 | 1232457 | 2021-04-18 | Palm Beach | Florida | 12099 | 138965 | 2717 |
1229208 | 1229208 | 2021-04-17 | Palm Beach | Florida | 12099 | 138474 | 2717 |
1225960 | 1225960 | 2021-04-16 | Palm Beach | Florida | 12099 | 138061 | 2715 |
1222713 | 1222713 | 2021-04-15 | Palm Beach | Florida | 12099 | 137550 | 2708 |
1219465 | 1219465 | 2021-04-14 | Palm Beach | Florida | 12099 | 137130 | 2704 |
1216217 | 1216217 | 2021-04-13 | Palm Beach | Florida | 12099 | 136673 | 2701 |
1212970 | 1212970 | 2021-04-12 | Palm Beach | Florida | 12099 | 136204 | 2700 |
1209722 | 1209722 | 2021-04-11 | Palm Beach | Florida | 12099 | 136106 | 2690 |
1206473 | 1206473 | 2021-04-10 | Palm Beach | Florida | 12099 | 135756 | 2692 |
1203225 | 1203225 | 2021-04-09 | Palm Beach | Florida | 12099 | 135322 | 2692 |
1199977 | 1199977 | 2021-04-08 | Palm Beach | Florida | 12099 | 134852 | 2685 |
1196728 | 1196728 | 2021-04-07 | Palm Beach | Florida | 12099 | 134335 | 2679 |
1193480 | 1193480 | 2021-04-06 | Palm Beach | Florida | 12099 | 133834 | 2676 |
1190230 | 1190230 | 2021-04-05 | Palm Beach | Florida | 12099 | 133569 | 2672 |
1186983 | 1186983 | 2021-04-04 | Palm Beach | Florida | 12099 | 133284 | 2661 |
1183736 | 1183736 | 2021-04-03 | Palm Beach | Florida | 12099 | 132959 | 2661 |
1180489 | 1180489 | 2021-04-02 | Palm Beach | Florida | 12099 | 132526 | 2659 |
1177242 | 1177242 | 2021-04-01 | Palm Beach | Florida | 12099 | 132096 | 2653 |
1173995 | 1173995 | 2021-03-31 | Palm Beach | Florida | 12099 | 131579 | 2649 |
1170748 | 1170748 | 2021-03-30 | Palm Beach | Florida | 12099 | 131233 | 2645 |
1167500 | 1167500 | 2021-03-29 | Palm Beach | Florida | 12099 | 130902 | 2644 |
1164252 | 1164252 | 2021-03-28 | Palm Beach | Florida | 12099 | 130725 | 2635 |
1161004 | 1161004 | 2021-03-27 | Palm Beach | Florida | 12099 | 130356 | 2635 |
1157756 | 1157756 | 2021-03-26 | Palm Beach | Florida | 12099 | 129902 | 2635 |
1154509 | 1154509 | 2021-03-25 | Palm Beach | Florida | 12099 | 129476 | 2626 |
1151262 | 1151262 | 2021-03-24 | Palm Beach | Florida | 12099 | 129027 | 2603 |
1148015 | 1148015 | 2021-03-23 | Palm Beach | Florida | 12099 | 128618 | 2602 |
1144768 | 1144768 | 2021-03-22 | Palm Beach | Florida | 12099 | 128319 | 2598 |
1141521 | 1141521 | 2021-03-21 | Palm Beach | Florida | 12099 | 128152 | 2596 |
1138275 | 1138275 | 2021-03-20 | Palm Beach | Florida | 12099 | 127828 | 2596 |
1135029 | 1135029 | 2021-03-19 | Palm Beach | Florida | 12099 | 127489 | 2595 |
1131782 | 1131782 | 2021-03-18 | Palm Beach | Florida | 12099 | 127109 | 2594 |
1128534 | 1128534 | 2021-03-17 | Palm Beach | Florida | 12099 | 126727 | 2586 |
1125288 | 1125288 | 2021-03-16 | Palm Beach | Florida | 12099 | 126353 | 2576 |
1122042 | 1122042 | 2021-03-15 | Palm Beach | Florida | 12099 | 126060 | 2569 |
1118795 | 1118795 | 2021-03-14 | Palm Beach | Florida | 12099 | 125864 | 2546 |
1115548 | 1115548 | 2021-03-13 | Palm Beach | Florida | 12099 | 125504 | 2545 |
1112302 | 1112302 | 2021-03-12 | Palm Beach | Florida | 12099 | 125083 | 2545 |
1109056 | 1109056 | 2021-03-11 | Palm Beach | Florida | 12099 | 124634 | 2535 |
1105810 | 1105810 | 2021-03-10 | Palm Beach | Florida | 12099 | 124228 | 2528 |
1102564 | 1102564 | 2021-03-09 | Palm Beach | Florida | 12099 | 123776 | 2523 |
1099318 | 1099318 | 2021-03-08 | Palm Beach | Florida | 12099 | 123518 | 2522 |
1096070 | 1096070 | 2021-03-07 | Palm Beach | Florida | 12099 | 123302 | 2510 |
1092824 | 1092824 | 2021-03-06 | Palm Beach | Florida | 12099 | 123031 | 2508 |
1089578 | 1089578 | 2021-03-05 | Palm Beach | Florida | 12099 | 122707 | 2510 |
1086333 | 1086333 | 2021-03-04 | Palm Beach | Florida | 12099 | 122224 | 2498 |
1083087 | 1083087 | 2021-03-03 | Palm Beach | Florida | 12099 | 121650 | 2490 |
1079841 | 1079841 | 2021-03-02 | Palm Beach | Florida | 12099 | 121224 | 2486 |
1076596 | 1076596 | 2021-03-01 | Palm Beach | Florida | 12099 | 120866 | 2480 |
1073350 | 1073350 | 2021-02-28 | Palm Beach | Florida | 12099 | 120733 | 2457 |
1070104 | 1070104 | 2021-02-27 | Palm Beach | Florida | 12099 | 120320 | 2455 |
1066859 | 1066859 | 2021-02-26 | Palm Beach | Florida | 12099 | 119909 | 2454 |
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 |
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);