names

20 rows where place_id = 608384

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3673490 1917734 1917734 defendant Cosyn Robert husbandman 608384 608384 Cosyn, Robert, of Cavenham, husbandman 0
3684222 1921200 1921200 plaintiff Wright William clerk 608384 608384 Wright, William, of Cavenham, clerk 0
4081710 2053760 2053760 defendant Garrett Henry yeoman 608384 608384 Garrett, Henry, of Cavenham, yeoman 1
4582768 2226046 2226046 defendant Sybryghte Richard   608384 608384 Sybryghte, Richard, of Cavenham 0
4583738 2226327 2226327 defendant Cappe Richard   608384 608384 Cappe, Richard, of Cavenham 0
4583740 2226327 2226327 defendant Spillyng Stephen   608384 608384 Spillyng, Stephen, of Cavenham 2
4753287 2281409 2281409 defendant atte Fen William   608384 608384 atte Fen, William, of Cavenham, vicar 2
4806302 2298181 2298181 plaintiff Cappe Richard (legal representative) 608384 608384 Cappe, Richard, of Cavenham, executors of 0
4806306 2298181 2298181 defendant atte Mere William painter 608384 608384 atte Mere, William, of Cavenham, painter 0
4826844 2304434 2304434 defendant Peyntour William yeoman 608384 608384 Peyntour, William, of Cavenham, yeoman 3
4844086 2309661 2309661 defendant (not given) William vicar of Fen 608384 608384 Fen, William, of Cavenham, parson of Tostoke alias perpetual vicar of Cavenham alias clerk of Herynggeswell 0
4999447 2356705 2356705 defendant Barwe John husbandman 608384 608384 Barwe, John, of Cavenham, husbandman 1
5022594 2363513 2363513 defendant of Barowe John husbandman 608384 608384 of Barowe, John, of Cavenham, husbandman 2
5060777 2374804 2374804 defendant Hykedon William, junior husbandman 608384 608384 Hykedon, William, junior, of Cavenham, husbandman 0
5232019 2424935 2424935 defendant Cosyn John   608384 608384 Cosyn, John, of Cavenham 1
5255674 2431893 2431893 defendant Lovell John chaplain 608384 608384 Lovell, John, of Cavenham, chaplain 0
5278781 2438902 2438902 defendant Cosyn or Cofyn John, senior husbandman 608384 608384 Cosyn or Cofyn, John, senior, of Cavenham, husbandman 4
5373491 2467306 2467306 defendant Rombold John fuller 608384 608384 Rombold, John, of Cavenham, fuller 0
5490285 2501981 2501981 defendant Cosyn John husbandman 608384 608384 Cosyn, John, of Cavenham, husbandman 1
5564974 2524342 2524342 defendant Woodcok John miller 608384 608384 Woodcok, John, of Cavenham, miller 2

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