names

26 rows where place_id = 761482

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4479343 2194189 2194189 plaintiff Hunter Thomas   761482 761482 Hunter, Thomas, of Birton 0
4540644 2212975 2212975 defendant Pelle Robert   761482 761482 Pelle, Robert, of Birton, vicar 0
4540646 2212976 2212976 defendant Pelle Robert   761482 761482 Pelle, Robert, of Birton, vicar 0
4595657 2229904 2229904 defendant Frost John   761482 761482 Frost, John, of Birton 1
4695324 2264018 2264018 defendant Sawer William husbandman 761482 761482 Sawer, William, of Birton, husbandman 0
4726161 2273468 2273468 defendant Ysonde Richard victualler 761482 761482 Ysonde, Richard, of Birton, victualler 3
4748911 2280173 2280173 defendant Smyth Robert   761482 761482 Smyth, Robert, of Birton, scythe maker & hokemaker 0
4813815 2300432 2300432 defendant Chapell John husbandman 761482 761482 Chapell, John, of Birton, husbandman 1
4813816 2300432 2300432 defendant Chapell Robert husbandman 761482 761482 Chapell, Robert, of Birton, husbandman 2
4813817 2300432 2300432 defendant Oxille William collier 761482 761482 Oxille, William, of Birton, collier 3
4813818 2300432 2300432 defendant Birton John   761482 761482 Birton, John, of Birton, franklin 4
4930567 2335965 2335965 defendant Chauntery Robert   761482 761482 Chauntery, Robert, of Birton clerk 0
5096234 2385336 2385336 defendant Cotes John fletcher 761482 761482 Cotes, John, of Birton, fletcher 2
5096240 2385337 2385337 defendant Syke John coper 761482 761482 Syke, John, of Birton, coper 3
5118779 2391925 2391925 defendant Wade Stephen husbandman 761482 761482 Wade, Stephen, of Birton, husbandman 2
5118780 2391925 2391925 defendant Baker John, senior husbandman 761482 761482 Baker, John, senior, of Birton, husbandman 3
5118781 2391925 2391925 defendant Baker John, junior husbandman 761482 761482 Baker, John, junior, of Birton, husbandman 4
5118782 2391925 2391925 defendant Strete William smith 761482 761482 Strete, William, of Birton, smith 5
5300026 2444972 2444972 defendant Heritage John husbandman 761482 761482 Heritage, John, of Birton, husbandman 0
5300027 2444972 2444972 defendant Crace John laborer 761482 761482 Crace, John, of Birton, laborer 1
5300028 2444972 2444972 defendant Compton Edmund laborer 761482 761482 Compton, Edmund, of Birton, laborer 2
5300030 2444973 2444973 defendant Heritage John husbandman 761482 761482 Heritage, John, of Birton, husbandman 0
5300031 2444973 2444973 defendant Brace John laborer 761482 761482 Brace, John, of Birton, laborer 1
5300032 2444973 2444973 defendant Compton Edmund laborer 761482 761482 Compton, Edmund, of Birton, laborer 2
5577735 2528106 2528106 defendant Cooke Ralph sherman 761482 761482 Cooke, Ralph, of Birton, sherman 1
5577736 2528106 2528106 defendant Cooke William sherman 761482 761482 Cooke, William, of Birton, sherman 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);