ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72005 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 |
---|---|---|---|---|---|---|---|
637215 | 637215 | 2020-10-16 | Aguadilla | Puerto Rico | 72005 | 506 | |
633969 | 633969 | 2020-10-15 | Aguadilla | Puerto Rico | 72005 | 496 | |
630724 | 630724 | 2020-10-14 | Aguadilla | Puerto Rico | 72005 | 487 | |
627480 | 627480 | 2020-10-13 | Aguadilla | Puerto Rico | 72005 | 483 | |
624238 | 624238 | 2020-10-12 | Aguadilla | Puerto Rico | 72005 | 470 | |
620995 | 620995 | 2020-10-11 | Aguadilla | Puerto Rico | 72005 | 467 | |
617752 | 617752 | 2020-10-10 | Aguadilla | Puerto Rico | 72005 | 464 | |
614510 | 614510 | 2020-10-09 | Aguadilla | Puerto Rico | 72005 | 458 | |
611269 | 611269 | 2020-10-08 | Aguadilla | Puerto Rico | 72005 | 451 | |
608027 | 608027 | 2020-10-07 | Aguadilla | Puerto Rico | 72005 | 450 | |
604784 | 604784 | 2020-10-06 | Aguadilla | Puerto Rico | 72005 | 450 | |
601542 | 601542 | 2020-10-05 | Aguadilla | Puerto Rico | 72005 | 449 | |
598299 | 598299 | 2020-10-04 | Aguadilla | Puerto Rico | 72005 | 449 | |
595056 | 595056 | 2020-10-03 | Aguadilla | Puerto Rico | 72005 | 448 | |
591815 | 591815 | 2020-10-02 | Aguadilla | Puerto Rico | 72005 | 444 | |
588574 | 588574 | 2020-10-01 | Aguadilla | Puerto Rico | 72005 | 441 | |
585334 | 585334 | 2020-09-30 | Aguadilla | Puerto Rico | 72005 | 439 | |
582094 | 582094 | 2020-09-29 | Aguadilla | Puerto Rico | 72005 | 438 | |
578854 | 578854 | 2020-09-28 | Aguadilla | Puerto Rico | 72005 | 435 | |
575613 | 575613 | 2020-09-27 | Aguadilla | Puerto Rico | 72005 | 435 | |
572369 | 572369 | 2020-09-26 | Aguadilla | Puerto Rico | 72005 | 427 | |
569127 | 569127 | 2020-09-25 | Aguadilla | Puerto Rico | 72005 | 424 | |
565886 | 565886 | 2020-09-24 | Aguadilla | Puerto Rico | 72005 | 421 | |
562645 | 562645 | 2020-09-23 | Aguadilla | Puerto Rico | 72005 | 412 | |
559408 | 559408 | 2020-09-22 | Aguadilla | Puerto Rico | 72005 | 412 | |
556171 | 556171 | 2020-09-21 | Aguadilla | Puerto Rico | 72005 | 412 | |
552934 | 552934 | 2020-09-20 | Aguadilla | Puerto Rico | 72005 | 407 | |
549695 | 549695 | 2020-09-19 | Aguadilla | Puerto Rico | 72005 | 406 | |
546456 | 546456 | 2020-09-18 | Aguadilla | Puerto Rico | 72005 | 386 | |
543219 | 543219 | 2020-09-17 | Aguadilla | Puerto Rico | 72005 | 383 | |
539983 | 539983 | 2020-09-16 | Aguadilla | Puerto Rico | 72005 | 375 | |
536746 | 536746 | 2020-09-15 | Aguadilla | Puerto Rico | 72005 | 374 | |
533510 | 533510 | 2020-09-14 | Aguadilla | Puerto Rico | 72005 | 370 | |
530275 | 530275 | 2020-09-13 | Aguadilla | Puerto Rico | 72005 | 367 | |
527038 | 527038 | 2020-09-12 | Aguadilla | Puerto Rico | 72005 | 364 | |
523802 | 523802 | 2020-09-11 | Aguadilla | Puerto Rico | 72005 | 358 | |
520566 | 520566 | 2020-09-10 | Aguadilla | Puerto Rico | 72005 | 353 | |
517330 | 517330 | 2020-09-09 | Aguadilla | Puerto Rico | 72005 | 346 | |
514095 | 514095 | 2020-09-08 | Aguadilla | Puerto Rico | 72005 | 346 | |
510862 | 510862 | 2020-09-07 | Aguadilla | Puerto Rico | 72005 | 343 | |
507629 | 507629 | 2020-09-06 | Aguadilla | Puerto Rico | 72005 | 336 | |
504397 | 504397 | 2020-09-05 | Aguadilla | Puerto Rico | 72005 | 335 | |
501163 | 501163 | 2020-09-04 | Aguadilla | Puerto Rico | 72005 | 329 | |
497929 | 497929 | 2020-09-03 | Aguadilla | Puerto Rico | 72005 | 329 | |
494696 | 494696 | 2020-09-02 | Aguadilla | Puerto Rico | 72005 | 328 | |
491462 | 491462 | 2020-09-01 | Aguadilla | Puerto Rico | 72005 | 327 | |
488229 | 488229 | 2020-08-31 | Aguadilla | Puerto Rico | 72005 | 326 | |
484996 | 484996 | 2020-08-30 | Aguadilla | Puerto Rico | 72005 | 322 | |
481761 | 481761 | 2020-08-29 | Aguadilla | Puerto Rico | 72005 | 309 | |
478527 | 478527 | 2020-08-28 | Aguadilla | Puerto Rico | 72005 | 304 | |
475294 | 475294 | 2020-08-27 | Aguadilla | Puerto Rico | 72005 | 298 | |
472060 | 472060 | 2020-08-26 | Aguadilla | Puerto Rico | 72005 | 293 | |
468828 | 468828 | 2020-08-25 | Aguadilla | Puerto Rico | 72005 | 293 | |
465600 | 465600 | 2020-08-24 | Aguadilla | Puerto Rico | 72005 | 288 | |
462371 | 462371 | 2020-08-23 | Aguadilla | Puerto Rico | 72005 | 282 | |
459143 | 459143 | 2020-08-22 | Aguadilla | Puerto Rico | 72005 | 281 | |
455915 | 455915 | 2020-08-21 | Aguadilla | Puerto Rico | 72005 | 272 | |
452687 | 452687 | 2020-08-20 | Aguadilla | Puerto Rico | 72005 | 263 | |
449459 | 449459 | 2020-08-19 | Aguadilla | Puerto Rico | 72005 | 260 | |
446231 | 446231 | 2020-08-18 | Aguadilla | Puerto Rico | 72005 | 259 | |
443005 | 443005 | 2020-08-17 | Aguadilla | Puerto Rico | 72005 | 256 | |
439778 | 439778 | 2020-08-16 | Aguadilla | Puerto Rico | 72005 | 250 | |
436553 | 436553 | 2020-08-15 | Aguadilla | Puerto Rico | 72005 | 247 | |
433326 | 433326 | 2020-08-14 | Aguadilla | Puerto Rico | 72005 | 239 | |
430100 | 430100 | 2020-08-13 | Aguadilla | Puerto Rico | 72005 | 234 | |
426875 | 426875 | 2020-08-12 | Aguadilla | Puerto Rico | 72005 | 233 | |
423652 | 423652 | 2020-08-11 | Aguadilla | Puerto Rico | 72005 | 232 | |
420429 | 420429 | 2020-08-10 | Aguadilla | Puerto Rico | 72005 | 230 | |
417209 | 417209 | 2020-08-09 | Aguadilla | Puerto Rico | 72005 | 223 | |
413988 | 413988 | 2020-08-08 | Aguadilla | Puerto Rico | 72005 | 221 | |
410768 | 410768 | 2020-08-07 | Aguadilla | Puerto Rico | 72005 | 209 | |
407548 | 407548 | 2020-08-06 | Aguadilla | Puerto Rico | 72005 | 200 | |
404329 | 404329 | 2020-08-05 | Aguadilla | Puerto Rico | 72005 | 195 | |
401111 | 401111 | 2020-08-04 | Aguadilla | Puerto Rico | 72005 | 193 | |
397896 | 397896 | 2020-08-03 | Aguadilla | Puerto Rico | 72005 | 192 | |
394679 | 394679 | 2020-08-02 | Aguadilla | Puerto Rico | 72005 | 185 | |
391463 | 391463 | 2020-08-01 | Aguadilla | Puerto Rico | 72005 | 180 | |
388246 | 388246 | 2020-07-31 | Aguadilla | Puerto Rico | 72005 | 168 | |
385029 | 385029 | 2020-07-30 | Aguadilla | Puerto Rico | 72005 | 166 | |
381811 | 381811 | 2020-07-29 | Aguadilla | Puerto Rico | 72005 | 160 | |
378594 | 378594 | 2020-07-28 | Aguadilla | Puerto Rico | 72005 | 160 | |
375378 | 375378 | 2020-07-27 | Aguadilla | Puerto Rico | 72005 | 156 | |
372165 | 372165 | 2020-07-26 | Aguadilla | Puerto Rico | 72005 | 152 | |
368953 | 368953 | 2020-07-25 | Aguadilla | Puerto Rico | 72005 | 142 | |
365744 | 365744 | 2020-07-24 | Aguadilla | Puerto Rico | 72005 | 135 | |
362538 | 362538 | 2020-07-23 | Aguadilla | Puerto Rico | 72005 | 130 | |
359332 | 359332 | 2020-07-22 | Aguadilla | Puerto Rico | 72005 | 121 | |
356128 | 356128 | 2020-07-21 | Aguadilla | Puerto Rico | 72005 | 120 | |
352925 | 352925 | 2020-07-20 | Aguadilla | Puerto Rico | 72005 | 112 | |
349722 | 349722 | 2020-07-19 | Aguadilla | Puerto Rico | 72005 | 110 | |
346522 | 346522 | 2020-07-18 | Aguadilla | Puerto Rico | 72005 | 102 | |
343322 | 343322 | 2020-07-17 | Aguadilla | Puerto Rico | 72005 | 97 | |
340124 | 340124 | 2020-07-16 | Aguadilla | Puerto Rico | 72005 | 89 | |
336927 | 336927 | 2020-07-15 | Aguadilla | Puerto Rico | 72005 | 85 | |
333733 | 333733 | 2020-07-14 | Aguadilla | Puerto Rico | 72005 | 84 | |
330541 | 330541 | 2020-07-13 | Aguadilla | Puerto Rico | 72005 | 84 | |
327355 | 327355 | 2020-07-12 | Aguadilla | Puerto Rico | 72005 | 82 | |
324170 | 324170 | 2020-07-11 | Aguadilla | Puerto Rico | 72005 | 79 | |
320990 | 320990 | 2020-07-10 | Aguadilla | Puerto Rico | 72005 | 78 | |
317812 | 317812 | 2020-07-09 | Aguadilla | Puerto Rico | 72005 | 72 |
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);