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 2022-01-24 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2145618 | 2145618 | 2022-01-24 | Adams | Indiana | 18001 | 6902 | 104 |
2145619 | 2145619 | 2022-01-24 | Allen | Indiana | 18003 | 96546 | 1058 |
2145620 | 2145620 | 2022-01-24 | Bartholomew | Indiana | 18005 | 19007 | 223 |
2145621 | 2145621 | 2022-01-24 | Benton | Indiana | 18007 | 2289 | 21 |
2145622 | 2145622 | 2022-01-24 | Blackford | Indiana | 18009 | 2837 | 59 |
2145623 | 2145623 | 2022-01-24 | Boone | Indiana | 18011 | 13947 | 146 |
2145624 | 2145624 | 2022-01-24 | Brown | Indiana | 18013 | 2400 | 58 |
2145625 | 2145625 | 2022-01-24 | Carroll | Indiana | 18015 | 3952 | 53 |
2145626 | 2145626 | 2022-01-24 | Cass | Indiana | 18017 | 10589 | 148 |
2145627 | 2145627 | 2022-01-24 | Clark | Indiana | 18019 | 27325 | 348 |
2145628 | 2145628 | 2022-01-24 | Clay | Indiana | 18021 | 6291 | 77 |
2145629 | 2145629 | 2022-01-24 | Clinton | Indiana | 18023 | 8501 | 104 |
2145630 | 2145630 | 2022-01-24 | Crawford | Indiana | 18025 | 2251 | 33 |
2145631 | 2145631 | 2022-01-24 | Daviess | Indiana | 18027 | 6827 | 132 |
2145632 | 2145632 | 2022-01-24 | DeKalb | Indiana | 18033 | 10486 | 135 |
2145633 | 2145633 | 2022-01-24 | Dearborn | Indiana | 18029 | 12249 | 121 |
2145634 | 2145634 | 2022-01-24 | Decatur | Indiana | 18031 | 6326 | 130 |
2145635 | 2145635 | 2022-01-24 | Delaware | Indiana | 18035 | 22479 | 388 |
2145636 | 2145636 | 2022-01-24 | Dubois | Indiana | 18037 | 11699 | 154 |
2145637 | 2145637 | 2022-01-24 | Elkhart | Indiana | 18039 | 51165 | 668 |
2145638 | 2145638 | 2022-01-24 | Fayette | Indiana | 18041 | 6197 | 128 |
2145639 | 2145639 | 2022-01-24 | Floyd | Indiana | 18043 | 16702 | 268 |
2145640 | 2145640 | 2022-01-24 | Fountain | Indiana | 18045 | 4943 | 85 |
2145641 | 2145641 | 2022-01-24 | Franklin | Indiana | 18047 | 3970 | 56 |
2145642 | 2145642 | 2022-01-24 | Fulton | Indiana | 18049 | 4512 | 95 |
2145643 | 2145643 | 2022-01-24 | Gibson | Indiana | 18051 | 10120 | 132 |
2145644 | 2145644 | 2022-01-24 | Grant | Indiana | 18053 | 16377 | 311 |
2145645 | 2145645 | 2022-01-24 | Greene | Indiana | 18055 | 6327 | 117 |
2145646 | 2145646 | 2022-01-24 | Hamilton | Indiana | 18057 | 75602 | 584 |
2145647 | 2145647 | 2022-01-24 | Hancock | Indiana | 18059 | 19345 | 227 |
2145648 | 2145648 | 2022-01-24 | Harrison | Indiana | 18061 | 9478 | 122 |
2145649 | 2145649 | 2022-01-24 | Hendricks | Indiana | 18063 | 38004 | 488 |
2145650 | 2145650 | 2022-01-24 | Henry | Indiana | 18065 | 12045 | 207 |
2145651 | 2145651 | 2022-01-24 | Howard | Indiana | 18067 | 23258 | 391 |
2145652 | 2145652 | 2022-01-24 | Huntington | Indiana | 18069 | 10530 | 144 |
2145653 | 2145653 | 2022-01-24 | Jackson | Indiana | 18071 | 11117 | 107 |
2145654 | 2145654 | 2022-01-24 | Jasper | Indiana | 18073 | 8471 | 122 |
2145655 | 2145655 | 2022-01-24 | Jay | Indiana | 18075 | 4341 | 71 |
2145656 | 2145656 | 2022-01-24 | Jefferson | Indiana | 18077 | 8324 | 132 |
2145657 | 2145657 | 2022-01-24 | Jennings | Indiana | 18079 | 6206 | 88 |
2145658 | 2145658 | 2022-01-24 | Johnson | Indiana | 18081 | 39681 | 553 |
2145659 | 2145659 | 2022-01-24 | Knox | Indiana | 18083 | 9420 | 128 |
2145660 | 2145660 | 2022-01-24 | Kosciusko | Indiana | 18085 | 18420 | 209 |
2145661 | 2145661 | 2022-01-24 | LaGrange | Indiana | 18087 | 5496 | 99 |
2145662 | 2145662 | 2022-01-24 | LaPorte | Indiana | 18091 | 23934 | 317 |
2145663 | 2145663 | 2022-01-24 | Lake | Indiana | 18089 | 102241 | 1589 |
2145664 | 2145664 | 2022-01-24 | Lawrence | Indiana | 18093 | 10533 | 225 |
2145665 | 2145665 | 2022-01-24 | Madison | Indiana | 18095 | 30368 | 575 |
2145666 | 2145666 | 2022-01-24 | Marion | Indiana | 18097 | 212050 | 2655 |
2145667 | 2145667 | 2022-01-24 | Marshall | Indiana | 18099 | 11637 | 181 |
2145668 | 2145668 | 2022-01-24 | Martin | Indiana | 18101 | 1969 | 23 |
2145669 | 2145669 | 2022-01-24 | Miami | Indiana | 18103 | 8542 | 139 |
2145670 | 2145670 | 2022-01-24 | Monroe | Indiana | 18105 | 24106 | 254 |
2145671 | 2145671 | 2022-01-24 | Montgomery | Indiana | 18107 | 9675 | 146 |
2145672 | 2145672 | 2022-01-24 | Morgan | Indiana | 18109 | 15118 | 248 |
2145673 | 2145673 | 2022-01-24 | Newton | Indiana | 18111 | 2399 | 63 |
2145674 | 2145674 | 2022-01-24 | Noble | Indiana | 18113 | 12175 | 146 |
2145675 | 2145675 | 2022-01-24 | Ohio | Indiana | 18115 | 1292 | 16 |
2145676 | 2145676 | 2022-01-24 | Orange | Indiana | 18117 | 4503 | 89 |
2145677 | 2145677 | 2022-01-24 | Owen | Indiana | 18119 | 5215 | 103 |
2145678 | 2145678 | 2022-01-24 | Parke | Indiana | 18121 | 3328 | 41 |
2145679 | 2145679 | 2022-01-24 | Perry | Indiana | 18123 | 4106 | 61 |
2145680 | 2145680 | 2022-01-24 | Pike | Indiana | 18125 | 3343 | 47 |
2145681 | 2145681 | 2022-01-24 | Porter | Indiana | 18127 | 35161 | 495 |
2145682 | 2145682 | 2022-01-24 | Posey | Indiana | 18129 | 5801 | 48 |
2145683 | 2145683 | 2022-01-24 | Pulaski | Indiana | 18131 | 2820 | 76 |
2145684 | 2145684 | 2022-01-24 | Putnam | Indiana | 18133 | 8556 | 104 |
2145685 | 2145685 | 2022-01-24 | Randolph | Indiana | 18135 | 5406 | 131 |
2145686 | 2145686 | 2022-01-24 | Ripley | Indiana | 18137 | 7509 | 120 |
2145687 | 2145687 | 2022-01-24 | Rush | Indiana | 18139 | 4411 | 41 |
2145688 | 2145688 | 2022-01-24 | Scott | Indiana | 18143 | 6866 | 91 |
2145689 | 2145689 | 2022-01-24 | Shelby | Indiana | 18145 | 13312 | 166 |
2145690 | 2145690 | 2022-01-24 | Spencer | Indiana | 18147 | 4678 | 58 |
2145691 | 2145691 | 2022-01-24 | St. Joseph | Indiana | 18141 | 66520 | 786 |
2145692 | 2145692 | 2022-01-24 | Starke | Indiana | 18149 | 4492 | 90 |
2145693 | 2145693 | 2022-01-24 | Steuben | Indiana | 18151 | 8942 | 108 |
2145694 | 2145694 | 2022-01-24 | Sullivan | Indiana | 18153 | 4627 | 68 |
2145695 | 2145695 | 2022-01-24 | Switzerland | Indiana | 18155 | 2080 | 14 |
2145696 | 2145696 | 2022-01-24 | Tippecanoe | Indiana | 18157 | 45733 | 343 |
2145697 | 2145697 | 2022-01-24 | Tipton | Indiana | 18159 | 3311 | 79 |
2145698 | 2145698 | 2022-01-24 | Union | Indiana | 18161 | 1810 | 20 |
2145699 | 2145699 | 2022-01-24 | Vanderburgh | Indiana | 18163 | 50533 | 548 |
2145700 | 2145700 | 2022-01-24 | Vermillion | Indiana | 18165 | 3708 | 62 |
2145701 | 2145701 | 2022-01-24 | Vigo | Indiana | 18167 | 26414 | 353 |
2145702 | 2145702 | 2022-01-24 | Wabash | Indiana | 18169 | 8032 | 141 |
2145703 | 2145703 | 2022-01-24 | Warren | Indiana | 18171 | 1842 | 24 |
2145704 | 2145704 | 2022-01-24 | Warrick | Indiana | 18173 | 17738 | 221 |
2145705 | 2145705 | 2022-01-24 | Washington | Indiana | 18175 | 5281 | 72 |
2145706 | 2145706 | 2022-01-24 | Wayne | Indiana | 18177 | 17359 | 310 |
2145707 | 2145707 | 2022-01-24 | Wells | Indiana | 18179 | 6119 | 126 |
2145708 | 2145708 | 2022-01-24 | White | Indiana | 18181 | 6383 | 86 |
2145709 | 2145709 | 2022-01-24 | Whitley | Indiana | 18183 | 9027 | 73 |
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);