names

22 rows where place_id = 674875

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4015997 2030414 2030414 defendant Totnam William yeoman 674875 674875 Totnam, William, of Barrington, yeoman 0
4016471 2030595 2030595 defendant Totnam William yeoman 674875 674875 Totnam, William, of Barrington, yeoman 0
4037647 2038116 2038116 defendant Tottenham John yeoman 674875 674875 Tottenham, John, of Barrington, yeoman 1
4096488 2059071 2059071 defendant Rychemond Robert yeoman 674875 674875 Rychemond, Robert, of Barrington, yeoman 3
4130334 2071159 2071159 defendant Thomas William yeoman 674875 674875 Thomas, William, of Barrington, or of Ilton, yeoman 1
4192245 2092851 2092851 defendant Ryveley Ferdinand gent 674875 674875 Ryveley, Ferdinand, of Barrington, gent 0
4250533 2113166 2113166 defendant Cottishall Thomas butcher 674875 674875 Cottishall, Thomas, of Barrington, butcher 2
4250563 2113172 2113172 defendant Cottishall Thomas butcher 674875 674875 Cottishall, Thomas, of Barrington, butcher 2
4284066 2124346 2124346 defendant Cley John husbandman 674875 674875 Cley, John, of Barrington, husbandman 0
4287321 2125522 2125522 defendant Cley John husbandman 674875 674875 Cley, John, of Barrington, husbandman 0
4314485 2135179 2135179 defendant Hawkes Thomas husbandman 674875 674875 Hawkes, Thomas, of Barrington, husbandman 1
4327068 2139385 2139385 defendant Clyfton John (legal representative) 674875 674875 Clyfton, John, of Barrington, knight, executor of 1
4342763 2144742 2144742 defendant Stevenson Richard miller 674875 674875 Stevenson, Richard, of Barrington, miller 0
4365365 2152676 2152676 defendant Hick John husbandman 674875 674875 Hick, John, of Barrington, husbandman 1
4391178 2161667 2161667 defendant Langbridge Mellenee   674875 674875 Langbridge, Mellenee, of Barrington, widow, administrators of 1
4391179 2161667 2161667 defendant Gaylard John husbandman 674875 674875 (Gaylard, John, of Barrington, husbandman 2
4391180 2161667 2161667 defendant Pyttard Thomas husbandman 674875 674875 Pyttard, Thomas, of Barrington, husbandman 3
4394307 2162694 2162694 defendant Casebolt William yeoman 674875 674875 Casebolt, William, of Barrington, yeoman 1
4397763 2163828 2163828 defendant Sparkes Samuel glover 674875 674875 Sparkes, Samuel, of Barrington, glover 2
4720581 2271771 2271771 defendant Wodehay John gent 674875 674875 Wodehay, John, of Barrington, gent 0
5168016 2406355 2406355 defendant Daubenry William esq 674875 674875 Daubenry, William, of Barrington, esq 0
5183750 2410981 2410981 defendant Daubeney William esq 674875 674875 Daubeney, William, of Barrington, esq 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);