names

17 rows where place_id = 611907

✎ 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
3690637 1923237 1923237 defendant Byrche Robert cooper 611907 611907 Byrche, Robert, of Southold, cooper 0
3775825 1950188 1950188 defendant Maydewell Edward mariner 611907 611907 Maydewell, Edward, of Southold, mariner 1
3821402 1964589 1964589 defendant Blake John merchant 611907 611907 Blake, John, of Southold, merchant 1
3894180 1988270 1988270 defendant Blake John mariner 611907 611907 Blake, John, of Southold, mariner 0
3922621 1997882 1997882 plaintiff Ryppyng James   611907 611907 Ryppyng, James, of Southold 0
3929136 2000083 2000083 defendant Stanton Simon mariner 611907 611907 Stanton, Simon, of Southold, mariner 1
3961553 2011140 2011140 defendant Tyler alias Marchant John husbandman 611907 611907 Tyler alias Marchant, John, of Southold, husbandman 1
3961557 2011141 2011141 defendant Tyler alias Marchant John husbandman 611907 611907 Tyler alias Marchant, John, of Southold, husbandman 1
3967060 2013106 2013106 plaintiff Browne Robert mariner 611907 611907 Browne, Robert, of Southold, mariner 0
4033917 2036783 2036783 plaintiff Gyllett alias Candlor John   611907 611907 Gyllett alias Candlor, John, of Southold 0
4046989 2041373 2041373 defendant Brusshe Richard yeoman 611907 611907 Brusshe, Richard, of Southold, yeoman 0
4046992 2041374 2041374 defendant Brusshe Richard yeoman 611907 611907 Brusshe, Richard, of Southold, yeoman 0
4153000 2079154 2079154 defendant Warne Thomas (legal representative) 611907 611907 Warne, Thomas, of Southold, yeoman, executors of 0
4239624 2109487 2109487 defendant Crucklinge Robert yeoman 611907 611907 Crucklinge, Robert, of Southold, yeoman 0
4247931 2112292 2112292 defendant Crucklinge Robert yeoman 611907 611907 Crucklinge, Robert, of Southold, yeoman 0
4334388 2141779 2141779 defendant Garrarde John gent 611907 611907 Garrarde, John, of Southold, gent 0
5597517 2534126 2534126 defendant Patryk Thomas laborer 611907 611907 Patryk, Thomas, of Southold, laborer 1

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