names

49 rows where place_id = 600872

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642911 1908235 1908235 plaintiff Cokkes John gent 600872 600872 Cokkes, John, of Abyngton, gent 0
3666743 1915544 1915544 defendant Guy Robert smith 600872 600872 Guy, Robert, of Abyngton, smith 1
3677059 1918864 1918864 defendant Bocher Robert butcher 600872 600872 Bocher, Robert, of Abyngton, butcher 0
3691314 1923443 1923443 defendant Hobson John husbandman 600872 600872 Hobson, John, of Abyngton, husbandman 1
3691525 1923505 1923505 defendant Thuregar Henry butcher 600872 600872 Thuregar, Henry, of Abyngton, butcher 1
3705816 1928098 1928098 defendant Thurgar Henry butcher 600872 600872 Thurgar, Henry, of Abyngton, butcher 1
3720368 1932649 1932649 defendant Dyvers or Dyners John   600872 600872 Dyvers or Dyners, John, of Abyngton, saffron man 0
3720370 1932650 1932650 defendant Dyvers John   600872 600872 Dyvers, John, of Abyngton, saffron man 0
3759560 1944981 1944981 defendant Wynter William clerk 600872 600872 (Wynter, William, of Abyngton, clerk 1
3759562 1944981 1944981 defendant Byldok John husbandman 600872 600872 Byldok, John, of Abyngton, husbandman 3
3788846 1954316 1954316 plaintiff Stone Thomas   600872 600872 Stone, Thomas, of Abyngton 0
3788847 1954316 1954316 defendant Rice John yeoman 600872 600872 Rice, John, of Abyngton, yeoman 0
3826629 1966176 1966176 plaintiff Barnard John esq 600872 600872 Barnard, John, of Abyngton, esq 0
3860067 1976864 1976864 defendant Forman Robert innholder 600872 600872 Forman, Robert, of Abyngton, innholder 0
3867559 1979385 1979385 defendant Eyre Robert husbandman 600872 600872 Eyre, Robert, of Abyngton, husbandman 0
3867564 1979387 1979387 defendant Eyre Robert husbandman 600872 600872 Eyre, Robert, of Abyngton, husbandman 0
3895734 1988781 1988781 defendant Hunte William husbandman 600872 600872 Hunte, William, of Abyngton, husbandman 1
3936046 2002377 2002377 defendant Forman Edward gent 600872 600872 Forman, Edward, of Abyngton, gent 0
3988163 2020512 2020512 defendant Hudson John yeoman 600872 600872 Hudson, John, of Abyngton, or of Kenyngton, Berks, yeoman 0
4000196 2024837 2024837 defendant Bartlam William baker 600872 600872 Bartlam, William, of Abyngton, baker 1
4170063 2085024 2085024 defendant Wilton Brian yeoman 600872 600872 Wilton, Brian, of Abyngton, yeoman 0
4237116 2108564 2108564 defendant Barnard Francis, junior gent 600872 600872 Barnard, Francis, junior, of Abyngton, gent 0
4496926 2199704 2199704 defendant Chapman John   600872 600872 Chapman, John, of Abyngton 0
4562962 2219986 2219986 defendant Chapman Nicholas   600872 600872 Chapman, Nicholas, of Abyngton 0
4641837 2243714 2243714 defendant Colet John   600872 600872 Colet, John, of Abyngton 1
4653744 2247093 2247093 defendant Note John   600872 600872 Note, John, of Abyngton 6
4655936 2247736 2247736 defendant Bate Thomas husbandman 600872 600872 Bate, Thomas, of Abyngton, husbandman 2
4678629 2258921 2258921 defendant Sturthe William yeoman 600872 600872 Sturthe, William, of Abyngton, yeoman 4
4701716 2265932 2265932 defendant Pury Richard husbandman 600872 600872 Pury, Richard, of Abyngton, husbandman 0
4738554 2277150 2277150 defendant Coyfote William husbandman 600872 600872 Coyfote, William, of Abyngton, husbandman 1
4781139 2290110 2290110 defendant Wryght William husbandman 600872 600872 Wryght, William, of Abyngton, husbandman 0
4796755 2295141 2295141 defendant North Thomas husbandman 600872 600872 North, Thomas, of Abyngton, husbandman 0
4846605 2310450 2310450 plaintiff Pygot John   600872 600872 Pygot, John, of Abyngton 0
4846607 2310451 2310451 plaintiff Pygot John   600872 600872 Pygot, John, of Abyngton 0
4896072 2325430 2325430 defendant Knolles John kerseyman 600872 600872 Knolles, John, of Abyngton, kerseyman 0
4926276 2334641 2334641 plaintiff Pygot John   600872 600872 Pygot, John, of Abyngton 0
4988987 2353643 2353643 defendant Norwych John yeoman 600872 600872 Norwych, John, of Abyngton, yeoman 1
5200834 2416004 2416004 defendant Boughton Simon husbandman 600872 600872 Boughton, Simon, of Abyngton, husbandman 0
5211657 2419147 2419147 defendant Boughton Simon husbandman 600872 600872 Boughton, Simon, of Abyngton, husbandman 0
5219256 2421358 2421358 defendant Pygot Thomas gent 600872 600872 Pygot, Thomas, of Abyngton, gent 0
5367930 2465594 2465594 defendant Tredde John husbandman & son of Richard Tradde 600872 600872 Tredde, John, of Abyngton, husbandman & son of Richard Tradde 1
5367934 2465594 2465594 defendant Tradde Stephen husbandman 600872 600872 Tradde, Stephen, of Abyngton, husbandman 5
5369986 2466202 2466202 defendant Tradde Stephen husbandman 600872 600872 Tradde, Stephen, of Abyngton, husbandman 4
5399676 2474996 2474996 defendant Penne William clerk & Rector 600872 600872 Penne, William, of Abyngton, clerk & Rector 0
5399677 2474996 2474996 defendant Arneburgh Robert husbandman 600872 600872 Arneburgh, Robert, of Abyngton, husbandman 1
5530523 2514062 2514062 defendant Barnard John esq 600872 600872 Barnard, John, of Abyngton, esq 0
5572331 2526461 2526461 defendant Soper Robert (legal representative) 600872 600872 Soper, Robert, of Abyngton, innholder, executrix of 4
5599997 2534880 2534880 defendant Skydmore Edward carver 600872 600872 Skydmore, Edward, of Abyngton, carver 0
5618135 2549492 2549492 defendant Morebred John   600872 600872 Morebred, John, of Abyngton 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);