names

42 rows where place_id = 596474

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624931 1875331 1875331 defendant Cooke Richard husbandman 596474 596474 Cooke, Richard, of Est Bekham, husbandman 0
3624932 1875331 1875331 defendant Cooke William husbandman 596474 596474 Cooke, William, of Est Bekham, husbandman 1
3652205 1911030 1911030 defendant Gonnour Richard gent 596474 596474 Gonnour, Richard, of Est Bekham, gent 0
3690076 1923057 1923057 defendant Gunnour Richard gent 596474 596474 Gunnour, Richard, of Est Bekham, gent 0
3707083 1928503 1928503 defendant Gonner Richard gent 596474 596474 Gonner, Richard, of Est Bekham, gent 0
3720102 1932563 1932563 defendant Gonnour Richard gent 596474 596474 Gonnour, Richard, of Est Bekham, gent 1
3782077 1952149 1952149 defendant Gunnor Richard gent 596474 596474 Gunnor, Richard, of Est Bekham, gent 0
3816049 1962920 1962920 defendant Dukke Robert butcher 596474 596474 Dukke, Robert, of Est Bekham, butcher 0
3874668 1981746 1981746 defendant Pygeon Thomas gent 596474 596474 Pygeon, Thomas, of Est Bekham, gent 0
3885646 1985456 1985456 plaintiff Beston Nicholas (legal representative) 596474 596474 Beston, Nicholas, of Est Bekham, executors of 0
3885650 1985456 1985456 defendant Pygeon Thomas gent 596474 596474 Pygeon, Thomas, of Est Bekham, gent 0
3908159 1993026 1993026 defendant Beston Joan widow 596474 596474 Beston, Joan, of Est Bekham, widow 0
3908160 1993026 1993026 defendant Beston Robert laborer 596474 596474 Beston, Robert, of Est Bekham, laborer 1
3921400 1997499 1997499 defendant Beston Joan widow 596474 596474 Beston, Joan, of Est Bekham, widow 0
3921401 1997499 1997499 defendant Beston Robert laborer 596474 596474 Beston, Robert, of Est Bekham, laborer 1
3921404 1997500 1997500 defendant West John tailor 596474 596474 West, John, of Est Bekham, tailor 1
4739392 2277404 2277404 defendant Curson John butcher 596474 596474 Curson, John, of East Bekham, butcher 0
4744706 2278969 2278969 defendant Catoe John husbandman 596474 596474 Catoe, John, of East Bekham, husbandman 0
4956228 2343822 2343822 defendant Gonore William gent 596474 596474 Gonore, William, of Est Bekham, gent 0
4956229 2343822 2343822 defendant Gonore Simon gent 596474 596474 Gonore, Simon, of Est Bekham, gent 1
4956233 2343823 2343823 defendant Gonore Simon gent 596474 596474 Gonore, Simon, of Est Bekham, gent 0
4976543 2349944 2349944 defendant Maryot John widow 596474 596474 Maryot, John, of Est Bekham, franklin, son of Maryot, Joan, of Crowemere, widow 0
4987522 2353224 2353224 defendant Maryot John   596474 596474 Maryot, John, of East Bekham, franklin, son of William & Joan Maryot, of Crowmere 0
5003490 2357916 2357916 defendant Maryot John   596474 596474 Maryot, John, of East Bekham, franklin, son of William & Joan Maryot, of Crowmere 0
5025038 2364223 2364223 defendant Gunnore Simon gent 596474 596474 Gunnore, Simon, of Est Bekham, gent 0
5092540 2384196 2384196 defendant Gunnore Simon gent 596474 596474 Gunnore, Simon, of Est Bekham, gent 0
5103600 2387479 2387479 defendant Gunnore Simon gent 596474 596474 Gunnore, Simon, of Est Bekham, gent 1
5222719 2422361 2422361 defendant Gonore Simon gent 596474 596474 Gonore, Simon, of Est Bekham, gent 0
5240043 2427290 2427290 defendant Gunnore Simon gent 596474 596474 Gunnore, Simon, of Est Bekham, gent 0
5242782 2428093 2428093 defendant Gonore Simon gent 596474 596474 Gonore, Simon, of Est Bekham, gent 0
5253028 2431053 2431053 defendant Gunnore Simon gent 596474 596474 Gunnore, Simon, of Est Bekham, gent 0
5254317 2431479 2431479 defendant Gunnore Simon gent 596474 596474 Gunnore, Simon, of Est Bekham, gent 0
5259488 2433089 2433089 defendant Maryot John gent 596474 596474 Maryot, John, of Est Bekham, gent 0
5286605 2441092 2441092 defendant Langdon Thomas yeoman 596474 596474 Langdon, Thomas, of Est Bekham, yeoman 3
5330343 2454150 2454150 defendant Maryet John gent 596474 596474 Maryet, John, of Est Bekham, gent 4
5335990 2455838 2455838 plaintiff Gunnore Simon   596474 596474 Gunnore, Simon, of Est Bekham 0
5418774 2480539 2480539 defendant Emnour Simon gent 596474 596474 Emnour, Simon, of East Bekham, gent 4
5427595 2483208 2483208 plaintiff Enmore Simon   596474 596474 Enmore, Simon, of East Bekham 0
5458038 2492306 2492306 plaintiff Emnore Simon   596474 596474 Emnore, Simon, of East Bekham 0
5482132 2499597 2499597 plaintiff Gunnour Simon   596474 596474 Gunnour, Simon, of Est Bekham 0
5484625 2500326 2500326 defendant Capron Richard yeoman 596474 596474 Capron, Richard, of Est Bekham, yeoman 0
5484811 2500380 2500380 defendant Capron Richard yeoman 596474 596474 Capron, Richard, of Est Bekham, yeoman 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);