names

18 rows where place_id = 590543

✎ 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
3601566 1868146 1868146 defendant Golby John, junior yeoman 590543 590543 Golby, John, junior, of Ayno, Nhants, yeoman 0
3631331 1904609 1904609 defendant Byknell or Bryknell alias Brudenell William husbandman 590543 590543 Byknell or Bryknell alias Brudenell, William, of Ayno, Nhants, husbandman 0
3647213 1909517 1909517 defendant Hyll Richard clerk 590543 590543 Hyll, Richard, of Ayno, Nhants, clerk 0
3657604 1912641 1912641 defendant Roose John gent 590543 590543 Roose, John, of Ayno, Nhants, gent 0
3657606 1912642 1912642 defendant Roose John gent 590543 590543 Roose, John, of Ayno, Nhants, gent 0
4305370 2132021 2132021 defendant Tayler Thomas yeoman 590543 590543 Tayler, Thomas, of Ayno, Nhants, yeoman 0
4309234 2133382 2133382 defendant Skylman Richard husbandman 590543 590543 Skylman, Richard, of Ayno, Nhants, husbandman 0
4663514 2250063 2250063 defendant Juster or Inster Walter husbandman 590543 590543 Juster or Inster, Walter, of Ayno, Nhants, husbandman 0
4931421 2336206 2336206 defendant Hopton Robert   590543 590543 Hopton, Robert, of Ayno, Nhants, knight 0
5008266 2359308 2359308 plaintiff Sutton William   590543 590543 Sutton, William, of Ayno, Nhants 0
5010576 2359967 2359967 defendant Hopton Robert   590543 590543 Hopton, Robert, of Ayno, Nhants, knight 1
5232436 2425062 2425062 defendant Brudenell Peter husbandman 590543 590543 Brudenell, Peter, of Ayno, Nhants, husbandman 1
5232441 2425064 2425064 defendant Brudenell Peter husbnandman 590543 590543 Brudenell, Peter, of Ayno, Nhants, husbnandman 0
5396052 2473958 2473958 defendant Howeden John smith 590543 590543 Howeden, John, of Ayno, Nhants, smith 0
5409339 2477763 2477763 defendant Howeden John smith 590543 590543 Howeden, John, of Ayno, Nhants, smith 0
5422861 2481793 2481793 defendant Haweden John smith 590543 590543 Haweden, John, of Ayno, Nhants, smith 0
5423321 2481935 2481935 defendant Haweden John smith 590543 590543 Haweden, John, of Ayno, Nhants, smith 0
5599196 2534629 2534629 defendant Brykenell alias Brudenell William husbandman 590543 590543 Brykenell alias Brudenell, William, of Ayno, Nhants, husbandman 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);