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 |
---|---|---|---|---|---|---|---|
386309 | 386309 | 2020-07-31 | Palm Beach | Florida | 12099 | 33272 | 815 |
383091 | 383091 | 2020-07-30 | Palm Beach | Florida | 12099 | 32694 | 806 |
379874 | 379874 | 2020-07-29 | Palm Beach | Florida | 12099 | 32169 | 795 |
376657 | 376657 | 2020-07-28 | Palm Beach | Florida | 12099 | 31596 | 779 |
373443 | 373443 | 2020-07-27 | Palm Beach | Florida | 12099 | 30956 | 758 |
370231 | 370231 | 2020-07-26 | Palm Beach | Florida | 12099 | 30323 | 755 |
367021 | 367021 | 2020-07-25 | Palm Beach | Florida | 12099 | 29705 | 752 |
363814 | 363814 | 2020-07-24 | Palm Beach | Florida | 12099 | 29002 | 744 |
360607 | 360607 | 2020-07-23 | Palm Beach | Florida | 12099 | 28265 | 727 |
357402 | 357402 | 2020-07-22 | Palm Beach | Florida | 12099 | 27504 | 709 |
354199 | 354199 | 2020-07-21 | Palm Beach | Florida | 12099 | 26949 | 701 |
350997 | 350997 | 2020-07-20 | Palm Beach | Florida | 12099 | 26424 | 685 |
347796 | 347796 | 2020-07-19 | Palm Beach | Florida | 12099 | 25783 | 679 |
344596 | 344596 | 2020-07-18 | Palm Beach | Florida | 12099 | 25043 | 666 |
341397 | 341397 | 2020-07-17 | Palm Beach | Florida | 12099 | 24359 | 659 |
338200 | 338200 | 2020-07-16 | Palm Beach | Florida | 12099 | 23709 | 638 |
335005 | 335005 | 2020-07-15 | Palm Beach | Florida | 12099 | 22786 | 634 |
331812 | 331812 | 2020-07-14 | Palm Beach | Florida | 12099 | 22277 | 624 |
328625 | 328625 | 2020-07-13 | Palm Beach | Florida | 12099 | 21804 | 611 |
325439 | 325439 | 2020-07-12 | Palm Beach | Florida | 12099 | 21016 | 606 |
322258 | 322258 | 2020-07-11 | Palm Beach | Florida | 12099 | 19845 | 594 |
319079 | 319079 | 2020-07-10 | Palm Beach | Florida | 12099 | 19231 | 586 |
315906 | 315906 | 2020-07-09 | Palm Beach | Florida | 12099 | 18654 | 578 |
312731 | 312731 | 2020-07-08 | Palm Beach | Florida | 12099 | 18229 | 569 |
309561 | 309561 | 2020-07-07 | Palm Beach | Florida | 12099 | 17636 | 563 |
306393 | 306393 | 2020-07-06 | Palm Beach | Florida | 12099 | 17240 | 543 |
303229 | 303229 | 2020-07-05 | Palm Beach | Florida | 12099 | 16834 | 542 |
300065 | 300065 | 2020-07-04 | Palm Beach | Florida | 12099 | 16147 | 541 |
296903 | 296903 | 2020-07-03 | Palm Beach | Florida | 12099 | 15322 | 536 |
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 |
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);