names

54 rows where place_id = 603353

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654274 1911595 1911595 defendant Postell John   603353 603353 Postell, John, of Yoxhall, shoe maker 1
3654275 1911595 1911595 defendant Date Robert butcher 603353 603353 Date, Robert, of Yoxhall, butcher 2
3655794 1912070 1912070 defendant Date Robert butcher 603353 603353 Date, Robert, of Yoxhall, butcher 0
3655795 1912070 1912070 defendant Date Thomas butcher 603353 603353 Date, Thomas, of Yoxhall, butcher 1
3658071 1912779 1912779 defendant Date Robert butcher 603353 603353 Date, Robert, of Yoxhall, butcher 0
3668297 1916031 1916031 defendant Baker John cooper 603353 603353 Baker, John, of Yoxhall, cooper 0
3668298 1916031 1916031 defendant Postell John cordwainer 603353 603353 Postell, John, of Yoxhall, cordwainer 1
3683604 1921003 1921003 defendant Webbe John husbandman 603353 603353 Webbe, John, of Yoxhall, husbandman 0
3689717 1922940 1922940 defendant Bell Richard   603353 603353 Bell, Richard, of Yoxhall, hat maker 2
3689718 1922940 1922940 defendant Bate Thomas   603353 603353 Bate, Thomas, of Yoxhall, hat maker 3
3690803 1923288 1923288 defendant Uttyng Nicholas husbandman 603353 603353 Uttyng, Nicholas, of Yoxhall, husbandman 1
3690804 1923288 1923288 defendant Uttyng John husbandman 603353 603353 Uttyng, John, of Yoxhall, husbandman 2
3698461 1925740 1925740 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 0
3698462 1925740 1925740 defendant Fusedale William husbandman 603353 603353 Fusedale, William, of Yoxhall, husbandman 1
3698463 1925740 1925740 defendant Devell William yeoman 603353 603353 Devell, William, of Yoxhall, yeoman 2
3698464 1925740 1925740 defendant Flemyng Thomas chaplain 603353 603353 Flemyng, Thomas, of Yoxhall, chaplain 3
3698466 1925741 1925741 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 0
3698467 1925741 1925741 defendant Fusedale William husbandman 603353 603353 Fusedale, William, of Yoxhall, husbandman 1
3698468 1925741 1925741 defendant Devell William yeoman 603353 603353 Devell, William, of Yoxhall, yeoman 2
3698469 1925741 1925741 defendant Flemyng Thomas chaplain 603353 603353 Flemyng, Thomas, of Yoxhall, chaplain 3
3698471 1925742 1925742 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 0
3698472 1925742 1925742 defendant Fusedale William husbandman 603353 603353 Fusedale, William, of Yoxhall, husbandman 1
3698473 1925742 1925742 defendant Devell William yeoman 603353 603353 Devell, William, of Yoxhall, yeoman 2
3698474 1925742 1925742 defendant Flemyng Thomas chaplain 603353 603353 Flemyng, Thomas, of Yoxhall, chaplain 3
3698478 1925744 1925744 defendant Coton Hugh yeoman 603353 603353 Coton, Hugh, of Yoxhall, yeoman 0
3698480 1925745 1925745 defendant Fusedale William husbandman 603353 603353 Fusedale, William, of Yoxhall, husbandman 0
3698481 1925745 1925745 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 1
3716979 1931597 1931597 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 0
3732424 1936374 1936374 defendant Devell William yeoman 603353 603353 Devell, William, of Yoxhall, yeoman 0
3732425 1936374 1936374 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 1
3732536 1936406 1936406 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 0
3732537 1936406 1936406 defendant Devell William yeoman 603353 603353 Devell, William, of Yoxhall, yeoman 1
3732538 1936406 1936406 defendant Perkyn Richard laborer 603353 603353 Perkyn, Richard, of Yoxhall, laborer 2
3732539 1936406 1936406 defendant Crowther Agnes widow 603353 603353 Crowther, Agnes, of Yoxhall, widow 3
3760046 1945138 1945138 defendant Arderne Robert gent 603353 603353 Arderne, Robert, of Yoxhall, gent 0
3772664 1949142 1949142 defendant Coton Hugh husbandman 603353 603353 Coton, Hugh, of Yoxhall, husbandman 0
3776813 1950489 1950489 defendant Pott Thomas miller 603353 603353 Pott, Thomas, of Yoxhall, miller 0
3787763 1953964 1953964 defendant Wetton John husbandman 603353 603353 Wetton, John, of Yoxhall, husbandman 2
3790316 1954789 1954789 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 0
3790317 1954789 1954789 defendant Devell William yeoman 603353 603353 Devell, William, of Yoxhall, yeoman 1
3790318 1954789 1954789 defendant Cooke James miller 603353 603353 Cooke, James, of Yoxhall, miller 2
3790319 1954789 1954789 defendant Cossall Thomas laborer 603353 603353 Cossall, Thomas, of Yoxhall, laborer 3
3811225 1961405 1961405 defendant Ramsker Richard chaplain 603353 603353 Ramsker, Richard, of Yoxhall, chaplain 0
3811226 1961405 1961405 defendant Cokke John laborer 603353 603353 Cokke, John, of Yoxhall, laborer 1
3824147 1965428 1965428 defendant Ardern Robert gent 603353 603353 Ardern, Robert, of Yoxhall, gent 0
3845616 1972171 1972171 defendant Alkyns John husbandman 603353 603353 Alkyns, John, of Yoxhall, husbandman 1
3861347 1977262 1977262 defendant Arderne Robert gent 603353 603353 Arderne, Robert, of Yoxhall, gent 0
3878183 1982949 1982949 defendant Towres Robert husbandman 603353 603353 Towres, Robert, of Yoxhall, husbandman 0
3881183 1983974 1983974 defendant Wotton James yeoman 603353 603353 Wotton, James, of Yoxhall, yeoman 0
3922647 1997891 1997891 plaintiff Salte Richard   603353 603353 Salte, Richard, of Yoxhall 0
3932252 2001093 2001093 defendant Morys Hugh husbandman 603353 603353 Morys, Hugh, of Yoxhall, husbandman 0
5404588 2476387 2476387 defendant Wodward John husbandman 603353 603353 Wodward, John, of Yoxhall, husbandman 0
5573777 2526897 2526897 defendant Oneley or Oveley Roger husbandman 603353 603353 Oneley or Oveley, Roger, of Yoxhall, husbandman 1
5573779 2526897 2526897 defendant Perkyn Roger fisher 603353 603353 Perkyn, Roger, of Yoxhall, fisher 3

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