names

58 rows where place_id = 587366

✎ 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
3591216 1864878 1864878 defendant Holder William yeoman 587366 587366 Holder, William, of Est Brent, yeoman 0
3670391 1916694 1916694 defendant Yong John husbandman 587366 587366 Yong, John, of Est Brent, husbandman 1
3690796 1923286 1923286 defendant Wyngod Richard husbandman 587366 587366 Wyngod, Richard, of Est Brent, husbandman 0
3690797 1923286 1923286 defendant Wyngod William laborer 587366 587366 Wyngod, William, of Est Brent, laborer 1
3690798 1923286 1923286 defendant Symmers Nicholas husbandman 587366 587366 Symmers, Nicholas, of Est Brent, husbandman 2
3701667 1926762 1926762 defendant Yong John husbandman 587366 587366 Yong, John, of Est Brent, husbandman 3
3729039 1935331 1935331 defendant Yong John yeoman 587366 587366 Yong, John, of Est Brent, yeoman 0
3789157 1954419 1954419 defendant Jenatt William carpenter 587366 587366 Jenatt, William, of Est Brent, carpenter 0
3791524 1955188 1955188 defendant Yong John husbandman 587366 587366 Yong, John, of Est Brent, husbandman 0
3791525 1955188 1955188 defendant Cooke Richard husbandman 587366 587366 Cooke, Richard, of Est Brent, husbandman 1
3791526 1955188 1955188 defendant Ticke John husbandman 587366 587366 Ticke, John, of Est Brent, husbandman 2
3793756 1955912 1955912 defendant Yong John husbandman 587366 587366 Yong, John, of Est Brent, husbandman 0
3925433 1998819 1998819 defendant Haggett Christopher yeoman 587366 587366 Haggett, Christopher, of Est Brent, yeoman 0
3939702 2003582 2003582 defendant Keme Thomas husbandman 587366 587366 Keme, Thomas, of East Brent, husbandman 2
4014196 2029804 2029804 plaintiff Ballett or Baled Thomas yeoman 587366 587366 Ballett or Baled, Thomas, of Est Brent, yeoman 1
4059141 2045670 2045670 defendant Atwell John husbandman 587366 587366 Atwell, John, of Est Brent, husbandman 0
4059142 2045670 2045670 defendant Nevell John husbandman 587366 587366 Nevell, John, of Est Brent, husbandman 1
4127627 2070171 2070171 defendant Verbye Philip husbandman 587366 587366 (Verbye, Philip, of East Brent, husbandman 1
4161159 2081979 2081979 defendant Cocke William husbandman 587366 587366 Cocke, William, of East Brent, husbandman 1
4161160 2081979 2081979 defendant Bynsam John husbandman 587366 587366 Bynsam, John, of East Brent, husbandman 2
4171702 2085569 2085569 defendant Cooke William husbandman 587366 587366 Cooke, William, of East Brent, husbandman 1
4202143 2096293 2096293 defendant Cooke William yeoman 587366 587366 Cooke, William, of Est Brent, yeoman 3
4208357 2098471 2098471 defendant Dyker William husbandman 587366 587366 Dyker, William, of Est Brent, husbandman 0
4241156 2110029 2110029 defendant Cooke Walter husbandman 587366 587366 Cooke, Walter, of Est Brent, husbandman 0
4289524 2126317 2126317 defendant Pole John husbandman 587366 587366 Pole, John, of Est Brent, husbandman 0
4301216 2130544 2130544 defendant Good John yeoman 587366 587366 Good, John, of East Brent, yeoman 0
4301974 2130814 2130814 defendant Dynghurst Lewis butcher 587366 587366 Dynghurst, Lewis, of Est Brent, butcher 0
4301975 2130814 2130814 defendant Lane William butcher 587366 587366 Lane, William, of Est Brent, butcher 1
4317120 2136105 2136105 defendant Wingood or Wingott John (legal representative) 587366 587366 Wingood or Wingott, John, of East Brent, husbandman, executors of 1
4317121 2136105 2136105 defendant Vinsent John husbandman 587366 587366 (Vinsent, John, of East Brent, husbandman 2
4317122 2136105 2136105 defendant Hillman John husbandman 587366 587366 Hillman, John, of East Brent, husbandman 3
4331330 2140775 2140775 defendant Poole John husbandman 587366 587366 Poole, John, of East Brent, husbandman 0
4360731 2151009 2151009 defendant Lane Nicholas husbandman 587366 587366 Lane, Nicholas, of Est Brent, husbandman 3
4367361 2153382 2153382 defendant Dene Nicholas husbandman 587366 587366 Dene, Nicholas, of Est Brent, husbandman 0
4367362 2153382 2153382 defendant Davye Humphrey husbandman 587366 587366 Davye, Humphrey, of Est Brent, husbandman 1
4370592 2154533 2154533 defendant Saye Henry husbandman 587366 587366 Saye, Henry, of East Brent, husbandman 0
4381287 2158420 2158420 defendant Hares Thomas husbandman 587366 587366 Hares, Thomas, of Est Brent, husbandman 2
4395310 2163011 2163011 defendant Hares Walter, senior husbandman 587366 587366 Hares, Walter, senior, of East Brent, husbandman 0
4397754 2163826 2163826 defendant Massy William husbandman 587366 587366 Massy, William, of East Brent, husbandman 0
4508796 2203229 2203229 defendant Bergeson Nicholas   587366 587366 Bergeson, Nicholas, of East Brent 0
4587011 2227341 2227341 defendant Lest Robert   587366 587366 Lest, Robert, of East Brent 0
4595085 2229719 2229719 defendant Bolayn Robert   587366 587366 Bolayn, Robert, of East Brent 4
4706418 2267389 2267389 defendant Bulgyn Thomas, sen husbandman 587366 587366 Bulgyn, Thomas, sen, of East Brent, husbandman 0
5032729 2366459 2366459 defendant Dene John, junior husbandman 587366 587366 Dene, John, junior, of Est Brent, husbandman 0
5032731 2366460 2366460 defendant Dene John, junior husbandman 587366 587366 Dene, John, junior, of Est Brent, husbandman 0
5125788 2394027 2394027 defendant Dene John yeoman 587366 587366 Dene, John, of East Brent, yeoman 2
5234174 2425586 2425586 defendant Dene John husbandman 587366 587366 Dene, John, of Est Brent, husbandman 1
5236214 2426178 2426178 defendant Dene John husbandman 587366 587366 Dene, John, of Est Brent, husbandman 0
5236215 2426178 2426178 defendant Dene John, junior husbandman 587366 587366 Dene, John, junior, of Est Brent, husbandman 1
5236216 2426178 2426178 defendant Leest Philip husbandman 587366 587366 Leest, Philip, of Est Brent, husbandman 2
5236219 2426179 2426179 defendant Dene John husbandman 587366 587366 Dene, John, of Est Brent, husbandman 0
5236220 2426179 2426179 defendant Dene John, junior husbandman 587366 587366 Dene, John, junior, of Est Brent, husbandman 1
5236221 2426179 2426179 defendant Leest Philip husbandman 587366 587366 Leest, Philip, of Est Brent, husbandman 2
5240375 2427398 2427398 defendant Rogers Robert husbandman 587366 587366 Rogers, Robert, of Est Brent, husbandman 1
5246575 2429161 2429161 defendant Crenche John   587366 587366 Crenche, John, of Est Brent, parish clerk 1
5265157 2434863 2434863 defendant Dene John husbandman 587366 587366 Dene, John, of Est Brent, husbandman 0
5483111 2499888 2499888 defendant Pyke John husbandman 587366 587366 Pyke, John, of Est Brent, husbandman 0
5483114 2499889 2499889 defendant Pyke John husbandman 587366 587366 Pyke, John, of Est Brent, husbandman 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);