ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and fips = 18047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921163 | 921163 | 2021-01-12 | Franklin | Indiana | 18047 | 1391 | 33 |
917918 | 917918 | 2021-01-11 | Franklin | Indiana | 18047 | 1384 | 31 |
914673 | 914673 | 2021-01-10 | Franklin | Indiana | 18047 | 1376 | 31 |
911428 | 911428 | 2021-01-09 | Franklin | Indiana | 18047 | 1363 | 31 |
908183 | 908183 | 2021-01-08 | Franklin | Indiana | 18047 | 1356 | 31 |
904937 | 904937 | 2021-01-07 | Franklin | Indiana | 18047 | 1334 | 31 |
901692 | 901692 | 2021-01-06 | Franklin | Indiana | 18047 | 1316 | 31 |
898447 | 898447 | 2021-01-05 | Franklin | Indiana | 18047 | 1296 | 30 |
895202 | 895202 | 2021-01-04 | Franklin | Indiana | 18047 | 1285 | 30 |
891955 | 891955 | 2021-01-03 | Franklin | Indiana | 18047 | 1276 | 30 |
888709 | 888709 | 2021-01-02 | Franklin | Indiana | 18047 | 1265 | 30 |
885463 | 885463 | 2021-01-01 | Franklin | Indiana | 18047 | 1261 | 30 |
882218 | 882218 | 2020-12-31 | Franklin | Indiana | 18047 | 1229 | 29 |
878973 | 878973 | 2020-12-30 | Franklin | Indiana | 18047 | 1215 | 29 |
875728 | 875728 | 2020-12-29 | Franklin | Indiana | 18047 | 1197 | 29 |
872483 | 872483 | 2020-12-28 | Franklin | Indiana | 18047 | 1173 | 29 |
869238 | 869238 | 2020-12-27 | Franklin | Indiana | 18047 | 1165 | 29 |
865993 | 865993 | 2020-12-26 | Franklin | Indiana | 18047 | 1162 | 29 |
862748 | 862748 | 2020-12-25 | Franklin | Indiana | 18047 | 1154 | 29 |
859503 | 859503 | 2020-12-24 | Franklin | Indiana | 18047 | 1134 | 29 |
856258 | 856258 | 2020-12-23 | Franklin | Indiana | 18047 | 1121 | 29 |
853013 | 853013 | 2020-12-22 | Franklin | Indiana | 18047 | 1102 | 29 |
849768 | 849768 | 2020-12-21 | Franklin | Indiana | 18047 | 1098 | 29 |
846523 | 846523 | 2020-12-20 | Franklin | Indiana | 18047 | 1091 | 29 |
843277 | 843277 | 2020-12-19 | Franklin | Indiana | 18047 | 1081 | 29 |
840032 | 840032 | 2020-12-18 | Franklin | Indiana | 18047 | 1073 | 29 |
836787 | 836787 | 2020-12-17 | Franklin | Indiana | 18047 | 1051 | 29 |
833541 | 833541 | 2020-12-16 | Franklin | Indiana | 18047 | 1030 | 29 |
830294 | 830294 | 2020-12-15 | Franklin | Indiana | 18047 | 1013 | 29 |
827048 | 827048 | 2020-12-14 | Franklin | Indiana | 18047 | 999 | 29 |
823801 | 823801 | 2020-12-13 | Franklin | Indiana | 18047 | 992 | 29 |
820555 | 820555 | 2020-12-12 | Franklin | Indiana | 18047 | 963 | 29 |
817309 | 817309 | 2020-12-11 | Franklin | Indiana | 18047 | 954 | 29 |
814063 | 814063 | 2020-12-10 | Franklin | Indiana | 18047 | 938 | 29 |
810818 | 810818 | 2020-12-09 | Franklin | Indiana | 18047 | 926 | 29 |
807573 | 807573 | 2020-12-08 | Franklin | Indiana | 18047 | 904 | 29 |
804328 | 804328 | 2020-12-07 | Franklin | Indiana | 18047 | 887 | 29 |
801083 | 801083 | 2020-12-06 | Franklin | Indiana | 18047 | 872 | 29 |
797838 | 797838 | 2020-12-05 | Franklin | Indiana | 18047 | 857 | 29 |
794593 | 794593 | 2020-12-04 | Franklin | Indiana | 18047 | 832 | 29 |
791348 | 791348 | 2020-12-03 | Franklin | Indiana | 18047 | 818 | 29 |
788103 | 788103 | 2020-12-02 | Franklin | Indiana | 18047 | 811 | 29 |
784859 | 784859 | 2020-12-01 | Franklin | Indiana | 18047 | 800 | 28 |
781614 | 781614 | 2020-11-30 | Franklin | Indiana | 18047 | 786 | 28 |
778368 | 778368 | 2020-11-29 | Franklin | Indiana | 18047 | 773 | 28 |
775123 | 775123 | 2020-11-28 | Franklin | Indiana | 18047 | 756 | 28 |
771878 | 771878 | 2020-11-27 | Franklin | Indiana | 18047 | 748 | 28 |
768633 | 768633 | 2020-11-26 | Franklin | Indiana | 18047 | 727 | 28 |
765387 | 765387 | 2020-11-25 | Franklin | Indiana | 18047 | 712 | 28 |
762142 | 762142 | 2020-11-24 | Franklin | Indiana | 18047 | 698 | 27 |
758897 | 758897 | 2020-11-23 | Franklin | Indiana | 18047 | 671 | 26 |
755650 | 755650 | 2020-11-22 | Franklin | Indiana | 18047 | 647 | 26 |
752404 | 752404 | 2020-11-21 | Franklin | Indiana | 18047 | 629 | 26 |
749158 | 749158 | 2020-11-20 | Franklin | Indiana | 18047 | 613 | 26 |
745912 | 745912 | 2020-11-19 | Franklin | Indiana | 18047 | 603 | 26 |
742665 | 742665 | 2020-11-18 | Franklin | Indiana | 18047 | 583 | 26 |
739418 | 739418 | 2020-11-17 | Franklin | Indiana | 18047 | 571 | 26 |
736174 | 736174 | 2020-11-16 | Franklin | Indiana | 18047 | 559 | 26 |
732928 | 732928 | 2020-11-15 | Franklin | Indiana | 18047 | 544 | 26 |
729683 | 729683 | 2020-11-14 | Franklin | Indiana | 18047 | 536 | 26 |
726440 | 726440 | 2020-11-13 | Franklin | Indiana | 18047 | 517 | 26 |
723197 | 723197 | 2020-11-12 | Franklin | Indiana | 18047 | 512 | 26 |
719954 | 719954 | 2020-11-11 | Franklin | Indiana | 18047 | 500 | 26 |
716711 | 716711 | 2020-11-10 | Franklin | Indiana | 18047 | 487 | 26 |
713467 | 713467 | 2020-11-09 | Franklin | Indiana | 18047 | 474 | 26 |
710223 | 710223 | 2020-11-08 | Franklin | Indiana | 18047 | 471 | 26 |
706979 | 706979 | 2020-11-07 | Franklin | Indiana | 18047 | 460 | 26 |
703736 | 703736 | 2020-11-06 | Franklin | Indiana | 18047 | 445 | 27 |
700494 | 700494 | 2020-11-05 | Franklin | Indiana | 18047 | 438 | 27 |
697250 | 697250 | 2020-11-04 | Franklin | Indiana | 18047 | 432 | 27 |
694008 | 694008 | 2020-11-03 | Franklin | Indiana | 18047 | 428 | 27 |
690765 | 690765 | 2020-11-02 | Franklin | Indiana | 18047 | 423 | 27 |
687520 | 687520 | 2020-11-01 | Franklin | Indiana | 18047 | 417 | 27 |
684276 | 684276 | 2020-10-31 | Franklin | Indiana | 18047 | 416 | 27 |
681033 | 681033 | 2020-10-30 | Franklin | Indiana | 18047 | 417 | 27 |
677790 | 677790 | 2020-10-29 | Franklin | Indiana | 18047 | 407 | 26 |
674547 | 674547 | 2020-10-28 | Franklin | Indiana | 18047 | 399 | 26 |
671305 | 671305 | 2020-10-27 | Franklin | Indiana | 18047 | 393 | 26 |
668062 | 668062 | 2020-10-26 | Franklin | Indiana | 18047 | 393 | 26 |
664818 | 664818 | 2020-10-25 | Franklin | Indiana | 18047 | 391 | 26 |
661573 | 661573 | 2020-10-24 | Franklin | Indiana | 18047 | 389 | 26 |
658329 | 658329 | 2020-10-23 | Franklin | Indiana | 18047 | 386 | 26 |
655084 | 655084 | 2020-10-22 | Franklin | Indiana | 18047 | 382 | 26 |
651839 | 651839 | 2020-10-21 | Franklin | Indiana | 18047 | 376 | 26 |
648595 | 648595 | 2020-10-20 | Franklin | Indiana | 18047 | 375 | 26 |
645350 | 645350 | 2020-10-19 | Franklin | Indiana | 18047 | 373 | 26 |
642103 | 642103 | 2020-10-18 | Franklin | Indiana | 18047 | 369 | 26 |
638856 | 638856 | 2020-10-17 | Franklin | Indiana | 18047 | 368 | 26 |
635610 | 635610 | 2020-10-16 | Franklin | Indiana | 18047 | 359 | 26 |
632364 | 632364 | 2020-10-15 | Franklin | Indiana | 18047 | 346 | 26 |
629120 | 629120 | 2020-10-14 | Franklin | Indiana | 18047 | 345 | 26 |
625877 | 625877 | 2020-10-13 | Franklin | Indiana | 18047 | 339 | 26 |
622635 | 622635 | 2020-10-12 | Franklin | Indiana | 18047 | 337 | 26 |
619391 | 619391 | 2020-10-11 | Franklin | Indiana | 18047 | 337 | 26 |
616149 | 616149 | 2020-10-10 | Franklin | Indiana | 18047 | 337 | 26 |
612908 | 612908 | 2020-10-09 | Franklin | Indiana | 18047 | 335 | 26 |
609666 | 609666 | 2020-10-08 | Franklin | Indiana | 18047 | 334 | 26 |
606423 | 606423 | 2020-10-07 | Franklin | Indiana | 18047 | 330 | 26 |
603181 | 603181 | 2020-10-06 | Franklin | Indiana | 18047 | 329 | 26 |
599938 | 599938 | 2020-10-05 | Franklin | Indiana | 18047 | 329 | 26 |
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);