names

37 rows where place_id = 591129

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603424 1868739 1868739 defendant Goddyng William clerk 591129 591129 Goddyng, William, of Shirford, clerk 13
3637411 1906507 1906507 plaintiff Smyth Henry (legal representative) 591129 591129 Smyth, Henry, of Shirford, esq, executrix of 0
3637415 1906508 1906508 plaintiff Smyth Henry (legal representative) 591129 591129 Smyth, Henry, of Shirford, esq, executrix of 0
3842691 1971246 1971246 defendant Wakeham Richard husbandman 591129 591129 Wakeham, Richard, of Shirford, husbandman 0
4523847 2207787 2207787 defendant Carpenter John   591129 591129 Carpenter, John, of Shirford 2
4524695 2208061 2208061 defendant Carpenter John   591129 591129 Carpenter, John, of Shirford 0
4541303 2213178 2213178 plaintiff Wolverych John   591129 591129 Wolverych, John, of Shirford 0
4541305 2213179 2213179 plaintiff Wolverych John   591129 591129 Wolverych, John, of Shirford 0
4541598 2213267 2213267 defendant Carpenter John   591129 591129 Carpenter, John, of Shirford 0
4558022 2218444 2218444 defendant Seymour John clerk 591129 591129 Seymour, John, of Shirford, clerk 0
4578007 2224627 2224627 defendant Belle Margaret   591129 591129 (Belle, Margaret, of Shirford, formerly wife of John 1
4578008 2224627 2224627 defendant Belle Robert   591129 591129 Belle, Robert, of Shirford 2
4693288 2263402 2263402 defendant Belle Robert husbandman 591129 591129 Belle, Robert, of Shirford, husbandman 1
4693289 2263402 2263402 defendant Crane Thomas laborer 591129 591129 Crane, Thomas, of Shirford, laborer 2
4731911 2275162 2275162 defendant Doraunt John   591129 591129 Doraunt, John, of Shirford, wright 0
4731912 2275162 2275162 defendant Webstere William weaver 591129 591129 Webstere, William, of Shirford, weaver 1
4732716 2275413 2275413 defendant Wryght William husbandman 591129 591129 Wryght, William, of Shirford, husbandman 0
4810010 2299287 2299287 defendant Cok John   591129 591129 Cok, John, of Shirford, parson 3
4810013 2299288 2299288 defendant Cok John   591129 591129 Cok, John, of Shirford, parson 1
4823782 2303524 2303524 defendant Cok John clerk 591129 591129 Cok, John, of Shirford, clerk 0
4876812 2319719 2319719 defendant Wryght William yeoman 591129 591129 Wryght, William, of Shirford, yeoman 0
4877846 2320031 2320031 defendant Cok John clerk 591129 591129 Cok, John, of Shirford, clerk 3
4878392 2320189 2320189 defendant Wa- Nicholas yeoman 591129 591129 Wa-, Nicholas, of Shirford, yeoman 3
4878408 2320190 2320190 defendant Wake John yeoman 591129 591129 Wake, John, of Shirford, yeoman 9
4919684 2332663 2332663 defendant Hervy Edmund husbandman 591129 591129 Hervy, Edmund, of Shirford, husbandman 0
4922771 2333535 2333535 defendant Mallory Philippa   591129 591129 Mallory, Philippa, of Shirford, widow, formerly wife of John Mallorry 0
5244362 2428533 2428533 defendant Sanger John husbandman 591129 591129 Sanger, John, of Shirford, husbandman 0
5244363 2428533 2428533 defendant Wakeham Thomas laborer 591129 591129 Wakeham, Thomas, of Shirford, laborer 1
5372172 2466886 2466886 defendant Curteys John yeoman 591129 591129 Curteys, John, of Shirford, yeoman 1
5383397 2470331 2470331 plaintiff Hynryngham Robert   591129 591129 Hynryngham, Robert, of Shirford 1
5415395 2479538 2479538 defendant Curteys John yeoman 591129 591129 Curteys, John, of Shirford, yeoman 1
5431606 2484408 2484408 defendant Curteys John yeoman 591129 591129 Curteys, John, of Shirford, yeoman 1
5431609 2484409 2484409 defendant Curteys John yeoman 591129 591129 Curteys, John, of Shirford, yeoman 1
5431611 2484410 2484410 defendant Curteys John yeoman 591129 591129 Curteys, John, of Shirford, yeoman 0
5496028 2503704 2503704 defendant Goddyng William clerk 591129 591129 Goddyng, William, of Shirford, clerk 3
5508456 2507513 2507513 defendant Venter William husbandman 591129 591129 Venter, William, of Shirford, husbandman 5
5623629 2551328 2551328 defendant Bonde Thomas chaplain 591129 591129 Bonde, Thomas, of Shirford, chaplain 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);