names

12 rows where place_id = 777240

✎ 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
4642834 2244015 2244015 defendant Laynys John   777240 777240 Laynys, John, of Mershefeld 1
4788852 2292569 2292569 defendant Iryshe Thomas tailor 777240 777240 Iryshe, Thomas, of Mershefeld, tailor 0
4807544 2298552 2298552 defendant Grome Walter   777240 777240 Grome, Walter, of Mershefeld, milward 0
4835585 2307120 2307120 defendant Fysshe William maltman 777240 777240 Fysshe, William, of Mershefeld, maltman 0
4999357 2356678 2356678 defendant Porter Richard laborer 777240 777240 Porter, Richard, of Mershefeld, laborer 0
4999376 2356683 2356683 defendant Porter Richard laborer 777240 777240 Porter, Richard, of Mershefeld, laborer 0
5017161 2361919 2361919 defendant Southwode Thomas laborer 777240 777240 Southwode, Thomas, of Mershefeld, laborer 1
5017162 2361919 2361919 defendant Millward William   777240 777240 Millward, William, of Mershefeld, servant 2
5079773 2380427 2380427 defendant Benfeld Thomas husbandman 777240 777240 Benfeld, Thomas, of Mershefeld, husbandman 10
5079774 2380427 2380427 defendant Hert Thomas baker 777240 777240 Hert, Thomas, of Mershefeld, baker 11
5324173 2452317 2452317 defendant Colerne John husbandman 777240 777240 Colerne, John, of Mershefeld, husbandman 1
5604604 2536300 2536300 defendant Saunders Nicholas husbandman 777240 777240 Saunders, Nicholas, of Mershefeld, 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);