names

17 rows where place_id = 756101

✎ 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
4434109 2175431 2175431 defendant Umfrey Robert   756101 756101 Umfrey, Robert, of Buttele 0
4450154 2185008 2185008 plaintiff (not given) William de prior of Halesworth 756101 756101 Halesworth, William de, of buttele, prior of the church, of the BM 0
4626898 2239356 2239356 plaintiff (not given) William prior of Randeworth 756101 756101 Randeworth, William, of Buttele, prior of the church of the BM 0
4626912 2239363 2239363 plaintiff Raneworthe William   756101 756101 Raneworthe, William, of Buttele, prior & successor of William Halesworth, the former prior 0
4626914 2239364 2239364 plaintiff Raneworthe William   756101 756101 Raneworthe, William, of Buttele, prior, successor to William Halesworthe 0
4671746 2256807 2256807 defendant Andrew John husbandman 756101 756101 Andrew, John, of Buttele, husbandman 1
4695959 2264223 2264223 plaintiff OR Prior William   756101 756101 OR Prior, William, of Buttele 0
4713439 2269526 2269526 defendant Prentys Robert smith 756101 756101 Prentys, Robert, of Buttele, smith 1
4809871 2299249 2299249 defendant Langwade John yeoman 756101 756101 Langwade, John, of Buttele, yeoman 0
4875257 2319214 2319214 defendant Bokenham John gent 756101 756101 Bokenham, John, of Buttele, gent 0
4885588 2322371 2322371 defendant Seman Thomas yeoman 756101 756101 Seman, Thomas, of Buttele, yeoman 5
4910579 2329817 2329817 defendant Reppys John husbandman 756101 756101 Reppys, John, of Buttele, husbandman 2
5020374 2362842 2362842 defendant Clerk Alexander yeoman 756101 756101 Clerk, Alexander, of Buttele, yeoman 0
5307564 2447277 2447277 plaintiff (not given) William prior of Poley 756101 756101 Poley, William, of Buttele, prior of the monastery of the BM 0
5433440 2484960 2484960 defendant Petyt Thomas (legal representative) 756101 756101 Petyt, Thomas, of Buttele, yeoman, executors of 0
5447438 2489122 2489122 defendant Petyt Thomas (legal representative) 756101 756101 Petyt, Thomas, of Buttele, yeoman, executors of 0
5473054 2496896 2496896 defendant Petyt Thomas (legal representative) 756101 756101 Petyt, Thomas, of Buttele, yeoman, executors of 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);