names

23 rows where place_id = 618807

✎ 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
3726485 1934551 1934551 defendant Morres William husbandman 618807 618807 Morres, William, of Masseworth, Bucks, husbandman 0
3952132 2007818 2007818 plaintiff Haydon Ralph gent 618807 618807 Haydon, Ralph, of Masseworth, Bucks, gent 0
4674630 2257673 2257673 defendant G---- John woolman 618807 618807 G----, John, of Masseworth, Bucks, woolman 1
4674636 2257674 2257674 defendant Goodman John woolman 618807 618807 Goodman, John, of Masseworth, Bucks, woolman 1
4762351 2284206 2284206 defendant Godman John, sen yeoman 618807 618807 Godman, John, sen, of Masseworth, Bucks, son of John Godman, wool man, yeoman 3
4933221 2336780 2336780 defendant Slacok John clerk 618807 618807 Slacok, John, of Masseworth, Bucks, clerk 1
4938472 2338410 2338410 defendant Heth John yeoman 618807 618807 (Heth, John, of Masseworth, Bucks, yeoman 1
4954917 2343427 2343427 defendant Heth John yeoman 618807 618807 (Heth, John, of Masseworth, Bucks, yeoman 1
4981288 2351324 2351324 defendant Hethe John yeoman 618807 618807 (Hethe, John, of Masseworth, Bucks, yeoman 1
5007972 2359222 2359222 defendant Turges Thomas (legal representative) 618807 618807 Turges, Thomas, of Masseworth, Bucks, yeoman, executors of 0
5007973 2359222 2359222 defendant Hethe John yeoman 618807 618807 (Hethe, John, of Masseworth, Bucks, yeoman 1
5034650 2366992 2366992 defendant Turges Thomas (legal representative) 618807 618807 Turges, Thomas, of Masseworth, Bucks, yeoman, administrator of 0
5034653 2366993 2366993 defendant Turgis Thomas (legal representative) 618807 618807 Turgis, Thomas, of Masseworth, Bucks, yeoman, administrator of 0
5049916 2371599 2371599 defendant Turgys Thomas (legal representative) 618807 618807 Turgys, Thomas, of Masseworth, Bucks, yeoman, administrator of 0
5071905 2378092 2378092 defendant Turgys Thomas (legal representative) 618807 618807 Turgys, Thomas, of Masseworth, Bucks, yeoman, administrator of 0
5079493 2380358 2380358 defendant Salcok John husbandman 618807 618807 Salcok, John, of Masseworth, Bucks, husbandman 4
5079499 2380359 2380359 defendant Salcok John husbandman 618807 618807 Salcok, John, of Masseworth, Bucks, husbandman 4
5098363 2385951 2385951 defendant Paly Lawrence (legal representative) 618807 618807 Paly, Lawrence, of Masseworth, Bucks, husbandman, executors of 0
5098372 2385954 2385954 defendant Paly Lawrence (legal representative) 618807 618807 Paly, Lawrence, of Masseworth, Bucks, husbandman, executors of 0
5269917 2436309 2436309 defendant Salcok Walter husbandman 618807 618807 Salcok, Walter, of Masseworth, Bucks, husbandman 3
5423951 2482118 2482118 defendant Edmond John miller 618807 618807 Edmond, John, of Masseworth, Bucks, miller 1
5443027 2487823 2487823 defendant Bemond John   618807 618807 Bemond, John, of Masseworth, Bucks 0
5455765 2491624 2491624 defendant Edmond John milner 618807 618807 Edmond, John, of Masseworth, Bucks, milner 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);