names

26 rows where place_id = 636214

✎ 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
3829622 1967156 1967156 plaintiff Day Robert yeoman 636214 636214 Day, Robert, of Southolt, yeoman 0
3829623 1967156 1967156 defendant Cocke John yeoman 636214 636214 Cocke, John, of Southolt, yeoman 0
4318655 2136634 2136634 defendant Crucklyn Robert yeoman 636214 636214 Crucklyn, Robert, of Southolt, yeoman 0
4331364 2140788 2140788 defendant Crucklyn or Crucklynge Robert yeoman 636214 636214 Crucklyn or Crucklynge, Robert, of Southolt, yeoman 0
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
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
4336569 2142518 2142518 defendant Bonde Thomas yeoman 636214 636214 Bonde, Thomas, of Southolt, yeoman 27
4786149 2291706 2291706 defendant Pope John, senior butcher 636214 636214 Pope, John, senior, of Southolt, butcher 0
4786150 2291706 2291706 defendant Pope Roger butcher 636214 636214 Pope, Roger, of Southolt, butcher 1
4786151 2291706 2291706 defendant Pope John, junior butcher 636214 636214 Pope, John, junior, of Southolt, butcher 2
5139479 2398032 2398032 defendant Douneham alias Aredern John husbandman 636214 636214 Douneham alias Aredern, John, of Southolt, husbandman 0
5219960 2421548 2421548 defendant Houlot Katherine widow 636214 636214 Houlot, Katherine, of Southolt, widow 6
5260969 2433550 2433550 defendant Bonevalet Thomas yeoman 636214 636214 Bonevalet, Thomas, of Southolt, yeoman 2
5303290 2445981 2445981 defendant Feld Robert husbandman 636214 636214 Feld, Robert, of Southolt, husbandman 1
5324463 2452402 2452402 defendant Boonvalett Thomas yeoman 636214 636214 Boonvalett, Thomas, of Southolt, yeoman 0
5352239 2460799 2460799 defendant Bonvalet Thomas yeoman 636214 636214 Bonvalet, Thomas, of Southolt, yeoman 2
5447449 2489124 2489124 defendant Elyot Robert husbandman 636214 636214 Elyot, Robert, of Southolt, husbandman 2
5459914 2492894 2492894 defendant Elyot Robert husbandman 636214 636214 Elyot, Robert, of Southolt, husbandman 2
5471580 2496447 2496447 defendant Elyot Robert husbandman 636214 636214 Elyot, Robert, of Southolt, husbandman 2
5487859 2501257 2501257 defendant Turpyn Andrew husbandman 636214 636214 Turpyn, Andrew, of Southolt, husbandman 0
5487860 2501257 2501257 defendant Dounham Robert laborer 636214 636214 Dounham, Robert, of Southolt, laborer 1
5487861 2501257 2501257 defendant Dounham John laborer 636214 636214 Dounham, John, of Southolt, laborer 2
5500283 2505034 2505034 defendant Bonnalet Thomas yeoman 636214 636214 Bonnalet, Thomas, of Southolt, yeoman 0
5633982 2554610 2554610 plaintiff Tounelonde Henry   636214 636214 Tounelonde, Henry, of Southolt 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);