names

19 rows where place_id = 596160

✎ 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
3623409 1874854 1874854 defendant Seyntyll Henry husbandman 596160 596160 Seyntyll, Henry, of Sylverton, husbandman 0
3644959 1908832 1908832 defendant Fursdon Richard yeoman 596160 596160 Fursdon, Richard, of Sylverton, yeoman 0
3703697 1927436 1927436 defendant Carsewyll Henry husbandman 596160 596160 Carsewyll, Henry, of Sylverton, husbandman 0
3722296 1933234 1933234 defendant Randall Nicholas weaver 596160 596160 Randall, Nicholas, of Sylverton, weaver 0
3737752 1938029 1938029 defendant Assherygge William husbandman 596160 596160 Assherygge, William, of Sylverton, husbandman 0
3742441 1939506 1939506 defendant Lymfyn Henry husbandman 596160 596160 Lymfyn, Henry, of Sylverton, husbandman 0
3822287 1964876 1964876 defendant Penne Thomas husbandman 596160 596160 Penne, Thomas, of Sylverton, husbandman 0
3822290 1964877 1964877 defendant Penne Thomas husbandman 596160 596160 Penne, Thomas, of Sylverton, husbandman 0
3896632 1989085 1989085 plaintiff Vycary William (legal representative) 596160 596160 Vycary, William, of Sylverton, executors of 0
3933892 2001631 2001631 defendant Bradmede John husbandman 596160 596160 Bradmede, John, of Sylverton, husbandman 1
4039597 2038780 2038780 defendant Hylner Lawrence yeoman 596160 596160 Hylner, Lawrence, of Sylverton, yeoman 7
4039614 2038781 2038781 defendant Hylmer Lawrence yeoman 596160 596160 Hylmer, Lawrence, of Sylverton, yeoman 7
4535831 2211483 2211483 defendant Aleyn Thomas   596160 596160 Aleyn, Thomas, of Sylverton 0
4940466 2339044 2339044 defendant Vogge William gent 596160 596160 Vogge, William, of Sylverton, gent 1
4970454 2348109 2348109 defendant Dygon John   596160 596160 Dygon, John, of Sylverton, mason 3
5026641 2364669 2364669 defendant Dolbury Andrew husbandman 596160 596160 Dolbury, Andrew, of Sylverton, husbandman 2
5038933 2368290 2368290 defendant Dygon John, junior   596160 596160 Dygon, John, junior, of Sylverton, mason 0
5069548 2377389 2377389 defendant Dygon John   596160 596160 Dygon, John, of Sylverton, mason 3
5254609 2431562 2431562 defendant Darte John husbandman 596160 596160 Darte, John, of Sylverton, husbandman 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);