names

26 rows where place_id = 597103

✎ 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
3627301 1903387 1903387 defendant Hedy John husbandman 597103 597103 Hedy, John, of Pepulton, husbandman 0
3632894 1905105 1905105 defendant Gybbons William husbandman 597103 597103 Gybbons, William, of Pepulton, husbandman 2
3632895 1905105 1905105 defendant Pynsyn William husbandman 597103 597103 Pynsyn, William, of Pepulton, husbandman 3
3632900 1905106 1905106 defendant Gybbyns William husbandman 597103 597103 Gybbyns, William, of Pepulton, husbandman 2
3632901 1905106 1905106 defendant Pysyn William husbandman 597103 597103 Pysyn, William, of Pepulton, husbandman 3
3657043 1912464 1912464 defendant Hyll Thomas husbandman 597103 597103 Hyll, Thomas, of Pepulton, husbandman 4
3671868 1917200 1917200 defendant Gybbyns William husbandman 597103 597103 Gybbyns, William, of Pepulton, husbandman 6
3702909 1927182 1927182 defendant Payne Robert tailor 597103 597103 Payne, Robert, of Pepulton, tailor 0
3702910 1927182 1927182 defendant Sheffeld Richard husbandman 597103 597103 Sheffeld, Richard, of Pepulton, husbandman 1
3702911 1927182 1927182 defendant Sheriff Henry husbandman 597103 597103 Sheriff, Henry, of Pepulton, husbandman 2
3731982 1936236 1936236 defendant Gybbyns Thomas husbandman 597103 597103 Gybbyns, Thomas, of Pepulton, husbandman 0
3741705 1939271 1939271 defendant Style Ralph husbandman 597103 597103 Style, Ralph, of Pepulton, husbandman 0
3759659 1945011 1945011 defendant Hedyn John husbandman 597103 597103 Hedyn, John, of Pepulton, husbandman 2
3777532 1950725 1950725 defendant Kyrwode William butcher 597103 597103 Kyrwode, William, of Pepulton, butcher 1
3779623 1951356 1951356 defendant Gonne Thomas husbandman 597103 597103 Gonne, Thomas, of Pepulton, husbandman 0
3790437 1954830 1954830 defendant Byllyng Robert husbandman 597103 597103 Byllyng, Robert, of Pepulton, husbandman 3
3790438 1954830 1954830 defendant Hedy John husbandman 597103 597103 Hedy, John, of Pepulton, husbandman 4
3794937 1956281 1956281 defendant Hedy John husbandman 597103 597103 Hedy, John, of Pepulton, husbandman 9
3796620 1956818 1956818 defendant Gonne Thomas husbandman 597103 597103 Gonne, Thomas, of Pepulton, husbandman 0
3824358 1965489 1965489 defendant Hedy John husbandman 597103 597103 Hedy, John, of Pepulton, husbandman 0
3824359 1965489 1965489 defendant Shreve alias Gybbyns Henry husbandman 597103 597103 Shreve alias Gybbyns, Henry, of Pepulton, husbandman 1
5095897 2385228 2385228 defendant Mors William husbandman 597103 597103 Mors, William, of Pepulton, husbandman 0
5247396 2429396 2429396 defendant Sevarn Richard husbandman 597103 597103 Sevarn, Richard, of Pepulton, husbandman 0
5247397 2429396 2429396 defendant Whytyng John husbandman 597103 597103 Whytyng, John, of Pepulton, husbandman 1
5269794 2436275 2436275 defendant Hody Richard husbandman 597103 597103 Hody, Richard, of Pepulton, husbandman 1
5309055 2447744 2447744 defendant Sytle Robert husbandman 597103 597103 Sytle, Robert, of Pepulton, husbandman 3

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