names

21 rows where place_id = 611255

✎ 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
3687601 1922295 1922295 defendant Harrys John laborer 611255 611255 Harrys, John, of Kyngton St Michael, laborer 0
3687605 1922295 1922295 defendant Burchell Agnes widow 611255 611255 Burchell, Agnes, of Kyngton St Michael, widow 4
3725317 1934214 1934214 plaintiff Snell Richard yeoman of the king 611255 611255 Snell, Richard, of Kyngton St Michael, yeoman of the king 0
3853472 1974711 1974711 plaintiff Snell Richard yeoman of the king 611255 611255 Snell, Richard, of Kyngton St Michael, yeoman of the king 0
3853473 1974711 1974711 defendant Lyghte Richard husbandman 611255 611255 Lyghte, Richard, of Kyngton St Michael, husbandman 0
3853474 1974711 1974711 defendant Hull Thomas clerk 611255 611255 Hull, Thomas, of Kyngton St Michael, clerk 1
4569480 2222040 2222040 defendant Cope William   611255 611255 Cope, William, of Kyngton St Michael 1
4703282 2266404 2266404 defendant Saynesbury Thomas clerk 611255 611255 Saynesbury, Thomas, of Kyngton St Michael, clerk 0
5262184 2433920 2433920 defendant Bray John laborer 611255 611255 Bray, John, of Kyngton St Michael, laborer 6
5266082 2435143 2435143 defendant Harold John husbandman 611255 611255 Harold, John, of Kyngton St Michael, husbandman 0
5299730 2444889 2444889 defendant Keynell Walter husbandman 611255 611255 Keynell, Walter, of Kyngton St Michael, husbandman 0
5312611 2448806 2448806 defendant Kaynell Walter gent 611255 611255 Kaynell, Walter, of Kyngton St Michael, gent 0
5365164 2464777 2464777 defendant Turney John husbandman 611255 611255 Turney, John, of Kyngton St Michael, husbandman 0
5365165 2464777 2464777 defendant Broun John husbandman 611255 611255 Broun, John, of Kyngton St Michael, husbandman 1
5372574 2467021 2467021 defendant Duke Walter husbandman 611255 611255 Duke, Walter, of Kyngton St Michael, husbandman 0
5415408 2479544 2479544 defendant Duke Walter husbandman 611255 611255 Duke, Walter, of Kyngton St Michael, husbandman 0
5431641 2484421 2484421 defendant Duke Walter husbandman 611255 611255 Duke, Walter, of Kyngton St Michael, husbandman 0
5433507 2484983 2484983 defendant Duke Walter husbandman 611255 611255 Duke, Walter, of Kyngton St Michael, husbandman 0
5449277 2489674 2489674 defendant (illegible) Walter husbandman 611255 611255 _, Walter, of Kyngton St Michael, husbandman 0
5489961 2501886 2501886 defendant Turney John husbandman 611255 611255 Turney, John, of Kyngton St Michael, husbandman 1
5489962 2501886 2501886 defendant Browne John husbandman 611255 611255 Browne, John, of Kyngton St Michael, husbandman 2

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