names

50 rows where place_id = 756065

✎ 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
4433753 2175322 2175322 plaintiff Hamelyn John   756065 756065 Hamelyn, John, of Sydemouth 0
4433754 2175322 2175322 defendant Bay Adam   756065 756065 Bay, Adam, of Sydemouth 0
4433755 2175322 2175322 defendant Taillour John   756065 756065 Taillour, John, of Sydemouth 1
4467676 2190569 2190569 defendant Lay John   756065 756065 Lay, John, of Sydemouth 0
4486230 2196400 2196400 defendant Whityng Peter   756065 756065 Whityng, Peter, of Sydemouth 0
4513307 2204578 2204578 plaintiff Brode John   756065 756065 Brode, John, of Sydemouth 0
4513308 2204578 2204578 defendant Gildeon John   756065 756065 Gildeon, John, of Sydemouth 0
4521882 2207184 2207184 defendant Bay Richard   756065 756065 Bay, Richard, of Sydemouth 0
4524842 2208109 2208109 defendant Crouk Nicholas   756065 756065 Crouk, Nicholas, of Sydemouth 2
4526232 2208493 2208493 defendant Benet Robert   756065 756065 Benet, Robert, of Sydemouth 1
4557218 2218191 2218191 defendant Harlewyn John   756065 756065 Harlewyn, John, of Sydemouth 2
4571000 2222496 2222496 defendant Herlewyne John   756065 756065 Herlewyne, John, of Sydemouth 2
4609166 2233972 2233972 defendant Palmere John   756065 756065 Palmere, John, of Sydemouth 0
4664110 2250263 2250263 defendant Herlewyn John merchant 756065 756065 Herlewyn, John, of Sydemouth, merchant 0
4688276 2261901 2261901 defendant Hake John gent 756065 756065 Hake, John, of Sydemouth, gent 1
4737695 2276895 2276895 defendant Marrak Peter merchant 756065 756065 Marrak, Peter, of Sydemouth, merchant 0
4737697 2276895 2276895 defendant Holbrok Henry seaman 756065 756065 Holbrok, Henry, of Sydemouth, seaman 2
4778040 2289118 2289118 defendant Olyver John smith 756065 756065 Olyver, John, of Sydemouth, smith 0
4784452 2291141 2291141 plaintiff Dobell Henry   756065 756065 Dobell, Henry, of Sydemouth 0
4793495 2294074 2294074 defendant Bay Richard yeoman 756065 756065 Bay, Richard, of Sydemouth, yeoman 0
4796207 2294962 2294962 defendant Marenak Peter merchant 756065 756065 Marenak, Peter, of Sydemouth, merchant 0
4797134 2295273 2295273 defendant Bay Richard shipman 756065 756065 Bay, Richard, of Sydemouth, shipman 1
4824143 2303628 2303628 defendant Harlewyn John merchant 756065 756065 Harlewyn, John, of Sydemouth, merchant 0
4824144 2303628 2303628 defendant Harlewyn Richard gent 756065 756065 Harlewyn, Richard, of Sydemouth, gent 1
4824145 2303628 2303628 defendant Lok John shipman 756065 756065 Lok, John, of Sydemouth, shipman 2
4824146 2303628 2303628 defendant Batyn William baker 756065 756065 Batyn, William, of Sydemouth, baker 3
4824147 2303628 2303628 defendant Dole Roger shipman 756065 756065 Dole, Roger, of Sydemouth, shipman 4
4825738 2304090 2304090 defendant Ibbedon John butcher 756065 756065 Ibbedon, John, of Sydemouth, butcher 1
4887528 2322936 2322936 defendant Cole Gilbert butcher 756065 756065 Cole, Gilbert, of Sydemouth, butcher 0
4907131 2328793 2328793 defendant Dun Richard husbandman 756065 756065 Dun, Richard, of Sydemouth, husbandman 1
4934947 2337334 2337334 defendant Marshall John, senior gent 756065 756065 Marshall, John, senior, of Sydemouth, gent 0
4960297 2345052 2345052 defendant atte Fenne Robert fletcher 756065 756065 atte Fenne, Robert, of Sydemouth, fletcher 6
4979996 2350971 2350971 defendant Nytheway Nicholas gent 756065 756065 Nytheway, Nicholas, of Sydemouth, gent 0
5018107 2362181 2362181 defendant Strange Richard laborer 756065 756065 Strange, Richard, of Sydemouth, laborer 0
5024296 2364021 2364021 defendant Lewys William   756065 756065 Lewys, William, of Sydemouth, "fissheionter" 0
5024297 2364021 2364021 defendant Bernebrok John tailor 756065 756065 Bernebrok, John, of Sydemouth, tailor 1
5033160 2366580 2366580 defendant Sparke Thomas husbandman 756065 756065 Sparke, Thomas, of Sydemouth, husbandman 8
5064894 2376031 2376031 defendant Nythewey Nicholas gent 756065 756065 Nythewey, Nicholas, of Sydemouth, gent 1
5079973 2380488 2380488 defendant Marsshall John gent 756065 756065 Marsshall, John, of Sydemouth, gent 0
5080004 2380499 2380499 defendant Sanger John husbandman 756065 756065 Sanger, John, of Sydemouth, husbandman 1
5098610 2386025 2386025 defendant Hampton Henry yeoman 756065 756065 Hampton, Henry, of Sydemouth, yeoman 1
5099231 2386202 2386202 defendant Dene alias Hampton Henry merchant 756065 756065 Dene alias Hampton, Henry, of Sydemouth, or of Crokern, Soms, merchant 2
5112331 2389993 2389993 defendant Goulde John husbandman 756065 756065 Goulde, John, of Sydemouth, husbandman 1
5259286 2433022 2433022 defendant Bowyer Thomas mercer 756065 756065 Bowyer, Thomas, of Sydemouth, mercer 0
5264525 2434659 2434659 defendant Havyll or Hanyll John mariner 756065 756065 Havyll or Hanyll, John, of Sydemouth, mariner 0
5264526 2434659 2434659 defendant Trent William mariner 756065 756065 Trent, William, of Sydemouth, mariner 1
5290041 2442092 2442092 defendant Bowyer John chapman 756065 756065 Bowyer, John, of Sydemouth, chapman 0
5322776 2451889 2451889 defendant Smyth John husbandman 756065 756065 Smyth, John, of Sydemouth, husbandman 1
5322777 2451889 2451889 defendant Goolde John husbandman 756065 756065 Goolde, John, of Sydemouth, husbandman 2
5363960 2464381 2464381 defendant Forster Emma widow 756065 756065 Forster, Emma, of Sydemouth, widow 2

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);