names

41 rows where place_id = 611030

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686423 1921908 1921908 defendant Athelard Robert husbandman 611030 611030 Athelard, Robert, of North Cove, husbandman 0
3741857 1939318 1939318 defendant Hamond James husbandman 611030 611030 Hamond, James, of North Cove, husbandman 0
3841277 1970854 1970854 defendant Elmy Henry husbandman 611030 611030 Elmy, Henry, of North Cove, husbandman 0
3852380 1974345 1974345 defendant Barry John carpenter 611030 611030 Barry, John, of North Cove, carpenter 2
3852381 1974345 1974345 defendant Goddaye Richard laborer 611030 611030 Goddaye, Richard, of North Cove, laborer 3
4248239 2112402 2112402 defendant Askewe John carpenter 611030 611030 Askewe, John, of North Cove, carpenter 2
4258930 2115958 2115958 defendant Kene John gent 611030 611030 Kene, John, of North Cove, gent 1
4628725 2239910 2239910 plaintiff Shypman William   611030 611030 Shypman, William, of North Cove 1
4628726 2239910 2239910 defendant Borhed Alan   611030 611030 Borhed, Alan, of North Cove 0
4724880 2273076 2273076 defendant Seman William husbandman 611030 611030 Seman, William, of North Cove, husbandman 2
4724881 2273076 2273076 defendant Prymour Andrew yeoman 611030 611030 Prymour, Andrew, of North Cove, yeoman 3
4761960 2284088 2284088 defendant Premon_ Andrew yeoman 611030 611030 Premon_, Andrew, of North Cove, yeoman 1
4762295 2284187 2284187 defendant Prymour Andrew yeoman 611030 611030 Prymour, Andrew, of North Cove, yeoman 0
4844896 2309923 2309923 defendant Eppe Thomas   611030 611030 Eppe, Thomas, of North Cove, parson 2
4978013 2350388 2350388 defendant Cove William gent 611030 611030 Cove, William, of North Cove, gent 0
5037561 2367860 2367860 defendant Premour Andrew husbandman 611030 611030 Premour, Andrew, of North Cove, husbandman 0
5098147 2385891 2385891 defendant Chafyn Edgar clerk 611030 611030 Chafyn, Edgar, of North Cove, clerk 0
5142458 2398921 2398921 defendant Dassh John clerk 611030 611030 Dassh, John, of North Cove, clerk 0
5163773 2405138 2405138 defendant Dassh John clerk 611030 611030 Dassh, John, of North Cove, clerk 0
5199246 2415533 2415533 defendant Somersale Thomas husbandman 611030 611030 Somersale, Thomas, of North Cove, husbandman 0
5200191 2415813 2415813 defendant Dassh John clerk 611030 611030 Dassh, John, of North Cove, clerk 0
5211026 2418957 2418957 defendant Somersale Thomas husbandman 611030 611030 Somersale, Thomas, of North Cove, husbandman 0
5271937 2436875 2436875 defendant Toke William laborer 611030 611030 Toke, William, of North Cove, laborer 0
5271938 2436875 2436875 defendant Toke John laborer 611030 611030 Toke, John, of North Cove, laborer 1
5502357 2505662 2505662 defendant Smyth John clerk 611030 611030 Smyth, John, of North Cove, clerk 0
5512396 2508738 2508738 defendant Alwyn Thomas husbandman 611030 611030 Alwyn, Thomas, of North Cove, husbandman 0
5516814 2510078 2510078 defendant Smyth John clerk 611030 611030 Smyth, John, of North Cove, clerk 0
5516817 2510079 2510079 defendant Smyth John clerk 611030 611030 Smyth, John, of North Cove, clerk 0
5525172 2512466 2512466 defendant Gernegam John gent 611030 611030 Gernegam, John, of North Cove, gent 0
5532102 2514585 2514585 plaintiff Syngylton Thomas (legal representative) 611030 611030 Syngylton, Thomas, of North Cove, executrix of 0
5546144 2518864 2518864 plaintiff Syngilton Thomas (legal representative) 611030 611030 Syngilton, Thomas, of North Cove, executrix of 0
5547500 2519287 2519287 defendant Seyntwary Richard scrivener 611030 611030 Seyntwary, Richard, of North Cove, scrivener 0
5559238 2522667 2522667 defendant Doo John yeoman 611030 611030 Doo, John, of North Cove, yeoman 0
5559289 2522685 2522685 defendant Coryour John husbandman 611030 611030 Coryour, John, of North Cove, husbandman 3
5560857 2523147 2523147 defendant Grevall John yeoman 611030 611030 Grevall, John, of North Cove, yeoman 0
5560858 2523147 2523147 defendant Sayntwary Richard yeoman 611030 611030 Sayntwary, Richard, of North Cove, yeoman 1
5560861 2523148 2523148 defendant Grevall John yeoman 611030 611030 Grevall, John, of North Cove, yeoman 0
5560862 2523148 2523148 defendant Sayntwary Richard yeoman 611030 611030 Sayntwary, Richard, of North Cove, yeoman 1
5596355 2533771 2533771 defendant Grevall or Grenall John gent 611030 611030 Grevall or Grenall, John, of North Cove, gent 2
5605104 2536467 2536467 defendant Pratt John yeoman 611030 611030 Pratt, John, of North Cove, yeoman 1
5608040 2537423 2537423 defendant Grevall or Grenall John husbandman 611030 611030 Grevall or Grenall, John, of North Cove, husbandman 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);