names

27 rows where place_id = 587036

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590311 1864613 1864613 defendant Elston Roger yeoman 587036 587036 Elston, Roger, of Broddesworth, yeoman 0
3590336 1864618 1864618 defendant Sale John husbandman 587036 587036 Sale, John, of Broddesworth, husbandman 0
3671803 1917175 1917175 defendant Paget William yeoman 587036 587036 Paget, William, of Broddesworth, yeoman 0
3729304 1935418 1935418 defendant Asten Robert husbandman 587036 587036 Asten, Robert, of Broddesworth, husbandman 0
3729305 1935418 1935418 defendant Paget William husbandman 587036 587036 Paget, William, of Broddesworth, husbandman 1
3729306 1935418 1935418 defendant Jubbe William husbandman 587036 587036 Jubbe, William, of Broddesworth, husbandman 2
3729307 1935418 1935418 defendant Kendall Henry laborer 587036 587036 Kendall, Henry, of Broddesworth, laborer 3
3768921 1947932 1947932 defendant Cotes Cuthbert clerk 587036 587036 Cotes, Cuthbert, of Broddesworth, clerk 0
3940502 2003837 2003837 defendant Pachett John husbandman 587036 587036 Pachett, John, of Broddesworth, husbandman 0
3940510 2003837 2003837 defendant Parker Richard laborer 587036 587036 Parker, Richard, of Broddesworth, laborer 8
3940512 2003838 2003838 defendant Paget John husbandman 587036 587036 Paget, John, of Broddesworth, husbandman 0
4578992 2224911 2224911 defendant Keld William   587036 587036 Keld, William, of Broddesworth 1
4580638 2225426 2225426 defendant Buldyre Thomas   587036 587036 Buldyre, Thomas, of Broddesworth 0
4621846 2237815 2237815 defendant Parlyngton Robert   587036 587036 Parlyngton, Robert, of Broddesworth, vicar 4
4658939 2248667 2248667 defendant Bulere Thomas yeoman 587036 587036 Bulere, Thomas, of Broddesworth, yeoman 0
4661326 2249365 2249365 defendant Bulder Thomas yeoman 587036 587036 Bulder, Thomas, of Broddesworth, yeoman 1
4669024 2256018 2256018 defendant Bulder William husbandman 587036 587036 Bulder, William, of Broddesworth, husbandman 0
4675415 2257919 2257919 defendant Parlyngton Robert   587036 587036 Parlyngton, Robert, of Broddesworth, vicar & chaplain 4
4681956 2259971 2259971 defendant Brewester Thomas   587036 587036 Brewester, Thomas, of Broddesworth, mason 0
4698496 2265005 2265005 defendant Buldre Thomas, sen husbandman 587036 587036 Buldre, Thomas, sen, of Broddesworth, husbandman 0
4748835 2280147 2280147 defendant Lund John weaver 587036 587036 Lund, John, of Broddesworth, weaver 0
4748836 2280147 2280147 defendant Barker John laborer 587036 587036 Barker, John, of Broddesworth, laborer 1
5021335 2363146 2363146 defendant Kyng Robert husbandman 587036 587036 Kyng, Robert, of Broddesworth, husbandman 0
5296636 2444003 2444003 defendant Neuhouse William yeoman 587036 587036 Neuhouse, William, of Broddesworth, yeoman 2
5370140 2466244 2466244 defendant Darell Margaret widow 587036 587036 Darell, Margaret, of Broddesworth, widow 0
5370142 2466245 2466245 defendant Darell Margaret widow 587036 587036 Darell, Margaret, of Broddesworth, widow 0
5542651 2517820 2517820 defendant Elston Roger yeoman 587036 587036 Elston, Roger, of Broddesworth, 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);