ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guayama" 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 |
---|---|---|---|---|---|---|---|
637242 | 637242 | 2020-10-16 | Guayama | Puerto Rico | 72057 | 349 | |
633996 | 633996 | 2020-10-15 | Guayama | Puerto Rico | 72057 | 346 | |
630751 | 630751 | 2020-10-14 | Guayama | Puerto Rico | 72057 | 343 | |
627507 | 627507 | 2020-10-13 | Guayama | Puerto Rico | 72057 | 342 | |
624265 | 624265 | 2020-10-12 | Guayama | Puerto Rico | 72057 | 340 | |
621022 | 621022 | 2020-10-11 | Guayama | Puerto Rico | 72057 | 340 | |
617779 | 617779 | 2020-10-10 | Guayama | Puerto Rico | 72057 | 340 | |
614537 | 614537 | 2020-10-09 | Guayama | Puerto Rico | 72057 | 332 | |
611296 | 611296 | 2020-10-08 | Guayama | Puerto Rico | 72057 | 331 | |
608054 | 608054 | 2020-10-07 | Guayama | Puerto Rico | 72057 | 322 | |
604811 | 604811 | 2020-10-06 | Guayama | Puerto Rico | 72057 | 322 | |
601569 | 601569 | 2020-10-05 | Guayama | Puerto Rico | 72057 | 318 | |
598326 | 598326 | 2020-10-04 | Guayama | Puerto Rico | 72057 | 316 | |
595083 | 595083 | 2020-10-03 | Guayama | Puerto Rico | 72057 | 315 | |
591842 | 591842 | 2020-10-02 | Guayama | Puerto Rico | 72057 | 314 | |
588601 | 588601 | 2020-10-01 | Guayama | Puerto Rico | 72057 | 306 | |
585361 | 585361 | 2020-09-30 | Guayama | Puerto Rico | 72057 | 302 | |
582121 | 582121 | 2020-09-29 | Guayama | Puerto Rico | 72057 | 301 | |
578881 | 578881 | 2020-09-28 | Guayama | Puerto Rico | 72057 | 287 | |
575640 | 575640 | 2020-09-27 | Guayama | Puerto Rico | 72057 | 287 | |
572396 | 572396 | 2020-09-26 | Guayama | Puerto Rico | 72057 | 285 | |
569154 | 569154 | 2020-09-25 | Guayama | Puerto Rico | 72057 | 284 | |
565913 | 565913 | 2020-09-24 | Guayama | Puerto Rico | 72057 | 282 | |
562672 | 562672 | 2020-09-23 | Guayama | Puerto Rico | 72057 | 279 | |
559435 | 559435 | 2020-09-22 | Guayama | Puerto Rico | 72057 | 279 | |
556198 | 556198 | 2020-09-21 | Guayama | Puerto Rico | 72057 | 279 | |
552961 | 552961 | 2020-09-20 | Guayama | Puerto Rico | 72057 | 279 | |
549722 | 549722 | 2020-09-19 | Guayama | Puerto Rico | 72057 | 276 | |
546483 | 546483 | 2020-09-18 | Guayama | Puerto Rico | 72057 | 270 | |
543246 | 543246 | 2020-09-17 | Guayama | Puerto Rico | 72057 | 267 | |
540010 | 540010 | 2020-09-16 | Guayama | Puerto Rico | 72057 | 263 | |
536773 | 536773 | 2020-09-15 | Guayama | Puerto Rico | 72057 | 261 | |
533537 | 533537 | 2020-09-14 | Guayama | Puerto Rico | 72057 | 260 | |
530302 | 530302 | 2020-09-13 | Guayama | Puerto Rico | 72057 | 259 | |
527065 | 527065 | 2020-09-12 | Guayama | Puerto Rico | 72057 | 260 | |
523829 | 523829 | 2020-09-11 | Guayama | Puerto Rico | 72057 | 249 | |
520593 | 520593 | 2020-09-10 | Guayama | Puerto Rico | 72057 | 246 | |
517357 | 517357 | 2020-09-09 | Guayama | Puerto Rico | 72057 | 244 | |
514122 | 514122 | 2020-09-08 | Guayama | Puerto Rico | 72057 | 244 | |
510889 | 510889 | 2020-09-07 | Guayama | Puerto Rico | 72057 | 240 | |
507656 | 507656 | 2020-09-06 | Guayama | Puerto Rico | 72057 | 236 | |
504424 | 504424 | 2020-09-05 | Guayama | Puerto Rico | 72057 | 236 | |
501190 | 501190 | 2020-09-04 | Guayama | Puerto Rico | 72057 | 236 | |
497956 | 497956 | 2020-09-03 | Guayama | Puerto Rico | 72057 | 236 | |
494723 | 494723 | 2020-09-02 | Guayama | Puerto Rico | 72057 | 233 | |
491489 | 491489 | 2020-09-01 | Guayama | Puerto Rico | 72057 | 232 | |
488256 | 488256 | 2020-08-31 | Guayama | Puerto Rico | 72057 | 231 | |
485023 | 485023 | 2020-08-30 | Guayama | Puerto Rico | 72057 | 230 | |
481788 | 481788 | 2020-08-29 | Guayama | Puerto Rico | 72057 | 229 | |
478554 | 478554 | 2020-08-28 | Guayama | Puerto Rico | 72057 | 218 | |
475321 | 475321 | 2020-08-27 | Guayama | Puerto Rico | 72057 | 214 | |
472087 | 472087 | 2020-08-26 | Guayama | Puerto Rico | 72057 | 212 | |
468855 | 468855 | 2020-08-25 | Guayama | Puerto Rico | 72057 | 212 | |
465627 | 465627 | 2020-08-24 | Guayama | Puerto Rico | 72057 | 212 | |
462398 | 462398 | 2020-08-23 | Guayama | Puerto Rico | 72057 | 209 | |
459170 | 459170 | 2020-08-22 | Guayama | Puerto Rico | 72057 | 208 | |
455942 | 455942 | 2020-08-21 | Guayama | Puerto Rico | 72057 | 203 | |
452714 | 452714 | 2020-08-20 | Guayama | Puerto Rico | 72057 | 196 | |
449486 | 449486 | 2020-08-19 | Guayama | Puerto Rico | 72057 | 196 | |
446258 | 446258 | 2020-08-18 | Guayama | Puerto Rico | 72057 | 194 | |
443032 | 443032 | 2020-08-17 | Guayama | Puerto Rico | 72057 | 191 | |
439805 | 439805 | 2020-08-16 | Guayama | Puerto Rico | 72057 | 189 | |
436580 | 436580 | 2020-08-15 | Guayama | Puerto Rico | 72057 | 185 | |
433353 | 433353 | 2020-08-14 | Guayama | Puerto Rico | 72057 | 179 | |
430127 | 430127 | 2020-08-13 | Guayama | Puerto Rico | 72057 | 170 | |
426902 | 426902 | 2020-08-12 | Guayama | Puerto Rico | 72057 | 168 | |
423679 | 423679 | 2020-08-11 | Guayama | Puerto Rico | 72057 | 164 | |
420456 | 420456 | 2020-08-10 | Guayama | Puerto Rico | 72057 | 162 | |
417236 | 417236 | 2020-08-09 | Guayama | Puerto Rico | 72057 | 158 | |
414015 | 414015 | 2020-08-08 | Guayama | Puerto Rico | 72057 | 154 | |
410795 | 410795 | 2020-08-07 | Guayama | Puerto Rico | 72057 | 149 | |
407575 | 407575 | 2020-08-06 | Guayama | Puerto Rico | 72057 | 143 | |
404356 | 404356 | 2020-08-05 | Guayama | Puerto Rico | 72057 | 141 | |
401138 | 401138 | 2020-08-04 | Guayama | Puerto Rico | 72057 | 140 | |
397923 | 397923 | 2020-08-03 | Guayama | Puerto Rico | 72057 | 140 | |
394706 | 394706 | 2020-08-02 | Guayama | Puerto Rico | 72057 | 133 | |
391490 | 391490 | 2020-08-01 | Guayama | Puerto Rico | 72057 | 132 | |
388273 | 388273 | 2020-07-31 | Guayama | Puerto Rico | 72057 | 128 | |
385056 | 385056 | 2020-07-30 | Guayama | Puerto Rico | 72057 | 127 | |
381838 | 381838 | 2020-07-29 | Guayama | Puerto Rico | 72057 | 122 | |
378621 | 378621 | 2020-07-28 | Guayama | Puerto Rico | 72057 | 119 | |
375405 | 375405 | 2020-07-27 | Guayama | Puerto Rico | 72057 | 118 | |
372192 | 372192 | 2020-07-26 | Guayama | Puerto Rico | 72057 | 118 | |
368980 | 368980 | 2020-07-25 | Guayama | Puerto Rico | 72057 | 114 | |
365771 | 365771 | 2020-07-24 | Guayama | Puerto Rico | 72057 | 110 | |
362565 | 362565 | 2020-07-23 | Guayama | Puerto Rico | 72057 | 105 | |
359359 | 359359 | 2020-07-22 | Guayama | Puerto Rico | 72057 | 104 | |
356155 | 356155 | 2020-07-21 | Guayama | Puerto Rico | 72057 | 103 | |
352952 | 352952 | 2020-07-20 | Guayama | Puerto Rico | 72057 | 101 | |
349749 | 349749 | 2020-07-19 | Guayama | Puerto Rico | 72057 | 98 | |
346549 | 346549 | 2020-07-18 | Guayama | Puerto Rico | 72057 | 95 | |
343349 | 343349 | 2020-07-17 | Guayama | Puerto Rico | 72057 | 92 | |
340151 | 340151 | 2020-07-16 | Guayama | Puerto Rico | 72057 | 85 | |
336954 | 336954 | 2020-07-15 | Guayama | Puerto Rico | 72057 | 84 | |
333760 | 333760 | 2020-07-14 | Guayama | Puerto Rico | 72057 | 84 | |
330568 | 330568 | 2020-07-13 | Guayama | Puerto Rico | 72057 | 84 | |
327382 | 327382 | 2020-07-12 | Guayama | Puerto Rico | 72057 | 84 | |
324197 | 324197 | 2020-07-11 | Guayama | Puerto Rico | 72057 | 83 | |
321017 | 321017 | 2020-07-10 | Guayama | Puerto Rico | 72057 | 80 | |
317839 | 317839 | 2020-07-09 | Guayama | Puerto Rico | 72057 | 76 |
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);