names

49 rows where place_id = 594438

✎ 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
3616135 1872685 1872685 defendant Corsse Edward husbandman 594438 594438 Corsse, Edward, of Litlyngton, husbandman 0
4300284 2130201 2130201 defendant Blowes Richard husbandman 594438 594438 Blowes, Richard, of Litlyngton, husbandman 0
4300286 2130201 2130201 defendant Payne Walter husbandman 594438 594438 Payne, Walter, of Litlyngton, husbandman 2
4326327 2139169 2139169 defendant Bloes Richard yeoman 594438 594438 Bloes, Richard, of Litlyngton, yeoman 0
4430001 2174168 2174168 plaintiff Willy John, senior   594438 594438 Willy, John, senior, of Litlyngton 0
4437191 2176375 2176375 defendant Martyn Warin   594438 594438 Martyn, Warin, of Litlyngton 0
4437193 2176376 2176376 defendant Martyn Warin   594438 594438 Martyn, Warin, of Litlyngton 0
4458218 2187608 2187608 defendant Godale Thomas   594438 594438 Godale, Thomas, of Litlyngton 7
4469978 2191275 2191275 defendant Meleman Geoffrey   594438 594438 Meleman, Geoffrey, of Litlyngton 2
4487812 2196904 2196904 defendant Kynne John clerk 594438 594438 Kynne, John, of Litlyngton, clerk 0
4574590 2223582 2223582 defendant Spencer John   594438 594438 Spencer, John, of Litlyngton 0
4609471 2234065 2234065 defendant Wynter Robert maltster 594438 594438 Wynter, Robert, of Litlyngton, maltster 0
4622142 2237902 2237902 defendant Colyer William   594438 594438 Colyer, William, of Litlyngton 0
4643566 2244221 2244221 defendant Benet William   594438 594438 Benet, William, of Litlyngton 0
4651224 2246389 2246389 defendant Bette John husbandman 594438 594438 Bette, John, of Litlyngton, husbandman 0
4651225 2246389 2246389 defendant Everard Walter husbandman 594438 594438 Everard, Walter, of Litlyngton, husbandman 1
4651226 2246389 2246389 defendant Smyth John husbandman 594438 594438 Smyth, John, of Litlyngton, husbandman 2
4651227 2246389 2246389 defendant Cors John, junior husbandman 594438 594438 Cors, John, junior, of Litlyngton, husbandman 3
4674409 2257608 2257608 defendant Plattynges Thomas husbandman 594438 594438 Plattynges, Thomas, of Litlyngton, husbandman 0
4809552 2299155 2299155 defendant Bocher John husbandman 594438 594438 Bocher, John, of Litlyngton, husbandman 0
4809553 2299155 2299155 defendant Roper John husbandman 594438 594438 Roper, John, of Litlyngton, husbandman 1
4850151 2311509 2311509 defendant Archer Henry husbandman 594438 594438 Archer, Henry, of Litlyngton, husbandman 0
4878179 2320127 2320127 defendant Archer Henry husbandman 594438 594438 Archer, Henry, of Litlyngton, husbandman 0
4913092 2330591 2330591 defendant Cammpes Thomas gent 594438 594438 Cammpes, Thomas, of Litlyngton, gent 2
4928461 2335324 2335324 defendant Purra William smith 594438 594438 Purra, William, of Litlyngton, smith 0
4930951 2336076 2336076 defendant Fyssher Roger fisher 594438 594438 Fyssher, Roger, of Litlyngton, fisher 0
4934319 2337122 2337122 defendant Fenell Henry husbandman 594438 594438 Fenell, Henry, of Litlyngton, husbandman 0
4934320 2337122 2337122 defendant Pope William laborer 594438 594438 Pope, William, of Litlyngton, laborer 1
4934321 2337122 2337122 defendant Cheseman William husbandman 594438 594438 Cheseman, William, of Litlyngton, husbandman 2
4951911 2342547 2342547 defendant Monke Edward husbandman 594438 594438 Monke, Edward, of Litlyngton, husbandman 0
4953774 2343088 2343088 defendant Pete or Pece John husbandman 594438 594438 Pete or Pece, John, of Litlyngton, husbandman 2
4964512 2346292 2346292 defendant Botyller John husbandman 594438 594438 Botyller, John, of Litlyngton, husbandman 0
4964513 2346292 2346292 defendant Stoughton John husbandman 594438 594438 Stoughton, John, of Litlyngton, husbandman 1
4970079 2348001 2348001 defendant Roper John roper 594438 594438 Roper, John, of Litlyngton, roper 0
4973030 2348864 2348864 defendant William John yeoman 594438 594438 William, John, of Litlyngton, yeoman 0
4985073 2352464 2352464 defendant Pyty John husbandman 594438 594438 Pyty, John, of Litlyngton, husbandman 0
5068724 2377142 2377142 defendant Fenell Thomas husbandman 594438 594438 Fenell, Thomas, of Litlyngton, husbandman 0
5083782 2381653 2381653 plaintiff Fordere or atte Forde John (legal representative) 594438 594438 Fordere or atte Forde, John, of Litlyngton, executors of 0
5383221 2470274 2470274 defendant Hille John   594438 594438 Hille, John, of Litlyngton, husbandman, collectors of firsts and twelths 3
5397044 2474235 2474235 defendant Hille John   594438 594438 Hille, John, of Litlyngton, husbandman, tax collectors 1
5403250 2476013 2476013 plaintiff Hille John   594438 594438 Hille, John, of Litlyngton, husbandman, tax collectors 3
5410280 2478026 2478026 defendant Hille John husbandman 594438 594438 Hille, John, of Litlyngton, husbandman 3
5416356 2479809 2479809 defendant Bolnes Richard husbandman 594438 594438 together with Bolnes, Richard, of Litlyngton, husbandman 3
5431894 2484508 2484508 defendant Osbourn William husbandman 594438 594438 Osbourn, William, of Litlyngton, husbandman 1
5431896 2484508 2484508 defendant Osbourn Thomas husbandman 594438 594438 Osbourn, Thomas, of Litlyngton, husbandman 3
5481114 2499302 2499302 defendant Bolnest or Bolvest Richard husbandman 594438 594438 Bolnest or Bolvest, Richard, of Litlyngton, husbandman 4
5618131 2549491 2549491 plaintiff Martyn John   594438 594438 Martyn, John, of Litlyngton, on his own account 0
5618133 2549492 2549492 plaintiff Martyn John   594438 594438 Martyn, John, of Litlyngton, on his own account 0
5621161 2550501 2550501 plaintiff Squyper Thomas   594438 594438 Squyper, Thomas, of Litlyngton 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);