names

10 rows where place_id = 809462

✎ 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
4831968 2306028 2306028 defendant Crosseby John chapman 809462 809462 Crosseby, John, of Prytewell, Essex, chapman 2
4944125 2340130 2340130 defendant Styward William clerk 809462 809462 Styward, William, of Prytewell, Essex, clerk 0
4944128 2340131 2340131 defendant Styward William clerk 809462 809462 Styward, William, of Prytewell, Essex, clerk 0
5115407 2390933 2390933 defendant Pratte Richard yeoman 809462 809462 Pratte, Richard, of Prytewell, Essex, yeoman 3
5115412 2390934 2390934 defendant Pratte Richard yeoman 809462 809462 Pratte, Richard, of Prytewell, Essex, yeoman 3
5224480 2422831 2422831 defendant Bretwyle John esq 809462 809462 Bretwyle, John, of Prytewell, Essex, esq 0
5257492 2432464 2432464 defendant Wyxton John chapman 809462 809462 Wyxton, John, of Prytewell, Essex, chapman 1
5290574 2442245 2442245 defendant Wygston John chapman 809462 809462 Wygston, John, of Prytewell, Essex, chapman 0
5290576 2442246 2442246 defendant Wygston John chapman 809462 809462 Wygston, John, of Prytewell, Essex, chapman 0
5293783 2443146 2443146 defendant Wygeston John mercer 809462 809462 Wygeston, John, of Prytewell, Essex, mercer 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);