names

39 rows where place_id = 587919

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592827 1865371 1865371 defendant Studdesbury John gent 587919 587919 Studdesbury, John, of Edynstowe, gent 0
3941030 2004005 2004005 defendant Smyth Anthony tanner 587919 587919 Smyth, Anthony, of Edynstowe, tanner 0
4466732 2190264 2190264 defendant Walsshe John   587919 587919 Walsshe, John, of Edynstowe 3
4466742 2190267 2190267 defendant Walsshe John   587919 587919 Walsshe, John, of Edynstowe 2
4480524 2194573 2194573 defendant Walssh John   587919 587919 Walssh, John, of Edynstowe 0
4530352 2209780 2209780 plaintiff Norton Thomas de   587919 587919 Norton, Thomas de, of Edynstowe, vicar 0
4747022 2279633 2279633 defendant Alferton John gent 587919 587919 Alferton, John, of Edynstowe, gent 0
4747023 2279633 2279633 defendant Hokerton Robert chaplain 587919 587919 Hokerton, Robert, of Edynstowe, chaplain 1
4853283 2312441 2312441 defendant Skotur Richard husbandman 587919 587919 Skotur, Richard, of Edynstowe, husbandman 3
4914997 2331195 2331195 defendant Martyn William laborer 587919 587919 Martyn, William, of Edynstowe, laborer 2
4920811 2333023 2333023 defendant Gamull John husbandman 587919 587919 Gamull, John, of Edynstowe, husbandman 1
5010784 2360008 2360008 defendant Bateman Roger husbandman 587919 587919 Bateman, Roger, of Edynstowe, husbandman 0
5034267 2366878 2366878 defendant Shefeld Thomas gent 587919 587919 Shefeld, Thomas, of Edynstowe, gent 0
5115067 2390824 2390824 defendant Gamull Richard husbandman 587919 587919 Gamull, Richard, of Edynstowe, husbandman 0
5115068 2390824 2390824 defendant Colyngham Robert yeoman 587919 587919 Colyngham, Robert, of Edynstowe, yeoman 1
5228382 2423907 2423907 defendant Oldham Nicholas husbandman 587919 587919 Oldham, Nicholas, of Edynstowe, husbandman 16
5228383 2423907 2423907 defendant Wybbe Robert husbandman 587919 587919 Wybbe, Robert, of Edynstowe, husbandman 17
5228385 2423907 2423907 defendant Machon John laborer 587919 587919 Machon, John, of Edynstowe, laborer 19
5228387 2423907 2423907 defendant Bever William laborer 587919 587919 Bever, William, of Edynstowe, laborer 21
5243187 2428208 2428208 defendant Worsley Thomas yeoman 587919 587919 Worsley, Thomas, of Edynstowe, yeoman 0
5279253 2439032 2439032 defendant Sclater John yeoman 587919 587919 Sclater, John, of Edynstowe, yeoman 1
5306144 2446827 2446827 defendant Couper Robert yeoman 587919 587919 Couper, Robert, of Edynstowe, yeoman 0
5329687 2453948 2453948 defendant Ulgarthorp John   587919 587919 Ulgarthorp, John, of Edynstowe 0
5337217 2456202 2456202 defendant Merefeld John clerk 587919 587919 Merefeld, John, of Edynstowe, clerk 0
5337218 2456202 2456202 defendant Sclater John yeoman 587919 587919 Sclater, John, of Edynstowe, yeoman 1
5337222 2456203 2456203 defendant Merefeld John clerk 587919 587919 Merefeld, John, of Edynstowe, clerk 0
5337223 2456203 2456203 defendant Sclater John yeoman 587919 587919 Sclater, John, of Edynstowe, yeoman 1
5337364 2456246 2456246 defendant Alveston or Alneston Thomas gent 587919 587919 Alveston or Alneston, Thomas, of Edynstowe, gent 0
5337365 2456246 2456246 defendant Lominers Lawrence weaver 587919 587919 Lominers, Lawrence, of Edynstowe, weaver 1
5341511 2457533 2457533 defendant Merefeld John clerk 587919 587919 Merefeld, John, of Edynstowe, clerk 0
5341512 2457533 2457533 defendant Sclater John yeoman 587919 587919 Sclater, John, of Edynstowe, yeoman 1
5341515 2457534 2457534 defendant Merefeld John clerk 587919 587919 Merefeld, John, of Edynstowe, clerk 0
5341516 2457534 2457534 defendant Sclater John yeoman 587919 587919 Sclater, John, of Edynstowe, yeoman 1
5365494 2464883 2464883 defendant Gamole John husbandman 587919 587919 Gamole, John, of Edynstowe, husbandman 0
5384482 2470646 2470646 defendant Gannill John yeoman 587919 587919 Gannill, John, of Edynstowe, yeoman 1
5438506 2486452 2486452 defendant Alfurton Thomas yeoman 587919 587919 Alfurton, Thomas, of Edynstowe, yeoman 1
5441228 2487289 2487289 defendant Alfurton Thomas yeoman 587919 587919 Alfurton, Thomas, of Edynstowe, yeoman 1
5479788 2498965 2498965 defendant Gamull John husbandman 587919 587919 Gamull, John, of Edynstowe, husbandman 0
5526542 2512869 2512869 defendant Smalley William tailor 587919 587919 Smalley, William, of Edynstowe, tailor 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);