names

24 rows where case_id = 2019160

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3984335 2019160 2019160 plaintiff Symcott William gent 627268 627268 Symcott, William, of Lowthe, gent 0
3984336 2019160 2019160 defendant Kyghley James tailor 667229 667229 Kyghley, James, of Swynstead, tailor 0
3984337 2019160 2019160 defendant Nicoll Richard yeoman 654910 654910 Nicoll, Richard, of Corbye, yeoman 1
3984338 2019160 2019160 defendant Todde William husbandman 654910 654910 Todde, William, of Corbye, husbandman 2
3984339 2019160 2019160 defendant Fokyngham John yeoman 644418 644418 Fokyngham, John, of Sleforth, yeoman 3
3984340 2019160 2019160 defendant Newton John yeoman 649409 649409 Newton, John, of New Sleforth, yeoman 4
3984341 2019160 2019160 defendant Aylief Robert yeoman 644418 644418 Aylief, Robert, of Sleforth, yeoman 5
3984342 2019160 2019160 defendant Dysney Lawrence yeoman 667230 667230 Dysney, Lawrence, of Waployte or Whaplide, yeoman 6
3984343 2019160 2019160 defendant Hobson William yeoman 667231 667231 Hobson, William, of Spaldynge, yeoman 7
3984344 2019160 2019160 defendant Ball Thomas yeoman 667232 667232 Ball, Thomas, of Sleforthe, yeoman 8
3984345 2019160 2019160 defendant Lytt Edward yeoman 644418 644418 Lytt, Edward, of Sleforth, yeoman 9
3984346 2019160 2019160 defendant Fowtehead Nicholas yeoman 667232 667232 Fowtehead, Nicholas, of Sleforthe, yeoman 10
3984347 2019160 2019160 defendant Thewe Thomas yeoman 661484 661484 Thewe, Thomas, of Salmonby, yeoman 11
3984348 2019160 2019160 defendant Assheton James yeoman 667233 667233 Assheton, James, of Aysby or Aylesby, yeoman 12
3984349 2019160 2019160 defendant Mulley or Morley John yeoman 588486 588486 Mulley or Morley, John, of Wynterton, yeoman 13
3984350 2019160 2019160 defendant Townesend Christopher yeoman 603087 603087 Townesend, Christopher, of Caster, yeoman 14
3984351 2019160 2019160 defendant Stawper George yeoman 667234 667234 Stawper, George, of Nettleton, yeoman 15
3984352 2019160 2019160 defendant Taylor Richard yeoman 632005 632005 Taylor, Richard, of Nettelton, yeoman 16
3984353 2019160 2019160 defendant Wharton Thomas yeoman 655707 655707 Wharton, Thomas, of Tallyngton, yeoman 17
3984354 2019160 2019160 defendant Mannynge William mercer 667235 667235 Mannynge, William, of Markett Depyng, mercer 18
3984355 2019160 2019160 defendant Buck John yeoman 619741 619741 Buck, John, of Depyng St James, yeoman 19
3984356 2019160 2019160 defendant Sympson Gilbert yeoman 598803 598803 Sympson, Gilbert, of Alford, yeoman 20
3984357 2019160 2019160 defendant Fox William yeoman 667236 667236 Fox, William, of Sutton in the Marshe, yeoman 21
3984358 2019160 2019160 defendant Skypwythe Thomas yeoman 628341 628341 Skypwythe, Thomas, of Hawneby, yeoman 22

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);