ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ceiba" 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 |
---|---|---|---|---|---|---|---|
637231 | 637231 | 2020-10-16 | Ceiba | Puerto Rico | 72037 | 167 | |
633985 | 633985 | 2020-10-15 | Ceiba | Puerto Rico | 72037 | 167 | |
630740 | 630740 | 2020-10-14 | Ceiba | Puerto Rico | 72037 | 167 | |
627496 | 627496 | 2020-10-13 | Ceiba | Puerto Rico | 72037 | 166 | |
624254 | 624254 | 2020-10-12 | Ceiba | Puerto Rico | 72037 | 164 | |
621011 | 621011 | 2020-10-11 | Ceiba | Puerto Rico | 72037 | 156 | |
617768 | 617768 | 2020-10-10 | Ceiba | Puerto Rico | 72037 | 155 | |
614526 | 614526 | 2020-10-09 | Ceiba | Puerto Rico | 72037 | 153 | |
611285 | 611285 | 2020-10-08 | Ceiba | Puerto Rico | 72037 | 153 | |
608043 | 608043 | 2020-10-07 | Ceiba | Puerto Rico | 72037 | 148 | |
604800 | 604800 | 2020-10-06 | Ceiba | Puerto Rico | 72037 | 148 | |
601558 | 601558 | 2020-10-05 | Ceiba | Puerto Rico | 72037 | 146 | |
598315 | 598315 | 2020-10-04 | Ceiba | Puerto Rico | 72037 | 145 | |
595072 | 595072 | 2020-10-03 | Ceiba | Puerto Rico | 72037 | 145 | |
591831 | 591831 | 2020-10-02 | Ceiba | Puerto Rico | 72037 | 145 | |
588590 | 588590 | 2020-10-01 | Ceiba | Puerto Rico | 72037 | 144 | |
585350 | 585350 | 2020-09-30 | Ceiba | Puerto Rico | 72037 | 144 | |
582110 | 582110 | 2020-09-29 | Ceiba | Puerto Rico | 72037 | 144 | |
578870 | 578870 | 2020-09-28 | Ceiba | Puerto Rico | 72037 | 141 | |
575629 | 575629 | 2020-09-27 | Ceiba | Puerto Rico | 72037 | 132 | |
572385 | 572385 | 2020-09-26 | Ceiba | Puerto Rico | 72037 | 131 | |
569143 | 569143 | 2020-09-25 | Ceiba | Puerto Rico | 72037 | 122 | |
565902 | 565902 | 2020-09-24 | Ceiba | Puerto Rico | 72037 | 117 | |
562661 | 562661 | 2020-09-23 | Ceiba | Puerto Rico | 72037 | 112 | |
559424 | 559424 | 2020-09-22 | Ceiba | Puerto Rico | 72037 | 112 | |
556187 | 556187 | 2020-09-21 | Ceiba | Puerto Rico | 72037 | 112 | |
552950 | 552950 | 2020-09-20 | Ceiba | Puerto Rico | 72037 | 108 | |
549711 | 549711 | 2020-09-19 | Ceiba | Puerto Rico | 72037 | 107 | |
546472 | 546472 | 2020-09-18 | Ceiba | Puerto Rico | 72037 | 104 | |
543235 | 543235 | 2020-09-17 | Ceiba | Puerto Rico | 72037 | 102 | |
539999 | 539999 | 2020-09-16 | Ceiba | Puerto Rico | 72037 | 100 | |
536762 | 536762 | 2020-09-15 | Ceiba | Puerto Rico | 72037 | 100 | |
533526 | 533526 | 2020-09-14 | Ceiba | Puerto Rico | 72037 | 96 | |
530291 | 530291 | 2020-09-13 | Ceiba | Puerto Rico | 72037 | 96 | |
527054 | 527054 | 2020-09-12 | Ceiba | Puerto Rico | 72037 | 95 | |
523818 | 523818 | 2020-09-11 | Ceiba | Puerto Rico | 72037 | 95 | |
520582 | 520582 | 2020-09-10 | Ceiba | Puerto Rico | 72037 | 94 | |
517346 | 517346 | 2020-09-09 | Ceiba | Puerto Rico | 72037 | 93 | |
514111 | 514111 | 2020-09-08 | Ceiba | Puerto Rico | 72037 | 93 | |
510878 | 510878 | 2020-09-07 | Ceiba | Puerto Rico | 72037 | 93 | |
507645 | 507645 | 2020-09-06 | Ceiba | Puerto Rico | 72037 | 92 | |
504413 | 504413 | 2020-09-05 | Ceiba | Puerto Rico | 72037 | 91 | |
501179 | 501179 | 2020-09-04 | Ceiba | Puerto Rico | 72037 | 90 | |
497945 | 497945 | 2020-09-03 | Ceiba | Puerto Rico | 72037 | 90 | |
494712 | 494712 | 2020-09-02 | Ceiba | Puerto Rico | 72037 | 88 | |
491478 | 491478 | 2020-09-01 | Ceiba | Puerto Rico | 72037 | 88 | |
488245 | 488245 | 2020-08-31 | Ceiba | Puerto Rico | 72037 | 88 | |
485012 | 485012 | 2020-08-30 | Ceiba | Puerto Rico | 72037 | 87 | |
481777 | 481777 | 2020-08-29 | Ceiba | Puerto Rico | 72037 | 87 | |
478543 | 478543 | 2020-08-28 | Ceiba | Puerto Rico | 72037 | 84 | |
475310 | 475310 | 2020-08-27 | Ceiba | Puerto Rico | 72037 | 82 | |
472076 | 472076 | 2020-08-26 | Ceiba | Puerto Rico | 72037 | 82 | |
468844 | 468844 | 2020-08-25 | Ceiba | Puerto Rico | 72037 | 82 | |
465616 | 465616 | 2020-08-24 | Ceiba | Puerto Rico | 72037 | 81 | |
462387 | 462387 | 2020-08-23 | Ceiba | Puerto Rico | 72037 | 80 | |
459159 | 459159 | 2020-08-22 | Ceiba | Puerto Rico | 72037 | 80 | |
455931 | 455931 | 2020-08-21 | Ceiba | Puerto Rico | 72037 | 80 | |
452703 | 452703 | 2020-08-20 | Ceiba | Puerto Rico | 72037 | 78 | |
449475 | 449475 | 2020-08-19 | Ceiba | Puerto Rico | 72037 | 77 | |
446247 | 446247 | 2020-08-18 | Ceiba | Puerto Rico | 72037 | 77 | |
443021 | 443021 | 2020-08-17 | Ceiba | Puerto Rico | 72037 | 76 | |
439794 | 439794 | 2020-08-16 | Ceiba | Puerto Rico | 72037 | 75 | |
436569 | 436569 | 2020-08-15 | Ceiba | Puerto Rico | 72037 | 75 | |
433342 | 433342 | 2020-08-14 | Ceiba | Puerto Rico | 72037 | 74 | |
430116 | 430116 | 2020-08-13 | Ceiba | Puerto Rico | 72037 | 73 | |
426891 | 426891 | 2020-08-12 | Ceiba | Puerto Rico | 72037 | 72 | |
423668 | 423668 | 2020-08-11 | Ceiba | Puerto Rico | 72037 | 72 | |
420445 | 420445 | 2020-08-10 | Ceiba | Puerto Rico | 72037 | 70 | |
417225 | 417225 | 2020-08-09 | Ceiba | Puerto Rico | 72037 | 68 | |
414004 | 414004 | 2020-08-08 | Ceiba | Puerto Rico | 72037 | 67 | |
410784 | 410784 | 2020-08-07 | Ceiba | Puerto Rico | 72037 | 66 | |
407564 | 407564 | 2020-08-06 | Ceiba | Puerto Rico | 72037 | 64 | |
404345 | 404345 | 2020-08-05 | Ceiba | Puerto Rico | 72037 | 63 | |
401127 | 401127 | 2020-08-04 | Ceiba | Puerto Rico | 72037 | 63 | |
397912 | 397912 | 2020-08-03 | Ceiba | Puerto Rico | 72037 | 63 | |
394695 | 394695 | 2020-08-02 | Ceiba | Puerto Rico | 72037 | 58 | |
391479 | 391479 | 2020-08-01 | Ceiba | Puerto Rico | 72037 | 57 | |
388262 | 388262 | 2020-07-31 | Ceiba | Puerto Rico | 72037 | 55 | |
385045 | 385045 | 2020-07-30 | Ceiba | Puerto Rico | 72037 | 53 | |
381827 | 381827 | 2020-07-29 | Ceiba | Puerto Rico | 72037 | 51 | |
378610 | 378610 | 2020-07-28 | Ceiba | Puerto Rico | 72037 | 50 | |
375394 | 375394 | 2020-07-27 | Ceiba | Puerto Rico | 72037 | 50 | |
372181 | 372181 | 2020-07-26 | Ceiba | Puerto Rico | 72037 | 49 | |
368969 | 368969 | 2020-07-25 | Ceiba | Puerto Rico | 72037 | 48 | |
365760 | 365760 | 2020-07-24 | Ceiba | Puerto Rico | 72037 | 46 | |
362554 | 362554 | 2020-07-23 | Ceiba | Puerto Rico | 72037 | 45 | |
359348 | 359348 | 2020-07-22 | Ceiba | Puerto Rico | 72037 | 43 | |
356144 | 356144 | 2020-07-21 | Ceiba | Puerto Rico | 72037 | 41 | |
352941 | 352941 | 2020-07-20 | Ceiba | Puerto Rico | 72037 | 40 | |
349738 | 349738 | 2020-07-19 | Ceiba | Puerto Rico | 72037 | 40 | |
346538 | 346538 | 2020-07-18 | Ceiba | Puerto Rico | 72037 | 40 | |
343338 | 343338 | 2020-07-17 | Ceiba | Puerto Rico | 72037 | 39 | |
340140 | 340140 | 2020-07-16 | Ceiba | Puerto Rico | 72037 | 38 | |
336943 | 336943 | 2020-07-15 | Ceiba | Puerto Rico | 72037 | 37 | |
333749 | 333749 | 2020-07-14 | Ceiba | Puerto Rico | 72037 | 37 | |
330557 | 330557 | 2020-07-13 | Ceiba | Puerto Rico | 72037 | 35 | |
327371 | 327371 | 2020-07-12 | Ceiba | Puerto Rico | 72037 | 35 | |
324186 | 324186 | 2020-07-11 | Ceiba | Puerto Rico | 72037 | 34 | |
321006 | 321006 | 2020-07-10 | Ceiba | Puerto Rico | 72037 | 34 | |
317828 | 317828 | 2020-07-09 | Ceiba | Puerto Rico | 72037 | 29 |
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);