names

21 rows where place_id = 612754

✎ 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
3694873 1924605 1924605 defendant Godfrey Robert chapman 612754 612754 Godfrey, Robert, of Harlston, chapman 0
3963753 2011924 2011924 defendant Benslye Thomas shoemaker 612754 612754 Benslye, Thomas, of Harlston, shoemaker 1
4019131 2031582 2031582 defendant Shrybe John goldsmith 612754 612754 Shrybe, John, of Harlston, goldsmith 0
4090262 2056803 2056803 defendant Moore John clerk 612754 612754 Moore, John, of Harlston, or of Alboroughe, clerk 1
4192162 2092823 2092823 defendant Jacobb Henry tailor 612754 612754 Jacobb, Henry, of Harlston, tailor 0
4194823 2093750 2093750 defendant Whiting Robert   612754 612754 Whiting, Robert, of Harlston, apothecary 0
4194824 2093750 2093750 defendant Hall Edmund yeoman 612754 612754 Hall, Edmund, of Harlston, yeoman 1
4195963 2094142 2094142 defendant Whiting Mathew yeoman 612754 612754 Whiting, Mathew, of Harlston, yeoman 1
4200682 2095796 2095796 defendant Gedge Roger husbandman 612754 612754 Gedge, Roger, of Harlston, husbandman 3
4202477 2096407 2096407 defendant Jacob Henry tailor 612754 612754 Jacob, Henry, of Harlston, tailor 3
4212404 2099887 2099887 defendant Whytyng Robert yeoman 612754 612754 Whytyng, Robert, of Harlston, yeoman 1
4212817 2100017 2100017 defendant Robertson Thomas tailor 612754 612754 Robertson, Thomas, of Harlston, tailor 1
4284566 2124529 2124529 defendant Whiting Katherine widow 612754 612754 Whiting, Katherine, of Harlston, widow 0
4286055 2125068 2125068 defendant Whytinge Katherine widow 612754 612754 Whytinge, Katherine, of Harlston, widow 1
4286056 2125068 2125068 defendant Jacob Henry tailor 612754 612754 Jacob, Henry, of Harlston, tailor 2
4286057 2125068 2125068 defendant Bode William barber 612754 612754 Bode, William, of Harlston, barber 3
4288204 2125827 2125827 defendant Dawlyng Anne widow 612754 612754 Dawlyng, Anne, of Harlston, widow 2
4288205 2125827 2125827 defendant Doggett Brian carpenter 612754 612754 Doggett, Brian, of Harlston, carpenter 3
4346256 2145945 2145945 defendant Muskett Richard gent 612754 612754 Muskett, Richard, of Harlston, gent 0
4409842 2167895 2167895 defendant Tompson Anthony husbandman 612754 612754 Tompson, Anthony, of Harlston, husbandman 0
4411098 2168299 2168299 defendant Muskett Richard blacksmith 612754 612754 Muskett, Richard, of Harlston, blacksmith 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);