names

11 rows where place_id = 714217

✎ 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
4202943 2096575 2096575 defendant Coxe Henry husbandman 714217 714217 Coxe, Henry, of Pakynton, husbandman 0
4663878 2250187 2250187 defendant Mody John husbandman 714217 714217 Mody, John, of Pakynton, husbandman 0
4757525 2282733 2282733 defendant Soweman John husbandman 714217 714217 Soweman, John, of Pakynton, husbandman 0
4922320 2333394 2333394 defendant Pynchebek William   714217 714217 Pynchebek, William, of Pakynton 14
4922325 2333394 2333394 defendant Dadyngton John   714217 714217 Dadyngton, John, of Pakynton 19
5145650 2399869 2399869 defendant Bothe John carpenter 714217 714217 Bothe, John, of Pakynton Prior, carpenter 0
5145652 2399869 2399869 defendant Bredsale John collier 714217 714217 Bredsale, John, of Pakynton Prior, collier 2
5381076 2469641 2469641 defendant Dadyngton John husbandman 714217 714217 Dadyngton, John, of Pakynton, husbandman 0
5381077 2469641 2469641 defendant Benet Thomas   714217 714217 Benet, Thomas, of Pakynton 1
5381141 2469664 2469664 defendant Dadyngton John husbandman 714217 714217 Dadyngton, John, of Pakynton, husbandman 1
5381142 2469664 2469664 defendant Benet Thomas husbandman 714217 714217 Benet, Thomas, of Pakynton, husbandman 2

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);