names

62 rows where place_id = 588708

✎ 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
3587576 1863761 1863761 defendant Roche Walter (legal representative) 588708 588708 Roche, Walter, of Hunspyll, husbandman, executor of 0
3595322 1866167 1866167 defendant Lyddon Robert yeoman 588708 588708 Lyddon, Robert, of Hunspyll, yeoman 3
3679515 1919663 1919663 defendant Hacche Robert husbandman 588708 588708 Hacche, Robert, of Hunspyll, husbandman 0
3706764 1928400 1928400 defendant Pody William husbandman 588708 588708 Pody, William, of Hunspyll, husbandman 3
3722696 1933365 1933365 defendant Pody William yeoman 588708 588708 Pody, William, of Hunspyll, yeoman 0
3788450 1954189 1954189 defendant Castylman John husbandman 588708 588708 Castylman, John, of Hunspyll, husbandman 0
3812934 1961941 1961941 defendant Gyllyng John husbandman 588708 588708 Gyllyng, John, of Hunspyll, husbandman 0
3823177 1965161 1965161 defendant Wynter William laborer 588708 588708 Wynter, William, of Hunspyll, laborer 0
3823178 1965161 1965161 defendant Castilman John, junior husbandman 588708 588708 Castilman, John, junior, of Hunspyll, husbandman 1
3823179 1965161 1965161 defendant Dun John clerk 588708 588708 Dun, John, of Hunspyll, clerk 2
3823180 1965161 1965161 defendant Frauncys John carpenter 588708 588708 Frauncys, John, of Hunspyll, carpenter 3
3853374 1974678 1974678 defendant Broten William husbandman 588708 588708 Broten, William, of Hunspyll, husbandman 0
3897373 1989338 1989338 plaintiff Whyte Richard husbandman 588708 588708 Whyte, Richard, of Hunspyll, husbandman 0
3899699 1990115 1990115 plaintiff Chewte William   588708 588708 Chewte, William, of Hunspyll 2
3899700 1990115 1990115 defendant Castelman John yeoman 588708 588708 Castelman, John, of Hunspyll, yeoman 0
3899701 1990115 1990115 defendant Dun John husbandman 588708 588708 Dun, John, of Hunspyll, husbandman 1
3901351 1990673 1990673 defendant Castelman John yeoman 588708 588708 Castelman, John, of Hunspyll, yeoman 0
3901352 1990673 1990673 defendant Donne John husbandman 588708 588708 Donne, John, of Hunspyll, husbandman 1
3903390 1991358 1991358 defendant Doon John, junior husbandman 588708 588708 Doon, John, junior, of Hunspyll, husbandman 0
3915136 1995421 1995421 defendant Puddye Robert husbandman 588708 588708 Puddye, Robert, of Hunspyll, husbandman 2
3915789 1995659 1995659 defendant Castylman Humphrey husbandman 588708 588708 Castylman, Humphrey, of Hunspyll, husbandman 0
3923718 1998242 1998242 defendant Puddye Robert yeoman 588708 588708 Puddye, Robert, of Hunspyll, yeoman 0
3923719 1998242 1998242 defendant Dun John husbandman 588708 588708 Dun, John, of Hunspyll, husbandman 1
3937468 2002867 2002867 defendant Smythes John husbandman 588708 588708 Smythes, John, of Hunspyll, husbandman 1
3940229 2003751 2003751 defendant Castelman John, senior yeoman 588708 588708 Castelman, John, senior, of Hunspyll, yeoman 0
3940230 2003751 2003751 defendant Castelman Humphrey husbandman 588708 588708 Castelman, Humphrey, of Hunspyll, husbandman 1
3940231 2003751 2003751 defendant Castelman John, junior husbandman 588708 588708 Castelman, John, junior, of Hunspyll, husbandman 2
3963501 2011841 2011841 defendant Castelman John yeoman 588708 588708 Castelman, John, of Hunspyll, yeoman 0
3974855 2015769 2015769 defendant Verbye Thomas husbandman 588708 588708 Verbye, Thomas, of Hunspyll, husbandman 0
4089796 2056644 2056644 defendant Macham John gent 588708 588708 Macham, John, of Hunspyll, gent 1
4101396 2060803 2060803 defendant Longe William husbandman 588708 588708 Longe, William, of Hunspyll, husbandman 1
4117125 2066430 2066430 defendant Wyllyams alias Fermor John husbandman 588708 588708 Wyllyams alias Fermor, John, of Hunspyll, husbandman 0
4193790 2093399 2093399 defendant Hopper John husbandman 588708 588708 Hopper, John, of Hunspyll, husbandman 2
4198479 2095019 2095019 defendant Hopper John yeoman 588708 588708 Hopper, John, of Hunspyll, yeoman 0
4204993 2097289 2097289 defendant Brinckelowe William husbandman 588708 588708 Brinckelowe, William, of Hunspyll, husbandman 0
4288679 2126006 2126006 defendant Brincklowe William yeoman 588708 588708 Brincklowe, William, of Hunspyll, yeoman 0
4292317 2127315 2127315 defendant Kempe Thomas victualer 588708 588708 Kempe, Thomas, of Hunspyll, butcher, victualer 0
4302422 2130968 2130968 defendant Locke John yeoman 588708 588708 Locke, John, of Hunspyll, yeoman 0
4401124 2164970 2164970 defendant Payne William yeoman 588708 588708 Payne, William, of Hunspyll, yeoman 0
4572642 2222981 2222981 defendant Foreman Thomas   588708 588708 Foreman, Thomas, of Hunspyll 1
4600652 2231431 2231431 defendant Gye Robert   588708 588708 Gye, Robert, of Hunspyll 0
4600653 2231431 2231431 defendant Smyth Henry   588708 588708 Smyth, Henry, of Hunspyll 1
4618510 2236800 2236800 defendant Ille Stephen   588708 588708 Ille, Stephen, of Hunspyll 0
4635024 2241803 2241803 defendant Mey John   588708 588708 Mey, John, of Hunspyll 0
4643387 2244171 2244171 defendant Bryd John   588708 588708 Bryd, John, of Hunspyll 4
5021780 2363263 2363263 defendant Dauncerdon John   588708 588708 Dauncerdon, John, of Hunspyll, groom 0
5025817 2364451 2364451 defendant Weston William husbandman 588708 588708 Weston, William, of Hunspyll, husbandman 0
5118775 2391924 2391924 defendant Hares Nicholas husbandman 588708 588708 Hares, Nicholas, of Hunspyll, husbandman 1
5236824 2426355 2426355 defendant Pody William husbandman 588708 588708 Pody, William, of Hunspyll, husbandman 0
5270947 2436600 2436600 defendant Ille Thomas husbandman 588708 588708 Ille, Thomas, of Hunspyll, husbandman 1
5292952 2442930 2442930 defendant Chamberleyn John husbandman 588708 588708 Chamberleyn, John, of Hunspyll, husbandman 2
5386791 2471288 2471288 defendant Castell William husbandman 588708 588708 Castell, William, of Hunspyll, husbandman 0
5386792 2471288 2471288 defendant Bole Peter husbandman 588708 588708 Bole, Peter, of Hunspyll, husbandman 1
5386793 2471288 2471288 defendant Rythe John husbandman 588708 588708 Rythe, John, of Hunspyll, husbandman 2
5386794 2471288 2471288 defendant Chamberleyn John husbandman 588708 588708 Chamberleyn, John, of Hunspyll, husbandman 3
5403515 2476076 2476076 defendant Eyre Thomas butcher 588708 588708 Eyre, Thomas, of Hunspyll, butcher 0
5416657 2479898 2479898 defendant Eyre Thomas butcher 588708 588708 Eyre, Thomas, of Hunspyll, butcher 0
5496604 2503900 2503900 defendant London Richard husbandman 588708 588708 London, Richard, of Hunspyll, husbandman 1
5496605 2503900 2503900 defendant Chamberleyn John husbandman 588708 588708 Chamberleyn, John, of Hunspyll, husbandman 2
5496606 2503900 2503900 defendant Walle John husbandman 588708 588708 Walle, John, of Hunspyll, husbandman 3
5584988 2530380 2530380 defendant Mellyn Walter husbandman 588708 588708 Mellyn, Walter, of Hunspyll, husbandman 5
5606529 2536930 2536930 defendant Castelman John husbandman 588708 588708 Castelman, John, of Hunspyll, husbandman 1

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