names

26 rows where place_id = 599271

✎ 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
3636052 1906068 1906068 defendant Natteres William yeoman 599271 599271 Natteres, William, of Fulborne, yeoman 0
3639715 1907229 1907229 defendant Smert Beatrice widow 599271 599271 Smert, Beatrice, of Fulborne, widow 1
3718503 1932065 1932065 plaintiff Frohoke William   599271 599271 Frohoke, William, of Fulborne 0
3722582 1933324 1933324 defendant Forman Richard husbandman 599271 599271 Forman, Richard, of Fulborne, husbandman 0
3758266 1944580 1944580 defendant Ball Richard pulter 599271 599271 Ball, Richard, of Fulborne, pulter 1
3803178 1958896 1958896 defendant Skarkyll John gent 599271 599271 (Skarkyll, John, of Fulborne, gent 1
3910969 1993994 1993994 defendant Rande Robert mercer 599271 599271 Rande, Robert, of Fulborne, mercer 0
3922274 1997761 1997761 defendant Dryver William husbandman 599271 599271 Dryver, William, of Fulborne, husbandman 1
3922275 1997761 1997761 defendant Crag William husbandman 599271 599271 Crag, William, of Fulborne, husbandman 2
3922307 1997774 1997774 defendant Kyrke William husbandman 599271 599271 Kyrke, William, of Fulborne, husbandman 0
3954155 2008528 2008528 plaintiff Kyllyngworthe Richard yeoman 599271 599271 Kyllyngworthe, Richard, of Fulborne, yeoman 0
3954157 2008529 2008529 plaintiff Kyllyngworthe Richard yeoman 599271 599271 Kyllyngworthe, Richard, of Fulborne, yeoman 0
3962946 2011638 2011638 plaintiff Wood Edward gent 599271 599271 Wood, Edward, of Fulborne, gent 0
4037648 2038117 2038117 plaintiff Killingworth Richard yeoman 599271 599271 Killingworth, Richard, of Fulborne, yeoman 0
4037653 2038118 2038118 plaintiff Killingworth Richard yeoman 599271 599271 Killingworth, Richard, of Fulborne, yeoman 0
4037666 2038122 2038122 plaintiff Killyngworthe Richard yeoman 599271 599271 Killyngworthe, Richard, of Fulborne, yeoman 0
4068317 2048969 2048969 defendant Burton George husbandman 599271 599271 Burton, George, of Fulborne, husbandman 1
4268100 2118947 2118947 defendant Hockley Thomas husbandman 599271 599271 Hockley, Thomas, of Fulborne, husbandman 1
4294528 2128129 2128129 defendant Fisher George husbandman 599271 599271 Fisher, George, of Fulborne, husbandman 1
4529910 2209644 2209644 defendant Godfrey John   599271 599271 Godfrey, John, of Fulborne 0
4529912 2209645 2209645 defendant Godfrey John   599271 599271 Godfrey, John, of Fulborne 0
4578412 2224734 2224734 defendant Irfot Sarah   599271 599271 Irfot, Sarah, of Fulborne 1
4800522 2296344 2296344 defendant Coke John, junior husbandman 599271 599271 Coke, John, junior, of Fulborne, husbandman 0
4843285 2309418 2309418 defendant Assheby Robert husbandman 599271 599271 Assheby, Robert, of Fulborne, husbandman 0
4934045 2337027 2337027 defendant Lee Robert miller 599271 599271 Lee, Robert, of Fulborne, miller 0
5604882 2536395 2536395 plaintiff Chambeyr John   599271 599271 Chambeyr, John, of Fulborne 1

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