names

26 rows where place_id = 755778

✎ 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
4414540 2169450 2169450 defendant Hebbere John le   755778 755778 Hebbere, John le, of Little Waltham, son of Se_ 0
4431186 2174514 2174514 defendant atte Grove Severus   755778 755778 atte Grove, Severus, of Little Waltham 0
4459834 2188130 2188130 plaintiff Sawene Jacob   755778 755778 Sawene, Jacob, of Little Waltham 0
4515783 2205363 2205363 defendant Chaymel John   755778 755778 Chaymel, John, of Little Waltham 0
4515785 2205364 2205364 defendant Chayne John   755778 755778 Chayne, John, of Little Waltham 0
4527054 2208741 2208741 plaintiff Lenegor John   755778 755778 Lenegor, John, of Little Waltham 0
4609677 2234122 2234122 defendant Osebarn John   755778 755778 Osebarn, John, of Little Waltham 0
4609679 2234123 2234123 defendant Osebarn John   755778 755778 Osebarn, John, of Little Waltham 0
4685145 2260956 2260956 plaintiff Rolfe Richard   755778 755778 Rolfe, Richard, of Little Waltham 0
4685146 2260956 2260956 defendant Osbern John yeoman 755778 755778 Osbern, John, of Little Waltham, yeoman 0
4712904 2269349 2269349 defendant Eldefeld Adam yeoman 755778 755778 Eldefeld, Adam, of Little Waltham, yeoman 0
4727704 2273907 2273907 defendant atte Hill Stephen husbandman 755778 755778 atte Hill, Stephen, of Little Waltham, husbandman 0
4763000 2284412 2284412 defendant atte Hill Stephen husbandman 755778 755778 atte Hill, Stephen, of Little Waltham,husbandman 0
4768971 2286274 2286274 plaintiff Osebarne John   755778 755778 Osebarne, John, of Little Waltham 0
4823154 2303330 2303330 defendant Rolf John, senior   755778 755778 Rolf, John, senior, of Little Waltham, wool man 0
4828986 2305108 2305108 defendant Hebbenge William   755778 755778 Hebbenge, William, of Little Waltham, parson 0
4834669 2306846 2306846 defendant Waleys William clerk 755778 755778 Waleys, William, of Little Waltham, clerk 0
4834670 2306846 2306846 defendant Rolfe John husbandman 755778 755778 Rolfe, John, of Little Waltham, husbandman 1
4834671 2306846 2306846 defendant Lewegore John husbandman 755778 755778 Lewegore, John, of Little Waltham, husbandman 2
4840152 2308471 2308471 defendant Rolf Roger tanner 755778 755778 Rolf, Roger, of Little Waltham, tanner 0
4845196 2310010 2310010 defendant Wavell John   755778 755778 Wavell, John, of Little Waltham, wheel wright 0
5044247 2369908 2369908 defendant Wakeryng Ralph husbandman 755778 755778 Wakeryng, Ralph, of Little Waltham, husbandman 1
5126455 2394213 2394213 defendant Freman Edmund yeoman 755778 755778 Freman, Edmund, of Little Waltham, yeoman 1
5126476 2394222 2394222 defendant Freman Edmund yeoman 755778 755778 Freman, Edmund, of Little Waltham, yeoman 1
5372745 2467078 2467078 defendant Stonacche John husbandman 755778 755778 Stonacche, John, of Little Waltham, husbandman 0
5623146 2551177 2551177 plaintiff Wolnet William   755778 755778 Wolnet, William, of Little Waltham 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);