ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,550 rows where county = "Scotland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
cases 738 ✖
- 306 69
- 4 47
- 681 37
- 305 35
- 11 34
- 682 32
- 8 18
- 308 18
- 309 14
- 680 13
- 18 12
- 263 12
- 331 12
- 9 11
- 312 11
- 1 10
- 2 10
- 304 10
- 12 9
- 233 9
- 311 9
- 427 9
- 3 7
- 31 7
- 225 7
- 240 7
- 333 7
- 9987 7
- 9999 7
- 10021 7
- 10052 7
- 10067 7
- 22 6
- 234 6
- 310 6
- 374 6
- 6047 6
- 20 5
- 45 5
- 183 5
- 235 5
- 307 5
- 313 5
- 365 5
- 394 5
- 438 5
- 514 5
- 5840 5
- 14 4
- 15 4
- 16 4
- 21 4
- 23 4
- 24 4
- 41 4
- 84 4
- 236 4
- 314 4
- 437 4
- 448 4
- 505 4
- 667 4
- 3575 4
- 3821 4
- 3838 4
- 3910 4
- 4810 4
- 7891 4
- 9972 4
- 19 3
- 28 3
- 29 3
- 36 3
- 63 3
- 78 3
- 123 3
- 135 3
- 177 3
- 217 3
- 222 3
- 303 3
- 395 3
- 396 3
- 426 3
- 441 3
- 527 3
- 562 3
- 628 3
- 672 3
- 683 3
- 2405 3
- 3528 3
- 3561 3
- 3610 3
- 3642 3
- 3683 3
- 3724 3
- 3778 3
- 3799 3
- 3856 3
- 3874 3
- 3885 3
- 3896 3
- 3905 3
- 3923 3
- 3953 3
- 4018 3
- 4104 3
- 4206 3
- 4337 3
- 4466 3
- 4639 3
- 5008 3
- 5208 3
- 5349 3
- 5479 3
- 5569 3
- 5636 3
- 5686 3
- 5735 3
- 5773 3
- 5806 3
- 5824 3
- 5876 3
- 5934 3
- 5995 3
- 6271 3
- 6809 3
- 8760 3
- 9299 3
- 9584 3
- 9732 3
- 9811 3
- 9854 3
- 9879 3
- 9904 3
- 9933 3
- 9960 3
- 10125 3
- 6 2
- 26 2
- 30 2
- 35 2
- 38 2
- 43 2
- 44 2
- 48 2
- 67 2
- 68 2
- 72 2
- 73 2
- 86 2
- 97 2
- 98 2
- 107 2
- 114 2
- 120 2
- 149 2
- 152 2
- 157 2
- 170 2
- 192 2
- 194 2
- 201 2
- 202 2
- 205 2
- 206 2
- 227 2
- 232 2
- 242 2
- 244 2
- 252 2
- 253 2
- 256 2
- 257 2
- 258 2
- 315 2
- 320 2
- 332 2
- 419 2
- 432 2
- 436 2
- 464 2
- 466 2
- 470 2
- 513 2
- 519 2
- 597 2
- 645 2
- 1902 2
- 2522 2
- 2962 2
- 3145 2
- 3479 2
- 3508 2
- 3531 2
- 3544 2
- 3880 2
- 3893 2
- 5796 2
- 5 1
- 10 1
- 13 1
- 17 1
- 25 1
- 27 1
- 32 1
- 34 1
- 40 1
- 46 1
- 50 1
- 52 1
- 53 1
- 54 1
- 55 1
- 56 1
- 58 1
- 59 1
- 60 1
- 61 1
- 62 1
- 64 1
- 69 1
- 71 1
- 80 1
- 81 1
- 82 1
- 85 1
- 87 1
- 88 1
- 89 1
- 90 1
- 92 1
- 95 1
- 96 1
- 99 1
- 100 1
- 102 1
- 104 1
- 108 1
- 111 1
- 113 1
- 115 1
- 117 1
- 124 1
- 129 1
- 130 1
- 132 1
- 133 1
- 134 1
- 136 1
- 137 1
- 138 1
- 142 1
- 144 1
- 146 1
- 147 1
- 151 1
- 163 1
- 165 1
- 166 1
- 168 1
- 172 1
- 174 1
- 176 1
- 181 1
- 185 1
- 188 1
- 191 1
- 195 1
- 197 1
- 200 1
- 203 1
- 209 1
- 212 1
- 214 1
- 215 1
- 216 1
- 220 1
- 224 1
- 229 1
- 230 1
- 231 1
- 237 1
- 238 1
- 239 1
- 245 1
- 246 1
- 249 1
- 250 1
- 259 1
- 262 1
- 273 1
- 281 1
- 286 1
- 302 1
- 330 1
- 334 1
- 339 1
- 341 1
- 343 1
- 351 1
- 360 1
- 362 1
- 371 1
- 382 1
- 388 1
- 390 1
- 393 1
- 398 1
- 413 1
- 415 1
- 439 1
- 440 1
- 449 1
- 452 1
- 460 1
- 469 1
- 472 1
- 481 1
- 482 1
- 485 1
- 486 1
- 495 1
- 496 1
- 501 1
- 522 1
- 524 1
- 526 1
- 531 1
- 534 1
- 542 1
- 546 1
- 549 1
- 553 1
- 556 1
- 561 1
- 567 1
- 569 1
- 573 1
- 575 1
- 589 1
- 592 1
- 593 1
- 596 1
- 599 1
- 608 1
- 619 1
- 623 1
- 625 1
- 630 1
- 641 1
- 643 1
- 646 1
- 647 1
- 648 1
- 649 1
- 657 1
- 659 1
- 664 1
- 669 1
- 677 1
- 684 1
- 697 1
- 730 1
- 734 1
- 743 1
- 746 1
- 747 1
- 751 1
- 771 1
- 794 1
- 811 1
- 820 1
- 831 1
- 838 1
- 848 1
- 889 1
- 899 1
- 907 1
- 957 1
- 962 1
- 968 1
- 984 1
- 1034 1
- 1095 1
- 1154 1
- 1167 1
- 1170 1
- 1174 1
- 1202 1
- 1257 1
- 1276 1
- 1295 1
- 1297 1
- 1316 1
- 1331 1
- 1355 1
- 1400 1
- 1416 1
- 1421 1
- 1435 1
- 1438 1
- 1448 1
- 1464 1
- 1489 1
- 1498 1
- 1508 1
- 1537 1
- 1541 1
- 1551 1
- 1576 1
- 1579 1
- 1587 1
- 1602 1
- 1606 1
- 1614 1
- 1621 1
- 1630 1
- 1652 1
- 1657 1
- 1663 1
- 1672 1
- 1674 1
- 1682 1
- 1701 1
- 1705 1
- 1710 1
- 1722 1
- 1725 1
- 1726 1
- 1730 1
- 1739 1
- 1745 1
- 1748 1
- 1752 1
- 1760 1
- 1765 1
- 1777 1
- 1791 1
- 1805 1
- 1833 1
- 1845 1
- 1865 1
- 1874 1
- 1886 1
- 1938 1
- 1949 1
- 1955 1
- 1962 1
- 1978 1
- 2001 1
- 2039 1
- 2053 1
- 2061 1
- 2079 1
- 2092 1
- 2103 1
- 2132 1
- 2154 1
- 2186 1
- 2212 1
- 2225 1
- 2239 1
- 2257 1
- 2281 1
- 2302 1
- 2331 1
- 2357 1
- 2372 1
- 2379 1
- 2387 1
- 2459 1
- 2468 1
- 2472 1
- 2475 1
- 2515 1
- 2604 1
- 2613 1
- 2627 1
- 2641 1
- 2670 1
- 2712 1
- 2740 1
- 2768 1
- 2801 1
- 2816 1
- 2831 1
- 2848 1
- 2895 1
- 2924 1
- 2943 1
- 2980 1
- 3005 1
- 3027 1
- 3041 1
- 3076 1
- 3088 1
- 3094 1
- 3102 1
- 3110 1
- 3134 1
- 3169 1
- 3172 1
- 3184 1
- 3216 1
- 3230 1
- 3247 1
- 3251 1
- 3269 1
- 3274 1
- 3282 1
- 3300 1
- 3314 1
- 3329 1
- 3335 1
- 3344 1
- 3356 1
- 3361 1
- 3375 1
- 3394 1
- 3406 1
- 3423 1
- 3431 1
- 3432 1
- 3434 1
- 3451 1
- 3465 1
- 3470 1
- 3490 1
- 3494 1
- 3499 1
- 3500 1
- 3505 1
- 3515 1
- 3519 1
- 3520 1
- 3522 1
- 3532 1
- 3535 1
- 3539 1
- 3546 1
- 3549 1
- 3554 1
- 3555 1
- 3570 1
- 3571 1
- 3573 1
- 3588 1
- 3590 1
- 3597 1
- 3602 1
- 3620 1
- 3621 1
- 3629 1
- 3637 1
- 3648 1
- 3658 1
- 3659 1
- 3671 1
- 3695 1
- 3700 1
- 3705 1
- 3716 1
- 3744 1
- 3746 1
- 3751 1
- 3767 1
- 3783 1
- 3785 1
- 3789 1
- 3796 1
- 3804 1
- 3808 1
- 3811 1
- 3815 1
- 3820 1
- 3831 1
- 3835 1
- 3848 1
- 3852 1
- 3855 1
- 3864 1
- 3865 1
- 3869 1
- 3871 1
- 3882 1
- 3884 1
- 3889 1
- 3892 1
- 3908 1
- 3914 1
- 3917 1
- 3918 1
- 3932 1
- 3934 1
- 3940 1
- 3947 1
- 3970 1
- 3988 1
- 3999 1
- 4009 1
- 4044 1
- 4060 1
- 4077 1
- 4096 1
- 4133 1
- 4144 1
- 4166 1
- 4185 1
- 4258 1
- 4275 1
- 4297 1
- 4316 1
- 4381 1
- 4393 1
- 4405 1
- 4430 1
- 4531 1
- 4548 1
- 4575 1
- 4606 1
- 4690 1
- 4710 1
- 4720 1
- 4752 1
- 4902 1
- 4924 1
- 4966 1
- 5093 1
- 5112 1
- 5137 1
- 5166 1
- 5254 1
- 5271 1
- 5304 1
- 5318 1
- 5397 1
- 5418 1
- 5436 1
- 5462 1
- 5517 1
- 5527 1
- 5534 1
- 5547 1
- 5602 1
- 5610 1
- 5619 1
- 5628 1
- 5651 1
- 5654 1
- 5659 1
- 5674 1
- 5705 1
- 5709 1
- 5712 1
- 5717 1
- 5754 1
- 5757 1
- 5762 1
- 5768 1
- 5781 1
- 5786 1
- 5816 1
- 5817 1
- 5818 1
- 5823 1
- 5832 1
- 5836 1
- 5856 1
- 5862 1
- 5864 1
- 5866 1
- 5890 1
- 5905 1
- 5918 1
- 5927 1
- 5956 1
- 5967 1
- 5974 1
- 5983 1
- 6030 1
- 6041 1
- 6114 1
- 6154 1
- 6207 1
- 6439 1
- 6470 1
- 6543 1
- 6655 1
- 7128 1
- 7266 1
- 7378 1
- 7664 1
- 8396 1
- 8526 1
- 8581 1
- 9043 1
- 9093 1
- 9132 1
- 9243 1
- 9417 1
- 9483 1
- 9508 1
- 9548 1
- 9641 1
- 9651 1
- 9684 1
- 9709 1
- 9758 1
- 9764 1
- 9777 1
- 9794 1
- 9825 1
- 9835 1
- 9844 1
- 9853 1
- 9861 1
- 9863 1
- 9872 1
- 9876 1
- 9885 1
- 9888 1
- 9899 1
- 9903 1
- 9914 1
- 9915 1
- 9921 1
- 9924 1
- 9951 1
- 9953 1
- 9954 1
- 9957 1
- 9964 1
- 9966 1
- 9970 1
- 9977 1
- 9982 1
state 2
- North Carolina 783
- Missouri 767
county 1
- Scotland · 1,550 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501171 | 2501171 | 2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 |
2501568 | 2501568 | 2022-05-13 | Scotland | North Carolina | 37165 | 10125 | 132 |
2497913 | 2497913 | 2022-05-12 | Scotland | Missouri | 29199 | 680 | 18 |
2498310 | 2498310 | 2022-05-12 | Scotland | North Carolina | 37165 | 10125 | 132 |
2494655 | 2494655 | 2022-05-11 | Scotland | Missouri | 29199 | 680 | 18 |
2495052 | 2495052 | 2022-05-11 | Scotland | North Carolina | 37165 | 10125 | 132 |
2491397 | 2491397 | 2022-05-10 | Scotland | Missouri | 29199 | 680 | 18 |
2491794 | 2491794 | 2022-05-10 | Scotland | North Carolina | 37165 | 10067 | 132 |
2488139 | 2488139 | 2022-05-09 | Scotland | Missouri | 29199 | 680 | 18 |
2488536 | 2488536 | 2022-05-09 | Scotland | North Carolina | 37165 | 10067 | 132 |
2484882 | 2484882 | 2022-05-08 | Scotland | Missouri | 29199 | 680 | 18 |
2485279 | 2485279 | 2022-05-08 | Scotland | North Carolina | 37165 | 10067 | 132 |
2481624 | 2481624 | 2022-05-07 | Scotland | Missouri | 29199 | 680 | 18 |
2482021 | 2482021 | 2022-05-07 | Scotland | North Carolina | 37165 | 10067 | 132 |
2478366 | 2478366 | 2022-05-06 | Scotland | Missouri | 29199 | 680 | 18 |
2478763 | 2478763 | 2022-05-06 | Scotland | North Carolina | 37165 | 10067 | 132 |
2475108 | 2475108 | 2022-05-05 | Scotland | Missouri | 29199 | 681 | 18 |
2475505 | 2475505 | 2022-05-05 | Scotland | North Carolina | 37165 | 10067 | 132 |
2471851 | 2471851 | 2022-05-04 | Scotland | Missouri | 29199 | 681 | 18 |
2472248 | 2472248 | 2022-05-04 | Scotland | North Carolina | 37165 | 10067 | 132 |
2468595 | 2468595 | 2022-05-03 | Scotland | Missouri | 29199 | 681 | 18 |
2468992 | 2468992 | 2022-05-03 | Scotland | North Carolina | 37165 | 10052 | 126 |
2465339 | 2465339 | 2022-05-02 | Scotland | Missouri | 29199 | 681 | 18 |
2465736 | 2465736 | 2022-05-02 | Scotland | North Carolina | 37165 | 10052 | 126 |
2462084 | 2462084 | 2022-05-01 | Scotland | Missouri | 29199 | 681 | 18 |
2462481 | 2462481 | 2022-05-01 | Scotland | North Carolina | 37165 | 10052 | 126 |
2458828 | 2458828 | 2022-04-30 | Scotland | Missouri | 29199 | 681 | 18 |
2459225 | 2459225 | 2022-04-30 | Scotland | North Carolina | 37165 | 10052 | 126 |
2455572 | 2455572 | 2022-04-29 | Scotland | Missouri | 29199 | 681 | 18 |
2455969 | 2455969 | 2022-04-29 | Scotland | North Carolina | 37165 | 10052 | 126 |
2452316 | 2452316 | 2022-04-28 | Scotland | Missouri | 29199 | 681 | 18 |
2452713 | 2452713 | 2022-04-28 | Scotland | North Carolina | 37165 | 10052 | 126 |
2449060 | 2449060 | 2022-04-27 | Scotland | Missouri | 29199 | 681 | 18 |
2449457 | 2449457 | 2022-04-27 | Scotland | North Carolina | 37165 | 10052 | 126 |
2445803 | 2445803 | 2022-04-26 | Scotland | Missouri | 29199 | 681 | 18 |
2446200 | 2446200 | 2022-04-26 | Scotland | North Carolina | 37165 | 10021 | 126 |
2442548 | 2442548 | 2022-04-25 | Scotland | Missouri | 29199 | 681 | 18 |
2442945 | 2442945 | 2022-04-25 | Scotland | North Carolina | 37165 | 10021 | 126 |
2439292 | 2439292 | 2022-04-24 | Scotland | Missouri | 29199 | 681 | 18 |
2439689 | 2439689 | 2022-04-24 | Scotland | North Carolina | 37165 | 10021 | 126 |
2436036 | 2436036 | 2022-04-23 | Scotland | Missouri | 29199 | 681 | 18 |
2436433 | 2436433 | 2022-04-23 | Scotland | North Carolina | 37165 | 10021 | 126 |
2432780 | 2432780 | 2022-04-22 | Scotland | Missouri | 29199 | 681 | 18 |
2433177 | 2433177 | 2022-04-22 | Scotland | North Carolina | 37165 | 10021 | 126 |
2429524 | 2429524 | 2022-04-21 | Scotland | Missouri | 29199 | 681 | 18 |
2429921 | 2429921 | 2022-04-21 | Scotland | North Carolina | 37165 | 10021 | 126 |
2426268 | 2426268 | 2022-04-20 | Scotland | Missouri | 29199 | 681 | 18 |
2426665 | 2426665 | 2022-04-20 | Scotland | North Carolina | 37165 | 10021 | 126 |
2423012 | 2423012 | 2022-04-19 | Scotland | Missouri | 29199 | 681 | 18 |
2423409 | 2423409 | 2022-04-19 | Scotland | North Carolina | 37165 | 9999 | 126 |
2419755 | 2419755 | 2022-04-18 | Scotland | Missouri | 29199 | 681 | 18 |
2420152 | 2420152 | 2022-04-18 | Scotland | North Carolina | 37165 | 9999 | 126 |
2416500 | 2416500 | 2022-04-17 | Scotland | Missouri | 29199 | 681 | 18 |
2416897 | 2416897 | 2022-04-17 | Scotland | North Carolina | 37165 | 9999 | 126 |
2413244 | 2413244 | 2022-04-16 | Scotland | Missouri | 29199 | 681 | 18 |
2413641 | 2413641 | 2022-04-16 | Scotland | North Carolina | 37165 | 9999 | 126 |
2409988 | 2409988 | 2022-04-15 | Scotland | Missouri | 29199 | 681 | 18 |
2410385 | 2410385 | 2022-04-15 | Scotland | North Carolina | 37165 | 9999 | 126 |
2406732 | 2406732 | 2022-04-14 | Scotland | Missouri | 29199 | 681 | 18 |
2407129 | 2407129 | 2022-04-14 | Scotland | North Carolina | 37165 | 9999 | 126 |
2403476 | 2403476 | 2022-04-13 | Scotland | Missouri | 29199 | 681 | 18 |
2403873 | 2403873 | 2022-04-13 | Scotland | North Carolina | 37165 | 9999 | 126 |
2400221 | 2400221 | 2022-04-12 | Scotland | Missouri | 29199 | 681 | 18 |
2400618 | 2400618 | 2022-04-12 | Scotland | North Carolina | 37165 | 9987 | 126 |
2396966 | 2396966 | 2022-04-11 | Scotland | Missouri | 29199 | 681 | 18 |
2397363 | 2397363 | 2022-04-11 | Scotland | North Carolina | 37165 | 9987 | 126 |
2393711 | 2393711 | 2022-04-10 | Scotland | Missouri | 29199 | 681 | 18 |
2394108 | 2394108 | 2022-04-10 | Scotland | North Carolina | 37165 | 9987 | 126 |
2390455 | 2390455 | 2022-04-09 | Scotland | Missouri | 29199 | 681 | 18 |
2390852 | 2390852 | 2022-04-09 | Scotland | North Carolina | 37165 | 9987 | 126 |
2387199 | 2387199 | 2022-04-08 | Scotland | Missouri | 29199 | 681 | 18 |
2387596 | 2387596 | 2022-04-08 | Scotland | North Carolina | 37165 | 9987 | 126 |
2383944 | 2383944 | 2022-04-07 | Scotland | Missouri | 29199 | 681 | 18 |
2384341 | 2384341 | 2022-04-07 | Scotland | North Carolina | 37165 | 9987 | 126 |
2380689 | 2380689 | 2022-04-06 | Scotland | Missouri | 29199 | 681 | 18 |
2381086 | 2381086 | 2022-04-06 | Scotland | North Carolina | 37165 | 9987 | 126 |
2377434 | 2377434 | 2022-04-05 | Scotland | Missouri | 29199 | 681 | 18 |
2377831 | 2377831 | 2022-04-05 | Scotland | North Carolina | 37165 | 9982 | 126 |
2374181 | 2374181 | 2022-04-04 | Scotland | Missouri | 29199 | 681 | 18 |
2374578 | 2374578 | 2022-04-04 | Scotland | North Carolina | 37165 | 9977 | 126 |
2370929 | 2370929 | 2022-04-03 | Scotland | Missouri | 29199 | 681 | 18 |
2371326 | 2371326 | 2022-04-03 | Scotland | North Carolina | 37165 | 9972 | 126 |
2367676 | 2367676 | 2022-04-02 | Scotland | Missouri | 29199 | 681 | 18 |
2368073 | 2368073 | 2022-04-02 | Scotland | North Carolina | 37165 | 9972 | 126 |
2364423 | 2364423 | 2022-04-01 | Scotland | Missouri | 29199 | 681 | 18 |
2364820 | 2364820 | 2022-04-01 | Scotland | North Carolina | 37165 | 9972 | 126 |
2361169 | 2361169 | 2022-03-31 | Scotland | Missouri | 29199 | 681 | 18 |
2361566 | 2361566 | 2022-03-31 | Scotland | North Carolina | 37165 | 9972 | 126 |
2357915 | 2357915 | 2022-03-30 | Scotland | Missouri | 29199 | 682 | 18 |
2358312 | 2358312 | 2022-03-30 | Scotland | North Carolina | 37165 | 9970 | 126 |
2354662 | 2354662 | 2022-03-29 | Scotland | Missouri | 29199 | 682 | 18 |
2355058 | 2355058 | 2022-03-29 | Scotland | North Carolina | 37165 | 9966 | 126 |
2351409 | 2351409 | 2022-03-28 | Scotland | Missouri | 29199 | 682 | 18 |
2351805 | 2351805 | 2022-03-28 | Scotland | North Carolina | 37165 | 9964 | 126 |
2348157 | 2348157 | 2022-03-27 | Scotland | Missouri | 29199 | 682 | 18 |
2348553 | 2348553 | 2022-03-27 | Scotland | North Carolina | 37165 | 9960 | 126 |
2344904 | 2344904 | 2022-03-26 | Scotland | Missouri | 29199 | 682 | 18 |
2345300 | 2345300 | 2022-03-26 | Scotland | North Carolina | 37165 | 9960 | 126 |
2341651 | 2341651 | 2022-03-25 | Scotland | Missouri | 29199 | 682 | 18 |
2342047 | 2342047 | 2022-03-25 | Scotland | North Carolina | 37165 | 9960 | 126 |
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);