names

32 rows where place_id = 770325

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4567010 2221238 2221238 defendant Martynson John   770325 770325 Martynson, John, of Qwaplode 0
4594528 2229546 2229546 plaintiff Porter John, sen   770325 770325 Porter, John, sen, of Qwaplode 0
4594529 2229546 2229546 defendant Storme William   770325 770325 Storme, William, of Qwaplode 0
4594531 2229546 2229546 defendant Champeneys William   770325 770325 Champeneys, William, of Qwaplode 2
4697103 2264571 2264571 defendant Cartwryght William   770325 770325 Cartwryght, William, of Qwaplode, cart wright 0
4697104 2264571 2264571 defendant Kyng Fulk husbandman 770325 770325 Kyng, Fulk, of Qwaplode, husbandman 1
4697105 2264571 2264571 defendant Biller William husbandman 770325 770325 Biller, William, of Qwaplode, husbandman 2
4698518 2265011 2265011 defendant Blakewell Alan yeoman 770325 770325 Blakewell, Alan, of Qwaplode, yeoman 0
4702447 2266175 2266175 defendant Blakewell Alan husbandman 770325 770325 Blakewell, Alan, of Qwaplode, husbandman 2
4706599 2267444 2267444 defendant Lyttester William yeoman 770325 770325 Lyttester, William, of Qwaplode, yeoman 0
4764724 2284955 2284955 defendant Clerk Walter husbandman 770325 770325 Clerk, Walter, of Qwaplode, husbandman 0
4827427 2304627 2304627 defendant Gannill Simon husbandman 770325 770325 Gannill, Simon, of Qwaplode, husbandman 0
4827428 2304627 2304627 defendant Prowet John husbandman 770325 770325 Prowet, John, of Qwaplode, husbandman 1
4827429 2304627 2304627 defendant Peresson Walter yeoman 770325 770325 Peresson, Walter, of Qwaplode, yeoman 2
4827430 2304627 2304627 defendant Skarlet John husbandman 770325 770325 Skarlet, John, of Qwaplode, husbandman 3
4904324 2327972 2327972 defendant Scarlet Alan husbandman 770325 770325 Scarlet, Alan, of Qwaplode, husbandman 0
5054754 2372998 2372998 plaintiff Gould John   770325 770325 Gould, John, of Qwaplode 3
5054755 2372998 2372998 defendant Calowe William gent 770325 770325 Calowe, William, of Qwaplode, gent 0
5058386 2374055 2374055 defendant Bygotte Richard husbandman 770325 770325 Bygotte, Richard, of Qwaplode, husbandman 4
5058387 2374055 2374055 defendant Wryght Thomas husbandman 770325 770325 Wryght, Thomas, of Qwaplode, husbandman 5
5058388 2374055 2374055 defendant Leke Simon husbandman 770325 770325 Leke, Simon, of Qwaplode, husbandman 6
5058389 2374055 2374055 defendant Hobard Robert husbandman 770325 770325 Hobard, Robert, of Qwaplode, husbandman 7
5061833 2375137 2375137 plaintiff Haltoft William   770325 770325 Haltoft, William, of Qwaplode 0
5131240 2395624 2395624 defendant Golyd William, senior husbandman 770325 770325 Golyd, William, senior, of Qwaplode, husbandman 1
5150757 2401365 2401365 defendant Golye William, sen husbandman 770325 770325 Golye, William, sen, of Qwaplode, husbandman 1
5175987 2408661 2408661 defendant Pynchebek Gilbert gent 770325 770325 Pynchebek, Gilbert, of Qwaplode, gent 0
5286022 2440923 2440923 defendant Tomson Robert   770325 770325 Tomson, Robert, of Qwaplode, husbandma 0
5434439 2485240 2485240 defendant Daweson Gilbert husbandman 770325 770325 Daweson, Gilbert, of qwaplode, husbandman 1
5479262 2498814 2498814 defendant Andrewe Robert gent 770325 770325 Andrewe, Robert, of Qwaplode, gent 0
5479448 2498870 2498870 defendant Knobyll William husbandman 770325 770325 Knobyll, William, of Qwaplode, husbandman 0
5488505 2501449 2501449 defendant Filpot John yeoman 770325 770325 Filpot, John, of Qwaplode, yeoman 4
5488506 2501449 2501449 defendant Dymmok Hugh yeoman 770325 770325 Dymmok, Hugh, of Qwaplode, yeoman 5

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