names

14 rows where case_id = 2382000

✎ 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
5084926 2382000 2382000 plaintiff Goldesburgh William     Goldesburgh, William 0
5084927 2382000 2382000 defendant Coke John husbandman 759149 759149 Coke, John, of Holme in Spaldyngmore, husbandman 0
5084928 2382000 2382000 defendant Clerkson William husbandman 759149 759149 Clerkson, William, of Holme in Spaldyngmore, husbandman 1
5084929 2382000 2382000 defendant Holmes Alan husbandman 844579 844579 Holmes, Alan,of Tolhouse, husbandman 2
5084930 2382000 2382000 defendant Wright John, senior husbandman 759149 759149 Wright, John, senior, of Holme in Spaldyngmore, husbandman 3
5084931 2382000 2382000 defendant Armet Thomas husbandman 759149 759149 Armet, Thomas, of Holme in Spaldyngmore, husbandman 4
5084932 2382000 2382000 defendant Couper John cooper 759149 759149 Couper, John, of Holme in Spaldyngmore, cooper 5
5084933 2382000 2382000 defendant Farbarn William husbandman 759149 759149 Farbarn, William, of Holme in Spaldyngmore, husbandman 6
5084934 2382000 2382000 defendant Madson Richard husbandman 759149 759149 Madson, Richard, of Holme in Spaldyngmore, husbandman 7
5084935 2382000 2382000 defendant Madson Thomas husbandman 759149 759149 Madson, Thomas, of Holme in Spaldyngmore, husbandman 8
5084936 2382000 2382000 defendant Freman Robert husbandman 759149 759149 Freman, Robert, of Holme in Spaldyngmore, husbandman 9
5084937 2382000 2382000 defendant Atkynson Thomas husbandman 844580 844580 Atkynson, Thomas, of Byrsey, husbandman 10
5084938 2382000 2382000 defendant Robertson William laborer 844580 844580 Robertson, William, of Byrsey, laborer 11
5084939 2382000 2382000 defendant Fawevell Thomas laborer 844581 844581 Fawevell, Thomas, of Whitmore juxta Clyff, laborer 12

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