ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-09-02" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1677614 | 1677614 | 2021-09-02 | Adams | Indiana | 18001 | 4207 | 64 |
1677615 | 1677615 | 2021-09-02 | Allen | Indiana | 18003 | 49445 | 747 |
1677616 | 1677616 | 2021-09-02 | Bartholomew | Indiana | 18005 | 9507 | 166 |
1677617 | 1677617 | 2021-09-02 | Benton | Indiana | 18007 | 1284 | 15 |
1677618 | 1677618 | 2021-09-02 | Blackford | Indiana | 18009 | 1537 | 34 |
1677619 | 1677619 | 2021-09-02 | Boone | Indiana | 18011 | 7887 | 114 |
1677620 | 1677620 | 2021-09-02 | Brown | Indiana | 18013 | 1241 | 45 |
1677621 | 1677621 | 2021-09-02 | Carroll | Indiana | 18015 | 2266 | 27 |
1677622 | 1677622 | 2021-09-02 | Cass | Indiana | 18017 | 6687 | 118 |
1677623 | 1677623 | 2021-09-02 | Clark | Indiana | 18019 | 16116 | 220 |
1677624 | 1677624 | 2021-09-02 | Clay | Indiana | 18021 | 3445 | 51 |
1677625 | 1677625 | 2021-09-02 | Clinton | Indiana | 18023 | 5046 | 67 |
1677626 | 1677626 | 2021-09-02 | Crawford | Indiana | 18025 | 1309 | 19 |
1677627 | 1677627 | 2021-09-02 | Daviess | Indiana | 18027 | 3646 | 104 |
1677628 | 1677628 | 2021-09-02 | DeKalb | Indiana | 18033 | 5216 | 92 |
1677629 | 1677629 | 2021-09-02 | Dearborn | Indiana | 18029 | 6869 | 88 |
1677630 | 1677630 | 2021-09-02 | Decatur | Indiana | 18031 | 3546 | 98 |
1677631 | 1677631 | 2021-09-02 | Delaware | Indiana | 18035 | 12659 | 212 |
1677632 | 1677632 | 2021-09-02 | Dubois | Indiana | 18037 | 7063 | 120 |
1677633 | 1677633 | 2021-09-02 | Elkhart | Indiana | 18039 | 31537 | 495 |
1677634 | 1677634 | 2021-09-02 | Fayette | Indiana | 18041 | 3448 | 70 |
1677635 | 1677635 | 2021-09-02 | Floyd | Indiana | 18043 | 9521 | 197 |
1677636 | 1677636 | 2021-09-02 | Fountain | Indiana | 18045 | 2788 | 54 |
1677637 | 1677637 | 2021-09-02 | Franklin | Indiana | 18047 | 2067 | 36 |
1677638 | 1677638 | 2021-09-02 | Fulton | Indiana | 18049 | 2415 | 48 |
1677639 | 1677639 | 2021-09-02 | Gibson | Indiana | 18051 | 5602 | 105 |
1677640 | 1677640 | 2021-09-02 | Grant | Indiana | 18053 | 8694 | 196 |
1677641 | 1677641 | 2021-09-02 | Greene | Indiana | 18055 | 3464 | 90 |
1677642 | 1677642 | 2021-09-02 | Hamilton | Indiana | 18057 | 41163 | 454 |
1677643 | 1677643 | 2021-09-02 | Hancock | Indiana | 18059 | 9960 | 158 |
1677644 | 1677644 | 2021-09-02 | Harrison | Indiana | 18061 | 5470 | 82 |
1677645 | 1677645 | 2021-09-02 | Hendricks | Indiana | 18063 | 20503 | 352 |
1677646 | 1677646 | 2021-09-02 | Henry | Indiana | 18065 | 6940 | 122 |
1677647 | 1677647 | 2021-09-02 | Howard | Indiana | 18067 | 12655 | 254 |
1677648 | 1677648 | 2021-09-02 | Huntington | Indiana | 18069 | 5552 | 89 |
1677649 | 1677649 | 2021-09-02 | Jackson | Indiana | 18071 | 6038 | 80 |
1677650 | 1677650 | 2021-09-02 | Jasper | Indiana | 18073 | 4380 | 62 |
1677651 | 1677651 | 2021-09-02 | Jay | Indiana | 18075 | 2351 | 36 |
1677652 | 1677652 | 2021-09-02 | Jefferson | Indiana | 18077 | 4214 | 91 |
1677653 | 1677653 | 2021-09-02 | Jennings | Indiana | 18079 | 3092 | 54 |
1677654 | 1677654 | 2021-09-02 | Johnson | Indiana | 18081 | 21922 | 423 |
1677655 | 1677655 | 2021-09-02 | Knox | Indiana | 18083 | 5018 | 96 |
1677656 | 1677656 | 2021-09-02 | Kosciusko | Indiana | 18085 | 10601 | 134 |
1677657 | 1677657 | 2021-09-02 | LaGrange | Indiana | 18087 | 2925 | 75 |
1677658 | 1677658 | 2021-09-02 | LaPorte | Indiana | 18091 | 13419 | 231 |
1677659 | 1677659 | 2021-09-02 | Lake | Indiana | 18089 | 60440 | 1104 |
1677660 | 1677660 | 2021-09-02 | Lawrence | Indiana | 18093 | 6341 | 142 |
1677661 | 1677661 | 2021-09-02 | Madison | Indiana | 18095 | 15923 | 384 |
1677662 | 1677662 | 2021-09-02 | Marion | Indiana | 18097 | 118998 | 1958 |
1677663 | 1677663 | 2021-09-02 | Marshall | Indiana | 18099 | 6860 | 124 |
1677664 | 1677664 | 2021-09-02 | Martin | Indiana | 18101 | 1118 | 15 |
1677665 | 1677665 | 2021-09-02 | Miami | Indiana | 18103 | 4846 | 78 |
1677666 | 1677666 | 2021-09-02 | Monroe | Indiana | 18105 | 13654 | 190 |
1677667 | 1677667 | 2021-09-02 | Montgomery | Indiana | 18107 | 5290 | 98 |
1677668 | 1677668 | 2021-09-02 | Morgan | Indiana | 18109 | 8078 | 157 |
1677669 | 1677669 | 2021-09-02 | Newton | Indiana | 18111 | 1301 | 42 |
1677670 | 1677670 | 2021-09-02 | Noble | Indiana | 18113 | 6819 | 101 |
1677671 | 1677671 | 2021-09-02 | Ohio | Indiana | 18115 | 707 | 11 |
1677672 | 1677672 | 2021-09-02 | Orange | Indiana | 18117 | 2551 | 60 |
1677673 | 1677673 | 2021-09-02 | Owen | Indiana | 18119 | 2595 | 63 |
1677674 | 1677674 | 2021-09-02 | Parke | Indiana | 18121 | 1958 | 18 |
1677675 | 1677675 | 2021-09-02 | Perry | Indiana | 18123 | 2301 | 46 |
1677676 | 1677676 | 2021-09-02 | Pike | Indiana | 18125 | 1788 | 35 |
1677677 | 1677677 | 2021-09-02 | Porter | Indiana | 18127 | 20703 | 347 |
1677678 | 1677678 | 2021-09-02 | Posey | Indiana | 18129 | 3334 | 38 |
1677679 | 1677679 | 2021-09-02 | Pulaski | Indiana | 18131 | 1425 | 50 |
1677680 | 1677680 | 2021-09-02 | Putnam | Indiana | 18133 | 4828 | 68 |
1677681 | 1677681 | 2021-09-02 | Randolph | Indiana | 18135 | 2826 | 85 |
1677682 | 1677682 | 2021-09-02 | Ripley | Indiana | 18137 | 4040 | 72 |
1677683 | 1677683 | 2021-09-02 | Rush | Indiana | 18139 | 2061 | 27 |
1677684 | 1677684 | 2021-09-02 | Scott | Indiana | 18143 | 3600 | 63 |
1677685 | 1677685 | 2021-09-02 | Shelby | Indiana | 18145 | 6922 | 111 |
1677686 | 1677686 | 2021-09-02 | Spencer | Indiana | 18147 | 2916 | 32 |
1677687 | 1677687 | 2021-09-02 | St. Joseph | Indiana | 18141 | 39773 | 597 |
1677688 | 1677688 | 2021-09-02 | Starke | Indiana | 18149 | 2539 | 62 |
1677689 | 1677689 | 2021-09-02 | Steuben | Indiana | 18151 | 4589 | 66 |
1677690 | 1677690 | 2021-09-02 | Sullivan | Indiana | 18153 | 2699 | 47 |
1677691 | 1677691 | 2021-09-02 | Switzerland | Indiana | 18155 | 1100 | 9 |
1677692 | 1677692 | 2021-09-02 | Tippecanoe | Indiana | 18157 | 25617 | 240 |
1677693 | 1677693 | 2021-09-02 | Tipton | Indiana | 18159 | 1966 | 53 |
1677694 | 1677694 | 2021-09-02 | Union | Indiana | 18161 | 882 | 11 |
1677695 | 1677695 | 2021-09-02 | Vanderburgh | Indiana | 18163 | 27840 | 426 |
1677696 | 1677696 | 2021-09-02 | Vermillion | Indiana | 18165 | 2101 | 48 |
1677697 | 1677697 | 2021-09-02 | Vigo | Indiana | 18167 | 14497 | 268 |
1677698 | 1677698 | 2021-09-02 | Wabash | Indiana | 18169 | 4406 | 86 |
1677699 | 1677699 | 2021-09-02 | Warren | Indiana | 18171 | 1034 | 18 |
1677700 | 1677700 | 2021-09-02 | Warrick | Indiana | 18173 | 9728 | 169 |
1677701 | 1677701 | 2021-09-02 | Washington | Indiana | 18175 | 3006 | 43 |
1677702 | 1677702 | 2021-09-02 | Wayne | Indiana | 18177 | 9062 | 209 |
1677703 | 1677703 | 2021-09-02 | Wells | Indiana | 18179 | 3533 | 84 |
1677704 | 1677704 | 2021-09-02 | White | Indiana | 18181 | 3680 | 57 |
1677705 | 1677705 | 2021-09-02 | Whitley | Indiana | 18183 | 4833 | 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);