names

30 rows where place_id = 602611

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650907 1910651 1910651 defendant Roughell Nicholas ironmonger 602611 602611 Roughell, Nicholas, of Burcestre, ironmonger 0
3967377 2013218 2013218 plaintiff Burman Thomas tailor 602611 602611 Burman, Thomas, of Burcestre, tailor 0
4413788 2169209 2169209 defendant Serch Richard   602611 602611 Serch, Richard, of Burcestre or Bicester 0
4413790 2169210 2169210 defendant Smyth Peter le   602611 602611 Smyth, Peter le, of Burcestre 0
4488959 2197263 2197263 defendant Cok Thomas   602611 602611 Cok, Thomas, of Burcestre 0
4495032 2199137 2199137 plaintiff Buckunhull Robert   602611 602611 Buckunhull, Robert, of Burcestre or Bicester, on his own account 0
4524332 2207947 2207947 defendant Skynnere Richard   602611 602611 Skynnere, Richard, of Burcestre 0
4606398 2233117 2233117 defendant Tannere John   602611 602611 Tannere, John, of Burcestre 6
4607911 2233594 2233594 plaintiff Bocher John   602611 602611 Bocher, John, of Burcestre 0
4614243 2235467 2235467 plaintiff Draper Thomas   602611 602611 Draper, Thomas, of Burcestre 0
4633977 2241480 2241480 plaintiff White John   602611 602611 White, John, of Burcestre 0
4866901 2316610 2316610 defendant Buns Hugh butcher 602611 602611 Buns, Hugh, of Burcestre, butcher 1
4881343 2321069 2321069 defendant Hunte John husbandman 602611 602611 Hunte, John, of Burcestre, husbandman 0
4945484 2340565 2340565 defendant Lynde Richard ostler 602611 602611 Lynde, Richard, of Burcestre, ostler 3
4975764 2349714 2349714 plaintiff Norton Edmund tailor 602611 602611 Norton, Edmund, of Burcestre, tailor 0
5051080 2371931 2371931 plaintiff Wantynge John   602611 602611 Wantynge, John, of Burcestre or Bicester, prior 0
5069136 2377264 2377264 defendant Huntyngdon John yeoman 602611 602611 Huntyngdon, John, of Burcestre, yeoman 0
5069137 2377264 2377264 defendant Gybbes Richard yeoman 602611 602611 Gybbes, Richard, of Burcestre, yeoman 1
5090297 2383541 2383541 defendant Ivys Thomas husbandman 602611 602611 Ivys, Thomas, of Burcestre, husbandman 0
5217365 2420816 2420816 defendant Huntyngdon William gent 602611 602611 Huntyngdon, William, of Burcestre, gent 0
5276931 2438334 2438334 defendant Tytsale Thomas (legal representative) 602611 602611 Tytsale, Thomas, of Burcestre or Bicester, executors of 0
5285746 2440858 2440858 defendant Barrye Richard yeoman 602611 602611 Barrye, Richard, of Burcestre, yeoman 1
5294860 2443483 2443483 defendant Tofte Roger salter 602611 602611 Tofte, Roger, of Burcestre, salter 1
5463945 2494134 2494134 defendant Cartworth John husbandman 602611 602611 Cartworth, John, of Burcestre, husbandman 0
5551544 2520492 2520492 plaintiff Cresse Thomas (legal representative) 602611 602611 Cresse, Thomas, of Burcestre, executrix of 0
5605667 2536655 2536655 defendant Browne William husbandman 602611 602611 Browne, William, of Burcestre, husbandman 0
5612099 2547519 2547519 defendant Carpenter Thomas   602611 602611 Carpenter, Thomas, of Burcestre 0
5612101 2547519 2547519 defendant Houth Thomas   602611 602611 Houth, Thomas, of Burcestre 2
5612106 2547519 2547519 defendant Correour Henry   602611 602611 Correour, Henry, of Burcestre, servant of Richard Correour 7
5612107 2547519 2547519 defendant Godchild William   602611 602611 Godchild, William, of Burcestre 8

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);