ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 18101 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054259 | 1054259 | 2021-02-22 | Martin | Indiana | 18101 | 800 | 14 |
1051012 | 1051012 | 2021-02-21 | Martin | Indiana | 18101 | 799 | 14 |
1047765 | 1047765 | 2021-02-20 | Martin | Indiana | 18101 | 798 | 14 |
1044520 | 1044520 | 2021-02-19 | Martin | Indiana | 18101 | 797 | 14 |
1041275 | 1041275 | 2021-02-18 | Martin | Indiana | 18101 | 798 | 14 |
1038030 | 1038030 | 2021-02-17 | Martin | Indiana | 18101 | 799 | 15 |
1034785 | 1034785 | 2021-02-16 | Martin | Indiana | 18101 | 799 | 15 |
1031539 | 1031539 | 2021-02-15 | Martin | Indiana | 18101 | 798 | 15 |
1028292 | 1028292 | 2021-02-14 | Martin | Indiana | 18101 | 798 | 15 |
1025047 | 1025047 | 2021-02-13 | Martin | Indiana | 18101 | 795 | 15 |
1021802 | 1021802 | 2021-02-12 | Martin | Indiana | 18101 | 794 | 15 |
1018557 | 1018557 | 2021-02-11 | Martin | Indiana | 18101 | 793 | 14 |
1015312 | 1015312 | 2021-02-10 | Martin | Indiana | 18101 | 789 | 14 |
1012067 | 1012067 | 2021-02-09 | Martin | Indiana | 18101 | 789 | 14 |
1008821 | 1008821 | 2021-02-08 | Martin | Indiana | 18101 | 787 | 14 |
1005575 | 1005575 | 2021-02-07 | Martin | Indiana | 18101 | 785 | 14 |
1002329 | 1002329 | 2021-02-06 | Martin | Indiana | 18101 | 784 | 14 |
999083 | 999083 | 2021-02-05 | Martin | Indiana | 18101 | 780 | 14 |
995837 | 995837 | 2021-02-04 | Martin | Indiana | 18101 | 779 | 14 |
992591 | 992591 | 2021-02-03 | Martin | Indiana | 18101 | 774 | 13 |
989345 | 989345 | 2021-02-02 | Martin | Indiana | 18101 | 774 | 13 |
986098 | 986098 | 2021-02-01 | Martin | Indiana | 18101 | 770 | 13 |
982851 | 982851 | 2021-01-31 | Martin | Indiana | 18101 | 769 | 13 |
979605 | 979605 | 2021-01-30 | Martin | Indiana | 18101 | 766 | 13 |
976359 | 976359 | 2021-01-29 | Martin | Indiana | 18101 | 761 | 13 |
973114 | 973114 | 2021-01-28 | Martin | Indiana | 18101 | 759 | 13 |
969869 | 969869 | 2021-01-27 | Martin | Indiana | 18101 | 753 | 13 |
966625 | 966625 | 2021-01-26 | Martin | Indiana | 18101 | 751 | 13 |
963380 | 963380 | 2021-01-25 | Martin | Indiana | 18101 | 750 | 13 |
960135 | 960135 | 2021-01-24 | Martin | Indiana | 18101 | 745 | 13 |
956889 | 956889 | 2021-01-23 | Martin | Indiana | 18101 | 738 | 13 |
953644 | 953644 | 2021-01-22 | Martin | Indiana | 18101 | 731 | 13 |
950399 | 950399 | 2021-01-21 | Martin | Indiana | 18101 | 724 | 13 |
947153 | 947153 | 2021-01-20 | Martin | Indiana | 18101 | 711 | 13 |
943906 | 943906 | 2021-01-19 | Martin | Indiana | 18101 | 708 | 13 |
940661 | 940661 | 2021-01-18 | Martin | Indiana | 18101 | 705 | 13 |
937416 | 937416 | 2021-01-17 | Martin | Indiana | 18101 | 701 | 13 |
934171 | 934171 | 2021-01-16 | Martin | Indiana | 18101 | 693 | 13 |
930926 | 930926 | 2021-01-15 | Martin | Indiana | 18101 | 689 | 13 |
927681 | 927681 | 2021-01-14 | Martin | Indiana | 18101 | 681 | 13 |
924435 | 924435 | 2021-01-13 | Martin | Indiana | 18101 | 681 | 13 |
921190 | 921190 | 2021-01-12 | Martin | Indiana | 18101 | 679 | 13 |
917945 | 917945 | 2021-01-11 | Martin | Indiana | 18101 | 677 | 13 |
914700 | 914700 | 2021-01-10 | Martin | Indiana | 18101 | 673 | 13 |
911455 | 911455 | 2021-01-09 | Martin | Indiana | 18101 | 661 | 13 |
908210 | 908210 | 2021-01-08 | Martin | Indiana | 18101 | 654 | 13 |
904964 | 904964 | 2021-01-07 | Martin | Indiana | 18101 | 649 | 13 |
901719 | 901719 | 2021-01-06 | Martin | Indiana | 18101 | 634 | 13 |
898474 | 898474 | 2021-01-05 | Martin | Indiana | 18101 | 627 | 13 |
895229 | 895229 | 2021-01-04 | Martin | Indiana | 18101 | 624 | 13 |
891982 | 891982 | 2021-01-03 | Martin | Indiana | 18101 | 618 | 13 |
888736 | 888736 | 2021-01-02 | Martin | Indiana | 18101 | 613 | 12 |
885490 | 885490 | 2021-01-01 | Martin | Indiana | 18101 | 602 | 12 |
882245 | 882245 | 2020-12-31 | Martin | Indiana | 18101 | 592 | 12 |
879000 | 879000 | 2020-12-30 | Martin | Indiana | 18101 | 574 | 11 |
875755 | 875755 | 2020-12-29 | Martin | Indiana | 18101 | 564 | 11 |
872510 | 872510 | 2020-12-28 | Martin | Indiana | 18101 | 563 | 11 |
869265 | 869265 | 2020-12-27 | Martin | Indiana | 18101 | 563 | 11 |
866020 | 866020 | 2020-12-26 | Martin | Indiana | 18101 | 558 | 11 |
862775 | 862775 | 2020-12-25 | Martin | Indiana | 18101 | 556 | 11 |
859530 | 859530 | 2020-12-24 | Martin | Indiana | 18101 | 544 | 11 |
856285 | 856285 | 2020-12-23 | Martin | Indiana | 18101 | 526 | 11 |
853040 | 853040 | 2020-12-22 | Martin | Indiana | 18101 | 521 | 11 |
849795 | 849795 | 2020-12-21 | Martin | Indiana | 18101 | 518 | 11 |
846550 | 846550 | 2020-12-20 | Martin | Indiana | 18101 | 511 | 11 |
843304 | 843304 | 2020-12-19 | Martin | Indiana | 18101 | 505 | 11 |
840059 | 840059 | 2020-12-18 | Martin | Indiana | 18101 | 502 | 11 |
836814 | 836814 | 2020-12-17 | Martin | Indiana | 18101 | 500 | 11 |
833568 | 833568 | 2020-12-16 | Martin | Indiana | 18101 | 494 | 11 |
830321 | 830321 | 2020-12-15 | Martin | Indiana | 18101 | 490 | 8 |
827075 | 827075 | 2020-12-14 | Martin | Indiana | 18101 | 489 | 8 |
823828 | 823828 | 2020-12-13 | Martin | Indiana | 18101 | 485 | 8 |
820582 | 820582 | 2020-12-12 | Martin | Indiana | 18101 | 471 | 8 |
817336 | 817336 | 2020-12-11 | Martin | Indiana | 18101 | 464 | 8 |
814090 | 814090 | 2020-12-10 | Martin | Indiana | 18101 | 450 | 8 |
810845 | 810845 | 2020-12-09 | Martin | Indiana | 18101 | 439 | 7 |
807600 | 807600 | 2020-12-08 | Martin | Indiana | 18101 | 434 | 6 |
804355 | 804355 | 2020-12-07 | Martin | Indiana | 18101 | 434 | 6 |
801110 | 801110 | 2020-12-06 | Martin | Indiana | 18101 | 426 | 6 |
797865 | 797865 | 2020-12-05 | Martin | Indiana | 18101 | 420 | 6 |
794620 | 794620 | 2020-12-04 | Martin | Indiana | 18101 | 414 | 6 |
791375 | 791375 | 2020-12-03 | Martin | Indiana | 18101 | 401 | 6 |
788130 | 788130 | 2020-12-02 | Martin | Indiana | 18101 | 390 | 6 |
784886 | 784886 | 2020-12-01 | Martin | Indiana | 18101 | 384 | 6 |
781641 | 781641 | 2020-11-30 | Martin | Indiana | 18101 | 387 | 6 |
778395 | 778395 | 2020-11-29 | Martin | Indiana | 18101 | 383 | 6 |
775150 | 775150 | 2020-11-28 | Martin | Indiana | 18101 | 378 | 6 |
771905 | 771905 | 2020-11-27 | Martin | Indiana | 18101 | 371 | 5 |
768660 | 768660 | 2020-11-26 | Martin | Indiana | 18101 | 365 | 5 |
765414 | 765414 | 2020-11-25 | Martin | Indiana | 18101 | 359 | 5 |
762169 | 762169 | 2020-11-24 | Martin | Indiana | 18101 | 352 | 5 |
758924 | 758924 | 2020-11-23 | Martin | Indiana | 18101 | 349 | 5 |
755677 | 755677 | 2020-11-22 | Martin | Indiana | 18101 | 343 | 5 |
752431 | 752431 | 2020-11-21 | Martin | Indiana | 18101 | 336 | 5 |
749185 | 749185 | 2020-11-20 | Martin | Indiana | 18101 | 328 | 5 |
745939 | 745939 | 2020-11-19 | Martin | Indiana | 18101 | 321 | 2 |
742692 | 742692 | 2020-11-18 | Martin | Indiana | 18101 | 305 | 2 |
739445 | 739445 | 2020-11-17 | Martin | Indiana | 18101 | 294 | 2 |
736201 | 736201 | 2020-11-16 | Martin | Indiana | 18101 | 287 | 2 |
732955 | 732955 | 2020-11-15 | Martin | Indiana | 18101 | 288 | 2 |
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);