names

34 rows where place_id = 597968

✎ 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
3630580 1904394 1904394 defendant Skytte Clement husbandman 597968 597968 Skytte, Clement, of Alborowe, husbandman 0
3645624 1909029 1909029 defendant Marschall Robert carpenter 597968 597968 Marschall, Robert, of Alborowe, carpenter 1
3675418 1918348 1918348 defendant Lumner Thomas gent 597968 597968 Lumner, Thomas, of Alborowe, gent 2
3694308 1924424 1924424 defendant Athorp John yeoman 597968 597968 Athorp, John, of Alborowe, yeoman 0
3735510 1937345 1937345 defendant Cocke Richard husbandman 597968 597968 Cocke, Richard, of Alborowe, husbandman 2
3736889 1937793 1937793 plaintiff Knyght John (legal representative) 597968 597968 Knyght, John, of Alborowe, executors of 0
3768691 1947854 1947854 defendant Stone Thomas chaplain 597968 597968 Stone, Thomas, of Alborowe, chaplain 0
3820179 1964191 1964191 defendant Trusse William cooper 597968 597968 Trusse, William, of Alborowe, cooper 0
3881279 1984007 1984007 defendant Byllop William husbandman 597968 597968 Byllop, William, of Alborowe, husbandman 0
3888285 1986343 1986343 defendant Rocke Thomas miller 597968 597968 Rocke, Thomas, of Alborowe, miller 0
3889791 1986824 1986824 defendant Notyngham Thomas yeoman 597968 597968 Notyngham, Thomas, of Alborowe, yeoman 0
3923010 1998002 1998002 defendant Kempe Geoffrey butcher 597968 597968 Kempe, Geoffrey, of Alborowe, butcher 0
3948946 2006697 2006697 defendant Harward Robert gent 597968 597968 Harward, Robert, of Alborowe, gent 4
4137120 2073625 2073625 defendant Hooker John, junior yeoman 597968 597968 Hooker, John, junior, of Alborowe, yeoman 0
4137121 2073625 2073625 defendant Curdye William yeoman 597968 597968 Curdye, William, of Alborowe, yeoman 1
4155826 2080117 2080117 defendant Kene Thomas haberdasher 597968 597968 Kene, Thomas, of Alborowe, haberdasher 0
4167367 2084085 2084085 defendant Moore John clerk 597968 597968 Moore, John, of Alborowe, clerk 3
4174345 2086490 2086490 defendant Moore John clerk 597968 597968 Moore, John, of Alborowe, clerk 0
4178387 2087915 2087915 defendant More John clerk 597968 597968 More, John, of Alborowe, clerk 1
4184164 2089957 2089957 defendant More John clerk 597968 597968 More, John, of Alborowe, clerk 1
4200323 2095667 2095667 defendant Harrowd Robert gent 597968 597968 Harrowd, Robert, of Alborowe, gent 0
4200326 2095667 2095667 defendant Mannocke John yeoman 597968 597968 Mannocke, John, of Alborowe, yeoman 3
4204431 2097096 2097096 defendant More John clerk 597968 597968 More, John, of Alborowe, clerk 0
4241472 2110132 2110132 defendant Webster John butcher 597968 597968 Webster, John, of Alborowe, butcher 0
4277695 2122123 2122123 defendant Hocker or Hooker John   597968 597968 Hocker or Hooker, John, of Alborowe yeoman 1
4281279 2123361 2123361 defendant Webster Thomas butcher 597968 597968 Webster, Thomas, of Alborowe, butcher 2
4281283 2123362 2123362 defendant Webster Thomas butcher 597968 597968 Webster, Thomas, of Alborowe, butcher 2
4303992 2131528 2131528 defendant Carpe William   597968 597968 Carpe, William, of Alborowe Suff, sailor 1
4339485 2143578 2143578 defendant Wright Thomas yeoman 597968 597968 Wright, Thomas, of Alborowe, yeoman 0
4351254 2147689 2147689 defendant Ransom William husbandman 597968 597968 Ransom, William, of Alborowe, husbandman 0
4380977 2158311 2158311 defendant Warryn or Warne John gent 597968 597968 Warryn or Warne, John, of Alborowe, gent 0
5427330 2483119 2483119 defendant Hoker Thomas husbandman 597968 597968 Hoker, Thomas, of Alborowe, husbandman 0
5427331 2483119 2483119 defendant Hoker John   597968 597968 Hoker, John, of Alborowe, husbandman, son of Thomas 1
5480966 2499261 2499261 defendant Foxley John husbandman 597968 597968 Foxley, John, of Alborowe, husbandman 2

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