ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Madison" and state = "Florida" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
319068 | 319068 | 2020-07-10 | Madison | Florida | 12079 | 302 | 4 |
322247 | 322247 | 2020-07-11 | Madison | Florida | 12079 | 320 | 4 |
325428 | 325428 | 2020-07-12 | Madison | Florida | 12079 | 335 | 4 |
328614 | 328614 | 2020-07-13 | Madison | Florida | 12079 | 367 | 4 |
331801 | 331801 | 2020-07-14 | Madison | Florida | 12079 | 382 | 4 |
334994 | 334994 | 2020-07-15 | Madison | Florida | 12079 | 402 | 4 |
338189 | 338189 | 2020-07-16 | Madison | Florida | 12079 | 415 | 4 |
341386 | 341386 | 2020-07-17 | Madison | Florida | 12079 | 423 | 4 |
344585 | 344585 | 2020-07-18 | Madison | Florida | 12079 | 431 | 4 |
347785 | 347785 | 2020-07-19 | Madison | Florida | 12079 | 444 | 4 |
350986 | 350986 | 2020-07-20 | Madison | Florida | 12079 | 451 | 4 |
354188 | 354188 | 2020-07-21 | Madison | Florida | 12079 | 477 | 4 |
357391 | 357391 | 2020-07-22 | Madison | Florida | 12079 | 492 | 4 |
360596 | 360596 | 2020-07-23 | Madison | Florida | 12079 | 504 | 5 |
363803 | 363803 | 2020-07-24 | Madison | Florida | 12079 | 514 | 5 |
367010 | 367010 | 2020-07-25 | Madison | Florida | 12079 | 519 | 6 |
370220 | 370220 | 2020-07-26 | Madison | Florida | 12079 | 526 | 6 |
373432 | 373432 | 2020-07-27 | Madison | Florida | 12079 | 553 | 6 |
376646 | 376646 | 2020-07-28 | Madison | Florida | 12079 | 560 | 6 |
379863 | 379863 | 2020-07-29 | Madison | Florida | 12079 | 564 | 6 |
383080 | 383080 | 2020-07-30 | Madison | Florida | 12079 | 583 | 7 |
386298 | 386298 | 2020-07-31 | Madison | Florida | 12079 | 604 | 7 |
389515 | 389515 | 2020-08-01 | Madison | Florida | 12079 | 618 | 7 |
392732 | 392732 | 2020-08-02 | Madison | Florida | 12079 | 643 | 7 |
395948 | 395948 | 2020-08-03 | Madison | Florida | 12079 | 655 | 8 |
399164 | 399164 | 2020-08-04 | Madison | Florida | 12079 | 661 | 8 |
402380 | 402380 | 2020-08-05 | Madison | Florida | 12079 | 663 | 8 |
405598 | 405598 | 2020-08-06 | Madison | Florida | 12079 | 675 | 8 |
408818 | 408818 | 2020-08-07 | Madison | Florida | 12079 | 686 | 8 |
412037 | 412037 | 2020-08-08 | Madison | Florida | 12079 | 700 | 8 |
415257 | 415257 | 2020-08-09 | Madison | Florida | 12079 | 700 | 8 |
418478 | 418478 | 2020-08-10 | Madison | Florida | 12079 | 708 | 8 |
421699 | 421699 | 2020-08-11 | Madison | Florida | 12079 | 710 | 8 |
424920 | 424920 | 2020-08-12 | Madison | Florida | 12079 | 732 | 8 |
428144 | 428144 | 2020-08-13 | Madison | Florida | 12079 | 738 | 9 |
431372 | 431372 | 2020-08-14 | Madison | Florida | 12079 | 748 | 10 |
434597 | 434597 | 2020-08-15 | Madison | Florida | 12079 | 754 | 10 |
437823 | 437823 | 2020-08-16 | Madison | Florida | 12079 | 763 | 11 |
441049 | 441049 | 2020-08-17 | Madison | Florida | 12079 | 766 | 11 |
444275 | 444275 | 2020-08-18 | Madison | Florida | 12079 | 772 | 12 |
447502 | 447502 | 2020-08-19 | Madison | Florida | 12079 | 778 | 12 |
450730 | 450730 | 2020-08-20 | Madison | Florida | 12079 | 782 | 12 |
453958 | 453958 | 2020-08-21 | Madison | Florida | 12079 | 807 | 12 |
457186 | 457186 | 2020-08-22 | Madison | Florida | 12079 | 822 | 12 |
460413 | 460413 | 2020-08-23 | Madison | Florida | 12079 | 830 | 12 |
463642 | 463642 | 2020-08-24 | Madison | Florida | 12079 | 832 | 12 |
466871 | 466871 | 2020-08-25 | Madison | Florida | 12079 | 834 | 12 |
470100 | 470100 | 2020-08-26 | Madison | Florida | 12079 | 841 | 14 |
473332 | 473332 | 2020-08-27 | Madison | Florida | 12079 | 844 | 14 |
476565 | 476565 | 2020-08-28 | Madison | Florida | 12079 | 852 | 14 |
479798 | 479798 | 2020-08-29 | Madison | Florida | 12079 | 860 | 14 |
483032 | 483032 | 2020-08-30 | Madison | Florida | 12079 | 867 | 14 |
486267 | 486267 | 2020-08-31 | Madison | Florida | 12079 | 868 | 14 |
489500 | 489500 | 2020-09-01 | Madison | Florida | 12079 | 877 | 15 |
492733 | 492733 | 2020-09-02 | Madison | Florida | 12079 | 877 | 16 |
495967 | 495967 | 2020-09-03 | Madison | Florida | 12079 | 887 | 16 |
499200 | 499200 | 2020-09-04 | Madison | Florida | 12079 | 898 | 16 |
502434 | 502434 | 2020-09-05 | Madison | Florida | 12079 | 907 | 16 |
505668 | 505668 | 2020-09-06 | Madison | Florida | 12079 | 922 | 16 |
508900 | 508900 | 2020-09-07 | Madison | Florida | 12079 | 926 | 17 |
512133 | 512133 | 2020-09-08 | Madison | Florida | 12079 | 926 | 16 |
515366 | 515366 | 2020-09-09 | Madison | Florida | 12079 | 935 | 16 |
518601 | 518601 | 2020-09-10 | Madison | Florida | 12079 | 956 | 16 |
521838 | 521838 | 2020-09-11 | Madison | Florida | 12079 | 974 | 16 |
525074 | 525074 | 2020-09-12 | Madison | Florida | 12079 | 981 | 16 |
528310 | 528310 | 2020-09-13 | Madison | Florida | 12079 | 988 | 16 |
531547 | 531547 | 2020-09-14 | Madison | Florida | 12079 | 989 | 16 |
534782 | 534782 | 2020-09-15 | Madison | Florida | 12079 | 989 | 16 |
538018 | 538018 | 2020-09-16 | Madison | Florida | 12079 | 993 | 17 |
541255 | 541255 | 2020-09-17 | Madison | Florida | 12079 | 995 | 18 |
544491 | 544491 | 2020-09-18 | Madison | Florida | 12079 | 1000 | 18 |
547729 | 547729 | 2020-09-19 | Madison | Florida | 12079 | 1001 | 18 |
550968 | 550968 | 2020-09-20 | Madison | Florida | 12079 | 1004 | 18 |
554207 | 554207 | 2020-09-21 | Madison | Florida | 12079 | 1005 | 18 |
557444 | 557444 | 2020-09-22 | Madison | Florida | 12079 | 1007 | 18 |
560680 | 560680 | 2020-09-23 | Madison | Florida | 12079 | 1009 | 18 |
563920 | 563920 | 2020-09-24 | Madison | Florida | 12079 | 1010 | 18 |
567160 | 567160 | 2020-09-25 | Madison | Florida | 12079 | 1013 | 18 |
570402 | 570402 | 2020-09-26 | Madison | Florida | 12079 | 1013 | 18 |
573644 | 573644 | 2020-09-27 | Madison | Florida | 12079 | 1014 | 19 |
576887 | 576887 | 2020-09-28 | Madison | Florida | 12079 | 1022 | 19 |
580128 | 580128 | 2020-09-29 | Madison | Florida | 12079 | 1022 | 20 |
583367 | 583367 | 2020-09-30 | Madison | Florida | 12079 | 1017 | 20 |
586607 | 586607 | 2020-10-01 | Madison | Florida | 12079 | 1017 | 20 |
589848 | 589848 | 2020-10-02 | Madison | Florida | 12079 | 1018 | 20 |
593088 | 593088 | 2020-10-03 | Madison | Florida | 12079 | 1022 | 20 |
596330 | 596330 | 2020-10-04 | Madison | Florida | 12079 | 1022 | 20 |
599573 | 599573 | 2020-10-05 | Madison | Florida | 12079 | 1024 | 20 |
602816 | 602816 | 2020-10-06 | Madison | Florida | 12079 | 1026 | 20 |
606058 | 606058 | 2020-10-07 | Madison | Florida | 12079 | 1030 | 20 |
609301 | 609301 | 2020-10-08 | Madison | Florida | 12079 | 1034 | 20 |
612543 | 612543 | 2020-10-09 | Madison | Florida | 12079 | 1035 | 22 |
615784 | 615784 | 2020-10-10 | Madison | Florida | 12079 | 1035 | 22 |
619026 | 619026 | 2020-10-11 | Madison | Florida | 12079 | 1041 | 24 |
622269 | 622269 | 2020-10-12 | Madison | Florida | 12079 | 1042 | 24 |
625512 | 625512 | 2020-10-13 | Madison | Florida | 12079 | 1043 | 24 |
628755 | 628755 | 2020-10-14 | Madison | Florida | 12079 | 1047 | 24 |
631999 | 631999 | 2020-10-15 | Madison | Florida | 12079 | 1049 | 24 |
635245 | 635245 | 2020-10-16 | Madison | Florida | 12079 | 1052 | 24 |
638490 | 638490 | 2020-10-17 | Madison | Florida | 12079 | 1053 | 24 |
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);