ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Hatillo" and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117519 | 117519 | 2020-05-05 | Hatillo | Puerto Rico | 72065 | 8 | |
120481 | 120481 | 2020-05-06 | Hatillo | Puerto Rico | 72065 | 8 | |
123458 | 123458 | 2020-05-07 | Hatillo | Puerto Rico | 72065 | 8 | |
126441 | 126441 | 2020-05-08 | Hatillo | Puerto Rico | 72065 | 8 | |
129430 | 129430 | 2020-05-09 | Hatillo | Puerto Rico | 72065 | 8 | |
132419 | 132419 | 2020-05-10 | Hatillo | Puerto Rico | 72065 | 8 | |
135410 | 135410 | 2020-05-11 | Hatillo | Puerto Rico | 72065 | 8 | |
138400 | 138400 | 2020-05-12 | Hatillo | Puerto Rico | 72065 | 8 | |
141396 | 141396 | 2020-05-13 | Hatillo | Puerto Rico | 72065 | 8 | |
144392 | 144392 | 2020-05-14 | Hatillo | Puerto Rico | 72065 | 8 | |
147393 | 147393 | 2020-05-15 | Hatillo | Puerto Rico | 72065 | 8 | |
150400 | 150400 | 2020-05-16 | Hatillo | Puerto Rico | 72065 | 8 | |
153411 | 153411 | 2020-05-17 | Hatillo | Puerto Rico | 72065 | 8 | |
156428 | 156428 | 2020-05-18 | Hatillo | Puerto Rico | 72065 | 10 | |
159449 | 159449 | 2020-05-19 | Hatillo | Puerto Rico | 72065 | 11 | |
162476 | 162476 | 2020-05-20 | Hatillo | Puerto Rico | 72065 | 11 | |
165505 | 165505 | 2020-05-21 | Hatillo | Puerto Rico | 72065 | 11 | |
168541 | 168541 | 2020-05-22 | Hatillo | Puerto Rico | 72065 | 11 | |
171580 | 171580 | 2020-05-23 | Hatillo | Puerto Rico | 72065 | 11 | |
174622 | 174622 | 2020-05-24 | Hatillo | Puerto Rico | 72065 | 11 | |
177666 | 177666 | 2020-05-25 | Hatillo | Puerto Rico | 72065 | 12 | |
180709 | 180709 | 2020-05-26 | Hatillo | Puerto Rico | 72065 | 12 | |
183759 | 183759 | 2020-05-27 | Hatillo | Puerto Rico | 72065 | 14 | |
186816 | 186816 | 2020-05-28 | Hatillo | Puerto Rico | 72065 | 16 | |
189878 | 189878 | 2020-05-29 | Hatillo | Puerto Rico | 72065 | 17 | |
192943 | 192943 | 2020-05-30 | Hatillo | Puerto Rico | 72065 | 17 | |
196012 | 196012 | 2020-05-31 | Hatillo | Puerto Rico | 72065 | 17 | |
199085 | 199085 | 2020-06-01 | Hatillo | Puerto Rico | 72065 | 18 | |
202160 | 202160 | 2020-06-02 | Hatillo | Puerto Rico | 72065 | 18 | |
205237 | 205237 | 2020-06-03 | Hatillo | Puerto Rico | 72065 | 18 | |
208318 | 208318 | 2020-06-04 | Hatillo | Puerto Rico | 72065 | 20 | |
211400 | 211400 | 2020-06-05 | Hatillo | Puerto Rico | 72065 | 20 | |
214486 | 214486 | 2020-06-06 | Hatillo | Puerto Rico | 72065 | 21 | |
217576 | 217576 | 2020-06-07 | Hatillo | Puerto Rico | 72065 | 21 | |
220668 | 220668 | 2020-06-08 | Hatillo | Puerto Rico | 72065 | 21 | |
223763 | 223763 | 2020-06-09 | Hatillo | Puerto Rico | 72065 | 23 | |
226863 | 226863 | 2020-06-10 | Hatillo | Puerto Rico | 72065 | 23 | |
229967 | 229967 | 2020-06-11 | Hatillo | Puerto Rico | 72065 | 24 | |
233072 | 233072 | 2020-06-12 | Hatillo | Puerto Rico | 72065 | 26 | |
236177 | 236177 | 2020-06-13 | Hatillo | Puerto Rico | 72065 | 27 | |
239285 | 239285 | 2020-06-14 | Hatillo | Puerto Rico | 72065 | 27 | |
242394 | 242394 | 2020-06-15 | Hatillo | Puerto Rico | 72065 | 28 | |
245506 | 245506 | 2020-06-16 | Hatillo | Puerto Rico | 72065 | 28 | |
248619 | 248619 | 2020-06-17 | Hatillo | Puerto Rico | 72065 | 28 | |
251734 | 251734 | 2020-06-18 | Hatillo | Puerto Rico | 72065 | 29 | |
254849 | 254849 | 2020-06-19 | Hatillo | Puerto Rico | 72065 | 29 | |
257975 | 257975 | 2020-06-20 | Hatillo | Puerto Rico | 72065 | 29 | |
261102 | 261102 | 2020-06-21 | Hatillo | Puerto Rico | 72065 | 29 | |
264230 | 264230 | 2020-06-22 | Hatillo | Puerto Rico | 72065 | 29 | |
267358 | 267358 | 2020-06-23 | Hatillo | Puerto Rico | 72065 | 29 | |
270492 | 270492 | 2020-06-24 | Hatillo | Puerto Rico | 72065 | 30 | |
273631 | 273631 | 2020-06-25 | Hatillo | Puerto Rico | 72065 | 30 | |
276778 | 276778 | 2020-06-26 | Hatillo | Puerto Rico | 72065 | 30 | |
279926 | 279926 | 2020-06-27 | Hatillo | Puerto Rico | 72065 | 33 | |
283072 | 283072 | 2020-06-28 | Hatillo | Puerto Rico | 72065 | 33 | |
286217 | 286217 | 2020-06-29 | Hatillo | Puerto Rico | 72065 | 33 | |
289368 | 289368 | 2020-06-30 | Hatillo | Puerto Rico | 72065 | 34 | |
292520 | 292520 | 2020-07-01 | Hatillo | Puerto Rico | 72065 | 34 | |
295676 | 295676 | 2020-07-02 | Hatillo | Puerto Rico | 72065 | 37 | |
298835 | 298835 | 2020-07-03 | Hatillo | Puerto Rico | 72065 | 37 | |
301999 | 301999 | 2020-07-04 | Hatillo | Puerto Rico | 72065 | 38 | |
305162 | 305162 | 2020-07-05 | Hatillo | Puerto Rico | 72065 | 38 | |
308329 | 308329 | 2020-07-06 | Hatillo | Puerto Rico | 72065 | 45 | |
311498 | 311498 | 2020-07-07 | Hatillo | Puerto Rico | 72065 | 46 | |
314670 | 314670 | 2020-07-08 | Hatillo | Puerto Rico | 72065 | 46 | |
317843 | 317843 | 2020-07-09 | Hatillo | Puerto Rico | 72065 | 47 | |
321021 | 321021 | 2020-07-10 | Hatillo | Puerto Rico | 72065 | 49 | |
324201 | 324201 | 2020-07-11 | Hatillo | Puerto Rico | 72065 | 50 | |
327386 | 327386 | 2020-07-12 | Hatillo | Puerto Rico | 72065 | 50 | |
330572 | 330572 | 2020-07-13 | Hatillo | Puerto Rico | 72065 | 53 | |
333764 | 333764 | 2020-07-14 | Hatillo | Puerto Rico | 72065 | 54 | |
336958 | 336958 | 2020-07-15 | Hatillo | Puerto Rico | 72065 | 55 | |
340155 | 340155 | 2020-07-16 | Hatillo | Puerto Rico | 72065 | 55 | |
343353 | 343353 | 2020-07-17 | Hatillo | Puerto Rico | 72065 | 56 | |
346553 | 346553 | 2020-07-18 | Hatillo | Puerto Rico | 72065 | 59 | |
349753 | 349753 | 2020-07-19 | Hatillo | Puerto Rico | 72065 | 59 | |
352956 | 352956 | 2020-07-20 | Hatillo | Puerto Rico | 72065 | 62 | |
356159 | 356159 | 2020-07-21 | Hatillo | Puerto Rico | 72065 | 64 | |
359363 | 359363 | 2020-07-22 | Hatillo | Puerto Rico | 72065 | 65 | |
362569 | 362569 | 2020-07-23 | Hatillo | Puerto Rico | 72065 | 70 | |
365775 | 365775 | 2020-07-24 | Hatillo | Puerto Rico | 72065 | 71 | |
368984 | 368984 | 2020-07-25 | Hatillo | Puerto Rico | 72065 | 72 | |
372196 | 372196 | 2020-07-26 | Hatillo | Puerto Rico | 72065 | 72 | |
375409 | 375409 | 2020-07-27 | Hatillo | Puerto Rico | 72065 | 73 | |
378625 | 378625 | 2020-07-28 | Hatillo | Puerto Rico | 72065 | 74 | |
381842 | 381842 | 2020-07-29 | Hatillo | Puerto Rico | 72065 | 74 | |
385060 | 385060 | 2020-07-30 | Hatillo | Puerto Rico | 72065 | 76 | |
388277 | 388277 | 2020-07-31 | Hatillo | Puerto Rico | 72065 | 80 | |
391494 | 391494 | 2020-08-01 | Hatillo | Puerto Rico | 72065 | 86 | |
394710 | 394710 | 2020-08-02 | Hatillo | Puerto Rico | 72065 | 89 | |
397927 | 397927 | 2020-08-03 | Hatillo | Puerto Rico | 72065 | 91 | |
401142 | 401142 | 2020-08-04 | Hatillo | Puerto Rico | 72065 | 97 | |
404360 | 404360 | 2020-08-05 | Hatillo | Puerto Rico | 72065 | 98 | |
407579 | 407579 | 2020-08-06 | Hatillo | Puerto Rico | 72065 | 101 | |
410799 | 410799 | 2020-08-07 | Hatillo | Puerto Rico | 72065 | 102 | |
414019 | 414019 | 2020-08-08 | Hatillo | Puerto Rico | 72065 | 104 | |
417240 | 417240 | 2020-08-09 | Hatillo | Puerto Rico | 72065 | 106 | |
420460 | 420460 | 2020-08-10 | Hatillo | Puerto Rico | 72065 | 114 | |
423683 | 423683 | 2020-08-11 | Hatillo | Puerto Rico | 72065 | 116 | |
426906 | 426906 | 2020-08-12 | Hatillo | Puerto Rico | 72065 | 118 |
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);