names

10 rows where place_id = 772169

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4586046 2227059 2227059 defendant Pycot Nicholas   772169 772169 Pycot, Nicholas, of Half Naked 0
4606856 2233253 2233253 defendant Webbe Nicholas   772169 772169 Webbe, Nicholas, of Half Naked 5
4705317 2267034 2267034 defendant Kyng Robert husbandman 772169 772169 Kyng, Robert, of Half Naked, husbandman 0
4726789 2273649 2273649 defendant Wolvele Robert yeoman 772169 772169 Wolvele, Robert, of Half Naked, yeoman 1
4726792 2273650 2273650 defendant Wolvele Robert yeoman 772169 772169 Wolvele, Robert, of Half Naked, yeoman 1
4743391 2278597 2278597 defendant Chese William, junior husbandman 772169 772169 Chese, William, junior, of Half Naked, husbandman 1
4829467 2305257 2305257 defendant Pycod Richard husbandman 772169 772169 Pycod, Richard, of Half Naked or Halnacker, husbandman 2
4999476 2356716 2356716 defendant Reyhold William husbandman 772169 772169 Reyhold, William, of Half Naked, husbandman 1
4999477 2356716 2356716 defendant Pyper John husbandman 772169 772169 Pyper, John, of Half Naked, husbandman 2
4999479 2356716 2356716 defendant Mops Henry miller 772169 772169 Mops. Henry, of Half Naked, miller 4

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