names

65 rows where place_id = 606776

✎ 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
3666482 1915464 1915464 defendant Parke Gilbert gent 606776 606776 Parke, Gilbert, of Warton, gent 2
3695276 1924742 1924742 defendant Stone Hugh laborer 606776 606776 Stone, Hugh, of Warton, laborer 0
3779439 1951293 1951293 defendant Ruston Thomas husbandman 606776 606776 Ruston, Thomas, of Warton, husbandman 2
3801903 1958493 1958493 defendant Murwey Richard husbandman 606776 606776 Murwey, Richard, of Warton, husbandman 1
3819426 1963961 1963961 defendant Murway Richard husbandman 606776 606776 Murway, Richard, of Warton, husbandman 1
3898786 1989795 1989795 defendant Hoggys John husbandman 606776 606776 Hoggys, John, of Warton, husbandman 0
3918718 1996592 1996592 defendant Lawkyn Thomas husbandman 606776 606776 Lawkyn, Thomas, of Warton, husbandman 0
4010814 2028644 2028644 plaintiff Peake Robert gent 606776 606776 Peake, Robert, of Warton, gent 0
4155188 2079907 2079907 defendant Webster Alexander weaver 606776 606776 Webster, Alexander, of Warton, weaver 0
4168339 2084410 2084410 defendant Orton Thomas husbandman 606776 606776 Orton, Thomas, of Warton, husbandman 0
4168343 2084411 2084411 defendant Goldsmythe Geoffrey yeoman 606776 606776 Goldsmythe, Geoffrey, of Warton, yeoman 2
4256379 2115103 2115103 defendant Showarde Hugh yeoman 606776 606776 Showarde, Hugh, of Warton, yeoman 3
4268674 2119114 2119114 defendant Showarde Hugh yeoman 606776 606776 Showarde, Hugh, of Warton, yeoman 2
4367246 2153343 2153343 defendant Scarlett John yeoman 606776 606776 Scarlett, John, of Warton, yeoman 1
4440625 2181978 2181978 defendant Warner John   606776 606776 Warner, John, of Warton 0
4442792 2182702 2182702 defendant Ryder John   606776 606776 Ryder, John, of Warton 0
4585298 2226825 2226825 defendant Brase John   606776 606776 Brase, John, of Warton 0
4585911 2227017 2227017 plaintiff Haukyns Thomas   606776 606776 Haukyns, Thomas, of Warton 0
4585912 2227017 2227017 defendant Bras John   606776 606776 Bras, John, of Warton 0
4636833 2242335 2242335 defendant Haukyns William   606776 606776 Haukyns, William, of Warton 3
4686321 2261327 2261327 plaintiff Shulton John   606776 606776 Shulton, John, of Warton, on his own account 0
4737602 2276870 2276870 defendant Bette William laborer 606776 606776 Bette, William, of Warton, laborer 0
4749729 2280401 2280401 defendant Paprke Richard gent 606776 606776 Paprke, Richard, of Warton, gent 1
4764082 2284755 2284755 defendant Bolton John husbandman 606776 606776 Bolton, John, of Warton, husbandman 1
4811006 2299556 2299556 defendant Smyth Thomas smith 606776 606776 Smyth, Thomas, of Warton, smith 1
4817711 2301626 2301626 defendant Warton Agnes   606776 606776 Warton, Agnes, of Warton, formerly wife of William Warton 0
4821256 2302729 2302729 plaintiff Rolleston Robert   606776 606776 Rolleston, Robert, of Warton, parson 0
4844410 2309764 2309764 defendant Holand John   606776 606776 Holand, John, of Warton, shepherd 0
4866417 2316465 2316465 defendant Parke Richard gent 606776 606776 Parke, Richard, of Warton, gent 0
4886751 2322710 2322710 defendant Aykhed Thomas yeoman 606776 606776 Aykhed, Thomas, of Warton, yeoman 1
4886752 2322710 2322710 defendant Chirden Walter yeoman 606776 606776 Chirden, Walter, of Warton, yeoman 2
4914083 2330913 2330913 defendant Wyryght Robert husbandman 606776 606776 Wyryght, Robert, of Warton, husbandman 0
4918025 2332154 2332154 defendant Wryght Robert husbandman 606776 606776 Wryght, Robert, of Warton, husbandman 0
4919022 2332461 2332461 defendant Wryght Robert yeoman 606776 606776 Wryght, Robert, of Warton, yeoman 0
4919935 2332746 2332746 defendant Wryght Robert husbandman 606776 606776 Wryght, Robert, of Warton, husbandman 1
4927239 2334956 2334956 defendant Wright Robert yeoman 606776 606776 Wright, Robert, of Warton, yeoman 0
4932514 2336563 2336563 defendant Wright Robert yeoman 606776 606776 Wright, Robert, of Warton, yeoman 1
4932857 2336663 2336663 plaintiff Wryght Robert   606776 606776 Wryght, Robert, of Warton 0
4937442 2338081 2338081 defendant Robyn Henry husbandman 606776 606776 Robyn, Henry, of Warton, husbandman 0
4945256 2340492 2340492 defendant Wryght Robert yeoman 606776 606776 Wryght, Robert, of Warton, yeoman 2
4965529 2346609 2346609 defendant Smyth Thomas smith 606776 606776 Smyth, Thomas, of Warton, smith 1
4969894 2347945 2347945 defendant Bysshop Thomas husbandman 606776 606776 Bysshop, Thomas, of Warton, husbandman 0
4979851 2350928 2350928 defendant Hawekyns William husbandman 606776 606776 Hawekyns, William, of Warton, husbandman 1
5001455 2357314 2357314 defendant Hencok Richard laborer 606776 606776 Hencok, Richard, of Warton, laborer 0
5016470 2361713 2361713 plaintiff Burgh Roger (legal representative) 606776 606776 Burgh, Roger, of Warton, executors of 0
5016471 2361713 2361713 plaintiff Wryght Robert   606776 606776 (Wryght, Robert, of Warton 1
5016482 2361714 2361714 plaintiff Burgh Roger (legal representative) 606776 606776 Burgh, Roger, of Warton, or of Randeby, executors of 0
5016483 2361714 2361714 plaintiff Wryght Robert   606776 606776 (Wryght, Robert, of Warton 1
5016486 2361715 2361715 plaintiff Burgh Roger (legal representative) 606776 606776 Burgh, Roger, of Warton, or of Steweton, executors of 0
5016487 2361715 2361715 plaintiff Wryght Robert   606776 606776 (Wryght, Robert, of Warton 1
5076445 2379453 2379453 defendant Stoone William husbandman 606776 606776 Stoone, William, of Warton, husbandman 4
5076446 2379453 2379453 defendant Grene Richard husbandman 606776 606776 Grene, Richard, of Warton, husbandman 5
5379662 2469224 2469224 defendant Strangeman Walter, senior husbandman 606776 606776 Strangeman, Walter, senior, of Warton, husbandman 0
5379663 2469224 2469224 defendant Strangeman Walter, junior husbandman 606776 606776 Strangeman, Walter, junior, of Warton, husbandman 1
5438253 2486375 2486375 defendant Adam Thomas husbandman 606776 606776 Adam, Thomas, of Warton, husbandman 0
5456750 2491939 2491939 defendant Scalys Henry husbandman 606776 606776 Scalys, Henry, of Warton, husbandman 9
5456751 2491939 2491939 defendant Hamond William husbandman 606776 606776 Hamond, William, of Warton, husbandman 10
5468655 2495560 2495560 defendant Salys Henry husbandman 606776 606776 Salys, Henry, of Warton, husbandman 9
5468656 2495560 2495560 defendant Hamond William husbandman 606776 606776 Hamond, William, of Warton, husbandman 10
5506994 2507102 2507102 defendant Jermyn Robert husbandman 606776 606776 Jermyn, Robert, of Warton, husbandman 1
5511299 2508376 2508376 defendant Chipper Robert husbandman 606776 606776 Chipper, Robert, of Warton, husbandman 0
5525626 2512606 2512606 defendant Symson John yeoman 606776 606776 Symson, John, of Warton, Wyghton, Cumber, yeoman 0
5593761 2533035 2533035 defendant Davyes John husbandman 606776 606776 Davyes, John, of Warton, husbandman 1
5616976 2549120 2549120 defendant Bad John   606776 606776 Bad, John, of Warton, parson 0
5633999 2554616 2554616 defendant Bolton John husbandman 606776 606776 Bolton, John, of Warton, husbandman 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);