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 deaths
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 |
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 |
7439 | 7439 | 2020-03-22 | Morgan | Indiana | 18109 | 1 | 0 |
8385 | 8385 | 2020-03-23 | Morgan | Colorado | 8087 | 3 | 0 |
8501 | 8501 | 2020-03-23 | Morgan | Georgia | 13211 | 1 | 0 |
8597 | 8597 | 2020-03-23 | Morgan | Indiana | 18109 | 3 | 0 |
9499 | 9499 | 2020-03-24 | Morgan | Alabama | 1103 | 2 | 0 |
9630 | 9630 | 2020-03-24 | Morgan | Colorado | 8087 | 3 | 0 |
9759 | 9759 | 2020-03-24 | Morgan | Georgia | 13211 | 1 | 0 |
9868 | 9868 | 2020-03-24 | Morgan | Indiana | 18109 | 3 | 0 |
10865 | 10865 | 2020-03-25 | Morgan | Alabama | 1103 | 5 | 0 |
11003 | 11003 | 2020-03-25 | Morgan | Colorado | 8087 | 3 | 0 |
11139 | 11139 | 2020-03-25 | Morgan | Georgia | 13211 | 1 | 0 |
11216 | 11216 | 2020-03-25 | Morgan | Illinois | 17137 | 1 | 0 |
11263 | 11263 | 2020-03-25 | Morgan | Indiana | 18109 | 5 | 0 |
12404 | 12404 | 2020-03-26 | Morgan | Alabama | 1103 | 9 | 0 |
12549 | 12549 | 2020-03-26 | Morgan | Colorado | 8087 | 3 | 0 |
12691 | 12691 | 2020-03-26 | Morgan | Georgia | 13211 | 1 | 0 |
12772 | 12772 | 2020-03-26 | Morgan | Illinois | 17137 | 1 | 0 |
12821 | 12821 | 2020-03-26 | Morgan | Indiana | 18109 | 7 | 0 |
13835 | 13835 | 2020-03-26 | Morgan | Utah | 49029 | 2 | 0 |
14065 | 14065 | 2020-03-27 | Morgan | Alabama | 1103 | 13 | 0 |
14218 | 14218 | 2020-03-27 | Morgan | Colorado | 8087 | 4 | 0 |
14365 | 14365 | 2020-03-27 | Morgan | Georgia | 13211 | 1 | 0 |
14450 | 14450 | 2020-03-27 | Morgan | Illinois | 17137 | 1 | 0 |
14506 | 14506 | 2020-03-27 | Morgan | Indiana | 18109 | 10 | 0 |
15600 | 15600 | 2020-03-27 | Morgan | Utah | 49029 | 2 | 0 |
15844 | 15844 | 2020-03-28 | Morgan | Alabama | 1103 | 15 | 0 |
16002 | 16002 | 2020-03-28 | Morgan | Colorado | 8087 | 4 | 0 |
16152 | 16152 | 2020-03-28 | Morgan | Georgia | 13211 | 1 | 0 |
16246 | 16246 | 2020-03-28 | Morgan | Illinois | 17137 | 3 | 0 |
16304 | 16304 | 2020-03-28 | Morgan | Indiana | 18109 | 14 | 0 |
17335 | 17335 | 2020-03-28 | Morgan | Tennessee | 47129 | 1 | 0 |
17473 | 17473 | 2020-03-28 | Morgan | Utah | 49029 | 2 | 0 |
17728 | 17728 | 2020-03-29 | Morgan | Alabama | 1103 | 17 | 0 |
17894 | 17894 | 2020-03-29 | Morgan | Colorado | 8087 | 5 | 0 |
18049 | 18049 | 2020-03-29 | Morgan | Georgia | 13211 | 1 | 0 |
18148 | 18148 | 2020-03-29 | Morgan | Illinois | 17137 | 3 | 0 |
19284 | 19284 | 2020-03-29 | Morgan | Tennessee | 47129 | 1 | 0 |
19432 | 19432 | 2020-03-29 | Morgan | Utah | 49029 | 2 | 0 |
19587 | 19587 | 2020-03-29 | Morgan | West Virginia | 54065 | 1 | 0 |
19700 | 19700 | 2020-03-30 | Morgan | Alabama | 1103 | 19 | 0 |
19872 | 19872 | 2020-03-30 | Morgan | Colorado | 8087 | 4 | 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 |
21495 | 21495 | 2020-03-30 | Morgan | Utah | 49029 | 3 | 0 |
21654 | 21654 | 2020-03-30 | Morgan | West Virginia | 54065 | 1 | 0 |
21772 | 21772 | 2020-03-31 | Morgan | Alabama | 1103 | 20 | 0 |
21948 | 21948 | 2020-03-31 | Morgan | Colorado | 8087 | 4 | 0 |
22123 | 22123 | 2020-03-31 | Morgan | Georgia | 13211 | 2 | 0 |
22855 | 22855 | 2020-03-31 | Morgan | Missouri | 29141 | 1 | 0 |
23480 | 23480 | 2020-03-31 | Morgan | Tennessee | 47129 | 1 | 0 |
23634 | 23634 | 2020-03-31 | Morgan | Utah | 49029 | 3 | 0 |
23804 | 23804 | 2020-03-31 | Morgan | West Virginia | 54065 | 1 | 0 |
23928 | 23928 | 2020-04-01 | Morgan | Alabama | 1103 | 20 | 0 |
24107 | 24107 | 2020-04-01 | Morgan | Colorado | 8087 | 5 | 0 |
24287 | 24287 | 2020-04-01 | Morgan | Georgia | 13211 | 2 | 0 |
25043 | 25043 | 2020-04-01 | Morgan | Missouri | 29141 | 1 | 0 |
25682 | 25682 | 2020-04-01 | Morgan | Tennessee | 47129 | 1 | 0 |
25849 | 25849 | 2020-04-01 | Morgan | Utah | 49029 | 3 | 0 |
26022 | 26022 | 2020-04-01 | Morgan | West Virginia | 54065 | 1 | 0 |
26150 | 26150 | 2020-04-02 | Morgan | Alabama | 1103 | 22 | 0 |
26337 | 26337 | 2020-04-02 | Morgan | Colorado | 8087 | 7 | 0 |
26518 | 26518 | 2020-04-02 | Morgan | Georgia | 13211 | 2 | 0 |
27299 | 27299 | 2020-04-02 | Morgan | Missouri | 29141 | 1 | 0 |
27961 | 27961 | 2020-04-02 | Morgan | Tennessee | 47129 | 1 | 0 |
28138 | 28138 | 2020-04-02 | Morgan | Utah | 49029 | 3 | 0 |
28314 | 28314 | 2020-04-02 | Morgan | West Virginia | 54065 | 1 | 0 |
28447 | 28447 | 2020-04-03 | Morgan | Alabama | 1103 | 24 | 0 |
28638 | 28638 | 2020-04-03 | Morgan | Colorado | 8087 | 7 | 0 |
28823 | 28823 | 2020-04-03 | Morgan | Georgia | 13211 | 2 | 0 |
29620 | 29620 | 2020-04-03 | Morgan | Missouri | 29141 | 1 | 0 |
30296 | 30296 | 2020-04-03 | Morgan | Tennessee | 47129 | 2 | 0 |
30481 | 30481 | 2020-04-03 | Morgan | Utah | 49029 | 3 | 0 |
30668 | 30668 | 2020-04-03 | Morgan | West Virginia | 54065 | 1 | 0 |
30804 | 30804 | 2020-04-04 | Morgan | Alabama | 1103 | 24 | 0 |
30995 | 30995 | 2020-04-04 | Morgan | Colorado | 8087 | 16 | 0 |
31183 | 31183 | 2020-04-04 | Morgan | Georgia | 13211 | 2 | 0 |
32000 | 32000 | 2020-04-04 | Morgan | Missouri | 29141 | 1 | 0 |
32687 | 32687 | 2020-04-04 | Morgan | Tennessee | 47129 | 4 | 0 |
32879 | 32879 | 2020-04-04 | Morgan | Utah | 49029 | 3 | 0 |
33069 | 33069 | 2020-04-04 | Morgan | West Virginia | 54065 | 1 | 0 |
33208 | 33208 | 2020-04-05 | Morgan | Alabama | 1103 | 27 | 0 |
33401 | 33401 | 2020-04-05 | Morgan | Colorado | 8087 | 17 | 0 |
33590 | 33590 | 2020-04-05 | Morgan | Georgia | 13211 | 2 | 0 |
34428 | 34428 | 2020-04-05 | Morgan | Missouri | 29141 | 1 | 0 |
35124 | 35124 | 2020-04-05 | Morgan | Tennessee | 47129 | 4 | 0 |
35317 | 35317 | 2020-04-05 | Morgan | Utah | 49029 | 3 | 0 |
35507 | 35507 | 2020-04-05 | Morgan | West Virginia | 54065 | 3 | 0 |
35647 | 35647 | 2020-04-06 | Morgan | Alabama | 1103 | 30 | 0 |
35846 | 35846 | 2020-04-06 | Morgan | Colorado | 8087 | 19 | 0 |
36040 | 36040 | 2020-04-06 | Morgan | Georgia | 13211 | 6 | 0 |
36893 | 36893 | 2020-04-06 | Morgan | Missouri | 29141 | 1 | 0 |
37276 | 37276 | 2020-04-06 | Morgan | Ohio | 39115 | 1 | 0 |
37600 | 37600 | 2020-04-06 | Morgan | Tennessee | 47129 | 5 | 0 |
37795 | 37795 | 2020-04-06 | Morgan | Utah | 49029 | 3 | 0 |
37992 | 37992 | 2020-04-06 | Morgan | West Virginia | 54065 | 3 | 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);