ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,570 rows where county = "Midland" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4753 | 4753 | 2020-03-19 | Midland | Michigan | 26111 | 1 | 0 |
5572 | 5572 | 2020-03-20 | Midland | Michigan | 26111 | 3 | 0 |
6537 | 6537 | 2020-03-21 | Midland | Michigan | 26111 | 3 | 0 |
6980 | 6980 | 2020-03-21 | Midland | Texas | 48329 | 1 | 0 |
7617 | 7617 | 2020-03-22 | Midland | Michigan | 26111 | 5 | 0 |
8110 | 8110 | 2020-03-22 | Midland | Texas | 48329 | 1 | 0 |
8791 | 8791 | 2020-03-23 | Midland | Michigan | 26111 | 5 | 0 |
9328 | 9328 | 2020-03-23 | Midland | Texas | 48329 | 1 | 0 |
10085 | 10085 | 2020-03-24 | Midland | Michigan | 26111 | 5 | 0 |
10668 | 10668 | 2020-03-24 | Midland | Texas | 48329 | 1 | 0 |
11500 | 11500 | 2020-03-25 | Midland | Michigan | 26111 | 6 | 0 |
13084 | 13084 | 2020-03-26 | Midland | Michigan | 26111 | 6 | 0 |
14796 | 14796 | 2020-03-27 | Midland | Michigan | 26111 | 8 | 0 |
16616 | 16616 | 2020-03-28 | Midland | Michigan | 26111 | 8 | 0 |
18532 | 18532 | 2020-03-29 | Midland | Michigan | 26111 | 8 | 0 |
20551 | 20551 | 2020-03-30 | Midland | Michigan | 26111 | 9 | 0 |
22662 | 22662 | 2020-03-31 | Midland | Michigan | 26111 | 10 | 0 |
24842 | 24842 | 2020-04-01 | Midland | Michigan | 26111 | 12 | 0 |
27095 | 27095 | 2020-04-02 | Midland | Michigan | 26111 | 15 | 0 |
29414 | 29414 | 2020-04-03 | Midland | Michigan | 26111 | 16 | 0 |
31792 | 31792 | 2020-04-04 | Midland | Michigan | 26111 | 17 | 0 |
34217 | 34217 | 2020-04-05 | Midland | Michigan | 26111 | 18 | 0 |
36676 | 36676 | 2020-04-06 | Midland | Michigan | 26111 | 22 | 0 |
39185 | 39185 | 2020-04-07 | Midland | Michigan | 26111 | 22 | 0 |
12170 | 12170 | 2020-03-25 | Midland | Texas | 48329 | 3 | 1 |
13802 | 13802 | 2020-03-26 | Midland | Texas | 48329 | 4 | 1 |
15558 | 15558 | 2020-03-27 | Midland | Texas | 48329 | 6 | 1 |
17429 | 17429 | 2020-03-28 | Midland | Texas | 48329 | 8 | 1 |
19384 | 19384 | 2020-03-29 | Midland | Texas | 48329 | 11 | 1 |
21445 | 21445 | 2020-03-30 | Midland | Texas | 48329 | 13 | 1 |
23584 | 23584 | 2020-03-31 | Midland | Texas | 48329 | 13 | 1 |
25796 | 25796 | 2020-04-01 | Midland | Texas | 48329 | 16 | 1 |
28082 | 28082 | 2020-04-02 | Midland | Texas | 48329 | 16 | 1 |
30418 | 30418 | 2020-04-03 | Midland | Texas | 48329 | 19 | 1 |
32814 | 32814 | 2020-04-04 | Midland | Texas | 48329 | 22 | 1 |
35252 | 35252 | 2020-04-05 | Midland | Texas | 48329 | 24 | 1 |
37728 | 37728 | 2020-04-06 | Midland | Texas | 48329 | 27 | 1 |
40256 | 40256 | 2020-04-07 | Midland | Texas | 48329 | 27 | 1 |
41737 | 41737 | 2020-04-08 | Midland | Michigan | 26111 | 24 | 1 |
42824 | 42824 | 2020-04-08 | Midland | Texas | 48329 | 30 | 1 |
44313 | 44313 | 2020-04-09 | Midland | Michigan | 26111 | 28 | 1 |
45416 | 45416 | 2020-04-09 | Midland | Texas | 48329 | 30 | 1 |
46922 | 46922 | 2020-04-10 | Midland | Michigan | 26111 | 28 | 1 |
48037 | 48037 | 2020-04-10 | Midland | Texas | 48329 | 31 | 1 |
49566 | 49566 | 2020-04-11 | Midland | Michigan | 26111 | 30 | 1 |
50695 | 50695 | 2020-04-11 | Midland | Texas | 48329 | 31 | 1 |
52236 | 52236 | 2020-04-12 | Midland | Michigan | 26111 | 31 | 1 |
54917 | 54917 | 2020-04-13 | Midland | Michigan | 26111 | 33 | 1 |
57615 | 57615 | 2020-04-14 | Midland | Michigan | 26111 | 33 | 1 |
60325 | 60325 | 2020-04-15 | Midland | Michigan | 26111 | 36 | 1 |
63047 | 63047 | 2020-04-16 | Midland | Michigan | 26111 | 41 | 1 |
65785 | 65785 | 2020-04-17 | Midland | Michigan | 26111 | 42 | 1 |
53370 | 53370 | 2020-04-12 | Midland | Texas | 48329 | 32 | 2 |
56058 | 56058 | 2020-04-13 | Midland | Texas | 48329 | 32 | 2 |
58763 | 58763 | 2020-04-14 | Midland | Texas | 48329 | 35 | 2 |
61481 | 61481 | 2020-04-15 | Midland | Texas | 48329 | 35 | 2 |
64210 | 64210 | 2020-04-16 | Midland | Texas | 48329 | 39 | 2 |
68536 | 68536 | 2020-04-18 | Midland | Michigan | 26111 | 43 | 2 |
71300 | 71300 | 2020-04-19 | Midland | Michigan | 26111 | 45 | 2 |
66957 | 66957 | 2020-04-17 | Midland | Texas | 48329 | 42 | 3 |
69717 | 69717 | 2020-04-18 | Midland | Texas | 48329 | 42 | 3 |
72486 | 72486 | 2020-04-19 | Midland | Texas | 48329 | 43 | 3 |
74072 | 74072 | 2020-04-20 | Midland | Michigan | 26111 | 47 | 3 |
75262 | 75262 | 2020-04-20 | Midland | Texas | 48329 | 64 | 3 |
76852 | 76852 | 2020-04-21 | Midland | Michigan | 26111 | 48 | 3 |
79638 | 79638 | 2020-04-22 | Midland | Michigan | 26111 | 47 | 3 |
82433 | 82433 | 2020-04-23 | Midland | Michigan | 26111 | 51 | 3 |
85237 | 85237 | 2020-04-24 | Midland | Michigan | 26111 | 50 | 3 |
88047 | 88047 | 2020-04-25 | Midland | Michigan | 26111 | 51 | 3 |
90863 | 90863 | 2020-04-26 | Midland | Michigan | 26111 | 52 | 3 |
93684 | 93684 | 2020-04-27 | Midland | Michigan | 26111 | 56 | 3 |
78044 | 78044 | 2020-04-21 | Midland | Texas | 48329 | 65 | 4 |
80835 | 80835 | 2020-04-22 | Midland | Texas | 48329 | 67 | 4 |
96519 | 96519 | 2020-04-28 | Midland | Michigan | 26111 | 56 | 4 |
83636 | 83636 | 2020-04-23 | Midland | Texas | 48329 | 69 | 5 |
86441 | 86441 | 2020-04-24 | Midland | Texas | 48329 | 70 | 5 |
89256 | 89256 | 2020-04-25 | Midland | Texas | 48329 | 71 | 5 |
92073 | 92073 | 2020-04-26 | Midland | Texas | 48329 | 73 | 5 |
94902 | 94902 | 2020-04-27 | Midland | Texas | 48329 | 74 | 5 |
99365 | 99365 | 2020-04-29 | Midland | Michigan | 26111 | 59 | 5 |
102217 | 102217 | 2020-04-30 | Midland | Michigan | 26111 | 61 | 5 |
97743 | 97743 | 2020-04-28 | Midland | Texas | 48329 | 75 | 6 |
100593 | 100593 | 2020-04-29 | Midland | Texas | 48329 | 76 | 6 |
103448 | 103448 | 2020-04-30 | Midland | Texas | 48329 | 79 | 6 |
105077 | 105077 | 2020-05-01 | Midland | Michigan | 26111 | 60 | 6 |
106312 | 106312 | 2020-05-01 | Midland | Texas | 48329 | 82 | 6 |
107941 | 107941 | 2020-05-02 | Midland | Michigan | 26111 | 62 | 6 |
109181 | 109181 | 2020-05-02 | Midland | Texas | 48329 | 82 | 6 |
110813 | 110813 | 2020-05-03 | Midland | Michigan | 26111 | 62 | 6 |
112055 | 112055 | 2020-05-03 | Midland | Texas | 48329 | 82 | 6 |
113691 | 113691 | 2020-05-04 | Midland | Michigan | 26111 | 62 | 7 |
116572 | 116572 | 2020-05-05 | Midland | Michigan | 26111 | 62 | 7 |
119533 | 119533 | 2020-05-06 | Midland | Michigan | 26111 | 63 | 7 |
114937 | 114937 | 2020-05-04 | Midland | Texas | 48329 | 89 | 8 |
117896 | 117896 | 2020-05-05 | Midland | Texas | 48329 | 91 | 8 |
120860 | 120860 | 2020-05-06 | Midland | Texas | 48329 | 91 | 8 |
122505 | 122505 | 2020-05-07 | Midland | Michigan | 26111 | 63 | 8 |
125487 | 125487 | 2020-05-08 | Midland | Michigan | 26111 | 66 | 8 |
128474 | 128474 | 2020-05-09 | Midland | Michigan | 26111 | 66 | 8 |
131464 | 131464 | 2020-05-10 | Midland | Michigan | 26111 | 66 | 8 |
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);