names

63 rows where place_id = 600144

✎ 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
3639864 1907281 1907281 defendant Woderove William yeoman 600144 600144 Woderove, William, of Tykhill, yeoman 1
3701394 1926683 1926683 defendant Ladley Thomas chaplain 600144 600144 Ladley, Thomas, of Tykhill, chaplain 0
3701395 1926683 1926683 defendant Martyn Nicholas chaplain 600144 600144 Martyn, Nicholas, of Tykhill, chaplain 1
3712915 1930360 1930360 defendant Lawson Richard laborer 600144 600144 Lawson, Richard, of Tykhill, laborer 0
3712997 1930388 1930388 defendant Martyn Nicholas chaplain 600144 600144 Martyn, Nicholas, of Tykhill, chaplain 0
3712998 1930388 1930388 defendant Renell or Revell Geoffrey turner 600144 600144 Renell or Revell, Geoffrey, of Tykhill, turner 1
3751505 1942385 1942385 plaintiff Norres Thomas (legal representative) 600144 600144 Norres, Thomas, of Tykhill, executors of 0
3751508 1942385 1942385 defendant Martyn Nicholas chaplain 600144 600144 Martyn, Nicholas, of Tykhill, chaplain 0
3751509 1942385 1942385 defendant Ladley Thomas chaplain 600144 600144 Ladley, Thomas, of Tykhill, chaplain 1
3767789 1947563 1947563 defendant Marton Nicholas chaplain 600144 600144 Marton, Nicholas, of Tykhill, chaplain 0
3767790 1947563 1947563 defendant Ladley Thomas chaplain 600144 600144 Ladley, Thomas, of Tykhill, chaplain 1
3801279 1958324 1958324 defendant Holme Robert yeoman 600144 600144 Holme, Robert, of Tykhill, yeoman 0
3847172 1972670 1972670 defendant Kendall Christopher yeoman 600144 600144 Kendall, Christopher, of Tykhill, yeoman 1
3913685 1994918 1994918 plaintiff Boswell Thomas gent 600144 600144 Boswell, Thomas, of Tykhill, gent 0
3928629 1999914 1999914 plaintiff Bossewell Thomas gent 600144 600144 Bossewell, Thomas, of Tykhill, gent 0
3942111 2004378 2004378 defendant Beamond Edward yeoman 600144 600144 Beamond, Edward, of Tykhill, yeoman 0
3942653 2004551 2004551 defendant Beamond Edward yeoman 600144 600144 Beamond, Edward, of Tykhill, yeoman 0
4448790 2184560 2184560 defendant Dadwall William   600144 600144 Dadwall, William, of Tykhill 0
4448941 2184607 2184607 defendant Styrop William   600144 600144 Styrop, William, of Tykhill 1
4453367 2186058 2186058 defendant del Kerre John   600144 600144 del Kerre, John, of Tykhill 0
4455169 2186617 2186617 defendant Leget Richard   600144 600144 Leget, Richard, of Tykhill 0
4462015 2188818 2188818 plaintiff Styrappe William de (legal representative) 600144 600144 Styrappe, William de, of Tykhill, executrix of 0
4466570 2190222 2190222 defendant Repas Robert tanner 600144 600144 Repas, Robert, of Tykhill, tanner 0
4469083 2190997 2190997 plaintiff Beweford John clerk & warden of the free chapel 600144 600144 Beweford, John, of Tykhill, clerk & warden of the free chapel 0
4479425 2194219 2194219 defendant Hyndhagh John de   600144 600144 Hyndhagh, John de, of Tykhill 0
4489456 2197423 2197423 plaintiff Thwayt Thomas de   600144 600144 Thwayt, Thomas de, of Tykhill 0
4538169 2212223 2212223 defendant Grey John, sen miller 600144 600144 Grey, John, sen, of Tykhill, miller 0
4544223 2214112 2214112 defendant Hawell Henry   600144 600144 Hawell, Henry, of Tykhill 0
4556164 2217869 2217869 defendant Thwayt Thomas   600144 600144 Thwayt, Thomas, of Tykhill 0
4556179 2217874 2217874 defendant Thwayt Thomas   600144 600144 Thwayt, Thomas, of Tykhill 0
4557787 2218364 2218364 defendant Twyer Robert   600144 600144 Twyer, Robert, of Tykhill 2
4569288 2221984 2221984 defendant Thawayt Thomas de   600144 600144 Thawayt, Thomas de, of Tykhill 0
4636220 2242161 2242161 defendant Tynmouth Robert   600144 600144 Tynmouth, Robert, of Tykhill 1
4650383 2246135 2246135 defendant Douke or Donke John   600144 600144 Douke or Donke, John, of Tykhill 0
4687758 2261743 2261743 defendant Hesyll John tanner 600144 600144 Hesyll, John, of Tykhill, tanner 0
4731435 2275032 2275032 defendant Denyll Gosselinus or Jocelin   600144 600144 Denyll, Gosselinus or Jocelin, of Tykhill, gent, administrators of 0
4843836 2309592 2309592 defendant Tuxford William sheerman 600144 600144 Tuxford, William, of Tykhill, sheerman 2
5048966 2371325 2371325 defendant Gurry Richard bower 600144 600144 Gurry, Richard, of Tykhill, bower 0
5083003 2381423 2381423 defendant Witton John carrier 600144 600144 Witton, John, of Tykhill, carrier 1
5129079 2394988 2394988 defendant Coke John yeoman 600144 600144 Coke, John, of Tykhill, yeoman 2
5154063 2402347 2402347 defendant Carglod John   600144 600144 Carglod, John, of Tykhill, free mason 1
5157198 2403245 2403245 defendant Bagshawe Robert yeoman 600144 600144 Bagshawe, Robert, of Tykhill, yeoman 0
5173198 2407872 2407872 defendant Bagshawe Robert yeoman 600144 600144 Bagshawe, Robert, of Tykhill, yeoman 0
5183223 2410834 2410834 defendant Coke John yeoman 600144 600144 Coke, John, of Tykhill, yeoman 1
5221180 2421895 2421895 defendant Twyer Thomas yeoman 600144 600144 Twyer, Thomas, of Tykhill, yeoman 0
5228374 2423907 2423907 defendant Bagshawe Oliver yeoman 600144 600144 Bagshawe, Oliver, of Tykhill, yeoman 8
5228751 2424022 2424022 plaintiff White Robert (legal representative) 600144 600144 White, Robert, of Tykhill, mercer, executors of 0
5234183 2425588 2425588 defendant Wheteley William esq 600144 600144 Wheteley, William, of Tykhill, esq 1
5248727 2429748 2429748 defendant Turton Thomas yeoman 600144 600144 Turton, Thomas, of Tykhill, yeoman 0
5253306 2431134 2431134 defendant Hubert William chapman 600144 600144 Hubert, William, of Tykhill, chapman 0
5306581 2446957 2446957 defendant Gudbarne John yeoman 600144 600144 Gudbarne, John, of Tykhill, yeoman 1
5362647 2463967 2463967 defendant Tewier Thomas, senior   600144 600144 Tewier, Thomas, senior, of Tykhill, franklin 0
5362648 2463967 2463967 defendant Tewier Thomas, junior yeoman 600144 600144 Tewier, Thomas, junior, of Tykhill, yeoman 1
5362650 2463968 2463968 defendant Twyer Thomas   600144 600144 Twyer, Thomas, of Tykhill, franklin 0
5362651 2463968 2463968 defendant Twyer Thomas, junior yeoman 600144 600144 Twyer, Thomas, junior, of Tykhill, yeoman 1
5363295 2464178 2464178 plaintiff West Robert   600144 600144 West, Robert, of Tykhill 0
5363299 2464179 2464179 plaintiff West Robert   600144 600144 West, Robert, of Tykhill 0
5369578 2466072 2466072 defendant Earglet John   600144 600144 Earglet, John, of Tykhill, mason 1
5384953 2470768 2470768 defendant Coke Isabel widow 600144 600144 Coke, Isabel, of Tykhill, widow 5
5397074 2474247 2474247 defendant Coke Isabel widow 600144 600144 Coke, Isabel, of Tykhill, widow 5
5439892 2486877 2486877 defendant Turton Thomas draper 600144 600144 Turton, Thomas, of Tykhill, draper 0
5613863 2548113 2548113 defendant Bolde Robert   600144 600144 Bolde, Robert, of Tykhill 0
5636068 2555238 2555238 defendant Ulley William   600144 600144 Ulley, William, of Tykhill 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);