ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72017 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 |
---|---|---|---|---|---|---|---|
637221 | 637221 | 2020-10-16 | Barceloneta | Puerto Rico | 72017 | 297 | |
633975 | 633975 | 2020-10-15 | Barceloneta | Puerto Rico | 72017 | 292 | |
630730 | 630730 | 2020-10-14 | Barceloneta | Puerto Rico | 72017 | 288 | |
627486 | 627486 | 2020-10-13 | Barceloneta | Puerto Rico | 72017 | 282 | |
624244 | 624244 | 2020-10-12 | Barceloneta | Puerto Rico | 72017 | 280 | |
621001 | 621001 | 2020-10-11 | Barceloneta | Puerto Rico | 72017 | 280 | |
617758 | 617758 | 2020-10-10 | Barceloneta | Puerto Rico | 72017 | 279 | |
614516 | 614516 | 2020-10-09 | Barceloneta | Puerto Rico | 72017 | 279 | |
611275 | 611275 | 2020-10-08 | Barceloneta | Puerto Rico | 72017 | 277 | |
608033 | 608033 | 2020-10-07 | Barceloneta | Puerto Rico | 72017 | 275 | |
604790 | 604790 | 2020-10-06 | Barceloneta | Puerto Rico | 72017 | 275 | |
601548 | 601548 | 2020-10-05 | Barceloneta | Puerto Rico | 72017 | 270 | |
598305 | 598305 | 2020-10-04 | Barceloneta | Puerto Rico | 72017 | 265 | |
595062 | 595062 | 2020-10-03 | Barceloneta | Puerto Rico | 72017 | 264 | |
591821 | 591821 | 2020-10-02 | Barceloneta | Puerto Rico | 72017 | 259 | |
588580 | 588580 | 2020-10-01 | Barceloneta | Puerto Rico | 72017 | 250 | |
585340 | 585340 | 2020-09-30 | Barceloneta | Puerto Rico | 72017 | 250 | |
582100 | 582100 | 2020-09-29 | Barceloneta | Puerto Rico | 72017 | 250 | |
578860 | 578860 | 2020-09-28 | Barceloneta | Puerto Rico | 72017 | 245 | |
575619 | 575619 | 2020-09-27 | Barceloneta | Puerto Rico | 72017 | 239 | |
572375 | 572375 | 2020-09-26 | Barceloneta | Puerto Rico | 72017 | 230 | |
569133 | 569133 | 2020-09-25 | Barceloneta | Puerto Rico | 72017 | 228 | |
565892 | 565892 | 2020-09-24 | Barceloneta | Puerto Rico | 72017 | 223 | |
562651 | 562651 | 2020-09-23 | Barceloneta | Puerto Rico | 72017 | 218 | |
559414 | 559414 | 2020-09-22 | Barceloneta | Puerto Rico | 72017 | 216 | |
556177 | 556177 | 2020-09-21 | Barceloneta | Puerto Rico | 72017 | 215 | |
552940 | 552940 | 2020-09-20 | Barceloneta | Puerto Rico | 72017 | 212 | |
549701 | 549701 | 2020-09-19 | Barceloneta | Puerto Rico | 72017 | 203 | |
546462 | 546462 | 2020-09-18 | Barceloneta | Puerto Rico | 72017 | 187 | |
543225 | 543225 | 2020-09-17 | Barceloneta | Puerto Rico | 72017 | 160 | |
539989 | 539989 | 2020-09-16 | Barceloneta | Puerto Rico | 72017 | 154 | |
536752 | 536752 | 2020-09-15 | Barceloneta | Puerto Rico | 72017 | 154 | |
533516 | 533516 | 2020-09-14 | Barceloneta | Puerto Rico | 72017 | 153 | |
530281 | 530281 | 2020-09-13 | Barceloneta | Puerto Rico | 72017 | 151 | |
527044 | 527044 | 2020-09-12 | Barceloneta | Puerto Rico | 72017 | 148 | |
523808 | 523808 | 2020-09-11 | Barceloneta | Puerto Rico | 72017 | 147 | |
520572 | 520572 | 2020-09-10 | Barceloneta | Puerto Rico | 72017 | 142 | |
517336 | 517336 | 2020-09-09 | Barceloneta | Puerto Rico | 72017 | 138 | |
514101 | 514101 | 2020-09-08 | Barceloneta | Puerto Rico | 72017 | 138 | |
510868 | 510868 | 2020-09-07 | Barceloneta | Puerto Rico | 72017 | 137 | |
507635 | 507635 | 2020-09-06 | Barceloneta | Puerto Rico | 72017 | 130 | |
504403 | 504403 | 2020-09-05 | Barceloneta | Puerto Rico | 72017 | 130 | |
501169 | 501169 | 2020-09-04 | Barceloneta | Puerto Rico | 72017 | 129 | |
497935 | 497935 | 2020-09-03 | Barceloneta | Puerto Rico | 72017 | 129 | |
494702 | 494702 | 2020-09-02 | Barceloneta | Puerto Rico | 72017 | 128 | |
491468 | 491468 | 2020-09-01 | Barceloneta | Puerto Rico | 72017 | 124 | |
488235 | 488235 | 2020-08-31 | Barceloneta | Puerto Rico | 72017 | 124 | |
485002 | 485002 | 2020-08-30 | Barceloneta | Puerto Rico | 72017 | 122 | |
481767 | 481767 | 2020-08-29 | Barceloneta | Puerto Rico | 72017 | 122 | |
478533 | 478533 | 2020-08-28 | Barceloneta | Puerto Rico | 72017 | 122 | |
475300 | 475300 | 2020-08-27 | Barceloneta | Puerto Rico | 72017 | 119 | |
472066 | 472066 | 2020-08-26 | Barceloneta | Puerto Rico | 72017 | 117 | |
468834 | 468834 | 2020-08-25 | Barceloneta | Puerto Rico | 72017 | 117 | |
465606 | 465606 | 2020-08-24 | Barceloneta | Puerto Rico | 72017 | 116 | |
462377 | 462377 | 2020-08-23 | Barceloneta | Puerto Rico | 72017 | 116 | |
459149 | 459149 | 2020-08-22 | Barceloneta | Puerto Rico | 72017 | 116 | |
455921 | 455921 | 2020-08-21 | Barceloneta | Puerto Rico | 72017 | 115 | |
452693 | 452693 | 2020-08-20 | Barceloneta | Puerto Rico | 72017 | 112 | |
449465 | 449465 | 2020-08-19 | Barceloneta | Puerto Rico | 72017 | 112 | |
446237 | 446237 | 2020-08-18 | Barceloneta | Puerto Rico | 72017 | 112 | |
443011 | 443011 | 2020-08-17 | Barceloneta | Puerto Rico | 72017 | 110 | |
439784 | 439784 | 2020-08-16 | Barceloneta | Puerto Rico | 72017 | 104 | |
436559 | 436559 | 2020-08-15 | Barceloneta | Puerto Rico | 72017 | 104 | |
433332 | 433332 | 2020-08-14 | Barceloneta | Puerto Rico | 72017 | 102 | |
430106 | 430106 | 2020-08-13 | Barceloneta | Puerto Rico | 72017 | 98 | |
426881 | 426881 | 2020-08-12 | Barceloneta | Puerto Rico | 72017 | 96 | |
423658 | 423658 | 2020-08-11 | Barceloneta | Puerto Rico | 72017 | 95 | |
420435 | 420435 | 2020-08-10 | Barceloneta | Puerto Rico | 72017 | 95 | |
417215 | 417215 | 2020-08-09 | Barceloneta | Puerto Rico | 72017 | 91 | |
413994 | 413994 | 2020-08-08 | Barceloneta | Puerto Rico | 72017 | 88 | |
410774 | 410774 | 2020-08-07 | Barceloneta | Puerto Rico | 72017 | 81 | |
407554 | 407554 | 2020-08-06 | Barceloneta | Puerto Rico | 72017 | 78 | |
404335 | 404335 | 2020-08-05 | Barceloneta | Puerto Rico | 72017 | 78 | |
401117 | 401117 | 2020-08-04 | Barceloneta | Puerto Rico | 72017 | 73 | |
397902 | 397902 | 2020-08-03 | Barceloneta | Puerto Rico | 72017 | 73 | |
394685 | 394685 | 2020-08-02 | Barceloneta | Puerto Rico | 72017 | 72 | |
391469 | 391469 | 2020-08-01 | Barceloneta | Puerto Rico | 72017 | 69 | |
388252 | 388252 | 2020-07-31 | Barceloneta | Puerto Rico | 72017 | 67 | |
385035 | 385035 | 2020-07-30 | Barceloneta | Puerto Rico | 72017 | 65 | |
381817 | 381817 | 2020-07-29 | Barceloneta | Puerto Rico | 72017 | 63 | |
378600 | 378600 | 2020-07-28 | Barceloneta | Puerto Rico | 72017 | 62 | |
375384 | 375384 | 2020-07-27 | Barceloneta | Puerto Rico | 72017 | 57 | |
372171 | 372171 | 2020-07-26 | Barceloneta | Puerto Rico | 72017 | 56 | |
368959 | 368959 | 2020-07-25 | Barceloneta | Puerto Rico | 72017 | 51 | |
365750 | 365750 | 2020-07-24 | Barceloneta | Puerto Rico | 72017 | 46 | |
362544 | 362544 | 2020-07-23 | Barceloneta | Puerto Rico | 72017 | 43 | |
359338 | 359338 | 2020-07-22 | Barceloneta | Puerto Rico | 72017 | 40 | |
356134 | 356134 | 2020-07-21 | Barceloneta | Puerto Rico | 72017 | 40 | |
352931 | 352931 | 2020-07-20 | Barceloneta | Puerto Rico | 72017 | 38 | |
349728 | 349728 | 2020-07-19 | Barceloneta | Puerto Rico | 72017 | 36 | |
346528 | 346528 | 2020-07-18 | Barceloneta | Puerto Rico | 72017 | 34 | |
343328 | 343328 | 2020-07-17 | Barceloneta | Puerto Rico | 72017 | 32 | |
340130 | 340130 | 2020-07-16 | Barceloneta | Puerto Rico | 72017 | 32 | |
336933 | 336933 | 2020-07-15 | Barceloneta | Puerto Rico | 72017 | 32 | |
333739 | 333739 | 2020-07-14 | Barceloneta | Puerto Rico | 72017 | 31 | |
330547 | 330547 | 2020-07-13 | Barceloneta | Puerto Rico | 72017 | 31 | |
327361 | 327361 | 2020-07-12 | Barceloneta | Puerto Rico | 72017 | 31 | |
324176 | 324176 | 2020-07-11 | Barceloneta | Puerto Rico | 72017 | 30 | |
320996 | 320996 | 2020-07-10 | Barceloneta | Puerto Rico | 72017 | 30 | |
317818 | 317818 | 2020-07-09 | Barceloneta | Puerto Rico | 72017 | 28 |
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);