ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lake" and fips = 18089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635632 | 635632 | 2020-10-16 | Lake | Indiana | 18089 | 12589 | 364 |
632386 | 632386 | 2020-10-15 | Lake | Indiana | 18089 | 12388 | 361 |
629142 | 629142 | 2020-10-14 | Lake | Indiana | 18089 | 12251 | 358 |
625899 | 625899 | 2020-10-13 | Lake | Indiana | 18089 | 12149 | 357 |
622657 | 622657 | 2020-10-12 | Lake | Indiana | 18089 | 12033 | 357 |
619413 | 619413 | 2020-10-11 | Lake | Indiana | 18089 | 11892 | 357 |
616171 | 616171 | 2020-10-10 | Lake | Indiana | 18089 | 11790 | 357 |
612930 | 612930 | 2020-10-09 | Lake | Indiana | 18089 | 11640 | 353 |
609688 | 609688 | 2020-10-08 | Lake | Indiana | 18089 | 11481 | 353 |
606445 | 606445 | 2020-10-07 | Lake | Indiana | 18089 | 11406 | 352 |
603203 | 603203 | 2020-10-06 | Lake | Indiana | 18089 | 11345 | 350 |
599960 | 599960 | 2020-10-05 | Lake | Indiana | 18089 | 11295 | 348 |
596718 | 596718 | 2020-10-04 | Lake | Indiana | 18089 | 11223 | 346 |
593476 | 593476 | 2020-10-03 | Lake | Indiana | 18089 | 11150 | 345 |
590235 | 590235 | 2020-10-02 | Lake | Indiana | 18089 | 11047 | 345 |
586994 | 586994 | 2020-10-01 | Lake | Indiana | 18089 | 10931 | 345 |
583754 | 583754 | 2020-09-30 | Lake | Indiana | 18089 | 10834 | 343 |
580515 | 580515 | 2020-09-29 | Lake | Indiana | 18089 | 10807 | 342 |
577274 | 577274 | 2020-09-28 | Lake | Indiana | 18089 | 10750 | 341 |
574032 | 574032 | 2020-09-27 | Lake | Indiana | 18089 | 10680 | 341 |
570789 | 570789 | 2020-09-26 | Lake | Indiana | 18089 | 10628 | 341 |
567547 | 567547 | 2020-09-25 | Lake | Indiana | 18089 | 10555 | 341 |
564307 | 564307 | 2020-09-24 | Lake | Indiana | 18089 | 10459 | 339 |
561067 | 561067 | 2020-09-23 | Lake | Indiana | 18089 | 10394 | 337 |
557831 | 557831 | 2020-09-22 | Lake | Indiana | 18089 | 10352 | 336 |
554594 | 554594 | 2020-09-21 | Lake | Indiana | 18089 | 10324 | 337 |
551355 | 551355 | 2020-09-20 | Lake | Indiana | 18089 | 10277 | 336 |
548116 | 548116 | 2020-09-19 | Lake | Indiana | 18089 | 10232 | 335 |
544878 | 544878 | 2020-09-18 | Lake | Indiana | 18089 | 10156 | 333 |
541642 | 541642 | 2020-09-17 | Lake | Indiana | 18089 | 10074 | 330 |
538405 | 538405 | 2020-09-16 | Lake | Indiana | 18089 | 10017 | 330 |
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 |
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);