names

32 rows where place_id = 758362

✎ 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
4453255 2186026 2186026 defendant Lyghtfot William   758362 758362 Lyghtfot, William, of Dorchestre 0
4454335 2186378 2186378 plaintiff Lyme William   758362 758362 Lyme, William, of Dorchestre 0
4488897 2197249 2197249 plaintiff Syward Roger (legal representative) 758362 758362 Syward, Roger, of Dorchestre, executor of 0
4494213 2198881 2198881 plaintiff Blount Peter   758362 758362 Blount, Peter, of Dorchestre 0
4494216 2198882 2198882 plaintiff Blount Peter   758362 758362 Blount, Peter, of Dorchestre 0
4494217 2198882 2198882 defendant Hert John   758362 758362 Hert, John, of Dorchestre 0
4495987 2199422 2199422 defendant Durant John   758362 758362 Durant, John, of Dorchestre 1
4496063 2199445 2199445 defendant Stote John   758362 758362 Stote, John, of Dorchestre 3
4505860 2202340 2202340 plaintiff Stote John   758362 758362 Stote, John, of Dorchestre 0
4578774 2224848 2224848 defendant Grevell Henry   758362 758362 Grevell, Henry, of Dorchestre 1
4606277 2233075 2233075 defendant Baron John   758362 758362 Baron, John, of Dorchestre 0
4656897 2248052 2248052 defendant Fogge John dyer 758362 758362 Fogge, John, of Dorchestre, dyer 11
4671856 2256841 2256841 defendant Smuth Thomas yeoman 758362 758362 Smuth, Thomas, of Dorchestre, yeoman 0
4681909 2259959 2259959 defendant Bailly William husbandman 758362 758362 Bailly, William, of Dorchestre, husbandman 0
4681910 2259959 2259959 defendant Stone John husbandman 758362 758362 Stone, John, of Dorchestre, husbandman 1
4783611 2290891 2290891 defendant Gerveys John carpenter 758362 758362 Gerveys, John, of Dorchestre, carpenter 0
4804592 2297629 2297629 defendant Leweston John yeoman 758362 758362 (Leweston, John, of Dorchestre, yeoman 1
4817361 2301515 2301515 defendant Forde John husbandman 758362 758362 Forde, John, of Dorchestre, husbandman 3
4914368 2331009 2331009 defendant Bertram Robert dyer 758362 758362 Bertram, Robert, of Dorchestre, dyer 0
4937266 2338020 2338020 defendant Bocher Walter butcher 758362 758362 Bocher, Walter, of Dorchestre, butcher 0
4944481 2340253 2340253 defendant Bocher Walter butcher 758362 758362 Bocher, Walter, of Dorchestre, butcher 0
4946244 2340811 2340811 defendant Carpenter Walter butcher 758362 758362 Carpenter, Walter, of Dorchestre, butcher 1
4949279 2341761 2341761 plaintiff Mose Robert (legal representative) 758362 758362 Mose, Robert, of Dorchestre, executors of 0
4949282 2341761 2341761 defendant Bere Richard   758362 758362 Bere, Richard, of Dorchestre, mercer, former apprentice of Mose, Robert 0
4949283 2341762 2341762 plaintiff Mose Robert (legal representative) 758362 758362 Mose, Robert, of Dorchestre, executors of 0
4971342 2348361 2348361 plaintiff Hore John   758362 758362 Hore, John, of Dorchestre 0
4973159 2348906 2348906 plaintiff Lee William   758362 758362 Lee, William, of Dorchestre 0
5024693 2364142 2364142 defendant Dikyn Robert yeoman 758362 758362 Dikyn, Robert, of Dorchestre, yeoman 0
5043725 2369747 2369747 defendant Bartram Robert dyer 758362 758362 Bartram, Robert, of Dorchestre, dyer 0
5117069 2391419 2391419 defendant Clement John (legal representative) 758362 758362 Clement, John, of Dorchestre, yeoman, executors of 0
5117070 2391419 2391419 defendant William David yeoman 758362 758362 (William, David, of Dorchestre, yeoman 1
5285753 2440859 2440859 defendant Curteys John yeoman 758362 758362 Curteys, John, of Dorchestre, yeoman 3

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