names

18 rows where place_id = 620648

✎ 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
3736812 1937766 1937766 plaintiff Key Giles   620648 620648 Key, Giles, of Almonbury 0
3953898 2008433 2008433 defendant Beamont Thomas husbandman 620648 620648 Beamont, Thomas, of Almonbury, husbandman 3
3953899 2008433 2008433 defendant Lockwood Charles husbandman 620648 620648 Lockwood, Charles, of Almonbury, husbandman 4
3953901 2008433 2008433 defendant Moldclyffe John tinker 620648 620648 Moldclyffe, John, of Almonbury, tinker 6
4004974 2026561 2026561 plaintiff Kaye Giles yeoman 620648 620648 Kaye, Giles, of Almonbury, yeoman 0
4004977 2026562 2026562 plaintiff Kaye Giles yeoman 620648 620648 Kaye, Giles, of Almonbury, yeoman 0
4045848 2040960 2040960 defendant Lockwood John husbandman 620648 620648 Lockwood, John, of Almonbury, husbandman 3
4076990 2052053 2052053 defendant Lockwood John yeoman 620648 620648 Lockwood, John, of Almonbury, yeoman 1
4083299 2054312 2054312 defendant Beamond William yeoman 620648 620648 together with Beamond, William, of Almonbury, yeoman 1
4102538 2061208 2061208 defendant Staynton Robert clerk 620648 620648 Staynton, Robert, of Almonbury, clerk 0
4112752 2064823 2064823 defendant Wood Richard husbandman 620648 620648 Wood, Richard, of Almonbury, husbandman 0
4112754 2064824 2064824 defendant Wood Richard husbandman 620648 620648 Wood, Richard, of Almonbury, husbandman 0
4385403 2159809 2159809 defendant Ramsden Robert husbandman 620648 620648 Ramsden, Robert, of Almonbury, husbandman 1
4887678 2322976 2322976 defendant Kay Peter yeoman 620648 620648 Kay, Peter, of Almonbury, yeoman 0
5216735 2420629 2420629 defendant Beaumont Lawrence yeoman 620648 620648 Beaumont, Lawrence, of Almonbury, yeoman 0
5281177 2439569 2439569 defendant Robard Richard yeoman 620648 620648 Robard, Richard, of Almonbury, yeoman 2
5406912 2477038 2477038 defendant Dalton Richard   620648 620648 Dalton, Richard, of Almonbury, yeoman, all of Farnehill, except where indicated 13
5420057 2480913 2480913 defendant Dalton Richard yeoman 620648 620648 Dalton, Richard, of Almonbury, yeoman 13

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);