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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- New Jersey 789
- Maryland 784
- Pennsylvania 781
- Maine 676
county 1
- Somerset · 3,030 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
310377 | 310377 | 2020-07-07 | Somerset | Maine | 23025 | 30 | 0 |
313547 | 313547 | 2020-07-08 | Somerset | Maine | 23025 | 30 | 0 |
316721 | 316721 | 2020-07-09 | Somerset | Maine | 23025 | 31 | 0 |
319896 | 319896 | 2020-07-10 | Somerset | Maine | 23025 | 31 | 0 |
323075 | 323075 | 2020-07-11 | Somerset | Maine | 23025 | 31 | 0 |
326258 | 326258 | 2020-07-12 | Somerset | Maine | 23025 | 31 | 0 |
329444 | 329444 | 2020-07-13 | Somerset | Maine | 23025 | 31 | 0 |
332631 | 332631 | 2020-07-14 | Somerset | Maine | 23025 | 31 | 0 |
335824 | 335824 | 2020-07-15 | Somerset | Maine | 23025 | 31 | 0 |
339020 | 339020 | 2020-07-16 | Somerset | Maine | 23025 | 31 | 0 |
342216 | 342216 | 2020-07-17 | Somerset | Maine | 23025 | 32 | 0 |
345416 | 345416 | 2020-07-18 | Somerset | Maine | 23025 | 32 | 0 |
348617 | 348617 | 2020-07-19 | Somerset | Maine | 23025 | 32 | 0 |
351817 | 351817 | 2020-07-20 | Somerset | Maine | 23025 | 33 | 0 |
355019 | 355019 | 2020-07-21 | Somerset | Maine | 23025 | 33 | 0 |
358222 | 358222 | 2020-07-22 | Somerset | Maine | 23025 | 32 | 0 |
361427 | 361427 | 2020-07-23 | Somerset | Maine | 23025 | 32 | 0 |
364634 | 364634 | 2020-07-24 | Somerset | Maine | 23025 | 33 | 0 |
367841 | 367841 | 2020-07-25 | Somerset | Maine | 23025 | 34 | 1 |
371051 | 371051 | 2020-07-26 | Somerset | Maine | 23025 | 34 | 1 |
374263 | 374263 | 2020-07-27 | Somerset | Maine | 23025 | 34 | 1 |
377478 | 377478 | 2020-07-28 | Somerset | Maine | 23025 | 34 | 1 |
380695 | 380695 | 2020-07-29 | Somerset | Maine | 23025 | 34 | 1 |
383912 | 383912 | 2020-07-30 | Somerset | Maine | 23025 | 34 | 1 |
387130 | 387130 | 2020-07-31 | Somerset | Maine | 23025 | 34 | 1 |
390347 | 390347 | 2020-08-01 | Somerset | Maine | 23025 | 34 | 1 |
393564 | 393564 | 2020-08-02 | Somerset | Maine | 23025 | 34 | 1 |
396780 | 396780 | 2020-08-03 | Somerset | Maine | 23025 | 34 | 1 |
399995 | 399995 | 2020-08-04 | Somerset | Maine | 23025 | 34 | 1 |
403212 | 403212 | 2020-08-05 | Somerset | Maine | 23025 | 34 | 1 |
406430 | 406430 | 2020-08-06 | Somerset | Maine | 23025 | 33 | 1 |
409650 | 409650 | 2020-08-07 | Somerset | Maine | 23025 | 33 | 1 |
412870 | 412870 | 2020-08-08 | Somerset | Maine | 23025 | 33 | 1 |
416090 | 416090 | 2020-08-09 | Somerset | Maine | 23025 | 33 | 1 |
419311 | 419311 | 2020-08-10 | Somerset | Maine | 23025 | 33 | 1 |
422533 | 422533 | 2020-08-11 | Somerset | Maine | 23025 | 33 | 1 |
425754 | 425754 | 2020-08-12 | Somerset | Maine | 23025 | 33 | 1 |
428978 | 428978 | 2020-08-13 | Somerset | Maine | 23025 | 35 | 1 |
432206 | 432206 | 2020-08-14 | Somerset | Maine | 23025 | 35 | 1 |
435431 | 435431 | 2020-08-15 | Somerset | Maine | 23025 | 36 | 1 |
438656 | 438656 | 2020-08-16 | Somerset | Maine | 23025 | 37 | 1 |
441883 | 441883 | 2020-08-17 | Somerset | Maine | 23025 | 40 | 1 |
445109 | 445109 | 2020-08-18 | Somerset | Maine | 23025 | 40 | 1 |
448336 | 448336 | 2020-08-19 | Somerset | Maine | 23025 | 41 | 1 |
451564 | 451564 | 2020-08-20 | Somerset | Maine | 23025 | 42 | 1 |
454792 | 454792 | 2020-08-21 | Somerset | Maine | 23025 | 42 | 1 |
458020 | 458020 | 2020-08-22 | Somerset | Maine | 23025 | 42 | 1 |
461247 | 461247 | 2020-08-23 | Somerset | Maine | 23025 | 46 | 1 |
464478 | 464478 | 2020-08-24 | Somerset | Maine | 23025 | 46 | 1 |
467707 | 467707 | 2020-08-25 | Somerset | Maine | 23025 | 46 | 1 |
470936 | 470936 | 2020-08-26 | Somerset | Maine | 23025 | 47 | 1 |
474168 | 474168 | 2020-08-27 | Somerset | Maine | 23025 | 50 | 1 |
477401 | 477401 | 2020-08-28 | Somerset | Maine | 23025 | 50 | 1 |
480634 | 480634 | 2020-08-29 | Somerset | Maine | 23025 | 50 | 1 |
483868 | 483868 | 2020-08-30 | Somerset | Maine | 23025 | 51 | 1 |
487103 | 487103 | 2020-08-31 | Somerset | Maine | 23025 | 51 | 1 |
490336 | 490336 | 2020-09-01 | Somerset | Maine | 23025 | 54 | 1 |
493570 | 493570 | 2020-09-02 | Somerset | Maine | 23025 | 54 | 2 |
496803 | 496803 | 2020-09-03 | Somerset | Maine | 23025 | 58 | 2 |
500037 | 500037 | 2020-09-04 | Somerset | Maine | 23025 | 61 | 3 |
503270 | 503270 | 2020-09-05 | Somerset | Maine | 23025 | 62 | 3 |
506504 | 506504 | 2020-09-06 | Somerset | Maine | 23025 | 62 | 3 |
509737 | 509737 | 2020-09-07 | Somerset | Maine | 23025 | 62 | 3 |
512969 | 512969 | 2020-09-08 | Somerset | Maine | 23025 | 63 | 3 |
516202 | 516202 | 2020-09-09 | Somerset | Maine | 23025 | 65 | 3 |
519437 | 519437 | 2020-09-10 | Somerset | Maine | 23025 | 69 | 3 |
522674 | 522674 | 2020-09-11 | Somerset | Maine | 23025 | 69 | 3 |
525910 | 525910 | 2020-09-12 | Somerset | Maine | 23025 | 74 | 4 |
529146 | 529146 | 2020-09-13 | Somerset | Maine | 23025 | 74 | 5 |
532383 | 532383 | 2020-09-14 | Somerset | Maine | 23025 | 85 | 5 |
535618 | 535618 | 2020-09-15 | Somerset | Maine | 23025 | 85 | 6 |
538855 | 538855 | 2020-09-16 | Somerset | Maine | 23025 | 85 | 7 |
542091 | 542091 | 2020-09-17 | Somerset | Maine | 23025 | 85 | 7 |
545327 | 545327 | 2020-09-18 | Somerset | Maine | 23025 | 85 | 7 |
548565 | 548565 | 2020-09-19 | Somerset | Maine | 23025 | 85 | 8 |
551804 | 551804 | 2020-09-20 | Somerset | Maine | 23025 | 86 | 8 |
555043 | 555043 | 2020-09-21 | Somerset | Maine | 23025 | 86 | 8 |
558280 | 558280 | 2020-09-22 | Somerset | Maine | 23025 | 86 | 8 |
561516 | 561516 | 2020-09-23 | Somerset | Maine | 23025 | 85 | 8 |
564756 | 564756 | 2020-09-24 | Somerset | Maine | 23025 | 85 | 8 |
567996 | 567996 | 2020-09-25 | Somerset | Maine | 23025 | 84 | 8 |
571238 | 571238 | 2020-09-26 | Somerset | Maine | 23025 | 85 | 8 |
574481 | 574481 | 2020-09-27 | Somerset | Maine | 23025 | 86 | 8 |
577723 | 577723 | 2020-09-28 | Somerset | Maine | 23025 | 86 | 8 |
580964 | 580964 | 2020-09-29 | Somerset | Maine | 23025 | 86 | 8 |
584204 | 584204 | 2020-09-30 | Somerset | Maine | 23025 | 86 | 8 |
587444 | 587444 | 2020-10-01 | Somerset | Maine | 23025 | 86 | 8 |
590685 | 590685 | 2020-10-02 | Somerset | Maine | 23025 | 86 | 8 |
593926 | 593926 | 2020-10-03 | Somerset | Maine | 23025 | 86 | 8 |
597168 | 597168 | 2020-10-04 | Somerset | Maine | 23025 | 86 | 8 |
600410 | 600410 | 2020-10-05 | Somerset | Maine | 23025 | 88 | 8 |
603653 | 603653 | 2020-10-06 | Somerset | Maine | 23025 | 92 | 8 |
606895 | 606895 | 2020-10-07 | Somerset | Maine | 23025 | 96 | 8 |
610137 | 610137 | 2020-10-08 | Somerset | Maine | 23025 | 99 | 8 |
613379 | 613379 | 2020-10-09 | Somerset | Maine | 23025 | 103 | 8 |
616620 | 616620 | 2020-10-10 | Somerset | Maine | 23025 | 108 | 8 |
619862 | 619862 | 2020-10-11 | Somerset | Maine | 23025 | 112 | 8 |
623106 | 623106 | 2020-10-12 | Somerset | Maine | 23025 | 118 | 8 |
626348 | 626348 | 2020-10-13 | Somerset | Maine | 23025 | 123 | 8 |
629592 | 629592 | 2020-10-14 | Somerset | Maine | 23025 | 128 | 8 |
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);