names

36 rows where place_id = 701115

✎ 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
4136828 2073520 2073520 defendant Anderson Richard gent 701115 701115 Anderson, Richard, of Roxby, gent 0
4239703 2109517 2109517 defendant Jackson Edmund yeoman 701115 701115 Jackson, Edmund, of Roxby, or of Garthroppe, Lullington, Lincs, yeoman 0
4262013 2116971 2116971 defendant Jackson Edmund yeoman 701115 701115 Jackson, Edmund, of Roxby, or of Garthroppe, Lullington, Lincs, yeoman 0
4404624 2166115 2166115 defendant Perte John pewterer 701115 701115 Perte, John, of Roxby, pewterer 5
4486715 2196558 2196558 plaintiff Scarburgh William   701115 701115 Scarburgh, William, of Roxby 0
4501716 2201139 2201139 defendant Scorburgh William   701115 701115 Scorburgh, William, of Roxby 1
4501726 2201140 2201140 defendant Skordeburgh William   701115 701115 Skordeburgh, William, of Roxby 1
4505303 2202189 2202189 defendant Vaux William   701115 701115 Vaux, William, of Roxby 0
4505304 2202190 2202190 plaintiff Snaythe John   701115 701115 Snaythe, John, of Roxby 0
4505305 2202190 2202190 defendant Vaux William   701115 701115 Vaux, William, of Roxby 0
4509373 2203405 2203405 plaintiff atte Hall John   701115 701115 atte Hall, John, of Roxby 0
4514302 2204890 2204890 defendant Mutte John   701115 701115 Mutte, John, of Roxby, vicar 0
4533517 2210754 2210754 defendant atte Hall William   701115 701115 atte Hall, William, of Roxby 0
4534637 2211104 2211104 plaintiff Scorburgh William de   701115 701115 Scorburgh, William de, of Roxby 0
4534639 2211105 2211105 plaintiff Scorburgh William   701115 701115 Scorburgh, William, of Roxby 0
4581168 2225589 2225589 defendant Coke John   701115 701115 Coke, John, of Roxby 0
4581170 2225590 2225590 defendant Coke John   701115 701115 Coke, John, of Roxby 0
4598258 2230693 2230693 defendant Scorburgh William   701115 701115 Scorburgh, William, of Roxby 0
4599745 2231140 2231140 defendant Scordeburgh William   701115 701115 Scordeburgh, William, of roxby 0
4632883 2241157 2241157 defendant Scorburgh William   701115 701115 Scorburgh, William, of Roxby 3
4632889 2241158 2241158 defendant Scorburgh William   701115 701115 Scorburgh, William, of Roxby 3
4741910 2278129 2278129 defendant Scorburgh John husbandman 701115 701115 Scorburgh, John, of Roxby, husbandman 2
4762254 2284175 2284175 defendant Scoreburgh John husbandman 701115 701115 Scoreburgh, John, of Roxby, husbandman 0
4851416 2311889 2311889 defendant Proctour John husbandman 701115 701115 Proctour, John, of Roxby, husbandman 0
4862756 2315338 2315338 defendant Devenshyre John husbandman 701115 701115 Devenshyre, John, of Roxby, husbandman 1
4884667 2322115 2322115 defendant Ferrour or Smith Robert husbandman 701115 701115 Ferrour or Smith, Robert, of Roxby, husbandman 0
4905633 2328364 2328364 defendant Halle William husbandman 701115 701115 Halle, William, of Roxby, husbandman 0
4905634 2328364 2328364 defendant Halle Nicholas husbandman 701115 701115 Halle, Nicholas, of Roxby, husbandman 1
4913677 2330774 2330774 defendant Gayldon John yeoman 701115 701115 Gayldon, John, of Roxby, yeoman 1
4913678 2330774 2330774 defendant Ferrour Robert husbandman 701115 701115 Ferrour, Robert, of Roxby, husbandman 2
4913679 2330774 2330774 defendant Cooke Robert husbandman 701115 701115 Cooke, Robert, of Roxby, husbandman 3
4966793 2346994 2346994 defendant Ferrour or Smith Robert husbandman 701115 701115 Ferrour or Smith, Robert, of Roxby, husbandman 5
5258219 2432692 2432692 defendant Fraunces Thomas husbandman 701115 701115 Fraunces, Thomas, of Roxby, husbandman 0
5258221 2432693 2432693 defendant Fraunces Thomas husbandman 701115 701115 Fraunces, Thomas, of Roxby, husbandman 0
5357580 2462439 2462439 defendant Spillesby Henry husbandman 701115 701115 Spillesby, Henry, of Roxby, husbandman 3
5636375 2555334 2555334 defendant Scorburgh William yeoman 701115 701115 Scorburgh, William, of Roxby, 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);