ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-11-30" 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 |
---|---|---|---|---|---|---|---|
781591 | 781591 | 2020-11-30 | Adams | Indiana | 18001 | 1801 | 24 |
781592 | 781592 | 2020-11-30 | Allen | Indiana | 18003 | 19608 | 320 |
781593 | 781593 | 2020-11-30 | Bartholomew | Indiana | 18005 | 3569 | 70 |
781594 | 781594 | 2020-11-30 | Benton | Indiana | 18007 | 394 | 3 |
781595 | 781595 | 2020-11-30 | Blackford | Indiana | 18009 | 607 | 13 |
781596 | 781596 | 2020-11-30 | Boone | Indiana | 18011 | 2695 | 58 |
781597 | 781597 | 2020-11-30 | Brown | Indiana | 18013 | 381 | 5 |
781598 | 781598 | 2020-11-30 | Carroll | Indiana | 18015 | 753 | 13 |
781599 | 781599 | 2020-11-30 | Cass | Indiana | 18017 | 3118 | 32 |
781600 | 781600 | 2020-11-30 | Clark | Indiana | 18019 | 5496 | 85 |
781601 | 781601 | 2020-11-30 | Clay | Indiana | 18021 | 1351 | 25 |
781602 | 781602 | 2020-11-30 | Clinton | Indiana | 18023 | 1933 | 26 |
781603 | 781603 | 2020-11-30 | Crawford | Indiana | 18025 | 326 | 2 |
781604 | 781604 | 2020-11-30 | Daviess | Indiana | 18027 | 1677 | 47 |
781605 | 781605 | 2020-11-30 | DeKalb | Indiana | 18033 | 1936 | 36 |
781606 | 781606 | 2020-11-30 | Dearborn | Indiana | 18029 | 2419 | 33 |
781607 | 781607 | 2020-11-30 | Decatur | Indiana | 18031 | 1442 | 47 |
781608 | 781608 | 2020-11-30 | Delaware | Indiana | 18035 | 5264 | 108 |
781609 | 781609 | 2020-11-30 | Dubois | Indiana | 18037 | 2538 | 33 |
781610 | 781610 | 2020-11-30 | Elkhart | Indiana | 18039 | 18168 | 244 |
781611 | 781611 | 2020-11-30 | Fayette | Indiana | 18041 | 1727 | 35 |
781612 | 781612 | 2020-11-30 | Floyd | Indiana | 18043 | 3388 | 81 |
781613 | 781613 | 2020-11-30 | Fountain | Indiana | 18045 | 878 | 8 |
781614 | 781614 | 2020-11-30 | Franklin | Indiana | 18047 | 786 | 28 |
781615 | 781615 | 2020-11-30 | Fulton | Indiana | 18049 | 903 | 19 |
781616 | 781616 | 2020-11-30 | Gibson | Indiana | 18051 | 2075 | 29 |
781617 | 781617 | 2020-11-30 | Grant | Indiana | 18053 | 3451 | 53 |
781618 | 781618 | 2020-11-30 | Greene | Indiana | 18055 | 1130 | 56 |
781619 | 781619 | 2020-11-30 | Hamilton | Indiana | 18057 | 14400 | 182 |
781620 | 781620 | 2020-11-30 | Hancock | Indiana | 18059 | 2961 | 60 |
781621 | 781621 | 2020-11-30 | Harrison | Indiana | 18061 | 1561 | 26 |
781622 | 781622 | 2020-11-30 | Hendricks | Indiana | 18063 | 6855 | 179 |
781623 | 781623 | 2020-11-30 | Henry | Indiana | 18065 | 2675 | 40 |
781624 | 781624 | 2020-11-30 | Howard | Indiana | 18067 | 3838 | 81 |
781625 | 781625 | 2020-11-30 | Huntington | Indiana | 18069 | 1421 | 10 |
781626 | 781626 | 2020-11-30 | Jackson | Indiana | 18071 | 2424 | 35 |
781627 | 781627 | 2020-11-30 | Jasper | Indiana | 18073 | 1593 | 14 |
781628 | 781628 | 2020-11-30 | Jay | Indiana | 18075 | 1074 | 16 |
781629 | 781629 | 2020-11-30 | Jefferson | Indiana | 18077 | 1335 | 16 |
781630 | 781630 | 2020-11-30 | Jennings | Indiana | 18079 | 991 | 16 |
781631 | 781631 | 2020-11-30 | Johnson | Indiana | 18081 | 7178 | 180 |
781632 | 781632 | 2020-11-30 | Knox | Indiana | 18083 | 1982 | 21 |
781633 | 781633 | 2020-11-30 | Kosciusko | Indiana | 18085 | 4860 | 44 |
781634 | 781634 | 2020-11-30 | LaGrange | Indiana | 18087 | 1526 | 33 |
781635 | 781635 | 2020-11-30 | LaPorte | Indiana | 18091 | 5026 | 98 |
781636 | 781636 | 2020-11-30 | Lake | Indiana | 18089 | 29244 | 488 |
781637 | 781637 | 2020-11-30 | Lawrence | Indiana | 18093 | 1915 | 51 |
781638 | 781638 | 2020-11-30 | Madison | Indiana | 18095 | 5530 | 137 |
781639 | 781639 | 2020-11-30 | Marion | Indiana | 18097 | 46309 | 925 |
781640 | 781640 | 2020-11-30 | Marshall | Indiana | 18099 | 3204 | 46 |
781641 | 781641 | 2020-11-30 | Martin | Indiana | 18101 | 387 | 6 |
781642 | 781642 | 2020-11-30 | Miami | Indiana | 18103 | 1819 | 17 |
781643 | 781643 | 2020-11-30 | Monroe | Indiana | 18105 | 5729 | 56 |
781644 | 781644 | 2020-11-30 | Montgomery | Indiana | 18107 | 1585 | 30 |
781645 | 781645 | 2020-11-30 | Morgan | Indiana | 18109 | 2379 | 47 |
781646 | 781646 | 2020-11-30 | Newton | Indiana | 18111 | 595 | 13 |
781647 | 781647 | 2020-11-30 | Noble | Indiana | 18113 | 2744 | 49 |
781648 | 781648 | 2020-11-30 | Ohio | Indiana | 18115 | 245 | 7 |
781649 | 781649 | 2020-11-30 | Orange | Indiana | 18117 | 733 | 30 |
781650 | 781650 | 2020-11-30 | Owen | Indiana | 18119 | 670 | 10 |
781651 | 781651 | 2020-11-30 | Parke | Indiana | 18121 | 660 | 6 |
781652 | 781652 | 2020-11-30 | Perry | Indiana | 18123 | 883 | 22 |
781653 | 781653 | 2020-11-30 | Pike | Indiana | 18125 | 549 | 20 |
781654 | 781654 | 2020-11-30 | Porter | Indiana | 18127 | 8919 | 93 |
781655 | 781655 | 2020-11-30 | Posey | Indiana | 18129 | 1303 | 18 |
781656 | 781656 | 2020-11-30 | Pulaski | Indiana | 18131 | 452 | 16 |
781657 | 781657 | 2020-11-30 | Putnam | Indiana | 18133 | 1388 | 29 |
781658 | 781658 | 2020-11-30 | Randolph | Indiana | 18135 | 1380 | 22 |
781659 | 781659 | 2020-11-30 | Ripley | Indiana | 18137 | 1559 | 21 |
781660 | 781660 | 2020-11-30 | Rush | Indiana | 18139 | 662 | 8 |
781661 | 781661 | 2020-11-30 | Scott | Indiana | 18143 | 1202 | 23 |
781662 | 781662 | 2020-11-30 | Shelby | Indiana | 18145 | 2702 | 68 |
781663 | 781663 | 2020-11-30 | Spencer | Indiana | 18147 | 929 | 8 |
781664 | 781664 | 2020-11-30 | St. Joseph | Indiana | 18141 | 17834 | 250 |
781665 | 781665 | 2020-11-30 | Starke | Indiana | 18149 | 982 | 26 |
781666 | 781666 | 2020-11-30 | Steuben | Indiana | 18151 | 1585 | 16 |
781667 | 781667 | 2020-11-30 | Sullivan | Indiana | 18153 | 1072 | 17 |
781668 | 781668 | 2020-11-30 | Switzerland | Indiana | 18155 | 275 | 5 |
781669 | 781669 | 2020-11-30 | Tippecanoe | Indiana | 18157 | 9484 | 31 |
781670 | 781670 | 2020-11-30 | Tipton | Indiana | 18159 | 645 | 30 |
781671 | 781671 | 2020-11-30 | Union | Indiana | 18161 | 330 | 2 |
781672 | 781672 | 2020-11-30 | Vanderburgh | Indiana | 18163 | 10551 | 129 |
781673 | 781673 | 2020-11-30 | Vermillion | Indiana | 18165 | 693 | 7 |
781674 | 781674 | 2020-11-30 | Vigo | Indiana | 18167 | 6442 | 94 |
781675 | 781675 | 2020-11-30 | Wabash | Indiana | 18169 | 1845 | 22 |
781676 | 781676 | 2020-11-30 | Warren | Indiana | 18171 | 268 | 4 |
781677 | 781677 | 2020-11-30 | Warrick | Indiana | 18173 | 3502 | 75 |
781678 | 781678 | 2020-11-30 | Washington | Indiana | 18175 | 848 | 7 |
781679 | 781679 | 2020-11-30 | Wayne | Indiana | 18177 | 3854 | 88 |
781680 | 781680 | 2020-11-30 | Wells | Indiana | 18179 | 1394 | 32 |
781681 | 781681 | 2020-11-30 | White | Indiana | 18181 | 1403 | 23 |
781682 | 781682 | 2020-11-30 | Whitley | Indiana | 18183 | 1497 | 15 |
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);