names

52 rows where place_id = 658543

✎ 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
3948871 2006670 2006670 defendant Scott alias Towrell Arthur fuller 658543 658543 Scott alias Towrell, Arthur, of Marlebroughe, fuller 0
3981238 2018052 2018052 defendant Cockey Thomas tailor 658543 658543 Cockey, Thomas, of Marlebroughe, tailor 1
4021919 2032565 2032565 plaintiff Allen John merchant 658543 658543 Allen, John, of Marlebroughe, merchant 0
4026890 2034267 2034267 defendant Raynold Avelena widow 658543 658543 Raynold, Avelena, of Marlebroughe, widow 1
4026892 2034268 2034268 defendant Raynold George (legal representative) 658543 658543 Raynold, George, of Marlebroughe, clothworker, executrix of 0
4119323 2067206 2067206 defendant Holloweye Richard chandler 658543 658543 (Holloweye, Richard, of Marlebroughe, chandler 1
4221276 2102939 2102939 defendant Alexander John baker 658543 658543 Alexander, John, of Marlebroughe, baker 0
4222625 2103405 2103405 defendant Bradfeilde John husbandman 658543 658543 Bradfeilde, John, of Marlebroughe, or of Cherhill, husbandman 0
4222882 2103491 2103491 defendant Alexander John baker 658543 658543 Alexander, John, of Marlebroughe, baker 0
4225483 2104380 2104380 defendant Write Roger husbandman 658543 658543 Write, Roger, of Marlebroughe, or of Uphaven, husbandman 0
4227262 2105016 2105016 defendant Benson Robert husbandman 658543 658543 Benson, Robert, of Marlebroughe, or of Weste Combe, Bedwyn Magna, husbandman 0
4227264 2105017 2105017 defendant Bond Agnes widow 658543 658543 Bond, Agnes, of Marlebroughe, or of Clyve Aunicy, widow 0
4227266 2105018 2105018 defendant Bond William yeoman 658543 658543 Bond, William, of Marlebroughe, or of Clyve Ancye, Hilmerston, yeoman 0
4232607 2106908 2106908 defendant Gaynesford Philip   658543 658543 Gaynesford, Philip, of Marlebroughe, surgeon 0
4233463 2107219 2107219 defendant Weekes Thomas gent 658543 658543 Weekes, Thomas, of Marlebroughe, or of Ashburie, Berks, gent 0
4233898 2107384 2107384 defendant Waterman Maud widow 658543 658543 Waterman, Maud, of Marlebroughe, widow 1
4235418 2107956 2107956 defendant Holland William innholder 658543 658543 Holland, William, of Marlebroughe, or of Spenehamland, Berks, innholder 0
4235592 2108018 2108018 defendant Massam William innholder 658543 658543 Massam, William, of Marlebroughe, innholder 0
4235593 2108018 2108018 defendant Massam Anthony   658543 658543 Massam, Anthony, of Marlebroughe, yeoman, his son, or of "le Greete Parke de Savernack" 1
4236194 2108228 2108228 defendant Townesend John yeoman 658543 658543 Townesend, John, of Marlebroughe, or of Heddenton, yeoman 0
4238458 2109066 2109066 defendant Whitfeild Thomas clerk 658543 658543 Whitfeild, Thomas, of Marlebroughe, clerk 0
4238459 2109066 2109066 defendant Boxe John baker 658543 658543 Boxe, John, of Marlebroughe, baker 1
4239376 2109390 2109390 defendant Button Edward esq 658543 658543 Button, Edward, of Marlebroughe, or of Columbar, St Nicholas, Glamorgan, esq 0
4239377 2109390 2109390 defendant Thomas William gent 658543 658543 Thomas, William, of Marlebroughe, or of Moulton, Lamarvan, gent 1
4239931 2109602 2109602 defendant Webbe Henry gent 658543 658543 Webbe, Henry, of Marlebroughe, gent, son of Edmund Webbe, of Bushton, gent 0
4251711 2113562 2113562 defendant Week Thomas gent 658543 658543 Week, Thomas, of Marlebroughe, or of Ashburie, Berks, gent 0
4275638 2121423 2121423 defendant Cartwright John merchant tailor 658543 658543 Cartwright, John, of Marlebroughe, merchant tailor 0
4275639 2121423 2121423 defendant Lambert Christopher joimer 658543 658543 Lambert, Christopher, of Marlebroughe, joimer 1
4276032 2121563 2121563 defendant Wright Christopher yeoman 658543 658543 Wright, Christopher, of Marlebroughe, or of Little Bedwyn, yeoman 0
4276343 2121670 2121670 defendant Younge alias Mlles William   658543 658543 Younge alias Mlles, William, of Marlebroughe, or of Chippenham, woollen draper 0
4277611 2122091 2122091 defendant Alleffe Thomas yeoman 658543 658543 Alleffe, Thomas, of Marlebroughe, or of Okeshey, yeoman 0
4277612 2122091 2122091 defendant Plaster or Playster Richard yeoman 658543 658543 Plaster or Playster, Richard, of Marlebroughe, yeoman 1
4278043 2122254 2122254 defendant Reves Simon yeoman 658543 658543 Reves, Simon, of Marlebroughe, or of Netherhaven, yeoman 0
4278360 2122369 2122369 defendant Rosewell William gent 658543 658543 Rosewell, William, of Marlebroughe, or of Donkerton, Soms, gent 0
4278361 2122369 2122369 defendant Chocke Alexander esq 658543 658543 Chocke, Alexander, of Marlebroughe, or of Avington, Berks, esq 1
4281324 2123375 2123375 defendant Spicer Edward husbandman 658543 658543 Spicer, Edward, of Marlebroughe, or of Uffcot, husbandman 0
4281325 2123375 2123375 defendant Spicer Richard husbandman 658543 658543 Spicer, Richard, of Marlebroughe, or of Brodehenton, husbandman 1
4281326 2123375 2123375 defendant Mason Thomas yeoman 658543 658543 Mason, Thomas, of Marlebroughe, or of West Stowell, Alton Priors, yeoman 2
4295501 2128476 2128476 defendant Browne Richard gent 658543 658543 Browne, Richard, of Marlebroughe, or of Calne, gent 0
4310491 2133822 2133822 defendant Rosewell Thomas gent 658543 658543 Rosewell, Thomas, of Marlebroughe, or of Donkerton, gent 0
4315308 2135466 2135466 defendant Woodroff William husbandman 658543 658543 Woodroff, William, of Marlebroughe, hatter, or of Summerford Parva, husbandman 0
4315744 2135617 2135617 defendant Batt John baker 658543 658543 Batt, John, of Marlebroughe, or of Lie on Mendippe, Soms, baker 0
4315745 2135617 2135617 defendant Gaye Richard yeoman 658543 658543 Gaye, Richard, of Marlebroughe, or of Whittnell, Enboroughe, yeoman 1
4322789 2138040 2138040 defendant Cary Richard gent 658543 658543 Cary, Richard, of Marlebroughe, gent 0
4344138 2145232 2145232 defendant Arden Richard   658543 658543 Arden, Richard, of Marlebroughe, felt maker 0
4345147 2145577 2145577 defendant Waldron Thomas gent 658543 658543 Waldron, Thomas, of Marlebroughe, or of Aldeborne, gent 0
4349465 2147077 2147077 defendant Bastard Robert cutler 658543 658543 Bastard, Robert, of Marlebroughe, or of Shaftsbury, Dorset, cutler 0
4349466 2147077 2147077 defendant Cooper Thomas clerk 658543 658543 Cooper, Thomas, of Marlebroughe, or of Shaftsbury, clerk 1
4367385 2153388 2153388 defendant Maslyn John innkeeper 658543 658543 Maslyn, John, of Marlebroughe, innkeeper 0
4373437 2155567 2155567 defendant Masline John   658543 658543 Masline, John, of Marlebroughe, Wilts vintner 0
4373439 2155568 2155568 defendant Maslyn John vintner 658543 658543 Maslyn, John, of Marlebroughe, vintner 0
4389094 2160982 2160982 defendant Traford Edmund esq 658543 658543 Traford, Edmund, of Marlebroughe, or of Manchester, Lancs, esq 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);