names

20 rows where place_id = 603968

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656412 1912250 1912250 defendant Palady John husbandman 603968 603968 Palady, John, of Rowell, husbandman 3
3740228 1938801 1938801 defendant Forstrete William husbandman 603968 603968 Forstrete, William, of Rowell, husbandman 2
3740229 1938801 1938801 defendant Forstrete Thomas husbandman 603968 603968 Forstrete, Thomas, of Rowell, husbandman 3
3741656 1939259 1939259 defendant Trymmell John yeoman 603968 603968 Trymmell, John, of Rowell, yeoman 0
3818424 1963661 1963661 defendant Skynner John husbandman 603968 603968 Skynner, John, of Rowell, husbandman 0
3818425 1963661 1963661 defendant Skynner Thomas chandler 603968 603968 Skynner, Thomas, of Rowell, chandler 1
3827824 1966567 1966567 defendant Blaklesley Henry husbandman 603968 603968 Blaklesley, Henry, of Rowell, husbandman 2
3908570 1993164 1993164 defendant Bordon Henry innholder 603968 603968 Bordon, Henry, of Rowell, innholder 0
4344585 2145385 2145385 defendant Atkyns Ralph vintner 603968 603968 Atkyns, Ralph, of Rowell, vintner 0
4408839 2167555 2167555 defendant Atkyns Ralph   603968 603968 Atkyns, Ralph, of Rowell, Nhants vintner 2
4958626 2344548 2344548 defendant Canun Thomas laborer 603968 603968 Canun, Thomas, of Rowell, laborer 0
4963609 2346032 2346032 defendant Boveton John husbandman 603968 603968 Boveton, John, of Rowell, husbandman 1
5222723 2422363 2422363 defendant Burdon Henry husbandman 603968 603968 Burdon, Henry, of Rowell, husbandman 0
5224780 2422916 2422916 defendant Thorp Thomas butcher 603968 603968 Thorp, Thomas, of Rowell, butcher 3
5237896 2426666 2426666 defendant Colham Thomas corveser 603968 603968 Colham, Thomas, of Rowell, corveser 2
5242469 2428005 2428005 defendant Horshill William chaplain 603968 603968 Horshill, William, of Rowell, chaplain 0
5242471 2428006 2428006 defendant Horshill William chaplain 603968 603968 Horshill, William, of Rowell, chaplain 0
5272433 2437009 2437009 defendant Racheford John carpenter 603968 603968 Racheford, John, of Rowell, carpenter 0
5357726 2462485 2462485 defendant Span John husbandman 603968 603968 Span, John, of Rowell, husbandman 0
5431210 2484278 2484278 defendant Edryche Richard tailor 603968 603968 Edryche, Richard, of Rowell, tailor 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);