names

51 rows where place_id = 585867

✎ 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
3587387 1863697 1863697 defendant Smyth Thomas yeoman 585867 585867 Smyth, Thomas, of Maughfeld, yeoman 0
3593656 1865650 1865650 defendant Dorraunte William butcher 585867 585867 Dorraunte, William, of Maughfeld, butcher 0
3593658 1865651 1865651 defendant Dorraunte William butcher 585867 585867 Dorraunte, William, of Maughfeld, butcher 0
3593660 1865652 1865652 defendant Edward John smith 585867 585867 Edward, John, of Maughfeld, smith 0
3593662 1865653 1865653 defendant Edward John smith 585867 585867 Edward, John, of Maughfeld, smith 0
3593666 1865655 1865655 defendant Smyth Thomas yeoman 585867 585867 Smyth, Thomas, of Maughfeld, yeoman 0
3593668 1865656 1865656 defendant Smyth Thomas yeoman 585867 585867 Smyth, Thomas, of Maughfeld, yeoman 0
3593670 1865657 1865657 defendant Smyth Thomas yeoman 585867 585867 Smyth, Thomas, of Maughfeld, yeoman 0
3601812 1868224 1868224 defendant Longe John husbandman 585867 585867 Longe, John, of Maughfeld, husbandman 3
3631732 1904735 1904735 defendant Harde William carpenter 585867 585867 Harde, William, of Maughfeld, carpenter 1
3704635 1927735 1927735 defendant Galett Agnes widow 585867 585867 Galett, Agnes, of Maughfeld, widow 2
3911536 1994176 1994176 plaintiff Wenborne William   585867 585867 Wenborne, William, of Maughfeld 0
3943895 2004974 2004974 plaintiff Aynscombe Gregory   585867 585867 Aynscombe, Gregory, of Maughfeld 0
3949190 2006786 2006786 plaintiff Duplake Thomas weaver 585867 585867 Duplake, Thomas, of Maughfeld, weaver 0
3991406 2021679 2021679 defendant Baker William yeoman 585867 585867 Baker, William, of Maughfeld, yeoman 1
4055390 2044323 2044323 defendant Jelbert George yeoman 585867 585867 Jelbert, George, of Maughfeld, yeoman 0
4055806 2044458 2044458 plaintiff Bocher Edward yeoman 585867 585867 Bocher, Edward, of Maughfeld, yeoman 0
4064596 2047619 2047619 defendant Rolff William yeoman 585867 585867 Rolff, William, of Maughfeld, yeoman 0
4074741 2051266 2051266 defendant Kenward John yeoman 585867 585867 Kenward, John, of Maughfeld, yeoman 0
4074743 2051266 2051266 defendant Eversfeld Nicholas husbandman 585867 585867 Eversfeld, Nicholas, of Maughfeld, husbandman 2
4074744 2051266 2051266 defendant Eversfeld John husbandman 585867 585867 together with Eversfeld, John, of Maughfeld, husbandman 3
4075147 2051415 2051415 defendant Kenward John yeoman 585867 585867 Kenward, John, of Maughfeld, yeoman 0
4075148 2051415 2051415 defendant Page Christopher husbandman 585867 585867 Page, Christopher, of Maughfeld, husbandman 1
4075149 2051415 2051415 defendant Everesfeld John husbandman 585867 585867 Everesfeld, John, of Maughfeld, husbandman 2
4075150 2051415 2051415 defendant Everesfeld Nicholas husbandman 585867 585867 Everesfeld, Nicholas, of Maughfeld, husbandman 3
4093182 2057878 2057878 defendant Quayle alias Seale John yeoman 585867 585867 Quayle alias Seale, John, of Maughfeld, yeoman 1
4107054 2062818 2062818 defendant Beckett George husbandman 585867 585867 Beckett, George, of Maughfeld, husbandman 2
4122466 2068344 2068344 defendant Howbeame William carpenter 585867 585867 Howbeame, William, of Maughfeld, carpenter 0
4155907 2080144 2080144 defendant Fuller John yeoman 585867 585867 Fuller, John, of Maughfeld, yeoman 0
4170329 2085114 2085114 defendant Sennock Thomas husbandman 585867 585867 Sennock, Thomas, of Maughfeld, husbandman 1
4195095 2093847 2093847 defendant Duke gregory husbandman 585867 585867 Duke, gregory, of Maughfeld, husbandman 3
4369849 2154271 2154271 defendant Muddell Hugh yeoman 585867 585867 Muddell, Hugh, of Maughfeld, yeoman 0
4485493 2196169 2196169 defendant Fraunceys Robert   585867 585867 Fraunceys, Robert, of Maughfeld 1
4488893 2197247 2197247 defendant Engeherst John   585867 585867 Engeherst, John, of Maughfeld 0
4548017 2215315 2215315 defendant Busy William   585867 585867 Busy, William, of Maughfeld 0
4891730 2324156 2324156 defendant Ponte William butcher 585867 585867 Ponte, William, of Maughfeld, butcher 2
4995747 2355569 2355569 defendant Croust Thomas butcher 585867 585867 Croust, Thomas, of Maughfeld, butcher 0
5177867 2409229 2409229 defendant Wynter John husbandman 585867 585867 Wynter, John, of Maughfeld, husbandman 0
5254482 2431523 2431523 defendant Forde John laborer 585867 585867 Forde, John, of Maughfeld, laborer 0
5254483 2431523 2431523 defendant Forde Thomas laborer 585867 585867 Forde, Thomas, of Maughfeld, laborer 1
5272623 2437068 2437068 defendant Forde John husbandman 585867 585867 Forde, John, of Maughfeld, husbandman 2
5296712 2444026 2444026 defendant Man Thomas yeoman 585867 585867 Man, Thomas, of Maughfeld, yeoman 0
5308504 2447579 2447579 defendant Gybbe Richard husbandman 585867 585867 Gybbe, Richard, of Maughfeld, husbandman 0
5332499 2454784 2454784 defendant Leyston John husbandman 585867 585867 Leyston, John, of Maughfeld, husbandman 0
5332500 2454784 2454784 defendant Weston William husbandman 585867 585867 Weston, William, of Maughfeld, husbandman 1
5338777 2456700 2456700 defendant Frende Thomas   585867 585867 Frende, Thomas, of Maughfeld, "rypyer" 0
5436315 2485796 2485796 defendant Germayn Richard yeoman 585867 585867 Germayn, Richard, of Maughfeld, yeoman 0
5436320 2485797 2485797 defendant Germayn Richard yeoman 585867 585867 Germayn, Richard, of Maughfeld, yeoman 0
5478131 2498485 2498485 defendant Wynter John husbandman 585867 585867 Wynter, John, of Maughfeld, husbandman 0
5540656 2517206 2517206 defendant Smyth Thomas yeoman 585867 585867 Smyth, Thomas, of Maughfeld, yeoman 0
5540657 2517206 2517206 defendant Dorraunte William butcher 585867 585867 Dorraunte, William, of Maughfeld, butcher 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);