names

12 rows where place_id = 767777

✎ 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
4543013 2213706 2213706 plaintiff Knappeton Richard   767777 767777 (Knappeton, Richard, of Wenham Combusta 1
4577274 2224411 2224411 defendant Clerk John   767777 767777 Clerk, John, of Wenham Combusta 2
4580458 2225374 2225374 defendant Clerk John   767777 767777 Clerk, John, of Wenham Combusta 0
4580468 2225376 2225376 defendant Clerk John   767777 767777 Clerk, John, of Wenham Combusta 0
4691487 2262861 2262861 defendant Cardenall Adam yeoman 767777 767777 Cardenall, Adam, of Wenham Combusta, yeoman 0
4835810 2307192 2307192 defendant Cardenal Adam yeoman 767777 767777 Cardenal, Adam, of Wenham Combusta, yeoman 11
4842519 2309196 2309196 defendant Cardenall Adam husbandman 767777 767777 Cardenall, Adam, of Wenham Combusta, husbandman 0
4863199 2315467 2315467 defendant Cardenal Adam yeoman 767777 767777 Cardenal, Adam, of Wenham Combusta, yeoman 2
5089885 2383418 2383418 defendant Goffe or Gosse John husbandman 767777 767777 Goffe or Gosse, John, of Wenham Combusta, husbandman 0
5093404 2384468 2384468 defendant Gosse John husbandman 767777 767777 Gosse, John, of Wenham Combusta, husbandman 0
5295437 2443658 2443658 defendant Cardenall Stephen yeoman 767777 767777 Cardenall, Stephen, of Wenham Combusta, yeoman 0
5310222 2448092 2448092 defendant Clerke Thomas husbandman 767777 767777 Clerke, Thomas, of Wenham Combusta, husbandman 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);