ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Canovanas" 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 |
---|---|---|---|---|---|---|---|
637227 | 637227 | 2020-10-16 | Canovanas | Puerto Rico | 72029 | 797 | |
633981 | 633981 | 2020-10-15 | Canovanas | Puerto Rico | 72029 | 794 | |
630736 | 630736 | 2020-10-14 | Canovanas | Puerto Rico | 72029 | 789 | |
627492 | 627492 | 2020-10-13 | Canovanas | Puerto Rico | 72029 | 776 | |
624250 | 624250 | 2020-10-12 | Canovanas | Puerto Rico | 72029 | 774 | |
621007 | 621007 | 2020-10-11 | Canovanas | Puerto Rico | 72029 | 769 | |
617764 | 617764 | 2020-10-10 | Canovanas | Puerto Rico | 72029 | 767 | |
614522 | 614522 | 2020-10-09 | Canovanas | Puerto Rico | 72029 | 766 | |
611281 | 611281 | 2020-10-08 | Canovanas | Puerto Rico | 72029 | 763 | |
608039 | 608039 | 2020-10-07 | Canovanas | Puerto Rico | 72029 | 757 | |
604796 | 604796 | 2020-10-06 | Canovanas | Puerto Rico | 72029 | 755 | |
601554 | 601554 | 2020-10-05 | Canovanas | Puerto Rico | 72029 | 748 | |
598311 | 598311 | 2020-10-04 | Canovanas | Puerto Rico | 72029 | 745 | |
595068 | 595068 | 2020-10-03 | Canovanas | Puerto Rico | 72029 | 743 | |
591827 | 591827 | 2020-10-02 | Canovanas | Puerto Rico | 72029 | 740 | |
588586 | 588586 | 2020-10-01 | Canovanas | Puerto Rico | 72029 | 737 | |
585346 | 585346 | 2020-09-30 | Canovanas | Puerto Rico | 72029 | 734 | |
582106 | 582106 | 2020-09-29 | Canovanas | Puerto Rico | 72029 | 729 | |
578866 | 578866 | 2020-09-28 | Canovanas | Puerto Rico | 72029 | 715 | |
575625 | 575625 | 2020-09-27 | Canovanas | Puerto Rico | 72029 | 690 | |
572381 | 572381 | 2020-09-26 | Canovanas | Puerto Rico | 72029 | 682 | |
569139 | 569139 | 2020-09-25 | Canovanas | Puerto Rico | 72029 | 669 | |
565898 | 565898 | 2020-09-24 | Canovanas | Puerto Rico | 72029 | 650 | |
562657 | 562657 | 2020-09-23 | Canovanas | Puerto Rico | 72029 | 635 | |
559420 | 559420 | 2020-09-22 | Canovanas | Puerto Rico | 72029 | 634 | |
556183 | 556183 | 2020-09-21 | Canovanas | Puerto Rico | 72029 | 631 | |
552946 | 552946 | 2020-09-20 | Canovanas | Puerto Rico | 72029 | 627 | |
549707 | 549707 | 2020-09-19 | Canovanas | Puerto Rico | 72029 | 619 | |
546468 | 546468 | 2020-09-18 | Canovanas | Puerto Rico | 72029 | 606 | |
543231 | 543231 | 2020-09-17 | Canovanas | Puerto Rico | 72029 | 598 | |
539995 | 539995 | 2020-09-16 | Canovanas | Puerto Rico | 72029 | 590 | |
536758 | 536758 | 2020-09-15 | Canovanas | Puerto Rico | 72029 | 588 | |
533522 | 533522 | 2020-09-14 | Canovanas | Puerto Rico | 72029 | 581 | |
530287 | 530287 | 2020-09-13 | Canovanas | Puerto Rico | 72029 | 580 | |
527050 | 527050 | 2020-09-12 | Canovanas | Puerto Rico | 72029 | 579 | |
523814 | 523814 | 2020-09-11 | Canovanas | Puerto Rico | 72029 | 572 | |
520578 | 520578 | 2020-09-10 | Canovanas | Puerto Rico | 72029 | 566 | |
517342 | 517342 | 2020-09-09 | Canovanas | Puerto Rico | 72029 | 556 | |
514107 | 514107 | 2020-09-08 | Canovanas | Puerto Rico | 72029 | 556 | |
510874 | 510874 | 2020-09-07 | Canovanas | Puerto Rico | 72029 | 554 | |
507641 | 507641 | 2020-09-06 | Canovanas | Puerto Rico | 72029 | 537 | |
504409 | 504409 | 2020-09-05 | Canovanas | Puerto Rico | 72029 | 535 | |
501175 | 501175 | 2020-09-04 | Canovanas | Puerto Rico | 72029 | 529 | |
497941 | 497941 | 2020-09-03 | Canovanas | Puerto Rico | 72029 | 528 | |
494708 | 494708 | 2020-09-02 | Canovanas | Puerto Rico | 72029 | 524 | |
491474 | 491474 | 2020-09-01 | Canovanas | Puerto Rico | 72029 | 523 | |
488241 | 488241 | 2020-08-31 | Canovanas | Puerto Rico | 72029 | 522 | |
485008 | 485008 | 2020-08-30 | Canovanas | Puerto Rico | 72029 | 514 | |
481773 | 481773 | 2020-08-29 | Canovanas | Puerto Rico | 72029 | 503 | |
478539 | 478539 | 2020-08-28 | Canovanas | Puerto Rico | 72029 | 495 | |
475306 | 475306 | 2020-08-27 | Canovanas | Puerto Rico | 72029 | 489 | |
472072 | 472072 | 2020-08-26 | Canovanas | Puerto Rico | 72029 | 483 | |
468840 | 468840 | 2020-08-25 | Canovanas | Puerto Rico | 72029 | 481 | |
465612 | 465612 | 2020-08-24 | Canovanas | Puerto Rico | 72029 | 480 | |
462383 | 462383 | 2020-08-23 | Canovanas | Puerto Rico | 72029 | 469 | |
459155 | 459155 | 2020-08-22 | Canovanas | Puerto Rico | 72029 | 469 | |
455927 | 455927 | 2020-08-21 | Canovanas | Puerto Rico | 72029 | 458 | |
452699 | 452699 | 2020-08-20 | Canovanas | Puerto Rico | 72029 | 448 | |
449471 | 449471 | 2020-08-19 | Canovanas | Puerto Rico | 72029 | 445 | |
446243 | 446243 | 2020-08-18 | Canovanas | Puerto Rico | 72029 | 438 | |
443017 | 443017 | 2020-08-17 | Canovanas | Puerto Rico | 72029 | 432 | |
439790 | 439790 | 2020-08-16 | Canovanas | Puerto Rico | 72029 | 425 | |
436565 | 436565 | 2020-08-15 | Canovanas | Puerto Rico | 72029 | 423 | |
433338 | 433338 | 2020-08-14 | Canovanas | Puerto Rico | 72029 | 417 | |
430112 | 430112 | 2020-08-13 | Canovanas | Puerto Rico | 72029 | 415 | |
426887 | 426887 | 2020-08-12 | Canovanas | Puerto Rico | 72029 | 412 | |
423664 | 423664 | 2020-08-11 | Canovanas | Puerto Rico | 72029 | 404 | |
420441 | 420441 | 2020-08-10 | Canovanas | Puerto Rico | 72029 | 388 | |
417221 | 417221 | 2020-08-09 | Canovanas | Puerto Rico | 72029 | 373 | |
414000 | 414000 | 2020-08-08 | Canovanas | Puerto Rico | 72029 | 359 | |
410780 | 410780 | 2020-08-07 | Canovanas | Puerto Rico | 72029 | 352 | |
407560 | 407560 | 2020-08-06 | Canovanas | Puerto Rico | 72029 | 339 | |
404341 | 404341 | 2020-08-05 | Canovanas | Puerto Rico | 72029 | 331 | |
401123 | 401123 | 2020-08-04 | Canovanas | Puerto Rico | 72029 | 323 | |
397908 | 397908 | 2020-08-03 | Canovanas | Puerto Rico | 72029 | 315 | |
394691 | 394691 | 2020-08-02 | Canovanas | Puerto Rico | 72029 | 302 | |
391475 | 391475 | 2020-08-01 | Canovanas | Puerto Rico | 72029 | 298 | |
388258 | 388258 | 2020-07-31 | Canovanas | Puerto Rico | 72029 | 282 | |
385041 | 385041 | 2020-07-30 | Canovanas | Puerto Rico | 72029 | 280 | |
381823 | 381823 | 2020-07-29 | Canovanas | Puerto Rico | 72029 | 269 | |
378606 | 378606 | 2020-07-28 | Canovanas | Puerto Rico | 72029 | 269 | |
375390 | 375390 | 2020-07-27 | Canovanas | Puerto Rico | 72029 | 263 | |
372177 | 372177 | 2020-07-26 | Canovanas | Puerto Rico | 72029 | 258 | |
368965 | 368965 | 2020-07-25 | Canovanas | Puerto Rico | 72029 | 247 | |
365756 | 365756 | 2020-07-24 | Canovanas | Puerto Rico | 72029 | 242 | |
362550 | 362550 | 2020-07-23 | Canovanas | Puerto Rico | 72029 | 236 | |
359344 | 359344 | 2020-07-22 | Canovanas | Puerto Rico | 72029 | 228 | |
356140 | 356140 | 2020-07-21 | Canovanas | Puerto Rico | 72029 | 225 | |
352937 | 352937 | 2020-07-20 | Canovanas | Puerto Rico | 72029 | 219 | |
349734 | 349734 | 2020-07-19 | Canovanas | Puerto Rico | 72029 | 213 | |
346534 | 346534 | 2020-07-18 | Canovanas | Puerto Rico | 72029 | 205 | |
343334 | 343334 | 2020-07-17 | Canovanas | Puerto Rico | 72029 | 199 | |
340136 | 340136 | 2020-07-16 | Canovanas | Puerto Rico | 72029 | 191 | |
336939 | 336939 | 2020-07-15 | Canovanas | Puerto Rico | 72029 | 188 | |
333745 | 333745 | 2020-07-14 | Canovanas | Puerto Rico | 72029 | 185 | |
330553 | 330553 | 2020-07-13 | Canovanas | Puerto Rico | 72029 | 184 | |
327367 | 327367 | 2020-07-12 | Canovanas | Puerto Rico | 72029 | 178 | |
324182 | 324182 | 2020-07-11 | Canovanas | Puerto Rico | 72029 | 172 | |
321002 | 321002 | 2020-07-10 | Canovanas | Puerto Rico | 72029 | 169 | |
317824 | 317824 | 2020-07-09 | Canovanas | Puerto Rico | 72029 | 163 |
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);