names

24 rows where place_id = 596473

✎ 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
3624916 1875325 1875325 defendant Bromle John yeoman 596473 596473 Bromle, John, of Whitmore, yeoman 7
3624917 1875325 1875325 defendant Wode Thomas yeoman 596473 596473 Wode, Thomas, of Whitmore, yeoman 8
3668088 1915962 1915962 defendant Boughey Humphrey gent 596473 596473 Boughey, Humphrey, of Whitmore, gent 0
3684709 1921350 1921350 defendant Boughey Humphrey gent 596473 596473 Boughey, Humphrey, of Whitmore, gent 0
3793066 1955691 1955691 defendant Boughey Humphrey gent 596473 596473 Boughey, Humphrey, of Whitmore, gent 0
3793067 1955691 1955691 defendant Boughey Sebastian gent 596473 596473 Boughey, Sebastian, of Whitmore, gent 1
3901051 1990579 1990579 defendant Swynnerton John husbandman 596473 596473 Swynnerton, John, of Whitmore, husbandman 1
3965820 2012659 2012659 defendant Clerke John husbandman 596473 596473 Clerke, John, of Whitmore, husbandman 0
3965821 2012659 2012659 defendant Cook John laborer 596473 596473 Cook, John, of Whitmore, laborer 1
3965822 2012659 2012659 defendant Rodes alias Sugar John laborer 596473 596473 Rodes alias Sugar, John, of Whitmore, laborer 2
3983169 2018752 2018752 defendant Berdemore James husbandman 596473 596473 Berdemore, James, of Whitmore, husbandman 0
4147334 2077206 2077206 defendant Cotton Edward yeoman 596473 596473 Cotton, Edward, of Whitmore, or of le Woodhowse, Staffs, yeoman 0
4355529 2149155 2149155 defendant Smalwood Katherine spinster 596473 596473 Smalwood, Katherine, of Whitmore, spinster 3
4386837 2160265 2160265 defendant Bromley George yeoman 596473 596473 Bromley, George, of Whitmore, yeoman 1
4386838 2160265 2160265 defendant Cotton Roger tailor 596473 596473 Cotton, Roger, of Whitmore, tailor 2
4587183 2227398 2227398 plaintiff Housband John   596473 596473 Housband, John, of Whitmore 0
4839747 2308345 2308345 defendant Hankocson John husbandman 596473 596473 Hankocson, John, of Whitmore, husbandman 0
4974856 2349450 2349450 defendant Pole David husbandman 596473 596473 Pole, David, of Whitmore, husbandman 1
5279978 2439214 2439214 defendant Bromley John yeoman 596473 596473 Bromley, John, of Whitmore, yeoman 10
5283779 2440297 2440297 defendant Boughhey Robert gent 596473 596473 Boughhey, Robert, of Whitmore, gent 0
5283781 2440298 2440298 defendant Boughhey Robert gent 596473 596473 Boughhey, Robert, of Whitmore, gent 0
5393282 2473132 2473132 defendant Whistons Thomas husbandman 596473 596473 Whistons, Thomas, of Whitmore, husbandman 1
5557362 2522115 2522115 defendant Boughey Robert gent 596473 596473 Boughey, Robert, of Whitmore, gent 0
5563937 2524064 2524064 defendant Swynerton Roger husbandman 596473 596473 Swynerton, Roger, of Whitmore, husbandman 1

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);