names

25 rows where place_id = 756563

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4438808 2181429 2181429 defendant Deighere Robert   756563 756563 Deighere, Robert, of Bokyngham 0
4449014 2184634 2184634 plaintiff Geddes William   756563 756563 Geddes, William, of Bokyngham 0
4449016 2184635 2184635 plaintiff Geddes William   756563 756563 Geddes, William, of Bokyngham 0
4479774 2194337 2194337 plaintiff Justice Robert   756563 756563 Justice, Robert, of Bokyngham 0
4490176 2197643 2197643 defendant Clerk John farcarter 756563 756563 Clerk, John, of Bokyngham, farcarter 8
4490203 2197644 2197644 defendant Clerk John   756563 756563 Clerk, John, of Bokyngham 8
4512490 2204348 2204348 defendant Midelsex Thomas draper 756563 756563 Midelsex, Thomas, of Bokyngham, draper 0
4532178 2210329 2210329 defendant Domer John   756563 756563 Domer, John, of Bokyngham 0
4532388 2210397 2210397 defendant Seman Agnes   756563 756563 Seman, Agnes, of Bokyngham 2
4554783 2217424 2217424 defendant Tournour Thomas   756563 756563 Tournour, Thomas, of Bokyngham 0
4554812 2217432 2217432 defendant Cary William glover 756563 756563 Cary, William, of Bokyngham, glover 1
4566547 2221106 2221106 defendant Olneye Nicholas   756563 756563 Olneye, Nicholas, of Bokyngham 0
4566548 2221106 2221106 defendant Dunmere John   756563 756563 Dunmere, John, of Bokyngham 1
4603723 2232350 2232350 defendant Seye Robert   756563 756563 Seye, Robert, of Bokyngham 6
4612463 2234964 2234964 defendant Hardell John   756563 756563 Hardell, John, of Bokyngham 1
4824198 2303640 2303640 defendant Coke Thomas butcher 756563 756563 Coke, Thomas, of Bokyngham, butcher 1
4824199 2303640 2303640 defendant Polayne John butcher 756563 756563 Polayne, John, of Bokyngham, butcher 2
4923322 2333721 2333721 defendant Warde John husbandman 756563 756563 Warde, John, of Bokyngham, husbandman 0
5095563 2385125 2385125 defendant Glene William fuller 756563 756563 Glene, William, of Bokyngham, fuller 1
5157081 2403211 2403211 defendant Sambroke William gent 756563 756563 Sambroke, William, of Bokyngham, gent 0
5235315 2425908 2425908 plaintiff Daysy William   756563 756563 Daysy, William, of Bokyngham 0
5245001 2428712 2428712 defendant Lo- William barker 756563 756563 Lo-, William, of Bokyngham, barker 3
5312701 2448837 2448837 plaintiff Bastard Roger   756563 756563 Bastard, Roger, of Bokyngham 0
5399399 2474905 2474905 defendant Foxcote John butcher 756563 756563 Foxcote, John, of Bokyngham, butcher 0
5426995 2483009 2483009 defendant Foxcote John butcher 756563 756563 Foxcote, John, of Bokyngham, butcher 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);