names

112 rows where place_id = 671308

✎ 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
3608665 1870370 1870370 defendant Goldsmyth Alan   671308 671308 Goldsmyth, Alan, of Est Derham, Norf, paten maker 1
3622656 1874616 1874616 defendant Wykham John draper 671308 671308 Wykham, John, of Est Derham, Norf, draper 2
3632362 1904942 1904942 defendant Codlyng Thomas yeoman 671308 671308 Codlyng, Thomas, of Est Derham, Norf, yeoman 0
3642748 1908179 1908179 defendant Fyske Nicholas raffman 671308 671308 Fyske, Nicholas, of Est Derham, Norf, raffman 0
3642752 1908181 1908181 defendant Snellyng John butcher 671308 671308 Snellyng, John, of Est Derham, Norf, butcher 0
3649309 1910174 1910174 defendant Pynnys Thomas yeoman 671308 671308 Pynnys, Thomas, of Est Derham, Norf, yeoman 0
3693701 1924223 1924223 defendant Snellyng John butcher 671308 671308 Snellyng, John, of Est Derham, Norf, butcher 0
3704468 1927693 1927693 defendant Pennys Thomas yeoman 671308 671308 Pennys, Thomas, of Est Derham, Norf, yeoman 1
3708513 1928959 1928959 defendant Atherton Arthur yeoman 671308 671308 Atherton, Arthur, of Est Derham, Norf, yeoman 2
3769324 1948062 1948062 defendant Perymount Geoffrey husbandman 671308 671308 Perymount, Geoffrey, of Est Derham, Norf, husbandman 2
3810313 1961117 1961117 defendant Goddyng Thomas yeoman 671308 671308 Goddyng, Thomas, of Est Derham, Norf, yeoman 0
3813465 1962124 1962124 defendant Bowgyn John   671308 671308 Bowgyn, John, of Est Derham, Norf, worsted weaver 0
3819174 1963884 1963884 defendant Fyske John haberdasher 671308 671308 Fyske, John, of Est Derham, Norf, haberdasher 1
3849323 1973384 1973384 defendant Codlyng Thomas, junior husbandman 671308 671308 Codlyng, Thomas, junior, of Est Derham, Norf, husbandman 0
3899384 1990007 1990007 defendant Bennys William baker 671308 671308 Bennys, William, of Est Derham, Norf, baker 0
3899386 1990008 1990008 defendant Bennys William baker 671308 671308 Bennys, William, of Est Derham, Norf, baker 0
3938555 2003236 2003236 defendant Harryson Godfrey   671308 671308 Harryson, Godfrey, of East Derham, Norf, black smith 0
3971892 2014729 2014729 defendant Wenne James yeoman 671308 671308 Wenne, James, of Est Derham, Norf, yeoman 3
3974887 2015781 2015781 defendant Roose Richard blacksmith 671308 671308 Roose, Richard, of Est Derham, Norf, blacksmith 0
3974892 2015782 2015782 defendant Roose Richard smith 671308 671308 Roose, Richard, of Est Derham, Norf, smith 1
3976935 2016495 2016495 defendant Sterling Robert husbandman 671308 671308 Sterling, Robert, of Est Derham, Norf, husbandman 0
3987161 2020154 2020154 defendant Malby Roger clerk 671308 671308 Malby, Roger, of Est Derham, Norf, clerk 0
3993861 2022554 2022554 defendant Warde George   671308 671308 Warde, George, of Est Derham, Norf, "fosterer" 0
4001054 2025152 2025152 defendant Mowtynge Edmund yeoman 671308 671308 Mowtynge, Edmund, of East Derham, Norf, yeoman 0
4020099 2031911 2031911 defendant Cuttinge Thomas yeoman 671308 671308 Cuttinge, Thomas, of Est Derham, Norf, yeoman 0
4064768 2047683 2047683 defendant Dethicke Richard yeoman 671308 671308 Dethicke, Richard, of Est Derham, Norf, yeoman 0
4100061 2060352 2060352 defendant Gurney Arthur gent 671308 671308 Gurney, Arthur, of Est Derham, Norf, gent 0
4100062 2060352 2060352 defendant Kynge Jerome tailor 671308 671308 Kynge, Jerome, of Est Derham, Norf, tailor 1
4124737 2069142 2069142 defendant Wilkinson William tailor 671308 671308 Wilkinson, William, of Est Derham, Norf, tailor 0
4212030 2099757 2099757 defendant Taylor Walter husbandman 671308 671308 Taylor, Walter, of Est Derham, Norf, husbandman 2
4507224 2202725 2202725 defendant Frere John   671308 671308 Frere, John, of East Derham, Norf 0
4526514 2208574 2208574 defendant Malyard John   671308 671308 Malyard, John, of East Derham, Norf 0
4740409 2277709 2277709 defendant Fleg Wailliam yeoman 671308 671308 Fleg, Wailliam, of East Derham, Norf, yeoman 2
4740411 2277709 2277709 defendant Broun Thomas chapman 671308 671308 Broun, Thomas, of East Derham, Norf, chapman 4
4759179 2283214 2283214 defendant Mule Thomas gent 671308 671308 Mule, Thomas, of East Derham, Norf, gent 1
4783974 2290997 2290997 defendant Moule Thomas yeoman 671308 671308 Moule, Thomas, of Est Derham, Norf, yeoman 2
4818239 2301783 2301783 plaintiff Noble Stephen   671308 671308 Noble, Stephen, of East Derham, Norf, parson, on his own account 0
4818241 2301784 2301784 plaintiff Noble Stephen   671308 671308 Noble, Stephen, of East Derham, Norf, parson, on his own account 0
4818345 2301820 2301820 defendant Lucas Edmund gent 671308 671308 Lucas, Edmund, of East Derham, Norf, gent 3
4821899 2302924 2302924 defendant MounteJoye Thomas yeoman 671308 671308 MounteJoye, Thomas, of East Derham, Norf, yeoman 2
4821905 2302925 2302925 defendant MounteJoye Thomas yeoman 671308 671308 MounteJoye, Thomas, of East Derham, Norf, yeoman 2
4833945 2306625 2306625 defendant Hervy Walter husbandman 671308 671308 Hervy, Walter, of East Derham, Norf, husbandman 1
4892542 2324398 2324398 defendant Flegh William yeoman 671308 671308 Flegh, William, of Est Derham, Norf, yeoman 2
4925585 2334438 2334438 defendant Brystowe Richard gent 671308 671308 Brystowe, Richard, of East Derham, Norf, gent 0
4964925 2346423 2346423 defendant Skernyng William smith 671308 671308 Skernyng, William, of Est Derham, Norf, smith 4
4994712 2355274 2355274 defendant Wykham Thomas chapman 671308 671308 Wykham, Thomas, of East Derham, Norf, chapman 2
4994716 2355275 2355275 defendant Wykham Thomas chapman 671308 671308 Wykham, Thomas, of East Derham, Norf, chapman 2
5030896 2365907 2365907 defendant Malyard Geoffrey draper 671308 671308 Malyard, Geoffrey, of Est Derham, Norf, draper 2
5034916 2367071 2367071 defendant Albred Martin chaplain 671308 671308 Albred, Martin, of Est Derham, Norf, chaplain 0
5136385 2397160 2397160 defendant Couper Edmund husbandman 671308 671308 Couper, Edmund, of East Derham, Norf, husbandman 2
5142182 2398837 2398837 defendant Pilche William   671308 671308 Pilche, William, of East Derham, Norf, "granour" 2
5142690 2398987 2398987 defendant Shotysham John yeoman 671308 671308 Shotysham, John, of East Derham, Norf, yeoman 0
5156771 2403138 2403138 defendant Couper Edmund husbandman 671308 671308 Couper, Edmund, of East Derham, Norf, husbandman 2
5177192 2409023 2409023 defendant Cote John laborer 671308 671308 Cote, John, of East Derham, Norf, laborer 1
5187807 2412154 2412154 defendant Alppe Stephen yeoman 671308 671308 Alppe, Stephen, of East Derham, Norf, yeoman 0
5199951 2415739 2415739 defendant cote John laborer 671308 671308 cote, John, of East Derham, Norf, laborer 1
5230187 2424447 2424447 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of Est Derham, Norf, gent 0
5230346 2424491 2424491 defendant Payn Thomas esq 671308 671308 Payn, Thomas, of Est Derham, Norf, esq 0
5230379 2424501 2424501 defendant Payn Thomas esq 671308 671308 Payn, Thomas, of Est Derham, Norf, esq 0
5236724 2426326 2426326 defendant Garnyssh Robert chapman 671308 671308 Garnyssh, Robert, of Est Derham, Norf, chapman 0
5236731 2426328 2426328 defendant Garnyssh Robert chapman 671308 671308 Garnyssh, Robert, of Est Derham, Norf, chapman 0
5236865 2426364 2426364 defendant Carteys Thomas hosier 671308 671308 Carteys, Thomas, of Est Derham, Norf, hosier 1
5259543 2433108 2433108 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of Est Derham, Norf, gent 0
5269940 2436317 2436317 defendant Baxter John yeoman 671308 671308 Baxter, John, of East Derham, Norf, yeoman 0
5307212 2447159 2447159 defendant Sterlyng John   671308 671308 Sterlyng, John, of East Derham, Norf 0
5324853 2452507 2452507 defendant Duram Thomas cordwainer 671308 671308 Duram, Thomas, of Est Derham, Norf, cordwainer 2
5337386 2456253 2456253 defendant Palmar Robert gent 671308 671308 Palmar, Robert, of Est Derham, Norf, gent 0
5353248 2461090 2461090 defendant Bawdyas John grocer 671308 671308 Bawdyas, John, of Est Derham, Norf, grocer 4
5356420 2462075 2462075 defendant Pratte alias Davy William sherman 671308 671308 Pratte alias Davy, William, of Est Derham, Norf, sherman 1
5376327 2468192 2468192 defendant Cr--- Henry fuller 671308 671308 Cr---, Henry, of East Derham, Norf, fuller 1
5385478 2470917 2470917 defendant Lumbard Nicholas draper 671308 671308 Lumbard, Nicholas, of East Derham, Norf, draper 0
5385479 2470917 2470917 defendant Lumbard Margaret widow 671308 671308 Lumbard, Margaret, of East Derham, Norf, widow 1
5391028 2472502 2472502 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 1
5394373 2473458 2473458 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 0
5396449 2474079 2474079 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 1
5404425 2476336 2476336 defendant Thoward William husbandman 671308 671308 Thoward, William, of East Derham, Norf, husbandman 1
5407612 2477247 2477247 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 0
5410720 2478152 2478152 defendant Lumbard Nicholas draper 671308 671308 Lumbard, Nicholas, of East Derham, Norf, draper 0
5410721 2478152 2478152 defendant Lumbard alias Beton Margaret widow 671308 671308 Lumbard alias Beton, Margaret, of East Derham, Norf, widow 1
5417142 2480033 2480033 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 1
5417560 2480170 2480170 defendant Throward William husbandman 671308 671308 Throward, William, of East Derham, Norf, husbandman 1
5419274 2480691 2480691 defendant Langtoft Nicholas draper 671308 671308 Langtoft, Nicholas, of East Derham, Norf, draper 3
5420823 2481154 2481154 defendant Palmer Robert   671308 671308 Palmer, Robert, of East Derham, Norf 0
5430654 2484105 2484105 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 3
5434296 2485194 2485194 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 0
5434946 2485382 2485382 defendant Throward William husbandman 671308 671308 Throward, William, of East Derham, Norf, husbandman 1
5434952 2485383 2485383 defendant Throward William husbandman 671308 671308 Throward, William, of East Derham, Norf, husbandman 1
5437519 2486160 2486160 defendant Langtoft Nicholas draper 671308 671308 Langtoft, Nicholas, of East Derham, Norf, draper 3
5438734 2486514 2486514 defendant Langtoft Nicholas husbandman 671308 671308 Langtoft, Nicholas, of East Derham, Norf, husbandman 1
5444038 2488133 2488133 defendant Ode Robert yeoman 671308 671308 Ode, Robert, of East Derham, Norf, yeoman 2
5447267 2489071 2489071 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 3
5447270 2489072 2489072 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 0
5449703 2489799 2489799 defendant (illegible) Robert gent 671308 671308 _, Robert, of East Derham, Norf, gent 0
5456762 2491941 2491941 defendant Ode Robert yeoman 671308 671308 Ode, Robert, of East Derham, Norf, yeoman 2
5459743 2492837 2492837 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 0
5460732 2493157 2493157 defendant Jesop John mercer 671308 671308 Jesop, John, of East Derham, Norf, mercer 0
5461854 2493488 2493488 defendant Palmer Robert gent 671308 671308 Palmer, Robert, of East Derham, Norf, gent 0
5463316 2493938 2493938 defendant Stacy Robert husbandman 671308 671308 Stacy, Robert, of East Derham, Norf, husbandman 5
5464575 2494323 2494323 defendant Langtoft Nicholas husbandman 671308 671308 Langtoft, Nicholas, of East Derham, Norf, husbandman 2
5465376 2494552 2494552 defendant Byrde John chaplain 671308 671308 Byrde, John, of East Derham, Norf, chaplain 3

Next page

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