names

16 rows where case_id = 2375441

✎ 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
5062906 2375441 2375441 plaintiff Holland Henry Duke of Exeter   Holland, Henry, Duke of Exeter 0
5062907 2375441 2375441 defendant Holcote John yeoman 607258 607258 Holcote, John, of Elyngton, Hunts, yeoman 0
5062908 2375441 2375441 defendant Bateman John husbandman 612044 612044 Bateman, John, of Elyngton, husbandman 1
5062909 2375441 2375441 defendant Penyell William husbandman 612044 612044 Penyell, William, of Elyngton, husbandman 2
5062910 2375441 2375441 defendant Couper John cooper 612044 612044 Couper, John, of Elyngton, cooper 3
5062911 2375441 2375441 defendant Kyng Thomas husbandman 612044 612044 Kyng, Thomas, of Elyngton, husbandman 4
5062912 2375441 2375441 defendant Elgare John yeoman 612044 612044 Elgare, John, of Elyngton, yeoman 5
5062913 2375441 2375441 defendant Stanwey Ralph yeoman 612044 612044 Stanwey, Ralph, of Elyngton, yeoman 6
5062914 2375441 2375441 defendant Mokke Richard husbandman 612044 612044 Mokke, Richard, of Elyngton, husbandman 7
5062915 2375441 2375441 defendant Hunt Thomas vicar of Stokton Magna, Hunts   Hunt, Thomas, vicar of Stokton Magna, Hunts 8
5062916 2375441 2375441 defendant Ive John husbandman 597826 597826 Ive, John, of Brampton, Hunts, husbandman 9
5062917 2375441 2375441 defendant Hendesson John husbandman 650511 650511 Hendesson, John, of Hamerton, Hunts, husbandman 10
5062918 2375441 2375441 defendant Cawyt John carpenter 609338 609338 Cawyt, John, of Hamerton, carpenter 11
5062919 2375441 2375441 defendant Dalton Robert gent 700220 700220 Dalton, Robert, of Upton, Hunts, gent 12
5062920 2375441 2375441 defendant Faukes John husbandman 841938 841938 Faukes, John, of Sibthorp, Hunts, husbandman 13
5062921 2375441 2375441 defendant Penyell Thomas husbandman 755798 755798 Penyell, Thomas, of Sibthorp, husbandman 14

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