names

24 rows where place_id = 640545

✎ 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
3855968 1975490 1975490 defendant Gray Ellen widow 640545 640545 Gray, Ellen, of Cumrewe, widow 0
3855969 1975490 1975490 defendant Gray Thomas husbandman 640545 640545 Gray, Thomas, of Cumrewe, husbandman 1
3855970 1975490 1975490 defendant Gray Adam husbandman 640545 640545 Gray, Adam, of Cumrewe, husbandman 2
3855971 1975490 1975490 defendant Gill Henry husbandman 640545 640545 Gill, Henry, of Cumrewe, husbandman 3
4453132 2185985 2185985 defendant Watson William   640545 640545 Watson, William, of Cumrewe 2
4529450 2209490 2209490 defendant Parker William   640545 640545 Parker, William, of Cumrewe 0
4529453 2209490 2209490 defendant Atkyngson Robert   640545 640545 Atkyngson, Robert, of Cumrewe 3
4613153 2235171 2235171 defendant Stodart Hugh   640545 640545 Stodart, Hugh, of Cumrewe 3
4613154 2235171 2235171 defendant Adamson William   640545 640545 Adamson, William, of Cumrewe 4
4613155 2235171 2235171 defendant Hughson John   640545 640545 Hughson, John, of Cumrewe 5
4613156 2235171 2235171 defendant Hughson Adam   640545 640545 Hughson, Adam, of Cumrewe 6
4613157 2235171 2235171 defendant Huchunson William   640545 640545 Huchunson, William, of Cumrewe 7
4613158 2235171 2235171 defendant Raynaldson Hugh   640545 640545 Raynaldson, Hugh, of Cumrewe 8
4613159 2235171 2235171 defendant Parker William   640545 640545 Parker, William, of Cumrewe 9
4613160 2235171 2235171 defendant Thomson William   640545 640545 Thomson, William, of Cumrewe 10
4659675 2248880 2248880 defendant Studhird Hugh yeoman 640545 640545 Studhird, Hugh, of Cumrewe, yeoman 4
4659676 2248880 2248880 defendant Studhird Adam yeoman 640545 640545 Studhird, Adam, of Cumrewe, yeoman 5
4659677 2248880 2248880 defendant Mill William yeoman 640545 640545 Mill, William, of Cumrewe, yeoman 6
4659678 2248880 2248880 defendant Raynoldson Hugh yeoman 640545 640545 Raynoldson, Hugh, of Cumrewe, yeoman 7
4659679 2248880 2248880 defendant Studhird John yeoman 640545 640545 Studhird, John, of Cumrewe, yeoman 8
4659680 2248880 2248880 defendant Lambe John yeoman 640545 640545 Lambe, John, of Cumrewe, yeoman 9
4659682 2248881 2248881 defendant Stodehird Hugh husbandman 640545 640545 Stodehird, Hugh, of Cumrewe, husbandman 0
4659683 2248881 2248881 defendant Stodehird John husbandman 640545 640545 Stodehird, John, of Cumrewe, husbandman 1
4659684 2248881 2248881 defendant Mille William husbandman 640545 640545 Mille, William, of Cumrewe, 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);