names

48 rows where place_id = 612755

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3694882 1924607 1924607 defendant Shreve John clerk 612755 612755 Shreve, John, of Hemmesby, clerk 3
3694884 1924608 1924608 defendant Shreve John clerk 612755 612755 Shreve, John, of Hemmesby, clerk 0
3694885 1924608 1924608 defendant Doke John yeoman 612755 612755 Doke, John, of Hemmesby, yeoman 1
3694886 1924608 1924608 defendant Brown John husbandman 612755 612755 Brown, John, of Hemmesby, husbandman 2
3703635 1927417 1927417 plaintiff Doke John   612755 612755 Doke, John, of Hemmesby 0
3706369 1928281 1928281 defendant Botolff John (legal representative) 612755 612755 Botolff, John, of Hemmesby, yeoman, executrix of 0
3706370 1928281 1928281 defendant Botolff Joan widow 612755 612755 Botolff, Joan, of Hemmesby, widow 1
3715190 1931043 1931043 defendant Doke John yeoman 612755 612755 Doke, John, of Hemmesby, yeoman 1
3720159 1932582 1932582 defendant Dukke John husbandman 612755 612755 Dukke, John, of hemmesby, husbandman 1
4576814 2224256 2224256 defendant Wakeman John   612755 612755 Wakeman, John, of Hemmesby 2
4700843 2265665 2265665 defendant Tommys Robert husbandman 612755 612755 Tommys, Robert, of Hemmesby, husbandman 0
4918967 2332445 2332445 defendant Estgate Philip carpenter 612755 612755 Estgate, Philip, of Hemmesby, carpenter 0
4924069 2333967 2333967 defendant Smyth Richard (legal representative) 612755 612755 Smyth, Richard, of Hemmesby, executors of 0
4924070 2333967 2333967 defendant Rose John shipman 612755 612755 (Rose, John, of Hemmesby, shipman 1
4932665 2336608 2336608 defendant Hay John husbandman 612755 612755 Hay, John, of Hemmesby, husbandman 3
4935310 2337445 2337445 defendant Morey John husbandman 612755 612755 Morey, John, of Hemmesby, husbandman 0
4976105 2349812 2349812 defendant Murray John shipman 612755 612755 Murray, John, of Hemmesby, shipman 1
4976106 2349812 2349812 defendant Kydman John husbandman 612755 612755 Kydman, John, of Hemmesby, husbandman 2
4991008 2354201 2354201 defendant Murray John husbandman 612755 612755 Murray, John, of Hemmesby, husbandman 0
4991009 2354201 2354201 defendant Buxton Henry husbandman 612755 612755 Buxton, Henry, of Hemmesby, husbandman 1
5024030 2363938 2363938 defendant Aleyn Ralph yeoman 612755 612755 Aleyn, Ralph, of Hemmesby, yeoman 1
5080204 2380566 2380566 defendant Symondesson William yeoman 612755 612755 Symondesson, William, of Hemmesby, yeoman 2
5116339 2391210 2391210 defendant Kidman John husbandman 612755 612755 Kidman, John, of Hemmesby, husbandman 0
5217683 2420906 2420906 defendant Aleyn Nicholas yeoman 612755 612755 Aleyn, Nicholas, of Hemmesby, yeoman 0
5217685 2420906 2420906 defendant Wakeman Stephen husbandman 612755 612755 Wakeman, Stephen, of Hemmesby, husbandman 2
5267386 2435565 2435565 defendant Wakeman Stephen husbandman 612755 612755 Wakeman, Stephen, of Hemmesby, husbandman 0
5267387 2435565 2435565 defendant Aleyn Ralph husbandman 612755 612755 Aleyn, Ralph, of Hemmesby, husbandman 1
5267388 2435565 2435565 defendant Blofeld Robert husbandman 612755 612755 Blofeld, Robert, of Hemmesby, husbandman 2
5267389 2435565 2435565 defendant Baldwyn John husbandman 612755 612755 Baldwyn, John, of Hemmesby, husbandman 3
5271949 2436878 2436878 defendant Aleyn Nicholas   612755 612755 Aleyn, Nicholas, of Hemmesby, husbandman, administrators of 0
5271950 2436878 2436878 defendant Aleyn John husbandman 612755 612755 (Aleyn, John, of Hemmesby, husbandman 1
5271952 2436878 2436878 defendant Aleyn Agnes widow 612755 612755 Aleyn, Agnes, of Hemmesby, widow 3
5286417 2441028 2441028 defendant Aleyn Nicholas   612755 612755 Aleyn, Nicholas, of Hemmesby, husbandman, administratos of 0
5286418 2441028 2441028 defendant Aleyn John husbandman 612755 612755 (Aleyn, John, of Hemmesby, husbandman 1
5286419 2441028 2441028 defendant Aleyn Agnes widow 612755 612755 Aleyn, Agnes, of Hemmesby, widow 2
5296782 2444047 2444047 defendant Bonde Richard husbandman 612755 612755 Bonde, Richard, of Hemmesby, husbandman 1
5296784 2444047 2444047 defendant Davy William husbandman 612755 612755 Davy, William, of Hemmesby, husbandman 3
5297995 2444427 2444427 plaintiff Bame Thomas yeoman 612755 612755 Bame, Thomas, of Hemmesby, yeoman 0
5311313 2448413 2448413 defendant Blofeld Robert husbandman 612755 612755 Blofeld, Robert, of Hemmesby, husbandman 0
5318339 2450583 2450583 defendant Kedman William husbandman 612755 612755 Kedman, William, of Hemmesby, husbandman 0
5318349 2450584 2450584 defendant Kedman William husbandman 612755 612755 Kedman, William, of Hemmesby, husbandman 0
5366633 2465215 2465215 plaintiff Sporyll Geoffrey   612755 612755 Sporyll, Geoffrey, of Hemmesby 1
5396829 2474177 2474177 defendant Blofeld Robert husbandman 612755 612755 Blofeld, Robert, of Hemmesby, husbandman 0
5442916 2487793 2487793 defendant Blofeld Robert husbandman 612755 612755 Blofeld, Robert, of Hemmesby, husbandman 0
5514453 2509367 2509367 defendant Wene or Weve John mariner 612755 612755 Wene or Weve, John, of Hemmesby, mariner 1
5554644 2521386 2521386 defendant Threde John laborer 612755 612755 Threde, John, of Hemmesby, laborer 1
5554645 2521386 2521386 defendant Maryot William laborer 612755 612755 Maryot, William, of Hemmesby, laborer 2
5554646 2521386 2521386 defendant Wegge William laborer 612755 612755 Wegge, William, of Hemmesby, 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);