names

54 rows where place_id = 589537

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597902 1866965 1866965 defendant Hervy Thomas yeoman 589537 589537 Hervy, Thomas, of Banburgh, yeoman 1
3604527 1869081 1869081 defendant Hervy Thomas thatcher 589537 589537 Hervy, Thomas, of Banburgh, thatcher 0
3639234 1907083 1907083 defendant Shymmyng Thomas husbandman 589537 589537 Shymmyng, Thomas, of Banburgh, husbandman 0
3650007 1910369 1910369 defendant Mombray Leonard yeoman 589537 589537 Mombray, Leonard, of Banburgh, yeoman 3
3654563 1911689 1911689 defendant Grote Edmund husbandman 589537 589537 Grote, Edmund, of Banburgh, husbandman 0
3659369 1913190 1913190 defendant Mumbrey Leonard warrener 589537 589537 Mumbrey, Leonard, of Banburgh, warrener 0
3660141 1913432 1913432 defendant Hykkys Thomas butcher 589537 589537 Hykkys, Thomas, of Banburgh, butcher 0
3660150 1913434 1913434 defendant Hykkys Thomas butcher 589537 589537 Hykkys, Thomas, of Banburgh, butcher 0
3681413 1920273 1920273 defendant Petfeld William husbandman 589537 589537 Petfeld, William, of Banburgh, husbandman 1
3695748 1924899 1924899 defendant Wenne Peter husbandman 589537 589537 Wenne, Peter, of Banburgh, husbandman 4
3695905 1924956 1924956 defendant Smyth Richard laborer 589537 589537 Smyth, Richard, of Banburgh, laborer 0
3734937 1937163 1937163 defendant Grote Edmund yeoman 589537 589537 Grote, Edmund, of Banburgh, yeoman 11
3747179 1941036 1941036 defendant Tylney Edward husbandman 589537 589537 Tylney, Edward, of Banburgh, husbandman 1
3768298 1947727 1947727 defendant Tylney Edmund husbandman 589537 589537 Tylney, Edmund, of Banburgh, husbandman 0
3768299 1947727 1947727 defendant Tylney Philip husbandman 589537 589537 Tylney, Philip, of Banburgh, husbandman 1
3792533 1955520 1955520 defendant Grote Edmund husbandman 589537 589537 Grote, Edmund, of Banburgh, husbandman 0
3797824 1957215 1957215 defendant Jurdon John yeoman 589537 589537 Jurdon, John, of Banburgh, yeoman 4
3815120 1962648 1962648 defendant Jurdon John husbandman 589537 589537 Jurdon, John, of Banburgh, husbandman 3
3846749 1972536 1972536 defendant Jurdon John husbandman 589537 589537 Jurdon, John, of Banburgh, husbandman 5
4224510 2104053 2104053 defendant Clarke Henry, junior yeoman 589537 589537 Clarke, Henry, junior, of Banburgh, yeoman 3
4691921 2263009 2263009 defendant Moom John husbandman 589537 589537 Moom, John, of Banburgh, husbandman 0
4730151 2274629 2274629 defendant Bernag Robert   589537 589537 Bernag, Robert, of Banburgh 8
4741637 2278046 2278046 defendant Mous or Mons Geoffrey   589537 589537 Mous or Mons, Geoffrey, of Banburgh, corsour 11
4901239 2326995 2326995 defendant Mouse Geoffrey husbandman 589537 589537 Mouse, Geoffrey, of Banburgh, husbandman 1
4930919 2336067 2336067 defendant Fisshman Richard husbandman 589537 589537 Fisshman, Richard, of Banburgh, husbandman 6
4975780 2349721 2349721 defendant Shymmyng John yeoman 589537 589537 Shymmyng, John, of Banburgh, yeoman 1
5022020 2363334 2363334 defendant Mastright Thomas chaplain 589537 589537 Mastright, Thomas, of Banburgh, chaplain 0
5046714 2370640 2370640 defendant (not given) Thomas vicar of Mastryk 589537 589537 Mastryk, Thomas, of Banburgh, clerk & perpetual vicar of Banburgh 0
5135869 2397005 2397005 defendant Mille John husbandman 589537 589537 Mille, John, of Banburgh, husbandman 0
5135870 2397005 2397005 defendant Mille Richard   589537 589537 Mille, Richard, of Banburgh, single man 1
5142959 2399066 2399066 defendant Nycoll William husbandman 589537 589537 Nycoll, William, of Banburgh, husbandman 3
5156144 2402956 2402956 defendant Mille John husbandman 589537 589537 Mille, John, of Banburgh, husbandman 0
5156145 2402956 2402956 defendant Mille Richard yeoman 589537 589537 Mille, Richard, of Banburgh, yeoman 1
5172439 2407665 2407665 defendant Mille John husbandman 589537 589537 Mille, John, of Banburgh, husbandman 0
5172440 2407665 2407665 defendant Mille Richard singleman & yeoman 589537 589537 Mille, Richard, of Banburgh, singleman & yeoman 1
5191921 2413369 2413369 defendant Mille John husbandman 589537 589537 Mille, John, of Banburgh, husbandman 0
5191922 2413369 2413369 defendant Mille Richard yeoman 589537 589537 Mille, Richard, of Banburgh, yeoman 1
5196239 2414652 2414652 defendant Shymmyng John yeoman 589537 589537 Shymmyng, John, of Banburgh, yeoman 0
5233009 2425236 2425236 defendant Clerk John husbandman 589537 589537 Clerk, John, of Banburgh, husbandman 0
5264708 2434719 2434719 defendant Maystryk Thomas clerk 589537 589537 Maystryk, Thomas, of Banburgh, clerk 1
5344401 2458428 2458428 defendant Hervy Richard husbandman 589537 589537 Hervy, Richard, of Banburgh, husbandman 0
5355341 2461745 2461745 defendant Marchaunt Richard yeoman 589537 589537 Marchaunt, Richard, of Banburgh, yeoman 0
5363373 2464196 2464196 defendant Clerk John husbandman 589537 589537 Clerk, John, of Banburgh, husbandman 0
5386748 2471276 2471276 defendant Prest Richard   589537 589537 Prest, Richard, of Banburgh 2
5424311 2482238 2482238 defendant Harvy Thomas husbandman 589537 589537 Harvy, Thomas, of Banburgh, husbandman 0
5443192 2487878 2487878 defendant Harvy Thomas husbandman 589537 589537 Harvy, Thomas, of Banburgh, husbandman 0
5443444 2487953 2487953 defendant Harvy Thomas husbandman 589537 589537 Harvy, Thomas, of Banburgh, husbandman 0
5456175 2491764 2491764 defendant Mone Thomas husbandman 589537 589537 Mone, Thomas, of Banburgh, husbandman 3
5467080 2495102 2495102 defendant Moine Thomas husbandman 589537 589537 Moine, Thomas, of Banburgh, husbandman 3
5581076 2529154 2529154 defendant Warde John husbandman 589537 589537 Warde, John, of Banburgh, husbandman 2
5598574 2534438 2534438 defendant Shymmyng Thomas husbandman 589537 589537 Shymmyng, Thomas, of Banburgh, husbandman 0
5598577 2534438 2534438 defendant Clerk Robert husbandman 589537 589537 Clerk, Robert, of Banburgh, husbandman 3
5598578 2534438 2534438 defendant Shymmyng Robert husbandman 589537 589537 Shymmyng, Robert, of Banburgh, husbandman 4
5607309 2537176 2537176 defendant Hervy Robert husbandman 589537 589537 Hervy, Robert, of Banburgh, 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);