names

29 rows where place_id = 597661

✎ 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
3629374 1904043 1904043 defendant Catfeld Robert laborer 597661 597661 Catfeld, Robert, of Swanyngton, laborer 13
3634377 1905551 1905551 defendant Chapman John clerk 597661 597661 Chapman, John, of Swanyngton, clerk 0
3655581 1912008 1912008 defendant Whyght William tailor 597661 597661 Whyght, William, of Swanyngton, tailor 0
3660679 1913604 1913604 defendant Whyte John yeoman 597661 597661 Whyte, John, of Swanyngton, yeoman 0
3711090 1929780 1929780 plaintiff Stokys Thomas (legal representative) 597661 597661 Stokys, Thomas, of Swanyngton, yeoman, executors of 0
3711093 1929780 1929780 defendant Stokys William husbandman 597661 597661 Stokys, William, of Swanyngton, husbandman 0
3718941 1932204 1932204 defendant Powle William husbandman 597661 597661 Powle, William, of Swanyngton, husbandman 3
3852663 1974440 1974440 plaintiff Rogers Stephen husbandman 597661 597661 Rogers, Stephen, of Swanyngton, husbandman 0
3884544 1985105 1985105 plaintiff Aleyns William (legal representative) 597661 597661 Aleyns, William, of Swanyngton, clerk, executor of 0
3904075 1991604 1991604 defendant Aleyne William yeoman 597661 597661 Aleyne, William, of Swanyngton, yeoman 2
3917676 1996268 1996268 defendant Aleyn William yeoman 597661 597661 Aleyn, William, of Swanyngton, yeoman 0
3984250 2019133 2019133 defendant Woodyard John husbandman 597661 597661 Woodyard, John, of Swanyngton, husbandman 0
4036887 2037873 2037873 defendant Fayer Henry carpenter 597661 597661 Fayer, Henry, of Swanyngton, carpenter 1
4076649 2051942 2051942 defendant Gooche Richard husbandman 597661 597661 Gooche, Richard, of Swanyngton, husbandman 12
4229553 2105824 2105824 defendant Gibson Thomas laborer 597661 597661 Gibson, Thomas, of Swanyngton, laborer 1
4476755 2193392 2193392 defendant Colyer John chaplain 597661 597661 Colyer, John, of Swanyngton, chaplain 0
4525241 2208232 2208232 defendant Dexter William   597661 597661 Dexter, William, of Swanyngton 0
4567227 2221311 2221311 plaintiff Talbot Philip (legal representative) 597661 597661 Talbot, Philip, of Swanyngton, knight, executors of 0
4567228 2221311 2221311 plaintiff Souche Alan   597661 597661 (Souche, Alan, of Swanyngton 1
4756390 2282362 2282362 defendant Hyll John de   597661 597661 Hyll, John de, of Swanyngton 4
5106470 2388325 2388325 defendant Walker Hugh yeoman 597661 597661 Walker, Hugh, of Swanyngton, yeoman 0
5346956 2459206 2459206 defendant Olyvere John husbandman 597661 597661 Olyvere, John, of Swanyngton, husbandman 0
5353115 2461052 2461052 defendant Cutbald Robert laborer 597661 597661 Cutbald, Robert, of Swanyngton, laborer 0
5549185 2519807 2519807 defendant Richers Henry gent 597661 597661 Richers, Henry, of Swanyngton, gent 0
5549186 2519807 2519807 defendant Halough John clerk 597661 597661 Halough, John, of Swanyngton, clerk 1
5569703 2525708 2525708 defendant Halough John clerk 597661 597661 Halough, John, of Swanyngton, clerk 0
5569705 2525709 2525709 defendant Pers William husbandman 597661 597661 Pers, William, of Swanyngton, husbandman 0
5569706 2525709 2525709 defendant Rychers Henry gent 597661 597661 Rychers, Henry, of Swanyngton, gent 1
5584573 2530246 2530246 defendant Pers William husbandman 597661 597661 Pers, William, of Swanyngton, husbandman 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);