names

25 rows where place_id = 759426

✎ 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
4461407 2188650 2188650 plaintiff Stapelton Helen de   759426 759426 Stapelton, Helen de, of Hugate, formerly wife of John de Stapelton 0
4461408 2188650 2188650 defendant atte Mare John   759426 759426 atte Mare, John, of Hugate 0
4469511 2191128 2191128 defendant atte Marre John   759426 759426 atte Marre, John, of Hugate 2
4490794 2197822 2197822 defendant Gerge William   759426 759426 Gerge, William, of Hugate 0
4503494 2201663 2201663 defendant Holme Thomas   759426 759426 Holme, Thomas, of Hugate 0
4564502 2220461 2220461 defendant atte Marre John   759426 759426 atte Marre, John, of Hugate 4
4591086 2228568 2228568 defendant Gerge William   759426 759426 Gerge, William, of Hugate 2
4614138 2235432 2235432 defendant Vance William   759426 759426 Vance, William, of Hugate 2
4639806 2243148 2243148 plaintiff Crosse William   759426 759426 Crosse, William, of Hugate, parson 0
4698331 2264956 2264956 plaintiff Cros William   759426 759426 Cros, William, of Hugate, rector 0
4698332 2264956 2264956 defendant Wayte John chaplain 759426 759426 Wayte, John, of Hugate, chaplain 0
4705828 2267196 2267196 defendant Cook Thomas   759426 759426 Cook, Thomas, of Hugate, shepherd 0
4928524 2335348 2335348 defendant Hode John smith 759426 759426 Hode, John, of Hugate, smith 0
5028512 2365215 2365215 defendant Mason Robert husbandman 759426 759426 Mason, Robert, of Hugate, husbandman 1
5038070 2368019 2368019 defendant Marre Thomas gent 759426 759426 Marre, Thomas, of Hugate, gent 0
5123571 2393349 2393349 defendant Shelcok Thomas husbandman 759426 759426 Shelcok, Thomas, of Hugate, husbandman 1
5274378 2437586 2437586 defendant Richerdson Robert yeoman 759426 759426 Richerdson, Robert, of Hugate, yeoman 3
5355206 2461699 2461699 defendant Burnby Richard husbandman 759426 759426 Burnby, Richard, of Hugate, husbandman 0
5496267 2503786 2503786 defendant Hall Thomas husbandman 759426 759426 Hall, Thomas, of Hugate, husbandman 0
5496268 2503786 2503786 defendant Kirkeby Thomas husbandman 759426 759426 Kirkeby, Thomas, of Hugate, husbandman 1
5496269 2503786 2503786 defendant Sharpe William husbandman 759426 759426 Sharpe, William, of Hugate, husbandman 2
5496270 2503786 2503786 defendant Johnson Alexander husbandman 759426 759426 Johnson, Alexander, of Hugate, husbandman 3
5496271 2503786 2503786 defendant Burnby Richard husbandman 759426 759426 Burnby, Richard, of Hugate, husbandman 4
5496272 2503786 2503786 defendant Warde William husbandman 759426 759426 Warde, William, of Hugate, husbandman 5
5628964 2553028 2553028 defendant Gerge William husbandman 759426 759426 Gerge, William, of Hugate, husbandman 1

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