names

36 rows where place_id = 637449

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3836583 1969345 1969345 defendant Hobbys John clerk 637449 637449 Hobbys, John, of Alderford, clerk 1
3852675 1974443 1974443 defendant Hobbys John clerk 637449 637449 Hobbys, John, of Alderford, clerk 1
3998635 2024248 2024248 defendant Joyeler Richard husbandman 637449 637449 Joyeler, Richard, of Alderford, husbandman 1
4080644 2053391 2053391 defendant Rookewoode William gent 637449 637449 Rookewoode, William, of Alderford, gent 3
4087090 2055676 2055676 defendant Jennyng John esq 637449 637449 Jennyng, John, of Alderford, esq 0
4218176 2101857 2101857 defendant Monyman Elizabeth widow 637449 637449 Monyman, Elizabeth, of Alderford, widow 3
4257028 2115324 2115324 defendant Bennett George   637449 637449 Bennett, George, of Alderford, worsted weaver 2
4329773 2140253 2140253 defendant Allen Stephen yeoman 637449 637449 Allen, Stephen, of Alderford, yeoman 1
4347840 2146495 2146495 defendant Downes John gent 637449 637449 Downes, John, of Alderford, gent 0
4559721 2218992 2218992 defendant Dowene Thomas   637449 637449 Dowene, Thomas, of Alderford 0
4657456 2248223 2248223 defendant Mileton William gent 637449 637449 Mileton, William, of Alderford, gent 1
4696120 2264269 2264269 defendant Prallyng John   637449 637449 Prallyng, John, of Alderford, shoe maker 2
4808430 2298812 2298812 defendant Jakes Thomas husbandman 637449 637449 Jakes, Thomas, of Alderford, husbandman 0
4873022 2318521 2318521 defendant Brolle John yeoman 637449 637449 Brolle, John, of Alderford, yeoman 0
4888504 2323202 2323202 defendant Mekylhill John husbandman 637449 637449 Mekylhill, John, of Alderford, husbandman 0
4970363 2348082 2348082 defendant Fray William husbandman 637449 637449 Fray, William, of Alderford, husbandman 9
4988891 2353630 2353630 defendant Mikilhill John husbandman 637449 637449 Mikilhill, John, of Alderford, husbandman 0
5008404 2359349 2359349 defendant Piers Simon husbandman 637449 637449 Piers, Simon, of Alderford, husbandman 0
5040199 2368667 2368667 defendant Mykylhill John, senior yeoman 637449 637449 Mykylhill, John, senior, of Alderford, yeoman 2
5071334 2377920 2377920 defendant Angoos John laborer 637449 637449 Angoos, John, of Alderford, laborer 3
5100856 2386665 2386665 plaintiff Aleyn William   637449 637449 Aleyn, William, of Alderford 0
5177974 2409264 2409264 plaintiff Aleyn William   637449 637449 Aleyn, William, of Alderford 0
5225582 2423154 2423154 defendant Frary John yeoman 637449 637449 Frary, John, of Alderford, yeoman 7
5263586 2434359 2434359 defendant Frary John husbandman 637449 637449 Frary, John, of Alderford, husbandman 3
5308957 2447725 2447725 defendant Dallyng Nicholas clerk 637449 637449 Dallyng, Nicholas, of Alderford, clerk 1
5317462 2450308 2450308 defendant Dallyng Nicholas clerk 637449 637449 Dallyng, Nicholas, of Alderford, clerk 0
5328454 2453584 2453584 defendant Frary Margaret (legal representative) 637449 637449 Frary, Margaret, of Alderford, widow, executor of 0
5331960 2454635 2454635 plaintiff Carter Geoffrey (legal representative) 637449 637449 Carter, Geoffrey, of Alderford, executor of Carter, John, of Boton, executors of 0
5465393 2494558 2494558 defendant Aleyn John husbandman 637449 637449 Aleyn, John, of Alderford, husbandman 2
5489047 2501599 2501599 defendant Dallyng Nicholas clerk 637449 637449 Dallyng, Nicholas, of Alderford, clerk 0
5497236 2504112 2504112 defendant Dallyng Nicholas clerk 637449 637449 Dallyng, Nicholas, of Alderford, clerk 0
5497245 2504113 2504113 defendant Dallyng Nicholas clerk 637449 637449 together with Dallyng, Nicholas, of Alderford, clerk 1
5502011 2505551 2505551 defendant Dallyng Nicholas clerk 637449 637449 Dallyng, Nicholas, of Alderford, clerk 0
5503708 2506075 2506075 plaintiff Wolman Thomas (legal representative) 637449 637449 Wolman, Thomas, of Alderford, or of Norwich, gent, executors of 0
5503714 2506076 2506076 plaintiff Wolman Thomas (legal representative) 637449 637449 Wolman, Thomas, of Alderford, or of Norwich, gent, executors of 0
5567276 2525006 2525006 defendant Wulman Thomas yeoman 637449 637449 Wulman, Thomas, of Alderford, yeoman 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);