names

47 rows where place_id = 597208

✎ 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
3627684 1903520 1903520 plaintiff Kene John   597208 597208 Kene, John, of Haverell 3
3669871 1916521 1916521 defendant Stevyn Robert yeoman 597208 597208 Stevyn, Robert, of Haverell, yeoman 0
3669872 1916521 1916521 defendant Reve John clothier 597208 597208 Reve, John, of Haverell, clothier 1
3669874 1916522 1916522 defendant Stobyn Robert tanner 597208 597208 Stobyn, Robert, of Haverell, tanner 0
3669875 1916522 1916522 defendant Ayer John husbandman 597208 597208 Ayer, John, of Haverell, husbandman 1
3669876 1916522 1916522 defendant Sherman Richard yeoman 597208 597208 Sherman, Richard, of Haverell, yeoman 2
3669877 1916522 1916522 defendant Reve John clothier 597208 597208 Reve, John, of Haverell, clothier 3
3678834 1919448 1919448 defendant Turnour Henry gent 597208 597208 Turnour, Henry, of Haverell, gent 0
3678835 1919448 1919448 defendant Cornewall John gent 597208 597208 Cornewall, John, of Haverell, gent 1
3724275 1933879 1933879 defendant Dyxson John husbandman 597208 597208 Dyxson, John, of Haverell, husbandman 4
3759918 1945094 1945094 defendant Smyth John husbandman 597208 597208 Smyth, John, of Haverell, husbandman 3
3790481 1954845 1954845 defendant Grene Robert shoemaker 597208 597208 Grene, Robert, of Haverell, shoemaker 2
3798416 1957405 1957405 defendant Pyngle Thomas tailor 597208 597208 Pyngle, Thomas, of Haverell, tailor 0
3804678 1959403 1959403 defendant Sturdy Robert yeoman 597208 597208 Sturdy, Robert, of Haverell, yeoman 1
3806747 1960010 1960010 defendant Grene Robert shoemaker 597208 597208 Grene, Robert, of Haverell, shoemaker 0
3806748 1960010 1960010 defendant Howell John shoemaker 597208 597208 Howell, John, of Haverell, shoemaker 1
3812395 1961768 1961768 defendant Pyngle Thomas tailor 597208 597208 Pyngle, Thomas, of Haverell, tailor 1
3830908 1967549 1967549 defendant Reve John clothier 597208 597208 Reve, John, of Haverell, clothier 1
3839212 1970191 1970191 defendant Reve William smith 597208 597208 Reve, William, of Haverell, smith 0
3844477 1971817 1971817 defendant Pyngle Thomas tailor 597208 597208 Pyngle, Thomas, of Haverell, tailor 3
3866728 1979106 1979106 defendant Whale William yeoman 597208 597208 Whale, William, of Haverell, yeoman 1
3874459 1981686 1981686 defendant Straker alias Dyxson Thomas sherman 597208 597208 Straker alias Dyxson, Thomas, of Haverell, sherman 0
3874617 1981730 1981730 defendant Pyngle Thomas tailor 597208 597208 Pyngle, Thomas, of Haverell, tailor 2
3913437 1994832 1994832 defendant Reve William blacksmith 597208 597208 Reve, William,of Haverell, blacksmith 0
3921698 1997599 1997599 defendant Rust William tanner 597208 597208 Rust, William, of Haverell, tanner 0
3944146 2005060 2005060 defendant Wallye William (legal representative) 597208 597208 Wallye, William, of Haverell, yeoman, administrator of 4
3944147 2005060 2005060 defendant Beckett William yeoman 597208 597208 Beckett, William, of Haverell, yeoman 5
3982395 2018476 2018476 defendant Kykes Robert smith 597208 597208 Kykes, Robert, of Haverell, smith 1
4017154 2030839 2030839 defendant Gale Thomas brewer 597208 597208 Gale, Thomas, of Haverell, brewer 1
4031949 2036091 2036091 defendant Clerke Richard clothier 597208 597208 Clerke, Richard, of Haverell, clothier 0
4168171 2084352 2084352 defendant Newman Robert yeoman 597208 597208 Newman, Robert, of Haverell, yeoman 3
4403479 2165735 2165735 defendant Cowle Daniel   597208 597208 Cowle, Daniel, of Haverell, woollen draper 0
4403480 2165735 2165735 defendant Fayerclif or Fayercloughe Thomas yeoman 597208 597208 Fayerclif or Fayercloughe, Thomas, of Haverell, yeoman 1
4406196 2166637 2166637 defendant Mortlacke William chapman 597208 597208 Mortlacke, William, of Haverell, chapman 3
4406228 2166647 2166647 defendant Mortlacke William chapman 597208 597208 Mortlacke, William, of Haverell, chapman 3
4511874 2204162 2204162 defendant Bocher Roger   597208 597208 Bocher, Roger, of Haverell 0
4683413 2260414 2260414 defendant Chapet Thomas husbandman 597208 597208 Chapet, Thomas, of Haverell, husbandman 0
4689356 2262232 2262232 defendant Perye John, junior tanner 597208 597208 Perye, John, junior, of Haverell, tanner 0
4689358 2262233 2262233 defendant Perye John, junior tanner 597208 597208 Perye, John, junior, of Haverell, tanner 0
4732801 2275436 2275436 defendant Payne John   597208 597208 Payne, John, of Haverell 1
4765369 2285152 2285152 defendant Fyssher John husbandman 597208 597208 Fyssher, John, of Haverell, husbandman 1
4765371 2285153 2285153 defendant Barbour John barber 597208 597208 Barbour, John, of Haverell, barber 0
5350910 2460394 2460394 defendant Priour Thomas   597208 597208 Priour, Thomas, of Haverell, tallow chandler 0
5409495 2477805 2477805 defendant Sterne Thomas   597208 597208 Sterne, Thomas, of Haverell 0
5462125 2493565 2493565 defendant Couper William husbandman 597208 597208 Couper, William, of Haverell, husbandman 0
5570988 2526077 2526077 defendant Cornwall Robert gent 597208 597208 Cornwall, Robert, of Haverell, gent 0
5570989 2526077 2526077 defendant Dod John yeoman 597208 597208 Dod, John, of Haverell, 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);