names

44 rows where place_id = 592177

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606836 1869806 1869806 defendant Cressell Godfrey yeoman 592177 592177 Cressell, Godfrey, of Grenewyche, Kent, yeoman 1
3632561 1905002 1905002 defendant Lloyd alias ap Morys William gent 592177 592177 Lloyd alias ap Morys, William, of Grenewyche, Kent, gent 0
3651064 1910698 1910698 defendant A Dene William tiler 592177 592177 A Dene, William, of Grenewyche, Kent, tiler 1
3676722 1918753 1918753 defendant Cotton William gent 592177 592177 Cotton, William, of Grenewyche, Kent, gent 0
3758623 1944692 1944692 defendant Acton Robert gent 592177 592177 Acton, Robert, of Grenewyche, Kent, gent 2
3799355 1957720 1957720 defendant Skelton Thomas yeoman 592177 592177 Skelton, Thomas, of Grenewyche, Kent, yeoman 0
3820692 1964358 1964358 defendant Westeby Thomas clerk 592177 592177 Westeby, Thomas, of Grenewyche, Kent, clerk 0
3834309 1968673 1968673 defendant Burde Henry yeoman of the chamber 592177 592177 Burde, Henry, of Grenewyche, Kent, yeoman of the chamber 0
3857416 1975954 1975954 defendant Holmes William (legal representative) 592177 592177 Holmes, William, of Grenewyche, Kent, yeoman, executors of 0
3873273 1981278 1981278 defendant Dyngley John gent 592177 592177 Dyngley, John, of Grenewyche, Kent, gent 1
3896434 1989012 1989012 defendant Jonys William yeoman 592177 592177 Jonys, William, of Grenewyche, Kent, yeoman 0
3918018 1996393 1996393 defendant Armorer William yeoman 592177 592177 Armorer, William, of Grenewyche, Kent, yeoman 0
3918026 1996394 1996394 defendant Barows Leonard yeoman 592177 592177 Barows, Leonard, of Grenewyche, Kent, yeoman 0
3918053 1996397 1996397 defendant Bygge John yeoman 592177 592177 Bygge, John, of Grenewyche, Kent, yeoman 0
3918062 1996398 1996398 defendant Care John esq 592177 592177 Care, John, of Grenewyche, Kent, esq 0
3918076 1996400 1996400 defendant Kyng John yeoman 592177 592177 Kyng, John, of Grenewyche, Kent, yeoman 2
3918093 1996403 1996403 defendant Jynkyn William yeoman 592177 592177 Jynkyn, William, of Grenewyche, Kent, yeoman 0
3918111 1996405 1996405 defendant Harryson Lancelot yeoman 592177 592177 Harryson, Lancelot, of Grenewyche, Kent, yeoman 1
3918170 1996413 1996413 defendant Sterne John   592177 592177 Sterne, John, of Grenewyche, Kent, cook 0
3919666 1996914 1996914 defendant Basyng Roger gent 592177 592177 Basyng, Roger, of Grenewyche, Kent, gent 0
4401797 2165199 2165199 defendant Wylson Thomas clerk 592177 592177 Wylson, Thomas, of Grenewyche, Kent, clerk 0
4856117 2313285 2313285 defendant Bene Geoffrey waterman 592177 592177 Bene, Geoffrey, of Grenewyche, Kent, waterman 2
4940511 2339057 2339057 defendant Maundewer Thomas clerk 592177 592177 Maundewer, Thomas, of Grenewyche, Kent, clerk 0
4971416 2348379 2348379 defendant Ederyche William mariner 592177 592177 Ederyche, William, of Grenewyche, Kent, mariner 0
4978056 2350403 2350403 defendant Wynne William vintner 592177 592177 Wynne, William, of Grenewyche, Kent, vintner 3
4978059 2350404 2350404 defendant Wynne William vintner 592177 592177 Wynne, William, of Grenewyche, Kent, vintner 1
5048005 2371024 2371024 defendant Sygasor John yeoman 592177 592177 Sygasor, John, of Grenewyche, Kent, yeoman 1
5048838 2371285 2371285 defendant Midelton Thomas esq 592177 592177 Midelton, Thomas, of Grenewyche, Kent, esq 0
5053877 2372754 2372754 defendant Johnson Peter gent 592177 592177 Johnson, Peter, of Grenewyche, Kent, gent 1
5088899 2383129 2383129 defendant Botiller John   592177 592177 Botiller, John, of Grenewyche, Kent, or of Lancaster, knight 0
5148006 2400563 2400563 defendant Hale Walter gent 592177 592177 Hale, Walter, of Grenewyche, Kent, gent 0
5232575 2425105 2425105 defendant Pykeryng Margaret widow 592177 592177 Pykeryng, Margaret, of Grenewyche, Kent, widow 0
5260927 2433540 2433540 defendant Grenewey Richard husbandman 592177 592177 Grenewey, Richard, of Grenewyche, Kent, husbandman 4
5273152 2437218 2437218 defendant Hobbys Robert butcher 592177 592177 Hobbys, Robert, of Grenewyche, Kent, butcher 3
5287521 2441375 2441375 defendant Stenbrugge John yeoman 592177 592177 Stenbrugge, John, of Grenewyche, Kent, yeoman 0
5317477 2450312 2450312 defendant Colyngborne William esq 592177 592177 Colyngborne, William, of Grenewyche, Kent, esq 3
5340368 2457191 2457191 defendant Valans Thomas yeoman 592177 592177 Valans, Thomas, of Grenewyche, Kent, yeoman 4
5357828 2462519 2462519 defendant Valens Thomas yeoman 592177 592177 Valens, Thomas, of Grenewyche, Kent, yeoman 2
5462788 2493778 2493778 defendant Barpyghtell Andrew husbandman 592177 592177 Barpyghtell, Andrew, of Grenewyche, Kent, husbandman 2
5462796 2493781 2493781 defendant Wilson Robert gent 592177 592177 Wilson, Robert, of Grenewyche, Kent, gent 2
5474326 2497299 2497299 defendant Wilson Robert gent 592177 592177 Wilson, Robert, of Grenewyche, Kent, gent 2
5504385 2506288 2506288 defendant Gele- Thomas husbandman 592177 592177 Gele-, Thomas, of Grenewyche, Kent, husbandman 2
5543964 2518221 2518221 defendant Bofeld John skinner 592177 592177 Bofeld, John, of Grenewyche, Kent, skinner 2
5576301 2527645 2527645 defendant Smyth Thomas salter 592177 592177 Smyth, Thomas, of Grenewyche, Kent, salter 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);