names

14 rows where place_id = 663113

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3967564 2013287 2013287 defendant Applyard John esq 663113 663113 Applyard, John, of Braken, esq 0
4535546 2211391 2211391 defendant Reynald William   663113 663113 Reynald, William, of Braken 1
4699770 2265371 2265371 defendant Chele Robert yeoman 663113 663113 Chele, Robert, of Braken, yeoman 0
4900085 2326658 2326658 defendant Apelyerd Nicholas gent 663113 663113 Apelyerd, Nicholas, of Braken, gent 0
5042094 2369242 2369242 defendant Appiliard Nicholas esq 663113 663113 Appiliard, Nicholas, of Braken, esq 0
5109175 2389107 2389107 defendant More Henry laborer 663113 663113 More, Henry, of Braken, laborer 0
5172406 2407656 2407656 plaintiff Moot Henry tailor 663113 663113 Moot, Henry, of Braken, tailor 0
5172407 2407656 2407656 defendant Kewe Richard husbandman 663113 663113 Kewe, Richard, of Braken, cart wright, Davy, William, of Fornessete, husbandman 0
5248053 2429569 2429569 defendant Lewe Richard husbandman 663113 663113 Lewe, Richard, of Braken, husbandman 0
5255834 2431948 2431948 defendant Marchale John sawyer 663113 663113 Marchale, John, of Braken, sawyer 2
5273241 2437242 2437242 plaintiff Marchale alias Sawyer John husbandman 663113 663113 Marchale alias Sawyer, John, of Braken, husbandman 0
5274460 2437609 2437609 defendant Applyerd Margaret widow 663113 663113 Applyerd, Margaret, of Braken, widow 0
5283073 2440110 2440110 defendant Keve or Keue Richard carpenter 663113 663113 Keve or Keue, Richard, of Braken, carpenter 0
5355438 2461775 2461775 defendant Kewe Richard husbandman 663113 663113 Kewe, Richard, of Braken, husbandman 1

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