names

17 rows where place_id = 612131

✎ 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
3691727 1923573 1923573 defendant Bradbury Robert husbandman 612131 612131 Bradbury, Robert, of Yolgreve, husbandman 0
3782057 1952140 1952140 defendant Bradbury Robert yeoman 612131 612131 Bradbury, Robert, of Yolgreve, yeoman 0
3816199 1962973 1962973 defendant Bradbury Robert yeoman 612131 612131 Bradbury, Robert, of Yolgreve, yeoman 0
4599564 2231079 2231079 defendant Fychet Roger   612131 612131 Fychet, Roger, of Yolgreve 0
4633170 2241243 2241243 defendant Swan Robert   612131 612131 Swan, Robert, of Yolgreve 0
4801762 2296733 2296733 defendant Fox John   612131 612131 Fox, John, of Yolgreve 0
4972529 2348715 2348715 defendant Wayn Richard yeoman 612131 612131 Wayn, Richard, of Yolgreve, yeoman 1
4983784 2352077 2352077 defendant Byrd John miner 612131 612131 Byrd, John, of Yolgreve, miner 3
4983786 2352077 2352077 defendant Marshall William miner 612131 612131 Marshall, William, of Yolgreve, miner 5
5036816 2367644 2367644 defendant Brid Richard miner 612131 612131 Brid, Richard, of Yolgreve, miner 3
5037934 2367976 2367976 defendant Bryd Nicholas yeoman 612131 612131 Bryd, Nicholas, of Yolgreve, yeoman 2
5037935 2367976 2367976 defendant Marshall Walter yeoman 612131 612131 Marshall, Walter, of Yolgreve, yeoman 3
5333244 2455014 2455014 defendant Gilbert Robert gent 612131 612131 Gilbert, Robert, of Yolgreve, gent 0
5344811 2458540 2458540 defendant Crychelowe Richard husbandman 612131 612131 Crychelowe, Richard, of Yolgreve, husbandman 7
5344820 2458541 2458541 defendant Crychelowe Richard husbandman 612131 612131 Crychelowe, Richard, of Yolgreve, husbandman 7
5497261 2504119 2504119 defendant Gylbert Robert gent 612131 612131 Gylbert, Robert, of Yolgreve, gent 0
5601323 2535308 2535308 defendant Cuyn Richard husbandman 612131 612131 Cuyn, Richard, of Yolgreve, 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);