ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Santa Isabel" and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117552 | 117552 | 2020-05-05 | Santa Isabel | Puerto Rico | 72133 | 8 | |
120514 | 120514 | 2020-05-06 | Santa Isabel | Puerto Rico | 72133 | 10 | |
123491 | 123491 | 2020-05-07 | Santa Isabel | Puerto Rico | 72133 | 10 | |
126474 | 126474 | 2020-05-08 | Santa Isabel | Puerto Rico | 72133 | 10 | |
129463 | 129463 | 2020-05-09 | Santa Isabel | Puerto Rico | 72133 | 10 | |
132452 | 132452 | 2020-05-10 | Santa Isabel | Puerto Rico | 72133 | 10 | |
135443 | 135443 | 2020-05-11 | Santa Isabel | Puerto Rico | 72133 | 11 | |
138433 | 138433 | 2020-05-12 | Santa Isabel | Puerto Rico | 72133 | 11 | |
141429 | 141429 | 2020-05-13 | Santa Isabel | Puerto Rico | 72133 | 11 | |
144425 | 144425 | 2020-05-14 | Santa Isabel | Puerto Rico | 72133 | 12 | |
147426 | 147426 | 2020-05-15 | Santa Isabel | Puerto Rico | 72133 | 12 | |
150434 | 150434 | 2020-05-16 | Santa Isabel | Puerto Rico | 72133 | 12 | |
153445 | 153445 | 2020-05-17 | Santa Isabel | Puerto Rico | 72133 | 12 | |
156462 | 156462 | 2020-05-18 | Santa Isabel | Puerto Rico | 72133 | 12 | |
159483 | 159483 | 2020-05-19 | Santa Isabel | Puerto Rico | 72133 | 12 | |
162510 | 162510 | 2020-05-20 | Santa Isabel | Puerto Rico | 72133 | 13 | |
165539 | 165539 | 2020-05-21 | Santa Isabel | Puerto Rico | 72133 | 13 | |
168575 | 168575 | 2020-05-22 | Santa Isabel | Puerto Rico | 72133 | 15 | |
171614 | 171614 | 2020-05-23 | Santa Isabel | Puerto Rico | 72133 | 15 | |
174656 | 174656 | 2020-05-24 | Santa Isabel | Puerto Rico | 72133 | 15 | |
177700 | 177700 | 2020-05-25 | Santa Isabel | Puerto Rico | 72133 | 15 | |
180743 | 180743 | 2020-05-26 | Santa Isabel | Puerto Rico | 72133 | 15 | |
183793 | 183793 | 2020-05-27 | Santa Isabel | Puerto Rico | 72133 | 17 | |
186850 | 186850 | 2020-05-28 | Santa Isabel | Puerto Rico | 72133 | 17 | |
189912 | 189912 | 2020-05-29 | Santa Isabel | Puerto Rico | 72133 | 17 | |
192977 | 192977 | 2020-05-30 | Santa Isabel | Puerto Rico | 72133 | 17 | |
196046 | 196046 | 2020-05-31 | Santa Isabel | Puerto Rico | 72133 | 17 | |
199119 | 199119 | 2020-06-01 | Santa Isabel | Puerto Rico | 72133 | 17 | |
202194 | 202194 | 2020-06-02 | Santa Isabel | Puerto Rico | 72133 | 17 | |
205271 | 205271 | 2020-06-03 | Santa Isabel | Puerto Rico | 72133 | 17 | |
208352 | 208352 | 2020-06-04 | Santa Isabel | Puerto Rico | 72133 | 20 | |
211434 | 211434 | 2020-06-05 | Santa Isabel | Puerto Rico | 72133 | 20 | |
214520 | 214520 | 2020-06-06 | Santa Isabel | Puerto Rico | 72133 | 21 | |
217610 | 217610 | 2020-06-07 | Santa Isabel | Puerto Rico | 72133 | 24 | |
220702 | 220702 | 2020-06-08 | Santa Isabel | Puerto Rico | 72133 | 24 | |
223797 | 223797 | 2020-06-09 | Santa Isabel | Puerto Rico | 72133 | 24 | |
226897 | 226897 | 2020-06-10 | Santa Isabel | Puerto Rico | 72133 | 25 | |
230001 | 230001 | 2020-06-11 | Santa Isabel | Puerto Rico | 72133 | 25 | |
233106 | 233106 | 2020-06-12 | Santa Isabel | Puerto Rico | 72133 | 27 | |
236211 | 236211 | 2020-06-13 | Santa Isabel | Puerto Rico | 72133 | 28 | |
239319 | 239319 | 2020-06-14 | Santa Isabel | Puerto Rico | 72133 | 28 | |
242428 | 242428 | 2020-06-15 | Santa Isabel | Puerto Rico | 72133 | 28 | |
245540 | 245540 | 2020-06-16 | Santa Isabel | Puerto Rico | 72133 | 29 | |
248653 | 248653 | 2020-06-17 | Santa Isabel | Puerto Rico | 72133 | 29 | |
251768 | 251768 | 2020-06-18 | Santa Isabel | Puerto Rico | 72133 | 33 | |
254883 | 254883 | 2020-06-19 | Santa Isabel | Puerto Rico | 72133 | 42 | |
258009 | 258009 | 2020-06-20 | Santa Isabel | Puerto Rico | 72133 | 45 | |
261136 | 261136 | 2020-06-21 | Santa Isabel | Puerto Rico | 72133 | 47 | |
264264 | 264264 | 2020-06-22 | Santa Isabel | Puerto Rico | 72133 | 47 | |
267392 | 267392 | 2020-06-23 | Santa Isabel | Puerto Rico | 72133 | 51 | |
270526 | 270526 | 2020-06-24 | Santa Isabel | Puerto Rico | 72133 | 51 | |
273665 | 273665 | 2020-06-25 | Santa Isabel | Puerto Rico | 72133 | 51 | |
276812 | 276812 | 2020-06-26 | Santa Isabel | Puerto Rico | 72133 | 51 | |
279960 | 279960 | 2020-06-27 | Santa Isabel | Puerto Rico | 72133 | 53 | |
283106 | 283106 | 2020-06-28 | Santa Isabel | Puerto Rico | 72133 | 53 | |
286251 | 286251 | 2020-06-29 | Santa Isabel | Puerto Rico | 72133 | 53 | |
289402 | 289402 | 2020-06-30 | Santa Isabel | Puerto Rico | 72133 | 53 | |
292554 | 292554 | 2020-07-01 | Santa Isabel | Puerto Rico | 72133 | 53 | |
295710 | 295710 | 2020-07-02 | Santa Isabel | Puerto Rico | 72133 | 53 | |
298869 | 298869 | 2020-07-03 | Santa Isabel | Puerto Rico | 72133 | 53 | |
302033 | 302033 | 2020-07-04 | Santa Isabel | Puerto Rico | 72133 | 53 | |
305196 | 305196 | 2020-07-05 | Santa Isabel | Puerto Rico | 72133 | 53 | |
308363 | 308363 | 2020-07-06 | Santa Isabel | Puerto Rico | 72133 | 58 | |
311532 | 311532 | 2020-07-07 | Santa Isabel | Puerto Rico | 72133 | 59 | |
314704 | 314704 | 2020-07-08 | Santa Isabel | Puerto Rico | 72133 | 59 | |
317877 | 317877 | 2020-07-09 | Santa Isabel | Puerto Rico | 72133 | 59 | |
321055 | 321055 | 2020-07-10 | Santa Isabel | Puerto Rico | 72133 | 59 | |
324235 | 324235 | 2020-07-11 | Santa Isabel | Puerto Rico | 72133 | 60 | |
327420 | 327420 | 2020-07-12 | Santa Isabel | Puerto Rico | 72133 | 60 | |
330606 | 330606 | 2020-07-13 | Santa Isabel | Puerto Rico | 72133 | 61 | |
333798 | 333798 | 2020-07-14 | Santa Isabel | Puerto Rico | 72133 | 61 | |
336992 | 336992 | 2020-07-15 | Santa Isabel | Puerto Rico | 72133 | 62 | |
340189 | 340189 | 2020-07-16 | Santa Isabel | Puerto Rico | 72133 | 63 | |
343387 | 343387 | 2020-07-17 | Santa Isabel | Puerto Rico | 72133 | 64 | |
346587 | 346587 | 2020-07-18 | Santa Isabel | Puerto Rico | 72133 | 67 | |
349787 | 349787 | 2020-07-19 | Santa Isabel | Puerto Rico | 72133 | 70 | |
352990 | 352990 | 2020-07-20 | Santa Isabel | Puerto Rico | 72133 | 71 | |
356193 | 356193 | 2020-07-21 | Santa Isabel | Puerto Rico | 72133 | 73 | |
359397 | 359397 | 2020-07-22 | Santa Isabel | Puerto Rico | 72133 | 73 | |
362603 | 362603 | 2020-07-23 | Santa Isabel | Puerto Rico | 72133 | 75 | |
365809 | 365809 | 2020-07-24 | Santa Isabel | Puerto Rico | 72133 | 76 | |
369018 | 369018 | 2020-07-25 | Santa Isabel | Puerto Rico | 72133 | 78 | |
372230 | 372230 | 2020-07-26 | Santa Isabel | Puerto Rico | 72133 | 81 | |
375443 | 375443 | 2020-07-27 | Santa Isabel | Puerto Rico | 72133 | 81 | |
378659 | 378659 | 2020-07-28 | Santa Isabel | Puerto Rico | 72133 | 81 | |
381876 | 381876 | 2020-07-29 | Santa Isabel | Puerto Rico | 72133 | 81 | |
385094 | 385094 | 2020-07-30 | Santa Isabel | Puerto Rico | 72133 | 81 | |
388311 | 388311 | 2020-07-31 | Santa Isabel | Puerto Rico | 72133 | 82 | |
391528 | 391528 | 2020-08-01 | Santa Isabel | Puerto Rico | 72133 | 87 | |
394744 | 394744 | 2020-08-02 | Santa Isabel | Puerto Rico | 72133 | 88 | |
397961 | 397961 | 2020-08-03 | Santa Isabel | Puerto Rico | 72133 | 89 | |
401176 | 401176 | 2020-08-04 | Santa Isabel | Puerto Rico | 72133 | 91 | |
404394 | 404394 | 2020-08-05 | Santa Isabel | Puerto Rico | 72133 | 92 | |
407613 | 407613 | 2020-08-06 | Santa Isabel | Puerto Rico | 72133 | 93 | |
410833 | 410833 | 2020-08-07 | Santa Isabel | Puerto Rico | 72133 | 93 | |
414053 | 414053 | 2020-08-08 | Santa Isabel | Puerto Rico | 72133 | 94 | |
417274 | 417274 | 2020-08-09 | Santa Isabel | Puerto Rico | 72133 | 94 | |
420494 | 420494 | 2020-08-10 | Santa Isabel | Puerto Rico | 72133 | 98 | |
423717 | 423717 | 2020-08-11 | Santa Isabel | Puerto Rico | 72133 | 100 | |
426940 | 426940 | 2020-08-12 | Santa Isabel | Puerto Rico | 72133 | 102 |
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);