names

28 rows where case_id = 2388312

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5106397 2388312 2388312 plaintiff Cumberford William     Cumberford, William 0
5106398 2388312 2388312 defendant Bolde John husbandman 597006 597006 Bolde, John, of Assheley, husbandman 0
5106399 2388312 2388312 defendant Courtener John husbandman 597006 597006 Courtener, John, of Assheley, husbandman 1
5106400 2388312 2388312 defendant Broun John husbandman 597006 597006 Broun, John, of Assheley, husbandman 2
5106401 2388312 2388312 defendant Berlyng John husbandman 597006 597006 Berlyng, John, of Assheley, husbandman 3
5106402 2388312 2388312 defendant Bonde William husbandman 597006 597006 Bonde, William, of Assheley, husbandman 4
5106403 2388312 2388312 defendant Stasy Thomas husbandman 589411 589411 Stasy, Thomas, of Lekford, husbandman 5
5106404 2388312 2388312 defendant Bowedon John husbandman 605126 605126 Bowedon, John, of Shirfeld, husbandman 6
5106405 2388312 2388312 defendant Russell Robert yeoman 620332 620332 Russell, Robert, of Bridport, Dorset, yeoman 7
5106406 2388312 2388312 defendant Richard John parson of Farle   Richard, John, parson of Farle 8
5106407 2388312 2388312 defendant Dene Thomas husbandman 610208 610208 Dene, Thomas, of Sombourn Regis, husbandman 9
5106408 2388312 2388312 defendant Seggeswyk John yeoman 587025 587025 Seggeswyk, John, of Houghton, yeoman 10
5106409 2388312 2388312 defendant Elys Augustine yeoman 592501 592501 Elys, Augustine, of Stokebrigge, yeoman 11
5106410 2388312 2388312 defendant Horn William chaplain 592501 592501 Horn, William, of Stokebrigge, chaplain 12
5106411 2388312 2388312 defendant Godfray John yeoman 586119 586119 togethe with Godfray, John, of Romsey, yeoman 13
5106412 2388312 2388312 defendant Notte Andrew husbandman 586119 586119 Notte, Andrew, of Romsey, husbandman 14
5106413 2388312 2388312 defendant Hunt Thomas yeoman 586119 586119 Hunt, Thomas, of Romsey, yeoman 15
5106414 2388312 2388312 defendant Markes Robert yeoman 599030 599030 Markes, Robert, of Mottesfont, yeoman 16
5106415 2388312 2388312 defendant Markes John yeoman 599030 599030 Markes, John, of Mottesfont, yeoman 17
5106416 2388312 2388312 defendant Markes Thomas yeoman 599030 599030 Markes, Thomas, of Mottesfont, yeoman 18
5106417 2388312 2388312 defendant Thornhill William yeoman 599030 599030 Thornhill, William, of Mottesfont, yeoman 19
5106418 2388312 2388312 defendant Langford Thomas yeoman 599030 599030 Langford, Thomas, of Mottesfont, yeoman 20
5106419 2388312 2388312 defendant Wyksey William yeoman 585951 585951 Wyksey, William, of Winchester, yeoman 21
5106420 2388312 2388312 defendant de le Pantry Richard yeoman 585951 585951 de le Pantry, Richard, of Winchester, yeoman 22
5106421 2388312 2388312 defendant Mowele Thomas   599030 599030 Mowele, Thomas, of Mottesfont, groom 23
5106422 2388312 2388312 defendant Mowele John   599030 599030 Mowele, John, of Mottesfont, groom 24
5106423 2388312 2388312 defendant Galmyn Richard husbandman 783425 783425 Galmyn, Richard, of Michelmersshe, husbandman 25
5106424 2388312 2388312 defendant Bocher John merchant 586119 586119 Bocher, John, of Romsey, merchant 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);