names

25 rows where place_id = 613387

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3698071 1925623 1925623 defendant Welhod Margaret widow 613387 613387 Welhod, Margaret, of Colham, widow 1
3892631 1987783 1987783 defendant Dyconson Hugh gent 613387 613387 Dyconson, Hugh, of Colham, gent 0
4166970 2083948 2083948 defendant Pers Thomas miller 613387 613387 Pers, Thomas, of Colham, miller 3
4648714 2245681 2245681 defendant Sprendre John   613387 613387 Sprendre, John, of Colham 1
4943530 2339945 2339945 defendant le Straunge Richard   613387 613387 le Straunge, Richard, of Colham, knight 0
4969033 2347701 2347701 defendant Straunge Richard   613387 613387 Straunge, Richard, of Colham, knight 0
4972310 2348657 2348657 defendant Straunge Richard   613387 613387 Straunge, Richard, of Colham, knight 0
4995797 2355588 2355588 defendant Straunge Richard   613387 613387 Straunge, Richard, of Colham, knight 0
5001939 2357467 2357467 defendant Strange Richard   613387 613387 Strange, Richard, of Colham, knight 0
5001941 2357468 2357468 defendant Straunge Richard   613387 613387 Straunge, Richard, of Colham, knight 0
5002697 2357702 2357702 defendant Lestraunge Richard   613387 613387 Lestraunge, Richard, of Colham, knight 0
5002699 2357703 2357703 defendant Straunge Richard   613387 613387 Straunge, Richard, of Colham, knight 0
5010609 2359974 2359974 defendant Straunge Richard   613387 613387 Straunge, Richard, of Colham, knight 0
5026072 2364519 2364519 defendant Dary Richard husbandman 613387 613387 Dary, Richard, of Colham, husbandman 0
5029099 2365386 2365386 defendant Straunge Richard   613387 613387 (Straunge, Richard, of Colham, knight 1
5029563 2365515 2365515 defendant Yerd Nicholas husbandman 613387 613387 Yerd, Nicholas, of Colham, husbandman 0
5109892 2389321 2389321 defendant Nowell Thomas husbandman 613387 613387 Nowell, Thomas, of Colham, husbandman 1
5251290 2430505 2430505 defendant de la Straunge John   613387 613387 de la Straunge, John, of Colham, knight 0
5251325 2430515 2430515 defendant de la Straunge John   613387 613387 de la Straunge, John, of Colham, knight 0
5253020 2431051 2431051 plaintiff Birt Walter yeoman 613387 613387 Birt, Walter, of Colham, yeoman 0
5257615 2432501 2432501 defendant Partriche John husbandman 613387 613387 Partriche, John, of Colham, husbandman 0
5257618 2432502 2432502 defendant Partryche John husbandman 613387 613387 Partryche, John, of Colham, husbandman 0
5263576 2434356 2434356 defendant Partrich John husbandman 613387 613387 Partrich, John, of Colham, husbandman 0
5263578 2434357 2434357 defendant Partriche John husbandman 613387 613387 Partriche, John, of Colham, husbandman 0
5445470 2488543 2488543 defendant Dobbys John yeoman 613387 613387 Dobbys, John, of Colham, yeoman 1

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