names

30 rows where place_id = 596035

✎ 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
3622831 1874672 1874672 defendant A Berewe Stephen husbandman 596035 596035 A Berewe, Stephen, of Fretynden, husbandman 0
3633294 1905230 1905230 defendant Badcok John yeoman 596035 596035 Badcok, John, of Fretynden, yeoman 0
3633295 1905230 1905230 defendant Sander William fuller 596035 596035 Sander, William, of Fretynden, fuller 1
3665806 1915246 1915246 defendant Dogett Thomas husbandman 596035 596035 Dogett, Thomas, of Fretynden, husbandman 0
3666401 1915442 1915442 defendant Halsnoth Robert yeoman 596035 596035 Halsnoth, Robert, of Fretynden, yeoman 2
3668487 1916098 1916098 defendant Edward William tailor 596035 596035 Edward, William, of Fretynden, tailor 0
3677208 1918915 1918915 defendant Burdon John butcher 596035 596035 Burdon, John, of Fretynden, butcher 0
3678420 1919304 1919304 defendant Ferlyng Robert clerk 596035 596035 Ferlyng, Robert, of Fretynden, clerk 0
3693906 1924297 1924297 defendant Igolynden William millman 596035 596035 Igolynden, William, of Fretynden, millman 4
3705455 1927995 1927995 defendant Halfnoth Thomas laborer 596035 596035 Halfnoth, Thomas, of Fretynden, laborer 0
3723266 1933548 1933548 defendant Jefferay William clothier 596035 596035 Jefferay, William, of Fretynden, clothier 1
3760903 1945415 1945415 defendant Halsnoth Robert husbandman 596035 596035 Halsnoth, Robert, of Fretynden, husbandman 0
3789252 1954455 1954455 defendant Whyte alias Joce Robert beer brewer 596035 596035 Whyte alias Joce, Robert, of Fretynden, beer brewer 3
3808765 1960621 1960621 defendant Shadwell Thomas butcher 596035 596035 Shadwell, Thomas, of Fretynden, butcher 0
3836461 1969311 1969311 defendant Holand John husbandman 596035 596035 Holand, John, of Fretynden, husbandman 1
3837126 1969512 1969512 defendant Bendon John butcher 596035 596035 Bendon, John, of Fretynden, butcher 0
3840795 1970687 1970687 defendant Herenden Geoffrey husbandman 596035 596035 Herenden, Geoffrey, of Fretynden, husbandman 0
3840796 1970687 1970687 defendant Pacchyng Richard husbandman 596035 596035 Pacchyng, Richard, of Fretynden, husbandman 1
3857491 1975979 1975979 defendant Herenden Geoffrey husbandman 596035 596035 Herenden, Geoffrey, of Fretynden, husbandman 0
3857492 1975979 1975979 defendant Pacchyng Richard husbandman 596035 596035 Pacchyng, Richard, of Fretynden, husbandman 1
3894981 1988529 1988529 defendant Taylour Walter   596035 596035 Taylour, Walter, of Fretynden 0
3896113 1988904 1988904 plaintiff Taylour Walter   596035 596035 Taylour, Walter, of Fretynden 0
3919816 1996963 1996963 defendant Benden John (legal representative) 596035 596035 Benden, John, of Fretynden, butcher, executrix of 1
5111129 2389640 2389640 defendant Godard Richard husbandman 596035 596035 Godard, Richard, of Fretynden, husbandman 2
5281025 2439527 2439527 defendant Hamond John husbandman 596035 596035 Hamond, John, of Fretynden, husbandman 3
5381530 2469774 2469774 defendant Barowe John   596035 596035 Barowe, John, of Fretynden 1
5519663 2510983 2510983 defendant Lucas Clement glover 596035 596035 Lucas, Clement, of Fretynden, glover 1
5564672 2524253 2524253 defendant Halfnoth Walter yeoman 596035 596035 Halfnoth, Walter, of Fretynden, yeoman 0
5566957 2524931 2524931 defendant Pellond John yeoman 596035 596035 Pellond, John, of Fretynden, yeoman 0
5588510 2531412 2531412 defendant Badcok John fuller 596035 596035 Badcok, John, of Fretynden, fuller 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);