names

39 rows where place_id = 607496

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3669502 1916399 1916399 defendant John William yeoman 607496 607496 John, William, of Helston Burgh, yeoman 1
3729868 1935598 1935598 defendant Trowte Thomas tailor 607496 607496 Trowte, Thomas, of Helston Burgh, tailor 0
3729869 1935598 1935598 defendant Kelleman William husbandman 607496 607496 Kelleman, William, of Helston Burgh, husbandman 1
3783332 1952538 1952538 defendant William Thomas glover 607496 607496 William, Thomas, of Helston Burgh, glover 0
3783333 1952538 1952538 defendant Geffrey Waren glover 607496 607496 Geffrey, Waren, of Helston Burgh, glover 1
3823316 1965206 1965206 defendant Baker Simon laborer 607496 607496 Baker, Simon, of Helston Burgh, laborer 0
3869953 1980191 1980191 defendant Trevena Henry laborer 607496 607496 Trevena, Henry, of Helston Burgh, laborer 1
3896147 1988915 1988915 defendant Trelogan William glover 607496 607496 Trelogan, William, of Helston Burgh, glover 2
3910422 1993801 1993801 defendant Trelegan William glover 607496 607496 Trelegan, William, of Helston Burgh, glover 2
4709435 2268305 2268305 defendant John Roger husbandman 607496 607496 John, Roger, of Helston Burgh, husbandman 4
4714640 2269912 2269912 defendant Bon William   607496 607496 Bon, William, of Helston Burgh, groom 0
4737054 2276718 2276718 defendant Bone William yeoman 607496 607496 Bone, William, of Helston burgh, yeoman 1
4737076 2276721 2276721 defendant Bone William yeoman 607496 607496 Bone, William, of Helston Burgh, yeoman 3
4737092 2276722 2276722 defendant Bone William yeoman 607496 607496 Bone, William, of Helston Burgh, yeoman 14
4737097 2276723 2276723 defendant Bone William yeoman 607496 607496 Bone, William, of Helston Burgh, yeoman 2
4758806 2283108 2283108 defendant Felyp Michael husbandman 607496 607496 Felyp, Michael, of Helston Burgh, husbandman 0
4758807 2283108 2283108 defendant Hervy John husbandman 607496 607496 Hervy, John, of Helston Burgh, husbandman 1
4796571 2295080 2295080 defendant Herry John husbandman 607496 607496 Herry, John, of Helston Burgh, husbandman 0
4828514 2304959 2304959 defendant Beye David husbandman 607496 607496 Beye, David, of Helston Burgh, husbandman 0
5008420 2359353 2359353 defendant Launargh John gent 607496 607496 Launargh, John, of Helston Burgh, gent 2
5009356 2359625 2359625 defendant Perkyn Thomas husbandman 607496 607496 Perkyn, Thomas, of Helston Burgh, husbandman 0
5009357 2359625 2359625 defendant Mellour Michael tailor 607496 607496 Mellour, Michael, of Helston Burgh, tailor 1
5009358 2359625 2359625 defendant Mellour William tailor 607496 607496 Mellour, William, of Helston Burgh, tailor 2
5009359 2359625 2359625 defendant Jakkerenvidyn John husbandman 607496 607496 Jakkerenvidyn , John, of Helston Burgh, husbandman 3
5009363 2359626 2359626 defendant Mellour Michael tailor 607496 607496 Mellour, Michael, of Helston Burgh, tailor 1
5009364 2359626 2359626 defendant Mellour William tailor 607496 607496 Mellour, William, of Helston Burgh, tailor 2
5009365 2359626 2359626 defendant Jakkerenandyn John husbandman 607496 607496 Jakkerenandyn, John, of Helston Burgh, husbandman 3
5151632 2401633 2401633 defendant Emont John mercer 607496 607496 Emont, John, of Helston Burgh, mercer 0
5162168 2404669 2404669 defendant Martyn John smith 607496 607496 Martyn, John, of Helston Burgh, smith 0
5169747 2406894 2406894 defendant Emount John mercer 607496 607496 Emount, John, of Helston Burgh, mercer 0
5176341 2408769 2408769 defendant Martyn John smith 607496 607496 Martyn, John, of Helston Burgh, smith 0
5304092 2446231 2446231 defendant Emond John mercer 607496 607496 Emond, John, of Helston Burgh, mercer 0
5304539 2446352 2446352 defendant Emond John mercer 607496 607496 Emond, John, of Helston Burgh, mercer 0
5306878 2447055 2447055 defendant Varcy John smith 607496 607496 Varcy, John, of Helston Burgh, smith 0
5306879 2447055 2447055 defendant Nole Robert husbandman 607496 607496 Nole, Robert, of Helston Burgh, husbandman 1
5306880 2447055 2447055 defendant James Henry weaver 607496 607496 James, Henry, of Helston Burgh, weaver 2
5306881 2447055 2447055 defendant Sampson Nicholas tiler 607496 607496 Sampson, Nicholas, of Helston Burgh, tiler 3
5306882 2447055 2447055 defendant Hoges William weaver 607496 607496 Hoges, William, of Helston Burgh, weaver 4
5500804 2505182 2505182 defendant Gelyot Joan widow 607496 607496 Gelyot, Joan, of Helston Burgh, widow 1

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