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 2021-02-23 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1057455 | 1057455 | 2021-02-23 | Adams | Indiana | 18001 | 3203 | 50 |
1057456 | 1057456 | 2021-02-23 | Allen | Indiana | 18003 | 35603 | 656 |
1057457 | 1057457 | 2021-02-23 | Bartholomew | Indiana | 18005 | 7394 | 153 |
1057458 | 1057458 | 2021-02-23 | Benton | Indiana | 18007 | 911 | 13 |
1057459 | 1057459 | 2021-02-23 | Blackford | Indiana | 18009 | 1211 | 27 |
1057460 | 1057460 | 2021-02-23 | Boone | Indiana | 18011 | 6053 | 93 |
1057461 | 1057461 | 2021-02-23 | Brown | Indiana | 18013 | 946 | 39 |
1057462 | 1057462 | 2021-02-23 | Carroll | Indiana | 18015 | 1758 | 20 |
1057463 | 1057463 | 2021-02-23 | Cass | Indiana | 18017 | 5376 | 101 |
1057464 | 1057464 | 2021-02-23 | Clark | Indiana | 18019 | 11864 | 187 |
1057465 | 1057465 | 2021-02-23 | Clay | Indiana | 18021 | 2389 | 44 |
1057466 | 1057466 | 2021-02-23 | Clinton | Indiana | 18023 | 3928 | 58 |
1057467 | 1057467 | 2021-02-23 | Crawford | Indiana | 18025 | 903 | 14 |
1057468 | 1057468 | 2021-02-23 | Daviess | Indiana | 18027 | 2844 | 98 |
1057469 | 1057469 | 2021-02-23 | DeKalb | Indiana | 18033 | 3825 | 82 |
1057470 | 1057470 | 2021-02-23 | Dearborn | Indiana | 18029 | 5411 | 69 |
1057471 | 1057471 | 2021-02-23 | Decatur | Indiana | 18031 | 2746 | 92 |
1057472 | 1057472 | 2021-02-23 | Delaware | Indiana | 18035 | 9801 | 183 |
1057473 | 1057473 | 2021-02-23 | Dubois | Indiana | 18037 | 5869 | 112 |
1057474 | 1057474 | 2021-02-23 | Elkhart | Indiana | 18039 | 25363 | 429 |
1057475 | 1057475 | 2021-02-23 | Fayette | Indiana | 18041 | 2835 | 56 |
1057476 | 1057476 | 2021-02-23 | Floyd | Indiana | 18043 | 7150 | 169 |
1057477 | 1057477 | 2021-02-23 | Fountain | Indiana | 18045 | 2005 | 42 |
1057478 | 1057478 | 2021-02-23 | Franklin | Indiana | 18047 | 1601 | 36 |
1057479 | 1057479 | 2021-02-23 | Fulton | Indiana | 18049 | 1765 | 37 |
1057480 | 1057480 | 2021-02-23 | Gibson | Indiana | 18051 | 4001 | 84 |
1057481 | 1057481 | 2021-02-23 | Grant | Indiana | 18053 | 6810 | 164 |
1057482 | 1057482 | 2021-02-23 | Greene | Indiana | 18055 | 2608 | 82 |
1057483 | 1057483 | 2021-02-23 | Hamilton | Indiana | 18057 | 31883 | 410 |
1057484 | 1057484 | 2021-02-23 | Hancock | Indiana | 18059 | 7386 | 132 |
1057485 | 1057485 | 2021-02-23 | Harrison | Indiana | 18061 | 3954 | 62 |
1057486 | 1057486 | 2021-02-23 | Hendricks | Indiana | 18063 | 15781 | 315 |
1057487 | 1057487 | 2021-02-23 | Henry | Indiana | 18065 | 5407 | 93 |
1057488 | 1057488 | 2021-02-23 | Howard | Indiana | 18067 | 9028 | 198 |
1057489 | 1057489 | 2021-02-23 | Huntington | Indiana | 18069 | 3385 | 77 |
1057490 | 1057490 | 2021-02-23 | Jackson | Indiana | 18071 | 4624 | 64 |
1057491 | 1057491 | 2021-02-23 | Jasper | Indiana | 18073 | 3133 | 45 |
1057492 | 1057492 | 2021-02-23 | Jay | Indiana | 18075 | 1782 | 30 |
1057493 | 1057493 | 2021-02-23 | Jefferson | Indiana | 18077 | 2930 | 73 |
1057494 | 1057494 | 2021-02-23 | Jennings | Indiana | 18079 | 2139 | 46 |
1057495 | 1057495 | 2021-02-23 | Johnson | Indiana | 18081 | 16301 | 366 |
1057496 | 1057496 | 2021-02-23 | Knox | Indiana | 18083 | 3546 | 84 |
1057497 | 1057497 | 2021-02-23 | Kosciusko | Indiana | 18085 | 8534 | 111 |
1057498 | 1057498 | 2021-02-23 | LaGrange | Indiana | 18087 | 2407 | 72 |
1057499 | 1057499 | 2021-02-23 | LaPorte | Indiana | 18091 | 9730 | 197 |
1057500 | 1057500 | 2021-02-23 | Lake | Indiana | 18089 | 48179 | 904 |
1057501 | 1057501 | 2021-02-23 | Lawrence | Indiana | 18093 | 4157 | 114 |
1057502 | 1057502 | 2021-02-23 | Madison | Indiana | 18095 | 11703 | 335 |
1057503 | 1057503 | 2021-02-23 | Marion | Indiana | 18097 | 90339 | 1693 |
1057504 | 1057504 | 2021-02-23 | Marshall | Indiana | 18099 | 5393 | 105 |
1057505 | 1057505 | 2021-02-23 | Martin | Indiana | 18101 | 802 | 14 |
1057506 | 1057506 | 2021-02-23 | Miami | Indiana | 18103 | 3546 | 64 |
1057507 | 1057507 | 2021-02-23 | Monroe | Indiana | 18105 | 10253 | 162 |
1057508 | 1057508 | 2021-02-23 | Montgomery | Indiana | 18107 | 3817 | 84 |
1057509 | 1057509 | 2021-02-23 | Morgan | Indiana | 18109 | 6056 | 129 |
1057510 | 1057510 | 2021-02-23 | Newton | Indiana | 18111 | 966 | 33 |
1057511 | 1057511 | 2021-02-23 | Noble | Indiana | 18113 | 5071 | 78 |
1057512 | 1057512 | 2021-02-23 | Ohio | Indiana | 18115 | 527 | 11 |
1057513 | 1057513 | 2021-02-23 | Orange | Indiana | 18117 | 1708 | 53 |
1057514 | 1057514 | 2021-02-23 | Owen | Indiana | 18119 | 1819 | 54 |
1057515 | 1057515 | 2021-02-23 | Parke | Indiana | 18121 | 1393 | 15 |
1057516 | 1057516 | 2021-02-23 | Perry | Indiana | 18123 | 1734 | 36 |
1057517 | 1057517 | 2021-02-23 | Pike | Indiana | 18125 | 1272 | 32 |
1057518 | 1057518 | 2021-02-23 | Porter | Indiana | 18127 | 15863 | 282 |
1057519 | 1057519 | 2021-02-23 | Posey | Indiana | 18129 | 2597 | 31 |
1057520 | 1057520 | 2021-02-23 | Pulaski | Indiana | 18131 | 1057 | 43 |
1057521 | 1057521 | 2021-02-23 | Putnam | Indiana | 18133 | 3268 | 59 |
1057522 | 1057522 | 2021-02-23 | Randolph | Indiana | 18135 | 2292 | 77 |
1057523 | 1057523 | 2021-02-23 | Ripley | Indiana | 18137 | 3253 | 61 |
1057524 | 1057524 | 2021-02-23 | Rush | Indiana | 18139 | 1701 | 22 |
1057525 | 1057525 | 2021-02-23 | Scott | Indiana | 18143 | 2491 | 48 |
1057526 | 1057526 | 2021-02-23 | Shelby | Indiana | 18145 | 5507 | 100 |
1057527 | 1057527 | 2021-02-23 | Spencer | Indiana | 18147 | 2161 | 30 |
1057528 | 1057528 | 2021-02-23 | St. Joseph | Indiana | 18141 | 29571 | 528 |
1057529 | 1057529 | 2021-02-23 | Starke | Indiana | 18149 | 1863 | 53 |
1057530 | 1057530 | 2021-02-23 | Steuben | Indiana | 18151 | 3365 | 57 |
1057531 | 1057531 | 2021-02-23 | Sullivan | Indiana | 18153 | 2023 | 38 |
1057532 | 1057532 | 2021-02-23 | Switzerland | Indiana | 18155 | 751 | 7 |
1057533 | 1057533 | 2021-02-23 | Tippecanoe | Indiana | 18157 | 19772 | 201 |
1057534 | 1057534 | 2021-02-23 | Tipton | Indiana | 18159 | 1459 | 44 |
1057535 | 1057535 | 2021-02-23 | Union | Indiana | 18161 | 695 | 10 |
1057536 | 1057536 | 2021-02-23 | Vanderburgh | Indiana | 18163 | 21125 | 383 |
1057537 | 1057537 | 2021-02-23 | Vermillion | Indiana | 18165 | 1581 | 40 |
1057538 | 1057538 | 2021-02-23 | Vigo | Indiana | 18167 | 11516 | 235 |
1057539 | 1057539 | 2021-02-23 | Wabash | Indiana | 18169 | 3292 | 75 |
1057540 | 1057540 | 2021-02-23 | Warren | Indiana | 18171 | 748 | 13 |
1057541 | 1057541 | 2021-02-23 | Warrick | Indiana | 18173 | 7372 | 149 |
1057542 | 1057542 | 2021-02-23 | Washington | Indiana | 18175 | 2077 | 27 |
1057543 | 1057543 | 2021-02-23 | Wayne | Indiana | 18177 | 6977 | 192 |
1057544 | 1057544 | 2021-02-23 | Wells | Indiana | 18179 | 2579 | 78 |
1057545 | 1057545 | 2021-02-23 | White | Indiana | 18181 | 2953 | 51 |
1057546 | 1057546 | 2021-02-23 | Whitley | Indiana | 18183 | 3462 | 35 |
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);