names

41 rows where place_id = 599080

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635128 1905787 1905787 defendant Trodis Alexander clerk 599080 599080 Trodis, Alexander, of West Walton, Norf, clerk 0
3643840 1908501 1908501 defendant Trodys Alexander clerk 599080 599080 Trodys, Alexander, of West Walton, Norf, clerk 0
3871379 1980677 1980677 defendant Wamvesley John yeoman 599080 599080 Wamvesley, John, of West Walton, Norf, yeoman 1
3920419 1997172 1997172 defendant Delff alias Broke Ellen widow 599080 599080 Delff alias Broke, Ellen, of West Walton, Norf, widow 1
3930317 2000486 2000486 defendant Candishe Edward gent 599080 599080 Candishe, Edward, of West Walton, Norf, gent 0
3947755 2006279 2006279 defendant Whelpedale William yeoman 599080 599080 Whelpedale, William, of West Walton, Norf, yeoman 0
4040248 2039016 2039016 defendant Reppes Henry (legal representative) 599080 599080 Reppes, Henry, of West Walton, Norf, esq, executors of 0
4061702 2046584 2046584 defendant Harvy Thomas yeoman 599080 599080 Harvy, Thomas, of West Walton, Norf, yeoman 0
4078020 2052440 2052440 defendant Weston Henry   599080 599080 (Weston, Henry, of West Walton, Norf, knight 1
4181545 2089025 2089025 defendant Stoote William yeoman 599080 599080 Stoote, William, of West Walton, Norf, yeoman 0
4197207 2094573 2094573 defendant Stoute William yeoman 599080 599080 Stoute, William, of West Walton, Norf, yeoman 0
4240363 2109753 2109753 defendant Clackson Christopher yeoman 599080 599080 Clackson, Christopher, of West Walton, Norf, yeoman 1
4275836 2121497 2121497 defendant Allyson Thomas husbandman 599080 599080 Allyson, Thomas, of West Walton, Norf, husbandman 3
4305602 2132093 2132093 defendant Allison Thomas yeoman 599080 599080 Allison, Thomas, of West Walton, Norf, yeoman 0
4318324 2136516 2136516 defendant Lane John gent 599080 599080 Lane, John, of West Walton, Norf, gent 0
4326268 2139152 2139152 defendant Willyngton Henry yeoman 599080 599080 Willyngton, Henry, of West Walton, Norf, yeoman 1
4338417 2143186 2143186 defendant Lane John gent 599080 599080 Lane, John, of West Walton, Norf, gent 0
4675333 2257896 2257896 defendant Pokedyceh John (legal representative) 599080 599080 Pokedyceh, John, of West Walton, Norf, executrix of 3
4763404 2284542 2284542 defendant Belle Robert butcher 599080 599080 Belle, Robert, of West Walton, Norf, butcher 2
4765554 2285217 2285217 defendant Howysson John yeoman 599080 599080 Howysson, John, of West Walton, Norf, yeoman 0
4804922 2297743 2297743 defendant Laurence Walter husbandman 599080 599080 Laurence, Walter, of West Walton, Norf, husbandman 0
4923145 2333655 2333655 defendant Laurence Walter husbandman 599080 599080 Laurence, Walter, of West Walton, Norf, husbandman 0
4957722 2344283 2344283 defendant Goche Stephen husbandman 599080 599080 Goche, Stephen, of West Walton, Norf, husbandman 0
5026820 2364716 2364716 defendant Eyre John husbandman 599080 599080 Eyre, John, of West Walton, Norf, husbandman 3
5131999 2395846 2395846 defendant Newport Robert clerk 599080 599080 Newport, Robert, of West Walton, Norf, clerk 0
5135004 2396736 2396736 defendant Newport Robert   599080 599080 Newport, Robert, of West Walton, Norf, parson 1
5151581 2401615 2401615 defendant Newport Robert clerk 599080 599080 Newport, Robert, of West Walton, Norf, clerk 0
5151583 2401616 2401616 defendant Newport Robert clerk 599080 599080 Newport, Robert, of West Walton, Norf, clerk 0
5169694 2406875 2406875 defendant Newport Robert clerk 599080 599080 Newport, Robert, of West Walton, Norf, clerk 0
5172804 2407781 2407781 defendant (not given) Robert rector of Neuport 599080 599080 Neuport, Robert, of West Walton, Norf, clerk & rector of the church 0
5192637 2413584 2413584 defendant (not given) Robert rector of Neuport 599080 599080 Neuport, Robert, of West Walton, Norf, clerk & rector of the parish church 0
5212889 2419514 2419514 defendant Alcok Thomas husbandman 599080 599080 Alcok, Thomas, of West Walton, Norf, husbandman 0
5254966 2431667 2431667 defendant Hamond Robert clerk 599080 599080 Hamond, Robert, of West Walton, Norf, clerk 0
5263890 2434464 2434464 defendant Pert William chapman 599080 599080 Pert, William, of West Walton, Norf, chapman 1
5284562 2440495 2440495 defendant Haukyn John husbandman 599080 599080 Haukyn, John, of West Walton, Norf, husbandman 4
5309902 2447998 2447998 defendant Stote Gregory husbandman 599080 599080 Stote, Gregory, of West Walton, Norf, husbandman 0
5315141 2449585 2449585 defendant Hunt Walter yeoman 599080 599080 Hunt, Walter, of West Walton, Norf, yeoman 1
5315147 2449586 2449586 defendant Hunt Walter husbandman 599080 599080 Hunt, Walter, of West Walton, Norf, husbandman 2
5348505 2459671 2459671 defendant Hert Richard husbandman 599080 599080 Hert, Richard, of West Walton, Norf, husbandman 0
5362227 2463852 2463852 defendant Harvy Stephen husbandman 599080 599080 Harvy, Stephen, of West Walton, Norf, husbandman 0
5364602 2464590 2464590 defendant Pondych William husbandman 599080 599080 Pondych, William, of West Walton, Norf, 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);