names

54 rows where place_id = 630866

✎ 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
3797103 1956976 1956976 defendant Vaughan David yeoman 630866 630866 Vaughan, David, of Brentwood, yeoman 0
3820630 1964337 1964337 defendant Halle George gent 630866 630866 Halle, George, of Brentwood, gent 0
3852889 1974518 1974518 defendant Alen Richard (legal representative) 630866 630866 Alen, Richard, of Brentwood, innholder, executor of 0
3852892 1974519 1974519 defendant Alen Richard (legal representative) 630866 630866 Alen, Richard, of Brentwood, innholder, executor of 0
3865740 1978767 1978767 plaintiff Nytyngale Richard gent 630866 630866 Nytyngale, Richard, of Brentwood, gent 0
3872301 1980961 1980961 defendant Grene Walter tailor 630866 630866 Grene, Walter, of Brentwood, tailor 0
3900206 1990294 1990294 defendant Carter Henry laborer 630866 630866 Carter, Henry, of Brentwood, laborer 1
3901425 1990700 1990700 defendant Coldwell John butcher 630866 630866 Coldwell, John, of Brentwood, butcher 1
3902270 1990994 1990994 defendant Vese Lawrence (legal representative) 630866 630866 Vese, Lawrence, of Brentwood, yeoman, executors of 0
3902273 1990994 1990994 defendant Habbert Dionisia spinster 630866 630866 Habbert, Dionisia, of Brentwood, spinster 3
3903479 1991389 1991389 defendant Salmon Robert yeoman 630866 630866 Salmon, Robert, of Brentwood, yeoman 0
3903887 1991537 1991537 defendant Salmon Robert yoeman 630866 630866 Salmon, Robert, of Brentwood, yoeman 0
3903910 1991546 1991546 defendant Palgrave Nicholas (legal representative) 630866 630866 Palgrave, Nicholas, of Brentwood, butcher, executors of 0
3906342 1992407 1992407 defendant Carter Henry   630866 630866 Carter, Henry, of Brentwood, horse courser 1
3906343 1992407 1992407 defendant Long John   630866 630866 Long, John, of Brentwood, horse courser 2
3906872 1992587 1992587 defendant Chambleyn John sawyer 630866 630866 Chambleyn, John, of Brentwood, sawyer 1
3906873 1992587 1992587 defendant Foster Richard   630866 630866 Foster, Richard, of Brentwood, horse courser 2
3911635 1994213 1994213 defendant Stokkette Thomas tanner 630866 630866 Stokkette, Thomas, of Brentwood, yeoman, tanner 2
3914173 1995085 1995085 defendant Curtyn William butcher 630866 630866 Curtyn, William, of Brentwood, butcher 1
3914174 1995085 1995085 defendant Grene Walter tailor 630866 630866 Grene, Walter, of Brentwood, tailor 2
3978271 2016981 2016981 defendant Wodland alias Egham John yeoman 630866 630866 Wodland alias Egham, John, of Brentwood, yeoman 0
4223225 2103614 2103614 defendant Prior Francis yeoman 630866 630866 Prior, Francis, of Brentwood, yeoman 0
4231436 2106496 2106496 defendant Ponde Robert yeoman 630866 630866 Ponde, Robert, of Brentwood, yeoman 0
4238380 2109036 2109036 defendant Haine Ralph yeoman 630866 630866 Haine, Ralph, of Brentwood, yeoman 2
4239860 2109577 2109577 defendant Ponde Robert yeoman 630866 630866 Ponde, Robert, of Brentwood, yeoman 0
4239861 2109577 2109577 defendant Colthurst Benjamin yeoman 630866 630866 Colthurst, Benjamin, of Brentwood, yeoman 1
4239862 2109577 2109577 defendant Pryor Francis yeoman 630866 630866 Pryor, Francis, of Brentwood, yeoman 2
4248713 2112555 2112555 defendant Prior Francis yeoman 630866 630866 Prior, Francis, of Brentwood, yeoman 0
4310149 2133704 2133704 defendant Camper Thomas yeoman 630866 630866 Camper, Thomas, of Brentwood, yeoman 0
4313978 2134995 2134995 defendant Stewarde Bartholomew   630866 630866 Stewarde, Bartholomew, of Brentwood, linen draper 0
4330801 2140600 2140600 defendant Ponde Mary widow 630866 630866 Ponde, Mary, of Brentwood, widow 0
4338811 2143329 2143329 defendant Reanowles William draper 630866 630866 Reanowles, William, of Brentwood, draper 1
4361859 2151402 2151402 defendant Maslyne alias Skynner Richard glover 630866 630866 Maslyne alias Skynner, Richard, of Brentwood, glover 0
4399556 2164440 2164440 defendant Wolston John butcher 630866 630866 Wolston, John, of Brentwood, butcher 0
4526881 2208684 2208684 defendant Pulter Henry   630866 630866 Pulter, Henry, of Brentwood 0
4709544 2268341 2268341 defendant Martyn Nicholas husbandman 630866 630866 Martyn, Nicholas, of Brentwood, husbandman 0
4716779 2270571 2270571 plaintiff Wretele John   630866 630866 Wretele, John, of Brentwood 0
4716780 2270571 2270571 defendant Bocher William butcher 630866 630866 Bocher, William, of Brentwood, butcher 0
4758021 2282882 2282882 defendant Bocher John   630866 630866 Bocher, John, of Brentwood, bailiff 1
4766557 2285531 2285531 defendant Flemmyng Henry tailor 630866 630866 Flemmyng, Henry, of Brentwood, tailor 0
4770491 2286747 2286747 defendant Efy John   630866 630866 Efy, John, of Brentwood, shoe maker 0
4770494 2286747 2286747 defendant Elewyne William pewterer 630866 630866 Elewyne, William, of Brentwood, pewterer 3
4847510 2310722 2310722 defendant Richard John ostler 630866 630866 Richard, John, of Brentwood, ostler 0
4850536 2311629 2311629 defendant Shelton Robert baker 630866 630866 Shelton, Robert, of Brentwood, baker 3
4988973 2353640 2353640 defendant Andrewe Thomas baker 630866 630866 Andrewe, Thomas, of Brentwood, baker 3
5136004 2397041 2397041 defendant Stams-d William clerk 630866 630866 Stams-d, William, of Brentwood, clerk 2
5159452 2403881 2403881 defendant Frenche Nichoals butcher 630866 630866 Frenche, Nichoals, of Brentwood, butcher 0
5174580 2408266 2408266 defendant Frenche Nicholas butcher 630866 630866 Frenche, Nicholas, of Brentwood, butcher 0
5176988 2408960 2408960 defendant Frebarn John butcher 630866 630866 Frebarn, John, of Brentwood, butcher 1
5177281 2409049 2409049 defendant _kelon Thomas butcher 630866 630866 _kelon, Thomas, of Brentwood, butcher 1
5192980 2413673 2413673 defendant Byrd Richard husbandman 630866 630866 Byrd, Richard, of Brentwood, husbandman 0
5192981 2413673 2413673 defendant Rychard John husbandman 630866 630866 Rychard, John, of Brentwood, husbandman 1
5298155 2444476 2444476 defendant Goman John baker 630866 630866 Goman, John, of Brentwood, baker 0
5426139 2482772 2482772 plaintiff Prentes William yeoman 630866 630866 Prentes, William, of Brentwood, yeoman 1

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