names

15 rows where place_id = 621618

✎ 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
3742488 1939521 1939521 defendant Dewer William husbandman 621618 621618 Dewer, William, of Bethersden, husbandman 0
3908580 1993168 1993168 defendant Godfrey Henry clothier 621618 621618 Godfrey, Henry, of Bethersden, clothier 1
3945637 2005548 2005548 defendant Holnas Stephen cooper 621618 621618 Holnas, Stephen, of Bethersden, cooper 0
3945638 2005548 2005548 defendant Holnas John barber 621618 621618 Holnas, John, of Bethersden, barber 1
3967166 2013141 2013141 plaintiff Bryssenden Thomas husbandman 621618 621618 Bryssenden, Thomas, of Bethersden, husbandman 0
4107799 2063067 2063067 defendant Blackwyth John sawyer 621618 621618 Blackwyth, John, of Bethersden, sawyer 1
4156096 2080208 2080208 defendant Pelle Paul shoemaker 621618 621618 Pelle, Paul, of Bethersden, shoemaker 0
4226755 2104831 2104831 defendant Gouldynge Giles gent 621618 621618 Gouldynge, Giles, of Bethersden, gent 1
4229935 2105952 2105952 defendant Lovelace William esq 621618 621618 Lovelace, William, of Bethersden, esq 0
4229939 2105954 2105954 defendant Lovelace William esq 621618 621618 Lovelace, William, of Bethersden, esq 0
4243798 2110906 2110906 defendant Gouldynge Giles gent 621618 621618 Gouldynge, Giles, of Bethersden, gent 1
4365967 2152866 2152866 defendant Reeve Edward husbandman 621618 621618 Reeve, Edward, of Bethersden, husbandman 0
4365969 2152867 2152867 defendant Reeve Edward husbandman 621618 621618 Reeve, Edward, of Bethersden, husbandman 0
4368789 2153891 2153891 defendant Morgan John gent 621618 621618 Morgan, John, of Bethersden, gent 2
5396866 2474188 2474188 defendant Carpenter Richard husbandman 621618 621618 Carpenter, Richard, of Bethersden, husbandman 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);