ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12099 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293747 | 293747 | 2020-07-02 | Palm Beach | Florida | 12099 | 14857 | 523 |
290593 | 290593 | 2020-07-01 | Palm Beach | Florida | 12099 | 14445 | 512 |
287442 | 287442 | 2020-06-30 | Palm Beach | Florida | 12099 | 14148 | 510 |
284296 | 284296 | 2020-06-29 | Palm Beach | Florida | 12099 | 13709 | 503 |
281150 | 281150 | 2020-06-28 | Palm Beach | Florida | 12099 | 13387 | 503 |
278003 | 278003 | 2020-06-27 | Palm Beach | Florida | 12099 | 12926 | 492 |
274855 | 274855 | 2020-06-26 | Palm Beach | Florida | 12099 | 12496 | 490 |
271715 | 271715 | 2020-06-25 | Palm Beach | Florida | 12099 | 11838 | 486 |
268579 | 268579 | 2020-06-24 | Palm Beach | Florida | 12099 | 11534 | 482 |
265449 | 265449 | 2020-06-23 | Palm Beach | Florida | 12099 | 11178 | 476 |
262321 | 262321 | 2020-06-22 | Palm Beach | Florida | 12099 | 10941 | 468 |
259194 | 259194 | 2020-06-21 | Palm Beach | Florida | 12099 | 10752 | 468 |
256067 | 256067 | 2020-06-20 | Palm Beach | Florida | 12099 | 10504 | 468 |
252948 | 252948 | 2020-06-19 | Palm Beach | Florida | 12099 | 10114 | 464 |
249833 | 249833 | 2020-06-18 | Palm Beach | Florida | 12099 | 9852 | 450 |
246721 | 246721 | 2020-06-17 | Palm Beach | Florida | 12099 | 9470 | 444 |
243608 | 243608 | 2020-06-16 | Palm Beach | Florida | 12099 | 9260 | 438 |
240497 | 240497 | 2020-06-15 | Palm Beach | Florida | 12099 | 9013 | 429 |
237389 | 237389 | 2020-06-14 | Palm Beach | Florida | 12099 | 8831 | 426 |
234282 | 234282 | 2020-06-13 | Palm Beach | Florida | 12099 | 8440 | 425 |
231176 | 231176 | 2020-06-12 | Palm Beach | Florida | 12099 | 8207 | 416 |
228073 | 228073 | 2020-06-11 | Palm Beach | Florida | 12099 | 7885 | 407 |
224971 | 224971 | 2020-06-10 | Palm Beach | Florida | 12099 | 7676 | 397 |
221876 | 221876 | 2020-06-09 | Palm Beach | Florida | 12099 | 7516 | 388 |
218781 | 218781 | 2020-06-08 | Palm Beach | Florida | 12099 | 7327 | 373 |
215690 | 215690 | 2020-06-07 | Palm Beach | Florida | 12099 | 7228 | 372 |
212603 | 212603 | 2020-06-06 | Palm Beach | Florida | 12099 | 7072 | 370 |
209518 | 209518 | 2020-06-05 | Palm Beach | Florida | 12099 | 6857 | 367 |
206437 | 206437 | 2020-06-04 | Palm Beach | Florida | 12099 | 6686 | 363 |
203357 | 203357 | 2020-06-03 | Palm Beach | Florida | 12099 | 6475 | 359 |
200281 | 200281 | 2020-06-02 | Palm Beach | Florida | 12099 | 6217 | 351 |
197208 | 197208 | 2020-06-01 | Palm Beach | Florida | 12099 | 6133 | 337 |
194138 | 194138 | 2020-05-31 | Palm Beach | Florida | 12099 | 5994 | 337 |
191071 | 191071 | 2020-05-30 | Palm Beach | Florida | 12099 | 5896 | 337 |
188006 | 188006 | 2020-05-29 | Palm Beach | Florida | 12099 | 5763 | 335 |
184950 | 184950 | 2020-05-28 | Palm Beach | Florida | 12099 | 5539 | 327 |
181896 | 181896 | 2020-05-27 | Palm Beach | Florida | 12099 | 5453 | 320 |
178852 | 178852 | 2020-05-26 | Palm Beach | Florida | 12099 | 5427 | 315 |
175808 | 175808 | 2020-05-25 | Palm Beach | Florida | 12099 | 5353 | 315 |
172765 | 172765 | 2020-05-24 | Palm Beach | Florida | 12099 | 5199 | 315 |
169724 | 169724 | 2020-05-23 | Palm Beach | Florida | 12099 | 5138 | 315 |
166687 | 166687 | 2020-05-22 | Palm Beach | Florida | 12099 | 5070 | 311 |
163654 | 163654 | 2020-05-21 | Palm Beach | Florida | 12099 | 4966 | 308 |
160626 | 160626 | 2020-05-20 | Palm Beach | Florida | 12099 | 4774 | 291 |
157600 | 157600 | 2020-05-19 | Palm Beach | Florida | 12099 | 4697 | 284 |
154584 | 154584 | 2020-05-18 | Palm Beach | Florida | 12099 | 4656 | 275 |
151572 | 151572 | 2020-05-17 | Palm Beach | Florida | 12099 | 4522 | 275 |
148563 | 148563 | 2020-05-16 | Palm Beach | Florida | 12099 | 4438 | 275 |
145560 | 145560 | 2020-05-15 | Palm Beach | Florida | 12099 | 4389 | 271 |
142560 | 142560 | 2020-05-14 | Palm Beach | Florida | 12099 | 4276 | 263 |
139564 | 139564 | 2020-05-13 | Palm Beach | Florida | 12099 | 4174 | 254 |
136573 | 136573 | 2020-05-12 | Palm Beach | Florida | 12099 | 4091 | 245 |
133584 | 133584 | 2020-05-11 | Palm Beach | Florida | 12099 | 3887 | 238 |
130593 | 130593 | 2020-05-10 | Palm Beach | Florida | 12099 | 3868 | 237 |
127602 | 127602 | 2020-05-09 | Palm Beach | Florida | 12099 | 3796 | 237 |
124615 | 124615 | 2020-05-08 | Palm Beach | Florida | 12099 | 3613 | 229 |
121636 | 121636 | 2020-05-07 | Palm Beach | Florida | 12099 | 3585 | 222 |
118667 | 118667 | 2020-05-06 | Palm Beach | Florida | 12099 | 3478 | 215 |
115707 | 115707 | 2020-05-05 | Palm Beach | Florida | 12099 | 3388 | 205 |
112824 | 112824 | 2020-05-04 | Palm Beach | Florida | 12099 | 3309 | 196 |
109949 | 109949 | 2020-05-03 | Palm Beach | Florida | 12099 | 3128 | 196 |
107080 | 107080 | 2020-05-02 | Palm Beach | Florida | 12099 | 3078 | 195 |
104215 | 104215 | 2020-05-01 | Palm Beach | Florida | 12099 | 3039 | 191 |
101360 | 101360 | 2020-04-30 | Palm Beach | Florida | 12099 | 2961 | 186 |
98510 | 98510 | 2020-04-29 | Palm Beach | Florida | 12099 | 2909 | 178 |
95665 | 95665 | 2020-04-28 | Palm Beach | Florida | 12099 | 2875 | 173 |
92833 | 92833 | 2020-04-27 | Palm Beach | Florida | 12099 | 2761 | 156 |
90015 | 90015 | 2020-04-26 | Palm Beach | Florida | 12099 | 2695 | 155 |
87198 | 87198 | 2020-04-25 | Palm Beach | Florida | 12099 | 2612 | 155 |
84390 | 84390 | 2020-04-24 | Palm Beach | Florida | 12099 | 2598 | 155 |
81590 | 81590 | 2020-04-23 | Palm Beach | Florida | 12099 | 2552 | 144 |
78796 | 78796 | 2020-04-22 | Palm Beach | Florida | 12099 | 2401 | 131 |
76012 | 76012 | 2020-04-21 | Palm Beach | Florida | 12099 | 2318 | 131 |
73236 | 73236 | 2020-04-20 | Palm Beach | Florida | 12099 | 2258 | 122 |
70467 | 70467 | 2020-04-19 | Palm Beach | Florida | 12099 | 2168 | 121 |
67705 | 67705 | 2020-04-18 | Palm Beach | Florida | 12099 | 2136 | 114 |
64957 | 64957 | 2020-04-17 | Palm Beach | Florida | 12099 | 2086 | 115 |
62224 | 62224 | 2020-04-16 | Palm Beach | Florida | 12099 | 1865 | 112 |
59505 | 59505 | 2020-04-15 | Palm Beach | Florida | 12099 | 1816 | 107 |
56797 | 56797 | 2020-04-14 | Palm Beach | Florida | 12099 | 1738 | 103 |
54105 | 54105 | 2020-04-13 | Palm Beach | Florida | 12099 | 1702 | 92 |
51425 | 51425 | 2020-04-12 | Palm Beach | Florida | 12099 | 1644 | 81 |
48764 | 48764 | 2020-04-11 | Palm Beach | Florida | 12099 | 1499 | 80 |
46134 | 46134 | 2020-04-10 | Palm Beach | Florida | 12099 | 1429 | 79 |
43532 | 43532 | 2020-04-09 | Palm Beach | Florida | 12099 | 1331 | 75 |
40958 | 40958 | 2020-04-08 | Palm Beach | Florida | 12099 | 1222 | 69 |
38414 | 38414 | 2020-04-07 | Palm Beach | Florida | 12099 | 1157 | 64 |
35923 | 35923 | 2020-04-06 | Palm Beach | Florida | 12099 | 1080 | 51 |
33477 | 33477 | 2020-04-05 | Palm Beach | Florida | 12099 | 998 | 49 |
31071 | 31071 | 2020-04-04 | Palm Beach | Florida | 12099 | 952 | 35 |
28711 | 28711 | 2020-04-03 | Palm Beach | Florida | 12099 | 856 | 33 |
26408 | 26408 | 2020-04-02 | Palm Beach | Florida | 12099 | 735 | 27 |
24178 | 24178 | 2020-04-01 | Palm Beach | Florida | 12099 | 616 | 22 |
22015 | 22015 | 2020-03-31 | Palm Beach | Florida | 12099 | 551 | 14 |
19937 | 19937 | 2020-03-30 | Palm Beach | Florida | 12099 | 462 | 10 |
17956 | 17956 | 2020-03-29 | Palm Beach | Florida | 12099 | 382 | 7 |
16063 | 16063 | 2020-03-28 | Palm Beach | Florida | 12099 | 318 | 6 |
14278 | 14278 | 2020-03-27 | Palm Beach | Florida | 12099 | 241 | 5 |
12608 | 12608 | 2020-03-26 | Palm Beach | Florida | 12099 | 172 | 3 |
11060 | 11060 | 2020-03-25 | Palm Beach | Florida | 12099 | 139 | 3 |
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);