names

11 rows where place_id = 634692

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3820602 1964328 1964328 defendant Smyth Robert laborer 634692 634692 Smyth, Robert, of Suthewell, laborer 0
4462237 2188886 2188886 defendant Godwyn Thomas   634692 634692 Godwyn, Thomas, of Suthewell 0
4696223 2264302 2264302 defendant Monce John chaplain 634692 634692 Monce, John, of Suthewell, chaplain 0
4704624 2266823 2266823 defendant Hode William butcher 634692 634692 Hode, William, of Suthewell, butcher 0
4755972 2282251 2282251 defendant Ragge Thomas husbandman 634692 634692 Ragge, Thomas, of Suthewell, husbandman 0
4800897 2296467 2296467 defendant Lombe William husbandman 634692 634692 Lombe, William, of Suthewell, husbandman 2
4846898 2310539 2310539 defendant Lamby William chaplain 634692 634692 Lamby, William, of Suthewell, chaplain 0
4895549 2325276 2325276 defendant Gonsyll or Gousyll Alan   634692 634692 Gonsyll or Gousyll, Alan, of Suthewell, or of Nottingham, locksmith 0
5049345 2371436 2371436 defendant Weston John smith 634692 634692 Weston, John, of Suthewell, smith 0
5630329 2553493 2553493 plaintiff Sabbe Henry   634692 634692 Sabbe, Henry, of Suthewell 0
5630333 2553494 2553494 plaintiff Sabbe Henry   634692 634692 Sabbe, Henry, of Suthewell 0

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