names

82 rows where place_id = 639256

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3847843 1972901 1972901 defendant Fytlyng Bartholomew butcher 639256 639256 Fytlyng, Bartholomew, of Hengham, Norf, butcher 1
3986579 2019938 2019938 defendant Norton John clerk 639256 639256 Norton, John, of Hengham, Norf, clerk 4
3986603 2019946 2019946 defendant Norton John clerk 639256 639256 Norton, John, of Hengham, Norf, clerk 3
3994114 2022643 2022643 defendant Futter Richard gent 639256 639256 Futter, Richard, of Hengham, Norf, gent 1
4330612 2140532 2140532 defendant Tanne Edmund shoemaker 639256 639256 Tanne, Edmund, of Hengham, Norf, shoemaker 0
4656473 2247921 2247921 defendant Pekke alias Warner William yeoman 639256 639256 Pekke alias Warner, William, of Hengham, Norf, yeoman 0
4656475 2247922 2247922 defendant Pekke alias Warner William yeoman 639256 639256 Pekke alias Warner, William, of Hengham, Norf, yeoman 0
4684366 2260716 2260716 defendant Nowolde Thomas   639256 639256 Nowolde, Thomas, of Hengham, Norf, well man 0
4743964 2278761 2278761 defendant Taverner John yeoman 639256 639256 Taverner, John, of Hengham, Norf, yeoman 1
4745348 2279148 2279148 defendant Bredman John woolman 639256 639256 Bredman, John, of Hengham, Norf, woolman 1
4745349 2279148 2279148 defendant Bredman Thomas woolman 639256 639256 Bredman, Thomas, of Hengham, Norf, woolman 2
4753919 2281607 2281607 defendant Crowe Edmund yeoman 639256 639256 Crowe, Edmund, of Hengham, Norf, yeoman 0
4753921 2281608 2281608 defendant Crowe Edmund yeoman 639256 639256 Crowe, Edmund, of Hengham, Norf, yeoman 0
4808705 2298890 2298890 defendant Taverner Edmund yeoman 639256 639256 Taverner, Edmund, of Hengham, Norf, yeoman 1
4816877 2301382 2301382 defendant Eylot Thomas draper 639256 639256 Eylot, Thomas, of Hengham, Norf, draper 4
4821897 2302924 2302924 defendant Fetyll John yeoman 639256 639256 Fetyll, John, of Hengham, Norf, yeoman 0
4821903 2302925 2302925 defendant Fetyll John yeoman 639256 639256 Fetyll, John, of Hengham, Norf, yeoman 0
4859823 2314442 2314442 defendant Gylok Thomas yeoman 639256 639256 Gylok, Thomas, of Hengham, Norf, yeoman 0
4876000 2319455 2319455 defendant Mey Thomas draper 639256 639256 Mey, Thomas, of Hengham, Norf, draper 0
4929946 2335776 2335776 defendant Pynchebek John   639256 639256 Pynchebek, John, of Hengham, Norf, corsour or shoemaker 2
4956952 2344036 2344036 defendant More Robert barker 639256 639256 More, Robert, of Hengham, Norf, barker 0
4958538 2344522 2344522 defendant Josep John brasier 639256 639256 Josep, John, of Hengham, Norf, brasier 2
4958543 2344523 2344523 defendant Josep John brasier 639256 639256 Josep, John, of Hengham, Norf, brasier 2
5038503 2368157 2368157 defendant Doubelday William husbandman 639256 639256 Doubelday, William, of Hengham, Norf, husbandman 0
5048987 2371332 2371332 defendant Kempe Edmund barber 639256 639256 Kempe, Edmund, of Hengham, Norf, barber 1
5067866 2376889 2376889 defendant atte Forth Henry butcher 639256 639256 atte Forth, Henry, of Hengham, Norf, butcher 0
5075946 2379298 2379298 defendant Bradley William baker 639256 639256 Bradley, William, of Hengham, Norf, baker 0
5116064 2391126 2391126 defendant Dam Cecily widow 639256 639256 Dam, Cecily, of Hengham, Norf, widow 0
5116066 2391127 2391127 defendant Dam Cecily widow 639256 639256 Dam, Cecily, of Hengham, Norf, widow 0
5130653 2395455 2395455 defendant Noth John husbandman 639256 639256 Noth, John, of Hengham, Norf, husbandman 3
5136128 2397077 2397077 defendant Davy John yeoman 639256 639256 Davy, John, of Hengham, Norf, yeoman 2
5169227 2406738 2406738 defendant Bredman Thomas yeoman 639256 639256 Bredman, Thomas, of Hengham, Norf, yeoman 0
5184971 2411349 2411349 defendant Caws Richard gent 639256 639256 Caws, Richard, of Hengham, Norf, gent 3
5185844 2411606 2411606 defendant Bredman Thomas yeoman 639256 639256 Bredman, Thomas, of Hengham, Norf, yeoman 0
5204620 2417096 2417096 defendant Caws Richard gent 639256 639256 Caws, Richard, of Hengham, Norf, gent 3
5242328 2427961 2427961 defendant Cans Richard esq 639256 639256 Cans, Richard, of Hengham, Norf, esq 0
5276874 2438318 2438318 defendant Aubry Patrick laborer 639256 639256 Aubry, Patrick, of Hengham, Norf, laborer 1
5285768 2440863 2440863 defendant Nothe John yeoman 639256 639256 Nothe, John, of Hengham, Norf, yeoman 0
5299046 2444701 2444701 defendant Cabs Richard gent 639256 639256 Cabs, Richard, of Hengham, Norf, gent 4
5301092 2445279 2445279 defendant Caus Richard gent 639256 639256 Caus, Richard, of Hengham, Norf, gent 0
5309949 2448012 2448012 defendant Levenard William dyer 639256 639256 Levenard, William, of Hengham, Norf, dyer 0
5338999 2456768 2456768 defendant Colyoure Robert chaplain 639256 639256 Colyoure, Robert, of Hengham, Norf, chaplain 2
5339515 2456930 2456930 defendant Nothe John yeoman 639256 639256 Nothe, John, of Hengham, Norf, yeoman 0
5341774 2457621 2457621 defendant Standon Robert mercer 639256 639256 Standon, Robert, of Hengham, Norf, mercer 0
5348898 2459785 2459785 defendant Westgate John husbandman 639256 639256 Westgate, John, of Hengham, Norf, husbandman 1
5350785 2460356 2460356 defendant Paler Thomas husbandman 639256 639256 Paler, Thomas, of Hengham, Norf, husbandman 0
5352235 2460798 2460798 defendant Davy John yeoman 639256 639256 Davy, John, of hengham, Norf, yeoman 1
5358528 2462725 2462725 defendant Clerk Richard yeoman 639256 639256 Clerk, Richard, of Hengham, Norf, yeoman 3
5360982 2463458 2463458 defendant Davy John yeoman 639256 639256 Davy, John, of Hengham, Norf, yeoman 1
5360986 2463459 2463459 defendant Davy John yeoman 639256 639256 Davy, John, of Hengham, Norf, yeoman 1
5365631 2464920 2464920 defendant Clerk Thomas baker 639256 639256 Clerk, Thomas, of Hengham, Norf, baker 2
5369965 2466197 2466197 defendant Cupper Robert husbandman 639256 639256 Cupper, Robert, of Hengham, Norf, husbandman 1
5383738 2470432 2470432 defendant Megecalfe John husbandman 639256 639256 Megecalfe, John, of Hengham, Norf, husbandman 4
5383743 2470433 2470433 defendant Metcalfe John husbandman 639256 639256 Metcalfe, John, of Hengham, Norf, husbandman 3
5395558 2473809 2473809 defendant Mettcalfe John husbandman 639256 639256 Mettcalfe, John, of Hengham, Norf, husbandman 3
5395565 2473810 2473810 defendant Metecalfe John husbandman 639256 639256 Metecalfe, John, of Hengham, Norf, husbandman 4
5396358 2474050 2474050 defendant Clerk Thomas baker 639256 639256 Clerk, Thomas, of Hengham, Norf, baker 3
5404752 2476440 2476440 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5404755 2476441 2476441 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5408848 2477607 2477607 defendant Metcalfe John husbandman 639256 639256 Metcalfe, John, of Hengham, Norf, husbandman 3
5408853 2477608 2477608 defendant Metcalfe John husbnadman 639256 639256 Metcalfe, John, of Hengham, Norf, husbnadman 2
5408859 2477609 2477609 defendant Metcalfe John husbandman 639256 639256 Metcalfe, John, of Hengham, Norf, husbandman 3
5408862 2477610 2477610 defendant Metcalfe John husbandman 639256 639256 Metcalfe, John, of Hengham, Norf, husbandman 1
5409663 2477861 2477861 defendant Clerk Thomas baker 639256 639256 Clerk, Thomas, of Hengham, Norf, baker 3
5416524 2479859 2479859 defendant Mikelfeld Robert gent 639256 639256 Mikelfeld, Robert, of Hengham, Norf, gent 0
5417899 2480281 2480281 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5423254 2481919 2481919 defendant Clerk Thomas baker 639256 639256 Clerk, Thomas, of Hengham, Norf, baker 3
5426909 2482996 2482996 defendant Caus or Cans Richard gent 639256 639256 Caus or Cans, Richard, of Hengham, Norf, gent 1
5435450 2485543 2485543 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5435452 2485544 2485544 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5435454 2485545 2485545 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5435457 2485546 2485546 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5435458 2485546 2485546 defendant Lyster Simon yeoman 639256 639256 Lyster, Simon, of Hengham, Norf, yeoman 1
5435461 2485547 2485547 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5435465 2485548 2485548 defendant Vygorows Thomas yeoman 639256 639256 Vygorows, Thomas, of Hengham, Norf, yeoman 0
5444870 2488356 2488356 defendant Caus Richard gent 639256 639256 Caus, Richard, of Hengham, Norf, gent 1
5445018 2488397 2488397 defendant Caus Richard gent 639256 639256 Caus, Richard, of Hengham, Norf, gent 1
5462639 2493736 2493736 defendant Vigerows Thomas yeoman 639256 639256 Vigerows, Thomas, of Hengham, Norf, yeoman 0
5486910 2500982 2500982 defendant Metcalf John yeoman 639256 639256 Metcalf, John, of Hengham, Norf, yeoman 2
5512676 2508821 2508821 defendant Bothe John yeoman 639256 639256 Bothe, John, of Hengham, Norf, yeoman 1
5563367 2523883 2523883 defendant More Thomas chapman 639256 639256 More, Thomas, of Hengham, Norf, chapman 0
5606094 2536796 2536796 defendant Rebet or Robet Robert tanner 639256 639256 Rebet or Robet, Robert, of Hengham, Norf, tanner 1

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