names

32 rows where place_id = 686336

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3845753 1972220 1972220 defendant Foster Robert (legal representative) 686336 686336 Foster, Robert, of Pountefract, yeoman, executors of 0
3983044 2018713 2018713 defendant Barkeby Robert   686336 686336 Barkeby, Robert, of Pountefract, Yorks chapman 2
4066303 2048237 2048237 plaintiff Holgate Henry   686336 686336 Holgate, Henry, of Pountefract 0
4415021 2169596 2169596 defendant Wakefeld Ralph de   686336 686336 Wakefeld, Ralph de, of Pountefract 0
4425978 2172928 2172928 plaintiff Mounkehill John de   686336 686336 Mounkehill, John de, of Pountefract, son of Adam 0
4455816 2186834 2186834 defendant Warrewyk Nicholas de   686336 686336 Warrewyk, Nicholas de, of Pountefract 0
4456169 2186948 2186948 defendant Warwyk Nicholas   686336 686336 Warwyk, Nicholas, of Pountefract 0
4456170 2186948 2186948 defendant Bubwyth Henry de   686336 686336 Bubwyth, Henry de, of Pountefract 1
4456516 2187056 2187056 defendant Seham John de   686336 686336 Seham, John de, of Pountefract 0
4458071 2187551 2187551 defendant Ploghman Robert   686336 686336 Ploghman, Robert, of Pountefract 0
4524799 2208094 2208094 defendant Shankys Robert   686336 686336 Shankys, Robert, of Pountefract 1
4540957 2213078 2213078 defendant Fraundeys William   686336 686336 Fraundeys, William, of Pountefract 1
4568969 2221880 2221880 defendant Selby John dyer 686336 686336 Selby, John, of Pountefract, dyer 4
4603676 2232336 2232336 plaintiff Wryght John   686336 686336 Wryght, John, of Pountefract 0
4632685 2241108 2241108 defendant Berwyk John taverner 686336 686336 Berwyk, John, of Pountefract, taverner 1
4647005 2245188 2245188 plaintiff Rowler Joan   686336 686336 (Rowler, Joan, of Pountefract, formerly wife of John 1
4647006 2245188 2245188 plaintiff Swyllyngton Robert   686336 686336 Swyllyngton, Robert, of Pountefract 2
4647016 2245189 2245189 plaintiff Swyllyngton Robert   686336 686336 Swyllyngton, Robert, of Pountefract 2
4680001 2259347 2259347 defendant Ledes John husbandman 686336 686336 Ledes, John, of Pountefract, husbandman 1
4785878 2291615 2291615 defendant del Stubbes Nicholas dyer 686336 686336 del Stubbes, Nicholas, of Pountefract, dyer 0
4805411 2297897 2297897 defendant del Fery Thomas skinner 686336 686336 del Fery, Thomas, of Pountefract, skinner 0
4817350 2301513 2301513 defendant Clynt John yeoman 686336 686336 Clynt, John, of Pountefract, yeoman 0
4817352 2301513 2301513 defendant Anton John husbandman 686336 686336 Anton, John, of Pountefract, husbandman 2
4965229 2346522 2346522 defendant Langley Robert butcher 686336 686336 Langley, Robert, of Pountefract, butcher 0
4988848 2353616 2353616 defendant Houchonson Roger mercer 686336 686336 Houchonson, Roger, of Pountefract, mercer 0
4997261 2356035 2356035 plaintiff Heseham John   686336 686336 Heseham, John, of Pountefract 0
5054293 2372864 2372864 defendant Lowe Henry yeoman 686336 686336 Lowe, Henry, of Pountefract, yeoman 2
5085344 2382107 2382107 defendant Tyde Thomas husbandman 686336 686336 Tyde, Thomas, of Pountefract, husbandman 0
5140759 2398411 2398411 plaintiff Arthur William   686336 686336 Arthur, William, of Pountefract 2
5140763 2398412 2398412 plaintiff Arthur William   686336 686336 Arthur, William, of Pountefract 2
5140767 2398413 2398413 plaintiff Arthur William   686336 686336 Arthur, William, of Pountefract 2
5370778 2466447 2466447 defendant Illyngworth Nicholas yeoman 686336 686336 Illyngworth, Nicholas, of Pountefract, yeoman 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);