names

41 rows where place_id = 619445

✎ 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
3729981 1935626 1935626 defendant Page John goldsmith 619445 619445 Page, John, of Stowe Markett, goldsmith 2
3732606 1936428 1936428 defendant Bacon Robert yeoman 619445 619445 Bacon, Robert, of Stowe Markett, yeoman 0
3738427 1938226 1938226 defendant Cottyngham John yeoman 619445 619445 Cottyngham, John, of Stowe Markett, yeoman 0
3738428 1938226 1938226 defendant Page Robert innkeeper 619445 619445 Page, Robert, of Stowe Markett, innkeeper 1
3738833 1938351 1938351 defendant Padnall John butcher 619445 619445 Padnall, John, of Stowe Markett, butcher 0
3739073 1938430 1938430 defendant Gerard Thomas sherman 619445 619445 Gerard, Thomas, of Stowe Markett, sherman 0
3740722 1938962 1938962 defendant Simond Richard husbandman 619445 619445 Simond, Richard, of Stowe Markett, husbandman 0
3742169 1939417 1939417 defendant Garrard Thomas sherman 619445 619445 Garrard, Thomas, of Stowe Markett, sherman 1
3742459 1939511 1939511 defendant Page Robert innholder 619445 619445 Page, Robert, of Stowe Markett, innholder 0
3742824 1939609 1939609 defendant Hamond alias Barker Roger laborer 619445 619445 Hamond alias Barker, Roger, of Stowe Markett, laborer 0
3742825 1939609 1939609 defendant Wynde John weaver 619445 619445 Wynde, John, of Stowe Markett, weaver 1
3767691 1947531 1947531 defendant Coppyng Robert pedder 619445 619445 Coppyng, Robert, of Stowe Markett, pedder 1
3767692 1947531 1947531 defendant Pyeman Richard sherman 619445 619445 Pyeman, Richard, of Stowe Markett, sherman 2
3767693 1947531 1947531 defendant Padnall John butcher 619445 619445 Padnall, John, of Stowe Markett, butcher 3
3777523 1950722 1950722 defendant Padmate Richard butcher 619445 619445 Padmate, Richard, of Stowe Markett, butcher 0
3796181 1956673 1956673 defendant Newport John yeoman 619445 619445 Newport, John, of Stowe Markett, yeoman 0
3840940 1970734 1970734 defendant Man John yeoman 619445 619445 Man, John, of Stowe Markett, yeoman 0
3884481 1985082 1985082 defendant Walker Thomas clerk 619445 619445 Walker, Thomas, of Stowe Markett, clerk 2
3900178 1990284 1990284 plaintiff Brydges Thomas gent 619445 619445 Brydges, Thomas, of Stowe Markett, gent 0
3907152 1992682 1992682 defendant Thorp William innholder 619445 619445 Thorp, William, of Stowe Markett, innholder 0
3910294 1993760 1993760 defendant Otley Firmun clothmaker 619445 619445 Otley, Firmun, of Stowe Markett, clothmaker 0
3946384 2005807 2005807 defendant Pykerell William clothier 619445 619445 Pykerell, William, of Stowe Markett, clothier 0
3949944 2007062 2007062 plaintiff Flegg John barber 619445 619445 Flegg, John, of Stowe Markett, barber 0
4034106 2036861 2036861 defendant Dyx Thomas   619445 619445 Dyx, Thomas, of Stowe Markett, carpet worker 0
4034115 2036863 2036863 defendant Dyx Thomas   619445 619445 Dyx, Thomas, of Stowe Markett, carpet worker 0
4034225 2036907 2036907 defendant Keble Robert yeoman 619445 619445 Keble, Robert, of Stowe Markett, yeoman 3
4034230 2036908 2036908 defendant Keble Robert yeoman 619445 619445 Keble, Robert, of Stowe Markett, yeoman 3
4037956 2038223 2038223 defendant Symond John clothier 619445 619445 Symond, John, of Stowe Markett, clothier 0
4045693 2040909 2040909 defendant Brydges Thomas yeoman 619445 619445 Brydges, Thomas, of Stowe Markett, yeoman 1
4096401 2059044 2059044 defendant Kynge Robert tailor 619445 619445 Kynge, Robert, of Stowe Markett, tailor 0
4115740 2065910 2065910 defendant Rede John husbandman 619445 619445 Rede, John, of Stowe Markett, husbandman 1
4115741 2065910 2065910 defendant Symondes Christopher shoemaker 619445 619445 Symondes, Christopher, of Stowe Markett, shoemaker 2
4168724 2084550 2084550 defendant Courtnall John vintner 619445 619445 Courtnall, John, of Stowe Markett, vintner 0
4168726 2084551 2084551 defendant Courtnall John vintner 619445 619445 Courtnall, John, of Stowe Markett, vintner 0
4281365 2123389 2123389 defendant Scapie Richard butcher 619445 619445 Scapie, Richard, of Stowe Markett, butcher 1
4281366 2123389 2123389 defendant Scapie Thomas butcher 619445 619445 Scapie, Thomas, of Stowe Markett, butcher 2
4331142 2140715 2140715 defendant Stange Robert saddler 619445 619445 Stange, Robert, of Stowe Markett, saddler 3
4387304 2160402 2160402 defendant Paynter Thomas clothier 619445 619445 Paynter, Thomas, of Stowe Markett, clothier 0
4390418 2161415 2161415 defendant Pattriche Peter yeoman 619445 619445 Pattriche, Peter, of Stowe Markett, yeoman 1
4398168 2163966 2163966 defendant Masslen John   619445 619445 Masslen, John, of Stowe Markett, brick maker 0
4398581 2164105 2164105 defendant Forrest John tailor 619445 619445 Forrest, John, of Stowe markett, tailor 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);