names

23 rows where place_id = 768983

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607369 1869966 1869966 defendant Baxter Esdward (legal representative) 768983 768983 Baxter, Esdward, of Brunham Westgate, husbandman, administrator of 0
4554094 2217205 2217205 plaintiff Gosson Edmund   768983 768983 Gosson, Edmund, of Brunham Westgate 0
4655581 2247635 2247635 defendant Gossene- John husbandman 768983 768983 Gossene-. John, of Brunham Westgate, husbandman 3
4673954 2257471 2257471 defendant Sylk Thomas butcher 768983 768983 Sylk, Thomas, of Brunham Westgate, butcher 0
4703612 2266507 2266507 defendant Smyth James   768983 768983 Smyth, James, of Brunham Westgate, iron worker 0
4809471 2299136 2299136 defendant Southgate Thomas yeoman 768983 768983 Southgate, Thomas, of Brunham Westgate, yeoman 2
4901273 2327007 2327007 defendant Patgrys Robert husbandman 768983 768983 Patgrys, Robert, of Brunham Westgate, husbandman 0
4903570 2327728 2327728 defendant Patrgys Robert husbandman 768983 768983 Patrgys, Robert, of Brunham Westgate, husbandman 0
4922293 2333390 2333390 defendant Patgrys Robert husbandman 768983 768983 Patgrys, Robert, of Brunham Westgate, husbandman 0
4982716 2351742 2351742 defendant Fitloke Roger weaver 768983 768983 Fitloke, Roger, of Brunham Westgate, weaver 3
4984003 2352146 2352146 defendant Patgryce Robert yeoman 768983 768983 Patgryce, Robert, of Brunham Westgate, yeoman 0
4985638 2352619 2352619 defendant Garbek or Garlek John shipman 768983 768983 Garbek or Garlek, John, of Brunham Westgate, shipman 4
5007013 2358949 2358949 defendant Smyth James husbandman 768983 768983 Smyth, James, of Brunham Westgate, husbandman 1
5010128 2359822 2359822 defendant Hony John shoemaker 768983 768983 Hony, John, of Brunham Westgate, shoemaker 1
5010131 2359823 2359823 defendant Hovy or Hony John shoemaker 768983 768983 Hovy or Hony, John, of Brunham Westgate, shoemaker 1
5017766 2362074 2362074 defendant Geyton William yeoman 768983 768983 Geyton, William, of Brunham Westgate, yeoman 0
5250505 2430262 2430262 defendant Gosson Edmund husbandman 768983 768983 Gosson, Edmund, of Brunham Westgate, husbandman 0
5258676 2432835 2432835 defendant Garlek John huysadman 768983 768983 Garlek, John, of Brunham Westgate, huysadman 1
5260921 2433539 2433539 defendant Bysshop Adam laborer 768983 768983 Bysshop, Adam, of Brunham Westgate, laborer 2
5284146 2440383 2440383 defendant Baxter Henry merchant 768983 768983 Baxter, Henry, of Brunham Westgate, merchant 0
5326028 2452877 2452877 defendant Person William chaplain 768983 768983 Person, William, of Brunham Westgate, chaplain 0
5352364 2460838 2460838 defendant Heyward William, junior husbandman 768983 768983 Heyward, William, junior, of Brunham Westgate, husbandman 0
5372749 2467080 2467080 defendant Palle Thomas yeoman 768983 768983 Palle, Thomas, of Brunham Westgate, 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);