names

13 rows where case_id = 2318683

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4873594 2318683 2318683 plaintiff Petye Thomas     Petye, Thomas 0
4873595 2318683 2318683 defendant Nicolson William yeoman 815699 815699 Nicolson, William, of Robriddyng, yeoman 0
4873596 2318683 2318683 defendant Denyas John yeoman 815700 815700 Denyas, John, of Heggilstale, yeoman 1
4873597 2318683 2318683 defendant Milner Robert yeoman 773594 773594 Milner, Robert, of Souleby, yeoman 2
4873598 2318683 2318683 defendant Knokestub John yeoman 773594 773594 Knokestub, John, of Souleby, yeoman 3
4873599 2318683 2318683 defendant Tomson William yeoman 815701 815701 Tomson, William, of Parva Musgrave, yeoman 4
4873600 2318683 2318683 defendant Watson John yeoman 815701 815701 Watson, John, of Parva Musgrave, yeoman 5
4873601 2318683 2318683 defendant Watson Richard yeoman 815701 815701 Watson, Richard, of Parva Musgrave, yeoman 6
4873602 2318683 2318683 defendant Boynell or Boyvell Richard yeoman 601139 601139 Boynell or Boyvell, Richard, of Magna Musgrave, yeoman 7
4873603 2318683 2318683 defendant Chapman William yeoman 594880 594880 Chapman, William, of Wynton, yeoman 8
4873604 2318683 2318683 defendant Morland William yeoman 594880 594880 Morland, William, of Wynton, yeoman 9
4873605 2318683 2318683 defendant Westmorland William yeoman 594880 594880 Westmorland, William, of Wynton, yeoman 10
4873606 2318683 2318683 defendant Hobson John yeoman 594880 594880 Hobson, John, of Wynton, yeoman 11

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