names

41 rows where place_id = 592327

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607367 1869965 1869965 defendant Barker John innholder 592327 592327 Barker, John, of Melford, Suff, innholder 0
3607372 1869967 1869967 defendant Barker John innholder 592327 592327 Barker, John, of Melford, Suff, innholder 0
3678044 1919177 1919177 plaintiff Martyn Roger esq 592327 592327 Martyn, Roger, of Melford, Suff, esq 0
3747277 1941071 1941071 plaintiff Dyke John yeoman 592327 592327 Dyke, John, of Melford, Suff, yeoman 0
3763065 1946079 1946079 defendant Gogger Joan widow 592327 592327 Gogger, Joan, of Melford, Suff, widow 4
3763070 1946080 1946080 defendant Goggar Joan widow 592327 592327 Goggar, Joan, of Melford, Suff, widow 3
3818362 1963643 1963643 defendant Smyth Thomas clothman 592327 592327 Smyth, Thomas, of Melford, Suff, clothman 5
3819173 1963884 1963884 defendant Barker John, senior yeoman 592327 592327 Barker, John, senior, of Melford, Suff, yeoman 0
3844002 1971666 1971666 defendant Penyngton Francis widow 592327 592327 Penyngton, Francis, of Melford, Suff, widow 1
3872519 1981033 1981033 defendant Gage Robert clothmaker 592327 592327 Gage, Robert, of Melford, Suff, clothmaker 2
3913001 1994680 1994680 defendant Bate John sherman 592327 592327 (Bate, John, of Melford, Suff, sherman 1
3939650 2003568 2003568 defendant Dasshe William husbandman 592327 592327 Dasshe, William, of Melford, Suff, husbandman 0
3974999 2015818 2015818 defendant Drewe James yeoman 592327 592327 Drewe, James, of Melford, Suff, yeoman 0
4275721 2121455 2121455 defendant Mayer John gent 592327 592327 Mayer, John, of Melford, Suff, gent 0
4275723 2121456 2121456 defendant Mayer John gent 592327 592327 Mayer, John, of Melford, Suff, gent 0
4495353 2199227 2199227 defendant Fullere Richard   592327 592327 Fullere, Richard, of Melford, Suff 0
4527654 2208931 2208931 defendant Petyt John   592327 592327 Petyt, John, of Melford, Suff 0
4661206 2249330 2249330 defendant Dextere Roger weaver 592327 592327 Dextere, Roger, of Melford, Suff, weaver 0
4662081 2249617 2249617 defendant Holbrygge William smith 592327 592327 Holbrygge, William, of Melford, Suff, smith 0
4694792 2263864 2263864 defendant Garne_ Thomas esq 592327 592327 Garne_, Thomas, of Melford, Suff, esq 2
4703491 2266475 2266475 defendant Gugge Seamus yeoman 592327 592327 Gugge, Seamus, of Melford, Suff, yeoman 2
4803205 2297193 2297193 defendant Cok Simon husbandman 592327 592327 Cok, Simon, of Melford, Suff, husbandman 1
4829334 2305214 2305214 defendant Cok Simon husbandman 592327 592327 Cok, Simon, of Melford, Suff, husbandman 0
4854766 2312845 2312845 defendant atte Helle John husbandman 592327 592327 atte Helle, John, of Melford, Suff, husbandman 0
4859733 2314409 2314409 defendant Taillour Robert yeoman 592327 592327 Taillour, Robert, of Melford, Suff, yeoman 3
4943660 2339986 2339986 defendant Brokhole Richard yeoman 592327 592327 Brokhole, Richard, of Melford, Suff, yeoman 3
5080728 2380730 2380730 defendant Brighthill Richard clothman 592327 592327 Brighthill, Richard, of Melford, Suff, clothman 1
5080735 2380731 2380731 defendant Brighthif Richard clothmaker 592327 592327 Brighthif, Richard, of Melford, Suff, clothmaker 1
5115499 2390959 2390959 defendant atte Hoo William yeoman 592327 592327 atte Hoo, William, of Melford, Suff, yeoman 0
5142599 2398964 2398964 defendant Carter Richard husbandman 592327 592327 Carter, Richard, of Melford, Suff, husbandman 0
5177523 2409122 2409122 defendant Carter Richard husbandman 592327 592327 Carter, Richard, of Melford, Suff, husbandman 0
5281155 2439562 2439562 defendant Muryell Roger merchant 592327 592327 Muryell, Roger, of Melford, Suff, merchant 0
5350229 2460193 2460193 defendant Redynall Thomas yeoman 592327 592327 Redynall, Thomas, of Melford, Suff, yeoman 1
5350234 2460194 2460194 defendant Redenhall Thomas clothmaker 592327 592327 Redenhall, Thomas, of Melford, Suff, clothmaker 2
5350239 2460195 2460195 defendant Redenhall Thomas clothmaker 592327 592327 Redenhall, Thomas, of Melford, Suff, clothmaker 2
5448894 2489559 2489559 defendant Grome William yeoman 592327 592327 (Grome, William, of Melford, Suff, yeoman 7
5461095 2493261 2493261 defendant Grome Nicholas (legal representative) 592327 592327 Grome, Nicholas, of Melford, Suff, yeoman, executors of 6
5461096 2493261 2493261 defendant Grome William yeoman 592327 592327 (Grome, William, of Melford, Suff, yeoman 7
5461097 2493261 2493261 defendant Woode Mathew yeoman 592327 592327 Woode, Mathew, of Melford, Suff, yeoman 8
5512472 2508763 2508763 plaintiff Martyn Richard merchant 592327 592327 Martyn, Richard, of Melford, Suff, merchant 0
5627517 2552578 2552578 defendant Webb John yeoman 592327 592327 Webb, John, of Melford, Suff, yeoman 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);