ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 18089 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054254 | 1054254 | 2021-02-22 | Lake | Indiana | 18089 | 48150 | 899 |
1051007 | 1051007 | 2021-02-21 | Lake | Indiana | 18089 | 48102 | 892 |
1047760 | 1047760 | 2021-02-20 | Lake | Indiana | 18089 | 48040 | 891 |
1044515 | 1044515 | 2021-02-19 | Lake | Indiana | 18089 | 47978 | 889 |
1041270 | 1041270 | 2021-02-18 | Lake | Indiana | 18089 | 47919 | 887 |
1038025 | 1038025 | 2021-02-17 | Lake | Indiana | 18089 | 47874 | 883 |
1034780 | 1034780 | 2021-02-16 | Lake | Indiana | 18089 | 47827 | 883 |
1031534 | 1031534 | 2021-02-15 | Lake | Indiana | 18089 | 47754 | 880 |
1028287 | 1028287 | 2021-02-14 | Lake | Indiana | 18089 | 47689 | 877 |
1025042 | 1025042 | 2021-02-13 | Lake | Indiana | 18089 | 47623 | 876 |
1021797 | 1021797 | 2021-02-12 | Lake | Indiana | 18089 | 47563 | 871 |
1018552 | 1018552 | 2021-02-11 | Lake | Indiana | 18089 | 47483 | 859 |
1015307 | 1015307 | 2021-02-10 | Lake | Indiana | 18089 | 47386 | 857 |
1012062 | 1012062 | 2021-02-09 | Lake | Indiana | 18089 | 47338 | 851 |
1008816 | 1008816 | 2021-02-08 | Lake | Indiana | 18089 | 47259 | 849 |
1005570 | 1005570 | 2021-02-07 | Lake | Indiana | 18089 | 47187 | 846 |
1002324 | 1002324 | 2021-02-06 | Lake | Indiana | 18089 | 47089 | 844 |
999078 | 999078 | 2021-02-05 | Lake | Indiana | 18089 | 46950 | 838 |
995832 | 995832 | 2021-02-04 | Lake | Indiana | 18089 | 46862 | 833 |
992586 | 992586 | 2021-02-03 | Lake | Indiana | 18089 | 46724 | 740 |
989340 | 989340 | 2021-02-02 | Lake | Indiana | 18089 | 46672 | 737 |
986093 | 986093 | 2021-02-01 | Lake | Indiana | 18089 | 46620 | 728 |
982846 | 982846 | 2021-01-31 | Lake | Indiana | 18089 | 46513 | 727 |
979600 | 979600 | 2021-01-30 | Lake | Indiana | 18089 | 46418 | 727 |
976354 | 976354 | 2021-01-29 | Lake | Indiana | 18089 | 46266 | 727 |
973109 | 973109 | 2021-01-28 | Lake | Indiana | 18089 | 46132 | 724 |
969864 | 969864 | 2021-01-27 | Lake | Indiana | 18089 | 45964 | 723 |
966620 | 966620 | 2021-01-26 | Lake | Indiana | 18089 | 45854 | 721 |
963375 | 963375 | 2021-01-25 | Lake | Indiana | 18089 | 45746 | 715 |
960130 | 960130 | 2021-01-24 | Lake | Indiana | 18089 | 45578 | 713 |
956884 | 956884 | 2021-01-23 | Lake | Indiana | 18089 | 45419 | 712 |
953639 | 953639 | 2021-01-22 | Lake | Indiana | 18089 | 45259 | 708 |
950394 | 950394 | 2021-01-21 | Lake | Indiana | 18089 | 45042 | 706 |
947148 | 947148 | 2021-01-20 | Lake | Indiana | 18089 | 44848 | 704 |
943901 | 943901 | 2021-01-19 | Lake | Indiana | 18089 | 44695 | 697 |
940656 | 940656 | 2021-01-18 | Lake | Indiana | 18089 | 44564 | 695 |
937411 | 937411 | 2021-01-17 | Lake | Indiana | 18089 | 44375 | 693 |
934166 | 934166 | 2021-01-16 | Lake | Indiana | 18089 | 44190 | 692 |
930921 | 930921 | 2021-01-15 | Lake | Indiana | 18089 | 43906 | 692 |
927676 | 927676 | 2021-01-14 | Lake | Indiana | 18089 | 43670 | 691 |
924430 | 924430 | 2021-01-13 | Lake | Indiana | 18089 | 43434 | 689 |
921185 | 921185 | 2021-01-12 | Lake | Indiana | 18089 | 43268 | 681 |
917940 | 917940 | 2021-01-11 | Lake | Indiana | 18089 | 43086 | 676 |
914695 | 914695 | 2021-01-10 | Lake | Indiana | 18089 | 42832 | 676 |
911450 | 911450 | 2021-01-09 | Lake | Indiana | 18089 | 42619 | 673 |
908205 | 908205 | 2021-01-08 | Lake | Indiana | 18089 | 42265 | 667 |
904959 | 904959 | 2021-01-07 | Lake | Indiana | 18089 | 41902 | 664 |
901714 | 901714 | 2021-01-06 | Lake | Indiana | 18089 | 41501 | 661 |
898469 | 898469 | 2021-01-05 | Lake | Indiana | 18089 | 41221 | 654 |
895224 | 895224 | 2021-01-04 | Lake | Indiana | 18089 | 41028 | 641 |
891977 | 891977 | 2021-01-03 | Lake | Indiana | 18089 | 40916 | 639 |
888731 | 888731 | 2021-01-02 | Lake | Indiana | 18089 | 40690 | 637 |
885485 | 885485 | 2021-01-01 | Lake | Indiana | 18089 | 40299 | 636 |
882240 | 882240 | 2020-12-31 | Lake | Indiana | 18089 | 39901 | 632 |
878995 | 878995 | 2020-12-30 | Lake | Indiana | 18089 | 39534 | 627 |
875750 | 875750 | 2020-12-29 | Lake | Indiana | 18089 | 39337 | 616 |
872505 | 872505 | 2020-12-28 | Lake | Indiana | 18089 | 39116 | 598 |
869260 | 869260 | 2020-12-27 | Lake | Indiana | 18089 | 38946 | 596 |
866015 | 866015 | 2020-12-26 | Lake | Indiana | 18089 | 38821 | 594 |
862770 | 862770 | 2020-12-25 | Lake | Indiana | 18089 | 38520 | 593 |
859525 | 859525 | 2020-12-24 | Lake | Indiana | 18089 | 38173 | 593 |
856280 | 856280 | 2020-12-23 | Lake | Indiana | 18089 | 37751 | 588 |
853035 | 853035 | 2020-12-22 | Lake | Indiana | 18089 | 37587 | 585 |
849790 | 849790 | 2020-12-21 | Lake | Indiana | 18089 | 37366 | 579 |
846545 | 846545 | 2020-12-20 | Lake | Indiana | 18089 | 37105 | 578 |
843299 | 843299 | 2020-12-19 | Lake | Indiana | 18089 | 36667 | 572 |
840054 | 840054 | 2020-12-18 | Lake | Indiana | 18089 | 36394 | 568 |
836809 | 836809 | 2020-12-17 | Lake | Indiana | 18089 | 36035 | 561 |
833563 | 833563 | 2020-12-16 | Lake | Indiana | 18089 | 35601 | 560 |
830316 | 830316 | 2020-12-15 | Lake | Indiana | 18089 | 35410 | 554 |
827070 | 827070 | 2020-12-14 | Lake | Indiana | 18089 | 35161 | 551 |
823823 | 823823 | 2020-12-13 | Lake | Indiana | 18089 | 34821 | 548 |
820577 | 820577 | 2020-12-12 | Lake | Indiana | 18089 | 34420 | 545 |
817331 | 817331 | 2020-12-11 | Lake | Indiana | 18089 | 33914 | 540 |
814085 | 814085 | 2020-12-10 | Lake | Indiana | 18089 | 33560 | 536 |
810840 | 810840 | 2020-12-09 | Lake | Indiana | 18089 | 33140 | 528 |
807595 | 807595 | 2020-12-08 | Lake | Indiana | 18089 | 32880 | 522 |
804350 | 804350 | 2020-12-07 | Lake | Indiana | 18089 | 32512 | 516 |
801105 | 801105 | 2020-12-06 | Lake | Indiana | 18089 | 32047 | 516 |
797860 | 797860 | 2020-12-05 | Lake | Indiana | 18089 | 31603 | 514 |
794615 | 794615 | 2020-12-04 | Lake | Indiana | 18089 | 31091 | 511 |
791370 | 791370 | 2020-12-03 | Lake | Indiana | 18089 | 30600 | 504 |
788125 | 788125 | 2020-12-02 | Lake | Indiana | 18089 | 30070 | 500 |
784881 | 784881 | 2020-12-01 | Lake | Indiana | 18089 | 29705 | 494 |
781636 | 781636 | 2020-11-30 | Lake | Indiana | 18089 | 29244 | 488 |
778390 | 778390 | 2020-11-29 | Lake | Indiana | 18089 | 28783 | 488 |
775145 | 775145 | 2020-11-28 | Lake | Indiana | 18089 | 28546 | 485 |
771900 | 771900 | 2020-11-27 | Lake | Indiana | 18089 | 28155 | 481 |
768655 | 768655 | 2020-11-26 | Lake | Indiana | 18089 | 27660 | 481 |
765409 | 765409 | 2020-11-25 | Lake | Indiana | 18089 | 27213 | 474 |
762164 | 762164 | 2020-11-24 | Lake | Indiana | 18089 | 26933 | 472 |
758919 | 758919 | 2020-11-23 | Lake | Indiana | 18089 | 26425 | 467 |
755672 | 755672 | 2020-11-22 | Lake | Indiana | 18089 | 25925 | 467 |
752426 | 752426 | 2020-11-21 | Lake | Indiana | 18089 | 25580 | 460 |
749180 | 749180 | 2020-11-20 | Lake | Indiana | 18089 | 25087 | 460 |
745934 | 745934 | 2020-11-19 | Lake | Indiana | 18089 | 24569 | 452 |
742687 | 742687 | 2020-11-18 | Lake | Indiana | 18089 | 24014 | 449 |
739440 | 739440 | 2020-11-17 | Lake | Indiana | 18089 | 23649 | 442 |
736196 | 736196 | 2020-11-16 | Lake | Indiana | 18089 | 23228 | 432 |
732950 | 732950 | 2020-11-15 | Lake | Indiana | 18089 | 22636 | 431 |
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);