names

41 rows where place_id = 627147

✎ 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
3651170 1910732 1910732 defendant Cambrugge John   627147 627147 Cambrugge, John, of Iron Acton, franklin 0
3774443 1949731 1949731 defendant Alen Richard yeoman 627147 627147 Alen, Richard, of Iron Acton, yeoman 0
3836017 1969176 1969176 defendant Aleyn Richard gent 627147 627147 Aleyn, Richard, of Iron Acton, gent 0
3855694 1975419 1975419 defendant Poyntz Giles gent 627147 627147 Poyntz, Giles, of Iron Acton, gent 1
3855695 1975419 1975419 defendant Goodryche John gent 627147 627147 Goodryche, John, of Iron Acton, gent 2
3855696 1975419 1975419 defendant Lathbury William yeoman 627147 627147 Lathbury, William, of Iron Acton, yeoman 3
3855699 1975419 1975419 defendant Wall Richard yeoman 627147 627147 Wall, Richard, of Iron Acton, yeoman 6
3855700 1975419 1975419 defendant Hunt Thomas yeoman 627147 627147 Hunt, Thomas, of Iron Acton, yeoman 7
3855701 1975419 1975419 defendant Hunt Ambrose yeoman 627147 627147 Hunt, Ambrose, of Iron Acton, yeoman 8
3855702 1975419 1975419 defendant Harvy Thomas yeoman 627147 627147 Harvy, Thomas, of Iron Acton, yeoman 9
3855704 1975419 1975419 defendant Browne William yeoman 627147 627147 Browne, William, of Iron Acton, yeoman 11
3871224 1980629 1980629 defendant Aleyn Richard gent 627147 627147 Aleyn, Richard, of Iron Acton, gent 0
3871225 1980629 1980629 defendant Wyllys Nicholas yeoman 627147 627147 Wyllys, Nicholas, of Iron Acton, yeoman 1
3878885 1983189 1983189 defendant Cokkys John husbandman 627147 627147 Cokkys, John, of Iron Acton, husbandman 0
3884180 1984974 1984974 defendant Hoper William yeoman 627147 627147 Hoper, William, of Iron Acton, yeoman 1
3887883 1986196 1986196 defendant Alen Richard gent 627147 627147 Alen, Richard, of Iron Acton, gent 1
3898629 1989749 1989749 defendant Aleyn Richard gent 627147 627147 Aleyn, Richard, of Iron Acton, gent 0
3908681 1993199 1993199 defendant Prygg Richard husbandman 627147 627147 Prygg, Richard, of Iron Acton, husbandman 0
3910311 1993766 1993766 defendant Baynham Thomas yeoman 627147 627147 Baynham, Thomas, of Iron Acton, yeoman 0
3917363 1996165 1996165 defendant Cockes John husbandman 627147 627147 Cockes, John, of Iron Acton, husbandman 0
3924181 1998398 1998398 defendant Bayneham Thomas weaver 627147 627147 Bayneham, Thomas, of Iron Acton, weaver 1
4023752 2033196 2033196 defendant Hobbes Robert husbandman 627147 627147 (Hobbes, Robert, of Iron Acton, husbandman 2
4023756 2033197 2033197 defendant Hobbes Robert husbandman 627147 627147 (Hobbes, Robert, of Iron Acton, husbandman 2
4134946 2072819 2072819 defendant Hobbes Robert, senior yeoman 627147 627147 Hobbes, Robert, senior, of Iron Acton, yeoman 0
4134948 2072819 2072819 defendant Hobbes Robert, junior   627147 627147 Hobbes, Robert, junior, of Iron Acton, yeoman, son of Robert senior 2
4159465 2081377 2081377 defendant Hobbes Robert, senior yeoman 627147 627147 Hobbes, Robert, senior, of Iron Acton, yeoman 0
4159467 2081377 2081377 defendant Hobbes Robert, junior   627147 627147 Hobbes, Robert, junior, of Iron Acton, yeoman, son of Robert senior 2
4221917 2103163 2103163 defendant Poyntz John   627147 627147 Poyntz, John, of Iron Acton, knight 0
4308386 2133087 2133087 defendant Cooke Thomas joiner 627147 627147 Cooke, Thomas, of Iron Acton, joiner 0
4330957 2140654 2140654 defendant Cowlman John innholder 627147 627147 Cowlman, John, of Iron Acton, innholder 2
4350796 2147534 2147534 defendant Batten Nicholas husbandman 627147 627147 Batten, Nicholas, of Iron Acton, husbandman 0
4350798 2147535 2147535 defendant Tucker John yeoman 627147 627147 Tucker, John, of Iron Acton, yeoman 0
4382585 2158884 2158884 defendant Tucker John yeoman 627147 627147 Tucker, John, of Iron Acton, yeoman 0
4715904 2270288 2270288 plaintiff Webbe John   627147 627147 Webbe, John, of Iron Acton 0
4720526 2271757 2271757 defendant Bully William yeoman 627147 627147 Bully, William, of Iron Acton, yeoman 1
4728068 2274025 2274025 defendant More Thomas husbandman 627147 627147 More, Thomas, of Iron Acton, husbandman 1
5146723 2400180 2400180 defendant Gryffyn Richard tanner 627147 627147 Gryffyn, Richard, of Iron Acton, tanner 0
5166716 2405988 2405988 defendant Gryffyn Richard tanner 627147 627147 Gryffyn, Richard, of Iron Acton, tanner 0
5474072 2497223 2497223 plaintiff Poyntz Robert   627147 627147 Poyntz, Robert, of Iron Acton 0
5474536 2497358 2497358 defendant Atkyns William baker 627147 627147 Atkyns, William, of Iron Acton, baker 0
5617144 2549178 2549178 plaintiff Kyng John   627147 627147 Kyng, John, of Iron Acton 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);