names

26 rows where place_id = 603928

✎ 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
3656255 1912202 1912202 defendant Driver John husbandman 603928 603928 Driver, John, of Fulbourne, husbandman 0
3773064 1949278 1949278 defendant Ball Richard pulter 603928 603928 Ball, Richard, of Fulbourne, pulter 0
3774843 1949860 1949860 defendant Newdygate John gent 603928 603928 Newdygate, John, of Fulbourne, gent 0
3905163 1991990 1991990 defendant Balle John yeoman 603928 603928 Balle, John, of Fulbourne, yeoman 1
3905164 1991990 1991990 defendant Balle Nicholas gent 603928 603928 Balle, Nicholas, of Fulbourne, gent 2
3905165 1991990 1991990 defendant Balle Richard poulter 603928 603928 Balle, Richard, of Fulbourne, poulter 3
3906577 1992492 1992492 defendant Hancok John draper 603928 603928 Hancok, John, of Fulbourne, draper 0
4124592 2069092 2069092 defendant Whitynge William, senior husbandman 603928 603928 Whitynge, William, senior, of Fulbourne, husbandman 0
4124593 2069092 2069092 defendant Whitynge Ambrose husbandman 603928 603928 Whitynge, Ambrose, of Fulbourne, husbandman 1
4127509 2070133 2070133 defendant Hettle Thomas butcher 603928 603928 Hettle, Thomas, of Fulbourne, butcher 0
4651330 2246418 2246418 defendant Gegyl John husbandman 603928 603928 Gegyl, John, of Fulbourne, husbandman 1
4651331 2246418 2246418 defendant Clement John husbandman 603928 603928 Clement, John, of Fulbourne, husbandman 2
4768584 2286155 2286155 plaintiff Newport William esq 603928 603928 Newport, William, of Fulbourne, esq 0
4773264 2287609 2287609 plaintiff Swettok John   603928 603928 Swettok, John, of Fulbourne 0
4774417 2287981 2287981 defendant Sextayn Richard butcher 603928 603928 Sextayn, Richard, of Fulbourne, butcher 1
4798581 2295736 2295736 plaintiff Swettok John   603928 603928 Swettok, John, of Fulbourne 0
4925358 2334365 2334365 plaintiff Glovere John   603928 603928 Glovere, John, of Fulbourne, wool man 1
4968462 2347535 2347535 defendant Russell John smith 603928 603928 Russell, John, of Fulbourne, smith 1
5092136 2384076 2384076 defendant Bowyere Michael   603928 603928 Bowyere, Michael, of Fulbourne, wheelwright 0
5092137 2384076 2384076 defendant Treve Robert husbandman 603928 603928 Treve, Robert, of Fulbourne, husbandman 1
5092138 2384076 2384076 defendant Gate John husbandman 603928 603928 Gate, John, of Fulbourne, husbandman 2
5222782 2422378 2422378 defendant Wryght Richard gent 603928 603928 Wryght, Richard, of Fulbourne, gent 1
5355622 2461834 2461834 defendant Blosune or Blosime William   603928 603928 Blosune or Blosime, William, of Fulbourne, administrators of 0
5355623 2461834 2461834 defendant Blosune or Blosime Joan widow 603928 603928 (Blosune or Blosime, Joan, of Fulbourne, widow 1
5557626 2522188 2522188 defendant Clerke Thomas mercer 603928 603928 Clerke, Thomas, of Fulbourne, mercer 0
5627932 2552705 2552705 defendant Salman Roger husbandman 603928 603928 Salman, Roger, of Fulbourne, husbandman 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);