names

73 rows where place_id = 588948

✎ 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
3596082 1866403 1866403 defendant Prentys Thomas yeoman 588948 588948 Prentys, Thomas, of Brendwode, yeoman 0
3596083 1866403 1866403 defendant Fuller John pulter 588948 588948 Fuller, John, of Brendwode, pulter 1
3599571 1867502 1867502 defendant Prentys Thomas yeoman 588948 588948 Prentys, Thomas, of Brendwode, yeoman 4
3602103 1868322 1868322 defendant Ryggewyke John yeoman 588948 588948 Ryggewyke, John, of Brendwode, yeoman 0
3619790 1873762 1873762 defendant Prentys Thomas yeoman 588948 588948 Prentys, Thomas, of Brendwode, yeoman 3
3621430 1874241 1874241 defendant Baldwyn John yeoman 588948 588948 Baldwyn, John, of Brendwode, yeoman 2
3622765 1874650 1874650 defendant Raynold Thomas smith 588948 588948 Raynold, Thomas, of Brendwode, smith 1
3636996 1906367 1906367 defendant White Tocher painter 588948 588948 White, Tocher, of Brendwode, painter 1
3656250 1912201 1912201 defendant Banson John beer brewer 588948 588948 Banson, John, of Brendwode, beer brewer 1
3671410 1917036 1917036 defendant Garrold Richard laborer 588948 588948 Garrold, Richard, of Brendwode, laborer 2
3673369 1917688 1917688 defendant Clerke John yeoman 588948 588948 Clerke, John, of Brendwode, yeoman 0
3678909 1919473 1919473 defendant Garold Richard laborer 588948 588948 Garold, Richard, of Brendwode, laborer 0
3682548 1920646 1920646 defendant Dreywode Richard laborer 588948 588948 Dreywode, Richard, of Brendwode, laborer 1
3683035 1920806 1920806 defendant Clerk John yeoman 588948 588948 Clerk, John, of Brendwode, yeoman 0
3697659 1925492 1925492 defendant Newman John yeoman 588948 588948 Newman, John, of Brendwode, yeoman 1
3698279 1925680 1925680 defendant Brett William (legal representative) 588948 588948 Brett, William, of Brendwode, yeoman, executrix of 1
3698280 1925680 1925680 defendant Brett Emma widow 588948 588948 Brett, Emma, of Brendwode, widow 2
3699467 1926061 1926061 defendant Reynold John yeoman 588948 588948 Reynold, John, of Brendwode, yeoman 0
3745765 1940576 1940576 defendant Reynold John draper 588948 588948 Reynold, John, of Brendwode, draper 0
3772361 1949042 1949042 defendant Palgrave Michael butcher 588948 588948 Palgrave, Michael, of Brendwode, butcher 0
3772362 1949042 1949042 defendant Lucas John rippier 588948 588948 Lucas, John, of Brendwode, rippier 1
3772363 1949042 1949042 defendant Ewen William butcher 588948 588948 Ewen, William, of Brendwode, butcher 2
4497336 2199813 2199813 defendant Payn John   588948 588948 Payn, John, of Brendwode 0
4526883 2208685 2208685 defendant Pulter Henry   588948 588948 Pulter, Henry, of Brendwode 0
4633099 2241219 2241219 defendant Payn John   588948 588948 Payn, John, of Brendwode 1
5048432 2371169 2371169 defendant Baker Robert   588948 588948 Baker, Robert, of Brendwode, servant 0
5062891 2375437 2375437 defendant Crakebon Richard husbandman 588948 588948 Crakebon, Richard, of Brendwode, husbandman 0
5076563 2379494 2379494 defendant Richard John yeoman 588948 588948 Richard, John, of Brendwode, yeoman 2
5085871 2382261 2382261 defendant Russher John baker 588948 588948 Russher, John, of Brendwode, baker 8
5085883 2382261 2382261 defendant Yonge Thomas carter 588948 588948 Yonge, Thomas, of Brendwode, carter 20
5155519 2402774 2402774 defendant Spycer Thomas husbandman alias spicer 588948 588948 Spycer, Thomas, of Brendwode, husbandman alias spicer 0
5156190 2402971 2402971 defendant Ruddok Thomas smith 588948 588948 Ruddok, Thomas, of Brendwode, smith 3
5196466 2414718 2414718 defendant Abbot Thomas   588948 588948 Abbot, Thomas, of Brendwode, spice man 0
5233507 2425391 2425391 defendant Frenssh Thomas butcher 588948 588948 Frenssh, Thomas, of Brendwode, butcher 3
5251129 2430456 2430456 defendant Cutbert William yeoman 588948 588948 Cutbert, William, of Brendwode, yeoman 4
5276432 2438177 2438177 defendant Styward John yeoman 588948 588948 Styward, John, of Brendwode, yeoman 0
5278093 2438684 2438684 defendant Goman John baker 588948 588948 Goman, John, of Brendwode, baker 0
5278199 2438720 2438720 defendant Cheweyn John yeoman 588948 588948 Cheweyn, John, of Brendwode, yeoman 0
5278200 2438720 2438720 defendant Frensshe Roger yeoman 588948 588948 Frensshe, Roger, of Brendwode, yeoman 1
5278201 2438720 2438720 defendant Baldweyn Thomas yeoman 588948 588948 Baldweyn, Thomas, of Brendwode, yeoman 2
5284269 2440419 2440419 defendant Frebarn John butcher 588948 588948 Frebarn, John, of Brendwode, butcher 2
5298615 2444569 2444569 defendant Nytynghale William yeoman 588948 588948 Nytynghale, William, of Brendwode, yeoman 0
5310076 2448045 2448045 defendant Derraunt alias Hogekyn John draper 588948 588948 Derraunt alias Hogekyn, John, of Brendwode, draper 0
5310152 2448068 2448068 defendant Baldewyn Thomas yeoman 588948 588948 Baldewyn, Thomas, of Brendwode, yeoman 2
5315320 2449638 2449638 defendant Steward John yeoman 588948 588948 Steward, John, of Brendwode, yeoman 0
5315321 2449638 2449638 defendant Reynold Richard yeoman 588948 588948 Reynold, Richard, of Brendwode, yeoman 1
5317879 2450433 2450433 defendant Smyth John husbandman 588948 588948 Smyth, John, of Brendwode, husbandman 0
5317880 2450433 2450433 defendant Durant John husbandman 588948 588948 Durant, John, of Brendwode, husbandman 1
5352043 2460744 2460744 defendant Prentise William yeoman 588948 588948 Prentise, William, of Brendwode, yeoman 0
5357259 2462335 2462335 defendant Baldewyn Clemence widow 588948 588948 Baldewyn, Clemence, of Brendwode, widow 0
5357260 2462335 2462335 defendant Broman Thomas butcher 588948 588948 Broman, Thomas, of Brendwode, butcher 1
5357262 2462335 2462335 defendant Goman Thomas yeoman 588948 588948 Goman, Thomas, of Brendwode, yeoman 3
5359463 2462996 2462996 defendant Westwyk Thomas tailor 588948 588948 Westwyk, Thomas, of Brendwode, tailor 2
5360688 2463376 2463376 defendant Prentyse William yeoman 588948 588948 Prentyse, William, of Brendwode, yeoman 1
5360690 2463376 2463376 defendant Goman John yeoman 588948 588948 Goman, John, of Brendwode, yeoman 3
5360693 2463377 2463377 defendant Prentyse William yeoman 588948 588948 Prentyse, William, of Brendwode, yeoman 1
5360695 2463377 2463377 defendant Goman John yeoman 588948 588948 Goman, John, of Brendwode, yeoman 3
5393972 2473335 2473335 defendant Aleyn Richard butcher 588948 588948 Aleyn, Richard, of Brendwode, butcher 1
5428372 2483410 2483410 defendant Crampe John husbandman 588948 588948 Crampe, John, of Brendwode, husbandman 0
5428377 2483412 2483412 defendant Crampe John husbandman 588948 588948 Crampe, John, of Brendwode, husbandman 0
5508828 2507614 2507614 defendant Prentys Thomas yeoman 588948 588948 Prentys, Thomas, of Brendwode, yeoman 1
5517198 2510214 2510214 defendant Prentes Thomas yeoman 588948 588948 Prentes, Thomas, of Brendwode, yeoman 0
5529923 2513862 2513862 defendant Tayllour John yeoman 588948 588948 Tayllour, John, of Brendwode, yeoman 0
5529924 2513862 2513862 defendant Broun John husbandman 588948 588948 Broun, John, of Brendwode, husbandman 1
5529925 2513862 2513862 defendant Clerale John yeoman 588948 588948 Clerale, John, of Brendwode, yeoman 2
5529926 2513862 2513862 defendant Skynner William   588948 588948 Skynner, William, of Brendwode, cook 3
5557290 2522093 2522093 defendant Lytell John yeoman 588948 588948 Lytell, John, of Brendwode, yeoman 0
5559825 2522832 2522832 defendant Edward John butcher 588948 588948 Edward, John, of Brendwode, butcher 0
5578690 2528398 2528398 defendant Maldon Richard butcher 588948 588948 Maldon, Richard, of Brendwode, butcher 2
5578691 2528398 2528398 defendant Samon William butcher 588948 588948 Samon, William, of Brendwode, butcher 3
5579905 2528797 2528797 defendant Newman John yeoman 588948 588948 Newman, John, of Brendwode, yeoman 0
5598952 2534552 2534552 defendant Barowes Thomas   588948 588948 (Barowes, Thomas, of Brendwode, pedlar 1
5601264 2535285 2535285 defendant Byrde Thomas shoemaker 588948 588948 Byrde, Thomas, of Brendwode, shoemaker 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);