names

32 rows where place_id = 610599

✎ 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
3684317 1921229 1921229 defendant Shaxton Thomas, junior yeoman 610599 610599 Shaxton, Thomas, junior, of Bathele, yeoman 4
3684320 1921230 1921230 defendant Shaxton Thomas, junior yeoman 610599 610599 (Shaxton, Thomas, junior, of Bathele, yeoman 1
3909232 1993383 1993383 plaintiff Shaxton Thomas (legal representative) 610599 610599 Shaxton, Thomas, of Bathele, executors of 0
3920653 1997256 1997256 plaintiff Myghte Geoffrey yeoman 610599 610599 Myghte, Geoffrey, of Bathele, yeoman 0
3978317 2017000 2017000 plaintiff Shaxston Nicholas yeoman 610599 610599 Shaxston, Nicholas, of Bathele, yeoman 1
4030098 2035412 2035412 defendant Shaxton Nicholas yeoman 610599 610599 Shaxton, Nicholas, of Bathele, yeoman 0
4216338 2101208 2101208 defendant Mason George yeoman 610599 610599 Mason, George, of Bathele, yeoman 0
4755661 2282153 2282153 defendant Milys Thomas yeoman 610599 610599 Milys, Thomas, of Bathele, yeoman 0
4886494 2322639 2322639 defendant Redyng John gent 610599 610599 Redyng, John, of Bathele, gent 0
4886496 2322639 2322639 defendant Davy Richard husbandman 610599 610599 Davy, Richard, of Bathele, husbandman 2
4886497 2322639 2322639 defendant Walley John husbandman 610599 610599 Walley, John, of Bathele, husbandman 3
5286399 2441023 2441023 defendant Byrlyngham John yeoman 610599 610599 Byrlyngham, John, of Bathele, yeoman 1
5299084 2444714 2444714 defendant Hoppys William (legal representative) 610599 610599 Hoppys, William, of Bathele, yeoman, administratrix of 5
5299085 2444714 2444714 defendant Hoppys Agnes widow 610599 610599 Hoppys, Agnes, of Bathele, widow 6
5302073 2445578 2445578 defendant Sendall Richard laborer 610599 610599 Sendall, Richard, of Bathele, laborer 2
5304622 2446381 2446381 defendant Byrlyngham Robert yeoman 610599 610599 Byrlyngham, Robert, of Bathele, yeoman 0
5306856 2447049 2447049 plaintiff Nicholas William   610599 610599 Nicholas, William, of Bathele, parson of the church 0
5314547 2449382 2449382 defendant Byrlyngham Robert husbandman 610599 610599 Byrlyngham, Robert, of Bathele, husbandman 0
5317967 2450464 2450464 defendant Falyate Richard husbandman 610599 610599 Falyate, Richard, of Bathele, husbandman 0
5318805 2450715 2450715 defendant Hoppys William (legal representative) 610599 610599 Hoppys, William, of Bathele, yeoman, executor of 0
5318808 2450716 2450716 defendant Hoppys William (legal representative) 610599 610599 Hoppys, William, of Bathele, yeoman, executors of 0
5327715 2453356 2453356 defendant Cotys Thomas husbandman 610599 610599 Cotys, Thomas, of Bathele, husbandman 2
5331820 2454596 2454596 defendant Belham Robert barker 610599 610599 Belham, Robert, of Bathele, barker 1
5335871 2455796 2455796 defendant Roberdson John yeoman 610599 610599 Roberdson, John, of Bathele, yeoman 5
5399493 2474934 2474934 plaintiff Dunne Thomas   610599 610599 Dunne, Thomas, of Bathele 0
5413397 2478936 2478936 defendant Byrlyngham John yeoman 610599 610599 Byrlyngham, John, of Bathele, yeoman 4
5427598 2483208 2483208 defendant Falyate Richard husbandman 610599 610599 (Falyate, Richard, of Bathele, husbandman 1
5458041 2492306 2492306 defendant Falyate Richard husbandman 610599 610599 (Falyate, Richard, of Bathele, husbandman 1
5482135 2499597 2499597 defendant Falyate Richard husbandman 610599 610599 (Falyate, Richard, of Bathele, husbandman 1
5516635 2510032 2510032 defendant Collys Richard mercer 610599 610599 Collys, Richard, of Bathele, mercer 0
5538298 2516463 2516463 defendant Overton Andrew husbandman 610599 610599 Overton, Andrew, of Bathele, husbandman 0
5546520 2518981 2518981 defendant Falyatte Richard husbandman 610599 610599 Falyatte, Richard, of Bathele, husbandman 7

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