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-04 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2272456 | 2272456 | 2022-03-04 | Adams | Indiana | 18001 | 7317 | 112 |
2272457 | 2272457 | 2022-03-04 | Allen | Indiana | 18003 | 103394 | 1160 |
2272458 | 2272458 | 2022-03-04 | Bartholomew | Indiana | 18005 | 21261 | 247 |
2272459 | 2272459 | 2022-03-04 | Benton | Indiana | 18007 | 2464 | 21 |
2272460 | 2272460 | 2022-03-04 | Blackford | Indiana | 18009 | 3116 | 69 |
2272461 | 2272461 | 2022-03-04 | Boone | Indiana | 18011 | 15080 | 175 |
2272462 | 2272462 | 2022-03-04 | Brown | Indiana | 18013 | 2581 | 62 |
2272463 | 2272463 | 2022-03-04 | Carroll | Indiana | 18015 | 4210 | 64 |
2272464 | 2272464 | 2022-03-04 | Cass | Indiana | 18017 | 11575 | 160 |
2272465 | 2272465 | 2022-03-04 | Clark | Indiana | 18019 | 30896 | 386 |
2272466 | 2272466 | 2022-03-04 | Clay | Indiana | 18021 | 6811 | 87 |
2272467 | 2272467 | 2022-03-04 | Clinton | Indiana | 18023 | 9169 | 120 |
2272468 | 2272468 | 2022-03-04 | Crawford | Indiana | 18025 | 2532 | 36 |
2272469 | 2272469 | 2022-03-04 | Daviess | Indiana | 18027 | 7452 | 150 |
2272470 | 2272470 | 2022-03-04 | DeKalb | Indiana | 18033 | 11299 | 148 |
2272471 | 2272471 | 2022-03-04 | Dearborn | Indiana | 18029 | 13394 | 134 |
2272472 | 2272472 | 2022-03-04 | Decatur | Indiana | 18031 | 7046 | 141 |
2272473 | 2272473 | 2022-03-04 | Delaware | Indiana | 18035 | 24666 | 428 |
2272474 | 2272474 | 2022-03-04 | Dubois | Indiana | 18037 | 12822 | 163 |
2272475 | 2272475 | 2022-03-04 | Elkhart | Indiana | 18039 | 54031 | 722 |
2272476 | 2272476 | 2022-03-04 | Fayette | Indiana | 18041 | 6848 | 145 |
2272477 | 2272477 | 2022-03-04 | Floyd | Indiana | 18043 | 18810 | 287 |
2272478 | 2272478 | 2022-03-04 | Fountain | Indiana | 18045 | 5369 | 97 |
2272479 | 2272479 | 2022-03-04 | Franklin | Indiana | 18047 | 4386 | 64 |
2272480 | 2272480 | 2022-03-04 | Fulton | Indiana | 18049 | 4881 | 102 |
2272481 | 2272481 | 2022-03-04 | Gibson | Indiana | 18051 | 11598 | 142 |
2272482 | 2272482 | 2022-03-04 | Grant | Indiana | 18053 | 17633 | 343 |
2272483 | 2272483 | 2022-03-04 | Greene | Indiana | 18055 | 7173 | 137 |
2272484 | 2272484 | 2022-03-04 | Hamilton | Indiana | 18057 | 81329 | 646 |
2272485 | 2272485 | 2022-03-04 | Hancock | Indiana | 18059 | 20599 | 256 |
2272486 | 2272486 | 2022-03-04 | Harrison | Indiana | 18061 | 10741 | 136 |
2272487 | 2272487 | 2022-03-04 | Hendricks | Indiana | 18063 | 40652 | 546 |
2272488 | 2272488 | 2022-03-04 | Henry | Indiana | 18065 | 12914 | 227 |
2272489 | 2272489 | 2022-03-04 | Howard | Indiana | 18067 | 25319 | 435 |
2272490 | 2272490 | 2022-03-04 | Huntington | Indiana | 18069 | 11461 | 153 |
2272491 | 2272491 | 2022-03-04 | Jackson | Indiana | 18071 | 12477 | 125 |
2272492 | 2272492 | 2022-03-04 | Jasper | Indiana | 18073 | 8969 | 144 |
2272493 | 2272493 | 2022-03-04 | Jay | Indiana | 18075 | 4842 | 77 |
2272494 | 2272494 | 2022-03-04 | Jefferson | Indiana | 18077 | 9332 | 151 |
2272495 | 2272495 | 2022-03-04 | Jennings | Indiana | 18079 | 6933 | 103 |
2272496 | 2272496 | 2022-03-04 | Johnson | Indiana | 18081 | 42197 | 599 |
2272497 | 2272497 | 2022-03-04 | Knox | Indiana | 18083 | 10701 | 148 |
2272498 | 2272498 | 2022-03-04 | Kosciusko | Indiana | 18085 | 19698 | 232 |
2272499 | 2272499 | 2022-03-04 | LaGrange | Indiana | 18087 | 5839 | 102 |
2272500 | 2272500 | 2022-03-04 | LaPorte | Indiana | 18091 | 25290 | 357 |
2272501 | 2272501 | 2022-03-04 | Lake | Indiana | 18089 | 105633 | 1786 |
2272502 | 2272502 | 2022-03-04 | Lawrence | Indiana | 18093 | 11801 | 253 |
2272503 | 2272503 | 2022-03-04 | Madison | Indiana | 18095 | 32540 | 637 |
2272504 | 2272504 | 2022-03-04 | Marion | Indiana | 18097 | 223657 | 2926 |
2272505 | 2272505 | 2022-03-04 | Marshall | Indiana | 18099 | 12290 | 193 |
2272506 | 2272506 | 2022-03-04 | Martin | Indiana | 18101 | 2155 | 25 |
2272507 | 2272507 | 2022-03-04 | Miami | Indiana | 18103 | 9230 | 158 |
2272508 | 2272508 | 2022-03-04 | Monroe | Indiana | 18105 | 27437 | 273 |
2272509 | 2272509 | 2022-03-04 | Montgomery | Indiana | 18107 | 10616 | 161 |
2272510 | 2272510 | 2022-03-04 | Morgan | Indiana | 18109 | 16404 | 278 |
2272511 | 2272511 | 2022-03-04 | Newton | Indiana | 18111 | 2545 | 68 |
2272512 | 2272512 | 2022-03-04 | Noble | Indiana | 18113 | 13032 | 156 |
2272513 | 2272513 | 2022-03-04 | Ohio | Indiana | 18115 | 1442 | 19 |
2272514 | 2272514 | 2022-03-04 | Orange | Indiana | 18117 | 5021 | 94 |
2272515 | 2272515 | 2022-03-04 | Owen | Indiana | 18119 | 5804 | 114 |
2272516 | 2272516 | 2022-03-04 | Parke | Indiana | 18121 | 3604 | 48 |
2272517 | 2272517 | 2022-03-04 | Perry | Indiana | 18123 | 4641 | 68 |
2272518 | 2272518 | 2022-03-04 | Pike | Indiana | 18125 | 3717 | 48 |
2272519 | 2272519 | 2022-03-04 | Porter | Indiana | 18127 | 37211 | 553 |
2272520 | 2272520 | 2022-03-04 | Posey | Indiana | 18129 | 6511 | 55 |
2272521 | 2272521 | 2022-03-04 | Pulaski | Indiana | 18131 | 3054 | 85 |
2272522 | 2272522 | 2022-03-04 | Putnam | Indiana | 18133 | 9277 | 125 |
2272523 | 2272523 | 2022-03-04 | Randolph | Indiana | 18135 | 5914 | 142 |
2272524 | 2272524 | 2022-03-04 | Ripley | Indiana | 18137 | 8250 | 136 |
2272525 | 2272525 | 2022-03-04 | Rush | Indiana | 18139 | 4894 | 57 |
2272526 | 2272526 | 2022-03-04 | Scott | Indiana | 18143 | 7836 | 104 |
2272527 | 2272527 | 2022-03-04 | Shelby | Indiana | 18145 | 14640 | 180 |
2272528 | 2272528 | 2022-03-04 | Spencer | Indiana | 18147 | 5211 | 60 |
2272529 | 2272529 | 2022-03-04 | St. Joseph | Indiana | 18141 | 70280 | 852 |
2272530 | 2272530 | 2022-03-04 | Starke | Indiana | 18149 | 4708 | 94 |
2272531 | 2272531 | 2022-03-04 | Steuben | Indiana | 18151 | 9606 | 119 |
2272532 | 2272532 | 2022-03-04 | Sullivan | Indiana | 18153 | 5256 | 73 |
2272533 | 2272533 | 2022-03-04 | Switzerland | Indiana | 18155 | 2303 | 19 |
2272534 | 2272534 | 2022-03-04 | Tippecanoe | Indiana | 18157 | 49664 | 380 |
2272535 | 2272535 | 2022-03-04 | Tipton | Indiana | 18159 | 3508 | 86 |
2272536 | 2272536 | 2022-03-04 | Union | Indiana | 18161 | 2044 | 21 |
2272537 | 2272537 | 2022-03-04 | Vanderburgh | Indiana | 18163 | 57066 | 614 |
2272538 | 2272538 | 2022-03-04 | Vermillion | Indiana | 18165 | 4051 | 73 |
2272539 | 2272539 | 2022-03-04 | Vigo | Indiana | 18167 | 28769 | 404 |
2272540 | 2272540 | 2022-03-04 | Wabash | Indiana | 18169 | 8691 | 151 |
2272541 | 2272541 | 2022-03-04 | Warren | Indiana | 18171 | 2072 | 27 |
2272542 | 2272542 | 2022-03-04 | Warrick | Indiana | 18173 | 20187 | 233 |
2272543 | 2272543 | 2022-03-04 | Washington | Indiana | 18175 | 5971 | 78 |
2272544 | 2272544 | 2022-03-04 | Wayne | Indiana | 18177 | 19146 | 330 |
2272545 | 2272545 | 2022-03-04 | Wells | Indiana | 18179 | 6508 | 132 |
2272546 | 2272546 | 2022-03-04 | White | Indiana | 18181 | 6803 | 92 |
2272547 | 2272547 | 2022-03-04 | Whitley | Indiana | 18183 | 9626 | 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);