ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Carroll" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908167 | 908167 | 2021-01-08 | Carroll | Indiana | 18015 | 1445 | 16 |
904921 | 904921 | 2021-01-07 | Carroll | Indiana | 18015 | 1435 | 16 |
901676 | 901676 | 2021-01-06 | Carroll | Indiana | 18015 | 1420 | 16 |
898431 | 898431 | 2021-01-05 | Carroll | Indiana | 18015 | 1394 | 15 |
895186 | 895186 | 2021-01-04 | Carroll | Indiana | 18015 | 1390 | 15 |
891939 | 891939 | 2021-01-03 | Carroll | Indiana | 18015 | 1373 | 15 |
888693 | 888693 | 2021-01-02 | Carroll | Indiana | 18015 | 1367 | 15 |
885447 | 885447 | 2021-01-01 | Carroll | Indiana | 18015 | 1355 | 15 |
882202 | 882202 | 2020-12-31 | Carroll | Indiana | 18015 | 1333 | 15 |
878957 | 878957 | 2020-12-30 | Carroll | Indiana | 18015 | 1310 | 15 |
875712 | 875712 | 2020-12-29 | Carroll | Indiana | 18015 | 1291 | 15 |
872467 | 872467 | 2020-12-28 | Carroll | Indiana | 18015 | 1272 | 15 |
869222 | 869222 | 2020-12-27 | Carroll | Indiana | 18015 | 1269 | 15 |
865977 | 865977 | 2020-12-26 | Carroll | Indiana | 18015 | 1260 | 15 |
862732 | 862732 | 2020-12-25 | Carroll | Indiana | 18015 | 1249 | 15 |
859487 | 859487 | 2020-12-24 | Carroll | Indiana | 18015 | 1234 | 15 |
856242 | 856242 | 2020-12-23 | Carroll | Indiana | 18015 | 1216 | 15 |
852997 | 852997 | 2020-12-22 | Carroll | Indiana | 18015 | 1199 | 15 |
849752 | 849752 | 2020-12-21 | Carroll | Indiana | 18015 | 1186 | 15 |
846507 | 846507 | 2020-12-20 | Carroll | Indiana | 18015 | 1166 | 15 |
843261 | 843261 | 2020-12-19 | Carroll | Indiana | 18015 | 1130 | 14 |
840016 | 840016 | 2020-12-18 | Carroll | Indiana | 18015 | 1121 | 14 |
836771 | 836771 | 2020-12-17 | Carroll | Indiana | 18015 | 1107 | 14 |
833525 | 833525 | 2020-12-16 | Carroll | Indiana | 18015 | 1098 | 14 |
830278 | 830278 | 2020-12-15 | Carroll | Indiana | 18015 | 1073 | 14 |
827032 | 827032 | 2020-12-14 | Carroll | Indiana | 18015 | 1057 | 14 |
823785 | 823785 | 2020-12-13 | Carroll | Indiana | 18015 | 1040 | 14 |
820539 | 820539 | 2020-12-12 | Carroll | Indiana | 18015 | 1021 | 14 |
817293 | 817293 | 2020-12-11 | Carroll | Indiana | 18015 | 979 | 14 |
814047 | 814047 | 2020-12-10 | Carroll | Indiana | 18015 | 961 | 14 |
810802 | 810802 | 2020-12-09 | Carroll | Indiana | 18015 | 935 | 13 |
807557 | 807557 | 2020-12-08 | Carroll | Indiana | 18015 | 908 | 13 |
804312 | 804312 | 2020-12-07 | Carroll | Indiana | 18015 | 887 | 13 |
801067 | 801067 | 2020-12-06 | Carroll | Indiana | 18015 | 868 | 13 |
797822 | 797822 | 2020-12-05 | Carroll | Indiana | 18015 | 851 | 13 |
794577 | 794577 | 2020-12-04 | Carroll | Indiana | 18015 | 839 | 13 |
791332 | 791332 | 2020-12-03 | Carroll | Indiana | 18015 | 813 | 13 |
788087 | 788087 | 2020-12-02 | Carroll | Indiana | 18015 | 793 | 13 |
784843 | 784843 | 2020-12-01 | Carroll | Indiana | 18015 | 769 | 13 |
781598 | 781598 | 2020-11-30 | Carroll | Indiana | 18015 | 753 | 13 |
778352 | 778352 | 2020-11-29 | Carroll | Indiana | 18015 | 737 | 13 |
775107 | 775107 | 2020-11-28 | Carroll | Indiana | 18015 | 729 | 13 |
771862 | 771862 | 2020-11-27 | Carroll | Indiana | 18015 | 719 | 13 |
768617 | 768617 | 2020-11-26 | Carroll | Indiana | 18015 | 696 | 13 |
765371 | 765371 | 2020-11-25 | Carroll | Indiana | 18015 | 686 | 13 |
762126 | 762126 | 2020-11-24 | Carroll | Indiana | 18015 | 679 | 13 |
758881 | 758881 | 2020-11-23 | Carroll | Indiana | 18015 | 668 | 13 |
755634 | 755634 | 2020-11-22 | Carroll | Indiana | 18015 | 653 | 13 |
752388 | 752388 | 2020-11-21 | Carroll | Indiana | 18015 | 637 | 13 |
749142 | 749142 | 2020-11-20 | Carroll | Indiana | 18015 | 626 | 13 |
745896 | 745896 | 2020-11-19 | Carroll | Indiana | 18015 | 615 | 13 |
742649 | 742649 | 2020-11-18 | Carroll | Indiana | 18015 | 591 | 13 |
739402 | 739402 | 2020-11-17 | Carroll | Indiana | 18015 | 577 | 13 |
736158 | 736158 | 2020-11-16 | Carroll | Indiana | 18015 | 564 | 13 |
732912 | 732912 | 2020-11-15 | Carroll | Indiana | 18015 | 552 | 13 |
729667 | 729667 | 2020-11-14 | Carroll | Indiana | 18015 | 541 | 13 |
726424 | 726424 | 2020-11-13 | Carroll | Indiana | 18015 | 520 | 13 |
723181 | 723181 | 2020-11-12 | Carroll | Indiana | 18015 | 514 | 13 |
719938 | 719938 | 2020-11-11 | Carroll | Indiana | 18015 | 505 | 13 |
716695 | 716695 | 2020-11-10 | Carroll | Indiana | 18015 | 493 | 13 |
713451 | 713451 | 2020-11-09 | Carroll | Indiana | 18015 | 485 | 13 |
710207 | 710207 | 2020-11-08 | Carroll | Indiana | 18015 | 469 | 13 |
706963 | 706963 | 2020-11-07 | Carroll | Indiana | 18015 | 455 | 13 |
703720 | 703720 | 2020-11-06 | Carroll | Indiana | 18015 | 442 | 13 |
700478 | 700478 | 2020-11-05 | Carroll | Indiana | 18015 | 439 | 13 |
697234 | 697234 | 2020-11-04 | Carroll | Indiana | 18015 | 422 | 13 |
693992 | 693992 | 2020-11-03 | Carroll | Indiana | 18015 | 408 | 13 |
690749 | 690749 | 2020-11-02 | Carroll | Indiana | 18015 | 396 | 13 |
687504 | 687504 | 2020-11-01 | Carroll | Indiana | 18015 | 386 | 13 |
684260 | 684260 | 2020-10-31 | Carroll | Indiana | 18015 | 379 | 13 |
681017 | 681017 | 2020-10-30 | Carroll | Indiana | 18015 | 370 | 13 |
677774 | 677774 | 2020-10-29 | Carroll | Indiana | 18015 | 364 | 13 |
674531 | 674531 | 2020-10-28 | Carroll | Indiana | 18015 | 352 | 13 |
671289 | 671289 | 2020-10-27 | Carroll | Indiana | 18015 | 347 | 13 |
668046 | 668046 | 2020-10-26 | Carroll | Indiana | 18015 | 343 | 13 |
664802 | 664802 | 2020-10-25 | Carroll | Indiana | 18015 | 338 | 13 |
661557 | 661557 | 2020-10-24 | Carroll | Indiana | 18015 | 332 | 13 |
658313 | 658313 | 2020-10-23 | Carroll | Indiana | 18015 | 329 | 13 |
655068 | 655068 | 2020-10-22 | Carroll | Indiana | 18015 | 325 | 13 |
651823 | 651823 | 2020-10-21 | Carroll | Indiana | 18015 | 317 | 13 |
648579 | 648579 | 2020-10-20 | Carroll | Indiana | 18015 | 314 | 13 |
645334 | 645334 | 2020-10-19 | Carroll | Indiana | 18015 | 308 | 13 |
642087 | 642087 | 2020-10-18 | Carroll | Indiana | 18015 | 305 | 13 |
638840 | 638840 | 2020-10-17 | Carroll | Indiana | 18015 | 305 | 13 |
635594 | 635594 | 2020-10-16 | Carroll | Indiana | 18015 | 305 | 13 |
632348 | 632348 | 2020-10-15 | Carroll | Indiana | 18015 | 301 | 13 |
629104 | 629104 | 2020-10-14 | Carroll | Indiana | 18015 | 300 | 13 |
625861 | 625861 | 2020-10-13 | Carroll | Indiana | 18015 | 299 | 13 |
622619 | 622619 | 2020-10-12 | Carroll | Indiana | 18015 | 299 | 13 |
619375 | 619375 | 2020-10-11 | Carroll | Indiana | 18015 | 299 | 13 |
616133 | 616133 | 2020-10-10 | Carroll | Indiana | 18015 | 298 | 13 |
612892 | 612892 | 2020-10-09 | Carroll | Indiana | 18015 | 294 | 13 |
609650 | 609650 | 2020-10-08 | Carroll | Indiana | 18015 | 292 | 13 |
606407 | 606407 | 2020-10-07 | Carroll | Indiana | 18015 | 292 | 13 |
603165 | 603165 | 2020-10-06 | Carroll | Indiana | 18015 | 289 | 13 |
599922 | 599922 | 2020-10-05 | Carroll | Indiana | 18015 | 289 | 13 |
596680 | 596680 | 2020-10-04 | Carroll | Indiana | 18015 | 288 | 13 |
593438 | 593438 | 2020-10-03 | Carroll | Indiana | 18015 | 287 | 13 |
590197 | 590197 | 2020-10-02 | Carroll | Indiana | 18015 | 286 | 13 |
586956 | 586956 | 2020-10-01 | Carroll | Indiana | 18015 | 285 | 13 |
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);