names

26 rows where place_id = 623522

✎ 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
3752920 1942840 1942840 defendant Fulke Edward husbandman 623522 623522 Fulke, Edward, of Swanton Abbots, husbandman 1
3868727 1979780 1979780 defendant Scottowe William   623522 623522 Scottowe, William, of Swanton Abbots, worsted weaver 4
3880989 1983912 1983912 defendant Dey Robert husbandman 623522 623522 Dey, Robert, of Swanton Abbots, husbandman 0
3880990 1983912 1983912 defendant Larke Robert husbandman 623522 623522 Larke, Robert, of Swanton Abbots, husbandman 1
4184457 2090071 2090071 defendant Crome Erasmus husbandman 623522 623522 Crome, Erasmus, of Swanton Abbots, husbandman 0
4678305 2258823 2258823 defendant Toke Henry   623522 623522 Toke, Henry, of Swanton abbots, worsted weaver 0
4814201 2300547 2300547 defendant Sporell John yeoman 623522 623522 Sporell, John, of Swanton Abbots, yeoman 1
5009181 2359572 2359572 defendant Toke John chapman 623522 623522 Toke, John, of Swanton Abbots, chapman 3
5031504 2366073 2366073 defendant Bolt Richard butcher 623522 623522 Bolt, Richard, of Swanton Abbots, butcher 2
5155590 2402788 2402788 defendant Knapton Thomas husbandman 623522 623522 Knapton, Thomas, of Swanton Abbots, husbandman 3
5172155 2407576 2407576 defendant Knapton Thomas husbandman 623522 623522 Knapton, Thomas, of Swanton Abbots, husbandman 3
5299581 2444848 2444848 defendant Tucke John husbandman 623522 623522 Tucke, John, of Swanton Abbots, husbandman 3
5329914 2454018 2454018 defendant Emondys Robert husbandman 623522 623522 Emondys, Robert, of Swanton Abbots, husbandman 0
5354087 2461342 2461342 defendant Holme Oliver husbandman 623522 623522 Holme, Oliver, of Swanton Abbots, husbandman 0
5358416 2462684 2462684 defendant Jay Robert   623522 623522 Jay, Robert, of Swanton Abbots, worsted weaver 0
5372106 2466870 2466870 defendant Emondys Robert husbandman 623522 623522 Emondys, Robert, of Swanton Abbots, husbandman 2
5372107 2466870 2466870 defendant Wryte William carpenter 623522 623522 Wryte, William, of Swanton Abbots, yeoman. Charelys, John, of Scottowe, carpenter 3
5381105 2469652 2469652 defendant Lesyngham Robert   623522 623522 Lesyngham, Robert, of Swanton Abbots, worsted weaver 0
5415619 2479614 2479614 defendant Hoddys Robert husbandman 623522 623522 Hoddys, Robert, of Swanton Abbots, husbandman 0
5417417 2480130 2480130 defendant Holme Oliver yeoman 623522 623522 Holme, Oliver, of Swanton Abbots, yeoman 4
5423688 2482049 2482049 defendant Emondys Robert husbandman 623522 623522 Emondys, Robert, of Swanton Abbots, husbandman 0
5455635 2491591 2491591 defendant Emondys Robert husbandman 623522 623522 Emondys, Robert, of Swanton Abbots, husbandman 0
5460584 2493108 2493108 defendant Hoddys Robert husbandman 623522 623522 Hoddys, Robert, of Swanton Abbots, husbandman 0
5478708 2498657 2498657 defendant Emondys Robert husbandman 623522 623522 Emondys, Robert, of Swanton Abbots, husbandman 0
5543061 2517949 2517949 defendant Jaye Robert   623522 623522 Jaye, Robert, of Swanton Abbots, worsted weaver 0
5603757 2536043 2536043 defendant Jay John   623522 623522 Jay, John, of Swanton Abbots, worsted weaver 3

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