names

23 rows where place_id = 600155

✎ 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
3639902 1907293 1907293 defendant Aslerkys Richard husbandman 600155 600155 Aslerkys, Richard, of Abyngeworth, husbandman 0
3715455 1931120 1931120 defendant Bowrer John husbandman 600155 600155 Bowrer, John, of Abyngeworth, husbandman 2
3715456 1931120 1931120 defendant Stone Ralph laborer 600155 600155 Stone, Ralph, of Abyngeworth, laborer 3
3745573 1940521 1940521 defendant Le Humphrey yeoman 600155 600155 Le, Humphrey, of Abyngeworth, yeoman 2
3746973 1940972 1940972 plaintiff Dalton Richard yeoman 600155 600155 Dalton, Richard, of Abyngeworth, yeoman 0
3758442 1944636 1944636 defendant Stere Edmund husbandman 600155 600155 Stere, Edmund, of Abyngeworth, husbandman 1
3758443 1944636 1944636 defendant Dalton Richard husbandman 600155 600155 Dalton, Richard, of Abyngeworth, husbandman 2
3758444 1944636 1944636 defendant Dalton Christopher husbandman 600155 600155 Dalton, Christopher, of Abyngeworth, husbandman 3
3793452 1955817 1955817 defendant Long John laborer 600155 600155 Long, John, of Abyngeworth, laborer 2
3797266 1957030 1957030 defendant Worsfold John husbandman 600155 600155 Worsfold, John, of Abyngeworth, husbandman 2
3810450 1961161 1961161 plaintiff Bromhall Hugh fuller 600155 600155 Bromhall, Hugh, of Abyngeworth, fuller 0
3810451 1961161 1961161 defendant Atlee Humphrey yeoman 600155 600155 Atlee, Humphrey, of Abyngeworth, yeoman 0
3846029 1972317 1972317 defendant Worsfold John husbandman 600155 600155 Worsfold, John, of Abyngeworth, husbandman 0
3860396 1976972 1976972 plaintiff Dalton Emery husbandman 600155 600155 Dalton, Emery, of Abyngeworth, husbandman 0
3899845 1990159 1990159 defendant Knyght William husbandman 600155 600155 Knyght, William, of Abyngeworth, husbandman 2
3937589 2002906 2002906 defendant Hyll Edmund gent 600155 600155 Hyll, Edmund, of Abyngeworth, gent 0
4667415 2255530 2255530 defendant Huchon William (legal representative) 600155 600155 Huchon, William, of Abyngeworth, executors of 0
4667419 2255531 2255531 defendant Huchon William (legal representative) 600155 600155 Huchon, William, of Abyngeworth, executors of 0
4921987 2333285 2333285 defendant Longherst John husbandman 600155 600155 Longherst, John, of Abyngeworth, husbandman 0
5009084 2359537 2359537 defendant Redeford Nicholas yeoman 600155 600155 Redeford, Nicholas, of Abyngeworth, yeoman 3
5009089 2359538 2359538 defendant Redeford Nicholas yeoman 600155 600155 Redeford, Nicholas, of Abyngeworth, yeoman 3
5634896 2554906 2554906 defendant Hakker John yeoman 600155 600155 Hakker, John, of Abyngeworth, yeoman 1
5634900 2554907 2554907 defendant Hakker John yeoman 600155 600155 Hakker, John, of Abyngeworth, 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);