names

58 rows where place_id = 589533

✎ 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
3597887 1866960 1866960 defendant Dyte Thomas husbandman 589533 589533 Dyte, Thomas, of Beteley, husbandman 5
3648012 1909779 1909779 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
3667213 1915681 1915681 defendant Some John, senior yeoman 589533 589533 Some, John, senior, of Beteley, yeoman 0
3673593 1917770 1917770 defendant Woode Oliver   589533 589533 Woode, Oliver, of Beteley, of chaplain 1
3678687 1919399 1919399 defendant Some alias Soham John, senior yeoman 589533 589533 Some alias Soham, John, senior, of Beteley, yeoman 0
3680205 1919881 1919881 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
3692257 1923748 1923748 defendant Some John yeoman 589533 589533 Some, John, of Beteley, yeoman 0
3699745 1926148 1926148 defendant Maybon Nicholas butcher 589533 589533 Maybon, Nicholas, of Beteley, butcher 1
3710014 1929441 1929441 defendant Some John yeoman 589533 589533 Some, John, of Beteley, yeoman 0
3724601 1933975 1933975 defendant Some John yeoman 589533 589533 Some, John, of Beteley, yeoman 0
3734069 1936905 1936905 defendant Some John yeoman 589533 589533 Some, John, of Beteley, yeoman 0
3766521 1947188 1947188 defendant Neve William (legal representative) 589533 589533 Neve, William, of Beteley, executors of 0
3768897 1947922 1947922 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
3781937 1952101 1952101 plaintiff Hewet John clerk 589533 589533 Hewet, John, of Beteley, clerk 0
3784438 1952915 1952915 defendant Neve William (legal representative) 589533 589533 Neve, William, of Beteley, executors of 0
3798622 1957477 1957477 plaintiff Hewet John clerk 589533 589533 Hewet, John, of Beteley, clerk 0
3802496 1958678 1958678 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
3805769 1959749 1959749 defendant Maykyn Nicholas thatcher 589533 589533 Maykyn, Nicholas, of Beteley, thatcher 1
3844738 1971897 1971897 defendant Thyknes John yeoman 589533 589533 Thyknes, John, of Beteley, yeoman 0
3845364 1972110 1972110 defendant Toke Edmund husbandman 589533 589533 Toke, Edmund, of Beteley, husbandman 0
3847599 1972819 1972819 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
3868923 1979849 1979849 plaintiff Tooke Edward   589533 589533 Tooke, Edward, of Beteley 0
3877130 1982592 1982592 plaintiff Hewett John clerk 589533 589533 Hewett, John, of Beteley, clerk 0
3877132 1982593 1982593 plaintiff Hewett John clerk 589533 589533 Hewett, John, of Beteley, clerk 0
3877134 1982594 1982594 plaintiff Hewett John clerk 589533 589533 Hewett, John, of Beteley, clerk 0
3882853 1984530 1984530 defendant Mayken Nicholas butcher 589533 589533 Mayken, Nicholas, of Beteley, butcher 2
3896283 1988968 1988968 plaintiff Tooke Edmund   589533 589533 Tooke, Edmund, of Beteley 0
3948458 2006523 2006523 defendant Gryme Henry husbandman 589533 589533 Gryme, Henry, of Beteley, husbandman 2
3965408 2012513 2012513 defendant Grene Thomas   589533 589533 Grene, Thomas, of Beteley, "knacker" 1
3983418 2018846 2018846 plaintiff Soham Thomas gent 589533 589533 Soham, Thomas, of Beteley, gent 0
3983420 2018847 2018847 plaintiff Soham Thomas, senior gent 589533 589533 Soham, Thomas, senior, of Beteley, gent 0
4062994 2047068 2047068 defendant Hewet Thomas thatcher 589533 589533 Hewet, Thomas, of Beteley, thatcher 0
4074452 2051166 2051166 defendant Bateley Henry gent 589533 589533 Bateley, Henry, of Beteley, gent 0
5009179 2359572 2359572 defendant Pedder Simon husbandman 589533 589533 Pedder, Simon, of Beteley, husbandman 1
5073818 2378656 2378656 defendant Rous Robert husbandman 589533 589533 Rous, Robert, of Beteley, husbandman 4
5082513 2381274 2381274 defendant Pedder John, senior yeoman 589533 589533 Pedder, John, senior, of Beteley, yeoman 0
5082514 2381274 2381274 defendant Pedder William yeoman 589533 589533 Pedder, William, of Beteley, yeoman 1
5082515 2381274 2381274 defendant Pedder John, junior husbandman 589533 589533 Pedder, John, junior, of Beteley, husbandman 2
5146373 2400070 2400070 defendant Hertyng Richard husbandman 589533 589533 Hertyng, Richard, of Beteley, husbandman 0
5166550 2405935 2405935 defendant Hertyng Richard husbandman 589533 589533 Hertyng, Richard, of Beteley, husbandman 0
5437300 2486100 2486100 defendant Batche William husbandman 589533 589533 Batche, William, of Beteley, husbandman 1
5501230 2505324 2505324 defendant Toke Simon yeoman 589533 589533 Toke, Simon, of Beteley, yeoman 1
5501231 2505324 2505324 defendant Hawys John laborer 589533 589533 Hawys, John, of Beteley, laborer 2
5501232 2505324 2505324 defendant Bache William yeoman 589533 589533 Bache, William, of Beteley, yeoman 3
5501233 2505324 2505324 defendant Wodecrosse Adam yeoman 589533 589533 Wodecrosse, Adam, of Beteley, yeoman 4
5501234 2505324 2505324 defendant Hamond William yeoman 589533 589533 Hamond, William, of Beteley, yeoman 5
5501740 2505477 2505477 defendant Batche William husbandman 589533 589533 Batche, William, of Beteley, husbandman 0
5501741 2505477 2505477 defendant Batche Henry laborer 589533 589533 Batche, Henry, of Beteley, laborer 1
5535155 2515522 2515522 defendant Batche Henry husbandman 589533 589533 Batche, Henry, of Beteley, husbandman 3
5573990 2526955 2526955 defendant Toke Simon (legal representative) 589533 589533 Toke, Simon, of Beteley, husbandman, executors of 2
5573991 2526955 2526955 defendant Bysshopp John clerk 589533 589533 (Bysshopp, John, of Beteley, clerk 3
5573992 2526955 2526955 defendant Toke Edmund husbandman 589533 589533 Toke, Edmund, of Beteley, husbandman 4
5576914 2527823 2527823 defendant Bysshop John clerk 589533 589533 Bysshop, John, of Beteley, clerk 0
5579817 2528767 2528767 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
5595377 2533500 2533500 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
5600501 2535043 2535043 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
5603827 2536064 2536064 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
5605436 2536579 2536579 plaintiff Sohame John yeoman 589533 589533 Sohame, John, of Beteley, yeoman 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);