names

13 rows where place_id = 611085

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686717 1921999 1921999 defendant Ede Richard   611085 611085 Ede, Richard, of Stodley 0
3730370 1935733 1935733 defendant Towyll John yeoman 611085 611085 Towyll, John, of Stodley, yeoman 0
3751085 1942268 1942268 defendant Trentham John butcher 611085 611085 Trentham, John, of Stodley, butcher 1
3751086 1942268 1942268 defendant Darrold William butcher 611085 611085 Darrold, William, of Stodley, butcher 2
3982897 2018660 2018660 defendant Prescote William husbandman 611085 611085 Prescote, William, of Stodley, husbandman 0
4820399 2302451 2302451 defendant Pouter Robert husbandman 611085 611085 Pouter, Robert, of Stodley, husbandman 0
4874403 2318936 2318936 plaintiff Quyntyn John   611085 611085 Quyntyn, John, of Stodley 0
4935814 2337592 2337592 defendant Eynesham Thomas husbandman 611085 611085 Eynesham, Thomas, of Stodley, husbandman 0
4940665 2339108 2339108 defendant Smyth William smith 611085 611085 Smyth, William, of Stodley, smith 0
5004118 2358092 2358092 defendant Shirburn Thomas husbandman 611085 611085 Shirburn, Thomas, of Stodley Rogger, husbandman 0
5466530 2494928 2494928 plaintiff (not given) Thomas prior of Awode 611085 611085 Awode, Thomas, of Stodley, prior of the house & church of St Peter 0
5610587 2547037 2547037 plaintiff Bargesdon Margery   611085 611085 Bargesdon, Margery, of Stodley, prioress 0
5611052 2547176 2547176 plaintiff Bergesden Margery   611085 611085 Bergesden, Margery, of Stodley, prioress 0

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