names

37 rows where place_id = 655543

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3936725 2002610 2002610 defendant Herbert Edward gent 655543 655543 Herbert, Edward, of Montgomery, gent 0
3964029 2012029 2012029 defendant Gryffyth William yeoman 655543 655543 Gryffyth, William, of Montgomery, yeoman 0
3964030 2012029 2012029 defendant ap Gader Maurice gent 655543 655543 ap Gader, Maurice, of Montgomery, gent 1
3966020 2012739 2012739 defendant Edward Hugh chapman 655543 655543 Edward, Hugh, of Montgomery, or of Bewdley, chapman 0
3974536 2015670 2015670 plaintiff Herbert Edward esq 655543 655543 Herbert, Edward, of Montgomery, esq 0
3989083 2020838 2020838 defendant Dio Morgan ap William yeoman 655543 655543 Dio, Morgan ap William, of Montgomery, yeoman 1
3997639 2023908 2023908 plaintiff Edward Hugh merchant 655543 655543 Edward, Hugh, of Montgomery, merchant 0
4025308 2033712 2033712 defendant Edward Hugh yeoman 655543 655543 Edward, Hugh, of Montgomery, yeoman 1
4053585 2043655 2043655 defendant ap Cadder Robert ap John gent 655543 655543 ap Cadder, Robert ap John, of Montgomery, gent 2
4076463 2051878 2051878 defendant Heywood Christopher esq 655543 655543 Heywood, Christopher, of Montgomery, esq 1
4081191 2053583 2053583 defendant Herbert Edward esq 655543 655543 Herbert, Edward, of Montgomery, esq 0
4081193 2053583 2053583 defendant Herbert Mathew gent 655543 655543 Herbert, Mathew, of Montgomery, gent 2
4081194 2053583 2053583 defendant Herbert George gent 655543 655543 Herbert, George, of Montgomery, gent 3
4081195 2053583 2053583 defendant Herbert Charles gent 655543 655543 Herbert, Charles, of Montgomery, gent 4
4085107 2054954 2054954 defendant Edwardes Hugh mercer 655543 655543 Edwardes, Hugh, of Montgomery, mercer 2
4117369 2066512 2066512 defendant Broughton Edward gent 655543 655543 Broughton, Edward, of Montgomery, gent 0
4120746 2067703 2067703 defendant Harbert Edward esq 655543 655543 Harbert, Edward, of Montgomery, esq 0
4131794 2071687 2071687 defendant Herbert Edward esq 655543 655543 Herbert, Edward, of Montgomery, esq 1
4157622 2080740 2080740 defendant ap Holl Howell David gent 655543 655543 ap Holl, Howell David, of Montgomery, gent 1
4157623 2080740 2080740 defendant ap Eigmon Thomas ap Maurice gent 655543 655543 ap Eigmon, Thomas ap Maurice, of Montgomery, gent 2
4157627 2080741 2080741 defendant ap Holl Howell David gent 655543 655543 ap Holl, Howell David, of Montgomery, gent 1
4157628 2080741 2080741 defendant ap Eigmon Thomas ap Maurice gent 655543 655543 ap Eigmon, Thomas ap Maurice, of Montgomery, gent 2
4188997 2091637 2091637 defendant Evans Lewis gent 655543 655543 Evans, Lewis, of Montgomery, gent 0
4191491 2092590 2092590 defendant Trumuth or Trinnuth Griffin ap Jevan gent 655543 655543 Trumuth or Trinnuth, Griffin ap Jevan, of Montgomery, gent 2
4203445 2096757 2096757 defendant Herbert Edward esq 655543 655543 Herbert, Edward, of Montgomery, esq 0
4216259 2101179 2101179 defendant Herbert Edward esq 655543 655543 Herbert, Edward, of Montgomery, esq 0
4258368 2115767 2115767 defendant Ashley alias Bell John mercer 655543 655543 Ashley alias Bell, John, of Montgomery, mercer 2
4265932 2118243 2118243 defendant Lloyd Richard gent 655543 655543 Lloyd, Richard, of Montgomery, gent 2
4270266 2119639 2119639 defendant Ashley alias Bell John mercer 655543 655543 Ashley alias Bell, John, of Montgomery, mercer 2
4287188 2125475 2125475 defendant Harberte Mathew esq 655543 655543 Harberte, Mathew, of Montgomery, esq 3
4341719 2144382 2144382 defendant Morrys John yeoman 655543 655543 Morrys, John, of Montgomery, yeoman 2
4368601 2153820 2153820 defendant Mores John gent 655543 655543 Mores, John, of Montgomery, gent 2
4416095 2169920 2169920 plaintiff Lodelowe Henry de   655543 655543 Lodelowe, Henry de, of Montgomery, parson 0
4416098 2169920 2169920 defendant Millesone John   655543 655543 Millesone, John, of Montgomery 2
4421111 2171495 2171495 defendant Wynnesbury Robert de   655543 655543 Wynnesbury, Robert de, of Montgomery, parson 0
4620801 2237488 2237488 defendant Delat John   655543 655543 Delat, John, of Montgomery 1
4646004 2244905 2244905 plaintiff Pegon John de   655543 655543 Pegon, John de, of Montgomery 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);