names

38 rows where place_id = 594624

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616885 1872913 1872913 defendant Boucher John butcher 594624 594624 Boucher, John, of Payhembury, butcher 0
3637980 1906698 1906698 defendant Robyns Richard dyer 594624 594624 Robyns, Richard, of Payhembury, dyer 4
3691885 1923622 1923622 defendant Trussele Thomas tucker 594624 594624 Trussele, Thomas, of Payhembury, tucker 0
3749555 1941773 1941773 defendant Truslowe Thomas chapman 594624 594624 Truslowe, Thomas, of Payhembury, chapman 4
3789682 1954603 1954603 defendant Truslade Thomas husbandman 594624 594624 Truslade, Thomas, of Payhembury, husbandman 0
3868263 1979622 1979622 defendant Salter alias Elys John husbandman 594624 594624 Salter alias Elys, John, of Payhembury, husbandman 0
3955344 2008937 2008937 plaintiff Marker Thomas (legal representative) 594624 594624 Marker, Thomas, of Payhembury, clothier, executor of 0
4651343 2246420 2246420 defendant Rygge Henry husbandman 594624 594624 Rygge, Henry, of Payhembury, husbandman 0
4684986 2260903 2260903 plaintiff Rigge Henry husbandman 594624 594624 Rigge, Henry, of Payhembury, husbandman 0
4725314 2273208 2273208 defendant atte Vyker John laborer 594624 594624 atte Vyker, John, of Payhembury, laborer 0
4857875 2313830 2313830 defendant Flay William husbandman 594624 594624 Flay, William, of Payhembury, husbandman 1
4881661 2321162 2321162 defendant Rigge Henry chapman 594624 594624 Rigge, Henry, of Payhembury, chapman 0
4901343 2327027 2327027 defendant Crosse John   594624 594624 Crosse, John, of Payhembury, bailiff 0
4947389 2341180 2341180 defendant Flay or Folay Walter husbandman 594624 594624 Flay or Folay, Walter, of Payhembury, husbandman 1
4974432 2349314 2349314 defendant Harry Elias   594624 594624 Harry, Elias, of Payhembury, millward 0
5111528 2389770 2389770 defendant Wray William clerk 594624 594624 Wray, William, of Payhembury, clerk 0
5111529 2389770 2389770 defendant Deke William smith 594624 594624 Deke, William, of Payhembury, smith 1
5111530 2389770 2389770 defendant Olde John   594624 594624 Olde, John, of Payhembury, holy water clerk 2
5111531 2389770 2389770 defendant Cole William husbandman 594624 594624 Cole, William, of Payhembury, husbandman 3
5170343 2407056 2407056 defendant Olde John   594624 594624 Olde, John, of Payhembury, holy water clerk 0
5170346 2407056 2407056 defendant Wrey William clerk 594624 594624 together with Wrey, William, of Payhembury, clerk 3
5170347 2407056 2407056 defendant Dode William smith 594624 594624 Dode, William, of Payhembury, smith 4
5170348 2407056 2407056 defendant Cole William husbandman 594624 594624 Cole, William, of Payhembury, husbandman 5
5209293 2418451 2418451 defendant Myller Thomas husbandman 594624 594624 Myller, Thomas, of Payhembury, husbandman 1
5215190 2420169 2420169 defendant Gage John husbandman 594624 594624 Gage, John, of Payhembury, husbandman 0
5270814 2436560 2436560 defendant Gegge Nicholas husbandman 594624 594624 Gegge, Nicholas, of Payhembury, husbandman 0
5270815 2436560 2436560 defendant Blake John laborer 594624 594624 Blake, John, of Payhembury, laborer 1
5270816 2436560 2436560 defendant Salter John butcher 594624 594624 Salter, John, of Payhembury, butcher 2
5270817 2436560 2436560 defendant Salter Ellis butcher 594624 594624 Salter, Ellis, of Payhembury, butcher 3
5270818 2436560 2436560 defendant Shirford William laborer 594624 594624 Shirford, William, of Payhembury, laborer 4
5424560 2482320 2482320 defendant Miller John husbandman 594624 594624 Miller, John, of Payhembury, husbandman 0
5424561 2482320 2482320 defendant Blake John husbandman 594624 594624 Blake, John, of Payhembury, husbandman 1
5424562 2482320 2482320 defendant Flay John husbandman 594624 594624 Flay, John, of Payhembury, husbandman 2
5488002 2501302 2501302 defendant Salter John husbandman 594624 594624 Salter, John, of Payhembury, husbandman 0
5488003 2501302 2501302 defendant Gegge Nicholas husbandman 594624 594624 Gegge, Nicholas, of Payhembury, husbandman 1
5518368 2510572 2510572 defendant Salter John husbandman 594624 594624 Salter, John, of Payhembury, husbandman 3
5525981 2512721 2512721 defendant Skynner alias Bocher John butcher 594624 594624 Skynner alias Bocher, John, of Payhembury, butcher 0
5573567 2526834 2526834 defendant Robyns Richard dyer 594624 594624 Robyns, Richard, of Payhembury, dyer 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);