names

20 rows where place_id = 654795

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3933793 2001597 2001597 defendant Nooke John chapman 654795 654795 Nooke, John, of Stelton, Hunts, chapman 0
3989187 2020871 2020871 defendant Pala William yeoman 654795 654795 Pala, William, of Stelton, Hunts, yeoman 0
4008641 2027851 2027851 defendant Palaye William innkeeper 654795 654795 Palaye, William, of Stelton, Hunts, gent, innkeeper 0
4195197 2093874 2093874 defendant Maxsey Richard gent 654795 654795 Maxsey, Richard, of Stelton, Hunts, gent 3
4760450 2283621 2283621 defendant Belle John (legal representative) 654795 654795 Belle, John, of Stelton, Hunts, executrix of 0
4766023 2285365 2285365 defendant Manton John husbandman 654795 654795 Manton, John, of Stelton, Hunts, husbandman 0
4782924 2290679 2290679 defendant Nelle Joan widow 654795 654795 Nelle, Joan, of Stelton, Hunts, widow 1
4790393 2293080 2293080 defendant Manton Richard husbandman 654795 654795 Manton, Richard, of Stelton, Hunts, husbandman 0
4908139 2329097 2329097 defendant Symson Richard husbandman 654795 654795 Symson, Richard, of Stelton, Hunts, husbandman 20
5115591 2390989 2390989 defendant Adamson Thomas (legal representative) 654795 654795 Adamson, Thomas, of Stelton, Hunts, husbandman, executors of 0
5142115 2398815 2398815 defendant Sanke or Sauke Henry gent 654795 654795 Sanke or Sauke, Henry, of Stelton, Hunts, gent 0
5159857 2403981 2403981 defendant Adamson John, sen husbandman 654795 654795 Adamson, John, sen, of Stelton, Hunts, husbandman 0
5159859 2403981 2403981 defendant Adamson Thomas (legal representative) 654795 654795 Adamson, Thomas, of Stelton, Hunts, husbandman, executors of 2
5174841 2408337 2408337 defendant Adamson John, sen husbandman 654795 654795 Adamson, John, sen, of Stelton, Hunts, husbandman 0
5174843 2408337 2408337 defendant Adamson Thomas, sen (legal representative) 654795 654795 Adamson, Thomas, sen, of Stelton, Hunts, husbandman, executors of 2
5184691 2411272 2411272 defendant Wygood Thomas clerk 654795 654795 Wygood, Thomas, of Stelton, Hunts, parson, alias of Berughby, Lincs, clerk 0
5195686 2414482 2414482 defendant Adamson John, sen husbandman 654795 654795 Adamson, John, sen, of Stelton, Hunts, husbandman 0
5195688 2414482 2414482 defendant Adamson Thomas, sen (legal representative) 654795 654795 Adamson, Thomas, sen, of Stelton, Hunts, husbandman, executors of 2
5204456 2417054 2417054 defendant Wygood Thomas   654795 654795 Wygood, Thomas, of Stelton, Hunts, parson 0
5222511 2422298 2422298 defendant Adamson John brewer 654795 654795 Adamson, John, of Stelton, Hunts, yeoman, or of Wysbeche, brewer 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);