names

47 rows where place_id = 605700

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662612 1914226 1914226 plaintiff Mordaunt John esq 605700 605700 Mordaunt, John, of Turvey, Beds, esq 0
3662616 1914227 1914227 plaintiff Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, sheriff, Lord Mordaunt 0
3663121 1914377 1914377 defendant Mordaunt John esq 605700 605700 Mordaunt, John, of Turvey, Beds, esq 0
3675155 1918260 1918260 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight 0
3751073 1942264 1942264 plaintiff Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight 0
3751075 1942265 1942265 plaintiff Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight 0
3807391 1960220 1960220 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight 0
3825184 1965743 1965743 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight 0
3831365 1967698 1967698 defendant Hoddell John yeoman 605700 605700 (Hoddell, John, of Turvey, Beds, yeoman 2
3854772 1975138 1975138 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight, Lord Mordaunt 0
3854773 1975138 1975138 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight 1
3854777 1975139 1975139 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight, Lord Mordaunt 0
3854778 1975139 1975139 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight 1
3876694 1982448 1982448 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, knight, Lord Mordaunt 0
3881318 1984016 1984016 defendant Downall Richard gent 605700 605700 Downall, Richard, of Turvey, Beds, gent 1
3881321 1984017 1984017 defendant Downall Richard gent 605700 605700 Downall, Richard, of Turvey, Beds, gent 1
4194845 2093758 2093758 defendant Pemberton Raphael gent 605700 605700 Pemberton, Raphael, of Turvey, Beds, gent 1
4235045 2107809 2107809 defendant Malcott Richard yeoman 605700 605700 Malcott, Richard, of Turvey, Beds, yeoman 0
4236310 2108271 2108271 defendant Edes Hugh butcher 605700 605700 Edes, Hugh, of Turvey, Beds, butcher 0
4254025 2114345 2114345 defendant Malcott Richard yeoman 605700 605700 Malcott, Richard, of Turvey, Beds, yeoman 0
4314586 2135216 2135216 defendant Malott or Malcott Richard yeoman 605700 605700 Malott or Malcott, Richard, of Turvey, Beds, yeoman 0
4333271 2141411 2141411 defendant Symes Richard (legal representative) 605700 605700 Symes, Richard, of Turvey, Beds, gent, administratrix of 0
4599720 2231130 2231130 defendant Geffreay Edmund   605700 605700 Geffreay, Edmund, of Turvey, Beds 0
4599722 2231131 2231131 defendant Geffrey Edmund   605700 605700 Geffrey, Edmund, of Turvey, Beds 0
4599724 2231132 2231132 defendant Geffrey Edmund   605700 605700 Geffrey, Edmund, of Turvey, Beds 0
4605797 2232927 2232927 plaintiff atte Brigge John   605700 605700 atte Brigge, John, of Turvey, Beds 0
4701863 2265987 2265987 defendant Mordaunt Robert esq 605700 605700 Mordaunt, Robert, of Turvey, Beds, esq 1
4701864 2265987 2265987 defendant Fetour Robert husbandman 605700 605700 Fetour, Robert, of Turvey, Beds, husbandman 2
4737260 2276772 2276772 defendant atte Brigge John husbandman 605700 605700 atte Brigge, John, of Turvey, Beds, husbandman 3
4748023 2279933 2279933 defendant Dardres Thomas   605700 605700 Dardres, Thomas, of Turvey, Beds 0
4788672 2292512 2292512 defendant Fordryngeye Agnes widow 605700 605700 Fordryngeye, Agnes, of Turvey, Beds, widow 0
4891337 2324020 2324020 defendant Fyssher John gent 605700 605700 Fyssher, John, of Turvey, Beds, gent 0
4918786 2332388 2332388 defendant Halby John   605700 605700 Halby, John, of Turvey, Beds, parson 0
4941048 2339220 2339220 defendant Mordaunt Robert esq 605700 605700 Mordaunt, Robert, of Turvey, Beds, esq 0
4959702 2344863 2344863 defendant Halby John   605700 605700 Halby, John, of Turvey, Beds 0
5005755 2358579 2358579 defendant Repynghale John husbandman 605700 605700 Repynghale, John, of Turvey, Beds, husbandman 3
5005756 2358579 2358579 defendant Spede William husbandman 605700 605700 Spede, William, of Turvey, Beds, husbandman 4
5113336 2390292 2390292 defendant Goditwot John butcher 605700 605700 Goditwot, John, of Turvey, Beds, butcher 0
5114664 2390704 2390704 defendant Dory John clerk 605700 605700 Dory, John, of Turvey, Beds, clerk 0
5114763 2390732 2390732 defendant Dory John clerk 605700 605700 Dory, John, of Turvey, Beds, clerk 0
5142833 2399032 2399032 defendant Walcote Thomas smith 605700 605700 Walcote, Thomas, of Turvey, Beds, smith 0
5224037 2422714 2422714 defendant Breggeman William husbandman 605700 605700 Breggeman, William, of Turvey, Beds, husbandman 2
5235988 2426108 2426108 defendant Lawe John husbandman 605700 605700 Lawe, John, of Turvey, Beds, husbandman 0
5442176 2487578 2487578 defendant Cowes Richard yeoman 605700 605700 Cowes, Richard, of Turvey, Beds, yeoman 1
5442179 2487579 2487579 defendant Cowes Richard yeoman 605700 605700 Cowes, Richard, of Turvey, Beds, yeoman 1
5527657 2513229 2513229 defendant Mordaunt John   605700 605700 Mordaunt, John, of Turvey, Beds, gent, sergeant at law 0
5602420 2535650 2535650 defendant Mordaunt John yeoman 605700 605700 Mordaunt, John, of Turvey, Beds, esq, Broun, Thomas, of Turvey, yeoman 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);