names

21 rows where place_id = 610906

✎ 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
3685829 1921725 1921725 defendant Pyers Edward husbandman 610906 610906 Pyers, Edward, of Torryng, husbandman 2
3701458 1926701 1926701 defendant Holyngdale Walter husbandman 610906 610906 Holyngdale, Walter, of Torryng, husbandman 0
3702601 1927080 1927080 defendant Adam Thomas yeoman 610906 610906 Adam, Thomas, of Torryng, yeoman 3
3706100 1928201 1928201 defendant Holyngdale Walter husbandman 610906 610906 Holyngdale, Walter, of Torryng, husbandman 0
3722125 1933183 1933183 defendant Holybone Thomas husbandman 610906 610906 Holybone, Thomas, of Torryng, husbandman 1
3753811 1943134 1943134 defendant Holybone Thomas husbandman 610906 610906 Holybone, Thomas, of Torryng, husbandman 1
3796736 1956864 1956864 defendant Bray John husbandman 610906 610906 Bray, John, of Torryng, husbandman 0
3825777 1965908 1965908 plaintiff Adam John (legal representative) 610906 610906 Adam, John, of Torryng, executor of 0
3825779 1965908 1965908 defendant Bray John   610906 610906 Bray, John, of Torryng, husbandman, son of Bray, Edward, of Bedyngham 0
3831143 1967625 1967625 defendant Adam Thomas yeoman 610906 610906 Adam, Thomas, of Torryng, yeoman 0
3840199 1970501 1970501 defendant Bray John husbandman 610906 610906 Bray, John, of Torryng, husbandman 0
4773250 2287603 2287603 defendant Skires Nicholas   610906 610906 Skires, Nicholas, of Torryng 1
4873970 2318797 2318797 defendant Aleyn John husbandman 610906 610906 Aleyn, John, of Torryng, husbandman 0
4873972 2318798 2318798 defendant Aleyn John husbandman 610906 610906 Aleyn, John, of Torryng, husbandman 0
5206758 2417714 2417714 defendant Adam Richard husbandman 610906 610906 Adam, Richard, of Torryng, husbandman 0
5221002 2421841 2421841 defendant Adam Richard husbandman 610906 610906 Adam, Richard, of Torryng, husbandman 0
5259379 2433055 2433055 defendant atte Pette William husbandman 610906 610906 atte Pette, William, of Torryng, husbandman 0
5259380 2433055 2433055 defendant Payne John husbandman 610906 610906 Payne, John, of Torryng, husbandman 1
5260137 2433295 2433295 defendant Adam Richard husbandman 610906 610906 Adam, Richard, of Torryng, husbandman 0
5260139 2433296 2433296 defendant Adam Richard husbandman 610906 610906 Adam, Richard, of Torryng, husbandman 0
5321386 2451490 2451490 plaintiff Lok William   610906 610906 Lok, William, of Torryng 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);