names

77 rows where place_id = 592053

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606418 1869674 1869674 defendant Wylly Walter clerk 592053 592053 Wylly, Walter, of Pekham, clerk 0
3611385 1871235 1871235 defendant Mustchamp Thomas gent 592053 592053 Mustchamp, Thomas, of Pekham, gent 0
3613380 1871830 1871830 defendant Plumpton John laborer 592053 592053 Plumpton, John, of Pekham, laborer 2
3625460 1875501 1875501 defendant Edall Richard husbandman 592053 592053 Edall, Richard, of Pekham, husbandman 0
3626582 1903167 1903167 defendant Hankys or Haukys Robert yeoman 592053 592053 Hankys or Haukys, Robert, of Pekham, yeoman 1
3640868 1907588 1907588 defendant Hunt John husbandman 592053 592053 Hunt, John, of Pekham, husbandman 0
3645658 1909042 1909042 defendant Webster John husbandman 592053 592053 Webster, John, of Pekham, husbandman 0
3647370 1909564 1909564 defendant Lane Richard yeoman 592053 592053 Lane, Richard, of Pekham, yeoman 0
3647372 1909565 1909565 defendant Lane Richard yeoman 592053 592053 Lane, Richard, of Pekham, yeoman 0
3647374 1909566 1909566 defendant Lane Richard, senior yeoman 592053 592053 Lane, Richard, senior, of Pekham, yeoman 0
3647375 1909566 1909566 defendant Lane Richard, junior husbandman 592053 592053 Lane, Richard, junior, of Pekham, husbandman 1
3647376 1909566 1909566 defendant Garette Thomas laborer 592053 592053 Garette, Thomas, of Pekham, laborer 2
3650649 1910568 1910568 defendant Lane Richard, senior yeoman 592053 592053 Lane, Richard, senior, of Pekham, yeoman 0
3650650 1910568 1910568 defendant Lane Richard, junior husbandman 592053 592053 Lane, Richard, junior, of Pekham, husbandman 1
3650651 1910568 1910568 defendant Garette Thomas laborer 592053 592053 Garette, Thomas, of Pekham, laborer 2
3676976 1918835 1918835 defendant Lane Richard yeoman of the crown 592053 592053 Lane, Richard, of Pekham, yeoman of the crown 0
3707239 1928555 1928555 defendant Hunt John husbandman 592053 592053 Hunt, John, of Pekham, husbandman 0
3729343 1935430 1935430 defendant Symond Richard laborer 592053 592053 Symond, Richard, of Pekham, laborer 3
3782656 1952317 1952317 defendant Smale William yeoman 592053 592053 Smale, William, of Pekham, yeoman 0
3782657 1952317 1952317 defendant Dalton John laborer 592053 592053 Dalton, John, of Pekham, laborer 1
3853695 1974787 1974787 defendant Wod Henry husbandman 592053 592053 Wod, Henry, of Pekham, husbandman 3
3865444 1978659 1978659 defendant Clogg alias Plogg Richard husbandman 592053 592053 Clogg alias Plogg, Richard, of Pekham, husbandman 0
3994752 2022876 2022876 defendant Pattenden Henry yeoman 592053 592053 Pattenden, Henry, of Pekham, yeoman 0
3994753 2022876 2022876 defendant Pattenden John yeoman 592053 592053 Pattenden, John, of Pekham, yeoman 1
3994754 2022876 2022876 defendant Pattenden Ralph yeoman 592053 592053 Pattenden, Ralph, of Pekham, yeoman 2
4445418 2183517 2183517 defendant Lokeman William   592053 592053 Lokeman, William, of Pekham 0
4489703 2197495 2197495 defendant Pyper Bartholomew   592053 592053 Pyper, Bartholomew, of Pekham 8
4489704 2197495 2197495 defendant Iryssh William   592053 592053 Iryssh, William, of Pekham 9
4490821 2197828 2197828 defendant Pyper Bartholomew   592053 592053 Pyper, Bartholomew, of Pekham 8
4490822 2197828 2197828 defendant Iryssh William   592053 592053 Iryssh, William, of Pekham 9
4491820 2198120 2198120 defendant Iryssh William   592053 592053 Iryssh, William, of Pekham 8
4559581 2218948 2218948 defendant Mannyng John   592053 592053 Mannyng, John, of Pekham 0
4565442 2220760 2220760 defendant Payn John   592053 592053 Payn, John, of Pekham 0
4570549 2222362 2222362 defendant Turk John   592053 592053 Turk, John, of Pekham 0
4572667 2222990 2222990 defendant Clerk John   592053 592053 Clerk, John, of Pekham 1
4620759 2237475 2237475 defendant Apuldre John   592053 592053 Apuldre, John, of Pekham 2
4620761 2237475 2237475 defendant Bocher John   592053 592053 Bocher, John, of Pekham 4
4620766 2237476 2237476 defendant Apuldre John   592053 592053 Apuldre, John, of Pekham 3
4652150 2246610 2246610 defendant Pertrych William cordwainer 592053 592053 Pertrych, William, of Pekham, cordwainer 5
4688783 2262047 2262047 defendant Broke Thomas laborer 592053 592053 Broke, Thomas, of Pekham, laborer 0
4701774 2265954 2265954 defendant Drynkewater John husbandman 592053 592053 Drynkewater, John, of Pekham, husbandman 0
4909017 2329363 2329363 plaintiff Baker Richard   592053 592053 Baker, Richard, of Pekham 0
4967693 2347282 2347282 defendant Haweke Robert brewer 592053 592053 Haweke, Robert, of Pekham, brewer 0
4971631 2348444 2348444 defendant Sandhirst Richard butcher 592053 592053 Sandhirst, Richard, of Pekham, butcher 0
5058998 2374255 2374255 defendant Webbe William husbandman 592053 592053 Webbe, William, of Pekham, husbandman 0
5067351 2376742 2376742 defendant Baker Richard yeoman 592053 592053 Baker, Richard, of Pekham, yeoman 0
5067450 2376765 2376765 defendant Gaille John laborer 592053 592053 Gaille, John, of Pekham, laborer 1
5075661 2379220 2379220 defendant Wylde John yeoman 592053 592053 Wylde, John, of Pekham, yeoman 1
5115070 2390825 2390825 defendant Jancok Gilbert miller 592053 592053 Jancok, Gilbert, of Pekham, miller 0
5124583 2393655 2393655 defendant Baille John laborer 592053 592053 Baille, John, of Pekham, laborer 1
5130575 2395428 2395428 plaintiff Fallan William   592053 592053 Fallan, William, of Pekham, rector 0
5141019 2398495 2398495 defendant atte Wode William husbandman 592053 592053 atte Wode, William, of Pekham, husbandman 1
5150011 2401136 2401136 plaintiff Fallan William   592053 592053 Fallan, William, of Pekham, parson & rector 0
5185255 2411434 2411434 defendant Drynkwater John husbandman 592053 592053 Drynkwater, John, of Pekham, husbandman 3
5193015 2413684 2413684 defendant Gaille John laborer 592053 592053 Gaille, John, of Pekham, laborer 1
5204492 2417066 2417066 plaintiff Fallan William   592053 592053 Fallan, William, of Pekham, parson & rector 0
5204732 2417128 2417128 defendant Drynkwater John husbandman 592053 592053 Drynkwater, John, of Pekham, husbandman 3
5216413 2420532 2420532 defendant Gryme John yeoman 592053 592053 Gryme, John, of Pekham, yeoman 1
5216417 2420533 2420533 defendant Fostell Thomas yeoman 592053 592053 Fostell, Thomas, of Pekham, yeoman 2
5242290 2427949 2427949 defendant Hankes Robert husbandman 592053 592053 Hankes, Robert, of Pekham, husbandman 1
5242291 2427949 2427949 defendant Gryme John husbandman 592053 592053 Gryme, John, of Pekham, husbandman 2
5242292 2427949 2427949 defendant Sampson John husbandman 592053 592053 Sampson, John, of Pekham, husbandman 3
5252277 2430821 2430821 defendant Forstall Thomas yeoman 592053 592053 Forstall, Thomas, of Pekham, yeoman 0
5252279 2430822 2430822 defendant Forstall Thomas yeoman 592053 592053 Forstall, Thomas, of Pekham, yeoman 0
5257745 2432541 2432541 defendant Messanger Thomas husbandman 592053 592053 Messanger, Thomas, of Pekham, husbandman 0
5322033 2451660 2451660 defendant Skynner Richard gent 592053 592053 Skynner, Richard, of Pekham, gent 0
5322740 2451877 2451877 defendant Westrey Nicholas laborer 592053 592053 Westrey, Nicholas, of Pekham, laborer 2
5331538 2454508 2454508 defendant Messenger Thomas yeoman 592053 592053 Messenger, Thomas, of Pekham, yeoman 0
5449319 2489686 2489686 defendant Clopham Alan husbandman 592053 592053 Clopham, Alan, of Pekham, husbandman 0
5560153 2522933 2522933 plaintiff Skynner Agnes (legal representative) 592053 592053 Skynner, Agnes, of Pekham, widow, administrator of 0
5571498 2526218 2526218 defendant Neell John husbandman 592053 592053 Neell, John, of Pekham, husbandman 0
5594085 2533127 2533127 defendant Legh Roger gent 592053 592053 Legh, Roger, of Pekham, gent 0
5594086 2533127 2533127 defendant Pylkyngton William laborer 592053 592053 Pylkyngton, William, of Pekham, laborer 1
5594087 2533127 2533127 defendant Gryme John laborer 592053 592053 Gryme, John, of Pekham, laborer 2
5596863 2533938 2533938 defendant Idall Richard yeoman 592053 592053 Idall, Richard, of Pekham, yeoman 3
5612792 2547755 2547755 defendant Ode William   592053 592053 Ode, William, of Pekham 0
5612795 2547756 2547756 defendant Ode William   592053 592053 Ode, William, of Pekham 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);