names

50 rows where place_id = 630995

✎ 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
3797835 1957218 1957218 defendant Holbroke John fuller 630995 630995 Holbroke, John, of Pensford, fuller 0
4119732 2067346 2067346 defendant Magges Thomas yeoman 630995 630995 Magges, Thomas, of Pensford, yeoman 0
4215463 2100902 2100902 defendant Rudge John tanner 630995 630995 Rudge, John, of Pensford, tanner 0
4262038 2116980 2116980 defendant Bisse Thomas clothier 630995 630995 Bisse, Thomas, of Pensford, clothier 0
4358669 2150269 2150269 defendant Morse alias Lumly Henry shoemaker 630995 630995 Morse alias Lumly, Henry, of Pensford, shoemaker 3
4465673 2189940 2189940 plaintiff Wyke John   630995 630995 Wyke, John, of Pensford 0
4496255 2199502 2199502 plaintiff Colchestre John   630995 630995 Colchestre, John, of Pensford 0
4496257 2199502 2199502 defendant Test Robert   630995 630995 Test, Robert, of Pensford 1
4500359 2200734 2200734 defendant Spencer John   630995 630995 Spencer, John, of Pensford 1
4511557 2204064 2204064 defendant Forster William dyer 630995 630995 Forster, William, of Pensford, dyer 0
4520704 2206825 2206825 plaintiff Forster William   630995 630995 Forster, William, of Pensford 0
4520707 2206825 2206825 defendant Austyn Richard   630995 630995 Austyn, Richard, of Pensford 2
4527022 2208734 2208734 defendant Shawe John   630995 630995 Shawe, John, of Pensford 0
4541664 2213289 2213289 defendant Dyer Thomas   630995 630995 Dyer, Thomas, of Pensford 0
4541665 2213289 2213289 defendant Porter Robert   630995 630995 Porter, Robert, of Pensford 1
4541666 2213289 2213289 defendant Doune Henry   630995 630995 Doune, Henry, of Pensford 2
4541667 2213289 2213289 defendant Shawe Thomas   630995 630995 Shawe, Thomas, of Pensford 3
4554874 2217452 2217452 defendant Reymond Thomas   630995 630995 Reymond, Thomas, of Pensford 0
4554875 2217452 2217452 defendant Langhert John   630995 630995 Langhert, John, of Pensford 1
4578195 2224676 2224676 defendant Clers Robert   630995 630995 Clers, Robert, of Pensford 0
4583020 2226113 2226113 defendant Tastour Robert   630995 630995 Tastour, Robert, of Pensford 3
4583025 2226114 2226114 defendant Tastour Robert   630995 630995 Tastour, Robert, of Pensford 2
4588497 2227771 2227771 defendant Neweman John, sen   630995 630995 Neweman, John, sen, of Pensford 0
4598431 2230745 2230745 defendant Wyke Nicholas   630995 630995 together with Wyke, Nicholas, of Pensford 2
4598483 2230762 2230762 defendant Diere Robert   630995 630995 Diere, Robert, of Pensford 3
4622889 2238139 2238139 defendant Wastell John   630995 630995 Wastell, John, of Pensford 1
4645147 2244649 2244649 defendant atte Mulle John   630995 630995 atte Mulle, John, of Pensford 5
4692581 2263196 2263196 defendant Hendy John weaver 630995 630995 Hendy, John, of Pensford, weaver 0
4697455 2264693 2264693 defendant Drake John dyer 630995 630995 Drake, John, of Pensford, dyer 1
4697456 2264693 2264693 defendant Radewey John weaver 630995 630995 Radewey, John, of Pensford, weaver 2
4735627 2276294 2276294 defendant Mabby John dyer 630995 630995 Mabby, John, of Pensford, dyer 0
4735629 2276294 2276294 defendant Wastell John butcher 630995 630995 Wastell, John, of Pensford, butcher 2
4763376 2284532 2284532 defendant Hendy John weaver 630995 630995 Hendy, John, of Pensford, weaver 3
4787109 2292030 2292030 defendant Hendy John weaver 630995 630995 Hendy, John, of Pensford, weaver 3
4873170 2318559 2318559 defendant Colles John clothmaker 630995 630995 Colles, John, of Pensford, clothmaker 1
4900830 2326890 2326890 defendant Kyngton John hosteler 630995 630995 Kyngton, John, of Pensford, hosteler 0
4938283 2338353 2338353 defendant Lavynder John baker 630995 630995 Lavynder, John, of Pensford, baker 2
4994854 2355312 2355312 defendant Whitenowe John   630995 630995 Whitenowe, John, of Pensford, cloth maker 4
5056950 2373655 2373655 defendant Smyth William smith 630995 630995 Smyth, William, of Pensford, smith 0
5202238 2416418 2416418 defendant Lavender John baker 630995 630995 Lavender, John, of Pensford, baker 0
5330594 2454242 2454242 defendant Andrew William weaver 630995 630995 Andrew, William, of Pensford, weaver 0
5358578 2462742 2462742 plaintiff Petegrewe John   630995 630995 Petegrewe, John, of Pensford 0
5368633 2465786 2465786 defendant Veysy alias Frier John butcher 630995 630995 Veysy alias Frier, John, of Pensford, butcher 0
5463122 2493884 2493884 defendant Lavynder John clothier 630995 630995 Lavynder, John, of Pensford, clothier 0
5486295 2500790 2500790 defendant Fliet Richard clothier 630995 630995 Fliet, Richard, of Pensford, clothier 0
5509804 2507900 2507900 defendant Laterigge Thomas clothier 630995 630995 Laterigge, Thomas, of Pensford, clothier 2
5514881 2509500 2509500 defendant Walsheman John tailor 630995 630995 Walsheman, John, of Pensford, tailor 0
5533759 2515106 2515106 defendant Lavender Thomas tucker 630995 630995 Lavender, Thomas, of Pensford, tucker 0
5583517 2529915 2529915 defendant Cork Richard tucker 630995 630995 Cork, Richard, of Pensford, tucker 0
5600586 2535076 2535076 defendant Phylyppes William butcher 630995 630995 Phylyppes, William, of Pensford, butcher 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);