names

51 rows where place_id = 605142

✎ 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
3660544 1913559 1913559 defendant Norne William yeoman 605142 605142 Norne, William, of Stafford, Staffs, yeoman 1
3926651 1999247 1999247 defendant Lant Robert, senior yeoman 605142 605142 Lant, Robert, senior, of Stafford, Staffs, yeoman 1
3928564 1999894 1999894 defendant Clemens Jamaes capper 605142 605142 Clemens, Jamaes, of Stafford, Staffs, capper 0
3936134 2002408 2002408 defendant Bockeley William chapman 605142 605142 Bockeley, William, of Stafford, Staffs, chapman 0
3936836 2002653 2002653 defendant Doryngton Francis chapman 605142 605142 Doryngton, Francis, of Stafford, Staffs, chapman 0
4744702 2278968 2278968 defendant Wodman Henry carrier 605142 605142 Wodman, Henry, of Stafford, Staffs, carrier 0
4748620 2280093 2280093 defendant Heuster Adam yeoman 605142 605142 Heuster, Adam, of Stafford, Staffs, yeoman 0
4755904 2282230 2282230 defendant Stanford Hugh de gent 605142 605142 Stanford, Hugh de, of Stafford, Staffs, gent 1
4772921 2287501 2287501 defendant Whitgrave William mercer 605142 605142 Whitgrave, William, of Stafford, Staffs, mercer 0
4850265 2311540 2311540 defendant Boughhey John gent 605142 605142 Boughhey, John, of Stafford, Staffs, gent 0
4925040 2334265 2334265 defendant Palmer Isabel widow 605142 605142 (Palmer, Isabel, of Stafford, Staffs, widow 1
4991685 2354397 2354397 defendant Bromwyche John skinner 605142 605142 Bromwyche, John, of Stafford, Staffs, skinner 2
5048860 2371293 2371293 defendant Middelton John glover 605142 605142 Middelton, John, of Stafford, Staffs, glover 1
5048871 2371295 2371295 defendant Middelton John glover 605142 605142 Middelton, John, of Stafford, Staffs, glover 1
5051485 2372057 2372057 defendant Nowell John sadler 605142 605142 Nowell, John, of Stafford, Staffs, sadler 0
5158196 2403517 2403517 defendant Boweghey John yeoman 605142 605142 Boweghey, John, of Stafford, Staffs, yeoman 3
5173857 2408051 2408051 defendant Boweghey John yeoman 605142 605142 Boweghey, John, of Stafford, Staffs, yeoman 3
5188836 2412463 2412463 defendant Waram William mercer 605142 605142 Waram, William, of Stafford, Staffs, mercer 3
5194034 2413989 2413989 defendant Boweghtey John yeoman 605142 605142 Boweghtey, John, of Stafford, Staffs, yeoman 3
5194054 2413995 2413995 defendant Mawedeley Nicholas yeoman 605142 605142 Mawedeley, Nicholas, of Stafford, Staffs, yeoman 0
5208516 2418221 2418221 defendant Boweghtey John yeoman 605142 605142 Boweghtey, John, of Stafford, Staffs, yeoman 3
5208518 2418222 2418222 defendant Mawedeley Nicholas yeoman 605142 605142 Mawedeley, Nicholas, of Stafford, Staffs, yeoman 0
5208520 2418222 2418222 defendant Boweghtey John yeoman 605142 605142 Boweghtey, John, of Stafford, Staffs, yeoman 2
5267821 2435698 2435698 defendant Thiknes Ralph gent 605142 605142 Thiknes, Ralph, of Stafford, Staffs, gent 0
5270763 2436549 2436549 defendant Thiknes Ralph gent 605142 605142 Thiknes, Ralph, of Stafford, Staffs, gent 0
5270767 2436550 2436550 defendant Thiknes Ralph   605142 605142 Thiknes, Ralph, of Stafford, Staffs 0
5310705 2448238 2448238 defendant Draycotes Roger esq 605142 605142 Draycotes, Roger, of Stafford, Staffs, esq 0
5311113 2448355 2448355 defendant Auncell John dyer 605142 605142 Auncell, John, of Stafford, Staffs, dyer 0
5382251 2469983 2469983 defendant Barbour Humphrey gent 605142 605142 Barbour, Humphrey, of Stafford, Staffs, gent 1
5385093 2470811 2470811 defendant Millys John chapman 605142 605142 Millys, John, of Stafford, Staffs, chapman 2
5386661 2471247 2471247 defendant Barbour Humphrey gent 605142 605142 Barbour, Humphrey, of Stafford, Staffs, gent 1
5386967 2471339 2471339 defendant Whitgreve Robert (legal representative) 605142 605142 Whitgreve, Robert, of Stafford, Staffs, esq, administrator of 0
5386968 2471339 2471339 defendant Whitgreve Thomas clerk 605142 605142 Whitgreve, Thomas, of Stafford, Staffs, clerk 1
5397123 2474260 2474260 defendant Myllis John chapman 605142 605142 Myllis, John, of Stafford, Staffs, chapman 2
5397181 2474278 2474278 defendant Millys John chapman 605142 605142 Millys, John, of Stafford, Staffs, chapman 2
5397842 2474453 2474453 defendant Bret William yeoman 605142 605142 Bret, William, of Stafford, Staffs, yeoman 0
5404088 2476247 2476247 defendant Barbour Humphrey gent 605142 605142 Barbour, Humphrey, of Stafford, Staffs, gent 1
5411005 2478245 2478245 defendant Brete William yeoman 605142 605142 Brete, William, of Stafford, Staffs, yeoman 0
5415674 2479632 2479632 defendant Barbour Humphrey gent 605142 605142 Barbour, Humphrey, of Stafford, Staffs, gent 1
5424519 2482304 2482304 defendant Millys Richard   605142 605142 Millys, Richard, of Stafford, Staffs 0
5432114 2484573 2484573 defendant Barbour Humphrey gent 605142 605142 Barbour, Humphrey, of Stafford, Staffs, gent 1
5434419 2485234 2485234 defendant Barbour Humphrey gent 605142 605142 Barbour, Humphrey, of Stafford, Staffs, gent 1
5437665 2486198 2486198 defendant Rodon Thomas dyer 605142 605142 Rodon, Thomas, of Stafford, Staffs, dyer 4
5443284 2487910 2487910 defendant Millis Richard mercer 605142 605142 Millis, Richard, of Stafford, Staffs, mercer 0
5443288 2487911 2487911 defendant Millys Richard mercer 605142 605142 Millys, Richard, of Stafford, Staffs, mercer 0
5462261 2493614 2493614 defendant Botre Roger barber 605142 605142 Botre, Roger, of Stafford, Staffs, barber 0
5462265 2493615 2493615 defendant Roodon Thomas dyer 605142 605142 Roodon, Thomas, of Stafford, Staffs, dyer 0
5466100 2494798 2494798 defendant Botre Roger tanner 605142 605142 Botre, Roger, of Stafford, Staffs, tanner 0
5473501 2497037 2497037 defendant Barbour Humphrey   605142 605142 Barbour, Humphrey, of Stafford, Staffs 1
5473865 2497163 2497163 defendant Roodon Thomas dyer 605142 605142 Roodon, Thomas, of Stafford, Staffs, dyer 0
5608442 2537541 2537541 defendant Myllis John chapman 605142 605142 Myllis, John, of Stafford, Staffs, chapman 2

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