names

21 rows where place_id = 610056

✎ 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
3681745 1920388 1920388 defendant Wodeward Robert husbandman 610056 610056 Wodeward, Robert, of Blakenham on the Hill, husbandman 1
3705656 1928051 1928051 defendant Bacon Nicholas husbandman 610056 610056 Bacon, Nicholas, of Blakenham on the Hill, husbandman 2
3749204 1941678 1941678 defendant Yngelby Ralph husbandman 610056 610056 Yngelby, Ralph, of Blakenham on the Hill, husbandman 0
3758797 1944740 1944740 defendant More John miller 610056 610056 More, John, of Blakenham on the Hill, miller 2
3789592 1954572 1954572 defendant Ingilby Ralph yeoman 610056 610056 Ingilby, Ralph, of Blakenham on the Hill, yeoman 0
3885665 1985463 1985463 plaintiff Bakon John yeoman 610056 610056 Bakon, John, of Blakenham on the Hill, yeoman 1
3917050 1996060 1996060 defendant Ingylby Ralph husbandman 610056 610056 Ingylby, Ralph, of Blakenham on the Hill, husbandman 0
3917051 1996060 1996060 defendant Ingylby Margaret widow 610056 610056 Ingylby, Margaret, of Blakenham on the Hill, widow 1
4233936 2107397 2107397 defendant Wentworth Henry esq 610056 610056 Wentworth, Henry, of Blakenham on the Hill, esq 10
4238931 2109236 2109236 defendant Marshe Nicholas husbandman 610056 610056 Marshe, Nicholas, of Blakenham on the Hill, or of Bramford, husbandman 0
4386718 2160233 2160233 defendant Bacon Edward yeoman 610056 610056 Bacon, Edward, of Blakenham on the Hill, or of Brickelsey, Essex, yeoman 2
4695094 2263959 2263959 defendant Crembill Angustine husbandman 610056 610056 Crembill, Angustine, of Blakenham on the Hill, husbandman 1
4729329 2274390 2274390 defendant Bakon John yeoman 610056 610056 Bakon, John, of Blakenham on the Hill, yeoman 1
4734924 2276082 2276082 defendant Brigges Thomas husbandman 610056 610056 Brigges, Thomas, of Blakenham on the Hill, husbandman 0
4741257 2277940 2277940 defendant Draper Bartholomew yeoman 610056 610056 Draper, Bartholomew, of Blakenham on the Hill, yeoman 1
4795363 2294705 2294705 defendant Draper Bartholomew husbandman 610056 610056 Draper, Bartholomew, of Blakenham on the Hill, husbandman 0
4795364 2294705 2294705 defendant Illey Thomas laborer 610056 610056 Illey, Thomas, of Blakenham on the Hill, laborer 1
4819152 2302068 2302068 defendant Braunche Robert   610056 610056 Braunche, Robert, of Blakenham on the hill, parson 0
5077104 2379652 2379652 defendant Hill Geoffrey husbandman 610056 610056 Hill, Geoffrey, of Blakenham on the Hill, husbandman 2
5086691 2382499 2382499 defendant Bacon John, junior yeoman 610056 610056 Bacon, John, junior, of Blakenham on the Hill, yeoman 0
5116073 2391130 2391130 defendant Pylbarowe William yeoman 610056 610056 Pylbarowe, William, of Blakenham on the Hill, yeoman 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);