names

22 rows where place_id = 596359

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624409 1875170 1875170 defendant Bagbeare Stephen hysbandman 596359 596359 Bagbeare, Stephen, of Mylton Damerell, hysbandman 0
3624410 1875170 1875170 defendant Averey John   596359 596359 Averey, John, of Mylton Damerell, groom 1
3659528 1913241 1913241 defendant Downe William husbandman 596359 596359 Downe, William, of Mylton Damerell, husbandman 0
3659529 1913241 1913241 defendant Towneshend Mark husbandman 596359 596359 Towneshend, Mark, of Mylton Damerell, husbandman 1
3709693 1929344 1929344 plaintiff Townyshende Mark yeoman 596359 596359 Townyshende, Mark, of Mylton Damerell, yeoman 1
3726141 1934440 1934440 defendant Hogge William husbandman 596359 596359 Hogge, William, of Mylton Damerell, husbandman 0
3732565 1936414 1936414 defendant Helyer John tucker 596359 596359 Helyer, John, of Mylton Damerell, tucker 0
3795423 1956441 1956441 defendant Baggebeer Walter   596359 596359 Baggebeer, Walter, of Mylton Damerell, groom 0
3886328 1985682 1985682 defendant Colys Humphrey gent 596359 596359 Colys, Humphrey, of Mylton Damerell, gent 0
4010689 2028593 2028593 defendant Gyffard Anthony gent 596359 596359 Gyffard, Anthony, of Mylton Damerell, or of Dyrworthye, gent 2
4042570 2039809 2039809 defendant Gyfford Anthony gent 596359 596359 Gyfford, Anthony, of Mylton Damerell, or of Dyrsworthie, Devon, gent 1
4077634 2052288 2052288 defendant Corner Robert husbandman 596359 596359 Corner, Robert, of Mylton Damerell, or of Molland, husbandman 0
4149265 2077870 2077870 defendant Barrye Humphrey gent 596359 596359 Barrye, Humphrey, of Mylton Damerell, gent 0
4308795 2133227 2133227 defendant Lappam or Lapham Dorothy spinster 596359 596359 Lappam or Lapham, Dorothy, of Mylton Damerell, spinster 0
4308796 2133227 2133227 defendant Lappam William husbandman 596359 596359 Lappam, William, of Mylton Damerell, husbandman 1
5222357 2422248 2422248 defendant Dunne Roger husbandman 596359 596359 Dunne, Roger, of Mylton Damerell, husbandman 3
5399657 2474987 2474987 defendant Draper Englesia widow 596359 596359 Draper, Englesia, of Mylton Damerell, widow 2
5467044 2495091 2495091 defendant Calle Henry husbandman 596359 596359 Calle, Henry, of Mylton Damerell, husbandman 0
5467045 2495091 2495091 defendant Peryn Nichols husbandman 596359 596359 Peryn, Nichols, of Mylton Damerell, husbandman 1
5467046 2495091 2495091 defendant Colle John gent 596359 596359 Colle, John, of Mylton Damerell, gent 2
5467047 2495091 2495091 defendant Adame William   596359 596359 Adame, William, of Mylton Damerell, groom 3
5564074 2524107 2524107 defendant Werthyn Richard husbandman 596359 596359 Werthyn, Richard, of Mylton Damerell, husbandman 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);