names

14 rows where place_id = 616494

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3714701 1930897 1930897 defendant Dormer Peter gent 616494 616494 Dormer, Peter, of Queynton, gent 0
3714705 1930898 1930898 defendant Dormer Peter gent 616494 616494 Dormer, Peter, of Queynton, gent 0
4177806 2087709 2087709 defendant Freman John husbandman 616494 616494 Freman, John, of Queynton, husbandman 2
4419888 2171121 2171121 defendant Beauner William   616494 616494 Beauner, William, of Queynton 0
4419890 2171122 2171122 defendant Beauner William   616494 616494 Beauner, William, of Queynton 0
4481733 2194988 2194988 defendant Souter John   616494 616494 Souter, John, of Queynton, son of William 0
4558756 2218691 2218691 plaintiff Malet Hugh   616494 616494 Malet, Hugh, of Queynton 0
4804331 2297541 2297541 defendant Couper Thomas (legal representative) 616494 616494 Couper, Thomas, of Queynton, executrix of 0
4894942 2325080 2325080 defendant Hurne Joan widow 616494 616494 Hurne, Joan, of Queynton, widow 0
5170699 2407150 2407150 defendant Hugh Hugh, sen husbandman 616494 616494 Hugh, Hugh, sen, of Queynton, husbandman 0
5333092 2454969 2454969 plaintiff Coweley John yeoman 616494 616494 Coweley, John, of Queynton, yeoman 0
5374303 2467567 2467567 defendant Whelere William husbandman 616494 616494 Whelere, William, of Queynton, husbandman 0
5488249 2501385 2501385 defendant Bunt Thomas husbandman 616494 616494 Bunt, Thomas, of Queynton, husbandman 0
5587057 2530980 2530980 defendant Whelpeley William husbandman 616494 616494 Whelpeley, William, of Queynton, husbandman 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);