ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Arecibo" 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 |
---|---|---|---|---|---|---|---|
637219 | 637219 | 2020-10-16 | Arecibo | Puerto Rico | 72013 | 971 | |
633973 | 633973 | 2020-10-15 | Arecibo | Puerto Rico | 72013 | 969 | |
630728 | 630728 | 2020-10-14 | Arecibo | Puerto Rico | 72013 | 963 | |
627484 | 627484 | 2020-10-13 | Arecibo | Puerto Rico | 72013 | 957 | |
624242 | 624242 | 2020-10-12 | Arecibo | Puerto Rico | 72013 | 955 | |
620999 | 620999 | 2020-10-11 | Arecibo | Puerto Rico | 72013 | 952 | |
617756 | 617756 | 2020-10-10 | Arecibo | Puerto Rico | 72013 | 948 | |
614514 | 614514 | 2020-10-09 | Arecibo | Puerto Rico | 72013 | 939 | |
611273 | 611273 | 2020-10-08 | Arecibo | Puerto Rico | 72013 | 929 | |
608031 | 608031 | 2020-10-07 | Arecibo | Puerto Rico | 72013 | 917 | |
604788 | 604788 | 2020-10-06 | Arecibo | Puerto Rico | 72013 | 916 | |
601546 | 601546 | 2020-10-05 | Arecibo | Puerto Rico | 72013 | 908 | |
598303 | 598303 | 2020-10-04 | Arecibo | Puerto Rico | 72013 | 901 | |
595060 | 595060 | 2020-10-03 | Arecibo | Puerto Rico | 72013 | 899 | |
591819 | 591819 | 2020-10-02 | Arecibo | Puerto Rico | 72013 | 887 | |
588578 | 588578 | 2020-10-01 | Arecibo | Puerto Rico | 72013 | 863 | |
585338 | 585338 | 2020-09-30 | Arecibo | Puerto Rico | 72013 | 849 | |
582098 | 582098 | 2020-09-29 | Arecibo | Puerto Rico | 72013 | 845 | |
578858 | 578858 | 2020-09-28 | Arecibo | Puerto Rico | 72013 | 836 | |
575617 | 575617 | 2020-09-27 | Arecibo | Puerto Rico | 72013 | 827 | |
572373 | 572373 | 2020-09-26 | Arecibo | Puerto Rico | 72013 | 813 | |
569131 | 569131 | 2020-09-25 | Arecibo | Puerto Rico | 72013 | 794 | |
565890 | 565890 | 2020-09-24 | Arecibo | Puerto Rico | 72013 | 774 | |
562649 | 562649 | 2020-09-23 | Arecibo | Puerto Rico | 72013 | 756 | |
559412 | 559412 | 2020-09-22 | Arecibo | Puerto Rico | 72013 | 744 | |
556175 | 556175 | 2020-09-21 | Arecibo | Puerto Rico | 72013 | 743 | |
552938 | 552938 | 2020-09-20 | Arecibo | Puerto Rico | 72013 | 708 | |
549699 | 549699 | 2020-09-19 | Arecibo | Puerto Rico | 72013 | 691 | |
546460 | 546460 | 2020-09-18 | Arecibo | Puerto Rico | 72013 | 662 | |
543223 | 543223 | 2020-09-17 | Arecibo | Puerto Rico | 72013 | 628 | |
539987 | 539987 | 2020-09-16 | Arecibo | Puerto Rico | 72013 | 608 | |
536750 | 536750 | 2020-09-15 | Arecibo | Puerto Rico | 72013 | 604 | |
533514 | 533514 | 2020-09-14 | Arecibo | Puerto Rico | 72013 | 594 | |
530279 | 530279 | 2020-09-13 | Arecibo | Puerto Rico | 72013 | 586 | |
527042 | 527042 | 2020-09-12 | Arecibo | Puerto Rico | 72013 | 574 | |
523806 | 523806 | 2020-09-11 | Arecibo | Puerto Rico | 72013 | 561 | |
520570 | 520570 | 2020-09-10 | Arecibo | Puerto Rico | 72013 | 554 | |
517334 | 517334 | 2020-09-09 | Arecibo | Puerto Rico | 72013 | 541 | |
514099 | 514099 | 2020-09-08 | Arecibo | Puerto Rico | 72013 | 541 | |
510866 | 510866 | 2020-09-07 | Arecibo | Puerto Rico | 72013 | 542 | |
507633 | 507633 | 2020-09-06 | Arecibo | Puerto Rico | 72013 | 530 | |
504401 | 504401 | 2020-09-05 | Arecibo | Puerto Rico | 72013 | 530 | |
501167 | 501167 | 2020-09-04 | Arecibo | Puerto Rico | 72013 | 529 | |
497933 | 497933 | 2020-09-03 | Arecibo | Puerto Rico | 72013 | 527 | |
494700 | 494700 | 2020-09-02 | Arecibo | Puerto Rico | 72013 | 519 | |
491466 | 491466 | 2020-09-01 | Arecibo | Puerto Rico | 72013 | 511 | |
488233 | 488233 | 2020-08-31 | Arecibo | Puerto Rico | 72013 | 510 | |
485000 | 485000 | 2020-08-30 | Arecibo | Puerto Rico | 72013 | 501 | |
481765 | 481765 | 2020-08-29 | Arecibo | Puerto Rico | 72013 | 493 | |
478531 | 478531 | 2020-08-28 | Arecibo | Puerto Rico | 72013 | 484 | |
475298 | 475298 | 2020-08-27 | Arecibo | Puerto Rico | 72013 | 477 | |
472064 | 472064 | 2020-08-26 | Arecibo | Puerto Rico | 72013 | 462 | |
468832 | 468832 | 2020-08-25 | Arecibo | Puerto Rico | 72013 | 458 | |
465604 | 465604 | 2020-08-24 | Arecibo | Puerto Rico | 72013 | 457 | |
462375 | 462375 | 2020-08-23 | Arecibo | Puerto Rico | 72013 | 449 | |
459147 | 459147 | 2020-08-22 | Arecibo | Puerto Rico | 72013 | 437 | |
455919 | 455919 | 2020-08-21 | Arecibo | Puerto Rico | 72013 | 426 | |
452691 | 452691 | 2020-08-20 | Arecibo | Puerto Rico | 72013 | 420 | |
449463 | 449463 | 2020-08-19 | Arecibo | Puerto Rico | 72013 | 414 | |
446235 | 446235 | 2020-08-18 | Arecibo | Puerto Rico | 72013 | 404 | |
443009 | 443009 | 2020-08-17 | Arecibo | Puerto Rico | 72013 | 389 | |
439782 | 439782 | 2020-08-16 | Arecibo | Puerto Rico | 72013 | 384 | |
436557 | 436557 | 2020-08-15 | Arecibo | Puerto Rico | 72013 | 377 | |
433330 | 433330 | 2020-08-14 | Arecibo | Puerto Rico | 72013 | 366 | |
430104 | 430104 | 2020-08-13 | Arecibo | Puerto Rico | 72013 | 352 | |
426879 | 426879 | 2020-08-12 | Arecibo | Puerto Rico | 72013 | 341 | |
423656 | 423656 | 2020-08-11 | Arecibo | Puerto Rico | 72013 | 336 | |
420433 | 420433 | 2020-08-10 | Arecibo | Puerto Rico | 72013 | 324 | |
417213 | 417213 | 2020-08-09 | Arecibo | Puerto Rico | 72013 | 312 | |
413992 | 413992 | 2020-08-08 | Arecibo | Puerto Rico | 72013 | 301 | |
410772 | 410772 | 2020-08-07 | Arecibo | Puerto Rico | 72013 | 287 | |
407552 | 407552 | 2020-08-06 | Arecibo | Puerto Rico | 72013 | 280 | |
404333 | 404333 | 2020-08-05 | Arecibo | Puerto Rico | 72013 | 277 | |
401115 | 401115 | 2020-08-04 | Arecibo | Puerto Rico | 72013 | 269 | |
397900 | 397900 | 2020-08-03 | Arecibo | Puerto Rico | 72013 | 262 | |
394683 | 394683 | 2020-08-02 | Arecibo | Puerto Rico | 72013 | 260 | |
391467 | 391467 | 2020-08-01 | Arecibo | Puerto Rico | 72013 | 254 | |
388250 | 388250 | 2020-07-31 | Arecibo | Puerto Rico | 72013 | 240 | |
385033 | 385033 | 2020-07-30 | Arecibo | Puerto Rico | 72013 | 237 | |
381815 | 381815 | 2020-07-29 | Arecibo | Puerto Rico | 72013 | 230 | |
378598 | 378598 | 2020-07-28 | Arecibo | Puerto Rico | 72013 | 229 | |
375382 | 375382 | 2020-07-27 | Arecibo | Puerto Rico | 72013 | 228 | |
372169 | 372169 | 2020-07-26 | Arecibo | Puerto Rico | 72013 | 227 | |
368957 | 368957 | 2020-07-25 | Arecibo | Puerto Rico | 72013 | 224 | |
365748 | 365748 | 2020-07-24 | Arecibo | Puerto Rico | 72013 | 208 | |
362542 | 362542 | 2020-07-23 | Arecibo | Puerto Rico | 72013 | 202 | |
359336 | 359336 | 2020-07-22 | Arecibo | Puerto Rico | 72013 | 193 | |
356132 | 356132 | 2020-07-21 | Arecibo | Puerto Rico | 72013 | 189 | |
352929 | 352929 | 2020-07-20 | Arecibo | Puerto Rico | 72013 | 186 | |
349726 | 349726 | 2020-07-19 | Arecibo | Puerto Rico | 72013 | 182 | |
346526 | 346526 | 2020-07-18 | Arecibo | Puerto Rico | 72013 | 174 | |
343326 | 343326 | 2020-07-17 | Arecibo | Puerto Rico | 72013 | 172 | |
340128 | 340128 | 2020-07-16 | Arecibo | Puerto Rico | 72013 | 167 | |
336931 | 336931 | 2020-07-15 | Arecibo | Puerto Rico | 72013 | 161 | |
333737 | 333737 | 2020-07-14 | Arecibo | Puerto Rico | 72013 | 162 | |
330545 | 330545 | 2020-07-13 | Arecibo | Puerto Rico | 72013 | 162 | |
327359 | 327359 | 2020-07-12 | Arecibo | Puerto Rico | 72013 | 151 | |
324174 | 324174 | 2020-07-11 | Arecibo | Puerto Rico | 72013 | 148 | |
320994 | 320994 | 2020-07-10 | Arecibo | Puerto Rico | 72013 | 147 | |
317816 | 317816 | 2020-07-09 | Arecibo | Puerto Rico | 72013 | 143 |
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);