ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Toa Alta" and state = "Puerto Rico" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
117553 | 117553 | 2020-05-05 | Toa Alta | Puerto Rico | 72135 | 51 | |
120515 | 120515 | 2020-05-06 | Toa Alta | Puerto Rico | 72135 | 52 | |
123492 | 123492 | 2020-05-07 | Toa Alta | Puerto Rico | 72135 | 54 | |
126475 | 126475 | 2020-05-08 | Toa Alta | Puerto Rico | 72135 | 57 | |
129464 | 129464 | 2020-05-09 | Toa Alta | Puerto Rico | 72135 | 57 | |
132453 | 132453 | 2020-05-10 | Toa Alta | Puerto Rico | 72135 | 58 | |
135444 | 135444 | 2020-05-11 | Toa Alta | Puerto Rico | 72135 | 62 | |
138434 | 138434 | 2020-05-12 | Toa Alta | Puerto Rico | 72135 | 63 | |
141430 | 141430 | 2020-05-13 | Toa Alta | Puerto Rico | 72135 | 64 | |
144426 | 144426 | 2020-05-14 | Toa Alta | Puerto Rico | 72135 | 65 | |
147427 | 147427 | 2020-05-15 | Toa Alta | Puerto Rico | 72135 | 67 | |
150435 | 150435 | 2020-05-16 | Toa Alta | Puerto Rico | 72135 | 67 | |
153446 | 153446 | 2020-05-17 | Toa Alta | Puerto Rico | 72135 | 67 | |
156463 | 156463 | 2020-05-18 | Toa Alta | Puerto Rico | 72135 | 68 | |
159484 | 159484 | 2020-05-19 | Toa Alta | Puerto Rico | 72135 | 71 | |
162511 | 162511 | 2020-05-20 | Toa Alta | Puerto Rico | 72135 | 73 | |
165540 | 165540 | 2020-05-21 | Toa Alta | Puerto Rico | 72135 | 77 | |
168576 | 168576 | 2020-05-22 | Toa Alta | Puerto Rico | 72135 | 77 | |
171615 | 171615 | 2020-05-23 | Toa Alta | Puerto Rico | 72135 | 78 | |
174657 | 174657 | 2020-05-24 | Toa Alta | Puerto Rico | 72135 | 80 | |
177701 | 177701 | 2020-05-25 | Toa Alta | Puerto Rico | 72135 | 81 | |
180744 | 180744 | 2020-05-26 | Toa Alta | Puerto Rico | 72135 | 82 | |
183794 | 183794 | 2020-05-27 | Toa Alta | Puerto Rico | 72135 | 83 | |
186851 | 186851 | 2020-05-28 | Toa Alta | Puerto Rico | 72135 | 85 | |
189913 | 189913 | 2020-05-29 | Toa Alta | Puerto Rico | 72135 | 90 | |
192978 | 192978 | 2020-05-30 | Toa Alta | Puerto Rico | 72135 | 92 | |
196047 | 196047 | 2020-05-31 | Toa Alta | Puerto Rico | 72135 | 92 | |
199120 | 199120 | 2020-06-01 | Toa Alta | Puerto Rico | 72135 | 94 | |
202195 | 202195 | 2020-06-02 | Toa Alta | Puerto Rico | 72135 | 94 | |
205272 | 205272 | 2020-06-03 | Toa Alta | Puerto Rico | 72135 | 96 | |
208353 | 208353 | 2020-06-04 | Toa Alta | Puerto Rico | 72135 | 108 | |
211435 | 211435 | 2020-06-05 | Toa Alta | Puerto Rico | 72135 | 111 | |
214521 | 214521 | 2020-06-06 | Toa Alta | Puerto Rico | 72135 | 120 | |
217611 | 217611 | 2020-06-07 | Toa Alta | Puerto Rico | 72135 | 123 | |
220703 | 220703 | 2020-06-08 | Toa Alta | Puerto Rico | 72135 | 124 | |
223798 | 223798 | 2020-06-09 | Toa Alta | Puerto Rico | 72135 | 126 | |
226898 | 226898 | 2020-06-10 | Toa Alta | Puerto Rico | 72135 | 126 | |
230002 | 230002 | 2020-06-11 | Toa Alta | Puerto Rico | 72135 | 126 | |
233107 | 233107 | 2020-06-12 | Toa Alta | Puerto Rico | 72135 | 128 | |
236212 | 236212 | 2020-06-13 | Toa Alta | Puerto Rico | 72135 | 129 | |
239320 | 239320 | 2020-06-14 | Toa Alta | Puerto Rico | 72135 | 133 | |
242429 | 242429 | 2020-06-15 | Toa Alta | Puerto Rico | 72135 | 133 | |
245541 | 245541 | 2020-06-16 | Toa Alta | Puerto Rico | 72135 | 133 | |
248654 | 248654 | 2020-06-17 | Toa Alta | Puerto Rico | 72135 | 134 | |
251769 | 251769 | 2020-06-18 | Toa Alta | Puerto Rico | 72135 | 136 | |
254884 | 254884 | 2020-06-19 | Toa Alta | Puerto Rico | 72135 | 136 | |
258010 | 258010 | 2020-06-20 | Toa Alta | Puerto Rico | 72135 | 142 | |
261137 | 261137 | 2020-06-21 | Toa Alta | Puerto Rico | 72135 | 145 | |
264265 | 264265 | 2020-06-22 | Toa Alta | Puerto Rico | 72135 | 147 | |
267393 | 267393 | 2020-06-23 | Toa Alta | Puerto Rico | 72135 | 147 | |
270527 | 270527 | 2020-06-24 | Toa Alta | Puerto Rico | 72135 | 150 | |
273666 | 273666 | 2020-06-25 | Toa Alta | Puerto Rico | 72135 | 152 | |
276813 | 276813 | 2020-06-26 | Toa Alta | Puerto Rico | 72135 | 153 | |
279961 | 279961 | 2020-06-27 | Toa Alta | Puerto Rico | 72135 | 156 | |
283107 | 283107 | 2020-06-28 | Toa Alta | Puerto Rico | 72135 | 158 | |
286252 | 286252 | 2020-06-29 | Toa Alta | Puerto Rico | 72135 | 158 | |
289403 | 289403 | 2020-06-30 | Toa Alta | Puerto Rico | 72135 | 165 | |
292555 | 292555 | 2020-07-01 | Toa Alta | Puerto Rico | 72135 | 170 | |
295711 | 295711 | 2020-07-02 | Toa Alta | Puerto Rico | 72135 | 171 | |
298870 | 298870 | 2020-07-03 | Toa Alta | Puerto Rico | 72135 | 174 | |
302034 | 302034 | 2020-07-04 | Toa Alta | Puerto Rico | 72135 | 176 | |
305197 | 305197 | 2020-07-05 | Toa Alta | Puerto Rico | 72135 | 176 | |
308364 | 308364 | 2020-07-06 | Toa Alta | Puerto Rico | 72135 | 187 | |
311533 | 311533 | 2020-07-07 | Toa Alta | Puerto Rico | 72135 | 189 | |
314705 | 314705 | 2020-07-08 | Toa Alta | Puerto Rico | 72135 | 189 | |
317878 | 317878 | 2020-07-09 | Toa Alta | Puerto Rico | 72135 | 191 | |
321056 | 321056 | 2020-07-10 | Toa Alta | Puerto Rico | 72135 | 198 | |
324236 | 324236 | 2020-07-11 | Toa Alta | Puerto Rico | 72135 | 201 | |
327421 | 327421 | 2020-07-12 | Toa Alta | Puerto Rico | 72135 | 205 | |
330607 | 330607 | 2020-07-13 | Toa Alta | Puerto Rico | 72135 | 211 | |
333799 | 333799 | 2020-07-14 | Toa Alta | Puerto Rico | 72135 | 214 | |
336993 | 336993 | 2020-07-15 | Toa Alta | Puerto Rico | 72135 | 220 | |
340190 | 340190 | 2020-07-16 | Toa Alta | Puerto Rico | 72135 | 226 | |
343388 | 343388 | 2020-07-17 | Toa Alta | Puerto Rico | 72135 | 236 | |
346588 | 346588 | 2020-07-18 | Toa Alta | Puerto Rico | 72135 | 246 | |
349788 | 349788 | 2020-07-19 | Toa Alta | Puerto Rico | 72135 | 267 | |
352991 | 352991 | 2020-07-20 | Toa Alta | Puerto Rico | 72135 | 279 | |
356194 | 356194 | 2020-07-21 | Toa Alta | Puerto Rico | 72135 | 288 | |
359398 | 359398 | 2020-07-22 | Toa Alta | Puerto Rico | 72135 | 292 | |
362604 | 362604 | 2020-07-23 | Toa Alta | Puerto Rico | 72135 | 301 | |
365810 | 365810 | 2020-07-24 | Toa Alta | Puerto Rico | 72135 | 307 | |
369019 | 369019 | 2020-07-25 | Toa Alta | Puerto Rico | 72135 | 335 | |
372231 | 372231 | 2020-07-26 | Toa Alta | Puerto Rico | 72135 | 351 | |
375444 | 375444 | 2020-07-27 | Toa Alta | Puerto Rico | 72135 | 363 | |
378660 | 378660 | 2020-07-28 | Toa Alta | Puerto Rico | 72135 | 378 | |
381877 | 381877 | 2020-07-29 | Toa Alta | Puerto Rico | 72135 | 384 | |
385095 | 385095 | 2020-07-30 | Toa Alta | Puerto Rico | 72135 | 398 | |
388312 | 388312 | 2020-07-31 | Toa Alta | Puerto Rico | 72135 | 410 | |
391529 | 391529 | 2020-08-01 | Toa Alta | Puerto Rico | 72135 | 458 | |
394745 | 394745 | 2020-08-02 | Toa Alta | Puerto Rico | 72135 | 472 | |
397962 | 397962 | 2020-08-03 | Toa Alta | Puerto Rico | 72135 | 479 | |
401177 | 401177 | 2020-08-04 | Toa Alta | Puerto Rico | 72135 | 498 | |
404395 | 404395 | 2020-08-05 | Toa Alta | Puerto Rico | 72135 | 504 | |
407614 | 407614 | 2020-08-06 | Toa Alta | Puerto Rico | 72135 | 511 | |
410834 | 410834 | 2020-08-07 | Toa Alta | Puerto Rico | 72135 | 540 | |
414054 | 414054 | 2020-08-08 | Toa Alta | Puerto Rico | 72135 | 563 | |
417275 | 417275 | 2020-08-09 | Toa Alta | Puerto Rico | 72135 | 578 | |
420495 | 420495 | 2020-08-10 | Toa Alta | Puerto Rico | 72135 | 595 | |
423718 | 423718 | 2020-08-11 | Toa Alta | Puerto Rico | 72135 | 613 | |
426941 | 426941 | 2020-08-12 | Toa Alta | Puerto Rico | 72135 | 627 |
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);