names

31 rows where place_id = 595609

✎ 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
3621153 1874162 1874162 defendant Colyns Thomas chapman 595609 595609 Colyns, Thomas, of Higham Ferrers, Nhants, chapman 36
4035513 2037374 2037374 defendant Hayes Robert husbandman 595609 595609 Hayes, Robert, of Higham Ferrers, Nhants, husbandman 0
4078746 2052694 2052694 defendant Boughton Thomas draper 595609 595609 Boughton, Thomas, of Higham Ferrers, Nhants, draper 0
4257062 2115335 2115335 defendant Kyddall Robert gent 595609 595609 Kyddall, Robert, of Higham Ferrers, Nhants, gent 2
4269322 2119330 2119330 defendant Kyddall Robert gent 595609 595609 Kyddall, Robert, of Higham Ferrers, Nhants, gent 2
4323452 2138262 2138262 defendant Kiddall Robert gent 595609 595609 Kiddall, Robert, of Higham Ferrers, Nhants, gent 0
4718667 2271177 2271177 defendant Pays John chapman 595609 595609 Pays, John, of Higham Ferrers, Nhants, chapman 3
4754800 2281881 2281881 defendant Bere John miller 595609 595609 Bere, John, of Higham Ferrers, Nhants, miller 2
4836576 2307411 2307411 defendant Skull William chapman 595609 595609 Skull, William, of Higham Ferrers, Nhants, chapman 0
4911476 2330091 2330091 defendant Helyer Robert helyer or slater 595609 595609 Helyer, Robert, of Higham Ferrers, Nhants, helyer or slater 3
4943945 2340071 2340071 defendant Crabbe Henry husbandman 595609 595609 Crabbe, Henry, of Higham Ferrers, Nhants, husbandman 0
5011790 2360299 2360299 defendant Fyssher William husbandman 595609 595609 Fyssher, William, of Higham Ferrers, Nhants, husbandman 0
5049322 2371430 2371430 defendant Wales William tailor 595609 595609 Wales, William, of Higham Ferrers, Nhants, tailor 0
5051020 2371915 2371915 defendant Parys John, junior butcher 595609 595609 Parys, John, junior, of Higham Ferrers, Nhants, butcher 0
5051021 2371915 2371915 defendant Rolyn William baker 595609 595609 Rolyn, William, of Higham Ferrers, Nhants, baker 1
5108438 2388903 2388903 defendant Parys John grasier 595609 595609 Parys, John, of Higham Ferrers, Nhants, grasier 0
5108441 2388904 2388904 defendant Parys John grasier 595609 595609 Parys, John, of Higham Ferrers, Nhants, grasier 0
5138689 2397812 2397812 defendant Wellys John gent 595609 595609 (Wellys, John, of Higham Ferrers, Nhants, gent 4
5159449 2403880 2403880 defendant Wellys John gent 595609 595609 (Wellys, John, of Higham Ferrers, Nhants, gent 4
5254742 2431596 2431596 defendant Parys William butcher 595609 595609 (Parys, William, of Higham Ferrers, Nhants, butcher 1
5254746 2431597 2431597 defendant Parys William butcher 595609 595609 (Parys, William, of Higham Ferrers, Nhants, butcher 1
5276573 2438224 2438224 defendant Warde John clerk 595609 595609 (Warde, John, of Higham Ferrers, Nhants, clerk 1
5276577 2438225 2438225 defendant Warde John clerk 595609 595609 (Warde, John, of Higham Ferrers, Nhants, clerk 1
5280249 2439300 2439300 defendant Farman William butcher 595609 595609 Farman, William, of Higham Ferrers, Nhants, butcher 0
5285685 2440839 2440839 defendant Walter William husbandman 595609 595609 Walter, William, of Higham Ferrers, Nhants, husbandman 0
5290917 2442347 2442347 defendant Reynes alias Bowier William yeoman or bowyer 595609 595609 Reynes alias Bowier, William, of Higham Ferrers, Nhants, yeoman or bowyer 0
5326783 2453080 2453080 defendant Alyne or Alyve William draper 595609 595609 Alyne or Alyve, William, of Higham Ferrers, Nhants, draper 2
5353069 2461043 2461043 defendant Bere William baker 595609 595609 Bere, William, of Higham Ferrers, Nhants, baker 4
5362264 2463858 2463858 defendant Herande Nicholas husbandman 595609 595609 Herande, Nicholas, of Higham Ferrers, Nhants, husbandman 3
5446093 2488718 2488718 defendant Mathewe William draper 595609 595609 Mathewe, William, of Higham Ferrers, Nhants, draper 0
5597582 2534142 2534142 defendant Wodeward William yeoman 595609 595609 Wodeward, William, of Higham Ferrers, Nhants, yeoman 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);