ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 12105 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534796 | 534796 | 2020-09-15 | Polk | Florida | 12105 | 18612 | 494 |
531561 | 531561 | 2020-09-14 | Polk | Florida | 12105 | 18523 | 488 |
528324 | 528324 | 2020-09-13 | Polk | Florida | 12105 | 18473 | 488 |
525088 | 525088 | 2020-09-12 | Polk | Florida | 12105 | 18337 | 488 |
521852 | 521852 | 2020-09-11 | Polk | Florida | 12105 | 18228 | 483 |
518615 | 518615 | 2020-09-10 | Polk | Florida | 12105 | 18121 | 483 |
515380 | 515380 | 2020-09-09 | Polk | Florida | 12105 | 18025 | 480 |
512147 | 512147 | 2020-09-08 | Polk | Florida | 12105 | 17932 | 469 |
508914 | 508914 | 2020-09-07 | Polk | Florida | 12105 | 17863 | 469 |
505682 | 505682 | 2020-09-06 | Polk | Florida | 12105 | 17799 | 468 |
502448 | 502448 | 2020-09-05 | Polk | Florida | 12105 | 17693 | 468 |
499214 | 499214 | 2020-09-04 | Polk | Florida | 12105 | 17566 | 464 |
495981 | 495981 | 2020-09-03 | Polk | Florida | 12105 | 17418 | 461 |
492747 | 492747 | 2020-09-02 | Polk | Florida | 12105 | 17292 | 455 |
489514 | 489514 | 2020-09-01 | Polk | Florida | 12105 | 17159 | 447 |
486281 | 486281 | 2020-08-31 | Polk | Florida | 12105 | 17011 | 443 |
483046 | 483046 | 2020-08-30 | Polk | Florida | 12105 | 16894 | 442 |
479812 | 479812 | 2020-08-29 | Polk | Florida | 12105 | 16803 | 442 |
476579 | 476579 | 2020-08-28 | Polk | Florida | 12105 | 16692 | 429 |
473346 | 473346 | 2020-08-27 | Polk | Florida | 12105 | 16569 | 425 |
470114 | 470114 | 2020-08-26 | Polk | Florida | 12105 | 16498 | 423 |
466885 | 466885 | 2020-08-25 | Polk | Florida | 12105 | 16388 | 419 |
463656 | 463656 | 2020-08-24 | Polk | Florida | 12105 | 16322 | 407 |
460427 | 460427 | 2020-08-23 | Polk | Florida | 12105 | 16251 | 404 |
457200 | 457200 | 2020-08-22 | Polk | Florida | 12105 | 16158 | 404 |
453972 | 453972 | 2020-08-21 | Polk | Florida | 12105 | 16015 | 399 |
450744 | 450744 | 2020-08-20 | Polk | Florida | 12105 | 15887 | 396 |
447516 | 447516 | 2020-08-19 | Polk | Florida | 12105 | 15723 | 389 |
444289 | 444289 | 2020-08-18 | Polk | Florida | 12105 | 15607 | 387 |
441063 | 441063 | 2020-08-17 | Polk | Florida | 12105 | 15506 | 360 |
437837 | 437837 | 2020-08-16 | Polk | Florida | 12105 | 15429 | 358 |
434611 | 434611 | 2020-08-15 | Polk | Florida | 12105 | 15312 | 358 |
431386 | 431386 | 2020-08-14 | Polk | Florida | 12105 | 15108 | 353 |
428158 | 428158 | 2020-08-13 | Polk | Florida | 12105 | 14992 | 343 |
424934 | 424934 | 2020-08-12 | Polk | Florida | 12105 | 14812 | 334 |
421713 | 421713 | 2020-08-11 | Polk | Florida | 12105 | 14645 | 326 |
418492 | 418492 | 2020-08-10 | Polk | Florida | 12105 | 14475 | 314 |
415271 | 415271 | 2020-08-09 | Polk | Florida | 12105 | 14301 | 312 |
412051 | 412051 | 2020-08-08 | Polk | Florida | 12105 | 14124 | 312 |
408832 | 408832 | 2020-08-07 | Polk | Florida | 12105 | 13839 | 304 |
405612 | 405612 | 2020-08-06 | Polk | Florida | 12105 | 13654 | 304 |
402394 | 402394 | 2020-08-05 | Polk | Florida | 12105 | 13419 | 298 |
399178 | 399178 | 2020-08-04 | Polk | Florida | 12105 | 13231 | 286 |
395962 | 395962 | 2020-08-03 | Polk | Florida | 12105 | 13137 | 271 |
392746 | 392746 | 2020-08-02 | Polk | Florida | 12105 | 12991 | 271 |
389529 | 389529 | 2020-08-01 | Polk | Florida | 12105 | 12735 | 269 |
386312 | 386312 | 2020-07-31 | Polk | Florida | 12105 | 12488 | 268 |
383094 | 383094 | 2020-07-30 | Polk | Florida | 12105 | 12281 | 262 |
379877 | 379877 | 2020-07-29 | Polk | Florida | 12105 | 12059 | 251 |
376660 | 376660 | 2020-07-28 | Polk | Florida | 12105 | 11893 | 236 |
373446 | 373446 | 2020-07-27 | Polk | Florida | 12105 | 11717 | 220 |
370234 | 370234 | 2020-07-26 | Polk | Florida | 12105 | 11423 | 217 |
367024 | 367024 | 2020-07-25 | Polk | Florida | 12105 | 11197 | 216 |
363817 | 363817 | 2020-07-24 | Polk | Florida | 12105 | 10909 | 215 |
360610 | 360610 | 2020-07-23 | Polk | Florida | 12105 | 10545 | 203 |
357405 | 357405 | 2020-07-22 | Polk | Florida | 12105 | 10309 | 200 |
354202 | 354202 | 2020-07-21 | Polk | Florida | 12105 | 10072 | 186 |
351000 | 351000 | 2020-07-20 | Polk | Florida | 12105 | 9877 | 176 |
347799 | 347799 | 2020-07-19 | Polk | Florida | 12105 | 9524 | 174 |
344599 | 344599 | 2020-07-18 | Polk | Florida | 12105 | 9030 | 174 |
341400 | 341400 | 2020-07-17 | Polk | Florida | 12105 | 8772 | 162 |
338203 | 338203 | 2020-07-16 | Polk | Florida | 12105 | 8498 | 159 |
335008 | 335008 | 2020-07-15 | Polk | Florida | 12105 | 8206 | 155 |
331815 | 331815 | 2020-07-14 | Polk | Florida | 12105 | 7881 | 151 |
328628 | 328628 | 2020-07-13 | Polk | Florida | 12105 | 7630 | 141 |
325442 | 325442 | 2020-07-12 | Polk | Florida | 12105 | 7246 | 140 |
322261 | 322261 | 2020-07-11 | Polk | Florida | 12105 | 6983 | 138 |
319082 | 319082 | 2020-07-10 | Polk | Florida | 12105 | 6611 | 129 |
315909 | 315909 | 2020-07-09 | Polk | Florida | 12105 | 6206 | 127 |
312734 | 312734 | 2020-07-08 | Polk | Florida | 12105 | 5895 | 122 |
309564 | 309564 | 2020-07-07 | Polk | Florida | 12105 | 5665 | 115 |
306396 | 306396 | 2020-07-06 | Polk | Florida | 12105 | 5472 | 114 |
303232 | 303232 | 2020-07-05 | Polk | Florida | 12105 | 5196 | 105 |
300068 | 300068 | 2020-07-04 | Polk | Florida | 12105 | 4906 | 105 |
296906 | 296906 | 2020-07-03 | Polk | Florida | 12105 | 4660 | 105 |
293750 | 293750 | 2020-07-02 | Polk | Florida | 12105 | 4327 | 102 |
290596 | 290596 | 2020-07-01 | Polk | Florida | 12105 | 4048 | 102 |
287445 | 287445 | 2020-06-30 | Polk | Florida | 12105 | 3836 | 98 |
284299 | 284299 | 2020-06-29 | Polk | Florida | 12105 | 3682 | 93 |
281153 | 281153 | 2020-06-28 | Polk | Florida | 12105 | 3495 | 93 |
278006 | 278006 | 2020-06-27 | Polk | Florida | 12105 | 3182 | 92 |
274858 | 274858 | 2020-06-26 | Polk | Florida | 12105 | 2780 | 87 |
271718 | 271718 | 2020-06-25 | Polk | Florida | 12105 | 2571 | 84 |
268582 | 268582 | 2020-06-24 | Polk | Florida | 12105 | 2454 | 80 |
265452 | 265452 | 2020-06-23 | Polk | Florida | 12105 | 2279 | 78 |
262324 | 262324 | 2020-06-22 | Polk | Florida | 12105 | 2225 | 78 |
259197 | 259197 | 2020-06-21 | Polk | Florida | 12105 | 2042 | 78 |
256070 | 256070 | 2020-06-20 | Polk | Florida | 12105 | 1970 | 78 |
252951 | 252951 | 2020-06-19 | Polk | Florida | 12105 | 1856 | 77 |
249836 | 249836 | 2020-06-18 | Polk | Florida | 12105 | 1702 | 76 |
246724 | 246724 | 2020-06-17 | Polk | Florida | 12105 | 1634 | 75 |
243611 | 243611 | 2020-06-16 | Polk | Florida | 12105 | 1566 | 75 |
240500 | 240500 | 2020-06-15 | Polk | Florida | 12105 | 1509 | 75 |
237392 | 237392 | 2020-06-14 | Polk | Florida | 12105 | 1466 | 75 |
234285 | 234285 | 2020-06-13 | Polk | Florida | 12105 | 1414 | 75 |
231179 | 231179 | 2020-06-12 | Polk | Florida | 12105 | 1373 | 74 |
228076 | 228076 | 2020-06-11 | Polk | Florida | 12105 | 1325 | 73 |
224974 | 224974 | 2020-06-10 | Polk | Florida | 12105 | 1287 | 71 |
221879 | 221879 | 2020-06-09 | Polk | Florida | 12105 | 1243 | 70 |
218784 | 218784 | 2020-06-08 | Polk | Florida | 12105 | 1206 | 67 |
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);