names

43 rows where place_id = 610826

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3685426 1921593 1921593 defendant Ponde John husbandman 610826 610826 Ponde, John, of Shenfeld, husbandman 0
3685429 1921593 1921593 defendant Rogers Thomas husbandman 610826 610826 Rogers, Thomas, of Shenfeld, husbandman 3
3700470 1926385 1926385 defendant Ponde John husbandman 610826 610826 Ponde, John, of Shenfeld, husbandman 0
3700473 1926385 1926385 defendant Rogers Thomas husbandman 610826 610826 Rogers, Thomas, of Shenfeld, husbandman 3
3751904 1942509 1942509 defendant Drabuls Joan widow 610826 610826 Drabuls, Joan, of Shenfeld, widow 0
3792879 1955627 1955627 defendant Holand Thomas laborer 610826 610826 Holand, Thomas, of Shenfeld, laborer 0
3810611 1961215 1961215 defendant Newlande William haberdasher 610826 610826 Newlande, William, of Shenfeld, haberdasher 4
3859043 1976516 1976516 defendant Tyrell Humphrey gent 610826 610826 Tyrell, Humphrey, of Shenfeld, gent 5
3859044 1976516 1976516 defendant Stretys Henry yeoman 610826 610826 Stretys, Henry, of Shenfeld, yeoman 6
3860488 1977001 1977001 defendant Browne William yeoman 610826 610826 Browne, William, of Shenfeld, yeoman 0
3873183 1981246 1981246 defendant Tyrell Humphrey gent 610826 610826 Tyrell, Humphrey, of Shenfeld, gent 5
3873184 1981246 1981246 defendant Stretys Henry yeoman 610826 610826 Stretys, Henry, of SHenfeld, yeoman 6
4451007 2185283 2185283 plaintiff Herde John   610826 610826 Herde, John, of Shenfeld 0
4455991 2186893 2186893 defendant Frenssh John, junior   610826 610826 Frenssh, John, junior, of Shenfeld 1
4455995 2186895 2186895 defendant Wolleye William   610826 610826 Wolleye, William, of Shenfeld 0
4455997 2186896 2186896 defendant Wolleye William   610826 610826 Wolleye, William, of Shenfeld 0
4455998 2186896 2186896 defendant Puttok John   610826 610826 Puttok, John, of Shenfeld 1
4601771 2231775 2231775 defendant Wreght Walter   610826 610826 Wreght, Walter, of Shenfeld 1
4708565 2268048 2268048 defendant Hyrde John   610826 610826 Hyrde, John, of Shenfeld, bailiff 2
5000726 2357088 2357088 plaintiff Marchall Thomas   610826 610826 Marchall, Thomas, of Shenfeld 0
5119840 2392237 2392237 defendant Mompard Thomas husbandman 610826 610826 Mompard, Thomas, of Shenfeld, husbandman 0
5211969 2419239 2419239 defendant Den Thomas laborer 610826 610826 Den, Thomas, of Shenfeld, laborer 2
5211973 2419240 2419240 defendant Mumpard Thomas yeoman 610826 610826 Mumpard, Thomas, of Shenfeld, yeoman 0
5291021 2442376 2442376 defendant Trasshell John laborer 610826 610826 Trasshell, John, of Shenfeld, laborer 0
5291022 2442376 2442376 defendant Balaham John laborer 610826 610826 Balaham, John, of Shenfeld, laborer 1
5376772 2468332 2468332 defendant Cosyn William tanner 610826 610826 Cosyn, William, of Shenfeld, tanner 0
5376783 2468334 2468334 defendant Cosyn William tanner 610826 610826 Cosyn, William, of Shenfeld, tanner 0
5385204 2470844 2470844 defendant Marchall Thomas maltman 610826 610826 Marchall, Thomas, of Shenfeld, maltman 2
5397289 2474307 2474307 defendant Marchall Thomas   610826 610826 Marchall, Thomas, of Shenfeld, malt man 2
5397293 2474308 2474308 defendant Marchall Thomas   610826 610826 Marchall, Thomas, of Shenfeld, malt man 2
5402584 2475813 2475813 defendant Cade John husbandman 610826 610826 Cade, John, of Shenfeld, husbandman 1
5408309 2477454 2477454 defendant Cade John husbandman 610826 610826 Cade, John, of Shenfeld, husbandman 1
5410497 2478084 2478084 defendant Marchall Thomas maltman 610826 610826 Marchall, Thomas, of Shenfeld, maltman 2
5431810 2484482 2484482 defendant Cade John husbandman 610826 610826 Cade, John, of Shenfeld, husbandman 1
5431817 2484483 2484483 defendant Cade John husbandman 610826 610826 Cade, John, of Shenfeld, husbandman 1
5432775 2484770 2484770 defendant Belle Robert laborer 610826 610826 Belle, Robert, of Shenfeld, laborer 0
5466001 2494759 2494759 defendant Stubber John (legal representative) 610826 610826 Stubber, John, of Shenfeld, executrix of 0
5466002 2494759 2494759 defendant Stubber Joan   610826 610826 Stubber, Joan, of Shenfeld 1
5474441 2497337 2497337 defendant Stubber Joan widow 610826 610826 Stubber, Joan, of Shenfeld, widow 1
5484787 2500373 2500373 defendant Marchall Thomas husbandman 610826 610826 Marchall, Thomas, of Shenfeld, husbandman 0
5494714 2503308 2503308 defendant S- Thomas butcher 610826 610826 S-, Thomas, of Shenfeld, butcher 4
5583790 2530006 2530006 plaintiff Glantham Thomas   610826 610826 Glantham, Thomas, of Shenfeld 0
5583792 2530006 2530006 defendant Wygelysworde William husbandman 610826 610826 Wygelysworde, William, of Shenfeld, husbandman 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);