names

31 rows where place_id = 624744

✎ 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
3602599 1868473 1868473 defendant Yong John husbandman 624744 624744 Yong, John, of Blakenham in Water, husbandman 1
3672064 1917265 1917265 defendant Dowe William laborer 624744 624744 Dowe, William, of Blakenham on Water, laborer 1
3752469 1942695 1942695 defendant Rowte Richard tailor 624744 624744 Rowte, Richard, of Blakenham super Agnam, tailor 2
3760071 1945148 1945148 defendant Ingylby Ralph husbandman 624744 624744 Ingylby, Ralph, of Blakenham, husbandman 0
3772563 1949109 1949109 defendant Dewe or Dowe William miller 624744 624744 Dewe or Dowe, William, of Blakenham, miller 0
4014327 2029849 2029849 defendant Sorrell Richard husbandman 624744 624744 Sorrell, Richard, of Blakenham, husbandman 3
4223381 2103669 2103669 defendant Wentworth Henry esq 624744 624744 Wentworth, Henry, of Blakenham, esq 0
4275359 2121317 2121317 defendant Roes or Rosse Robert husbandman 624744 624744 Roes or Rosse, Robert, of Blakenham, or of Stowe Upland in Stowemarkett, husbandman 0
4301655 2130697 2130697 defendant Rose Robert yeoman 624744 624744 Rose, Robert, of Blakenham, or of Stowe Uplonde, yeoman 1
4460645 2188388 2188388 defendant Scaldere John   624744 624744 Scaldere, John, of Blakenham 0
4520577 2206785 2206785 defendant Hayl William   624744 624744 Hayl, William, of Blakenham 1
4524760 2208083 2208083 plaintiff Hovell John   624744 624744 Hovell, John, of Blakenham 0
4524762 2208083 2208083 defendant Hayl William   624744 624744 Hayl, William, of Blakenham 1
4741554 2278025 2278025 defendant Jorge Thomas ploughman 624744 624744 Jorge, Thomas, of Blakenham, on the water, ploughman 1
4741555 2278025 2278025 defendant Cole Seamus, junior ploughman 624744 624744 Cole, Seamus, junior, of Blakenham, ploughman 2
4794268 2294347 2294347 defendant Boteler Thomas yeoman 624744 624744 Boteler, Thomas, of Blakenham on Water, yeoman 0
4830883 2305682 2305682 defendant Cole Seamus   624744 624744 Cole, Seamus, of Blakenham 1
4908426 2329191 2329191 defendant Colchestre Thomas yeoman 624744 624744 Colchestre, Thomas, of Blakenham, on the water, yeoman 3
4937626 2338142 2338142 defendant Cole Seman fuller 624744 624744 Cole, Seman, of Blakenham, fuller 3
4966738 2346985 2346985 defendant Ivot William laborer 624744 624744 Ivot, William, of Blakenham on Water, laborer 3
5077108 2379653 2379653 defendant Hill Geoffrey husbandman 624744 624744 Hill, Geoffrey, of Blakenham super Montem, husbandman 2
5145132 2399718 2399718 defendant Hill Geoffrey husbandman 624744 624744 Hill, Geoffrey, of Blakenham, husbandman 1
5246010 2428997 2428997 defendant Hylle Geoffrey yeoman 624744 624744 Hylle, Geoffrey, of Blakenham, yeoman 1
5278800 2438907 2438907 defendant Hill Geoffrey yeoman 624744 624744 Hill, Geoffrey, of Blakenham on Water, yeoman 0
5313264 2449004 2449004 defendant Hill Geoffrey yeoman 624744 624744 Hill, Geoffrey, of Blakenham on Water, yeoman 0
5324457 2452400 2452400 defendant Hill Geoffrey yeoman 624744 624744 Hill, Geoffrey, of Blakenham on Water, yeoman 1
5494398 2503227 2503227 defendant Hille William   624744 624744 Hille, William, of Blakenham on Water, husbandman, son of Hille, Geoffrey 0
5494400 2503228 2503228 defendant Hylle William   624744 624744 Hylle, William, of Blakenham on Water, husbandman, son of Hille, Geoffrey 0
5494665 2503292 2503292 defendant Hyll William husbandman 624744 624744 Hyll, William, of Blakenham on Water, husbandman 0
5565922 2524635 2524635 defendant Bacon John   624744 624744 Bacon, John, of Blakenham, yeoman, son of Bacon, John, senior 0
5565924 2524636 2524636 defendant Bacon Nicholas husbandman 624744 624744 Bacon, Nicholas, of Blakenham on Water, husbandman 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);