names

40 rows where place_id = 628427

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3782204 1952185 1952185 defendant Deane William husbandman 628427 628427 Deane, William, of Horsforth, husbandman 1
3970198 2014174 2014174 defendant Prynse Robert husbandman 628427 628427 Prynse, Robert, of Horsforth, husbandman 2
3973032 2015138 2015138 defendant Erle John brickmaker 628427 628427 Erle, John, of Horsforth, brickmaker 0
3973033 2015138 2015138 defendant Erle William brickmaker 628427 628427 Erle, William, of Horsforth, brickmaker 1
3973034 2015138 2015138 defendant Kyng Thomas husbandman 628427 628427 Kyng, Thomas, of Horsforth, husbandman 2
3988496 2020629 2020629 defendant Cloghton Richard tailor 628427 628427 Cloghton, Richard, of Horsforth, tailor 2
4014984 2030071 2030071 defendant Palmer William warrener 628427 628427 Palmer, William, of Horsforth, warrener 10
4028672 2034903 2034903 defendant Kynge Thomas husbandman 628427 628427 Kynge, Thomas, of Horsforth, husbandman 0
4043340 2040085 2040085 defendant Abbis Richard husbandman 628427 628427 Abbis, Richard, of Horsforth, husbandman 4
4180459 2088645 2088645 defendant Gyrlyng Edmund warrener 628427 628427 Gyrlyng, Edmund, of Horsforth, warrener 0
4180461 2088646 2088646 defendant Gyrlynge Alexander warrener 628427 628427 Gyrlynge, Alexander, of Horsforth, warrener 0
4188293 2091408 2091408 defendant Bedingfeld John gent 628427 628427 Bedingfeld, John, of Horsforth, gent 0
4285422 2124835 2124835 defendant Dyxon John husbandman 628427 628427 Dyxon, John, of Horsforth, husbandman 0
4285423 2124835 2124835 defendant Chapman Mathew husbandman 628427 628427 Chapman, Mathew, of Horsforth, husbandman 1
4285424 2124835 2124835 defendant Tombs William laborer 628427 628427 Tombs, William, of Horsforth, laborer 2
4285425 2124835 2124835 defendant Balye Roger husbandman 628427 628427 Balye, Roger, of Horsforth, husbandman 3
4302952 2131155 2131155 defendant Saxton Anthony yeoman 628427 628427 Saxton, Anthony, of Horsforth, yeoman 0
4302953 2131155 2131155 defendant Wrighte John yeoman 628427 628427 Wrighte, John, of Horsforth, yeoman 1
4332627 2141199 2141199 defendant Mayner Henry yeoman 628427 628427 Mayner, Henry, of Horsforth, yeoman 0
4334212 2141722 2141722 defendant Colston Thomas yeoman 628427 628427 Colston, Thomas, of Horsforth, yeoman 0
4336977 2142659 2142659 defendant Bullyn Robert, senior husbandman 628427 628427 Bullyn, Robert, senior, of Horsforth, husbandman 0
4336978 2142659 2142659 defendant Kyng Thomas husbandman 628427 628427 Kyng, Thomas, of Horsforth, husbandman 1
4336980 2142660 2142660 defendant Hudson Robert tailor 628427 628427 Hudson, Robert, of Horsforth, tailor 0
4336982 2142661 2142661 defendant Bullyn Robert, junior husbandman 628427 628427 Bullyn, Robert, junior, of Horsforth, husbandman 0
4338207 2143104 2143104 defendant Blenerhasett Thomas gent 628427 628427 Blenerhasett, Thomas, of Horsforth, gent 0
4338714 2143294 2143294 defendant Baldwyn Elizabeth widow 628427 628427 Baldwyn, Elizabeth, of Horsforth, widow 1
4353938 2148605 2148605 defendant Bullyne Robert, senior yeoman 628427 628427 Bullyne, Robert, senior, of Horsforth, yeoman 0
4353939 2148605 2148605 defendant Bullyne Robert, junior husbandman 628427 628427 Bullyne, Robert, junior, of Horsforth, husbandman 1
4353940 2148605 2148605 defendant Bullyne Richard husbandman 628427 628427 Bullyne, Richard, of Horsforth, husbandman 2
4354050 2148644 2148644 defendant Benerhausett Thomas gent 628427 628427 Benerhausett, Thomas, of Horsforth, gent 0
4392516 2162118 2162118 defendant Sikes James yeoman 628427 628427 Sikes, James, of Horsforth, yeoman 1
4395674 2163140 2163140 defendant Lister Arthur yeoman 628427 628427 Lister, Arthur, of Horsforth, yeoman 1
4404881 2166202 2166202 defendant Hunter Richard yeoman 628427 628427 Hunter Richard, of Horsforth, yeoman 2
4405452 2166402 2166402 defendant Craven John husbandman 628427 628427 Craven, John, of Horsforth, husbandman 3
4779032 2289420 2289420 defendant Gipton John miller 628427 628427 Gipton, John, of Horsforth, miller 0
4840272 2308504 2308504 defendant Marcheforth William husbandman 628427 628427 Marcheforth, William, of Horsforth, husbandman 1
5134694 2396641 2396641 defendant Ratclyff Robert yeoman 628427 628427 Ratclyff, Robert, of Horsforth, yeoman 0
5154631 2402508 2402508 defendant Radclyff Robert yeoman 628427 628427 Radclyff, Robert, of Horsforth, yeoman 0
5154633 2402509 2402509 defendant Ratclyff Robert yeoman 628427 628427 Ratclyff, Robert, of Horsforth, yeoman 0
5200364 2415868 2415868 defendant Rous Stephen miller 628427 628427 Rous, Stephen, of Horsforth, miller 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);