ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-06-21" 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 |
---|---|---|---|---|---|---|---|
259515 | 259515 | 2020-06-21 | Adams | Indiana | 18001 | 37 | 2 |
259516 | 259516 | 2020-06-21 | Allen | Indiana | 18003 | 2428 | 101 |
259517 | 259517 | 2020-06-21 | Bartholomew | Indiana | 18005 | 572 | 46 |
259518 | 259518 | 2020-06-21 | Benton | Indiana | 18007 | 41 | 0 |
259519 | 259519 | 2020-06-21 | Blackford | Indiana | 18009 | 35 | 2 |
259520 | 259520 | 2020-06-21 | Boone | Indiana | 18011 | 408 | 43 |
259521 | 259521 | 2020-06-21 | Brown | Indiana | 18013 | 37 | 1 |
259522 | 259522 | 2020-06-21 | Carroll | Indiana | 18015 | 103 | 2 |
259523 | 259523 | 2020-06-21 | Cass | Indiana | 18017 | 1628 | 10 |
259524 | 259524 | 2020-06-21 | Clark | Indiana | 18019 | 602 | 50 |
259525 | 259525 | 2020-06-21 | Clay | Indiana | 18021 | 56 | 3 |
259526 | 259526 | 2020-06-21 | Clinton | Indiana | 18023 | 274 | 2 |
259527 | 259527 | 2020-06-21 | Crawford | Indiana | 18025 | 28 | 1 |
259528 | 259528 | 2020-06-21 | Daviess | Indiana | 18027 | 134 | 18 |
259529 | 259529 | 2020-06-21 | DeKalb | Indiana | 18033 | 140 | 4 |
259530 | 259530 | 2020-06-21 | Dearborn | Indiana | 18029 | 190 | 23 |
259531 | 259531 | 2020-06-21 | Decatur | Indiana | 18031 | 254 | 35 |
259532 | 259532 | 2020-06-21 | Delaware | Indiana | 18035 | 409 | 47 |
259533 | 259533 | 2020-06-21 | Dubois | Indiana | 18037 | 251 | 6 |
259534 | 259534 | 2020-06-21 | Elkhart | Indiana | 18039 | 2658 | 41 |
259535 | 259535 | 2020-06-21 | Fayette | Indiana | 18041 | 133 | 7 |
259536 | 259536 | 2020-06-21 | Floyd | Indiana | 18043 | 346 | 45 |
259537 | 259537 | 2020-06-21 | Fountain | Indiana | 18045 | 24 | 2 |
259538 | 259538 | 2020-06-21 | Franklin | Indiana | 18047 | 128 | 9 |
259539 | 259539 | 2020-06-21 | Fulton | Indiana | 18049 | 62 | 1 |
259540 | 259540 | 2020-06-21 | Gibson | Indiana | 18051 | 27 | 2 |
259541 | 259541 | 2020-06-21 | Grant | Indiana | 18053 | 354 | 28 |
259542 | 259542 | 2020-06-21 | Greene | Indiana | 18055 | 189 | 32 |
259543 | 259543 | 2020-06-21 | Hamilton | Indiana | 18057 | 1382 | 102 |
259544 | 259544 | 2020-06-21 | Hancock | Indiana | 18059 | 395 | 34 |
259545 | 259545 | 2020-06-21 | Harrison | Indiana | 18061 | 202 | 24 |
259546 | 259546 | 2020-06-21 | Hendricks | Indiana | 18063 | 1342 | 110 |
259547 | 259547 | 2020-06-21 | Henry | Indiana | 18065 | 214 | 15 |
259548 | 259548 | 2020-06-21 | Howard | Indiana | 18067 | 504 | 51 |
259549 | 259549 | 2020-06-21 | Huntington | Indiana | 18069 | 60 | 2 |
259550 | 259550 | 2020-06-21 | Jackson | Indiana | 18071 | 435 | 4 |
259551 | 259551 | 2020-06-21 | Jasper | Indiana | 18073 | 92 | 1 |
259552 | 259552 | 2020-06-21 | Jay | Indiana | 18075 | 66 | 0 |
259553 | 259553 | 2020-06-21 | Jefferson | Indiana | 18077 | 57 | 1 |
259554 | 259554 | 2020-06-21 | Jennings | Indiana | 18079 | 163 | 11 |
259555 | 259555 | 2020-06-21 | Johnson | Indiana | 18081 | 1228 | 125 |
259556 | 259556 | 2020-06-21 | Knox | Indiana | 18083 | 45 | 0 |
259557 | 259557 | 2020-06-21 | Kosciusko | Indiana | 18085 | 385 | 3 |
259558 | 259558 | 2020-06-21 | LaGrange | Indiana | 18087 | 379 | 5 |
259559 | 259559 | 2020-06-21 | LaPorte | Indiana | 18091 | 487 | 25 |
259560 | 259560 | 2020-06-21 | Lake | Indiana | 18089 | 4436 | 249 |
259561 | 259561 | 2020-06-21 | Lawrence | Indiana | 18093 | 194 | 25 |
259562 | 259562 | 2020-06-21 | Madison | Indiana | 18095 | 630 | 73 |
259563 | 259563 | 2020-06-21 | Marion | Indiana | 18097 | 11067 | 714 |
259564 | 259564 | 2020-06-21 | Marshall | Indiana | 18099 | 359 | 3 |
259565 | 259565 | 2020-06-21 | Martin | Indiana | 18101 | 21 | 0 |
259566 | 259566 | 2020-06-21 | Miami | Indiana | 18103 | 179 | 2 |
259567 | 259567 | 2020-06-21 | Monroe | Indiana | 18105 | 210 | 28 |
259568 | 259568 | 2020-06-21 | Montgomery | Indiana | 18107 | 274 | 20 |
259569 | 259569 | 2020-06-21 | Morgan | Indiana | 18109 | 315 | 32 |
259570 | 259570 | 2020-06-21 | Newton | Indiana | 18111 | 89 | 11 |
259571 | 259571 | 2020-06-21 | Noble | Indiana | 18113 | 369 | 28 |
259572 | 259572 | 2020-06-21 | Ohio | Indiana | 18115 | 13 | 0 |
259573 | 259573 | 2020-06-21 | Orange | Indiana | 18117 | 134 | 25 |
259574 | 259574 | 2020-06-21 | Owen | Indiana | 18119 | 40 | 1 |
259575 | 259575 | 2020-06-21 | Parke | Indiana | 18121 | 25 | 0 |
259576 | 259576 | 2020-06-21 | Perry | Indiana | 18123 | 116 | 4 |
259577 | 259577 | 2020-06-21 | Pike | Indiana | 18125 | 6 | 0 |
259578 | 259578 | 2020-06-21 | Porter | Indiana | 18127 | 624 | 38 |
259579 | 259579 | 2020-06-21 | Posey | Indiana | 18129 | 24 | 0 |
259580 | 259580 | 2020-06-21 | Pulaski | Indiana | 18131 | 55 | 1 |
259581 | 259581 | 2020-06-21 | Putnam | Indiana | 18133 | 163 | 8 |
259582 | 259582 | 2020-06-21 | Randolph | Indiana | 18135 | 96 | 3 |
259583 | 259583 | 2020-06-21 | Ripley | Indiana | 18137 | 112 | 7 |
259584 | 259584 | 2020-06-21 | Rush | Indiana | 18139 | 72 | 3 |
259585 | 259585 | 2020-06-21 | Scott | Indiana | 18143 | 151 | 7 |
259586 | 259586 | 2020-06-21 | Shelby | Indiana | 18145 | 618 | 32 |
259587 | 259587 | 2020-06-21 | Spencer | Indiana | 18147 | 27 | 1 |
259588 | 259588 | 2020-06-21 | St. Joseph | Indiana | 18141 | 1672 | 61 |
259589 | 259589 | 2020-06-21 | Starke | Indiana | 18149 | 62 | 4 |
259590 | 259590 | 2020-06-21 | Steuben | Indiana | 18151 | 109 | 2 |
259591 | 259591 | 2020-06-21 | Sullivan | Indiana | 18153 | 42 | 1 |
259592 | 259592 | 2020-06-21 | Switzerland | Indiana | 18155 | 24 | 0 |
259593 | 259593 | 2020-06-21 | Tippecanoe | Indiana | 18157 | 533 | 8 |
259594 | 259594 | 2020-06-21 | Tipton | Indiana | 18159 | 29 | 2 |
259595 | 259595 | 2020-06-21 | Union | Indiana | 18161 | 27 | 0 |
259596 | 259596 | 2020-06-21 | Vanderburgh | Indiana | 18163 | 345 | 6 |
259597 | 259597 | 2020-06-21 | Vermillion | Indiana | 18165 | 14 | 0 |
259598 | 259598 | 2020-06-21 | Vigo | Indiana | 18167 | 211 | 9 |
259599 | 259599 | 2020-06-21 | Wabash | Indiana | 18169 | 95 | 2 |
259600 | 259600 | 2020-06-21 | Warren | Indiana | 18171 | 15 | 1 |
259601 | 259601 | 2020-06-21 | Warrick | Indiana | 18173 | 182 | 31 |
259602 | 259602 | 2020-06-21 | Washington | Indiana | 18175 | 62 | 1 |
259603 | 259603 | 2020-06-21 | Wayne | Indiana | 18177 | 279 | 6 |
259604 | 259604 | 2020-06-21 | Wells | Indiana | 18179 | 72 | 1 |
259605 | 259605 | 2020-06-21 | White | Indiana | 18181 | 249 | 10 |
259606 | 259606 | 2020-06-21 | Whitley | Indiana | 18183 | 71 | 4 |
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);