names

58 rows where place_id = 588150

✎ 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
3593520 1865606 1865606 defendant Bryggys William yeoman 588150 588150 Bryggys, William, of Halyfax, yorks, yeoman 2
3633761 1905371 1905371 defendant Lacy Richard gent 588150 588150 Lacy, Richard, of Halyfax, Yorks, gent 0
3635419 1905874 1905874 defendant Lyster John clothman 588150 588150 Lyster, John, of Halyfax, Yorks, clothman 0
3656230 1912197 1912197 defendant Ottys Gilbert clothier 588150 588150 Ottys, Gilbert, of Halyfax, Yorks, clothier 2
3656235 1912198 1912198 defendant Ottys Gilbert clothier 588150 588150 Ottys, Gilbert, of Halyfax, Yorks, clothier 2
3656240 1912199 1912199 defendant Ottys Gilbert clothier 588150 588150 Ottys, Gilbert, of Halyfax, Yorks, clothier 2
3663541 1914522 1914522 defendant Bremley William dyer 588150 588150 Bremley, William, of Halyfax, Yorks, dyer 0
3679400 1919621 1919621 defendant Borneley Wlliam dyer 588150 588150 Borneley, Wlliam, of Halyfax, Yorks, dyer 0
3684682 1921341 1921341 defendant Hanson Robert   588150 588150 Hanson, Robert, of Halyfax, Yorks, wool driver 2
3688749 1922642 1922642 defendant Hanson Robert   588150 588150 Hanson, Robert, of Halyfax, Yorks, wool driver 0
3705060 1927873 1927873 defendant Waller Nicholas dyer 588150 588150 Waller, Nicholas, of Halyfax, Yorks, dyer 0
3705546 1928017 1928017 defendant Crowdor John yeoman 588150 588150 Crowdor, John, of Halyfax, Yorks, yeoman 0
3738458 1938232 1938232 defendant Crabtre William clothman 588150 588150 Crabtre, William, of Halyfax, Yorks, clothman 1
3747181 1941037 1941037 defendant Hanson Richard woolman 588150 588150 Hanson, Richard, of Halyfax, Yorks, woolman 0
3769237 1948033 1948033 defendant Batys Thomas yeoman 588150 588150 Batys, Thomas, of Halyfax, Yorks, yeoman 1
3769240 1948034 1948034 defendant Batys Thomas yeoman 588150 588150 Batys, Thomas, of Halyfax, Yorks, yeoman 1
3785127 1953136 1953136 defendant Ellastonys alias Adellastonys Richard clothman 588150 588150 Ellastonys alias Adellastonys, Richard, of Halyfax, Yorks, clothman 0
3798546 1957450 1957450 plaintiff Herdy John clothier 588150 588150 Herdy, John, of Halyfax, Yorks, clothier 0
3798549 1957451 1957451 plaintiff Herdy John clothier 588150 588150 Herdy, John, of Halyfax, Yorks, clothier 0
3801103 1958264 1958264 defendant Hanson Richard yeoman 588150 588150 Hanson, Richard, of Halyfax, Yorks, yeoman 0
3801104 1958264 1958264 defendant Hanson Robert yeoman 588150 588150 Hanson, Robert, of Halyfax, Yorks, yeoman 1
3808094 1960423 1960423 defendant Banaster John yeoman 588150 588150 Banaster, John, of Halyfax, Yorks, yeoman 1
3814155 1962331 1962331 defendant Whyttwham Nicholas mercer 588150 588150 Whyttwham, Nicholas, of Halyfax, Yorks, mercer 2
3814841 1962556 1962556 defendant Waterhouse Robert yeoman 588150 588150 Waterhouse, Robert, of Halyfax, Yorks, yeoman 0
3826598 1966168 1966168 defendant Prestley Robert yeoman 588150 588150 Prestley, Robert, of Halyfax, Yorks, yeoman 0
3838303 1969895 1969895 defendant Waterhouse John, junior clothier 588150 588150 Waterhouse, John, junior, of Halyfax, Yorks, clothier 0
3850940 1973886 1973886 defendant Banaster John clothier 588150 588150 Banaster, John, of Halyfax, Yorks, clothier 0
3874979 1981854 1981854 defendant Ferrer Robert chapman 588150 588150 Ferrer, Robert, of Halyfax, Yorks, chapman 2
3882496 1984409 1984409 defendant Mawde William yeoman 588150 588150 Mawde, William, of Halyfax, Yorks, yeoman 2
3894141 1988257 1988257 defendant Kyng William dyer 588150 588150 Kyng, William, of Halyfax, Yorks, dyer 0
3898718 1989776 1989776 defendant Haldersworth Gilbert clothier 588150 588150 Haldersworth, Gilbert, of Halyfax, Yorks, clothier 4
3915791 1995660 1995660 defendant Dyconson John clothier 588150 588150 Dyconson, John, of Halyfax, Yorks, clothier 0
3928672 1999929 1999929 defendant Beamount John clothier 588150 588150 Beamount, John, of Halyfax, Yorks, clothier 0
3930900 2000673 2000673 defendant Sayvyll William   588150 588150 Sayvyll, William, of Halyfax, Yorks 0
3931570 2000856 2000856 defendant Briggis Richard clothier & son of Thomas 588150 588150 Briggis, Richard, of Halyfax, Yorks, clothier & son of Thomas 0
3939019 2003382 2003382 defendant Rybaill William clothier 588150 588150 Rybaill, William, of Halyfax, Yorks, clothier 0
3940889 2003958 2003958 defendant Savill William mercer 588150 588150 Savill, William, of Halyfax, Yorks, mercer 0
3962789 2011574 2011574 plaintiff Wilkenson Edward clothier 588150 588150 Wilkenson, Edward, of Halyfax, Yorks, clothier 0
3974036 2015490 2015490 defendant Baraclowghe Edward chapman 588150 588150 Baraclowghe, Edward, of Halyfax, Yorks, chapman 0
3974039 2015491 2015491 defendant Burton Christopher chapman 588150 588150 Burton, Christopher, of Halyfax, Yorks, chapman 0
4370511 2154503 2154503 defendant Lyster Samuel mercer 588150 588150 Lyster, Samuel, of Halyfax, Yorks, mercer 0
4873998 2318805 2318805 defendant Sonderland Thurstan yeoman 588150 588150 Sonderland, Thurstan, of Halyfax, Yorks, yeoman 1
4895586 2325289 2325289 plaintiff Shagh Richard draper 588150 588150 Shagh, Richard, of Halyfax, Yorks, draper 0
4898950 2326315 2326315 plaintiff atte Shagh Thomas draper 588150 588150 atte Shagh, Thomas, of Halyfax, Yorks, draper 0
4917255 2331903 2331903 plaintiff Furneys Ralph draper 588150 588150 Furneys, Ralph, of Halyfax, Yorks, draper 0
4961057 2345269 2345269 defendant Potter William   588150 588150 Potter, William, of Halyfax, Yorks, servant 0
5254177 2431427 2431427 defendant Otes Isabel widow 588150 588150 Otes, Isabel, of Halyfax, Yorks, widow 1
5285599 2440811 2440811 plaintiff Haleworth John chapman 588150 588150 Haleworth, John, of Halyfax, Yorks, chapman 0
5374179 2467522 2467522 defendant Bacheler Henry dyer 588150 588150 Bacheler, Henry, of Halyfax, Yorks, dyer 0
5374182 2467523 2467523 defendant Bacheler Henry dyer 588150 588150 Bacheler, Henry, of Halyfax, Yorks, dyer 0
5382194 2469964 2469964 defendant Bacheler Henry yeoman 588150 588150 Bacheler, Henry, of Halyfax, Yorks, yeoman 0
5390861 2472451 2472451 defendant Bacheler Henry yeoman 588150 588150 Bacheler, Henry, of Halyfax, Yorks, yeoman 0
5390864 2472452 2472452 defendant Bacheler Henry yeoman 588150 588150 Bacheler, Henry, of Halyfax, Yorks, yeoman 0
5499078 2504663 2504663 defendant Gybson John yeoman 588150 588150 Gybson, John, of Halyfax, Yorks, yeoman 2
5552266 2520708 2520708 defendant Gybson James clothier 588150 588150 Gybson, James, of Halyfax, Yorks, clothier 0
5569020 2525490 2525490 defendant Craven William clothier 588150 588150 Craven, William, of Halyfax, Yorks, clothier 0
5586481 2530811 2530811 defendant Hanson Richard clothmaker 588150 588150 Hanson, Richard, of Halyfax,Yorks, clothmaker 0
5602662 2535711 2535711 defendant Otes Robert mercer 588150 588150 Otes, Robert, of Halyfax, Yorks, mercer 17

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