ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ciales" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637232 | 637232 | 2020-10-16 | Ciales | Puerto Rico | 72039 | 314 | |
633986 | 633986 | 2020-10-15 | Ciales | Puerto Rico | 72039 | 312 | |
630741 | 630741 | 2020-10-14 | Ciales | Puerto Rico | 72039 | 310 | |
627497 | 627497 | 2020-10-13 | Ciales | Puerto Rico | 72039 | 304 | |
624255 | 624255 | 2020-10-12 | Ciales | Puerto Rico | 72039 | 304 | |
621012 | 621012 | 2020-10-11 | Ciales | Puerto Rico | 72039 | 302 | |
617769 | 617769 | 2020-10-10 | Ciales | Puerto Rico | 72039 | 302 | |
614527 | 614527 | 2020-10-09 | Ciales | Puerto Rico | 72039 | 300 | |
611286 | 611286 | 2020-10-08 | Ciales | Puerto Rico | 72039 | 294 | |
608044 | 608044 | 2020-10-07 | Ciales | Puerto Rico | 72039 | 293 | |
604801 | 604801 | 2020-10-06 | Ciales | Puerto Rico | 72039 | 293 | |
601559 | 601559 | 2020-10-05 | Ciales | Puerto Rico | 72039 | 292 | |
598316 | 598316 | 2020-10-04 | Ciales | Puerto Rico | 72039 | 290 | |
595073 | 595073 | 2020-10-03 | Ciales | Puerto Rico | 72039 | 290 | |
591832 | 591832 | 2020-10-02 | Ciales | Puerto Rico | 72039 | 288 | |
588591 | 588591 | 2020-10-01 | Ciales | Puerto Rico | 72039 | 281 | |
585351 | 585351 | 2020-09-30 | Ciales | Puerto Rico | 72039 | 270 | |
582111 | 582111 | 2020-09-29 | Ciales | Puerto Rico | 72039 | 259 | |
578871 | 578871 | 2020-09-28 | Ciales | Puerto Rico | 72039 | 253 | |
575630 | 575630 | 2020-09-27 | Ciales | Puerto Rico | 72039 | 252 | |
572386 | 572386 | 2020-09-26 | Ciales | Puerto Rico | 72039 | 243 | |
569144 | 569144 | 2020-09-25 | Ciales | Puerto Rico | 72039 | 237 | |
565903 | 565903 | 2020-09-24 | Ciales | Puerto Rico | 72039 | 228 | |
562662 | 562662 | 2020-09-23 | Ciales | Puerto Rico | 72039 | 220 | |
559425 | 559425 | 2020-09-22 | Ciales | Puerto Rico | 72039 | 218 | |
556188 | 556188 | 2020-09-21 | Ciales | Puerto Rico | 72039 | 218 | |
552951 | 552951 | 2020-09-20 | Ciales | Puerto Rico | 72039 | 215 | |
549712 | 549712 | 2020-09-19 | Ciales | Puerto Rico | 72039 | 212 | |
546473 | 546473 | 2020-09-18 | Ciales | Puerto Rico | 72039 | 207 | |
543236 | 543236 | 2020-09-17 | Ciales | Puerto Rico | 72039 | 203 | |
540000 | 540000 | 2020-09-16 | Ciales | Puerto Rico | 72039 | 201 | |
536763 | 536763 | 2020-09-15 | Ciales | Puerto Rico | 72039 | 202 | |
533527 | 533527 | 2020-09-14 | Ciales | Puerto Rico | 72039 | 201 | |
530292 | 530292 | 2020-09-13 | Ciales | Puerto Rico | 72039 | 200 | |
527055 | 527055 | 2020-09-12 | Ciales | Puerto Rico | 72039 | 199 | |
523819 | 523819 | 2020-09-11 | Ciales | Puerto Rico | 72039 | 198 | |
520583 | 520583 | 2020-09-10 | Ciales | Puerto Rico | 72039 | 195 | |
517347 | 517347 | 2020-09-09 | Ciales | Puerto Rico | 72039 | 193 | |
514112 | 514112 | 2020-09-08 | Ciales | Puerto Rico | 72039 | 193 | |
510879 | 510879 | 2020-09-07 | Ciales | Puerto Rico | 72039 | 194 | |
507646 | 507646 | 2020-09-06 | Ciales | Puerto Rico | 72039 | 192 | |
504414 | 504414 | 2020-09-05 | Ciales | Puerto Rico | 72039 | 192 | |
501180 | 501180 | 2020-09-04 | Ciales | Puerto Rico | 72039 | 192 | |
497946 | 497946 | 2020-09-03 | Ciales | Puerto Rico | 72039 | 192 | |
494713 | 494713 | 2020-09-02 | Ciales | Puerto Rico | 72039 | 192 | |
491479 | 491479 | 2020-09-01 | Ciales | Puerto Rico | 72039 | 190 | |
488246 | 488246 | 2020-08-31 | Ciales | Puerto Rico | 72039 | 190 | |
485013 | 485013 | 2020-08-30 | Ciales | Puerto Rico | 72039 | 189 | |
481778 | 481778 | 2020-08-29 | Ciales | Puerto Rico | 72039 | 188 | |
478544 | 478544 | 2020-08-28 | Ciales | Puerto Rico | 72039 | 187 | |
475311 | 475311 | 2020-08-27 | Ciales | Puerto Rico | 72039 | 186 | |
472077 | 472077 | 2020-08-26 | Ciales | Puerto Rico | 72039 | 182 | |
468845 | 468845 | 2020-08-25 | Ciales | Puerto Rico | 72039 | 182 | |
465617 | 465617 | 2020-08-24 | Ciales | Puerto Rico | 72039 | 180 | |
462388 | 462388 | 2020-08-23 | Ciales | Puerto Rico | 72039 | 180 | |
459160 | 459160 | 2020-08-22 | Ciales | Puerto Rico | 72039 | 179 | |
455932 | 455932 | 2020-08-21 | Ciales | Puerto Rico | 72039 | 178 | |
452704 | 452704 | 2020-08-20 | Ciales | Puerto Rico | 72039 | 174 | |
449476 | 449476 | 2020-08-19 | Ciales | Puerto Rico | 72039 | 173 | |
446248 | 446248 | 2020-08-18 | Ciales | Puerto Rico | 72039 | 172 | |
443022 | 443022 | 2020-08-17 | Ciales | Puerto Rico | 72039 | 171 | |
439795 | 439795 | 2020-08-16 | Ciales | Puerto Rico | 72039 | 170 | |
436570 | 436570 | 2020-08-15 | Ciales | Puerto Rico | 72039 | 168 | |
433343 | 433343 | 2020-08-14 | Ciales | Puerto Rico | 72039 | 165 | |
430117 | 430117 | 2020-08-13 | Ciales | Puerto Rico | 72039 | 163 | |
426892 | 426892 | 2020-08-12 | Ciales | Puerto Rico | 72039 | 161 | |
423669 | 423669 | 2020-08-11 | Ciales | Puerto Rico | 72039 | 158 | |
420446 | 420446 | 2020-08-10 | Ciales | Puerto Rico | 72039 | 155 | |
417226 | 417226 | 2020-08-09 | Ciales | Puerto Rico | 72039 | 149 | |
414005 | 414005 | 2020-08-08 | Ciales | Puerto Rico | 72039 | 139 | |
410785 | 410785 | 2020-08-07 | Ciales | Puerto Rico | 72039 | 135 | |
407565 | 407565 | 2020-08-06 | Ciales | Puerto Rico | 72039 | 128 | |
404346 | 404346 | 2020-08-05 | Ciales | Puerto Rico | 72039 | 125 | |
401128 | 401128 | 2020-08-04 | Ciales | Puerto Rico | 72039 | 125 | |
397913 | 397913 | 2020-08-03 | Ciales | Puerto Rico | 72039 | 122 | |
394696 | 394696 | 2020-08-02 | Ciales | Puerto Rico | 72039 | 122 | |
391480 | 391480 | 2020-08-01 | Ciales | Puerto Rico | 72039 | 120 | |
388263 | 388263 | 2020-07-31 | Ciales | Puerto Rico | 72039 | 115 | |
385046 | 385046 | 2020-07-30 | Ciales | Puerto Rico | 72039 | 115 | |
381828 | 381828 | 2020-07-29 | Ciales | Puerto Rico | 72039 | 111 | |
378611 | 378611 | 2020-07-28 | Ciales | Puerto Rico | 72039 | 108 | |
375395 | 375395 | 2020-07-27 | Ciales | Puerto Rico | 72039 | 105 | |
372182 | 372182 | 2020-07-26 | Ciales | Puerto Rico | 72039 | 105 | |
368970 | 368970 | 2020-07-25 | Ciales | Puerto Rico | 72039 | 102 | |
365761 | 365761 | 2020-07-24 | Ciales | Puerto Rico | 72039 | 96 | |
362555 | 362555 | 2020-07-23 | Ciales | Puerto Rico | 72039 | 89 | |
359349 | 359349 | 2020-07-22 | Ciales | Puerto Rico | 72039 | 83 | |
356145 | 356145 | 2020-07-21 | Ciales | Puerto Rico | 72039 | 82 | |
352942 | 352942 | 2020-07-20 | Ciales | Puerto Rico | 72039 | 81 | |
349739 | 349739 | 2020-07-19 | Ciales | Puerto Rico | 72039 | 78 | |
346539 | 346539 | 2020-07-18 | Ciales | Puerto Rico | 72039 | 76 | |
343339 | 343339 | 2020-07-17 | Ciales | Puerto Rico | 72039 | 75 | |
340141 | 340141 | 2020-07-16 | Ciales | Puerto Rico | 72039 | 73 | |
336944 | 336944 | 2020-07-15 | Ciales | Puerto Rico | 72039 | 72 | |
333750 | 333750 | 2020-07-14 | Ciales | Puerto Rico | 72039 | 69 | |
330558 | 330558 | 2020-07-13 | Ciales | Puerto Rico | 72039 | 66 | |
327372 | 327372 | 2020-07-12 | Ciales | Puerto Rico | 72039 | 65 | |
324187 | 324187 | 2020-07-11 | Ciales | Puerto Rico | 72039 | 65 | |
321007 | 321007 | 2020-07-10 | Ciales | Puerto Rico | 72039 | 65 | |
317829 | 317829 | 2020-07-09 | Ciales | Puerto Rico | 72039 | 64 |
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);