ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lawrence" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921186 | 921186 | 2021-01-12 | Lawrence | Indiana | 18093 | 3699 | 74 |
917941 | 917941 | 2021-01-11 | Lawrence | Indiana | 18093 | 3663 | 72 |
914696 | 914696 | 2021-01-10 | Lawrence | Indiana | 18093 | 3646 | 70 |
911451 | 911451 | 2021-01-09 | Lawrence | Indiana | 18093 | 3621 | 70 |
908206 | 908206 | 2021-01-08 | Lawrence | Indiana | 18093 | 3575 | 69 |
904960 | 904960 | 2021-01-07 | Lawrence | Indiana | 18093 | 3547 | 68 |
901715 | 901715 | 2021-01-06 | Lawrence | Indiana | 18093 | 3505 | 68 |
898470 | 898470 | 2021-01-05 | Lawrence | Indiana | 18093 | 3463 | 68 |
895225 | 895225 | 2021-01-04 | Lawrence | Indiana | 18093 | 3419 | 67 |
891978 | 891978 | 2021-01-03 | Lawrence | Indiana | 18093 | 3397 | 67 |
888732 | 888732 | 2021-01-02 | Lawrence | Indiana | 18093 | 3368 | 67 |
885486 | 885486 | 2021-01-01 | Lawrence | Indiana | 18093 | 3340 | 65 |
882241 | 882241 | 2020-12-31 | Lawrence | Indiana | 18093 | 3299 | 65 |
878996 | 878996 | 2020-12-30 | Lawrence | Indiana | 18093 | 3240 | 65 |
875751 | 875751 | 2020-12-29 | Lawrence | Indiana | 18093 | 3194 | 65 |
872506 | 872506 | 2020-12-28 | Lawrence | Indiana | 18093 | 3147 | 64 |
869261 | 869261 | 2020-12-27 | Lawrence | Indiana | 18093 | 3144 | 64 |
866016 | 866016 | 2020-12-26 | Lawrence | Indiana | 18093 | 3117 | 63 |
862771 | 862771 | 2020-12-25 | Lawrence | Indiana | 18093 | 3074 | 63 |
859526 | 859526 | 2020-12-24 | Lawrence | Indiana | 18093 | 3031 | 63 |
856281 | 856281 | 2020-12-23 | Lawrence | Indiana | 18093 | 2985 | 63 |
853036 | 853036 | 2020-12-22 | Lawrence | Indiana | 18093 | 2935 | 62 |
849791 | 849791 | 2020-12-21 | Lawrence | Indiana | 18093 | 2900 | 61 |
846546 | 846546 | 2020-12-20 | Lawrence | Indiana | 18093 | 2843 | 59 |
843300 | 843300 | 2020-12-19 | Lawrence | Indiana | 18093 | 2806 | 59 |
840055 | 840055 | 2020-12-18 | Lawrence | Indiana | 18093 | 2774 | 59 |
836810 | 836810 | 2020-12-17 | Lawrence | Indiana | 18093 | 2730 | 58 |
833564 | 833564 | 2020-12-16 | Lawrence | Indiana | 18093 | 2661 | 58 |
830317 | 830317 | 2020-12-15 | Lawrence | Indiana | 18093 | 2628 | 58 |
827071 | 827071 | 2020-12-14 | Lawrence | Indiana | 18093 | 2579 | 58 |
823824 | 823824 | 2020-12-13 | Lawrence | Indiana | 18093 | 2531 | 57 |
820578 | 820578 | 2020-12-12 | Lawrence | Indiana | 18093 | 2490 | 57 |
817332 | 817332 | 2020-12-11 | Lawrence | Indiana | 18093 | 2427 | 57 |
814086 | 814086 | 2020-12-10 | Lawrence | Indiana | 18093 | 2378 | 57 |
810841 | 810841 | 2020-12-09 | Lawrence | Indiana | 18093 | 2321 | 56 |
807596 | 807596 | 2020-12-08 | Lawrence | Indiana | 18093 | 2279 | 56 |
804351 | 804351 | 2020-12-07 | Lawrence | Indiana | 18093 | 2245 | 55 |
801106 | 801106 | 2020-12-06 | Lawrence | Indiana | 18093 | 2192 | 54 |
797861 | 797861 | 2020-12-05 | Lawrence | Indiana | 18093 | 2148 | 54 |
794616 | 794616 | 2020-12-04 | Lawrence | Indiana | 18093 | 2103 | 54 |
791371 | 791371 | 2020-12-03 | Lawrence | Indiana | 18093 | 2061 | 53 |
788126 | 788126 | 2020-12-02 | Lawrence | Indiana | 18093 | 2007 | 51 |
784882 | 784882 | 2020-12-01 | Lawrence | Indiana | 18093 | 1977 | 51 |
781637 | 781637 | 2020-11-30 | Lawrence | Indiana | 18093 | 1915 | 51 |
778391 | 778391 | 2020-11-29 | Lawrence | Indiana | 18093 | 1881 | 51 |
775146 | 775146 | 2020-11-28 | Lawrence | Indiana | 18093 | 1862 | 51 |
771901 | 771901 | 2020-11-27 | Lawrence | Indiana | 18093 | 1840 | 51 |
768656 | 768656 | 2020-11-26 | Lawrence | Indiana | 18093 | 1799 | 50 |
765410 | 765410 | 2020-11-25 | Lawrence | Indiana | 18093 | 1778 | 50 |
762165 | 762165 | 2020-11-24 | Lawrence | Indiana | 18093 | 1742 | 49 |
758920 | 758920 | 2020-11-23 | Lawrence | Indiana | 18093 | 1718 | 48 |
755673 | 755673 | 2020-11-22 | Lawrence | Indiana | 18093 | 1694 | 48 |
752427 | 752427 | 2020-11-21 | Lawrence | Indiana | 18093 | 1674 | 46 |
749181 | 749181 | 2020-11-20 | Lawrence | Indiana | 18093 | 1642 | 46 |
745935 | 745935 | 2020-11-19 | Lawrence | Indiana | 18093 | 1609 | 46 |
742688 | 742688 | 2020-11-18 | Lawrence | Indiana | 18093 | 1585 | 45 |
739441 | 739441 | 2020-11-17 | Lawrence | Indiana | 18093 | 1549 | 45 |
736197 | 736197 | 2020-11-16 | Lawrence | Indiana | 18093 | 1519 | 45 |
732951 | 732951 | 2020-11-15 | Lawrence | Indiana | 18093 | 1502 | 45 |
729706 | 729706 | 2020-11-14 | Lawrence | Indiana | 18093 | 1479 | 45 |
726463 | 726463 | 2020-11-13 | Lawrence | Indiana | 18093 | 1419 | 45 |
723220 | 723220 | 2020-11-12 | Lawrence | Indiana | 18093 | 1371 | 44 |
719977 | 719977 | 2020-11-11 | Lawrence | Indiana | 18093 | 1359 | 44 |
716734 | 716734 | 2020-11-10 | Lawrence | Indiana | 18093 | 1336 | 44 |
713490 | 713490 | 2020-11-09 | Lawrence | Indiana | 18093 | 1294 | 44 |
710246 | 710246 | 2020-11-08 | Lawrence | Indiana | 18093 | 1276 | 44 |
707002 | 707002 | 2020-11-07 | Lawrence | Indiana | 18093 | 1248 | 44 |
703759 | 703759 | 2020-11-06 | Lawrence | Indiana | 18093 | 1221 | 43 |
700517 | 700517 | 2020-11-05 | Lawrence | Indiana | 18093 | 1183 | 43 |
697273 | 697273 | 2020-11-04 | Lawrence | Indiana | 18093 | 1160 | 42 |
694031 | 694031 | 2020-11-03 | Lawrence | Indiana | 18093 | 1125 | 42 |
690788 | 690788 | 2020-11-02 | Lawrence | Indiana | 18093 | 1109 | 41 |
687543 | 687543 | 2020-11-01 | Lawrence | Indiana | 18093 | 1099 | 41 |
684299 | 684299 | 2020-10-31 | Lawrence | Indiana | 18093 | 1092 | 41 |
681056 | 681056 | 2020-10-30 | Lawrence | Indiana | 18093 | 1064 | 40 |
677813 | 677813 | 2020-10-29 | Lawrence | Indiana | 18093 | 1044 | 40 |
674570 | 674570 | 2020-10-28 | Lawrence | Indiana | 18093 | 1024 | 40 |
671328 | 671328 | 2020-10-27 | Lawrence | Indiana | 18093 | 994 | 40 |
668085 | 668085 | 2020-10-26 | Lawrence | Indiana | 18093 | 970 | 40 |
664841 | 664841 | 2020-10-25 | Lawrence | Indiana | 18093 | 949 | 39 |
661596 | 661596 | 2020-10-24 | Lawrence | Indiana | 18093 | 942 | 39 |
658352 | 658352 | 2020-10-23 | Lawrence | Indiana | 18093 | 910 | 39 |
655107 | 655107 | 2020-10-22 | Lawrence | Indiana | 18093 | 876 | 38 |
651862 | 651862 | 2020-10-21 | Lawrence | Indiana | 18093 | 828 | 36 |
648618 | 648618 | 2020-10-20 | Lawrence | Indiana | 18093 | 787 | 36 |
645373 | 645373 | 2020-10-19 | Lawrence | Indiana | 18093 | 780 | 34 |
642126 | 642126 | 2020-10-18 | Lawrence | Indiana | 18093 | 769 | 34 |
638879 | 638879 | 2020-10-17 | Lawrence | Indiana | 18093 | 741 | 34 |
635633 | 635633 | 2020-10-16 | Lawrence | Indiana | 18093 | 716 | 34 |
632387 | 632387 | 2020-10-15 | Lawrence | Indiana | 18093 | 672 | 33 |
629143 | 629143 | 2020-10-14 | Lawrence | Indiana | 18093 | 667 | 33 |
625900 | 625900 | 2020-10-13 | Lawrence | Indiana | 18093 | 659 | 32 |
622658 | 622658 | 2020-10-12 | Lawrence | Indiana | 18093 | 650 | 32 |
619414 | 619414 | 2020-10-11 | Lawrence | Indiana | 18093 | 637 | 32 |
616172 | 616172 | 2020-10-10 | Lawrence | Indiana | 18093 | 628 | 32 |
612931 | 612931 | 2020-10-09 | Lawrence | Indiana | 18093 | 617 | 32 |
609689 | 609689 | 2020-10-08 | Lawrence | Indiana | 18093 | 600 | 32 |
606446 | 606446 | 2020-10-07 | Lawrence | Indiana | 18093 | 579 | 32 |
603204 | 603204 | 2020-10-06 | Lawrence | Indiana | 18093 | 575 | 31 |
599961 | 599961 | 2020-10-05 | Lawrence | Indiana | 18093 | 570 | 31 |
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);