ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lake" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535169 | 535169 | 2020-09-15 | Lake | Indiana | 18089 | 10000 | 327 |
531934 | 531934 | 2020-09-14 | Lake | Indiana | 18089 | 9963 | 326 |
528697 | 528697 | 2020-09-13 | Lake | Indiana | 18089 | 9913 | 326 |
525461 | 525461 | 2020-09-12 | Lake | Indiana | 18089 | 9852 | 326 |
522225 | 522225 | 2020-09-11 | Lake | Indiana | 18089 | 9793 | 325 |
518988 | 518988 | 2020-09-10 | Lake | Indiana | 18089 | 9709 | 322 |
515753 | 515753 | 2020-09-09 | Lake | Indiana | 18089 | 9662 | 319 |
512520 | 512520 | 2020-09-08 | Lake | Indiana | 18089 | 9628 | 317 |
509287 | 509287 | 2020-09-07 | Lake | Indiana | 18089 | 9604 | 316 |
506055 | 506055 | 2020-09-06 | Lake | Indiana | 18089 | 9546 | 316 |
502821 | 502821 | 2020-09-05 | Lake | Indiana | 18089 | 9490 | 316 |
499587 | 499587 | 2020-09-04 | Lake | Indiana | 18089 | 9406 | 316 |
496354 | 496354 | 2020-09-03 | Lake | Indiana | 18089 | 9335 | 316 |
493120 | 493120 | 2020-09-02 | Lake | Indiana | 18089 | 9266 | 316 |
489887 | 489887 | 2020-09-01 | Lake | Indiana | 18089 | 9233 | 315 |
486654 | 486654 | 2020-08-31 | Lake | Indiana | 18089 | 9203 | 314 |
483419 | 483419 | 2020-08-30 | Lake | Indiana | 18089 | 9135 | 314 |
480185 | 480185 | 2020-08-29 | Lake | Indiana | 18089 | 9084 | 313 |
476952 | 476952 | 2020-08-28 | Lake | Indiana | 18089 | 9005 | 312 |
473719 | 473719 | 2020-08-27 | Lake | Indiana | 18089 | 8932 | 311 |
470487 | 470487 | 2020-08-26 | Lake | Indiana | 18089 | 8859 | 311 |
467258 | 467258 | 2020-08-25 | Lake | Indiana | 18089 | 8804 | 310 |
464029 | 464029 | 2020-08-24 | Lake | Indiana | 18089 | 8760 | 310 |
460800 | 460800 | 2020-08-23 | Lake | Indiana | 18089 | 8653 | 310 |
457573 | 457573 | 2020-08-22 | Lake | Indiana | 18089 | 8583 | 308 |
454345 | 454345 | 2020-08-21 | Lake | Indiana | 18089 | 8497 | 306 |
451117 | 451117 | 2020-08-20 | Lake | Indiana | 18089 | 8415 | 305 |
447889 | 447889 | 2020-08-19 | Lake | Indiana | 18089 | 8357 | 304 |
444662 | 444662 | 2020-08-18 | Lake | Indiana | 18089 | 8316 | 303 |
441436 | 441436 | 2020-08-17 | Lake | Indiana | 18089 | 8231 | 301 |
438210 | 438210 | 2020-08-16 | Lake | Indiana | 18089 | 8147 | 300 |
434984 | 434984 | 2020-08-15 | Lake | Indiana | 18089 | 8083 | 300 |
431759 | 431759 | 2020-08-14 | Lake | Indiana | 18089 | 8003 | 300 |
428531 | 428531 | 2020-08-13 | Lake | Indiana | 18089 | 7888 | 300 |
425307 | 425307 | 2020-08-12 | Lake | Indiana | 18089 | 7789 | 298 |
422086 | 422086 | 2020-08-11 | Lake | Indiana | 18089 | 7732 | 294 |
418863 | 418863 | 2020-08-10 | Lake | Indiana | 18089 | 7674 | 291 |
415642 | 415642 | 2020-08-09 | Lake | Indiana | 18089 | 7613 | 291 |
412422 | 412422 | 2020-08-08 | Lake | Indiana | 18089 | 7538 | 291 |
409203 | 409203 | 2020-08-07 | Lake | Indiana | 18089 | 7489 | 290 |
405983 | 405983 | 2020-08-06 | Lake | Indiana | 18089 | 7385 | 290 |
402765 | 402765 | 2020-08-05 | Lake | Indiana | 18089 | 7264 | 289 |
399549 | 399549 | 2020-08-04 | Lake | Indiana | 18089 | 7182 | 289 |
396333 | 396333 | 2020-08-03 | Lake | Indiana | 18089 | 7144 | 287 |
393117 | 393117 | 2020-08-02 | Lake | Indiana | 18089 | 7080 | 285 |
389900 | 389900 | 2020-08-01 | Lake | Indiana | 18089 | 7037 | 285 |
386683 | 386683 | 2020-07-31 | Lake | Indiana | 18089 | 6977 | 283 |
383465 | 383465 | 2020-07-30 | Lake | Indiana | 18089 | 6919 | 282 |
380248 | 380248 | 2020-07-29 | Lake | Indiana | 18089 | 6861 | 282 |
377031 | 377031 | 2020-07-28 | Lake | Indiana | 18089 | 6829 | 282 |
373816 | 373816 | 2020-07-27 | Lake | Indiana | 18089 | 6769 | 281 |
370604 | 370604 | 2020-07-26 | Lake | Indiana | 18089 | 6716 | 281 |
367394 | 367394 | 2020-07-25 | Lake | Indiana | 18089 | 6628 | 281 |
364187 | 364187 | 2020-07-24 | Lake | Indiana | 18089 | 6564 | 276 |
360980 | 360980 | 2020-07-23 | Lake | Indiana | 18089 | 6507 | 275 |
357775 | 357775 | 2020-07-22 | Lake | Indiana | 18089 | 6418 | 274 |
354573 | 354573 | 2020-07-21 | Lake | Indiana | 18089 | 6316 | 272 |
351371 | 351371 | 2020-07-20 | Lake | Indiana | 18089 | 6262 | 270 |
348171 | 348171 | 2020-07-19 | Lake | Indiana | 18089 | 6184 | 270 |
344970 | 344970 | 2020-07-18 | Lake | Indiana | 18089 | 6122 | 270 |
341770 | 341770 | 2020-07-17 | Lake | Indiana | 18089 | 6022 | 268 |
338574 | 338574 | 2020-07-16 | Lake | Indiana | 18089 | 5958 | 268 |
335378 | 335378 | 2020-07-15 | Lake | Indiana | 18089 | 5870 | 268 |
332185 | 332185 | 2020-07-14 | Lake | Indiana | 18089 | 5803 | 267 |
328998 | 328998 | 2020-07-13 | Lake | Indiana | 18089 | 5716 | 265 |
325812 | 325812 | 2020-07-12 | Lake | Indiana | 18089 | 5689 | 265 |
322631 | 322631 | 2020-07-11 | Lake | Indiana | 18089 | 5627 | 264 |
319452 | 319452 | 2020-07-10 | Lake | Indiana | 18089 | 5471 | 264 |
316279 | 316279 | 2020-07-09 | Lake | Indiana | 18089 | 5376 | 263 |
313105 | 313105 | 2020-07-08 | Lake | Indiana | 18089 | 5315 | 262 |
309935 | 309935 | 2020-07-07 | Lake | Indiana | 18089 | 5251 | 260 |
306767 | 306767 | 2020-07-06 | Lake | Indiana | 18089 | 5219 | 258 |
303602 | 303602 | 2020-07-05 | Lake | Indiana | 18089 | 5184 | 258 |
300438 | 300438 | 2020-07-04 | Lake | Indiana | 18089 | 5142 | 258 |
297276 | 297276 | 2020-07-03 | Lake | Indiana | 18089 | 5091 | 258 |
294118 | 294118 | 2020-07-02 | Lake | Indiana | 18089 | 5023 | 257 |
290964 | 290964 | 2020-07-01 | Lake | Indiana | 18089 | 4910 | 256 |
287814 | 287814 | 2020-06-30 | Lake | Indiana | 18089 | 4884 | 255 |
284665 | 284665 | 2020-06-29 | Lake | Indiana | 18089 | 4818 | 255 |
281520 | 281520 | 2020-06-28 | Lake | Indiana | 18089 | 4778 | 255 |
278372 | 278372 | 2020-06-27 | Lake | Indiana | 18089 | 4733 | 255 |
275224 | 275224 | 2020-06-26 | Lake | Indiana | 18089 | 4687 | 254 |
272082 | 272082 | 2020-06-25 | Lake | Indiana | 18089 | 4633 | 254 |
268945 | 268945 | 2020-06-24 | Lake | Indiana | 18089 | 4562 | 254 |
265815 | 265815 | 2020-06-23 | Lake | Indiana | 18089 | 4526 | 254 |
262687 | 262687 | 2020-06-22 | Lake | Indiana | 18089 | 4473 | 250 |
259560 | 259560 | 2020-06-21 | Lake | Indiana | 18089 | 4436 | 249 |
256434 | 256434 | 2020-06-20 | Lake | Indiana | 18089 | 4392 | 249 |
253314 | 253314 | 2020-06-19 | Lake | Indiana | 18089 | 4361 | 248 |
250199 | 250199 | 2020-06-18 | Lake | Indiana | 18089 | 4332 | 247 |
247087 | 247087 | 2020-06-17 | Lake | Indiana | 18089 | 4257 | 246 |
243974 | 243974 | 2020-06-16 | Lake | Indiana | 18089 | 4246 | 245 |
240863 | 240863 | 2020-06-15 | Lake | Indiana | 18089 | 4207 | 245 |
237755 | 237755 | 2020-06-14 | Lake | Indiana | 18089 | 4168 | 245 |
234648 | 234648 | 2020-06-13 | Lake | Indiana | 18089 | 4144 | 243 |
231542 | 231542 | 2020-06-12 | Lake | Indiana | 18089 | 4116 | 239 |
228439 | 228439 | 2020-06-11 | Lake | Indiana | 18089 | 4092 | 238 |
225337 | 225337 | 2020-06-10 | Lake | Indiana | 18089 | 4068 | 234 |
222242 | 222242 | 2020-06-09 | Lake | Indiana | 18089 | 4040 | 232 |
219147 | 219147 | 2020-06-08 | Lake | Indiana | 18089 | 3994 | 230 |
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);