names

32 rows where place_id = 586591

✎ 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
3589115 1864243 1864243 plaintiff Brook John   586591 586591 Brook, John, of Soham Monks 0
3601490 1868121 1868121 defendant Spyche William chaplain 586591 586591 Spyche, William, of Soham Monks, chaplain 0
3606546 1869719 1869719 defendant Corbald John husbandman 586591 586591 Corbald, John, of Soham Monks, husbandman 1
3683181 1920858 1920858 defendant Wulffe Robert husbandman 586591 586591 Wulffe, Robert, of Soham Monks, husbandman 2
3695833 1924931 1924931 defendant Wheymond Robert husbandman 586591 586591 Wheymond, Robert, of Soham Monks, husbandman 1
3728066 1935037 1935037 plaintiff Nicolle John   586591 586591 (Nicolle, John, of Soham Monks 1
3744223 1940090 1940090 defendant Lyng William husbandman 586591 586591 Lyng, William, of Soham Monks, husbandman 0
3746563 1940839 1940839 defendant Aleyn alias Langere John husbandman 586591 586591 Aleyn alias Langere, John, of Soham Monks, husbandman 3
3755496 1943673 1943673 defendant Broke William husbandman 586591 586591 Broke, William, of Soham Monks, husbandman 0
3773264 1949347 1949347 defendant Broke William husbandman 586591 586591 Broke, William, of Soham Monks, husbandman 0
3782852 1952386 1952386 defendant Wolff Robert husbandman 586591 586591 Wolff, Robert, of Soham Monks, husbandman 0
3782853 1952386 1952386 defendant Sheldrake John husbandman 586591 586591 Sheldrake, John, of Soham Monks, husbandman 1
3797862 1957228 1957228 defendant Alred John husbandman 586591 586591 Alred, John, of Soham Monks, husbandman 0
3811174 1961391 1961391 defendant Exymbull Robert yeoman 586591 586591 Exymbull, Robert, of Soham Monks, yeoman 0
3887204 1985986 1985986 defendant Weymond Peter husbandman 586591 586591 Weymond, Peter, of Soham Monks, husbandman 0
3955166 2008869 2008869 plaintiff Mahew John   586591 586591 Mahew, John, of Soham Monks 0
3971453 2014574 2014574 defendant Aldryche Peter husbandman 586591 586591 Aldryche, Peter, of Soham Monks, husbandman 0
4353812 2148554 2148554 defendant Mahewe John yeoman 586591 586591 Mahewe, John, of Soham Monks, yeoman 2
5013419 2360759 2360759 defendant Nicoll William weaver 586591 586591 Nicoll, William, of Soham Monks, weaver 0
5015373 2361377 2361377 defendant Lyncoln John husbandman 586591 586591 Lyncoln, John, of Soham Monks, husbandman 1
5022384 2363444 2363444 defendant Benet John weaver 586591 586591 Benet, John, of Soham Monks, weaver 0
5027168 2364816 2364816 defendant Skynner John yeoman 586591 586591 Skynner, John, of Soham Monks, yeoman 2
5055303 2373171 2373171 defendant Gamyn Stephen husbandman 586591 586591 Gamyn, Stephen, of Soham Monks, husbandman 0
5055307 2373171 2373171 defendant Alred Edmund husbandman 586591 586591 Alred, Edmund, of Soham Monks, husbandman 4
5333699 2455152 2455152 defendant Elyot John butcher 586591 586591 Elyot, John, of Soham Monks, butcher 1
5350906 2460393 2460393 defendant Elyot John butcher 586591 586591 Elyot, John, of Soham Monks, butcher 2
5527569 2513201 2513201 defendant Elyot John butcher 586591 586591 Elyot, John, of Soham Monks, butcher 4
5539176 2516737 2516737 defendant Caldewell John   586591 586591 Caldewell, John, of Soham Monks 0
5539178 2516738 2516738 defendant Caldewell John   586591 586591 Caldewell, John, of Soham Monks 0
5539260 2516765 2516765 defendant Nicholl John yeoman 586591 586591 (Nicholl, John, of Soham Monks, yeoman 1
5539261 2516765 2516765 defendant Wythe Robert yeoman 586591 586591 Wythe, Robert, of Soham Monks, yeoman 2
5583648 2529961 2529961 defendant Caldewell Richard gent 586591 586591 Caldewell, Richard, of Soham Monks, gent 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);