names

41 rows where place_id = 632496

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3723642 1933669 1933669 defendant Horman William   632496 632496 Horman, William, of Wresyll, arras maker 0
3723643 1933669 1933669 defendant Parman Peter   632496 632496 Parman, Peter, of Wresyll, arras maker 1
3723644 1933669 1933669 defendant Mashowe Nicholas   632496 632496 Mashowe, Nicholas, of Wresyll, arras maker 2
3806998 1960087 1960087 defendant Worme William gent 632496 632496 Worme, William, of Wresyll, gent 2
4581483 2225669 2225669 defendant Walker Thomas   632496 632496 Walker, Thomas, of Wresyll 1
4581484 2225669 2225669 defendant Houton Thomas   632496 632496 Houton, Thomas, of Wresyll 2
4581485 2225669 2225669 defendant Barker John   632496 632496 Barker, John, of Wresyll 3
4581486 2225669 2225669 defendant Freman John   632496 632496 Freman, John, of Wresyll 4
4581487 2225669 2225669 defendant Gibbeson Robert   632496 632496 Gibbeson, Robert, of Wresyll 5
4581488 2225669 2225669 defendant Fyssher Robert   632496 632496 Fyssher, Robert, of Wresyll 6
4581489 2225669 2225669 defendant Ward Richard   632496 632496 Ward, Richard, of Wresyll 7
4581490 2225669 2225669 defendant Milner William   632496 632496 Milner, William, of Wresyll 8
4581491 2225669 2225669 defendant Warde John   632496 632496 Warde, John, of Wresyll 9
4581492 2225669 2225669 defendant Boythorp William   632496 632496 Boythorp, William, of Wresyll 10
4581493 2225669 2225669 defendant Marynell William   632496 632496 Marynell, William, of Wresyll 11
4581494 2225669 2225669 defendant Rayner Richard   632496 632496 Rayner, Richard, of Wresyll 12
4581496 2225670 2225670 defendant Sergeant John   632496 632496 Sergeant, John, of Wresyll 0
4581497 2225670 2225670 defendant Walker Thomas   632496 632496 Walker, Thomas, of Wresyll 1
4581498 2225670 2225670 defendant Houton Thomas   632496 632496 Houton, Thomas, of Wresyll 2
4581499 2225670 2225670 defendant Baker John   632496 632496 Baker, John, of Wresyll 3
4581500 2225670 2225670 defendant Freman John   632496 632496 Freman, John, of Wresyll 4
4581502 2225670 2225670 defendant Fyssher Robert   632496 632496 Fyssher, Robert, of Wresyll 6
4581503 2225670 2225670 defendant Ward Richard   632496 632496 Ward, Richard, of Wresyll 7
4581504 2225670 2225670 defendant Milner William   632496 632496 Milner, William, of Wresyll 8
4581505 2225670 2225670 defendant Barde John   632496 632496 Barde, John, of Wresyll 9
4581506 2225670 2225670 defendant Boythorp William   632496 632496 Boythorp, William, of Wresyll 10
4581507 2225670 2225670 defendant Marynell William   632496 632496 Marynell, William, of Wresyll 11
4581508 2225670 2225670 defendant Rayner Richard   632496 632496 Rayner, Richard, of Wresyll 12
5177837 2409221 2409221 defendant Whynfeld John gent 632496 632496 Whynfeld, John, of Wresyll, gent 0
5177838 2409221 2409221 defendant Thyrlwall Richard gent 632496 632496 Thyrlwall, Richard, of Wresyll, gent 1
5177839 2409221 2409221 defendant Wyghtman Nicholas yeoman 632496 632496 Wyghtman, Nicholas, of Wresyll, yeoman 2
5220169 2421602 2421602 defendant Scruby Richard laborer 632496 632496 Scruby, Richard, of Wresyll, laborer 14
5251331 2430517 2430517 defendant Wyghtman John yeoman 632496 632496 Wyghtman, John, of Wresyll, yeoman 0
5286895 2441168 2441168 defendant Bilbrough Joan widow 632496 632496 Bilbrough, Joan, of Wresyll, widow 0
5286896 2441168 2441168 defendant Bilbrough Robert, senior husbandman 632496 632496 Bilbrough, Robert, senior, of Wresyll, husbandman 1
5287626 2441409 2441409 defendant Banke Peter esq 632496 632496 Banke, Peter, of Wresyll, esq 0
5287627 2441409 2441409 defendant Scharpe Christopher esq 632496 632496 Scharpe, Christopher, of Wresyll, esq 1
5354969 2461625 2461625 defendant Cotes isabel widow 632496 632496 Cotes, isabel, of Wresyll, widow 2
5365046 2464738 2464738 defendant Langdale Henry gent 632496 632496 Langdale, Henry, of Wresyll, gent 0
5419315 2480700 2480700 defendant Wykys John gent 632496 632496 Wykys, John, of Wresyll, gent 0
5504702 2506389 2506389 defendant Warde Anthony gent 632496 632496 Warde, Anthony, of Wresyll, gent 2

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