names

14 rows where place_id = 588513

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594780 1865992 1865992 defendant Legh Edward yeoman 588513 588513 Legh, Edward, of Chelsham, yeoman 0
3601739 1868200 1868200 defendant Giler John husbandman 588513 588513 Giler, John, of Chelsham, husbandman 0
3985578 2019604 2019604 defendant Wooddyn John husbandman 588513 588513 Wooddyn, John, of Chelsham, husbandman 1
4152990 2079151 2079151 defendant Palmer alias Woodden John, junior yeoman 588513 588513 Palmer alias Woodden, John, junior, of Chelsham, yeoman 0
4279899 2122882 2122882 defendant Haywarde John yeoman 588513 588513 Haywarde, John, of Chelsham, yeoman 1
4345170 2145586 2145586 defendant Hayward Richard yeoman 588513 588513 Hayward, Richard, of Chelsham, or of Lympsfield, Surrey, yeoman 0
4400976 2164916 2164916 defendant Hayward John yeoman 588513 588513 Hayward, John, of Chelsham, yeoman 3
4414968 2169573 2169573 defendant Bertelot John, senior   588513 588513 Bertelot, John, senior, of Chelsham 0
4543626 2213902 2213902 defendant Fanchild John   588513 588513 Fanchild, John, of Chelsham 0
4569625 2222080 2222080 defendant atte Welle William   588513 588513 atte Welle, William, of Chelsham 2
5360947 2463447 2463447 defendant Hamond William husbandman 588513 588513 Hamond, William, of Chelsham, husbandman 3
5381713 2469826 2469826 defendant Basset Thomas husbandman 588513 588513 Basset, Thomas, of Chelsham, husbandman 0
5381715 2469827 2469827 defendant Basset Thomas husbandman 588513 588513 Basset, Thomas, of Chelsham, husbandman 0
5402243 2475711 2475711 defendant Basset Thomas yeoman 588513 588513 Basset, Thomas, of Chelsham, yeoman 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);