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-02-24 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2246445 | 2246445 | 2022-02-24 | Adams | Indiana | 18001 | 7303 | 112 |
2246446 | 2246446 | 2022-02-24 | Allen | Indiana | 18003 | 103211 | 1150 |
2246447 | 2246447 | 2022-02-24 | Bartholomew | Indiana | 18005 | 21202 | 244 |
2246448 | 2246448 | 2022-02-24 | Benton | Indiana | 18007 | 2456 | 21 |
2246449 | 2246449 | 2022-02-24 | Blackford | Indiana | 18009 | 3098 | 68 |
2246450 | 2246450 | 2022-02-24 | Boone | Indiana | 18011 | 15037 | 172 |
2246451 | 2246451 | 2022-02-24 | Brown | Indiana | 18013 | 2579 | 62 |
2246452 | 2246452 | 2022-02-24 | Carroll | Indiana | 18015 | 4197 | 62 |
2246453 | 2246453 | 2022-02-24 | Cass | Indiana | 18017 | 11514 | 159 |
2246454 | 2246454 | 2022-02-24 | Clark | Indiana | 18019 | 30742 | 382 |
2246455 | 2246455 | 2022-02-24 | Clay | Indiana | 18021 | 6797 | 85 |
2246456 | 2246456 | 2022-02-24 | Clinton | Indiana | 18023 | 9147 | 118 |
2246457 | 2246457 | 2022-02-24 | Crawford | Indiana | 18025 | 2509 | 35 |
2246458 | 2246458 | 2022-02-24 | Daviess | Indiana | 18027 | 7437 | 147 |
2246459 | 2246459 | 2022-02-24 | DeKalb | Indiana | 18033 | 11285 | 148 |
2246460 | 2246460 | 2022-02-24 | Dearborn | Indiana | 18029 | 13354 | 130 |
2246461 | 2246461 | 2022-02-24 | Decatur | Indiana | 18031 | 7031 | 141 |
2246462 | 2246462 | 2022-02-24 | Delaware | Indiana | 18035 | 24548 | 423 |
2246463 | 2246463 | 2022-02-24 | Dubois | Indiana | 18037 | 12782 | 159 |
2246464 | 2246464 | 2022-02-24 | Elkhart | Indiana | 18039 | 53945 | 718 |
2246465 | 2246465 | 2022-02-24 | Fayette | Indiana | 18041 | 6829 | 144 |
2246466 | 2246466 | 2022-02-24 | Floyd | Indiana | 18043 | 18718 | 281 |
2246467 | 2246467 | 2022-02-24 | Fountain | Indiana | 18045 | 5338 | 97 |
2246468 | 2246468 | 2022-02-24 | Franklin | Indiana | 18047 | 4372 | 64 |
2246469 | 2246469 | 2022-02-24 | Fulton | Indiana | 18049 | 4863 | 101 |
2246470 | 2246470 | 2022-02-24 | Gibson | Indiana | 18051 | 11552 | 138 |
2246471 | 2246471 | 2022-02-24 | Grant | Indiana | 18053 | 17594 | 338 |
2246472 | 2246472 | 2022-02-24 | Greene | Indiana | 18055 | 7153 | 135 |
2246473 | 2246473 | 2022-02-24 | Hamilton | Indiana | 18057 | 81194 | 639 |
2246474 | 2246474 | 2022-02-24 | Hancock | Indiana | 18059 | 20558 | 255 |
2246475 | 2246475 | 2022-02-24 | Harrison | Indiana | 18061 | 10686 | 135 |
2246476 | 2246476 | 2022-02-24 | Hendricks | Indiana | 18063 | 40554 | 539 |
2246477 | 2246477 | 2022-02-24 | Henry | Indiana | 18065 | 12878 | 224 |
2246478 | 2246478 | 2022-02-24 | Howard | Indiana | 18067 | 25249 | 432 |
2246479 | 2246479 | 2022-02-24 | Huntington | Indiana | 18069 | 11421 | 152 |
2246480 | 2246480 | 2022-02-24 | Jackson | Indiana | 18071 | 12437 | 123 |
2246481 | 2246481 | 2022-02-24 | Jasper | Indiana | 18073 | 8950 | 143 |
2246482 | 2246482 | 2022-02-24 | Jay | Indiana | 18075 | 4824 | 76 |
2246483 | 2246483 | 2022-02-24 | Jefferson | Indiana | 18077 | 9314 | 149 |
2246484 | 2246484 | 2022-02-24 | Jennings | Indiana | 18079 | 6909 | 103 |
2246485 | 2246485 | 2022-02-24 | Johnson | Indiana | 18081 | 42124 | 594 |
2246486 | 2246486 | 2022-02-24 | Knox | Indiana | 18083 | 10668 | 140 |
2246487 | 2246487 | 2022-02-24 | Kosciusko | Indiana | 18085 | 19656 | 229 |
2246488 | 2246488 | 2022-02-24 | LaGrange | Indiana | 18087 | 5825 | 102 |
2246489 | 2246489 | 2022-02-24 | LaPorte | Indiana | 18091 | 25244 | 354 |
2246490 | 2246490 | 2022-02-24 | Lake | Indiana | 18089 | 105403 | 1768 |
2246491 | 2246491 | 2022-02-24 | Lawrence | Indiana | 18093 | 11762 | 246 |
2246492 | 2246492 | 2022-02-24 | Madison | Indiana | 18095 | 32469 | 632 |
2246493 | 2246493 | 2022-02-24 | Marion | Indiana | 18097 | 223288 | 2897 |
2246494 | 2246494 | 2022-02-24 | Marshall | Indiana | 18099 | 12275 | 190 |
2246495 | 2246495 | 2022-02-24 | Martin | Indiana | 18101 | 2153 | 25 |
2246496 | 2246496 | 2022-02-24 | Miami | Indiana | 18103 | 9204 | 154 |
2246497 | 2246497 | 2022-02-24 | Monroe | Indiana | 18105 | 27338 | 272 |
2246498 | 2246498 | 2022-02-24 | Montgomery | Indiana | 18107 | 10598 | 160 |
2246499 | 2246499 | 2022-02-24 | Morgan | Indiana | 18109 | 16360 | 273 |
2246500 | 2246500 | 2022-02-24 | Newton | Indiana | 18111 | 2533 | 68 |
2246501 | 2246501 | 2022-02-24 | Noble | Indiana | 18113 | 13012 | 154 |
2246502 | 2246502 | 2022-02-24 | Ohio | Indiana | 18115 | 1437 | 18 |
2246503 | 2246503 | 2022-02-24 | Orange | Indiana | 18117 | 5012 | 92 |
2246504 | 2246504 | 2022-02-24 | Owen | Indiana | 18119 | 5800 | 113 |
2246505 | 2246505 | 2022-02-24 | Parke | Indiana | 18121 | 3596 | 48 |
2246506 | 2246506 | 2022-02-24 | Perry | Indiana | 18123 | 4625 | 68 |
2246507 | 2246507 | 2022-02-24 | Pike | Indiana | 18125 | 3707 | 48 |
2246508 | 2246508 | 2022-02-24 | Porter | Indiana | 18127 | 37087 | 546 |
2246509 | 2246509 | 2022-02-24 | Posey | Indiana | 18129 | 6496 | 55 |
2246510 | 2246510 | 2022-02-24 | Pulaski | Indiana | 18131 | 3044 | 85 |
2246511 | 2246511 | 2022-02-24 | Putnam | Indiana | 18133 | 9246 | 124 |
2246512 | 2246512 | 2022-02-24 | Randolph | Indiana | 18135 | 5899 | 141 |
2246513 | 2246513 | 2022-02-24 | Ripley | Indiana | 18137 | 8237 | 130 |
2246514 | 2246514 | 2022-02-24 | Rush | Indiana | 18139 | 4871 | 55 |
2246515 | 2246515 | 2022-02-24 | Scott | Indiana | 18143 | 7802 | 100 |
2246516 | 2246516 | 2022-02-24 | Shelby | Indiana | 18145 | 14603 | 180 |
2246517 | 2246517 | 2022-02-24 | Spencer | Indiana | 18147 | 5189 | 58 |
2246518 | 2246518 | 2022-02-24 | St. Joseph | Indiana | 18141 | 70122 | 848 |
2246519 | 2246519 | 2022-02-24 | Starke | Indiana | 18149 | 4694 | 93 |
2246520 | 2246520 | 2022-02-24 | Steuben | Indiana | 18151 | 9588 | 119 |
2246521 | 2246521 | 2022-02-24 | Sullivan | Indiana | 18153 | 5249 | 72 |
2246522 | 2246522 | 2022-02-24 | Switzerland | Indiana | 18155 | 2295 | 17 |
2246523 | 2246523 | 2022-02-24 | Tippecanoe | Indiana | 18157 | 49519 | 375 |
2246524 | 2246524 | 2022-02-24 | Tipton | Indiana | 18159 | 3506 | 84 |
2246525 | 2246525 | 2022-02-24 | Union | Indiana | 18161 | 2038 | 21 |
2246526 | 2246526 | 2022-02-24 | Vanderburgh | Indiana | 18163 | 56920 | 600 |
2246527 | 2246527 | 2022-02-24 | Vermillion | Indiana | 18165 | 4033 | 72 |
2246528 | 2246528 | 2022-02-24 | Vigo | Indiana | 18167 | 28705 | 396 |
2246529 | 2246529 | 2022-02-24 | Wabash | Indiana | 18169 | 8664 | 149 |
2246530 | 2246530 | 2022-02-24 | Warren | Indiana | 18171 | 2054 | 25 |
2246531 | 2246531 | 2022-02-24 | Warrick | Indiana | 18173 | 20126 | 232 |
2246532 | 2246532 | 2022-02-24 | Washington | Indiana | 18175 | 5947 | 77 |
2246533 | 2246533 | 2022-02-24 | Wayne | Indiana | 18177 | 19106 | 329 |
2246534 | 2246534 | 2022-02-24 | Wells | Indiana | 18179 | 6495 | 132 |
2246535 | 2246535 | 2022-02-24 | White | Indiana | 18181 | 6769 | 91 |
2246536 | 2246536 | 2022-02-24 | Whitley | Indiana | 18183 | 9610 | 81 |
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);