names

17 rows where place_id = 619299

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3663303 1914447 1914447 defendant Benne Robert   619299 619299 Benne, Robert, of Waldon, malt man 3
3729172 1935373 1935373 defendant Mone Thomas husbandman 619299 619299 Mone, Thomas, of Waldon, husbandman 0
3810816 1961285 1961285 defendant Spruce John tailor 619299 619299 Spruce, John, of Waldon, tailor 0
3876061 1982246 1982246 defendant Rutland John butcher 619299 619299 Rutland, John, of Waldon, butcher 2
4415868 2169852 2169852 defendant Tailour Edmund   619299 619299 Tailour, Edmund, of Waldon 6
4415873 2169852 2169852 defendant del Halle John   619299 619299 together with del Halle, John, of Waldon, bailiff 11
4717243 2270722 2270722 plaintiff Yerd John   619299 619299 Yerd, John, of Waldon 0
4725889 2273385 2273385 defendant May Thomas husbandman 619299 619299 May, Thomas, of Waldon, husbandman 3
4730505 2274739 2274739 defendant Payn Walter   619299 619299 Payn, Walter, of Waldon, school master 2
4792919 2293873 2293873 defendant Broun David pardoner 619299 619299 Broun, David, of Waldon, pardoner 0
4860576 2314665 2314665 defendant Carter Thomas husbandman 619299 619299 Carter, Thomas, of Waldon, husbandman 0
4881691 2321173 2321173 defendant Carter Thomas chapman 619299 619299 Carter, Thomas, of Waldon, chapman 0
5150654 2401340 2401340 defendant Semar John husbandman 619299 619299 Semar, John, of Waldon, husbandman 1
5250666 2430317 2430317 defendant Ayly John cordwainer 619299 619299 Ayly, John, of Waldon, cordwainer 0
5304119 2446241 2446241 defendant Note Simon shoemaker 619299 619299 Note, Simon, of Waldon, shoemaker 1
5431800 2484479 2484479 defendant Parys Simon tiler 619299 619299 Parys, Simon, of Waldon, tiler 1
5463897 2494119 2494119 defendant Curtney Stephen dyer 619299 619299 Curtney, Stephen, of Waldon, dyer 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);