names

24 rows where place_id = 653107

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3660606 1913578 1913578 defendant Chamberleyn Edward   653107 653107 Chamberleyn, Edward, of Woodstock, Oxon, knight 0
3927304 1999473 1999473 plaintiff Andrewes Richard esq 653107 653107 Andrewes, Richard, of Woodstock, Oxon, esq 0
3932527 2001169 2001169 defendant Barnes William, junior   653107 653107 Barnes, William, junior, of Woodstock, Oxon 1
3946278 2005775 2005775 defendant Wright Edward yeoman 653107 653107 Wright, Edward, of Woodstock, Oxon, yeoman 0
3951430 2007562 2007562 defendant Westall Jerome yeoman 653107 653107 Westall, Jerome, of Woodstock, Oxon, yeoman 1
3961730 2011204 2011204 defendant Flecher John yeoman 653107 653107 Flecher, John, of Woodstock, Oxon, yeoman 0
3981209 2018040 2018040 defendant Crosseley John yeoman 653107 653107 Crosseley, John, of Woodstock, Oxon, yeoman 0
3981785 2018244 2018244 defendant Westall Jerome innholder 653107 653107 Westall, Jerome, of Woodstock, Oxon, innholder 1
4051140 2042847 2042847 plaintiff Whitton George gent 653107 653107 Whitton, George, of Woodstock, Oxon, gent 0
4051253 2042888 2042888 plaintiff Whytton George gent 653107 653107 Whytton, George, of Woodstock, Oxon, gent 0
4059318 2045726 2045726 defendant Skelton William butcher 653107 653107 Skelton, William, of Woodstock, Oxon, butcher 2
4144786 2076339 2076339 defendant Radman William woolman 653107 653107 Radman, William, of Woodstock, Oxon, yeoman, woolman 0
4146559 2076948 2076948 defendant Radman William woolman 653107 653107 Radman, William, of Woodstock, Oxon, yeoman, woolman 0
4150380 2078263 2078263 defendant Abraham Nicholas chapman 653107 653107 Abraham, Nicholas, of Woodstock, Oxon, chapman 1
4241218 2110050 2110050 defendant Kynge Thomas gent 653107 653107 Kynge, Thomas, of Woodstock, Oxon, or of Marshe, Bucks, gent 1
4248438 2112465 2112465 defendant Powell Roger yeoman 653107 653107 Powell, Roger, of Woodstock, Oxon, yeoman 1
4262922 2117264 2117264 defendant Powell Roger yeoman 653107 653107 Powell, Roger, of Woodstock, Oxon, yeoman 1
4292404 2127348 2127348 defendant Whytton George esq 653107 653107 Whytton, George, of Woodstock, Oxon, esq 0
4386685 2160224 2160224 defendant Reelye John chapman 653107 653107 Reelye, John, of Woodstock, Oxon, chapman 1
4401974 2165254 2165254 defendant Ryley John chapman 653107 653107 Ryley, John, of Woodstock, Oxon, chapman 1
4756568 2282417 2282417 defendant Wykam Thomas gent 653107 653107 Wykam, Thomas, of Woodstock, Oxon, gent 0
4762133 2284135 2284135 defendant Wykham John gent 653107 653107 Wykham, John, of Woodstock, Oxon, gent 8
4838479 2307951 2307951 defendant Weller William yeoman 653107 653107 Weller, William, of Woodstock, Oxon, yeoman 0
5012202 2360417 2360417 defendant Maykyn Thomas chapman 653107 653107 Maykyn, Thomas, of Woodstock, Oxon, chapman 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);