names

17 rows where place_id = 601685

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646506 1909306 1909306 defendant Olderyng Thomas husbandman 601685 601685 Olderyng, Thomas, of Carleton Colvyle, Suff, husbandman 0
3711487 1929900 1929900 defendant Downyng John mercer 601685 601685 Downyng, John, of Carleton Colvyle, Suff, mercer 0
3752549 1942724 1942724 defendant Wylde Nicholas husbandman 601685 601685 Wylde, Nicholas, of Carleton Colvyle, Suff, husbandman 1
3803381 1958959 1958959 defendant Wylde Nicholas husbandman 601685 601685 Wylde, Nicholas, of Carleton Colvyle, Suff, husbandman 1
3827312 1966408 1966408 defendant Burnam John clerk 601685 601685 Burnam, John, of Carleton Colvyle, Suff, clerk 1
3866041 1978874 1978874 defendant Burneham John chaplain 601685 601685 Burneham, John, of Carleton Colvyle, Suff, chaplain 0
3941687 2004233 2004233 defendant Andrewes Robert gent 601685 601685 Andrewes, Robert, of Carleton Colvyle, Suff, gent 0
3941689 2004234 2004234 defendant Fyske John husbandman 601685 601685 Fyske, John, of Carleton Colvyle, Suff, husbandman 0
3982656 2018565 2018565 defendant Plowman or Ploughman John yeoman 601685 601685 Plowman or Ploughman, John, of Carleton Colvyle, Suff, yeoman 1
4731324 2274997 2274997 defendant Geddyng Thomas yeoman 601685 601685 Geddyng, Thomas, of Carleton Colvyle, Suff, yeoman 2
4827611 2304686 2304686 defendant Eyre John   601685 601685 Eyre, John, of Carleton Colvyle, Suff, parson 2
4854116 2312698 2312698 defendant Eyre John   601685 601685 Eyre, John, of Carleton Colvyle, Suff, parson 1
5040225 2368676 2368676 defendant Skyn Robert yeoman 601685 601685 Skyn, Robert, of Carleton Colvyle, Suff, yeoman 0
5431244 2484289 2484289 defendant Craske Henry yeoman 601685 601685 Craske, Henry, of Carleton Colvyle, Suff, yeoman 0
5458837 2492536 2492536 defendant Craske William clerk & rector 601685 601685 Craske, William, of Carleton Colvyle, Suff, clerk & rector 0
5470435 2496078 2496078 defendant Craske William clerk 601685 601685 Craske, William, of Carleton Colvyle, Suff, clerk 0
5470884 2496220 2496220 defendant Craske William clerk 601685 601685 Craske, William, of Carleton Colvyle, Suff, clerk 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);