names

46 rows where place_id = 753445

✎ 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
4413541 2169126 2169126 defendant Oxenford John de   753445 753445 Oxenford, John de, of Nottinghamshire 0
4420455 2171303 2171303 defendant (not given) John his son 753445 753445 John, his son, of Nottinghamshire 1
4433421 2175213 2175213 defendant Birkes William   753445 753445 Birkes, William, of Nottinghamshire 2
4460394 2188311 2188311 defendant Newmarche Hugh   753445 753445 Newmarche, Hugh, of Nottinghamshire, knight 0
4492061 2198208 2198208 defendant Byldesthorp John   753445 753445 Byldesthorp, John, of Nottinghamshire 0
4497473 2199854 2199854 defendant Athelyng John   753445 753445 Athelyng, John, of Nottinghamshire 1
4512965 2204489 2204489 defendant Halom Robert   753445 753445 Halom, Robert, of Nottinghamshire 0
4513000 2204501 2204501 defendant Hayton Robert de   753445 753445 Hayton, Robert de, of Nottinghamshire 1
4523238 2207591 2207591 defendant Staunton Ralph de   753445 753445 Staunton, Ralph de, of Nottinghamshire 2
4524458 2207989 2207989 defendant atte Kirke John   753445 753445 atte Kirke, John, of Nottinghamshire 1
4526245 2208497 2208497 defendant Morton Robert   753445 753445 Morton, Robert, of Nottinghamshire 0
4526583 2208591 2208591 defendant Laxton Thomas   753445 753445 Laxton, Thomas, of Nottinghamshire 2
4561688 2219591 2219591 defendant Bekyngham Roger de   753445 753445 Bekyngham, Roger de, of Nottinghamshire 0
4574040 2223404 2223404 defendant Cranby John   753445 753445 Cranby, John, of Nottinghamshire 0
4578130 2224662 2224662 defendant Caufrey William   753445 753445 Caufrey, William, of Nottinghamshire 2
4578134 2224663 2224663 defendant Caudrey William   753445 753445 Caudrey, William, of Nottinghamshire 2
4595340 2229794 2229794 defendant Meryng William   753445 753445 Meryng, William, of Nottinghamshire 1
4595352 2229796 2229796 defendant Meryng William   753445 753445 Meryng, William, of Nottinghamshire 1
4598531 2230776 2230776 defendant Thoresby John   753445 753445 Thoresby, John, of Nottinghamshire 0
4600748 2231461 2231461 defendant Warde Nicholas   753445 753445 Warde, Nicholas, of Nottinghamshire 0
4600972 2231531 2231531 defendant Stanhope Richard   753445 753445 Stanhope, Richard, of Nottinghamshire, knight 1
4629982 2240300 2240300 defendant Pare Ralph   753445 753445 Pare, Ralph, of Nottinghamshire 0
4646270 2244982 2244982 defendant Warde Nicholas   753445 753445 Warde, Nicholas, of Nottinghamshire 0
4646274 2244983 2244983 defendant Warde Nicholas   753445 753445 Warde, Nicholas, of Nottinghamshire 0
4718289 2271059 2271059 plaintiff Babyngton William   753445 753445 Babyngton, William, of Nottinghamshire 0
4909599 2329538 2329538 plaintiff Fox John   753445 753445 Fox, John, of Nottinghamshire 1
4910926 2329929 2329929 plaintiff Bowys Henry esq 753445 753445 Bowys, Henry, of Nottinghamshire, esq 0
4910928 2329930 2329930 plaintiff Bowys Henry esq 753445 753445 Bowys, Henry, of Nottinghamshire, esq, on his own account 0
5043526 2369684 2369684 plaintiff Froste Walter esq 753445 753445 Froste, Walter, of Nottinghamshire, esq, gent & brother of Thomas Frost of Gaytforth, son of Thomas Frost of Beverley, esq 0
5049842 2371579 2371579 defendant Sutton Richard esq 753445 753445 Sutton, Richard, of Nottinghamshire, esq 1
5049848 2371580 2371580 defendant Sutton Richard esq 753445 753445 Sutton, Richard, of Nottinghamshire, esq 1
5051135 2371953 2371953 defendant Serelley John esq 753445 753445 Serelley, John, of Nottinghamshire, esq 0
5137678 2397533 2397533 defendant Syeston Thomas   753445 753445 Syeston, Thomas, of Nottinghamshire 0
5138954 2397888 2397888 defendant Nort--- Robert yeoman 753445 753445 Nort---, Robert, of Nottinghamshire, yeoman 9
5302736 2445800 2445800 defendant D_ Thomas smith 753445 753445 D_, Thomas, of Nottinghamshire, smith 0
5383197 2470270 2470270 defendant Waryner Reginald   753445 753445 Waryner, Reginald, of Nottinghamshire 0
5385988 2471066 2471066 plaintiff Clyfton Gervase   753445 753445 Clyfton, Gervase, of Nottinghamshire, formerly sheriff, knight, formerly esquire 0
5390287 2472287 2472287 plaintiff Markham Robert   753445 753445 Markham, Robert, of Nottinghamshire, knight & formerly sheriff 0
5411293 2478337 2478337 plaintiff Clyfton Gervase   753445 753445 Clyfton, Gervase, of Nottinghamshire, sheriff & knight 0
5415710 2479641 2479641 defendant Weston William husbandman 753445 753445 Weston, William, of Nottinghamshire, husbandman 1
5421417 2481341 2481341 defendant Bla_ Henry gent 753445 753445 Bla_, Henry, of Nottinghamshire, gent 1
5447359 2489104 2489104 defendant Serlby William esq 753445 753445 Serlby, William, of Nottinghamshire, esq 0
5471704 2496487 2496487 defendant M_ John husbandman 753445 753445 M_, John, of Nottinghamshire, husbandman 0
5619888 2550081 2550081 plaintiff Staunton Thomas de   753445 753445 Staunton, Thomas de, of Nottinghamshire 0
5621272 2550540 2550540 plaintiff Staunton Thomas de   753445 753445 Staunton, Thomas de, of Nottinghamshire 1
5622779 2551055 2551055 defendant Kyngham Richard de   753445 753445 Kyngham, Richard de, of Nottinghamshire, knight 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);