names

24 rows where place_id = 662399

✎ 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
3964776 2012287 2012287 defendant Tommes Robert yeoman 662399 662399 Tommes, Robert, of Colford, yeoman 0
3964777 2012287 2012287 defendant Morse John yeoman 662399 662399 Morse, John, of Colford, yeoman 1
3970876 2014385 2014385 defendant Griffith George yeoman 662399 662399 Griffith, George, of Colford, yeoman 6
4024363 2033392 2033392 defendant Stocker Robert yeoman 662399 662399 Stocker, Robert, of Colford, yeoman 11
4057739 2045154 2045154 defendant Yee William yeoman 662399 662399 Yee, William, of Colford, yeoman 0
4057740 2045154 2045154 defendant Yarsley John yeoman 662399 662399 Yarsley, John, of Colford, yeoman 1
4122770 2068436 2068436 defendant Worgan Robert yeoman 662399 662399 Worgan, Robert, of Colford, yeoman 1
4122771 2068436 2068436 defendant Powell Richard chapman 662399 662399 Powell, Richard, of Colford, chapman 2
4142947 2075705 2075705 defendant Naylor John yeoman 662399 662399 Naylor, John, of Colford, yeoman 2
4311792 2134261 2134261 defendant Morton Henry joiner 662399 662399 Morton, Henry, of Colford, joiner 0
4311794 2134262 2134262 defendant Morton Henry joiner 662399 662399 Morton, Henry, of Colford, joiner 0
4320280 2137194 2137194 defendant Dowle Robert yeoman 662399 662399 Dowle, Robert, of Colford, yeoman 0
4374436 2155925 2155925 defendant Naylor James (legal representative) 662399 662399 Naylor, James, of Colford, yeoman, executor of 0
4374437 2155925 2155925 defendant Naylor John yeoman 662399 662399 Naylor, John, of Colford, yeoman 1
4721300 2271992 2271992 plaintiff Carpenter John   662399 662399 Carpenter, John, of Colford 0
4721301 2271992 2271992 defendant Skyn Thomas ploughman 662399 662399 Skyn, Thomas, of Colford, ploughman 0
4776603 2288675 2288675 defendant Kere Roger smith 662399 662399 Kere, Roger, of Colford, smith 0
4832290 2306130 2306130 defendant Bylston Thomas husbandman 662399 662399 Bylston, Thomas, of Colford, husbandman 0
5346639 2459103 2459103 defendant More John smith holder 662399 662399 More, John, of Colford, smith holder 0
5346640 2459103 2459103 defendant Nayler Richard smith holder 662399 662399 Nayler, Richard, of Colford, smith holder 1
5346643 2459104 2459104 defendant More John smith holder 662399 662399 More, John, of Colford, smith holder 0
5346644 2459104 2459104 defendant Nayler Richard smith holder 662399 662399 Nayler, Richard, of Colford, smith holder 1
5454142 2491135 2491135 defendant Cornyssh Thomas   662399 662399 Cornyssh, Thomas, of Colford 1
5514162 2509275 2509275 defendant Saunders Richard clothier 662399 662399 Saunders, Richard, of Colford, clothier 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);