ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Dorado" 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 |
---|---|---|---|---|---|---|---|
637238 | 637238 | 2020-10-16 | Dorado | Puerto Rico | 72051 | 945 | |
633992 | 633992 | 2020-10-15 | Dorado | Puerto Rico | 72051 | 935 | |
630747 | 630747 | 2020-10-14 | Dorado | Puerto Rico | 72051 | 918 | |
627503 | 627503 | 2020-10-13 | Dorado | Puerto Rico | 72051 | 894 | |
624261 | 624261 | 2020-10-12 | Dorado | Puerto Rico | 72051 | 891 | |
621018 | 621018 | 2020-10-11 | Dorado | Puerto Rico | 72051 | 883 | |
617775 | 617775 | 2020-10-10 | Dorado | Puerto Rico | 72051 | 873 | |
614533 | 614533 | 2020-10-09 | Dorado | Puerto Rico | 72051 | 871 | |
611292 | 611292 | 2020-10-08 | Dorado | Puerto Rico | 72051 | 859 | |
608050 | 608050 | 2020-10-07 | Dorado | Puerto Rico | 72051 | 857 | |
604807 | 604807 | 2020-10-06 | Dorado | Puerto Rico | 72051 | 857 | |
601565 | 601565 | 2020-10-05 | Dorado | Puerto Rico | 72051 | 852 | |
598322 | 598322 | 2020-10-04 | Dorado | Puerto Rico | 72051 | 842 | |
595079 | 595079 | 2020-10-03 | Dorado | Puerto Rico | 72051 | 835 | |
591838 | 591838 | 2020-10-02 | Dorado | Puerto Rico | 72051 | 827 | |
588597 | 588597 | 2020-10-01 | Dorado | Puerto Rico | 72051 | 820 | |
585357 | 585357 | 2020-09-30 | Dorado | Puerto Rico | 72051 | 816 | |
582117 | 582117 | 2020-09-29 | Dorado | Puerto Rico | 72051 | 811 | |
578877 | 578877 | 2020-09-28 | Dorado | Puerto Rico | 72051 | 802 | |
575636 | 575636 | 2020-09-27 | Dorado | Puerto Rico | 72051 | 786 | |
572392 | 572392 | 2020-09-26 | Dorado | Puerto Rico | 72051 | 772 | |
569150 | 569150 | 2020-09-25 | Dorado | Puerto Rico | 72051 | 764 | |
565909 | 565909 | 2020-09-24 | Dorado | Puerto Rico | 72051 | 748 | |
562668 | 562668 | 2020-09-23 | Dorado | Puerto Rico | 72051 | 723 | |
559431 | 559431 | 2020-09-22 | Dorado | Puerto Rico | 72051 | 721 | |
556194 | 556194 | 2020-09-21 | Dorado | Puerto Rico | 72051 | 717 | |
552957 | 552957 | 2020-09-20 | Dorado | Puerto Rico | 72051 | 704 | |
549718 | 549718 | 2020-09-19 | Dorado | Puerto Rico | 72051 | 652 | |
546479 | 546479 | 2020-09-18 | Dorado | Puerto Rico | 72051 | 614 | |
543242 | 543242 | 2020-09-17 | Dorado | Puerto Rico | 72051 | 611 | |
540006 | 540006 | 2020-09-16 | Dorado | Puerto Rico | 72051 | 601 | |
536769 | 536769 | 2020-09-15 | Dorado | Puerto Rico | 72051 | 600 | |
533533 | 533533 | 2020-09-14 | Dorado | Puerto Rico | 72051 | 597 | |
530298 | 530298 | 2020-09-13 | Dorado | Puerto Rico | 72051 | 587 | |
527061 | 527061 | 2020-09-12 | Dorado | Puerto Rico | 72051 | 582 | |
523825 | 523825 | 2020-09-11 | Dorado | Puerto Rico | 72051 | 571 | |
520589 | 520589 | 2020-09-10 | Dorado | Puerto Rico | 72051 | 565 | |
517353 | 517353 | 2020-09-09 | Dorado | Puerto Rico | 72051 | 559 | |
514118 | 514118 | 2020-09-08 | Dorado | Puerto Rico | 72051 | 559 | |
510885 | 510885 | 2020-09-07 | Dorado | Puerto Rico | 72051 | 556 | |
507652 | 507652 | 2020-09-06 | Dorado | Puerto Rico | 72051 | 546 | |
504420 | 504420 | 2020-09-05 | Dorado | Puerto Rico | 72051 | 544 | |
501186 | 501186 | 2020-09-04 | Dorado | Puerto Rico | 72051 | 538 | |
497952 | 497952 | 2020-09-03 | Dorado | Puerto Rico | 72051 | 537 | |
494719 | 494719 | 2020-09-02 | Dorado | Puerto Rico | 72051 | 535 | |
491485 | 491485 | 2020-09-01 | Dorado | Puerto Rico | 72051 | 523 | |
488252 | 488252 | 2020-08-31 | Dorado | Puerto Rico | 72051 | 514 | |
485019 | 485019 | 2020-08-30 | Dorado | Puerto Rico | 72051 | 511 | |
481784 | 481784 | 2020-08-29 | Dorado | Puerto Rico | 72051 | 509 | |
478550 | 478550 | 2020-08-28 | Dorado | Puerto Rico | 72051 | 465 | |
475317 | 475317 | 2020-08-27 | Dorado | Puerto Rico | 72051 | 455 | |
472083 | 472083 | 2020-08-26 | Dorado | Puerto Rico | 72051 | 449 | |
468851 | 468851 | 2020-08-25 | Dorado | Puerto Rico | 72051 | 449 | |
465623 | 465623 | 2020-08-24 | Dorado | Puerto Rico | 72051 | 445 | |
462394 | 462394 | 2020-08-23 | Dorado | Puerto Rico | 72051 | 428 | |
459166 | 459166 | 2020-08-22 | Dorado | Puerto Rico | 72051 | 422 | |
455938 | 455938 | 2020-08-21 | Dorado | Puerto Rico | 72051 | 410 | |
452710 | 452710 | 2020-08-20 | Dorado | Puerto Rico | 72051 | 400 | |
449482 | 449482 | 2020-08-19 | Dorado | Puerto Rico | 72051 | 398 | |
446254 | 446254 | 2020-08-18 | Dorado | Puerto Rico | 72051 | 395 | |
443028 | 443028 | 2020-08-17 | Dorado | Puerto Rico | 72051 | 382 | |
439801 | 439801 | 2020-08-16 | Dorado | Puerto Rico | 72051 | 365 | |
436576 | 436576 | 2020-08-15 | Dorado | Puerto Rico | 72051 | 362 | |
433349 | 433349 | 2020-08-14 | Dorado | Puerto Rico | 72051 | 354 | |
430123 | 430123 | 2020-08-13 | Dorado | Puerto Rico | 72051 | 348 | |
426898 | 426898 | 2020-08-12 | Dorado | Puerto Rico | 72051 | 341 | |
423675 | 423675 | 2020-08-11 | Dorado | Puerto Rico | 72051 | 332 | |
420452 | 420452 | 2020-08-10 | Dorado | Puerto Rico | 72051 | 325 | |
417232 | 417232 | 2020-08-09 | Dorado | Puerto Rico | 72051 | 315 | |
414011 | 414011 | 2020-08-08 | Dorado | Puerto Rico | 72051 | 306 | |
410791 | 410791 | 2020-08-07 | Dorado | Puerto Rico | 72051 | 285 | |
407571 | 407571 | 2020-08-06 | Dorado | Puerto Rico | 72051 | 276 | |
404352 | 404352 | 2020-08-05 | Dorado | Puerto Rico | 72051 | 276 | |
401134 | 401134 | 2020-08-04 | Dorado | Puerto Rico | 72051 | 266 | |
397919 | 397919 | 2020-08-03 | Dorado | Puerto Rico | 72051 | 263 | |
394702 | 394702 | 2020-08-02 | Dorado | Puerto Rico | 72051 | 260 | |
391486 | 391486 | 2020-08-01 | Dorado | Puerto Rico | 72051 | 252 | |
388269 | 388269 | 2020-07-31 | Dorado | Puerto Rico | 72051 | 228 | |
385052 | 385052 | 2020-07-30 | Dorado | Puerto Rico | 72051 | 226 | |
381834 | 381834 | 2020-07-29 | Dorado | Puerto Rico | 72051 | 224 | |
378617 | 378617 | 2020-07-28 | Dorado | Puerto Rico | 72051 | 223 | |
375401 | 375401 | 2020-07-27 | Dorado | Puerto Rico | 72051 | 217 | |
372188 | 372188 | 2020-07-26 | Dorado | Puerto Rico | 72051 | 213 | |
368976 | 368976 | 2020-07-25 | Dorado | Puerto Rico | 72051 | 203 | |
365767 | 365767 | 2020-07-24 | Dorado | Puerto Rico | 72051 | 198 | |
362561 | 362561 | 2020-07-23 | Dorado | Puerto Rico | 72051 | 189 | |
359355 | 359355 | 2020-07-22 | Dorado | Puerto Rico | 72051 | 186 | |
356151 | 356151 | 2020-07-21 | Dorado | Puerto Rico | 72051 | 185 | |
352948 | 352948 | 2020-07-20 | Dorado | Puerto Rico | 72051 | 181 | |
349745 | 349745 | 2020-07-19 | Dorado | Puerto Rico | 72051 | 173 | |
346545 | 346545 | 2020-07-18 | Dorado | Puerto Rico | 72051 | 168 | |
343345 | 343345 | 2020-07-17 | Dorado | Puerto Rico | 72051 | 154 | |
340147 | 340147 | 2020-07-16 | Dorado | Puerto Rico | 72051 | 151 | |
336950 | 336950 | 2020-07-15 | Dorado | Puerto Rico | 72051 | 147 | |
333756 | 333756 | 2020-07-14 | Dorado | Puerto Rico | 72051 | 137 | |
330564 | 330564 | 2020-07-13 | Dorado | Puerto Rico | 72051 | 128 | |
327378 | 327378 | 2020-07-12 | Dorado | Puerto Rico | 72051 | 127 | |
324193 | 324193 | 2020-07-11 | Dorado | Puerto Rico | 72051 | 123 | |
321013 | 321013 | 2020-07-10 | Dorado | Puerto Rico | 72051 | 120 | |
317835 | 317835 | 2020-07-09 | Dorado | Puerto Rico | 72051 | 117 |
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);