names

15 rows where case_id = 2323556

✎ 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
4889636 2323556 2323556 plaintiff Lyes John     Lyes, John 0
4889637 2323556 2323556 defendant Stevenson John husbandman 817877 817877 Stevenson, John, of Skeldyke in Holand, husbandman 0
4889638 2323556 2323556 defendant Hodegreve John of Skeldyke in Holand husbandman   Hodegreve, John of Skeldyke in Holand, husbandman 1
4889639 2323556 2323556 defendant Arkell Robert husbandman 817877 817877 Arkell, Robert, of Skeldyke in Holand, husbandman 2
4889640 2323556 2323556 defendant Mayden William husbandman 817877 817877 Mayden, William, of Skeldyke in Holand, husbandman 3
4889641 2323556 2323556 defendant Potoke John husbandman 601114 601114 Potoke, John, of Kyrton in Holand, husbandman 4
4889642 2323556 2323556 defendant Potoke Elizabeth singlewoman 601114 601114 Potoke, Elizabeth, of Kyrton in Holand, singlewoman 5
4889643 2323556 2323556 defendant Williamson John Jonson husbandman 601114 601114 Williamson, John Jonson, of Kyrton in Holand, husbandman 6
4889644 2323556 2323556 defendant Stevenet Agnes husbandman 601114 601114 Stevenet, Agnes, of Kyrton in Holand, husbandman 7
4889645 2323556 2323556 defendant Cokkewell Margaret widow 601114 601114 Cokkewell, Margaret, of Kyrton in Holand, widow 8
4889646 2323556 2323556 defendant Wylson Alice widow 601114 601114 Wylson, Alice, of Kyrton in Holand, widow 9
4889647 2323556 2323556 defendant John son of Peresson Richard husbandman 601114 601114 John son of Peresson, Richard, of Kyrton in Holand, husbandman 10
4889648 2323556 2323556 defendant Peke Mary widow 601114 601114 Peke, Mary, of Kyrton in Holand, widow 11
4889649 2323556 2323556 defendant Boson Lambert husbandman 601114 601114 Boson, Lambert, of Kyrton in Holand, husbandman 12
4889650 2323556 2323556 defendant Frankes Richard husbandman 601114 601114 Frankes, Richard, of Kyrton in Holand, 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);