names

54 rows where place_id = 587947

✎ 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
3592906 1865400 1865400 defendant Kellom John gent 587947 587947 Kellom, John, of Kellom, gent 0
3661224 1913787 1913787 defendant Barcotys Roger husbandman 587947 587947 Barcotys, Roger, of Kellom, husbandman 0
3661225 1913787 1913787 defendant Newton John chaplain 587947 587947 Newton, John, of Kellom, chaplain 1
3680470 1919974 1919974 defendant Bladys Stephen yeoman 587947 587947 Bladys, Stephen, of Kellom, yeoman 0
3698733 1925819 1925819 defendant Chapman John carpenter 587947 587947 Chapman, John, of Kellom, carpenter 0
3698734 1925819 1925819 defendant Staynton Thomas husbandman 587947 587947 Staynton, Thomas, of Kellom, husbandman 1
3698735 1925819 1925819 defendant Ferman Robert husbandman 587947 587947 Ferman, Robert, of Kellom, husbandman 2
3749925 1941892 1941892 defendant Chapman John carpenter 587947 587947 Chapman, John, of Kellom, carpenter 0
3828128 1966665 1966665 defendant Wetton William husbandman 587947 587947 Wetton, William, of Kellom, husbandman 0
3944578 2005203 2005203 defendant Hewbanke Christopher yeoman 587947 587947 Hewbanke, Christopher, of Kellom, yeoman 0
3944579 2005203 2005203 defendant Bolton William husbandman 587947 587947 Bolton, William, of Kellom, husbandman 1
3944580 2005203 2005203 defendant Hartley John husbandman 587947 587947 Hartley, John, of Kellom, husbandman 2
3944595 2005206 2005206 defendant Williamson Stephen yeoman 587947 587947 Williamson, Stephen, of Kellom, yeoman 0
4044815 2040597 2040597 defendant Lauwerton George husbandman 587947 587947 Lauwerton, George, of Kellom, husbandman 1
4044819 2040598 2040598 defendant Lawerton George husbandman 587947 587947 Lawerton, George, of Kellom, husbandman 1
4143311 2075827 2075827 defendant Wells Mark (legal representative) 587947 587947 Wells, Mark, of Kellom, yeoman, executor of 0
4760152 2283522 2283522 defendant Milner William miller 587947 587947 Milner, William, of Kellom, miller 0
4788690 2292517 2292517 defendant Boteler Adam husbandman 587947 587947 Boteler, Adam, of Kellom, husbandman 0
4843842 2309594 2309594 defendant Kellom William yeoman 587947 587947 Kellom, William, of Kellom, yeoman 0
4861072 2314820 2314820 defendant Derlyng William husbandman 587947 587947 Derlyng, William, of Kellom, husbandman 0
4937005 2337948 2337948 defendant Cok John smith 587947 587947 Cok, John, of Kellom, smith 1
4947333 2341160 2341160 defendant Turnour John carpenter 587947 587947 Turnour, John, of Kellom, carpenter 0
4950768 2342211 2342211 defendant Wellys Thomas   587947 587947 Wellys, Thomas, of Kellom, mason 1
4973540 2349035 2349035 defendant Kellom William gent 587947 587947 Kellom, William, of Kellom, gent 0
4974607 2349372 2349372 defendant Skyrne John husbandman 587947 587947 Skyrne, John, of Kellom, husbandman 0
4983626 2352025 2352025 defendant Scaley or Staley Thgomas husbandman 587947 587947 Scaley or Staley, Thgomas, of Kellom, husbandman 1
5028943 2365333 2365333 defendant Bolet John husbandman 587947 587947 Bolet, John, of Kellom, husbandman 0
5248539 2429698 2429698 defendant Kellom Richard laborer 587947 587947 Kellom, Richard, of Kellom, laborer 0
5248540 2429698 2429698 defendant Turnour John laborer 587947 587947 Turnour, John, of Kellom, laborer 1
5248541 2429698 2429698 defendant Turnour William laborer 587947 587947 Turnour, William, of Kellom, laborer 2
5288884 2441754 2441754 defendant Peyretre John husbandman 587947 587947 Peyretre, John, of Kellom, husbandman 0
5333483 2455088 2455088 defendant Elmet Thomas husbandman 587947 587947 Elmet, Thomas, of Kellom, husbandman 0
5333484 2455088 2455088 defendant Beghton John husbandman 587947 587947 Beghton, John, of Kellom, husbandman 1
5333485 2455088 2455088 defendant Pertre Thomas husbandman 587947 587947 Pertre, Thomas, of Kellom, husbandman 2
5343829 2458253 2458253 defendant Raulynson William thatcher 587947 587947 Raulynson, William, of Kellom, thatcher 0
5343830 2458253 2458253 defendant Wever John weaver 587947 587947 Wever, John, of kellom, weaver 1
5361282 2463552 2463552 defendant Banester William clerk 587947 587947 Banester, William, of Kellom, clerk 12
5361283 2463552 2463552 defendant Skrymshyre Robert chaplain 587947 587947 Skrymshyre, Robert, of Kellom, chaplain 13
5361284 2463552 2463552 defendant Bostok William yeoman 587947 587947 Bostok, William, of Kellom, yeoman 14
5369591 2466075 2466075 defendant Roberdson Thomas yeoman 587947 587947 Roberdson, Thomas, of Kellom, yeoman 1
5372794 2467093 2467093 defendant Banester William clerk 587947 587947 Banester, William, of Kellom, clerk 0
5403078 2475963 2475963 defendant Spenser Richard husbandman 587947 587947 Spenser, Richard, of Kellom, husbandman 1
5409167 2477710 2477710 defendant Banester William clerk 587947 587947 Banester, William, of Kellom, clerk 0
5418184 2480364 2480364 defendant Rowese Edward milner 587947 587947 Rowese, Edward, of Kellom, milner 0
5418185 2480364 2480364 defendant Rowese Peter milner 587947 587947 Rowese, Peter, of Kellom, milner 1
5420965 2481201 2481201 defendant Beghton John husbandman 587947 587947 Beghton, John, of Kellom, husbandman 0
5435954 2485696 2485696 defendant Rowese Edward miller 587947 587947 Rowese, Edward, of Kellom, miller 0
5435955 2485696 2485696 defendant Rowese Peter miller 587947 587947 Rowese, Peter, of Kellom, miller 1
5435958 2485697 2485697 defendant Rowese Edward milner 587947 587947 Rowese, Edward, of Kellom, milner 0
5435959 2485697 2485697 defendant Rowese Peter milner 587947 587947 Rowese, Peter, of Kellom, milner 1
5440095 2486941 2486941 defendant Beghton John husbandman 587947 587947 Beghton, John, of Kellom, husbandman 0
5492428 2502650 2502650 defendant Clerk John yeoman 587947 587947 Clerk, John, of Kellom, yeoman 3
5502219 2505620 2505620 defendant Staynton Hugh yeoman 587947 587947 Staynton, Hugh, of Kellom, yeoman 0
5601535 2535371 2535371 defendant Kellom Robert gent 587947 587947 Kellom, Robert, of Kellom, gent 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);