names

51 rows where place_id = 588945

✎ 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
3596078 1866402 1866402 defendant Barker John yeoman 588945 588945 Barker, John, of Hempstede, yeoman 1
3692354 1923781 1923781 defendant Rose Edmund husbandman 588945 588945 Rose, Edmund, of Hempstede, husbandman 0
3705134 1927894 1927894 defendant Hawkyns John husbandman 588945 588945 Hawkyns, John, of Hempstede, husbandman 0
3727159 1934765 1934765 defendant Parteryge John husbandman 588945 588945 Parteryge, John, of Hempstede, husbandman 3
3943269 2004769 2004769 plaintiff Alleyn Robert yeoman 588945 588945 Alleyn, Robert, of Hempstede, yeoman 0
3966673 2012981 2012981 plaintiff Brettyngham Nicholas   588945 588945 Brettyngham, Nicholas, of Hempstede, worsted weaver 0
4004747 2026474 2026474 plaintiff Johnson Robert singleman 588945 588945 Johnson, Robert, of Hempstede, singleman 0
4057439 2045042 2045042 defendant Hert Stephen husbandman 588945 588945 together with Hert, Stephen, of Hempstede, husbandman 1
4396605 2163429 2163429 defendant Morgan Richard yeoman 588945 588945 Morgan, Richard, of Hempstede, yeoman 2
4500754 2200850 2200850 defendant Aleyn Robert   588945 588945 Aleyn, Robert, of Hempstede 1
4501078 2200941 2200941 defendant Marchall Thomas brother & heir of Henry Marchall 588945 588945 Marchall, Thomas, of Hempstede, brother & heir of Henry Marchall 0
4541310 2213180 2213180 defendant Wyncelowe John   588945 588945 Wyncelowe, John, of Hempstede 0
4570157 2222238 2222238 defendant Wyncelowe John   588945 588945 Wyncelowe, John, of Hempstede 0
4594517 2229542 2229542 defendant Shyryngham Edmund   588945 588945 Shyryngham, Edmund, of Hempstede 0
4617402 2236455 2236455 defendant Heryon William   588945 588945 Heryon, William, of Hempstede 0
4645623 2244788 2244788 defendant Pyn John   588945 588945 Pyn, John, of Hempstede 9
4660946 2249248 2249248 defendant Brounyng John yeoman 588945 588945 Brounyng, John, of Hempstede, yeoman 1
4660947 2249248 2249248 defendant Chymme John yeoman 588945 588945 Chymme, John, of Hempstede, yeoman 2
4665256 2250620 2250620 defendant Trench John yeoman 588945 588945 Trench, John, of Hempstede, yeoman 2
4665257 2250620 2250620 defendant Custauns John yeoman 588945 588945 Custauns, John, of Hempstede, yeoman 3
4667344 2255513 2255513 defendant Chapelyen Henry laborer 588945 588945 Chapelyen, Henry, of Hempstede, laborer 0
4667345 2255513 2255513 defendant Hayron John husbandman 588945 588945 Hayron, John, of Hempstede, husbandman 1
4667346 2255513 2255513 defendant Nyrlynge John   588945 588945 Nyrlynge, John, of Hempstede, holy water clerk 2
4680772 2259605 2259605 defendant atte Welle John miller 588945 588945 atte Welle, John, of Hempstede, miller 1
4691277 2262794 2262794 defendant Sheryngham Edmund yeoman 588945 588945 Sheryngham, Edmund, of Hempstede, yeoman 0
4691279 2262795 2262795 defendant Sheryngham Edmund yeoman 588945 588945 Sheryngham, Edmund, of Hempstede, yeoman 0
4783155 2290747 2290747 plaintiff Dalton William   588945 588945 Dalton, William, of Hempstede 0
4791581 2293461 2293461 defendant White John laborer 588945 588945 White, John, of Hempstede, laborer 0
4814280 2300571 2300571 defendant Walkelyne Robert husbandman 588945 588945 Walkelyne, Robert, of Hempstede, husbandman 1
4830169 2305479 2305479 defendant Trenche John yeoman 588945 588945 Trenche, John, of Hempstede, yeoman 0
4830170 2305479 2305479 defendant Basely Thomas yeoman 588945 588945 Basely, Thomas, of Hempstede, yeoman 1
4933592 2336889 2336889 defendant Heynes William yeoman 588945 588945 Heynes, William, of Hempstede, yeoman 1
4935483 2337495 2337495 defendant Welde Ralph yeoman 588945 588945 Welde, Ralph, of Hempstede, yeoman 0
4938147 2338309 2338309 defendant Trenche John yeoman 588945 588945 Trenche, John, of Hempstede, yeoman 0
4938148 2338309 2338309 defendant Heynes William yeoman 588945 588945 Heynes, William, of Hempstede, yeoman 1
4953846 2343112 2343112 defendant Bulford Reginald husbandman 588945 588945 Bulford, Reginald, of Hempstede, husbandman 2
5027258 2364844 2364844 defendant Baselye John husbandman 588945 588945 Baselye, John, of Hempstede, husbandman 0
5184627 2411250 2411250 defendant Rolf Richard husbandman 588945 588945 Rolf Richard, of Hempstede, husbandman 5
5323360 2452063 2452063 defendant Coke William husbandman 588945 588945 Coke, William, of Hempstede, husbandman 3
5331819 2454596 2454596 defendant Langdon Thomas yeoman 588945 588945 Langdon, Thomas, of Hempstede, yeoman 0
5360687 2463376 2463376 defendant Chapman Thomas husbandman 588945 588945 Chapman, Thomas, of Hempstede, husbandman 0
5360692 2463377 2463377 defendant Chapman Thomas husbandman 588945 588945 Chapman, Thomas, of Hempstede, husbandman 0
5421652 2481412 2481412 defendant Bolt William husbandman 588945 588945 Bolt, William, of Hempstede, husbandman 0
5540315 2517102 2517102 defendant Broun James laborer 588945 588945 Broun, James, of Hempstede, laborer 1
5554234 2521280 2521280 defendant Studhagh Lawrence gent 588945 588945 Studhagh, Lawrence, of Hempstede, gent 0
5557828 2522241 2522241 defendant Westley George husbandman 588945 588945 Westley, George, of Hempstede, husbandman 2
5570115 2525834 2525834 defendant Gybbes Robert laborer 588945 588945 Gybbes, Robert, of Hempstede, laborer 2
5570116 2525834 2525834 defendant Atbury William laborer 588945 588945 Atbury, William, of Hempstede, laborer 3
5570746 2526003 2526003 defendant Rogers Thomas husbandman 588945 588945 Rogers, Thomas, of Hempstede, husbandman 0
5605494 2536599 2536599 defendant Henlyng Robert husbandman 588945 588945 Henlyng, Robert, of Hempstede, husbandman 1
5625347 2551865 2551865 defendant Trenche John yeoman 588945 588945 Trenche, John, of Hempstede, yeoman 6

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