ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,549 rows where county = "Morgan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053794 | 1053794 | 2021-02-22 | Morgan | Colorado | 8087 | 2415 | 90 |
1053999 | 1053999 | 2021-02-22 | Morgan | Georgia | 13211 | 1890 | 17 |
1054174 | 1054174 | 2021-02-22 | Morgan | Illinois | 17137 | 3631 | 98 |
1054263 | 1054263 | 2021-02-22 | Morgan | Indiana | 18109 | 6046 | 129 |
1054594 | 1054594 | 2021-02-22 | Morgan | Kentucky | 21175 | 2010 | 1 |
1055075 | 1055075 | 2021-02-22 | Morgan | Missouri | 29141 | 1620 | 39 |
1055623 | 1055623 | 2021-02-22 | Morgan | Ohio | 39115 | 980 | 34 |
1056096 | 1056096 | 2021-02-22 | Morgan | Tennessee | 47129 | 2282 | 36 |
1056396 | 1056396 | 2021-02-22 | Morgan | Utah | 49029 | 1119 | 11 |
1056634 | 1056634 | 2021-02-22 | Morgan | West Virginia | 54065 | 919 | 13 |
1050310 | 1050310 | 2021-02-21 | Morgan | Alabama | 1103 | 13483 | 241 |
1050547 | 1050547 | 2021-02-21 | Morgan | Colorado | 8087 | 2415 | 90 |
1050752 | 1050752 | 2021-02-21 | Morgan | Georgia | 13211 | 1889 | 17 |
1050927 | 1050927 | 2021-02-21 | Morgan | Illinois | 17137 | 3631 | 98 |
1051016 | 1051016 | 2021-02-21 | Morgan | Indiana | 18109 | 6037 | 129 |
1051347 | 1051347 | 2021-02-21 | Morgan | Kentucky | 21175 | 2010 | 1 |
1051828 | 1051828 | 2021-02-21 | Morgan | Missouri | 29141 | 1620 | 39 |
1052377 | 1052377 | 2021-02-21 | Morgan | Ohio | 39115 | 977 | 34 |
1052850 | 1052850 | 2021-02-21 | Morgan | Tennessee | 47129 | 2280 | 36 |
1053150 | 1053150 | 2021-02-21 | Morgan | Utah | 49029 | 1118 | 11 |
1053388 | 1053388 | 2021-02-21 | Morgan | West Virginia | 54065 | 919 | 13 |
1047063 | 1047063 | 2021-02-20 | Morgan | Alabama | 1103 | 13468 | 241 |
1047300 | 1047300 | 2021-02-20 | Morgan | Colorado | 8087 | 2412 | 90 |
1047505 | 1047505 | 2021-02-20 | Morgan | Georgia | 13211 | 1888 | 17 |
1047680 | 1047680 | 2021-02-20 | Morgan | Illinois | 17137 | 3631 | 98 |
1047769 | 1047769 | 2021-02-20 | Morgan | Indiana | 18109 | 6030 | 129 |
1048100 | 1048100 | 2021-02-20 | Morgan | Kentucky | 21175 | 2010 | 1 |
1048581 | 1048581 | 2021-02-20 | Morgan | Missouri | 29141 | 1620 | 39 |
1049130 | 1049130 | 2021-02-20 | Morgan | Ohio | 39115 | 974 | 34 |
1049603 | 1049603 | 2021-02-20 | Morgan | Tennessee | 47129 | 2276 | 36 |
1049903 | 1049903 | 2021-02-20 | Morgan | Utah | 49029 | 1118 | 11 |
1050141 | 1050141 | 2021-02-20 | Morgan | West Virginia | 54065 | 910 | 13 |
1043818 | 1043818 | 2021-02-19 | Morgan | Alabama | 1103 | 13464 | 240 |
1044055 | 1044055 | 2021-02-19 | Morgan | Colorado | 8087 | 2413 | 90 |
1044260 | 1044260 | 2021-02-19 | Morgan | Georgia | 13211 | 1883 | 17 |
1044435 | 1044435 | 2021-02-19 | Morgan | Illinois | 17137 | 3619 | 97 |
1044524 | 1044524 | 2021-02-19 | Morgan | Indiana | 18109 | 6014 | 129 |
1044855 | 1044855 | 2021-02-19 | Morgan | Kentucky | 21175 | 1996 | 1 |
1045335 | 1045335 | 2021-02-19 | Morgan | Missouri | 29141 | 1619 | 39 |
1045883 | 1045883 | 2021-02-19 | Morgan | Ohio | 39115 | 966 | 34 |
1046356 | 1046356 | 2021-02-19 | Morgan | Tennessee | 47129 | 2272 | 34 |
1046656 | 1046656 | 2021-02-19 | Morgan | Utah | 49029 | 1116 | 11 |
1046894 | 1046894 | 2021-02-19 | Morgan | West Virginia | 54065 | 909 | 13 |
1040573 | 1040573 | 2021-02-18 | Morgan | Alabama | 1103 | 13448 | 239 |
1040810 | 1040810 | 2021-02-18 | Morgan | Colorado | 8087 | 2409 | 90 |
1041015 | 1041015 | 2021-02-18 | Morgan | Georgia | 13211 | 1880 | 16 |
1041190 | 1041190 | 2021-02-18 | Morgan | Illinois | 17137 | 3619 | 97 |
1041279 | 1041279 | 2021-02-18 | Morgan | Indiana | 18109 | 5993 | 129 |
1041610 | 1041610 | 2021-02-18 | Morgan | Kentucky | 21175 | 1983 | 1 |
1042090 | 1042090 | 2021-02-18 | Morgan | Missouri | 29141 | 1619 | 39 |
1042638 | 1042638 | 2021-02-18 | Morgan | Ohio | 39115 | 963 | 34 |
1043111 | 1043111 | 2021-02-18 | Morgan | Tennessee | 47129 | 2271 | 34 |
1043411 | 1043411 | 2021-02-18 | Morgan | Utah | 49029 | 1116 | 11 |
1043649 | 1043649 | 2021-02-18 | Morgan | West Virginia | 54065 | 907 | 13 |
1037328 | 1037328 | 2021-02-17 | Morgan | Alabama | 1103 | 13424 | 237 |
1037565 | 1037565 | 2021-02-17 | Morgan | Colorado | 8087 | 2406 | 90 |
1037770 | 1037770 | 2021-02-17 | Morgan | Georgia | 13211 | 1875 | 15 |
1037945 | 1037945 | 2021-02-17 | Morgan | Illinois | 17137 | 3619 | 97 |
1038034 | 1038034 | 2021-02-17 | Morgan | Indiana | 18109 | 5988 | 129 |
1038365 | 1038365 | 2021-02-17 | Morgan | Kentucky | 21175 | 1971 | 1 |
1038845 | 1038845 | 2021-02-17 | Morgan | Missouri | 29141 | 1619 | 39 |
1039393 | 1039393 | 2021-02-17 | Morgan | Ohio | 39115 | 952 | 34 |
1039866 | 1039866 | 2021-02-17 | Morgan | Tennessee | 47129 | 2261 | 34 |
1040166 | 1040166 | 2021-02-17 | Morgan | Utah | 49029 | 1115 | 11 |
1040404 | 1040404 | 2021-02-17 | Morgan | West Virginia | 54065 | 905 | 13 |
1034083 | 1034083 | 2021-02-16 | Morgan | Alabama | 1103 | 13418 | 234 |
1034320 | 1034320 | 2021-02-16 | Morgan | Colorado | 8087 | 2405 | 90 |
1034525 | 1034525 | 2021-02-16 | Morgan | Georgia | 13211 | 1871 | 15 |
1034700 | 1034700 | 2021-02-16 | Morgan | Illinois | 17137 | 3608 | 97 |
1034789 | 1034789 | 2021-02-16 | Morgan | Indiana | 18109 | 5967 | 129 |
1035120 | 1035120 | 2021-02-16 | Morgan | Kentucky | 21175 | 1964 | 1 |
1035600 | 1035600 | 2021-02-16 | Morgan | Missouri | 29141 | 1619 | 39 |
1036148 | 1036148 | 2021-02-16 | Morgan | Ohio | 39115 | 943 | 34 |
1036621 | 1036621 | 2021-02-16 | Morgan | Tennessee | 47129 | 2257 | 34 |
1036921 | 1036921 | 2021-02-16 | Morgan | Utah | 49029 | 1114 | 11 |
1037159 | 1037159 | 2021-02-16 | Morgan | West Virginia | 54065 | 903 | 13 |
1030837 | 1030837 | 2021-02-15 | Morgan | Alabama | 1103 | 13407 | 234 |
1031074 | 1031074 | 2021-02-15 | Morgan | Colorado | 8087 | 2405 | 90 |
1031279 | 1031279 | 2021-02-15 | Morgan | Georgia | 13211 | 1852 | 13 |
1031454 | 1031454 | 2021-02-15 | Morgan | Illinois | 17137 | 3542 | 96 |
1031543 | 1031543 | 2021-02-15 | Morgan | Indiana | 18109 | 5960 | 129 |
1031874 | 1031874 | 2021-02-15 | Morgan | Kentucky | 21175 | 1964 | 1 |
1032355 | 1032355 | 2021-02-15 | Morgan | Missouri | 29141 | 1618 | 39 |
1032903 | 1032903 | 2021-02-15 | Morgan | Ohio | 39115 | 946 | 33 |
1033376 | 1033376 | 2021-02-15 | Morgan | Tennessee | 47129 | 2241 | 34 |
1033676 | 1033676 | 2021-02-15 | Morgan | Utah | 49029 | 1114 | 11 |
1033914 | 1033914 | 2021-02-15 | Morgan | West Virginia | 54065 | 903 | 13 |
1027590 | 1027590 | 2021-02-14 | Morgan | Alabama | 1103 | 13395 | 234 |
1027827 | 1027827 | 2021-02-14 | Morgan | Colorado | 8087 | 2403 | 90 |
1028032 | 1028032 | 2021-02-14 | Morgan | Georgia | 13211 | 1847 | 13 |
1028207 | 1028207 | 2021-02-14 | Morgan | Illinois | 17137 | 3542 | 96 |
1028296 | 1028296 | 2021-02-14 | Morgan | Indiana | 18109 | 5943 | 129 |
1028627 | 1028627 | 2021-02-14 | Morgan | Kentucky | 21175 | 1964 | 1 |
1029108 | 1029108 | 2021-02-14 | Morgan | Missouri | 29141 | 1616 | 39 |
1029657 | 1029657 | 2021-02-14 | Morgan | Ohio | 39115 | 940 | 33 |
1030130 | 1030130 | 2021-02-14 | Morgan | Tennessee | 47129 | 2233 | 34 |
1030430 | 1030430 | 2021-02-14 | Morgan | Utah | 49029 | 1114 | 11 |
1030668 | 1030668 | 2021-02-14 | Morgan | West Virginia | 54065 | 902 | 13 |
1024345 | 1024345 | 2021-02-13 | Morgan | Alabama | 1103 | 13375 | 234 |
1024582 | 1024582 | 2021-02-13 | Morgan | Colorado | 8087 | 2404 | 90 |
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);