names

21 rows where case_id = 2385487

✎ 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
5096754 2385487 2385487 plaintiff Strangways James knight   Strangways, James, knight 0
5096755 2385487 2385487 plaintiff Conyers John knight   Conyers, John, knight 1
5096756 2385487 2385487 defendant Huntlegh James yeoman 824474 824474 Huntlegh, James, of Wollour, yeoman 0
5096757 2385487 2385487 defendant Huntlegh Henry yeoman 824474 824474 Huntlegh, Henry, of Wollour, yeoman 1
5096758 2385487 2385487 defendant Gresdon Robert yeoman 596678 596678 Gresdon, Robert, of Middilton, yeoman 2
5096759 2385487 2385487 defendant Hugeson Robert yeoman 596678 596678 Hugeson,Robert, of Middilton, yeoman 3
5096760 2385487 2385487 defendant Tuggale Thomas   845922 845922 Tuggale, Thomas, of Lylburn, yemoan 4
5096761 2385487 2385487 defendant Broun Robert yeoman 845923 845923 Broun, Robert, of Yerdhill, yeoman 5
5096762 2385487 2385487 defendant Ruttour James yeoman 845923 845923 Ruttour, James, of Yerdhill, yeoman 6
5096763 2385487 2385487 defendant Weston Robert yeoman 835695 835695 Weston, Robert, of Homeldon, yeoman 7
5096764 2385487 2385487 defendant Laweson Thomas yeoman 845923 845923 Laweson, Thomas, of Yerdhill, yeoman 8
5096765 2385487 2385487 defendant Weston Adam yeoman 845923 845923 Weston, Adam, of Yerdhill, yeoman 9
5096766 2385487 2385487 defendant Carre John yeoman 845923 845923 Carre, John, of Yerdhill, yeoman 10
5096767 2385487 2385487 defendant Atkynson John yeoman 845923 845923 Atkynson, John, of Yerdhill, yeoman 11
5096768 2385487 2385487 defendant Walterson John yeoman 845923 845923 Walterson, John, of Yerdhill, yeoman 12
5096769 2385487 2385487 defendant Shawe John yeoman 824474 824474 Shawe, John, of Wollour, yeoman 13
5096770 2385487 2385487 defendant Huntlegh John yeoman 824474 824474 Huntlegh, John, of Wollour, yeoman 14
5096771 2385487 2385487 defendant Patonson Patrick yeoman 835695 835695 Patonson, Patrick, of Homeldon,yeoman 15
5096772 2385487 2385487 defendant Vasour William yeoman 593239 593239 Vasour, William, of Lylburn, yeoman 16
5096773 2385487 2385487 defendant Walker William yeoman 793773 793773 Walker, William, of Ilderton, yeoman 17
5096774 2385487 2385487 defendant Hoton Edward yeoman 586083 586083 Hoton, Edward, of Langton, yeoman 18

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