names

42 rows where place_id = 754449

✎ 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
4420268 2171240 2171240 plaintiff Bristowe John de   754449 754449 Bristowe, John de, of Algerkirke 0
4420269 2171240 2171240 defendant Comeynson Barn John   754449 754449 Comeynson Barn, John, of Algerkirke 0
4431650 2174666 2174666 plaintiff Bermyngham Morris de master & parson 754449 754449 Bermyngham, Morris de, of Algerkirke, master & parson 1
4431654 2174668 2174668 plaintiff Bristowe John de   754449 754449 Bristowe, John de, of Algerkirke 0
4431655 2174668 2174668 defendant Fen Robert of the   754449 754449 Fen, Robert of the, of Algerkirke 0
4437975 2181195 2181195 defendant Plocorn Richard de   754449 754449 Plocorn, Richard de, of Algerkirke, son of John 0
4439953 2181778 2181778 plaintiff Bate John   754449 754449 Bate, John, of Algerkirke 0
4448961 2184615 2184615 plaintiff Gate John   754449 754449 Gate, John, of Algerkirke 0
4457426 2187333 2187333 defendant Crabdam Simon   754449 754449 Crabdam, Simon, of Algerkirke 0
4465551 2189896 2189896 defendant Polvertoft Joan   754449 754449 Polvertoft, Joan, of Algerkirke, formerly wife of Richard 0
4488865 2197234 2197234 defendant Pullertoft Roger de   754449 754449 Pullertoft, Roger de, of Algerkirke 0
4504504 2201966 2201966 defendant Toup John   754449 754449 Toup, John, of Algerkirke 0
4522332 2207332 2207332 defendant Gildente Robert   754449 754449 Gildente, Robert, of Algerkirke 0
4534053 2210919 2210919 defendant Toup John   754449 754449 Toup, John, of Algerkirke 0
4653121 2246913 2246913 plaintiff Bate Christiana   754449 754449 Bate, Christiana, of Algerkirke 0
4653123 2246913 2246913 defendant Stubynet John laborer 754449 754449 Stubynet, John, of Algerkirke, laborer 1
4659781 2248909 2248909 plaintiff de Meres Athelard   754449 754449 de Meres, Athelard, of Algerkirke 2
4737720 2276901 2276901 defendant Hunyng Lambert husbandman 754449 754449 Hunyng, Lambert, of Algerkirke, husbandman 0
4737721 2276901 2276901 defendant Hunnyng Thomas husbandman 754449 754449 Hunnyng, Thomas, of Algerkirke, husbandman 1
4755207 2282015 2282015 defendant Gobbe John carter 754449 754449 Gobbe, John, of Algerkirke, carter 0
4811531 2299715 2299715 defendant Marable John husbandman 754449 754449 Marable, John, of Algerkirke, husbandman 0
4811533 2299716 2299716 defendant Marable John husbandman 754449 754449 Marable, John, of Algerkirke, husbandman 0
4992982 2354784 2354784 defendant London Thomas husbandman 754449 754449 London, Thomas, of Algerkirke, husbandman 3
5087476 2382715 2382715 defendant Gybon John, senior husbandman 754449 754449 Gybon, John, senior, of Algerkirke, husbandman 0
5087477 2382715 2382715 defendant Gyldentoo Thomas husbandman 754449 754449 Gyldentoo, Thomas, of Algerkirke, husbandman 1
5093911 2384618 2384618 defendant Chesall Thomas gent 754449 754449 Chesall, Thomas, of Algerkirke, gent 0
5104644 2387795 2387795 defendant Male Roger husbandman 754449 754449 Male, Roger, of Algerkirke, husbandman 0
5106255 2388267 2388267 defendant Betson Richard husbandman 754449 754449 Betson, Richard, of Algerkirke, husbandman 0
5146778 2400200 2400200 defendant Pulvertofte Robert gent 754449 754449 Pulvertofte, Robert, of Algerkirke, gent 0
5166752 2406001 2406001 defendant Pulvertofte Robert gent 754449 754449 Pulvertofte, Robert, of Algerkirke, gent 0
5181802 2410420 2410420 defendant Pulvertofte Robert gent 754449 754449 Pulvertofte, Robert, of Algerkirke, gent 0
5254664 2431579 2431579 defendant Pulvertofte Robert gent 754449 754449 Pulvertofte, Robert, of Algerkirke, gent 0
5612022 2547492 2547492 plaintiff Bryghous John de   754449 754449 Bryghous, John de, of Algerkirke 0
5613310 2547945 2547945 plaintiff Crabdam Simon   754449 754449 Crabdam, Simon, of Algerkirke 0
5613312 2547946 2547946 plaintiff Crabdam Simon   754449 754449 Crabdam, Simon, of Algerkirke 0
5613315 2547947 2547947 plaintiff Crabedam Simon de   754449 754449 Crabedam, Simon de, of Algerkirke 0
5615747 2548719 2548719 defendant Morice Roger   754449 754449 Morice, Roger, of Algerkirke 0
5619754 2550039 2550039 plaintiff Pulvertoft Thomas   754449 754449 Pulvertoft, Thomas, of Algerkirke 0
5621098 2550481 2550481 plaintiff Spenser Robert (legal representative) 754449 754449 Spenser, Robert, of Algerkirke, executors of 0
5621099 2550481 2550481 plaintiff Pulvertoft Thomas de   754449 754449 (Pulvertoft, Thomas de, of Algerkirke, son of Robert 1
5622095 2550823 2550823 defendant Coveyn John weaver 754449 754449 Coveyn, John, of Algerkirke, weaver 0
5622096 2550824 2550824 plaintiff Toupe Roger   754449 754449 Toupe, Roger, of Algerkirke, on his own account 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);