names

42 rows where place_id = 599771

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3638204 1906767 1906767 defendant Wystowe John gent 599771 599771 Wystowe, John, of Pakyngton, gent 0
3643487 1908391 1908391 defendant Wystowe John gent 599771 599771 Wystowe, John, of Pakyngton, gent 0
3714830 1930938 1930938 defendant Shrygley Robert husbandman 599771 599771 Shrygley, Robert, of Pakyngton Prior, husbandman 1
3734558 1937054 1937054 defendant Mason William husbandman 599771 599771 Mason, William, of Pakyngton Prior, husbandman 1
3734559 1937054 1937054 defendant Wotton William husbandman 599771 599771 Wotton, William, of Pakyngton Prior, husbandman 2
3745044 1940358 1940358 plaintiff Boteler Thomas   599771 599771 Boteler, Thomas, of Pakyngton, gent, excutrix of 0
3882032 1984249 1984249 defendant Asten Thomas husbandman 599771 599771 Asten, Thomas, of Pakyngton, husbandman 0
3923698 1998237 1998237 defendant Alen John husbandman 599771 599771 Alen, John, of Pakyngton, husbandman 0
3925992 1999013 1999013 defendant Alyn John husbandman 599771 599771 Alyn, John, of Pakyngton, husbandman 0
4053057 2043522 2043522 defendant Corbett Thomas   599771 599771 Corbett, Thomas, of Pakyngton, brick maker 0
4438575 2181355 2181355 defendant Raulynson Henry   599771 599771 Raulynson, Henry, of Pakyngton 0
4902629 2327442 2327442 defendant Jonson Thomas clerk 599771 599771 Jonson, Thomas, of Pakyngton, clerk 1
4908966 2329349 2329349 defendant atte Cok John tanner 599771 599771 atte Cok, John, of Pakyngton, tanner 0
4908967 2329349 2329349 defendant Osver William butcher 599771 599771 Osver, William, of Pakyngton, butcher 1
4922321 2333394 2333394 defendant Alkyn John   599771 599771 Alkyn, John, of Pakyngton 15
4922322 2333394 2333394 defendant Yngram William   599771 599771 Yngram, William, of Pakyngton 16
4922329 2333394 2333394 defendant Staunton John   599771 599771 Staunton, John, of Pakyngton, mason 23
4934227 2337093 2337093 defendant Pakyngton Ralph gent 599771 599771 Pakyngton, Ralph, of Pakyngton, gent 0
4934230 2337094 2337094 defendant Pakyngton Robert gent 599771 599771 Pakyngton, Robert, of Pakyngton, gent 0
4947470 2341205 2341205 defendant Pynchebek William husbandman 599771 599771 Pynchebek, William, of Pakyngton, husbandman 5
4947471 2341205 2341205 defendant Staunton John husbandman 599771 599771 Staunton, John, of Pakyngton, husbandman 6
5086171 2382351 2382351 defendant Alkyns Robert husbandman 599771 599771 Alkyns, Robert, of Pakyngton, husbandman 0
5131189 2395612 2395612 defendant Wheston Thomas yeoman 599771 599771 Wheston, Thomas, of Pakyngton, yeoman 0
5150701 2401352 2401352 defendant Wheston Thomas yeoman 599771 599771 Wheston, Thomas, of Pakyngton, yeoman 0
5150709 2401353 2401353 defendant Wheston Thomas yeoman 599771 599771 Wheston, Thomas, of Pakyngton, yeoman 0
5156230 2402983 2402983 defendant Wheston Thomas yeoman 599771 599771 Wheston, Thomas, of Pakyngton, yeoman 2
5168836 2406616 2406616 defendant Wheston Thomas yeoman 599771 599771 Wheston, Thomas, of Pakyngton, yeoman 0
5172507 2407684 2407684 defendant Wheston Thomas yeoman 599771 599771 Wheston, Thomas, of Pakyngton, yeoman 2
5191991 2413387 2413387 defendant Wheston Thomas yeoman 599771 599771 Wheston, Thomas, of Pakyngton Prior, yeoman 2
5230577 2424556 2424556 defendant Jonson William husbandman 599771 599771 Jonson, William, of Pakyngton, husbandman 3
5272525 2437038 2437038 defendant Taverner Thomas yeoman 599771 599771 Taverner, Thomas, of Pakyngton, yeoman 1
5386034 2471078 2471078 defendant Leson William yeoman 599771 599771 Leson, William, of Pakyngton, yeoman 1
5406054 2476806 2476806 defendant Mortykoys Thomas yeoman 599771 599771 Mortykoys, Thomas, of Pakyngton Prior, yeoman 0
5419092 2480637 2480637 defendant Mortyboys Thomas yeoman 599771 599771 Mortyboys, Thomas, of Pakyngton Prior, yeoman 0
5447872 2489247 2489247 defendant Dadyngton John husbandman 599771 599771 Dadyngton, John, of Pakyngton, husbandman 0
5448248 2489368 2489368 defendant Gardyner John, senior husbandman 599771 599771 Gardyner, John, senior, of Pakyngton, husbandman 0
5448249 2489368 2489368 defendant Gardyner Roger laborer 599771 599771 Gardyner, Roger, of pakyngton, laborer 1
5448250 2489368 2489368 defendant (illegible) John husbandman 599771 599771 _, John, of Pakyngton, husbandman 2
5510832 2508232 2508232 defendant Blewe Roger yeoman 599771 599771 Blewe, Roger, of Pakyngton, yeoman 0
5510833 2508232 2508232 defendant Blewe John yeoman 599771 599771 Blewe, John, of Pakyngton, yeoman 1
5514490 2509380 2509380 defendant Nicoll Thomas husbandman 599771 599771 Nicoll, Thomas, of Pakyngton, husbandman 1
5514491 2509380 2509380 defendant Morley Thomas husbandman 599771 599771 Morley, Thomas, of Pakyngton, 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);