names

37 rows where place_id = 596758

✎ 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
3626069 1903012 1903012 defendant Houghton John husbandman 596758 596758 Houghton, John, of Paynton, husbandman 0
3626070 1903012 1903012 defendant Adam John husbandman 596758 596758 Adam, John, of Paynton, husbandman 1
3638140 1906746 1906746 defendant Spert John husbandman 596758 596758 Spert, John, of Paynton, husbandman 0
3640459 1907448 1907448 defendant Houghton John husbandman 596758 596758 Houghton, John, of Paynton, husbandman 0
3640460 1907448 1907448 defendant Adam John husbandman 596758 596758 Adam John, of Paynton, husbandman 1
3643452 1908379 1908379 defendant Clement William husbandman 596758 596758 Clement, William, of Paynton, husbandman 0
3711379 1929863 1929863 defendant Hoppyng Joan widow 596758 596758 Hoppyng, Joan, of Paynton, widow 0
3724891 1934071 1934071 defendant Hyllyng Nicholas husbandman 596758 596758 Hyllyng, Nicholas, of Paynton, husbandman 1
3741344 1939160 1939160 defendant Hyllyng Nicholas husbandman 596758 596758 Hyllyng, Nicholas, of Paynton, husbandman 1
3743279 1939766 1939766 defendant Parker Nicholas husbandman 596758 596758 Parker, Nicholas, of Paynton, husbandman 0
3743280 1939766 1939766 defendant Sperte Roger husbandman 596758 596758 Sperte, Roger, of Paynton, husbandman 1
3746321 1940765 1940765 defendant Codnor Richard   596758 596758 Codnor, Richard, of Paynton, "fysshe dryver" 0
3750538 1942083 1942083 defendant Rawe William husbandman 596758 596758 Rawe, William, of Paynton, husbandman 0
3768154 1947677 1947677 defendant Dunstepyll John mariner 596758 596758 Dunstepyll, John, of Paynton, mariner 0
3783452 1952573 1952573 defendant Haradon Ambrose husbandman 596758 596758 Haradon, Ambrose, of Paynton, husbandman 0
3806039 1959816 1959816 defendant Parker John husbandman 596758 596758 Parker, John, of Paynton, husbandman 1
3806040 1959816 1959816 defendant Carswyll John yeoman 596758 596758 Carswyll, John, of Paynton, yeoman 2
3930172 2000436 2000436 plaintiff Cole John   596758 596758 Cole, John, of Paynton, 0
3973208 2015199 2015199 defendant Powell Peter yeoman 596758 596758 Powell, Peter, of Paynton, yeoman 0
4024311 2033387 2033387 defendant Risedon Walter weaver 596758 596758 Risedon, Walter, of Paynton, weaver 4
4024317 2033388 2033388 defendant Risedon Walter weaver 596758 596758 Risedon, Walter, of Paynton, weaver 4
4273742 2120762 2120762 defendant Garthe William clerk 596758 596758 Garthe, William, of Paynton, clerk 0
4726024 2273425 2273425 defendant Lucas Thomas butcher 596758 596758 Lucas, Thomas, of Paynton, butcher 0
4850503 2311618 2311618 defendant Henry William smith 596758 596758 Henry, William, of Paynton, smith 0
4934670 2337234 2337234 defendant Davy William yeoman 596758 596758 Davy, William, of Paynton, yeoman 3
5243912 2428411 2428411 plaintiff Parker Stephen (legal representative) 596758 596758 Parker, Stephen, of Paynton, executors of 0
5287799 2441454 2441454 defendant Wolston William husbandman 596758 596758 Wolston, William, of Paynton, husbandman 0
5451035 2490202 2490202 defendant Cole Stephen husbandman 596758 596758 Cole, Stephen, of Paynton, husbandman 1
5458979 2492580 2492580 defendant Gylberd Otto esq 596758 596758 Gylberd, Otto, of Paynton, esq 1
5474709 2497419 2497419 defendant Cole Stephen husbandman 596758 596758 Cole, Stephen, of Paynton, husbandman 1
5474715 2497420 2497420 defendant Cole Stephen husbandman 596758 596758 Cole, Stephen, of Paynton, husbandman 1
5506486 2506936 2506936 defendant Comyng Stephen yeoman 596758 596758 Comyng, Stephen, of Paynton, yeoman 0
5506487 2506936 2506936 defendant Byllysford William yeoman 596758 596758 Byllysford, William, of Paynton, yeoman 1
5506488 2506936 2506936 defendant atte Bowe Thomas yeoman 596758 596758 atte Bowe, Thomas, of Paynton, yeoman 2
5534897 2515458 2515458 defendant Desper William husbandman 596758 596758 Desper, William, of Paynton, husbandman 1
5550513 2520173 2520173 defendant Sperte John weaver 596758 596758 Sperte, John, of Paynton, weaver 0
5553368 2521025 2521025 defendant Spart John weaver 596758 596758 Spart, John, of Paynton, weaver 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);