names

34 rows where place_id = 614729

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3705211 1927915 1927915 defendant Wylloughby Anthony esq 614729 614729 Wylloughby, Anthony, of Bewdeley, esq 0
3744931 1940319 1940319 defendant Patrycke Thomas husbandman 614729 614729 Patrycke, Thomas, of Bewdeley, husbandman 0
3744932 1940319 1940319 defendant Patrycke Edward yeoman 614729 614729 Patrycke, Edward, of Bewdeley, yeoman 1
3753586 1943065 1943065 plaintiff Southall Roger merchant 614729 614729 Southall, Roger, of Bewdeley, merchant 0
3768980 1947949 1947949 defendant Tyler John, junior yeoman 614729 614729 Tyler, John, junior, of Bewdeley, yeoman 3
3768981 1947949 1947949 defendant Seberne John yeoman 614729 614729 Seberne, John, of Bewdeley, yeoman 4
3768982 1947949 1947949 defendant Harrys William sherman 614729 614729 Harrys, William, of Bewdeley, sherman 5
3768984 1947949 1947949 defendant Randyll Richard laborer 614729 614729 Randyll, Richard, of Bewdeley, laborer 7
3768987 1947949 1947949 defendant Welshman William yeoman 614729 614729 Welshman, William, of Bewdeley, yeoman 10
3768991 1947949 1947949 defendant Bawdewyn William yeoman 614729 614729 Bawdewyn, William, of Bewdeley, yeoman 14
3768992 1947949 1947949 defendant Blount Arthur gent 614729 614729 Blount, Arthur, of Bewdeley, gent 15
3770727 1948529 1948529 plaintiff Southall Roger merchant 614729 614729 Southall, Roger, of Bewdeley, merchant 0
3770729 1948530 1948530 plaintiff Southall Roger merchant 614729 614729 Southall, Roger, of Bewdeley, merchant 0
3788447 1954188 1954188 plaintiff Southall Roger merchant 614729 614729 Southall, Roger, of Bewdeley, merchant 0
3807358 1960207 1960207 plaintiff Wodwall Humphrey merchant 614729 614729 Wodwall, Humphrey, of Bewdeley, merchant 0
3840145 1970489 1970489 defendant Bysshop John laborer 614729 614729 Bysshop, John, of Bewdeley, laborer 1
3840146 1970489 1970489 defendant Nicols Thomas laborer 614729 614729 Nicols, Thomas, of Bewdeley, laborer 2
3856924 1975796 1975796 defendant Southall Roger yeoman 614729 614729 Southall, Roger, of Bewdeley, yeoman 0
3856925 1975796 1975796 defendant Bysshop John laborer 614729 614729 Bysshop, John, of Bewdeley, laborer 1
3856926 1975796 1975796 defendant Nycols Thomas laborer 614729 614729 Nycols, Thomas, of Bewdeley, laborer 2
3856928 1975797 1975797 defendant Southall Roger yeoman 614729 614729 Southall, Roger, of Bewdeley, yeoman 0
3886985 1985910 1985910 defendant Pether John gent 614729 614729 Pether, John, of Bewdeley, gent 0
3887351 1986034 1986034 plaintiff Constantyne Richard mercer 614729 614729 Constantyne, Richard, of Bewdeley, mercer 0
3917314 1996149 1996149 defendant Stone Simon yeoman 614729 614729 Stone, Simon, of Bewdeley, yeoman 0
3918269 1996444 1996444 defendant Smyth Hugh laborer 614729 614729 Smyth, Hugh, of Bewdeley, laborer 0
3918270 1996444 1996444 defendant Myller Ralph laborer 614729 614729 Myller, Ralph, of Bewdeley, laborer 1
3946042 2005691 2005691 defendant Stone John merchant 614729 614729 Stone, John, of Bewdeley, innholder, or of Bristol, merchant 0
3947900 2006329 2006329 defendant Gye William yeoman or tailor 614729 614729 Gye, William, of Bewdeley, yeoman or tailor 2
3966738 2013000 2013000 plaintiff Brigg Oliver merchant 614729 614729 Brigg, Oliver, of Bewdeley, merchant 0
4047691 2041621 2041621 defendant Campyon Edward gent 614729 614729 Campyon, Edward, of Bewdeley, gent 0
4142437 2075529 2075529 defendant Meerson John dyer 614729 614729 Meerson, John, of Bewdeley, dyer 0
4237212 2108602 2108602 defendant Perryns John innholder 614729 614729 Perryns, John, of Bewdeley, innholder 1
4607834 2233565 2233565 plaintiff Bagger Thomas   614729 614729 Bagger, Thomas, of Bewdeley 1
5432594 2484718 2484718 defendant Halle Thomas chapman 614729 614729 Halle, Thomas, of Bewdeley, chapman 1

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);