names

53 rows where place_id = 823271

✎ 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
4927205 2334944 2334944 defendant Harry Robert glover 823271 823271 Harry, Robert, of Great Totnes, glover 0
5049798 2371569 2371569 defendant Lynyer Nicholas order of the Holy Trinity & the Redemption of captives 823271 823271 Lynyer, Nicholas, of Great Totnes, minister of the House of Holy Spirit of Warlond, order of the Holy Trinity & the Redemption of captives 0
5131091 2395582 2395582 defendant Hewe Walter yeoman 823271 823271 Hewe, Walter, of Great Totnes, yeoman 0
5138804 2397850 2397850 defendant Canbon John yeoman 823271 823271 Canbon, John, of Great Totnes, yeoman 0
5138805 2397850 2397850 defendant Carpenter Henry   823271 823271 Carpenter, Henry, of Great Totnes 1
5138806 2397850 2397850 defendant Tolke John yeoman 823271 823271 Tolke, John, of Great Totnes, yeoman 2
5138807 2397850 2397850 defendant --out Richard   823271 823271 --out, Richard, of Great Totnes 3
5150595 2401319 2401319 defendant Howe Walter yeoman 823271 823271 Howe, Walter, of Great Totnes, yeoman 0
5150597 2401320 2401320 defendant Howe Walter yeoman 823271 823271 Howe, Walter, of Great Totnes, yeoman 0
5169059 2406685 2406685 defendant Howe Walter yeoman 823271 823271 Howe, Walter, of Great Totnes, yeoman 0
5169061 2406686 2406686 defendant Howe Walter yeoman 823271 823271 Howe, Walter, of Great Totnes, yeoman 0
5184364 2411164 2411164 defendant John David yeoman 823271 823271 John, David, of Great Totnes, yeoman 5
5192972 2413671 2413671 defendant Norwych Richard dyer 823271 823271 Norwych, Richard, of Great Totnes, dyer 0
5204278 2417004 2417004 defendant John David husbandman 823271 823271 John, David, of Great Totnes, husbandman 1
5204813 2417158 2417158 defendant Andrewe John yeoman 823271 823271 Andrewe, John, of Great Totnes, yeoman 0
5303117 2445922 2445922 defendant Franke Ambrose baker 823271 823271 Franke, Ambrose, of Great Totnes, baker 0
5303118 2445922 2445922 defendant Noseworthy John smith 823271 823271 Noseworthy, John, of Great Totnes, smith 1
5367936 2465595 2465595 defendant Gardyner John clerk 823271 823271 Gardyner, John, of Great Totnes, clerk 0
5367976 2465609 2465609 defendant Gardyner John clerk 823271 823271 Gardyner, John, of Great Totnes, clerk 1
5367979 2465610 2465610 defendant Gardyner John clerk 823271 823271 Gardyner, John, of Great Totnes, clerk 1
5379444 2469162 2469162 defendant Saverey Michael   823271 823271 Saverey, Michael, of Great Totnes, shoe maker 0
5394794 2473579 2473579 defendant Saveray Michael shoemaker 823271 823271 Saveray, Michael, of Great Totnes, shoemaker 0
5394795 2473579 2473579 defendant Kent Benedict goldsmith 823271 823271 Kent, Benedict, of Great Totnes, goldsmith 1
5394796 2473579 2473579 defendant Limburne John yeoman 823271 823271 Limburne, John, of Great Totnes, yeoman 2
5398614 2474665 2474665 defendant Smale William butcher 823271 823271 Smale, William, of Great Totnes, butcher 0
5400533 2475218 2475218 defendant Antron Walter sheer man 823271 823271 (Antron, Walter, of Great Totnes, sheer man 1
5408045 2477380 2477380 defendant Saverey John   823271 823271 Saverey, John, of Great Totnes, cord wainer 0
5408046 2477380 2477380 defendant Kent Benedict goldsmith 823271 823271 Kent, Benedict, of Great Totnes, goldsmith 1
5408047 2477380 2477380 defendant Lamburne John yeoman 823271 823271 Lamburne, John, of Great Totnes, yeoman 2
5411740 2478463 2478463 defendant Smale William butcher 823271 823271 Smale, William, of Great Totnes, butcher 0
5413551 2478975 2478975 defendant Autron Walter sheerman 823271 823271 (Autron, Walter, of Great Totnes, sheerman 1
5414015 2479130 2479130 defendant Stevyn Richard yeoman 823271 823271 Stevyn, Richard, of Great Totnes, yeoman 0
5420187 2480956 2480956 defendant Holman John barber 823271 823271 Holman, John, of Great Totnes, barber 0
5421230 2481282 2481282 defendant Saverey Michael shoemaker 823271 823271 Saverey, Michael, of Great Totnes, shoemaker 0
5421231 2481282 2481282 defendant Kent Benedict goldsmith 823271 823271 Kent, Benedict, of Great Totnes, goldsmith 1
5421232 2481282 2481282 defendant Lamburn John yeoman 823271 823271 Lamburn, John, of Great Totnes, yeoman 2
5426187 2482785 2482785 defendant Smale William butcher 823271 823271 Smale, William, of Great Totnes, butcher 0
5426189 2482786 2482786 defendant Smale William butcher 823271 823271 Smale, William, of Great Totnes, butcher 0
5426503 2482873 2482873 defendant Stevyn Richard yeoman 823271 823271 Stevyn, Richard, of Great Totnes, yeoman 0
5427128 2483051 2483051 defendant Bughton Robert yeoman 823271 823271 Bughton, Robert, of Great Totnes, yeoman 0
5435224 2485466 2485466 defendant Nosworthy John smith 823271 823271 Nosworthy, John, of Great Totnes, smith 0
5441027 2487225 2487225 defendant William John   823271 823271 William, John, of Great Totnes 0
5441028 2487225 2487225 defendant William William spinner 823271 823271 William, William, of Great Totnes, spinner 1
5449192 2489644 2489644 defendant Kent Benedict goldsmith 823271 823271 Kent, Benedict, of Great Totnes, goldsmith 0
5450294 2489971 2489971 defendant Noseworthy John smith 823271 823271 Noseworthy, John, of Great Totnes, smith 0
5457703 2492202 2492202 defendant William John haulier 823271 823271 William, John, of Great Totnes, haulier 0
5457705 2492202 2492202 defendant William William spinter 823271 823271 William, William, of Great Totnes, spinter 2
5469484 2495798 2495798 defendant Bughton Robert yeoman 823271 823271 Bughton, Robert, of Great Totnes, yeoman 0
5471676 2496477 2496477 defendant Cosby Walter baker 823271 823271 Cosby, Walter, of Great Totnes, baker 0
5471677 2496477 2496477 defendant Touker John baker 823271 823271 Touker, John, of Great Totnes, baker 1
5472987 2496875 2496875 defendant Kent Benedict goldsmith 823271 823271 Kent, Benedict, of Great Totnes, goldsmith 0
5474856 2497463 2497463 defendant Soper Richard baker 823271 823271 Soper, Richard, of Great Totnes, baker 0
5474857 2497463 2497463 defendant Lamborne John brewer 823271 823271 Lamborne, John, of Great Totnes, brewer 1

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