names

32 rows where place_id = 634076

✎ 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
3816670 1963116 1963116 defendant Pope alias Arbyn Thomas innholder 634076 634076 Pope alias Arbyn, Thomas, of Wymborne Mynster, Dorset, innholder 2
3882280 1984332 1984332 defendant Clyfford John yeoman 634076 634076 Clyfford, John, of Wymborne Mynster, Dorset, yeoman 0
3957777 2009778 2009778 defendant Dewey Agnes (legal representative) 634076 634076 Dewey, Agnes, of Wymborne Mynster, Dorset, widow, executor of 0
3993206 2022315 2022315 plaintiff Carter John mercer 634076 634076 Carter, John, of Wymborne Mynster, Dorset, mercer 0
4002656 2025720 2025720 defendant Carter John chapman 634076 634076 Carter, John, of Wymborne Mynster, Dorset, chapman 0
4021415 2032385 2032385 defendant Welstede William draper 634076 634076 Welstede, William, of Wymborne Mynster, Dorset, draper 0
4039089 2038606 2038606 defendant Hyett Clement gent 634076 634076 Hyett, Clement, of Wymborne Mynster, Dorset, gent 0
4050594 2042641 2042641 defendant Jenyng John yeoman 634076 634076 Jenyng, John, of Wymborne Mynster, Dorset, yeoman 0
4050597 2042642 2042642 defendant Jenynge John yeoman 634076 634076 Jenynge, John, of Wymborne Mynster, Dorset, yeoman 0
4065542 2047966 2047966 defendant Carter John chapman 634076 634076 Carter, John, of Wymborne Mynster, Dorset, chapman 0
4069421 2049346 2049346 plaintiff Leyland James yeoman 634076 634076 Leyland, James, of Wymborne Mynster, Dorset, yeoman 0
4073594 2050845 2050845 defendant Watkyns Humphrey gent 634076 634076 Watkyns, Humphrey, of Wymborne Mynster, Dorset, gent 2
4093248 2057904 2057904 defendant Gaye James   634076 634076 Gaye, James, of Wymborne Mynster, Dorset, linen draper 0
4099172 2060028 2060028 defendant Coppen Henry chapman 634076 634076 Coppen, Henry, of Wymborne Mynster, Dorset, chapman 2
4099238 2060053 2060053 defendant Gaye James chapman 634076 634076 Gaye, James, of Wymborne, Dorset, chapman 0
4125199 2069300 2069300 defendant Barne Robert victualer 634076 634076 Barne, Robert, of Wymborne Mynster, Dorset, butcher, victualer 0
4168458 2084453 2084453 defendant Bryne Morgan joiner 634076 634076 Bryne, Morgan, of Wymborne, Dorset, joiner 2
4194980 2093807 2093807 defendant Etrycke Anthony yeoman 634076 634076 Etrycke, Anthony, of Wymborne Mynster, Dorset, yeoman 0
4219815 2102435 2102435 defendant Coffyn Henry   634076 634076 Coffyn, Henry, of Wymborne Mynster, Dorset, linen draper 0
4236159 2108216 2108216 defendant Randall Ralph husbandman 634076 634076 Randall, Ralph, of Wymborne Mynster, Dorset, husbandman 3
4246212 2111710 2111710 defendant Sachevyle Robert yeoman 634076 634076 Sachevyle, Robert, of Wymborne Minster, Dorset, yeoman 2
4270635 2119756 2119756 defendant Sachevyle Robert yeoman 634076 634076 Sachevyle, Robert, of Wymborne Minster, Dorset, yeoman 2
4376184 2156546 2156546 defendant Jeye George   634076 634076 Jeye, George, of Wymborne Mynster, Dorset, woollen draper 1
4400662 2164811 2164811 defendant Hues William carpenter 634076 634076 Hues, William, of Wymborne Mynster, Dorset, carpenter 0
4833148 2306379 2306379 defendant Wolcote Richard butcher 634076 634076 Wolcote, Richard, of Wymborne Minster, Dorset, butcher 1
4919900 2332732 2332732 defendant Abbot John dyer 634076 634076 Abbot, John, of Wymborne Minster, Dorset, dyer 0
5277450 2438483 2438483 defendant Whyng Richard yeoman 634076 634076 Whyng, Richard, of Wymborne Mynster, Dorset, yeoman 3
5277461 2438487 2438487 defendant Stoborough William chaplain 634076 634076 Stoborough, William, of Wymborne Mynster, Dorset, butcher, Burgeys, Edmund, of Berwyke St Leonard, chaplain 2
5277475 2438490 2438490 defendant Knyght John armorer 634076 634076 Knyght, John, of Wymborne Mynster, Dorset, armorer 0
5344162 2458351 2458351 defendant Southstrete William yeoman 634076 634076 Southstrete, William, of Wymborne Mynster, Dorset, yeoman 0
5516589 2510017 2510017 defendant Broughton Maurice yeoman 634076 634076 Broughton, Maurice, of Wymborne Mynster, Dorset, yeoman 0
5566474 2524786 2524786 defendant Pope alias Harvard Thomas mercer 634076 634076 Pope alias Harvard, Thomas, of Wymborne, Dorset, mercer 2

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);