names

13 rows where place_id = 599442

✎ 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
3636795 1906298 1906298 defendant Melton John tailor 599442 599442 Melton, John, of Helpeston, tailor 1
3636796 1906298 1906298 defendant Manne John husbandman 599442 599442 Manne, John, of Helpeston, husbandman 2
4462052 2188830 2188830 defendant Wythom Robert   599442 599442 Wythom, Robert, of Helpeston 0
4462054 2188831 2188831 defendant Wythom Robert   599442 599442 Wythom, Robert, of Helpeston 0
4543148 2213737 2213737 defendant Sulgrave John de   599442 599442 Sulgrave, John de, of Helpeston 0
4574022 2223397 2223397 defendant Rysborough John   599442 599442 Rysborough, John, of Helpeston 0
4629429 2240132 2240132 defendant Benet Richard coueser 599442 599442 Benet, Richard, of Helpeston, coueser 1
4629438 2240135 2240135 defendant Benet Richard shoemaker 599442 599442 Benet, Richard, of Helpeston, shoemaker 1
4752306 2281135 2281135 defendant Crosseby Roger husbandman 599442 599442 Crosseby, Roger, of Helpeston, husbandman 0
4902754 2327481 2327481 defendant Thakker John husbandman 599442 599442 Thakker, John, of Helpeston, husbandman 0
5247178 2429332 2429332 defendant Blogwyn John husbandman 599442 599442 Blogwyn, John, of Helpeston, husbandman 0
5281946 2439795 2439795 defendant Mullesworth Thomas gent 599442 599442 Mullesworth, Thomas, of Helpeston, gent 0
5281947 2439795 2439795 defendant Kynge Thomas yeoman 599442 599442 Kynge, Thomas, of Helpeston, yeoman 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);