names

36 rows where place_id = 812153

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4092135 2057482 2057482 defendant Trowell Thomas husbandman 812153 812153 Trowell, Thomas, of Salley, or of Wylstropp, husbandman 1
4848163 2310898 2310898 defendant Barker John tanner 812153 812153 Barker, John, of Salley, tanner 1
5020422 2362858 2362858 defendant Wythys John yeoman 812153 812153 Wythys, John, of Salley, yeoman 2
5153070 2402039 2402039 defendant Taillour Thomas yeoman 812153 812153 Taillour, Thomas, of Salley, yeoman 13
5170627 2407128 2407128 defendant Taillour Thomas yeoman 812153 812153 Taillour, Thomas, of Salley, yeoman 14
5406675 2476977 2476977 defendant Bothe John clerk 812153 812153 Bothe, John, of Salley, clerk 0
5406676 2476977 2476977 defendant Bothe William gent 812153 812153 Bothe, William, of Salley, gent 1
5406677 2476977 2476977 defendant Cutte William chaplain 812153 812153 Cutte, William, of Salley, chaplain 2
5406679 2476977 2476977 defendant Smyth Henry yeoman 812153 812153 Smyth, Henry, of Salley, yeoman 4
5426842 2482970 2482970 defendant Glome John laborer 812153 812153 Glome, John, of Salley, laborer 2
5426843 2482970 2482970 defendant Glome William laborer 812153 812153 Glome, William, of Salley, laborer 3
5498475 2504495 2504495 defendant Lemyng William barker 812153 812153 Lemyng, William, of Salley, barker 4
5498476 2504495 2504495 defendant Barhous William   812153 812153 Barhous, William, of Salley 5
5498477 2504495 2504495 defendant Skypton John tailor 812153 812153 Skypton, John, of Salley, tailor 6
5498478 2504495 2504495 defendant Abbot John weaver 812153 812153 Abbot, John, of Salley, weaver 7
5498479 2504495 2504495 defendant rasskell George husbandman 812153 812153 rasskell, George, of Salley, husbandman 8
5498480 2504495 2504495 defendant Kyng William laborer 812153 812153 Kyng, William, of Salley, laborer 9
5498481 2504495 2504495 defendant Wilkynson William yeoman 812153 812153 Wilkynson, William, of Salley, yeoman 10
5498482 2504495 2504495 defendant Lax John husbandman 812153 812153 Lax, John, of Salley, husbandman 11
5498483 2504495 2504495 defendant Askwyth William yeoman 812153 812153 Askwyth, William, of Salley, yeoman 12
5498484 2504495 2504495 defendant Horsman John husbandman 812153 812153 Horsman, John, of Salley, husbandman 13
5498485 2504495 2504495 defendant Wardrop Edmund laborer 812153 812153 Wardrop, Edmund, of Salley, laborer 14
5498486 2504495 2504495 defendant Walker William laborer 812153 812153 Walker, William, of Salley, laborer 15
5498493 2504496 2504496 defendant Barhous William laborer 812153 812153 Barhous, William, of Salley, laborer 5
5498494 2504496 2504496 defendant Skypton John tailor 812153 812153 Skypton, John, of Salley, tailor 6
5498495 2504496 2504496 defendant Abbot John weaver 812153 812153 Abbot, John, of Salley, weaver 7
5498496 2504496 2504496 defendant Raskell George husbandman 812153 812153 Raskell, George, of Salley, husbandman 8
5498497 2504496 2504496 defendant Kyng William laborer 812153 812153 Kyng, William, of Salley, laborer 9
5498498 2504496 2504496 defendant Wilkynson William yeoman 812153 812153 Wilkynson, William, of Salley, yeoman 10
5498499 2504496 2504496 defendant Lax John husbandman 812153 812153 Lax, John, of Salley, husbandman 11
5498500 2504496 2504496 defendant Askwyth William yeoman 812153 812153 Askwyth, William, of Salley, yeoman 12
5498501 2504496 2504496 defendant Horsman John husbandman 812153 812153 Horsman, John, of Salley, husbandman 13
5498502 2504496 2504496 defendant Wardrop Edmund laborer 812153 812153 Wardrop, Edmund, of Salley, laborer 14
5498503 2504496 2504496 defendant Walker William laborer 812153 812153 Walker, William, of Salley, laborer 15
5498506 2504497 2504497 defendant Wardrop Edmund laborer 812153 812153 Wardrop, Edmund, of Salley, laborer 1
5498507 2504497 2504497 defendant Lax John husbandman 812153 812153 Lax, John, of Salley, husbandman 2

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