names

22 rows where place_id = 638509

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3843070 1971357 1971357 defendant Wasshe Christopher cooper 638509 638509 Wasshe, Christopher, of Aysheberton, cooper 3
3902896 1991200 1991200 defendant Northlegh Robert gent 638509 638509 Northlegh, Robert, of Aysheberton, gent 0
3903992 1991575 1991575 defendant Dolbeare John, junior tanner 638509 638509 Dolbeare, John, junior, of Aysheberton, tanner 0
3949577 2006927 2006927 defendant Preston Christopher smith 638509 638509 Preston, Christopher, of Aysheberton, smith 0
3971983 2014759 2014759 defendant Hayes Robert yeoman 638509 638509 Hayes, Robert, of Aysheberton, yeoman 0
3981014 2017969 2017969 plaintiff Pridyaux Robert   638509 638509 Pridyaux, Robert, of Aysheberton, gent, attorney of the bench 0
3981016 2017970 2017970 plaintiff Pridyaux Robert   638509 638509 Pridyaux, Robert, of Aysheberton, gent, attorney of the bench 0
3981018 2017971 2017971 plaintiff Pridyaux Robert   638509 638509 Pridyaux, Robert, of Aysheberton, gent, attorney of the bench 0
3994419 2022758 2022758 defendant Hale Thomas tanner 638509 638509 Hale, Thomas, of Aysheberton, tanner 0
4011958 2029006 2029006 plaintiff Predyaux Robert   638509 638509 Predyaux, Robert, of Aysheberton, attorney of the bench 0
4103968 2061692 2061692 defendant Bowden Edward clothier 638509 638509 Bowden, Edward, of Aysheberton, clothier 0
4103969 2061692 2061692 defendant Lowman Thomas victualer 638509 638509 Lowman, Thomas, of Aysheberton, victualer 1
4103970 2061692 2061692 defendant Springe Jerome weaver 638509 638509 Springe, Jerome, of Aysheberton, weaver 2
4103973 2061693 2061693 defendant Bowden John   638509 638509 Bowden, John, of Aysheberton, tailor, his brother 1
4103974 2061693 2061693 defendant Bowden Thomas   638509 638509 Bowden, Thomas, of Aysheberton, tailor, his brother 2
4108141 2063183 2063183 defendant Langworthy John husbandman 638509 638509 Langworthy, John, of Aysheberton, husbandman 0
4108142 2063183 2063183 defendant Haly John tanner 638509 638509 Haly, John, of Aysheberton, tanner 1
4108143 2063183 2063183 defendant Loman Thomas husbandman 638509 638509 Loman, Thomas, of Aysheberton, husbandman 2
4133450 2072290 2072290 defendant Preston Alexander   638509 638509 Preston, Alexander, of Aysheberton, husbandman, son of John 0
4189374 2091784 2091784 defendant Luscombe Hugh husbandman 638509 638509 Luscombe, Hugh, of Aysheberton, husbandman 1
4599355 2231017 2231017 defendant Vaal William   638509 638509 together with Vaal, William, of Aysheberton 1
5203174 2416690 2416690 defendant Mathewe Thomas yeoman 638509 638509 Mathewe, Thomas, of Aysheberton, yeoman 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);