names

31 rows where place_id = 592568

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608111 1870189 1870189 defendant Presgrave John gent 592568 592568 Presgrave, John, of Rokyngham, Nhants, gent 0
3608115 1870190 1870190 defendant Wynter Guy fishmonger 592568 592568 Wynter, Guy, of Rokyngham, Nhants, fishmonger 0
3608711 1870387 1870387 defendant Wynter Guy fishmonger 592568 592568 Wynter, Guy, of Rokyngham, Nhants, fishmonger 0
3647327 1909551 1909551 defendant Marre Richard husbandman 592568 592568 Marre, Richard, of Rokyngham, Nhants, husbandman 0
3660554 1913561 1913561 defendant May Elizabeth widow 592568 592568 May, Elizabeth, of Rokyngham, Nhants, widow 4
3836639 1969363 1969363 defendant Foxon William chapman 592568 592568 Foxon, William, of Rokyngham, Nhants, chapman 3
3858406 1976290 1976290 defendant Stafford William   592568 592568 Stafford, William, of Rokyngham, Nhants, gent, son of Stafford, Humphrey 0
3858412 1976291 1976291 defendant Stafford William gent 592568 592568 Stafford, William, of Rokyngham, Nhants, gent 0
3867100 1979235 1979235 defendant Myllys Thomas chapman 592568 592568 Myllys, Thomas, of Rokyngham, Nhants, chapman 1
3867103 1979236 1979236 defendant Myllys Thomas chapman 592568 592568 Myllys, Thomas, of Rokyngham, Nhants, chapman 1
3947350 2006145 2006145 plaintiff Clyffe Roland yeoman 592568 592568 Clyffe, Roland, of Rokyngham, Nhants, yeoman 0
4038933 2038545 2038545 defendant Danford Thomas baker 592568 592568 Danford, Thomas, of Rokyngham, Nhants, baker 2
4668640 2255904 2255904 defendant Branspath Ralph gent 592568 592568 Branspath, Ralph, of Rokyngham, Nhants, gent 0
4778633 2289300 2289300 defendant Braunspath Ralph esq 592568 592568 Braunspath, Ralph, of Rokyngham, Nhants, esq 0
4827049 2304501 2304501 defendant Brauncepath Ralph gent 592568 592568 Brauncepath, Ralph, of Rokyngham, Nhants, gent 1
4845368 2310061 2310061 defendant Undererth Walter yeoman 592568 592568 Undererth, Walter, of Rokyngham, Nhants, yeoman 10
4848393 2310969 2310969 defendant Palmer Thomas gent 592568 592568 Palmer, Thomas, of Rokyngham, Nhants, gent 0
4848398 2310971 2310971 defendant Palmer Thomas gent 592568 592568 Palmer, Thomas, of Rokyngham, Nhants, gent 0
4918712 2332369 2332369 defendant duraunt John gent 592568 592568 duraunt, John, of Rokyngham, Nhants, gent 2
5134870 2396701 2396701 defendant Walker Richard husbandman 592568 592568 Walker, Richard, of Rokyngham, Nhants, husbandman 1
5175967 2408653 2408653 defendant Bridport Thomas crover 592568 592568 Bridport, Thomas, of Rokyngham, Nhants, crover 0
5196217 2414644 2414644 defendant Bridport Thomas drover 592568 592568 Bridport, Thomas, of Rokyngham, Nhants, drover 0
5196219 2414645 2414645 defendant Bridport Thomas drover 592568 592568 Bridport, Thomas, of Rokyngham, Nhants, drover 0
5205818 2417438 2417438 defendant Zouche Richard   592568 592568 Zouche, Richard, of Rokyngham, Nhants, hermit 4
5205825 2417439 2417439 defendant Zouche Richard   592568 592568 Zouche, Richard, of Rokyngham, Nhants, hermit 5
5233422 2425367 2425367 plaintiff Chapman Robert courser 592568 592568 Chapman, Robert, of Rokyngham, Nhants, courser 0
5332108 2454680 2454680 defendant Byrteport Thomas (legal representative) 592568 592568 Byrteport, Thomas, of Rokyngham, Nhants, yeoman, executrix of 0
5350466 2460266 2460266 defendant Byllyng William yeoman 592568 592568 Byllyng, William, of Rokyngham, Nhants, yeoman 0
5497723 2504262 2504262 defendant Presgrave John husbandman 592568 592568 Presgrave, John, of Rokyngham, Nhants, husbandman 0
5540180 2517055 2517055 defendant Loge Nicholas yeoman 592568 592568 Loge, Nicholas, of Rokyngham, Nhants, yeoman 0
5540183 2517056 2517056 defendant Loge Nicholas yeoman 592568 592568 Loge, Nicholas, of Rokyngham, Nhants, 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);