names

49 rows where place_id = 622112

✎ 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
3745269 1940428 1940428 defendant North William mercer 622112 622112 North, William, of Fenny Stratford, mercer 1
3764693 1946620 1946620 defendant Auste or Anste Roger tanner 622112 622112 Auste or Anste, Roger, of Fenny Stratford, tanner 0
3782675 1952323 1952323 defendant Auste Roger tanner 622112 622112 Auste, Roger, of Fenny Stratford, tanner 1
3782680 1952324 1952324 defendant Auste Roger tanner 622112 622112 Auste, Roger, of Fenny Stratford, tanner 1
3828469 1966778 1966778 plaintiff Chewall William husbandman 622112 622112 Chewall, William, of Fenny Stratford, husbandman 0
3836795 1969408 1969408 defendant Hull John butcher 622112 622112 Hull, John, of Fenny Stratford, butcher 0
3846036 1972320 1972320 defendant Bordes Thomas cooper 622112 622112 Bordes, Thomas, of Fenny Stratford, cooper 0
3888257 1986333 1986333 defendant Grace John miller 622112 622112 Grace, John, of Fenny Stratford, miller 0
3962349 2011415 2011415 defendant Hudson Robert   622112 622112 Hudson, Robert, of Fenny Stratford, Bucks tailor 1
3962352 2011416 2011416 defendant Hudson Robert   622112 622112 Hudson, Robert, of Fenny Stratford, Bucks tailor 1
4173011 2086015 2086015 defendant Shipley William yeoman 622112 622112 Shipley, William, of Fenny Stratford, yeoman 0
4416621 2170067 2170067 defendant Hunt Robert le   622112 622112 Hunt, Robert le, of Fenny Stratford 0
4418241 2170588 2170588 defendant Hunt John   622112 622112 Hunt, John, of Fenny Stratford 0
4424340 2172455 2172455 plaintiff Hunte Nicholas le   622112 622112 Hunte, Nicholas le, of Fenny Stratford 0
4435394 2175824 2175824 defendant Hunt Robert le   622112 622112 Hunt, Robert le, of Fenny Stratford 0
4437269 2176405 2176405 defendant Hunte John le   622112 622112 Hunte, John le, of Fenny Stratford 0
4443687 2182994 2182994 plaintiff Chandeler Richard   622112 622112 Chandeler, Richard, of Fenny Stratford 0
4444056 2183112 2183112 defendant Hayward Geoffrey   622112 622112 Hayward, Geoffrey, of Fenny Stratford 0
4476313 2193255 2193255 defendant Gerlond John pulter or skinner 622112 622112 Gerlond, John, of Fenny Stratford, pulter or skinner 0
4476314 2193255 2193255 defendant Smyth John   622112 622112 Smyth, John, of Fenny Stratford 1
4476317 2193256 2193256 defendant Gerlonde John skinner 622112 622112 Gerlonde, John, of Fenny Stratford, skinner 1
4571464 2222657 2222657 defendant Woketon Thomas   622112 622112 Woketon, Thomas, of Fenny Stratford 0
4676021 2258111 2258111 plaintiff Fysshere Thomas   622112 622112 Fysshere, Thomas, of Fenny Stratford 0
4676022 2258111 2258111 defendant Hawekyn Thomas husbandman 622112 622112 Hawekyn, Thomas, of Fenny Stratford, husbandman 0
4701274 2265799 2265799 defendant Hawekyn Thomas laborer 622112 622112 Hawekyn, Thomas, of Fenny Stratford, laborer 0
4716616 2270516 2270516 defendant atte Halle Thomas husbandman 622112 622112 atte Halle, Thomas, of Fenny Stratford, husbandman 1
4731414 2275025 2275025 defendant Roger John butcher 622112 622112 Roger, John, of Fenny Stratford, butcher 0
4740671 2277790 2277790 defendant Bocher Roger butcher 622112 622112 Bocher, Roger, of Fenny Stratford, butcher 0
4750442 2280611 2280611 defendant Bocher William butcher 622112 622112 Bocher, William, of Fenny Stratford, butcher 0
4777817 2289053 2289053 defendant Herman William shoemaker 622112 622112 Herman, William, of Fenny Stratford, shoemaker 0
4851973 2312051 2312051 defendant Baret Richard yeoman 622112 622112 Baret, Richard, of Fenny Stratford, yeoman 0
4873987 2318802 2318802 defendant Woughton William husbandman 622112 622112 Woughton, William, of Fenny Stratford, husbandman 0
4881334 2321066 2321066 plaintiff Woketon William maltman 622112 622112 Woketon, William, of Fenny Stratford, maltman 0
4885784 2322424 2322424 defendant Draper Lawrence yeoman 622112 622112 Draper, Lawrence, of Fenny Stratford, yeoman 2
4958057 2344375 2344375 plaintiff Woketon William maltman 622112 622112 Woketon, William, of Fenny Stratford, maltman 0
4970095 2348006 2348006 defendant Nassh William hosteler 622112 622112 Nassh, William, of Fenny Stratford, hosteler 2
4984623 2352333 2352333 plaintiff Woketon William maltman 622112 622112 Woketon, William, of Fenny Stratford, maltman 0
4985090 2352467 2352467 defendant Draper Lawrence maltman 622112 622112 Draper, Lawrence, of Fenny Stratford, maltman 3
5000056 2356900 2356900 defendant Draper Lawrence yeoman 622112 622112 Draper, Lawrence, of Fenny Stratford, yeoman 0
5074598 2378905 2378905 defendant Hebbes Roger butcher 622112 622112 Hebbes, Roger, of Fenny Stratford, butcher 0
5105140 2387941 2387941 defendant Fyssher William fisher 622112 622112 Fyssher, William, of Fenny Stratford, fisher 0
5162223 2404680 2404680 defendant Wetherby James yeoman 622112 622112 Wetherby, James, of Fenny Stratford, yeoman 12
5305992 2446781 2446781 plaintiff Maleherbe William yeoman & carpenter 622112 622112 Maleherbe, William, of Fenny Stratford, yeoman & carpenter 0
5305994 2446782 2446782 plaintiff Maleherbe William yeoman & carpenter 622112 622112 Maleherbe, William, of Fenny Stratford, yeoman & carpenter 0
5397190 2474281 2474281 defendant Hobbys Roger yeoman 622112 622112 Hobbys, Roger, of Fenny Stratford, yeoman 1
5440996 2487215 2487215 defendant Glyn Thomas   622112 622112 Glyn, Thomas, of Fenny Stratford 0
5478895 2498708 2498708 defendant Broke William gent 622112 622112 Broke, William, of Fenny Stratford, gent 0
5480764 2499209 2499209 defendant Gannough Hugh yeoman 622112 622112 Gannough, Hugh, of Fenny Stratford, yeoman 0
5558185 2522345 2522345 plaintiff Parke William (legal representative) 622112 622112 Parke, William, of Fenny Stratford, yeoman, executors of 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);