names

36 rows where place_id = 600418

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640966 1907615 1907615 defendant Kempe Geoffrey merchant 600418 600418 Kempe, Geoffrey, of Woodbregge, merchant 0
3642259 1908028 1908028 plaintiff Cantell Robert   600418 600418 Cantell, Robert, of Woodbregge 0
3645622 1909029 1909029 plaintiff Hache Nicholas, junior   600418 600418 Hache, Nicholas, junior, of Woodbregge 0
3660030 1913400 1913400 defendant West Robert butcher 600418 600418 West, Robert, of Woodbregge, butcher 0
3668802 1916180 1916180 defendant Lonesse Thomas mercer 600418 600418 Lonesse, Thomas, of Woodbregge, mercer 0
3676376 1918656 1918656 defendant Re Robert weaver 600418 600418 Re, Robert, of Woodbregge, weaver 2
3707625 1928683 1928683 defendant Clodde Simon merchant 600418 600418 Clodde, Simon, of Woodbregge, merchant 0
3710725 1929675 1929675 plaintiff Smythe William merchant 600418 600418 Smythe, William, of Woodbregge, merchant 0
3719609 1932399 1932399 defendant Bele William beer brewer 600418 600418 Bele, William, of Woodbregge, beer brewer 0
3745803 1940592 1940592 plaintiff Camell Robert   600418 600418 Camell, Robert, of Woodbregge 0
3751825 1942489 1942489 defendant Woode Geoffrey brewer 600418 600418 Woode, Geoffrey, of Woodbregge, brewer 2
3751827 1942489 1942489 defendant Butter William butcher 600418 600418 Butter, William, of Woodbregge, butcher 4
3752309 1942647 1942647 defendant Woode Geoffrey beer brewer 600418 600418 Woode, Geoffrey, of Woodbregge, beer brewer 0
3752667 1942764 1942764 defendant Partrych William butcher 600418 600418 Partrych, William, of Woodbregge, butcher 1
3753492 1943029 1943029 defendant Symond Thomas merchant 600418 600418 Symond, Thomas, of Woodbregge, merchant 0
3756803 1944100 1944100 defendant Burtur William butcher 600418 600418 Burtur, William, of Woodbregge, butcher 0
3758548 1944670 1944670 defendant Partryche Thomas butcher 600418 600418 Partryche, Thomas, of Woodbregge, butcher 3
3758688 1944711 1944711 defendant Bukker Thomas saddler 600418 600418 Bukker, Thomas, of Woodbregge, saddler 1
3762119 1945794 1945794 plaintiff Fylley alias Ropur John   600418 600418 Fylley alias Ropur, John, of Woodbregge 0
3767255 1947398 1947398 defendant Smyth John draper 600418 600418 Smyth, John, of Woodbregge, draper 0
3785438 1953234 1953234 defendant Waren Robert beer brewer 600418 600418 Waren, Robert, of Woodbregge, beer brewer 0
3785439 1953234 1953234 defendant Waryn John barber 600418 600418 Waryn, John, of Woodbregge, barber 1
3785440 1953234 1953234 defendant Waryn Nicholas husbandman 600418 600418 Waryn, Nicholas, of Woodbregge, husbandman 2
3786002 1953416 1953416 defendant Waren Nicholas husbandman 600418 600418 Waren, Nicholas, of Woodbregge, husbandman 0
3786003 1953416 1953416 defendant Woode Geoffrey beer brewer 600418 600418 Woode, Geoffrey, of Woodbregge, beer brewer 1
3813252 1962056 1962056 defendant Page Robert yeoman 600418 600418 Page, Robert, of Woodbregge, yeoman 0
3814383 1962413 1962413 defendant Smyth William tailor 600418 600418 Smyth, William, of Woodbregge, tailor 0
3851867 1974176 1974176 defendant Hollond Edmund beer brewer 600418 600418 Hollond, Edmund, of Woodbregge, beer brewer 1
5541814 2517552 2517552 plaintiff Latherhed Richard   600418 600418 Latherhed, Richard, of Woodbregge 0
5558165 2522339 2522339 defendant Botell Thomas glover 600418 600418 Botell, Thomas, of Woodbregge, glover 0
5558167 2522340 2522340 defendant Smyth William tailor 600418 600418 Smyth, William, of Woodbregge, tailor 0
5558169 2522341 2522341 defendant Smyth William tailor 600418 600418 Smyth, William, of Woodbregge, tailor 0
5558171 2522341 2522341 defendant Botell Thomas glover 600418 600418 Botell, Thomas, of Woodbregge, glover 2
5573192 2526710 2526710 defendant Beele John merchant 600418 600418 Beele, John, of Woodbregge, merchant 0
5576943 2527832 2527832 defendant Woode William, junior mariner 600418 600418 Woode, William, junior, of Woodbregge, mariner 0
5578760 2528420 2528420 defendant Clement Richard yeoman 600418 600418 Clement, Richard, of Woodbregge, 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);