ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Morgan" and fips = 18109 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- …
state 1
- Indiana 783
fips 1
- 18109 · 783 ✖
county 1
- Morgan · 783 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7439 | 7439 | 2020-03-22 | Morgan | Indiana | 18109 | 1 | 0 |
8597 | 8597 | 2020-03-23 | Morgan | Indiana | 18109 | 3 | 0 |
9868 | 9868 | 2020-03-24 | Morgan | Indiana | 18109 | 3 | 0 |
11263 | 11263 | 2020-03-25 | Morgan | Indiana | 18109 | 5 | 0 |
12821 | 12821 | 2020-03-26 | Morgan | Indiana | 18109 | 7 | 0 |
14506 | 14506 | 2020-03-27 | Morgan | Indiana | 18109 | 10 | 0 |
16304 | 16304 | 2020-03-28 | Morgan | Indiana | 18109 | 14 | 0 |
18208 | 18208 | 2020-03-29 | Morgan | Indiana | 18109 | 20 | 1 |
20214 | 20214 | 2020-03-30 | Morgan | Indiana | 18109 | 23 | 1 |
22309 | 22309 | 2020-03-31 | Morgan | Indiana | 18109 | 32 | 1 |
24480 | 24480 | 2020-04-01 | Morgan | Indiana | 18109 | 41 | 1 |
26719 | 26719 | 2020-04-02 | Morgan | Indiana | 18109 | 48 | 1 |
29029 | 29029 | 2020-04-03 | Morgan | Indiana | 18109 | 52 | 1 |
31396 | 31396 | 2020-04-04 | Morgan | Indiana | 18109 | 60 | 1 |
33807 | 33807 | 2020-04-05 | Morgan | Indiana | 18109 | 65 | 1 |
36260 | 36260 | 2020-04-06 | Morgan | Indiana | 18109 | 76 | 1 |
38758 | 38758 | 2020-04-07 | Morgan | Indiana | 18109 | 79 | 1 |
41304 | 41304 | 2020-04-08 | Morgan | Indiana | 18109 | 82 | 1 |
43880 | 43880 | 2020-04-09 | Morgan | Indiana | 18109 | 83 | 3 |
46484 | 46484 | 2020-04-10 | Morgan | Indiana | 18109 | 90 | 4 |
49118 | 49118 | 2020-04-11 | Morgan | Indiana | 18109 | 95 | 4 |
51781 | 51781 | 2020-04-12 | Morgan | Indiana | 18109 | 102 | 4 |
54462 | 54462 | 2020-04-13 | Morgan | Indiana | 18109 | 104 | 4 |
57155 | 57155 | 2020-04-14 | Morgan | Indiana | 18109 | 105 | 4 |
59863 | 59863 | 2020-04-15 | Morgan | Indiana | 18109 | 106 | 4 |
62584 | 62584 | 2020-04-16 | Morgan | Indiana | 18109 | 109 | 4 |
65318 | 65318 | 2020-04-17 | Morgan | Indiana | 18109 | 112 | 4 |
68067 | 68067 | 2020-04-18 | Morgan | Indiana | 18109 | 112 | 4 |
70829 | 70829 | 2020-04-19 | Morgan | Indiana | 18109 | 117 | 4 |
73600 | 73600 | 2020-04-20 | Morgan | Indiana | 18109 | 120 | 4 |
76377 | 76377 | 2020-04-21 | Morgan | Indiana | 18109 | 125 | 4 |
79161 | 79161 | 2020-04-22 | Morgan | Indiana | 18109 | 125 | 5 |
81954 | 81954 | 2020-04-23 | Morgan | Indiana | 18109 | 126 | 5 |
84754 | 84754 | 2020-04-24 | Morgan | Indiana | 18109 | 129 | 5 |
87564 | 87564 | 2020-04-25 | Morgan | Indiana | 18109 | 134 | 4 |
90380 | 90380 | 2020-04-26 | Morgan | Indiana | 18109 | 132 | 5 |
93199 | 93199 | 2020-04-27 | Morgan | Indiana | 18109 | 133 | 4 |
96031 | 96031 | 2020-04-28 | Morgan | Indiana | 18109 | 137 | 4 |
98875 | 98875 | 2020-04-29 | Morgan | Indiana | 18109 | 142 | 5 |
101726 | 101726 | 2020-04-30 | Morgan | Indiana | 18109 | 155 | 5 |
104582 | 104582 | 2020-05-01 | Morgan | Indiana | 18109 | 159 | 6 |
107447 | 107447 | 2020-05-02 | Morgan | Indiana | 18109 | 163 | 6 |
110317 | 110317 | 2020-05-03 | Morgan | Indiana | 18109 | 166 | 7 |
113192 | 113192 | 2020-05-04 | Morgan | Indiana | 18109 | 171 | 8 |
116075 | 116075 | 2020-05-05 | Morgan | Indiana | 18109 | 174 | 8 |
119035 | 119035 | 2020-05-06 | Morgan | Indiana | 18109 | 179 | 9 |
122005 | 122005 | 2020-05-07 | Morgan | Indiana | 18109 | 186 | 9 |
124985 | 124985 | 2020-05-08 | Morgan | Indiana | 18109 | 185 | 9 |
127972 | 127972 | 2020-05-09 | Morgan | Indiana | 18109 | 197 | 9 |
130963 | 130963 | 2020-05-10 | Morgan | Indiana | 18109 | 200 | 9 |
133953 | 133953 | 2020-05-11 | Morgan | Indiana | 18109 | 211 | 9 |
136942 | 136942 | 2020-05-12 | Morgan | Indiana | 18109 | 213 | 10 |
139934 | 139934 | 2020-05-13 | Morgan | Indiana | 18109 | 229 | 14 |
142930 | 142930 | 2020-05-14 | Morgan | Indiana | 18109 | 231 | 14 |
145930 | 145930 | 2020-05-15 | Morgan | Indiana | 18109 | 247 | 16 |
148934 | 148934 | 2020-05-16 | Morgan | Indiana | 18109 | 248 | 19 |
151943 | 151943 | 2020-05-17 | Morgan | Indiana | 18109 | 251 | 21 |
154955 | 154955 | 2020-05-18 | Morgan | Indiana | 18109 | 254 | 21 |
157971 | 157971 | 2020-05-19 | Morgan | Indiana | 18109 | 257 | 23 |
160997 | 160997 | 2020-05-20 | Morgan | Indiana | 18109 | 258 | 23 |
164025 | 164025 | 2020-05-21 | Morgan | Indiana | 18109 | 259 | 24 |
167058 | 167058 | 2020-05-22 | Morgan | Indiana | 18109 | 261 | 24 |
170095 | 170095 | 2020-05-23 | Morgan | Indiana | 18109 | 265 | 26 |
173136 | 173136 | 2020-05-24 | Morgan | Indiana | 18109 | 266 | 26 |
176180 | 176180 | 2020-05-25 | Morgan | Indiana | 18109 | 269 | 26 |
179224 | 179224 | 2020-05-26 | Morgan | Indiana | 18109 | 270 | 26 |
182268 | 182268 | 2020-05-27 | Morgan | Indiana | 18109 | 278 | 26 |
185322 | 185322 | 2020-05-28 | Morgan | Indiana | 18109 | 285 | 26 |
188380 | 188380 | 2020-05-29 | Morgan | Indiana | 18109 | 286 | 26 |
191445 | 191445 | 2020-05-30 | Morgan | Indiana | 18109 | 287 | 26 |
194512 | 194512 | 2020-05-31 | Morgan | Indiana | 18109 | 286 | 26 |
197582 | 197582 | 2020-06-01 | Morgan | Indiana | 18109 | 289 | 26 |
200655 | 200655 | 2020-06-02 | Morgan | Indiana | 18109 | 290 | 26 |
203731 | 203731 | 2020-06-03 | Morgan | Indiana | 18109 | 292 | 26 |
206811 | 206811 | 2020-06-04 | Morgan | Indiana | 18109 | 293 | 28 |
209892 | 209892 | 2020-06-05 | Morgan | Indiana | 18109 | 295 | 28 |
212977 | 212977 | 2020-06-06 | Morgan | Indiana | 18109 | 296 | 30 |
216064 | 216064 | 2020-06-07 | Morgan | Indiana | 18109 | 299 | 30 |
219156 | 219156 | 2020-06-08 | Morgan | Indiana | 18109 | 300 | 30 |
222251 | 222251 | 2020-06-09 | Morgan | Indiana | 18109 | 303 | 30 |
225346 | 225346 | 2020-06-10 | Morgan | Indiana | 18109 | 303 | 30 |
228448 | 228448 | 2020-06-11 | Morgan | Indiana | 18109 | 303 | 30 |
231551 | 231551 | 2020-06-12 | Morgan | Indiana | 18109 | 305 | 30 |
234657 | 234657 | 2020-06-13 | Morgan | Indiana | 18109 | 306 | 31 |
237764 | 237764 | 2020-06-14 | Morgan | Indiana | 18109 | 307 | 31 |
240872 | 240872 | 2020-06-15 | Morgan | Indiana | 18109 | 308 | 31 |
243983 | 243983 | 2020-06-16 | Morgan | Indiana | 18109 | 309 | 31 |
247096 | 247096 | 2020-06-17 | Morgan | Indiana | 18109 | 309 | 32 |
250208 | 250208 | 2020-06-18 | Morgan | Indiana | 18109 | 310 | 32 |
253323 | 253323 | 2020-06-19 | Morgan | Indiana | 18109 | 310 | 32 |
256443 | 256443 | 2020-06-20 | Morgan | Indiana | 18109 | 313 | 32 |
259569 | 259569 | 2020-06-21 | Morgan | Indiana | 18109 | 315 | 32 |
262696 | 262696 | 2020-06-22 | Morgan | Indiana | 18109 | 314 | 32 |
265824 | 265824 | 2020-06-23 | Morgan | Indiana | 18109 | 314 | 32 |
268954 | 268954 | 2020-06-24 | Morgan | Indiana | 18109 | 317 | 33 |
272091 | 272091 | 2020-06-25 | Morgan | Indiana | 18109 | 318 | 33 |
275233 | 275233 | 2020-06-26 | Morgan | Indiana | 18109 | 319 | 34 |
278381 | 278381 | 2020-06-27 | Morgan | Indiana | 18109 | 323 | 34 |
281529 | 281529 | 2020-06-28 | Morgan | Indiana | 18109 | 324 | 34 |
284674 | 284674 | 2020-06-29 | Morgan | Indiana | 18109 | 326 | 34 |
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);