names

58 rows where place_id = 585998

✎ 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
3587658 1863786 1863786 defendant Fendyke Swilliam husbandman 585998 585998 Fendyke, Swilliam, of Keteryngham, husbandman 0
3589184 1864261 1864261 defendant Grey Henry   585998 585998 Grey, Henry, of Keteryngham, knight 0
3589185 1864261 1864261 defendant Hevenyngham Thomas esq 585998 585998 Hevenyngham, Thomas, of Keteryngham, esq 1
3592143 1865161 1865161 defendant Grey Henry   585998 585998 Grey, Henry, of Keteryngham, knight 0
3592145 1865162 1865162 defendant Grey Henry   585998 585998 Grey, Henry, of Keteryngham, knight 0
3592807 1865362 1865362 defendant Fendyke William husbandman 585998 585998 Fendyke, William, of Keteryngham, husbandman 0
3592809 1865363 1865363 defendant Fendyke William husbandman 585998 585998 Fendyke, William, of Keteryngham, husbandman 0
3593317 1865541 1865541 defendant Grey Henry   585998 585998 Grey, Henry, of Keteryngham, knight 0
3593318 1865541 1865541 defendant Hevenyngham Thomas esq 585998 585998 Hevenyngham, Thomas, of Keteryngham, esq 1
3593323 1865543 1865543 defendant Hevenyngham Thomas esq 585998 585998 Hevenyngham, Thomas, of Keteryngham, esq 0
3593325 1865544 1865544 defendant Hevenyngham Thomas esq 585998 585998 Hevenyngham, Thomas, of Keteryngham, esq 0
3602692 1868505 1868505 defendant Hevenyngham Thomas esq 585998 585998 Hevenyngham, Thomas, of Keteryngham, esq 0
3701821 1926821 1926821 defendant Rudde Robert husbandman 585998 585998 Rudde, Robert, of Keteryngham, husbandman 1
3701822 1926821 1926821 defendant Pycher Thomas husbandman 585998 585998 Pycher, Thomas, of Keteryngham, husbandman 2
3884033 1984929 1984929 defendant Hevenyngham Anthony esq 585998 585998 Hevenyngham, Anthony, of Keteryngham, esq 0
4139638 2074539 2074539 defendant Skoles Robert husbandman 585998 585998 Skoles, Robert, of Keteryngham, husbandman 3
4331559 2140851 2140851 defendant Westwraye John yeoman 585998 585998 Westwraye, John, of Keteryngham, yeoman 3
4345108 2145563 2145563 defendant Dall Robert yeoman 585998 585998 Dall, Robert, of Keteryngham, yeoman 0
4458170 2187590 2187590 defendant Waggestaff John   585998 585998 Waggestaff, John, of Keteryngham 0
4458172 2187591 2187591 defendant Waggestaff John   585998 585998 Waggestaff, John, of Keteryngham 0
4463622 2189321 2189321 defendant Awe John   585998 585998 Awe, John, of Keteryngham 0
4583798 2226349 2226349 defendant Bysshop John   585998 585998 Bysshop, John, of Keteryngham 0
4624694 2238706 2238706 defendant Skit Roger   585998 585998 Skit, Roger, of Keteryngham, parson of All Saints church in Somerton 1
4632356 2241008 2241008 defendant Eliot John esq 585998 585998 Eliot, John, of Keteryngham, esq 0
4649303 2245846 2245846 defendant Elyot John esq 585998 585998 Elyot, John, of Keteryngham, esq 0
4692809 2263262 2263262 defendant Wanstaf John laborer 585998 585998 Wanstaf, John, of Keteryngham, laborer 2
4751725 2280992 2280992 plaintiff Spycer John   585998 585998 Spycer, John, of Keteryngham, on his own account 0
4863086 2315434 2315434 defendant FitzRaff Robert esq 585998 585998 FitzRaff, Robert, of Keteryngham, esq 1
4872439 2318345 2318345 defendant Wode John husbandman 585998 585998 Wode, John, of Keteryngham, husbandman 0
4891016 2323928 2323928 defendant FitzPers Lawrence gent 585998 585998 FitzPers, Lawrence, of Keteryngham, gent 6
4923919 2333919 2333919 defendant Goldspynk Richard yeoman 585998 585998 Goldspynk, Richard, of Keteryngham, yeoman 7
4936729 2337868 2337868 defendant Monford Nicholas gent 585998 585998 Monford, Nicholas, of Keteryngham, gent 0
5045134 2370174 2370174 defendant Fuller Simon clerk 585998 585998 Fuller, Simon, of Keteryngham, clerk 0
5080760 2380736 2380736 defendant Wode John husbandman 585998 585998 Wode, John, of Keteryngham, husbandman 0
5109977 2389348 2389348 plaintiff Gray Henry esq 585998 585998 Gray, Henry, of Keteryngham, esq 0
5110547 2389483 2389483 defendant Sygon John yeoman 585998 585998 Sygon, John, of Keteryngham, yeoman 2
5166619 2405956 2405956 defendant Martyn Robert esq 585998 585998 Martyn, Robert, of Keteryngham, esq 0
5243895 2428407 2428407 defendant Benet John yeoman 585998 585998 Benet, John, of Keteryngham, yeoman 2
5258212 2432690 2432690 plaintiff Gray Henry esq 585998 585998 Gray, Henry, of Keteryngham, esq 0
5258216 2432691 2432691 plaintiff Gray Henry esq 585998 585998 Gray, Henry, of Keteryngham, esq 0
5276100 2438085 2438085 defendant Benet John husbandman 585998 585998 Benet, John, of Keteryngham, husbandman 0
5287250 2441294 2441294 defendant Hobard Robert yeoman 585998 585998 Hobard, Robert, of Keteryngham, yeoman 0
5287251 2441294 2441294 defendant Hurry Thomas husbandman 585998 585998 Hurry, Thomas, of Keteryngham, husbandman 1
5287252 2441294 2441294 defendant Benet John husbandman 585998 585998 Benet, John, of Keteryngham, husbandman 2
5287253 2441294 2441294 defendant Webster William husbandman 585998 585998 Webster, William, of Keteryngham, husbandman 3
5287254 2441294 2441294 defendant Brandon Robert husbandman 585998 585998 Brandon, Robert, of Keteryngham, husbandman 4
5287255 2441294 2441294 defendant Barsham John husbandman 585998 585998 Barsham, John, of Keteryngham, husbandman 5
5287256 2441294 2441294 defendant Calowe John laborer 585998 585998 Calowe, John, of Keteryngham, laborer 6
5287257 2441294 2441294 defendant Benet Richard laborer 585998 585998 Benet, Richard, of Keteryngham, laborer 7
5304797 2446438 2446438 defendant Puttok Edmund husbandman 585998 585998 Puttok, Edmund, of Keteryngham, husbandman 0
5320397 2451184 2451184 defendant Puttok Edmund (legal representative) 585998 585998 Puttok, Edmund, of Keteryngham, shepherd, executor of 6
5320398 2451184 2451184 defendant Puttok John husbandman 585998 585998 Puttok, John, of Keteryngham, husbandman 7
5351369 2460526 2460526 defendant Burgh Edmund yeoman or butcher 585998 585998 Burgh, Edmund, of Keteryngham, yeoman or butcher 1
5460139 2492965 2492965 defendant Hurry Thomas husbandman 585998 585998 Hurry, Thomas, of Keteryngham, husbandman 6
5471774 2496510 2496510 defendant Hurry Thomas husbandman 585998 585998 Hurry, Thomas, of Keteryngham, husbandman 6
5483183 2499910 2499910 defendant Hurry Thomas husbandman 585998 585998 Hurry, Thomas, of Keteryngham, husbandman 1
5484335 2500235 2500235 defendant Duke John husbandman 585998 585998 Duke, John, of Keteryngham, husbandman 0
5520447 2511214 2511214 defendant Barton George husbandman 585998 585998 Barton, George, of Keteryngham, husbandman 5

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