names

41 rows where place_id = 622995

✎ 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
3639975 1907317 1907317 defendant Sutton Edward   622995 622995 Sutton, Edward, of Dudley, Staffs, knight, Lord Dudley 0
3689546 1922885 1922885 defendant Sutton Edward   622995 622995 Sutton, Edward, of Dudley, Staffs, knight, Lord Dudley 0
3689548 1922886 1922886 defendant Sutton Edward   622995 622995 Sutton, Edward, of Dudley, Staffs, knight, Lord Dudley 0
3689550 1922887 1922887 defendant Sutton John   622995 622995 Sutton, John, of Dudley, Staffs, knight 0
3735764 1937424 1937424 defendant Sutton Edward   622995 622995 Sutton, Edward, of Dudley, Staffs, knight, Lord Dudley 0
3735766 1937425 1937425 defendant Sutton Edward   622995 622995 Sutton, Edward, of Dudley, Staffs, knight, Lord Dudley 0
3750151 1941962 1941962 defendant Lynd William yeoman 622995 622995 Lynd, William, of Dudley, Staffs, yeoman 0
3770602 1948488 1948488 defendant Lynde William gent 622995 622995 Lynde, William, of Dudley, Staffs, gent 0
3784367 1952892 1952892 defendant Sotton Edward   622995 622995 Sotton, Edward, of Dudley, Staffs, knight, Lord Dudley 1
3817408 1963358 1963358 defendant Lynd William yeoman 622995 622995 Lynd, William, of Dudley, Staffs, yeoman 0
3917389 1996175 1996175 defendant Dudley Geoffrey gent 622995 622995 Dudley, Geoffrey, of Dudley, Staffs, gent 0
4283242 2124043 2124043 defendant Carewe John gent 622995 622995 Carewe, John, of Dudley, Staffs, gent 0
4745701 2279256 2279256 defendant Dudley Constance widow 622995 622995 Dudley, Constance, of Dudley, Staffs, Lady Dudley, widow 0
4799294 2295955 2295955 defendant Sutton John   622995 622995 Sutton, John, of Dudley, Staffs, knight 0
4837073 2307553 2307553 defendant Sutton John   622995 622995 Sutton, John, of Dudley, Staffs, knight 0
4954789 2343389 2343389 defendant Meryhurst William cordwainer 622995 622995 Meryhurst, William, of Dudley, Staffs, cordwainer 2
4964060 2346160 2346160 defendant Bradshawe Richard smith 622995 622995 Bradshawe, Richard, of Dudley, Staffs, smith 0
5024133 2363967 2363967 defendant Clerk John yeoman 622995 622995 Clerk, John, of Dudley, Staffs, yeoman 0
5024135 2363968 2363968 defendant Clerk John yeoman 622995 622995 Clerk, John, of Dudley, Staffs, yeoman 0
5062639 2375384 2375384 defendant Taillour John ironmonger or carrier 622995 622995 Taillour, John, of Dudley, Staffs, ironmonger or carrier 4
5062646 2375385 2375385 defendant Taillour John ironmonger 622995 622995 Taillour, John, of Dudley, Staffs, ironmonger 4
5086847 2382549 2382549 defendant Taylour John carrier 622995 622995 Taylour, John, of Dudley, Staffs, carrier 3
5117395 2391520 2391520 defendant Pachyngham William carrier 622995 622995 Pachyngham, William, of Dudley, Staffs, carrier 1
5119713 2392203 2392203 defendant Dudley John   622995 622995 Dudley, John, of Dudley, Staffs, knight 1
5222583 2422319 2422319 defendant Sutton John   622995 622995 Sutton, John, of Dudley, Staffs, knight, Lord Dudley 0
5223402 2422537 2422537 defendant Meklowe Thomas smith 622995 622995 Meklowe, Thomas, of Dudley, Staffs, smith 4
5242632 2428051 2428051 defendant Sutton John   622995 622995 Sutton, John, of Dudley, Staffs, knight 0
5261278 2433639 2433639 defendant Patyngham alias Elcok William yeoman 622995 622995 Patyngham alias Elcok, William, of Dudley, Staffs, yeoman 1
5272304 2436970 2436970 defendant Patencham Thomas chapman 622995 622995 Patencham, Thomas, of Dudley, Staffs, chapman 2
5272310 2436971 2436971 defendant Patencham Thomas chapman 622995 622995 Patencham, Thomas, of Dudley, Staffs, chapman 2
5278452 2438805 2438805 defendant Aynesworth William ironmonger 622995 622995 Aynesworth, William, of Dudley, Staffs, ironmonger 0
5384457 2470639 2470639 defendant Smyth William yeoman 622995 622995 Smyth, William, of Dudley, Staffs, yeoman 4
5388910 2471892 2471892 defendant Hopkyns John   622995 622995 Hopkyns, John, of Dudley, Staffs 0
5388912 2471892 2471892 defendant Patynge William nailman 622995 622995 Patynge, William, of Dudley, Staffs, nailman 2
5395087 2473662 2473662 defendant Smyth (illegible) yeoman 622995 622995 Smyth, ----, of Dudley, Staffs, yeoman 4
5396271 2474021 2474021 defendant Smyth (illegible) yeoman 622995 622995 Smyth, ----, of Dudley, Staffs, yeoman 4
5401605 2475529 2475529 defendant Patryngeham William   622995 622995 Patryngeham, William, of Dudley, Staffs, nail man 2
5409586 2477832 2477832 defendant Smyth William yeoman 622995 622995 Smyth, William, of Dudley, Staffs, yeoman 4
5414564 2479294 2479294 defendant Hopkyns John   622995 622995 Hopkyns, John, of Dudley, Staffs, nail man 0
5414566 2479294 2479294 defendant Patyngeham William   622995 622995 Patyngeham, William, of Dudley, Staffs, nail man 2
5478405 2498568 2498568 defendant Smyth William husbandman 622995 622995 Smyth, William, of Dudley, Staffs, husbandman 2

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