names

15 rows where place_id = 637950

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3839531 1970290 1970290 defendant Taylser Richard yeoman 637950 637950 Taylser, Richard, of Rossyngton, yeoman 0
3839532 1970290 1970290 defendant Meredewe William husbandman 637950 637950 Meredewe, William, of of Rossyngton, husbandman 1
3839533 1970290 1970290 defendant Holt Robert husbandman 637950 637950 Holt, Robert, of Rossyngton, husbandman 2
3839534 1970290 1970290 defendant Holt James husbandman 637950 637950 Holt, James, of Rossyngton, husbandman 3
4633171 2241243 2241243 defendant Calton William   637950 637950 Calton, William, of Rossyngton 1
4768671 2286178 2286178 defendant Wyndon John husbandman 637950 637950 Wyndon, John, of Rossyngton, husbandman 2
4960402 2345077 2345077 defendant Hyde William husbandman 637950 637950 Hyde, William, of Rossyngton, husbandman 3
4960403 2345077 2345077 defendant Hyde Thomas husbandman 637950 637950 Hyde, Thomas, of Rossyngton, husbandman 4
4960404 2345077 2345077 defendant Philipotte John husbandman 637950 637950 Philipotte, John, of Rossyngton, husbandman 5
4960405 2345077 2345077 defendant Calton Richard husbandman 637950 637950 Calton, Richard, of Rossyngton, husbandman 6
4960406 2345077 2345077 defendant Smyth John laborer 637950 637950 Smyth, John, of Rossyngton, laborer 7
4960407 2345077 2345077 defendant Adbaston Thomas husbandman 637950 637950 Adbaston, Thomas, of Rossyngton, husbandman 8
4960410 2345077 2345077 defendant Calton William chapman 637950 637950 Calton, William, of Rossyngton, chapman 11
4960411 2345077 2345077 defendant Pecok John tailor 637950 637950 Pecok, John, of Rossyngton, tailor 12
5362853 2464027 2464027 defendant Tyrre Thomas husbandman 637950 637950 Tyrre, Thomas, of Rossyngton, 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);