names

49 rows where place_id = 592641

✎ 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
3608367 1870275 1870275 defendant Letton William yeoman 592641 592641 Letton, William, of Basyngham, yeoman 0
3620333 1873941 1873941 defendant Coke Thomas husbandman 592641 592641 Coke, Thomas, of Basyngham, husbandman 0
3882712 1984481 1984481 defendant Purrey John husbandman 592641 592641 Purrey, John, of Basyngham, husbandman 2
4072990 2050637 2050637 defendant Marten Robert thatcher 592641 592641 Marten, Robert, of Basyngham, thatcher 3
4351255 2147689 2147689 defendant Overton Thomas glover 592641 592641 Overton, Thomas, of Basyngham, glover 1
4451217 2185339 2185339 defendant Souter John   592641 592641 Souter, John, of Basyngham 4
4584789 2226670 2226670 defendant Cane Robert   592641 592641 Cane, Robert, of Basyngham 0
4584791 2226671 2226671 defendant del Watir John   592641 592641 del Watir, John, of Basyngham, son of John 0
4675025 2257798 2257798 defendant Skunsyte Robert   592641 592641 Skunsyte, Robert, of Basyngham, parson 0
4682537 2260161 2260161 defendant Jonetson Thomas husbandman 592641 592641 Jonetson, Thomas, of Basyngham, husbandman 1
4900607 2326830 2326830 defendant Taillour William husbandman 592641 592641 Taillour, William, of Basyngham, husbandman 3
4908002 2329062 2329062 defendant Wryght Walter   592641 592641 Wryght, Walter, of Basyngham, parson 1
4952908 2342829 2342829 defendant Wilkes Thomas husbandman 592641 592641 Wilkes, Thomas, of Basyngham, husbandman 2
4974399 2349305 2349305 defendant Wilkes Thomas husbandman 592641 592641 Wilkes, Thomas, of Basyngham, husbandman 0
4985022 2352451 2352451 defendant Wilkes Thomas husbandman 592641 592641 Wilkes, Thomas, of Basyngham, husbandman 4
5001690 2357391 2357391 defendant Wylkys Thomas husbandman 592641 592641 Wylkys, Thomas, of Basyngham, husbandman 0
5001691 2357391 2357391 defendant Wylkys John   592641 592641 Wylkys, John, of Basyngham, servant 1
5012132 2360398 2360398 defendant Wylkes Thomas husbandman 592641 592641 Wylkes, Thomas, of Basyngham, husbandman 1
5021658 2363231 2363231 defendant Wilkys Thomas husbandman 592641 592641 Wilkys, Thomas, of Basyngham, husbandman 0
5022434 2363460 2363460 defendant Smyth William smith 592641 592641 Smyth, William, of Basyngham, smith 0
5038092 2368025 2368025 defendant Smyth William yeoman 592641 592641 Smyth, William, of Basyngham, yeoman 1
5044853 2370098 2370098 defendant Basyngham John husbandman 592641 592641 Basyngham, John, of Basyngham, husbandman 4
5046539 2370605 2370605 defendant Basyngham John husbandman 592641 592641 Basyngham, John, of Basyngham, husbandman 0
5056162 2373416 2373416 defendant Basyngham John yeoman 592641 592641 Basyngham, John, of Basyngham, yeoman 7
5125875 2394055 2394055 defendant Basyngham John yeoman 592641 592641 Basyngham, John, of Basyngham, yeoman 0
5136861 2397304 2397304 defendant Basyngham John yeoman 592641 592641 Basyngham, John, of Basyngham, yeoman 0
5144479 2399546 2399546 defendant Basyngham John yeoman 592641 592641 Basyngham, John, of Basyngham, yeoman 0
5157424 2403310 2403310 defendant Basyngham John yeoman 592641 592641 Basyngham, John, of Basyngham, yeoman 0
5173349 2407914 2407914 defendant Basyngham John yeoman 592641 592641 Basyngham, John, of Basyngham, yeoman 0
5193331 2413779 2413779 defendant Basyngham John yeoman 592641 592641 Basyngham, John, of Basyngham, yeoman 0
5250352 2430222 2430222 defendant Byrdok Thomas yeoman 592641 592641 Byrdok, Thomas, of Basyngham, yeoman 0
5250353 2430222 2430222 defendant Cokke John yeoman 592641 592641 Cokke, John, of Basyngham, yeoman 1
5279930 2439205 2439205 defendant Topclyff John clerk 592641 592641 Topclyff, John, of Basyngham, clerk 4
5279931 2439205 2439205 defendant Cokkys John husbandman 592641 592641 Cokkys, John, of Basyngham, husbandman 5
5337094 2456172 2456172 defendant Kyttys William yeoman 592641 592641 Kyttys, William, of Basyngham, yeoman 0
5355023 2461640 2461640 defendant Cromer Robert husbandman 592641 592641 Cromer, Robert, of Basyngham, husbandman 1
5374001 2467467 2467467 plaintiff Crowme Robert   592641 592641 Crowme, Robert, of Basyngham 1
5384366 2470617 2470617 plaintiff Bettys Henry   592641 592641 Bettys, Henry, of Basyngham 0
5384368 2470617 2470617 defendant Crowemer Robert yeoman 592641 592641 Crowemer, Robert, of Basyngham, yeoman 0
5396171 2473993 2473993 plaintiff Bettys Henry   592641 592641 Bettys, Henry, of Basyngham 0
5396173 2473993 2473993 defendant Crowemer Robert yeoman 592641 592641 Crowemer, Robert, of Basyngham, yeoman 0
5409422 2477782 2477782 plaintiff Benys Henry   592641 592641 Benys, Henry, of Basyngham 0
5409424 2477782 2477782 defendant Crowemer Robert yeoman 592641 592641 Crowemer, Robert, of Basyngham, yeoman 0
5430801 2484150 2484150 defendant Harneys William clerk 592641 592641 Harneys, William, of Basyngham, clerk 2
5497972 2504339 2504339 plaintiff Cromemere Robert   592641 592641 Cromemere, Robert, of Basyngham 1
5498578 2504518 2504518 defendant Basyngham John, junior husbandman 592641 592641 Basyngham, John, junior, of Basyngham, husbandman 0
5551395 2520442 2520442 defendant Mosgrave Robert chaplain 592641 592641 Mosgrave, Robert, of Basyngham, chaplain 1
5551398 2520443 2520443 defendant Mosgrave Robert chaplain 592641 592641 Mosgrave, Robert, of Basyngham, chaplain 1
5590050 2531873 2531873 defendant Hawe Katherine widow 592641 592641 Hawe, Katherine, of Basyngham, widow 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);