names

22 rows where place_id = 603516

✎ 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
3654802 1911762 1911762 defendant Byngley John gent 603516 603516 Byngley, John, of Ilford, Essex, gent 0
3781411 1951923 1951923 defendant Jonys Hugh gent 603516 603516 Jonys, Hugh, of Ilford, Essex, gent 3
3826035 1965986 1965986 defendant Marram Robert clerk 603516 603516 Marram, Robert, of Ilford, Essex, clerk 0
3826041 1965988 1965988 defendant Marram Robert clerk 603516 603516 Marram, Robert, of Ilford, Essex, clerk 0
3840417 1970564 1970564 defendant Marham Robert clerk 603516 603516 Marham, Robert, of Ilford, Essex, clerk 1
3858802 1976430 1976430 defendant Browne Leonard clerk 603516 603516 Browne, Leonard, of Ilford, Essex, clerk 2
3858828 1976440 1976440 defendant Browne Leonard clerk 603516 603516 Browne, Leonard, of Ilford, Essex, clerk 1
4035703 2037446 2037446 defendant Hurde Edward yeoman 603516 603516 Hurde, Edward, of Ilford, Essex, or of Snayth, Yorks, yeoman 0
4248931 2112627 2112627 defendant Holstock Henry esq 603516 603516 Holstock, Henry, of Ilford, Essex, esq 0
4253890 2114298 2114298 defendant Fysher William clerk 603516 603516 Fysher, William, of Ilford, Essex, clerk 0
4357845 2149983 2149983 defendant Brasye Edward gent 603516 603516 Brasye, Edward, of Ilford, Essex, gent 3
4396276 2163329 2163329 defendant Vere Ellen gent 603516 603516 Vere, Ellen, of Ilford, Essex, gent 1
4762957 2284398 2284398 defendant Powele John clerk 603516 603516 Powele, John, of Ilford, Essex, clerk 1
4762972 2284402 2284402 defendant Powele John clerk 603516 603516 Powele, John, of Ilford, Essex, clerk 1
4786675 2291887 2291887 defendant Powele John clerk 603516 603516 Powele, John, of Ilford, Essex, clerk 0
4796810 2295154 2295154 defendant Paul John clerk 603516 603516 Paul, John, of Ilford, Essex, clerk 0
4796812 2295155 2295155 defendant Paul John clerk 603516 603516 Paul, John, of Ilford, Essex, clerk 0
5060914 2374836 2374836 defendant Osborn Henry husbandman 603516 603516 Osborn, Henry, of Ilford, Essex, husbandman 3
5199446 2415586 2415586 defendant Pryour Thomas smith 603516 603516 Pryour, Thomas, of Ilford, Essex, smith 2
5199452 2415587 2415587 defendant Pryour Thomas smith 603516 603516 Pryour, Thomas, of Ilford, Essex, smith 2
5211123 2418980 2418980 defendant Pryour Thomas smith 603516 603516 Pryour, Thomas, of Ilford, Essex, smith 0
5500963 2505237 2505237 defendant Grey Robert yeoman 603516 603516 Grey, Robert, of Ilford, Essex, 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);