names

17 rows where place_id = 770164

✎ 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
4565186 2220685 2220685 plaintiff Skynner John   770164 770164 Skynner, John, of Tolre Porcorum 0
4686409 2261354 2261354 defendant Skynner John husbandman 770164 770164 Skynner, John, of Tolre Porcorum, husbandman 0
4688282 2261903 2261903 defendant Skynnere John woolmonger 770164 770164 Skynnere, John, of Tolre Porcorum, woolmonger 0
4725506 2273269 2273269 defendant Coteryg William husbandman 770164 770164 Coteryg, William, of Tolre Porcorum, husbandman 0
4736953 2276686 2276686 defendant Wylmot John butcher 770164 770164 Wylmot, John, of Tolre Porcorum, butcher 0
4752817 2281277 2281277 defendant Wilmot John husbandman 770164 770164 Wilmot, John, of Tolre Porcorum, husbandman 10
4782809 2290640 2290640 defendant Walkeleyn William, junior husbandman 770164 770164 Walkeleyn, William, junior, of Tolre Porcorum, husbandman 1
4782812 2290641 2290641 defendant Walkeleyn William, junior husbandman 770164 770164 Walkeleyn, William, junior, of Tolre Porcorum, husbandman 1
4791220 2293353 2293353 defendant Coterygge Richard husbandman 770164 770164 Coterygge, Richard, of Tolre Porcorum, husbandman 0
4799400 2295992 2295992 defendant Coterych William husbandman 770164 770164 Coterych, William, of Tolre Porcorum, husbandman 2
4828617 2304990 2304990 defendant Constable Thomas husbandman 770164 770164 Constable, Thomas, of Tolre Porcorum, husbandman 1
4828618 2304990 2304990 defendant Coteryche Richard husbandman 770164 770164 Coteryche, Richard, of Tolre Porcorum, husbandman 2
4884876 2322167 2322167 defendant Coteryche Richard husbandman 770164 770164 Coteryche, Richard, of Tolre Porcorum, husbandman 0
4884877 2322167 2322167 defendant Constable Thomas husbandman 770164 770164 Constable, Thomas, of Tolre Porcorum, husbandman 1
4884878 2322167 2322167 defendant Servant Walter husbandman 770164 770164 Servant, Walter, of Tolre Porcorum, husbandman 2
4884880 2322167 2322167 defendant Skynner Joan widow 770164 770164 Skynner, Joan, of Tolre Porcorum, widow 4
4956017 2343765 2343765 defendant Coterygge Richard husbandman 770164 770164 Coterygge, Richard, of Tolre Porcorum, 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);