names

33 rows where place_id = 588275

✎ 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
3593929 1865740 1865740 defendant Cokker John yeoman 588275 588275 Cokker, John, of Byngham, Notts, yeoman 0
3605578 1869411 1869411 defendant Cokker John yeoman of the crown 588275 588275 Cokker, John, of Byngham, Notts, yeoman of the crown 1
3745778 1940582 1940582 defendant Wheteley Thomas husbandman 588275 588275 Wheteley, Thomas, of Byngham, Notts, husbandman 0
4766784 2285605 2285605 defendant Carter John yeoman 588275 588275 Carter, John, of Byngham, Notts, yeoman 0
4766786 2285606 2285606 defendant Carter John yeoman 588275 588275 Carter, John, of Byngham, Notts, yeoman 0
4791115 2293320 2293320 defendant Carter John yeoman 588275 588275 Carter, John, of Byngham, Notts, yeoman 0
4836733 2307454 2307454 defendant Barmesdale Thomas yeoman 588275 588275 Barmesdale, Thomas, of Byngham, Notts, yeoman 0
4888522 2323207 2323207 defendant Roter Richard miller 588275 588275 Roter, Richard, of Byngham, Notts, miller 1
4912322 2330355 2330355 defendant Rempston William   588275 588275 Rempston, William, of Byngham, Notts, parson 0
4912652 2330461 2330461 defendant Rempston William   588275 588275 Rempston, William, of Byngham, Notts, parson 0
4923373 2333736 2333736 defendant Rempston William   588275 588275 Rempston, William, of Byngham, Notts, parson 0
4946907 2341035 2341035 defendant Rempston William clerk 588275 588275 Rempston, William, of Byngham, Notts, clerk 0
4951134 2342319 2342319 defendant Rempston Thomas   588275 588275 Rempston, Thomas, of Byngham, Notts, knight 0
4990066 2353937 2353937 defendant Pryde Robert baker 588275 588275 Pryde, Robert, of Byngham, Notts, baker 2
4994923 2355337 2355337 defendant Rompston William   588275 588275 Rompston, William, of Byngham, Notts, clerk, rector & parson 0
5005297 2358451 2358451 defendant Rempston William clerk 588275 588275 Rempston, William, of Byngham, Notts, clerk 0
5005302 2358452 2358452 defendant Rugewyn William clerk 588275 588275 Rugewyn, William, of Byngham, Notts, clerk 3
5099009 2386141 2386141 defendant Rempston Thomas   588275 588275 Rempston, Thomas, of Byngham, Notts, knight 0
5113555 2390355 2390355 defendant Rempston Thomas   588275 588275 Rempston, Thomas, of Byngham, Notts, knight 1
5117413 2391525 2391525 defendant Rempston Thomas   588275 588275 Rempston, Thomas, of Byngham, Notts, knight 0
5323759 2452193 2452193 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 0
5399822 2475042 2475042 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 1
5412819 2478783 2478783 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 1
5427795 2483271 2483271 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 1
5427800 2483272 2483272 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 1
5427805 2483273 2483273 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 1
5428905 2483561 2483561 defendant Holt Richard gent 588275 588275 Holt, Richard, of Byngham, Notts, gent 0
5437880 2486263 2486263 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 0
5446108 2488724 2488724 defendant Holt Richard gent 588275 588275 Holt, Richard, of Byngham, Notts, gent 0
5452031 2490489 2490489 defendant Dalby Thomas yeoman 588275 588275 Dalby, Thomas, of Byngham, Notts, yeoman 0
5458742 2492509 2492509 defendant Holt Richard gent 588275 588275 Holt, Richard, of Byngham, Notts, gent 0
5506516 2506944 2506944 defendant Stodard William husbandman 588275 588275 Stodard, William, of Byngham, Notts, husbandman 0
5526949 2512995 2512995 defendant Warde Roger yeoman 588275 588275 Warde, Roger, of Byngham, Notts, yeoman 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);