ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cayey" 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 |
---|---|---|---|---|---|---|---|
637230 | 637230 | 2020-10-16 | Cayey | Puerto Rico | 72035 | 434 | |
633984 | 633984 | 2020-10-15 | Cayey | Puerto Rico | 72035 | 429 | |
630739 | 630739 | 2020-10-14 | Cayey | Puerto Rico | 72035 | 427 | |
627495 | 627495 | 2020-10-13 | Cayey | Puerto Rico | 72035 | 425 | |
624253 | 624253 | 2020-10-12 | Cayey | Puerto Rico | 72035 | 418 | |
621010 | 621010 | 2020-10-11 | Cayey | Puerto Rico | 72035 | 406 | |
617767 | 617767 | 2020-10-10 | Cayey | Puerto Rico | 72035 | 401 | |
614525 | 614525 | 2020-10-09 | Cayey | Puerto Rico | 72035 | 394 | |
611284 | 611284 | 2020-10-08 | Cayey | Puerto Rico | 72035 | 390 | |
608042 | 608042 | 2020-10-07 | Cayey | Puerto Rico | 72035 | 388 | |
604799 | 604799 | 2020-10-06 | Cayey | Puerto Rico | 72035 | 388 | |
601557 | 601557 | 2020-10-05 | Cayey | Puerto Rico | 72035 | 385 | |
598314 | 598314 | 2020-10-04 | Cayey | Puerto Rico | 72035 | 381 | |
595071 | 595071 | 2020-10-03 | Cayey | Puerto Rico | 72035 | 381 | |
591830 | 591830 | 2020-10-02 | Cayey | Puerto Rico | 72035 | 373 | |
588589 | 588589 | 2020-10-01 | Cayey | Puerto Rico | 72035 | 370 | |
585349 | 585349 | 2020-09-30 | Cayey | Puerto Rico | 72035 | 363 | |
582109 | 582109 | 2020-09-29 | Cayey | Puerto Rico | 72035 | 363 | |
578869 | 578869 | 2020-09-28 | Cayey | Puerto Rico | 72035 | 357 | |
575628 | 575628 | 2020-09-27 | Cayey | Puerto Rico | 72035 | 354 | |
572384 | 572384 | 2020-09-26 | Cayey | Puerto Rico | 72035 | 350 | |
569142 | 569142 | 2020-09-25 | Cayey | Puerto Rico | 72035 | 345 | |
565901 | 565901 | 2020-09-24 | Cayey | Puerto Rico | 72035 | 336 | |
562660 | 562660 | 2020-09-23 | Cayey | Puerto Rico | 72035 | 331 | |
559423 | 559423 | 2020-09-22 | Cayey | Puerto Rico | 72035 | 331 | |
556186 | 556186 | 2020-09-21 | Cayey | Puerto Rico | 72035 | 331 | |
552949 | 552949 | 2020-09-20 | Cayey | Puerto Rico | 72035 | 328 | |
549710 | 549710 | 2020-09-19 | Cayey | Puerto Rico | 72035 | 320 | |
546471 | 546471 | 2020-09-18 | Cayey | Puerto Rico | 72035 | 312 | |
543234 | 543234 | 2020-09-17 | Cayey | Puerto Rico | 72035 | 308 | |
539998 | 539998 | 2020-09-16 | Cayey | Puerto Rico | 72035 | 304 | |
536761 | 536761 | 2020-09-15 | Cayey | Puerto Rico | 72035 | 304 | |
533525 | 533525 | 2020-09-14 | Cayey | Puerto Rico | 72035 | 302 | |
530290 | 530290 | 2020-09-13 | Cayey | Puerto Rico | 72035 | 297 | |
527053 | 527053 | 2020-09-12 | Cayey | Puerto Rico | 72035 | 295 | |
523817 | 523817 | 2020-09-11 | Cayey | Puerto Rico | 72035 | 286 | |
520581 | 520581 | 2020-09-10 | Cayey | Puerto Rico | 72035 | 283 | |
517345 | 517345 | 2020-09-09 | Cayey | Puerto Rico | 72035 | 281 | |
514110 | 514110 | 2020-09-08 | Cayey | Puerto Rico | 72035 | 281 | |
510877 | 510877 | 2020-09-07 | Cayey | Puerto Rico | 72035 | 280 | |
507644 | 507644 | 2020-09-06 | Cayey | Puerto Rico | 72035 | 274 | |
504412 | 504412 | 2020-09-05 | Cayey | Puerto Rico | 72035 | 274 | |
501178 | 501178 | 2020-09-04 | Cayey | Puerto Rico | 72035 | 271 | |
497944 | 497944 | 2020-09-03 | Cayey | Puerto Rico | 72035 | 272 | |
494711 | 494711 | 2020-09-02 | Cayey | Puerto Rico | 72035 | 272 | |
491477 | 491477 | 2020-09-01 | Cayey | Puerto Rico | 72035 | 271 | |
488244 | 488244 | 2020-08-31 | Cayey | Puerto Rico | 72035 | 269 | |
485011 | 485011 | 2020-08-30 | Cayey | Puerto Rico | 72035 | 265 | |
481776 | 481776 | 2020-08-29 | Cayey | Puerto Rico | 72035 | 261 | |
478542 | 478542 | 2020-08-28 | Cayey | Puerto Rico | 72035 | 258 | |
475309 | 475309 | 2020-08-27 | Cayey | Puerto Rico | 72035 | 251 | |
472075 | 472075 | 2020-08-26 | Cayey | Puerto Rico | 72035 | 246 | |
468843 | 468843 | 2020-08-25 | Cayey | Puerto Rico | 72035 | 246 | |
465615 | 465615 | 2020-08-24 | Cayey | Puerto Rico | 72035 | 245 | |
462386 | 462386 | 2020-08-23 | Cayey | Puerto Rico | 72035 | 243 | |
459158 | 459158 | 2020-08-22 | Cayey | Puerto Rico | 72035 | 242 | |
455930 | 455930 | 2020-08-21 | Cayey | Puerto Rico | 72035 | 237 | |
452702 | 452702 | 2020-08-20 | Cayey | Puerto Rico | 72035 | 232 | |
449474 | 449474 | 2020-08-19 | Cayey | Puerto Rico | 72035 | 229 | |
446246 | 446246 | 2020-08-18 | Cayey | Puerto Rico | 72035 | 229 | |
443020 | 443020 | 2020-08-17 | Cayey | Puerto Rico | 72035 | 227 | |
439793 | 439793 | 2020-08-16 | Cayey | Puerto Rico | 72035 | 223 | |
436568 | 436568 | 2020-08-15 | Cayey | Puerto Rico | 72035 | 222 | |
433341 | 433341 | 2020-08-14 | Cayey | Puerto Rico | 72035 | 215 | |
430115 | 430115 | 2020-08-13 | Cayey | Puerto Rico | 72035 | 206 | |
426890 | 426890 | 2020-08-12 | Cayey | Puerto Rico | 72035 | 203 | |
423667 | 423667 | 2020-08-11 | Cayey | Puerto Rico | 72035 | 203 | |
420444 | 420444 | 2020-08-10 | Cayey | Puerto Rico | 72035 | 199 | |
417224 | 417224 | 2020-08-09 | Cayey | Puerto Rico | 72035 | 197 | |
414003 | 414003 | 2020-08-08 | Cayey | Puerto Rico | 72035 | 196 | |
410783 | 410783 | 2020-08-07 | Cayey | Puerto Rico | 72035 | 194 | |
407563 | 407563 | 2020-08-06 | Cayey | Puerto Rico | 72035 | 192 | |
404344 | 404344 | 2020-08-05 | Cayey | Puerto Rico | 72035 | 188 | |
401126 | 401126 | 2020-08-04 | Cayey | Puerto Rico | 72035 | 184 | |
397911 | 397911 | 2020-08-03 | Cayey | Puerto Rico | 72035 | 178 | |
394694 | 394694 | 2020-08-02 | Cayey | Puerto Rico | 72035 | 172 | |
391478 | 391478 | 2020-08-01 | Cayey | Puerto Rico | 72035 | 170 | |
388261 | 388261 | 2020-07-31 | Cayey | Puerto Rico | 72035 | 165 | |
385044 | 385044 | 2020-07-30 | Cayey | Puerto Rico | 72035 | 163 | |
381826 | 381826 | 2020-07-29 | Cayey | Puerto Rico | 72035 | 159 | |
378609 | 378609 | 2020-07-28 | Cayey | Puerto Rico | 72035 | 157 | |
375393 | 375393 | 2020-07-27 | Cayey | Puerto Rico | 72035 | 156 | |
372180 | 372180 | 2020-07-26 | Cayey | Puerto Rico | 72035 | 155 | |
368968 | 368968 | 2020-07-25 | Cayey | Puerto Rico | 72035 | 152 | |
365759 | 365759 | 2020-07-24 | Cayey | Puerto Rico | 72035 | 146 | |
362553 | 362553 | 2020-07-23 | Cayey | Puerto Rico | 72035 | 142 | |
359347 | 359347 | 2020-07-22 | Cayey | Puerto Rico | 72035 | 138 | |
356143 | 356143 | 2020-07-21 | Cayey | Puerto Rico | 72035 | 137 | |
352940 | 352940 | 2020-07-20 | Cayey | Puerto Rico | 72035 | 136 | |
349737 | 349737 | 2020-07-19 | Cayey | Puerto Rico | 72035 | 135 | |
346537 | 346537 | 2020-07-18 | Cayey | Puerto Rico | 72035 | 131 | |
343337 | 343337 | 2020-07-17 | Cayey | Puerto Rico | 72035 | 126 | |
340139 | 340139 | 2020-07-16 | Cayey | Puerto Rico | 72035 | 123 | |
336942 | 336942 | 2020-07-15 | Cayey | Puerto Rico | 72035 | 123 | |
333748 | 333748 | 2020-07-14 | Cayey | Puerto Rico | 72035 | 119 | |
330556 | 330556 | 2020-07-13 | Cayey | Puerto Rico | 72035 | 119 | |
327370 | 327370 | 2020-07-12 | Cayey | Puerto Rico | 72035 | 118 | |
324185 | 324185 | 2020-07-11 | Cayey | Puerto Rico | 72035 | 118 | |
321005 | 321005 | 2020-07-10 | Cayey | Puerto Rico | 72035 | 115 | |
317827 | 317827 | 2020-07-09 | Cayey | Puerto Rico | 72035 | 114 |
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);