ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-03-24" 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 |
---|---|---|---|---|---|---|---|
2337509 | 2337509 | 2022-03-24 | Adams | Indiana | 18001 | 7331 | 112 |
2337510 | 2337510 | 2022-03-24 | Allen | Indiana | 18003 | 103659 | 1173 |
2337511 | 2337511 | 2022-03-24 | Bartholomew | Indiana | 18005 | 21320 | 248 |
2337512 | 2337512 | 2022-03-24 | Benton | Indiana | 18007 | 2474 | 21 |
2337513 | 2337513 | 2022-03-24 | Blackford | Indiana | 18009 | 3123 | 69 |
2337514 | 2337514 | 2022-03-24 | Boone | Indiana | 18011 | 15174 | 181 |
2337515 | 2337515 | 2022-03-24 | Brown | Indiana | 18013 | 2585 | 62 |
2337516 | 2337516 | 2022-03-24 | Carroll | Indiana | 18015 | 4221 | 67 |
2337517 | 2337517 | 2022-03-24 | Cass | Indiana | 18017 | 11653 | 163 |
2337518 | 2337518 | 2022-03-24 | Clark | Indiana | 18019 | 31038 | 392 |
2337519 | 2337519 | 2022-03-24 | Clay | Indiana | 18021 | 6825 | 87 |
2337520 | 2337520 | 2022-03-24 | Clinton | Indiana | 18023 | 9185 | 123 |
2337521 | 2337521 | 2022-03-24 | Crawford | Indiana | 18025 | 2544 | 38 |
2337522 | 2337522 | 2022-03-24 | Daviess | Indiana | 18027 | 7468 | 151 |
2337523 | 2337523 | 2022-03-24 | DeKalb | Indiana | 18033 | 11334 | 149 |
2337524 | 2337524 | 2022-03-24 | Dearborn | Indiana | 18029 | 13423 | 138 |
2337525 | 2337525 | 2022-03-24 | Decatur | Indiana | 18031 | 7057 | 145 |
2337526 | 2337526 | 2022-03-24 | Delaware | Indiana | 18035 | 24787 | 438 |
2337527 | 2337527 | 2022-03-24 | Dubois | Indiana | 18037 | 12854 | 165 |
2337528 | 2337528 | 2022-03-24 | Elkhart | Indiana | 18039 | 54127 | 728 |
2337529 | 2337529 | 2022-03-24 | Fayette | Indiana | 18041 | 6868 | 146 |
2337530 | 2337530 | 2022-03-24 | Floyd | Indiana | 18043 | 18898 | 295 |
2337531 | 2337531 | 2022-03-24 | Fountain | Indiana | 18045 | 5393 | 101 |
2337532 | 2337532 | 2022-03-24 | Franklin | Indiana | 18047 | 4396 | 65 |
2337533 | 2337533 | 2022-03-24 | Fulton | Indiana | 18049 | 4909 | 102 |
2337534 | 2337534 | 2022-03-24 | Gibson | Indiana | 18051 | 11629 | 145 |
2337535 | 2337535 | 2022-03-24 | Grant | Indiana | 18053 | 17676 | 346 |
2337536 | 2337536 | 2022-03-24 | Greene | Indiana | 18055 | 7201 | 139 |
2337537 | 2337537 | 2022-03-24 | Hamilton | Indiana | 18057 | 81715 | 654 |
2337538 | 2337538 | 2022-03-24 | Hancock | Indiana | 18059 | 20649 | 258 |
2337539 | 2337539 | 2022-03-24 | Harrison | Indiana | 18061 | 10793 | 138 |
2337540 | 2337540 | 2022-03-24 | Hendricks | Indiana | 18063 | 40746 | 551 |
2337541 | 2337541 | 2022-03-24 | Henry | Indiana | 18065 | 12973 | 228 |
2337542 | 2337542 | 2022-03-24 | Howard | Indiana | 18067 | 25384 | 444 |
2337543 | 2337543 | 2022-03-24 | Huntington | Indiana | 18069 | 11492 | 155 |
2337544 | 2337544 | 2022-03-24 | Jackson | Indiana | 18071 | 12512 | 129 |
2337545 | 2337545 | 2022-03-24 | Jasper | Indiana | 18073 | 9008 | 147 |
2337546 | 2337546 | 2022-03-24 | Jay | Indiana | 18075 | 4851 | 78 |
2337547 | 2337547 | 2022-03-24 | Jefferson | Indiana | 18077 | 9349 | 154 |
2337548 | 2337548 | 2022-03-24 | Jennings | Indiana | 18079 | 6945 | 107 |
2337549 | 2337549 | 2022-03-24 | Johnson | Indiana | 18081 | 42299 | 608 |
2337550 | 2337550 | 2022-03-24 | Knox | Indiana | 18083 | 10736 | 153 |
2337551 | 2337551 | 2022-03-24 | Kosciusko | Indiana | 18085 | 19733 | 235 |
2337552 | 2337552 | 2022-03-24 | LaGrange | Indiana | 18087 | 5849 | 102 |
2337553 | 2337553 | 2022-03-24 | LaPorte | Indiana | 18091 | 25409 | 365 |
2337554 | 2337554 | 2022-03-24 | Lake | Indiana | 18089 | 106065 | 1810 |
2337555 | 2337555 | 2022-03-24 | Lawrence | Indiana | 18093 | 11835 | 258 |
2337556 | 2337556 | 2022-03-24 | Madison | Indiana | 18095 | 32648 | 647 |
2337557 | 2337557 | 2022-03-24 | Marion | Indiana | 18097 | 224841 | 2962 |
2337558 | 2337558 | 2022-03-24 | Marshall | Indiana | 18099 | 12322 | 195 |
2337559 | 2337559 | 2022-03-24 | Martin | Indiana | 18101 | 2164 | 25 |
2337560 | 2337560 | 2022-03-24 | Miami | Indiana | 18103 | 9255 | 159 |
2337561 | 2337561 | 2022-03-24 | Monroe | Indiana | 18105 | 27588 | 279 |
2337562 | 2337562 | 2022-03-24 | Montgomery | Indiana | 18107 | 10662 | 164 |
2337563 | 2337563 | 2022-03-24 | Morgan | Indiana | 18109 | 16461 | 285 |
2337564 | 2337564 | 2022-03-24 | Newton | Indiana | 18111 | 2560 | 68 |
2337565 | 2337565 | 2022-03-24 | Noble | Indiana | 18113 | 13057 | 156 |
2337566 | 2337566 | 2022-03-24 | Ohio | Indiana | 18115 | 1443 | 19 |
2337567 | 2337567 | 2022-03-24 | Orange | Indiana | 18117 | 5033 | 96 |
2337568 | 2337568 | 2022-03-24 | Owen | Indiana | 18119 | 5828 | 118 |
2337569 | 2337569 | 2022-03-24 | Parke | Indiana | 18121 | 3608 | 49 |
2337570 | 2337570 | 2022-03-24 | Perry | Indiana | 18123 | 4665 | 68 |
2337571 | 2337571 | 2022-03-24 | Pike | Indiana | 18125 | 3724 | 49 |
2337572 | 2337572 | 2022-03-24 | Porter | Indiana | 18127 | 37553 | 557 |
2337573 | 2337573 | 2022-03-24 | Posey | Indiana | 18129 | 6527 | 57 |
2337574 | 2337574 | 2022-03-24 | Pulaski | Indiana | 18131 | 3070 | 86 |
2337575 | 2337575 | 2022-03-24 | Putnam | Indiana | 18133 | 9318 | 127 |
2337576 | 2337576 | 2022-03-24 | Randolph | Indiana | 18135 | 5935 | 146 |
2337577 | 2337577 | 2022-03-24 | Ripley | Indiana | 18137 | 8281 | 138 |
2337578 | 2337578 | 2022-03-24 | Rush | Indiana | 18139 | 4906 | 58 |
2337579 | 2337579 | 2022-03-24 | Scott | Indiana | 18143 | 7862 | 106 |
2337580 | 2337580 | 2022-03-24 | Shelby | Indiana | 18145 | 14673 | 181 |
2337581 | 2337581 | 2022-03-24 | Spencer | Indiana | 18147 | 5219 | 60 |
2337582 | 2337582 | 2022-03-24 | St. Joseph | Indiana | 18141 | 70512 | 863 |
2337583 | 2337583 | 2022-03-24 | Starke | Indiana | 18149 | 4744 | 96 |
2337584 | 2337584 | 2022-03-24 | Steuben | Indiana | 18151 | 9620 | 120 |
2337585 | 2337585 | 2022-03-24 | Sullivan | Indiana | 18153 | 5274 | 76 |
2337586 | 2337586 | 2022-03-24 | Switzerland | Indiana | 18155 | 2308 | 20 |
2337587 | 2337587 | 2022-03-24 | Tippecanoe | Indiana | 18157 | 49855 | 392 |
2337588 | 2337588 | 2022-03-24 | Tipton | Indiana | 18159 | 3528 | 87 |
2337589 | 2337589 | 2022-03-24 | Union | Indiana | 18161 | 2046 | 21 |
2337590 | 2337590 | 2022-03-24 | Vanderburgh | Indiana | 18163 | 57232 | 621 |
2337591 | 2337591 | 2022-03-24 | Vermillion | Indiana | 18165 | 4068 | 74 |
2337592 | 2337592 | 2022-03-24 | Vigo | Indiana | 18167 | 28821 | 409 |
2337593 | 2337593 | 2022-03-24 | Wabash | Indiana | 18169 | 8714 | 154 |
2337594 | 2337594 | 2022-03-24 | Warren | Indiana | 18171 | 2083 | 30 |
2337595 | 2337595 | 2022-03-24 | Warrick | Indiana | 18173 | 20243 | 237 |
2337596 | 2337596 | 2022-03-24 | Washington | Indiana | 18175 | 5988 | 81 |
2337597 | 2337597 | 2022-03-24 | Wayne | Indiana | 18177 | 19193 | 333 |
2337598 | 2337598 | 2022-03-24 | Wells | Indiana | 18179 | 6522 | 132 |
2337599 | 2337599 | 2022-03-24 | White | Indiana | 18181 | 6842 | 93 |
2337600 | 2337600 | 2022-03-24 | Whitley | Indiana | 18183 | 9647 | 83 |
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);