ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,399 rows where deaths = 1 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Warren 231
- Crawford 172
- Washington 146
- Pulaski 139
- Owen 133
- Brown 127
- Fulton 93
- Sullivan 92
- Jasper 88
- Spencer 87
- Adams 66
- Jefferson 51
- Miami 49
- Blackford 42
- Clay 41
- Pike 41
- Tipton 41
- Whitley 40
- Marshall 39
- Wells 37
- Rush 32
- Steuben 31
- Vanderburgh 27
- Vermillion 27
- Parke 25
- Carroll 24
- Benton 23
- Perry 22
- Delaware 21
- Henry 20
- …
state 1
- Indiana · 2,399 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
762199 | 762199 | 2020-11-24 | Union | Indiana | 18161 | 296 | 1 |
758877 | 758877 | 2020-11-23 | Benton | Indiana | 18007 | 325 | 1 |
758954 | 758954 | 2020-11-23 | Union | Indiana | 18161 | 291 | 1 |
755630 | 755630 | 2020-11-22 | Benton | Indiana | 18007 | 310 | 1 |
755707 | 755707 | 2020-11-22 | Union | Indiana | 18161 | 284 | 1 |
752384 | 752384 | 2020-11-21 | Benton | Indiana | 18007 | 302 | 1 |
752461 | 752461 | 2020-11-21 | Union | Indiana | 18161 | 280 | 1 |
749138 | 749138 | 2020-11-20 | Benton | Indiana | 18007 | 297 | 1 |
749215 | 749215 | 2020-11-20 | Union | Indiana | 18161 | 277 | 1 |
745892 | 745892 | 2020-11-19 | Benton | Indiana | 18007 | 292 | 1 |
745969 | 745969 | 2020-11-19 | Union | Indiana | 18161 | 267 | 1 |
742645 | 742645 | 2020-11-18 | Benton | Indiana | 18007 | 262 | 1 |
742722 | 742722 | 2020-11-18 | Union | Indiana | 18161 | 264 | 1 |
739398 | 739398 | 2020-11-17 | Benton | Indiana | 18007 | 253 | 1 |
739472 | 739472 | 2020-11-17 | Switzerland | Indiana | 18155 | 219 | 1 |
739475 | 739475 | 2020-11-17 | Union | Indiana | 18161 | 260 | 1 |
736154 | 736154 | 2020-11-16 | Benton | Indiana | 18007 | 249 | 1 |
736228 | 736228 | 2020-11-16 | Switzerland | Indiana | 18155 | 210 | 1 |
736231 | 736231 | 2020-11-16 | Union | Indiana | 18161 | 256 | 1 |
736236 | 736236 | 2020-11-16 | Warren | Indiana | 18171 | 180 | 1 |
732908 | 732908 | 2020-11-15 | Benton | Indiana | 18007 | 241 | 1 |
732982 | 732982 | 2020-11-15 | Switzerland | Indiana | 18155 | 207 | 1 |
732985 | 732985 | 2020-11-15 | Union | Indiana | 18161 | 251 | 1 |
732990 | 732990 | 2020-11-15 | Warren | Indiana | 18171 | 176 | 1 |
729663 | 729663 | 2020-11-14 | Benton | Indiana | 18007 | 217 | 1 |
729737 | 729737 | 2020-11-14 | Switzerland | Indiana | 18155 | 203 | 1 |
729740 | 729740 | 2020-11-14 | Union | Indiana | 18161 | 245 | 1 |
729745 | 729745 | 2020-11-14 | Warren | Indiana | 18171 | 175 | 1 |
726420 | 726420 | 2020-11-13 | Benton | Indiana | 18007 | 193 | 1 |
726494 | 726494 | 2020-11-13 | Switzerland | Indiana | 18155 | 190 | 1 |
726497 | 726497 | 2020-11-13 | Union | Indiana | 18161 | 232 | 1 |
726502 | 726502 | 2020-11-13 | Warren | Indiana | 18171 | 167 | 1 |
723177 | 723177 | 2020-11-12 | Benton | Indiana | 18007 | 195 | 1 |
723251 | 723251 | 2020-11-12 | Switzerland | Indiana | 18155 | 189 | 1 |
723254 | 723254 | 2020-11-12 | Union | Indiana | 18161 | 227 | 1 |
723259 | 723259 | 2020-11-12 | Warren | Indiana | 18171 | 162 | 1 |
719934 | 719934 | 2020-11-11 | Benton | Indiana | 18007 | 175 | 1 |
720008 | 720008 | 2020-11-11 | Switzerland | Indiana | 18155 | 171 | 1 |
720011 | 720011 | 2020-11-11 | Union | Indiana | 18161 | 217 | 1 |
720016 | 720016 | 2020-11-11 | Warren | Indiana | 18171 | 153 | 1 |
716691 | 716691 | 2020-11-10 | Benton | Indiana | 18007 | 167 | 1 |
716765 | 716765 | 2020-11-10 | Switzerland | Indiana | 18155 | 166 | 1 |
716773 | 716773 | 2020-11-10 | Warren | Indiana | 18171 | 150 | 1 |
713447 | 713447 | 2020-11-09 | Benton | Indiana | 18007 | 160 | 1 |
713521 | 713521 | 2020-11-09 | Switzerland | Indiana | 18155 | 158 | 1 |
713529 | 713529 | 2020-11-09 | Warren | Indiana | 18171 | 149 | 1 |
710203 | 710203 | 2020-11-08 | Benton | Indiana | 18007 | 152 | 1 |
710285 | 710285 | 2020-11-08 | Warren | Indiana | 18171 | 147 | 1 |
706959 | 706959 | 2020-11-07 | Benton | Indiana | 18007 | 142 | 1 |
707041 | 707041 | 2020-11-07 | Warren | Indiana | 18171 | 144 | 1 |
703716 | 703716 | 2020-11-06 | Benton | Indiana | 18007 | 135 | 1 |
703798 | 703798 | 2020-11-06 | Warren | Indiana | 18171 | 139 | 1 |
700474 | 700474 | 2020-11-05 | Benton | Indiana | 18007 | 132 | 1 |
700556 | 700556 | 2020-11-05 | Warren | Indiana | 18171 | 133 | 1 |
697230 | 697230 | 2020-11-04 | Benton | Indiana | 18007 | 131 | 1 |
697312 | 697312 | 2020-11-04 | Warren | Indiana | 18171 | 127 | 1 |
693988 | 693988 | 2020-11-03 | Benton | Indiana | 18007 | 127 | 1 |
694070 | 694070 | 2020-11-03 | Warren | Indiana | 18171 | 124 | 1 |
690745 | 690745 | 2020-11-02 | Benton | Indiana | 18007 | 124 | 1 |
690824 | 690824 | 2020-11-02 | Vermillion | Indiana | 18165 | 311 | 1 |
690827 | 690827 | 2020-11-02 | Warren | Indiana | 18171 | 117 | 1 |
687500 | 687500 | 2020-11-01 | Benton | Indiana | 18007 | 123 | 1 |
687579 | 687579 | 2020-11-01 | Vermillion | Indiana | 18165 | 307 | 1 |
687582 | 687582 | 2020-11-01 | Warren | Indiana | 18171 | 116 | 1 |
684335 | 684335 | 2020-10-31 | Vermillion | Indiana | 18165 | 301 | 1 |
684338 | 684338 | 2020-10-31 | Warren | Indiana | 18171 | 116 | 1 |
681092 | 681092 | 2020-10-30 | Vermillion | Indiana | 18165 | 296 | 1 |
681095 | 681095 | 2020-10-30 | Warren | Indiana | 18171 | 109 | 1 |
677849 | 677849 | 2020-10-29 | Vermillion | Indiana | 18165 | 292 | 1 |
677852 | 677852 | 2020-10-29 | Warren | Indiana | 18171 | 103 | 1 |
674606 | 674606 | 2020-10-28 | Vermillion | Indiana | 18165 | 288 | 1 |
674609 | 674609 | 2020-10-28 | Warren | Indiana | 18171 | 103 | 1 |
671364 | 671364 | 2020-10-27 | Vermillion | Indiana | 18165 | 277 | 1 |
671367 | 671367 | 2020-10-27 | Warren | Indiana | 18171 | 93 | 1 |
668121 | 668121 | 2020-10-26 | Vermillion | Indiana | 18165 | 273 | 1 |
668124 | 668124 | 2020-10-26 | Warren | Indiana | 18171 | 92 | 1 |
664877 | 664877 | 2020-10-25 | Vermillion | Indiana | 18165 | 269 | 1 |
664880 | 664880 | 2020-10-25 | Warren | Indiana | 18171 | 90 | 1 |
661632 | 661632 | 2020-10-24 | Vermillion | Indiana | 18165 | 261 | 1 |
661635 | 661635 | 2020-10-24 | Warren | Indiana | 18171 | 90 | 1 |
658388 | 658388 | 2020-10-23 | Vermillion | Indiana | 18165 | 254 | 1 |
658391 | 658391 | 2020-10-23 | Warren | Indiana | 18171 | 85 | 1 |
655126 | 655126 | 2020-10-22 | Pulaski | Indiana | 18131 | 154 | 1 |
655143 | 655143 | 2020-10-22 | Vermillion | Indiana | 18165 | 242 | 1 |
655146 | 655146 | 2020-10-22 | Warren | Indiana | 18171 | 79 | 1 |
651881 | 651881 | 2020-10-21 | Pulaski | Indiana | 18131 | 150 | 1 |
651898 | 651898 | 2020-10-21 | Vermillion | Indiana | 18165 | 226 | 1 |
651901 | 651901 | 2020-10-21 | Warren | Indiana | 18171 | 77 | 1 |
648637 | 648637 | 2020-10-20 | Pulaski | Indiana | 18131 | 149 | 1 |
648654 | 648654 | 2020-10-20 | Vermillion | Indiana | 18165 | 219 | 1 |
648657 | 648657 | 2020-10-20 | Warren | Indiana | 18171 | 76 | 1 |
645392 | 645392 | 2020-10-19 | Pulaski | Indiana | 18131 | 145 | 1 |
645409 | 645409 | 2020-10-19 | Vermillion | Indiana | 18165 | 212 | 1 |
645412 | 645412 | 2020-10-19 | Warren | Indiana | 18171 | 74 | 1 |
642145 | 642145 | 2020-10-18 | Pulaski | Indiana | 18131 | 142 | 1 |
642162 | 642162 | 2020-10-18 | Vermillion | Indiana | 18165 | 204 | 1 |
642165 | 642165 | 2020-10-18 | Warren | Indiana | 18171 | 73 | 1 |
638898 | 638898 | 2020-10-17 | Pulaski | Indiana | 18131 | 141 | 1 |
638915 | 638915 | 2020-10-17 | Vermillion | Indiana | 18165 | 197 | 1 |
638918 | 638918 | 2020-10-17 | Warren | Indiana | 18171 | 73 | 1 |
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);