names

40 rows where place_id = 667175

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3846725 1972532 1972532 defendant Strelley Nicholas   667175 667175 Strelley, Nicholas, of Strelley, Notts, knight 0
3862214 1977545 1977545 defendant Strelley Nicholas   667175 667175 Strelley, Nicholas, of Strelley, Notts, knight 0
3895354 1988654 1988654 defendant Strelley Nicholas   667175 667175 Strelley, Nicholas, of Strelley, Notts, knight 0
3900137 1990270 1990270 defendant Strelley Nicholas   667175 667175 Strelley, Nicholas, of Strelley, Notts, knight 0
3931355 2000782 2000782 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
3947279 2006117 2006117 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
3963275 2011758 2011758 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
3974203 2015543 2015543 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 1
3984056 2019067 2019067 plaintiff Strelley John esq 667175 667175 Strelley, John, of Strelley, Notts, esq 0
4082176 2053935 2053935 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
4082178 2053936 2053936 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 0
4084979 2054907 2054907 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
4139410 2074456 2074456 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
4182503 2089358 2089358 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
4200413 2095701 2095701 defendant Strelley Anthony   667175 667175 Strelley, Anthony, of Strelley, Notts, knight 0
4242345 2110436 2110436 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 0
4242347 2110437 2110437 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 0
4245575 2111497 2111497 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 1
4245578 2111498 2111498 defendant Strelley Philip   667175 667175 Strelley, Philip, of Strelley, Notts, esq, son of Anthony Strelley, of Strelley, knight 0
4257634 2115528 2115528 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 1
4257637 2115529 2115529 defendant Strelley Philip   667175 667175 Strelley, Philip, of Strelley, Notts, esq, son of Anthony Strelley, of Strelley, knight 0
4277499 2122052 2122052 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 0
4297550 2129226 2129226 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 0
4297568 2129233 2129233 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 0
4330552 2140514 2140514 defendant Jennyng Ralph yeoman 667175 667175 Jennyng, Ralph, of Strelley, Notts, yeoman 3
4330554 2140515 2140515 defendant Strelley Philip esq 667175 667175 Strelley, Philip, of Strelley, Notts, esq 0
4330558 2140516 2140516 defendant Felahay Robert yeoman 667175 667175 Felahay, Robert, of Strelley, Notts, yeoman, Prescott, Hugh, of Newsteade, Notts, yeoman 2
4331935 2140975 2140975 defendant Jennynges Ralph yeoman 667175 667175 Jennynges, Ralph, of Strelley, Notts, yeoman 3
4370181 2154395 2154395 defendant Houghe Giles yeoman 667175 667175 Houghe, Giles, of Strelley, Notts, yeoman 0
4402612 2165459 2165459 defendant Delahay Robert gent 667175 667175 Delahay, Robert, of Strelley, Notts, gent 1
4793979 2294246 2294246 defendant Strelley Robert   667175 667175 Strelley, Robert, of Strelley, Notts, knight 0
4888665 2323247 2323247 defendant Strelley Robert   667175 667175 Strelley, Robert, of Strelley, Notts, knight 0
4890929 2323910 2323910 defendant Strelley Robert   667175 667175 Strelley, Robert, of Strelley, Notts, knight 0
4903604 2327740 2327740 defendant Strelley Robert   667175 667175 Strelley, Robert, of Strelley, Notts, knight 0
4947231 2341121 2341121 defendant Lemyng John gent 667175 667175 Lemyng, John, of Strelley, Notts, gent 1
5041047 2368948 2368948 defendant Strelley Robert esq 667175 667175 Strelley, Robert, of Strelley, Notts, esq 0
5277011 2438359 2438359 defendant Strelley John gent 667175 667175 Strelley, John, of Strelley, Notts, gent 2
5280139 2439264 2439264 defendant Strelley John gent 667175 667175 Strelley, John, of Strelley, Notts, gent 2
5336786 2456067 2456067 defendant Strelley Robert   667175 667175 Strelley, Robert, of Strelley, Notts, knight 3
5532165 2514606 2514606 defendant Strelley John esq 667175 667175 Strelley, John, of Strelley, Notts, esq 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);