names

15 rows where case_id = 2399899

✎ 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
5145741 2399899 2399899 plaintiff Brounflete Henry knight   Brounflete, Henry, knight 0
5145742 2399899 2399899 defendant Haunserd Richard esq 702669 702669 Haunserd, Richard, of Sheryf Hoton, esq 0
5145743 2399899 2399899 defendant Acclom John esq 852844 852844 Acclom, John, of Cathwhatte by Sutton on Derwent, esq 1
5145744 2399899 2399899 defendant Acclom Ralph esq 828503 828503 Acclom, Ralph, of West Harlesey, esq 2
5145745 2399899 2399899 defendant Westeby Richard gent 587101 587101 Westeby, Richard, of Snayth, gent 3
5145746 2399899 2399899 defendant Laweton William gent 655323 655323 Laweton, William, of Howeden, gent 4
5145747 2399899 2399899 defendant Thorp Thomas yeoman 655323 655323 Thorp, Thomas, of Howeden, yeoman 5
5145748 2399899 2399899 defendant Constable Robert esq 637924 637924 Constable, Robert, of Barnby Bossall, esq 6
5145749 2399899 2399899 defendant Laton John esq 852845 852845 Laton, John, of Sproxeton, esq 7
5145750 2399899 2399899 defendant Morley Roger yeoman 852846 852846 Morley, Roger, of Rykcall, yeoman 8
5145751 2399899 2399899 defendant Lee Hugh esq 655323 655323 Lee, Hugh, of Howeden, esq 9
5145752 2399899 2399899 defendant Ibotson Thomas yeoman 852847 852847 Ibotson, Thomas, of Aremyn, yeoman 10
5145753 2399899 2399899 defendant Smyth John yeoman 852848 852848 Smyth, John, of Goule, in Snayth, yeoman 11
5145754 2399899 2399899 defendant Hoby John yeoman 702669 702669 Hoby, John, of Sheryf Hoton, yeoman 12
5145755 2399899 2399899 defendant Syngelton Richard yeoman 852849 852849 Syngelton, Richard, of Bagthorp, in Hemyngburgh, yeoman 13

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