names

25 rows where place_id = 642296

✎ 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
3867075 1979225 1979225 defendant Sacheverell Thomas gent 642296 642296 Sacheverell, Thomas, of Horsley, Derbs, gent 0
3941798 2004270 2004270 defendant Lowe Francis gent 642296 642296 Lowe, Francis, of Horsley, Derbs, gent 3
3970030 2014114 2014114 defendant Waddyngton Nicholas yeoman 642296 642296 Waddyngton, Nicholas, of Horsley, Derbs, yeoman 0
4037808 2038175 2038175 defendant Semper Robert yeoman 642296 642296 Semper, Robert, of Horsley, Derbs, yeoman 2
4070263 2049658 2049658 defendant Blundewell Alan gent 642296 642296 Blundewell, Alan, of Horsley, Derbs, gent 0
4149593 2077981 2077981 defendant Chillwill alias Burley Henry   642296 642296 Chillwill alias Burley, Henry, of Horsley, Derbs, scythe grinder 3
4714015 2269710 2269710 defendant Milner Thomas smith 642296 642296 Milner, Thomas, of Horsley, Derbs, smith 1
4745124 2279080 2279080 defendant Foleiambe Edward   642296 642296 Foleiambe, Edward, of Horsley, Derbs, knight 3
4815747 2301027 2301027 defendant Normanton Roger gent 642296 642296 Normanton, Roger, of Horsley, Derbs, gent 0
4842301 2309123 2309123 defendant Stacy Thomas   642296 642296 Stacy, Thomas, of Horsley, Derbs 0
4918956 2332443 2332443 defendant Fraunceys Ingelram gent 642296 642296 Fraunceys, Ingelram, of Horsley, Derbs, gent 2
4942266 2339573 2339573 defendant Fraunceys Ingelram gent 642296 642296 Fraunceys, Ingelram, of Horsley, Derbs, gent 0
4989168 2353696 2353696 defendant Smythson Thomas laborer 642296 642296 Smythson, Thomas, of Horsley, Derbs, laborer 7
5427224 2483084 2483084 defendant Smyth Henry smith 642296 642296 Smyth, Henry, of Horsley, Derbs, smith 1
5445064 2488411 2488411 defendant smyth Henry smith 642296 642296 smyth, Henry, of Horsley, Derbs, smith 1
5445065 2488411 2488411 defendant Smyth John smith 642296 642296 Smyth, John, of Horsley, Derbs, smith 2
5457724 2492206 2492206 defendant smyth Henry smith 642296 642296 smyth, Henry, of Horsley, Derbs, smith 1
5457725 2492206 2492206 defendant Smyth John smith 642296 642296 Smyth, John, of Horsley, Derbs, smith 2
5523783 2512260 2512260 defendant Oley John   642296 642296 Oley, John, of Horsley, Derbs, scythe smith 1
5525322 2512511 2512511 defendant Oley John   642296 642296 Oley, John, of Horsley, Derbs, scythe smith 1
5526767 2512940 2512940 defendant Smyth John   642296 642296 Smyth, John, of Horsley, Derbs, scythe smith 2
5548004 2519447 2519447 defendant Leesse William yeoman 642296 642296 Leesse, William, of Horsley, Derbs, yeoman 1
5557182 2522062 2522062 defendant Ball Henry   642296 642296 Ball, Henry, of Horsley, Derbs, scythe smith 0
5557190 2522066 2522066 defendant Ball Henry   642296 642296 Ball, Henry, of Horsley, Derbs, scythe smith 0
5557192 2522067 2522067 defendant Ball Henry   642296 642296 Ball, Henry, of Horsley, Derbs, scythe smith 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);