ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Unknown" and state = "Puerto Rico" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
261140 | 261140 | 2020-06-21 | Unknown | Puerto Rico | 434 | 149 | |
264268 | 264268 | 2020-06-22 | Unknown | Puerto Rico | 442 | 149 | |
267396 | 267396 | 2020-06-23 | Unknown | Puerto Rico | 554 | 149 | |
270530 | 270530 | 2020-06-24 | Unknown | Puerto Rico | 560 | 149 | |
273669 | 273669 | 2020-06-25 | Unknown | Puerto Rico | 295 | 151 | |
276816 | 276816 | 2020-06-26 | Unknown | Puerto Rico | 302 | 151 | |
279964 | 279964 | 2020-06-27 | Unknown | Puerto Rico | 307 | 152 | |
283110 | 283110 | 2020-06-28 | Unknown | Puerto Rico | 337 | 153 | |
286255 | 286255 | 2020-06-29 | Unknown | Puerto Rico | 320 | 153 | |
289406 | 289406 | 2020-06-30 | Unknown | Puerto Rico | 353 | 153 | |
292558 | 292558 | 2020-07-01 | Unknown | Puerto Rico | 351 | 153 | |
295714 | 295714 | 2020-07-02 | Unknown | Puerto Rico | 296 | 153 | |
298873 | 298873 | 2020-07-03 | Unknown | Puerto Rico | 268 | 154 | |
302037 | 302037 | 2020-07-04 | Unknown | Puerto Rico | 274 | 155 | |
305200 | 305200 | 2020-07-05 | Unknown | Puerto Rico | 301 | 155 | |
308367 | 308367 | 2020-07-06 | Unknown | Puerto Rico | 432 | 155 | |
311536 | 311536 | 2020-07-07 | Unknown | Puerto Rico | 455 | 157 | |
314708 | 314708 | 2020-07-08 | Unknown | Puerto Rico | 433 | 159 | |
317881 | 317881 | 2020-07-09 | Unknown | Puerto Rico | 396 | 159 | |
321059 | 321059 | 2020-07-10 | Unknown | Puerto Rico | 383 | 159 | |
324239 | 324239 | 2020-07-11 | Unknown | Puerto Rico | 411 | 167 | |
327424 | 327424 | 2020-07-12 | Unknown | Puerto Rico | 448 | 167 | |
330610 | 330610 | 2020-07-13 | Unknown | Puerto Rico | 449 | 167 | |
333802 | 333802 | 2020-07-14 | Unknown | Puerto Rico | 467 | 169 | |
336996 | 336996 | 2020-07-15 | Unknown | Puerto Rico | 477 | 171 | |
340193 | 340193 | 2020-07-16 | Unknown | Puerto Rico | 509 | 172 | |
343391 | 343391 | 2020-07-17 | Unknown | Puerto Rico | 622 | 177 | |
346591 | 346591 | 2020-07-18 | Unknown | Puerto Rico | 669 | 178 | |
349791 | 349791 | 2020-07-19 | Unknown | Puerto Rico | 742 | 178 | |
352994 | 352994 | 2020-07-20 | Unknown | Puerto Rico | 790 | 180 | |
356197 | 356197 | 2020-07-21 | Unknown | Puerto Rico | 827 | 180 | |
359401 | 359401 | 2020-07-22 | Unknown | Puerto Rico | 798 | 185 | |
362607 | 362607 | 2020-07-23 | Unknown | Puerto Rico | 780 | 188 | |
365813 | 365813 | 2020-07-24 | Unknown | Puerto Rico | 827 | 191 | |
369022 | 369022 | 2020-07-25 | Unknown | Puerto Rico | 833 | 201 | |
372234 | 372234 | 2020-07-26 | Unknown | Puerto Rico | 893 | 201 | |
375447 | 375447 | 2020-07-27 | Unknown | Puerto Rico | 927 | 201 | |
378663 | 378663 | 2020-07-28 | Unknown | Puerto Rico | 969 | 209 | |
381880 | 381880 | 2020-07-29 | Unknown | Puerto Rico | 986 | 211 | |
385098 | 385098 | 2020-07-30 | Unknown | Puerto Rico | 990 | 214 | |
388315 | 388315 | 2020-07-31 | Unknown | Puerto Rico | 970 | 219 | |
391532 | 391532 | 2020-08-01 | Unknown | Puerto Rico | 1070 | 225 | |
394748 | 394748 | 2020-08-02 | Unknown | Puerto Rico | 1142 | 230 | |
397965 | 397965 | 2020-08-03 | Unknown | Puerto Rico | 1159 | 230 | |
401180 | 401180 | 2020-08-04 | Unknown | Puerto Rico | 1199 | 237 | |
404398 | 404398 | 2020-08-05 | Unknown | Puerto Rico | 1149 | 246 | |
407617 | 407617 | 2020-08-06 | Unknown | Puerto Rico | 1117 | 258 | |
410837 | 410837 | 2020-08-07 | Unknown | Puerto Rico | 1118 | 265 | |
414057 | 414057 | 2020-08-08 | Unknown | Puerto Rico | 1166 | 274 | |
417278 | 417278 | 2020-08-09 | Unknown | Puerto Rico | 1165 | 279 | |
420498 | 420498 | 2020-08-10 | Unknown | Puerto Rico | 1204 | 279 | |
423721 | 423721 | 2020-08-11 | Unknown | Puerto Rico | 1198 | 287 | |
426944 | 426944 | 2020-08-12 | Unknown | Puerto Rico | 1233 | 295 | |
430169 | 430169 | 2020-08-13 | Unknown | Puerto Rico | 1192 | 306 | |
433395 | 433395 | 2020-08-14 | Unknown | Puerto Rico | 1179 | 317 | |
436622 | 436622 | 2020-08-15 | Unknown | Puerto Rico | 1199 | 329 | |
439847 | 439847 | 2020-08-16 | Unknown | Puerto Rico | 1198 | 335 | |
443074 | 443074 | 2020-08-17 | Unknown | Puerto Rico | 1274 | 335 | |
446300 | 446300 | 2020-08-18 | Unknown | Puerto Rico | 1401 | 346 | |
449528 | 449528 | 2020-08-19 | Unknown | Puerto Rico | 1366 | 356 | |
452756 | 452756 | 2020-08-20 | Unknown | Puerto Rico | 1305 | 367 | |
455984 | 455984 | 2020-08-21 | Unknown | Puerto Rico | 1303 | 374 | |
459212 | 459212 | 2020-08-22 | Unknown | Puerto Rico | 1348 | 381 | |
462440 | 462440 | 2020-08-23 | Unknown | Puerto Rico | 1296 | 390 | |
465669 | 465669 | 2020-08-24 | Unknown | Puerto Rico | 1376 | 390 | |
468897 | 468897 | 2020-08-25 | Unknown | Puerto Rico | 1383 | 395 | |
472129 | 472129 | 2020-08-26 | Unknown | Puerto Rico | 1306 | 404 | |
475363 | 475363 | 2020-08-27 | Unknown | Puerto Rico | 1329 | 412 | |
478596 | 478596 | 2020-08-28 | Unknown | Puerto Rico | 1328 | 424 | |
481830 | 481830 | 2020-08-29 | Unknown | Puerto Rico | 1313 | 428 | |
485065 | 485065 | 2020-08-30 | Unknown | Puerto Rico | 1294 | 434 | |
488298 | 488298 | 2020-08-31 | Unknown | Puerto Rico | 1320 | 434 | |
491531 | 491531 | 2020-09-01 | Unknown | Puerto Rico | 1336 | 435 | |
494765 | 494765 | 2020-09-02 | Unknown | Puerto Rico | 1356 | 443 | |
497998 | 497998 | 2020-09-03 | Unknown | Puerto Rico | 1296 | 448 | |
501232 | 501232 | 2020-09-04 | Unknown | Puerto Rico | 1283 | 455 | |
504466 | 504466 | 2020-09-05 | Unknown | Puerto Rico | 1291 | 464 | |
507698 | 507698 | 2020-09-06 | Unknown | Puerto Rico | 1255 | 477 | |
510931 | 510931 | 2020-09-07 | Unknown | Puerto Rico | 1298 | 477 | |
514164 | 514164 | 2020-09-08 | Unknown | Puerto Rico | 1299 | 482 | |
517399 | 517399 | 2020-09-09 | Unknown | Puerto Rico | 1299 | 500 | |
520635 | 520635 | 2020-09-10 | Unknown | Puerto Rico | 1325 | 512 | |
523871 | 523871 | 2020-09-11 | Unknown | Puerto Rico | 1275 | 523 | |
527107 | 527107 | 2020-09-12 | Unknown | Puerto Rico | 1281 | 535 | |
530344 | 530344 | 2020-09-13 | Unknown | Puerto Rico | 1266 | 539 | |
533579 | 533579 | 2020-09-14 | Unknown | Puerto Rico | 1270 | 542 | |
536815 | 536815 | 2020-09-15 | Unknown | Puerto Rico | 1277 | 551 | |
540052 | 540052 | 2020-09-16 | Unknown | Puerto Rico | 1252 | 570 | |
543288 | 543288 | 2020-09-17 | Unknown | Puerto Rico | 1244 | 588 | |
546525 | 546525 | 2020-09-18 | Unknown | Puerto Rico | 1305 | 599 | |
549764 | 549764 | 2020-09-19 | Unknown | Puerto Rico | 1333 | 605 | |
553003 | 553003 | 2020-09-20 | Unknown | Puerto Rico | 1334 | 608 | |
556240 | 556240 | 2020-09-21 | Unknown | Puerto Rico | 1352 | 609 | |
559477 | 559477 | 2020-09-22 | Unknown | Puerto Rico | 1352 | 613 | |
562714 | 562714 | 2020-09-23 | Unknown | Puerto Rico | 1315 | 617 | |
565955 | 565955 | 2020-09-24 | Unknown | Puerto Rico | 1332 | 627 | |
569196 | 569196 | 2020-09-25 | Unknown | Puerto Rico | 1326 | 635 | |
572438 | 572438 | 2020-09-26 | Unknown | Puerto Rico | 1310 | 642 | |
575682 | 575682 | 2020-09-27 | Unknown | Puerto Rico | 1311 | 644 | |
578923 | 578923 | 2020-09-28 | Unknown | Puerto Rico | 1344 | 648 |
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);