names

34 rows where place_id = 593179

✎ 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
3610807 1871046 1871046 defendant Kese William husbandman 593179 593179 Kese, William, of Brodehempston, husbandman 0
3790270 1954773 1954773 defendant Ford Thomas   593179 593179 Ford, Thomas, of Brodehempston, franklin 0
3897645 1989423 1989423 defendant Yellys Richard husbandman 593179 593179 Yellys, Richard, of Brodehempston, husbandman 13
3965752 2012639 2012639 defendant Cooke Nicholas   593179 593179 Cooke, Nicholas, of Brodehempston, groom 0
4005788 2026848 2026848 defendant Blatchford James husbandman 593179 593179 Blatchford, James, of Brodehempston, husbandman 0
4026822 2034241 2034241 defendant Lowman William weaver 593179 593179 Lowman, William, of Brodehempston, weaver 0
4108245 2063216 2063216 defendant Loman Nicholas yeoman 593179 593179 Loman, Nicholas, of Brodehempston, yeoman 0
4168203 2084365 2084365 defendant Lake William yeoman 593179 593179 Lake, William, of Brodehempston, yeoman 0
4168205 2084366 2084366 defendant Mortymer William yeoman 593179 593179 Mortymer, William, of Brodehempston, yeoman 0
4181992 2089183 2089183 defendant Loman Nicholas   593179 593179 Loman, Nicholas, of Brodehempston, yeoman, his son 2
4236936 2108496 2108496 defendant Mortymer William yeoman 593179 593179 Mortymer, William, of Brodehempston, yeoman 0
4237311 2108640 2108640 defendant Lowman Nicholas yeoman 593179 593179 Lowman, Nicholas, of Brodehempston, yeoman 0
4254981 2114658 2114658 defendant Mortymer William yeoman 593179 593179 Mortymer, William, of Brodehempston, yeoman 0
4254982 2114658 2114658 defendant Averye Richard clothier 593179 593179 Averye, Richard, of Brodehempston, clothier 1
4258329 2115757 2115757 defendant Lowman Nicholas yeoman 593179 593179 Lowman, Nicholas, of Brodehempston, yeoman 0
4287428 2125555 2125555 defendant Mortymer William yeoman 593179 593179 Mortymer, William, of Brodehempston, yeoman 0
4308799 2133228 2133228 defendant Lowman Nicholas yeoman 593179 593179 Lowman, Nicholas, of Brodehempston, yeoman 1
4315739 2135615 2135615 defendant Bennett John yeoman 593179 593179 Bennett, John, of Brodehempston, yeoman 1
4315740 2135615 2135615 defendant Bennett Wilmota widow 593179 593179 Bennett, Wilmota, of Brodehempston, widow 2
4778695 2289318 2289318 defendant Kese John skinner 593179 593179 Kese, John, of Brodehempston, skinner 0
4778697 2289318 2289318 defendant Smert Robert husbandman 593179 593179 Smert, Robert, of Brodehempston, husbandman 2
4778698 2289318 2289318 defendant Smert John husbandman 593179 593179 Smert, John, of Brodehempston, husbandman 3
4778699 2289318 2289318 defendant Kese John husbandman 593179 593179 Kese, John, of Brodehempston, husbandman 4
4778700 2289318 2289318 defendant Rodde Adam husbandman 593179 593179 Rodde, Adam, of Brodehempston, husbandman 5
4778701 2289318 2289318 defendant Hogge Robert husbandman 593179 593179 Hogge, Robert, of Brodehempston, husbandman 6
4778702 2289318 2289318 defendant Forde Walter husbandman 593179 593179 Forde, Walter, of Brodehempston, husbandman 7
4778703 2289318 2289318 defendant atte Weye William husbandman 593179 593179 atte Weye, William, of Brodehempston, husbandman 8
4778704 2289318 2289318 defendant Holton Robert husbandman 593179 593179 Holton, Robert, of Brodehempston, husbandman 9
4778705 2289318 2289318 defendant Coke John husbandman 593179 593179 Coke, John, of Brodehempston, husbandman 10
4785158 2291374 2291374 defendant Major John dyer 593179 593179 Major, John, of Brodehempston, dyer 0
4856602 2313447 2313447 defendant Hempston Nicholas   593179 593179 Hempston, Nicholas, of Brodehempston, franklin 0
4977249 2350148 2350148 defendant Jane Walter husbandman 593179 593179 Jane, Walter, of Brodehempston, husbandman 0
5260089 2433277 2433277 defendant Cooke Robert husbandman or tailor 593179 593179 Cooke, Robert, of Brodehempston, husbandman or tailor 0
5554481 2521348 2521348 defendant Bartur Michael butcher 593179 593179 Bartur, Michael, of Brodehempston, butcher 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);