names

25 rows where place_id = 644833

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3882132 1984282 1984282 defendant Grene Thomas clerk 644833 644833 Grene, Thomas, of Dydley, clerk 0
4011064 2028731 2028731 defendant Grene John, senior husbandman 644833 644833 Grene, John, senior, of Dydley, husbandman 0
4011065 2028731 2028731 defendant Grene John, junior husbandman 644833 644833 Grene, John, junior, of Dydley, husbandman 1
4011066 2028731 2028731 defendant Grene Richard husbandman 644833 644833 Grene, Richard, of Dydley, husbandman 2
4015480 2030234 2030234 defendant Grene John, senior yeoman 644833 644833 Grene, John, senior, of Dydley, yeoman 0
4015481 2030234 2030234 defendant Grene John, junior husbandman 644833 644833 Grene, John, junior, of Dydley, husbandman 1
4015482 2030234 2030234 defendant Grene Richard husbandman 644833 644833 Grene, Richard, of Dydley, husbandman 2
4022452 2032754 2032754 defendant Quarrell James yeoman 644833 644833 Quarrell, James, of Dydley, yeoman 0
4022453 2032754 2032754 defendant Pygge John laborer 644833 644833 Pygge, John, of Dydley, laborer 1
4022454 2032754 2032754 defendant Quarrell William laborer 644833 644833 Quarrell, William, of Dydley, laborer 2
4032407 2036248 2036248 defendant Pye John yeoman 644833 644833 Pye, John, of Dydley, yeoman 13
4043862 2040254 2040254 defendant James Henry yeoman 644833 644833 James, Henry, of Dydley, or of St Drevelles, yeoman 1
4061295 2046442 2046442 defendant Lewys Thomas husbandman 644833 644833 Lewys, Thomas, of Dydley, husbandman 10
4063206 2047136 2047136 defendant Perce Richard yeoman 644833 644833 Perce, Richard, of Dydley, yeoman 0
4068627 2049066 2049066 defendant Perse Richard yeoman 644833 644833 Perse, Richard, of Dydley, yeoman 4
4081454 2053677 2053677 defendant Quarrell John yeoman 644833 644833 Quarrell, John, of Dydley, yeoman 3
4101217 2060744 2060744 defendant Peers Richard yeoman 644833 644833 Peers, Richard, of Dydley, yeoman 1
4101227 2060747 2060747 defendant Peers Richard yeoman 644833 644833 Peers, Richard, of Dydley, yeoman 1
4182303 2089288 2089288 defendant Pyrs or Peers Richard gent 644833 644833 Pyrs or Peers, Richard, of Dydley, gent 0
4182584 2089385 2089385 defendant Pye John gent 644833 644833 Pye, John, of Dydley, gent 2
4189408 2091795 2091795 defendant Cicell Philip yeoman 644833 644833 Cicell, Philip, of Dydley, yeoman 0
4189409 2091795 2091795 defendant Cowle John yeoman 644833 644833 Cowle, John, of Dydley, yeoman 1
4189449 2091804 2091804 defendant Perce or Pearse Richard gent 644833 644833 Perce or Pearse, Richard, of Dydley, gent 0
4247100 2112005 2112005 defendant Phillip alias Taberer Howell laborer 644833 644833 Phillip alias Taberer, Howell, of Dydley, laborer 0
5401606 2475529 2475529 defendant Sarvell or Sarnell William   644833 644833 Sarvell or Sarnell, William, of Dydley, nail man 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);