names

15 rows where place_id = 669536

✎ 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
3993573 2022447 2022447 plaintiff Charke Robert clerk 669536 669536 Charke, Robert, of Belstede, clerk 0
4452202 2185670 2185670 defendant Shandran Richard   669536 669536 Shandran, Richard, of Belstede 2
4481621 2194947 2194947 defendant Cook William   669536 669536 Cook, William, of Belstede 2
4577262 2224408 2224408 defendant Waryn John   669536 669536 Waryn, John, of Belstede 0
4577269 2224410 2224410 defendant Waryn Philip   669536 669536 Waryn, Philip, of Belstede 0
4673912 2257458 2257458 defendant Neweport Robert fuller 669536 669536 Neweport, Robert, of Belstede, fuller 2
4723466 2272650 2272650 defendant Andrewe William husbandman 669536 669536 Andrewe, William, of Belstede, husbandman 0
4723467 2272650 2272650 defendant Neweman Thomas ploughman 669536 669536 Neweman, Thomas, of Belstede, ploughman 1
4723650 2272701 2272701 defendant Lodbroke John husbandman 669536 669536 Lodbroke, John, of Belstede, husbandman 0
4738466 2277122 2277122 defendant Mason William yeoman 669536 669536 Mason, William, of Belstede, yeoman 1
4844638 2309842 2309842 defendant Smyth John laborer 669536 669536 Smyth, John, of Belstede, laborer 0
4898485 2326177 2326177 plaintiff Wareyn John   669536 669536 Wareyn, John, of Belstede 6
4977487 2350231 2350231 defendant Caston Adam yeoman 669536 669536 Caston, Adam, of Belstede, yeoman 1
5346357 2459006 2459006 plaintiff Alderman Gilbert yeoman 669536 669536 Alderman, Gilbert, of Belstede, yeoman 0
5346360 2459007 2459007 plaintiff Alderman Gilbert yeoman 669536 669536 Alderman, Gilbert, of Belstede, yeoman 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);