names

23 rows where place_id = 630144

✎ 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
3766768 1947269 1947269 defendant Byron John   630144 630144 Byron, John, of Colwyk, Notts, knight 0
3766772 1947270 1947270 defendant Byron John   630144 630144 Byron, John, of Colwyk, Notts, knight 0
3784631 1952980 1952980 defendant Byron John   630144 630144 Byron, John, of Colwyk, Notts, knight 0
3792734 1955580 1955580 defendant Bennett John yeoman 630144 630144 Bennett, John, of Colwyk, Notts, yeoman 2
3793424 1955808 1955808 defendant Bennett John yeoman 630144 630144 Bennett, John, of Colwyk, Notts, yeoman 2
3796876 1956900 1956900 defendant Bennett John   630144 630144 Bennett, John, of Colwyk, Notts 2
3799101 1957628 1957628 defendant Bennett John yeoman 630144 630144 Bennett, John, of Colwyk, Notts, yeoman 2
3803603 1959040 1959040 defendant Bennett John yeoman 630144 630144 Bennett, John, of Colwyk, Notts, yeoman 2
3806962 1960081 1960081 defendant Biron John   630144 630144 Biron, John, of Colwyk, Notts, knight 1
3817980 1963543 1963543 defendant Biron John   630144 630144 Biron, John, of Colwyk, Notts, knight 1
3826054 1965991 1965991 defendant Byron John   630144 630144 Byron, John, of Colwyk, Notts, knight 3
3830693 1967483 1967483 defendant Benet John yeoman 630144 630144 Benet, John, of Colwyk, Notts, yeoman 2
3849016 1973286 1973286 defendant Byron John   630144 630144 Byron, John, of Colwyk, Notts, knight 0
3849018 1973287 1973287 defendant Byron John   630144 630144 Byron, John, of Colwyk, Notts, knight 0
3849036 1973293 1973293 defendant Byron John   630144 630144 Byron, John, of Colwyk, Notts, knight 0
3873979 1981520 1981520 defendant Knyveton John gent 630144 630144 Knyveton, John, of Colwyk, Notts, gent 0
3873985 1981521 1981521 defendant Knyfton alias Knyveton John gent 630144 630144 Knyfton alias Knyveton, John, of Colwyk, Notts, gent 0
3894941 1988517 1988517 defendant Byrron John   630144 630144 Byrron, John, of Colwyk, Notts, knight 0
5029407 2365475 2365475 defendant Fyndern William   630144 630144 Fyndern, William, of Colwyk, Notts, parson of Barton in the Benys, Notts 0
5140092 2398200 2398200 defendant Tofte Thomas   630144 630144 Tofte, Thomas, of Colwyk, Notts, servant 1
5582191 2529502 2529502 defendant Bureham John esq 630144 630144 Bureham, John, of Colwyk, Notts, esq 1
5583480 2529904 2529904 defendant Slory Robert esq 630144 630144 Slory, Robert, of Colwyk, Notts, esq 0
5583488 2529906 2529906 defendant Slory Robert esq 630144 630144 Slory, Robert, of Colwyk, Notts, esq 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);