ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72053 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 |
---|---|---|---|---|---|---|---|
637239 | 637239 | 2020-10-16 | Fajardo | Puerto Rico | 72053 | 642 | |
633993 | 633993 | 2020-10-15 | Fajardo | Puerto Rico | 72053 | 641 | |
630748 | 630748 | 2020-10-14 | Fajardo | Puerto Rico | 72053 | 641 | |
627504 | 627504 | 2020-10-13 | Fajardo | Puerto Rico | 72053 | 627 | |
624262 | 624262 | 2020-10-12 | Fajardo | Puerto Rico | 72053 | 625 | |
621019 | 621019 | 2020-10-11 | Fajardo | Puerto Rico | 72053 | 621 | |
617776 | 617776 | 2020-10-10 | Fajardo | Puerto Rico | 72053 | 616 | |
614534 | 614534 | 2020-10-09 | Fajardo | Puerto Rico | 72053 | 613 | |
611293 | 611293 | 2020-10-08 | Fajardo | Puerto Rico | 72053 | 605 | |
608051 | 608051 | 2020-10-07 | Fajardo | Puerto Rico | 72053 | 603 | |
604808 | 604808 | 2020-10-06 | Fajardo | Puerto Rico | 72053 | 603 | |
601566 | 601566 | 2020-10-05 | Fajardo | Puerto Rico | 72053 | 592 | |
598323 | 598323 | 2020-10-04 | Fajardo | Puerto Rico | 72053 | 586 | |
595080 | 595080 | 2020-10-03 | Fajardo | Puerto Rico | 72053 | 584 | |
591839 | 591839 | 2020-10-02 | Fajardo | Puerto Rico | 72053 | 580 | |
588598 | 588598 | 2020-10-01 | Fajardo | Puerto Rico | 72053 | 573 | |
585358 | 585358 | 2020-09-30 | Fajardo | Puerto Rico | 72053 | 571 | |
582118 | 582118 | 2020-09-29 | Fajardo | Puerto Rico | 72053 | 570 | |
578878 | 578878 | 2020-09-28 | Fajardo | Puerto Rico | 72053 | 552 | |
575637 | 575637 | 2020-09-27 | Fajardo | Puerto Rico | 72053 | 543 | |
572393 | 572393 | 2020-09-26 | Fajardo | Puerto Rico | 72053 | 518 | |
569151 | 569151 | 2020-09-25 | Fajardo | Puerto Rico | 72053 | 517 | |
565910 | 565910 | 2020-09-24 | Fajardo | Puerto Rico | 72053 | 494 | |
562669 | 562669 | 2020-09-23 | Fajardo | Puerto Rico | 72053 | 473 | |
559432 | 559432 | 2020-09-22 | Fajardo | Puerto Rico | 72053 | 473 | |
556195 | 556195 | 2020-09-21 | Fajardo | Puerto Rico | 72053 | 473 | |
552958 | 552958 | 2020-09-20 | Fajardo | Puerto Rico | 72053 | 469 | |
549719 | 549719 | 2020-09-19 | Fajardo | Puerto Rico | 72053 | 466 | |
546480 | 546480 | 2020-09-18 | Fajardo | Puerto Rico | 72053 | 450 | |
543243 | 543243 | 2020-09-17 | Fajardo | Puerto Rico | 72053 | 429 | |
540007 | 540007 | 2020-09-16 | Fajardo | Puerto Rico | 72053 | 420 | |
536770 | 536770 | 2020-09-15 | Fajardo | Puerto Rico | 72053 | 417 | |
533534 | 533534 | 2020-09-14 | Fajardo | Puerto Rico | 72053 | 413 | |
530299 | 530299 | 2020-09-13 | Fajardo | Puerto Rico | 72053 | 411 | |
527062 | 527062 | 2020-09-12 | Fajardo | Puerto Rico | 72053 | 408 | |
523826 | 523826 | 2020-09-11 | Fajardo | Puerto Rico | 72053 | 402 | |
520590 | 520590 | 2020-09-10 | Fajardo | Puerto Rico | 72053 | 399 | |
517354 | 517354 | 2020-09-09 | Fajardo | Puerto Rico | 72053 | 389 | |
514119 | 514119 | 2020-09-08 | Fajardo | Puerto Rico | 72053 | 389 | |
510886 | 510886 | 2020-09-07 | Fajardo | Puerto Rico | 72053 | 383 | |
507653 | 507653 | 2020-09-06 | Fajardo | Puerto Rico | 72053 | 372 | |
504421 | 504421 | 2020-09-05 | Fajardo | Puerto Rico | 72053 | 369 | |
501187 | 501187 | 2020-09-04 | Fajardo | Puerto Rico | 72053 | 364 | |
497953 | 497953 | 2020-09-03 | Fajardo | Puerto Rico | 72053 | 364 | |
494720 | 494720 | 2020-09-02 | Fajardo | Puerto Rico | 72053 | 360 | |
491486 | 491486 | 2020-09-01 | Fajardo | Puerto Rico | 72053 | 350 | |
488253 | 488253 | 2020-08-31 | Fajardo | Puerto Rico | 72053 | 349 | |
485020 | 485020 | 2020-08-30 | Fajardo | Puerto Rico | 72053 | 348 | |
481785 | 481785 | 2020-08-29 | Fajardo | Puerto Rico | 72053 | 348 | |
478551 | 478551 | 2020-08-28 | Fajardo | Puerto Rico | 72053 | 341 | |
475318 | 475318 | 2020-08-27 | Fajardo | Puerto Rico | 72053 | 334 | |
472084 | 472084 | 2020-08-26 | Fajardo | Puerto Rico | 72053 | 329 | |
468852 | 468852 | 2020-08-25 | Fajardo | Puerto Rico | 72053 | 330 | |
465624 | 465624 | 2020-08-24 | Fajardo | Puerto Rico | 72053 | 329 | |
462395 | 462395 | 2020-08-23 | Fajardo | Puerto Rico | 72053 | 321 | |
459167 | 459167 | 2020-08-22 | Fajardo | Puerto Rico | 72053 | 314 | |
455939 | 455939 | 2020-08-21 | Fajardo | Puerto Rico | 72053 | 312 | |
452711 | 452711 | 2020-08-20 | Fajardo | Puerto Rico | 72053 | 306 | |
449483 | 449483 | 2020-08-19 | Fajardo | Puerto Rico | 72053 | 303 | |
446255 | 446255 | 2020-08-18 | Fajardo | Puerto Rico | 72053 | 301 | |
443029 | 443029 | 2020-08-17 | Fajardo | Puerto Rico | 72053 | 293 | |
439802 | 439802 | 2020-08-16 | Fajardo | Puerto Rico | 72053 | 290 | |
436577 | 436577 | 2020-08-15 | Fajardo | Puerto Rico | 72053 | 288 | |
433350 | 433350 | 2020-08-14 | Fajardo | Puerto Rico | 72053 | 281 | |
430124 | 430124 | 2020-08-13 | Fajardo | Puerto Rico | 72053 | 276 | |
426899 | 426899 | 2020-08-12 | Fajardo | Puerto Rico | 72053 | 276 | |
423676 | 423676 | 2020-08-11 | Fajardo | Puerto Rico | 72053 | 266 | |
420453 | 420453 | 2020-08-10 | Fajardo | Puerto Rico | 72053 | 256 | |
417233 | 417233 | 2020-08-09 | Fajardo | Puerto Rico | 72053 | 240 | |
414012 | 414012 | 2020-08-08 | Fajardo | Puerto Rico | 72053 | 232 | |
410792 | 410792 | 2020-08-07 | Fajardo | Puerto Rico | 72053 | 222 | |
407572 | 407572 | 2020-08-06 | Fajardo | Puerto Rico | 72053 | 213 | |
404353 | 404353 | 2020-08-05 | Fajardo | Puerto Rico | 72053 | 212 | |
401135 | 401135 | 2020-08-04 | Fajardo | Puerto Rico | 72053 | 209 | |
397920 | 397920 | 2020-08-03 | Fajardo | Puerto Rico | 72053 | 208 | |
394703 | 394703 | 2020-08-02 | Fajardo | Puerto Rico | 72053 | 201 | |
391487 | 391487 | 2020-08-01 | Fajardo | Puerto Rico | 72053 | 196 | |
388270 | 388270 | 2020-07-31 | Fajardo | Puerto Rico | 72053 | 180 | |
385053 | 385053 | 2020-07-30 | Fajardo | Puerto Rico | 72053 | 176 | |
381835 | 381835 | 2020-07-29 | Fajardo | Puerto Rico | 72053 | 168 | |
378618 | 378618 | 2020-07-28 | Fajardo | Puerto Rico | 72053 | 167 | |
375402 | 375402 | 2020-07-27 | Fajardo | Puerto Rico | 72053 | 165 | |
372189 | 372189 | 2020-07-26 | Fajardo | Puerto Rico | 72053 | 162 | |
368977 | 368977 | 2020-07-25 | Fajardo | Puerto Rico | 72053 | 154 | |
365768 | 365768 | 2020-07-24 | Fajardo | Puerto Rico | 72053 | 152 | |
362562 | 362562 | 2020-07-23 | Fajardo | Puerto Rico | 72053 | 144 | |
359356 | 359356 | 2020-07-22 | Fajardo | Puerto Rico | 72053 | 135 | |
356152 | 356152 | 2020-07-21 | Fajardo | Puerto Rico | 72053 | 133 | |
352949 | 352949 | 2020-07-20 | Fajardo | Puerto Rico | 72053 | 128 | |
349746 | 349746 | 2020-07-19 | Fajardo | Puerto Rico | 72053 | 124 | |
346546 | 346546 | 2020-07-18 | Fajardo | Puerto Rico | 72053 | 117 | |
343346 | 343346 | 2020-07-17 | Fajardo | Puerto Rico | 72053 | 115 | |
340148 | 340148 | 2020-07-16 | Fajardo | Puerto Rico | 72053 | 110 | |
336951 | 336951 | 2020-07-15 | Fajardo | Puerto Rico | 72053 | 110 | |
333757 | 333757 | 2020-07-14 | Fajardo | Puerto Rico | 72053 | 107 | |
330565 | 330565 | 2020-07-13 | Fajardo | Puerto Rico | 72053 | 105 | |
327379 | 327379 | 2020-07-12 | Fajardo | Puerto Rico | 72053 | 102 | |
324194 | 324194 | 2020-07-11 | Fajardo | Puerto Rico | 72053 | 101 | |
321014 | 321014 | 2020-07-10 | Fajardo | Puerto Rico | 72053 | 101 | |
317836 | 317836 | 2020-07-09 | Fajardo | Puerto Rico | 72053 | 97 |
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);