names

31 rows where case_id = 2142518

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4336541 2142518 2142518 plaintiff Bedingfeld William gent, attorney   Bedingfeld, William, gent, attorney 0
4336542 2142518 2142518 defendant Nicolls John yeoman 586928 586928 Nicolls, John, of Monk Soham, yeoman 0
4336543 2142518 2142518 defendant Bedingfeld John yeoman 586928 586928 Bedingfeld, John, of Monk Soham, yeoman 1
4336544 2142518 2142518 defendant Hubbard William yeoman 635297 635297 Hubbard, William, of Occolt, yeoman 2
4336545 2142518 2142518 defendant Reade John yeoman 635297 635297 Reade, John, of Occolt, yeoman 3
4336546 2142518 2142518 defendant Games or Gaines Robert yeoman 592304 592304 Games or Gaines, Robert, of Horham, yeoman 4
4336547 2142518 2142518 defendant Crycklinge Robert yeoman 636214 636214 Crycklinge, Robert, of Southolt, yeoman 5
4336548 2142518 2142518 defendant Butteram Nicholas cooper 636214 636214 Butteram, Nicholas, of Southolt, cooper 6
4336549 2142518 2142518 defendant Smythe John joiner 586928 586928 Smythe, John, of Monk Soham, joiner 7
4336550 2142518 2142518 defendant Peartree John yeoman 739616 739616 Peartree, John, of Franesden, yeoman 8
4336551 2142518 2142518 defendant Peartree William yeoman 717513 717513 Peartree, William, of Athelington, yeoman 9
4336552 2142518 2142518 defendant Dowsinge John   714766 714766 Dowsinge, John, of Wilbie yeoman 10
4336553 2142518 2142518 defendant Grater Robert husbandman 635297 635297 Grater, Robert, of Occolt, husbandman 11
4336554 2142518 2142518 defendant Dennye James butcher 729223 729223 Dennye, James, of Warlingworthe, butcher 12
4336555 2142518 2142518 defendant Foster Thomas laborer 710426 710426 Foster, Thomas, of Stradbrooke, laborer 13
4336556 2142518 2142518 defendant Godferie Edward yeoman 739618 739618 Godferie, Edward, of Wrabnesse, Essex, yeoman 14
4336557 2142518 2142518 defendant Sadler John yeoman 739619 739619 Sadler, John, of Muche Ockley, Essex, yeoman 15
4336558 2142518 2142518 defendant Harris John yeoman 739620 739620 Harris, John, of Muche Ockley, yeoman 16
4336559 2142518 2142518 defendant Jaye John yeoman 636214 636214 Jaye, John, of Southolt, yeoman 17
4336560 2142518 2142518 defendant Chapman Robert wawyer 636214 636214 Chapman, Robert, of Southolt, wawyer 18
4336561 2142518 2142518 defendant Hayward Thomas husbandman 654586 654586 Hayward, Thomas, of Warlingworth, husbandman 19
4336562 2142518 2142518 defendant Rous Thomas, junior gent 729324 729324 Rous, Thomas, junior, of Alington, gent 20
4336563 2142518 2142518 defendant Kewe John tanner 729223 729223 Kewe, John, of Warlingworthe, tanner 21
4336564 2142518 2142518 defendant Murdocke Robert joiner 695293 695293 Murdocke, Robert, of Ashefeld, joiner 22
4336565 2142518 2142518 defendant London Richard yeoman 587550 587550 London, Richard, of Eye, yeoman 23
4336566 2142518 2142518 defendant Rushe Thomas, senior yeoman 587550 587550 Rushe, Thomas, senior, of Eye, yeoman 24
4336567 2142518 2142518 defendant Bell Nicholas gent 601078 601078 Bell, Nicholas, of Framesden, gent 25
4336568 2142518 2142518 defendant Adams Robert   654586 654586 Adams, Robert, of Warlingworth, ploughwright 26
4336569 2142518 2142518 defendant Bonde Thomas yeoman 636214 636214 Bonde, Thomas, of Southolt, yeoman 27
4336570 2142518 2142518 defendant Palmer Robert clerk 627199 627199 Palmer, Robert, of Occolte, clerk 28
4336571 2142518 2142518 defendant Hatche John weaver 739622 739622 Hatche, John, of Southolte, weaver 29

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