ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

92 rows where "date" is on date 2021-03-19 and state = "Indiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Indiana · 92 ✖
Link rowid date ▲ county state fips cases deaths
1135361 1135361 2021-03-19 Adams Indiana 18001 3363 52
1135362 1135362 2021-03-19 Allen Indiana 18003 36972 679
1135363 1135363 2021-03-19 Bartholomew Indiana 18005 7618 156
1135364 1135364 2021-03-19 Benton Indiana 18007 931 13
1135365 1135365 2021-03-19 Blackford Indiana 18009 1280 28
1135366 1135366 2021-03-19 Boone Indiana 18011 6295 100
1135367 1135367 2021-03-19 Brown Indiana 18013 963 40
1135368 1135368 2021-03-19 Carroll Indiana 18015 1790 21
1135369 1135369 2021-03-19 Cass Indiana 18017 5574 103
1135370 1135370 2021-03-19 Clark Indiana 18019 12301 191
1135371 1135371 2021-03-19 Clay Indiana 18021 2443 44
1135372 1135372 2021-03-19 Clinton Indiana 18023 4017 58
1135373 1135373 2021-03-19 Crawford Indiana 18025 945 14
1135374 1135374 2021-03-19 Daviess Indiana 18027 2871 98
1135375 1135375 2021-03-19 DeKalb Indiana 18033 3931 83
1135376 1135376 2021-03-19 Dearborn Indiana 18029 5560 75
1135377 1135377 2021-03-19 Decatur Indiana 18031 2791 96
1135378 1135378 2021-03-19 Delaware Indiana 18035 10023 188
1135379 1135379 2021-03-19 Dubois Indiana 18037 5988 113
1135380 1135380 2021-03-19 Elkhart Indiana 18039 25994 441
1135381 1135381 2021-03-19 Fayette Indiana 18041 2874 61
1135382 1135382 2021-03-19 Floyd Indiana 18043 7343 180
1135383 1135383 2021-03-19 Fountain Indiana 18045 2041 44
1135384 1135384 2021-03-19 Franklin Indiana 18047 1635 36
1135385 1135385 2021-03-19 Fulton Indiana 18049 1841 39
1135386 1135386 2021-03-19 Gibson Indiana 18051 4154 89
1135387 1135387 2021-03-19 Grant Indiana 18053 6959 170
1135388 1135388 2021-03-19 Greene Indiana 18055 2669 85
1135389 1135389 2021-03-19 Hamilton Indiana 18057 32954 420
1135390 1135390 2021-03-19 Hancock Indiana 18059 7598 139
1135391 1135391 2021-03-19 Harrison Indiana 18061 4144 70
1135392 1135392 2021-03-19 Hendricks Indiana 18063 16202 324
1135393 1135393 2021-03-19 Henry Indiana 18065 5483 97
1135394 1135394 2021-03-19 Howard Indiana 18067 9270 211
1135395 1135395 2021-03-19 Huntington Indiana 18069 3603 80
1135396 1135396 2021-03-19 Jackson Indiana 18071 4708 68
1135397 1135397 2021-03-19 Jasper Indiana 18073 3255 48
1135398 1135398 2021-03-19 Jay Indiana 18075 1820 30
1135399 1135399 2021-03-19 Jefferson Indiana 18077 2984 76
1135400 1135400 2021-03-19 Jennings Indiana 18079 2207 47
1135401 1135401 2021-03-19 Johnson Indiana 18081 16800 384
1135402 1135402 2021-03-19 Knox Indiana 18083 3590 86
1135403 1135403 2021-03-19 Kosciusko Indiana 18085 8708 116
1135404 1135404 2021-03-19 LaGrange Indiana 18087 2449 72
1135405 1135405 2021-03-19 LaPorte Indiana 18091 9991 205
1135406 1135406 2021-03-19 Lake Indiana 18089 49403 945
1135407 1135407 2021-03-19 Lawrence Indiana 18093 4232 119
1135408 1135408 2021-03-19 Madison Indiana 18095 11965 349
1135409 1135409 2021-03-19 Marion Indiana 18097 92509 1749
1135410 1135410 2021-03-19 Marshall Indiana 18099 5546 107
1135411 1135411 2021-03-19 Martin Indiana 18101 812 14
1135412 1135412 2021-03-19 Miami Indiana 18103 3646 65
1135413 1135413 2021-03-19 Monroe Indiana 18105 10624 168
1135414 1135414 2021-03-19 Montgomery Indiana 18107 4002 85
1135415 1135415 2021-03-19 Morgan Indiana 18109 6229 136
1135416 1135416 2021-03-19 Newton Indiana 18111 986 35
1135417 1135417 2021-03-19 Noble Indiana 18113 5189 82
1135418 1135418 2021-03-19 Ohio Indiana 18115 544 11
1135419 1135419 2021-03-19 Orange Indiana 18117 1732 55
1135420 1135420 2021-03-19 Owen Indiana 18119 1869 56
1135421 1135421 2021-03-19 Parke Indiana 18121 1426 16
1135422 1135422 2021-03-19 Perry Indiana 18123 1766 37
1135423 1135423 2021-03-19 Pike Indiana 18125 1286 34
1135424 1135424 2021-03-19 Porter Indiana 18127 16347 297
1135425 1135425 2021-03-19 Posey Indiana 18129 2640 32
1135426 1135426 2021-03-19 Pulaski Indiana 18131 1100 44
1135427 1135427 2021-03-19 Putnam Indiana 18133 3431 60
1135428 1135428 2021-03-19 Randolph Indiana 18135 2321 78
1135429 1135429 2021-03-19 Ripley Indiana 18137 3297 66
1135430 1135430 2021-03-19 Rush Indiana 18139 1732 24
1135431 1135431 2021-03-19 Scott Indiana 18143 2550 54
1135432 1135432 2021-03-19 Shelby Indiana 18145 5638 103
1135433 1135433 2021-03-19 Spencer Indiana 18147 2234 30
1135434 1135434 2021-03-19 St. Joseph Indiana 18141 31263 539
1135435 1135435 2021-03-19 Starke Indiana 18149 1918 54
1135436 1135436 2021-03-19 Steuben Indiana 18151 3455 59
1135437 1135437 2021-03-19 Sullivan Indiana 18153 2054 41
1135438 1135438 2021-03-19 Switzerland Indiana 18155 759 8
1135439 1135439 2021-03-19 Tippecanoe Indiana 18157 20539 213
1135440 1135440 2021-03-19 Tipton Indiana 18159 1548 44
1135441 1135441 2021-03-19 Union Indiana 18161 716 11
1135442 1135442 2021-03-19 Vanderburgh Indiana 18163 21564 391
1135443 1135443 2021-03-19 Vermillion Indiana 18165 1627 43
1135444 1135444 2021-03-19 Vigo Indiana 18167 11863 244
1135445 1135445 2021-03-19 Wabash Indiana 18169 3372 77
1135446 1135446 2021-03-19 Warren Indiana 18171 765 15
1135447 1135447 2021-03-19 Warrick Indiana 18173 7527 158
1135448 1135448 2021-03-19 Washington Indiana 18175 2171 29
1135449 1135449 2021-03-19 Wayne Indiana 18177 7108 200
1135450 1135450 2021-03-19 Wells Indiana 18179 2698 81
1135451 1135451 2021-03-19 White Indiana 18181 3011 55
1135452 1135452 2021-03-19 Whitley Indiana 18183 3583 39

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);