names

17 rows where place_id = 614382

✎ 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
3703338 1927319 1927319 defendant Parmenter William husbandman 614382 614382 Parmenter, William, of Clyf, husbandman 0
3703340 1927319 1927319 defendant Foster William smith 614382 614382 Foster, William, of Clyf, smith 2
3842081 1971076 1971076 defendant Perytt Thomas husbandman 614382 614382 Perytt, Thomas, of Clyf, husbandman 0
3882175 1984295 1984295 defendant Rolf Richard husbandman 614382 614382 Rolf, Richard, of Clyf, husbandman 3
4454127 2186309 2186309 defendant Mortymer John   614382 614382 Mortymer, John, of Clyf 0
4580586 2225411 2225411 defendant Pultere William, sen   614382 614382 Pultere, William, sen, of Clyf 0
4580587 2225411 2225411 defendant Bonde William   614382 614382 Bonde, William, of Clyf 1
4648852 2245725 2245725 defendant Clyf William   614382 614382 Clyf, William, of Clyf 0
4655504 2247614 2247614 defendant Corfe John gent 614382 614382 Corfe, John, of Clyf, gent 1
4779295 2289504 2289504 defendant Latton John yeoman 614382 614382 Latton, John, of Clyf, yeoman 3
4779300 2289505 2289505 defendant Horne Thomas   614382 614382 Horne, Thomas, of Clyf, gent, son of Thomas 2
4779301 2289505 2289505 defendant Latton John yeoman 614382 614382 Latton, John, of Clyf, yeoman 3
4902208 2327298 2327298 defendant Aylysford John baker 614382 614382 Aylysford, John, of Clyf, baker 5
4902209 2327298 2327298 defendant Cust Thomas laborer 614382 614382 Cust, Thomas, of Clyf, laborer 6
4942183 2339543 2339543 defendant Horby John husbandman 614382 614382 Horby, John, of Clyf, husbandman 0
4942184 2339543 2339543 defendant Tyler John husbandman 614382 614382 Tyler, John, of Clyf, husbandman 1
4974791 2349430 2349430 defendant Johnson William   614382 614382 Johnson, William, of Clyf, shepherd 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);