names

17 rows where case_id = 2277851

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4740893 2277851 2277851 plaintiff Belyeter Thomas   755389 755389 Belyeter, Thomas, of Bishop's Lenn, on his own account 0
4740894 2277851 2277851 defendant Benne John yeoman 588755 588755 Benne, John, of Teryngton, yeoman 0
4740895 2277851 2277851 defendant Watesson John laborer 794433 794433 Watesson, John, of North Lenche Forton, laborer 1
4740896 2277851 2277851 defendant Broun Richard yeoman 755389 755389 Broun, Richard, of Bishop's Lenn, yeoman 2
4740897 2277851 2277851 defendant Everard John fisher 755389 755389 Everard, John, of Bishop's Lenn, fisher 3
4740898 2277851 2277851 defendant Shepherd Peter fisher 626888 626888 Shepherd, Peter, of West Lenn, fisher 4
4740899 2277851 2277851 defendant Watesson John   794436 794436 Watesson, John, of NLF, parson 5
4740900 2277851 2277851 defendant Somerd John, senior   794436 794436 Somerd, John, senior, of NLF, shepherd 6
4740901 2277851 2277851 defendant Somerd John, junior yeoman 794436 794436 Somerd, John, junior, of NLF, yeoman 7
4740902 2277851 2277851 defendant Aylwyn John husbandman 794436 794436 Aylwyn, John, of NLF, husbandman 8
4740903 2277851 2277851 defendant Caryngton John laborer 794436 794436 Caryngton, John, of NLF, laborer 9
4740904 2277851 2277851 defendant Sammes Richard husbandman 640089 640089 Sammes, Richard, of Tilney, husbandman 10
4740905 2277851 2277851 defendant Parfay Andrew of North Lenn shepherd   Parfay, Andrew of North Lenn, shepherd 11
4740906 2277851 2277851 defendant Brys William laborer 586231 586231 Brys, William, of Wygenhale, laborer 12
4740907 2277851 2277851 defendant Daddy William yeoman 774862 774862 Daddy, William, of North Lenn, yeoman 13
4740908 2277851 2277851 defendant Clerk Thomas laborer 590276 590276 Clerk, Thomas, of West Wynche, laborer 14
4740909 2277851 2277851 defendant Kenston John yeoman 794437 794437 Kenston, John, of North Runton, yeoman 15

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