names

21 rows where place_id = 632010

✎ 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
3804129 1959219 1959219 defendant Goudehey alias Lancashire William husbandman 632010 632010 Goudehey alias Lancashire, William, of Balne, husbandman 0
4080733 2053420 2053420 defendant Nowell John gent 632010 632010 Nowell, John, of Balne, gent 0
4080734 2053420 2053420 defendant Balne Robert yeoman 632010 632010 Balne, Robert, of Balne, yeoman 1
4085046 2054932 2054932 defendant Nowell John gent 632010 632010 Nowell, John, of Balne, gent 0
4495114 2199160 2199160 defendant Megeson Robert   632010 632010 Megeson, Robert, of Balne 0
4528474 2209186 2209186 defendant Mangol_ Alexander   632010 632010 Mangol_, Alexander, of Balne 0
4660535 2249119 2249119 defendant Bramwith Robert   632010 632010 Bramwith, Robert, of Balne, "warkman" 1
4679214 2259107 2259107 plaintiff Jepson John   632010 632010 Jepson, John, of Balne, son of Robert 0
4699604 2265327 2265327 plaintiff Dylcok Thomas, sen   632010 632010 Dylcok, Thomas, sen, of Balne 0
4767662 2285866 2285866 defendant Robynson John yeoman 632010 632010 Robynson, John, of Balne, yeoman 16
4792042 2293612 2293612 defendant Robynson John yeoman 632010 632010 Robynson, John, of Balne, yeoman 16
4819502 2302178 2302178 plaintiff Merchant Henry merchant 632010 632010 (Merchant, Henry, of Balne, merchant 1
4854418 2312776 2312776 defendant Rycard John husbandman 632010 632010 Rycard, John, of Balne, husbandman 0
4854419 2312776 2312776 defendant Stepill John husbandman 632010 632010 Stepill, John, of Balne, husbandman 1
4854420 2312776 2312776 defendant Balne William de husbandman 632010 632010 Balne, William de, of Balne, husbandman 2
4854421 2312776 2312776 defendant Mangoll Robert husbandman 632010 632010 Mangoll, Robert, of Balne, husbandman 3
4881403 2321082 2321082 defendant Dilcok Thomas husbandman 632010 632010 Dilcok, Thomas, of Balne, husbandman 0
4906618 2328658 2328658 plaintiff Dylcok Thomas, junior   632010 632010 Dylcok, Thomas, junior, of Balne 0
4906621 2328659 2328659 plaintiff Dylcok Thomas, junior   632010 632010 Dylcok, Thomas, junior, of Balne 0
5029684 2365552 2365552 defendant Richardson John husbandman 632010 632010 Richardson, John, of Balne, husbandman 0
5062113 2375224 2375224 defendant Tesedale William yeoman 632010 632010 Tesedale, William, of Balne, yeoman 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);