ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Dorado" and state = "Puerto Rico" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
117511 | 117511 | 2020-05-05 | Dorado | Puerto Rico | 72051 | 35 | |
120473 | 120473 | 2020-05-06 | Dorado | Puerto Rico | 72051 | 36 | |
123450 | 123450 | 2020-05-07 | Dorado | Puerto Rico | 72051 | 40 | |
126433 | 126433 | 2020-05-08 | Dorado | Puerto Rico | 72051 | 40 | |
129422 | 129422 | 2020-05-09 | Dorado | Puerto Rico | 72051 | 40 | |
132411 | 132411 | 2020-05-10 | Dorado | Puerto Rico | 72051 | 40 | |
135402 | 135402 | 2020-05-11 | Dorado | Puerto Rico | 72051 | 41 | |
138392 | 138392 | 2020-05-12 | Dorado | Puerto Rico | 72051 | 41 | |
141388 | 141388 | 2020-05-13 | Dorado | Puerto Rico | 72051 | 41 | |
144384 | 144384 | 2020-05-14 | Dorado | Puerto Rico | 72051 | 42 | |
147385 | 147385 | 2020-05-15 | Dorado | Puerto Rico | 72051 | 42 | |
150392 | 150392 | 2020-05-16 | Dorado | Puerto Rico | 72051 | 42 | |
153403 | 153403 | 2020-05-17 | Dorado | Puerto Rico | 72051 | 42 | |
156420 | 156420 | 2020-05-18 | Dorado | Puerto Rico | 72051 | 42 | |
159441 | 159441 | 2020-05-19 | Dorado | Puerto Rico | 72051 | 43 | |
162468 | 162468 | 2020-05-20 | Dorado | Puerto Rico | 72051 | 44 | |
165497 | 165497 | 2020-05-21 | Dorado | Puerto Rico | 72051 | 45 | |
168533 | 168533 | 2020-05-22 | Dorado | Puerto Rico | 72051 | 51 | |
171572 | 171572 | 2020-05-23 | Dorado | Puerto Rico | 72051 | 52 | |
174614 | 174614 | 2020-05-24 | Dorado | Puerto Rico | 72051 | 56 | |
177658 | 177658 | 2020-05-25 | Dorado | Puerto Rico | 72051 | 56 | |
180701 | 180701 | 2020-05-26 | Dorado | Puerto Rico | 72051 | 57 | |
183751 | 183751 | 2020-05-27 | Dorado | Puerto Rico | 72051 | 58 | |
186808 | 186808 | 2020-05-28 | Dorado | Puerto Rico | 72051 | 60 | |
189870 | 189870 | 2020-05-29 | Dorado | Puerto Rico | 72051 | 61 | |
192935 | 192935 | 2020-05-30 | Dorado | Puerto Rico | 72051 | 61 | |
196004 | 196004 | 2020-05-31 | Dorado | Puerto Rico | 72051 | 62 | |
199077 | 199077 | 2020-06-01 | Dorado | Puerto Rico | 72051 | 62 | |
202152 | 202152 | 2020-06-02 | Dorado | Puerto Rico | 72051 | 62 | |
205229 | 205229 | 2020-06-03 | Dorado | Puerto Rico | 72051 | 62 | |
208310 | 208310 | 2020-06-04 | Dorado | Puerto Rico | 72051 | 67 | |
211392 | 211392 | 2020-06-05 | Dorado | Puerto Rico | 72051 | 68 | |
214478 | 214478 | 2020-06-06 | Dorado | Puerto Rico | 72051 | 72 | |
217568 | 217568 | 2020-06-07 | Dorado | Puerto Rico | 72051 | 73 | |
220660 | 220660 | 2020-06-08 | Dorado | Puerto Rico | 72051 | 73 | |
223755 | 223755 | 2020-06-09 | Dorado | Puerto Rico | 72051 | 79 | |
226855 | 226855 | 2020-06-10 | Dorado | Puerto Rico | 72051 | 79 | |
229959 | 229959 | 2020-06-11 | Dorado | Puerto Rico | 72051 | 79 | |
233064 | 233064 | 2020-06-12 | Dorado | Puerto Rico | 72051 | 83 | |
236169 | 236169 | 2020-06-13 | Dorado | Puerto Rico | 72051 | 83 | |
239277 | 239277 | 2020-06-14 | Dorado | Puerto Rico | 72051 | 84 | |
242386 | 242386 | 2020-06-15 | Dorado | Puerto Rico | 72051 | 84 | |
245498 | 245498 | 2020-06-16 | Dorado | Puerto Rico | 72051 | 84 | |
248611 | 248611 | 2020-06-17 | Dorado | Puerto Rico | 72051 | 84 | |
251726 | 251726 | 2020-06-18 | Dorado | Puerto Rico | 72051 | 86 | |
254841 | 254841 | 2020-06-19 | Dorado | Puerto Rico | 72051 | 87 | |
257967 | 257967 | 2020-06-20 | Dorado | Puerto Rico | 72051 | 89 | |
261094 | 261094 | 2020-06-21 | Dorado | Puerto Rico | 72051 | 89 | |
264222 | 264222 | 2020-06-22 | Dorado | Puerto Rico | 72051 | 89 | |
267350 | 267350 | 2020-06-23 | Dorado | Puerto Rico | 72051 | 89 | |
270484 | 270484 | 2020-06-24 | Dorado | Puerto Rico | 72051 | 91 | |
273623 | 273623 | 2020-06-25 | Dorado | Puerto Rico | 72051 | 93 | |
276770 | 276770 | 2020-06-26 | Dorado | Puerto Rico | 72051 | 94 | |
279918 | 279918 | 2020-06-27 | Dorado | Puerto Rico | 72051 | 95 | |
283064 | 283064 | 2020-06-28 | Dorado | Puerto Rico | 72051 | 96 | |
286209 | 286209 | 2020-06-29 | Dorado | Puerto Rico | 72051 | 95 | |
289360 | 289360 | 2020-06-30 | Dorado | Puerto Rico | 72051 | 98 | |
292512 | 292512 | 2020-07-01 | Dorado | Puerto Rico | 72051 | 98 | |
295668 | 295668 | 2020-07-02 | Dorado | Puerto Rico | 72051 | 101 | |
298827 | 298827 | 2020-07-03 | Dorado | Puerto Rico | 72051 | 102 | |
301991 | 301991 | 2020-07-04 | Dorado | Puerto Rico | 72051 | 105 | |
305154 | 305154 | 2020-07-05 | Dorado | Puerto Rico | 72051 | 106 | |
308321 | 308321 | 2020-07-06 | Dorado | Puerto Rico | 72051 | 116 | |
311490 | 311490 | 2020-07-07 | Dorado | Puerto Rico | 72051 | 116 | |
314662 | 314662 | 2020-07-08 | Dorado | Puerto Rico | 72051 | 116 | |
317835 | 317835 | 2020-07-09 | Dorado | Puerto Rico | 72051 | 117 | |
321013 | 321013 | 2020-07-10 | Dorado | Puerto Rico | 72051 | 120 | |
324193 | 324193 | 2020-07-11 | Dorado | Puerto Rico | 72051 | 123 | |
327378 | 327378 | 2020-07-12 | Dorado | Puerto Rico | 72051 | 127 | |
330564 | 330564 | 2020-07-13 | Dorado | Puerto Rico | 72051 | 128 | |
333756 | 333756 | 2020-07-14 | Dorado | Puerto Rico | 72051 | 137 | |
336950 | 336950 | 2020-07-15 | Dorado | Puerto Rico | 72051 | 147 | |
340147 | 340147 | 2020-07-16 | Dorado | Puerto Rico | 72051 | 151 | |
343345 | 343345 | 2020-07-17 | Dorado | Puerto Rico | 72051 | 154 | |
346545 | 346545 | 2020-07-18 | Dorado | Puerto Rico | 72051 | 168 | |
349745 | 349745 | 2020-07-19 | Dorado | Puerto Rico | 72051 | 173 | |
352948 | 352948 | 2020-07-20 | Dorado | Puerto Rico | 72051 | 181 | |
356151 | 356151 | 2020-07-21 | Dorado | Puerto Rico | 72051 | 185 | |
359355 | 359355 | 2020-07-22 | Dorado | Puerto Rico | 72051 | 186 | |
362561 | 362561 | 2020-07-23 | Dorado | Puerto Rico | 72051 | 189 | |
365767 | 365767 | 2020-07-24 | Dorado | Puerto Rico | 72051 | 198 | |
368976 | 368976 | 2020-07-25 | Dorado | Puerto Rico | 72051 | 203 | |
372188 | 372188 | 2020-07-26 | Dorado | Puerto Rico | 72051 | 213 | |
375401 | 375401 | 2020-07-27 | Dorado | Puerto Rico | 72051 | 217 | |
378617 | 378617 | 2020-07-28 | Dorado | Puerto Rico | 72051 | 223 | |
381834 | 381834 | 2020-07-29 | Dorado | Puerto Rico | 72051 | 224 | |
385052 | 385052 | 2020-07-30 | Dorado | Puerto Rico | 72051 | 226 | |
388269 | 388269 | 2020-07-31 | Dorado | Puerto Rico | 72051 | 228 | |
391486 | 391486 | 2020-08-01 | Dorado | Puerto Rico | 72051 | 252 | |
394702 | 394702 | 2020-08-02 | Dorado | Puerto Rico | 72051 | 260 | |
397919 | 397919 | 2020-08-03 | Dorado | Puerto Rico | 72051 | 263 | |
401134 | 401134 | 2020-08-04 | Dorado | Puerto Rico | 72051 | 266 | |
404352 | 404352 | 2020-08-05 | Dorado | Puerto Rico | 72051 | 276 | |
407571 | 407571 | 2020-08-06 | Dorado | Puerto Rico | 72051 | 276 | |
410791 | 410791 | 2020-08-07 | Dorado | Puerto Rico | 72051 | 285 | |
414011 | 414011 | 2020-08-08 | Dorado | Puerto Rico | 72051 | 306 | |
417232 | 417232 | 2020-08-09 | Dorado | Puerto Rico | 72051 | 315 | |
420452 | 420452 | 2020-08-10 | Dorado | Puerto Rico | 72051 | 325 | |
423675 | 423675 | 2020-08-11 | Dorado | Puerto Rico | 72051 | 332 | |
426898 | 426898 | 2020-08-12 | Dorado | Puerto Rico | 72051 | 341 |
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);