ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
846500 | 846500 | 2020-12-20 | Adams | Indiana | 18001 | 2446 | 31 |
846501 | 846501 | 2020-12-20 | Allen | Indiana | 18003 | 25827 | 446 |
846502 | 846502 | 2020-12-20 | Bartholomew | Indiana | 18005 | 4987 | 83 |
846503 | 846503 | 2020-12-20 | Benton | Indiana | 18007 | 683 | 5 |
846504 | 846504 | 2020-12-20 | Blackford | Indiana | 18009 | 826 | 21 |
846505 | 846505 | 2020-12-20 | Boone | Indiana | 18011 | 3930 | 61 |
846506 | 846506 | 2020-12-20 | Brown | Indiana | 18013 | 613 | 8 |
846507 | 846507 | 2020-12-20 | Carroll | Indiana | 18015 | 1166 | 15 |
846508 | 846508 | 2020-12-20 | Cass | Indiana | 18017 | 3925 | 38 |
846509 | 846509 | 2020-12-20 | Clark | Indiana | 18019 | 7475 | 110 |
846510 | 846510 | 2020-12-20 | Clay | Indiana | 18021 | 1720 | 30 |
846511 | 846511 | 2020-12-20 | Clinton | Indiana | 18023 | 2902 | 34 |
846512 | 846512 | 2020-12-20 | Crawford | Indiana | 18025 | 531 | 8 |
846513 | 846513 | 2020-12-20 | Daviess | Indiana | 18027 | 2115 | 66 |
846514 | 846514 | 2020-12-20 | DeKalb | Indiana | 18033 | 2749 | 53 |
846515 | 846515 | 2020-12-20 | Dearborn | Indiana | 18029 | 3424 | 41 |
846516 | 846516 | 2020-12-20 | Decatur | Indiana | 18031 | 1977 | 64 |
846517 | 846517 | 2020-12-20 | Delaware | Indiana | 18035 | 7036 | 126 |
846518 | 846518 | 2020-12-20 | Dubois | Indiana | 18037 | 3930 | 38 |
846519 | 846519 | 2020-12-20 | Elkhart | Indiana | 18039 | 21799 | 304 |
846520 | 846520 | 2020-12-20 | Fayette | Indiana | 18041 | 2130 | 43 |
846521 | 846521 | 2020-12-20 | Floyd | Indiana | 18043 | 4596 | 91 |
846522 | 846522 | 2020-12-20 | Fountain | Indiana | 18045 | 1358 | 19 |
846523 | 846523 | 2020-12-20 | Franklin | Indiana | 18047 | 1091 | 29 |
846524 | 846524 | 2020-12-20 | Fulton | Indiana | 18049 | 1276 | 23 |
846525 | 846525 | 2020-12-20 | Gibson | Indiana | 18051 | 2768 | 50 |
846526 | 846526 | 2020-12-20 | Grant | Indiana | 18053 | 4888 | 88 |
846527 | 846527 | 2020-12-20 | Greene | Indiana | 18055 | 1703 | 58 |
846528 | 846528 | 2020-12-20 | Hamilton | Indiana | 18057 | 21156 | 248 |
846529 | 846529 | 2020-12-20 | Hancock | Indiana | 18059 | 4586 | 80 |
846530 | 846530 | 2020-12-20 | Harrison | Indiana | 18061 | 2274 | 31 |
846531 | 846531 | 2020-12-20 | Hendricks | Indiana | 18063 | 10063 | 210 |
846532 | 846532 | 2020-12-20 | Henry | Indiana | 18065 | 3709 | 49 |
846533 | 846533 | 2020-12-20 | Howard | Indiana | 18067 | 5972 | 105 |
846534 | 846534 | 2020-12-20 | Huntington | Indiana | 18069 | 2158 | 25 |
846535 | 846535 | 2020-12-20 | Jackson | Indiana | 18071 | 3475 | 42 |
846536 | 846536 | 2020-12-20 | Jasper | Indiana | 18073 | 2254 | 28 |
846537 | 846537 | 2020-12-20 | Jay | Indiana | 18075 | 1442 | 22 |
846538 | 846538 | 2020-12-20 | Jefferson | Indiana | 18077 | 1908 | 28 |
846539 | 846539 | 2020-12-20 | Jennings | Indiana | 18079 | 1564 | 29 |
846540 | 846540 | 2020-12-20 | Johnson | Indiana | 18081 | 10639 | 216 |
846541 | 846541 | 2020-12-20 | Knox | Indiana | 18083 | 2707 | 34 |
846542 | 846542 | 2020-12-20 | Kosciusko | Indiana | 18085 | 6383 | 67 |
846543 | 846543 | 2020-12-20 | LaGrange | Indiana | 18087 | 1918 | 46 |
846544 | 846544 | 2020-12-20 | LaPorte | Indiana | 18091 | 6713 | 124 |
846545 | 846545 | 2020-12-20 | Lake | Indiana | 18089 | 37105 | 578 |
846546 | 846546 | 2020-12-20 | Lawrence | Indiana | 18093 | 2843 | 59 |
846547 | 846547 | 2020-12-20 | Madison | Indiana | 18095 | 8006 | 171 |
846548 | 846548 | 2020-12-20 | Marion | Indiana | 18097 | 64119 | 1100 |
846549 | 846549 | 2020-12-20 | Marshall | Indiana | 18099 | 4217 | 65 |
846550 | 846550 | 2020-12-20 | Martin | Indiana | 18101 | 511 | 11 |
846551 | 846551 | 2020-12-20 | Miami | Indiana | 18103 | 2506 | 25 |
846552 | 846552 | 2020-12-20 | Monroe | Indiana | 18105 | 7467 | 86 |
846553 | 846553 | 2020-12-20 | Montgomery | Indiana | 18107 | 2546 | 40 |
846554 | 846554 | 2020-12-20 | Morgan | Indiana | 18109 | 3839 | 73 |
846555 | 846555 | 2020-12-20 | Newton | Indiana | 18111 | 780 | 20 |
846556 | 846556 | 2020-12-20 | Noble | Indiana | 18113 | 3724 | 55 |
846557 | 846557 | 2020-12-20 | Ohio | Indiana | 18115 | 346 | 7 |
846558 | 846558 | 2020-12-20 | Orange | Indiana | 18117 | 1063 | 31 |
846559 | 846559 | 2020-12-20 | Owen | Indiana | 18119 | 1142 | 24 |
846560 | 846560 | 2020-12-20 | Parke | Indiana | 18121 | 1102 | 7 |
846561 | 846561 | 2020-12-20 | Perry | Indiana | 18123 | 1093 | 23 |
846562 | 846562 | 2020-12-20 | Pike | Indiana | 18125 | 811 | 25 |
846563 | 846563 | 2020-12-20 | Porter | Indiana | 18127 | 11663 | 135 |
846564 | 846564 | 2020-12-20 | Posey | Indiana | 18129 | 1686 | 26 |
846565 | 846565 | 2020-12-20 | Pulaski | Indiana | 18131 | 745 | 29 |
846566 | 846566 | 2020-12-20 | Putnam | Indiana | 18133 | 2213 | 34 |
846567 | 846567 | 2020-12-20 | Randolph | Indiana | 18135 | 1772 | 31 |
846568 | 846568 | 2020-12-20 | Ripley | Indiana | 18137 | 2228 | 37 |
846569 | 846569 | 2020-12-20 | Rush | Indiana | 18139 | 1065 | 10 |
846570 | 846570 | 2020-12-20 | Scott | Indiana | 18143 | 1762 | 35 |
846571 | 846571 | 2020-12-20 | Shelby | Indiana | 18145 | 3805 | 77 |
846572 | 846572 | 2020-12-20 | Spencer | Indiana | 18147 | 1273 | 10 |
846573 | 846573 | 2020-12-20 | St. Joseph | Indiana | 18141 | 22867 | 321 |
846574 | 846574 | 2020-12-20 | Starke | Indiana | 18149 | 1425 | 37 |
846575 | 846575 | 2020-12-20 | Steuben | Indiana | 18151 | 2312 | 18 |
846576 | 846576 | 2020-12-20 | Sullivan | Indiana | 18153 | 1513 | 22 |
846577 | 846577 | 2020-12-20 | Switzerland | Indiana | 18155 | 433 | 5 |
846578 | 846578 | 2020-12-20 | Tippecanoe | Indiana | 18157 | 13546 | 66 |
846579 | 846579 | 2020-12-20 | Tipton | Indiana | 18159 | 959 | 32 |
846580 | 846580 | 2020-12-20 | Union | Indiana | 18161 | 451 | 2 |
846581 | 846581 | 2020-12-20 | Vanderburgh | Indiana | 18163 | 13774 | 183 |
846582 | 846582 | 2020-12-20 | Vermillion | Indiana | 18165 | 1092 | 24 |
846583 | 846583 | 2020-12-20 | Vigo | Indiana | 18167 | 8567 | 140 |
846584 | 846584 | 2020-12-20 | Wabash | Indiana | 18169 | 2448 | 37 |
846585 | 846585 | 2020-12-20 | Warren | Indiana | 18171 | 457 | 8 |
846586 | 846586 | 2020-12-20 | Warrick | Indiana | 18173 | 4623 | 87 |
846587 | 846587 | 2020-12-20 | Washington | Indiana | 18175 | 1266 | 12 |
846588 | 846588 | 2020-12-20 | Wayne | Indiana | 18177 | 5178 | 130 |
846589 | 846589 | 2020-12-20 | Wells | Indiana | 18179 | 1823 | 47 |
846590 | 846590 | 2020-12-20 | White | Indiana | 18181 | 2075 | 25 |
846591 | 846591 | 2020-12-20 | Whitley | Indiana | 18183 | 2225 | 17 |
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);