names

54 rows where place_id = 630008

✎ 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
3791980 1955342 1955342 defendant Bener or Bever John yeoman 630008 630008 Bener or Bever, John, of Kynges Clere, yeoman 0
3793022 1955676 1955676 defendant Nutt John husbandman 630008 630008 Nutt, John, of Kynges Clere, husbandman 0
3843439 1971484 1971484 defendant Wygmore William husbandman 630008 630008 Wygmore, William, of Kynges Clere, husbandman 0
3843536 1971516 1971516 defendant Wygmore William husbandman 630008 630008 Wygmore, William, of Kynges Clere, husbandman 0
3989230 2020888 2020888 defendant Boswell John   630008 630008 Boswell, John, of Kynges Clere, Hants gent 0
4433206 2175137 2175137 defendant White Richard le   630008 630008 White, Richard le, of Kynges Clere 0
4470982 2191579 2191579 defendant Baron Thomas   630008 630008 Baron, Thomas, of Kynges Clere 0
4526813 2208664 2208664 plaintiff Lauerance John (legal representative) 630008 630008 Lauerance, John, of Kynges Clere, formerly vicar, executors of 0
4557572 2218302 2218302 defendant Faukener William   630008 630008 Faukener, William, of Kynges Clere 0
4557574 2218303 2218303 defendant Fauconere William   630008 630008 Fauconere, William, of Kynges Clere 0
4573444 2223225 2223225 plaintiff Barne William   630008 630008 Barne, William, of Kynges Clere 0
4578823 2224859 2224859 defendant Byenham Philip   630008 630008 Byenham, Philip, of Kynges Clere 0
4610782 2234444 2234444 plaintiff Chapman Robert   630008 630008 Chapman, Robert, of Kynges Clere 0
4611277 2234591 2234591 defendant Archer William   630008 630008 Archer, William, of Kynges Clere 0
4626238 2239164 2239164 defendant Savage William   630008 630008 Savage, William, of Kynges Clere 0
4642043 2243781 2243781 defendant Bele John   630008 630008 Bele, John, of Kynges Clere 0
4642045 2243782 2243782 defendant Chaundeler Robert   630008 630008 Chaundeler, Robert, of Kynges Clere 0
4644524 2244486 2244486 defendant Smyth Simon   630008 630008 (Smyth, Simon, of Kynges Clere 1
4648463 2245598 2245598 defendant Waleys John   630008 630008 Waleys, John, of Kynges Clere 0
4676578 2258291 2258291 defendant Kachefrensh William husbandman 630008 630008 Kachefrensh, William, of Kynges Clere, husbandman 1
4684224 2260670 2260670 plaintiff Preest Thomas   630008 630008 Preest, Thomas, of Kynges Clere 0
4689232 2262192 2262192 defendant Wheler Thomas husbandman 630008 630008 Wheler, Thomas, of Kynges Clere, husbandman 0
4691218 2262772 2262772 defendant Heryng John husbandman 630008 630008 Heryng, John, of Kynges Clere, husbandman 4
4724623 2273001 2273001 plaintiff Fauconer William (legal representative) 630008 630008 Fauconer, William, of Kynges Clere, executors of 0
4724626 2273002 2273002 plaintiff Fauconer William (legal representative) 630008 630008 Fauconer, William, of Kynges Clere, executors of 0
4733071 2275521 2275521 plaintiff Preest Thomas   630008 630008 Preest, Thomas, of Kynges Clere 0
4761543 2283954 2283954 defendant Heryng William husbandman 630008 630008 Heryng, William, of Kynges Clere, husbandman 0
4764464 2284870 2284870 defendant Trullay Stephen skinner 630008 630008 Trullay, Stephen, of Kynges Clere, skinner 0
4764465 2284870 2284870 defendant Stilman John husbandman 630008 630008 Stilman, John, of Kynges Clere, husbandman 1
4764466 2284870 2284870 defendant Webbe Richard husbandman 630008 630008 Webbe, Richard, of Kynges Clere, husbandman 2
4764470 2284870 2284870 defendant Seman Thomas husbandman 630008 630008 Seman, Thomas, of Kynges Clere, husbandman 6
4764471 2284870 2284870 defendant Mate William husbandman 630008 630008 Mate, William, of Kynges Clere, husbandman 7
4851655 2311952 2311952 defendant Taillour Walter   630008 630008 Taillour, Walter, of Kynges Clere, bailiff 3
4851660 2311953 2311953 defendant Taillour Walter   630008 630008 Taillour, Walter, of Kynges Clere, bailiff 3
4919038 2332466 2332466 defendant Seman Thomas   630008 630008 Seman, Thomas, of Kynges Clere, milward 0
4920263 2332853 2332853 defendant Smyth John husbandman 630008 630008 Smyth, John, of Kynges Clere, husbandman 1
4930623 2335984 2335984 defendant Gyddale Walter tailor 630008 630008 Gyddale, Walter, of Kynges Clere, tailor 2
4993497 2354926 2354926 defendant Gille John   630008 630008 Gille, John, of Kynges Clere, servant 0
4995161 2355404 2355404 defendant Humbre John weaver 630008 630008 Humbre, John, of Kynges Clere, weaver 0
4997235 2356026 2356026 plaintiff Heryng John clerk & vicar 630008 630008 Heryng John, of Kynges Clere, clerk & vicar 0
4997236 2356026 2356026 defendant Colyer alias Turner William collier 630008 630008 Colyer alias Turner, William, of Kynges Clere, collier 0
4997240 2356028 2356028 plaintiff Heryng John   630008 630008 Heryng, John, of Kynges Clere, perpetual vicar & clerk 0
4997241 2356028 2356028 defendant Colyer alias Turner William collier 630008 630008 Colyer alias Turner, William, of Kynges Clere, collier 0
5134748 2396662 2396662 defendant More William tanner 630008 630008 More, William, of Kynges Clere, tanner 0
5134749 2396662 2396662 defendant Cade Robert weaver 630008 630008 Cade, Robert, of Kynges Clere, weaver 1
5134750 2396662 2396662 defendant Colyer John butcher 630008 630008 Colyer, John, of Kynges Clere, butcher 2
5140048 2398193 2398193 defendant Faconer Richard gent 630008 630008 Faconer, Richard, of Kynges Clere, gent 1
5152641 2401912 2401912 defendant Borgh John yeoman 630008 630008 Borgh, John, of Kynges Clere, yeoman 2
5207494 2417934 2417934 defendant Borogh John yeoman 630008 630008 Borogh, John, of Kynges Clere, yeoman 1
5207526 2417943 2417943 defendant Burgh John yeoman 630008 630008 Burgh, John, of Kynges Clere, yeoman 0
5299313 2444772 2444772 defendant Bokelond John butcher 630008 630008 Bokelond, John, of Kynges Clere, butcher 0
5299314 2444772 2444772 defendant Brontysdon Thomas husbandman 630008 630008 Brontysdon, Thomas, of Kynges Clere, husbandman 1
5365964 2465012 2465012 defendant Wedowesson John husbandman 630008 630008 Wedowesson, John, of Kynges Clere, husbandman 0
5491838 2502465 2502465 defendant Seman Nicholas smith 630008 630008 Seman, Nicholas, of Kynges Clere, smith 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);