names

31 rows where place_id = 764790

✎ 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
4509622 2203486 2203486 defendant Jayberd Alan   764790 764790 Jayberd, Alan, of Quappelad 0
4512317 2204292 2204292 defendant Coupere Richard   764790 764790 Coupere, Richard, of Quappelad 0
4530815 2209927 2209927 defendant Bryston Helen   764790 764790 Bryston, Helen, of Quappelad 0
4532162 2210326 2210326 plaintiff Porter John   764790 764790 Porter, John, of Quappelad 0
4532166 2210327 2210327 plaintiff Porter John   764790 764790 Porter, John, of Quappelad 0
4532167 2210327 2210327 defendant Litster William   764790 764790 Litster, William, of Quappelad 0
4532169 2210327 2210327 defendant Tolyet John   764790 764790 Tolyet, John, of Quappelad 2
4532172 2210327 2210327 defendant Storme William   764790 764790 Storme, William, of Quappelad 5
4532173 2210327 2210327 defendant Litster John   764790 764790 Litster, John, of Quappelad 6
4532179 2210330 2210330 plaintiff Porter John, sen   764790 764790 Porter, John, sen, of Quappelad 0
4532183 2210331 2210331 plaintiff Porter John, sen   764790 764790 Porter, John, sen, of Quappelad 0
4532186 2210331 2210331 defendant Kyriel John   764790 764790 Kyriel, John, of Quappelad 2
4538394 2212292 2212292 defendant Bosvyll John   764790 764790 Bosvyll, John, of Quappelad 3
4555621 2217686 2217686 defendant Welby Geoffrey   764790 764790 Welby, Geoffrey, of Quappelad 0
4562400 2219801 2219801 plaintiff Porter John   764790 764790 Porter, John, of Quappelad 0
4562401 2219801 2219801 defendant Averay Geoffrey   764790 764790 Averay, Geoffrey, of Quappelad 0
4562402 2219801 2219801 defendant Porter Geoffrey   764790 764790 Porter, Geoffrey, of Quappelad 1
4594520 2229544 2229544 plaintiff Porter John   764790 764790 Porter, John, of Quappelad 0
4594521 2229544 2229544 defendant Pertryktaker Robert   764790 764790 Pertryktaker, Robert, of Quappelad 0
4594522 2229544 2229544 defendant Baxster John   764790 764790 Baxster, John, of Quappelad 1
4602657 2232046 2232046 defendant Martynson John   764790 764790 Martynson, John, of Quappelad 0
4638947 2242914 2242914 defendant Lacy William   764790 764790 Lacy, William, of Quappelad, dyer, son of Simon 0
4677108 2258457 2258457 defendant Welby Geoffrey husbandman 764790 764790 Welby, Geoffrey, of Quappelad, husbandman 0
4677110 2258458 2258458 defendant Welby Geoffrey husbandman 764790 764790 Welby, Geoffrey, of Quappelad, husbandman 0
4706055 2267268 2267268 defendant Dockyng John yeoman 764790 764790 Dockyng, John, of Quappelad, yeoman 1
4782792 2290635 2290635 plaintiff Luff Simon   764790 764790 (Luff, Simon, of Quappelad 1
4787342 2292112 2292112 defendant Prowet John husbandman 764790 764790 Prowet, John, of Quappelad, husbandman 0
4787343 2292112 2292112 defendant Wenylsey William husbandman 764790 764790 Wenylsey, William, of Quappelad, husbandman 1
4787344 2292112 2292112 defendant Tunnok Thomas husbandman 764790 764790 Tunnok, Thomas, of Quappelad, husbandman 2
4787592 2292192 2292192 defendant Skarlet William husbandman 764790 764790 Skarlet, William, of Quappelad, husbandman 9
4992978 2354784 2354784 plaintiff Dockyng John husbandman 764790 764790 Dockyng, John, of Quappelad, 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);