names

57 rows where place_id = 593791

✎ 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
3613315 1871814 1871814 defendant Wrask Roger husbandman 593791 593791 Wrask, Roger, of Segeford, husbandman 1
3643978 1908549 1908549 defendant Mason Thomas husbandman 593791 593791 Mason, Thomas, of Segeford, husbandman 0
3643981 1908549 1908549 defendant Heche Henry husbandman 593791 593791 Heche, Henry, of Segeford, husbandman 3
3647409 1909578 1909578 defendant Pepyr Robert husbandman 593791 593791 Pepyr, Robert, of Segeford, husbandman 0
3647410 1909578 1909578 defendant Bele Thomas husbandman 593791 593791 Bele, Thomas, of Segeford, husbandman 1
3654656 1911714 1911714 defendant Elger John husbandman 593791 593791 Elger, John, of Segeford, husbandman 0
3694260 1924406 1924406 defendant Russell Henry gent 593791 593791 Russell, Henry, of Segeford, gent 0
3694262 1924407 1924407 defendant Russell Henry gent 593791 593791 Russell, Henry, of Segeford, gent 0
3696879 1925245 1925245 defendant Russell Henry gent 593791 593791 Russell, Henry, of Segeford, gent 0
3710578 1929631 1929631 defendant Russell Henry gent 593791 593791 Russell, Henry, of Segeford, gent 0
3735417 1937315 1937315 defendant Harstonge Thomas laborer 593791 593791 Harstonge, Thomas, of Segeford, laborer 0
3757465 1944305 1944305 defendant Russell Henry gent 593791 593791 Russell, Henry, of Segeford, gent 0
3783686 1952660 1952660 defendant Byrde Randolph husbandman 593791 593791 Byrde, Randolph, of Segeford, husbandman 0
3784117 1952815 1952815 defendant Chamberleyn John husbandman 593791 593791 Chamberleyn, John, of Segeford, husbandman 0
3803880 1959128 1959128 defendant Beales Thomas husbandman 593791 593791 Beales, Thomas, of Segeford, husbandman 0
3803881 1959128 1959128 defendant Clerke Robert husbandman 593791 593791 Clerke, Robert, of Segeford, husbandman 1
3833453 1968392 1968392 defendant Brampton Robert gent 593791 593791 Brampton, Robert, of Segeford, gent 0
3849251 1973358 1973358 defendant Russell Henry gent 593791 593791 Russell, Henry, of Segeford, gent 2
3851285 1974000 1974000 defendant Russell Henry yeoman 593791 593791 Russell, Henry, of Segeford, yeoman 0
3873507 1981354 1981354 defendant Smyth Nicholas husbandman 593791 593791 Smyth, Nicholas, of Segeford, husbandman 1
3880808 1983849 1983849 defendant Chamberlayne John husbandman 593791 593791 Chamberlayne, John, of Segeford, husbandman 2
3918973 1996667 1996667 defendant Grene William husbandman 593791 593791 Grene, William, of Segeford, husbandman 0
3918974 1996667 1996667 defendant Hargate Thomas husbandman 593791 593791 Hargate, Thomas, of Segeford, husbandman 1
4481687 2194970 2194970 defendant Hyche John   593791 593791 Hyche, John, of Segeford 0
4635116 2241828 2241828 defendant Bocher Robert   593791 593791 Bocher, Robert, of Segeford 0
4676526 2258274 2258274 defendant Barker Thomas tanner 593791 593791 Barker, Thomas, of Segeford, tanner 1
4802297 2296907 2296907 defendant atte Watyr Thomas yeoman 593791 593791 atte Watyr, Thomas, of Segeford, yeoman 1
4943938 2340069 2340069 defendant Cosshe Geoffrey husbandman 593791 593791 Cosshe, Geoffrey, of Segeford, husbandman 1
4975926 2349762 2349762 defendant Broun John (legal representative) 593791 593791 Broun, John, of Segeford, yeoman, executrix of 2
4975927 2349762 2349762 defendant Broun Joah widow 593791 593791 Broun, Joah, of Segeford, widow 3
5003661 2357963 2357963 defendant Hyche Richard laborer 593791 593791 Hyche, Richard, of Segeford, laborer 0
5022380 2363442 2363442 defendant Cryspe William husbandman 593791 593791 Cryspe, William, of Segeford, husbandman 0
5047110 2370759 2370759 defendant Collyn Thomas husbandman 593791 593791 Collyn, Thomas, of Segeford, husbandman 2
5047111 2370759 2370759 defendant Hamond John yeoman 593791 593791 Hamond, John, of Segeford, yeoman 3
5047112 2370759 2370759 defendant Howelyn John husbandman 593791 593791 Howelyn, John, of Segeford, husbandman 4
5076592 2379502 2379502 defendant Brok Thomas husbandman 593791 593791 Brok, Thomas, of Segeford, husbandman 1
5208861 2418315 2418315 defendant Chosyll John laborer 593791 593791 Chosyll, John, of Segeford, laborer 0
5217686 2420906 2420906 defendant Derham Richard yeoman 593791 593791 Derham, Richard, of Segeford, yeoman 3
5239609 2427170 2427170 defendant Dereham Richard yeoman 593791 593791 Dereham, Richard, of Segeford, yeoman 0
5259370 2433053 2433053 defendant Derham Richard yeoman 593791 593791 Derham, Richard, of Segeford, yeoman 1
5317480 2450313 2450313 defendant Julyan Thomas husbandman 593791 593791 Julyan, Thomas, of Segeford, husbandman 0
5333541 2455105 2455105 defendant Clerk Thomas husbandman 593791 593791 Clerk, Thomas, of Segeford, husbandman 0
5362377 2463890 2463890 defendant Broke Thomas yeoman 593791 593791 Broke, Thomas, of Segeford, yeoman 0
5385422 2470906 2470906 defendant Colyn William (legal representative) 593791 593791 Colyn, William, of Segeford, husbandman, executrix of 14
5385423 2470906 2470906 defendant Colyn Margaret widow 593791 593791 Colyn, Margaret, of Segeford, widow 15
5397562 2474374 2474374 defendant Colyn William (legal representative) 593791 593791 Colyn, William, of Segeford, husbandman, executrix of 14
5397563 2474374 2474374 defendant Colyn Margaret widow 593791 593791 Colyn, Margaret, of Segeford, widow 15
5460520 2493090 2493090 defendant Cornelle Simon husbandman 593791 593791 Cornelle, Simon, of Segeford, husbandman 0
5460521 2493090 2493090 defendant Cornelle Robert husbandman 593791 593791 Cornelle, Robert, of Segeford, husbandman 1
5460522 2493090 2493090 defendant Alman John husbandman 593791 593791 Alman, John, of Segeford, husbandman 2
5460523 2493090 2493090 defendant Dynne Gilbert husbandman 593791 593791 Dynne, Gilbert, of Segeford, husbandman 3
5510371 2508084 2508084 defendant Crispe John husbandman 593791 593791 Crispe, John, of Segeford, husbandman 1
5533822 2515122 2515122 defendant Tomson John husbandman 593791 593791 Tomson, John, of Segeford, husbandman 0
5533824 2515122 2515122 defendant White John husbandman 593791 593791 White, John, of Segeford, husbandman 2
5605271 2536527 2536527 defendant Bele Thomas husbandman 593791 593791 (Bele, Thomas, of Segeford, husbandman 1
5605273 2536527 2536527 defendant Mason Thomas husbandman 593791 593791 Mason, Thomas, of Segeford, husbandman 3
5612405 2547627 2547627 defendant Clerk Thomas   593791 593791 Clerk, Thomas, of Segeford 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);