names

20 rows where place_id = 827693

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3746146 1940702 1940702 defendant Dacre William   827693 827693 Dacre, William, of Dacre, knight, son of Dacre, Thomas 0
3754305 1943299 1943299 defendant Dacre William   827693 827693 Dacre, William, of Dacre, knight 0
4155004 2079843 2079843 defendant Oseley Richard   827693 827693 Oseley, Richard, of Dacre, cook 2
4155011 2079844 2079844 defendant Oseby Richard   827693 827693 Oseby, Richard, of Dacre, cook 5
4435281 2175792 2175792 defendant Burgh William de   827693 827693 Burgh, William de, of Dacre, parson who vouched Dacre, William de, son & heir of Randolf de Dacre 2
4725087 2273143 2273143 defendant Golthweyte Robert   827693 827693 Golthweyte, Robert, of Dacre, groom 0
4960664 2345151 2345151 defendant Knoll John husbandman 827693 827693 Knoll, John, of Dacre, husbandman 3
4960665 2345151 2345151 defendant Toppan Richard yeoman 827693 827693 Toppan, Richard, of Dacre, yeoman 4
4960666 2345151 2345151 defendant Hochonson William yeoman 827693 827693 Hochonson, William, of Dacre, yeoman 5
5005968 2358647 2358647 defendant Haythwayt William yeoman 827693 827693 Haythwayt, William, of Dacre, yeoman 1
5005969 2358647 2358647 defendant Johnson Thomas yeoman 827693 827693 Johnson, Thomas, of Dacre, yeoman 2
5006000 2358649 2358649 defendant Haythwayt William yeoman 827693 827693 Haythwayt, William, of Dacre, yeoman 6
5006001 2358649 2358649 defendant Johnson Thomas yeoman 827693 827693 Johnson, Thomas, of Dacre, yeoman 7
5028907 2365329 2365329 defendant Dayncourt John chaplain 827693 827693 Dayncourt, John, of Dacre, chaplain 1
5028910 2365329 2365329 defendant Jonson Thomas gent 827693 827693 Jonson, Thomas, of Dacre, gent 4
5028915 2365329 2365329 defendant Lancastre Thomas gent 827693 827693 Lancastre, Thomas, of Dacre, gent 9
5028920 2365330 2365330 defendant Jonson Thomas yeoman 827693 827693 Jonson, Thomas, of Dacre, yeoman 1
5028921 2365330 2365330 defendant Gilbank Alexander yeoman 827693 827693 Gilbank, Alexander, of Dacre, yeoman 2
5028923 2365330 2365330 defendant Lancastre Thomas gent 827693 827693 Lancastre, Thomas, of Dacre, gent 4
5028928 2365330 2365330 defendant Dayncourt John chaplain 827693 827693 Dayncourt, John, of Dacre, chaplain 9

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