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 |
---|---|---|---|---|---|---|---|
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 | |
314654 | 314654 | 2020-07-08 | Cayey | Puerto Rico | 72035 | 114 | |
311482 | 311482 | 2020-07-07 | Cayey | Puerto Rico | 72035 | 114 | |
308313 | 308313 | 2020-07-06 | Cayey | Puerto Rico | 72035 | 114 | |
305146 | 305146 | 2020-07-05 | Cayey | Puerto Rico | 72035 | 111 | |
301983 | 301983 | 2020-07-04 | Cayey | Puerto Rico | 72035 | 111 | |
298819 | 298819 | 2020-07-03 | Cayey | Puerto Rico | 72035 | 111 | |
295660 | 295660 | 2020-07-02 | Cayey | Puerto Rico | 72035 | 109 | |
292504 | 292504 | 2020-07-01 | Cayey | Puerto Rico | 72035 | 109 | |
289352 | 289352 | 2020-06-30 | Cayey | Puerto Rico | 72035 | 109 | |
286201 | 286201 | 2020-06-29 | Cayey | Puerto Rico | 72035 | 108 | |
283056 | 283056 | 2020-06-28 | Cayey | Puerto Rico | 72035 | 108 | |
279910 | 279910 | 2020-06-27 | Cayey | Puerto Rico | 72035 | 107 | |
276762 | 276762 | 2020-06-26 | Cayey | Puerto Rico | 72035 | 107 | |
273615 | 273615 | 2020-06-25 | Cayey | Puerto Rico | 72035 | 107 | |
270476 | 270476 | 2020-06-24 | Cayey | Puerto Rico | 72035 | 105 | |
267342 | 267342 | 2020-06-23 | Cayey | Puerto Rico | 72035 | 103 | |
264214 | 264214 | 2020-06-22 | Cayey | Puerto Rico | 72035 | 101 | |
261086 | 261086 | 2020-06-21 | Cayey | Puerto Rico | 72035 | 101 | |
257959 | 257959 | 2020-06-20 | Cayey | Puerto Rico | 72035 | 101 | |
254833 | 254833 | 2020-06-19 | Cayey | Puerto Rico | 72035 | 100 | |
251718 | 251718 | 2020-06-18 | Cayey | Puerto Rico | 72035 | 101 | |
248603 | 248603 | 2020-06-17 | Cayey | Puerto Rico | 72035 | 101 | |
245490 | 245490 | 2020-06-16 | Cayey | Puerto Rico | 72035 | 100 | |
242378 | 242378 | 2020-06-15 | Cayey | Puerto Rico | 72035 | 100 | |
239269 | 239269 | 2020-06-14 | Cayey | Puerto Rico | 72035 | 100 | |
236161 | 236161 | 2020-06-13 | Cayey | Puerto Rico | 72035 | 100 | |
233056 | 233056 | 2020-06-12 | Cayey | Puerto Rico | 72035 | 97 | |
229951 | 229951 | 2020-06-11 | Cayey | Puerto Rico | 72035 | 93 | |
226847 | 226847 | 2020-06-10 | Cayey | Puerto Rico | 72035 | 92 | |
223747 | 223747 | 2020-06-09 | Cayey | Puerto Rico | 72035 | 88 | |
220652 | 220652 | 2020-06-08 | Cayey | Puerto Rico | 72035 | 86 |
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);