names

31 rows where place_id = 765096

✎ 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
4425804 2172882 2172882 plaintiff Molyneux Beatrice le   765096 765096 Molyneux, Beatrice le, of Crosseby, formerly wife of Richard 0
4513267 2204568 2204568 defendant Wilson Thomas   765096 765096 Wilson, Thomas, of Crosseby 2
4541020 2213099 2213099 plaintiff Wilson John   765096 765096 Wilson, John, of Crosseby 0
4546057 2214707 2214707 defendant Smyth John   765096 765096 Smyth, John, of Crosseby 0
4607776 2233544 2233544 defendant Wilson Henry   765096 765096 Wilson, Henry, of Crosseby, son of John 0
4614746 2235625 2235625 defendant Robynson William   765096 765096 Robynson, William, of Crosseby 0
4622428 2237996 2237996 defendant Milner William   765096 765096 Milner, William, of Crosseby 2
4625120 2238822 2238822 defendant Treweld William de (legal representative) 765096 765096 Treweld, William de, of Crosseby, knight, executors of 0
4631701 2240798 2240798 defendant Gibson William   765096 765096 Gibson, William, of Crosseby 0
4633276 2241276 2241276 defendant Atkynson John   765096 765096 Atkynson, John, of Crosseby 8
4633277 2241276 2241276 defendant Henryson John   765096 765096 Henryson, John, of Crosseby 9
4633278 2241276 2241276 defendant Dykson Richard   765096 765096 Dykson, Richard, of Crosseby 10
4633281 2241276 2241276 defendant Walker William   765096 765096 Walker, William, of Crosseby 13
4633293 2241277 2241277 defendant Boweston William   765096 765096 Boweston, William, of Crosseby 9
4633295 2241277 2241277 defendant Atkynson John   765096 765096 Atkynson, John, of Crosseby 11
4644307 2244424 2244424 defendant Milner William   765096 765096 Milner, William, of Crosseby 2
4665359 2250651 2250651 defendant atte Halle William yeoman 765096 765096 atte Halle, William, of Crosseby, yeoman 2
4688685 2262025 2262025 defendant Nicolson Thomas yeoman 765096 765096 Nicolson, Thomas, of Crosseby, yeoman 3
4724427 2272935 2272935 defendant Grane Thomas gent 765096 765096 Grane, Thomas, of Crosseby, gent 0
4731916 2275164 2275164 defendant Gillesson William chaplain 765096 765096 Gillesson, William, of Crosseby, chaplain 0
4753527 2281479 2281479 defendant Doweson William yeoman 765096 765096 Doweson, William, of Crosseby, yeoman 9
4753528 2281479 2281479 defendant Henryson John yeoman 765096 765096 Henryson, John, of Crosseby, yeoman 10
4808857 2298938 2298938 defendant Nicolson Thomas yeoman 765096 765096 Nicolson, Thomas, of Crosseby, yeoman 4
4816929 2301396 2301396 defendant Garethorn Nicholas husbandman 765096 765096 Garethorn, Nicholas, of Crosseby, husbandman 0
4816930 2301396 2301396 defendant Garethorn William husbandman 765096 765096 Garethorn, William, of Crosseby, husbandman 1
4824784 2303795 2303795 defendant Sanderson Richard yeoman 765096 765096 Sanderson, Richard, of Crosseby, yeoman 1
4824818 2303801 2303801 defendant Daweson John yeoman 765096 765096 Daweson, John, of Crosseby, yeoman 3
4830520 2305570 2305570 defendant Raynaldson John husbandman 765096 765096 Raynaldson, John, of Crosseby, husbandman 9
4883110 2321641 2321641 defendant Leget John yeoman 765096 765096 Leget, John, of Crosseby, yeoman 0
4886754 2322710 2322710 defendant Levynton Thomas yeoman 765096 765096 Levynton, Thomas, of Crosseby, yeoman 4
5283940 2440331 2440331 defendant Tebbe Richard husbandman 765096 765096 Tebbe, Richard, of Crosseby, husbandman 10

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);