names

19 rows where place_id = 755099

✎ 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
4425627 2172834 2172834 defendant Geffraysone John   755099 755099 Geffraysone, John, of Neuburgh 11
4425631 2172834 2172834 defendant Lang William   755099 755099 Lang, William, of Neuburgh 15
4425632 2172834 2172834 defendant Lang John   755099 755099 Lang, John, of Neuburgh 16
4425649 2172835 2172835 defendant Geffraysone John   755099 755099 Geffraysone, John, of Neuburgh 11
4425653 2172835 2172835 defendant Lang William   755099 755099 Lang, William, of Neuburgh 15
4425654 2172835 2172835 defendant Lang John   755099 755099 Lang, John, of Neuburgh 16
4435064 2175727 2175727 defendant Geffraysone John   755099 755099 Geffraysone, John, of Neuburgh 12
4435067 2175727 2175727 defendant Lang William   755099 755099 Lang, William, of Neuburgh 15
4435068 2175727 2175727 defendant Lang John   755099 755099 Lang, John, of Neuburgh 16
4473927 2192501 2192501 plaintiff de la Pole Cecily   755099 755099 de la Pole, Cecily, of Neuburgh, formerly wife of John de la Pole, knight 0
4497013 2199728 2199728 defendant Hunt Stephen   755099 755099 Hunt, Stephen, of Neuburgh 0
4728308 2274099 2274099 defendant Watson John   755099 755099 Watson, John, of Neuburgh, cart wright 0
4808722 2298895 2298895 defendant Sparry Richard yeoman 755099 755099 Sparry, Richard, of Neuburgh, yeoman 0
4869550 2317442 2317442 defendant Bank John   755099 755099 Bank, John, of Neuburgh, organ player 0
4869557 2317442 2317442 defendant Spence Robert yeoman 755099 755099 Spence, Robert, of Neuburgh, yeoman 7
5219456 2421416 2421416 defendant Craunce Richard carpenter 755099 755099 Craunce, Richard, of Neuburgh, carpenter 0
5286737 2441128 2441128 defendant Jonson John husbandman 755099 755099 Jonson, John, of Neuburgh, husbandman 0
5521746 2511614 2511614 defendant Wyghall Robert gent 755099 755099 Wyghall, Robert, of Neuburgh, gent 2
5521747 2511614 2511614 defendant Danby Robert laborer 755099 755099 Danby, Robert, of Neuburgh, laborer 3

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