ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cabo Rojo" 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 |
---|---|---|---|---|---|---|---|
637224 | 637224 | 2020-10-16 | Cabo Rojo | Puerto Rico | 72023 | 462 | |
633978 | 633978 | 2020-10-15 | Cabo Rojo | Puerto Rico | 72023 | 461 | |
630733 | 630733 | 2020-10-14 | Cabo Rojo | Puerto Rico | 72023 | 456 | |
627489 | 627489 | 2020-10-13 | Cabo Rojo | Puerto Rico | 72023 | 446 | |
624247 | 624247 | 2020-10-12 | Cabo Rojo | Puerto Rico | 72023 | 422 | |
621004 | 621004 | 2020-10-11 | Cabo Rojo | Puerto Rico | 72023 | 390 | |
617761 | 617761 | 2020-10-10 | Cabo Rojo | Puerto Rico | 72023 | 389 | |
614519 | 614519 | 2020-10-09 | Cabo Rojo | Puerto Rico | 72023 | 372 | |
611278 | 611278 | 2020-10-08 | Cabo Rojo | Puerto Rico | 72023 | 368 | |
608036 | 608036 | 2020-10-07 | Cabo Rojo | Puerto Rico | 72023 | 362 | |
604793 | 604793 | 2020-10-06 | Cabo Rojo | Puerto Rico | 72023 | 362 | |
601551 | 601551 | 2020-10-05 | Cabo Rojo | Puerto Rico | 72023 | 360 | |
598308 | 598308 | 2020-10-04 | Cabo Rojo | Puerto Rico | 72023 | 359 | |
595065 | 595065 | 2020-10-03 | Cabo Rojo | Puerto Rico | 72023 | 358 | |
591824 | 591824 | 2020-10-02 | Cabo Rojo | Puerto Rico | 72023 | 357 | |
588583 | 588583 | 2020-10-01 | Cabo Rojo | Puerto Rico | 72023 | 351 | |
585343 | 585343 | 2020-09-30 | Cabo Rojo | Puerto Rico | 72023 | 349 | |
582103 | 582103 | 2020-09-29 | Cabo Rojo | Puerto Rico | 72023 | 349 | |
578863 | 578863 | 2020-09-28 | Cabo Rojo | Puerto Rico | 72023 | 347 | |
575622 | 575622 | 2020-09-27 | Cabo Rojo | Puerto Rico | 72023 | 342 | |
572378 | 572378 | 2020-09-26 | Cabo Rojo | Puerto Rico | 72023 | 331 | |
569136 | 569136 | 2020-09-25 | Cabo Rojo | Puerto Rico | 72023 | 330 | |
565895 | 565895 | 2020-09-24 | Cabo Rojo | Puerto Rico | 72023 | 327 | |
562654 | 562654 | 2020-09-23 | Cabo Rojo | Puerto Rico | 72023 | 321 | |
559417 | 559417 | 2020-09-22 | Cabo Rojo | Puerto Rico | 72023 | 321 | |
556180 | 556180 | 2020-09-21 | Cabo Rojo | Puerto Rico | 72023 | 320 | |
552943 | 552943 | 2020-09-20 | Cabo Rojo | Puerto Rico | 72023 | 319 | |
549704 | 549704 | 2020-09-19 | Cabo Rojo | Puerto Rico | 72023 | 309 | |
546465 | 546465 | 2020-09-18 | Cabo Rojo | Puerto Rico | 72023 | 301 | |
543228 | 543228 | 2020-09-17 | Cabo Rojo | Puerto Rico | 72023 | 300 | |
539992 | 539992 | 2020-09-16 | Cabo Rojo | Puerto Rico | 72023 | 295 | |
536755 | 536755 | 2020-09-15 | Cabo Rojo | Puerto Rico | 72023 | 295 | |
533519 | 533519 | 2020-09-14 | Cabo Rojo | Puerto Rico | 72023 | 294 | |
530284 | 530284 | 2020-09-13 | Cabo Rojo | Puerto Rico | 72023 | 293 | |
527047 | 527047 | 2020-09-12 | Cabo Rojo | Puerto Rico | 72023 | 291 | |
523811 | 523811 | 2020-09-11 | Cabo Rojo | Puerto Rico | 72023 | 284 | |
520575 | 520575 | 2020-09-10 | Cabo Rojo | Puerto Rico | 72023 | 283 | |
517339 | 517339 | 2020-09-09 | Cabo Rojo | Puerto Rico | 72023 | 280 | |
514104 | 514104 | 2020-09-08 | Cabo Rojo | Puerto Rico | 72023 | 280 | |
510871 | 510871 | 2020-09-07 | Cabo Rojo | Puerto Rico | 72023 | 281 | |
507638 | 507638 | 2020-09-06 | Cabo Rojo | Puerto Rico | 72023 | 279 | |
504406 | 504406 | 2020-09-05 | Cabo Rojo | Puerto Rico | 72023 | 278 | |
501172 | 501172 | 2020-09-04 | Cabo Rojo | Puerto Rico | 72023 | 278 | |
497938 | 497938 | 2020-09-03 | Cabo Rojo | Puerto Rico | 72023 | 280 | |
494705 | 494705 | 2020-09-02 | Cabo Rojo | Puerto Rico | 72023 | 280 | |
491471 | 491471 | 2020-09-01 | Cabo Rojo | Puerto Rico | 72023 | 280 | |
488238 | 488238 | 2020-08-31 | Cabo Rojo | Puerto Rico | 72023 | 280 | |
485005 | 485005 | 2020-08-30 | Cabo Rojo | Puerto Rico | 72023 | 279 | |
481770 | 481770 | 2020-08-29 | Cabo Rojo | Puerto Rico | 72023 | 277 | |
478536 | 478536 | 2020-08-28 | Cabo Rojo | Puerto Rico | 72023 | 271 | |
475303 | 475303 | 2020-08-27 | Cabo Rojo | Puerto Rico | 72023 | 268 | |
472069 | 472069 | 2020-08-26 | Cabo Rojo | Puerto Rico | 72023 | 264 | |
468837 | 468837 | 2020-08-25 | Cabo Rojo | Puerto Rico | 72023 | 263 | |
465609 | 465609 | 2020-08-24 | Cabo Rojo | Puerto Rico | 72023 | 263 | |
462380 | 462380 | 2020-08-23 | Cabo Rojo | Puerto Rico | 72023 | 262 | |
459152 | 459152 | 2020-08-22 | Cabo Rojo | Puerto Rico | 72023 | 258 | |
455924 | 455924 | 2020-08-21 | Cabo Rojo | Puerto Rico | 72023 | 250 | |
452696 | 452696 | 2020-08-20 | Cabo Rojo | Puerto Rico | 72023 | 247 | |
449468 | 449468 | 2020-08-19 | Cabo Rojo | Puerto Rico | 72023 | 244 | |
446240 | 446240 | 2020-08-18 | Cabo Rojo | Puerto Rico | 72023 | 243 | |
443014 | 443014 | 2020-08-17 | Cabo Rojo | Puerto Rico | 72023 | 241 | |
439787 | 439787 | 2020-08-16 | Cabo Rojo | Puerto Rico | 72023 | 241 | |
436562 | 436562 | 2020-08-15 | Cabo Rojo | Puerto Rico | 72023 | 239 | |
433335 | 433335 | 2020-08-14 | Cabo Rojo | Puerto Rico | 72023 | 236 | |
430109 | 430109 | 2020-08-13 | Cabo Rojo | Puerto Rico | 72023 | 231 | |
426884 | 426884 | 2020-08-12 | Cabo Rojo | Puerto Rico | 72023 | 220 | |
423661 | 423661 | 2020-08-11 | Cabo Rojo | Puerto Rico | 72023 | 216 | |
420438 | 420438 | 2020-08-10 | Cabo Rojo | Puerto Rico | 72023 | 210 | |
417218 | 417218 | 2020-08-09 | Cabo Rojo | Puerto Rico | 72023 | 206 | |
413997 | 413997 | 2020-08-08 | Cabo Rojo | Puerto Rico | 72023 | 202 | |
410777 | 410777 | 2020-08-07 | Cabo Rojo | Puerto Rico | 72023 | 197 | |
407557 | 407557 | 2020-08-06 | Cabo Rojo | Puerto Rico | 72023 | 192 | |
404338 | 404338 | 2020-08-05 | Cabo Rojo | Puerto Rico | 72023 | 185 | |
401120 | 401120 | 2020-08-04 | Cabo Rojo | Puerto Rico | 72023 | 180 | |
397905 | 397905 | 2020-08-03 | Cabo Rojo | Puerto Rico | 72023 | 177 | |
394688 | 394688 | 2020-08-02 | Cabo Rojo | Puerto Rico | 72023 | 172 | |
391472 | 391472 | 2020-08-01 | Cabo Rojo | Puerto Rico | 72023 | 171 | |
388255 | 388255 | 2020-07-31 | Cabo Rojo | Puerto Rico | 72023 | 163 | |
385038 | 385038 | 2020-07-30 | Cabo Rojo | Puerto Rico | 72023 | 160 | |
381820 | 381820 | 2020-07-29 | Cabo Rojo | Puerto Rico | 72023 | 160 | |
378603 | 378603 | 2020-07-28 | Cabo Rojo | Puerto Rico | 72023 | 159 | |
375387 | 375387 | 2020-07-27 | Cabo Rojo | Puerto Rico | 72023 | 158 | |
372174 | 372174 | 2020-07-26 | Cabo Rojo | Puerto Rico | 72023 | 156 | |
368962 | 368962 | 2020-07-25 | Cabo Rojo | Puerto Rico | 72023 | 152 | |
365753 | 365753 | 2020-07-24 | Cabo Rojo | Puerto Rico | 72023 | 150 | |
362547 | 362547 | 2020-07-23 | Cabo Rojo | Puerto Rico | 72023 | 144 | |
359341 | 359341 | 2020-07-22 | Cabo Rojo | Puerto Rico | 72023 | 142 | |
356137 | 356137 | 2020-07-21 | Cabo Rojo | Puerto Rico | 72023 | 140 | |
352934 | 352934 | 2020-07-20 | Cabo Rojo | Puerto Rico | 72023 | 135 | |
349731 | 349731 | 2020-07-19 | Cabo Rojo | Puerto Rico | 72023 | 130 | |
346531 | 346531 | 2020-07-18 | Cabo Rojo | Puerto Rico | 72023 | 127 | |
343331 | 343331 | 2020-07-17 | Cabo Rojo | Puerto Rico | 72023 | 125 | |
340133 | 340133 | 2020-07-16 | Cabo Rojo | Puerto Rico | 72023 | 118 | |
336936 | 336936 | 2020-07-15 | Cabo Rojo | Puerto Rico | 72023 | 111 | |
333742 | 333742 | 2020-07-14 | Cabo Rojo | Puerto Rico | 72023 | 111 | |
330550 | 330550 | 2020-07-13 | Cabo Rojo | Puerto Rico | 72023 | 110 | |
327364 | 327364 | 2020-07-12 | Cabo Rojo | Puerto Rico | 72023 | 106 | |
324179 | 324179 | 2020-07-11 | Cabo Rojo | Puerto Rico | 72023 | 97 | |
320999 | 320999 | 2020-07-10 | Cabo Rojo | Puerto Rico | 72023 | 95 | |
317821 | 317821 | 2020-07-09 | Cabo Rojo | Puerto Rico | 72023 | 88 |
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);