names

19 rows where place_id = 609225

✎ 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
3677554 1919024 1919024 defendant Baynton Edward esq 609225 609225 Baynton, Edward, of Bromham, Wilts, esq 0
3767076 1947361 1947361 defendant Beynton Edward   609225 609225 Beynton, Edward, of Bromham, Wilts, knight 3
3801578 1958395 1958395 defendant Baynton Edward   609225 609225 Baynton, Edward, of Bromham, Wilts, knight 3
3807018 1960089 1960089 defendant Baynton Edward   609225 609225 Baynton, Edward, of Bromham, Wilts, knight 0
3915066 1995394 1995394 defendant Baynton Edward (legal representative) 609225 609225 Baynton, Edward, of Bromham, Wilts, knight, executor of 0
3932964 2001317 2001317 defendant Baynton Andrew esq 609225 609225 Baynton, Andrew, of Bromham, Wilts, esq 0
3940240 2003755 2003755 defendant Baynton Andrew esq 609225 609225 Baynton, Andrew, of Bromham, Wilts, esq 0
3940242 2003756 2003756 defendant Baynton Andrew esq 609225 609225 Baynton, Andrew, of Bromham, Wilts, esq 0
3940244 2003757 2003757 defendant Baynton Andrew esq 609225 609225 Baynton, Andrew, of Bromham, Wilts, esq 0
3940246 2003758 2003758 defendant Baynton Andrew esq 609225 609225 Baynton, Andrew, of Bromham, Wilts, esq 0
3965979 2012721 2012721 defendant Pede Henry gent 609225 609225 Pede, Henry, of Bromham, Wilts, gent 0
3965981 2012722 2012722 defendant Dawmer George clothier 609225 609225 Dawmer, George, of Bromham, Wilts, clothier 0
3998446 2024182 2024182 defendant Ballard Robert   609225 609225 Ballard, Robert, of Bromham, Wilts 0
3999467 2024574 2024574 defendant Wylliams Thomas yeoman 609225 609225 Wylliams, Thomas, of Bromham, Wilts, yeoman 1
4101606 2060881 2060881 defendant Bayneton Edward   609225 609225 Bayneton, Edward, of Bromham, Wilts, knight 0
4602513 2232003 2232003 defendant Dalton William   609225 609225 Dalton, William, of Bromham, Wilts, parson 0
4721432 2272036 2272036 defendant Beauchamp Katherine   609225 609225 Beauchamp, Katherine, of Bromham, Wilts, gentle woman, formerly wife of William 0
5507229 2507165 2507165 defendant Tocotys Roger   609225 609225 Tocotys, Roger, of Bromham, Wilts, knight 0
5539417 2516816 2516816 defendant Michell John   609225 609225 Michell, John, of Bromham, Wilts, gent, son of Michell, John 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);