names

42 rows where place_id = 596139

✎ 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
3620868 1874089 1874089 defendant Scras Richard (legal representative) 596139 596139 Scras, Richard, of Burwasshe, husbandman, executor of 2
3623316 1874820 1874820 defendant Erle Simon   596139 596139 Erle, Simon, of Burwasshe 0
3657641 1912650 1912650 defendant Walter Nicholas husbandman 596139 596139 Walter, Nicholas, of Burwasshe, husbandman 0
3680947 1920122 1920122 defendant Dawe John   596139 596139 Dawe, John, of Burwasshe, ash burner 0
3699229 1925971 1925971 defendant Walter Nicholas husbandman 596139 596139 Walter, Nicholas, of Burwasshe, husbandman 0
3699230 1925971 1925971 defendant Marden Richard husbandman 596139 596139 Marden, Richard, of Burwasshe, husbandman 1
3699231 1925971 1925971 defendant Brodebylt John smith 596139 596139 Brodebylt, John, of Burwasshe, smith 2
3709782 1929375 1929375 defendant Brodbelt John smith 596139 596139 Brodbelt, John, of Burwasshe, smith 0
3709783 1929375 1929375 defendant Walter Nicholas husbandman 596139 596139 Walter, Nicholas, of Burwasshe, husbandman 1
3725320 1934215 1934215 plaintiff Sneppe Richard (legal representative) 596139 596139 Sneppe, Richard, of Burwasshe, executors of 0
3725323 1934215 1934215 defendant Sheppe Richard (legal representative) 596139 596139 Sheppe, Richard, of Burwasshe, executors of 0
3725324 1934215 1934215 defendant Sneppe Geoffrey yeoman 596139 596139 (Sneppe, Geoffrey, of Burwasshe, yeoman 1
3732745 1936472 1936472 defendant Donett or Dovett Thomas husbandman 596139 596139 Donett or Dovett, Thomas, of Burwasshe, husbandman 0
3735797 1937433 1937433 defendant Okham Geoffrey shoemaker 596139 596139 Okham, Geoffrey, of Burwasshe, shoemaker 0
3751038 1942257 1942257 defendant Croche John (legal representative) 596139 596139 Croche, John, of Burwasshe, smith, executor of 1
3751039 1942257 1942257 defendant Brodebelt John smith 596139 596139 Brodebelt, John, of Burwasshe, smith 2
3757221 1944241 1944241 defendant Cuckowe William butcher 596139 596139 Cuckowe, William, of Burwasshe, butcher 0
3775151 1949961 1949961 defendant Cokkow William butcher 596139 596139 Cokkow, William, of Burwasshe, butcher 2
3797085 1956969 1956969 defendant Dennett Thomas husbandman 596139 596139 Dennett, Thomas, of Burwasshe, husbandman 0
3814328 1962393 1962393 defendant Denett Thomas husbandman 596139 596139 Denett, Thomas, of Burwasshe, husbandman 0
3830669 1967475 1967475 defendant Brasyer Roger husbandman 596139 596139 Brasyer, Roger, of Burwasshe, husbandman 4
3870742 1980459 1980459 defendant Cukkowe William butcher 596139 596139 Cukkowe, William, of Burwasshe, butcher 0
3882350 1984356 1984356 defendant Colman Henry tailor 596139 596139 Colman, Henry, of Burwasshe, tailor 0
3921851 1997652 1997652 defendant Weston Henry husbandman 596139 596139 Weston, Henry, of Burwasshe, husbandman 0
3921852 1997652 1997652 defendant Waterer Richard husbandman 596139 596139 Waterer, Richard, of Burwasshe, husbandman 1
3921853 1997652 1997652 defendant Conye John husbandman 596139 596139 Conye, John, of Burwasshe, husbandman 2
3929476 2000205 2000205 defendant Weble or Welle Jospeh weaver 596139 596139 Weble or Welle, Jospeh, of Burwasshe, weaver 0
3943313 2004781 2004781 defendant Weston William butcher 596139 596139 Weston, William, of Burwasshe, butcher 1
4016691 2030679 2030679 defendant Maye George gent 596139 596139 Maye, George, of Burwasshe, gent 0
4055807 2044458 2044458 defendant Goodsall Stephen, senior husbandman 596139 596139 Goodsall, Stephen, senior, of Burwasshe, husbandman 0
4060754 2046252 2046252 plaintiff Dennet Elizabeth   596139 596139 Dennet, Elizabeth, of Burwasshe 0
4063544 2047249 2047249 defendant Pynyan John husbandman 596139 596139 Pynyan, John, of Burwasshe, husbandman 1
4081121 2053560 2053560 defendant Goodsole Thomas yeoman 596139 596139 Goodsole, Thomas, of Burwasshe, yeoman 0
4095222 2058614 2058614 defendant Ellys Thomas yeoman 596139 596139 Ellys, Thomas, of Burwasshe, yeoman 0
4098766 2059889 2059889 defendant Ives Thomas gent 596139 596139 Ives, Thomas, of Burwasshe, gent 0
4117769 2066647 2066647 defendant A Rede Richard yeoman 596139 596139 A Rede, Richard, of Burwasshe, yeoman 0
4312731 2134584 2134584 defendant Tuttey William collier 596139 596139 Tuttey, William, of Burwasshe, collier 1
4396002 2163239 2163239 defendant Smart Roger husbandman 596139 596139 Smart, Roger, of Burwasshe, husbandman 0
5297778 2444355 2444355 defendant Weston John husbandman 596139 596139 Weston, John, of Burwasshe, husbandman 0
5297780 2444356 2444356 defendant Weston Henry husbandman 596139 596139 Weston, Henry, of Burwasshe, husbandman 0
5496724 2503941 2503941 defendant Dawe William tanner 596139 596139 Dawe, William, of Burwasshe, tanner 1
5503315 2505946 2505946 defendant A Ry Michael husbandman 596139 596139 A Ry, Michael, of Burwasshe, 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);