names

20 rows where place_id = 694648

✎ 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
3924800 1998613 1998613 plaintiff Walden Robert (legal representative) 694648 694648 Walden, Robert, of Brandon Ferye, mercer, executors of 0
4105480 2062236 2062236 defendant Sargeant William husbandman 694648 694648 Sargeant, William, of Brandon Ferye, husbandman 0
4167977 2084284 2084284 defendant Hovell or Houell Edward yeoman 694648 694648 Hovell or Houell, Edward, of Brandon Ferye, yeoman 0
4463372 2189235 2189235 plaintiff Tudenham William master & parson of the church 694648 694648 Tudenham, William, of Brandon Ferye, master & parson of the church 0
4608119 2233653 2233653 defendant Lamynghithe Alan   694648 694648 Lamynghithe, Alan, of Brandon Ferye 0
4905787 2328412 2328412 plaintiff Gebonn Richard   694648 694648 Gebonn, Richard, of Brandon Ferye 0
4973443 2349001 2349001 defendant Chandeler Richard chandler 694648 694648 Chandeler, Richard, of Brandon Ferye, chandler 1
4999054 2356596 2356596 plaintiff Whetelee Roger   694648 694648 Whetelee, Roger, of Brandon Ferye 1
5030298 2365733 2365733 plaintiff Pepyr John yeoman 694648 694648 Pepyr, John, of Brandon Ferye, yeoman 0
5107893 2388745 2388745 plaintiff Edward William yeoman 694648 694648 Edward, William, of Brandon Ferye, yeoman 0
5635555 2555084 2555084 defendant Cost William laborer 694648 694648 Cost, William, of Brandon Ferye, laborer 0
5635556 2555084 2555084 defendant George Richard laborer 694648 694648 George, Richard, of Brandon Ferye, laborer 1
5635557 2555084 2555084 defendant Laueraunce John pedder 694648 694648 Laueraunce, John, of Brandon Ferye, pedder 2
5635560 2555084 2555084 defendant Gebon John warrener 694648 694648 together with Gebon, John, of Brandon Ferye, warrener 5
5635561 2555084 2555084 defendant Hervy John laborer 694648 694648 Hervy, John, of Brandon Ferye, laborer 6
5635563 2555085 2555085 defendant Gebon John warrener 694648 694648 Gebon, John, of Brandon Ferye, warrener 0
5635564 2555085 2555085 defendant Costyn or Costyner William laborer 694648 694648 Costyn or Costyner, William, of Brandon Ferye, laborer 1
5635565 2555085 2555085 defendant George Richard lsboter 694648 694648 George, Richard, of Brandon Ferye, lsboter 2
5635566 2555085 2555085 defendant Laueraunce John pedder 694648 694648 Laueraunce, John, of Brandon Ferye, pedder 3
5635571 2555086 2555086 defendant Gebon John warrener 694648 694648 Gebon, John, of Brandon Ferye, warrener 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);