ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,130 rows where county = "Somerset" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 549 ✖
- 0 233
- 3 192
- 1 118
- 8 68
- 846 59
- 37 55
- 40 55
- 4 48
- 26 42
- 219 42
- 27 41
- 73 41
- 34 39
- 42 38
- 54 38
- 33 33
- 55 31
- 218 30
- 74 29
- 20 28
- 29 28
- 101 28
- 30 24
- 2 23
- 32 23
- 5 21
- 35 21
- 21 19
- 41 19
- 52 19
- 67 19
- 186 19
- 9 18
- 31 18
- 38 18
- 6 17
- 25 17
- 70 17
- 187 17
- 46 16
- 69 15
- 22 14
- 28 14
- 396 14
- 24 13
- 43 13
- 44 13
- 45 13
- 104 13
- 973 13
- 408 12
- 960 12
- 62 11
- 66 11
- 103 11
- 185 11
- 220 11
- 19 10
- 60 10
- 102 10
- 405 10
- 566 10
- 7 9
- 23 9
- 878 9
- 36 8
- 47 8
- 57 8
- 564 8
- 568 8
- 838 8
- 845 8
- 881 8
- 970 8
- 972 8
- 15 7
- 71 7
- 79 7
- 80 7
- 222 7
- 399 7
- 848 7
- 849 7
- 876 7
- 966 7
- 967 7
- 11 6
- 12 6
- 13 6
- 48 6
- 50 6
- 58 6
- 64 6
- 72 6
- 78 6
- 87 6
- 99 6
- 190 6
- 201 6
- 207 6
- 212 6
- 213 6
- 226 6
- 394 6
- 398 6
- 404 6
- 406 6
- 553 6
- 567 6
- 573 6
- 577 6
- 592 6
- 609 6
- 864 6
- 10 5
- 51 5
- 56 5
- 192 5
- 193 5
- 208 5
- 253 5
- 267 5
- 271 5
- 356 5
- 387 5
- 391 5
- 407 5
- 438 5
- 565 5
- 569 5
- 595 5
- 613 5
- 798 5
- 803 5
- 807 5
- 815 5
- 850 5
- 863 5
- 868 5
- 871 5
- 874 5
- 962 5
- 965 5
- 971 5
- 975 5
- 61 4
- 77 4
- 86 4
- 88 4
- 92 4
- 109 4
- 110 4
- 176 4
- 195 4
- 196 4
- 205 4
- 216 4
- 225 4
- 235 4
- 241 4
- 293 4
- 317 4
- 361 4
- 401 4
- 551 4
- 555 4
- 561 4
- 599 4
- 607 4
- 628 4
- 776 4
- 788 4
- 810 4
- 834 4
- 840 4
- 842 4
- 884 4
- 885 4
- 887 4
- 888 4
- 899 4
- 902 4
- 904 4
- 919 4
- 955 4
- 959 4
- 14 3
- 18 3
- 63 3
- 90 3
- 181 3
- 191 3
- 217 3
- 223 3
- 227 3
- 229 3
- 259 3
- 274 3
- 280 3
- 303 3
- 330 3
- 345 3
- 370 3
- 385 3
- 400 3
- 402 3
- 419 3
- 524 3
- 528 3
- 550 3
- 554 3
- 562 3
- 588 3
- 600 3
- 604 3
- 758 3
- 800 3
- 835 3
- 837 3
- 853 3
- 862 3
- 873 3
- 901 3
- 929 3
- 939 3
- 16 2
- 65 2
- 68 2
- 84 2
- 85 2
- 89 2
- 97 2
- 105 2
- 143 2
- 146 2
- 183 2
- 184 2
- 188 2
- 198 2
- 203 2
- 209 2
- 214 2
- 228 2
- 243 2
- 248 2
- 252 2
- 257 2
- 269 2
- 272 2
- 276 2
- 289 2
- 300 2
- 315 2
- 328 2
- 331 2
- 333 2
- 349 2
- 359 2
- 363 2
- 375 2
- 381 2
- 397 2
- 423 2
- 437 2
- 527 2
- 529 2
- 558 2
- 582 2
- 584 2
- 590 2
- 594 2
- 601 2
- 605 2
- 640 2
- 657 2
- 658 2
- 693 2
- 708 2
- 710 2
- 724 2
- 744 2
- 745 2
- 750 2
- 769 2
- 772 2
- 777 2
- 783 2
- 789 2
- 801 2
- 804 2
- 806 2
- 809 2
- 813 2
- 818 2
- 820 2
- 825 2
- 828 2
- 833 2
- 847 2
- 851 2
- 856 2
- 860 2
- 870 2
- 883 2
- 886 2
- 890 2
- 895 2
- 896 2
- 906 2
- 909 2
- 911 2
- 912 2
- 915 2
- 936 2
- 949 2
- 950 2
- 953 2
- 961 2
- 17 1
- 53 1
- 59 1
- 81 1
- 82 1
- 91 1
- 94 1
- 95 1
- 98 1
- 100 1
- 106 1
- 107 1
- 111 1
- 113 1
- 117 1
- 121 1
- 125 1
- 132 1
- 135 1
- 142 1
- 150 1
- 153 1
- 154 1
- 158 1
- 159 1
- 160 1
- 162 1
- 166 1
- 170 1
- 171 1
- 173 1
- 175 1
- 179 1
- 182 1
- 189 1
- 200 1
- 202 1
- 210 1
- 211 1
- 215 1
- 221 1
- 230 1
- 233 1
- 234 1
- 237 1
- 239 1
- 242 1
- 244 1
- 246 1
- 247 1
- 249 1
- 250 1
- 254 1
- 258 1
- 261 1
- 266 1
- 270 1
- 277 1
- 278 1
- 279 1
- 281 1
- 282 1
- 284 1
- 286 1
- 291 1
- 295 1
- 298 1
- 299 1
- 306 1
- 308 1
- 311 1
- 318 1
- 320 1
- 323 1
- 334 1
- 335 1
- 337 1
- 339 1
- 340 1
- 343 1
- 348 1
- 353 1
- 355 1
- 364 1
- 368 1
- 369 1
- 374 1
- 376 1
- 378 1
- 379 1
- 380 1
- 382 1
- 384 1
- 386 1
- 389 1
- 390 1
- 392 1
- 403 1
- 410 1
- 411 1
- 417 1
- 424 1
- 425 1
- 426 1
- 427 1
- 430 1
- 431 1
- 432 1
- 433 1
- 436 1
- 439 1
- 440 1
- 441 1
- 444 1
- 530 1
- 531 1
- 535 1
- 537 1
- 544 1
- 549 1
- 552 1
- 556 1
- 557 1
- 572 1
- 578 1
- 579 1
- 581 1
- 586 1
- 587 1
- 589 1
- 593 1
- 597 1
- 598 1
- 608 1
- 610 1
- 614 1
- 618 1
- 624 1
- 626 1
- 633 1
- 641 1
- 642 1
- 643 1
- 645 1
- 647 1
- 652 1
- 654 1
- 659 1
- 662 1
- 664 1
- 666 1
- 667 1
- 668 1
- 669 1
- 673 1
- 683 1
- 689 1
- 691 1
- 694 1
- 704 1
- 706 1
- 709 1
- 712 1
- 713 1
- 715 1
- 718 1
- 723 1
- 731 1
- 738 1
- 740 1
- 743 1
- 755 1
- 756 1
- 757 1
- 764 1
- 765 1
- 771 1
- 778 1
- 779 1
- 780 1
- 782 1
- 785 1
- 786 1
- 787 1
- 792 1
- 796 1
- 811 1
- 812 1
- 816 1
- 817 1
- 821 1
- 822 1
- 827 1
- 836 1
- 843 1
- 844 1
- 854 1
- 855 1
- 859 1
- 861 1
- 865 1
- 866 1
- 867 1
- 889 1
- 891 1
- 892 1
- 894 1
- 897 1
- 900 1
- 903 1
- 905 1
- 907 1
- 913 1
- 916 1
- 918 1
- 921 1
- 923 1
- 927 1
- 933 1
- 934 1
- 941 1
- 942 1
- 944 1
- 946 1
- 951 1
- 952 1
- 956 1
- 958 1
- 963 1
- 964 1
- 969 1
state 4
- New Jersey 789
- Maryland 784
- Pennsylvania 781
- Maine 776
county 1
- Somerset · 3,130 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500776 | 2500776 | 2022-05-13 | Somerset | Maine | 23025 | 10213 | 110 |
2500799 | 2500799 | 2022-05-13 | Somerset | Maryland | 24039 | 5267 | 74 |
2501389 | 2501389 | 2022-05-13 | Somerset | New Jersey | 34035 | 72382 | 975 |
2501902 | 2501902 | 2022-05-13 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
2497518 | 2497518 | 2022-05-12 | Somerset | Maine | 23025 | 10196 | 110 |
2497541 | 2497541 | 2022-05-12 | Somerset | Maryland | 24039 | 5254 | 74 |
2498131 | 2498131 | 2022-05-12 | Somerset | New Jersey | 34035 | 72097 | 975 |
2498644 | 2498644 | 2022-05-12 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
2494260 | 2494260 | 2022-05-11 | Somerset | Maine | 23025 | 10175 | 110 |
2494283 | 2494283 | 2022-05-11 | Somerset | Maryland | 24039 | 5250 | 74 |
2494873 | 2494873 | 2022-05-11 | Somerset | New Jersey | 34035 | 71849 | 975 |
2495386 | 2495386 | 2022-05-11 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
2491002 | 2491002 | 2022-05-10 | Somerset | Maine | 23025 | 10161 | 110 |
2491025 | 2491025 | 2022-05-10 | Somerset | Maryland | 24039 | 5246 | 74 |
2491615 | 2491615 | 2022-05-10 | Somerset | New Jersey | 34035 | 71645 | 975 |
2492128 | 2492128 | 2022-05-10 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2487745 | 2487745 | 2022-05-09 | Somerset | Maine | 23025 | 10130 | 109 |
2487768 | 2487768 | 2022-05-09 | Somerset | Maryland | 24039 | 5237 | 74 |
2488357 | 2488357 | 2022-05-09 | Somerset | New Jersey | 34035 | 71416 | 975 |
2488870 | 2488870 | 2022-05-09 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2484487 | 2484487 | 2022-05-08 | Somerset | Maine | 23025 | 10115 | 109 |
2484510 | 2484510 | 2022-05-08 | Somerset | Maryland | 24039 | 5234 | 74 |
2485100 | 2485100 | 2022-05-08 | Somerset | New Jersey | 34035 | 71326 | 973 |
2485613 | 2485613 | 2022-05-08 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2481229 | 2481229 | 2022-05-07 | Somerset | Maine | 23025 | 10115 | 109 |
2481252 | 2481252 | 2022-05-07 | Somerset | Maryland | 24039 | 5234 | 74 |
2481842 | 2481842 | 2022-05-07 | Somerset | New Jersey | 34035 | 71193 | 973 |
2482355 | 2482355 | 2022-05-07 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2477971 | 2477971 | 2022-05-06 | Somerset | Maine | 23025 | 10091 | 107 |
2477994 | 2477994 | 2022-05-06 | Somerset | Maryland | 24039 | 5234 | 74 |
2478584 | 2478584 | 2022-05-06 | Somerset | New Jersey | 34035 | 71037 | 973 |
2479097 | 2479097 | 2022-05-06 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2474713 | 2474713 | 2022-05-05 | Somerset | Maine | 23025 | 10068 | 105 |
2474736 | 2474736 | 2022-05-05 | Somerset | Maryland | 24039 | 5232 | 74 |
2475326 | 2475326 | 2022-05-05 | Somerset | New Jersey | 34035 | 70822 | 973 |
2475839 | 2475839 | 2022-05-05 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2471456 | 2471456 | 2022-05-04 | Somerset | Maine | 23025 | 10048 | 105 |
2471479 | 2471479 | 2022-05-04 | Somerset | Maryland | 24039 | 5232 | 74 |
2472069 | 2472069 | 2022-05-04 | Somerset | New Jersey | 34035 | 70623 | 972 |
2472582 | 2472582 | 2022-05-04 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2468200 | 2468200 | 2022-05-03 | Somerset | Maine | 23025 | 10020 | 104 |
2468223 | 2468223 | 2022-05-03 | Somerset | Maryland | 24039 | 5228 | 74 |
2468813 | 2468813 | 2022-05-03 | Somerset | New Jersey | 34035 | 70463 | 973 |
2469326 | 2469326 | 2022-05-03 | Somerset | Pennsylvania | 42111 | 18788 | 408 |
2464945 | 2464945 | 2022-05-02 | Somerset | Maine | 23025 | 9983 | 104 |
2464968 | 2464968 | 2022-05-02 | Somerset | Maryland | 24039 | 5224 | 74 |
2465557 | 2465557 | 2022-05-02 | Somerset | New Jersey | 34035 | 70328 | 973 |
2466070 | 2466070 | 2022-05-02 | Somerset | Pennsylvania | 42111 | 18786 | 407 |
2461689 | 2461689 | 2022-05-01 | Somerset | Maine | 23025 | 9959 | 104 |
2461712 | 2461712 | 2022-05-01 | Somerset | Maryland | 24039 | 5222 | 74 |
2462302 | 2462302 | 2022-05-01 | Somerset | New Jersey | 34035 | 70242 | 973 |
2462815 | 2462815 | 2022-05-01 | Somerset | Pennsylvania | 42111 | 18782 | 407 |
2458433 | 2458433 | 2022-04-30 | Somerset | Maine | 23025 | 9959 | 104 |
2458456 | 2458456 | 2022-04-30 | Somerset | Maryland | 24039 | 5222 | 74 |
2459046 | 2459046 | 2022-04-30 | Somerset | New Jersey | 34035 | 70140 | 973 |
2459559 | 2459559 | 2022-04-30 | Somerset | Pennsylvania | 42111 | 18775 | 407 |
2455177 | 2455177 | 2022-04-29 | Somerset | Maine | 23025 | 9943 | 104 |
2455200 | 2455200 | 2022-04-29 | Somerset | Maryland | 24039 | 5222 | 74 |
2455790 | 2455790 | 2022-04-29 | Somerset | New Jersey | 34035 | 70006 | 973 |
2456303 | 2456303 | 2022-04-29 | Somerset | Pennsylvania | 42111 | 18771 | 407 |
2451921 | 2451921 | 2022-04-28 | Somerset | Maine | 23025 | 9920 | 104 |
2451944 | 2451944 | 2022-04-28 | Somerset | Maryland | 24039 | 5219 | 74 |
2452534 | 2452534 | 2022-04-28 | Somerset | New Jersey | 34035 | 69837 | 973 |
2453047 | 2453047 | 2022-04-28 | Somerset | Pennsylvania | 42111 | 18764 | 407 |
2448665 | 2448665 | 2022-04-27 | Somerset | Maine | 23025 | 9913 | 104 |
2448688 | 2448688 | 2022-04-27 | Somerset | Maryland | 24039 | 5216 | 74 |
2449278 | 2449278 | 2022-04-27 | Somerset | New Jersey | 34035 | 69703 | 973 |
2449791 | 2449791 | 2022-04-27 | Somerset | Pennsylvania | 42111 | 18761 | 406 |
2445409 | 2445409 | 2022-04-26 | Somerset | Maine | 23025 | 9888 | 104 |
2445432 | 2445432 | 2022-04-26 | Somerset | Maryland | 24039 | 5217 | 74 |
2446021 | 2446021 | 2022-04-26 | Somerset | New Jersey | 34035 | 69570 | 973 |
2446534 | 2446534 | 2022-04-26 | Somerset | Pennsylvania | 42111 | 18759 | 406 |
2442153 | 2442153 | 2022-04-25 | Somerset | Maine | 23025 | 9860 | 104 |
2442176 | 2442176 | 2022-04-25 | Somerset | Maryland | 24039 | 5215 | 74 |
2442766 | 2442766 | 2022-04-25 | Somerset | New Jersey | 34035 | 69466 | 973 |
2443279 | 2443279 | 2022-04-25 | Somerset | Pennsylvania | 42111 | 18755 | 406 |
2438897 | 2438897 | 2022-04-24 | Somerset | Maine | 23025 | 9860 | 104 |
2438920 | 2438920 | 2022-04-24 | Somerset | Maryland | 24039 | 5213 | 74 |
2439510 | 2439510 | 2022-04-24 | Somerset | New Jersey | 34035 | 69412 | 972 |
2440023 | 2440023 | 2022-04-24 | Somerset | Pennsylvania | 42111 | 18754 | 406 |
2435641 | 2435641 | 2022-04-23 | Somerset | Maine | 23025 | 9860 | 104 |
2435664 | 2435664 | 2022-04-23 | Somerset | Maryland | 24039 | 5213 | 74 |
2436254 | 2436254 | 2022-04-23 | Somerset | New Jersey | 34035 | 69346 | 972 |
2436767 | 2436767 | 2022-04-23 | Somerset | Pennsylvania | 42111 | 18753 | 406 |
2432385 | 2432385 | 2022-04-22 | Somerset | Maine | 23025 | 9848 | 104 |
2432408 | 2432408 | 2022-04-22 | Somerset | Maryland | 24039 | 5213 | 74 |
2432998 | 2432998 | 2022-04-22 | Somerset | New Jersey | 34035 | 69237 | 972 |
2433511 | 2433511 | 2022-04-22 | Somerset | Pennsylvania | 42111 | 18750 | 406 |
2429129 | 2429129 | 2022-04-21 | Somerset | Maine | 23025 | 9837 | 104 |
2429152 | 2429152 | 2022-04-21 | Somerset | Maryland | 24039 | 5213 | 74 |
2429742 | 2429742 | 2022-04-21 | Somerset | New Jersey | 34035 | 69065 | 972 |
2430255 | 2430255 | 2022-04-21 | Somerset | Pennsylvania | 42111 | 18743 | 405 |
2425873 | 2425873 | 2022-04-20 | Somerset | Maine | 23025 | 9831 | 103 |
2425896 | 2425896 | 2022-04-20 | Somerset | Maryland | 24039 | 5213 | 74 |
2426486 | 2426486 | 2022-04-20 | Somerset | New Jersey | 34035 | 68962 | 972 |
2426999 | 2426999 | 2022-04-20 | Somerset | Pennsylvania | 42111 | 18735 | 405 |
2422617 | 2422617 | 2022-04-19 | Somerset | Maine | 23025 | 9779 | 103 |
2422640 | 2422640 | 2022-04-19 | Somerset | Maryland | 24039 | 5215 | 74 |
2423230 | 2423230 | 2022-04-19 | Somerset | New Jersey | 34035 | 68862 | 972 |
2423743 | 2423743 | 2022-04-19 | Somerset | Pennsylvania | 42111 | 18729 | 405 |
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);