names

40 rows where place_id = 623651

✎ 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
3753563 1943054 1943054 defendant Hunt Humphrey husbandman 623651 623651 Hunt, Humphrey, of Kynton, husbandman 0
3755591 1943705 1943705 defendant Lyghtfot John husbandman 623651 623651 Lyghtfot, John, of Kynton, husbandman 0
3805040 1959519 1959519 plaintiff Stevyns John   623651 623651 Stevyns, John, of Kynton 0
3842112 1971084 1971084 defendant Dey William husbandman 623651 623651 Dey, William, of Kynton, husbandman 0
3870547 1980388 1980388 defendant Deckett William miller 623651 623651 Deckett, William, of Kynton, miller 0
3917757 1996295 1996295 defendant Longforde David yeoman 623651 623651 Longforde, David, of Kynton, yeoman 0
3927351 1999492 1999492 defendant Phelyppes Thomas tinner 623651 623651 Phelyppes, Thomas, of Kynton, tinner 0
3932821 2001276 2001276 defendant Edwyn Richard   623651 623651 Edwyn, Richard, of Kynton, shoe maker 15
3942072 2004363 2004363 defendant Edwyn Richard   623651 623651 (Edwyn, Richard, of Kynton, shoe maker 3
3954804 2008749 2008749 plaintiff Longford John yeoman 623651 623651 Longford, John, of Kynton, yeoman 0
4018150 2031214 2031214 plaintiff Turner John   623651 623651 Turner, John, of Kynton 0
4018151 2031214 2031214 defendant Saunders John husbandman 623651 623651 Saunders, John, of Kynton, husbandman 0
4018844 2031469 2031469 defendant Langforde John, junior yeoman 623651 623651 Langforde, John, junior, of Kynton, yeoman 0
4052487 2043311 2043311 defendant Okeley Henry yeoman 623651 623651 Okeley, Henry, of Kynton, yeoman 0
4052489 2043312 2043312 defendant Okeley Henry yeoman 623651 623651 Okeley, Henry, of Kynton, yeoman 0
4072334 2050407 2050407 defendant Browne Walter gent 623651 623651 Browne, Walter, of Kynton, gent 3
4076886 2052022 2052022 defendant Wood Richard yeoman 623651 623651 Wood, Richard, of Kynton, or of Oldbury, Thorneburye, Glos, yeoman 0
4076888 2052022 2052022 defendant Thurston George yeoman 623651 623651 Thurston, George, of Kynton, yeoman 2
4135495 2073017 2073017 defendant Walle Joan widow 623651 623651 Walle, Joan, of Kynton, widow 1
4159639 2081439 2081439 defendant Maylerd Thomas yeoman 623651 623651 Maylerd, Thomas, of Kynton, yeoman 1
4165144 2083318 2083318 defendant Gamble Richard yeoman 623651 623651 Gamble, Richard, of Kynton, or of Kimpton, Lincs, yeoman 0
4234172 2107484 2107484 defendant Vaughan Charles gent 623651 623651 Vaughan, Charles, of Kynton, gent 1
4245597 2111505 2111505 defendant Mayllard Thomas yeoman 623651 623651 Mayllard, Thomas, of Kynton, yeoman 0
4245602 2111506 2111506 defendant Saundrett Jenkin yeoman 623651 623651 Saundrett, Jenkin, of Kynton, yeoman 0
4295926 2128640 2128640 defendant Parker William butcher 623651 623651 Parker, William, of Kynton, butcher 0
4295928 2128640 2128640 defendant Scaundrett Jenkin yeoman 623651 623651 Scaundrett, Jenkin, of Kynton, yeoman 2
4308388 2133088 2133088 defendant Whittingham Thomas gent 623651 623651 Whittingham, Thomas, of Kynton, gent 0
4308389 2133088 2133088 defendant Adye John yeoman 623651 623651 Adye, John, of Kynton, yeoman 1
4308390 2133088 2133088 defendant Tanner William yeoman 623651 623651 Tanner, William, of Kynton, yeoman 2
4372898 2155384 2155384 defendant Wolmer William gent 623651 623651 Wolmer, William, of Kynton, gent 1
4374646 2155995 2155995 defendant Pennye Richard, junior husbandman 623651 623651 Pennye, Richard, junior, of Kynton, husbandman 0
4464800 2189652 2189652 defendant Stanhop Robert de   623651 623651 Stanhop, Robert de, of Kynton 0
4758460 2283024 2283024 defendant Gerveys Nicholas   623651 623651 Gerveys, Nicholas, of Kynton, vicar 0
4971617 2348436 2348436 defendant Aylewyn John clerk 623651 623651 Aylewyn, John, of Kynton, clerk 8
4982875 2351790 2351790 defendant Gibson William husbandman 623651 623651 Gibson, William, of Kynton, husbandman 0
4982878 2351790 2351790 defendant Wryght John husbandman 623651 623651 Wryght, John, of Kynton, husbandman 3
5354308 2461415 2461415 defendant Rogers John husbandman 623651 623651 Rogers, John, of Kynton, husbandman 0
5488480 2501443 2501443 defendant ap Madwyn Thomas ap Deyo yeoman 623651 623651 ap Madwyn, Thomas ap Deyo, of Kynton, yeoman 4
5488481 2501443 2501443 defendant Deyo Dackyn drover 623651 623651 Deyo, Dackyn, of Kynton, drover 5
5555108 2521501 2521501 defendant Worseley Edward chaplain 623651 623651 Worseley, Edward, of Kynton, chaplain 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);