names

23 rows where place_id = 774862

✎ 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
4616867 2236278 2236278 plaintiff Geboun Stephen   774862 774862 Geboun, Stephen, of North Lenn 0
4617970 2236627 2236627 plaintiff Gyboun Stephen   774862 774862 Gyboun, Stephen, of North Lenn 0
4637354 2242480 2242480 plaintiff Gehoun Stephen   774862 774862 Gehoun, Stephen, of North Lenn 1
4642161 2243821 2243821 plaintiff Gyboun Stephen   774862 774862 Gyboun, Stephen, of North Lenn 0
4663121 2249931 2249931 plaintiff Geboun Stephen   774862 774862 Geboun, Stephen, of North Lenn 0
4664015 2250232 2250232 plaintiff Gybon Stephen   774862 774862 Gybon, Stephen, of North Lenn 0
4677012 2258430 2258430 plaintiff Gybon Stephen   774862 774862 Gybon, Stephen, of North Lenn 0
4677019 2258431 2258431 plaintiff Gybon Stephen   774862 774862 Gybon, Stephen, of North Lenn 0
4677024 2258432 2258432 plaintiff Gybon Stephen   774862 774862 Gybon, Stephen, of North Lenn, on his own account 0
4677032 2258433 2258433 plaintiff Gybon Stephen   774862 774862 Gybon, Stephen, of North Lenn, on his own account 0
4725851 2273373 2273373 plaintiff Gobon Stephen   774862 774862 Gobon, Stephen, of North Lenn 0
4740907 2277851 2277851 defendant Daddy William yeoman 774862 774862 Daddy, William, of North Lenn, yeoman 13
4771330 2287016 2287016 defendant Bukle Thomas shipman 774862 774862 Bukle, Thomas, of North Lenn, shipman 0
4812352 2299977 2299977 plaintiff Gybon Stephen   774862 774862 Gybon, Stephen, of North Lenn 0
4897791 2325973 2325973 defendant Colson John yeoman 774862 774862 Colson, John, of North Lenn, yeoman 0
5013405 2360755 2360755 defendant Pierpounte Roger esq 774862 774862 (Pierpounte, Roger, of North Lenn, esq 1
5072084 2378143 2378143 plaintiff Sutton John, senior   774862 774862 Sutton, John, senior, of North Lenn 0
5072085 2378143 2378143 plaintiff Sutton John, junior   774862 774862 Sutton, John, junior, of North Lenn 1
5085558 2382171 2382171 plaintiff Guybon Gregory gent 774862 774862 Guybon, Gregory, of North Lenn, gent 0
5085559 2382171 2382171 defendant Sutton John husbandman 774862 774862 Sutton, John, of North Lenn, husbandman 0
5096941 2385536 2385536 plaintiff Sutton John, senior   774862 774862 Sutton, John, senior, of North Lenn 0
5096942 2385536 2385536 plaintiff Sutton John, junior   774862 774862 Sutton, John, junior, of North Lenn 1
5218203 2421052 2421052 defendant Guybon Gregory gent 774862 774862 Guybon, Gregory, of North Lenn, gent 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);