names

15 rows where place_id = 616544

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3714952 1930972 1930972 defendant Luson Augustine husbandman 616544 616544 Luson, Augustine, of Lexham, husbandman 0
4006409 2027071 2027071 plaintiff Lestraunge Robert gent 616544 616544 Lestraunge, Robert, of Lexham, gent 0
4006411 2027072 2027072 plaintiff Lestraunge Robert gent 616544 616544 Lestraunge, Robert, of Lexham, gent 0
4196611 2094360 2094360 defendant Tompson Robert tanner 616544 616544 Tompson, Robert, of Lexham, tanner 2
4340998 2144129 2144129 defendant Allee William yeoman 616544 616544 together with Allee, William, of Lexham, yeoman 2
4391342 2161723 2161723 defendant Alee William yeoman 616544 616544 Alee, William, of Lexham, yeoman 2
4432946 2175048 2175048 defendant Moubray John   616544 616544 Moubray, John, of Lexham 0
4432948 2175049 2175049 defendant Moubray John   616544 616544 Moubray, John, of Lexham 0
4554372 2217296 2217296 defendant Rous Nicholas   616544 616544 Rous, Nicholas, of Lexham 0
4624732 2238715 2238715 defendant Horscroft William   616544 616544 Horscroft, William, of Lexham 1
4739167 2277343 2277343 defendant Fullere William laborer 616544 616544 Fullere, William, of Lexham, laborer 0
4809202 2299054 2299054 defendant Nowete Richard chaplain 616544 616544 Nowete, Richard, of Lexham, chaplain 0
4834982 2306944 2306944 defendant Gedney John   616544 616544 Gedney, John, of Lexham, vicar 0
5373788 2467396 2467396 defendant Clement John chaplain 616544 616544 Clement, John, of Lexham, chaplain 0
5378109 2468731 2468731 defendant Penne William clerk 616544 616544 Penne, William, of Lexham, clerk 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);