names

64 rows where place_id = 590961

✎ 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
3602827 1868554 1868554 defendant Rowe John carpenter 590961 590961 Rowe, John, of Bildeston, carpenter 2
3603059 1868624 1868624 defendant Couper Thomas fuller 590961 590961 Couper, Thomas, of Bildeston, fuller 0
3603988 1868914 1868914 defendant Couper alias Cokok Thomas clothmaker 590961 590961 Couper alias Cokok, Thomas, of Bildeston, clothmaker 0
3605630 1869426 1869426 defendant Coke Simon clothmaker 590961 590961 Coke, Simon, of Bildeston, clothmaker 0
3605631 1869426 1869426 defendant Gosselyn John clothmaker 590961 590961 Gosselyn, John, of Bildeston, clothmaker 1
4223391 2103674 2103674 defendant Abbott Thomas yeoman 590961 590961 Abbott, Thomas, of Bildeston, yeoman 0
4223392 2103674 2103674 defendant Vynsent Nicholas tanner 590961 590961 Vynsent, Nicholas, of Bildeston, tanner 1
4242064 2110340 2110340 defendant Blomfild William blacksmith 590961 590961 Blomfild, William, of Bildeston, blacksmith 1
4242109 2110355 2110355 defendant Osmonde Elizabeth widow 590961 590961 Osmonde, Elizabeth, of Bildeston, widow 1
4243124 2110691 2110691 defendant Bovye William cooper 590961 590961 Bovye, William, of Bildeston, cooper 1
4248911 2112621 2112621 defendant Elye William tanner 590961 590961 Elye, William, of Bildeston, tanner 0
4481945 2195060 2195060 defendant Marchaunt Alflesia   590961 590961 Marchaunt, Alflesia, of Bildeston, formerly wife of Thomas 0
4513544 2204659 2204659 defendant Shepherde John   590961 590961 Shepherde, John, of Bildeston 1
4525774 2208365 2208365 defendant Bradefeld Thomas   590961 590961 together with Bradefeld, Thomas, of Bildeston 1
4525779 2208366 2208366 defendant Bradefeld Thomas   590961 590961 together with Bradefeld, Thomas, of Bildeston 1
4534612 2211094 2211094 defendant Peyntour John   590961 590961 Peyntour, John, of Bildeston 1
4545995 2214687 2214687 defendant Shepherd Nicholas   590961 590961 Shepherd, Nicholas, of Bildeston 0
4553679 2217076 2217076 defendant Bevys John   590961 590961 Bevys, John, of Bildeston 2
4571722 2222735 2222735 defendant Randolf Walter   590961 590961 Randolf, Walter, of Bildeston 0
4586544 2227200 2227200 defendant Skippelond Robert   590961 590961 Skippelond, Robert, of Bildeston 0
4586546 2227201 2227201 defendant Skyppelond Robert   590961 590961 Skyppelond, Robert, of Bildeston 0
4589427 2228068 2228068 defendant Anystace Robert   590961 590961 Anystace, Robert, of Bildeston 3
4609372 2234031 2234031 defendant Smyth Richard   590961 590961 Smyth, Richard, of Bildeston 1
4631320 2240687 2240687 defendant Pertryche John   590961 590961 Pertryche, John, of Bildeston 6
4631321 2240687 2240687 defendant Meller John   590961 590961 Meller, John, of Bildeston 7
4653532 2247038 2247038 plaintiff Belle John   590961 590961 Belle, John, of Bildeston 0
4672276 2256977 2256977 plaintiff Jerveys John   590961 590961 Jerveys, John, of Bildeston 1
4683938 2260588 2260588 plaintiff Baron John   590961 590961 Baron, John, of Bildeston 1
4695466 2264061 2264061 defendant Howarde Thomas mercer 590961 590961 Howarde, Thomas, of Bildeston, mercer 0
4697487 2264701 2264701 defendant Talbot Simon yeoman 590961 590961 Talbot, Simon, of Bildeston, yeoman 0
4722584 2272379 2272379 defendant Howard Thomas yeoman 590961 590961 Howard, Thomas, of Bildeston, yeoman 0
4741965 2278148 2278148 defendant Bargh John, junior husbandman 590961 590961 Bargh, John, junior, of Bildeston, husbandman 0
4765152 2285079 2285079 defendant Broun Thomas baker 590961 590961 Broun, Thomas, of Bildeston, baker 2
4780027 2289755 2289755 defendant Skiplond John fuller 590961 590961 Skiplond, John, of Bildeston, fuller 0
4780033 2289758 2289758 defendant Skiplond John fuller 590961 590961 Skiplond, John, of Bildeston, fuller 0
4801977 2296802 2296802 defendant Peyntour John painter 590961 590961 Peyntour, John, of Bildeston, painter 1
4915958 2331488 2331488 defendant Bakeler John baker 590961 590961 Bakeler, John, of Bildeston, baker 0
4925109 2334284 2334284 defendant Howell Geoffrey dyer 590961 590961 Howell, Geoffrey, of Bildeston, dyer 1
4932580 2336582 2336582 defendant Bargh John chapman 590961 590961 Bargh, John, of Bildeston, chapman 2
5035927 2367364 2367364 defendant Aleyn John cordwainer 590961 590961 Aleyn, John, of Bildeston, cordwainer 1
5060725 2374788 2374788 defendant Motte William carpenter 590961 590961 Motte, William, of Bildeston, carpenter 1
5096704 2385472 2385472 defendant Raufe Walter husbandman 590961 590961 Raufe, Walter, of Bildeston, husbandman 4
5100960 2386694 2386694 defendant Horold John, senior husbandman 590961 590961 Horold, John, senior, of Bildeston, husbandman 0
5150905 2401404 2401404 defendant Shepherd Robert tanner 590961 590961 Shepherd, Robert, of Bildeston, tanner 0
5154575 2402492 2402492 defendant Motte John (legal representative) 590961 590961 Motte, John, of Bildeston, merchant, executors of 0
5154576 2402492 2402492 defendant Whitop William husbandman 590961 590961 (Whitop, William, of Bildeston, husbandman 1
5169470 2406808 2406808 defendant Shepherd Robert tanner 590961 590961 Shepherd, Robert, of Bildeston, tanner 0
5190182 2412870 2412870 defendant Motte John (legal representative) 590961 590961 Motte, John, of Bildeston, merchant, executors of 2
5190183 2412870 2412870 defendant Whitop William yeoman 590961 590961 (Whitop, William, of Bildeston, yeoman 3
5190191 2412871 2412871 defendant Motte John (legal representative) 590961 590961 Motte, John, of Bildeston, merchant, executors of 2
5190192 2412871 2412871 defendant Whitop William yeoman 590961 590961 (Whitop, William, of Bildeston, yeoman 3
5206800 2417725 2417725 defendant Motte John (legal representative) 590961 590961 Motte, John, of Bildeston, merchant, executors of 0
5206801 2417725 2417725 defendant Whytop William yeoman 590961 590961 (Whytop, William, of Bildeston, yeoman 1
5237039 2426415 2426415 defendant Goodale John carpenter 590961 590961 Goodale, John, of Bildeston, carpenter 3
5279530 2439090 2439090 defendant Horold Thomas husbandman 590961 590961 Horold, Thomas, of Bildeston, husbandman 0
5279531 2439090 2439090 defendant Carter John husbandman 590961 590961 Carter, John, of Bildeston, husbandman 1
5393478 2473189 2473189 defendant Havell or Hanell John mercer 590961 590961 Havell or Hanell, John, of Bildeston, mercer 0
5406635 2476965 2476965 defendant Hanell or Havell John mercer 590961 590961 Hanell or Havell, John, of Bildeston, mercer 0
5423435 2481968 2481968 defendant Cook William yeoman 590961 590961 Cook, William, of Bildeston, yeoman 4
5442742 2487741 2487741 defendant Cook William yeoman 590961 590961 Cook, William, of Bildeston, yeoman 4
5455428 2491537 2491537 defendant Cook William yeoman 590961 590961 Cook, William, of Bildeston, yeoman 0
5455436 2491538 2491538 defendant Cook William yeoman 590961 590961 Cook, William, of Bildeston, yeoman 4
5489882 2501859 2501859 defendant Cook John clothmaker 590961 590961 Cook, John, of Bildeston, clothmaker 0
5627659 2552623 2552623 defendant Wade Simon fuller 590961 590961 Wade, Simon, of Bildeston, fuller 5

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