names

66 rows where place_id = 601768

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646925 1909437 1909437 defendant Canon John yeoman 601768 601768 Canon, John, of Harowe, yeoman 0
3646926 1909437 1909437 defendant Walsheman Thomas laborer 601768 601768 Walsheman, Thomas, of Harowe, laborer 1
3646927 1909437 1909437 defendant Canon Richard laborer 601768 601768 Canon, Richard, of Harowe, laborer 2
3646928 1909437 1909437 defendant Canon Lawrence laborer 601768 601768 Canon, Lawrence, of Harowe, laborer 3
3790484 1954847 1954847 plaintiff Webbe John   601768 601768 Webbe, John, of Harowe 0
4593567 2229262 2229262 defendant Bellowe John (legal representative) 601768 601768 Bellowe, John, of Harowe, executor of 5
4593568 2229262 2229262 defendant Bellowe John   601768 601768 Bellowe, John, of Harowe 6
4651665 2246502 2246502 defendant Cornhill Richard husbandman 601768 601768 Cornhill, Richard, of Harowe, husbandman 0
4652636 2246781 2246781 defendant Readynge John husbandman 601768 601768 Readynge, John, of Harowe, husbandman 1
4652637 2246781 2246781 defendant Waps Gilbert husbandman 601768 601768 Waps, Gilbert, of Harowe, husbandman 2
4652638 2246781 2246781 defendant Alfrich John husbandman 601768 601768 Alfrich, John, of Harowe, husbandman 3
4652639 2246781 2246781 defendant Pyryman Richard husbandman 601768 601768 Pyryman, Richard, of Harowe, husbandman 4
4652640 2246781 2246781 defendant Edelyne John husbandman 601768 601768 Edelyne, John, of Harowe, husbandman 5
4652642 2246781 2246781 defendant Denys William husbandman 601768 601768 Denys, William, of Harowe, husbandman 7
4652643 2246781 2246781 defendant Horlok Nicholas husbandman 601768 601768 Horlok, Nicholas, of Harowe, husbandman 8
4652644 2246781 2246781 defendant Rowehed John husbandman 601768 601768 Rowehed, John, of Harowe, husbandman 9
4652645 2246781 2246781 defendant Payn John husbandman 601768 601768 Payn, John, of Harowe, husbandman 10
4652646 2246781 2246781 defendant Vynch John husbandman 601768 601768 Vynch, John, of Harowe, husbandman 11
4652661 2246782 2246782 defendant Reddynge John husbandman 601768 601768 Reddynge, John, of Harowe, husbandman 1
4652662 2246782 2246782 defendant Waps Gilbert husbandman 601768 601768 Waps, Gilbert, of Harowe, husbandman 2
4652663 2246782 2246782 defendant Alfrich John husbandman 601768 601768 Alfrich, John, of Harowe, husbandman 3
4652664 2246782 2246782 defendant Pyryman Richard husbandman 601768 601768 Pyryman, Richard, of Harowe, husbandman 4
4652665 2246782 2246782 defendant Edelyne John husbandman 601768 601768 Edelyne, John, of Harowe, husbandman 5
4652667 2246782 2246782 defendant Denys William husbandman 601768 601768 Denys, William, of Harowe, husbandman 7
4652668 2246782 2246782 defendant Horlok Nicholas husbandman 601768 601768 Horlok, Nicholas, of Harowe, husbandman 8
4652669 2246782 2246782 defendant Rowehed John husbandman 601768 601768 Rowehed, John, of Harowe, husbandman 9
4652670 2246782 2246782 defendant Payn John husbandman 601768 601768 Payn, John, of Harowe, husbandman 10
4652671 2246782 2246782 defendant Vynch John husbandman 601768 601768 Vynch, John, of Harowe, husbandman 11
4652686 2246783 2246783 defendant Asselyn Hugh husbandman 601768 601768 Asselyn, Hugh, of Harowe, husbandman 1
4652687 2246783 2246783 defendant Donner Richard husbandman 601768 601768 Donner, Richard, of Harowe, husbandman 2
4652688 2246783 2246783 defendant Redyng Thomas husbandman 601768 601768 Redyng, Thomas, of Harowe, husbandman 3
4652689 2246783 2246783 defendant Nele John husbandman 601768 601768 Nele, John, of Harowe, husbandman 4
4652690 2246783 2246783 defendant Bouryng John husbandman 601768 601768 Bouryng, John, of Harowe, husbandman 5
4652691 2246783 2246783 defendant Godyng John husbandman 601768 601768 Godyng, John, of Harowe, husbandman 6
4734151 2275861 2275861 defendant Peterwych Hugh laborer 601768 601768 Peterwych, Hugh, of Harowe, laborer 0
4781524 2290232 2290232 defendant Rokkesheth John husbandman 601768 601768 Rokkesheth, John, of Harowe, husbandman 0
4781526 2290233 2290233 defendant Redyng John husbandman 601768 601768 Redyng, John, of Harowe, husbandman 0
4783292 2290794 2290794 defendant Sexteyn John husbandman 601768 601768 Sexteyn, John, of Harowe, husbandman 0
4790596 2293145 2293145 defendant Redyng Thomas husbandman 601768 601768 Redyng, Thomas, of Harowe, husbandman 0
4790597 2293145 2293145 defendant Waps Gilbert husbandman 601768 601768 Waps, Gilbert, of Harowe, husbandman 1
4790598 2293145 2293145 defendant Redyng John husbandman 601768 601768 Redyng, John, of Harowe, husbandman 2
4790599 2293145 2293145 defendant Bowryng John husbandman 601768 601768 Bowryng, John, of Harowe, husbandman 3
4809320 2299089 2299089 defendant Holwey William husbandman 601768 601768 Holwey, William, of Harowe, husbandman 0
4864546 2315884 2315884 defendant Pyle Roger husbandman 601768 601768 Pyle, Roger, of Harowe, husbandman 1
4871213 2317975 2317975 defendant Waspe Richard husbandman 601768 601768 Waspe, Richard, of Harowe, husbandman 2
4871215 2317975 2317975 defendant Blake John husbandman 601768 601768 Blake, John, of Harowe, husbandman 4
4872529 2318367 2318367 defendant Person Stephen husbandman 601768 601768 Person, Stephen, of Harowe, husbandman 1
4890745 2323856 2323856 plaintiff Smyth Hugh husbandman 601768 601768 Smyth, Hugh, of Harowe, husbandman 0
4906144 2328512 2328512 defendant Peryman R- yeoman 601768 601768 Peryman, R-, of Harowe, yeoman 0
4931292 2336164 2336164 defendant Bowryng John, senior husbandman 601768 601768 Bowryng, John, senior, of Harowe, husbandman 3
4956445 2343885 2343885 defendant Clerk John husbandman 601768 601768 Clerk, John, of Harowe, husbandman 0
4956446 2343885 2343885 defendant Williams John husbandman 601768 601768 Williams, John, of Harowe, husbandman 1
4956447 2343885 2343885 defendant Pyreman Richard husbandman 601768 601768 Pyreman, Richard, of Harowe, husbandman 2
5007169 2358987 2358987 defendant Turnour Richard collker 601768 601768 Turnour, Richard, of Harowe, collker 0
5046089 2370457 2370457 defendant Kyng John husbandman 601768 601768 Kyng, John, of Harowe, husbandman 0
5046090 2370457 2370457 defendant Kyng Thomas husbandman 601768 601768 Kyng, Thomas, of Harowe, husbandman 1
5046091 2370457 2370457 defendant Donn or Doun Gilbert smith 601768 601768 Donn or Doun, Gilbert, of Harowe, smith 2
5097976 2385837 2385837 defendant Peryman John yeoman 601768 601768 Peryman, John, of Harowe, yeoman 3
5104736 2387824 2387824 plaintiff Cawche John   601768 601768 Cawche, John, of Harowe 0
5113318 2390288 2390288 plaintiff Kyng Thomas   601768 601768 Kyng, Thomas, of Harowe 0
5358108 2462600 2462600 defendant Wedryall George yeoman 601768 601768 Wedryall, George, of Harowe, yeoman 2
5523398 2512148 2512148 defendant Harres alias Voluntyne Thomas maltman 601768 601768 Harres alias Voluntyne, Thomas, of Harowe, maltman 2
5523401 2512149 2512149 defendant Herres Valentine husbandman 601768 601768 Herres, Valentine, of Harowe, husbandman 1
5523402 2512149 2512149 defendant Harres alias Voluntyne Thomas maltman 601768 601768 Harres alias Voluntyne, Thomas, of Harowe, maltman 2
5533076 2514887 2514887 plaintiff Waren Robert husbandman 601768 601768 Waren, Robert, of Harowe, husbandman 0
5547577 2519310 2519310 defendant Osmond John husbandman 601768 601768 Osmond, John, of Harowe, husbandman 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);