names

38 rows where place_id = 638395

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3842223 1971112 1971112 defendant Dyer John husbandman 638395 638395 Dyer, John, of Martock, husbandman 0
3869050 1979894 1979894 defendant Nurse Nicholas clerk 638395 638395 Nurse, Nicholas, of Martock, clerk 0
3882879 1984539 1984539 defendant Nursse Stephen clerk 638395 638395 Nursse, Stephen, of Martock, clerk 0
3920818 1997309 1997309 defendant Shyrwoode William smith 638395 638395 Shyrwoode, William, of Martock, smith 0
3949119 2006754 2006754 defendant Sprake Robert yeoman 638395 638395 (Sprake, Robert, of Martock, yeoman 1
3956299 2009265 2009265 defendant Cole William butcher 638395 638395 Cole, William, of Martock, butcher 1
3958754 2010138 2010138 defendant Cole William butcher 638395 638395 Cole, William, of Martock, butcher 0
4063800 2047338 2047338 defendant Gold John yeoman 638395 638395 Gold, John, of Martock, yeoman 0
4097594 2059468 2059468 defendant Popham George gent 638395 638395 Popham, George, of Martock, or of Bridgewater, gent 0
4097595 2059468 2059468 defendant Popham John gent 638395 638395 Popham, John, of Martock, or of Dunware, Bridgewater, gent 1
4097596 2059468 2059468 defendant Courte John husbandman 638395 638395 Courte, John, of Martock, yeoman, or of Moreland, Middlesoy, husbandman 2
4105371 2062201 2062201 defendant Cannon Stephen butcher 638395 638395 Cannon, Stephen, of Martock, butcher 3
4111954 2064525 2064525 defendant Prygge John yeoman 638395 638395 Prygge, John, of Martock, or of Mochelney, yeoman 0
4209037 2098712 2098712 defendant Jeves Thomas yeoman 638395 638395 Jeves, Thomas, of Martock, yeoman 0
4209038 2098712 2098712 defendant Pownd alias Sugar Alexander yeoman 638395 638395 Pownd alias Sugar, Alexander, of Martock, yeoman 1
4360619 2150967 2150967 defendant Goulde John, senior husbandman 638395 638395 Goulde, John, senior, of Martock, husbandman 0
4360620 2150967 2150967 defendant Goulde John, junior   638395 638395 Goulde, John, junior, of Martock, butcher, victualer, his son 1
4361612 2151316 2151316 defendant Sampson John husbandman 638395 638395 Sampson, John, of Martock, husbandman 0
4361613 2151316 2151316 defendant Saylard Nicholas husbandman 638395 638395 Saylard, Nicholas, of Martock, husbandman 1
4372885 2155378 2155378 defendant Busshell John husbandman 638395 638395 Busshell, John, of Martock, husbandman 0
4376661 2156719 2156719 defendant Sampson John yeoman 638395 638395 Sampson, John, of Martock, yeoman 0
4528396 2209157 2209157 defendant Bonde John   638395 638395 Bonde, John, of Martock 2
4555380 2217617 2217617 defendant Carleton William   638395 638395 Carleton, William, of Martock 0
4694616 2263813 2263813 defendant Lymborwe John tailor 638395 638395 Lymborwe, John, of Martock, tailor 0
4695625 2264112 2264112 defendant Toker Henry   638395 638395 Toker, Henry, of Martock, vicar 0
4703261 2266398 2266398 defendant Curteys Robert ostler 638395 638395 Curteys, Robert, of Martock, ostler 0
4707041 2267585 2267585 defendant Irlond John fishmonger 638395 638395 Irlond, John, of Martock, fishmonger 0
4707042 2267585 2267585 defendant Bonde John fishmonger 638395 638395 Bonde, John, of Martock, fishmonger 1
4707043 2267585 2267585 defendant Curteys Robert ostler 638395 638395 Curteys, Robert, of Martock, ostler 2
4713954 2269693 2269693 defendant Curteys Robert husbandman 638395 638395 Curteys, Robert, of Martock, husbandman 0
4726382 2273535 2273535 defendant Bone John fishmonger 638395 638395 Bone, John, of Martock, fishmonger 1
4761656 2283991 2283991 defendant Patewyn William husbandman 638395 638395 Patewyn, William, of Martock, husbandman 0
4763909 2284705 2284705 defendant Houchyns John draper 638395 638395 Houchyns, John, of Martock, draper 0
4763910 2284705 2284705 defendant Wolle Thomas yeoman 638395 638395 Wolle, Thomas, of Martock, yeoman 1
4835605 2307127 2307127 defendant Blakalre William mercer 638395 638395 Blakalre, William, of Martock, mercer 1
5138411 2397741 2397741 defendant Bele John gent 638395 638395 Bele, John, of Martock, Soms, senior, gent 3
5470284 2496031 2496031 defendant Hykkys Robert husbandman 638395 638395 Hykkys, Robert, of Martock, husbandman 1
5470286 2496031 2496031 defendant Garde Thomas husbandman 638395 638395 Garde, Thomas, of Martock, husbandman 3

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