ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 18011 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635592 | 635592 | 2020-10-16 | Boone | Indiana | 18011 | 1177 | 51 |
632346 | 632346 | 2020-10-15 | Boone | Indiana | 18011 | 1162 | 51 |
629102 | 629102 | 2020-10-14 | Boone | Indiana | 18011 | 1150 | 51 |
625859 | 625859 | 2020-10-13 | Boone | Indiana | 18011 | 1143 | 49 |
622617 | 622617 | 2020-10-12 | Boone | Indiana | 18011 | 1134 | 49 |
619373 | 619373 | 2020-10-11 | Boone | Indiana | 18011 | 1126 | 49 |
616131 | 616131 | 2020-10-10 | Boone | Indiana | 18011 | 1117 | 49 |
612890 | 612890 | 2020-10-09 | Boone | Indiana | 18011 | 1107 | 49 |
609648 | 609648 | 2020-10-08 | Boone | Indiana | 18011 | 1096 | 49 |
606405 | 606405 | 2020-10-07 | Boone | Indiana | 18011 | 1087 | 49 |
603163 | 603163 | 2020-10-06 | Boone | Indiana | 18011 | 1067 | 49 |
599920 | 599920 | 2020-10-05 | Boone | Indiana | 18011 | 1064 | 49 |
596678 | 596678 | 2020-10-04 | Boone | Indiana | 18011 | 1061 | 49 |
593436 | 593436 | 2020-10-03 | Boone | Indiana | 18011 | 1055 | 49 |
590195 | 590195 | 2020-10-02 | Boone | Indiana | 18011 | 1044 | 49 |
586954 | 586954 | 2020-10-01 | Boone | Indiana | 18011 | 1031 | 49 |
583714 | 583714 | 2020-09-30 | Boone | Indiana | 18011 | 1023 | 49 |
580475 | 580475 | 2020-09-29 | Boone | Indiana | 18011 | 1017 | 49 |
577234 | 577234 | 2020-09-28 | Boone | Indiana | 18011 | 1011 | 49 |
573992 | 573992 | 2020-09-27 | Boone | Indiana | 18011 | 1006 | 49 |
570749 | 570749 | 2020-09-26 | Boone | Indiana | 18011 | 1001 | 49 |
567507 | 567507 | 2020-09-25 | Boone | Indiana | 18011 | 988 | 49 |
564267 | 564267 | 2020-09-24 | Boone | Indiana | 18011 | 980 | 49 |
561027 | 561027 | 2020-09-23 | Boone | Indiana | 18011 | 976 | 49 |
557791 | 557791 | 2020-09-22 | Boone | Indiana | 18011 | 971 | 49 |
554554 | 554554 | 2020-09-21 | Boone | Indiana | 18011 | 965 | 49 |
551315 | 551315 | 2020-09-20 | Boone | Indiana | 18011 | 964 | 49 |
548076 | 548076 | 2020-09-19 | Boone | Indiana | 18011 | 964 | 49 |
544838 | 544838 | 2020-09-18 | Boone | Indiana | 18011 | 960 | 49 |
541602 | 541602 | 2020-09-17 | Boone | Indiana | 18011 | 958 | 49 |
538365 | 538365 | 2020-09-16 | Boone | Indiana | 18011 | 957 | 49 |
535129 | 535129 | 2020-09-15 | Boone | Indiana | 18011 | 956 | 49 |
531894 | 531894 | 2020-09-14 | Boone | Indiana | 18011 | 952 | 49 |
528657 | 528657 | 2020-09-13 | Boone | Indiana | 18011 | 947 | 49 |
525421 | 525421 | 2020-09-12 | Boone | Indiana | 18011 | 938 | 49 |
522185 | 522185 | 2020-09-11 | Boone | Indiana | 18011 | 932 | 49 |
518948 | 518948 | 2020-09-10 | Boone | Indiana | 18011 | 921 | 49 |
515713 | 515713 | 2020-09-09 | Boone | Indiana | 18011 | 915 | 49 |
512480 | 512480 | 2020-09-08 | Boone | Indiana | 18011 | 912 | 49 |
509247 | 509247 | 2020-09-07 | Boone | Indiana | 18011 | 912 | 49 |
506015 | 506015 | 2020-09-06 | Boone | Indiana | 18011 | 909 | 49 |
502781 | 502781 | 2020-09-05 | Boone | Indiana | 18011 | 905 | 49 |
499547 | 499547 | 2020-09-04 | Boone | Indiana | 18011 | 893 | 49 |
496314 | 496314 | 2020-09-03 | Boone | Indiana | 18011 | 887 | 49 |
493080 | 493080 | 2020-09-02 | Boone | Indiana | 18011 | 880 | 49 |
489847 | 489847 | 2020-09-01 | Boone | Indiana | 18011 | 866 | 49 |
486614 | 486614 | 2020-08-31 | Boone | Indiana | 18011 | 862 | 49 |
483379 | 483379 | 2020-08-30 | Boone | Indiana | 18011 | 852 | 49 |
480145 | 480145 | 2020-08-29 | Boone | Indiana | 18011 | 846 | 49 |
476912 | 476912 | 2020-08-28 | Boone | Indiana | 18011 | 839 | 49 |
473679 | 473679 | 2020-08-27 | Boone | Indiana | 18011 | 833 | 49 |
470447 | 470447 | 2020-08-26 | Boone | Indiana | 18011 | 817 | 49 |
467218 | 467218 | 2020-08-25 | Boone | Indiana | 18011 | 808 | 49 |
463989 | 463989 | 2020-08-24 | Boone | Indiana | 18011 | 804 | 49 |
460760 | 460760 | 2020-08-23 | Boone | Indiana | 18011 | 798 | 49 |
457533 | 457533 | 2020-08-22 | Boone | Indiana | 18011 | 795 | 49 |
454305 | 454305 | 2020-08-21 | Boone | Indiana | 18011 | 790 | 49 |
451077 | 451077 | 2020-08-20 | Boone | Indiana | 18011 | 776 | 49 |
447849 | 447849 | 2020-08-19 | Boone | Indiana | 18011 | 770 | 49 |
444622 | 444622 | 2020-08-18 | Boone | Indiana | 18011 | 767 | 49 |
441396 | 441396 | 2020-08-17 | Boone | Indiana | 18011 | 759 | 49 |
438170 | 438170 | 2020-08-16 | Boone | Indiana | 18011 | 753 | 49 |
434944 | 434944 | 2020-08-15 | Boone | Indiana | 18011 | 745 | 49 |
431719 | 431719 | 2020-08-14 | Boone | Indiana | 18011 | 735 | 49 |
428491 | 428491 | 2020-08-13 | Boone | Indiana | 18011 | 723 | 49 |
425267 | 425267 | 2020-08-12 | Boone | Indiana | 18011 | 716 | 49 |
422046 | 422046 | 2020-08-11 | Boone | Indiana | 18011 | 706 | 49 |
418823 | 418823 | 2020-08-10 | Boone | Indiana | 18011 | 702 | 49 |
415602 | 415602 | 2020-08-09 | Boone | Indiana | 18011 | 697 | 49 |
412382 | 412382 | 2020-08-08 | Boone | Indiana | 18011 | 691 | 49 |
409163 | 409163 | 2020-08-07 | Boone | Indiana | 18011 | 681 | 49 |
405943 | 405943 | 2020-08-06 | Boone | Indiana | 18011 | 672 | 49 |
402725 | 402725 | 2020-08-05 | Boone | Indiana | 18011 | 668 | 49 |
399509 | 399509 | 2020-08-04 | Boone | Indiana | 18011 | 663 | 49 |
396293 | 396293 | 2020-08-03 | Boone | Indiana | 18011 | 654 | 49 |
393077 | 393077 | 2020-08-02 | Boone | Indiana | 18011 | 651 | 49 |
389860 | 389860 | 2020-08-01 | Boone | Indiana | 18011 | 645 | 49 |
386643 | 386643 | 2020-07-31 | Boone | Indiana | 18011 | 632 | 49 |
383425 | 383425 | 2020-07-30 | Boone | Indiana | 18011 | 627 | 48 |
380208 | 380208 | 2020-07-29 | Boone | Indiana | 18011 | 616 | 48 |
376991 | 376991 | 2020-07-28 | Boone | Indiana | 18011 | 610 | 48 |
373776 | 373776 | 2020-07-27 | Boone | Indiana | 18011 | 602 | 48 |
370564 | 370564 | 2020-07-26 | Boone | Indiana | 18011 | 597 | 48 |
367354 | 367354 | 2020-07-25 | Boone | Indiana | 18011 | 589 | 48 |
364147 | 364147 | 2020-07-24 | Boone | Indiana | 18011 | 582 | 48 |
360940 | 360940 | 2020-07-23 | Boone | Indiana | 18011 | 578 | 48 |
357735 | 357735 | 2020-07-22 | Boone | Indiana | 18011 | 572 | 48 |
354533 | 354533 | 2020-07-21 | Boone | Indiana | 18011 | 565 | 48 |
351331 | 351331 | 2020-07-20 | Boone | Indiana | 18011 | 552 | 48 |
348131 | 348131 | 2020-07-19 | Boone | Indiana | 18011 | 548 | 48 |
344930 | 344930 | 2020-07-18 | Boone | Indiana | 18011 | 538 | 48 |
341730 | 341730 | 2020-07-17 | Boone | Indiana | 18011 | 528 | 47 |
338534 | 338534 | 2020-07-16 | Boone | Indiana | 18011 | 524 | 47 |
335338 | 335338 | 2020-07-15 | Boone | Indiana | 18011 | 519 | 47 |
332145 | 332145 | 2020-07-14 | Boone | Indiana | 18011 | 515 | 47 |
328958 | 328958 | 2020-07-13 | Boone | Indiana | 18011 | 510 | 47 |
325772 | 325772 | 2020-07-12 | Boone | Indiana | 18011 | 509 | 47 |
322591 | 322591 | 2020-07-11 | Boone | Indiana | 18011 | 500 | 47 |
319412 | 319412 | 2020-07-10 | Boone | Indiana | 18011 | 492 | 47 |
316239 | 316239 | 2020-07-09 | Boone | Indiana | 18011 | 477 | 47 |
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);