names

47 rows where place_id = 633612

✎ 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
3813795 1962227 1962227 defendant Goodwyn John husbandman 633612 633612 Goodwyn, John, of Thorp Market, husbandman 0
3814386 1962414 1962414 defendant Hanneworth Robert husbandman 633612 633612 Hanneworth, Robert, of Thorp Market, husbandman 1
3821283 1964547 1964547 defendant Hanworth Robert   633612 633612 Hanworth, Robert, of Thorp Market, worsted weaver 0
3864885 1978457 1978457 plaintiff Marchall John yeoman 633612 633612 Marchall, John, of Thorp Market, yeoman 0
3968491 2013613 2013613 defendant Walshe Bartholomew   633612 633612 Walshe, Bartholomew, of Thorp Market, gent, administrators of 0
4464936 2189708 2189708 defendant Frost John   633612 633612 Frost, John, of Thorp Market 3
4464937 2189708 2189708 defendant Gryme John   633612 633612 Gryme, John, of Thorp Market 4
4464940 2189708 2189708 defendant James William   633612 633612 James, William, of Thorp market 7
4510865 2203852 2203852 defendant Cokk John   633612 633612 Cokk, John, of Thorp Market 0
4538110 2212203 2212203 defendant Reppes John de   633612 633612 Reppes, John de, of Thorp Market, son of Richard 0
4556648 2218012 2218012 plaintiff Hylbrond Thomas   633612 633612 Hylbrond, Thomas, of Thorp Market, vicar 0
4574308 2223494 2223494 defendant Barbour Nicholas   633612 633612 Barbour, Nicholas, of Thorp Market 1
4593708 2229306 2229306 plaintiff Penere Thomas   633612 633612 Penere, Thomas, of Thorp Market, warden of a third part of the manor 0
4593709 2229306 2229306 defendant Bippes John   633612 633612 Bippes, John, of Thorp Market 0
4593710 2229306 2229306 defendant Robynesson John   633612 633612 Robynesson, John, of Thorp Market 1
4605845 2232941 2232941 defendant Benedyte William   633612 633612 Benedyte, William, of Thorp Market 2
4630672 2240499 2240499 defendant Wolvene John   633612 633612 Wolvene, John, of Thorp Market, vicar 8
4630682 2240500 2240500 defendant Wolvene John   633612 633612 Wolvene, John, of Thorp Market, vicar 4
4667236 2255485 2255485 defendant Bippes John   633612 633612 Bippes, John, of Thorp Market 0
4667238 2255486 2255486 defendant Bippes John   633612 633612 Bippes, John, of Thorp Market 0
4694465 2263763 2263763 plaintiff Makke John   633612 633612 Makke, John, of Thorp Market 2
4709648 2268382 2268382 defendant Groom Roger   633612 633612 Groom, Roger, of Thorp Market, shoe maker 0
4709652 2268384 2268384 defendant Groom Roger   633612 633612 Groom, Roger, of Thorp Market, shoe maker 0
4733515 2275657 2275657 defendant Reppys John husbandman 633612 633612 Reppys, John, of Thorp Market, husbandman 2
4878636 2320260 2320260 defendant Grom Roger yeoman 633612 633612 Grom, Roger, of Thorp Market, yeoman 2
4954958 2343441 2343441 defendant Groom Roger yeoman 633612 633612 Groom, Roger, of Thorp Market, yeoman 0
5028982 2365345 2365345 defendant Skardeburgh Robert shoemaker 633612 633612 Skardeburgh, Robert, of Thorp Market, shoemaker 0
5036396 2367501 2367501 defendant Groom Roger yeoman 633612 633612 Groom, Roger, of Thorp Market, yeoman 0
5062460 2375339 2375339 defendant Reppes Robert gent 633612 633612 Reppes, Robert, of Thorp Market, gent 0
5116035 2391118 2391118 defendant Wode Robert husbandman 633612 633612 Wode, Robert, of Thorp Market, husbandman 2
5124850 2393741 2393741 plaintiff Amys Henry   633612 633612 Amys, Henry, of Thorp Market 0
5224663 2422883 2422883 defendant Erl William yeoman 633612 633612 Erl, William, of Thorp Market, yeoman 0
5278535 2438831 2438831 defendant Colard Robert laborer 633612 633612 Colard, Robert, of Thorp Market, laborer 0
5285717 2440850 2440850 plaintiff Hanworth Adam   633612 633612 Hanworth, Adam, of Thorp Market, 2
5289532 2441940 2441940 defendant Aleyns Robert yeoman 633612 633612 Aleyns, Robert, of Thorp Market, yeoman 0
5296555 2443982 2443982 defendant Wode Robert gent 633612 633612 Wode, Robert, of Thorp Market, gent 0
5358401 2462680 2462680 defendant Ode Richard husbandman 633612 633612 Ode, Richard, of Thorp Market, husbandman 6
5365346 2464834 2464834 defendant Starlyng John husbandman 633612 633612 Starlyng, John, of Thorp market, husbandman 1
5380151 2469372 2469372 defendant Starlyng John husbandman 633612 633612 Starlyng, John, of Thorp Market, husbandman 1
5384250 2470585 2470585 defendant Starlyng John husbandman 633612 633612 Starlyng, John, of Thorp Market, husbandman 0
5409350 2477768 2477768 defendant Starlyng John husbandman 633612 633612 Starlyng, John, of Thorp Market, husbandman 0
5458325 2492386 2492386 defendant Amys Henry yeoman 633612 633612 Amys, Henry, of Thorp Market, yeoman 0
5539184 2516741 2516741 defendant Ameys Henry (legal representative) 633612 633612 Ameys, Henry, of Thorp Market, yeoman, executor of 0
5544136 2518281 2518281 defendant Woode Richard spicer 633612 633612 Woode, Richard, of Thorp Market, spicer 1
5548363 2519555 2519555 plaintiff Asshwell Richard   633612 633612 Asshwell, Richard, of Thorp Market, worsted weaver 0
5548364 2519555 2519555 defendant Haneworth Thomas   633612 633612 Haneworth, Thomas, of Thorp Market, worsted weaver 0
5595652 2533563 2533563 defendant Ode Thomas yeoman 633612 633612 Ode, Thomas, of Thorp Market, 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);