names

12 rows where place_id = 612869

✎ 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
3695402 1924785 1924785 defendant A Broke Richard husbandman 612869 612869 A Broke, Richard, of Westdene, husbandman 0
3945586 2005532 2005532 defendant Rychemond Robert husbandman 612869 612869 Rychemond, Robert, of Westdene, husbandman 1
3945587 2005532 2005532 defendant Awood George husbandman 612869 612869 Awood, George, of Westdene, husbandman 2
3945764 2005591 2005591 defendant Segar John (legal representative) 612869 612869 Segar, John, of Westdene, executors of 0
4068487 2049023 2049023 defendant Towner John husbandman 612869 612869 Towner, John, of Westdene, husbandman 1
4074062 2051016 2051016 defendant Towner John husbandman 612869 612869 Towner, John, of Westdene, husbandman 3
4098758 2059887 2059887 defendant Towner John yeoman 612869 612869 Towner, John, of Westdene, yeoman 2
4150098 2078171 2078171 defendant Collyngham Robert husbandman 612869 612869 Collyngham, Robert, of Westdene, or of Haylesham, husbandman 1
4228144 2105325 2105325 defendant Pyckhaver Thomas yeoman 612869 612869 Pyckhaver, Thomas, of Westdene, yeoman 0
4685241 2260980 2260980 defendant Saffrey John husbandman 612869 612869 Saffrey, John, of Westdene, husbandman 0
5025333 2364302 2364302 defendant Fyrmen John smith 612869 612869 Fyrmen, John, of Westdene, smith 0
5026656 2364673 2364673 defendant Leem Richard laborer 612869 612869 Leem, Richard, of Westdene, laborer 1

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