names

13 rows where place_id = 684973

✎ 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
4060487 2046154 2046154 defendant Lloide Richard gent 684973 684973 Lloide, Richard, of Wroxton, gent 1
4122905 2068490 2068490 defendant Pope John (legal representative) 684973 684973 Pope, John, of Wroxton, esq, administratrix of 0
4132995 2072130 2072130 defendant Pope John (legal representative) 684973 684973 Pope, John, of Wroxton, esq, administratrix of 0
4138291 2074061 2074061 defendant Pope John (legal representative) 684973 684973 Pope, John, of Wroxton, esq, administratrix of 0
4302457 2130979 2130979 defendant Taylor William yeoman 684973 684973 Taylor, William, of Wroxton, yeoman 2
4308496 2133126 2133126 defendant Vaughan Richard, senior   684973 684973 Vaughan, Richard, senior, of Wroxton, gent Vaughan, Philip gent 0
4348633 2146778 2146778 defendant Lucas Thomas yeoman 684973 684973 Lucas, Thomas, of Wroxton, yeoman 0
4498669 2200222 2200222 defendant Midlyngton Richard   684973 684973 Midlyngton, Richard, of Wroxton, prior 0
4535611 2211417 2211417 plaintiff Smyth John   684973 684973 Smyth, John, of Wroxton 0
4730989 2274894 2274894 defendant Sutton John husbandman 684973 684973 Sutton, John, of Wroxton, husbandman 0
4907641 2328956 2328956 plaintiff Abberbury John   684973 684973 Abberbury, John, of Wroxton, prior 0
5296870 2444074 2444074 defendant Broun Robert yeoman 684973 684973 Broun, Robert, of Wroxton, yeoman 1
5296871 2444074 2444074 defendant Fyssheman Thomas yeoman 684973 684973 Fyssheman, Thomas, of Wroxton, yeoman 2

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