ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-09-10" 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 |
---|---|---|---|---|---|---|---|
1703609 | 1703609 | 2021-09-10 | Adams | Indiana | 18001 | 4340 | 66 |
1703610 | 1703610 | 2021-09-10 | Allen | Indiana | 18003 | 51279 | 761 |
1703611 | 1703611 | 2021-09-10 | Bartholomew | Indiana | 18005 | 9985 | 168 |
1703612 | 1703612 | 2021-09-10 | Benton | Indiana | 18007 | 1367 | 15 |
1703613 | 1703613 | 2021-09-10 | Blackford | Indiana | 18009 | 1601 | 34 |
1703614 | 1703614 | 2021-09-10 | Boone | Indiana | 18011 | 8089 | 115 |
1703615 | 1703615 | 2021-09-10 | Brown | Indiana | 18013 | 1283 | 45 |
1703616 | 1703616 | 2021-09-10 | Carroll | Indiana | 18015 | 2340 | 27 |
1703617 | 1703617 | 2021-09-10 | Cass | Indiana | 18017 | 6932 | 119 |
1703618 | 1703618 | 2021-09-10 | Clark | Indiana | 18019 | 16693 | 224 |
1703619 | 1703619 | 2021-09-10 | Clay | Indiana | 18021 | 3627 | 54 |
1703620 | 1703620 | 2021-09-10 | Clinton | Indiana | 18023 | 5155 | 67 |
1703621 | 1703621 | 2021-09-10 | Crawford | Indiana | 18025 | 1394 | 19 |
1703622 | 1703622 | 2021-09-10 | Daviess | Indiana | 18027 | 3875 | 104 |
1703623 | 1703623 | 2021-09-10 | DeKalb | Indiana | 18033 | 5456 | 94 |
1703624 | 1703624 | 2021-09-10 | Dearborn | Indiana | 18029 | 7164 | 89 |
1703625 | 1703625 | 2021-09-10 | Decatur | Indiana | 18031 | 3713 | 99 |
1703626 | 1703626 | 2021-09-10 | Delaware | Indiana | 18035 | 13248 | 220 |
1703627 | 1703627 | 2021-09-10 | Dubois | Indiana | 18037 | 7359 | 123 |
1703628 | 1703628 | 2021-09-10 | Elkhart | Indiana | 18039 | 32364 | 497 |
1703629 | 1703629 | 2021-09-10 | Fayette | Indiana | 18041 | 3665 | 72 |
1703630 | 1703630 | 2021-09-10 | Floyd | Indiana | 18043 | 9901 | 204 |
1703631 | 1703631 | 2021-09-10 | Fountain | Indiana | 18045 | 2989 | 55 |
1703632 | 1703632 | 2021-09-10 | Franklin | Indiana | 18047 | 2223 | 37 |
1703633 | 1703633 | 2021-09-10 | Fulton | Indiana | 18049 | 2572 | 50 |
1703634 | 1703634 | 2021-09-10 | Gibson | Indiana | 18051 | 5901 | 106 |
1703635 | 1703635 | 2021-09-10 | Grant | Indiana | 18053 | 9031 | 200 |
1703636 | 1703636 | 2021-09-10 | Greene | Indiana | 18055 | 3640 | 90 |
1703637 | 1703637 | 2021-09-10 | Hamilton | Indiana | 18057 | 42308 | 459 |
1703638 | 1703638 | 2021-09-10 | Hancock | Indiana | 18059 | 10344 | 159 |
1703639 | 1703639 | 2021-09-10 | Harrison | Indiana | 18061 | 5765 | 86 |
1703640 | 1703640 | 2021-09-10 | Hendricks | Indiana | 18063 | 21291 | 355 |
1703641 | 1703641 | 2021-09-10 | Henry | Indiana | 18065 | 7239 | 125 |
1703642 | 1703642 | 2021-09-10 | Howard | Indiana | 18067 | 13207 | 259 |
1703643 | 1703643 | 2021-09-10 | Huntington | Indiana | 18069 | 5768 | 91 |
1703644 | 1703644 | 2021-09-10 | Jackson | Indiana | 18071 | 6262 | 80 |
1703645 | 1703645 | 2021-09-10 | Jasper | Indiana | 18073 | 4533 | 63 |
1703646 | 1703646 | 2021-09-10 | Jay | Indiana | 18075 | 2440 | 37 |
1703647 | 1703647 | 2021-09-10 | Jefferson | Indiana | 18077 | 4442 | 91 |
1703648 | 1703648 | 2021-09-10 | Jennings | Indiana | 18079 | 3290 | 54 |
1703649 | 1703649 | 2021-09-10 | Johnson | Indiana | 18081 | 22764 | 428 |
1703650 | 1703650 | 2021-09-10 | Knox | Indiana | 18083 | 5236 | 97 |
1703651 | 1703651 | 2021-09-10 | Kosciusko | Indiana | 18085 | 10949 | 139 |
1703652 | 1703652 | 2021-09-10 | LaGrange | Indiana | 18087 | 3047 | 76 |
1703653 | 1703653 | 2021-09-10 | LaPorte | Indiana | 18091 | 13741 | 236 |
1703654 | 1703654 | 2021-09-10 | Lake | Indiana | 18089 | 61690 | 1113 |
1703655 | 1703655 | 2021-09-10 | Lawrence | Indiana | 18093 | 6654 | 149 |
1703656 | 1703656 | 2021-09-10 | Madison | Indiana | 18095 | 16523 | 391 |
1703657 | 1703657 | 2021-09-10 | Marion | Indiana | 18097 | 123078 | 1989 |
1703658 | 1703658 | 2021-09-10 | Marshall | Indiana | 18099 | 7054 | 127 |
1703659 | 1703659 | 2021-09-10 | Martin | Indiana | 18101 | 1200 | 15 |
1703660 | 1703660 | 2021-09-10 | Miami | Indiana | 18103 | 5082 | 82 |
1703661 | 1703661 | 2021-09-10 | Monroe | Indiana | 18105 | 13984 | 191 |
1703662 | 1703662 | 2021-09-10 | Montgomery | Indiana | 18107 | 5516 | 102 |
1703663 | 1703663 | 2021-09-10 | Morgan | Indiana | 18109 | 8461 | 160 |
1703664 | 1703664 | 2021-09-10 | Newton | Indiana | 18111 | 1349 | 43 |
1703665 | 1703665 | 2021-09-10 | Noble | Indiana | 18113 | 7059 | 102 |
1703666 | 1703666 | 2021-09-10 | Ohio | Indiana | 18115 | 738 | 11 |
1703667 | 1703667 | 2021-09-10 | Orange | Indiana | 18117 | 2665 | 61 |
1703668 | 1703668 | 2021-09-10 | Owen | Indiana | 18119 | 2710 | 63 |
1703669 | 1703669 | 2021-09-10 | Parke | Indiana | 18121 | 2080 | 18 |
1703670 | 1703670 | 2021-09-10 | Perry | Indiana | 18123 | 2384 | 50 |
1703671 | 1703671 | 2021-09-10 | Pike | Indiana | 18125 | 1929 | 36 |
1703672 | 1703672 | 2021-09-10 | Porter | Indiana | 18127 | 21061 | 348 |
1703673 | 1703673 | 2021-09-10 | Posey | Indiana | 18129 | 3453 | 38 |
1703674 | 1703674 | 2021-09-10 | Pulaski | Indiana | 18131 | 1498 | 50 |
1703675 | 1703675 | 2021-09-10 | Putnam | Indiana | 18133 | 5087 | 68 |
1703676 | 1703676 | 2021-09-10 | Randolph | Indiana | 18135 | 2956 | 86 |
1703677 | 1703677 | 2021-09-10 | Ripley | Indiana | 18137 | 4257 | 75 |
1703678 | 1703678 | 2021-09-10 | Rush | Indiana | 18139 | 2219 | 28 |
1703679 | 1703679 | 2021-09-10 | Scott | Indiana | 18143 | 3805 | 65 |
1703680 | 1703680 | 2021-09-10 | Shelby | Indiana | 18145 | 7206 | 116 |
1703681 | 1703681 | 2021-09-10 | Spencer | Indiana | 18147 | 3058 | 33 |
1703682 | 1703682 | 2021-09-10 | St. Joseph | Indiana | 18141 | 40632 | 600 |
1703683 | 1703683 | 2021-09-10 | Starke | Indiana | 18149 | 2621 | 62 |
1703684 | 1703684 | 2021-09-10 | Steuben | Indiana | 18151 | 4732 | 66 |
1703685 | 1703685 | 2021-09-10 | Sullivan | Indiana | 18153 | 2872 | 47 |
1703686 | 1703686 | 2021-09-10 | Switzerland | Indiana | 18155 | 1177 | 9 |
1703687 | 1703687 | 2021-09-10 | Tippecanoe | Indiana | 18157 | 26160 | 245 |
1703688 | 1703688 | 2021-09-10 | Tipton | Indiana | 18159 | 2024 | 55 |
1703689 | 1703689 | 2021-09-10 | Union | Indiana | 18161 | 921 | 11 |
1703690 | 1703690 | 2021-09-10 | Vanderburgh | Indiana | 18163 | 29032 | 433 |
1703691 | 1703691 | 2021-09-10 | Vermillion | Indiana | 18165 | 2194 | 50 |
1703692 | 1703692 | 2021-09-10 | Vigo | Indiana | 18167 | 15148 | 272 |
1703693 | 1703693 | 2021-09-10 | Wabash | Indiana | 18169 | 4628 | 89 |
1703694 | 1703694 | 2021-09-10 | Warren | Indiana | 18171 | 1086 | 18 |
1703695 | 1703695 | 2021-09-10 | Warrick | Indiana | 18173 | 10192 | 176 |
1703696 | 1703696 | 2021-09-10 | Washington | Indiana | 18175 | 3161 | 44 |
1703697 | 1703697 | 2021-09-10 | Wayne | Indiana | 18177 | 9610 | 216 |
1703698 | 1703698 | 2021-09-10 | Wells | Indiana | 18179 | 3688 | 85 |
1703699 | 1703699 | 2021-09-10 | White | Indiana | 18181 | 3770 | 58 |
1703700 | 1703700 | 2021-09-10 | Whitley | Indiana | 18183 | 5003 | 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);