names

45 rows where place_id = 600984

✎ 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
3643423 1908369 1908369 defendant Skam John husbandman and tinner 600984 600984 Skam, John, of Shawe, husbandman and tinner 0
3696852 1925238 1925238 defendant Monten Patrick miller 600984 600984 Monten, Patrick, of Shawe, miller 1
3746444 1940807 1940807 defendant Homersley Thomas husbandman 600984 600984 Homersley, Thomas, of Shawe, husbandman 0
3777645 1950757 1950757 defendant Homersley Thomas husbandman 600984 600984 Homersley, Thomas, of Shawe, husbandman 0
3784755 1953023 1953023 defendant Hobbys Thomas weaver 600984 600984 Hobbys, Thomas, of Shawe, weaver 2
3801270 1958321 1958321 defendant Hebbys Thomas weaver 600984 600984 Hebbys, Thomas, of Shawe, weaver 1
3804465 1959337 1959337 defendant Barkesdale John, junior tanner 600984 600984 Barkesdale, John, junior, of Shawe, tanner 0
3821933 1964753 1964753 defendant Barkysdale Henry tanner 600984 600984 Barkysdale, Henry, of Shawe, tanner 0
3863483 1977982 1977982 defendant Fote John tucker 600984 600984 Fote, John, of Shawe, tucker 1
3885272 1985326 1985326 defendant Feythfull John husbandman 600984 600984 Feythfull, John, of Shawe, husbandman 2
3914996 1995368 1995368 defendant Walthewe James   600984 600984 Walthewe, James, of Shawe, shear grinder 0
3923263 1998092 1998092 plaintiff Smart Morris tanner 600984 600984 Smart, Morris, of Shawe, tanner 0
3962909 2011622 2011622 defendant Momford Nicholas husbandman 600984 600984 Momford, Nicholas, of Shawe, husbandman 0
4177917 2087750 2087750 defendant White Richard yeoman 600984 600984 White, Richard, of Shawe, yeoman 0
4200415 2095702 2095702 defendant Barkesdale William tanner 600984 600984 Barkesdale, William, of Shawe, tanner 0
4310474 2133818 2133818 defendant Williamson John yeoman 600984 600984 Williamson, John, of Shawe, yeoman 1
4351268 2147694 2147694 defendant Homersley Thomas yeoman 600984 600984 Homersley, Thomas, of Shawe, yeoman 0
4547560 2215170 2215170 defendant Benet William   600984 600984 Benet, William, of Shawe 0
4726077 2273443 2273443 defendant Shawe Richard husbandman 600984 600984 Shawe, Richard, of Shawe, husbandman 1
4841420 2308848 2308848 defendant Tracy John husbandman 600984 600984 Tracy, John, of Shawe, husbandman 5
4843865 2309599 2309599 defendant Cronmale Richard   600984 600984 Cronmale, Richard, of Shawe, mill ward 3
4868703 2317182 2317182 defendant Tracy John husbandman 600984 600984 Tracy, John, of Shawe, husbandman 4
4868712 2317183 2317183 defendant Tracy John husbandman 600984 600984 Tracy, John, of Shawe, husbandman 3
4868723 2317184 2317184 defendant Tracy John husbandman 600984 600984 Tracy, John, of Shawe, husbandman 4
4952567 2342726 2342726 defendant Shaf Thomas husbandman 600984 600984 Shaf, Thomas, of Shawe, husbandman 1
4953516 2343022 2343022 defendant Bulford John carpenter 600984 600984 Bulford, John, of Shawe, carpenter 2
5064435 2375903 2375903 defendant Elwyk Henry clerk 600984 600984 Elwyk, Henry, of Shawe, clerk 0
5070863 2377779 2377779 defendant Bolforde John (legal representative) 600984 600984 Bolforde, John, of Shawe, merchant, executors of 2
5111645 2389803 2389803 defendant Elwyke Henry clerk 600984 600984 Elwyke, Henry, of Shawe, clerk 0
5111648 2389804 2389804 defendant Elwyke Henry clerk 600984 600984 Elwyke, Henry, of Shawe, clerk 0
5244653 2428617 2428617 defendant Jagge Walter laborer 600984 600984 Jagge, Walter, of Shawe, laborer 0
5362513 2463926 2463926 defendant Leyceter John husbandman 600984 600984 Leyceter, John, of Shawe, husbandman 4
5552316 2520727 2520727 defendant Berkysdale Henry tanner 600984 600984 Berkysdale, Henry, of Shawe, tanner 0
5563770 2524012 2524012 defendant Barsdale Henry tanner 600984 600984 Barsdale, Henry, of Shawe, tanner 0
5578556 2528362 2528362 defendant Barkesdale John tanner 600984 600984 Barkesdale, John, of Shawe, tanner 2
5585788 2530613 2530613 defendant Damerell William yeoman 600984 600984 Damerell, William, of Shawe, yeoman 2
5585789 2530613 2530613 defendant Horwell Richard yeoman 600984 600984 Horwell, Richard, of Shawe, yeoman 3
5585791 2530614 2530614 defendant Herewell Richard yeoman 600984 600984 Herewell, Richard, of Shawe, yeoman 0
5585792 2530614 2530614 defendant Dollyn John yeoman 600984 600984 Dollyn, John, of Shawe, yeoman 1
5585794 2530615 2530615 defendant Want Richard yeoman 600984 600984 Want, Richard, of Shawe, yeoman 0
5585795 2530615 2530615 defendant Horwell Richard yeoman 600984 600984 Horwell, Richard, of Shawe, yeoman 1
5601182 2535261 2535261 defendant Horwell Richard husbandman 600984 600984 Horwell, Richard, of Shawe, husbandman 0
5601183 2535261 2535261 defendant Dollyn John husbandman 600984 600984 Dollyn, John, of Shawe, husbandman 1
5601184 2535261 2535261 defendant Want Richard yeoman 600984 600984 Want, Richard, of Shawe, yeoman 2
5601185 2535261 2535261 defendant Damerell William husbandman 600984 600984 Damerell, William, of Shawe, husbandman 3

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);