names

52 rows where place_id = 594106

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614607 1872218 1872218 defendant Bryggys Robert sherman or chapman 594106 594106 Bryggys, Robert, of Kyrkeby in Kendale, sherman or chapman 0
3614608 1872218 1872218 defendant Colyn Richard baker 594106 594106 Colyn, Richard, of Kyrkeby in Kendale, baker 1
3614609 1872218 1872218 defendant Garnet Henry dyer 594106 594106 Garnet, Henry, of Kyrkeby in Kendale, dyer 2
3614611 1872219 1872219 defendant Bryggys Robert sherman or chapman 594106 594106 Bryggys, Robert, of Kyrkeby in Kendale, sherman or chapman 0
3614612 1872219 1872219 defendant Colyn Richard barker 594106 594106 Colyn, Richard, of Kyrkeby in Kendale, barker 1
3614613 1872219 1872219 defendant Barnet Henry dyer 594106 594106 Barnet, Henry, of Kyrkeby in Kendale, dyer 2
3623303 1874815 1874815 defendant Jopson Peter chapman 594106 594106 Jopson, Peter, of Kyrkeby in Kendale, chapman 0
3623304 1874815 1874815 defendant Cause Robert yeoman 594106 594106 Cause, Robert, of Kyrkeby in Kendale, yeoman 1
3669161 1916292 1916292 plaintiff Bawdwenson William (legal representative) 594106 594106 Bawdwenson, William, of Kyrkeby in Kendale, chapman, executors of 0
3669165 1916293 1916293 plaintiff Bawdwenson William (legal representative) 594106 594106 Bawdwenson, William, of Kyrkeby in Kendale, chapman, executors of 0
4432039 2174800 2174800 defendant Ward John   594106 594106 Ward, John, of Kyrkeby in Kendale 1
4457236 2187272 2187272 plaintiff Patton Roger de   594106 594106 Patton, Roger de, of Kyrkeby in Kendale 0
4717415 2270785 2270785 defendant Burgh Robert gent 594106 594106 Burgh, Robert, of Kyrkeby in Kendale, gent 0
4798432 2295694 2295694 defendant Wylkynson John chapman 594106 594106 Wylkynson, John, of Kyrkeby in Kendale, chapman 3
4798438 2295695 2295695 defendant Wylkynson John chapman 594106 594106 Wylkynson, John, of Kyrkeby in Kendale, chapman 3
4808351 2298789 2298789 defendant Wilkylson John yeoman 594106 594106 Wilkylson, John, of Kyrkeby in Kendale, yeoman 1
4808352 2298789 2298789 defendant Brady William yeoman 594106 594106 Brady, William, of Kyrkeby in Kendale, yeoman 2
4886707 2322702 2322702 defendant Beverley William shoemaker 594106 594106 Beverley, William, of Kyrkeby in Kendale, shoemaker 0
4886709 2322702 2322702 defendant Masker William chapman 594106 594106 Masker, William, of Kyrkeby in Kendale, chapman 2
4886710 2322702 2322702 defendant Neleson John shoemaker 594106 594106 Neleson, John, of Kyrkeby in Kendale, shoemaker 3
4888334 2323155 2323155 plaintiff Lorde Robert   594106 594106 Lorde, Robert, of Kyrkeby in Kendale 0
4915457 2331335 2331335 defendant Wryght Henry dyer 594106 594106 Wryght, Henry, of Kyrkeby in Kendale, dyer 0
4915458 2331335 2331335 defendant Wyllyamson John yeoman 594106 594106 Wyllyamson, John, of Kyrkeby in Kendale, yeoman 1
4915459 2331335 2331335 defendant Sclater Thomas chapman 594106 594106 Sclater, Thomas, of Kyrkeby in Kendale, chapman 2
4915460 2331335 2331335 defendant Wylson Richard chapman 594106 594106 Wylson, Richard, of Kyrkeby in Kendale, chapman 3
4925081 2334276 2334276 defendant Colynson Robert yeoman 594106 594106 Colynson, Robert, of Kyrkeby in Kendale, yeoman 0
4962968 2345842 2345842 defendant Wryght Henry dyer 594106 594106 Wryght, Henry, of Kyrkeby in Kendale, dyer 0
4966819 2346999 2346999 defendant Garnet Robert yeoman 594106 594106 Garnet, Robert, of Kyrkeby in Kendale, yeoman 0
4966820 2346999 2346999 defendant Hogeson John chapman 594106 594106 Hogeson, John, of Kyrkeby in Kendale, chapman 1
4966821 2346999 2346999 defendant Preston William gent 594106 594106 Preston, William, of Kyrkeby in Kendale, gent 2
4970997 2348266 2348266 defendant Strykeland William chapman 594106 594106 Strykeland, William, of Kyrkeby in Kendale, chapman 0
4970998 2348266 2348266 defendant Dokwra Roger mercer 594106 594106 Dokwra, Roger, of Kyrkeby in Kendale, mercer 1
4972782 2348796 2348796 defendant Bredee William merchant 594106 594106 Bredee, William, of Kyrkeby in Kendale, merchant 0
4972783 2348796 2348796 defendant Preston John yeoman 594106 594106 Preston, John, of Kyrkeby in Kendale, yeoman 1
4972784 2348797 2348797 plaintiff Lamplogh Adam chapman 594106 594106 Lamplogh, Adam, of Kyrkeby in Kendale, chapman 0
4972806 2348803 2348803 defendant Rygg Robert chapman 594106 594106 Rygg, Robert, of Kyrkeby in Kendale, chapman 0
4972813 2348806 2348806 defendant Garnet William yeoman 594106 594106 Garnet, William, of Kyrkeby in Kendale, yeoman 0
4975518 2349644 2349644 defendant Par Thomas   594106 594106 Par, Thomas, of Kyrkeby in Kendale, knight 0
4981047 2351263 2351263 defendant Lamplowe Adam chapman 594106 594106 Lamplowe, Adam, of Kyrkeby in Kendale, chapman 0
4981048 2351263 2351263 defendant Pullowe Adam yeoman 594106 594106 Pullowe, Adam, of Kyrkeby in Kendale, yeoman 1
4981049 2351263 2351263 defendant Richerdson John yeoman 594106 594106 Richerdson, John, of Kyrkeby in Kendale, yeoman 2
5019090 2362476 2362476 defendant Kycchyn Thomas yeoman 594106 594106 Kycchyn, Thomas, of Kyrkeby in Kendale, yeoman 0
5036184 2367438 2367438 defendant Dakwra Roger gent 594106 594106 Dakwra, Roger, of Kyrkeby in Kendale, gent 0
5337801 2456384 2456384 defendant Tollanson Isabel widow 594106 594106 Tollanson, Isabel, of Kyrkeby in Kendale, widow 0
5337802 2456384 2456384 defendant Tollanson Robert yeoman 594106 594106 Tollanson, Robert, of Kyrkeby in Kendale, yeoman 1
5493227 2502883 2502883 defendant Gorney Robert yeoman 594106 594106 Gorney, Robert, of Kyrkeby in Kendale, yeoman 0
5493228 2502883 2502883 defendant Bryghede Robert yeoman 594106 594106 Bryghede, Robert, of Kyrkeby in Kendale, yeoman 1
5493231 2502884 2502884 defendant Ormsyde Richard shoemaker 594106 594106 Ormsyde, Richard, of Kyrkeby in Kendale, shoemaker 1
5493335 2502920 2502920 defendant Fell John yeoman 594106 594106 Fell, John, of Kyrkeby in Kendale, yeoman 0
5535999 2515762 2515762 defendant Bryggys Robert sherman 594106 594106 Bryggys, Robert, of Kyrkeby in Kendale, sherman 0
5536000 2515762 2515762 defendant Garnette Henry dyer 594106 594106 Garnette, Henry, of Kyrkeby in Kendale, dyer 1
5560205 2522946 2522946 plaintiff Slatter John   594106 594106 Slatter, John, of Kyrkeby in Kendale 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);