names

65 rows where place_id = 604822

✎ 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
3659384 1913195 1913195 defendant Grena Richard butcher 604822 604822 Grena, Richard, of Wolvernehampton, butcher 1
3705750 1928079 1928079 defendant Smyth John butcher 604822 604822 Smyth, John, of Wolvernehampton, butcher 0
3716193 1931357 1931357 defendant Barton Ralph tailor 604822 604822 Barton, Ralph, of Wolvernehampton, tailor 0
3732519 1936401 1936401 defendant Smale William dyer 604822 604822 Smale, William, of Wolvernehampton, dyer 3
3733289 1936644 1936644 defendant Fletcher John fletcher 604822 604822 Fletcher, John, of Wolvernehampton, fletcher 0
3750342 1942024 1942024 defendant Salford William gent 604822 604822 Salford, William, of Wolvernehampton, gent 0
3750355 1942030 1942030 defendant Smale William dyer 604822 604822 Smale, William, of Wolvernehampton, dyer 0
3760131 1945164 1945164 defendant Lane William butcher 604822 604822 Lane, William, of Wolvernehampton, butcher 1
3765833 1946979 1946979 defendant Salford William gent 604822 604822 Salford, William, of Wolvernehampton, gent 0
3778132 1950870 1950870 defendant Cawle Edmund tanner 604822 604822 Cawle, Edmund, of Wolvernehampton, tanner 3
3783273 1952520 1952520 defendant Bynge James mercer 604822 604822 Bynge, James, of Wolvernehampton, mercer 2
3783275 1952520 1952520 defendant Grene Richard spurrier 604822 604822 Grene, Richard, of Wolvernehampton, spurrier 4
3792751 1955586 1955586 defendant Rideley Richard gent 604822 604822 Rideley, Richard, of Wolvernehampton, gent 1
3797625 1957155 1957155 defendant Heylyn Nicholas merchant of the staple 604822 604822 Heylyn, Nicholas, of Wolvernehampton, merchant of the staple 0
3797626 1957155 1957155 defendant Ridley Richard gent 604822 604822 Ridley, Richard, of Wolvernehampton, gent 1
3812476 1961790 1961790 defendant Cowley Richard drover 604822 604822 Cowley, Richard, of Wolvernehampton, drover 0
3812483 1961791 1961791 defendant Grene Richard butcher 604822 604822 Grene, Richard, of Wolvernehampton, butcher 5
3814890 1962573 1962573 defendant Smyth Thomas yeoman 604822 604822 Smyth, Thomas, of Wolvernehampton, yeoman 0
3821422 1964594 1964594 defendant Bynge James mercer 604822 604822 Bynge, James, of Wolvernehampton, mercer 0
3821423 1964594 1964594 defendant Grene Richard spurrier 604822 604822 Grene, Richard, of Wolvernehampton, spurrier 1
3821424 1964594 1964594 defendant Jenkys Roger tailor 604822 604822 Jenkys, Roger, of Wolvernehampton, tailor 2
3844151 1971719 1971719 defendant Wryte Richard miller 604822 604822 Wryte, Richard, of Wolvernehampton, miller 0
3860118 1976881 1976881 defendant Hyggyns John butcher 604822 604822 Hyggyns, John, of Wolvernehampton, butcher 1
3860119 1976881 1976881 defendant Bynge James mercer 604822 604822 Bynge, James, of Wolvernehampton, mercer 2
3864493 1978325 1978325 defendant Salteford William gent 604822 604822 Salteford, William, of Wolvernehampton, gent 0
4417517 2170366 2170366 defendant Fox Emma le   604822 604822 Fox, Emma le, of Wolvernehampton, formerly wife of Henry 0
4447136 2184011 2184011 defendant Hulton Richard   604822 604822 Hulton, Richard, of Wolvernehampton 0
4467263 2190437 2190437 plaintiff Atte Lynde John   604822 604822 Atte Lynde, John, of Wolvernehampton 0
4494145 2198860 2198860 defendant Waturfall John   604822 604822 Waturfall, John, of Wolvernehampton 0
4501306 2201012 2201012 defendant Bagot John   604822 604822 Bagot, John, of Wolvernehampton 0
4501307 2201012 2201012 defendant Stafford Thomas de   604822 604822 Stafford, Thomas de, of Wolvernehampton 1
4511492 2204039 2204039 defendant Elys John   604822 604822 Elys, John, of Wolvernehampton 7
4511708 2204109 2204109 defendant atte Lynde John   604822 604822 atte Lynde, John, of Wolvernehampton 0
4524834 2208106 2208106 defendant Bagot John   604822 604822 Bagot, John, of Wolvernehampton 0
4554796 2217427 2217427 defendant atte Lee Henry   604822 604822 atte Lee, Henry, of Wolvernehampton 0
4580528 2225399 2225399 defendant Smyth John   604822 604822 Smyth, John, of Wolvernehampton 1
4624237 2238566 2238566 defendant Jurdans Clement   604822 604822 Jurdans, Clement, of Wolvernehampton 0
4789503 2292786 2292786 plaintiff Hychecokes John chapman 604822 604822 Hychecokes, John, of Wolvernehampton, chapman 0
4789505 2292787 2292787 plaintiff Hychecokes John chapman 604822 604822 Hychecokes, John, of Wolvernehampton, chapman 0
4814778 2300737 2300737 plaintiff Kelynge Robert   604822 604822 Kelynge, Robert, of Wolvernehampton 0
4884820 2322154 2322154 defendant Bowyer Peter bowyer 604822 604822 Bowyer, Peter, of Wolvernehampton, bowyer 2
4902695 2327462 2327462 defendant Bowyer Peter bowyer 604822 604822 Bowyer, Peter, of Wolvernehampton, bowyer 2
4929622 2335679 2335679 defendant Colyns Thomas husbandman 604822 604822 Colyns, Thomas, of Wolvernehampton, husbandman 0
5028275 2365147 2365147 defendant Tawer John yeoman 604822 604822 Tawer, John, of Wolvernehampton, yeoman 0
5082718 2381333 2381333 defendant Loveson Nicholas   604822 604822 Loveson, Nicholas, of Wolvernehampton gent 0
5101251 2386776 2386776 defendant Tolle Reginald gent 604822 604822 Tolle, Reginald, of Wolvernehampton, gent 0
5101252 2386776 2386776 defendant Rynge Richard butcher 604822 604822 Rynge, Richard, of Wolvernehampton, butcher 1
5212727 2419469 2419469 defendant Wales John yeoman 604822 604822 Wales, John, of Wolvernehampton, yeoman 0
5219572 2421459 2421459 defendant Wales John merchant 604822 604822 Wales, John, of Wolvernehampton, merchant 1
5256634 2432194 2432194 defendant Salford John gent 604822 604822 Salford, John, of Wolvernehampton, gent 0
5256635 2432194 2432194 defendant Alwey Thomas laborer 604822 604822 together with Alwey, Thomas, of Wolvernehampton, laborer 1
5256636 2432194 2432194 defendant Baker John laborer 604822 604822 Baker, John, of Wolvernehampton, laborer 2
5256637 2432194 2432194 defendant Davy William laborer 604822 604822 Davy, William, of Wolvernehampton, laborer 3
5256638 2432194 2432194 defendant Hykmans William tailor 604822 604822 Hykmans, William, of Wolvernehampton, tailor 4
5256639 2432194 2432194 defendant Stokton William laborer 604822 604822 Stokton, William, of Wolvernehampton, laborer 5
5256640 2432194 2432194 defendant Bente Thomas butcher 604822 604822 Bente, Thomas, of Wolvernehampton, butcher 6
5270765 2436549 2436549 defendant Ryng Thomas weaver 604822 604822 Ryng, Thomas, of Wolvernehampton, weaver 2
5282258 2439871 2439871 defendant Muchell William dyer 604822 604822 Muchell, William, of Wolvernehampton, dyer 0
5282259 2439871 2439871 defendant Tomson Thomas barker 604822 604822 Tomson, Thomas, of Wolvernehampton, barker 1
5295087 2443551 2443551 plaintiff Tolle Reginald   604822 604822 Tolle, Reginald, of Wolvernehampton 0
5295514 2443677 2443677 defendant Colyns Thomas husbandman 604822 604822 Colyns, Thomas, of Wolvernehampton, husbandman 0
5295516 2443678 2443678 defendant Colyns Thomas husbandman 604822 604822 Colyns, Thomas, of Wolvernehampton, husbandman 0
5330887 2454307 2454307 defendant Dudrych Richard weaver 604822 604822 Dudrych, Richard, of Wolvernehampton, weaver 4
5495367 2503515 2503515 defendant Westurffeld John yeoman 604822 604822 Westurffeld, John, of Wolvernehampton, yeoman 1
5502050 2505562 2505562 defendant Grene Nicholas butcher 604822 604822 Grene, Nicholas, of Wolvernehampton, butcher 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);