names

38 rows where place_id = 602260

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649189 1910135 1910135 defendant Eyre Philip gent 602260 602260 Eyre, Philip, of Tyddyswall, gent 0
3662431 1914162 1914162 defendant Robynson Thurstam husbandman 602260 602260 Robynson, Thurstam, of Tyddyswall, husbandman 2
3689739 1922948 1922948 defendant Wodroffe Robert yeoman 602260 602260 Wodroffe, Robert, of Tyddyswall, yeoman 0
3689740 1922948 1922948 defendant Purseloffe John husbandman 602260 602260 Purseloffe, John, of Tyddyswall, husbandman 1
3693817 1924265 1924265 defendant Basgshawe Robert yeoman 602260 602260 Basgshawe, Robert, of Tyddyswall, yeoman 0
3693818 1924265 1924265 defendant Benett Robert husbandman 602260 602260 Benett, Robert, of Tyddyswall, husbandman 1
3720654 1932748 1932748 defendant Bagshawe William husbandman 602260 602260 Bagshawe, William, of Tyddyswall, husbandman 0
3749255 1941695 1941695 defendant Peke Roger yeoman 602260 602260 Peke, Roger, of Tyddyswall, yeoman 1
3752330 1942653 1942653 defendant Benet Thomas husbandman 602260 602260 Benet, Thomas, of Tyddyswall, husbandman 2
3756734 1944078 1944078 defendant Holylees William husbandman 602260 602260 Holylees, William, of Tyddyswall, husbandman 0
3764134 1946432 1946432 defendant Peeke Roger yeoman 602260 602260 Peeke, Roger, of Tyddyswall, yeoman 2
3774811 1949850 1949850 defendant Chapman John husbandman 602260 602260 Chapman, John, of Tyddyswall, husbandman 0
3774812 1949850 1949850 defendant Chapman William husbandman 602260 602260 Chapman, William, of Tyddyswall, husbandman 1
3788032 1954048 1954048 defendant Purselowe Edmund yeoman 602260 602260 Purselowe, Edmund, of Tyddyswall, yeoman 1
3809042 1960709 1960709 defendant Marshall Roger miner 602260 602260 Marshall, Roger, of Tyddyswall, miner 0
3825811 1965920 1965920 defendant James alias Richardson Thomas yeoman 602260 602260 James alias Richardson, Thomas, of Tyddyswall, yeoman 0
3825813 1965921 1965921 defendant James alias Richardson Thomas yeoman 602260 602260 James alias Richardson, Thomas, of Tyddyswall, yeoman 0
3857574 1976004 1976004 defendant Netham Edward gent 602260 602260 Netham, Edward, of Tyddyswall, gent 1
3861823 1977414 1977414 defendant Bayshawe Edward yeoman 602260 602260 Bayshawe, Edward, of Tyddyswall, yeoman 1
3883399 1984715 1984715 defendant Bagsha Edward yeoman 602260 602260 Bagsha, Edward, of Tyddyswall, yeoman 0
3889301 1986659 1986659 defendant Coke Robert   602260 602260 Coke, Robert, of Tyddyswall, "corvesor" 0
3889302 1986659 1986659 defendant Barkar Philip husbandman 602260 602260 Barkar, Philip, of Tyddyswall, husbandman 1
3889303 1986659 1986659 defendant Holleley William yeoman 602260 602260 Holleley, William, of Tyddyswall, yeoman 2
3902651 1991117 1991117 defendant James Richard butcher 602260 602260 James, Richard, of Tyddyswall, butcher 0
3903457 1991382 1991382 defendant Barkar Philip husbandman 602260 602260 Barkar, Philip, of Tyddyswall, husbandman 1
3903458 1991382 1991382 defendant Halleley William yeoman 602260 602260 Halleley, William, of Tyddyswall, yeoman 2
3906394 1992427 1992427 defendant Chapman John husbandman 602260 602260 Chapman, John, of Tyddyswall, husbandman 0
3913095 1994711 1994711 defendant Barker Philip husbandman 602260 602260 Barker, Philip, of Tyddyswall, husbandman 0
3920392 1997163 1997163 defendant Crychelowe William yeoman 602260 602260 Crychelowe, William, of Tyddyswall, yeoman 1
3932940 2001306 2001306 defendant Lytton John husbandman 602260 602260 Lytton, John, of Tyddyswall, husbandman 0
5338163 2456502 2456502 defendant Barton Alexander yeoman 602260 602260 Barton, Alexander, of Tyddyswall, yeoman 2
5420461 2481043 2481043 defendant Walker Richard yeoman 602260 602260 Walker, Richard, of Tyddyswall, yeoman 8
5420462 2481043 2481043 defendant Smyth William butcher 602260 602260 Smyth, William, of Tyddyswall, butcher 9
5420463 2481043 2481043 defendant Cok Nicholas shoemaker 602260 602260 Cok, Nicholas, of Tyddyswall, shoemaker 10
5420464 2481043 2481043 defendant Hoggekynson William laborer 602260 602260 Hoggekynson, William, of Tyddyswall, laborer 11
5420465 2481043 2481043 defendant Barton Robert laborer 602260 602260 Barton, Robert, of Tyddyswall, laborer 12
5420466 2481043 2481043 defendant Hill William shoemaker 602260 602260 Hill, William, of Tyddyswall, shoemaker 13
5420467 2481043 2481043 defendant Pursclowe Robert laborer 602260 602260 Pursclowe, Robert, of Tyddyswall, laborer 14

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