names

50 rows where place_id = 619824

✎ 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
3732108 1936276 1936276 defendant Colyn Richard mercer 619824 619824 Colyn, Richard, of Kendale, mercer 0
3829195 1967013 1967013 defendant Waryner Richard mercer 619824 619824 Waryner, Richard, of Kendale, mercer 1
3832234 1967995 1967995 defendant A Mylne Robert   619824 619824 A Mylne, Robert, of Kendale, cartwright 0
3864335 1978267 1978267 defendant Blande William chapman 619824 619824 Blande, William, of Kendale, chapman 0
4418667 2170711 2170711 defendant Redemane Thomas de   619824 619824 Redemane, Thomas de, of Kendale 0
4418690 2170716 2170716 defendant Burton Roger de   619824 619824 Burton, Roger de, of Kendale, knight 0
4427271 2173362 2173362 plaintiff Roos Thomas de   619824 619824 Roos, Thomas de, of Kendale, knight, son & heir of William de Roos, of Kendale 0
4428268 2173672 2173672 defendant Malkynessone William   619824 619824 Malkynessone, William, of Kendale 0
4428950 2173855 2173855 defendant Ros Thomas de   619824 619824 Ros, Thomas de, of Kendale, knight 0
4430483 2174306 2174306 defendant Redemane Thomas de   619824 619824 Redemane, Thomas de, of Kendale 0
4430499 2174308 2174308 defendant Redmane Thomas de   619824 619824 Redmane, Thomas de, of Kendale 0
4437732 2176554 2176554 defendant Redmane Thomas de   619824 619824 Redmane, Thomas de, of Kendale 0
4446200 2183722 2183722 defendant Coky Adam   619824 619824 Coky, Adam, of Kendale 0
4498719 2200235 2200235 defendant del Brigge Thomas   619824 619824 del Brigge, Thomas, of Kendale 4
4498721 2200235 2200235 defendant Twysaday Robert merchant 619824 619824 Twysaday, Robert, of Kendale, merchant 6
4502596 2201394 2201394 plaintiff Mosser John   619824 619824 Mosser, John, of Kendale 0
4510462 2203732 2203732 defendant Elysman William   619824 619824 Elysman, William, of Kendale 0
4520694 2206821 2206821 defendant Worymer Adam   619824 619824 Worymer, Adam, of Kendale 0
4529600 2209539 2209539 plaintiff Moser John   619824 619824 Moser, John, of Kendale 0
4539120 2212498 2212498 defendant Coke Roger   619824 619824 Coke, Roger, of Kendale 27
4539136 2212498 2212498 defendant Coke William   619824 619824 Coke, William, of Kendale 43
4552482 2216735 2216735 defendant Stodherd Nicholas   619824 619824 Stodherd, Nicholas, of Kendale 0
4552485 2216735 2216735 defendant Brokbank Thomas   619824 619824 Brokbank, Thomas, of Kendale 3
4552486 2216735 2216735 defendant Stveneson William   619824 619824 Stveneson, William, of Kendale 4
4552488 2216735 2216735 defendant Patton Agnes   619824 619824 Patton, Agnes, of Kendale 6
4557726 2218353 2218353 defendant Codlyng Simon   619824 619824 Codlyng, Simon, of Kendale 0
4561191 2219460 2219460 defendant del Wartre John   619824 619824 del Wartre, John, of Kendale 0
4580497 2225387 2225387 defendant Wilkynson Richard   619824 619824 Wilkynson, Richard, of Kendale 0
4589048 2227953 2227953 defendant Lamplugh Adam de   619824 619824 Lamplugh, Adam de, of Kendale 0
4591779 2228783 2228783 plaintiff Moser John   619824 619824 Moser, John, of Kendale 0
4591781 2228784 2228784 plaintiff Moser John   619824 619824 Moser, John, of Kendale 0
4595336 2229793 2229793 defendant Bechum Thomas esq 619824 619824 Bechum, Thomas, of Kendale, esq 1
4595347 2229795 2229795 defendant Bethum Thomas esq 619824 619824 Bethum, Thomas, of Kendale, esq 1
4596465 2230141 2230141 defendant Lek Thomas   619824 619824 Lek, Thomas, of Kendale 3
4604641 2232615 2232615 defendant Marsshall John   619824 619824 Marsshall, John, of Kendale 0
4621077 2237576 2237576 defendant Brydd John   619824 619824 Brydd, John, of Kendale 1
4622658 2238065 2238065 defendant Rowelandson Ellis   619824 619824 Rowelandson, Ellis, of Kendale 2
4643357 2244162 2244162 defendant Corker William   619824 619824 Corker, William, of Kendale 0
4645052 2244622 2244622 defendant Brade William   619824 619824 Brade, William, of Kendale 4
4647086 2245204 2245204 defendant Bavysdale Robert   619824 619824 Bavysdale, Robert, of Kendale 5
4659297 2248774 2248774 defendant de Moyser William husbandman 619824 619824 de Moyser, William, of Kendale, husbandman 5
4659298 2248774 2248774 defendant Hirde Robert husbandman 619824 619824 Hirde, Robert, of Kendale, husbandman 6
4660754 2249188 2249188 plaintiff Dezhate John   619824 619824 Dezhate, John, of Kendale 0
4717416 2270785 2270785 defendant Lamplough Adam draper 619824 619824 Lamplough, Adam, of Kendale, draper 1
4806082 2298108 2298108 defendant Shiphird William yeoman 619824 619824 Shiphird, William, of Kendale, yeoman 2
4834450 2306781 2306781 defendant Kendale John de yeoman 619824 619824 Kendale, John de, of Kendale, son of William de Kendale, of Holtons Lane, yeoman 1
4851359 2311872 2311872 defendant del Watre Thomas yeoman 619824 619824 del Watre, Thomas, of Kendale, yeoman 1
4879333 2320466 2320466 defendant del Watre Thomas yeoman 619824 619824 del Watre, Thomas, of Kendale, yeoman 1
5112716 2390108 2390108 defendant Staynbank Edmund husbandman 619824 619824 Staynbank, Edmund, of Kendale, husbandman 1
5112717 2390108 2390108 defendant Harrysondenyson William husbandman 619824 619824 Harrysondenyson, William, of Kendale, 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);