names

15 rows where place_id = 590189

✎ 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
3600184 1867707 1867707 defendant Warter Henry husbandman 590189 590189 Warter, Henry, of Melton Rose, husbandman 5
3682567 1920652 1920652 defendant Potter Robert husbandman 590189 590189 Potter, Robert, of Melton Rose, husbandman 4
4072355 2050415 2050415 plaintiff Otbye Edward yeoman 590189 590189 Otbye, Edward, of Melton Rose, yeoman 0
4835855 2307201 2307201 defendant Scate Thomas weaver 590189 590189 Scate, Thomas, of Melton Rose, weaver 10
4855591 2313114 2313114 defendant Cartwryght John husbandman 590189 590189 Cartwryght, John, of Melton Rose, husbandman 0
4891408 2324042 2324042 defendant Gournay Thomas husbandman 590189 590189 Gournay, Thomas, of Melton Rose, husbandman 0
4904953 2328152 2328152 defendant Clerk Richard husbandman 590189 590189 Clerk, Richard, of Melton Rose, husbandman 1
4911561 2330118 2330118 defendant Halton John husbandman 590189 590189 Halton, John, of Melton rose, husbandman 1
4911562 2330118 2330118 defendant atte Halles John   590189 590189 atte Halles, John, of Melton Rose, wright 2
4914502 2331055 2331055 defendant Neucome John husbandman 590189 590189 Neucome, John, of Melton Rose, husbandman 0
4914503 2331055 2331055 defendant Pacok William husbandman 590189 590189 Pacok, William, of Melton Rose, husbandman 1
4914504 2331055 2331055 defendant Clerk Richard husbandman 590189 590189 Clerk, Richard, of Melton Rose, husbandman 2
4914508 2331055 2331055 defendant Gournay Thomas husbandman 590189 590189 Gournay, Thomas, of Melton Rose,husbandman 6
4938987 2338586 2338586 defendant Spillesby Robert   590189 590189 Spillesby, Robert, of Melton Rose, shepherd 0
5572420 2526475 2526475 defendant Wodhall Robert husbandman 590189 590189 Wodhall, Robert, of Melton Rose, husbandman 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);