names

61 rows where place_id = 593846

✎ 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
3613562 1871890 1871890 defendant Preyst Thomas chapman 593846 593846 Preyst, Thomas, of Stone, Staffs, chapman 0
3760235 1945205 1945205 defendant Crompton John capper 593846 593846 Crompton, John, of Stone, Staffs, capper 2
3760241 1945206 1945206 defendant Crompton John capper 593846 593846 Crompton, John, of Stone, Staffs, capper 2
3788533 1954210 1954210 defendant Yonge Thomas mercer 593846 593846 Yonge, Thomas, of Stone, Staffs, mercer 2
3788537 1954211 1954211 defendant Yonge Thomas mercer 593846 593846 Yonge, Thomas, of Stone, Staffs, mercer 2
3808290 1960466 1960466 defendant Aspdyn Robert yeoman 593846 593846 Aspdyn, Robert, of Stone, Staffs, yeoman 1
3808293 1960467 1960467 defendant Aspdyn Robert yeoman 593846 593846 Aspdyn, Robert, of Stone, Staffs, yeoman 1
3812718 1961871 1961871 defendant Payttsson Thomas yeoman 593846 593846 Payttsson, Thomas, of Stone, Staffs, yeoman 2
3885595 1985435 1985435 defendant Brodebury Roger dyer 593846 593846 Brodebury, Roger, of Stone, Staffs, dyer 0
3885598 1985436 1985436 defendant Brodebury Roger dyer 593846 593846 Brodebury, Roger, of Stone, Staffs, dyer 0
3885608 1985440 1985440 defendant Bradbury Roger dyer 593846 593846 Bradbury, Roger, of Stone, Staffs, dyer 0
3891973 1987566 1987566 defendant Hawkyns John husbandman 593846 593846 Hawkyns, John, of Stone, Staffs, husbandman 2
3891974 1987566 1987566 defendant Hawkyns James husbandman 593846 593846 Hawkyns, James, of Stone, Staffs, husbandman 3
3894339 1988323 1988323 defendant Pateson John chapman 593846 593846 Pateson, John, of Stone, Staffs, chapman 2
3901658 1990783 1990783 defendant Pateson James chapman 593846 593846 Pateson, James, of Stone, Staffs, chapman 4
3925354 1998792 1998792 defendant Lawes John husbandman 593846 593846 (Lawes, John, of Stone, Staffs, husbandman 1
3968121 2013474 2013474 defendant Dymmocke James butcher 593846 593846 Dymmocke, James, of Stone, Staffs, butcher 1
3969617 2013980 2013980 defendant Collyer Robert chapman 593846 593846 Collyer, Robert, of Stone, Staffs, chapman 2
3976138 2016221 2016221 defendant Dycken John butcher 593846 593846 Dycken, John, of Stone, Staffs, butcher 0
4007752 2027556 2027556 defendant Browne William innholder 593846 593846 Browne, William, of Stone, Staffs, innholder 1
4034130 2036868 2036868 defendant Collyer Robert esq 593846 593846 Collyer, Robert, of Stone, Staffs, esq 1
4034217 2036905 2036905 defendant Collyer Robert esq 593846 593846 Collyer, Robert, of Stone, Staffs, esq 1
4043301 2040072 2040072 defendant Webbe John yeoman or blacksmith 593846 593846 Webbe, John, of Stone, Staffs, yeoman or blacksmith 0
4061490 2046509 2046509 defendant Johnson Francis mercer 593846 593846 Johnson, Francis, of Stone, Staffs, mercer 3
4096549 2059094 2059094 defendant Hawkyns Thomas yeoman 593846 593846 Hawkyns, Thomas, of Stone, Staffs, yeoman 3
4104712 2061965 2061965 defendant Parker Humphrey husbandman 593846 593846 Parker, Humphrey, of Stone, Staffs, husbandman 2
4107379 2062928 2062928 defendant Austen John yeoman 593846 593846 Austen, John, of Stone, Staffs, yeoman 0
4133767 2072411 2072411 defendant Baylies Ralph chapman 593846 593846 Baylies, Ralph, of Stone, Staffs, chapman 0
4141384 2075143 2075143 defendant Baylye Ralph chapman 593846 593846 Baylye, Ralph, of Stone, Staffs, chapman 0
4151350 2078595 2078595 defendant Walkerden alias Cliff Thomas carrier 593846 593846 Walkerden alias Cliff, Thomas, of Stone, Staffs, carrier 0
4165356 2083390 2083390 defendant Bowlde Thomas chapman 593846 593846 Bowlde, Thomas, of Stone, Staffs, chapman 3
4190624 2092283 2092283 defendant Collyer Robert esq 593846 593846 Collyer, Robert, of Stone, Staffs, esq 0
4230895 2106304 2106304 defendant Waweden Sampson gent 593846 593846 Waweden, Sampson, of Stone, Staffs, gent 0
4241299 2110074 2110074 defendant Tyll Thomas yeoman 593846 593846 Tyll, Thomas, of Stone, Staffs, yeoman 0
4245328 2111416 2111416 defendant Trevin John yeoman 593846 593846 Trevin, John, of Stone, Staffs, yeoman 1
4245333 2111417 2111417 defendant Trevyn John yeoman 593846 593846 Trevyn, John, of Stone, Staffs, yeoman 1
4257718 2115555 2115555 defendant Johnson Thomas innholder 593846 593846 Johnson, Thomas, of Stone, Staffs, innholder 1
4257728 2115557 2115557 defendant Till Humphrey yeoman 593846 593846 Till, Humphrey, of Stone, Staffs, yeoman 1
4269911 2119523 2119523 defendant Johnson Thomas innholder 593846 593846 Johnson, Thomas, of Stone, Staffs, innholder 1
4269922 2119525 2119525 defendant Tull Humphrey gent 593846 593846 Tull, Humphrey, of Stone, Staffs, gent 1
4311267 2134088 2134088 defendant Hawkens Thomas vintner 593846 593846 Hawkens, Thomas, of Stone, Staffs, vintner 0
4674692 2257694 2257694 defendant Palmer John yeoman 593846 593846 Palmer, John, of Stone, Staffs, yeoman 0
4738585 2277157 2277157 defendant Frenche Roger yeoman 593846 593846 Frenche, Roger, of Stone, Staffs, yeoman 2
4750243 2280548 2280548 defendant Heyward John chapman 593846 593846 Heyward, John, of Stone, Staffs, chapman 0
4794500 2294419 2294419 defendant Grey John gent 593846 593846 Grey, John, of Stone, Staffs, gent 0
4794515 2294424 2294424 defendant Grey John gent 593846 593846 Grey, John, of Stone, Staffs, gent 0
4881253 2321040 2321040 defendant Wylotes John hosteler 593846 593846 Wylotes, John, of Stone, Staffs, hosteler 1
5139780 2398112 2398112 defendant Gregory John chapman 593846 593846 Gregory, John, of Stone, Staffs, chapman 0
5227894 2423773 2423773 defendant Gregory John yeoman 593846 593846 Gregory, John, of Stone, Staffs, yeoman 4
5230087 2424418 2424418 defendant Gregory John chapman 593846 593846 Gregory, John, of Stone, Staffs, chapman 0
5230098 2424420 2424420 defendant Gregory John chapman 593846 593846 Gregory, John, of Stone, Staffs, chapman 0
5272150 2436937 2436937 defendant Bregory John mercer 593846 593846 Bregory, John, of Stone, Staffs, mercer 2
5345695 2458805 2458805 defendant Milner John chapman 593846 593846 Milner, John, of Stone, Staffs, chapman 0
5345752 2458811 2458811 defendant Lambard John chapman 593846 593846 Lambard, John, of Stone, Staffs, chapman 11
5361965 2463767 2463767 defendant Shelley Robert yeoman 593846 593846 Shelley, Robert, of Stone, Staffs, yeoman 1
5437664 2486198 2486198 defendant Coton Thomas clothman 593846 593846 Coton, Thomas, of Stone, Staffs, clothman 3
5451858 2490434 2490434 defendant Coton Thomas clothman 593846 593846 Coton, Thomas, of Stone, Staffs, clothman 1
5467683 2495265 2495265 defendant Kerver John brewer 593846 593846 Kerver, John, of Stone, Staffs, brewer 0
5487781 2501232 2501232 defendant Wayn Richard miller 593846 593846 Wayn, Richard, of Stone, Staffs, miller 0
5487784 2501233 2501233 defendant Wayne Richard miller 593846 593846 Wayne, Richard, of Stone, Staffs, miller 0
5547012 2519131 2519131 defendant Johnson Thomas yeoman 593846 593846 Johnson, Thomas, of Stone, Staffs, 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);