names

44 rows where place_id = 597715

✎ 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
3629547 1904099 1904099 defendant Lowther Nicholas chaplain 597715 597715 Lowther, Nicholas, of Wygton, chaplain 0
3629548 1904099 1904099 defendant Lowther Gilbert gent 597715 597715 Lowther, Gilbert, of Wygton, gent 1
3629549 1904099 1904099 defendant Lowther Miles gent 597715 597715 Lowther, Miles, of Wygton, gent 2
3629550 1904099 1904099 defendant Key John   597715 597715 Key, John, of Wygton, wright 3
3629551 1904099 1904099 defendant Irelond William laborer 597715 597715 Irelond, William, of Wygton, laborer 4
3629552 1904099 1904099 defendant Skales Richard laborer 597715 597715 Skales, Richard, of Wygton, laborer 5
3629553 1904099 1904099 defendant Yong William laborer 597715 597715 Yong, William, of Wygton, laborer 6
3757420 1944299 1944299 defendant Clerk Richard chaplain 597715 597715 Clerk, Richard, of Wygton, chaplain 3
3846436 1972439 1972439 defendant Willyamson Nicholas shoemaker 597715 597715 Willyamson, Nicholas, of Wygton, shoemaker 1
4439634 2181664 2181664 defendant Coke William draper 597715 597715 Coke, William, of Wygton, draper 0
4439636 2181664 2181664 defendant Lyster Patrick   597715 597715 Lyster, Patrick, of Wygton 2
4576177 2224050 2224050 defendant Hare Richard   597715 597715 together with Hare, Richard, of Wygton 1
4610392 2234328 2234328 defendant Marsshall John   597715 597715 Marsshall, John, of Wygton 3
4611868 2234775 2234775 defendant Dicson Robert   597715 597715 Dicson, Robert, of Wygton 0
4611869 2234775 2234775 defendant Dicson William   597715 597715 Dicson, William, of Wygton 1
4611871 2234775 2234775 defendant Smythson Richard   597715 597715 Smythson, Richard, of Wygton 3
4611872 2234775 2234775 defendant Bromfeld John   597715 597715 Bromfeld, John, of Wygton 4
4611874 2234775 2234775 defendant Barker John   597715 597715 Barker, John, of Wygton 6
4618936 2236914 2236914 defendant Louther John de   597715 597715 Louther, John de, of Wygton, vicar 0
4621634 2237752 2237752 defendant Whynfell Henry de   597715 597715 Whynfell, Henry de, of Wygton 4
4636664 2242294 2242294 defendant Huton William de   597715 597715 Huton, William de, of Wygton 0
4640276 2243272 2243272 defendant Smyth John   597715 597715 Smyth, John, of Wygton 3
4640279 2243272 2243272 defendant Codlyng John   597715 597715 Codlyng, John, of Wygton 6
4642021 2243772 2243772 defendant Smyth John   597715 597715 Smyth, John, of Wygton 0
4659445 2248815 2248815 defendant Dicson Robert yeoman 597715 597715 Dicson, Robert, of Wygton, yeoman 1
4663904 2250193 2250193 defendant Alcestre John mercer 597715 597715 Alcestre, John, of Wygton, mercer 0
4700939 2265696 2265696 defendant Fyssh William yeoman 597715 597715 Fyssh, William, of Wygton, yeoman 3
4731316 2274995 2274995 defendant Wampole John husbandman 597715 597715 Wampole, John, of Wygton, husbandman 0
4732196 2275249 2275249 defendant Whynfell Henry yeoman 597715 597715 Whynfell, Henry, of Wygton, yeoman 0
4760580 2283656 2283656 defendant Laundere John yeoman 597715 597715 Laundere, John, of Wygton, yeoman 6
4760581 2283656 2283656 defendant Hare John yeoman 597715 597715 Hare, John, of Wygton, yeoman 7
4760592 2283657 2283657 defendant Launder John yeoman 597715 597715 Launder, John, of Wygton, yeoman 5
4760593 2283657 2283657 defendant Slake Thomas husbandman 597715 597715 Slake, Thomas, of Wygton, husbandman 6
4767091 2285695 2285695 defendant Merssh John butcher 597715 597715 Merssh, John, of Wygton, butcher 3
4799207 2295933 2295933 defendant Qwynsell Henry yeoman 597715 597715 Qwynsell, Henry, of Wygton, yeoman 0
4813259 2300261 2300261 defendant Gybon John husbandman 597715 597715 Gybon, John, of Wygton, husbandman 2
4825946 2304147 2304147 defendant Payn John husbandman 597715 597715 Payn, John, of Wygton, husbandman 1
4992331 2354597 2354597 defendant Luffe Roland chaplain 597715 597715 Luffe, Roland, of Wygton, chaplain 2
4992387 2354608 2354608 defendant Whitehed John husbandman 597715 597715 Whitehed, John, of Wygton, husbandman 6
5039541 2368475 2368475 plaintiff Gigge John   597715 597715 Gigge, John, of Wygton 2
5087038 2382588 2382588 defendant Colterd John yeoman 597715 597715 Colterd, John, of Wygton, Cumber, yeoman 0
5087039 2382588 2382588 defendant Thomson William yeoman 597715 597715 Thomson, William, of Wygton, or of Weseward, yeoman 1
5288542 2441665 2441665 defendant Louther Bartholomew gent 597715 597715 Louther, Bartholomew, of Wygton, gent 0
5347384 2459343 2459343 defendant Swalowe John yeoman 597715 597715 Swalowe, John, of Wygton, yeoman 0

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