names

48 rows where place_id = 606326

✎ 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
3664807 1914939 1914939 plaintiff Sewell Walter yeoman 606326 606326 Sewell, Walter, of Strowde, yeoman 1
3664808 1914939 1914939 plaintiff Churchey John yeoman 606326 606326 Churchey, John, of Strowde, yeoman 2
3664809 1914939 1914939 plaintiff Tomson Thomas yeoman 606326 606326 Tomson, Thomas, of Strowde, yeoman 3
3710324 1929546 1929546 plaintiff Sewell Thomas yeoman 606326 606326 Sewell, Thomas, of Strowde, yeoman 0
3710325 1929546 1929546 plaintiff Shewell Walter yeoman 606326 606326 Shewell, Walter, of Strowde, yeoman 1
3710326 1929546 1929546 plaintiff Churcheis John yeoman 606326 606326 Churcheis, John, of Strowde, yeoman 2
3719513 1932367 1932367 defendant Esyngwald Elizabeth widow 606326 606326 Esyngwald, Elizabeth, of Strowde, widow 3
3727153 1934764 1934764 defendant Foorde Thomas weaver 606326 606326 Foorde, Thomas, of Strowde, weaver 1
3727160 1934765 1934765 defendant Whyte John yeoman 606326 606326 Whyte, John, of Strowde, yeoman 4
3740947 1939030 1939030 plaintiff Shewell Thomas yeoman 606326 606326 Shewell, Thomas, of Strowde, yeoman 0
3740948 1939030 1939030 plaintiff Shewell Walter yeoman 606326 606326 Shewell, Walter, of Strowde, yeoman 1
3740949 1939030 1939030 plaintiff Churchey John yeoman 606326 606326 Churchey, John, of Strowde, yeoman 2
3753209 1942945 1942945 defendant Myll John weaver 606326 606326 Myll, John, of Strowde, weaver 1
3839956 1970427 1970427 defendant Atterbery John yeoman 606326 606326 Atterbery, John, of Strowde, yeoman 1
3839957 1970427 1970427 defendant Warwike Matthew carpenter 606326 606326 Warwike, Matthew, of Strowde, carpenter 2
3856748 1975736 1975736 defendant Atterbery John yeoman 606326 606326 Atterbery, John, of Strowde, yeoman 1
3856749 1975736 1975736 defendant Warwyck Mathew carpenter 606326 606326 Warwyck, Mathew, of Strowde, carpenter 2
3874017 1981532 1981532 defendant Cullun Alice widow 606326 606326 Cullun, Alice, of Strowde, widow 0
3897324 1989323 1989323 defendant Cullam Alice widow 606326 606326 Cullam, Alice, of Strowde, widow 2
3971061 2014430 2014430 defendant Strynger John yeoman 606326 606326 Strynger, John, of Strowde, yeoman 0
3971062 2014430 2014430 defendant Cokers Richard yeoman 606326 606326 Cokers, Richard, of Strowde, yeoman 1
3971459 2014577 2014577 plaintiff Ellys John   606326 606326 Ellys, John, of Strowde 0
3971460 2014577 2014577 defendant Sylke alias Baker John weaver 606326 606326 Sylke alias Baker, John, of Strowde, weaver 0
4056697 2044783 2044783 defendant Hollyday John clothier 606326 606326 Hollyday, John, of Strowde, clothier 0
4076358 2051843 2051843 defendant Ashemead alias Hunt William yeoman 606326 606326 Ashemead alias Hunt, William, of Strowde, yeoman 0
4135195 2072907 2072907 defendant Dudbridge Richard tucker 606326 606326 Dudbridge, Richard, of Strowde, tucker 0
4135199 2072909 2072909 defendant Shewall William clothier 606326 606326 Shewall, William, of Strowde, clothier 0
4154538 2079680 2079680 defendant Taylowe Robert yeoman 606326 606326 (Taylowe, Robert, of Strowde, yeoman 2
4170661 2085238 2085238 defendant Arrundell William clothier 606326 606326 Arrundell, William, of Strowde, clothier 1
4187966 2091291 2091291 defendant Sworde John yeoman 606326 606326 Sworde, John, of Strowde Water, yeoman 0
4206290 2097748 2097748 defendant Cogar Richard yeoman 606326 606326 Cogar, Richard, of Strowde, yeoman 1
4238525 2109087 2109087 defendant Cogeere Richard gent 606326 606326 Cogeere, Richard, of Strowde, gent 1
4242480 2110483 2110483 defendant Poole Richard mercer 606326 606326 Poole, Richard, of Strowde, mercer 0
4246980 2111965 2111965 defendant Cogeere Richard gent 606326 606326 Cogeere, Richard, of Strowde, gent 1
4300708 2130350 2130350 defendant Arundell Richard clothman 606326 606326 Arundell, Richard, of Strowde, clothman 1
4300710 2130351 2130351 defendant Dorney William clothier 606326 606326 Dorney, William, of Strowde, clothier 0
4308179 2133009 2133009 defendant Arrundell Richard yeoman 606326 606326 Arrundell, Richard, of Strowde, yeoman 0
4311667 2134223 2134223 defendant Taylowe Robert clothier 606326 606326 Taylowe, Robert, of Strowde, clothier 1
4322964 2138095 2138095 defendant Deacon Thomas glover 606326 606326 Deacon, Thomas, of Strowde, glover 0
4358260 2150124 2150124 defendant Dorney William innholder 606326 606326 Dorney, William, of Strowde, yeoman, innholder 0
4361739 2151356 2151356 defendant Arundell Richard yeoman 606326 606326 Arundell, Richard, of Strowde, yeoman 0
4363498 2152019 2152019 defendant Fyssher John gunner 606326 606326 Fyssher, John, of Strowde, gunner 1
4370170 2154391 2154391 defendant Strodlinge Charles clothier 606326 606326 Strodlinge, Charles, of Strowde, clothier 0
4370171 2154391 2154391 defendant Webbe Thomas tucker 606326 606326 Webbe, Thomas, of of Strowde, yeoman, tucker 1
4374733 2156018 2156018 defendant Poole Richard mercer 606326 606326 Poole, Richard, of Strowde, mercer 0
4385267 2159764 2159764 defendant Munn William   606326 606326 (Munn, William, of Strowde juxta Rochester, sailor 1
4409590 2167805 2167805 defendant Dobbes Richard blacksmith 606326 606326 Dobbes, Richard, of Strowde, blacksmith 1
5559833 2522836 2522836 defendant Atterberye John yeoman 606326 606326 Atterberye, John, of Strowde, yeoman 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);