names

34 rows where place_id = 599639

✎ 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
3637572 1906562 1906562 defendant Alee Robert innholder 599639 599639 Alee, Robert, of Lycham, innholder 2
3725342 1934218 1934218 defendant Teversham John innkeeper 599639 599639 Teversham, John, of Lycham, innkeeper 0
3752522 1942713 1942713 defendant Teversham John yeoman 599639 599639 Teversham, John, of Lycham, yeoman 0
3796694 1956850 1956850 defendant Taversham John innholder 599639 599639 Taversham, John, of Lycham, innholder 0
3820367 1964248 1964248 defendant Taversham John pedder 599639 599639 Taversham, John, of Lycham, pedder 3
3824726 1965607 1965607 defendant Taversham John innkeeper 599639 599639 Taversham, John, of Lycham, innkeeper 0
3875370 1982008 1982008 defendant Cusham John fishmonger 599639 599639 Cusham, John, of Lycham, fishmonger 2
3875775 1982150 1982150 defendant Malby Robert yeoman 599639 599639 Malby, Robert, of Lycham, yeoman 0
3876995 1982547 1982547 defendant Poynt John husbandman 599639 599639 Poynt, John, of Lycham, husbandman 0
3896284 1988968 1988968 defendant Maltby Robert yeoman 599639 599639 Maltby, Robert, of Lycham, yeoman 0
3915373 1995509 1995509 defendant Rous Robert husbandman 599639 599639 Rous, Robert, of Lycham, husbandman 0
3915375 1995510 1995510 defendant Rowse Robert husbandman 599639 599639 Rowse, Robert, of Lycham, husbandman 0
3919981 1997021 1997021 defendant Colyson Richard tanner 599639 599639 Colyson, Richard, of Lycham, tanner 0
4469960 2191268 2191268 defendant Caudeler John   599639 599639 Caudeler, John, of Lycham 0
4501328 2201021 2201021 defendant Sadelere Reginald   599639 599639 Sadelere, Reginald, of Lycham 0
4527500 2208879 2208879 defendant Sadelere Henry   599639 599639 Sadelere, Henry, of Lycham 1
4576514 2224166 2224166 defendant Sadeler Reginald   599639 599639 Sadeler, Reginald, of Lycham 0
4580803 2225478 2225478 defendant Foune Thomas   599639 599639 Foune, Thomas, of Lycham 1
4599783 2231154 2231154 defendant Sadelere Reginald   599639 599639 Sadelere, Reginald, of Lycham 0
4617593 2236511 2236511 defendant Candeler John   599639 599639 Candeler, John, of Lycham 0
4679714 2259272 2259272 defendant Caudeler John ostler 599639 599639 Caudeler, John, of Lycham, ostler 2
4937042 2337962 2337962 defendant Cordy Richard yeoman 599639 599639 Cordy, Richard, of Lycham, yeoman 0
4937043 2337962 2337962 defendant Cordy John laborer 599639 599639 Cordy, John, of Lycham, laborer 1
4962470 2345679 2345679 defendant Cordy Richard yeoman 599639 599639 Cordy, Richard, of Lycham, yeoman 0
4962471 2345679 2345679 defendant Cordy John laborer 599639 599639 Cordy, John, of Lycham, laborer 1
5017047 2361881 2361881 defendant Pavy Thomas laborer 599639 599639 Pavy, Thomas, of Lycham, laborer 0
5095960 2385248 2385248 defendant Basse Robert yeoman 599639 599639 Basse, Robert, of Lycham, yeoman 1
5160113 2404058 2404058 defendant Tussy John husbandman 599639 599639 Tussy, John, of Lycham, husbandman 0
5175002 2408383 2408383 defendant Tussy John husbandman 599639 599639 Tussy, John, of Lycham, husbandman 0
5218740 2421207 2421207 defendant Shortwode John yeoman 599639 599639 Shortwode, John, of Lycham, yeoman 0
5404661 2476410 2476410 defendant Walter Richard husbandman 599639 599639 Walter, Richard, of Lycham, husbandman 0
5531170 2514263 2514263 defendant Fyssher John (legal representative) 599639 599639 Fyssher, John, of Lycham, executors of 0
5531171 2514263 2514263 defendant Fyssher Richard yeoman 599639 599639 (Fyssher, Richard, of Lycham, yeoman 1
5531172 2514263 2514263 defendant Fyssher Thomas husbandman 599639 599639 Fyssher, Thomas, of Lycham, husbandman 2

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