names

25 rows where place_id = 757717

✎ 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
4448175 2184350 2184350 defendant Eston John   757717 757717 Eston, John, of Hawenes 0
4448179 2184351 2184351 defendant Eston John   757717 757717 Eston, John, of Hawenes 0
4535939 2211515 2211515 defendant Stokkere Thomas   757717 757717 Stokkere, Thomas, of Hawenes 0
4539936 2212758 2212758 defendant Crace William   757717 757717 Crace, William, of Hawenes 0
4554623 2217373 2217373 plaintiff Hadham Simon   757717 757717 Hadham, Simon, of Hawenes 0
4565472 2220771 2220771 defendant atte Halle Robert   757717 757717 atte Halle, Robert, of Hawenes 1
4693741 2263544 2263544 defendant Tranell William butcher 757717 757717 Tranell, William, of Hawenes, butcher 0
4754638 2281834 2281834 defendant Lynford William laborer 757717 757717 Lynford, William, of Hawenes, laborer 1
4757667 2282773 2282773 defendant Loryng Robert husbandman 757717 757717 Loryng, Robert, of Hawenes, husbandman 0
4757669 2282773 2282773 defendant Walter Richard husbandman 757717 757717 Walter, Richard, of Hawenes, husbandman 2
4782405 2290504 2290504 defendant Conquest John husbandman 757717 757717 Conquest, John, of Hawenes, husbandman 0
4785052 2291340 2291340 defendant Frankeleyn Thomas yeoman 757717 757717 Frankeleyn, Thomas, of Hawenes, yeoman 0
4785053 2291340 2291340 defendant Smyth Roger husbandman 757717 757717 Smyth, Roger, of Hawenes, husbandman 1
4788083 2292341 2292341 defendant Almond John husbandman 757717 757717 Almond, John, of Hawenes, husbandman 0
4800424 2296313 2296313 defendant atte Halle Robert yeoman 757717 757717 atte Halle, Robert, of Hawenes, yeoman 0
4831613 2305920 2305920 defendant Stonedon John butcher 757717 757717 Stonedon, John, of Hawenes, butcher 0
4832621 2306224 2306224 defendant Stondon John butcher 757717 757717 Stondon, John, of Hawenes, butcher 4
4848930 2311132 2311132 defendant Seweward William husbandman 757717 757717 Seweward, William, of Hawenes, husbandman 0
4859452 2314332 2314332 defendant Stondon John butcher 757717 757717 Stondon, John, of Hawenes, butcher 4
5241592 2427743 2427743 defendant Fitz Thomas skinner 757717 757717 Fitz, Thomas, of Hawenes, skinner 0
5315473 2449693 2449693 defendant Dynsey William husbandman 757717 757717 Dynsey, William, of Hawenes, husbandman 0
5370909 2466489 2466489 defendant Chitwode Roger gent 757717 757717 Chitwode, Roger, of Hawenes, gent 1
5529893 2513854 2513854 defendant Harryson Robert husbandman 757717 757717 Harryson, Robert, of Hawenes, husbandman 2
5531612 2514420 2514420 defendant Swyllyngton John husbandman 757717 757717 Swyllyngton, John, of Hawenes, husbandman 0
5627020 2552419 2552419 defendant Cook Robert yeoman 757717 757717 Cook, Robert, of Hawenes, yeoman 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);