names

34 rows where place_id = 625820

✎ 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
3766544 1947194 1947194 defendant Dampier William husbandman 625820 625820 Dampier, William, of Rympton, husbandman 0
3766546 1947195 1947195 defendant Dampier William husbandman 625820 625820 Dampier, William, of Rympton, husbandman 0
3893518 1988059 1988059 plaintiff Petwyn George (legal representative) 625820 625820 Petwyn, George, of Rympton, gent, executors of 0
3907813 1992902 1992902 plaintiff Petwyn George (legal representative) 625820 625820 Petwyn, George, of Rympton, executors of 0
3993275 2022337 2022337 defendant Anthonye John husbandman 625820 625820 Anthonye, John, of Rympton, husbandman 0
4119209 2067162 2067162 defendant Clothier John husbandman 625820 625820 Clothier, John, of Rympton, husbandman 0
4119211 2067163 2067163 defendant Clothyer John husbandman 625820 625820 Clothyer, John, of Rympton, husbandman 0
4123372 2068660 2068660 defendant Badcott William yeoman 625820 625820 Badcott, William, of Rympton, yeoman 2
4123374 2068661 2068661 defendant Rapley John yeoman 625820 625820 Rapley, John, of Rympton, yeoman 0
4130943 2071379 2071379 defendant Southye Andrew yeoman 625820 625820 Southye, Andrew, of Rympton, yeoman 1
4147416 2077237 2077237 defendant Clenche Robert yeoman 625820 625820 Clenche, Robert, of Rympton, yeoman 0
4156429 2080326 2080326 defendant Rapley John yeoman 625820 625820 Rapley, John, of Rympton, yeoman 0
4158012 2080874 2080874 defendant Clenche Robert husbandman 625820 625820 Clenche, Robert, of Rympton, husbandman 0
4170276 2085097 2085097 defendant Rapley John, senior husbandman 625820 625820 Rapley, John, senior, of Rympton, husbandman 0
4170277 2085097 2085097 defendant Payne John husbandman 625820 625820 Payne, John, of Rympton, husbandman 1
4170278 2085097 2085097 defendant Wyll John weaver 625820 625820 Wyll, John, of Rympton, weaver 2
4182623 2089401 2089401 defendant Rapley John yeoman 625820 625820 Rapley, John, of Rympton, yeoman 0
4187698 2091199 2091199 defendant Raplye John yeoman 625820 625820 Raplye, John, of Rympton, yeoman 3
4199057 2095226 2095226 defendant Clyves Humphrey (legal representative) 625820 625820 Clyves, Humphrey, of Rympton, husbandman, executrix of 0
4219953 2102482 2102482 defendant Clenche Robert yeoman 625820 625820 Clenche, Robert, of Rympton, yeoman 0
4350139 2147306 2147306 defendant Clench Robert husbandman 625820 625820 Clench, Robert, of Rympton, husbandman 0
4375032 2156131 2156131 defendant Clenche Robert husbandman 625820 625820 Clenche, Robert, of Rympton, husbandman 1
4390758 2161521 2161521 defendant Ridowte William yeoman 625820 625820 Ridowte, William, of Rympton, yeoman 0
4619645 2237130 2237130 defendant Staunton William   625820 625820 Staunton, William, of Rympton 1
4628467 2239824 2239824 defendant Staunton William   625820 625820 Staunton, William, of Rympton 4
4704280 2266716 2266716 defendant Sandret John   625820 625820 Sandret, John, of Rympton, parson 0
4719391 2271409 2271409 defendant Saundrys John   625820 625820 Saundrys, John, of Rympton, parson & clerk 0
4751050 2280791 2280791 plaintiff Saundres John   625820 625820 Saundres, John, of Rympton, parson, on his own account 0
4771406 2287039 2287039 plaintiff Saundres John   625820 625820 Saundres, John, of Rympton, parson 0
4859173 2314243 2314243 plaintiff Byrche John (legal representative) 625820 625820 Byrche, John, of Rympton, executors of 0
4868247 2317046 2317046 defendant Saundres John clerk 625820 625820 Saundres, John, of Rympton, clerk 3
4868253 2317047 2317047 defendant Saundres John clerk 625820 625820 Saundres, John, of Rympton, clerk 3
4986696 2352955 2352955 defendant Stouton Thomas butcher 625820 625820 Stouton, Thomas, of Rympton, butcher 0
5142214 2398845 2398845 defendant Staunton Thomas butcher 625820 625820 Staunton, Thomas, of Rympton, butcher 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);