names

25 rows where place_id = 593482

✎ 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
3612060 1871416 1871416 defendant Bambury William yeoman 593482 593482 Bambury, William, of South Pederton, Soms, yeoman 1
3635513 1905905 1905905 defendant Cowle John husbandman 593482 593482 Cowle, John, of South Pederton, Soms, husbandman 0
3635515 1905906 1905906 defendant Cowle John husbandman 593482 593482 Cowle, John, of South Pederton, Soms, husbandman 0
3711408 1929872 1929872 defendant Moke Thomas yeoman 593482 593482 Moke, Thomas, of South Pederton, Soms, yeoman 0
3805457 1959645 1959645 defendant Loveryng Geoffrey husbandman 593482 593482 Loveryng, Geoffrey, of South Pederton, Soms, husbandman 0
3805460 1959646 1959646 defendant Loveryng Geoffrey husbandman 593482 593482 Loveryng, Geoffrey, of South Pederton, Soms, husbandman 0
3823235 1965181 1965181 defendant Mokke Thomas fishmonger 593482 593482 Mokke, Thomas, of South Pederton, Soms, fishmonger 0
4712236 2269143 2269143 defendant Bradon Philip yeoman 593482 593482 Bradon, Philip, of South Pederton, Soms, yeoman 1
4746386 2279440 2279440 defendant Case Nicholas husbandman 593482 593482 Case, Nicholas, of South Pederton, Soms, husbandman 1
4760852 2283733 2283733 defendant Davy John husbandman 593482 593482 Davy, John, of South Pederton, Soms, husbandman 0
4769752 2286510 2286510 defendant More John dyer 593482 593482 More, John, of South Pederton, Soms, dyer 0
4940134 2338943 2338943 defendant Davy Nicholas husbandman 593482 593482 Davy, Nicholas, of South Pederton, Soms, husbandman 0
4940168 2338957 2338957 defendant Clauclesey Richard yeoman 593482 593482 Clauclesey, Richard, of South Pederton, Soms, yeoman 0
4940172 2338958 2338958 defendant Clavelesey Richard yeoman 593482 593482 Clavelesey, Richard, of South Pederton, Soms, yeoman 0
4992644 2354679 2354679 defendant Claveleshey Richard gent 593482 593482 Claveleshey, Richard, of South Pederton, Soms, gent 0
5004832 2358310 2358310 defendant Claveleshey Richard gent 593482 593482 Claveleshey, Richard, of South Pederton, Soms, gent 0
5004834 2358311 2358311 defendant Claveleshey Richard gent 593482 593482 Claveleshey, Richard, of South Pederton, Soms, gent 0
5229544 2424254 2424254 defendant Balle William gent 593482 593482 Balle, William, of South Pederton, Soms, gent 1
5237452 2426536 2426536 defendant Balle William chapman 593482 593482 Balle, William, of South Pederton, Soms, chapman 1
5237467 2426540 2426540 defendant Balle William chapman 593482 593482 Balle, William, of South Pederton, Soms, chapman 0
5337652 2456331 2456331 defendant Case John gent 593482 593482 Case, John, of South Pederton, Soms, gent 0
5479601 2498910 2498910 defendant Peke John   593482 593482 Peke, John, of South Pederton, Soms, "fissheionter" 1
5498684 2504552 2504552 defendant Pyke John   593482 593482 Pyke, John, of South Pederton, Soms, fish loader 1
5517394 2510281 2510281 defendant Case John gent 593482 593482 Case, John, of South Pederton, Soms, gent 0
5603438 2535964 2535964 defendant Gowle John husbandman 593482 593482 Gowle, John, of South Pederton, Soms, 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);