names

44 rows where place_id = 767615

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4434307 2175490 2175490 plaintiff Kent John de   767615 767615 Kent, John de, of Braham, parson 0
4434313 2175491 2175491 plaintiff Kent John de   767615 767615 Kent, John de, of Braham, parson 0
4434315 2175492 2175492 plaintiff Kent John de   767615 767615 Kent, John de, of Braham, parson 0
4434319 2175493 2175493 plaintiff Kent John de   767615 767615 Kent, John de, of Braham, parson 0
4434321 2175494 2175494 plaintiff Kent John de   767615 767615 Kent, John de, of Braham, parson 0
4541265 2213165 2213165 defendant Pilloun Richard   767615 767615 Pilloun, Richard, of Braham 0
4608721 2233832 2233832 defendant Botyngham John   767615 767615 Botyngham, John, of Braham 1
4608722 2233832 2233832 defendant Serre John   767615 767615 Serre, John, of Braham 2
4614113 2235425 2235425 defendant Adam Thomas   767615 767615 Adam, Thomas, of Braham 0
4974470 2349326 2349326 defendant Clerk Robert barker 767615 767615 Clerk, Robert, of Braham, barker 0
5008738 2359444 2359444 defendant Mopetyd Bartholomew yeoman 767615 767615 Mopetyd, Bartholomew, of Braham, yeoman 0
5039132 2368350 2368350 defendant adgore Geoffrey husbandman 767615 767615 adgore, Geoffrey, of Braham, husbandman 2
5053240 2372571 2372571 defendant Bayon John laborer 767615 767615 Bayon, John, of Braham, laborer 2
5058732 2374176 2374176 defendant Palmer Godfrey weaver 767615 767615 Palmer, Godfrey, of Braham, weaver 0
5059844 2374512 2374512 defendant Buxton William yeoman 767615 767615 Buxton, William, of Braham, yeoman 1
5059846 2374512 2374512 defendant Hervy John skinner 767615 767615 Hervy, John, of Braham, skinner 3
5106530 2388337 2388337 defendant Adgor Robert yeoman 767615 767615 Adgor, Robert, of Braham, yeoman 0
5127365 2394485 2394485 defendant Belde Thomas smith 767615 767615 Belde, Thomas, of Braham, smith 3
5130981 2395544 2395544 defendant Barker William husbandman 767615 767615 Barker, William, of Braham, husbandman 0
5143733 2399299 2399299 plaintiff Atgor Geoffrey (legal representative) 767615 767615 Atgor, Geoffrey, of Braham, executor of 0
5146252 2400033 2400033 defendant Belde Thomas smith 767615 767615 Belde, Thomas, of Braham, smith 3
5146886 2400229 2400229 plaintiff Caxton Thomas   767615 767615 Caxton, Thomas, of Braham, parson 0
5146887 2400229 2400229 defendant Newton John (legal representative) 767615 767615 Newton, John, of Braham, executor of 0
5166458 2405914 2405914 defendant Belde Thomas smith 767615 767615 Belde, Thomas, of Braham, smith 3
5166801 2406016 2406016 plaintiff Caxton Thomas   767615 767615 Caxton, Thomas, of Braham, parson 0
5166802 2406016 2406016 defendant Newton John (legal representative) 767615 767615 Newton, John, of Braham, executor of 0
5167872 2406315 2406315 defendant Adgor Robert yeoman 767615 767615 Adgor, Robert, of Braham, yeoman 0
5181885 2410449 2410449 plaintiff Caxton Thomas   767615 767615 Caxton, Thomas, of Braham, parson 0
5181886 2410449 2410449 defendant Newton John (legal representative) 767615 767615 Newton, John, of Braham, executor of 0
5202813 2416590 2416590 defendant Bolde Thomas smith 767615 767615 Bolde, Thomas, of Braham, smith 3
5203135 2416677 2416677 plaintiff Caxton Thomas   767615 767615 Caxton, Thomas, of Braham, parson 0
5203136 2416677 2416677 defendant Newton John (legal representative) 767615 767615 Newton, John, of Braham, executor of 0
5251596 2430604 2430604 plaintiff Adgore Robert   767615 767615 Adgore, Robert, of Braham 0
5251602 2430605 2430605 plaintiff Adgore Robert   767615 767615 Adgore, Robert, of Braham 0
5254340 2431488 2431488 defendant Masselyn John husbandman 767615 767615 Masselyn, John, of Braham, husbandman 0
5254352 2431490 2431490 defendant Adgor Robert yeoman 767615 767615 Adgor, Robert, of Braham, yeoman 1
5261435 2433686 2433686 defendant Masselyn Thomas yeoman 767615 767615 Masselyn, Thomas, of Braham, yeoman 0
5261437 2433687 2433687 defendant Masselyn Thomas yeoman 767615 767615 Masselyn, Thomas, of Braham, yeoman 0
5269266 2436113 2436113 defendant Masselyn John yeoman 767615 767615 Masselyn, John, of Braham, yeoman 0
5294746 2443444 2443444 defendant Fyppe Peter thatcher 767615 767615 Fyppe, Peter, of Braham, thatcher 1
5329060 2453772 2453772 plaintiff Adgore Robert   767615 767615 Adgore, Robert, of Braham 0
5397486 2474358 2474358 defendant Tarle Edmund tailor 767615 767615 Tarle, Edmund, of Braham, tailor 5
5424659 2482337 2482337 defendant Tarle Edmund tailor 767615 767615 Tarle, Edmund, of Braham, tailor 5
5443387 2487938 2487938 defendant (illegible) John tailor 767615 767615 _, John, of Braham, tailor 4

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