ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where "date" is on date 2020-04-02 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26668 | 26668 | 2020-04-02 | Adams | Indiana | 18001 | 1 | 0 |
26669 | 26669 | 2020-04-02 | Allen | Indiana | 18003 | 47 | 3 |
26670 | 26670 | 2020-04-02 | Bartholomew | Indiana | 18005 | 15 | 0 |
26671 | 26671 | 2020-04-02 | Blackford | Indiana | 18009 | 1 | 0 |
26672 | 26672 | 2020-04-02 | Boone | Indiana | 18011 | 32 | 0 |
26673 | 26673 | 2020-04-02 | Brown | Indiana | 18013 | 3 | 0 |
26674 | 26674 | 2020-04-02 | Carroll | Indiana | 18015 | 2 | 0 |
26675 | 26675 | 2020-04-02 | Cass | Indiana | 18017 | 2 | 0 |
26676 | 26676 | 2020-04-02 | Clark | Indiana | 18019 | 49 | 1 |
26677 | 26677 | 2020-04-02 | Clay | Indiana | 18021 | 1 | 0 |
26678 | 26678 | 2020-04-02 | Clinton | Indiana | 18023 | 1 | 0 |
26679 | 26679 | 2020-04-02 | Crawford | Indiana | 18025 | 1 | 0 |
26680 | 26680 | 2020-04-02 | DeKalb | Indiana | 18033 | 2 | 0 |
26681 | 26681 | 2020-04-02 | Dearborn | Indiana | 18029 | 22 | 1 |
26682 | 26682 | 2020-04-02 | Decatur | Indiana | 18031 | 60 | 4 |
26683 | 26683 | 2020-04-02 | Delaware | Indiana | 18035 | 25 | 1 |
26684 | 26684 | 2020-04-02 | Dubois | Indiana | 18037 | 3 | 0 |
26685 | 26685 | 2020-04-02 | Elkhart | Indiana | 18039 | 27 | 3 |
26686 | 26686 | 2020-04-02 | Fayette | Indiana | 18041 | 11 | 2 |
26687 | 26687 | 2020-04-02 | Floyd | Indiana | 18043 | 34 | 0 |
26688 | 26688 | 2020-04-02 | Fountain | Indiana | 18045 | 2 | 1 |
26689 | 26689 | 2020-04-02 | Franklin | Indiana | 18047 | 45 | 6 |
26690 | 26690 | 2020-04-02 | Fulton | Indiana | 18049 | 1 | 0 |
26691 | 26691 | 2020-04-02 | Gibson | Indiana | 18051 | 4 | 0 |
26692 | 26692 | 2020-04-02 | Grant | Indiana | 18053 | 11 | 0 |
26693 | 26693 | 2020-04-02 | Greene | Indiana | 18055 | 8 | 0 |
26694 | 26694 | 2020-04-02 | Hamilton | Indiana | 18057 | 207 | 4 |
26695 | 26695 | 2020-04-02 | Hancock | Indiana | 18059 | 37 | 2 |
26696 | 26696 | 2020-04-02 | Harrison | Indiana | 18061 | 18 | 0 |
26697 | 26697 | 2020-04-02 | Hendricks | Indiana | 18063 | 116 | 1 |
26698 | 26698 | 2020-04-02 | Henry | Indiana | 18065 | 6 | 0 |
26699 | 26699 | 2020-04-02 | Howard | Indiana | 18067 | 25 | 3 |
26700 | 26700 | 2020-04-02 | Huntington | Indiana | 18069 | 3 | 1 |
26701 | 26701 | 2020-04-02 | Jackson | Indiana | 18071 | 19 | 0 |
26702 | 26702 | 2020-04-02 | Jasper | Indiana | 18073 | 11 | 1 |
26703 | 26703 | 2020-04-02 | Jay | Indiana | 18075 | 1 | 0 |
26704 | 26704 | 2020-04-02 | Jefferson | Indiana | 18077 | 3 | 0 |
26705 | 26705 | 2020-04-02 | Jennings | Indiana | 18079 | 24 | 1 |
26706 | 26706 | 2020-04-02 | Johnson | Indiana | 18081 | 126 | 3 |
26707 | 26707 | 2020-04-02 | Knox | Indiana | 18083 | 4 | 0 |
26708 | 26708 | 2020-04-02 | Kosciusko | Indiana | 18085 | 5 | 0 |
26709 | 26709 | 2020-04-02 | LaGrange | Indiana | 18087 | 2 | 0 |
26710 | 26710 | 2020-04-02 | LaPorte | Indiana | 18091 | 14 | 1 |
26711 | 26711 | 2020-04-02 | Lake | Indiana | 18089 | 216 | 7 |
26712 | 26712 | 2020-04-02 | Lawrence | Indiana | 18093 | 13 | 2 |
26713 | 26713 | 2020-04-02 | Madison | Indiana | 18095 | 66 | 7 |
26714 | 26714 | 2020-04-02 | Marion | Indiana | 18097 | 1306 | 26 |
26715 | 26715 | 2020-04-02 | Marshall | Indiana | 18099 | 4 | 0 |
26716 | 26716 | 2020-04-02 | Miami | Indiana | 18103 | 4 | 0 |
26717 | 26717 | 2020-04-02 | Monroe | Indiana | 18105 | 36 | 0 |
26718 | 26718 | 2020-04-02 | Montgomery | Indiana | 18107 | 10 | 0 |
26719 | 26719 | 2020-04-02 | Morgan | Indiana | 18109 | 48 | 1 |
26720 | 26720 | 2020-04-02 | Newton | Indiana | 18111 | 1 | 0 |
26721 | 26721 | 2020-04-02 | Noble | Indiana | 18113 | 3 | 0 |
26722 | 26722 | 2020-04-02 | Ohio | Indiana | 18115 | 1 | 0 |
26723 | 26723 | 2020-04-02 | Orange | Indiana | 18117 | 3 | 0 |
26724 | 26724 | 2020-04-02 | Owen | Indiana | 18119 | 12 | 0 |
26725 | 26725 | 2020-04-02 | Porter | Indiana | 18127 | 35 | 0 |
26726 | 26726 | 2020-04-02 | Posey | Indiana | 18129 | 4 | 0 |
26727 | 26727 | 2020-04-02 | Putnam | Indiana | 18133 | 11 | 1 |
26728 | 26728 | 2020-04-02 | Randolph | Indiana | 18135 | 3 | 0 |
26729 | 26729 | 2020-04-02 | Ripley | Indiana | 18137 | 39 | 1 |
26730 | 26730 | 2020-04-02 | Rush | Indiana | 18139 | 7 | 0 |
26731 | 26731 | 2020-04-02 | Scott | Indiana | 18143 | 5 | 1 |
26732 | 26732 | 2020-04-02 | Shelby | Indiana | 18145 | 24 | 0 |
26733 | 26733 | 2020-04-02 | Spencer | Indiana | 18147 | 1 | 0 |
26734 | 26734 | 2020-04-02 | St. Joseph | Indiana | 18141 | 68 | 4 |
26735 | 26735 | 2020-04-02 | Starke | Indiana | 18149 | 2 | 0 |
26736 | 26736 | 2020-04-02 | Steuben | Indiana | 18151 | 2 | 0 |
26737 | 26737 | 2020-04-02 | Sullivan | Indiana | 18153 | 3 | 0 |
26738 | 26738 | 2020-04-02 | Switzerland | Indiana | 18155 | 4 | 0 |
26739 | 26739 | 2020-04-02 | Tippecanoe | Indiana | 18157 | 19 | 1 |
26740 | 26740 | 2020-04-02 | Tipton | Indiana | 18159 | 5 | 0 |
26741 | 26741 | 2020-04-02 | Unknown | Indiana | 1 | 0 | |
26742 | 26742 | 2020-04-02 | Vanderburgh | Indiana | 18163 | 23 | 0 |
26743 | 26743 | 2020-04-02 | Vermillion | Indiana | 18165 | 1 | 0 |
26744 | 26744 | 2020-04-02 | Vigo | Indiana | 18167 | 11 | 3 |
26745 | 26745 | 2020-04-02 | Wabash | Indiana | 18169 | 1 | 0 |
26746 | 26746 | 2020-04-02 | Warren | Indiana | 18171 | 2 | 1 |
26747 | 26747 | 2020-04-02 | Warrick | Indiana | 18173 | 8 | 0 |
26748 | 26748 | 2020-04-02 | Washington | Indiana | 18175 | 12 | 0 |
26749 | 26749 | 2020-04-02 | Wayne | Indiana | 18177 | 3 | 0 |
26750 | 26750 | 2020-04-02 | Wells | Indiana | 18179 | 2 | 0 |
26751 | 26751 | 2020-04-02 | White | Indiana | 18181 | 3 | 0 |
26752 | 26752 | 2020-04-02 | Whitley | Indiana | 18183 | 3 | 0 |
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);