names

15 rows where place_id = 667499

✎ 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
3985340 2019514 2019514 defendant Franche Henry yeoman 667499 667499 Franche, Henry, of Eastwell, yeoman 0
3985343 2019515 2019515 defendant Frenche Henry yeoman 667499 667499 Frenche, Henry, of Eastwell, yeoman 1
4366239 2152966 2152966 defendant Bodill Anthony yeoman 667499 667499 Bodill, Anthony, of Eastwell, yeoman 0
4666199 2250901 2250901 plaintiff Ikham William (legal representative) 667499 667499 Ikham, William, of Eastwell, executors of 0
5001623 2357366 2357366 defendant Lymsey Edward gent 667499 667499 Lymsey, Edward, of Eastwell, gent 0
5001751 2357407 2357407 defendant Lymsey Edward gent 667499 667499 Lymsey, Edward, of Eastwell, gent 0
5165400 2405628 2405628 defendant Jurdan John butcher 667499 667499 Jurdan, John, of Eastwell, butcher 1
5165402 2405628 2405628 defendant Dudston Robert husbandman 667499 667499 Dudston, Robert, of Eastwell, husbandman 3
5189756 2412749 2412749 defendant Rykard John wheler alias weaver 667499 667499 Rykard, John, of Eastwell, wheler alias weaver 0
5322497 2451802 2451802 defendant Somer Roger husbandman 667499 667499 Somer, Roger, of Eastwell, husbandman 0
5322536 2451818 2451818 defendant Somer Roger husbandman 667499 667499 Somer, Roger, of Eastwell, husbandman 0
5449408 2489711 2489711 plaintiff Moylle Walter   667499 667499 Moylle, Walter, of Eastwell, knight, exeucutrix of 0
5461492 2493389 2493389 plaintiff Moylle Walter (legal representative) 667499 667499 Moylle, Walter, of Eastwell, knight, executrix of 0
5467519 2495219 2495219 defendant Bocher Richard butcher 667499 667499 Bocher, Richard, of Eastwell, butcher 0
5473116 2496916 2496916 plaintiff Moylle Walter (legal representative) 667499 667499 Moylle, Walter, of Eastwell, knight, executrix 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);