names

43 rows where place_id = 609641

✎ 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
3679502 1919659 1919659 defendant Rogger William husbandman 609641 609641 Rogger, William, of Otteford, husbandman 0
3714215 1930745 1930745 plaintiff Barton John   609641 609641 Barton, John, of Otteford 0
3717013 1931607 1931607 defendant Maundy Richard   609641 609641 Maundy, Richard, of Otteford, mason 0
3729553 1935491 1935491 defendant Hammyng John husbandman 609641 609641 Hammyng, John, of Otteford, husbandman 0
3729554 1935491 1935491 defendant Hammyng John, senior yeoman 609641 609641 Hammyng, John, senior, of Otteford, yeoman 1
3729555 1935491 1935491 defendant Hammyng John, junior laborer 609641 609641 Hammyng, John, junior, of Otteford, laborer 2
3729556 1935491 1935491 defendant Barton Edmund miller 609641 609641 Barton, Edmund, of Otteford, miller 3
3767327 1947426 1947426 plaintiff Multon Robert, senior yeoman 609641 609641 Multon, Robert, senior, of Otteford, yeoman 0
3767329 1947427 1947427 plaintiff Multon Robert, senior yeoman 609641 609641 Multon, Robert, senior, of Otteford, yeoman 0
3850388 1973711 1973711 defendant Whyte Richard yeoman 609641 609641 Whyte, Richard, of Otteford, yeoman 0
4480322 2194510 2194510 defendant Bowchere John   609641 609641 Bowchere, John, of Otteford 0
4509705 2203518 2203518 defendant Caryng John   609641 609641 Caryng, John, of Otteford 0
4588269 2227723 2227723 plaintiff Kierll William   609641 609641 Kierll, William, of Otteford 0
4588273 2227724 2227724 plaintiff Kierll William   609641 609641 Kierll, William, of Otteford 0
4613501 2235240 2235240 defendant Beche John   609641 609641 Beche, John, of Otteford 1
4629451 2240140 2240140 defendant Couper Robert   609641 609641 Couper, Robert, of Otteford 0
4671906 2256860 2256860 defendant Colyn John   609641 609641 Colyn, John, of Otteford 0
4725629 2273303 2273303 defendant Roweshawe John   609641 609641 Roweshawe, John, of Otteford, park man 0
4732354 2275297 2275297 defendant Flaundrys John laborer 609641 609641 Flaundrys, John, of Otteford, laborer 0
4806918 2298370 2298370 defendant Edolf John clerk 609641 609641 Edolf, John, of Otteford, clerk 1
4806921 2298371 2298371 defendant Edolf John clerk 609641 609641 Edolf, John, of Otteford, clerk 1
4927233 2334953 2334953 defendant Cotyere John husbandman 609641 609641 Cotyere, John, of Otteford, husbandman 3
4953685 2343064 2343064 defendant Dryvere John, junior husbandman 609641 609641 Dryvere, John, junior, of Otteford, husbandman 0
4977656 2350283 2350283 defendant Dryver John tanner 609641 609641 Dryver, John, of Otteford, tanner 2
5005389 2358477 2358477 defendant Dyere William husbandman 609641 609641 Dyere, William, of Otteford, husbandman 2
5005404 2358480 2358480 defendant Dyere William husbandman 609641 609641 Dyere, William, of Otteford, husbandman 2
5048650 2371234 2371234 defendant Ailnoth William butcher 609641 609641 Ailnoth, William, of Otteford, butcher 4
5105470 2388042 2388042 defendant Gardyner Thomas husbandman 609641 609641 Gardyner, Thomas, of Otteford, husbandman 0
5116559 2391275 2391275 plaintiff Palmer John gent 609641 609641 Palmer, John, of Otteford, gent 0
5136711 2397260 2397260 defendant Boselworth Richard chaplain 609641 609641 Boselworth, Richard, of Otteford, chaplain 1
5145209 2399739 2399739 defendant Couper John husbandman 609641 609641 Couper, John, of Otteford, husbandman 0
5157278 2403268 2403268 defendant Barnard Joan   609641 609641 Barnard, Joan, of Otteford, widow, formerly wife of John 0
5157279 2403268 2403268 defendant Beselworth Richard chaplain 609641 609641 Beselworth, Richard, of Otteford, chaplain 1
5186221 2411719 2411719 defendant Couper John husbandman 609641 609641 Couper, John, of Otteford, husbandman 0
5195225 2414350 2414350 defendant Couper John husbandman 609641 609641 Couper, John, of Otteford, husbandman 0
5205122 2417256 2417256 defendant Couper John husbandman 609641 609641 Couper, John, of Otteford, husbandman 0
5209164 2418409 2418409 defendant Couper John husbandman 609641 609641 Couper, John, of Otteford, husbandman 0
5222479 2422289 2422289 defendant Gardener John yeoman 609641 609641 Gardener, John, of Otteford, yeoman 2
5273756 2437405 2437405 defendant Doraunt John butcher 609641 609641 Doraunt, John, of Otteford, butcher 3
5390509 2472349 2472349 defendant Bewyk Walter laborer 609641 609641 Bewyk, Walter, of Otteford, laborer 0
5475848 2497780 2497780 defendant Rogger William (legal representative) 609641 609641 Rogger, William, of Otteford, brewer, executors of 0
5545218 2518602 2518602 defendant Rompney Richard husbandman 609641 609641 Rompney, Richard, of Otteford, husbandman 1
5623751 2551368 2551368 plaintiff Kierle William   609641 609641 Kierle, William, of Otteford 0

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