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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4502 | 4502 | 2020-03-19 | Morgan | Colorado | 8087 | 1 | 0 |
7439 | 7439 | 2020-03-22 | Morgan | Indiana | 18109 | 1 | 0 |
8501 | 8501 | 2020-03-23 | Morgan | Georgia | 13211 | 1 | 0 |
9759 | 9759 | 2020-03-24 | Morgan | Georgia | 13211 | 1 | 0 |
11139 | 11139 | 2020-03-25 | Morgan | Georgia | 13211 | 1 | 0 |
11216 | 11216 | 2020-03-25 | Morgan | Illinois | 17137 | 1 | 0 |
12691 | 12691 | 2020-03-26 | Morgan | Georgia | 13211 | 1 | 0 |
12772 | 12772 | 2020-03-26 | Morgan | Illinois | 17137 | 1 | 0 |
14365 | 14365 | 2020-03-27 | Morgan | Georgia | 13211 | 1 | 0 |
14450 | 14450 | 2020-03-27 | Morgan | Illinois | 17137 | 1 | 0 |
16152 | 16152 | 2020-03-28 | Morgan | Georgia | 13211 | 1 | 0 |
17335 | 17335 | 2020-03-28 | Morgan | Tennessee | 47129 | 1 | 0 |
18049 | 18049 | 2020-03-29 | Morgan | Georgia | 13211 | 1 | 0 |
19284 | 19284 | 2020-03-29 | Morgan | Tennessee | 47129 | 1 | 0 |
19587 | 19587 | 2020-03-29 | Morgan | West Virginia | 54065 | 1 | 0 |
20042 | 20042 | 2020-03-30 | Morgan | Georgia | 13211 | 1 | 0 |
20736 | 20736 | 2020-03-30 | Morgan | Missouri | 29141 | 1 | 0 |
21341 | 21341 | 2020-03-30 | Morgan | Tennessee | 47129 | 1 | 0 |
21654 | 21654 | 2020-03-30 | Morgan | West Virginia | 54065 | 1 | 0 |
22855 | 22855 | 2020-03-31 | Morgan | Missouri | 29141 | 1 | 0 |
23480 | 23480 | 2020-03-31 | Morgan | Tennessee | 47129 | 1 | 0 |
23804 | 23804 | 2020-03-31 | Morgan | West Virginia | 54065 | 1 | 0 |
25043 | 25043 | 2020-04-01 | Morgan | Missouri | 29141 | 1 | 0 |
25682 | 25682 | 2020-04-01 | Morgan | Tennessee | 47129 | 1 | 0 |
26022 | 26022 | 2020-04-01 | Morgan | West Virginia | 54065 | 1 | 0 |
27299 | 27299 | 2020-04-02 | Morgan | Missouri | 29141 | 1 | 0 |
27961 | 27961 | 2020-04-02 | Morgan | Tennessee | 47129 | 1 | 0 |
28314 | 28314 | 2020-04-02 | Morgan | West Virginia | 54065 | 1 | 0 |
29620 | 29620 | 2020-04-03 | Morgan | Missouri | 29141 | 1 | 0 |
30668 | 30668 | 2020-04-03 | Morgan | West Virginia | 54065 | 1 | 0 |
32000 | 32000 | 2020-04-04 | Morgan | Missouri | 29141 | 1 | 0 |
33069 | 33069 | 2020-04-04 | Morgan | West Virginia | 54065 | 1 | 0 |
34428 | 34428 | 2020-04-05 | Morgan | Missouri | 29141 | 1 | 0 |
36893 | 36893 | 2020-04-06 | Morgan | Missouri | 29141 | 1 | 0 |
37276 | 37276 | 2020-04-06 | Morgan | Ohio | 39115 | 1 | 0 |
39406 | 39406 | 2020-04-07 | Morgan | Missouri | 29141 | 1 | 0 |
39794 | 39794 | 2020-04-07 | Morgan | Ohio | 39115 | 1 | 0 |
41960 | 41960 | 2020-04-08 | Morgan | Missouri | 29141 | 1 | 0 |
44537 | 44537 | 2020-04-09 | Morgan | Missouri | 29141 | 1 | 0 |
47146 | 47146 | 2020-04-10 | Morgan | Missouri | 29141 | 1 | 0 |
49794 | 49794 | 2020-04-11 | Morgan | Missouri | 29141 | 1 | 0 |
52036 | 52036 | 2020-04-12 | Morgan | Kentucky | 21175 | 1 | 0 |
52467 | 52467 | 2020-04-12 | Morgan | Missouri | 29141 | 1 | 0 |
54717 | 54717 | 2020-04-13 | Morgan | Kentucky | 21175 | 1 | 0 |
55149 | 55149 | 2020-04-13 | Morgan | Missouri | 29141 | 1 | 0 |
57415 | 57415 | 2020-04-14 | Morgan | Kentucky | 21175 | 1 | 0 |
57847 | 57847 | 2020-04-14 | Morgan | Missouri | 29141 | 1 | 0 |
60124 | 60124 | 2020-04-15 | Morgan | Kentucky | 21175 | 1 | 0 |
60561 | 60561 | 2020-04-15 | Morgan | Missouri | 29141 | 1 | 0 |
62844 | 62844 | 2020-04-16 | Morgan | Kentucky | 21175 | 1 | 0 |
65583 | 65583 | 2020-04-17 | Morgan | Kentucky | 21175 | 1 | 0 |
68332 | 68332 | 2020-04-18 | Morgan | Kentucky | 21175 | 1 | 0 |
71095 | 71095 | 2020-04-19 | Morgan | Kentucky | 21175 | 1 | 0 |
73867 | 73867 | 2020-04-20 | Morgan | Kentucky | 21175 | 1 | 0 |
76648 | 76648 | 2020-04-21 | Morgan | Kentucky | 21175 | 1 | 0 |
79433 | 79433 | 2020-04-22 | Morgan | Kentucky | 21175 | 1 | 0 |
82230 | 82230 | 2020-04-23 | Morgan | Kentucky | 21175 | 1 | 0 |
85033 | 85033 | 2020-04-24 | Morgan | Kentucky | 21175 | 1 | 0 |
87842 | 87842 | 2020-04-25 | Morgan | Kentucky | 21175 | 1 | 0 |
90658 | 90658 | 2020-04-26 | Morgan | Kentucky | 21175 | 1 | 0 |
93479 | 93479 | 2020-04-27 | Morgan | Kentucky | 21175 | 1 | 0 |
96313 | 96313 | 2020-04-28 | Morgan | Kentucky | 21175 | 1 | 0 |
99159 | 99159 | 2020-04-29 | Morgan | Kentucky | 21175 | 1 | 0 |
102011 | 102011 | 2020-04-30 | Morgan | Kentucky | 21175 | 1 | 0 |
104872 | 104872 | 2020-05-01 | Morgan | Kentucky | 21175 | 1 | 0 |
107737 | 107737 | 2020-05-02 | Morgan | Kentucky | 21175 | 1 | 0 |
110608 | 110608 | 2020-05-03 | Morgan | Kentucky | 21175 | 1 | 0 |
113485 | 113485 | 2020-05-04 | Morgan | Kentucky | 21175 | 1 | 0 |
116367 | 116367 | 2020-05-05 | Morgan | Kentucky | 21175 | 1 | 0 |
119328 | 119328 | 2020-05-06 | Morgan | Kentucky | 21175 | 1 | 0 |
122299 | 122299 | 2020-05-07 | Morgan | Kentucky | 21175 | 1 | 0 |
125281 | 125281 | 2020-05-08 | Morgan | Kentucky | 21175 | 1 | 0 |
128269 | 128269 | 2020-05-09 | Morgan | Kentucky | 21175 | 1 | 0 |
131259 | 131259 | 2020-05-10 | Morgan | Kentucky | 21175 | 1 | 0 |
134250 | 134250 | 2020-05-11 | Morgan | Kentucky | 21175 | 1 | 0 |
137240 | 137240 | 2020-05-12 | Morgan | Kentucky | 21175 | 1 | 0 |
140233 | 140233 | 2020-05-13 | Morgan | Kentucky | 21175 | 1 | 0 |
143229 | 143229 | 2020-05-14 | Morgan | Kentucky | 21175 | 1 | 0 |
146229 | 146229 | 2020-05-15 | Morgan | Kentucky | 21175 | 1 | 0 |
149234 | 149234 | 2020-05-16 | Morgan | Kentucky | 21175 | 1 | 0 |
152245 | 152245 | 2020-05-17 | Morgan | Kentucky | 21175 | 1 | 0 |
155259 | 155259 | 2020-05-18 | Morgan | Kentucky | 21175 | 1 | 0 |
158276 | 158276 | 2020-05-19 | Morgan | Kentucky | 21175 | 1 | 0 |
161302 | 161302 | 2020-05-20 | Morgan | Kentucky | 21175 | 1 | 0 |
164331 | 164331 | 2020-05-21 | Morgan | Kentucky | 21175 | 1 | 0 |
167367 | 167367 | 2020-05-22 | Morgan | Kentucky | 21175 | 1 | 0 |
170405 | 170405 | 2020-05-23 | Morgan | Kentucky | 21175 | 1 | 0 |
173446 | 173446 | 2020-05-24 | Morgan | Kentucky | 21175 | 1 | 0 |
176490 | 176490 | 2020-05-25 | Morgan | Kentucky | 21175 | 1 | 0 |
179534 | 179534 | 2020-05-26 | Morgan | Kentucky | 21175 | 1 | 0 |
182579 | 182579 | 2020-05-27 | Morgan | Kentucky | 21175 | 1 | 0 |
185634 | 185634 | 2020-05-28 | Morgan | Kentucky | 21175 | 1 | 0 |
188692 | 188692 | 2020-05-29 | Morgan | Kentucky | 21175 | 1 | 0 |
191756 | 191756 | 2020-05-30 | Morgan | Kentucky | 21175 | 1 | 0 |
194824 | 194824 | 2020-05-31 | Morgan | Kentucky | 21175 | 1 | 0 |
197895 | 197895 | 2020-06-01 | Morgan | Kentucky | 21175 | 1 | 0 |
200967 | 200967 | 2020-06-02 | Morgan | Kentucky | 21175 | 1 | 0 |
5278 | 5278 | 2020-03-20 | Morgan | Colorado | 8087 | 2 | 0 |
6205 | 6205 | 2020-03-21 | Morgan | Colorado | 8087 | 2 | 0 |
7240 | 7240 | 2020-03-22 | Morgan | Colorado | 8087 | 2 | 0 |
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);