names

27 rows where case_id = 2391777

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5118249 2391777 2391777 defendant Godfray John yeoman 586119 586119 Godfray, John, of Romsey, yeoman 0
5118250 2391777 2391777 defendant Notte Andrew husbandman 586119 586119 Notte, Andrew, of Romsey, husbandman 1
5118251 2391777 2391777 defendant Hunt Thomas   848458 848458 Hunt, Thomas, of Romsey, romsey 2
5118252 2391777 2391777 defendant Markes Robert yeoman 599030 599030 Markes, Robert, of Mottesfont, yeoman 3
5118253 2391777 2391777 defendant Markes John yeoman 599030 599030 Markes, John, of Mottesfont, yeoman 4
5118254 2391777 2391777 defendant Markes Thomas yeoman 599030 599030 Markes, Thomas, of Mottesfont, yeoman 5
5118255 2391777 2391777 defendant Thornhill William yeoman 599030 599030 Thornhill, William, of Mottesfont, yeoman 6
5118256 2391777 2391777 defendant Langford Thomas yeoman 586119 586119 Langford, Thomas, of Romsey, yeoman 7
5118257 2391777 2391777 defendant Wyksey William yeoman 585951 585951 Wyksey, William, of Winchester, yeoman 8
5118258 2391777 2391777 defendant de la Pantry Richard yeoman 585951 585951 de la Pantry, Richard, of Winchester, yeoman 9
5118259 2391777 2391777 defendant Mowele Thomas   599030 599030 Mowele, Thomas, of Mottesfont, groom 10
5118260 2391777 2391777 defendant Mowele John   599030 599030 Mowele, John, of Mottesfont, groom 11
5118261 2391777 2391777 defendant Galmyn Richard husbandman 783425 783425 Galmyn, Richard, of Michelmersshe, husbandman 12
5118262 2391777 2391777 defendant Bocher John merchant 586119 586119 Bocher, John, of Romsey, merchant 13
5118263 2391777 2391777 defendant Bolde John husbandman 597006 597006 together with Bolde, John, of Assheley, husbandman 14
5118264 2391777 2391777 defendant Courtener John husbandman 597006 597006 Courtener, John, of Assheley, husbandman 15
5118265 2391777 2391777 defendant Broune John husbandman 597006 597006 Broune, John, of Assheley, husbandman 16
5118266 2391777 2391777 defendant Berlyng John husbandman 597006 597006 Berlyng, John, of Assheley, husbandman 17
5118267 2391777 2391777 defendant Bonde William husbandman 597006 597006 Bonde, William, of Assheley, husbandman 18
5118268 2391777 2391777 defendant Stasy Thomas husbandman 589411 589411 Stasy, Thomas, of Lekford, husbandman 19
5118269 2391777 2391777 defendant Bowedon John husbandman 605126 605126 Bowedon, John, of Shirfeld, husbandman 20
5118270 2391777 2391777 defendant Russell Robert yeoman 620332 620332 Russell, Robert, of Bridport, Dorset, yeoman 21
5118271 2391777 2391777 defendant Richard John parson of Farle   Richard, John, parson of Farle 22
5118272 2391777 2391777 defendant Dene Thomas husbandman 610208 610208 Dene, Thomas, of Sombourn Regis, husbandman 23
5118273 2391777 2391777 defendant Seggeswyk John yeoman 587025 587025 Seggeswyk, John, of Houghton, yeoman 24
5118274 2391777 2391777 defendant Elys Augustine yeoman 592501 592501 Elys, Augustine, of Stokebrigge, yeoman 25
5118275 2391777 2391777 defendant Horn William chaplain 592501 592501 Horn, William, of Stokebrigge, chaplain 26

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);