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 2022-03-08 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2285467 | 2285467 | 2022-03-08 | Adams | Indiana | 18001 | 7319 | 112 |
2285468 | 2285468 | 2022-03-08 | Allen | Indiana | 18003 | 103443 | 1162 |
2285469 | 2285469 | 2022-03-08 | Bartholomew | Indiana | 18005 | 21276 | 247 |
2285470 | 2285470 | 2022-03-08 | Benton | Indiana | 18007 | 2466 | 21 |
2285471 | 2285471 | 2022-03-08 | Blackford | Indiana | 18009 | 3118 | 69 |
2285472 | 2285472 | 2022-03-08 | Boone | Indiana | 18011 | 15102 | 175 |
2285473 | 2285473 | 2022-03-08 | Brown | Indiana | 18013 | 2583 | 62 |
2285474 | 2285474 | 2022-03-08 | Carroll | Indiana | 18015 | 4210 | 64 |
2285475 | 2285475 | 2022-03-08 | Cass | Indiana | 18017 | 11606 | 160 |
2285476 | 2285476 | 2022-03-08 | Clark | Indiana | 18019 | 30931 | 386 |
2285477 | 2285477 | 2022-03-08 | Clay | Indiana | 18021 | 6816 | 87 |
2285478 | 2285478 | 2022-03-08 | Clinton | Indiana | 18023 | 9172 | 120 |
2285479 | 2285479 | 2022-03-08 | Crawford | Indiana | 18025 | 2535 | 36 |
2285480 | 2285480 | 2022-03-08 | Daviess | Indiana | 18027 | 7454 | 150 |
2285481 | 2285481 | 2022-03-08 | DeKalb | Indiana | 18033 | 11307 | 148 |
2285482 | 2285482 | 2022-03-08 | Dearborn | Indiana | 18029 | 13399 | 135 |
2285483 | 2285483 | 2022-03-08 | Decatur | Indiana | 18031 | 7048 | 144 |
2285484 | 2285484 | 2022-03-08 | Delaware | Indiana | 18035 | 24696 | 428 |
2285485 | 2285485 | 2022-03-08 | Dubois | Indiana | 18037 | 12829 | 165 |
2285486 | 2285486 | 2022-03-08 | Elkhart | Indiana | 18039 | 54053 | 723 |
2285487 | 2285487 | 2022-03-08 | Fayette | Indiana | 18041 | 6852 | 145 |
2285488 | 2285488 | 2022-03-08 | Floyd | Indiana | 18043 | 18829 | 287 |
2285489 | 2285489 | 2022-03-08 | Fountain | Indiana | 18045 | 5375 | 98 |
2285490 | 2285490 | 2022-03-08 | Franklin | Indiana | 18047 | 4387 | 64 |
2285491 | 2285491 | 2022-03-08 | Fulton | Indiana | 18049 | 4888 | 102 |
2285492 | 2285492 | 2022-03-08 | Gibson | Indiana | 18051 | 11608 | 142 |
2285493 | 2285493 | 2022-03-08 | Grant | Indiana | 18053 | 17644 | 343 |
2285494 | 2285494 | 2022-03-08 | Greene | Indiana | 18055 | 7180 | 137 |
2285495 | 2285495 | 2022-03-08 | Hamilton | Indiana | 18057 | 81444 | 647 |
2285496 | 2285496 | 2022-03-08 | Hancock | Indiana | 18059 | 20615 | 256 |
2285497 | 2285497 | 2022-03-08 | Harrison | Indiana | 18061 | 10751 | 136 |
2285498 | 2285498 | 2022-03-08 | Hendricks | Indiana | 18063 | 40684 | 549 |
2285499 | 2285499 | 2022-03-08 | Henry | Indiana | 18065 | 12930 | 227 |
2285500 | 2285500 | 2022-03-08 | Howard | Indiana | 18067 | 25340 | 436 |
2285501 | 2285501 | 2022-03-08 | Huntington | Indiana | 18069 | 11470 | 153 |
2285502 | 2285502 | 2022-03-08 | Jackson | Indiana | 18071 | 12485 | 125 |
2285503 | 2285503 | 2022-03-08 | Jasper | Indiana | 18073 | 8976 | 144 |
2285504 | 2285504 | 2022-03-08 | Jay | Indiana | 18075 | 4843 | 77 |
2285505 | 2285505 | 2022-03-08 | Jefferson | Indiana | 18077 | 9334 | 152 |
2285506 | 2285506 | 2022-03-08 | Jennings | Indiana | 18079 | 6936 | 103 |
2285507 | 2285507 | 2022-03-08 | Johnson | Indiana | 18081 | 42234 | 600 |
2285508 | 2285508 | 2022-03-08 | Knox | Indiana | 18083 | 10710 | 148 |
2285509 | 2285509 | 2022-03-08 | Kosciusko | Indiana | 18085 | 19704 | 232 |
2285510 | 2285510 | 2022-03-08 | LaGrange | Indiana | 18087 | 5840 | 102 |
2285511 | 2285511 | 2022-03-08 | LaPorte | Indiana | 18091 | 25310 | 357 |
2285512 | 2285512 | 2022-03-08 | Lake | Indiana | 18089 | 105725 | 1789 |
2285513 | 2285513 | 2022-03-08 | Lawrence | Indiana | 18093 | 11807 | 253 |
2285514 | 2285514 | 2022-03-08 | Madison | Indiana | 18095 | 32560 | 637 |
2285515 | 2285515 | 2022-03-08 | Marion | Indiana | 18097 | 224277 | 2927 |
2285516 | 2285516 | 2022-03-08 | Marshall | Indiana | 18099 | 12294 | 193 |
2285517 | 2285517 | 2022-03-08 | Martin | Indiana | 18101 | 2160 | 25 |
2285518 | 2285518 | 2022-03-08 | Miami | Indiana | 18103 | 9231 | 158 |
2285519 | 2285519 | 2022-03-08 | Monroe | Indiana | 18105 | 27468 | 273 |
2285520 | 2285520 | 2022-03-08 | Montgomery | Indiana | 18107 | 10623 | 163 |
2285521 | 2285521 | 2022-03-08 | Morgan | Indiana | 18109 | 16416 | 278 |
2285522 | 2285522 | 2022-03-08 | Newton | Indiana | 18111 | 2546 | 68 |
2285523 | 2285523 | 2022-03-08 | Noble | Indiana | 18113 | 13032 | 156 |
2285524 | 2285524 | 2022-03-08 | Ohio | Indiana | 18115 | 1442 | 19 |
2285525 | 2285525 | 2022-03-08 | Orange | Indiana | 18117 | 5026 | 96 |
2285526 | 2285526 | 2022-03-08 | Owen | Indiana | 18119 | 5810 | 114 |
2285527 | 2285527 | 2022-03-08 | Parke | Indiana | 18121 | 3605 | 48 |
2285528 | 2285528 | 2022-03-08 | Perry | Indiana | 18123 | 4645 | 68 |
2285529 | 2285529 | 2022-03-08 | Pike | Indiana | 18125 | 3718 | 48 |
2285530 | 2285530 | 2022-03-08 | Porter | Indiana | 18127 | 37309 | 554 |
2285531 | 2285531 | 2022-03-08 | Posey | Indiana | 18129 | 6515 | 56 |
2285532 | 2285532 | 2022-03-08 | Pulaski | Indiana | 18131 | 3063 | 85 |
2285533 | 2285533 | 2022-03-08 | Putnam | Indiana | 18133 | 9289 | 125 |
2285534 | 2285534 | 2022-03-08 | Randolph | Indiana | 18135 | 5918 | 142 |
2285535 | 2285535 | 2022-03-08 | Ripley | Indiana | 18137 | 8254 | 137 |
2285536 | 2285536 | 2022-03-08 | Rush | Indiana | 18139 | 4896 | 58 |
2285537 | 2285537 | 2022-03-08 | Scott | Indiana | 18143 | 7849 | 105 |
2285538 | 2285538 | 2022-03-08 | Shelby | Indiana | 18145 | 14647 | 180 |
2285539 | 2285539 | 2022-03-08 | Spencer | Indiana | 18147 | 5212 | 60 |
2285540 | 2285540 | 2022-03-08 | St. Joseph | Indiana | 18141 | 70318 | 853 |
2285541 | 2285541 | 2022-03-08 | Starke | Indiana | 18149 | 4712 | 94 |
2285542 | 2285542 | 2022-03-08 | Steuben | Indiana | 18151 | 9612 | 119 |
2285543 | 2285543 | 2022-03-08 | Sullivan | Indiana | 18153 | 5259 | 73 |
2285544 | 2285544 | 2022-03-08 | Switzerland | Indiana | 18155 | 2306 | 19 |
2285545 | 2285545 | 2022-03-08 | Tippecanoe | Indiana | 18157 | 49700 | 381 |
2285546 | 2285546 | 2022-03-08 | Tipton | Indiana | 18159 | 3511 | 86 |
2285547 | 2285547 | 2022-03-08 | Union | Indiana | 18161 | 2044 | 21 |
2285548 | 2285548 | 2022-03-08 | Vanderburgh | Indiana | 18163 | 57096 | 617 |
2285549 | 2285549 | 2022-03-08 | Vermillion | Indiana | 18165 | 4053 | 73 |
2285550 | 2285550 | 2022-03-08 | Vigo | Indiana | 18167 | 28789 | 404 |
2285551 | 2285551 | 2022-03-08 | Wabash | Indiana | 18169 | 8695 | 151 |
2285552 | 2285552 | 2022-03-08 | Warren | Indiana | 18171 | 2076 | 28 |
2285553 | 2285553 | 2022-03-08 | Warrick | Indiana | 18173 | 20203 | 233 |
2285554 | 2285554 | 2022-03-08 | Washington | Indiana | 18175 | 5975 | 78 |
2285555 | 2285555 | 2022-03-08 | Wayne | Indiana | 18177 | 19159 | 330 |
2285556 | 2285556 | 2022-03-08 | Wells | Indiana | 18179 | 6512 | 132 |
2285557 | 2285557 | 2022-03-08 | White | Indiana | 18181 | 6814 | 92 |
2285558 | 2285558 | 2022-03-08 | Whitley | Indiana | 18183 | 9630 | 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);