names

41 rows where place_id = 586741

✎ 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
3589504 1864354 1864354 plaintiff Burton Edward   586741 586741 Burton, Edward, of Hyde 0
3619741 1873747 1873747 plaintiff Jerard John   586741 586741 Jerard, John, of Hyde 0
3622658 1874617 1874617 defendant Haweke John yeoman 586741 586741 Haweke, John, of Hyde juxta Westminster, yeoman 0
3827834 1966570 1966570 defendant Brygge Nicholas yeoman 586741 586741 Brygge, Nicholas, of Hyde, yeoman 3
3916573 1995919 1995919 defendant Lane John esq 586741 586741 Lane, John, of Hyde, esq 0
3926332 1999130 1999130 defendant Lane John esq 586741 586741 Lane, John, of Hyde, esq 0
3928203 1999769 1999769 plaintiff Beckome John   586741 586741 Beckome, John, of Hyde 0
3934967 2001997 2001997 defendant Polle John husbandman 586741 586741 Polle, John, of Hyde, husbandman 1
3976982 2016516 2016516 plaintiff Lane John esq 586741 586741 Lane, John, of Hyde, esq 0
4005918 2026889 2026889 plaintiff Lane Thomas gent or esq 586741 586741 Lane, Thomas, of Hyde, gent or esq 0
4038263 2038321 2038321 plaintiff Lane John gent 586741 586741 Lane, John, of Hyde, gent 0
4038267 2038322 2038322 plaintiff Lane John gent 586741 586741 Lane, John, of Hyde, gent 0
4038285 2038329 2038329 plaintiff Lane Thomas esq 586741 586741 Lane, Thomas, of Hyde, esq 0
4038287 2038330 2038330 plaintiff Lane Thomas esq 586741 586741 Lane, Thomas, of Hyde, esq 0
4326239 2139141 2139141 defendant Eyton William yeoman 586741 586741 Eyton, William, of Hyde, yeoman 3
4327479 2139512 2139512 defendant Lope Thomas yeoman 586741 586741 Lope, Thomas, of Hyde, yeoman 1
4352646 2148158 2148158 defendant Knight Peter yeoman 586741 586741 Knight, Peter, of Hyde, yeoman 0
4352649 2148158 2148158 defendant Knyght Elizabeth widow 586741 586741 Knyght, Elizabeth, of Hyde, widow 3
4743143 2278518 2278518 defendant Pypperwell William husbandman 586741 586741 Pypperwell, William, of Hyde by Winchester, husbandman 0
4789654 2292832 2292832 defendant Lene or Leve Richard gent 586741 586741 Lene or Leve, Richard, of Hyde, gent 0
4812579 2300050 2300050 defendant Strode Nicholas   586741 586741 Strode, Nicholas, of Hyde, near Winchester, abbot 0
4812580 2300050 2300050 defendant Boteler Thomas yeoman 586741 586741 Boteler, Thomas, of Hyde, yeoman 1
4823706 2303504 2303504 plaintiff Strode Nicholas   586741 586741 Strode, Nicholas, of Hyde near Winchester, abbot 0
4823709 2303505 2303505 plaintiff Strode Nicholas   586741 586741 Strode, Nicholas, of Hyde near Winchester, abbot of the church of St Peter 0
4823712 2303506 2303506 plaintiff Strode Nicholas   586741 586741 Strode, Nicholas, of Hyde, by Winchester, abbot of the church of St Peter 0
4823716 2303507 2303507 plaintiff Strode Nicholas   586741 586741 Strode, Nicholas, of Hyde, near Winchester, abbot of the church of St Peter 0
4823718 2303508 2303508 plaintiff Strode Nicholas   586741 586741 Strode, Nicholas, of Hyde, near Winchester, abbot of the church of St Peter 0
5008848 2359479 2359479 defendant Neweman William farmer 586741 586741 Neweman, William, of Hyde, farmer 1
5114951 2390788 2390788 defendant Bedford Robert husbandman 586741 586741 Bedford, Robert, of Hyde, husbandman 0
5126608 2394257 2394257 plaintiff Bramley Thomas   586741 586741 Bramley, Thomas, of Hyde near Winchester, abbot of the House & church of St Peter 0
5153275 2402109 2402109 plaintiff Hyde Thomas   586741 586741 Hyde, Thomas, of Hyde by Winchester, abbot of the house & church of St Peter 0
5200390 2415876 2415876 defendant Gradgrave James esq 586741 586741 Gradgrave, James, of Hyde, esq 0
5268396 2435882 2435882 defendant Rauyn John yeoman 586741 586741 (Rauyn, John, of Hyde by Winchester, yeoman 3
5325821 2452806 2452806 defendant Trevarrak Robert yeoman 586741 586741 Trevarrak, Robert, of Hyde juxta Winchester, yeoman 0
5325822 2452806 2452806 defendant Wylcok John carver 586741 586741 Wylcok, John, of Hyde juxta Winchester, carver 1
5408983 2477649 2477649 defendant Collingbourne John   586741 586741 Collingbourne, John, of Hyde, near Winchester, abbot of the monastery of St Peter 0
5506807 2507050 2507050 defendant Hawoke John husbandman 586741 586741 Hawoke, John, of Hyde, husbandman 0
5506810 2507051 2507051 defendant Hawoke John husbandman 586741 586741 Hawoke, John, of Hyde, husbandman 0
5509983 2507961 2507961 defendant Haweke John husbandman 586741 586741 Haweke, John, of Hyde, husbandman 0
5542158 2517678 2517678 defendant Haweke John husbandman 586741 586741 Haweke, John, of Hyde, husbandman 0
5546950 2519109 2519109 defendant Hawke John husbandman 586741 586741 Hawke, John, of Hyde, or of Paddyngton, Middx, 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);