names

18 rows where place_id = 608636

✎ 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
3674606 1918109 1918109 defendant Goldeston Thomas husbandman 608636 608636 Goldeston, Thomas, of Egmer, husbandman 1
3762954 1946045 1946045 defendant Jekeler Thomas husbandman 608636 608636 Jekeler, Thomas, of Egmer, husbandman 1
3762960 1946046 1946046 defendant Jekker Thomas   608636 608636 Jekker, Thomas, of Egmer 4
3782271 1952209 1952209 defendant Jekeler Thomas husbandman 608636 608636 Jekeler, Thomas, of Egmer, husbandman 0
3790126 1954730 1954730 defendant Jecker Thomas husbandman 608636 608636 Jecker, Thomas, of Egmer, husbandman 0
3845415 1972128 1972128 defendant Jeglar Thomas yeoman 608636 608636 Jeglar, Thomas, of Egmer, yeoman 0
3855777 1975438 1975438 plaintiff Wenne Thomas (legal representative) 608636 608636 Wenne, Thomas, of Egmer, carpenter, executor of 0
3858464 1976307 1976307 defendant Jekler Thomas husbandman 608636 608636 Jekler, Thomas, of Egmer, husbandman 1
3865612 1978716 1978716 defendant Jaklone Thomas husbandman 608636 608636 Jaklone, Thomas, of Egmer, husbandman 0
3878543 1983068 1983068 defendant Jekeler Thomas husbandman 608636 608636 Jekeler, Thomas, of Egmer, husbandman 0
3990589 2021384 2021384 defendant Cooke Thomas yeoman 608636 608636 Cooke, Thomas, of Egmer, yeoman 0
4016905 2030746 2030746 defendant Cooke Thomas yeoman 608636 608636 Cooke, Thomas, of Egmer, yeoman 0
5053039 2372506 2372506 defendant Wylly Hamon gent 608636 608636 together with Wylly, Hamon, of Egmer, gent 1
5196448 2414712 2414712 defendant Ham William yeoman 608636 608636 Ham, William, of Egmer, yeoman 2
5284444 2440465 2440465 defendant Shelton alias Fleccher Thomas yeoman 608636 608636 Shelton alias Fleccher, Thomas, of Egmer, yeoman 4
5413395 2478936 2478936 defendant Goodfelawe John husbandman 608636 608636 Goodfelawe, John, of Egmer, husbandman 2
5417106 2480022 2480022 defendant Goodfelawe John husbandman 608636 608636 Goodfelawe, John, of Egmer, husbandman 1
5434263 2485183 2485183 defendant Goodfelawe John husbandman 608636 608636 Goodfelawe, John, of Egmer, husbandman 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);