names

25 rows where place_id = 638757

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3819183 1963887 1963887 defendant Eure alias Ever William   638757 638757 Eure alias Ever, William, of Malton, Yorks, knight 0
3844620 1971857 1971857 defendant Langdaill William yeoman 638757 638757 Langdaill, William, of Malton, Yorks, yeoman 0
3946177 2005740 2005740 defendant Bygod Edmund gent 638757 638757 Bygod, Edmund, of Malton, Yorks, gent, son of Robert Bygod, of Wharram in the Streate, Yorks, gent 0
4020222 2031955 2031955 defendant Raysen William chapman 638757 638757 Raysen, William, of Malton, Yorks, chapman 1
4139408 2074455 2074455 defendant Robson Rowland chapman 638757 638757 Robson, Rowland, of Malton, Yorks, chapman 0
4236034 2108175 2108175 defendant Sall Henry yeoman 638757 638757 Sall, Henry, of Malton, Yorks, yeoman 0
4249418 2112792 2112792 defendant Frear William chapman 638757 638757 Frear, William, of Malton, Yorks, chapman 0
4249429 2112795 2112795 defendant Frear William chapman 638757 638757 Frear, William, of Malton, Yorks, chapman 0
4268477 2119060 2119060 defendant Sall or Sawle Henry yeoman 638757 638757 Sall or Sawle, Henry, of Malton, Yorks, yeoman 0
4293221 2127640 2127640 defendant Eglesfeild alias Edenfield Ralph chapman 638757 638757 Eglesfeild alias Edenfield, Ralph, of Malton, Yorks, chapman 0
4360137 2150790 2150790 defendant Dutton George gent 638757 638757 Dutton, George, of Malton, Yorks, gent 0
4373706 2155664 2155664 defendant Eckelsfeild Ralph chapman 638757 638757 Eckelsfeild, Ralph, of Malton, Yorks, chapman 2
4750003 2280477 2280477 defendant Scalby William gent 638757 638757 Scalby, William, of Malton, Yorks, gent 0
4769848 2286545 2286545 defendant Scawy or Scalby William gent 638757 638757 Scawy or Scalby, William, of Malton, Yorks, gent 0
4794404 2294392 2294392 defendant Scalby William gent 638757 638757 Scalby, William, of Malton, Yorks, gent 0
4816113 2301129 2301129 defendant Henryson Thomas husbandman 638757 638757 Henryson, Thomas, of Malton, Yorks, husbandman 0
4816121 2301130 2301130 defendant Seymoure William   638757 638757 Seymoure, William, of Malton, Yorks, franklin 1
4838254 2307883 2307883 defendant Senyowr William gent 638757 638757 Senyowr, William, of Malton, Yorks, gent 2
4857204 2313639 2313639 defendant Stalby or Scalby William gent 638757 638757 Stalby or Scalby, William, of Malton, Yorks, gent 1
5010615 2359975 2359975 defendant Langdale William gent 638757 638757 Langdale, William, of Malton, Yorks, gent 3
5138927 2397883 2397883 defendant Loncastre John tailor 638757 638757 Loncastre, John, of Malton, Yorks, tailor 0
5159829 2403973 2403973 defendant Loncastre John tailor 638757 638757 Loncastre, John, of Malton, Yorks, tailor 0
5174796 2408327 2408327 defendant Lancastre John tailor 638757 638757 Lancastre, John, of Malton, Yorks, tailor 0
5275520 2437909 2437909 defendant Chapman Thomas mercer 638757 638757 Chapman, Thomas, of Malton, Yorks, mercer 4
5441307 2487315 2487315 defendant Cartar Richard butcher 638757 638757 Cartar, Richard, of Malton, Yorks, butcher 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);