ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Barranquitas" 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 |
---|---|---|---|---|---|---|---|
637222 | 637222 | 2020-10-16 | Barranquitas | Puerto Rico | 72019 | 537 | |
633976 | 633976 | 2020-10-15 | Barranquitas | Puerto Rico | 72019 | 537 | |
630731 | 630731 | 2020-10-14 | Barranquitas | Puerto Rico | 72019 | 532 | |
627487 | 627487 | 2020-10-13 | Barranquitas | Puerto Rico | 72019 | 518 | |
624245 | 624245 | 2020-10-12 | Barranquitas | Puerto Rico | 72019 | 518 | |
621002 | 621002 | 2020-10-11 | Barranquitas | Puerto Rico | 72019 | 515 | |
617759 | 617759 | 2020-10-10 | Barranquitas | Puerto Rico | 72019 | 514 | |
614517 | 614517 | 2020-10-09 | Barranquitas | Puerto Rico | 72019 | 510 | |
611276 | 611276 | 2020-10-08 | Barranquitas | Puerto Rico | 72019 | 507 | |
608034 | 608034 | 2020-10-07 | Barranquitas | Puerto Rico | 72019 | 504 | |
604791 | 604791 | 2020-10-06 | Barranquitas | Puerto Rico | 72019 | 504 | |
601549 | 601549 | 2020-10-05 | Barranquitas | Puerto Rico | 72019 | 502 | |
598306 | 598306 | 2020-10-04 | Barranquitas | Puerto Rico | 72019 | 499 | |
595063 | 595063 | 2020-10-03 | Barranquitas | Puerto Rico | 72019 | 499 | |
591822 | 591822 | 2020-10-02 | Barranquitas | Puerto Rico | 72019 | 497 | |
588581 | 588581 | 2020-10-01 | Barranquitas | Puerto Rico | 72019 | 489 | |
585341 | 585341 | 2020-09-30 | Barranquitas | Puerto Rico | 72019 | 488 | |
582101 | 582101 | 2020-09-29 | Barranquitas | Puerto Rico | 72019 | 476 | |
578861 | 578861 | 2020-09-28 | Barranquitas | Puerto Rico | 72019 | 456 | |
575620 | 575620 | 2020-09-27 | Barranquitas | Puerto Rico | 72019 | 446 | |
572376 | 572376 | 2020-09-26 | Barranquitas | Puerto Rico | 72019 | 437 | |
569134 | 569134 | 2020-09-25 | Barranquitas | Puerto Rico | 72019 | 436 | |
565893 | 565893 | 2020-09-24 | Barranquitas | Puerto Rico | 72019 | 420 | |
562652 | 562652 | 2020-09-23 | Barranquitas | Puerto Rico | 72019 | 414 | |
559415 | 559415 | 2020-09-22 | Barranquitas | Puerto Rico | 72019 | 414 | |
556178 | 556178 | 2020-09-21 | Barranquitas | Puerto Rico | 72019 | 414 | |
552941 | 552941 | 2020-09-20 | Barranquitas | Puerto Rico | 72019 | 412 | |
549702 | 549702 | 2020-09-19 | Barranquitas | Puerto Rico | 72019 | 406 | |
546463 | 546463 | 2020-09-18 | Barranquitas | Puerto Rico | 72019 | 393 | |
543226 | 543226 | 2020-09-17 | Barranquitas | Puerto Rico | 72019 | 388 | |
539990 | 539990 | 2020-09-16 | Barranquitas | Puerto Rico | 72019 | 378 | |
536753 | 536753 | 2020-09-15 | Barranquitas | Puerto Rico | 72019 | 377 | |
533517 | 533517 | 2020-09-14 | Barranquitas | Puerto Rico | 72019 | 373 | |
530282 | 530282 | 2020-09-13 | Barranquitas | Puerto Rico | 72019 | 372 | |
527045 | 527045 | 2020-09-12 | Barranquitas | Puerto Rico | 72019 | 372 | |
523809 | 523809 | 2020-09-11 | Barranquitas | Puerto Rico | 72019 | 370 | |
520573 | 520573 | 2020-09-10 | Barranquitas | Puerto Rico | 72019 | 370 | |
517337 | 517337 | 2020-09-09 | Barranquitas | Puerto Rico | 72019 | 361 | |
514102 | 514102 | 2020-09-08 | Barranquitas | Puerto Rico | 72019 | 361 | |
510869 | 510869 | 2020-09-07 | Barranquitas | Puerto Rico | 72019 | 361 | |
507636 | 507636 | 2020-09-06 | Barranquitas | Puerto Rico | 72019 | 350 | |
504404 | 504404 | 2020-09-05 | Barranquitas | Puerto Rico | 72019 | 350 | |
501170 | 501170 | 2020-09-04 | Barranquitas | Puerto Rico | 72019 | 347 | |
497936 | 497936 | 2020-09-03 | Barranquitas | Puerto Rico | 72019 | 347 | |
494703 | 494703 | 2020-09-02 | Barranquitas | Puerto Rico | 72019 | 347 | |
491469 | 491469 | 2020-09-01 | Barranquitas | Puerto Rico | 72019 | 333 | |
488236 | 488236 | 2020-08-31 | Barranquitas | Puerto Rico | 72019 | 332 | |
485003 | 485003 | 2020-08-30 | Barranquitas | Puerto Rico | 72019 | 331 | |
481768 | 481768 | 2020-08-29 | Barranquitas | Puerto Rico | 72019 | 329 | |
478534 | 478534 | 2020-08-28 | Barranquitas | Puerto Rico | 72019 | 326 | |
475301 | 475301 | 2020-08-27 | Barranquitas | Puerto Rico | 72019 | 323 | |
472067 | 472067 | 2020-08-26 | Barranquitas | Puerto Rico | 72019 | 316 | |
468835 | 468835 | 2020-08-25 | Barranquitas | Puerto Rico | 72019 | 314 | |
465607 | 465607 | 2020-08-24 | Barranquitas | Puerto Rico | 72019 | 313 | |
462378 | 462378 | 2020-08-23 | Barranquitas | Puerto Rico | 72019 | 303 | |
459150 | 459150 | 2020-08-22 | Barranquitas | Puerto Rico | 72019 | 301 | |
455922 | 455922 | 2020-08-21 | Barranquitas | Puerto Rico | 72019 | 297 | |
452694 | 452694 | 2020-08-20 | Barranquitas | Puerto Rico | 72019 | 289 | |
449466 | 449466 | 2020-08-19 | Barranquitas | Puerto Rico | 72019 | 288 | |
446238 | 446238 | 2020-08-18 | Barranquitas | Puerto Rico | 72019 | 288 | |
443012 | 443012 | 2020-08-17 | Barranquitas | Puerto Rico | 72019 | 280 | |
439785 | 439785 | 2020-08-16 | Barranquitas | Puerto Rico | 72019 | 275 | |
436560 | 436560 | 2020-08-15 | Barranquitas | Puerto Rico | 72019 | 273 | |
433333 | 433333 | 2020-08-14 | Barranquitas | Puerto Rico | 72019 | 269 | |
430107 | 430107 | 2020-08-13 | Barranquitas | Puerto Rico | 72019 | 267 | |
426882 | 426882 | 2020-08-12 | Barranquitas | Puerto Rico | 72019 | 264 | |
423659 | 423659 | 2020-08-11 | Barranquitas | Puerto Rico | 72019 | 260 | |
420436 | 420436 | 2020-08-10 | Barranquitas | Puerto Rico | 72019 | 248 | |
417216 | 417216 | 2020-08-09 | Barranquitas | Puerto Rico | 72019 | 245 | |
413995 | 413995 | 2020-08-08 | Barranquitas | Puerto Rico | 72019 | 242 | |
410775 | 410775 | 2020-08-07 | Barranquitas | Puerto Rico | 72019 | 228 | |
407555 | 407555 | 2020-08-06 | Barranquitas | Puerto Rico | 72019 | 226 | |
404336 | 404336 | 2020-08-05 | Barranquitas | Puerto Rico | 72019 | 221 | |
401118 | 401118 | 2020-08-04 | Barranquitas | Puerto Rico | 72019 | 218 | |
397903 | 397903 | 2020-08-03 | Barranquitas | Puerto Rico | 72019 | 217 | |
394686 | 394686 | 2020-08-02 | Barranquitas | Puerto Rico | 72019 | 217 | |
391470 | 391470 | 2020-08-01 | Barranquitas | Puerto Rico | 72019 | 207 | |
388253 | 388253 | 2020-07-31 | Barranquitas | Puerto Rico | 72019 | 187 | |
385036 | 385036 | 2020-07-30 | Barranquitas | Puerto Rico | 72019 | 172 | |
381818 | 381818 | 2020-07-29 | Barranquitas | Puerto Rico | 72019 | 164 | |
378601 | 378601 | 2020-07-28 | Barranquitas | Puerto Rico | 72019 | 164 | |
375385 | 375385 | 2020-07-27 | Barranquitas | Puerto Rico | 72019 | 163 | |
372172 | 372172 | 2020-07-26 | Barranquitas | Puerto Rico | 72019 | 162 | |
368960 | 368960 | 2020-07-25 | Barranquitas | Puerto Rico | 72019 | 154 | |
365751 | 365751 | 2020-07-24 | Barranquitas | Puerto Rico | 72019 | 147 | |
362545 | 362545 | 2020-07-23 | Barranquitas | Puerto Rico | 72019 | 138 | |
359339 | 359339 | 2020-07-22 | Barranquitas | Puerto Rico | 72019 | 135 | |
356135 | 356135 | 2020-07-21 | Barranquitas | Puerto Rico | 72019 | 135 | |
352932 | 352932 | 2020-07-20 | Barranquitas | Puerto Rico | 72019 | 131 | |
349729 | 349729 | 2020-07-19 | Barranquitas | Puerto Rico | 72019 | 129 | |
346529 | 346529 | 2020-07-18 | Barranquitas | Puerto Rico | 72019 | 119 | |
343329 | 343329 | 2020-07-17 | Barranquitas | Puerto Rico | 72019 | 115 | |
340131 | 340131 | 2020-07-16 | Barranquitas | Puerto Rico | 72019 | 109 | |
336934 | 336934 | 2020-07-15 | Barranquitas | Puerto Rico | 72019 | 108 | |
333740 | 333740 | 2020-07-14 | Barranquitas | Puerto Rico | 72019 | 107 | |
330548 | 330548 | 2020-07-13 | Barranquitas | Puerto Rico | 72019 | 106 | |
327362 | 327362 | 2020-07-12 | Barranquitas | Puerto Rico | 72019 | 106 | |
324177 | 324177 | 2020-07-11 | Barranquitas | Puerto Rico | 72019 | 104 | |
320997 | 320997 | 2020-07-10 | Barranquitas | Puerto Rico | 72019 | 101 | |
317819 | 317819 | 2020-07-09 | Barranquitas | Puerto Rico | 72019 | 99 |
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);