ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Morgan" and fips = 18109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386692 | 386692 | 2020-07-31 | Morgan | Indiana | 18109 | 422 | 35 |
383474 | 383474 | 2020-07-30 | Morgan | Indiana | 18109 | 420 | 35 |
380257 | 380257 | 2020-07-29 | Morgan | Indiana | 18109 | 414 | 34 |
377040 | 377040 | 2020-07-28 | Morgan | Indiana | 18109 | 411 | 34 |
373825 | 373825 | 2020-07-27 | Morgan | Indiana | 18109 | 405 | 34 |
370613 | 370613 | 2020-07-26 | Morgan | Indiana | 18109 | 405 | 34 |
367403 | 367403 | 2020-07-25 | Morgan | Indiana | 18109 | 397 | 34 |
364196 | 364196 | 2020-07-24 | Morgan | Indiana | 18109 | 395 | 34 |
360989 | 360989 | 2020-07-23 | Morgan | Indiana | 18109 | 392 | 34 |
357784 | 357784 | 2020-07-22 | Morgan | Indiana | 18109 | 379 | 34 |
354582 | 354582 | 2020-07-21 | Morgan | Indiana | 18109 | 379 | 34 |
351380 | 351380 | 2020-07-20 | Morgan | Indiana | 18109 | 381 | 34 |
348180 | 348180 | 2020-07-19 | Morgan | Indiana | 18109 | 380 | 34 |
344979 | 344979 | 2020-07-18 | Morgan | Indiana | 18109 | 377 | 34 |
341779 | 341779 | 2020-07-17 | Morgan | Indiana | 18109 | 375 | 34 |
338583 | 338583 | 2020-07-16 | Morgan | Indiana | 18109 | 364 | 34 |
335387 | 335387 | 2020-07-15 | Morgan | Indiana | 18109 | 358 | 34 |
332194 | 332194 | 2020-07-14 | Morgan | Indiana | 18109 | 355 | 34 |
329007 | 329007 | 2020-07-13 | Morgan | Indiana | 18109 | 355 | 34 |
325821 | 325821 | 2020-07-12 | Morgan | Indiana | 18109 | 356 | 34 |
322640 | 322640 | 2020-07-11 | Morgan | Indiana | 18109 | 353 | 34 |
319461 | 319461 | 2020-07-10 | Morgan | Indiana | 18109 | 347 | 34 |
316288 | 316288 | 2020-07-09 | Morgan | Indiana | 18109 | 339 | 34 |
313114 | 313114 | 2020-07-08 | Morgan | Indiana | 18109 | 338 | 34 |
309944 | 309944 | 2020-07-07 | Morgan | Indiana | 18109 | 340 | 34 |
306776 | 306776 | 2020-07-06 | Morgan | Indiana | 18109 | 340 | 34 |
303611 | 303611 | 2020-07-05 | Morgan | Indiana | 18109 | 340 | 34 |
300447 | 300447 | 2020-07-04 | Morgan | Indiana | 18109 | 338 | 34 |
297285 | 297285 | 2020-07-03 | Morgan | Indiana | 18109 | 336 | 35 |
294127 | 294127 | 2020-07-02 | Morgan | Indiana | 18109 | 333 | 34 |
290973 | 290973 | 2020-07-01 | Morgan | Indiana | 18109 | 330 | 34 |
287823 | 287823 | 2020-06-30 | Morgan | Indiana | 18109 | 328 | 34 |
284674 | 284674 | 2020-06-29 | Morgan | Indiana | 18109 | 326 | 34 |
281529 | 281529 | 2020-06-28 | Morgan | Indiana | 18109 | 324 | 34 |
278381 | 278381 | 2020-06-27 | Morgan | Indiana | 18109 | 323 | 34 |
275233 | 275233 | 2020-06-26 | Morgan | Indiana | 18109 | 319 | 34 |
272091 | 272091 | 2020-06-25 | Morgan | Indiana | 18109 | 318 | 33 |
268954 | 268954 | 2020-06-24 | Morgan | Indiana | 18109 | 317 | 33 |
265824 | 265824 | 2020-06-23 | Morgan | Indiana | 18109 | 314 | 32 |
262696 | 262696 | 2020-06-22 | Morgan | Indiana | 18109 | 314 | 32 |
259569 | 259569 | 2020-06-21 | Morgan | Indiana | 18109 | 315 | 32 |
256443 | 256443 | 2020-06-20 | Morgan | Indiana | 18109 | 313 | 32 |
253323 | 253323 | 2020-06-19 | Morgan | Indiana | 18109 | 310 | 32 |
250208 | 250208 | 2020-06-18 | Morgan | Indiana | 18109 | 310 | 32 |
247096 | 247096 | 2020-06-17 | Morgan | Indiana | 18109 | 309 | 32 |
243983 | 243983 | 2020-06-16 | Morgan | Indiana | 18109 | 309 | 31 |
240872 | 240872 | 2020-06-15 | Morgan | Indiana | 18109 | 308 | 31 |
237764 | 237764 | 2020-06-14 | Morgan | Indiana | 18109 | 307 | 31 |
234657 | 234657 | 2020-06-13 | Morgan | Indiana | 18109 | 306 | 31 |
231551 | 231551 | 2020-06-12 | Morgan | Indiana | 18109 | 305 | 30 |
228448 | 228448 | 2020-06-11 | Morgan | Indiana | 18109 | 303 | 30 |
225346 | 225346 | 2020-06-10 | Morgan | Indiana | 18109 | 303 | 30 |
222251 | 222251 | 2020-06-09 | Morgan | Indiana | 18109 | 303 | 30 |
219156 | 219156 | 2020-06-08 | Morgan | Indiana | 18109 | 300 | 30 |
216064 | 216064 | 2020-06-07 | Morgan | Indiana | 18109 | 299 | 30 |
212977 | 212977 | 2020-06-06 | Morgan | Indiana | 18109 | 296 | 30 |
209892 | 209892 | 2020-06-05 | Morgan | Indiana | 18109 | 295 | 28 |
206811 | 206811 | 2020-06-04 | Morgan | Indiana | 18109 | 293 | 28 |
203731 | 203731 | 2020-06-03 | Morgan | Indiana | 18109 | 292 | 26 |
200655 | 200655 | 2020-06-02 | Morgan | Indiana | 18109 | 290 | 26 |
197582 | 197582 | 2020-06-01 | Morgan | Indiana | 18109 | 289 | 26 |
194512 | 194512 | 2020-05-31 | Morgan | Indiana | 18109 | 286 | 26 |
191445 | 191445 | 2020-05-30 | Morgan | Indiana | 18109 | 287 | 26 |
188380 | 188380 | 2020-05-29 | Morgan | Indiana | 18109 | 286 | 26 |
185322 | 185322 | 2020-05-28 | Morgan | Indiana | 18109 | 285 | 26 |
182268 | 182268 | 2020-05-27 | Morgan | Indiana | 18109 | 278 | 26 |
179224 | 179224 | 2020-05-26 | Morgan | Indiana | 18109 | 270 | 26 |
176180 | 176180 | 2020-05-25 | Morgan | Indiana | 18109 | 269 | 26 |
173136 | 173136 | 2020-05-24 | Morgan | Indiana | 18109 | 266 | 26 |
170095 | 170095 | 2020-05-23 | Morgan | Indiana | 18109 | 265 | 26 |
167058 | 167058 | 2020-05-22 | Morgan | Indiana | 18109 | 261 | 24 |
164025 | 164025 | 2020-05-21 | Morgan | Indiana | 18109 | 259 | 24 |
160997 | 160997 | 2020-05-20 | Morgan | Indiana | 18109 | 258 | 23 |
157971 | 157971 | 2020-05-19 | Morgan | Indiana | 18109 | 257 | 23 |
154955 | 154955 | 2020-05-18 | Morgan | Indiana | 18109 | 254 | 21 |
151943 | 151943 | 2020-05-17 | Morgan | Indiana | 18109 | 251 | 21 |
148934 | 148934 | 2020-05-16 | Morgan | Indiana | 18109 | 248 | 19 |
145930 | 145930 | 2020-05-15 | Morgan | Indiana | 18109 | 247 | 16 |
142930 | 142930 | 2020-05-14 | Morgan | Indiana | 18109 | 231 | 14 |
139934 | 139934 | 2020-05-13 | Morgan | Indiana | 18109 | 229 | 14 |
136942 | 136942 | 2020-05-12 | Morgan | Indiana | 18109 | 213 | 10 |
133953 | 133953 | 2020-05-11 | Morgan | Indiana | 18109 | 211 | 9 |
130963 | 130963 | 2020-05-10 | Morgan | Indiana | 18109 | 200 | 9 |
127972 | 127972 | 2020-05-09 | Morgan | Indiana | 18109 | 197 | 9 |
124985 | 124985 | 2020-05-08 | Morgan | Indiana | 18109 | 185 | 9 |
122005 | 122005 | 2020-05-07 | Morgan | Indiana | 18109 | 186 | 9 |
119035 | 119035 | 2020-05-06 | Morgan | Indiana | 18109 | 179 | 9 |
116075 | 116075 | 2020-05-05 | Morgan | Indiana | 18109 | 174 | 8 |
113192 | 113192 | 2020-05-04 | Morgan | Indiana | 18109 | 171 | 8 |
110317 | 110317 | 2020-05-03 | Morgan | Indiana | 18109 | 166 | 7 |
107447 | 107447 | 2020-05-02 | Morgan | Indiana | 18109 | 163 | 6 |
104582 | 104582 | 2020-05-01 | Morgan | Indiana | 18109 | 159 | 6 |
101726 | 101726 | 2020-04-30 | Morgan | Indiana | 18109 | 155 | 5 |
98875 | 98875 | 2020-04-29 | Morgan | Indiana | 18109 | 142 | 5 |
96031 | 96031 | 2020-04-28 | Morgan | Indiana | 18109 | 137 | 4 |
93199 | 93199 | 2020-04-27 | Morgan | Indiana | 18109 | 133 | 4 |
90380 | 90380 | 2020-04-26 | Morgan | Indiana | 18109 | 132 | 5 |
87564 | 87564 | 2020-04-25 | Morgan | Indiana | 18109 | 134 | 4 |
84754 | 84754 | 2020-04-24 | Morgan | Indiana | 18109 | 129 | 5 |
81954 | 81954 | 2020-04-23 | Morgan | Indiana | 18109 | 126 | 5 |
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);