names

17 rows where place_id = 676810

✎ 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
3756642 1944059 1944059 defendant Baron John (legal representative) 676810 676810 Baron, John, of Pynho, executors of 1
3756648 1944060 1944060 defendant Baron John (legal representative) 676810 676810 Baron, John, of Pynho, executors of 2
4024275 2033383 2033383 defendant Parker William tailor 676810 676810 Parker, William, of Pynho, tailor 1
4024340 2033391 2033391 defendant Parker William tailor 676810 676810 Parker, William, of Pynho, tailor 1
4106300 2062542 2062542 defendant Hyckman John husbandman or laborer 676810 676810 Hyckman, John, of Pynho, husbandman or laborer 0
4798345 2295670 2295670 defendant Pynde Thomas husbandman 676810 676810 Pynde, Thomas, of Pynho, husbandman 0
4837261 2307600 2307600 defendant Crymell William husbandman 676810 676810 Crymell, William, of Pynho, husbandman 1
4837262 2307600 2307600 defendant Crymall John laborer 676810 676810 Crymall, John, of Pynho, laborer 2
4929896 2335762 2335762 defendant Perys John   676810 676810 Perys, John, of Pynho, vicar 0
5089089 2383185 2383185 defendant Clemment Geoffrey laborer 676810 676810 Clemment, Geoffrey, of Pynho, laborer 0
5125548 2393959 2393959 plaintiff Baron John   676810 676810 Baron, John, of Pynho 0
5125551 2393960 2393960 plaintiff Baron John   676810 676810 Baron, John, of Pynho 0
5353388 2461138 2461138 defendant Germyn William (legal representative) 676810 676810 Germyn, William, of Pynho, executrix of 0
5353389 2461138 2461138 defendant Germyn Isabel widow 676810 676810 Germyn, Isabel, of Pynho, widow 1
5482859 2499818 2499818 defendant Elyot John carrier 676810 676810 Elyot, John, of Pynho, carrier 5
5482867 2499819 2499819 defendant Elyot John carrier 676810 676810 Elyot, John, of Pynho, carrier 5
5577561 2528047 2528047 defendant Miller John carrier 676810 676810 Miller, John, of Pynho, carrier 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);