names

32 rows where place_id = 596839

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626364 1903104 1903104 defendant Crymp Thomas husbandman 596839 596839 Crymp, Thomas, of Launston, husbandman 2
3626365 1903104 1903104 defendant Pyers John tailor 596839 596839 Pyers, John, of Launston, tailor 3
3704534 1927712 1927712 defendant Langdon Richard gent 596839 596839 Langdon, Richard, of Launston, gent 1
3704535 1927712 1927712 defendant Downyng John yeoman 596839 596839 Downyng, John, of Launston, yeoman 2
3704536 1927712 1927712 defendant Estys John yeoman 596839 596839 Estys, John, of Launston, yeoman 3
3754039 1943211 1943211 defendant Carlytton John gent 596839 596839 Carlytton, John, of Launston, gent 0
3796055 1956628 1956628 defendant Combsede Elsota widow 596839 596839 Combsede, Elsota, of Launston, widow 1
3811531 1961501 1961501 defendant Crowycott John yeoman 596839 596839 Crowycott, John, of Launston, yeoman 0
3838453 1969949 1969949 defendant Lynne John merchant 596839 596839 Lynne, John, of Launston, merchant 0
3846193 1972364 1972364 defendant Lynn John, junior merchant 596839 596839 Lynn, John, junior, of Launston, merchant 0
4078456 2052594 2052594 plaintiff Tamson John capper 596839 596839 Tamson, John, of Launston, capper 0
4606329 2233095 2233095 defendant Wotton John   596839 596839 Wotton, John, of Launston 0
4606332 2233096 2233096 defendant Wotton John   596839 596839 Wotton, John, of Launston 0
4662493 2249740 2249740 defendant Philpoy Robert husbandman 596839 596839 Philpoy, Robert, of Launston, husbandman 0
4902814 2327498 2327498 defendant Whyte Nicholas husbandman 596839 596839 Whyte, Nicholas, of Launston, husbandman 0
4902815 2327498 2327498 defendant Longewille William   596839 596839 together with Longewille, William, of Launston, bailiff 1
4902820 2327499 2327499 defendant Longewille William   596839 596839 Longewille, William, of Launston, bailiff 0
4934329 2337125 2337125 defendant Page Walter merchant 596839 596839 Page, Walter, of Launston, merchant 0
4996410 2355784 2355784 defendant Burnebury John merchant 596839 596839 Burnebury, John, of Launston, merchant 0
4996417 2355786 2355786 defendant Burnebury John merchant 596839 596839 Burnebury, John, of Launston, merchant 0
5135951 2397027 2397027 defendant Skynoll Stephen yeoman 596839 596839 Skynoll, Stephen, of Launston, yeoman 1
5156811 2403152 2403152 defendant Bolepyt William yeoman 596839 596839 Bolepyt, William, of Launston, yeoman 0
5163682 2405114 2405114 defendant Bolepyt William yeoman 596839 596839 Bolepyt, William, of Launston, yeoman 0
5317934 2450453 2450453 plaintiff Frye Walter   596839 596839 Frye, Walter, of Launston 0
5449027 2489603 2489603 plaintiff Maynard Richard (legal representative) 596839 596839 Maynard, Richard, of Launston, executors of 0
5461187 2493294 2493294 plaintiff Maynard Richard (legal representative) 596839 596839 Maynard, Richard, of Launston, executors of 0
5464159 2494187 2494187 plaintiff Stoterich Thomas (legal representative) 596839 596839 Stoterich, Thomas, of Launston, yeoman, executrix of 0
5472722 2496810 2496810 plaintiff Maynard Richard (legal representative) 596839 596839 Maynard, Richard, of Launston, executors of 0
5631329 2553800 2553800 defendant Huet Thomas chapman 596839 596839 Huet, Thomas, of Launston, chapman 0
5631330 2553800 2553800 defendant Goylok Walter chapman 596839 596839 Goylok, Walter, of Launston, chapman 1
5631332 2553800 2553800 defendant Robyn Serlond smith 596839 596839 Robyn, Serlond, of Launston, smith 3
5631333 2553800 2553800 defendant Goudfende John shoemaker 596839 596839 Goudfende, John, of Launston, shoemaker 4

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