ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,822 rows where county = "San Juan" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 396 ✖
- 0 1,388
- - 739
- 37 155
- 1 103
- 2 96
- 47 73
- 36 56
- 29 45
- 48 41
- 39 34
- 43 34
- 30 31
- 41 27
- 32 25
- 5 20
- 40 20
- 45 20
- 31 18
- 744 16
- 35 15
- 504 14
- 466 13
- 503 13
- 28 12
- 497 12
- 4 11
- 194 11
- 7 10
- 49 10
- 19 9
- 25 9
- 204 9
- 9 8
- 46 8
- 189 8
- 199 8
- 752 8
- 176 7
- 203 7
- 463 7
- 484 7
- 745 7
- 3 6
- 27 6
- 34 6
- 197 6
- 202 6
- 451 6
- 469 6
- 492 6
- 499 6
- 739 6
- 11 5
- 24 5
- 26 5
- 178 5
- 460 5
- 501 5
- 534 5
- 537 5
- 594 5
- 603 5
- 653 5
- 723 5
- 741 5
- 22 4
- 164 4
- 187 4
- 190 4
- 192 4
- 206 4
- 207 4
- 208 4
- 453 4
- 464 4
- 468 4
- 476 4
- 487 4
- 493 4
- 505 4
- 508 4
- 517 4
- 522 4
- 527 4
- 630 4
- 641 4
- 661 4
- 671 4
- 707 4
- 733 4
- 6 3
- 8 3
- 10 3
- 17 3
- 18 3
- 62 3
- 163 3
- 181 3
- 183 3
- 185 3
- 200 3
- 201 3
- 205 3
- 210 3
- 222 3
- 415 3
- 446 3
- 450 3
- 467 3
- 473 3
- 474 3
- 482 3
- 502 3
- 507 3
- 510 3
- 531 3
- 542 3
- 548 3
- 556 3
- 562 3
- 570 3
- 589 3
- 609 3
- 676 3
- 689 3
- 697 3
- 710 3
- 711 3
- 717 3
- 731 3
- 748 3
- 14 2
- 44 2
- 57 2
- 71 2
- 147 2
- 154 2
- 155 2
- 160 2
- 161 2
- 182 2
- 184 2
- 191 2
- 211 2
- 255 2
- 260 2
- 265 2
- 285 2
- 314 2
- 318 2
- 320 2
- 383 2
- 430 2
- 433 2
- 455 2
- 465 2
- 470 2
- 472 2
- 489 2
- 496 2
- 498 2
- 521 2
- 523 2
- 529 2
- 533 2
- 539 2
- 544 2
- 560 2
- 569 2
- 591 2
- 674 2
- 699 2
- 718 2
- 732 2
- 737 2
- 754 2
- 13 1
- 15 1
- 21 1
- 23 1
- 33 1
- 38 1
- 42 1
- 51 1
- 64 1
- 69 1
- 74 1
- 80 1
- 81 1
- 84 1
- 85 1
- 86 1
- 87 1
- 92 1
- 96 1
- 99 1
- 103 1
- 105 1
- 108 1
- 110 1
- 112 1
- 113 1
- 114 1
- 115 1
- 117 1
- 121 1
- 123 1
- 124 1
- 127 1
- 129 1
- 130 1
- 131 1
- 132 1
- 134 1
- 135 1
- 137 1
- 144 1
- 145 1
- 148 1
- 151 1
- 152 1
- 153 1
- 156 1
- 157 1
- 162 1
- 165 1
- 166 1
- 167 1
- 169 1
- 170 1
- 171 1
- 172 1
- 173 1
- 174 1
- 175 1
- 177 1
- 179 1
- 180 1
- 188 1
- 193 1
- 195 1
- 198 1
- 216 1
- 225 1
- 226 1
- 230 1
- 235 1
- 237 1
- 238 1
- 240 1
- 243 1
- 246 1
- 247 1
- 249 1
- 250 1
- 252 1
- 256 1
- 263 1
- 268 1
- 270 1
- 273 1
- 276 1
- 277 1
- 278 1
- 280 1
- 282 1
- 284 1
- 286 1
- 287 1
- 288 1
- 293 1
- 296 1
- 297 1
- 299 1
- 300 1
- 301 1
- 302 1
- 304 1
- 308 1
- 310 1
- 312 1
- 324 1
- 328 1
- 333 1
- 336 1
- 341 1
- 347 1
- 353 1
- 357 1
- 359 1
- 361 1
- 364 1
- 366 1
- 372 1
- 377 1
- 379 1
- 385 1
- 389 1
- 392 1
- 394 1
- 396 1
- 400 1
- 404 1
- 405 1
- 408 1
- 410 1
- 412 1
- 417 1
- 418 1
- 419 1
- 423 1
- 424 1
- 426 1
- 428 1
- 429 1
- 431 1
- 436 1
- 438 1
- 439 1
- 442 1
- 452 1
- 458 1
- 459 1
- 462 1
- 490 1
- 491 1
- 495 1
- 500 1
- 515 1
- 519 1
- 524 1
- 528 1
- 532 1
- 535 1
- 536 1
- 541 1
- 545 1
- 546 1
- 550 1
- 551 1
- 552 1
- 553 1
- 558 1
- 561 1
- 565 1
- 567 1
- 572 1
- 578 1
- 581 1
- 585 1
- 597 1
- 598 1
- 601 1
- 602 1
- 607 1
- 608 1
- 611 1
- 612 1
- 615 1
- 622 1
- 635 1
- 637 1
- 644 1
- 646 1
- 649 1
- 656 1
- 659 1
- 665 1
- 666 1
- 669 1
- 670 1
- 673 1
- 677 1
- 679 1
- 682 1
- 686 1
- 690 1
- 692 1
- 693 1
- 696 1
- 703 1
- 709 1
- 712 1
- 714 1
- 715 1
- 716 1
- 720 1
- 725 1
- 726 1
- 729 1
- 735 1
- 736 1
- 742 1
- 747 1
- 751 1
- 755 1
state 5
- Washington 785
- New Mexico 783
- Utah 777
- Puerto Rico 739
- Colorado 738
county 1
- San Juan · 3,822 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6032 | 6032 | 2020-03-20 | San Juan | Washington | 53055 | 1 | 0 |
7063 | 7063 | 2020-03-21 | San Juan | Washington | 53055 | 1 | 0 |
7790 | 7790 | 2020-03-22 | San Juan | New Mexico | 35045 | 1 | 0 |
8200 | 8200 | 2020-03-22 | San Juan | Washington | 53055 | 1 | 0 |
8987 | 8987 | 2020-03-23 | San Juan | New Mexico | 35045 | 3 | 0 |
9425 | 9425 | 2020-03-23 | San Juan | Washington | 53055 | 1 | 0 |
10293 | 10293 | 2020-03-24 | San Juan | New Mexico | 35045 | 7 | 0 |
10774 | 10774 | 2020-03-24 | San Juan | Washington | 53055 | 1 | 0 |
11727 | 11727 | 2020-03-25 | San Juan | New Mexico | 35045 | 8 | 0 |
12298 | 12298 | 2020-03-25 | San Juan | Washington | 53055 | 2 | 0 |
13330 | 13330 | 2020-03-26 | San Juan | New Mexico | 35045 | 14 | 0 |
13948 | 13948 | 2020-03-26 | San Juan | Washington | 53055 | 3 | 0 |
15063 | 15063 | 2020-03-27 | San Juan | New Mexico | 35045 | 17 | 0 |
15716 | 15716 | 2020-03-27 | San Juan | Washington | 53055 | 3 | 0 |
16892 | 16892 | 2020-03-28 | San Juan | New Mexico | 35045 | 18 | 0 |
17475 | 17475 | 2020-03-28 | San Juan | Utah | 49037 | 1 | 0 |
17596 | 17596 | 2020-03-28 | San Juan | Washington | 53055 | 4 | 0 |
18816 | 18816 | 2020-03-29 | San Juan | New Mexico | 35045 | 22 | 0 |
19434 | 19434 | 2020-03-29 | San Juan | Utah | 49037 | 4 | 0 |
19561 | 19561 | 2020-03-29 | San Juan | Washington | 53055 | 4 | 0 |
20854 | 20854 | 2020-03-30 | San Juan | New Mexico | 35045 | 27 | 0 |
21497 | 21497 | 2020-03-30 | San Juan | Utah | 49037 | 4 | 0 |
21628 | 21628 | 2020-03-30 | San Juan | Washington | 53055 | 4 | 0 |
22977 | 22977 | 2020-03-31 | San Juan | New Mexico | 35045 | 32 | 0 |
23636 | 23636 | 2020-03-31 | San Juan | Utah | 49037 | 4 | 0 |
23777 | 23777 | 2020-03-31 | San Juan | Washington | 53055 | 4 | 0 |
25171 | 25171 | 2020-04-01 | San Juan | New Mexico | 35045 | 37 | 0 |
25851 | 25851 | 2020-04-01 | San Juan | Utah | 49037 | 4 | 0 |
25995 | 25995 | 2020-04-01 | San Juan | Washington | 53055 | 6 | 0 |
27431 | 27431 | 2020-04-02 | San Juan | New Mexico | 35045 | 41 | 0 |
28140 | 28140 | 2020-04-02 | San Juan | Utah | 49037 | 5 | 0 |
28286 | 28286 | 2020-04-02 | San Juan | Washington | 53055 | 6 | 0 |
29754 | 29754 | 2020-04-03 | San Juan | New Mexico | 35045 | 50 | 0 |
30483 | 30483 | 2020-04-03 | San Juan | Utah | 49037 | 5 | 0 |
30639 | 30639 | 2020-04-03 | San Juan | Washington | 53055 | 6 | 0 |
32141 | 32141 | 2020-04-04 | San Juan | New Mexico | 35045 | 58 | 0 |
32881 | 32881 | 2020-04-04 | San Juan | Utah | 49037 | 5 | 0 |
33039 | 33039 | 2020-04-04 | San Juan | Washington | 53055 | 7 | 0 |
34572 | 34572 | 2020-04-05 | San Juan | New Mexico | 35045 | 58 | 0 |
35319 | 35319 | 2020-04-05 | San Juan | Utah | 49037 | 5 | 0 |
35477 | 35477 | 2020-04-05 | San Juan | Washington | 53055 | 7 | 0 |
37042 | 37042 | 2020-04-06 | San Juan | New Mexico | 35045 | 83 | 0 |
37797 | 37797 | 2020-04-06 | San Juan | Utah | 49037 | 5 | 0 |
37961 | 37961 | 2020-04-06 | San Juan | Washington | 53055 | 10 | 0 |
39557 | 39557 | 2020-04-07 | San Juan | New Mexico | 35045 | 107 | 0 |
40326 | 40326 | 2020-04-07 | San Juan | Utah | 49037 | 5 | 0 |
40496 | 40496 | 2020-04-07 | San Juan | Washington | 53055 | 11 | 0 |
42114 | 42114 | 2020-04-08 | San Juan | New Mexico | 35045 | 116 | 0 |
42894 | 42894 | 2020-04-08 | San Juan | Utah | 49037 | 6 | 0 |
43065 | 43065 | 2020-04-08 | San Juan | Washington | 53055 | 12 | 0 |
44697 | 44697 | 2020-04-09 | San Juan | New Mexico | 35045 | 126 | 0 |
45488 | 45488 | 2020-04-09 | San Juan | Utah | 49037 | 6 | 0 |
45661 | 45661 | 2020-04-09 | San Juan | Washington | 53055 | 12 | 0 |
47310 | 47310 | 2020-04-10 | San Juan | New Mexico | 35045 | 142 | 0 |
48112 | 48112 | 2020-04-10 | San Juan | Utah | 49037 | 6 | 0 |
48289 | 48289 | 2020-04-10 | San Juan | Washington | 53055 | 12 | 0 |
49965 | 49965 | 2020-04-11 | San Juan | New Mexico | 35045 | 149 | 1 |
50770 | 50770 | 2020-04-11 | San Juan | Utah | 49037 | 8 | 0 |
50947 | 50947 | 2020-04-11 | San Juan | Washington | 53055 | 13 | 0 |
52638 | 52638 | 2020-04-12 | San Juan | New Mexico | 35045 | 151 | 2 |
53445 | 53445 | 2020-04-12 | San Juan | Utah | 49037 | 8 | 0 |
53622 | 53622 | 2020-04-12 | San Juan | Washington | 53055 | 13 | 0 |
55321 | 55321 | 2020-04-13 | San Juan | New Mexico | 35045 | 173 | 7 |
56134 | 56134 | 2020-04-13 | San Juan | Utah | 49037 | 9 | 0 |
56312 | 56312 | 2020-04-13 | San Juan | Washington | 53055 | 13 | 0 |
58021 | 58021 | 2020-04-14 | San Juan | New Mexico | 35045 | 192 | 10 |
58840 | 58840 | 2020-04-14 | San Juan | Utah | 49037 | 9 | 0 |
59018 | 59018 | 2020-04-14 | San Juan | Washington | 53055 | 13 | 0 |
60735 | 60735 | 2020-04-15 | San Juan | New Mexico | 35045 | 200 | 10 |
61558 | 61558 | 2020-04-15 | San Juan | Utah | 49037 | 9 | 0 |
61737 | 61737 | 2020-04-15 | San Juan | Washington | 53055 | 13 | 0 |
63461 | 63461 | 2020-04-16 | San Juan | New Mexico | 35045 | 229 | 13 |
64290 | 64290 | 2020-04-16 | San Juan | Utah | 49037 | 9 | 0 |
64470 | 64470 | 2020-04-16 | San Juan | Washington | 53055 | 13 | 0 |
66203 | 66203 | 2020-04-17 | San Juan | New Mexico | 35045 | 243 | 14 |
67038 | 67038 | 2020-04-17 | San Juan | Utah | 49037 | 17 | 2 |
67218 | 67218 | 2020-04-17 | San Juan | Washington | 53055 | 15 | 0 |
68960 | 68960 | 2020-04-18 | San Juan | New Mexico | 35045 | 260 | 14 |
69799 | 69799 | 2020-04-18 | San Juan | Utah | 49037 | 18 | 2 |
69980 | 69980 | 2020-04-18 | San Juan | Washington | 53055 | 15 | 0 |
71727 | 71727 | 2020-04-19 | San Juan | New Mexico | 35045 | 275 | 15 |
72569 | 72569 | 2020-04-19 | San Juan | Utah | 49037 | 22 | 2 |
72750 | 72750 | 2020-04-19 | San Juan | Washington | 53055 | 15 | 0 |
74502 | 74502 | 2020-04-20 | San Juan | New Mexico | 35045 | 293 | 17 |
75345 | 75345 | 2020-04-20 | San Juan | Utah | 49037 | 29 | 2 |
75526 | 75526 | 2020-04-20 | San Juan | Washington | 53055 | 14 | 0 |
77283 | 77283 | 2020-04-21 | San Juan | New Mexico | 35045 | 314 | 17 |
78127 | 78127 | 2020-04-21 | San Juan | Utah | 49037 | 34 | 2 |
78309 | 78309 | 2020-04-21 | San Juan | Washington | 53055 | 14 | 0 |
80072 | 80072 | 2020-04-22 | San Juan | New Mexico | 35045 | 339 | 22 |
80919 | 80919 | 2020-04-22 | San Juan | Utah | 49037 | 34 | 2 |
81102 | 81102 | 2020-04-22 | San Juan | Washington | 53055 | 16 | 0 |
82871 | 82871 | 2020-04-23 | San Juan | New Mexico | 35045 | 390 | 24 |
83720 | 83720 | 2020-04-23 | San Juan | Utah | 49037 | 37 | 2 |
83903 | 83903 | 2020-04-23 | San Juan | Washington | 53055 | 14 | 0 |
85675 | 85675 | 2020-04-24 | San Juan | New Mexico | 35045 | 420 | 27 |
86527 | 86527 | 2020-04-24 | San Juan | Utah | 49037 | 37 | 2 |
86710 | 86710 | 2020-04-24 | San Juan | Washington | 53055 | 14 | 0 |
88486 | 88486 | 2020-04-25 | San Juan | New Mexico | 35045 | 435 | 33 |
89342 | 89342 | 2020-04-25 | San Juan | Utah | 49037 | 40 | 2 |
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);