names

21 rows where place_id = 597588

✎ 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
3629133 1903984 1903984 defendant Fen Andrew mercer 597588 597588 Fen, Andrew, of Wolpett, mercer 0
3652240 1911040 1911040 defendant Fen Andrew mercer 597588 597588 Fen, Andrew, of Wolpett, mercer 0
3758277 1944585 1944585 plaintiff Bryghte William   597588 597588 Bryghte, William, of Wolpett 0
3790452 1954834 1954834 defendant Aborne William husbandman 597588 597588 Aborne, William, of Wolpett, husbandman 1
3812672 1961853 1961853 defendant Flode Simon husbandman 597588 597588 Flode, Simon, of Wolpett, husbandman 2
3833707 1968471 1968471 defendant Ungar Thomas baker 597588 597588 Ungar, Thomas, of Wolpett, baker 0
3838834 1970071 1970071 defendant Osbern William butcher 597588 597588 Osbern, William, of Wolpett, butcher 2
3852399 1974352 1974352 defendant Fen Robert mercer 597588 597588 Fen, Robert, of Wolpett, mercer 0
3967116 2013124 2013124 defendant Garrard Thomas yeoman 597588 597588 Garrard, Thomas, of Wolpett, yeoman 0
4025757 2033866 2033866 defendant Garrard John smith 597588 597588 Garrard, John, of Wolpett, smith 2
4047346 2041508 2041508 plaintiff Starlyng Alan beer brewer 597588 597588 Starlyng, Alan, of Wolpett, beer brewer 0
4047347 2041508 2041508 defendant Cretyng Robert husbandman 597588 597588 Cretyng, Robert, of Wolpett, husbandman 0
4111028 2064193 2064193 defendant Smythe Francis gent 597588 597588 Smythe, Francis, of Wolpett, gent 1
4211447 2099557 2099557 defendant Bonde Bartholomew yeoman 597588 597588 Bonde, Bartholomew, of Wolpett, yeoman 0
4211448 2099557 2099557 defendant Bonde John yeoman 597588 597588 Bonde, John, of Wolpett, yeoman 1
4222516 2103368 2103368 defendant Rushebrooke John clothier 597588 597588 Rushebrooke, John, of Wolpett, clothier 0
4222517 2103368 2103368 defendant Harrys Gilbert laborer 597588 597588 Harrys, Gilbert, of Wolpett, laborer 1
4274773 2121122 2121122 defendant Sharpe alias Smarte Robert shoemaker 597588 597588 Sharpe alias Smarte, Robert, of Wolpett, shoemaker 0
4301757 2130738 2130738 defendant Goodwyn Robert blacksmith 597588 597588 Goodwyn, Robert, of Wolpett, or of Stowmarkett, blacksmith 0
4301786 2130749 2130749 defendant Clothier Thomas husbandman 597588 597588 Clothier, Thomas, of Wolpett, husbandman 1
5593246 2532869 2532869 defendant Lane John butcher 597588 597588 Lane, John, of Wolpett, butcher 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);