names

31 rows where place_id = 586133

✎ 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
3588006 1863901 1863901 defendant Rygold Godfrey husbandman 586133 586133 Rygold, Godfrey, of Langele, husbandman 3
4413740 2169193 2169193 defendant Goldsmyth Robert le   586133 586133 Goldsmyth, Robert le, of Langele 0
4415990 2169888 2169888 defendant Goldsmyth Robert le   586133 586133 Goldsmyth, Robert le, of Langele 0
4418537 2170674 2170674 defendant Parker Richard   586133 586133 Parker, Richard, of Langele 0
4421913 2171729 2171729 defendant Smyth William le   586133 586133 Smyth, William le, of Langele 0
4428898 2173840 2173840 defendant Potter Richard le   586133 586133 Potter, Richard le, of Langele 1
4436493 2176151 2176151 defendant Wam Alan   586133 586133 Wam, Alan, of Langele 0
4440733 2182017 2182017 defendant Cooke John   586133 586133 Cooke, John, of Langele;. Cook, William, of Langele 0
4440736 2182018 2182018 defendant Cooke John   586133 586133 Cooke, John, of Langele 0
4471982 2191904 2191904 defendant Brid Thomas   586133 586133 Brid, Thomas, of Langele 0
4480645 2194612 2194612 defendant Bryd Thomas   586133 586133 Bryd, Thomas, of Langele 0
4480647 2194613 2194613 defendant Bryd Thomas   586133 586133 Bryd, Thomas, of Langele 0
4482730 2195304 2195304 defendant Barbour Richard   586133 586133 Barbour, Richard, of Langele 0
4492010 2198188 2198188 defendant Dodde John   586133 586133 Dodde, John, of Langele 3
4538681 2212375 2212375 defendant Aleyn John   586133 586133 Aleyn, John, of Langele 0
4607561 2233473 2233473 defendant Scorme William   586133 586133 Scorme, William, of Langele 5
4608498 2233765 2233765 defendant Baxtere Thomas   586133 586133 Baxtere, Thomas, of Langele 0
4636965 2242369 2242369 defendant Storme William   586133 586133 Storme, William, of Langele 1
4643800 2244283 2244283 defendant Jacob Robert   586133 586133 Jacob, Robert, of Langele 4
4679748 2259282 2259282 plaintiff Kyryell John   586133 586133 Kyryell, John, of Langele, on his own account 0
4705065 2266956 2266956 plaintiff Keryell John   586133 586133 Keryell, John, of Langele 0
4795215 2294652 2294652 defendant Lyon William laborer 586133 586133 Lyon, William, of Langele, laborer 2
4823803 2303528 2303528 defendant Foster Thomas yeoman 586133 586133 Foster, Thomas, of Langele, yeoman 1
4887223 2322843 2322843 defendant Hornynge John   586133 586133 Hornynge, John, of Langele chaplain 3
4977842 2350331 2350331 defendant Swan William yeoman 586133 586133 Swan, William, of Langele, yeoman 2
4995440 2355479 2355479 defendant Cobbe Robert husbandman 586133 586133 Cobbe, Robert, of Langele, husbandman 2
5030376 2365757 2365757 defendant Borell John gent 586133 586133 Borell, John, of Langele, gent 0
5030377 2365757 2365757 defendant Jonson William yeoman 586133 586133 Jonson, William, of Langele, yeoman 1
5030378 2365757 2365757 defendant Cobbe John yeoman 586133 586133 Cobbe, John, of Langele, yeoman 2
5067677 2376826 2376826 defendant Neel John husbandman 586133 586133 Neel, John, of Langele, husbandman 1
5610230 2546912 2546912 defendant Hoxne John de   586133 586133 Hoxne, John de, of Langele 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);