names

28 rows where place_id = 589279

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597090 1866712 1866712 defendant Yon John yeoman 589279 589279 Yon, John, of South Colyngham, yeoman 0
3670462 1916719 1916719 defendant Howes William chaplain 589279 589279 Howes, William, of South Colyngham, chaplain 0
3675379 1918337 1918337 defendant Meryng Thomas gent 589279 589279 Meryng, Thomas, of South Colyngham, gent 0
3679986 1919805 1919805 defendant Meryng Thomas gent 589279 589279 Meryng, Thomas, of South Colyngham, gent 0
3683546 1920986 1920986 defendant Burkes William husbandman 589279 589279 Burkes, William, of South Colyngham, husbandman 1
3683547 1920986 1920986 defendant Roger Thomas husbandman 589279 589279 Roger, Thomas, of South Colyngham, husbandman 2
3688684 1922623 1922623 defendant Gylby Robert butcher 589279 589279 Gylby, Robert, of South Colyngham, butcher 0
3722360 1933253 1933253 defendant Howle John pewterer 589279 589279 Howle, John, of South Colyngham, pewterer 0
3813564 1962160 1962160 defendant Sheref John husbandman 589279 589279 Sheref, John, of South Colyngham, husbandman 0
3841406 1970893 1970893 defendant Verdone William husbandman 589279 589279 Verdone, William, of South Colyngham, husbandman 3
3841413 1970894 1970894 defendant Vardone William husbandman 589279 589279 Vardone, William, of South Colyngham, husbandman 3
3939395 2003479 2003479 defendant Deynse Christopher yeoman 589279 589279 Deynse, Christopher, of South Colyngham, yeoman 1
5157980 2403458 2403458 defendant Davy William tailor 589279 589279 Davy, William, of South Colyngham, tailor 3
5173712 2408007 2408007 defendant Davy William tailor 589279 589279 Davy, William, of South Colyngham, tailor 3
5193810 2413911 2413911 defendant Davy William tailor 589279 589279 Davy, William, of South Colyngham, tailor 3
5193816 2413912 2413912 defendant Davy William tailor 589279 589279 Davy, William, of South Colyngham, tailor 3
5382031 2469918 2469918 defendant Curtes Thomas clerk 589279 589279 Curtes, Thomas, of South Colyngham, clerk 0
5426280 2482814 2482814 defendant Davy William husbandman 589279 589279 Davy, William, of South Colyngham, husbandman 0
5435770 2485638 2485638 defendant Swumpe Robert   589279 589279 Swumpe, Robert, of South Colyngham, Notts, questor 3
5441298 2487311 2487311 defendant Davy William husbandman 589279 589279 Davy, William, of South Colyngham, husbandman 0
5450203 2489946 2489946 defendant Yon John gent 589279 589279 Yon, John, of South Colyngham, gent 0
5457166 2492039 2492039 defendant Davy William husbandman 589279 589279 Davy, William, of South Colyngham, husbandman 0
5462365 2493646 2493646 defendant Yon John gent 589279 589279 Yon, John, of South Colyngham, gent 0
5469026 2495661 2495661 defendant Davy William husbandman 589279 589279 Davy, William, of South Colyngham, husbandman 0
5499774 2504878 2504878 defendant Yon John yeoman 589279 589279 Yon, John, of South Colyngham, yeoman 0
5514289 2509320 2509320 defendant Yon John yeoman 589279 589279 Yon, John, of South Colyngham, yeoman 0
5566525 2524801 2524801 defendant Roger Thomas husbandman 589279 589279 Roger, Thomas, of South Colyngham, husbandman 2
5581536 2529300 2529300 defendant Langley Adam yeoman 589279 589279 Langley, Adam, of South Colyngham, 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);