names

29 rows where place_id = 607235

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668307 1916035 1916035 defendant Ardren Robert gent 607235 607235 Ardren, Robert, of Rowley, Staffs, gent 0
3685005 1921449 1921449 defendant Ardern Robert gent 607235 607235 Ardern, Robert, of Rowley, Staffs, gent 0
3685007 1921450 1921450 defendant Ardern Robert gent 607235 607235 Ardern, Robert, of Rowley, Staffs, gent 0
3727724 1934940 1934940 defendant Underell Thomas chapman 607235 607235 Underell, Thomas, of Rowley, Staffs, chapman 2
3778609 1951021 1951021 defendant Forest Thomas ironmonger 607235 607235 Forest, Thomas, of Rowley, Staffs, ironmonger 1
3804989 1959504 1959504 defendant Catell Henry yeoman 607235 607235 Catell, Henry, of Rowley, Staffs, yeoman 0
3891373 1987379 1987379 defendant Stokker William nailer 607235 607235 Stokker, William, of Rowley, Staffs, nailer 3
3938549 2003233 2003233 defendant Badnam John nailer 607235 607235 Badnam, John, of Rowley, Staffs, nailer 3
3946683 2005905 2005905 defendant Staunford Edward gent 607235 607235 Staunford, Edward, of Rowley, Staffs, gent 0
3966553 2012934 2012934 defendant Marten William yeoman 607235 607235 Marten, William, of Rowley, Staffs, yeoman 0
3969125 2013812 2013812 defendant Bodnam John smith 607235 607235 Bodnam, John, of Rowley, Staffs, smith 0
3969703 2014010 2014010 defendant Coley William nailer 607235 607235 Coley, William, of Rowley, Staffs, nailer 1
3969706 2014011 2014011 defendant Coley William nailer 607235 607235 Coley, William, of Rowley, Staffs, nailer 1
4131101 2071442 2071442 defendant Grove Robert yeoman or nailer 607235 607235 Grove, Robert, of Rowley, Staffs, yeoman or nailer 0
4149405 2077919 2077919 defendant Colbarne William yeoman 607235 607235 Colbarne, William, of Rowley, Staffs, yeoman 1
4154806 2079776 2079776 defendant Grove Robert nailer 607235 607235 Grove, Robert, of Rowley, Staffs, yeoman, nailer 0
4156251 2080259 2080259 defendant Martine John nailer 607235 607235 Martine, John, of Rowley, Staffs, nailer 1
4180509 2088663 2088663 defendant Russon Thomas yeoman 607235 607235 Russon, Thomas, of Rowley, Staffs, yeoman 3
4198959 2095193 2095193 defendant Wood Walter gent 607235 607235 Wood, Walter, of Rowley, Staffs, gent 0
4216054 2101109 2101109 defendant Grove William, junior yeoman 607235 607235 Grove, William, junior, of Rowley, Staffs, yeoman, son of William grove, senior, yeoman 0
4225372 2104342 2104342 defendant Grove William, junior yeoman 607235 607235 Grove, William, junior, of Rowley, Staffs, yeoman, son of William Grove, senior, yeoman 0
4283246 2124044 2124044 defendant Chapman Thomas yeoman 607235 607235 Chapman, Thomas, of Rowley, Staffs, yeoman 1
4283277 2124056 2124056 defendant Grove William, junior yeoman 607235 607235 Grove, William, junior, of Rowley, Staffs, yeoman 0
4285850 2124992 2124992 defendant Grove Philip smith 607235 607235 Grove, Philip, of Rowley, Staffs, smith 0
4285852 2124993 2124993 defendant Grove William, junior   607235 607235 Grove, William, junior, of Rowley, Staffs, yeoman, son of William 0
4285854 2124994 2124994 defendant Grove William, senior yeoman 607235 607235 Grove, William, senior, of Rowley, Staffs, yeoman 0
4291971 2127205 2127205 defendant Jones alias Martyn Richard nailer 607235 607235 Jones alias Martyn, Richard, of Rowley, Staffs, nailer 0
4322755 2138027 2138027 defendant Jones alias Martyn Richard nailer 607235 607235 Jones alias Martyn, Richard, of Rowley, Staffs, nailer 0
4409875 2167905 2167905 defendant Russell Thomas yeoman 607235 607235 Russell, Thomas, of Rowley, Staffs, yeoman 1

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