ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Morgan" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064000 | 1064000 | 2021-02-25 | Morgan | Indiana | 18109 | 6070 | 129 |
1060755 | 1060755 | 2021-02-24 | Morgan | Indiana | 18109 | 6060 | 129 |
1057509 | 1057509 | 2021-02-23 | Morgan | Indiana | 18109 | 6056 | 129 |
1054263 | 1054263 | 2021-02-22 | Morgan | Indiana | 18109 | 6046 | 129 |
1051016 | 1051016 | 2021-02-21 | Morgan | Indiana | 18109 | 6037 | 129 |
1047769 | 1047769 | 2021-02-20 | Morgan | Indiana | 18109 | 6030 | 129 |
1044524 | 1044524 | 2021-02-19 | Morgan | Indiana | 18109 | 6014 | 129 |
1041279 | 1041279 | 2021-02-18 | Morgan | Indiana | 18109 | 5993 | 129 |
1038034 | 1038034 | 2021-02-17 | Morgan | Indiana | 18109 | 5988 | 129 |
1034789 | 1034789 | 2021-02-16 | Morgan | Indiana | 18109 | 5967 | 129 |
1031543 | 1031543 | 2021-02-15 | Morgan | Indiana | 18109 | 5960 | 129 |
1028296 | 1028296 | 2021-02-14 | Morgan | Indiana | 18109 | 5943 | 129 |
1025051 | 1025051 | 2021-02-13 | Morgan | Indiana | 18109 | 5931 | 129 |
1021806 | 1021806 | 2021-02-12 | Morgan | Indiana | 18109 | 5915 | 129 |
1018561 | 1018561 | 2021-02-11 | Morgan | Indiana | 18109 | 5902 | 129 |
1015316 | 1015316 | 2021-02-10 | Morgan | Indiana | 18109 | 5880 | 129 |
1012071 | 1012071 | 2021-02-09 | Morgan | Indiana | 18109 | 5877 | 129 |
1008825 | 1008825 | 2021-02-08 | Morgan | Indiana | 18109 | 5867 | 126 |
1005579 | 1005579 | 2021-02-07 | Morgan | Indiana | 18109 | 5857 | 124 |
1002333 | 1002333 | 2021-02-06 | Morgan | Indiana | 18109 | 5838 | 124 |
999087 | 999087 | 2021-02-05 | Morgan | Indiana | 18109 | 5800 | 122 |
995841 | 995841 | 2021-02-04 | Morgan | Indiana | 18109 | 5780 | 120 |
992595 | 992595 | 2021-02-03 | Morgan | Indiana | 18109 | 5754 | 108 |
989349 | 989349 | 2021-02-02 | Morgan | Indiana | 18109 | 5737 | 107 |
986102 | 986102 | 2021-02-01 | Morgan | Indiana | 18109 | 5704 | 106 |
982855 | 982855 | 2021-01-31 | Morgan | Indiana | 18109 | 5681 | 105 |
979609 | 979609 | 2021-01-30 | Morgan | Indiana | 18109 | 5673 | 105 |
976363 | 976363 | 2021-01-29 | Morgan | Indiana | 18109 | 5634 | 105 |
973118 | 973118 | 2021-01-28 | Morgan | Indiana | 18109 | 5584 | 103 |
969873 | 969873 | 2021-01-27 | Morgan | Indiana | 18109 | 5560 | 101 |
966629 | 966629 | 2021-01-26 | Morgan | Indiana | 18109 | 5534 | 101 |
963384 | 963384 | 2021-01-25 | Morgan | Indiana | 18109 | 5501 | 100 |
960139 | 960139 | 2021-01-24 | Morgan | Indiana | 18109 | 5472 | 100 |
956893 | 956893 | 2021-01-23 | Morgan | Indiana | 18109 | 5427 | 100 |
953648 | 953648 | 2021-01-22 | Morgan | Indiana | 18109 | 5370 | 100 |
950403 | 950403 | 2021-01-21 | Morgan | Indiana | 18109 | 5320 | 99 |
947157 | 947157 | 2021-01-20 | Morgan | Indiana | 18109 | 5277 | 99 |
943910 | 943910 | 2021-01-19 | Morgan | Indiana | 18109 | 5256 | 97 |
940665 | 940665 | 2021-01-18 | Morgan | Indiana | 18109 | 5209 | 96 |
937420 | 937420 | 2021-01-17 | Morgan | Indiana | 18109 | 5177 | 96 |
934175 | 934175 | 2021-01-16 | Morgan | Indiana | 18109 | 5138 | 93 |
930930 | 930930 | 2021-01-15 | Morgan | Indiana | 18109 | 5107 | 92 |
927685 | 927685 | 2021-01-14 | Morgan | Indiana | 18109 | 5029 | 90 |
924439 | 924439 | 2021-01-13 | Morgan | Indiana | 18109 | 4988 | 90 |
921194 | 921194 | 2021-01-12 | Morgan | Indiana | 18109 | 4958 | 89 |
917949 | 917949 | 2021-01-11 | Morgan | Indiana | 18109 | 4916 | 88 |
914704 | 914704 | 2021-01-10 | Morgan | Indiana | 18109 | 4874 | 87 |
911459 | 911459 | 2021-01-09 | Morgan | Indiana | 18109 | 4813 | 87 |
908214 | 908214 | 2021-01-08 | Morgan | Indiana | 18109 | 4741 | 87 |
904968 | 904968 | 2021-01-07 | Morgan | Indiana | 18109 | 4655 | 87 |
901723 | 901723 | 2021-01-06 | Morgan | Indiana | 18109 | 4586 | 87 |
898478 | 898478 | 2021-01-05 | Morgan | Indiana | 18109 | 4541 | 85 |
895233 | 895233 | 2021-01-04 | Morgan | Indiana | 18109 | 4512 | 84 |
891986 | 891986 | 2021-01-03 | Morgan | Indiana | 18109 | 4476 | 84 |
888740 | 888740 | 2021-01-02 | Morgan | Indiana | 18109 | 4430 | 83 |
885494 | 885494 | 2021-01-01 | Morgan | Indiana | 18109 | 4368 | 83 |
882249 | 882249 | 2020-12-31 | Morgan | Indiana | 18109 | 4271 | 82 |
879004 | 879004 | 2020-12-30 | Morgan | Indiana | 18109 | 4224 | 81 |
875759 | 875759 | 2020-12-29 | Morgan | Indiana | 18109 | 4185 | 81 |
872514 | 872514 | 2020-12-28 | Morgan | Indiana | 18109 | 4122 | 79 |
869269 | 869269 | 2020-12-27 | Morgan | Indiana | 18109 | 4118 | 79 |
866024 | 866024 | 2020-12-26 | Morgan | Indiana | 18109 | 4108 | 79 |
862779 | 862779 | 2020-12-25 | Morgan | Indiana | 18109 | 4065 | 79 |
859534 | 859534 | 2020-12-24 | Morgan | Indiana | 18109 | 3996 | 79 |
856289 | 856289 | 2020-12-23 | Morgan | Indiana | 18109 | 3938 | 75 |
853044 | 853044 | 2020-12-22 | Morgan | Indiana | 18109 | 3908 | 74 |
849799 | 849799 | 2020-12-21 | Morgan | Indiana | 18109 | 3875 | 73 |
846554 | 846554 | 2020-12-20 | Morgan | Indiana | 18109 | 3839 | 73 |
843308 | 843308 | 2020-12-19 | Morgan | Indiana | 18109 | 3735 | 72 |
840063 | 840063 | 2020-12-18 | Morgan | Indiana | 18109 | 3706 | 70 |
836818 | 836818 | 2020-12-17 | Morgan | Indiana | 18109 | 3621 | 67 |
833572 | 833572 | 2020-12-16 | Morgan | Indiana | 18109 | 3551 | 63 |
830325 | 830325 | 2020-12-15 | Morgan | Indiana | 18109 | 3475 | 61 |
827079 | 827079 | 2020-12-14 | Morgan | Indiana | 18109 | 3424 | 59 |
823832 | 823832 | 2020-12-13 | Morgan | Indiana | 18109 | 3353 | 59 |
820586 | 820586 | 2020-12-12 | Morgan | Indiana | 18109 | 3319 | 57 |
817340 | 817340 | 2020-12-11 | Morgan | Indiana | 18109 | 3207 | 57 |
814094 | 814094 | 2020-12-10 | Morgan | Indiana | 18109 | 3133 | 56 |
810849 | 810849 | 2020-12-09 | Morgan | Indiana | 18109 | 3025 | 54 |
807604 | 807604 | 2020-12-08 | Morgan | Indiana | 18109 | 2951 | 52 |
804359 | 804359 | 2020-12-07 | Morgan | Indiana | 18109 | 2884 | 51 |
801114 | 801114 | 2020-12-06 | Morgan | Indiana | 18109 | 2808 | 51 |
797869 | 797869 | 2020-12-05 | Morgan | Indiana | 18109 | 2750 | 50 |
794624 | 794624 | 2020-12-04 | Morgan | Indiana | 18109 | 2687 | 50 |
791379 | 791379 | 2020-12-03 | Morgan | Indiana | 18109 | 2605 | 50 |
788134 | 788134 | 2020-12-02 | Morgan | Indiana | 18109 | 2532 | 49 |
784890 | 784890 | 2020-12-01 | Morgan | Indiana | 18109 | 2455 | 48 |
781645 | 781645 | 2020-11-30 | Morgan | Indiana | 18109 | 2379 | 47 |
778399 | 778399 | 2020-11-29 | Morgan | Indiana | 18109 | 2301 | 47 |
775154 | 775154 | 2020-11-28 | Morgan | Indiana | 18109 | 2278 | 47 |
771909 | 771909 | 2020-11-27 | Morgan | Indiana | 18109 | 2226 | 47 |
768664 | 768664 | 2020-11-26 | Morgan | Indiana | 18109 | 2169 | 47 |
765418 | 765418 | 2020-11-25 | Morgan | Indiana | 18109 | 2122 | 47 |
762173 | 762173 | 2020-11-24 | Morgan | Indiana | 18109 | 2058 | 47 |
758928 | 758928 | 2020-11-23 | Morgan | Indiana | 18109 | 2020 | 47 |
755681 | 755681 | 2020-11-22 | Morgan | Indiana | 18109 | 1974 | 47 |
752435 | 752435 | 2020-11-21 | Morgan | Indiana | 18109 | 1922 | 47 |
749189 | 749189 | 2020-11-20 | Morgan | Indiana | 18109 | 1886 | 47 |
745943 | 745943 | 2020-11-19 | Morgan | Indiana | 18109 | 1845 | 47 |
742696 | 742696 | 2020-11-18 | Morgan | Indiana | 18109 | 1801 | 46 |
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);