names

14 rows where case_id = 2354478

✎ 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
4991937 2354478 2354478 plaintiff Courtenay Hugh knight   Courtenay, Hugh, knight 0
4991938 2354478 2354478 defendant Abell William husbandman 831763 831763 Abell, William, of Haesworthy, husbandman 0
4991939 2354478 2354478 defendant Gauter Walter husbandman 831764 831764 Gauter, Walter, of Kylworthy, husbandman 1
4991940 2354478 2354478 defendant Godescote Richard husbandman 831765 831765 Godescote, Richard, of South Brente, in Lamerton, husbandman 2
4991941 2354478 2354478 defendant Neuton Richard husbandman 831766 831766 Neuton, Richard, of South Brent in Lamerton, husbandman 3
4991942 2354478 2354478 defendant Glubbe Roger laborer 661735 661735 Glubbe, Roger, of South Brente, laborer 4
4991943 2354478 2354478 defendant Grugyn Thomas husbandman 831767 831767 Grugyn, Thomas, of East Langeston, husbandman 5
4991944 2354478 2354478 defendant Frenship John husbandman 831768 831768 Frenship, John, of West Langeston, husbandman 6
4991945 2354478 2354478 defendant Dollyng William, sen husbandman 768224 768224 Dollyng, William, sen, of Rowedon, husbandman 7
4991946 2354478 2354478 defendant Dollyng William jun, of Rowedon, husbandman   Dollyng, William, jun, of Rowedon, husbandman 8
4991947 2354478 2354478 defendant Alyn Nicholas, sen husbandman 611152 611152 Alyn, Nicholas, sen, of Lytton, husbandman 9
4991948 2354478 2354478 defendant Dollyng John husbandman 628847 628847 Dollyng, John, of Monkeston, husbandman 10
4991949 2354478 2354478 defendant Dollyng Philip husbandman 628847 628847 Dollyng, Philip, of Monkeston, husbandman 11
4991950 2354478 2354478 defendant Cragge William husbandman 831769 831769 Cragge, William,of South Brente in Lamerton, husbandman 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);