names

13 rows where place_id = 624659

✎ 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
3759524 1944971 1944971 defendant Ladde Robert, senior husbandman 624659 624659 Ladde, Robert, senior, of Cranesley, husbandman 0
3817339 1963332 1963332 defendant Dexter George yeoman 624659 624659 Dexter, George, of Cranesley, yeoman 0
3878239 1982970 1982970 defendant Hypwell Hugh husbandman 624659 624659 Hypwell, Hugh, of Cranesley, husbandman 2
4060353 2046103 2046103 defendant Barnewell Edward gent 624659 624659 Barnewell, Edward, of Cranesley, gent 0
4159987 2081563 2081563 defendant Barnewell Edward gent 624659 624659 Barnewell, Edward, of Cranesley, gent 2
4207526 2098191 2098191 defendant Dallyson Edward gent 624659 624659 Dallyson, Edward, of Cranesley, gent 0
4315889 2135666 2135666 defendant Barnewell Edward gent 624659 624659 Barnewell, Edward, of Cranesley, or of Thorpe Underwood, gent 1
4908719 2329277 2329277 defendant Burbache Thomas husbandman 624659 624659 Burbache, Thomas, of Cranesley, husbandman 0
4912602 2330442 2330442 defendant Broughton William   624659 624659 Broughton, William, of Cranesley, franklin 0
5010310 2359883 2359883 defendant Burbage Thomas husbandman 624659 624659 Burbage, Thomas, of Cranesley, husbandman 0
5088554 2383026 2383026 defendant Smyth Simon smith 624659 624659 Smyth, Simon, of Cranesley, smith 0
5232460 2425070 2425070 defendant Tanfeld Robert, junior gent 624659 624659 Tanfeld, Robert, junior, of Cranesley, gent 0
5636336 2555320 2555320 defendant Carter John husbandman 624659 624659 Carter, John, of Cranesley, husbandman 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);