ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12031 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635221 | 635221 | 2020-10-16 | Duval | Florida | 12031 | 32625 | 505 |
631975 | 631975 | 2020-10-15 | Duval | Florida | 12031 | 32489 | 500 |
628731 | 628731 | 2020-10-14 | Duval | Florida | 12031 | 32311 | 494 |
625488 | 625488 | 2020-10-13 | Duval | Florida | 12031 | 32138 | 491 |
622245 | 622245 | 2020-10-12 | Duval | Florida | 12031 | 32027 | 487 |
619002 | 619002 | 2020-10-11 | Duval | Florida | 12031 | 31956 | 483 |
615760 | 615760 | 2020-10-10 | Duval | Florida | 12031 | 31669 | 474 |
612519 | 612519 | 2020-10-09 | Duval | Florida | 12031 | 31669 | 474 |
609277 | 609277 | 2020-10-08 | Duval | Florida | 12031 | 31500 | 471 |
606034 | 606034 | 2020-10-07 | Duval | Florida | 12031 | 31383 | 452 |
602792 | 602792 | 2020-10-06 | Duval | Florida | 12031 | 31195 | 438 |
599549 | 599549 | 2020-10-05 | Duval | Florida | 12031 | 31056 | 432 |
596306 | 596306 | 2020-10-04 | Duval | Florida | 12031 | 30985 | 429 |
593064 | 593064 | 2020-10-03 | Duval | Florida | 12031 | 30914 | 427 |
589824 | 589824 | 2020-10-02 | Duval | Florida | 12031 | 30787 | 419 |
586583 | 586583 | 2020-10-01 | Duval | Florida | 12031 | 30666 | 407 |
583343 | 583343 | 2020-09-30 | Duval | Florida | 12031 | 30548 | 394 |
580104 | 580104 | 2020-09-29 | Duval | Florida | 12031 | 30418 | 385 |
576863 | 576863 | 2020-09-28 | Duval | Florida | 12031 | 30264 | 379 |
573620 | 573620 | 2020-09-27 | Duval | Florida | 12031 | 30207 | 378 |
570378 | 570378 | 2020-09-26 | Duval | Florida | 12031 | 30114 | 378 |
567136 | 567136 | 2020-09-25 | Duval | Florida | 12031 | 29965 | 371 |
563896 | 563896 | 2020-09-24 | Duval | Florida | 12031 | 29845 | 367 |
560656 | 560656 | 2020-09-23 | Duval | Florida | 12031 | 29717 | 362 |
557420 | 557420 | 2020-09-22 | Duval | Florida | 12031 | 29580 | 354 |
554183 | 554183 | 2020-09-21 | Duval | Florida | 12031 | 29449 | 353 |
550944 | 550944 | 2020-09-20 | Duval | Florida | 12031 | 29381 | 353 |
547705 | 547705 | 2020-09-19 | Duval | Florida | 12031 | 29241 | 353 |
544467 | 544467 | 2020-09-18 | Duval | Florida | 12031 | 29056 | 350 |
541231 | 541231 | 2020-09-17 | Duval | Florida | 12031 | 28876 | 345 |
537994 | 537994 | 2020-09-16 | Duval | Florida | 12031 | 28756 | 336 |
534758 | 534758 | 2020-09-15 | Duval | Florida | 12031 | 28632 | 326 |
531523 | 531523 | 2020-09-14 | Duval | Florida | 12031 | 28525 | 322 |
528286 | 528286 | 2020-09-13 | Duval | Florida | 12031 | 28458 | 319 |
525050 | 525050 | 2020-09-12 | Duval | Florida | 12031 | 28370 | 319 |
521814 | 521814 | 2020-09-11 | Duval | Florida | 12031 | 28230 | 319 |
518577 | 518577 | 2020-09-10 | Duval | Florida | 12031 | 28051 | 302 |
515342 | 515342 | 2020-09-09 | Duval | Florida | 12031 | 27886 | 276 |
512109 | 512109 | 2020-09-08 | Duval | Florida | 12031 | 27802 | 272 |
508876 | 508876 | 2020-09-07 | Duval | Florida | 12031 | 27734 | 272 |
505644 | 505644 | 2020-09-06 | Duval | Florida | 12031 | 27635 | 271 |
502410 | 502410 | 2020-09-05 | Duval | Florida | 12031 | 27544 | 270 |
499176 | 499176 | 2020-09-04 | Duval | Florida | 12031 | 27405 | 268 |
495943 | 495943 | 2020-09-03 | Duval | Florida | 12031 | 27241 | 267 |
492709 | 492709 | 2020-09-02 | Duval | Florida | 12031 | 26807 | 262 |
489476 | 489476 | 2020-09-01 | Duval | Florida | 12031 | 26683 | 259 |
486243 | 486243 | 2020-08-31 | Duval | Florida | 12031 | 26460 | 254 |
483008 | 483008 | 2020-08-30 | Duval | Florida | 12031 | 26391 | 254 |
479774 | 479774 | 2020-08-29 | Duval | Florida | 12031 | 26284 | 254 |
476541 | 476541 | 2020-08-28 | Duval | Florida | 12031 | 26169 | 251 |
473308 | 473308 | 2020-08-27 | Duval | Florida | 12031 | 26017 | 249 |
470076 | 470076 | 2020-08-26 | Duval | Florida | 12031 | 25879 | 246 |
466847 | 466847 | 2020-08-25 | Duval | Florida | 12031 | 25732 | 243 |
463618 | 463618 | 2020-08-24 | Duval | Florida | 12031 | 25658 | 235 |
460389 | 460389 | 2020-08-23 | Duval | Florida | 12031 | 25558 | 235 |
457162 | 457162 | 2020-08-22 | Duval | Florida | 12031 | 25454 | 235 |
453934 | 453934 | 2020-08-21 | Duval | Florida | 12031 | 25316 | 235 |
450706 | 450706 | 2020-08-20 | Duval | Florida | 12031 | 25117 | 232 |
447478 | 447478 | 2020-08-19 | Duval | Florida | 12031 | 24966 | 232 |
444251 | 444251 | 2020-08-18 | Duval | Florida | 12031 | 24836 | 230 |
441025 | 441025 | 2020-08-17 | Duval | Florida | 12031 | 24731 | 222 |
437799 | 437799 | 2020-08-16 | Duval | Florida | 12031 | 24629 | 222 |
434573 | 434573 | 2020-08-15 | Duval | Florida | 12031 | 24509 | 221 |
431348 | 431348 | 2020-08-14 | Duval | Florida | 12031 | 24300 | 214 |
428120 | 428120 | 2020-08-13 | Duval | Florida | 12031 | 24162 | 212 |
424896 | 424896 | 2020-08-12 | Duval | Florida | 12031 | 23972 | 210 |
421675 | 421675 | 2020-08-11 | Duval | Florida | 12031 | 23741 | 198 |
418454 | 418454 | 2020-08-10 | Duval | Florida | 12031 | 23530 | 189 |
415233 | 415233 | 2020-08-09 | Duval | Florida | 12031 | 23437 | 188 |
412013 | 412013 | 2020-08-08 | Duval | Florida | 12031 | 23166 | 188 |
408794 | 408794 | 2020-08-07 | Duval | Florida | 12031 | 22889 | 177 |
405574 | 405574 | 2020-08-06 | Duval | Florida | 12031 | 22568 | 165 |
402356 | 402356 | 2020-08-05 | Duval | Florida | 12031 | 22215 | 164 |
399140 | 399140 | 2020-08-04 | Duval | Florida | 12031 | 22034 | 162 |
395924 | 395924 | 2020-08-03 | Duval | Florida | 12031 | 21830 | 160 |
392708 | 392708 | 2020-08-02 | Duval | Florida | 12031 | 21665 | 158 |
389491 | 389491 | 2020-08-01 | Duval | Florida | 12031 | 21322 | 157 |
386274 | 386274 | 2020-07-31 | Duval | Florida | 12031 | 21038 | 153 |
383056 | 383056 | 2020-07-30 | Duval | Florida | 12031 | 20816 | 152 |
379839 | 379839 | 2020-07-29 | Duval | Florida | 12031 | 20398 | 149 |
376622 | 376622 | 2020-07-28 | Duval | Florida | 12031 | 20138 | 146 |
373408 | 373408 | 2020-07-27 | Duval | Florida | 12031 | 20001 | 143 |
370196 | 370196 | 2020-07-26 | Duval | Florida | 12031 | 19753 | 139 |
366986 | 366986 | 2020-07-25 | Duval | Florida | 12031 | 19288 | 138 |
363779 | 363779 | 2020-07-24 | Duval | Florida | 12031 | 18781 | 122 |
360572 | 360572 | 2020-07-23 | Duval | Florida | 12031 | 18357 | 113 |
357367 | 357367 | 2020-07-22 | Duval | Florida | 12031 | 17979 | 108 |
354164 | 354164 | 2020-07-21 | Duval | Florida | 12031 | 17544 | 105 |
350962 | 350962 | 2020-07-20 | Duval | Florida | 12031 | 17245 | 98 |
347761 | 347761 | 2020-07-19 | Duval | Florida | 12031 | 16546 | 94 |
344561 | 344561 | 2020-07-18 | Duval | Florida | 12031 | 15903 | 93 |
341362 | 341362 | 2020-07-17 | Duval | Florida | 12031 | 15641 | 93 |
338165 | 338165 | 2020-07-16 | Duval | Florida | 12031 | 14992 | 89 |
334970 | 334970 | 2020-07-15 | Duval | Florida | 12031 | 14152 | 89 |
331777 | 331777 | 2020-07-14 | Duval | Florida | 12031 | 13724 | 87 |
328590 | 328590 | 2020-07-13 | Duval | Florida | 12031 | 13370 | 84 |
325404 | 325404 | 2020-07-12 | Duval | Florida | 12031 | 12864 | 81 |
322223 | 322223 | 2020-07-11 | Duval | Florida | 12031 | 12287 | 76 |
319044 | 319044 | 2020-07-10 | Duval | Florida | 12031 | 11772 | 74 |
315871 | 315871 | 2020-07-09 | Duval | Florida | 12031 | 11028 | 74 |
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);