names

66 rows where place_id = 589892

✎ 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
3599137 1867366 1867366 defendant Wodeshawe John husbandman 589892 589892 Wodeshawe, John, of Wotton Basset, husbandman 0
3599138 1867366 1867366 defendant Reve Nicholas husbandman 589892 589892 Reve, Nicholas, of Wotton Basset, husbandman 1
3608178 1870214 1870214 defendant Benet William yeoman 589892 589892 Benet, William, of Wotton Basset, yeoman 0
3684229 1921202 1921202 defendant Quynteyn John, senior gent 589892 589892 Quynteyn, John, senior, of Wotton Basset, gent 0
3685625 1921658 1921658 defendant Brymstone William grasier 589892 589892 Brymstone, William, of Wotton Basset, grasier 0
3687270 1922199 1922199 defendant Clement Ralph tailor 589892 589892 Clement, Ralph, of Wotton Basset, tailor 0
3687271 1922199 1922199 defendant Clement William laborer 589892 589892 Clement, William, of Wotton Basset, laborer 1
3700612 1926438 1926438 defendant Brymston William grasier 589892 589892 Brymston, William, of Wotton Basset, grasier 0
3733643 1936763 1936763 defendant Estcourt John gent 589892 589892 Estcourt, John, of Wotton Basset, gent 0
3737799 1938043 1938043 defendant Robyns Christopher husbandman 589892 589892 Robyns, Christopher, of Wotton Basset, husbandman 0
3739967 1938719 1938719 defendant Escourte John gent 589892 589892 Escourte, John, of Wotton Basset, gent 0
3773123 1949297 1949297 defendant Saye John husbandman 589892 589892 Saye, John, of Wotton Basset, husbandman 0
3796499 1956777 1956777 defendant Escourte John gent 589892 589892 Escourte, John, of Wotton Basset, gent 0
3803402 1958966 1958966 defendant Felpys William butcher 589892 589892 Felpys, William, of Wotton Basset, butcher 0
3803403 1958966 1958966 defendant Carter John butcher 589892 589892 Carter, John, of Wotton Basset, butcher 1
3869983 1980203 1980203 defendant Rudman John butcher 589892 589892 Rudman, John, of Wotton Basset, butcher 0
3869984 1980203 1980203 defendant Parysse James butcher 589892 589892 Parysse, James, of Wotton Basset, butcher 1
3915437 1995529 1995529 defendant Estorte Walter, junior gent 589892 589892 Estorte, Walter, junior, of Wotton Basset, gent 2
4227564 2105126 2105126 defendant Hewse alias Wormes Richard butcher 589892 589892 Hewse alias Wormes, Richard, of Wotton Basset, butcher 0
4565530 2220789 2220789 plaintiff Smyth Thomas   589892 589892 Smyth, Thomas, of Wotton Basset 0
4570378 2222310 2222310 defendant Jocy Walter   589892 589892 Jocy, Walter, of Wotton Basset 1
4702115 2266070 2266070 defendant Rokell John laborer 589892 589892 Rokell, John, of Wotton Basset, laborer 0
4817278 2301496 2301496 defendant Hele Walter yeoman 589892 589892 with Hele, Walter, of Wotton Basset, yeoman 2
4856698 2313471 2313471 defendant Uffyngton John gent 589892 589892 Uffyngton, John, of Wotton Basset, gent 0
4881452 2321101 2321101 defendant Pogot Robert chapman 589892 589892 Pogot, Robert, of Wotton Basset, chapman 0
4900242 2326705 2326705 defendant Pecot Robert yeoman 589892 589892 Pecot, Robert, of Wotton Basset, yeoman 0
4978289 2350453 2350453 defendant Thurkell John husbandman 589892 589892 Thurkell, John, of Wotton Basset, husbandman 1
4978291 2350454 2350454 defendant Thurkell John husbandman 589892 589892 Thurkell, John, of Wotton Basset, husbandman 1
4988737 2353589 2353589 defendant Benet William husbandman 589892 589892 Benet, William, of Wotton Basset, husbandman 0
4988738 2353589 2353589 defendant Sherman Lawrence husbandman 589892 589892 Sherman, Lawrence, of Wotton Basset, husbandman 1
4988740 2353589 2353589 defendant Watkyn Thomas husbandman 589892 589892 Watkyn, Thomas, of Wotton Basset, husbandman 3
4989282 2353726 2353726 defendant Grenhill William yeoman 589892 589892 Grenhill, William, of Wotton Basset, yeoman 1
5005269 2358441 2358441 defendant Nicoll William husbandman 589892 589892 Nicoll, William, of Wotton Basset, husbandman 0
5012610 2360527 2360527 defendant Thurkell John husbandman 589892 589892 Thurkell, John, of Wotton Basset, husbandman 1
5017052 2361882 2361882 defendant Hele Walter husbandman 589892 589892 Hele, Walter, of Wotton Basset, husbandman 1
5037750 2367914 2367914 defendant Brontesdon John husbandman 589892 589892 Brontesdon, John, of Wotton Basset, husbandman 1
5065666 2376258 2376258 defendant Parker Walter yeoman 589892 589892 Parker, Walter, of Wotton Basset, yeoman 4
5065667 2376258 2376258 defendant Wodecok William husbandman 589892 589892 Wodecok, William, of Wotton Basset, husbandman 5
5065668 2376258 2376258 defendant Taillour Roger tailor 589892 589892 Taillour, Roger, of Wotton Basset, tailor 6
5097332 2385650 2385650 defendant Snede Walter parker 589892 589892 Snede, Walter, of Wotton Basset, parker 0
5097333 2385650 2385650 defendant de Landaf John yeoman 589892 589892 de Landaf, John, of Wotton Basset, yeoman 1
5097334 2385650 2385650 defendant Glasyer William yeoman 589892 589892 Glasyer, William, of Wotton Basset, yeoman 2
5097335 2385650 2385650 defendant Golabyf Richard   589892 589892 Golabyf, Richard, of Wotton Basset, minstrel 3
5097336 2385650 2385650 defendant Wattys John husbandman 589892 589892 Wattys, John, of Wotton Basset, husbandman 4
5112225 2389957 2389957 defendant Doget Walter butcher 589892 589892 Doget, Walter, of Wotton Basset, butcher 0
5112230 2389958 2389958 defendant Doket Walter butcher 589892 589892 together with Doket, Walter, of Wotton Basset, butcher 1
5119583 2392159 2392159 defendant Basset Richard chapman 589892 589892 Basset, Richard, of Wotton Basset, chapman 0
5261744 2433781 2433781 defendant Colles Richard yeoman 589892 589892 Colles, Richard, of Wotton Basset, yeoman 3
5269044 2436048 2436048 defendant Bavet or Banet William yeoman 589892 589892 Bavet or Banet, William, of Wotton Basset, yeoman 1
5286754 2441135 2441135 defendant Parys William husbandman 589892 589892 Parys, William, of Wotton Basset, husbandman 0
5292942 2442928 2442928 defendant Clement Walter tailor 589892 589892 Clement, Walter, of Wotton Basset, tailor 0
5292945 2442928 2442928 defendant Pogyn alias Geffray John cordwainer 589892 589892 Pogyn alias Geffray, John, of Wotton Basset, cordwainer 3
5299262 2444759 2444759 plaintiff Broker Wiiliam (legal representative) 589892 589892 Broker, Wiiliam, of Wotton Basset, executors of 0
5299270 2444759 2444759 defendant Quynteyne Alice widow 589892 589892 Quynteyne, Alice, of Wotton Basset, widow 3
5299272 2444759 2444759 defendant Benet William, sen yeoman 589892 589892 Benet, William, sen, of Wotton Basset, yeoman 5
5305475 2446639 2446639 defendant Clement Walter tailor 589892 589892 Clement, Walter, of Wotton Basset, tailor 1
5305476 2446639 2446639 defendant Benet John yeoman 589892 589892 Benet, John, of Wotton Basset, yeoman 2
5305541 2446661 2446661 defendant Clement Walter tailor 589892 589892 Clement, Walter, of Wotton Basset, tailor 1
5321159 2451427 2451427 defendant Clement William tailor 589892 589892 Clement, William, of Wotton Basset, tailor 1
5321160 2451427 2451427 defendant Benet William, junior yeoman 589892 589892 Benet, William, junior, of Wotton Basset, yeoman 2
5321163 2451428 2451428 defendant Clement William tailor 589892 589892 Clement, William, of Wotton Basset, tailor 1
5321164 2451428 2451428 defendant Benet William, junior yeoman 589892 589892 Benet, William, junior, of Wotton Basset, yeoman 2
5507843 2507352 2507352 defendant Hele John husbandman 589892 589892 Hele, John, of Wotton Basset, husbandman 3
5526177 2512761 2512761 defendant Smyth William husbandman 589892 589892 Smyth, William, of Wotton Basset, husbandman 0
5574870 2527221 2527221 defendant Parker John yeoman 589892 589892 Parker, John, of Wotton Basset, yeoman 2
5577157 2527905 2527905 defendant Benet William yeoman 589892 589892 Benet, William, of Wotton Basset, or of Sherton, 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);