names

26 rows where place_id = 604833

✎ 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
3659429 1913210 1913210 defendant Keryche William yeoman 604833 604833 Keryche, William, of Saxsted, yeoman 0
3664483 1914840 1914840 defendant Shymgylwode Richard husbandman 604833 604833 Shymgylwode, Richard, of Saxsted, husbandman 0
3704792 1927789 1927789 defendant Smyth Robert   604833 604833 Smyth, Robert, of Saxsted, freemason 0
3769078 1947980 1947980 defendant Smyth Robert   604833 604833 Smyth, Robert, of Saxsted, rough mason 0
3776713 1950464 1950464 defendant Wyard Nicholas shoemaker 604833 604833 Wyard, Nicholas, of Saxsted, shoemaker 0
3776714 1950464 1950464 defendant Norman Thomas husbandman 604833 604833 Norman, Thomas, of Saxsted, husbandman 1
3853453 1974705 1974705 defendant Smyth Robert   604833 604833 Smyth, Robert, of Saxsted, rough mason 0
3937186 2002769 2002769 defendant Bungey Edward butcher 604833 604833 Bungey, Edward, of Saxsted, butcher 0
3995121 2023003 2023003 defendant Poynt John yeoman 604833 604833 Poynt, John, of Saxsted, yeoman 1
4026337 2034065 2034065 defendant Pointz John husbandman 604833 604833 Pointz, John, of Saxsted, husbandman 0
4057562 2045083 2045083 defendant Button Humphrey yeoman 604833 604833 Button, Humphrey, of Saxsted, yeoman 0
4080367 2053292 2053292 defendant Button Humphrey yeoman 604833 604833 Button, Humphrey, of Saxsted, yeoman 0
4143026 2075729 2075729 defendant Button Thomas yeoman 604833 604833 Button, Thomas, of Saxsted, yeoman 0
5012836 2360586 2360586 defendant Lyon John yeoman 604833 604833 Lyon, John, of Saxsted, yeoman 3
5220872 2421796 2421796 defendant Lyon or Leyown John yeoman 604833 604833 Lyon or Leyown, John, of Saxsted, yeoman 0
5279089 2438993 2438993 plaintiff Boton John   604833 604833 Boton, John, of Saxsted 0
5285367 2440740 2440740 defendant Warner William husandman 604833 604833 Warner, William, of Saxsted, husandman 0
5285369 2440741 2440741 defendant Warner William husbandman 604833 604833 Warner, William, of Saxsted, husbandman 0
5288922 2441766 2441766 plaintiff Lyon Thomas husbandman 604833 604833 Lyon, Thomas, of Saxsted, husbandman 0
5352830 2460972 2460972 defendant Elyot William husbandman 604833 604833 Elyot, William, of Saxsted, husbandman 0
5481271 2499344 2499344 defendant Baxster John chaplain 604833 604833 Baxster, John, of Saxsted, chaplain 2
5497389 2504159 2504159 plaintiff Lyon Thomas (legal representative) 604833 604833 Lyon, Thomas, of Saxsted, executors of 0
5497397 2504160 2504160 plaintiff Lyon Thomas (legal representative) 604833 604833 Lyon, Thomas, of Saxsted, executors of 0
5512190 2508675 2508675 plaintiff Lyon Thomas (legal representative) 604833 604833 Lyon, Thomas, of Saxsted, executors of 0
5512195 2508676 2508676 plaintiff Lyon Thomas (legal representative) 604833 604833 Lyon, Thomas, of Saxsted, executors of 0
5568306 2525275 2525275 plaintiff Fereby John clerk 604833 604833 Fereby, John, of Saxsted, clerk 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);