names

31 rows where place_id = 615325

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3708292 1928888 1928888 defendant Rutkyn Henry husbandman 615325 615325 Rutkyn, Henry, of Manton, husbandman 0
3819801 1964074 1964074 plaintiff Parker Richard clerk 615325 615325 Parker, Richard, of Manton, clerk 0
3866871 1979158 1979158 defendant Flemmyng Richard tailor 615325 615325 Flemmyng, Richard, of Manton, tailor 1
3976217 2016247 2016247 defendant Reve alias Goslyng John miller 615325 615325 Reve alias Goslyng, John, of Manton, miller 1
4087202 2055712 2055712 defendant Freman Richard laborer 615325 615325 Freman, Richard, of Manton, laborer 0
4087203 2055712 2055712 defendant Colson Robert laborer 615325 615325 Colson, Robert, of Manton, laborer 1
4116067 2066038 2066038 defendant Wryght John tailor 615325 615325 Wryght, John, of Manton, tailor 0
4181883 2089144 2089144 defendant Greene John gent 615325 615325 Greene, John, of Manton, gent 2
4215609 2100957 2100957 defendant Brodford John husbandman 615325 615325 Brodford, John, of Manton, husbandman 0
4225532 2104394 2104394 defendant Goddarde Richard yeoman 615325 615325 Goddarde, Richard, of Manton, yeoman 0
4225533 2104394 2104394 defendant Chapman alias Hitchcock John husbandman 615325 615325 Chapman alias Hitchcock, John, of Manton, husbandman 1
4274399 2120990 2120990 defendant Bellingham William gent 615325 615325 Bellingham, William, of Manton, gent 0
4589832 2228186 2228186 defendant Kene Lawrence   615325 615325 Kene, Lawrence, of Manton 3
4597465 2230451 2230451 defendant Aleyn John   615325 615325 Aleyn, John, of Manton 1
4650693 2246219 2246219 defendant Wyght John   615325 615325 Wyght, John, of Manton 0
4667653 2255593 2255593 defendant Kele Laurence husbandman 615325 615325 Kele, Laurence, of Manton, husbandman 1
4677171 2258477 2258477 defendant Warner William yeoman 615325 615325 Warner, William, of Manton, yeoman 0
4768376 2286079 2286079 defendant Brigge William husbandman 615325 615325 Brigge, William, of Manton, husbandman 0
4791833 2293547 2293547 defendant Brigge John husbandman 615325 615325 Brigge, John, of Manton, husbandman 0
4836458 2307381 2307381 defendant Roser Richard husbandman 615325 615325 Roser, Richard, of Manton, husbandman 1
4905873 2328439 2328439 defendant Heyward Robert husbandman 615325 615325 Heyward, Robert, of Manton, husbandman 0
4932437 2336540 2336540 plaintiff Whitwell Richard   615325 615325 Whitwell, Richard, of Manton 0
4932438 2336540 2336540 defendant Chamburleyn William   615325 615325 Chamburleyn, William, of Manton, shepherd 0
4994634 2355253 2355253 defendant Crewhit William   615325 615325 Crewhit, William, of Manton, mill ward 1
5026704 2364680 2364680 defendant Bette William husbandman 615325 615325 Bette, William, of Manton, husbandman 2
5070270 2377601 2377601 defendant Fermour John yeoman 615325 615325 Fermour, John, of Manton, yeoman 2
5222901 2422411 2422411 defendant Wattisman William husbandman 615325 615325 Wattisman, William, of Manton, husbandman 1
5295925 2443798 2443798 defendant Wattesman William husbandman 615325 615325 Wattesman, William, of Manton, husbandman 0
5295926 2443798 2443798 defendant Fayrechyld John husbandman 615325 615325 Fayrechyld, John, of Manton, husbandman 1
5295927 2443798 2443798 defendant Philipp John husbandman 615325 615325 Philipp, John, of Manton, husbandman 2
5535006 2515479 2515479 defendant Belyngeham Thomas gent 615325 615325 Belyngeham, Thomas, of Manton, gent 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);