names

50 rows where place_id = 590265

✎ 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
3600436 1867783 1867783 defendant More Edward gent 590265 590265 More, Edward, of Hendon, Middx, gent 0
3627784 1903549 1903549 defendant Edwardis John yeoman 590265 590265 Edwardis, John, of Hendon, Middx, yeoman 2
3657576 1912630 1912630 defendant Ryse Richard gent 590265 590265 Ryse, Richard, of Hendon, Middx, gent 0
3661943 1914024 1914024 defendant Ryce Richard gent 590265 590265 Ryce, Richard, of Hendon, Middx, gent 0
3744217 1940088 1940088 defendant Hache William yeoman 590265 590265 Hache, William, of Hendon, Middx, yeoman 1
3826884 1966258 1966258 defendant Clerke alias Tybbys Thomas coalburner 590265 590265 Clerke alias Tybbys, Thomas, of Hendon, Middx, coalburner 2
3829037 1966963 1966963 defendant Marshe Roger husbandman 590265 590265 Marshe, Roger, of Hendon, Middx, husbandman 0
3865668 1978737 1978737 plaintiff Nicolles John yeoman 590265 590265 Nicolles, John, of Hendon, Middx, yeoman 0
3879203 1983298 1983298 defendant Harrowe Thomas yeoman 590265 590265 Harrowe, Thomas, of Hendon, Middx, yeoman 0
3918110 1996405 1996405 defendant Reskymer William gent 590265 590265 Reskymer, William, of Hendon, Middx, gent 0
3949335 2006838 2006838 defendant Somerton Thomas husbandman 590265 590265 (Somerton, Thomas, of Hendon, Middx, husbandman 1
4000316 2024884 2024884 defendant Taylor John yeoman 590265 590265 Taylor, John, of Hendon, Middx, yeoman 1
4018192 2031229 2031229 defendant Nycoll William yeoman 590265 590265 Nycoll, William, of Hendon, Middx, yeoman 3
4045713 2040914 2040914 defendant Somerton Thomas yeoman 590265 590265 Somerton, Thomas, of Hendon, Middx, yeoman 0
4075156 2051417 2051417 defendant Barker Francis yeoman 590265 590265 Barker, Francis, of Hendon, Middx, yeoman 1
4130370 2071174 2071174 defendant Barker Francis yeoman 590265 590265 Barker, Francis, of Hendon, Middx, yeoman 0
4132373 2071893 2071893 defendant Wise William yeoman 590265 590265 Wise, William, of Hendon, Middx, yeoman 0
4140224 2074747 2074747 defendant Baker Francis yeoman 590265 590265 Baker, Francis, of Hendon, Middx, yeoman 0
4163620 2082797 2082797 defendant Evans Richard clerk 590265 590265 Evans, Richard, of Hendon, Middx, clerk 0
4186112 2090630 2090630 defendant Thurlebye Henry gent 590265 590265 Thurlebye, Henry, of Hendon, Middx, gent 2
4245754 2111557 2111557 defendant Sturley Nicholas gent 590265 590265 Sturley, Nicholas, of Hendon, Middx, gent 1
4276181 2121613 2121613 defendant Somerton Thomas yeoman 590265 590265 Somerton, Thomas, of Hendon, Middx, yeoman 1
4281328 2123376 2123376 defendant Jackson John tanner 590265 590265 Jackson, John, of Hendon, Middx, tanner 0
4318808 2136693 2136693 defendant Nicoll Robert yeoman 590265 590265 Nicoll, Robert, of Hendon, Middx, yeoman 1
4347162 2146266 2146266 defendant Barker Francis yeoman 590265 590265 Barker, Francis, of Hendon, Middx, yeoman 2
4368520 2153786 2153786 defendant Rippyn Thomas yeoman 590265 590265 Rippyn, Thomas, of Hendon, Middx, yeoman 0
4726951 2273696 2273696 defendant Norton Gervase   590265 590265 Norton, Gervase, of Hendon, Middx, parson 0
4753218 2281390 2281390 defendant Braunt John husbandman 590265 590265 Braunt, John, of Hendon, Middx, husbandman 3
4755448 2282082 2282082 defendant Colter William collier 590265 590265 Colter, William, of Hendon, Middx, collier 0
4911186 2330007 2330007 defendant Walcote Thomas smith 590265 590265 Walcote, Thomas, of Hendon, Middx, smith 1
4995084 2355388 2355388 defendant Chalkhill Richard husbandman 590265 590265 Chalkhill, Richard, of Hendon, Middx, husbandman 2
5064924 2376041 2376041 defendant Pymbard Thomas husbandman 590265 590265 Pymbard, Thomas, of Hendon, Middx, husbandman 0
5148099 2400590 2400590 defendant Colles Thomas maltman 590265 590265 Colles, Thomas, of Hendon, Middx, maltman 0
5167529 2406233 2406233 defendant Collas Thomas maltman 590265 590265 Collas, Thomas, of Hendon, Middx, maltman 0
5183069 2410793 2410793 defendant Colla Thomas maltman 590265 590265 Colla, Thomas, of Hendon, Middx, maltman 0
5183071 2410794 2410794 defendant Collas Thomas maltman 590265 590265 Collas, Thomas, of Hendon, Middx, maltman 0
5225984 2423266 2423266 defendant Collys Thomas husbandman 590265 590265 Collys, Thomas, of Hendon, Middx, husbandman 0
5231421 2424776 2424776 defendant Norton Thomas clerk 590265 590265 Norton, Thomas, of Hendon, Middx, clerk 0
5371237 2466588 2466588 defendant Wayte alias Smyth Alan collier 590265 590265 Wayte alias Smyth, Alan, of Hendon, Middx, collier 0
5382302 2469997 2469997 defendant More Edward gent 590265 590265 (More, Edward, of Hendon, Middx, gent 1
5382306 2469998 2469998 defendant More Edward gent 590265 590265 (More, Edward, of Hendon, Middx, gent 1
5382310 2469999 2469999 defendant More Edward gent 590265 590265 (More, Edward, of Hendon, Middx, gent 1
5400202 2475132 2475132 defendant Wode John yeoman 590265 590265 Wode, John, of Hendon, Middx, yeoman 0
5415468 2479564 2479564 defendant Burton Bartholomew gent 590265 590265 Burton, Bartholomew, of Hendon, Middx, gent 0
5431742 2484461 2484461 defendant Burton Bartholomew gent 590265 590265 Burton, Bartholomew, of Hendon, Middx, gent 0
5431747 2484462 2484462 defendant Burton Bartholomew gent 590265 590265 Burton, Bartholomew, of Hendon, Middx, gent 0
5520458 2511216 2511216 defendant Edwardes John husbandman 590265 590265 Edwardes, John, of Hendon, Middx, husbandman 0
5520460 2511217 2511217 defendant Edwardes John husbandman 590265 590265 Edwardes, John, of Hendon, Middx, husbandman 0
5565106 2524381 2524381 defendant Edward John yeoman 590265 590265 Edward, John, of Hendon, Middx, yeoman 2
5602000 2535522 2535522 defendant Edward John husbandman 590265 590265 Edward, John, of Hendon, Middx, husbandman 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);