names

23 rows where place_id = 757927

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4449810 2184890 2184890 defendant Rous Richard le   757927 757927 Rous, Richard le, of Berkhampstede 0
4452924 2185921 2185921 defendant Coke John   757927 757927 Coke, John, of Berkhampstede 0
4488508 2197127 2197127 defendant Clerk John   757927 757927 Clerk, John, of Berkhampstede 0
4628849 2239953 2239953 defendant Bocher William   757927 757927 Bocher, William, of Berkhampstede 1
4639045 2242936 2242936 defendant Cook Richard   757927 757927 Cook, Richard, of Berkhampstede 0
4657509 2248242 2248242 plaintiff Cok Stephen   757927 757927 Cok, Stephen, of Berkhampstede 0
4675752 2258023 2258023 defendant Barry William (legal representative) 757927 757927 Barry, William, of Berkhampstede, executors of 0
4702032 2266047 2266047 defendant atte Burne Henry husbandman 757927 757927 atte Burne, Henry, of Berkhampstede, husbandman 1
4723272 2272589 2272589 defendant Turgys William yeoman bailiff of the liberty & honour 757927 757927 Turgys, William, of Berkhampstede, yeoman bailiff of the liberty & honour 1
4803580 2297305 2297305 defendant Hodevale John smith 757927 757927 Hodevale, John, of Berkhampstede, smith 0
4821942 2302935 2302935 defendant Wyn Walter clerk 757927 757927 Wyn, Walter, of Berkhampstede, clerk 0
4823225 2303352 2303352 defendant Stalle Alice widow & formerly wife of Richard Stalle 757927 757927 Stalle, Alice, of Berkhampstede, widow & formerly wife of Richard Stalle 0
4830826 2305668 2305668 defendant Molder Robert laborer 757927 757927 Molder, Robert, of Berkhampstede, laborer 0
4837164 2307576 2307576 defendant Middelyerd William tanner 757927 757927 Middelyerd, William, of Berkhampstede, tanner 0
4892929 2324518 2324518 defendant Bynde John miller 757927 757927 Bynde, John, of Berkhampstede, miller 5
4893511 2324670 2324670 defendant Hore John collier 757927 757927 Hore, John, of Berkhampstede, collier 0
4914889 2331167 2331167 plaintiff de Bury Joan (legal representative) 757927 757927 de Bury, Joan, of Berkhampstede, formerly wife of Stephen Cok, executor of 0
4914891 2331167 2331167 plaintiff Broun Bartarms Robert   757927 757927 Broun Bartarms, Robert, of Berkhampstede 2
4914893 2331167 2331167 plaintiff Newelove Robert   757927 757927 Newelove, Robert, of Berkhampstede, guardian of the church of St Peter 4
5000449 2357000 2357000 defendant Dene John yeoman 757927 757927 Dene, John, of Berkhampstede, yeoman 0
5032245 2366309 2366309 defendant Chaundeler John butcher 757927 757927 Chaundeler, John, of Berkhampstede, butcher 0
5032247 2366310 2366310 defendant Manne Thomas butcher 757927 757927 Manne, Thomas, of Berkhampstede, butcher 0
5060605 2374751 2374751 defendant Shorham John carpenter 757927 757927 Shorham, John, of Berkhampstede, carpenter 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);