names

40 rows where place_id = 586113

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587968 1863890 1863890 defendant Stafford John clerk 586113 586113 Stafford, John, of Kyrton, Devon, clerk 2
3631150 1904565 1904565 defendant Gregson Edward clerk 586113 586113 Gregson, Edward, of Kyrton, Devon, clerk 0
3713210 1930435 1930435 defendant Medley Thomas yeoman 586113 586113 Medley, Thomas, of Kyrton, Devon, yeoman 0
3713212 1930436 1930436 defendant Medley Thomas yeoman 586113 586113 Medley, Thomas, of Kyrton, Devon, yeoman 0
3733907 1936850 1936850 defendant Olyver John yeoman 586113 586113 Olyver, John, of Kyrton, Devon, yeoman 4
3733913 1936851 1936851 defendant Bokyngham Thomas yeoman 586113 586113 Bokyngham, Thomas, of Kyrton, Devon, yeoman 4
3903196 1991294 1991294 defendant Popeham Nicholas yeoman 586113 586113 Popeham, Nicholas, of Kyrton, Devon, yeoman 1
3920209 1997096 1997096 defendant Peers Thomas chapman 586113 586113 Peers, Thomas, of Kyrton, Devon, chapman 3
3985364 2019524 2019524 defendant Vemcom John clothier 586113 586113 Vemcom, John, of Kyrton, Devon, clothier 1
3997195 2023766 2023766 defendant Wyvell Nicholas gent 586113 586113 Wyvell, Nicholas, of Kyrton, Devon, gent 0
4018109 2031197 2031197 plaintiff Turbervyle Nicholas gent 586113 586113 Turbervyle, Nicholas, of Kyrton, Devon,, gent 0
4018111 2031198 2031198 plaintiff Turbervyle Nicholas gent 586113 586113 Turbervyle, Nicholas, of Kyrton, Devon,, gent 0
4033241 2036544 2036544 defendant Turbervile Nicholas gent 586113 586113 Turbervile, Nicholas, of Kyrton, Devon, gent 0
4077383 2052197 2052197 plaintiff Spenser Thomas merchant 586113 586113 Spenser, Thomas, of Kyrton, Devon, merchant 0
4077385 2052198 2052198 plaintiff Spenser Thomas merchant 586113 586113 Spenser, Thomas, of Kyrton, Devon, merchant 0
4244760 2111234 2111234 defendant Charde John yeoman 586113 586113 Charde, John, of Kyrton, Devon, yeoman 0
4256417 2115115 2115115 defendant Charde John yeoman 586113 586113 Charde, John, of Kyrton, Devon, yeoman 0
4655016 2247450 2247450 defendant Benet William chapman 586113 586113 Benet, William, of Kyrton, Devon, chapman 0
4955732 2343680 2343680 defendant Martyn William husbandman 586113 586113 Martyn, William, of Kyrton, Devon, husbandman 0
4955735 2343681 2343681 defendant Martyn William husbandman 586113 586113 Martyn, William, of Kyrton, Devon, husbandman 0
4994038 2355089 2355089 defendant Prescote John yeoman 586113 586113 Prescote, John, of Kyrton, Devon, yeoman 0
4994040 2355090 2355090 defendant Prescote John yeoman 586113 586113 Prescote, John, of Kyrton, Devon, yeoman 0
5062681 2375397 2375397 defendant Spycer Robert chapman 586113 586113 Spycer, Robert, of Kyrton, Devon, chapman 2
5097319 2385647 2385647 defendant Leche William yeoman 586113 586113 Leche, William, of Kyrton, Devon, yeoman 3
5324201 2452324 2452324 defendant Mar- John gent 586113 586113 Mar-, John, of Kyrton, Devon, gent 0
5324203 2452325 2452325 defendant Martyn John   586113 586113 Martyn, John, of Kyrton, Devon, gen 0
5342352 2457804 2457804 defendant Yorke Roger brasier 586113 586113 Yorke, Roger, of Kyrton, Devon, brasier 0
5370078 2466226 2466226 defendant Lye Richard mercer 586113 586113 Lye, Richard, of Kyrton, Devon, mercer 1
5397766 2474430 2474430 defendant Lye Richard mercer 586113 586113 Lye, Richard, of Kyrton, Devon, mercer 1
5504618 2506365 2506365 defendant Stafford John clerk 586113 586113 Stafford, John, of Kyrton, Devon, clerk 2
5504623 2506366 2506366 defendant Stafford John clerk 586113 586113 Stafford, John, of Kyrton, Devon, clerk 2
5520612 2511269 2511269 defendant Selak John yeoman 586113 586113 Selak, John, of Kyrton, Devon, yeoman 0
5529791 2513827 2513827 defendant James Robert clerk 586113 586113 James, Robert, of Kyrton, Devon, clerk 2
5533515 2515029 2515029 defendant Wode Richard yeoman 586113 586113 Wode, Richard, of Kyrton, Devon, yeoman 0
5557173 2522060 2522060 defendant Selake John gent 586113 586113 Selake, John, of Kyrton, Devon, gent 1
5570573 2525962 2525962 defendant Selake John gent 586113 586113 Selake, John, of Kyrton, Devon, gent 1
5585922 2530650 2530650 defendant Selok John gent 586113 586113 Selok, John, of Kyrton, Devon, gent 0
5588569 2531430 2531430 defendant Selake John yeoman 586113 586113 Selake, John, of Kyrton, Devon, yeoman 1
5600854 2535154 2535154 defendant Selake John gent 586113 586113 Selake, John, of Kyrton, Devon, gent 2
5609349 2537823 2537823 defendant Colbeare Stephen merchant 586113 586113 Colbeare, Stephen, of Kyrton, Devon, merchant 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);