names

43 rows where place_id = 719529

✎ 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
4230236 2106063 2106063 defendant Condy Richard merchant 719529 719529 Condy, Richard, of Bodrugan, Cornw, merchant 0
4891230 2323991 2323991 defendant Bodrugan William   719529 719529 Bodrugan, William, of Bodrugan, Cornw, knight 1
4987774 2353306 2353306 defendant Clerk William gent 719529 719529 Clerk, William, of Bodrugan, Cornw, gent 0
5053646 2372693 2372693 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5081110 2380854 2380854 defendant Bodrugan Henry gent 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, gent 0
5081112 2380855 2380855 defendant Bodrugan Henry gent 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, gent 0
5089209 2383214 2383214 defendant Bodrugan Henry gent 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, gent 0
5091673 2383953 2383953 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5091676 2383954 2383954 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5091679 2383955 2383955 defendant Bodrugan Henry gent 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, gent 0
5091682 2383956 2383956 defendant Bodrugan Henry gent 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, gent 0
5102117 2387045 2387045 defendant Boneythen or Boveythen James gent 719529 719529 Boneythen or Boveythen, James, of Bodrugan, Cornw, gent 0
5131367 2395664 2395664 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 1
5131492 2395694 2395694 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of bodrugan, Cornw, esq 0
5211917 2419223 2419223 defendant mainpernors for Bodrugan Thomas esq 719529 719529 mainpernors for Bodrugan, Thomas, of Bodrugan, Cornw, esq 4
5218133 2421039 2421039 defendant Bodrygan Henry esq 719529 719529 Bodrygan, Henry, of Bodrugan, Cornw, esq 0
5233597 2425418 2425418 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5243145 2428196 2428196 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5243354 2428254 2428254 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5255627 2431877 2431877 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5255629 2431878 2431878 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5262163 2433917 2433917 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5271202 2436673 2436673 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5273437 2437304 2437304 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 0
5273560 2437343 2437343 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5273563 2437344 2437344 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5284658 2440529 2440529 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5323825 2452210 2452210 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5323833 2452211 2452211 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5323841 2452212 2452212 defendant Bodrugan Henry esq 719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, esq 0
5353975 2461306 2461306 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 1
5388022 2471631 2471631 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 0
5396537 2474099 2474099 defendant Beamond John esq 719529 719529 Beamond, John, of Bodrugan, Cornw, esq 4
5409819 2477905 2477905 defendant Beamond John esq 719529 719529 Beamond, John, of Bodrugan, Cornw, esq 4
5409830 2477906 2477906 defendant Beamond John esq 719529 719529 Beamond, John, of Bodrugan, Cornw, esq 4
5421617 2481401 2481401 defendant Oldom Hugh clerk 719529 719529 Oldom, Hugh, of Bodrugan, Cornw, clerk 0
5429719 2483827 2483827 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 2
5457172 2492041 2492041 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 0
5457174 2492042 2492042 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 0
5458848 2492538 2492538 defendant bodrugans Henry   719529 719529 bodrugans, Henry, of Bodrugan, Cornw, knight 2
5469038 2495666 2495666 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 0
5469040 2495667 2495667 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 0
5469059 2495673 2495673 defendant Bodrugan Henry   719529 719529 Bodrugan, Henry, of Bodrugan, Cornw, knight 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);