names

37 rows where place_id = 597136

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627434 1903436 1903436 defendant Smyth John husbandman 597136 597136 Smyth, John, of Cubley, husbandman 0
3636916 1906339 1906339 defendant Mountgomery Elizabeth widow 597136 597136 Mountgomery, Elizabeth, of Cubley, widow 0
3637435 1906515 1906515 defendant Botsythe John smith 597136 597136 Botsythe, John, of Cubley, smith 0
3707130 1928516 1928516 defendant Saunder Richard husbandman 597136 597136 Saunder, Richard, of Cubley, husbandman 1
3707133 1928517 1928517 defendant Saunder Richard husbandman 597136 597136 Saunder, Richard, of Cubley, husbandman 1
3775501 1950079 1950079 defendant Saunders Richard yeoman 597136 597136 Saunders, Richard, of Cubley, yeoman 1
3960116 2010641 2010641 defendant Loggan John yeoman 597136 597136 Loggan, John, of Cubley, yeoman 0
4583777 2226342 2226342 defendant Tyrry William   597136 597136 Tyrry, William, of Cubley 0
4863948 2315700 2315700 defendant Smyth Nicholas husbandman 597136 597136 Smyth, Nicholas, of Cubley, husbandman 0
4974935 2349477 2349477 plaintiff Montegomery Nicholas esq 597136 597136 Montegomery, Nicholas, of Cubley, esq 0
5037177 2367741 2367741 defendant Straunge Nicholas husbandman 597136 597136 Straunge, Nicholas, of Cubley, husbandman 0
5122926 2393135 2393135 defendant Snappe Robert yeoman 597136 597136 Snappe, Robert, of Cubley, yeoman 3
5133972 2396432 2396432 defendant Mountgomerey Nicholas, senior esq 597136 597136 Mountgomerey, Nicholas, senior, of Cubley, esq 0
5153887 2402292 2402292 defendant Mountgomerey Nicholas, sen esq 597136 597136 Mountgomerey, Nicholas, sen, of Cubley, esq 0
5171159 2407285 2407285 defendant Mountgomerey Nicholas, sen esq 597136 597136 Mountgomerey, Nicholas, sen, of Cubley, esq 0
5189391 2412632 2412632 defendant Mountgomerey Nicholas, sen esq 597136 597136 Mountgomerey, Nicholas, sen, of Cubley, esq 0
5215412 2420236 2420236 defendant Mountgomery Nicholas, senior esq 597136 597136 Mountgomery, Nicholas, senior, of Cubley, esq 0
5215413 2420236 2420236 defendant Mountgomery Nicholas, junior esq 597136 597136 Mountgomery, Nicholas, junior, of Cubley, esq 1
5222786 2422380 2422380 defendant Mountgomery Nicholas, senior esq 597136 597136 Mountgomery, Nicholas, senior, of Cubley, esq 0
5222787 2422380 2422380 defendant Mountgomery Nicholas, junior esq 597136 597136 Mountgomery, Nicholas, junior, of Cubley, esq 1
5233791 2425472 2425472 defendant Mountgomery Nicholas, senior esq 597136 597136 Mountgomery, Nicholas, senior, of Cubley, esq 0
5233792 2425472 2425472 defendant Mountgomery Nicholas, junior esq 597136 597136 Mountgomery, Nicholas, junior, of Cubley, esq 1
5242823 2428105 2428105 defendant Mountgomery Nicholas, senior esq 597136 597136 Mountgomery, Nicholas, senior, of Cubley, esq 0
5242824 2428105 2428105 defendant Mountgomery Nicholas, junior esq 597136 597136 Mountgomery, Nicholas, junior, of Cubley, esq 1
5351395 2460536 2460536 defendant Bradshawe Hugh yeoman 597136 597136 Bradshawe, Hugh, of Cubley, yeoman 0
5598641 2534454 2534454 defendant Mountgomery John   597136 597136 Mountgomery, John, of Cubley, knight 0
5598642 2534454 2534454 defendant Chalner Thomas yeoman 597136 597136 Chalner, Thomas, of Cubley, yeoman 1
5598645 2534454 2534454 defendant Poker Henry husbandman 597136 597136 Poker, Henry, of Cubley, husbandman 4
5598650 2534455 2534455 defendant Mountgomery John   597136 597136 Mountgomery, John, of Cubley, knight 0
5598651 2534455 2534455 defendant Sherle Richard clerk 597136 597136 Sherle, Richard, of Cubley, clerk 1
5598652 2534455 2534455 defendant Botefyssh John smith 597136 597136 Botefyssh, John, of Cubley, smith 2
5598653 2534455 2534455 defendant Chalnar Robert husbandman 597136 597136 Chalnar, Robert, of Cubley, husbandman 3
5598654 2534455 2534455 defendant Poker Thomas husbandman 597136 597136 Poker, Thomas, of Cubley, husbandman 4
5598655 2534455 2534455 defendant Heype William yeoman 597136 597136 Heype, William, of Cubley, yeoman 5
5598663 2534456 2534456 defendant Mountgomery John   597136 597136 Mountgomery, John, of Cubley, knight 0
5598664 2534456 2534456 defendant Sydebothom Robert cooper 597136 597136 Sydebothom, Robert, of Cubley, cooper 1
5598665 2534456 2534456 defendant Chalner Robert husbandman 597136 597136 Chalner Robert, of Cubley, husbandman 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);