names

17 rows where place_id = 701239

✎ 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
4137450 2073743 2073743 defendant Ingre Edward yeoman 701239 701239 Ingre, Edward, of Shepereth, yeoman 0
4634488 2241633 2241633 defendant Pulter Nicholas   701239 701239 Pulter, Nicholas, of Shepereth 0
4643020 2244065 2244065 defendant Londeneys John   701239 701239 Londeneys, John, of Shepereth 1
4654246 2247209 2247209 defendant Taillour John   701239 701239 Taillour, John, of Shepereth, shepherd 1
4654247 2247209 2247209 defendant Broke John husbandman 701239 701239 Broke, John, of Shepereth, husbandman 2
4654340 2247231 2247231 defendant Sympton John ploughman 701239 701239 Sympton, John, of Shepereth, ploughman 3
4654341 2247231 2247231 defendant Beton John ploughman 701239 701239 Beton, John, of Shepereth, ploughman 4
4654342 2247231 2247231 defendant Fuller John ploughman 701239 701239 Fuller, John, of Shepereth, ploughman 5
4654343 2247231 2247231 defendant Cassaundre Thomas ploughman 701239 701239 Cassaundre, Thomas, of Shepereth, ploughman 6
4771659 2287112 2287112 defendant Pulter Nicholas husbandman 701239 701239 Pulter, Nicholas, of Shepereth, husbandman 1
4816308 2301186 2301186 plaintiff Lundeneys John   701239 701239 Lundeneys, John, of Shepereth 0
4818389 2301831 2301831 defendant Cartere Robert laborer 701239 701239 Cartere, Robert, of Shepereth, laborer 1
4847742 2310787 2310787 defendant Gylle William husbandman 701239 701239 Gylle, William, of Shepereth, husbandman 3
4893370 2324629 2324629 defendant Pulter Nicholas husbandman 701239 701239 Pulter, Nicholas, of Shepereth, husbandman 0
5230616 2424565 2424565 defendant Heynes John husbandman 701239 701239 Heynes, John, of Shepereth, husbandman 1
5258479 2432768 2432768 defendant Beton Robert husbandman 701239 701239 Beton, Robert, of Shepereth, husbandman 0
5516669 2510042 2510042 defendant Taillour William husbandman 701239 701239 Taillour, William, of Shepereth, husbandman 1

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