names

29 rows where place_id = 622990

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3750119 1941951 1941951 defendant Lowse William husbandman 622990 622990 Lowse, William, of Fyldallyng, husbandman 1
3783526 1952601 1952601 defendant Lowse William husbandman 622990 622990 Lowse, William, of Fyldallyng, husbandman 0
3800412 1958049 1958049 defendant Lose William yeoman 622990 622990 Lose, William, of Fyldallyng, yeoman 0
3817956 1963535 1963535 defendant Lose William yeoman 622990 622990 Lose, William, of Fyldallyng, yeoman 0
3920656 1997256 1997256 defendant Borne John yeoman 622990 622990 Borne, John, of Fyldallyng, yeoman 2
3947528 2006206 2006206 defendant Framyngham Edmund   622990 622990 Framyngham, Edmund, of Fyldallyng, ploughwright 2
3951956 2007747 2007747 defendant Bourne John yeoman 622990 622990 Bourne, John, of Fyldallyng, yeoman 0
3951957 2007747 2007747 defendant Bett Edmund husbandman 622990 622990 Bett, Edmund, of Fyldallyng, husbandman 1
3951959 2007748 2007748 defendant Bourne John yeoman 622990 622990 Bourne, John, of Fyldallyng, yeoman 0
3951961 2007748 2007748 defendant Bett Edmund husbandman 622990 622990 together with Bett, Edmund, of Fyldallyng, husbandman 2
3951963 2007749 2007749 defendant Taylour John husbandman 622990 622990 Taylour, John, of Fyldallyng, husbandman 0
3951964 2007749 2007749 defendant Taylour William husbandman 622990 622990 Taylour, William, of Fyldallyng, husbandman 1
3955446 2008971 2008971 defendant Frayngham Edmund   622990 622990 Frayngham, Edmund, of Fyldallyng, ploughwright 0
4000832 2025067 2025067 defendant Lowsse William husbandman 622990 622990 Lowsse, William, of Fyldallyng, husbandman 0
4000833 2025067 2025067 defendant Nycholas William yeoman 622990 622990 Nycholas, William, of Fyldallyng, yeoman 1
4008383 2027764 2027764 defendant Borne James   622990 622990 Borne, James, of Fyldallyng, or of Claye juxta Mare gent 0
4011336 2028831 2028831 defendant Bourne James gent 622990 622990 Bourne, James, of Fyldallyng, gent 0
4011341 2028832 2028832 defendant Bourne James gent 622990 622990 Bourne, James, of Fyldallyng, gent 0
4022497 2032771 2032771 defendant Boyne or Borne James merchant 622990 622990 Boyne or Borne, James, of Fyldallyng, merchant 0
4027026 2034313 2034313 defendant Harryson John husbandman 622990 622990 Harryson, John, of Fyldallyng, husbandman 0
4045833 2040954 2040954 defendant Butcher Roger weaver 622990 622990 Butcher, Roger, of Fyldallyng, weaver 0
4060828 2046279 2046279 defendant Nicholas Thomas yeoman 622990 622990 Nicholas, Thomas, of Fyldallyng, yeoman 0
4062277 2046799 2046799 defendant Nichollas Thomas yeoman 622990 622990 Nichollas, Thomas, of Fyldallyng, yeoman 0
4095454 2058698 2058698 defendant Nicholas Thomas yeoman 622990 622990 Nicholas, Thomas, of Fyldallyng, yeoman 0
4095950 2058883 2058883 defendant Bourne John (legal representative) 622990 622990 Bourne, John, of Fyldallyng, yeoman, executor of 0
4095951 2058883 2058883 defendant Bourne James gent 622990 622990 Bourne, James, of Fyldallyng, gent 1
4095955 2058884 2058884 defendant Bourne John (legal representative) 622990 622990 Bourne, John, of Fyldallyng, yeoman, executor of 0
4095956 2058884 2058884 defendant Bourne James gent 622990 622990 Bourne, James, of Fyldallyng, gent 1
4901174 2326980 2326980 defendant Cake Thomas husbandman 622990 622990 Cake, Thomas, of Fyldallyng, husbandman 3

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