names

53 rows where place_id = 611509

✎ 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
3688695 1922625 1922625 defendant Reve Thomas husbandman 611509 611509 Reve, Thomas, of Sutton Valence, husbandman 4
3717334 1931705 1931705 defendant Reve Thomas husbandman 611509 611509 Reve, Thomas, of Sutton Valence, husbandman 0
3717335 1931705 1931705 defendant Lomeherst John husbandman 611509 611509 Lomeherst, John, of Sutton Valence, husbandman 1
3741952 1939350 1939350 defendant Cheseman Robert husbandman 611509 611509 Cheseman, Robert, of Sutton Valence, husbandman 0
3746936 1940960 1940960 defendant Hepey Randolph weaver 611509 611509 Hepey, Randolph, of Sutton Valence, weaver 2
3747990 1941290 1941290 defendant Iden William gent 611509 611509 Iden, William, of Sutton Valence, gent 0
3747991 1941290 1941290 defendant Frankwell Matthew laborer 611509 611509 Frankwell, Matthew, of Sutton Valence, laborer 1
3747992 1941290 1941290 defendant Lodynden Richard laborer 611509 611509 Lodynden, Richard, of Sutton Valence, laborer 2
3747993 1941290 1941290 defendant Carpenter John laborer 611509 611509 Carpenter, John, of Sutton Valence, laborer 3
3778379 1950952 1950952 defendant Clyfford Lewis (legal representative) 611509 611509 Clyfford, Lewis, of Sutton Valence, esq, executors of 0
3829903 1967244 1967244 defendant Joce John butcher 611509 611509 Joce, John, of Sutton Valence, butcher 1
3848420 1973083 1973083 plaintiff Iden William gent 611509 611509 Iden, William, of Sutton Valence, gent 0
3861443 1977288 1977288 defendant Dunnyng Stephen husbandman 611509 611509 Dunnyng, Stephen, of Sutton Valence, husbandman 2
3866200 1978924 1978924 defendant Clerk Thomas shoemaker 611509 611509 Clerk, Thomas, of Sutton Valence, shoemaker 0
3866201 1978924 1978924 defendant Whitte Robert husbandman 611509 611509 Whitte, Robert, of Sutton valence, husbandman 1
4000146 2024821 2024821 defendant Goldesmythe Robert tailor 611509 611509 Goldesmythe, Robert, of Sutton Valence, tailor 0
4000147 2024821 2024821 defendant Jefferay Richard husbandman 611509 611509 Jefferay, Richard, of Sutton Valence, husbandman 1
4007407 2027431 2027431 defendant Iseley William esq 611509 611509 Iseley, William, of Sutton Valence, esq 0
4015895 2030373 2030373 defendant Stydolff Edmund husbandman 611509 611509 Stydolff, Edmund, of Sutton Valence, husbandman 0
4020257 2031965 2031965 defendant Baker Thomas glover 611509 611509 Baker, Thomas, of Sutton Valence, glover 0
4149673 2078011 2078011 defendant Budd Thomas shoemaker 611509 611509 Budd, Thomas, of Sutton Valence, shoemaker 1
4153980 2079486 2079486 defendant Wood Cheyney clothier 611509 611509 Wood, Cheyney, of Sutton Valence, clothier 0
4282361 2123730 2123730 defendant Swaynland Nicholas shoemaker 611509 611509 Swaynland, Nicholas, of Sutton Valence, shoemaker 0
4453997 2186266 2186266 plaintiff Lomherst Stephen de   611509 611509 Lomherst, Stephen de, of Sutton Valence, mason 0
4485971 2196318 2196318 plaintiff Roger William   611509 611509 Roger, William, of Sutton Valence 0
4694933 2263907 2263907 defendant Romden John laborer 611509 611509 Romden, John, of Sutton Valence, laborer 0
4694934 2263907 2263907 defendant Smyth John laborer 611509 611509 Smyth, John, of Sutton Valence, laborer 1
4700443 2265552 2265552 defendant Alby John laborer 611509 611509 Alby, John, of Sutton Valence, laborer 1
4703128 2266355 2266355 defendant Roger William husbandman 611509 611509 Roger, William, of Sutton Valence, husbandman 1
4719462 2271432 2271432 plaintiff Blake Thomas (legal representative) 611509 611509 Blake, Thomas, of Sutton Valence, executors of 0
4744958 2279039 2279039 defendant Graunge William laborer 611509 611509 Graunge, William, of Sutton Valence, laborer 2
4755221 2282021 2282021 plaintiff atte Bregge Stephen   611509 611509 atte Bregge, Stephen, of Sutton Valence 1
4770856 2286865 2286865 plaintiff Rogger William   611509 611509 Rogger, William, of Sutton Valence 0
4807651 2298584 2298584 defendant Hadde John husbandman 611509 611509 Hadde, John, of Sutton Valence, husbandman 0
4867571 2316828 2316828 defendant atte Bregge Simon husbandman 611509 611509 atte Bregge, Simon, of Sutton Valence, husbandman 0
4867574 2316829 2316829 defendant atte Bregge Simon husbandman 611509 611509 atte Bregge, Simon, of Sutton Valence, husbandman 0
4907241 2328828 2328828 defendant Sampson Thomas laborer 611509 611509 Sampson, Thomas, of Sutton Valence, laborer 1
4907928 2329037 2329037 defendant Croche Richard laborer 611509 611509 Croche, Richard, of Sutton Valence, laborer 1
4981512 2351381 2351381 defendant Alderchirche William tailor 611509 611509 Alderchirche, William, of Sutton Valence, tailor 2
4997539 2356116 2356116 defendant Colyn John laborer 611509 611509 Colyn, John, of Sutton Valence, laborer 1
5081425 2380948 2380948 defendant Clerk William husbandman 611509 611509 togeter with Clerk, William, of Sutton Valence, husbandman 2
5273867 2437438 2437438 plaintiff Norton Stephen, senior   611509 611509 Norton, Stephen, senior, of Sutton Valence 0
5307976 2447402 2447402 defendant Rede Robert dyer 611509 611509 Rede, Robert, of Sutton Valence, dyer 1
5358737 2462793 2462793 defendant Elneregge John clothmaker 611509 611509 Elneregge, John, of Sutton Valence, clothmaker 2
5409543 2477818 2477818 defendant Hadde William husbandman 611509 611509 Hadde, William, of Sutton Valence, husbandman 0
5434617 2485290 2485290 plaintiff Parke William yeoman 611509 611509 Parke, William, of Sutton Valence, yeoman 0
5449955 2489875 2489875 plaintiff Parke William yeoman 611509 611509 Parke, William, of Sutton Valence, yeoman 0
5485097 2500464 2500464 plaintiff Parke William yeoman 611509 611509 Parke, William, of Sutton Valence, yeoman 0
5511296 2508375 2508375 defendant Etherst Thomas butcher 611509 611509 Etherst, Thomas, of Sutton Valence, butcher 1
5529467 2513724 2513724 defendant Byxe John butcher 611509 611509 Byxe, John, of Sutton Valence, butcher 2
5532133 2514593 2514593 defendant Byx John butcher 611509 611509 Byx, John, of Sutton Valence, butcher 2
5543515 2518085 2518085 defendant Bix John butcher 611509 611509 Bix, John, of Sutton Valence, butcher 1
5571551 2526236 2526236 defendant Reader Nicholas husbandman 611509 611509 Reader, Nicholas, of Sutton Valence, 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);