ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 18091 and state = "Indiana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2054 | 2054 | 2020-03-14 | LaPorte | Indiana | 18091 | 1 | 0 |
2448 | 2448 | 2020-03-15 | LaPorte | Indiana | 18091 | 1 | 0 |
2893 | 2893 | 2020-03-16 | LaPorte | Indiana | 18091 | 1 | 0 |
3383 | 3383 | 2020-03-17 | LaPorte | Indiana | 18091 | 1 | 0 |
3956 | 3956 | 2020-03-18 | LaPorte | Indiana | 18091 | 1 | 0 |
4632 | 4632 | 2020-03-19 | LaPorte | Indiana | 18091 | 1 | 0 |
5440 | 5440 | 2020-03-20 | LaPorte | Indiana | 18091 | 1 | 0 |
6379 | 6379 | 2020-03-21 | LaPorte | Indiana | 18091 | 2 | 0 |
7433 | 7433 | 2020-03-22 | LaPorte | Indiana | 18091 | 2 | 0 |
8591 | 8591 | 2020-03-23 | LaPorte | Indiana | 18091 | 2 | 0 |
9860 | 9860 | 2020-03-24 | LaPorte | Indiana | 18091 | 2 | 0 |
11255 | 11255 | 2020-03-25 | LaPorte | Indiana | 18091 | 2 | 0 |
12812 | 12812 | 2020-03-26 | LaPorte | Indiana | 18091 | 2 | 0 |
14497 | 14497 | 2020-03-27 | LaPorte | Indiana | 18091 | 2 | 0 |
16295 | 16295 | 2020-03-28 | LaPorte | Indiana | 18091 | 4 | 0 |
18199 | 18199 | 2020-03-29 | LaPorte | Indiana | 18091 | 6 | 0 |
20205 | 20205 | 2020-03-30 | LaPorte | Indiana | 18091 | 6 | 0 |
22300 | 22300 | 2020-03-31 | LaPorte | Indiana | 18091 | 8 | 0 |
24471 | 24471 | 2020-04-01 | LaPorte | Indiana | 18091 | 11 | 0 |
26710 | 26710 | 2020-04-02 | LaPorte | Indiana | 18091 | 14 | 1 |
29020 | 29020 | 2020-04-03 | LaPorte | Indiana | 18091 | 17 | 1 |
31386 | 31386 | 2020-04-04 | LaPorte | Indiana | 18091 | 19 | 2 |
33797 | 33797 | 2020-04-05 | LaPorte | Indiana | 18091 | 21 | 2 |
36250 | 36250 | 2020-04-06 | LaPorte | Indiana | 18091 | 21 | 3 |
38748 | 38748 | 2020-04-07 | LaPorte | Indiana | 18091 | 25 | 3 |
41294 | 41294 | 2020-04-08 | LaPorte | Indiana | 18091 | 28 | 3 |
43870 | 43870 | 2020-04-09 | LaPorte | Indiana | 18091 | 30 | 3 |
46474 | 46474 | 2020-04-10 | LaPorte | Indiana | 18091 | 31 | 3 |
49108 | 49108 | 2020-04-11 | LaPorte | Indiana | 18091 | 31 | 3 |
51771 | 51771 | 2020-04-12 | LaPorte | Indiana | 18091 | 33 | 3 |
54452 | 54452 | 2020-04-13 | LaPorte | Indiana | 18091 | 34 | 3 |
57145 | 57145 | 2020-04-14 | LaPorte | Indiana | 18091 | 36 | 3 |
59853 | 59853 | 2020-04-15 | LaPorte | Indiana | 18091 | 42 | 4 |
62574 | 62574 | 2020-04-16 | LaPorte | Indiana | 18091 | 112 | 5 |
65308 | 65308 | 2020-04-17 | LaPorte | Indiana | 18091 | 129 | 5 |
68057 | 68057 | 2020-04-18 | LaPorte | Indiana | 18091 | 134 | 5 |
70819 | 70819 | 2020-04-19 | LaPorte | Indiana | 18091 | 140 | 5 |
73590 | 73590 | 2020-04-20 | LaPorte | Indiana | 18091 | 140 | 5 |
76367 | 76367 | 2020-04-21 | LaPorte | Indiana | 18091 | 140 | 5 |
79151 | 79151 | 2020-04-22 | LaPorte | Indiana | 18091 | 144 | 5 |
81944 | 81944 | 2020-04-23 | LaPorte | Indiana | 18091 | 148 | 5 |
84744 | 84744 | 2020-04-24 | LaPorte | Indiana | 18091 | 149 | 5 |
87554 | 87554 | 2020-04-25 | LaPorte | Indiana | 18091 | 156 | 5 |
90370 | 90370 | 2020-04-26 | LaPorte | Indiana | 18091 | 188 | 5 |
93189 | 93189 | 2020-04-27 | LaPorte | Indiana | 18091 | 192 | 5 |
96021 | 96021 | 2020-04-28 | LaPorte | Indiana | 18091 | 199 | 5 |
98865 | 98865 | 2020-04-29 | LaPorte | Indiana | 18091 | 209 | 5 |
101716 | 101716 | 2020-04-30 | LaPorte | Indiana | 18091 | 218 | 5 |
104572 | 104572 | 2020-05-01 | LaPorte | Indiana | 18091 | 224 | 6 |
107437 | 107437 | 2020-05-02 | LaPorte | Indiana | 18091 | 229 | 7 |
110307 | 110307 | 2020-05-03 | LaPorte | Indiana | 18091 | 251 | 8 |
113182 | 113182 | 2020-05-04 | LaPorte | Indiana | 18091 | 254 | 8 |
116065 | 116065 | 2020-05-05 | LaPorte | Indiana | 18091 | 268 | 8 |
119025 | 119025 | 2020-05-06 | LaPorte | Indiana | 18091 | 284 | 9 |
121995 | 121995 | 2020-05-07 | LaPorte | Indiana | 18091 | 303 | 10 |
124975 | 124975 | 2020-05-08 | LaPorte | Indiana | 18091 | 307 | 11 |
127962 | 127962 | 2020-05-09 | LaPorte | Indiana | 18091 | 321 | 11 |
130953 | 130953 | 2020-05-10 | LaPorte | Indiana | 18091 | 324 | 11 |
133943 | 133943 | 2020-05-11 | LaPorte | Indiana | 18091 | 329 | 12 |
136932 | 136932 | 2020-05-12 | LaPorte | Indiana | 18091 | 335 | 12 |
139924 | 139924 | 2020-05-13 | LaPorte | Indiana | 18091 | 340 | 12 |
142920 | 142920 | 2020-05-14 | LaPorte | Indiana | 18091 | 346 | 13 |
145920 | 145920 | 2020-05-15 | LaPorte | Indiana | 18091 | 352 | 14 |
148924 | 148924 | 2020-05-16 | LaPorte | Indiana | 18091 | 355 | 14 |
151933 | 151933 | 2020-05-17 | LaPorte | Indiana | 18091 | 358 | 14 |
154945 | 154945 | 2020-05-18 | LaPorte | Indiana | 18091 | 360 | 16 |
157961 | 157961 | 2020-05-19 | LaPorte | Indiana | 18091 | 360 | 16 |
160987 | 160987 | 2020-05-20 | LaPorte | Indiana | 18091 | 366 | 16 |
164015 | 164015 | 2020-05-21 | LaPorte | Indiana | 18091 | 374 | 17 |
167048 | 167048 | 2020-05-22 | LaPorte | Indiana | 18091 | 377 | 20 |
170085 | 170085 | 2020-05-23 | LaPorte | Indiana | 18091 | 388 | 21 |
173126 | 173126 | 2020-05-24 | LaPorte | Indiana | 18091 | 400 | 21 |
176170 | 176170 | 2020-05-25 | LaPorte | Indiana | 18091 | 409 | 21 |
179214 | 179214 | 2020-05-26 | LaPorte | Indiana | 18091 | 416 | 22 |
185312 | 185312 | 2020-05-28 | LaPorte | Indiana | 18091 | 421 | 22 |
182258 | 182258 | 2020-05-27 | LaPorte | Indiana | 18091 | 416 | 23 |
188370 | 188370 | 2020-05-29 | LaPorte | Indiana | 18091 | 425 | 23 |
191435 | 191435 | 2020-05-30 | LaPorte | Indiana | 18091 | 431 | 23 |
194502 | 194502 | 2020-05-31 | LaPorte | Indiana | 18091 | 434 | 23 |
197572 | 197572 | 2020-06-01 | LaPorte | Indiana | 18091 | 439 | 24 |
200645 | 200645 | 2020-06-02 | LaPorte | Indiana | 18091 | 435 | 24 |
203721 | 203721 | 2020-06-03 | LaPorte | Indiana | 18091 | 437 | 24 |
206801 | 206801 | 2020-06-04 | LaPorte | Indiana | 18091 | 447 | 24 |
209882 | 209882 | 2020-06-05 | LaPorte | Indiana | 18091 | 449 | 24 |
212967 | 212967 | 2020-06-06 | LaPorte | Indiana | 18091 | 456 | 24 |
216054 | 216054 | 2020-06-07 | LaPorte | Indiana | 18091 | 458 | 24 |
219146 | 219146 | 2020-06-08 | LaPorte | Indiana | 18091 | 461 | 24 |
222241 | 222241 | 2020-06-09 | LaPorte | Indiana | 18091 | 463 | 24 |
225336 | 225336 | 2020-06-10 | LaPorte | Indiana | 18091 | 464 | 24 |
228438 | 228438 | 2020-06-11 | LaPorte | Indiana | 18091 | 466 | 24 |
231541 | 231541 | 2020-06-12 | LaPorte | Indiana | 18091 | 466 | 24 |
234647 | 234647 | 2020-06-13 | LaPorte | Indiana | 18091 | 468 | 24 |
237754 | 237754 | 2020-06-14 | LaPorte | Indiana | 18091 | 471 | 24 |
240862 | 240862 | 2020-06-15 | LaPorte | Indiana | 18091 | 471 | 24 |
243973 | 243973 | 2020-06-16 | LaPorte | Indiana | 18091 | 472 | 24 |
247086 | 247086 | 2020-06-17 | LaPorte | Indiana | 18091 | 474 | 25 |
250198 | 250198 | 2020-06-18 | LaPorte | Indiana | 18091 | 480 | 25 |
253313 | 253313 | 2020-06-19 | LaPorte | Indiana | 18091 | 483 | 25 |
256433 | 256433 | 2020-06-20 | LaPorte | Indiana | 18091 | 484 | 25 |
259559 | 259559 | 2020-06-21 | LaPorte | Indiana | 18091 | 487 | 25 |
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);