names

19 rows where place_id = 622161

✎ 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
3598009 1867001 1867001 defendant Ros Henry   622161 622161 Ros, Henry, of West Grensted, Sussex, knight 0
3598012 1867002 1867002 defendant Ros Henry   622161 622161 Ros, Henry, of West Grensted, Sussex, knight 0
3745569 1940520 1940520 defendant Baken Walter yeoman 622161 622161 Baken, Walter, of West Grensted, Sussex, yeoman 0
3764934 1946695 1946695 defendant Sherley Thomas esq 622161 622161 Sherley, Thomas, of West Grensted, Sussex, esq 2
3989844 2021118 2021118 defendant Shirlowe Francis gent 622161 622161 Shirlowe, Francis, of West Grensted, Sussex, gent 2
4057872 2045200 2045200 defendant Farnestuld or Farnesculd James gent 622161 622161 Farnestuld or Farnesculd, James, of West Grensted, Sussex, gent 0
4320018 2137107 2137107 defendant Sherley Thomas esq 622161 622161 Sherley, Thomas, of West Grensted, Sussex, esq 0
4320020 2137108 2137108 defendant Sherley Thomas esq 622161 622161 Sherley, Thomas, of West Grensted, Sussex, esq 0
4320022 2137109 2137109 defendant Sherley Thomas esq 622161 622161 Sherley, Thomas, of West Grensted, Sussex, esq 0
4897002 2325713 2325713 defendant Halsham Hugh   622161 622161 Halsham, Hugh, of West Grensted, Sussex, knight 0
5028654 2365256 2365256 defendant Halsham John gent 622161 622161 Halsham, John, of West Grensted, Sussex, or of Wokkyng, gent 4
5293983 2443212 2443212 defendant Leukenore Joan widow 622161 622161 Leukenore, Joan, of West Grensted, Sussex, widow 2
5294311 2443309 2443309 defendant Wody John husbandman 622161 622161 Wody, John, of West Grensted, Sussex, husbandman 4
5307628 2447296 2447296 defendant Aleyn John yeoman 622161 622161 Aleyn, John, of West Grensted, Sussex, yeoman 0
5385328 2470879 2470879 defendant Roos Henry   622161 622161 Roos, Henry, of West Grensted, Sussex, knight 2
5391586 2472664 2472664 defendant Shuldeham Hugh gent 622161 622161 Shuldeham, Hugh, of West Grensted, Sussex, gent 1
5397400 2474341 2474341 defendant Roos Henry   622161 622161 Roos, Henry, of West Grensted, Sussex, knight 0
5410602 2478115 2478115 defendant Roos Henry   622161 622161 Roos, Henry, of West Grensted, Sussex, knight 0
5480554 2499157 2499157 defendant Roos Henry   622161 622161 Roos, Henry, of West Grensted, Sussex, knight 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);