names

28 rows where place_id = 749034

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4387062 2160328 2160328 defendant Thorye Nicholas yeoman 749034 749034 Thorye, Nicholas, of Waynflete, Lincs, yeoman 1
4387068 2160330 2160330 defendant Thorye Nicholas yeoman 749034 749034 Thorye, Nicholas, of Waynflete, Lincs, yeoman 1
4722817 2272450 2272450 defendant Forthyngton John chapman 749034 749034 Forthyngton, John, of Waynflete, Lincs, chapman 0
4806940 2298377 2298377 defendant atte Halle John husbandman 749034 749034 atte Halle, John, of Waynflete, Lincs, husbandman 3
4806942 2298377 2298377 defendant Wace John gent 749034 749034 Wace, John, of Waynflete, Lincs, gent 5
4847254 2310642 2310642 defendant Wate John gent 749034 749034 Wate, John, of Waynflete, Lincs, gent 0
4847258 2310643 2310643 defendant Wace John gent 749034 749034 Wace, John, of Waynflete, Lincs, gent 0
4852725 2312275 2312275 defendant Wace John husbandman 749034 749034 Wace, John, of Waynflete, Lincs, husbandman 3
4874954 2319115 2319115 defendant Wace John gent 749034 749034 Wace, John, of Waynflete, Lincs, gent 0
4884412 2322025 2322025 defendant Wase William gent 749034 749034 Wase, William, of Waynflete, Lincs, gent 2
4912308 2330350 2330350 defendant Alotson Tjhomas yeoman 749034 749034 Alotson, Tjhomas, of Waynflete, Lincs, yeoman 1
4984954 2352433 2352433 defendant Forthyngton John chapman 749034 749034 Forthyngton, John, of Waynflete, Lincs, chapman 0
4984959 2352435 2352435 defendant Forthyngton John chapman 749034 749034 Forthyngton, John, of Waynflete, Lincs, chapman 0
5142181 2398837 2398837 defendant Johnson William mariner 749034 749034 Johnson, William, of Waynflete, Lincs, mariner 1
5142186 2398838 2398838 defendant Johnson William mariner 749034 749034 Johnson, William, of Waynflete, Lincs, mariner 1
5163348 2405016 2405016 defendant Johnson William mariner 749034 749034 Johnson, William, of Waynflete, Lincs, mariner 2
5163353 2405017 2405017 defendant Johnson William mariner 749034 749034 Johnson, William, of Waynflete, Lincs, mariner 1
5211253 2419019 2419019 defendant Johnson William mariner 749034 749034 Johnson, William, of Waynflete, Lincs, mariner 1
5228681 2423997 2423997 defendant Johnson William mariner 749034 749034 Johnson, William, of Waynflete, Lincs, mariner 0
5229524 2424248 2424248 defendant Baldon John, senior husbandman 749034 749034 Baldon, John, senior, of Waynflete, Lincs, husbandman 0
5279203 2439015 2439015 defendant Bullok John yeoman 749034 749034 Bullok, John, of Waynflete, Lincs, yeoman 3
5299033 2444697 2444697 defendant atte Hall John gent 749034 749034 atte Hall, John, of Waynflete, Lincs, gent 4
5327578 2453322 2453322 defendant Ganuke John husbandman 749034 749034 Ganuke, John, of Waynflete, Lincs, husbandman 0
5419283 2480693 2480693 defendant (illegible) John yeoman 749034 749034 _, John, of Waynflete, Lincs, yeoman 1
5426051 2482745 2482745 defendant Gannok John fisher 749034 749034 Gannok, John, of Waynflete, Lincs, fisher 0
5437585 2486178 2486178 defendant Person John yeoman 749034 749034 Person, John, of Waynflete, Lincs, yeoman 1
5437590 2486179 2486179 defendant Person John yeoman 749034 749034 Person, John, of Waynflete, Lincs, yeoman 1
5440902 2487192 2487192 defendant Gannok John   749034 749034 Gannok, John, of Waynflete, Lincs 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);