names

15 rows where place_id = 626203

✎ 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
3768632 1947837 1947837 defendant Bocher William husbandman 626203 626203 Bocher, William, of Cropton, husbandman 0
3768633 1947837 1947837 defendant Hardyng Robert chaplain 626203 626203 Hardyng, Robert, of Cropton, chaplain 1
4364435 2152339 2152339 defendant Horseley William gent 626203 626203 Horseley, William, of Cropton, gent 0
4394945 2162895 2162895 defendant Horseley William gent 626203 626203 Horseley, William, of Cropton, gent 1
4409406 2167740 2167740 defendant Marwood Edward husbandman 626203 626203 Marwood, Edward, of Cropton, husbandman 0
4819107 2302055 2302055 defendant Persyson Richard husbandman 626203 626203 Persyson, Richard, of Cropton, husbandman 5
4819108 2302055 2302055 defendant Robynson John husbandman 626203 626203 Robynson, John, of Cropton, husbandman 6
4819109 2302055 2302055 defendant Dykson William husbandman 626203 626203 Dykson, William, of Cropton, husbandman 7
4819110 2302055 2302055 defendant Dogesson William husbandman 626203 626203 Dogesson, William, of Cropton, husbandman 8
4826509 2304328 2304328 defendant Wode Robert yeoman 626203 626203 Wode, Robert, of Cropton, yeoman 3
4885951 2322473 2322473 defendant Wode John yeoman 626203 626203 Wode, John, of Cropton, yeoman 1
4898610 2326210 2326210 defendant del Wodd John yeoman 626203 626203 del Wodd, John, of Cropton, yeoman 6
4954349 2343268 2343268 defendant Hardewyk Thomas husbandman 626203 626203 Hardewyk, Thomas, of Cropton, husbandman 4
5349255 2459896 2459896 defendant Blachosse William husbandman 626203 626203 Blachosse, William, of Cropton, husbandman 0
5632055 2554046 2554046 defendant Pierson William husbandman 626203 626203 Pierson, William, of Cropton, husbandman 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);