names

17 rows where place_id = 755684

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4430395 2174293 2174293 defendant Clerk Ivan le   755684 755684 Clerk, Ivan le, of Kirkeby in Lonesdale 2
4515859 2205380 2205380 defendant Redmane John de   755684 755684 Redmane, John de, of Kirkeby in Lonesdale 0
4668573 2255879 2255879 defendant Redeman Ralph gent 755684 755684 Redeman, Ralph, of Kirkeby in Lonesdale, gent 0
4710647 2268686 2268686 defendant Clyveland William husbandman 755684 755684 Clyveland, William, of Kirkeby in Lonesdale, husbandman 0
4720774 2271829 2271829 defendant Hoghwyk William husbandman 755684 755684 Hoghwyk, William, of Kirkeby in Lonesdale, husbandman 1
4736623 2276585 2276585 defendant Condore Roger yeoman 755684 755684 Condore, Roger, of Kirkeby in Lonesdale, yeoman 0
4737777 2276920 2276920 defendant Rodemane Ralph de yeoman 755684 755684 Rodemane, Ralph de, of Kirkeby in Lonesdale, yeoman 2
4797779 2295482 2295482 defendant Wright Robert   755684 755684 Wright, Robert, of Kirkeby in Lonesdale, wright 10
4797780 2295482 2295482 defendant Pyper Thomas tailor 755684 755684 Pyper, Thomas, of Kirkeby in Lonesdale, tailor 11
4797781 2295482 2295482 defendant Riddyng Adam husbandman 755684 755684 Riddyng, Adam, of Kirkeby in Lonesdale, husbandman 12
4797782 2295482 2295482 defendant Condour John yeoman 755684 755684 Condour, John, of Kirkeby in Lonesdale, yeoman 13
4940391 2339017 2339017 defendant Neuton John gent 755684 755684 Neuton, John, of Kirkeby in Lonesdale, gent 0
5023518 2363787 2363787 defendant Stokdall James yeoman 755684 755684 Stokdall, James, of Kirkeby in Lonesdale, yeoman 1
5023519 2363787 2363787 defendant Stokdall Edward yeoman 755684 755684 Stokdall, Edward, of Kirkeby in Lonesdale, yeoman 2
5096200 2385327 2385327 defendant Middelton Oliver gent 755684 755684 Middelton, Oliver, of Kirkeby in Lonesdale, gent 1
5366256 2465106 2465106 defendant Roos Richard gent 755684 755684 Roos, Richard, of Kirkeby in Lonesdale, gent 1
5616622 2548999 2548999 defendant Bluman Thomas   755684 755684 Bluman, Thomas, of Kirkeby in Lonesdale 9

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