names

94 rows where place_id = 592927

✎ 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
3609427 1870612 1870612 defendant Skowtar Geoffrey husbandman 592927 592927 Skowtar, Geoffrey, of Brome, husbandman 0
3657142 1912498 1912498 defendant Cornwalys Margaret widow 592927 592927 Cornwalys, Margaret, of Brome, widow 0
3679403 1919622 1919622 defendant Smyth Richard chapman 592927 592927 Smyth, Richard, of Brome, chapman 0
3682354 1920582 1920582 defendant Smyth Richard chapman 592927 592927 Smyth, Richard, of Brome, chapman 0
3682355 1920582 1920582 defendant Smyth Ralph husbandman 592927 592927 Smyth, Ralph, of Brome, husbandman 1
3682989 1920793 1920793 defendant Legent William husbandman 592927 592927 Legent, William, of Brome, husbandman 0
3692292 1923759 1923759 defendant Hayes Margaret widow 592927 592927 Hayes, Margaret, of Brome Candever, widow 0
3697879 1925558 1925558 defendant Roo Alexander carpenter 592927 592927 Roo, Alexander, of Brome, carpenter 0
3697880 1925558 1925558 defendant Bolour Katherine widow 592927 592927 Bolour, Katherine, of brome, widow 1
3708022 1928807 1928807 defendant Smyth Richard yeoman 592927 592927 Smyth, Richard, of Brome, yeoman 0
3722570 1933319 1933319 defendant Smyth Richard yeoman 592927 592927 Smyth, Richard, of Brome, yeoman 0
3734813 1937134 1937134 defendant Elme Henry   592927 592927 Elme, Henry, of Brome, chair maker 0
3738357 1938210 1938210 defendant Smyth Richard yeoman 592927 592927 Smyth, Richard, of Brome, yeoman 0
3747721 1941207 1941207 defendant Woodesyde Thomas yeoman 592927 592927 Woodesyde, Thomas, of Brome, yeoman 0
3758197 1944554 1944554 defendant Hyll Thomas husbandman 592927 592927 Hyll, Thomas, of Brome, husbandman 0
3823741 1965322 1965322 defendant Badlond Thomas husbandman 592927 592927 Badlond, Thomas, of Brome, husbandman 0
3837164 1969525 1969525 defendant Legent William husbandman 592927 592927 Legent, William, of Brome, husbandman 0
3837165 1969525 1969525 defendant Legent Reginald laborer 592927 592927 Legent, Reginald, of Brome, laborer 1
3837166 1969526 1969526 plaintiff Shelton Ralph esq 592927 592927 Shelton, Ralph, of Brome, esq 0
3842827 1971290 1971290 defendant Kytteley Eustace gent 592927 592927 Kytteley, Eustace, of Brome, gent 0
3848261 1973024 1973024 defendant Kyttley Eustace gent 592927 592927 Kyttley, Eustace, of Brome, gent 0
3853169 1974611 1974611 plaintiff Shelton Ralph esq 592927 592927 Shelton, Ralph, of Brome, esq 0
3854105 1974920 1974920 plaintiff Swyfte Robert gent 592927 592927 Swyfte, Robert, of Brome, gent 0
3862541 1977665 1977665 defendant Colman Richard, senior husbandman 592927 592927 Colman, Richard, senior, of Brome, husbandman 4
3863455 1977970 1977970 defendant Kytteley Eustace gent 592927 592927 Kytteley, Eustace, of Brome, gent 0
3897577 1989401 1989401 defendant Colman Richard husbandman 592927 592927 Colman, Richard, of Brome, husbandman 1
3913961 1995016 1995016 plaintiff Broune Mathew gent 592927 592927 Broune, Mathew, of Brome, gent 0
3916868 1996006 1996006 defendant Potter William yeoman 592927 592927 Potter, William, of Brome, yeoman 0
3927696 1999601 1999601 defendant Gallett John, senior husbandman 592927 592927 Gallett, John, senior, of Brome, husbandman 0
3927697 1999601 1999601 defendant Gallett Thomas husbandman 592927 592927 Gallett, Thomas, of Brome, husbandman 1
3927698 1999601 1999601 defendant Brydd John husbandman 592927 592927 Brydd, John, of Brome, husbandman 2
3934963 2001996 2001996 defendant Harrys Richard husbandman 592927 592927 Harrys, Richard, of Brome, husbandman 0
3940893 2003959 2003959 defendant Turnour William   592927 592927 Turnour, William, of Brome, shoe maker 2
3952928 2008094 2008094 defendant Shelton Ralph esq 592927 592927 Shelton, Ralph, of Brome, esq 0
3956959 2009500 2009500 defendant Hunk Henry gent 592927 592927 Hunk, Henry, of Brome, gent 0
3967097 2013117 2013117 defendant Denton Edmund tailor 592927 592927 Denton, Edmund, of Brome, tailor 0
3969496 2013939 2013939 defendant Barkar William gent 592927 592927 Barkar, William, of Brome, gent 0
3983853 2018996 2018996 defendant Gostlyng William husbandman 592927 592927 Gostlyng, William, of Brome, husbandman 0
3991683 2021783 2021783 defendant Knight William husbandman 592927 592927 Knight, William, of Brome, husbandman 2
3991686 2021784 2021784 plaintiff Brome Mathew gent 592927 592927 Brome, Mathew, of Brome, gent 0
3991687 2021784 2021784 defendant Blucke John yeoman 592927 592927 Blucke, John, of Brome, yeoman 0
4023272 2033029 2033029 defendant Blucke John yeoman 592927 592927 Blucke, John, of Brome, yeoman 3
4033347 2036579 2036579 defendant Normecote Henry yeoman 592927 592927 Normecote, Henry, of Brome, yeoman 1
4033350 2036580 2036580 defendant Normecote Henry yeoman 592927 592927 Normecote, Henry, of Brome, yeoman 1
4045300 2040777 2040777 defendant Blucke John yeoman 592927 592927 Blucke, John, of Brome, yeoman 0
4085850 2055215 2055215 defendant Hughes John yeoman 592927 592927 Hughes, John, of Brome, yeoman 0
4091082 2057098 2057098 defendant Blucke John yeoman 592927 592927 Blucke, John, of Brome, yeoman 2
4119143 2067135 2067135 defendant Browne Jerome yeoman 592927 592927 Browne, Jerome, of Brome, yeoman 1
4156886 2080487 2080487 defendant Cole Alexander   592927 592927 Cole, Alexander, of Brome, scythe smith 0
4210708 2099302 2099302 defendant Locke William yeoman 592927 592927 Locke, William, of Brome, yeoman 3
4279746 2122833 2122833 defendant Brome Lucy widow 592927 592927 Brome, Lucy, of Brome, widow 1
4313863 2134956 2134956 defendant Norman Robert   592927 592927 Norman, Robert, of Brome, Suff, taylor 2
4317266 2136152 2136152 defendant Undrell Philip   592927 592927 Undrell, Philip, of Brome, scythe smith 0
4383936 2159332 2159332 defendant Buller John yeoman 592927 592927 Buller, John, of Brome, yeoman 0
4404053 2165926 2165926 defendant Burdytt John   592927 592927 Burdytt, John, of Brome, mason 2
4594183 2229446 2229446 defendant Brome John   592927 592927 Brome, John, of Brome 0
4612061 2234838 2234838 defendant Wardon John   592927 592927 Wardon, John, of Brome 0
4630063 2240318 2240318 defendant Walpooll Richard   592927 592927 Walpooll, Richard, of Brome, vicar 4
4703722 2266542 2266542 defendant Brome John husbandman 592927 592927 Brome, John, of Brome, husbandman 0
4707311 2267664 2267664 defendant Breton Robert tanner 592927 592927 Breton, Robert, of Brome, tanner 0
4767643 2285865 2285865 defendant Merynton John husbandman 592927 592927 (Merynton, John, of Brome, husbandman 1
4815954 2301080 2301080 defendant Brome William husbandman 592927 592927 Brome, William, of Brome, husbandman 4
4835398 2307067 2307067 defendant Hayll Augustine husbandman 592927 592927 Hayll, Augustine, of Brome, husbandman 4
4838434 2307936 2307936 defendant Othebrome John butcher 592927 592927 Othebrome, John, of Brome, butcher 1
4841584 2308902 2308902 defendant Aleham William husbandman 592927 592927 Aleham, William, of Brome, husbandman 0
4841585 2308902 2308902 defendant (illegible) Simon yeoman 592927 592927 _, Simon, of Brome, yeoman 1
4860283 2314574 2314574 defendant Child Robert husbandman 592927 592927 Child, Robert, of Brome, husbandman 1
4934620 2337221 2337221 defendant Bochere John butcher 592927 592927 Bochere, John, of Brome, butcher 0
5001202 2357232 2357232 defendant Pye Robert husbandman 592927 592927 Pye, Robert, of Brome, husbandman 0
5001203 2357232 2357232 defendant Pye Thomas husbandman 592927 592927 Pye, Thomas, of Brome, husbandman 1
5011227 2360140 2360140 defendant Gebon John husbandman 592927 592927 Gebon, John, of Brome, husbandman 0
5020980 2363034 2363034 defendant Brome John husbandman 592927 592927 Brome, John, of Brome, husbandman 1
5095853 2385215 2385215 defendant Maynard John husbandman 592927 592927 Maynard, John, of Brome, husbandman 0
5255212 2431745 2431745 plaintiff Smyth Richard, junior   592927 592927 Smyth, Richard, junior, of Brome 2
5281619 2439689 2439689 defendant Hervy John husbandman 592927 592927 Hervy, John, of Brome, husbandman 0
5326420 2452987 2452987 defendant Aldham Simon husbandman 592927 592927 Aldham, Simon, of Brome, husbandman 0
5326421 2452987 2452987 defendant Aldham Thomas husbandman 592927 592927 Aldham, Thomas, of Brome, husbandman 1
5340295 2457171 2457171 defendant Brither William husbandman 592927 592927 Brither, William, of Brome, husbandman 3
5445555 2488568 2488568 defendant Brome Walter husbandman 592927 592927 Brome, Walter, of Brome, husbandman 0
5445556 2488568 2488568 defendant Brome William husbandman 592927 592927 Brome, William, of Brome, husbandman 1
5445559 2488569 2488569 defendant Bromer Walter husbandman 592927 592927 Bromer, Walter, of Brome, husbandman 0
5445560 2488569 2488569 defendant Brome William husbandman 592927 592927 Brome, William, of Brome, husbandman 1
5469984 2495944 2495944 defendant Brome Walter husbandman 592927 592927 Brome, Walter, of Brome, husbandman 0
5469985 2495944 2495944 defendant Brome William husbandman 592927 592927 Brome, William, of Brome, husbandman 1
5478508 2498600 2498600 defendant Jay Thomas clerk 592927 592927 Jay, Thomas, of Brome, clerk 1
5488212 2501372 2501372 defendant Maynard John husbandman 592927 592927 Maynard, John, of Brome, husbandman 0
5504193 2506227 2506227 plaintiff Aldham Thomas   592927 592927 Aldham, Thomas, of Brome 0
5515610 2509725 2509725 defendant Hyron William husbandman 592927 592927 Hyron, William, of Brome, husbandman 0
5523414 2512152 2512152 defendant Merdy John yeoman 592927 592927 Merdy, John, of Brome, yeoman 2
5544499 2518390 2518390 defendant Rowe Geoffrey husbandman 592927 592927 Rowe, Geoffrey, of Brome, husbandman 0
5547693 2519341 2519341 plaintiff Wryght John (legal representative) 592927 592927 Wryght, John, of Brome, son of Wryght, Richard, executor of 0
5547695 2519342 2519342 plaintiff Wryght John (legal representative) 592927 592927 Wryght, John, of Brome, son of Wryght, Richard, executor of 0
5599758 2534814 2534814 plaintiff Haldam Robert   592927 592927 (Haldam, Robert, of Brome 1
5599759 2534814 2534814 plaintiff Haldam William   592927 592927 Haldam, William, of Brome 2

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