ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,577 rows where county = "Medina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117895 | 117895 | 2020-05-05 | Medina | Texas | 48325 | 20 | 2 |
120241 | 120241 | 2020-05-06 | Medina | Ohio | 39103 | 184 | 16 |
120859 | 120859 | 2020-05-06 | Medina | Texas | 48325 | 20 | 2 |
123218 | 123218 | 2020-05-07 | Medina | Ohio | 39103 | 185 | 17 |
123838 | 123838 | 2020-05-07 | Medina | Texas | 48325 | 21 | 2 |
126201 | 126201 | 2020-05-08 | Medina | Ohio | 39103 | 190 | 17 |
126822 | 126822 | 2020-05-08 | Medina | Texas | 48325 | 22 | 2 |
129190 | 129190 | 2020-05-09 | Medina | Ohio | 39103 | 193 | 17 |
129811 | 129811 | 2020-05-09 | Medina | Texas | 48325 | 22 | 2 |
132179 | 132179 | 2020-05-10 | Medina | Ohio | 39103 | 194 | 17 |
132801 | 132801 | 2020-05-10 | Medina | Texas | 48325 | 31 | 2 |
135170 | 135170 | 2020-05-11 | Medina | Ohio | 39103 | 195 | 17 |
135792 | 135792 | 2020-05-11 | Medina | Texas | 48325 | 32 | 2 |
138160 | 138160 | 2020-05-12 | Medina | Ohio | 39103 | 203 | 17 |
138782 | 138782 | 2020-05-12 | Medina | Texas | 48325 | 38 | 2 |
141156 | 141156 | 2020-05-13 | Medina | Ohio | 39103 | 205 | 17 |
141778 | 141778 | 2020-05-13 | Medina | Texas | 48325 | 45 | 2 |
144151 | 144151 | 2020-05-14 | Medina | Ohio | 39103 | 207 | 18 |
144775 | 144775 | 2020-05-14 | Medina | Texas | 48325 | 47 | 2 |
147152 | 147152 | 2020-05-15 | Medina | Ohio | 39103 | 210 | 18 |
147779 | 147779 | 2020-05-15 | Medina | Texas | 48325 | 48 | 2 |
150159 | 150159 | 2020-05-16 | Medina | Ohio | 39103 | 212 | 18 |
150787 | 150787 | 2020-05-16 | Medina | Texas | 48325 | 49 | 2 |
153170 | 153170 | 2020-05-17 | Medina | Ohio | 39103 | 216 | 18 |
153798 | 153798 | 2020-05-17 | Medina | Texas | 48325 | 50 | 2 |
156187 | 156187 | 2020-05-18 | Medina | Ohio | 39103 | 224 | 18 |
156815 | 156815 | 2020-05-18 | Medina | Texas | 48325 | 58 | 2 |
159207 | 159207 | 2020-05-19 | Medina | Ohio | 39103 | 229 | 18 |
159837 | 159837 | 2020-05-19 | Medina | Texas | 48325 | 59 | 2 |
162234 | 162234 | 2020-05-20 | Medina | Ohio | 39103 | 237 | 18 |
162865 | 162865 | 2020-05-20 | Medina | Texas | 48325 | 60 | 2 |
165263 | 165263 | 2020-05-21 | Medina | Ohio | 39103 | 245 | 18 |
165894 | 165894 | 2020-05-21 | Medina | Texas | 48325 | 64 | 2 |
168299 | 168299 | 2020-05-22 | Medina | Ohio | 39103 | 258 | 18 |
168930 | 168930 | 2020-05-22 | Medina | Texas | 48325 | 64 | 2 |
171338 | 171338 | 2020-05-23 | Medina | Ohio | 39103 | 274 | 19 |
171970 | 171970 | 2020-05-23 | Medina | Texas | 48325 | 66 | 2 |
174380 | 174380 | 2020-05-24 | Medina | Ohio | 39103 | 288 | 19 |
175013 | 175013 | 2020-05-24 | Medina | Texas | 48325 | 67 | 2 |
177424 | 177424 | 2020-05-25 | Medina | Ohio | 39103 | 302 | 19 |
178057 | 178057 | 2020-05-25 | Medina | Texas | 48325 | 67 | 2 |
180467 | 180467 | 2020-05-26 | Medina | Ohio | 39103 | 307 | 19 |
181101 | 181101 | 2020-05-26 | Medina | Texas | 48325 | 67 | 2 |
183516 | 183516 | 2020-05-27 | Medina | Ohio | 39103 | 310 | 20 |
184151 | 184151 | 2020-05-27 | Medina | Texas | 48325 | 68 | 2 |
186573 | 186573 | 2020-05-28 | Medina | Ohio | 39103 | 313 | 22 |
187208 | 187208 | 2020-05-28 | Medina | Texas | 48325 | 69 | 2 |
189633 | 189633 | 2020-05-29 | Medina | Ohio | 39103 | 328 | 23 |
190272 | 190272 | 2020-05-29 | Medina | Texas | 48325 | 71 | 2 |
192697 | 192697 | 2020-05-30 | Medina | Ohio | 39103 | 337 | 23 |
193338 | 193338 | 2020-05-30 | Medina | Texas | 48325 | 71 | 2 |
195767 | 195767 | 2020-05-31 | Medina | Ohio | 39103 | 337 | 22 |
196408 | 196408 | 2020-05-31 | Medina | Texas | 48325 | 73 | 2 |
198840 | 198840 | 2020-06-01 | Medina | Ohio | 39103 | 346 | 24 |
199481 | 199481 | 2020-06-01 | Medina | Texas | 48325 | 73 | 2 |
201915 | 201915 | 2020-06-02 | Medina | Ohio | 39103 | 356 | 23 |
202557 | 202557 | 2020-06-02 | Medina | Texas | 48325 | 73 | 2 |
204992 | 204992 | 2020-06-03 | Medina | Ohio | 39103 | 366 | 23 |
205636 | 205636 | 2020-06-03 | Medina | Texas | 48325 | 74 | 2 |
208073 | 208073 | 2020-06-04 | Medina | Ohio | 39103 | 376 | 25 |
208718 | 208718 | 2020-06-04 | Medina | Texas | 48325 | 76 | 2 |
211155 | 211155 | 2020-06-05 | Medina | Ohio | 39103 | 376 | 24 |
211802 | 211802 | 2020-06-05 | Medina | Texas | 48325 | 78 | 2 |
214241 | 214241 | 2020-06-06 | Medina | Ohio | 39103 | 382 | 25 |
214889 | 214889 | 2020-06-06 | Medina | Texas | 48325 | 216 | 2 |
217331 | 217331 | 2020-06-07 | Medina | Ohio | 39103 | 387 | 25 |
217979 | 217979 | 2020-06-07 | Medina | Texas | 48325 | 216 | 2 |
220423 | 220423 | 2020-06-08 | Medina | Ohio | 39103 | 388 | 25 |
221071 | 221071 | 2020-06-08 | Medina | Texas | 48325 | 216 | 2 |
223518 | 223518 | 2020-06-09 | Medina | Ohio | 39103 | 390 | 25 |
224166 | 224166 | 2020-06-09 | Medina | Texas | 48325 | 216 | 2 |
226618 | 226618 | 2020-06-10 | Medina | Ohio | 39103 | 394 | 26 |
227266 | 227266 | 2020-06-10 | Medina | Texas | 48325 | 216 | 2 |
229722 | 229722 | 2020-06-11 | Medina | Ohio | 39103 | 394 | 26 |
230370 | 230370 | 2020-06-11 | Medina | Texas | 48325 | 218 | 2 |
232827 | 232827 | 2020-06-12 | Medina | Ohio | 39103 | 397 | 26 |
233474 | 233474 | 2020-06-12 | Medina | Texas | 48325 | 220 | 2 |
235932 | 235932 | 2020-06-13 | Medina | Ohio | 39103 | 396 | 30 |
236580 | 236580 | 2020-06-13 | Medina | Texas | 48325 | 221 | 2 |
239040 | 239040 | 2020-06-14 | Medina | Ohio | 39103 | 397 | 30 |
239688 | 239688 | 2020-06-14 | Medina | Texas | 48325 | 221 | 2 |
242149 | 242149 | 2020-06-15 | Medina | Ohio | 39103 | 398 | 30 |
242798 | 242798 | 2020-06-15 | Medina | Texas | 48325 | 221 | 2 |
245261 | 245261 | 2020-06-16 | Medina | Ohio | 39103 | 400 | 30 |
245910 | 245910 | 2020-06-16 | Medina | Texas | 48325 | 221 | 2 |
248374 | 248374 | 2020-06-17 | Medina | Ohio | 39103 | 402 | 31 |
249023 | 249023 | 2020-06-17 | Medina | Texas | 48325 | 227 | 2 |
251489 | 251489 | 2020-06-18 | Medina | Ohio | 39103 | 404 | 31 |
252138 | 252138 | 2020-06-18 | Medina | Texas | 48325 | 228 | 2 |
254604 | 254604 | 2020-06-19 | Medina | Ohio | 39103 | 406 | 31 |
255253 | 255253 | 2020-06-19 | Medina | Texas | 48325 | 244 | 2 |
257729 | 257729 | 2020-06-20 | Medina | Ohio | 39103 | 407 | 31 |
258380 | 258380 | 2020-06-20 | Medina | Texas | 48325 | 245 | 2 |
260856 | 260856 | 2020-06-21 | Medina | Ohio | 39103 | 413 | 31 |
261507 | 261507 | 2020-06-21 | Medina | Texas | 48325 | 250 | 2 |
263984 | 263984 | 2020-06-22 | Medina | Ohio | 39103 | 416 | 31 |
264635 | 264635 | 2020-06-22 | Medina | Texas | 48325 | 250 | 2 |
267112 | 267112 | 2020-06-23 | Medina | Ohio | 39103 | 426 | 31 |
267763 | 267763 | 2020-06-23 | Medina | Texas | 48325 | 251 | 2 |
270246 | 270246 | 2020-06-24 | Medina | Ohio | 39103 | 434 | 31 |
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);