ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18119 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054268 | 1054268 | 2021-02-22 | Owen | Indiana | 18119 | 1819 | 54 |
1051021 | 1051021 | 2021-02-21 | Owen | Indiana | 18119 | 1818 | 54 |
1047774 | 1047774 | 2021-02-20 | Owen | Indiana | 18119 | 1818 | 54 |
1044529 | 1044529 | 2021-02-19 | Owen | Indiana | 18119 | 1817 | 54 |
1041284 | 1041284 | 2021-02-18 | Owen | Indiana | 18119 | 1815 | 54 |
1038039 | 1038039 | 2021-02-17 | Owen | Indiana | 18119 | 1814 | 54 |
1034794 | 1034794 | 2021-02-16 | Owen | Indiana | 18119 | 1813 | 54 |
1031548 | 1031548 | 2021-02-15 | Owen | Indiana | 18119 | 1813 | 54 |
1028301 | 1028301 | 2021-02-14 | Owen | Indiana | 18119 | 1813 | 54 |
1025056 | 1025056 | 2021-02-13 | Owen | Indiana | 18119 | 1812 | 53 |
1021811 | 1021811 | 2021-02-12 | Owen | Indiana | 18119 | 1811 | 53 |
1018566 | 1018566 | 2021-02-11 | Owen | Indiana | 18119 | 1807 | 52 |
1015321 | 1015321 | 2021-02-10 | Owen | Indiana | 18119 | 1801 | 52 |
1012076 | 1012076 | 2021-02-09 | Owen | Indiana | 18119 | 1800 | 52 |
1008830 | 1008830 | 2021-02-08 | Owen | Indiana | 18119 | 1799 | 52 |
1005584 | 1005584 | 2021-02-07 | Owen | Indiana | 18119 | 1794 | 52 |
1002338 | 1002338 | 2021-02-06 | Owen | Indiana | 18119 | 1788 | 52 |
999092 | 999092 | 2021-02-05 | Owen | Indiana | 18119 | 1765 | 52 |
995846 | 995846 | 2021-02-04 | Owen | Indiana | 18119 | 1758 | 50 |
992600 | 992600 | 2021-02-03 | Owen | Indiana | 18119 | 1753 | 40 |
989354 | 989354 | 2021-02-02 | Owen | Indiana | 18119 | 1752 | 40 |
986107 | 986107 | 2021-02-01 | Owen | Indiana | 18119 | 1744 | 40 |
982860 | 982860 | 2021-01-31 | Owen | Indiana | 18119 | 1735 | 40 |
979614 | 979614 | 2021-01-30 | Owen | Indiana | 18119 | 1730 | 40 |
976368 | 976368 | 2021-01-29 | Owen | Indiana | 18119 | 1723 | 40 |
973123 | 973123 | 2021-01-28 | Owen | Indiana | 18119 | 1705 | 40 |
969878 | 969878 | 2021-01-27 | Owen | Indiana | 18119 | 1690 | 40 |
966634 | 966634 | 2021-01-26 | Owen | Indiana | 18119 | 1686 | 40 |
963389 | 963389 | 2021-01-25 | Owen | Indiana | 18119 | 1679 | 39 |
960144 | 960144 | 2021-01-24 | Owen | Indiana | 18119 | 1671 | 39 |
956898 | 956898 | 2021-01-23 | Owen | Indiana | 18119 | 1660 | 39 |
953653 | 953653 | 2021-01-22 | Owen | Indiana | 18119 | 1639 | 39 |
950408 | 950408 | 2021-01-21 | Owen | Indiana | 18119 | 1631 | 39 |
947162 | 947162 | 2021-01-20 | Owen | Indiana | 18119 | 1620 | 39 |
943915 | 943915 | 2021-01-19 | Owen | Indiana | 18119 | 1614 | 39 |
940670 | 940670 | 2021-01-18 | Owen | Indiana | 18119 | 1604 | 39 |
937425 | 937425 | 2021-01-17 | Owen | Indiana | 18119 | 1598 | 39 |
934180 | 934180 | 2021-01-16 | Owen | Indiana | 18119 | 1581 | 39 |
930935 | 930935 | 2021-01-15 | Owen | Indiana | 18119 | 1568 | 38 |
927690 | 927690 | 2021-01-14 | Owen | Indiana | 18119 | 1558 | 38 |
924444 | 924444 | 2021-01-13 | Owen | Indiana | 18119 | 1546 | 36 |
921199 | 921199 | 2021-01-12 | Owen | Indiana | 18119 | 1542 | 36 |
917954 | 917954 | 2021-01-11 | Owen | Indiana | 18119 | 1532 | 36 |
914709 | 914709 | 2021-01-10 | Owen | Indiana | 18119 | 1520 | 36 |
911464 | 911464 | 2021-01-09 | Owen | Indiana | 18119 | 1505 | 36 |
908219 | 908219 | 2021-01-08 | Owen | Indiana | 18119 | 1488 | 36 |
904973 | 904973 | 2021-01-07 | Owen | Indiana | 18119 | 1467 | 35 |
901728 | 901728 | 2021-01-06 | Owen | Indiana | 18119 | 1432 | 34 |
898483 | 898483 | 2021-01-05 | Owen | Indiana | 18119 | 1396 | 34 |
895238 | 895238 | 2021-01-04 | Owen | Indiana | 18119 | 1393 | 34 |
891991 | 891991 | 2021-01-03 | Owen | Indiana | 18119 | 1377 | 33 |
888745 | 888745 | 2021-01-02 | Owen | Indiana | 18119 | 1361 | 33 |
885499 | 885499 | 2021-01-01 | Owen | Indiana | 18119 | 1346 | 33 |
882254 | 882254 | 2020-12-31 | Owen | Indiana | 18119 | 1325 | 32 |
879009 | 879009 | 2020-12-30 | Owen | Indiana | 18119 | 1295 | 32 |
875764 | 875764 | 2020-12-29 | Owen | Indiana | 18119 | 1280 | 32 |
872519 | 872519 | 2020-12-28 | Owen | Indiana | 18119 | 1267 | 30 |
869274 | 869274 | 2020-12-27 | Owen | Indiana | 18119 | 1256 | 30 |
866029 | 866029 | 2020-12-26 | Owen | Indiana | 18119 | 1245 | 30 |
862784 | 862784 | 2020-12-25 | Owen | Indiana | 18119 | 1240 | 30 |
859539 | 859539 | 2020-12-24 | Owen | Indiana | 18119 | 1220 | 29 |
856294 | 856294 | 2020-12-23 | Owen | Indiana | 18119 | 1181 | 28 |
853049 | 853049 | 2020-12-22 | Owen | Indiana | 18119 | 1171 | 27 |
849804 | 849804 | 2020-12-21 | Owen | Indiana | 18119 | 1158 | 24 |
846559 | 846559 | 2020-12-20 | Owen | Indiana | 18119 | 1142 | 24 |
843313 | 843313 | 2020-12-19 | Owen | Indiana | 18119 | 1120 | 22 |
840068 | 840068 | 2020-12-18 | Owen | Indiana | 18119 | 1108 | 20 |
836823 | 836823 | 2020-12-17 | Owen | Indiana | 18119 | 1091 | 19 |
833577 | 833577 | 2020-12-16 | Owen | Indiana | 18119 | 1061 | 19 |
830330 | 830330 | 2020-12-15 | Owen | Indiana | 18119 | 1042 | 17 |
827084 | 827084 | 2020-12-14 | Owen | Indiana | 18119 | 1029 | 16 |
823837 | 823837 | 2020-12-13 | Owen | Indiana | 18119 | 1007 | 16 |
820591 | 820591 | 2020-12-12 | Owen | Indiana | 18119 | 985 | 16 |
817345 | 817345 | 2020-12-11 | Owen | Indiana | 18119 | 949 | 16 |
814099 | 814099 | 2020-12-10 | Owen | Indiana | 18119 | 932 | 15 |
810854 | 810854 | 2020-12-09 | Owen | Indiana | 18119 | 883 | 15 |
807609 | 807609 | 2020-12-08 | Owen | Indiana | 18119 | 865 | 14 |
804364 | 804364 | 2020-12-07 | Owen | Indiana | 18119 | 841 | 14 |
801119 | 801119 | 2020-12-06 | Owen | Indiana | 18119 | 809 | 13 |
797874 | 797874 | 2020-12-05 | Owen | Indiana | 18119 | 780 | 13 |
794629 | 794629 | 2020-12-04 | Owen | Indiana | 18119 | 745 | 12 |
791384 | 791384 | 2020-12-03 | Owen | Indiana | 18119 | 723 | 11 |
788139 | 788139 | 2020-12-02 | Owen | Indiana | 18119 | 715 | 11 |
784895 | 784895 | 2020-12-01 | Owen | Indiana | 18119 | 688 | 10 |
781650 | 781650 | 2020-11-30 | Owen | Indiana | 18119 | 670 | 10 |
778404 | 778404 | 2020-11-29 | Owen | Indiana | 18119 | 660 | 9 |
775159 | 775159 | 2020-11-28 | Owen | Indiana | 18119 | 653 | 9 |
771914 | 771914 | 2020-11-27 | Owen | Indiana | 18119 | 647 | 9 |
768669 | 768669 | 2020-11-26 | Owen | Indiana | 18119 | 632 | 8 |
765423 | 765423 | 2020-11-25 | Owen | Indiana | 18119 | 609 | 8 |
762178 | 762178 | 2020-11-24 | Owen | Indiana | 18119 | 599 | 8 |
758933 | 758933 | 2020-11-23 | Owen | Indiana | 18119 | 582 | 7 |
755686 | 755686 | 2020-11-22 | Owen | Indiana | 18119 | 568 | 7 |
752440 | 752440 | 2020-11-21 | Owen | Indiana | 18119 | 550 | 7 |
749194 | 749194 | 2020-11-20 | Owen | Indiana | 18119 | 523 | 7 |
745948 | 745948 | 2020-11-19 | Owen | Indiana | 18119 | 515 | 7 |
742701 | 742701 | 2020-11-18 | Owen | Indiana | 18119 | 496 | 7 |
739454 | 739454 | 2020-11-17 | Owen | Indiana | 18119 | 481 | 5 |
736210 | 736210 | 2020-11-16 | Owen | Indiana | 18119 | 471 | 3 |
732964 | 732964 | 2020-11-15 | Owen | Indiana | 18119 | 466 | 3 |
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);