names

29 rows where place_id = 605126

✎ 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
3660496 1913545 1913545 defendant Hoggyll Gilbert clerk 605126 605126 Hoggyll, Gilbert, of Shirfeld, clerk 0
3681673 1920363 1920363 defendant Joure John clothman 605126 605126 Joure, John, of Shirfeld, clothman 0
4446369 2183783 2183783 plaintiff Warbilton John Winchester diocese 605126 605126 Warbilton, John, of Shirfeld, Winchester diocese 2
4765143 2285076 2285076 defendant Pykernell John husbandman 605126 605126 Pykernell, John, of Shirfeld, husbandman 0
4778779 2289337 2289337 plaintiff Blake Richard   605126 605126 Blake, Richard, of Shirfeld 0
4778780 2289337 2289337 defendant Hull Richard husbandman 605126 605126 Hull, Richard, of Shirfeld, husbandman 0
4819225 2302092 2302092 defendant Poleyn John clerk 605126 605126 Poleyn, John, of Shirfeld, clerk 3
4840059 2308441 2308441 defendant Stryke Richard   605126 605126 Stryke, Richard, of Shirfeld, parson 0
4850702 2311674 2311674 defendant Smyth William husbandman 605126 605126 Smyth, William, of Shirfeld, husbandman 4
4850703 2311674 2311674 defendant Spencer Christine widow 605126 605126 Spencer, Christine, of Shirfeld, widow 5
4850704 2311674 2311674 defendant Hulles Isabel widow 605126 605126 Hulles, Isabel, of Shirfeld, widow 6
4969179 2347743 2347743 defendant Andrewe Henry laborer 605126 605126 Andrewe, Henry, of Shirfeld, laborer 0
4969180 2347743 2347743 defendant Child John husbandman 605126 605126 Child, John, of Shirfeld, husbandman 1
4972648 2348751 2348751 defendant Warbelton William esq 605126 605126 Warbelton, William, of Shirfeld, esq 0
4995958 2355640 2355640 defendant Coudray William yeoman 605126 605126 Coudray, William, of Shirfeld, yeoman 0
5015349 2361371 2361371 defendant Pykerell John, senior (legal representative) 605126 605126 Pykerell, John, senior, of Shirfeld, executors of 3
5015350 2361371 2361371 defendant Pykerell John, junior husbandman 605126 605126 (Pykerell, John, junior, of Shirfeld, husbandman 4
5015351 2361371 2361371 defendant Collys William husbandman 605126 605126 Collys, William, of Shirfeld, husbandman 5
5036514 2367541 2367541 defendant Wheler Nicholas   605126 605126 Wheler, Nicholas, of Shirfeld, groom 0
5106404 2388312 2388312 defendant Bowedon John husbandman 605126 605126 Bowedon, John, of Shirfeld, husbandman 6
5118269 2391777 2391777 defendant Bowedon John husbandman 605126 605126 Bowedon, John, of Shirfeld, husbandman 20
5243789 2428376 2428376 defendant Palmer John husbandman 605126 605126 Palmer, John, of Shirfeld, husbandman 0
5312799 2448857 2448857 defendant Wulfe Richard husbandman 605126 605126 Wulfe, Richard, of Shirfeld, husbandman 0
5312800 2448857 2448857 defendant Sterte John fuller 605126 605126 Sterte, John, of Shirfeld, fuller 1
5339808 2457024 2457024 defendant Shorter Richard husbandman 605126 605126 Shorter, Richard, of Shirfeld, husbandman 0
5339809 2457024 2457024 defendant Wulfe Richard husbandman 605126 605126 Wulfe, Richard, of Shirfeld, husbandman 1
5407261 2477139 2477139 defendant Hamildon Robert clerk 605126 605126 Hamildon, Robert,of Shirfeld, clerk 0
5439301 2486685 2486685 defendant Hamildon Robert clerk 605126 605126 Hamildon, Robert, of Shirfeld, clerk 0
5503549 2506025 2506025 defendant Willys John yeoman 605126 605126 Willys, John, of Shirfeld, yeoman 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);