ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2021-09-06 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1690613 | 1690613 | 2021-09-06 | Adams | Indiana | 18001 | 4225 | 64 |
1690614 | 1690614 | 2021-09-06 | Allen | Indiana | 18003 | 49750 | 749 |
1690615 | 1690615 | 2021-09-06 | Bartholomew | Indiana | 18005 | 9577 | 166 |
1690616 | 1690616 | 2021-09-06 | Benton | Indiana | 18007 | 1310 | 15 |
1690617 | 1690617 | 2021-09-06 | Blackford | Indiana | 18009 | 1550 | 34 |
1690618 | 1690618 | 2021-09-06 | Boone | Indiana | 18011 | 7904 | 114 |
1690619 | 1690619 | 2021-09-06 | Brown | Indiana | 18013 | 1247 | 45 |
1690620 | 1690620 | 2021-09-06 | Carroll | Indiana | 18015 | 2286 | 27 |
1690621 | 1690621 | 2021-09-06 | Cass | Indiana | 18017 | 6727 | 119 |
1690622 | 1690622 | 2021-09-06 | Clark | Indiana | 18019 | 16190 | 220 |
1690623 | 1690623 | 2021-09-06 | Clay | Indiana | 18021 | 3468 | 51 |
1690624 | 1690624 | 2021-09-06 | Clinton | Indiana | 18023 | 5066 | 67 |
1690625 | 1690625 | 2021-09-06 | Crawford | Indiana | 18025 | 1315 | 19 |
1690626 | 1690626 | 2021-09-06 | Daviess | Indiana | 18027 | 3683 | 104 |
1690627 | 1690627 | 2021-09-06 | DeKalb | Indiana | 18033 | 5261 | 92 |
1690628 | 1690628 | 2021-09-06 | Dearborn | Indiana | 18029 | 6918 | 88 |
1690629 | 1690629 | 2021-09-06 | Decatur | Indiana | 18031 | 3565 | 98 |
1690630 | 1690630 | 2021-09-06 | Delaware | Indiana | 18035 | 12765 | 213 |
1690631 | 1690631 | 2021-09-06 | Dubois | Indiana | 18037 | 7107 | 121 |
1690632 | 1690632 | 2021-09-06 | Elkhart | Indiana | 18039 | 31640 | 495 |
1690633 | 1690633 | 2021-09-06 | Fayette | Indiana | 18041 | 3480 | 70 |
1690634 | 1690634 | 2021-09-06 | Floyd | Indiana | 18043 | 9585 | 198 |
1690635 | 1690635 | 2021-09-06 | Fountain | Indiana | 18045 | 2814 | 54 |
1690636 | 1690636 | 2021-09-06 | Franklin | Indiana | 18047 | 2111 | 36 |
1690637 | 1690637 | 2021-09-06 | Fulton | Indiana | 18049 | 2445 | 48 |
1690638 | 1690638 | 2021-09-06 | Gibson | Indiana | 18051 | 5653 | 105 |
1690639 | 1690639 | 2021-09-06 | Grant | Indiana | 18053 | 8738 | 196 |
1690640 | 1690640 | 2021-09-06 | Greene | Indiana | 18055 | 3488 | 90 |
1690641 | 1690641 | 2021-09-06 | Hamilton | Indiana | 18057 | 41367 | 454 |
1690642 | 1690642 | 2021-09-06 | Hancock | Indiana | 18059 | 10024 | 158 |
1690643 | 1690643 | 2021-09-06 | Harrison | Indiana | 18061 | 5501 | 82 |
1690644 | 1690644 | 2021-09-06 | Hendricks | Indiana | 18063 | 20651 | 353 |
1690645 | 1690645 | 2021-09-06 | Henry | Indiana | 18065 | 6967 | 123 |
1690646 | 1690646 | 2021-09-06 | Howard | Indiana | 18067 | 12760 | 254 |
1690647 | 1690647 | 2021-09-06 | Huntington | Indiana | 18069 | 5599 | 89 |
1690648 | 1690648 | 2021-09-06 | Jackson | Indiana | 18071 | 6059 | 80 |
1690649 | 1690649 | 2021-09-06 | Jasper | Indiana | 18073 | 4399 | 63 |
1690650 | 1690650 | 2021-09-06 | Jay | Indiana | 18075 | 2370 | 36 |
1690651 | 1690651 | 2021-09-06 | Jefferson | Indiana | 18077 | 4235 | 91 |
1690652 | 1690652 | 2021-09-06 | Jennings | Indiana | 18079 | 3126 | 54 |
1690653 | 1690653 | 2021-09-06 | Johnson | Indiana | 18081 | 22072 | 424 |
1690654 | 1690654 | 2021-09-06 | Knox | Indiana | 18083 | 5115 | 96 |
1690655 | 1690655 | 2021-09-06 | Kosciusko | Indiana | 18085 | 10666 | 135 |
1690656 | 1690656 | 2021-09-06 | LaGrange | Indiana | 18087 | 2941 | 75 |
1690657 | 1690657 | 2021-09-06 | LaPorte | Indiana | 18091 | 13477 | 231 |
1690658 | 1690658 | 2021-09-06 | Lake | Indiana | 18089 | 60627 | 1105 |
1690659 | 1690659 | 2021-09-06 | Lawrence | Indiana | 18093 | 6389 | 143 |
1690660 | 1690660 | 2021-09-06 | Madison | Indiana | 18095 | 16023 | 384 |
1690661 | 1690661 | 2021-09-06 | Marion | Indiana | 18097 | 119576 | 1961 |
1690662 | 1690662 | 2021-09-06 | Marshall | Indiana | 18099 | 6907 | 124 |
1690663 | 1690663 | 2021-09-06 | Martin | Indiana | 18101 | 1135 | 15 |
1690664 | 1690664 | 2021-09-06 | Miami | Indiana | 18103 | 4878 | 78 |
1690665 | 1690665 | 2021-09-06 | Monroe | Indiana | 18105 | 13704 | 190 |
1690666 | 1690666 | 2021-09-06 | Montgomery | Indiana | 18107 | 5321 | 98 |
1690667 | 1690667 | 2021-09-06 | Morgan | Indiana | 18109 | 8140 | 158 |
1690668 | 1690668 | 2021-09-06 | Newton | Indiana | 18111 | 1307 | 42 |
1690669 | 1690669 | 2021-09-06 | Noble | Indiana | 18113 | 6857 | 101 |
1690670 | 1690670 | 2021-09-06 | Ohio | Indiana | 18115 | 707 | 11 |
1690671 | 1690671 | 2021-09-06 | Orange | Indiana | 18117 | 2576 | 60 |
1690672 | 1690672 | 2021-09-06 | Owen | Indiana | 18119 | 2617 | 63 |
1690673 | 1690673 | 2021-09-06 | Parke | Indiana | 18121 | 1974 | 18 |
1690674 | 1690674 | 2021-09-06 | Perry | Indiana | 18123 | 2322 | 46 |
1690675 | 1690675 | 2021-09-06 | Pike | Indiana | 18125 | 1809 | 35 |
1690676 | 1690676 | 2021-09-06 | Porter | Indiana | 18127 | 20750 | 347 |
1690677 | 1690677 | 2021-09-06 | Posey | Indiana | 18129 | 3355 | 38 |
1690678 | 1690678 | 2021-09-06 | Pulaski | Indiana | 18131 | 1440 | 50 |
1690679 | 1690679 | 2021-09-06 | Putnam | Indiana | 18133 | 4873 | 68 |
1690680 | 1690680 | 2021-09-06 | Randolph | Indiana | 18135 | 2846 | 85 |
1690681 | 1690681 | 2021-09-06 | Ripley | Indiana | 18137 | 4079 | 72 |
1690682 | 1690682 | 2021-09-06 | Rush | Indiana | 18139 | 2078 | 27 |
1690683 | 1690683 | 2021-09-06 | Scott | Indiana | 18143 | 3626 | 63 |
1690684 | 1690684 | 2021-09-06 | Shelby | Indiana | 18145 | 6958 | 111 |
1690685 | 1690685 | 2021-09-06 | Spencer | Indiana | 18147 | 2941 | 32 |
1690686 | 1690686 | 2021-09-06 | St. Joseph | Indiana | 18141 | 39920 | 597 |
1690687 | 1690687 | 2021-09-06 | Starke | Indiana | 18149 | 2555 | 62 |
1690688 | 1690688 | 2021-09-06 | Steuben | Indiana | 18151 | 4611 | 66 |
1690689 | 1690689 | 2021-09-06 | Sullivan | Indiana | 18153 | 2735 | 47 |
1690690 | 1690690 | 2021-09-06 | Switzerland | Indiana | 18155 | 1103 | 9 |
1690691 | 1690691 | 2021-09-06 | Tippecanoe | Indiana | 18157 | 25706 | 240 |
1690692 | 1690692 | 2021-09-06 | Tipton | Indiana | 18159 | 1975 | 53 |
1690693 | 1690693 | 2021-09-06 | Union | Indiana | 18161 | 887 | 11 |
1690694 | 1690694 | 2021-09-06 | Vanderburgh | Indiana | 18163 | 28041 | 430 |
1690695 | 1690695 | 2021-09-06 | Vermillion | Indiana | 18165 | 2114 | 48 |
1690696 | 1690696 | 2021-09-06 | Vigo | Indiana | 18167 | 14592 | 271 |
1690697 | 1690697 | 2021-09-06 | Wabash | Indiana | 18169 | 4450 | 86 |
1690698 | 1690698 | 2021-09-06 | Warren | Indiana | 18171 | 1043 | 18 |
1690699 | 1690699 | 2021-09-06 | Warrick | Indiana | 18173 | 9809 | 170 |
1690700 | 1690700 | 2021-09-06 | Washington | Indiana | 18175 | 3026 | 43 |
1690701 | 1690701 | 2021-09-06 | Wayne | Indiana | 18177 | 9155 | 209 |
1690702 | 1690702 | 2021-09-06 | Wells | Indiana | 18179 | 3564 | 84 |
1690703 | 1690703 | 2021-09-06 | White | Indiana | 18181 | 3692 | 57 |
1690704 | 1690704 | 2021-09-06 | Whitley | Indiana | 18183 | 4860 | 48 |
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);