names

27 rows where place_id = 594257

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615309 1872433 1872433 defendant Swetnam William innholder 594257 594257 Swetnam, William, of Huntyngton, Hunts, innholder 1
3615314 1872434 1872434 defendant Swetnam William innholder 594257 594257 Swetnam, William, of Huntyngton, Hunts, innholder 1
3679849 1919762 1919762 defendant Cowper William chapman 594257 594257 Cowper, William, of Huntyngton, Hunts, chapman 3
3868231 1979609 1979609 defendant Barnes William cordwainer 594257 594257 Barnes, William, of Huntyngton, Hunts, cordwainer 1
3943790 2004938 2004938 defendant Smyth Gilbert   594257 594257 Smyth, Gilbert, of Huntyngton, Hunts, linen draper 0
3961409 2011085 2011085 defendant Hynde Martin chapman 594257 594257 (Hynde, Martin, of Huntyngton, Hunts, chapman 5
3965794 2012649 2012649 defendant Blynkhorne Robert innholder 594257 594257 Blynkhorne, Robert, of Huntyngton, Hunts, innholder 0
4020912 2032207 2032207 defendant Woodrouse Clement vintner 594257 594257 Woodrouse, Clement, of Huntyngton, Hunts, vintner 0
4036173 2037622 2037622 defendant Lamkyn William pewterer 594257 594257 Lamkyn, William, of Huntyngton, Hunts, pewterer 0
4040428 2039067 2039067 defendant Bullyngham John   594257 594257 Bullyngham, John, of Huntyngton, Hunts, clerk, archdeacon of Huntington 0
4053022 2043512 2043512 defendant Powes John glover 594257 594257 Powes, John, of Huntyngton, Hunts, glover 0
4121622 2068027 2068027 defendant Hexsam John gent 594257 594257 Hexsam, John, of Huntyngton, Hunts, gent 0
4141056 2075030 2075030 defendant Hexsam John gent 594257 594257 Hexsam, John, of Huntyngton, Hunts, gent 0
4691554 2262883 2262883 defendant Chambirleyn Roger gent 594257 594257 Chambirleyn, Roger, of Huntyngton, Hunts, gent 1
4803956 2297419 2297419 defendant Smyth Roger smith 594257 594257 Smyth, Roger, of Huntyngton, Hunts, smith 0
4805229 2297835 2297835 defendant Pekke Robert gent 594257 594257 Pekke, Robert, of Huntyngton, Hunts, gent 0
4934624 2337222 2337222 defendant Cut Thomas butcher 594257 594257 Cut, Thomas, of Huntyngton, Hunts, butcher 0
5175867 2408624 2408624 defendant Raad William smith 594257 594257 Raad, William, of Huntyngton, Hunts, smith 0
5213147 2419577 2419577 defendant Polyard John yeoman 594257 594257 Polyard, John, of Huntyngton, Hunts, yeoman 0
5322534 2451817 2451817 defendant Wodeward John baker 594257 594257 Wodeward, John, of Huntyngton, Hunts, baker 0
5422822 2481780 2481780 defendant Swettenham William yeoman 594257 594257 Swettenham, William, of Huntyngton, Hunts, yeoman 0
5437021 2486009 2486009 defendant Clerke William yeoman 594257 594257 Clerke, William, of Huntyngton, Hunts, yeoman 2
5455051 2491431 2491431 defendant Swettenham William yeoman 594257 594257 Swettenham, William, of Huntyngton, Hunts, yeoman 0
5455053 2491432 2491432 defendant Swettenham William yeoman 594257 594257 Swettenham, William, of Huntyngton, Hunts, yeoman 0
5529166 2513635 2513635 defendant Kerver John merchant 594257 594257 Kerver, John, of Huntyngton, Hunts, merchant 1
5566082 2524679 2524679 defendant Swetman William innholder 594257 594257 Swetman, William, of Huntyngton, Hunts, innholder 0
5570152 2525844 2525844 defendant Pecarde Robert innholder 594257 594257 Pecarde, Robert, of Huntyngton, Hunts, innholder 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);