names

19 rows where place_id = 717341

✎ 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
4219144 2102192 2102192 defendant Baxenden Robert yeoman 717341 717341 Baxenden, Robert, of Misterton, Notts, yeoman 0
4219594 2102358 2102358 defendant Baxenden Robert yeoman 717341 717341 Baxenden, Robert, of Misterton, Notts, yeoman 0
4219596 2102359 2102359 defendant Dawson Richard yeoman 717341 717341 Dawson, Richard, of Misterton, Notts, yeoman 0
4221345 2102965 2102965 defendant Baxendaile Robert yeoman 717341 717341 Baxendaile, Robert, of Misterton, Notts, yeoman 0
4247519 2112158 2112158 defendant Podge George gent 717341 717341 Podge, George, of Misterton, Notts, gent 0
4257851 2115600 2115600 defendant Poge George gent or esq 717341 717341 Poge, George, of Misterton, Notts, gent or esq 0
4274176 2120912 2120912 defendant Poge George esq 717341 717341 Poge, George, of Misterton, Notts, esq 0
4281763 2123524 2123524 defendant Dawson Richard yeoman 717341 717341 Dawson, Richard, of Misterton, Notts, yeoman 0
4282047 2123622 2123622 defendant Dawson Richard yeoman 717341 717341 Dawson, Richard, of Misterton, Notts, yeoman 0
4291289 2126956 2126956 defendant Poage George esq 717341 717341 Poage, George, of Misterton, Notts, esq 1
4311809 2134268 2134268 defendant Gylbie John yeoman 717341 717341 Gylbie, John, of Misterton, Notts, yeoman 0
4346081 2145884 2145884 defendant Gilbye John yeoman 717341 717341 Gilbye, John, of Misterton, Notts, yeoman 0
4359597 2150595 2150595 defendant Dawson Richard yeoman 717341 717341 Dawson, Richard, of Misterton, Notts, yeoman 0
4367081 2153282 2153282 defendant Wikeham Anthony yeoman 717341 717341 Wikeham, Anthony, of Misterton, notts, yeoman 0
4367119 2153296 2153296 defendant Gilbye John yeoman 717341 717341 Gilbye, John, of Misterton, Notts, yeoman 0
4385960 2159995 2159995 defendant Tonge Thomas yeoman 717341 717341 Tonge, Thomas, of Misterton, Notts, yeoman 0
4573262 2223171 2223171 defendant Catirton John   717341 717341 Catirton, John, of Misterton, Notts, vicar 0
4673823 2257433 2257433 defendant Puddesey John yeoman 717341 717341 Puddesey, John, of Misterton, Notts, yeoman 10
4965450 2346581 2346581 defendant Donell or Dovell William husbandman 717341 717341 Donell or Dovell, William, of Misterton, Notts, husbandman 2

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