names

31 rows where place_id = 760239

✎ 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
4468340 2190763 2190763 defendant Tredde John   760239 760239 Tredde, John, of Ilmynstre 2
4489242 2197354 2197354 plaintiff Thecher John   760239 760239 Thecher, John, of Ilmynstre, son of William 0
4489243 2197354 2197354 defendant Peverell Richard   760239 760239 Peverell, Richard, of Ilmynstre 0
4537899 2212138 2212138 defendant Marchyaunt Thomas   760239 760239 Marchyaunt, Thomas, of Ilmynstre 0
4549429 2215767 2215767 defendant Orchard John   760239 760239 Orchard, John, of Ilmynstre 3
4563887 2220275 2220275 defendant Rok John   760239 760239 Rok, John, of Ilmynstre 0
4612062 2234839 2234839 plaintiff Cook John   760239 760239 Cook, John, of Ilmynstre 0
4651537 2246485 2246485 defendant Osgodde John yeoman 760239 760239 together with Osgodde, John, of Ilmynstre, yeoman 1
4673092 2257227 2257227 defendant Baker Robert drover 760239 760239 Baker, Robert, of Ilmynstre, drover 0
4673093 2257227 2257227 defendant Deye John butcher 760239 760239 Deye, John, of Ilmynstre, butcher 1
4679430 2259182 2259182 defendant Presford William draper 760239 760239 Presford, William, of Ilmynstre, draper 1
4682154 2260040 2260040 defendant Delyngton Matilda widow & formerly wife of Richard 760239 760239 Delyngton, Matilda, of Ilmynstre, widow & formerly wife of Richard 0
4682156 2260040 2260040 defendant Bastedore Robert husbandman 760239 760239 Bastedore, Robert, of Ilmynstre, husbandman 2
4750539 2280641 2280641 defendant Sawyer Thomas draper 760239 760239 Sawyer, Thomas, of Ilmynstre, draper 1
4767870 2285925 2285925 defendant Imberley John husbandman 760239 760239 Imberley, John, of Ilmynstre, husbandman 1
4767872 2285925 2285925 defendant Bocher Stephen butcher 760239 760239 Bocher, Stephen, of Ilmynstre, butcher 3
4788878 2292573 2292573 defendant Dillyng Maud widow 760239 760239 Dillyng, Maud, of Ilmynstre, widow 2
4792274 2293670 2293670 defendant Bocher Stephen butcher 760239 760239 Bocher, Stephen, of Ilmynstre, butcher 2
4868287 2317058 2317058 defendant Stathe John husbandman 760239 760239 Stathe, John, of Ilmynstre, husbandman 0
4868288 2317058 2317058 defendant Baker William husbandman 760239 760239 Baker, William, of Ilmynstre, husbandman 1
4868290 2317058 2317058 defendant Lythenard John barber 760239 760239 Lythenard, John, of Ilmynstre, barber 3
4868291 2317058 2317058 defendant Bowyer Richard bowyer 760239 760239 together with Bowyer, Richard, of Ilmynstre, bowyer 4
4902885 2327517 2327517 defendant Marke William glover 760239 760239 Marke, William, of Ilmynstre, glover 0
4909147 2329404 2329404 defendant Badecok John tailor 760239 760239 Badecok, John, of Ilmynstre, tailor 0
4936114 2337694 2337694 defendant Scoce Roger crocker or potter 760239 760239 Scoce, Roger, of Ilmynstre, crocker or potter 0
4982908 2351799 2351799 defendant Stoke John husbandman 760239 760239 Stoke, John, of Ilmynstre, husbandman 0
5029347 2365458 2365458 defendant Anneleygh or Onnelegh Thomas schoolmaster 760239 760239 Anneleygh or Onnelegh, Thomas, of Ilmynstre, schoolmaster 0
5068262 2377012 2377012 defendant Baker Thomas laborer 760239 760239 Baker, Thomas, of Ilmynstre, laborer 1
5626351 2552206 2552206 defendant Marke John glover 760239 760239 Marke, John, of Ilmynstre, glover 0
5631098 2553733 2553733 defendant Burdon Thomas carpenter 760239 760239 Burdon, Thomas, of Ilmynstre, carpenter 0
5636943 2555497 2555497 defendant Iryssh Edward yeoman 760239 760239 Iryssh, Edward, of Ilmynstre, yeoman 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);