names

21 rows where place_id = 614224

✎ 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
3663887 1914645 1914645 defendant Forde Robert, junior   614224 614224 Forde, Robert, junior, of Hadeley, cloth maker 0
3702533 1927060 1927060 defendant Strangman John gent 614224 614224 Strangman, John, of Hadeley, gent 0
3901095 1990591 1990591 defendant Tyler John laborer 614224 614224 Tyler, John, of Hadeley, laborer 1
3901096 1990591 1990591 defendant Tyler Ralph laborer 614224 614224 Tyler, Ralph, of Hadeley, laborer 2
4452826 2185894 2185894 defendant Pypere Richard   614224 614224 Pypere, Richard, of Hadeley 0
4454109 2186302 2186302 plaintiff Loteman Richard   614224 614224 Loteman, Richard, of Hadeley 0
4460639 2188385 2188385 defendant Pypere Richard   614224 614224 Pypere, Richard, of Hadeley 0
4478466 2193940 2193940 defendant Loveman Richard draper 614224 614224 Loveman, Richard, of Hadeley, draper 2
4478470 2193941 2193941 defendant Loveman Richard draper 614224 614224 Loveman, Richard, of Hadeley, draper 2
4525910 2208403 2208403 defendant Hillory Robert   614224 614224 Hillory, Robert, of Hadeley 1
4537643 2212045 2212045 defendant Debyl Richard   614224 614224 Debyl, Richard, of Hadeley 0
4549886 2215897 2215897 defendant Seman John   614224 614224 Seman, John, of Hadeley 2
4554856 2217447 2217447 plaintiff Hardeheved Philip   614224 614224 Hardeheved, Philip, of Hadeley 0
4554865 2217450 2217450 plaintiff Hardheved Philip   614224 614224 Hardheved, Philip, of Hadeley 0
4554976 2217484 2217484 defendant Tiryngton Henry   614224 614224 Tiryngton, Henry, of Hadeley 0
4623529 2238336 2238336 defendant Doddere Thomas   614224 614224 Doddere, Thomas, of Hadeley 2
4636873 2242349 2242349 defendant Wade John   614224 614224 Wade, John, of Hadeley 5
4744359 2278873 2278873 defendant Cook John butcher 614224 614224 Cook, John, of Hadeley, butcher 2
5235835 2426060 2426060 defendant Yonge John beer brewer 614224 614224 Yonge, John, of Hadeley, beer brewer 0
5553215 2520980 2520980 plaintiff Gardener Stephen draper 614224 614224 Gardener, Stephen, of Hadeley, draper 0
5633455 2554460 2554460 defendant Cremvyle Nicholas dyer 614224 614224 Cremvyle, Nicholas, of Hadeley, dyer 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);