ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-07-16" 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 |
---|---|---|---|---|---|---|---|
338529 | 338529 | 2020-07-16 | Adams | Indiana | 18001 | 54 | 2 |
338530 | 338530 | 2020-07-16 | Allen | Indiana | 18003 | 3055 | 148 |
338531 | 338531 | 2020-07-16 | Bartholomew | Indiana | 18005 | 618 | 48 |
338532 | 338532 | 2020-07-16 | Benton | Indiana | 18007 | 51 | 0 |
338533 | 338533 | 2020-07-16 | Blackford | Indiana | 18009 | 47 | 2 |
338534 | 338534 | 2020-07-16 | Boone | Indiana | 18011 | 524 | 47 |
338535 | 338535 | 2020-07-16 | Brown | Indiana | 18013 | 47 | 1 |
338536 | 338536 | 2020-07-16 | Carroll | Indiana | 18015 | 116 | 2 |
338537 | 338537 | 2020-07-16 | Cass | Indiana | 18017 | 1659 | 10 |
338538 | 338538 | 2020-07-16 | Clark | Indiana | 18019 | 759 | 51 |
338539 | 338539 | 2020-07-16 | Clay | Indiana | 18021 | 69 | 5 |
338540 | 338540 | 2020-07-16 | Clinton | Indiana | 18023 | 299 | 4 |
338541 | 338541 | 2020-07-16 | Crawford | Indiana | 18025 | 37 | 1 |
338542 | 338542 | 2020-07-16 | Daviess | Indiana | 18027 | 158 | 19 |
338543 | 338543 | 2020-07-16 | DeKalb | Indiana | 18033 | 173 | 5 |
338544 | 338544 | 2020-07-16 | Dearborn | Indiana | 18029 | 298 | 26 |
338545 | 338545 | 2020-07-16 | Decatur | Indiana | 18031 | 277 | 35 |
338546 | 338546 | 2020-07-16 | Delaware | Indiana | 18035 | 494 | 53 |
338547 | 338547 | 2020-07-16 | Dubois | Indiana | 18037 | 370 | 7 |
338548 | 338548 | 2020-07-16 | Elkhart | Indiana | 18039 | 3920 | 66 |
338549 | 338549 | 2020-07-16 | Fayette | Indiana | 18041 | 167 | 7 |
338550 | 338550 | 2020-07-16 | Floyd | Indiana | 18043 | 444 | 46 |
338551 | 338551 | 2020-07-16 | Fountain | Indiana | 18045 | 41 | 2 |
338552 | 338552 | 2020-07-16 | Franklin | Indiana | 18047 | 140 | 9 |
338553 | 338553 | 2020-07-16 | Fulton | Indiana | 18049 | 83 | 1 |
338554 | 338554 | 2020-07-16 | Gibson | Indiana | 18051 | 142 | 2 |
338555 | 338555 | 2020-07-16 | Grant | Indiana | 18053 | 512 | 30 |
338556 | 338556 | 2020-07-16 | Greene | Indiana | 18055 | 207 | 36 |
338557 | 338557 | 2020-07-16 | Hamilton | Indiana | 18057 | 1851 | 107 |
338558 | 338558 | 2020-07-16 | Hancock | Indiana | 18059 | 485 | 37 |
338559 | 338559 | 2020-07-16 | Harrison | Indiana | 18061 | 224 | 24 |
338560 | 338560 | 2020-07-16 | Hendricks | Indiana | 18063 | 1525 | 118 |
338561 | 338561 | 2020-07-16 | Henry | Indiana | 18065 | 315 | 18 |
338562 | 338562 | 2020-07-16 | Howard | Indiana | 18067 | 641 | 61 |
338563 | 338563 | 2020-07-16 | Huntington | Indiana | 18069 | 99 | 2 |
338564 | 338564 | 2020-07-16 | Jackson | Indiana | 18071 | 490 | 4 |
338565 | 338565 | 2020-07-16 | Jasper | Indiana | 18073 | 145 | 2 |
338566 | 338566 | 2020-07-16 | Jay | Indiana | 18075 | 77 | 0 |
338567 | 338567 | 2020-07-16 | Jefferson | Indiana | 18077 | 112 | 2 |
338568 | 338568 | 2020-07-16 | Jennings | Indiana | 18079 | 184 | 14 |
338569 | 338569 | 2020-07-16 | Johnson | Indiana | 18081 | 1425 | 126 |
338570 | 338570 | 2020-07-16 | Knox | Indiana | 18083 | 79 | 0 |
338571 | 338571 | 2020-07-16 | Kosciusko | Indiana | 18085 | 610 | 6 |
338572 | 338572 | 2020-07-16 | LaGrange | Indiana | 18087 | 496 | 10 |
338573 | 338573 | 2020-07-16 | LaPorte | Indiana | 18091 | 660 | 28 |
338574 | 338574 | 2020-07-16 | Lake | Indiana | 18089 | 5958 | 268 |
338575 | 338575 | 2020-07-16 | Lawrence | Indiana | 18093 | 260 | 26 |
338576 | 338576 | 2020-07-16 | Madison | Indiana | 18095 | 712 | 74 |
338577 | 338577 | 2020-07-16 | Marion | Indiana | 18097 | 12494 | 747 |
338578 | 338578 | 2020-07-16 | Marshall | Indiana | 18099 | 623 | 12 |
338579 | 338579 | 2020-07-16 | Martin | Indiana | 18101 | 30 | 0 |
338580 | 338580 | 2020-07-16 | Miami | Indiana | 18103 | 206 | 2 |
338581 | 338581 | 2020-07-16 | Monroe | Indiana | 18105 | 402 | 30 |
338582 | 338582 | 2020-07-16 | Montgomery | Indiana | 18107 | 305 | 21 |
338583 | 338583 | 2020-07-16 | Morgan | Indiana | 18109 | 364 | 34 |
338584 | 338584 | 2020-07-16 | Newton | Indiana | 18111 | 102 | 11 |
338585 | 338585 | 2020-07-16 | Noble | Indiana | 18113 | 540 | 29 |
338586 | 338586 | 2020-07-16 | Ohio | Indiana | 18115 | 26 | 0 |
338587 | 338587 | 2020-07-16 | Orange | Indiana | 18117 | 144 | 26 |
338588 | 338588 | 2020-07-16 | Owen | Indiana | 18119 | 54 | 1 |
338589 | 338589 | 2020-07-16 | Parke | Indiana | 18121 | 33 | 0 |
338590 | 338590 | 2020-07-16 | Perry | Indiana | 18123 | 164 | 12 |
338591 | 338591 | 2020-07-16 | Pike | Indiana | 18125 | 16 | 0 |
338592 | 338592 | 2020-07-16 | Porter | Indiana | 18127 | 894 | 40 |
338593 | 338593 | 2020-07-16 | Posey | Indiana | 18129 | 82 | 0 |
338594 | 338594 | 2020-07-16 | Pulaski | Indiana | 18131 | 68 | 1 |
338595 | 338595 | 2020-07-16 | Putnam | Indiana | 18133 | 185 | 8 |
338596 | 338596 | 2020-07-16 | Randolph | Indiana | 18135 | 108 | 4 |
338597 | 338597 | 2020-07-16 | Ripley | Indiana | 18137 | 145 | 7 |
338598 | 338598 | 2020-07-16 | Rush | Indiana | 18139 | 91 | 3 |
338599 | 338599 | 2020-07-16 | Scott | Indiana | 18143 | 178 | 10 |
338600 | 338600 | 2020-07-16 | Shelby | Indiana | 18145 | 719 | 32 |
338601 | 338601 | 2020-07-16 | Spencer | Indiana | 18147 | 82 | 1 |
338602 | 338602 | 2020-07-16 | St. Joseph | Indiana | 18141 | 2332 | 76 |
338603 | 338603 | 2020-07-16 | Starke | Indiana | 18149 | 129 | 5 |
338604 | 338604 | 2020-07-16 | Steuben | Indiana | 18151 | 144 | 3 |
338605 | 338605 | 2020-07-16 | Sullivan | Indiana | 18153 | 64 | 1 |
338606 | 338606 | 2020-07-16 | Switzerland | Indiana | 18155 | 35 | 0 |
338607 | 338607 | 2020-07-16 | Tippecanoe | Indiana | 18157 | 817 | 11 |
338608 | 338608 | 2020-07-16 | Tipton | Indiana | 18159 | 37 | 2 |
338609 | 338609 | 2020-07-16 | Union | Indiana | 18161 | 36 | 0 |
338610 | 338610 | 2020-07-16 | Vanderburgh | Indiana | 18163 | 966 | 6 |
338611 | 338611 | 2020-07-16 | Vermillion | Indiana | 18165 | 21 | 0 |
338612 | 338612 | 2020-07-16 | Vigo | Indiana | 18167 | 274 | 9 |
338613 | 338613 | 2020-07-16 | Wabash | Indiana | 18169 | 126 | 3 |
338614 | 338614 | 2020-07-16 | Warren | Indiana | 18171 | 17 | 1 |
338615 | 338615 | 2020-07-16 | Warrick | Indiana | 18173 | 302 | 31 |
338616 | 338616 | 2020-07-16 | Washington | Indiana | 18175 | 70 | 1 |
338617 | 338617 | 2020-07-16 | Wayne | Indiana | 18177 | 378 | 6 |
338618 | 338618 | 2020-07-16 | Wells | Indiana | 18179 | 105 | 1 |
338619 | 338619 | 2020-07-16 | White | Indiana | 18181 | 284 | 10 |
338620 | 338620 | 2020-07-16 | Whitley | Indiana | 18183 | 112 | 6 |
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);