names

40 rows where place_id = 596282

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624016 1875045 1875045 defendant Lemyng Henry gent 596282 596282 Lemyng, Henry, of Bilburgh, gent 2
3648672 1909972 1909972 defendant Kyng Henry husbandman 596282 596282 Kyng, Henry, of Bilburgh, husbandman 0
3648673 1909972 1909972 defendant Kyng John husbandman 596282 596282 Kyng, John, of Bilburgh, husbandman 1
3648676 1909973 1909973 defendant Kyng Henry husbandman 596282 596282 Kyng, Henry, of Bilburgh, husbandman 1
3648677 1909973 1909973 defendant Kyng John husbandman 596282 596282 Kyng, John, of Bilburgh, husbandman 2
3720260 1932613 1932613 defendant Wade Percival yeoman 596282 596282 Wade, Percival, of Bilburgh, yeoman 0
3723022 1933469 1933469 defendant Whithawse Robert husbandman 596282 596282 Whithawse, Robert, of Bilburgh, husbandman 0
3748227 1941373 1941373 defendant Norton Christopher esq 596282 596282 Norton, Christopher, of Bilburgh, esq 0
3762380 1945877 1945877 defendant Norton Christopher esq 596282 596282 Norton, Christopher, of Bilburgh, esq 0
3794009 1955990 1955990 defendant Caroke Thomas husbandman 596282 596282 Caroke, Thomas, of Bilburgh, husbandman 0
3901577 1990753 1990753 defendant Preston Arthur gent 596282 596282 Preston, Arthur, of Bilburgh, gent 0
4422615 2171930 2171930 plaintiff Estweyt Nicholas de   596282 596282 Estweyt, Nicholas de, of Bilburgh 1
4422616 2171930 2171930 defendant Mersshton Richard de   596282 596282 Mersshton, Richard de, of Bilburgh, parson 0
4468328 2190761 2190761 plaintiff Basy Richard (legal representative) 596282 596282 Basy, Richard, of Bilburgh, executors of 0
4468329 2190761 2190761 plaintiff Basy Elizabeth   596282 596282 (Basy, Elizabeth, of Bilburgh, formerly wife of Richard Basy 1
4482498 2195228 2195228 plaintiff Thorneton Alan de chaplain 596282 596282 Thorneton, Alan de, of Bilburgh, chaplain 2
4617043 2236339 2236339 defendant Basy Richard (legal representative) 596282 596282 Basy, Richard, of Bilburgh, executrix of 0
4687726 2261735 2261735 defendant Smyth John smith 596282 596282 Smyth, John, of Bilburgh, smith 1
4687727 2261735 2261735 defendant Wryght John   596282 596282 Wryght, John, of Bilburgh, wright 2
4760871 2283740 2283740 defendant Fairard Thomas husbandman 596282 596282 Fairard, Thomas, of Bilburgh, husbandman 0
4773894 2287814 2287814 defendant Coke John laborer 596282 596282 Coke, John, of Bilburgh, laborer 0
4799326 2295965 2295965 defendant Coke John laborer 596282 596282 Coke, John, of Bilburgh, laborer 0
4960778 2345186 2345186 defendant Norton William gent 596282 596282 Norton, William, of Bilburgh, gent 2
4984425 2352274 2352274 defendant Hyde Robert laborer 596282 596282 Hyde, Robert, of Bilburgh, laborer 0
5009835 2359752 2359752 defendant Davell Thomas chaplain 596282 596282 Davell, Thomas, of Bilburgh, chaplain 0
5072147 2378158 2378158 defendant Preston Hugh yeoman 596282 596282 Preston, Hugh,of Bilburgh, yeoman 1
5249095 2429854 2429854 defendant Bergh Richard husbandman 596282 596282 Bergh, Richard, of Bilburgh, husbandman 2
5314489 2449362 2449362 defendant Lemyng Henry gent 596282 596282 Lemyng, Henry, of Bilburgh, gent 0
5353934 2461293 2461293 defendant Lemyng Robert yeoman 596282 596282 Lemyng, Robert, of Bilburgh, yeoman 3
5356746 2462173 2462173 defendant Lemyng Henry gent 596282 596282 Lemyng, Henry, of Bilburgh, gent 0
5432820 2484783 2484783 defendant Lemyng Robert carrier 596282 596282 Lemyng, Robert, of Bilburgh, carrier 1
5472619 2496778 2496778 defendant Lemyng Robert carrier 596282 596282 Lemyng, Robert, of Bilburgh, carrier 1
5484109 2500181 2500181 defendant Lemyng Henry gent 596282 596282 Lemyng, Henry, of Bilburgh, gent 0
5484110 2500181 2500181 defendant Lemyng Robert carrier 596282 596282 Lemyng, Robert, of Bilburgh, carrier 1
5484121 2500183 2500183 defendant Lemyng Henry gent 596282 596282 Lemyng, Henry, of Bilburgh, gent 0
5484122 2500183 2500183 defendant Lemyng Robert carrier 596282 596282 Lemyng, Robert, of Bilburgh, carrier 1
5484152 2500190 2500190 defendant Lemyng Robert yeoman 596282 596282 Lemyng, Robert, of Bilburgh, yeoman 0
5484153 2500190 2500190 defendant Lemyng Henry gent 596282 596282 Lemyng, Henry, of Bilburgh, gent 1
5521465 2511531 2511531 defendant Norton William gent 596282 596282 Norton, William, of Bilburgh, gent 0
5601664 2535418 2535418 defendant Cuke Thomas husbandman 596282 596282 Cuke, Thomas, of Bilburgh, 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);