names

15 rows where case_id = 2343959

✎ 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
4956693 2343959 2343959 plaintiff Vernoun William     Vernoun, William 0
4956694 2343959 2343959 defendant Appulby John gent 588481 588481 Appulby, John, of Appulby, gent 0
4956695 2343959 2343959 defendant Appulby Edmund gent 588481 588481 Appulby, Edmund, of Appulby, gent 1
4956696 2343959 2343959 defendant Molde John husbandman 588481 588481 Molde, John, of Appulby, husbandman 2
4956697 2343959 2343959 defendant Molde William husbandman 588481 588481 Molde, William, of Appulby, husbandman 3
4956698 2343959 2343959 defendant Derby John laborer 588481 588481 Derby, John, of Appulby, laborer 4
4956699 2343959 2343959 defendant Derby John, junior laborer 588481 588481 Derby, John, junior, of Appulby, laborer 5
4956700 2343959 2343959 defendant Derby Richard laborer 588481 588481 Derby, Richard, of Appulby, laborer 6
4956701 2343959 2343959 defendant Taillour Robert tailor 588481 588481 Taillour, Robert, of Appulby, tailor 7
4956702 2343959 2343959 defendant Taillour John yeoman 588481 588481 Taillour, John, of Appulby, yeoman 8
4956703 2343959 2343959 defendant Dymmok John yeoman 588481 588481 Dymmok, John, of Appulby, yeoman 9
4956704 2343959 2343959 defendant Smyth John smith 588481 588481 Smyth, John, of Appulby, smith 10
4956705 2343959 2343959 defendant Machon William husbandman 588481 588481 Machon, William, of Appulby, husbandman 11
4956706 2343959 2343959 defendant Scotte John husbandman 588481 588481 Scotte, John, of Appulby, husbandman 12
4956707 2343959 2343959 defendant Milner Robert husbandman 827179 827179 Milner, Robert, of Over Shayle, Leics, husbandman 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);