names

38 rows where place_id = 587900

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592762 1865348 1865348 defendant Rokke John laborer 587900 587900 Rokke, John, of Sundrysshe, laborer 0
3637228 1906444 1906444 defendant Wodeward John, senior husbandman 587900 587900 Wodeward, John, senior, of Sundrysshe, husbandman 0
3655311 1911919 1911919 defendant Colman John yeoman 587900 587900 Colman, John, of Sundrysshe, yeoman 3
3708171 1928855 1928855 defendant Smyth John tailor 587900 587900 Smyth, John, of Sundrysshe, tailor 0
3727185 1934774 1934774 defendant Holwey Thomas carpenter 587900 587900 Holwey, Thomas, of Sundrysshe, carpenter 0
3751183 1942297 1942297 defendant Wellys Thomas husbandman 587900 587900 Wellys, Thomas, of Sundrysshe, husbandman 0
3757843 1944431 1944431 defendant Smyth John brewer 587900 587900 Smyth, John, of Sundrysshe, brewer 0
3758081 1944512 1944512 defendant Overey William tanner 587900 587900 Overey, William, of Sundrysshe, tanner 0
3789013 1954375 1954375 defendant Wellys John husbandman 587900 587900 Wellys, John, of Sundrysshe, husbandman 1
3812038 1961675 1961675 plaintiff Coltherst William gent 587900 587900 Coltherst, William, of Sundrysshe, gent 0
3895241 1988616 1988616 defendant Lamport William husbandman 587900 587900 Lamport, William, of Sundrysshe, husbandman 0
4025343 2033726 2033726 plaintiff Britridge William yeoman 587900 587900 Britridge, William, of Sundrysshe, yeoman 0
4025344 2033726 2033726 defendant Tye Walter yeoman 587900 587900 Tye, Walter, of Sundrysshe, yeoman 0
4604812 2232673 2232673 defendant Barker Robert   587900 587900 Barker, Robert, of Sundrysshe 1
4733262 2275582 2275582 defendant Jele Roger gent 587900 587900 (Jele, Roger, of Sundrysshe, gent 1
4787835 2292260 2292260 defendant Clerk Simon butcher 587900 587900 Clerk, Simon, of Sundrysshe, butcher 0
5087691 2382787 2382787 defendant Chellescombe Thomas husbandman 587900 587900 Chellescombe, Thomas, of Sundrysshe, husbandman 0
5087692 2382787 2382787 defendant Rolf Henry laborer 587900 587900 together with Rolf, Henry, of Sundrysshe, laborer 1
5087697 2382789 2382789 defendant Rolf Henry laborer 587900 587900 Rolf, Henry, of Sundrysshe, laborer 0
5087699 2382789 2382789 defendant Chellescombe Thomas husbandman 587900 587900 together with Chellescombe, Thomas, of Sundrysshe, husbandman 2
5220590 2421716 2421716 defendant Cacote Stephen husbandman 587900 587900 Cacote, Stephen, of Sundrysshe, husbandman 0
5220591 2421716 2421716 defendant Daunce Lawrence husbandman 587900 587900 Daunce, Lawrence, of Sundrysshe, husbandman 1
5220593 2421716 2421716 defendant May John, senior husbandman 587900 587900 May, John, senior, of Sundrysshe, husbandman 3
5220596 2421717 2421717 defendant Maye Richard husbandman 587900 587900 Maye, Richard, of Sundrysshe, husbandman 0
5220597 2421717 2421717 defendant Maye John, senior husbandman 587900 587900 Maye, John, senior, of Sundrysshe, husbandman 1
5220598 2421717 2421717 defendant Maye John, junior husbandman 587900 587900 Maye, John, junior, of Sundrysshe, husbandman 2
5220599 2421717 2421717 defendant Cotman Thomas tiler 587900 587900 Cotman, Thomas, of Sundrysshe, tiler 3
5220600 2421717 2421717 defendant atte Rye William laborer 587900 587900 atte Rye, William, of Sundrysshe, laborer 4
5220601 2421717 2421717 defendant Cryell John laborer 587900 587900 Cryell, John, of Sundrysshe, laborer 5
5220602 2421717 2421717 defendant Style John, junior husbandman 587900 587900 Style, John, junior, of Sundrysshe, husbandman 6
5220603 2421717 2421717 defendant Taillour Thomas laborer 587900 587900 Taillour, Thomas, of Sundrysshe, laborer 7
5220604 2421717 2421717 defendant Polbroke John laborer 587900 587900 Polbroke, John, of Sundrysshe, laborer 8
5259822 2433193 2433193 defendant Cacote Stephen husbandman 587900 587900 Cacote, Stephen, of Sundrysshe, husbandman 3
5281965 2439799 2439799 defendant Gascoigne Nicholas esq 587900 587900 Gascoigne, Nicholas, of Sundrysshe, esq 0
5281975 2439800 2439800 defendant Gascoigne Nicholas esq 587900 587900 Gascoigne, Nicholas, of Sundrysshe, esq 0
5391341 2472603 2472603 defendant Graunge William yeoman 587900 587900 Graunge, William, of Sundrysshe, yeoman 1
5391343 2472603 2472603 defendant Lytell Nicholas yeoman 587900 587900 Lytell, Nicholas, of Sundrysshe, yeoman 3
5463926 2494129 2494129 defendant Stabyll William husbandman 587900 587900 Stabyll, William, of Sundrysshe, 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);