names

44 rows where place_id = 590987

✎ 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
3602926 1868578 1868578 defendant Takyl Nicholas yeoman 590987 590987 Takyl, Nicholas, of Lyngefeld, yeoman 0
3602927 1868578 1868578 defendant Pyers Richard yeoman 590987 590987 Pyers, Richard, of Lyngefeld, yeoman 1
3892565 1987755 1987755 defendant Wodye Thomas, junior   590987 590987 Wodye, Thomas, junior, of Lyngefeld, yeoman, singingman, college of Lyngefeld 0
4169701 2084893 2084893 defendant Winchester Edward yeoman 590987 590987 Winchester, Edward, of Lyngefeld, yeoman 1
4303310 2131286 2131286 defendant Lusted George yeoman 590987 590987 Lusted, George, of Lyngefeld, yeoman 0
4303312 2131286 2131286 defendant Knowlden Peter husbandman 590987 590987 Knowlden, Peter, of Lyngefeld, husbandman 2
4515349 2205213 2205213 defendant Cartere John   590987 590987 Cartere, John, of Lyngefeld 0
4519649 2206507 2206507 plaintiff Enyngfeld William   590987 590987 Enyngfeld, William, of Lyngefeld 0
4528374 2209148 2209148 plaintiff Marchaunt John   590987 590987 Marchaunt, John, of Lyngefeld 0
4550149 2215988 2215988 plaintiff Cryps John   590987 590987 Cryps, John, of Lyngefeld 0
4551717 2216481 2216481 defendant Brugger John butcher 590987 590987 Brugger, John, of Lyngefeld, butcher 0
4553730 2217089 2217089 defendant Brugger John butcher 590987 590987 Brugger, John, of Lyngefeld, butcher 0
4554627 2217374 2217374 defendant Gloucestr John chaplain 590987 590987 Gloucestr, John, of Lyngefeld, chaplain 0
4554629 2217375 2217375 defendant Gloucestre John chaplain 590987 590987 Gloucestre, John, of Lyngefeld, chaplain 0
4653193 2246935 2246935 defendant Luggebrugge Thomas yeoman 590987 590987 Luggebrugge, Thomas, of Lyngefeld, yeoman 0
4653194 2246935 2246935 defendant Elyot William carpenter 590987 590987 Elyot, William, of Lyngefeld, carpenter 1
4653195 2246935 2246935 defendant Passevey John husbandman 590987 590987 Passevey, John, of Lyngefeld, husbandman 2
4653197 2246936 2246936 defendant Luggebrugge Thomas yeoman 590987 590987 Luggebrugge, Thomas, of Lyngefeld, yeoman 0
4653198 2246936 2246936 defendant Elyot William carpenter 590987 590987 Elyot, William, of Lyngefeld, carpenter 1
4653199 2246936 2246936 defendant Passevey John husbandman 590987 590987 Passevey, John, of Lyngefeld, husbandman 2
4655517 2247619 2247619 defendant Umfrey Walter husbandman 590987 590987 Umfrey, Walter, of Lyngefeld, husbandman 0
4682457 2260137 2260137 plaintiff Neylond Thomas   590987 590987 Neylond, Thomas, of Lyngefeld, parson 0
4692595 2263201 2263201 defendant Laurence William   590987 590987 Laurence, William, of Lyngefeld, bailiff 0
4712667 2269277 2269277 defendant Mathewe John haberdasher 590987 590987 Mathewe, John, of Lyngefeld, haberdasher 2
4712671 2269278 2269278 defendant Maathewe John haberdassher 590987 590987 Maathewe, John, of Lyngefeld, haberdassher 2
4770211 2286656 2286656 defendant Mathewe Walter chapman 590987 590987 Mathewe, Walter, of Lyngefeld, chapman 0
4785786 2291591 2291591 defendant Ussher John yeoman 590987 590987 Ussher, John, of Lyngefeld, yeoman 4
4785787 2291591 2291591 defendant Irland John yeoman 590987 590987 Irland, John, of Lyngefeld, yeoman 5
4785788 2291591 2291591 defendant atte Sole Richard yeoman 590987 590987 atte Sole, Richard, of Lyngefeld, yeoman 6
4785797 2291593 2291593 defendant Langholm John gent 590987 590987 Langholm, John, of Lyngefeld, gent 4
4785798 2291593 2291593 defendant Morpath Robert yeoman 590987 590987 Morpath, Robert, of Lyngefeld, yeoman 5
4815999 2301096 2301096 defendant Whetlond William barber 590987 590987 Whetlond, William, of Lyngefeld, barber 0
4816000 2301096 2301096 defendant Londer John husbandman 590987 590987 Londer, John, of Lyngefeld, husbandman 1
4816001 2301096 2301096 defendant Pally Henry smith 590987 590987 Pally, Henry, of Lyngefeld, smith 2
4816002 2301096 2301096 defendant Doget William laborer 590987 590987 Doget, William, of Lyngefeld, laborer 3
4856963 2313557 2313557 defendant Toth Thomas baker 590987 590987 Toth, Thomas, of Lyngefeld, baker 0
4928358 2335293 2335293 defendant Rede John carpenter 590987 590987 Rede, John, of Lyngefeld, carpenter 0
4968564 2347563 2347563 defendant Stokket John, senior husbandman 590987 590987 Stokket, John, senior, of Lyngefeld, husbandman 0
5051549 2372082 2372082 defendant Umfray William tanner 590987 590987 Umfray, William, of Lyngefeld, tanner 0
5210732 2418870 2418870 defendant Innyngfeld William husbandman 590987 590987 Innyngfeld, William, of Lyngefeld, husbandman 0
5210734 2418871 2418871 defendant Innyngfeld William husbandman 590987 590987 Innyngfeld, William, of Lyngefeld, husbandman 0
5276414 2438170 2438170 defendant Umfrey John husbandman 590987 590987 Umfrey, John, of Lyngefeld, husbandman 0
5543929 2518210 2518210 defendant Underhyll John, junior husbandman 590987 590987 Underhyll, John, junior, of Lyngefeld, husbandman 4
5615195 2548547 2548547 plaintiff Fytlyng Edmund   590987 590987 Fytlyng, Edmund, of Lyngefeld, parson 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);