names

43 rows where place_id = 628360

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3781895 1952084 1952084 defendant Coke Alexander husbandman 628360 628360 Coke, Alexander, of Sedbergh, husbandman 0
3788212 1954112 1954112 defendant Atkynson Reginald husbandman 628360 628360 Atkynson, Reginald, of Sedbergh, husbandman 0
3788213 1954112 1954112 defendant Thomson Christopher smith 628360 628360 Thomson, Christopher, of Sedbergh, smith 1
3836505 1969325 1969325 defendant Blande Mabel widow 628360 628360 Blande, Mabel, of Sedbergh, widow 0
3836506 1969325 1969325 defendant Blande Richard laborer 628360 628360 Blande, Richard, of Sedbergh, laborer 1
3928426 1999846 1999846 plaintiff Blande Roland (legal representative) 628360 628360 Blande, Roland, of Sedbergh, executors of 0
4060622 2046201 2046201 defendant Moyser James yeoman 628360 628360 Moyser, James, of Sedbergh, yeoman 3
4060624 2046201 2046201 defendant Ryding Richard yeoman 628360 628360 Ryding, Richard, of Sedbergh, yeoman 5
4130727 2071300 2071300 defendant Duckett Richard gent 628360 628360 Duckett, Richard, of Sedbergh, gent 1
4215903 2101061 2101061 defendant Atkinson John tanner 628360 628360 Atkinson, John, of Sedbergh, tanner 0
4403087 2165613 2165613 defendant Cowper Francis yeoman 628360 628360 Cowper, Francis, of Sedbergh, yeoman 2
4455727 2186802 2186802 defendant Webster Nigel   628360 628360 Webster, Nigel, of Sedbergh 1
4483842 2195644 2195644 defendant Thomlynson William   628360 628360 Thomlynson, William, of Sedbergh 0
4602783 2232085 2232085 defendant Holme John de   628360 628360 Holme, John de, of Sedbergh 0
4602787 2232086 2232086 defendant Thomlynson Adam   628360 628360 Thomlynson, Adam, of Sedbergh 0
4639908 2243178 2243178 defendant Branthwayt John   628360 628360 Branthwayt, John, of Sedbergh 2
4659483 2248825 2248825 defendant de Bramthwayt John   628360 628360 de Bramthwayt, John, of Sedbergh 0
4783943 2290988 2290988 defendant de Fauxside William   628360 628360 de Fauxside, William, of Sedbergh, wright 6
4816088 2301124 2301124 defendant Elythorne Richard chapman 628360 628360 Elythorne, Richard, of Sedbergh, chapman 1
4853028 2312366 2312366 defendant Warde Richard yeoman 628360 628360 Warde, Richard, of Sedbergh, yeoman 2
4853030 2312366 2312366 defendant Ryddynge John de yeoman 628360 628360 Ryddynge, John de, of Sedbergh, yeoman 4
4861434 2314947 2314947 defendant Bramthwayt Margaret widow 628360 628360 Bramthwayt, Margaret, of Sedbergh, widow 0
4888621 2323234 2323234 defendant Gerthwayt John yeoman 628360 628360 Gerthwayt, John, of Sedbergh, yeoman 0
4901371 2327039 2327039 defendant Ward Adam yeoman 628360 628360 Ward, Adam, of Sedbergh, yeoman 0
4926680 2334764 2334764 defendant Fauset Henry yeoman 628360 628360 Fauset, Henry, of Sedbergh, yeoman 0
4926681 2334764 2334764 defendant Fauset Adam yeoman 628360 628360 Fauset, Adam, of Sedbergh, yeoman 1
4926682 2334764 2334764 defendant Tomlynson Wilkynson Adam yeoman 628360 628360 Tomlynson Wilkynson, Adam, of Sedbergh, yeoman 2
4926683 2334764 2334764 defendant Wilkynson Thomas yeoman 628360 628360 Wilkynson, Thomas, of Sedbergh, yeoman 3
4967770 2347304 2347304 defendant Hoggeson John Richardson yeoman 628360 628360 Hoggeson, John Richardson, of Sedbergh, yeoman 1
4994401 2355200 2355200 defendant Richardson Henry yeoman 628360 628360 Richardson, Henry, of Sedbergh, yeoman 0
4994402 2355200 2355200 defendant Bland Christopher yeoman 628360 628360 Bland, Christopher, of Sedbergh, yeoman 1
5029857 2365606 2365606 defendant Hebilthwayte Richard yeoman 628360 628360 Hebilthwayte, Richard, of Sedbergh, yeoman 5
5029863 2365606 2365606 defendant Whyrygge Richard yeoman 628360 628360 Whyrygge, Richard, of Sedbergh, yeoman 11
5029872 2365607 2365607 defendant Whirigge Richard yeoman 628360 628360 Whirigge, Richard, of Sedbergh, yeoman 7
5189736 2412743 2412743 defendant Atkynson Robert yeoman 628360 628360 Atkynson, Robert, of Sedbergh, yeoman 2
5189737 2412743 2412743 defendant (illegible) Christopher yeoman 628360 628360 _, Christopher, of Sedbergh, yeoman 3
5189738 2412743 2412743 defendant Byndelans William yeoman 628360 628360 Byndelans, William, of Sedbergh, yeoman 4
5189742 2412744 2412744 defendant Atkynson Robert yeoman 628360 628360 Atkynson, Robert, of Sedbergh, yeoman 2
5189746 2412745 2412745 defendant Atkynson Robert yeoman 628360 628360 Atkynson, Robert, of Sedbergh, yeoman 2
5189747 2412745 2412745 defendant Boure Christopher yeoman 628360 628360 Boure, Christopher, of Sedbergh, yeoman 3
5538757 2516605 2516605 defendant Faucid Alexander yeoman 628360 628360 Faucid, Alexander, of Sedbergh, yeoman 1
5538758 2516605 2516605 defendant Faucid Stephen yeoman 628360 628360 Faucid, Stephen, of Sedbergh, yeoman 2
5572705 2526560 2526560 defendant Heryson Gilbert yeoman 628360 628360 Heryson, Gilbert, of Sedbergh, yeoman 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);