names

37 rows where place_id = 658136

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3947169 2006076 2006076 plaintiff Clark James (legal representative) 658136 658136 Clark, James, of Est Bergholte, clothmaker, executor of 0
3947172 2006076 2006076 defendant Mark James clothier 658136 658136 Mark, James, of Est Bergholte, clothier 1
3976928 2016493 2016493 defendant Fryer Nicholas clothier 658136 658136 Fryer, Nicholas, of Est Bergholte, clothier 13
4198938 2095185 2095185 defendant Daynes John clothier 658136 658136 Daynes, John, of East Bergholte, clothier 1
4198939 2095185 2095185 defendant Letton Thomas clothier 658136 658136 Letton, Thomas, of East Bergholte, clothier 2
4198943 2095186 2095186 defendant Rigges Robert clothier 658136 658136 Rigges, Robert, of East Bergholte, clothier 2
4198944 2095186 2095186 defendant Markes Walter clothier 658136 658136 Markes, Walter, of East Bergholte, clothier 3
4236539 2108353 2108353 defendant Lewes Christopher clothier 658136 658136 Lewes, Christopher, of Est Bergholte, clothier 0
4308293 2133050 2133050 defendant Culpecke Joshua weaver 658136 658136 Culpecke, Joshua, of Est Bergholte, weaver 0
4326187 2139128 2139128 defendant Wellocke Henry weaver 658136 658136 Wellocke, Henry, of Est Bergholte, weaver 0
4326188 2139128 2139128 defendant Mylles John sherman 658136 658136 Mylles, John, of Est Bergholte, sherman 1
4326189 2139128 2139128 defendant Wyles John husbandman 658136 658136 Wyles, John, of Est Bergholte, husbandman 2
4326191 2139128 2139128 defendant Martyn Alice widow 658136 658136 Martyn, Alice, of Est Bergholte, widow 4
4333328 2141429 2141429 defendant Newton Edmund clothmaker 658136 658136 Newton, Edmund, of Est Bergholte, clothmaker 2
4342979 2144819 2144819 defendant Lewes Thomas clothier 658136 658136 Lewes, Thomas, of Est Bergholte, clothier 0
4390388 2161409 2161409 defendant Kettle John yeoman 658136 658136 Kettle, John, of East Bergholte, yeoman 1
4559247 2218847 2218847 defendant Waldoun John   658136 658136 Waldoun, John, of East Bergholte 1
4569237 2221965 2221965 defendant Waldoune John   658136 658136 Waldoune, John, of East Bergholte 0
4571723 2222736 2222736 plaintiff Andrewe Thomas   658136 658136 Andrewe, Thomas, of East Bergholte 0
4571724 2222736 2222736 defendant Cuckok William   658136 658136 Cuckok, William, of East Bergholte 0
4648679 2245667 2245667 defendant Waldoune John butcher 658136 658136 Waldoune, John, of East Bergholte, butcher 2
4686464 2261371 2261371 defendant Hervy William   658136 658136 Hervy, William, of East Bergholte 0
4774328 2287952 2287952 plaintiff Tynte Simon   658136 658136 Tynte, Simon, of East Bergholte 0
4774333 2287953 2287953 plaintiff Tynte Simon   658136 658136 Tynte, Simon, of East Bergholte 0
4807621 2298575 2298575 defendant Brook William husbandman 658136 658136 Brook, William, of East Bergholte, husbandman 0
5030223 2365710 2365710 defendant Broke William husbandman 658136 658136 Broke, William, of Est Bergholte, husbandman 0
5030224 2365710 2365710 defendant Tepe Walter husbandman 658136 658136 Tepe, Walter, of Est Bergholte, husbandman 1
5059885 2374523 2374523 defendant Sowetherne Thomas fuller 658136 658136 Sowetherne, Thomas, of Est Bergholte, fuller 0
5127841 2394619 2394619 defendant Peverell William clothmaker 658136 658136 Peverell, William, of East Bergholte, clothmaker 1
5143737 2399299 2399299 defendant Hakon Alice widow 658136 658136 (Hakon, Alice, of East Bergholte, widow 2
5151300 2401529 2401529 plaintiff Gravener Thomas (legal representative) 658136 658136 Gravener, Thomas, of East Bergholte, executor of 0
5169481 2406812 2406812 plaintiff Gravener Thomas (legal representative) 658136 658136 Gravener, Thomas, of East Bergholte, executor of 0
5186329 2411755 2411755 plaintiff Gravener Thomas (legal representative) 658136 658136 Gravener, Thomas, of East Bergholte, executor of 0
5239088 2427025 2427025 plaintiff Cole John   658136 658136 Cole, John, of Est Bergholte 3
5259158 2432980 2432980 defendant Peverell Richard clothmaker 658136 658136 Peverell, Richard, of Est Bergholte, clothmaker 0
5259159 2432980 2432980 defendant Arnold William husbandman 658136 658136 Arnold, William, of Est Bergholte, husbandman 1
5259160 2432980 2432980 defendant Peverell William, junior husbandman 658136 658136 Peverell, William, junior, of Est Bergholte, husbandman 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);