ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Carolina" 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 |
---|---|---|---|---|---|---|---|
637228 | 637228 | 2020-10-16 | Carolina | Puerto Rico | 72031 | 3355 | |
633982 | 633982 | 2020-10-15 | Carolina | Puerto Rico | 72031 | 3336 | |
630737 | 630737 | 2020-10-14 | Carolina | Puerto Rico | 72031 | 3305 | |
627493 | 627493 | 2020-10-13 | Carolina | Puerto Rico | 72031 | 3245 | |
624251 | 624251 | 2020-10-12 | Carolina | Puerto Rico | 72031 | 3237 | |
621008 | 621008 | 2020-10-11 | Carolina | Puerto Rico | 72031 | 3216 | |
617765 | 617765 | 2020-10-10 | Carolina | Puerto Rico | 72031 | 3198 | |
614523 | 614523 | 2020-10-09 | Carolina | Puerto Rico | 72031 | 3185 | |
611282 | 611282 | 2020-10-08 | Carolina | Puerto Rico | 72031 | 3145 | |
608040 | 608040 | 2020-10-07 | Carolina | Puerto Rico | 72031 | 3121 | |
604797 | 604797 | 2020-10-06 | Carolina | Puerto Rico | 72031 | 3121 | |
601555 | 601555 | 2020-10-05 | Carolina | Puerto Rico | 72031 | 3103 | |
598312 | 598312 | 2020-10-04 | Carolina | Puerto Rico | 72031 | 3055 | |
595069 | 595069 | 2020-10-03 | Carolina | Puerto Rico | 72031 | 3025 | |
591828 | 591828 | 2020-10-02 | Carolina | Puerto Rico | 72031 | 2990 | |
588587 | 588587 | 2020-10-01 | Carolina | Puerto Rico | 72031 | 2944 | |
585347 | 585347 | 2020-09-30 | Carolina | Puerto Rico | 72031 | 2924 | |
582107 | 582107 | 2020-09-29 | Carolina | Puerto Rico | 72031 | 2912 | |
578867 | 578867 | 2020-09-28 | Carolina | Puerto Rico | 72031 | 2842 | |
575626 | 575626 | 2020-09-27 | Carolina | Puerto Rico | 72031 | 2611 | |
572382 | 572382 | 2020-09-26 | Carolina | Puerto Rico | 72031 | 2563 | |
569140 | 569140 | 2020-09-25 | Carolina | Puerto Rico | 72031 | 2533 | |
565899 | 565899 | 2020-09-24 | Carolina | Puerto Rico | 72031 | 2483 | |
562658 | 562658 | 2020-09-23 | Carolina | Puerto Rico | 72031 | 2415 | |
559421 | 559421 | 2020-09-22 | Carolina | Puerto Rico | 72031 | 2413 | |
556184 | 556184 | 2020-09-21 | Carolina | Puerto Rico | 72031 | 2408 | |
552947 | 552947 | 2020-09-20 | Carolina | Puerto Rico | 72031 | 2383 | |
549708 | 549708 | 2020-09-19 | Carolina | Puerto Rico | 72031 | 2344 | |
546469 | 546469 | 2020-09-18 | Carolina | Puerto Rico | 72031 | 2279 | |
543232 | 543232 | 2020-09-17 | Carolina | Puerto Rico | 72031 | 2238 | |
539996 | 539996 | 2020-09-16 | Carolina | Puerto Rico | 72031 | 2199 | |
536759 | 536759 | 2020-09-15 | Carolina | Puerto Rico | 72031 | 2192 | |
533523 | 533523 | 2020-09-14 | Carolina | Puerto Rico | 72031 | 2161 | |
530288 | 530288 | 2020-09-13 | Carolina | Puerto Rico | 72031 | 2149 | |
527051 | 527051 | 2020-09-12 | Carolina | Puerto Rico | 72031 | 2140 | |
523815 | 523815 | 2020-09-11 | Carolina | Puerto Rico | 72031 | 2120 | |
520579 | 520579 | 2020-09-10 | Carolina | Puerto Rico | 72031 | 2105 | |
517343 | 517343 | 2020-09-09 | Carolina | Puerto Rico | 72031 | 2050 | |
514108 | 514108 | 2020-09-08 | Carolina | Puerto Rico | 72031 | 2050 | |
510875 | 510875 | 2020-09-07 | Carolina | Puerto Rico | 72031 | 2044 | |
507642 | 507642 | 2020-09-06 | Carolina | Puerto Rico | 72031 | 1980 | |
504410 | 504410 | 2020-09-05 | Carolina | Puerto Rico | 72031 | 1972 | |
501176 | 501176 | 2020-09-04 | Carolina | Puerto Rico | 72031 | 1965 | |
497942 | 497942 | 2020-09-03 | Carolina | Puerto Rico | 72031 | 1963 | |
494709 | 494709 | 2020-09-02 | Carolina | Puerto Rico | 72031 | 1946 | |
491475 | 491475 | 2020-09-01 | Carolina | Puerto Rico | 72031 | 1903 | |
488242 | 488242 | 2020-08-31 | Carolina | Puerto Rico | 72031 | 1886 | |
485009 | 485009 | 2020-08-30 | Carolina | Puerto Rico | 72031 | 1863 | |
481774 | 481774 | 2020-08-29 | Carolina | Puerto Rico | 72031 | 1843 | |
478540 | 478540 | 2020-08-28 | Carolina | Puerto Rico | 72031 | 1801 | |
475307 | 475307 | 2020-08-27 | Carolina | Puerto Rico | 72031 | 1766 | |
472073 | 472073 | 2020-08-26 | Carolina | Puerto Rico | 72031 | 1732 | |
468841 | 468841 | 2020-08-25 | Carolina | Puerto Rico | 72031 | 1728 | |
465613 | 465613 | 2020-08-24 | Carolina | Puerto Rico | 72031 | 1724 | |
462384 | 462384 | 2020-08-23 | Carolina | Puerto Rico | 72031 | 1692 | |
459156 | 459156 | 2020-08-22 | Carolina | Puerto Rico | 72031 | 1676 | |
455928 | 455928 | 2020-08-21 | Carolina | Puerto Rico | 72031 | 1641 | |
452700 | 452700 | 2020-08-20 | Carolina | Puerto Rico | 72031 | 1595 | |
449472 | 449472 | 2020-08-19 | Carolina | Puerto Rico | 72031 | 1589 | |
446244 | 446244 | 2020-08-18 | Carolina | Puerto Rico | 72031 | 1580 | |
443018 | 443018 | 2020-08-17 | Carolina | Puerto Rico | 72031 | 1533 | |
439791 | 439791 | 2020-08-16 | Carolina | Puerto Rico | 72031 | 1493 | |
436566 | 436566 | 2020-08-15 | Carolina | Puerto Rico | 72031 | 1473 | |
433339 | 433339 | 2020-08-14 | Carolina | Puerto Rico | 72031 | 1444 | |
430113 | 430113 | 2020-08-13 | Carolina | Puerto Rico | 72031 | 1407 | |
426888 | 426888 | 2020-08-12 | Carolina | Puerto Rico | 72031 | 1389 | |
423665 | 423665 | 2020-08-11 | Carolina | Puerto Rico | 72031 | 1337 | |
420442 | 420442 | 2020-08-10 | Carolina | Puerto Rico | 72031 | 1302 | |
417222 | 417222 | 2020-08-09 | Carolina | Puerto Rico | 72031 | 1263 | |
414001 | 414001 | 2020-08-08 | Carolina | Puerto Rico | 72031 | 1213 | |
410781 | 410781 | 2020-08-07 | Carolina | Puerto Rico | 72031 | 1184 | |
407561 | 407561 | 2020-08-06 | Carolina | Puerto Rico | 72031 | 1122 | |
404342 | 404342 | 2020-08-05 | Carolina | Puerto Rico | 72031 | 1103 | |
401124 | 401124 | 2020-08-04 | Carolina | Puerto Rico | 72031 | 1068 | |
397909 | 397909 | 2020-08-03 | Carolina | Puerto Rico | 72031 | 1015 | |
394692 | 394692 | 2020-08-02 | Carolina | Puerto Rico | 72031 | 981 | |
391476 | 391476 | 2020-08-01 | Carolina | Puerto Rico | 72031 | 941 | |
388259 | 388259 | 2020-07-31 | Carolina | Puerto Rico | 72031 | 848 | |
385042 | 385042 | 2020-07-30 | Carolina | Puerto Rico | 72031 | 841 | |
381824 | 381824 | 2020-07-29 | Carolina | Puerto Rico | 72031 | 813 | |
378607 | 378607 | 2020-07-28 | Carolina | Puerto Rico | 72031 | 797 | |
375391 | 375391 | 2020-07-27 | Carolina | Puerto Rico | 72031 | 779 | |
372178 | 372178 | 2020-07-26 | Carolina | Puerto Rico | 72031 | 759 | |
368966 | 368966 | 2020-07-25 | Carolina | Puerto Rico | 72031 | 740 | |
365757 | 365757 | 2020-07-24 | Carolina | Puerto Rico | 72031 | 698 | |
362551 | 362551 | 2020-07-23 | Carolina | Puerto Rico | 72031 | 676 | |
359345 | 359345 | 2020-07-22 | Carolina | Puerto Rico | 72031 | 647 | |
356141 | 356141 | 2020-07-21 | Carolina | Puerto Rico | 72031 | 636 | |
352938 | 352938 | 2020-07-20 | Carolina | Puerto Rico | 72031 | 614 | |
349735 | 349735 | 2020-07-19 | Carolina | Puerto Rico | 72031 | 583 | |
346535 | 346535 | 2020-07-18 | Carolina | Puerto Rico | 72031 | 544 | |
343335 | 343335 | 2020-07-17 | Carolina | Puerto Rico | 72031 | 523 | |
340137 | 340137 | 2020-07-16 | Carolina | Puerto Rico | 72031 | 491 | |
336940 | 336940 | 2020-07-15 | Carolina | Puerto Rico | 72031 | 481 | |
333746 | 333746 | 2020-07-14 | Carolina | Puerto Rico | 72031 | 464 | |
330554 | 330554 | 2020-07-13 | Carolina | Puerto Rico | 72031 | 462 | |
327368 | 327368 | 2020-07-12 | Carolina | Puerto Rico | 72031 | 444 | |
324183 | 324183 | 2020-07-11 | Carolina | Puerto Rico | 72031 | 429 | |
321003 | 321003 | 2020-07-10 | Carolina | Puerto Rico | 72031 | 425 | |
317825 | 317825 | 2020-07-09 | Carolina | Puerto Rico | 72031 | 409 |
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);