names

60 rows where place_id = 634384

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3818531 1963697 1963697 defendant Romans Robert husbandman 634384 634384 Romans, Robert, of Cawood, husbandman 0
3881993 1984237 1984237 defendant Thornton Thomas yeoman 634384 634384 Thornton, Thomas, of Cawood, yeoman 1
3881994 1984237 1984237 defendant Warde William miller 634384 634384 Warde, William, of Cawood, miller 2
3925164 1998727 1998727 plaintiff Welbeke William gent 634384 634384 Welbeke, William, of Cawood, gent 0
3925165 1998727 1998727 plaintiff Marton Alexander yeoman 634384 634384 Marton, Alexander, of Cawood, yeoman 1
3977175 2016586 2016586 defendant Lee Richard yeoman 634384 634384 Lee, Richard, of Cawood, yeoman 0
3977177 2016586 2016586 defendant Smyth Henry yeoman 634384 634384 Smyth, Henry, of Cawood, yeoman 2
3977178 2016586 2016586 defendant Allen William laborer 634384 634384 Allen, William, of Cawood, laborer 3
4006050 2026933 2026933 defendant Rowdon William   634384 634384 Rowdon, William, of Cawood yeoman 2
4078211 2052510 2052510 defendant Shipton Richard glover 634384 634384 Shipton, Richard, of Cawood, glover 0
4079216 2052873 2052873 defendant Rowden William, senior yeoman 634384 634384 Rowden, William, senior, of Cawood, yeoman 0
4079217 2052873 2052873 defendant Rowden Thomas laborer 634384 634384 Rowden, Thomas, of Cawood, laborer 1
4079218 2052873 2052873 defendant Rowden William, junior laborer 634384 634384 Rowden, William, junior, of Cawood, laborer 2
4106928 2062771 2062771 defendant Hornby John carrier 634384 634384 Hornby, John, of Cawood, husbandman, carrier 0
4147985 2077427 2077427 defendant Rawson William   634384 634384 Rawson, William, of Cawood, brick maker 0
4151643 2078689 2078689 defendant Harryson Richard yeoman 634384 634384 Harryson, Richard, of Cawood, yeoman 0
4171692 2085565 2085565 defendant Benn Thomas yeoman 634384 634384 Benn, Thomas, of Cawood, yeoman 0
4176382 2087217 2087217 defendant Rawson William   634384 634384 Rawson, William, of Cawood, brick maker 1
4178071 2087800 2087800 defendant Lepton Lawrence yeoman 634384 634384 Lepton, Lawrence, of Cawood, yeoman 1
4181294 2088939 2088939 defendant Wilkinson George yeoman 634384 634384 Wilkinson, George, of Cawood, or of Copmanthorpe, yeoman 0
4191778 2092680 2092680 defendant Rawson William tiler 634384 634384 Rawson, William, of Cawood, tiler 3
4217609 2101653 2101653 defendant Herreson Richard yeoman 634384 634384 Herreson, Richard, of Cawood, yeoman 0
4217610 2101653 2101653 defendant Watson Thomas merchant 634384 634384 Watson, Thomas, of Cawood, merchant 1
4224136 2103928 2103928 defendant Lee Ralph gent 634384 634384 Lee, Ralph, of Cawood, gent 1
4250735 2113222 2113222 defendant Wilkinson George yeoman 634384 634384 Wilkinson, George, of Cawood, yeoman 0
4250737 2113222 2113222 defendant Kirkbye Thomas yeoman 634384 634384 Kirkbye, Thomas, of Cawood, yeoman 2
4258945 2115962 2115962 defendant Rither Giles gent 634384 634384 Rither, Giles, of Cawood, gent 2
4258952 2115963 2115963 defendant Ryther Giles gent 634384 634384 Ryther, Giles, of Cawood, gent 2
4263148 2117341 2117341 defendant Wilkenson George, senior yeoman 634384 634384 Wilkenson, George, senior, of Cawood, yeoman 0
4263149 2117341 2117341 defendant Wilkenson George, junior husbandman 634384 634384 Wilkenson, George, junior, of Cawood, husbandman 1
4272033 2120212 2120212 defendant Hutton Francis yeoman 634384 634384 Hutton, Francis, of Cawood, yeoman 0
4296991 2129021 2129021 defendant Camage John yeoman 634384 634384 Camage, John, of Cawood, yeoman 0
4296993 2129022 2129022 defendant Childe William yeoman 634384 634384 Childe, William, of Cawood, yeoman 0
4305290 2131991 2131991 defendant Michell John weaver 634384 634384 Michell, John, of Cawood, weaver 0
4310640 2133867 2133867 defendant Rawson William   634384 634384 Rawson, William, of Cawood, yeoman, tile maker 0
4310641 2133867 2133867 defendant Child William yeoman 634384 634384 Child, William, of Cawood, yeoman 1
4310642 2133867 2133867 defendant Kirton William yeoman 634384 634384 Kirton, William, of Cawood, yeoman 2
4310645 2133868 2133868 defendant Rawson William   634384 634384 Rawson, William, of Cawood, yeoman, tile maker 0
4310646 2133868 2133868 defendant Child William yeoman 634384 634384 Child, William, of Cawood, yeoman 1
4310647 2133868 2133868 defendant Kirton William yeoman 634384 634384 Kirton, William, of Cawood, yeoman 2
4311820 2134271 2134271 defendant Caster Thomas yeoman 634384 634384 Caster, Thomas, of Cawood, yeoman 0
4311821 2134271 2134271 defendant Birndholme Stephen yeoman 634384 634384 Birndholme, Stephen, of Cawood, yeoman 1
4312069 2134361 2134361 defendant Potter John weaver 634384 634384 Potter, John, of Cawood, weaver 2
4314557 2135205 2135205 defendant Shawe Edward yeoman 634384 634384 Shawe, Edward, of Cawood, yeoman 0
4314627 2135231 2135231 defendant Child William yeoman 634384 634384 Child, William, of Cawood, yeoman 0
4314631 2135231 2135231 defendant Spoffurth John yeoman 634384 634384 Spoffurth, John, of Cawood, yeoman 4
4315665 2135591 2135591 defendant Gaynes Anthony yeoman 634384 634384 Gaynes, Anthony, of Cawood, or of Myres, Kirkbie Malzerd, yeoman 0
4316458 2135873 2135873 defendant Harrison Richard, senior yeoman 634384 634384 Harrison, Richard, senior, of Cawood, yeoman 2
4316726 2135967 2135967 defendant Childe William yeoman 634384 634384 Childe, William, of Cawood, yeoman 0
4316727 2135967 2135967 defendant Camadge John yeoman 634384 634384 Camadge, John, of Cawood, yeoman 1
4321556 2137628 2137628 defendant Kurtyn William yeoman 634384 634384 Kurtyn, William, of Cawood, yeoman 2
4321557 2137628 2137628 defendant Childe William yeoman 634384 634384 Childe, William, of Cawood, yeoman 3
4321561 2137629 2137629 defendant Kurtyn William yeoman 634384 634384 Kurtyn, William, of Cawood, yeoman 2
4321562 2137629 2137629 defendant Childe William yeoman 634384 634384 Childe, William, of Cawood, yeoman 3
4322335 2137884 2137884 defendant Caster Thomas laborer 634384 634384 Caster, Thomas, of Cawood, carrier, laborer 1
4344321 2145293 2145293 defendant Camadge John yeoman 634384 634384 Camadge, John, of Cawood, yeoman 1
4353197 2148345 2148345 defendant Smythe Richard husbandman 634384 634384 Smythe, Richard, of Cawood, husbandman 1
4371184 2154751 2154751 defendant Childe William yeoman 634384 634384 Childe, William, of Cawood, yeoman 0
4394897 2162878 2162878 defendant Gaynes Anthony tailor 634384 634384 Gaynes, Anthony, of Cawood, tailor 0
4408738 2167519 2167519 defendant Carter Thomas carrier 634384 634384 Carter, Thomas, of Cawood, carrier 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);