names

18 rows where place_id = 775530

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4623854 2238437 2238437 defendant Bokelond William   775530 775530 Bokelond, William, of Nymet Bowe 0
4665150 2250582 2250582 defendant Canne Alexander husbandman 775530 775530 Canne, Alexander, of Nymet Bowe, husbandman 1
4665153 2250583 2250583 defendant Canne Alexander husbandman 775530 775530 Canne, Alexander, of Nymet Bowe, husbandman 1
4665156 2250584 2250584 defendant Canne Alexander husbandman 775530 775530 Canne, Alexander, of Nymet Bowe, husbandman 1
4665165 2250588 2250588 defendant Canne Alexander husbandman 775530 775530 Canne, Alexander, of Nymet Bowe, husbandman 1
4698081 2264887 2264887 defendant atte Beare Walwin husbandman 775530 775530 atte Beare, Walwin, of Nymet Bowe, husbandman 0
4702405 2266163 2266163 defendant atte Wode Geoffrey smith 775530 775530 atte Wode, Geoffrey, of Nymet Bowe, smith 4
4726456 2273555 2273555 defendant Smyth Geoffrey husbandman 775530 775530 Smyth, Geoffrey, of Nymet Bowe, husbandman 1
4992663 2354688 2354688 defendant Croppe Henry husbandman 775530 775530 Croppe, Henry, of Nymet Bowe, husbandman 0
5041100 2368963 2368963 defendant Wynsham William husbandman 775530 775530 Wynsham, William, of Nymet Bowe, husbandman 2
5308912 2447709 2447709 defendant Everard Richard tanner 775530 775530 Everard, Richard, of Nymet Bowe, tanner 0
5308914 2447710 2447710 defendant Everard Richard tanner 775530 775530 Everard, Richard, of Nymet Bowe, tanner 0
5311402 2448442 2448442 defendant Snell Richard tanner 775530 775530 Snell, Richard, of Nymet Bowe, tanner 7
5311403 2448442 2448442 defendant Burnet Edmund husbandman 775530 775530 Burnet, Edmund, of Nymet Bowe, husbandman 8
5311408 2448443 2448443 defendant Snell Richard tanner 775530 775530 Snell, Richard, of Nymet Bowe, tanner 3
5311409 2448443 2448443 defendant Burnet Edmund husbandman 775530 775530 Burnet, Edmund, of Nymet Bowe, husbandman 4
5311415 2448444 2448444 defendant Snell Richard tanner 775530 775530 Snell, Richard, of Nymet Bowe, tanner 3
5311416 2448444 2448444 defendant Burnet Edmund husbandman 775530 775530 Burnet, Edmund, of Nymet Bowe, husbandman 4

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