names

16 rows where place_id = 587684

✎ 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
3592132 1865156 1865156 defendant Bolde Thomas husbandman 587684 587684 Bolde, Thomas, of Banstede, husbandman 0
3614996 1872334 1872334 plaintiff Cantelewe Geoffrey gent 587684 587684 Cantelewe, Geoffrey, of Banstede, gent 0
4414344 2169398 2169398 defendant Farnecroft Adam   587684 587684 Farnecroft, Adam, of Banstede 5
4414345 2169398 2169398 defendant Fraunk Peter   587684 587684 Fraunk, Peter, of Banstede 6
4414346 2169398 2169398 defendant Tykenore Richard de   587684 587684 Tykenore, Richard de, of Banstede 7
4417857 2170459 2170459 defendant Bures Robert   587684 587684 Bures, Robert, of Banstede, son of John 0
4421767 2171689 2171689 defendant Farnecroft Adam   587684 587684 Farnecroft, Adam, of Banstede 5
4421768 2171689 2171689 defendant Fraunk Peter   587684 587684 Fraunk, Peter, of Banstede 6
4480894 2194694 2194694 defendant Flesshewer Randolf   587684 587684 Flesshewer, Randolf, of Banstede 0
4480896 2194695 2194695 defendant Flesshhewer Randolf   587684 587684 Flesshhewer, Randolf, of Banstede 0
4545077 2214381 2214381 defendant Wyke Peter   587684 587684 Wyke, Peter, of Banstede 3
4558205 2218506 2218506 defendant Wyke Peter   587684 587684 Wyke, Peter, of Banstede 3
4616688 2236220 2236220 defendant Clerk John   587684 587684 Clerk, John, of Banstede 1
4668215 2255770 2255770 defendant Lampit John husbandman 587684 587684 Lampit, John, of Banstede, husbandman 0
4739970 2277579 2277579 defendant Halfhyde Roger husbandman 587684 587684 Halfhyde, Roger, of Banstede, husbandman 0
5233967 2425524 2425524 defendant Norse John, senior yeoman 587684 587684 Norse, John, senior, of Banstede, yeoman 2

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