names

33 rows where place_id = 601003

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643505 1908398 1908398 defendant Parker Henry gent 601003 601003 Parker, Henry, of Grenewiche, Kent, gent 0
3645346 1908953 1908953 defendant Seyntleger George   601003 601003 Seyntleger, George, of Grenewiche, Kent, knight 0
3647104 1909485 1909485 defendant Herryson John yeoman or merchant 601003 601003 Herryson, John, of Grenewiche, Kent, yeoman or merchant 0
3657315 1912548 1912548 defendant Owen Jasper gent 601003 601003 Owen, Jasper, of Grenewiche, Kent, gent 0
3660063 1913411 1913411 defendant Davenport Ralph gent & clerk of the Avery 601003 601003 Davenport, Ralph, of Grenewiche, Kent, gent & clerk of the Avery 0
3660080 1913415 1913415 defendant Davenport Ralph gent 601003 601003 Davenport, Ralph, of Grenewiche, Kent, gent 0
3660095 1913417 1913417 defendant Swynerton Edward gent & Sewer of the Kyngis Chamber 601003 601003 Swynerton, Edward, of Grenewiche, Kent, gent & Sewer of the Kyngis Chamber 1
3723541 1933633 1933633 defendant Devenport Ralph gent 601003 601003 Devenport, Ralph, of Grenewiche, Kent, gent 0
3723559 1933641 1933641 defendant Davenport Ralph gent 601003 601003 Davenport, Ralph, of Grenewiche, Kent, gent 0
3748876 1941584 1941584 defendant Raynsforth John gent 601003 601003 Raynsforth, John, of Grenewiche, Kent, gent 3
3775703 1950148 1950148 defendant Leygray Roger gent 601003 601003 Leygray, Roger, of Grenewiche, Kent, gent 3
3859141 1976544 1976544 defendant Williams John yeoman of the guard 601003 601003 Williams, John, of Grenewiche, Kent, yeoman of the guard 4
3861734 1977388 1977388 defendant Alen Thomas gent 601003 601003 Alen, Thomas, of Grenewiche, Kent, gent 1
3976915 2016493 2016493 defendant Wyseman Robert gent 601003 601003 Wyseman, Robert, of Grenewiche, Kent, gent 0
3977977 2016871 2016871 defendant Wyseman Robert   601003 601003 Wyseman, Robert, of Grenewiche, Kent, gent, servant of the Queen 0
4041839 2039563 2039563 defendant Somersett William yeoman 601003 601003 Somersett, William, of Grenewiche, Kent, yeoman 0
4041843 2039564 2039564 defendant Somersett William yeoman 601003 601003 Somersett, William, of Grenewiche, Kent, yeoman 0
4081760 2053781 2053781 defendant Pawley Walter gent 601003 601003 Pawley, Walter, of Grenewiche, Kent, gent 1
4152542 2079003 2079003 defendant Cardyffe Ralph gent 601003 601003 Cardyffe, Ralph, of Grenewiche, Kent, gent 2
4196827 2094438 2094438 defendant Shelton Thomas gent 601003 601003 Shelton, Thomas, of Grenewiche, Kent, gent 0
4328210 2139750 2139750 defendant Brounker Henry esq 601003 601003 Brounker, Henry, of grenewiche, Kent, esq 0
4386432 2160140 2160140 defendant Bishoppe Thomas gent 601003 601003 Bishoppe, Thomas, of Grenewiche, Kent, gent 2
4397183 2163631 2163631 defendant Randall John yeoman 601003 601003 Randall, John, of Grenewiche, Kent, yeoman 0
4397185 2163632 2163632 defendant Randall John   601003 601003 Randall, John, of Grenewiche, Kent 0
4409674 2167835 2167835 defendant Welles Richard chapman 601003 601003 Welles, Richard, of Grenewiche, Kent, chapman 2
4410069 2167972 2167972 defendant Van Wilder Henry esq 601003 601003 Van Wilder, Henry, of Grenewiche, Kent, or of Layton, Essex, esq 0
4700453 2265555 2265555 defendant Gunby William clerk 601003 601003 Gunby, William, of Grenewiche, Kent, clerk 1
5045126 2370172 2370172 defendant Bokelond William esq 601003 601003 Bokelond, William, of Grenewiche, Kent, esq 1
5048825 2371283 2371283 defendant Middelton Thomas esq 601003 601003 Middelton, Thomas, of Grenewiche, Kent, esq 0
5228437 2423921 2423921 defendant Phylip Thomas ironmonger 601003 601003 Phylip, Thomas, of Grenewiche, Kent, yeoman, or of London, ironmonger 4
5229682 2424301 2424301 defendant Couper Robert husbandman 601003 601003 Couper, Robert, of Grenewiche, Kent, husbandman 3
5287519 2441374 2441374 defendant Stenbrugge John yeoman 601003 601003 Stenbrugge, John, of Grenewiche, Kent, or of Suthwerk, yeoman 0
5570044 2525813 2525813 defendant Kent George gent 601003 601003 Kent, George, of Grenewiche, Kent, gent 3

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