names

51 rows where place_id = 586417

✎ 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
3588677 1864102 1864102 defendant Couper John draper 586417 586417 Couper, John, of Stuston, draper 0
3588679 1864103 1864103 defendant Couper John draper 586417 586417 Couper, John, of Stuston, draper 0
3628272 1903704 1903704 defendant Mynsterchambre John gent 586417 586417 Mynsterchambre, John, of Stuston, gent 0
3633336 1905242 1905242 defendant Waren John husbandman 586417 586417 Waren, John, of Stuston, husbandman 0
3634824 1905691 1905691 defendant Clerk John   586417 586417 Clerk, John, of Stuston, wheelwright 0
3642214 1908012 1908012 defendant Mynsterchambre John gent 586417 586417 Mynsterchambre, John, of Stuston, gent 0
3715707 1931203 1931203 defendant Melton Robert (legal representative) 586417 586417 Melton, Robert, of Stuston, gent, executrix of 0
3715708 1931203 1931203 defendant Melton Cecilia widow 586417 586417 Melton, Cecilia, of Stuston, widow 1
3715712 1931204 1931204 defendant Melton Robert (legal representative) 586417 586417 Melton, Robert, of Stuston, gent, executrix of 0
3715713 1931204 1931204 defendant Melton Cecilia widow 586417 586417 Melton, Cecilia, of Stuston, widow 1
3733805 1936826 1936826 defendant Mynsterchamber John gent 586417 586417 Mynsterchamber, John, of Stuston, gent 1
3794684 1956214 1956214 plaintiff Clerk John   586417 586417 Clerk, John, of Stuston 0
3838387 1969927 1969927 defendant Mynsterchamber John gent 586417 586417 Mynsterchamber, John, of Stuston, gent 0
3861726 1977386 1977386 defendant Mysterchamber John gent 586417 586417 Mysterchamber, John, of Stuston, gent 0
3867250 1979283 1979283 defendant Warren Robert cooper 586417 586417 Warren, Robert, of Stuston, cooper 0
3867252 1979283 1979283 defendant Harrold Thomas husbandman 586417 586417 Harrold, Thomas, of Stuston, husbandman 2
3870320 1980324 1980324 defendant Mynsterchambre John gent 586417 586417 Mynsterchambre, John, of Stuston, gent 2
3891381 1987382 1987382 defendant Waren Robert cooper 586417 586417 Waren, Robert, of Stuston, cooper 0
3895405 1988674 1988674 defendant Mynsterchamber Humphrey gent 586417 586417 Mynsterchamber, Humphrey, of Stuston, gent 0
3897294 1989314 1989314 defendant Harold Thomas yeoman 586417 586417 Harold, Thomas, of Stuston, yeoman 0
3911105 1994042 1994042 defendant Mynstrechamber Humphrey gent 586417 586417 Mynstrechamber, Humphrey, of Stuston, gent 0
3939864 2003633 2003633 defendant Mynsterchamber Humphrey gent 586417 586417 Mynsterchamber, Humphrey, of Stuston, gent 0
4059948 2045953 2045953 defendant Browne John yeoman 586417 586417 Browne, John, of Stuston, yeoman 1
4135810 2073136 2073136 defendant Chappell Robert husbandman 586417 586417 Chappell, Robert, of Stuston, husbandman 0
4163544 2082772 2082772 defendant Gislingham Nicholas gent 586417 586417 Gislingham, Nicholas, of Stuston, gent 0
4262362 2117081 2117081 defendant Castleton Richard husbandman 586417 586417 Castleton, Richard, of Stuston, husbandman 2
4276357 2121675 2121675 defendant Chapman Edmund husbandman 586417 586417 Chapman, Edmund, of Stuston, husbandman 1
4340453 2143926 2143926 defendant Smythe Hugh clerk 586417 586417 Smythe, Hugh, of Stuston, clerk 0
4390355 2161397 2161397 defendant Smythe Hugh clerk 586417 586417 Smythe, Hugh, of Stuston, clerk 0
4396683 2163456 2163456 defendant Corbolde Thomas gent 586417 586417 Corbolde, Thomas, of Stuston, gent 0
4652447 2246714 2246714 defendant Clerk Robert husbandman 586417 586417 Clerk, Robert, of Stuston, husbandman 0
5057141 2373717 2373717 defendant Cade James clerk 586417 586417 Cade, James, of Stuston, clerk 4
5105924 2388172 2388172 defendant Martyn John butcher 586417 586417 Martyn, John, of Stuston, butcher 0
5137948 2397610 2397610 defendant Cade Roger husbandman 586417 586417 Cade, Roger, of Stuston, husbandman 3
5161684 2404521 2404521 defendant Couper Walter laborer 586417 586417 Couper, Walter, of Stuston, laborer 2
5175993 2408663 2408663 defendant Couper Walter laborer 586417 586417 Couper, Walter, of Stuston, laborer 2
5197753 2415086 2415086 defendant Couper Walter laborer 586417 586417 Couper, Walter, of Stuston, laborer 2
5228393 2423909 2423909 defendant Harald John   586417 586417 Harald, John, of Stuston, servant, son of Harald, Henry 0
5234393 2425648 2425648 defendant Martyn John yeoman 586417 586417 Martyn, John, of Stuston, yeoman 2
5352012 2460732 2460732 plaintiff Edon Richard   586417 586417 Edon, Richard, of Stuston 0
5354546 2461496 2461496 defendant Chevyrcourte William husbandman 586417 586417 Chevyrcourte, William, of Stuston, husbandman 0
5369137 2465948 2465948 plaintiff Edon Richard   586417 586417 Edon, Richard, of Stuston 0
5369142 2465949 2465949 plaintiff Edon Richard   586417 586417 Edon, Richard, of Stuston 0
5371341 2466614 2466614 defendant Harold John husbandman 586417 586417 Harold, John, of Stuston, husbandman 1
5461208 2493300 2493300 defendant Couper John draper 586417 586417 Couper, John, of Stuston, draper 0
5471334 2496364 2496364 defendant Chenyrcourt William husbandman 586417 586417 Chenyrcourt, William, of Stuston, husbandman 1
5472506 2496741 2496741 defendant Couper John draper 586417 586417 Couper, John, of Stuston, draper 0
5497812 2504288 2504288 defendant Couper John draper 586417 586417 Couper, John, of Stuston, draper 0
5497943 2504331 2504331 defendant Caldewell Roger laborer 586417 586417 Caldewell, Roger, of Stuston, laborer 0
5529139 2513628 2513628 defendant Clerk Robert husbandman 586417 586417 Clerk, Robert, of Stuston, husbandman 0
5579639 2528716 2528716 defendant Mynsterchamber John gent 586417 586417 Mynsterchamber, John, of Stuston, gent 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);