names

75 rows where place_id = 607927

✎ 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
3671505 1917070 1917070 defendant Harman John yeoman 607927 607927 Harman, John, of Westleton, yeoman 1
3682334 1920575 1920575 defendant Cotyngham John husbandman 607927 607927 Cotyngham, John, of Westleton, husbandman 0
3682335 1920575 1920575 defendant Cotyngham John yeoman 607927 607927 Cotyngham, John, of Westleton, yeoman 1
3841068 1970781 1970781 defendant Flemyng Robert husbandman 607927 607927 Flemyng, Robert, of Westleton, husbandman 0
3901274 1990651 1990651 defendant Brend John husbandman 607927 607927 Brend, John, of Westleton, husbandman 0
3951586 2007611 2007611 plaintiff Haddenham William   607927 607927 Haddenham, William, of Westleton 0
3951833 2007703 2007703 defendant Cooke Anthony carpenter 607927 607927 Cooke, Anthony, of Westleton, carpenter 0
3958241 2009955 2009955 defendant Coke Anthony carpenter 607927 607927 Coke, Anthony, of Westleton, carpenter 1
3974834 2015763 2015763 defendant Crispe John   607927 607927 Crispe, John, of Westleton, wheelwright 0
3982884 2018655 2018655 defendant Hamond John husbandman 607927 607927 Hamond, John, of Westleton, husbandman 0
3985418 2019544 2019544 defendant Grene Francis husbandman 607927 607927 Grene, Francis, of Westleton, husbandman 3
3994421 2022759 2022759 defendant Ary Thomas husbandman 607927 607927 Ary, Thomas, of Westleton, husbandman 0
3996721 2023591 2023591 defendant Hamond John husbandman 607927 607927 Hamond, John, of Westleton, husbandman 0
3996724 2023591 2023591 defendant Cryspe Edmund husbandman 607927 607927 Cryspe, Edmund, of Westleton, husbandman 3
3998424 2024174 2024174 defendant Yong John husbandman 607927 607927 Yong, John, of Westleton, husbandman 0
3998425 2024174 2024174 defendant Harlyng Nicholas husbandman 607927 607927 Harlyng, Nicholas, of Westleton, husbandman 1
4001145 2025187 2025187 defendant Yong John husbandman 607927 607927 Yong, John, of Westleton, husbandman 0
4003351 2025959 2025959 defendant Berry William husbandman 607927 607927 Berry, William, of Westleton, husbandman 0
4003353 2025960 2025960 defendant Rushe Anthony husbandman 607927 607927 Rushe, Anthony, of Westleton, husbandman 0
4019332 2031648 2031648 defendant Vyncent Walter husbandman 607927 607927 Vyncent, Walter, of Westleton, husbandman 0
4022035 2032609 2032609 defendant Carber or Tarver or Carvell Peter husbandman 607927 607927 Carber or Tarver or Carvell, Peter, of Westleton, husbandman 0
4022037 2032610 2032610 defendant Carver alias Tarver alias Carvell Peter husbandman 607927 607927 Carver alias Tarver alias Carvell, Peter, of Westleton, husbandman 0
4025991 2033945 2033945 defendant Calber Richard husbandman 607927 607927 Calber, Richard, of Westleton, husbandman 0
4028693 2034914 2034914 plaintiff Covell John husbandman 607927 607927 Covell, John, of Westleton, husbandman 0
4028694 2034914 2034914 defendant Walker or Wallor James husbandman 607927 607927 Walker or Wallor, James, of Westleton, husbandman 0
4028695 2034914 2034914 defendant Sprunte Thomas husbandman 607927 607927 Sprunte, Thomas, of Westleton, husbandman 1
4028696 2034915 2034915 plaintiff Covell John husbandman 607927 607927 Covell, John, of Westleton, husbandman 0
4028697 2034915 2034915 defendant Waller James husbandman 607927 607927 Waller, James, of Westleton, husbandman 0
4028698 2034915 2034915 defendant Sprunte Thomas husbandman 607927 607927 Sprunte, Thomas, of Westleton, husbandman 1
4031429 2035909 2035909 defendant Yong John husbandman 607927 607927 Yong, John, of Westleton, husbandman 1
4044582 2040513 2040513 defendant Hamlyn Robert husbandman 607927 607927 Hamlyn, Robert, of Westleton, husbandman 0
4045414 2040812 2040812 defendant Cryspe Edmund cooper 607927 607927 Cryspe, Edmund, of Westleton, cooper 5
4045418 2040813 2040813 defendant Larkyn Everard miller 607927 607927 Larkyn, Everard, of Westleton, miller 2
4046179 2041074 2041074 plaintiff Sheryngton John   607927 607927 Sheryngton, John, of Westleton 0
4047661 2041610 2041610 defendant Cryspe Edmund cooper 607927 607927 Cryspe, Edmund, of Westleton, cooper 1
4062484 2046874 2046874 defendant Osborne Thomas husbandman 607927 607927 Osborne, Thomas, of Westleton, husbandman 0
4072339 2050408 2050408 defendant Rushe Robert   607927 607927 Rushe, Robert, of Westleton, mason 3
4074971 2051349 2051349 defendant Markant Robert husbandman 607927 607927 Markant, Robert, of Westleton, husbandman 0
4096181 2058962 2058962 defendant Markant Robert yeoman 607927 607927 Markant, Robert, of Westleton, yeoman 1
4113137 2064968 2064968 defendant Holdynge Thomas husbandman 607927 607927 Holdynge, Thomas, of Westleton, husbandman 1
4153423 2079294 2079294 defendant Wynsden Thomas gent 607927 607927 Wynsden, Thomas, of Westleton, gent 0
4173783 2086285 2086285 defendant Rydge Elizabeth widow 607927 607927 Rydge, Elizabeth, of Westleton, widow 3
4222306 2103292 2103292 defendant Hasburgh Robert yeoman 607927 607927 Hasburgh, Robert, of Westleton, yeoman 0
4240011 2109632 2109632 defendant Waynflete John yeoman 607927 607927 Waynflete, John, of Westleton, yeoman 0
4242303 2110421 2110421 defendant Bedingfeild Francis gent 607927 607927 Bedingfeild, Francis, of Westleton, gent 0
4248377 2112447 2112447 defendant Cupper William yeoman 607927 607927 Cupper, William, of Westleton, yeoman 0
4248379 2112447 2112447 defendant Scotford Robert husbandman 607927 607927 Scotford, Robert, of Westleton, husbandman 2
4322835 2138055 2138055 defendant Copper William yeoman 607927 607927 Copper, William, of Westleton, yeoman 0
4349991 2147256 2147256 defendant Harlinge Nicholas husbandman 607927 607927 Harlinge, Nicholas, of Westleton, husbandman 3
4391944 2161932 2161932 defendant Watson Alan beer brewer 607927 607927 Watson, Alan, of Westleton, beer brewer 0
4400917 2164898 2164898 defendant Fermley Robert yeoman 607927 607927 Fermley, Robert, of Westleton, yeoman 1
4406343 2166687 2166687 defendant Whynery Robert yeoman 607927 607927 Whynery, Robert, of Westleton, yeoman 2
4411884 2168568 2168568 defendant Baldrye Edmund husbandman 607927 607927 Baldrye, Edmund, of Westleton, husbandman 1
4411892 2168570 2168570 defendant Baldrye Edmund husbandman 607927 607927 Baldrye, Edmund, of Westleton, husbandman 1
4483734 2195605 2195605 plaintiff Osbern Roger   607927 607927 Osbern, Roger, of Westleton 0
4483753 2195610 2195610 plaintiff Osebern Roger   607927 607927 Osebern, Roger, of Westleton 0
4496124 2199466 2199466 defendant Gerelere John   607927 607927 Gerelere, John, of Westleton 3
4792712 2293807 2293807 defendant Peion Walter butcher 607927 607927 Peion, Walter, of Westleton, butcher 1
4804658 2297652 2297652 defendant Chesteyn William gent 607927 607927 Chesteyn, William, of Westleton, gent 3
4811873 2299825 2299825 defendant Wolsy John   607927 607927 Wolsy, John, of Westleton, bailiff & yeoman 3
4840370 2308532 2308532 defendant West John husbandman 607927 607927 West, John, of Westleton, husbandman 2
4849884 2311434 2311434 defendant Wolsy John   607927 607927 Wolsy, John, of Westleton, yeoman, formerly bailiff 1
4909798 2329587 2329587 defendant Chestan Roger   607927 607927 Chestan, Roger, of Westleton, administrators of, Suff, 0
4932077 2336425 2336425 defendant Croxton Nicholas   607927 607927 Croxton, Nicholas, of Westleton 4
4932078 2336425 2336425 defendant Croxton John   607927 607927 Croxton, John, of Westleton 5
4932079 2336425 2336425 defendant Cotyngham William   607927 607927 Cotyngham, William, of Westleton 6
5054165 2372837 2372837 defendant Byrd Robert husbandman 607927 607927 Byrd, Robert, of Westleton, husbandman 0
5106550 2388342 2388342 defendant Deynes John butcher 607927 607927 Deynes, John, of Westleton, butcher 3
5215059 2420127 2420127 defendant Skut John yeoman 607927 607927 Skut, John, of Westleton, yeoman 1
5559483 2522737 2522737 defendant Bower William butcher 607927 607927 Bower, William, of Westleton, butcher 0
5559484 2522737 2522737 defendant Gerrard Richard husbandman 607927 607927 Gerrard, Richard, of Westleton, husbandman 1
5559485 2522737 2522737 defendant Bower John tanner 607927 607927 Bower, John, of Westleton, tanner 2
5610593 2547040 2547040 plaintiff Barker Walter le   607927 607927 Barker, Walter le, of Westleton 0
5610594 2547040 2547040 defendant Smyth Edmund le   607927 607927 Smyth, Edmund le, of Westleton 0
5633039 2554335 2554335 defendant del Fenne Robert husbandman 607927 607927 del Fenne, Robert, of Westleton, husbandman 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);