ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,079 rows where deaths = 3 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Brown 76
- Huntington 75
- Spencer 62
- Rush 50
- Jefferson 49
- Steuben 47
- Randolph 41
- Adams 35
- Blackford 33
- Wabash 31
- Kosciusko 28
- Scott 28
- Starke 28
- Marshall 24
- Benton 23
- Whitley 22
- Elkhart 21
- Fountain 21
- Clay 19
- Jasper 18
- Knox 18
- Jackson 16
- Ripley 15
- Washington 15
- Fayette 14
- Grant 14
- Wayne 14
- Tippecanoe 13
- Vigo 12
- Jennings 11
- …
state 1
- Indiana · 1,079 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418946 | 2418946 | 2022-04-18 | Unknown | Indiana | 0 | 3 | |
937446 | 937446 | 2021-01-17 | Union | Indiana | 18161 | 638 | 3 |
934201 | 934201 | 2021-01-16 | Union | Indiana | 18161 | 633 | 3 |
930956 | 930956 | 2021-01-15 | Union | Indiana | 18161 | 633 | 3 |
927711 | 927711 | 2021-01-14 | Union | Indiana | 18161 | 630 | 3 |
924465 | 924465 | 2021-01-13 | Union | Indiana | 18161 | 627 | 3 |
840012 | 840012 | 2020-12-18 | Benton | Indiana | 18007 | 676 | 3 |
836767 | 836767 | 2020-12-17 | Benton | Indiana | 18007 | 656 | 3 |
833521 | 833521 | 2020-12-16 | Benton | Indiana | 18007 | 643 | 3 |
830274 | 830274 | 2020-12-15 | Benton | Indiana | 18007 | 635 | 3 |
827028 | 827028 | 2020-12-14 | Benton | Indiana | 18007 | 621 | 3 |
823781 | 823781 | 2020-12-13 | Benton | Indiana | 18007 | 616 | 3 |
820535 | 820535 | 2020-12-12 | Benton | Indiana | 18007 | 607 | 3 |
817289 | 817289 | 2020-12-11 | Benton | Indiana | 18007 | 582 | 3 |
814043 | 814043 | 2020-12-10 | Benton | Indiana | 18007 | 548 | 3 |
810798 | 810798 | 2020-12-09 | Benton | Indiana | 18007 | 535 | 3 |
807553 | 807553 | 2020-12-08 | Benton | Indiana | 18007 | 521 | 3 |
804308 | 804308 | 2020-12-07 | Benton | Indiana | 18007 | 504 | 3 |
804317 | 804317 | 2020-12-07 | Crawford | Indiana | 18025 | 407 | 3 |
801063 | 801063 | 2020-12-06 | Benton | Indiana | 18007 | 496 | 3 |
801072 | 801072 | 2020-12-06 | Crawford | Indiana | 18025 | 395 | 3 |
797818 | 797818 | 2020-12-05 | Benton | Indiana | 18007 | 488 | 3 |
797827 | 797827 | 2020-12-05 | Crawford | Indiana | 18025 | 380 | 3 |
794573 | 794573 | 2020-12-04 | Benton | Indiana | 18007 | 465 | 3 |
794582 | 794582 | 2020-12-04 | Crawford | Indiana | 18025 | 373 | 3 |
791328 | 791328 | 2020-12-03 | Benton | Indiana | 18007 | 448 | 3 |
788083 | 788083 | 2020-12-02 | Benton | Indiana | 18007 | 442 | 3 |
784839 | 784839 | 2020-12-01 | Benton | Indiana | 18007 | 411 | 3 |
781594 | 781594 | 2020-11-30 | Benton | Indiana | 18007 | 394 | 3 |
778348 | 778348 | 2020-11-29 | Benton | Indiana | 18007 | 384 | 3 |
775103 | 775103 | 2020-11-28 | Benton | Indiana | 18007 | 370 | 3 |
771858 | 771858 | 2020-11-27 | Benton | Indiana | 18007 | 364 | 3 |
771940 | 771940 | 2020-11-27 | Warren | Indiana | 18171 | 258 | 3 |
768613 | 768613 | 2020-11-26 | Benton | Indiana | 18007 | 355 | 3 |
768695 | 768695 | 2020-11-26 | Warren | Indiana | 18171 | 256 | 3 |
765446 | 765446 | 2020-11-25 | Vermillion | Indiana | 18165 | 625 | 3 |
765449 | 765449 | 2020-11-25 | Warren | Indiana | 18171 | 240 | 3 |
762125 | 762125 | 2020-11-24 | Brown | Indiana | 18013 | 335 | 3 |
762201 | 762201 | 2020-11-24 | Vermillion | Indiana | 18165 | 600 | 3 |
762204 | 762204 | 2020-11-24 | Warren | Indiana | 18171 | 240 | 3 |
758880 | 758880 | 2020-11-23 | Brown | Indiana | 18013 | 326 | 3 |
758951 | 758951 | 2020-11-23 | Switzerland | Indiana | 18155 | 249 | 3 |
758959 | 758959 | 2020-11-23 | Warren | Indiana | 18171 | 237 | 3 |
755633 | 755633 | 2020-11-22 | Brown | Indiana | 18013 | 315 | 3 |
755704 | 755704 | 2020-11-22 | Switzerland | Indiana | 18155 | 247 | 3 |
755712 | 755712 | 2020-11-22 | Warren | Indiana | 18171 | 229 | 3 |
752387 | 752387 | 2020-11-21 | Brown | Indiana | 18013 | 308 | 3 |
752458 | 752458 | 2020-11-21 | Switzerland | Indiana | 18155 | 244 | 3 |
752466 | 752466 | 2020-11-21 | Warren | Indiana | 18171 | 226 | 3 |
749141 | 749141 | 2020-11-20 | Brown | Indiana | 18013 | 302 | 3 |
749212 | 749212 | 2020-11-20 | Switzerland | Indiana | 18155 | 239 | 3 |
749220 | 749220 | 2020-11-20 | Warren | Indiana | 18171 | 218 | 3 |
745895 | 745895 | 2020-11-19 | Brown | Indiana | 18013 | 300 | 3 |
745966 | 745966 | 2020-11-19 | Switzerland | Indiana | 18155 | 233 | 3 |
745974 | 745974 | 2020-11-19 | Warren | Indiana | 18171 | 203 | 3 |
742648 | 742648 | 2020-11-18 | Brown | Indiana | 18013 | 292 | 3 |
742719 | 742719 | 2020-11-18 | Switzerland | Indiana | 18155 | 227 | 3 |
742727 | 742727 | 2020-11-18 | Warren | Indiana | 18171 | 195 | 3 |
739401 | 739401 | 2020-11-17 | Brown | Indiana | 18013 | 285 | 3 |
739480 | 739480 | 2020-11-17 | Warren | Indiana | 18171 | 187 | 3 |
736157 | 736157 | 2020-11-16 | Brown | Indiana | 18013 | 273 | 3 |
736210 | 736210 | 2020-11-16 | Owen | Indiana | 18119 | 471 | 3 |
732911 | 732911 | 2020-11-15 | Brown | Indiana | 18013 | 252 | 3 |
732964 | 732964 | 2020-11-15 | Owen | Indiana | 18119 | 466 | 3 |
729666 | 729666 | 2020-11-14 | Brown | Indiana | 18013 | 242 | 3 |
729719 | 729719 | 2020-11-14 | Owen | Indiana | 18119 | 438 | 3 |
726423 | 726423 | 2020-11-13 | Brown | Indiana | 18013 | 234 | 3 |
726476 | 726476 | 2020-11-13 | Owen | Indiana | 18119 | 421 | 3 |
723180 | 723180 | 2020-11-12 | Brown | Indiana | 18013 | 228 | 3 |
723233 | 723233 | 2020-11-12 | Owen | Indiana | 18119 | 410 | 3 |
719937 | 719937 | 2020-11-11 | Brown | Indiana | 18013 | 223 | 3 |
716694 | 716694 | 2020-11-10 | Brown | Indiana | 18013 | 209 | 3 |
713450 | 713450 | 2020-11-09 | Brown | Indiana | 18013 | 199 | 3 |
710206 | 710206 | 2020-11-08 | Brown | Indiana | 18013 | 186 | 3 |
706962 | 706962 | 2020-11-07 | Brown | Indiana | 18013 | 184 | 3 |
703719 | 703719 | 2020-11-06 | Brown | Indiana | 18013 | 179 | 3 |
700477 | 700477 | 2020-11-05 | Brown | Indiana | 18013 | 172 | 3 |
700558 | 700558 | 2020-11-05 | Washington | Indiana | 18175 | 455 | 3 |
697233 | 697233 | 2020-11-04 | Brown | Indiana | 18013 | 167 | 3 |
697249 | 697249 | 2020-11-04 | Fountain | Indiana | 18045 | 429 | 3 |
697314 | 697314 | 2020-11-04 | Washington | Indiana | 18175 | 447 | 3 |
693991 | 693991 | 2020-11-03 | Brown | Indiana | 18013 | 166 | 3 |
694007 | 694007 | 2020-11-03 | Fountain | Indiana | 18045 | 425 | 3 |
694072 | 694072 | 2020-11-03 | Washington | Indiana | 18175 | 438 | 3 |
690748 | 690748 | 2020-11-02 | Brown | Indiana | 18013 | 162 | 3 |
690764 | 690764 | 2020-11-02 | Fountain | Indiana | 18045 | 410 | 3 |
690829 | 690829 | 2020-11-02 | Washington | Indiana | 18175 | 433 | 3 |
687503 | 687503 | 2020-11-01 | Brown | Indiana | 18013 | 160 | 3 |
687519 | 687519 | 2020-11-01 | Fountain | Indiana | 18045 | 403 | 3 |
687584 | 687584 | 2020-11-01 | Washington | Indiana | 18175 | 428 | 3 |
684259 | 684259 | 2020-10-31 | Brown | Indiana | 18013 | 159 | 3 |
684275 | 684275 | 2020-10-31 | Fountain | Indiana | 18045 | 386 | 3 |
684340 | 684340 | 2020-10-31 | Washington | Indiana | 18175 | 426 | 3 |
681016 | 681016 | 2020-10-30 | Brown | Indiana | 18013 | 156 | 3 |
681032 | 681032 | 2020-10-30 | Fountain | Indiana | 18045 | 363 | 3 |
681097 | 681097 | 2020-10-30 | Washington | Indiana | 18175 | 422 | 3 |
677773 | 677773 | 2020-10-29 | Brown | Indiana | 18013 | 152 | 3 |
677789 | 677789 | 2020-10-29 | Fountain | Indiana | 18045 | 365 | 3 |
677854 | 677854 | 2020-10-29 | Washington | Indiana | 18175 | 414 | 3 |
674530 | 674530 | 2020-10-28 | Brown | Indiana | 18013 | 152 | 3 |
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);