names

42 rows where place_id = 596873

✎ 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
3626477 1903137 1903137 defendant Warffe Thomas yeoman 596873 596873 Warffe, Thomas, of Dunstall, yeoman 0
3698845 1925856 1925856 defendant Yate William husbandman 596873 596873 Yate, William, of Dunstall, husbandman 2
3733838 1936836 1936836 defendant Lethum Thomas yeoman 596873 596873 Lethum, Thomas, of Dunstall, yeoman 1
3760846 1945395 1945395 defendant Lethum Thomas yeoman 596873 596873 Lethum, Thomas, of Dunstall, yeoman 0
3760850 1945396 1945396 defendant Lethum Thomas yeoman 596873 596873 Lethum, Thomas, of Dunstall, yeoman 0
3761624 1945648 1945648 defendant Lethome Thomas yeoman 596873 596873 Lethome, Thomas, of Dunstall, yeoman 1
3761636 1945652 1945652 defendant Lethome Thomas yeoman 596873 596873 Lethome, Thomas, of Dunstall, yeoman 0
3761639 1945653 1945653 defendant Lethome Thomas yeoman 596873 596873 Lethome, Thomas, of Dunstall, yeoman 0
3761715 1945674 1945674 defendant Tromes Richard husbandman 596873 596873 Tromes, Richard, of Dunstall, husbandman 0
3779844 1951429 1951429 defendant Tremys Richard husbandman 596873 596873 Tremys, Richard, of Dunstall, husbandman 0
3780112 1951505 1951505 defendant Naylour Robert husbandman 596873 596873 Naylour, Robert, of Dunstall, husbandman 0
3796813 1956883 1956883 defendant Sutton William husbandman 596873 596873 Sutton, William, of Dunstall, husbandman 2
3807076 1960106 1960106 defendant Colyn William chaplain 596873 596873 Colyn, William, of Dunstall, chaplain 0
3822063 1964794 1964794 defendant Glasyer John husbandman 596873 596873 Glasyer, John, of Dunstall, husbandman 2
3912972 1994672 1994672 defendant Drake Thomas butcher 596873 596873 Drake, Thomas, of Dunstall, butcher 0
3951834 2007703 2007703 defendant Raynold Peter husbandman 596873 596873 Raynold, Peter, of Dunstall, husbandman 1
4441420 2182258 2182258 defendant Poyntel Walter   596873 596873 Poyntel, Walter, of Dunstall 0
4607742 2233532 2233532 defendant Femmyng John   596873 596873 Femmyng, John, of Dunstall 0
4722391 2272322 2272322 defendant Bolunhull John husbandman 596873 596873 Bolunhull, John, of Dunstall, husbandman 0
4809439 2299129 2299129 defendant Hychyn Richard husbandman 596873 596873 Hychyn, Richard, of Dunstall, husbandman 1
4855617 2313124 2313124 plaintiff atte Gore Walter   596873 596873 atte Gore, Walter, of Dunstall 0
5033617 2366717 2366717 defendant Lynnys Richard yeoman 596873 596873 Lynnys, Richard, of Dunstall, yeoman 3
5033618 2366717 2366717 defendant Malop William yeoman 596873 596873 Malop, William, of Dunstall, yeoman 4
5033619 2366717 2366717 defendant Wryght Henry yeoman 596873 596873 Wryght, Henry, of Dunstall, yeoman 5
5033620 2366717 2366717 defendant More Richard yeoman 596873 596873 More, Richard, of Dunstall, yeoman 6
5033622 2366717 2366717 defendant Nuttyng Richard yeoman 596873 596873 Nuttyng, Richard, of Dunstall, yeoman 8
5037127 2367733 2367733 defendant atte Hacche Stephen, junior husbandman 596873 596873 atte Hacche, Stephen, junior, of Dunstall, husbandman 0
5104989 2387900 2387900 defendant Tonge Thomas husbandman 596873 596873 Tonge, Thomas, of Dunstall, husbandman 0
5104990 2387900 2387900 defendant Bocher Stephen laborer 596873 596873 Bocher, Stephen, of Dunstall, laborer 1
5152696 2401929 2401929 defendant Marchaunt John husbandman 596873 596873 Marchaunt, John, of Dunstall, husbandman 0
5236908 2426376 2426376 defendant Andirton Thomas yeoman 596873 596873 Andirton, Thomas, of Dunstall, yeoman 0
5236909 2426376 2426376 defendant Benyngton William yeoman 596873 596873 Benyngton, William, of Dunstall, yeoman 1
5236912 2426377 2426377 defendant Andirton Thomas yeoman 596873 596873 Andirton, Thomas, of Dunstall, yeoman 1
5236913 2426377 2426377 defendant Benyngton William yeoman 596873 596873 Benyngton, William, of Dunstall, yeoman 2
5236915 2426378 2426378 defendant Clyff Robert yeoman 596873 596873 Clyff, Robert, of Dunstall, yeoman 0
5239737 2427209 2427209 defendant Materas John laborer 596873 596873 Materas, John, of Dunstall, laborer 0
5327214 2453211 2453211 defendant Crowemer William esq 596873 596873 Crowemer, William, of Dunstall, esq 0
5563457 2523913 2523913 defendant Jeffrey William husbandman 596873 596873 Jeffrey, William, of Dunstall, husbandman 0
5563458 2523913 2523913 defendant Jeffrey John husbandman 596873 596873 Jeffrey, John, of Dunstall, husbandman 1
5580333 2528930 2528930 defendant Potman Richard husbandman 596873 596873 Potman, Richard, of Dunstall, husbandman 0
5580335 2528931 2528931 defendant Potman Richard husbandman 596873 596873 Potman, Richard, of Dunstall, husbandman 0
5636224 2555287 2555287 defendant Caym Henry yeoman 596873 596873 Caym, Henry, of Dunstall, 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);