names

209 rows where place_id = 590356

✎ 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
3600762 1867898 1867898 defendant Walden Robert yeoman 590356 590356 Walden, Robert, of Oundell, yeoman 0
3619208 1873608 1873608 defendant Shakelo William miller 590356 590356 Shakelo, William, of Oundell, miller 1
3645654 1909040 1909040 defendant Broun Thomas smith 590356 590356 Broun, Thomas, of Oundell, smith 0
3670806 1916833 1916833 defendant Russheton John husbandman 590356 590356 Russheton, John, of Oundell, husbandman 0
3701031 1926571 1926571 defendant Herryson Richard husbandman 590356 590356 Herryson, Richard, of Oundell, husbandman 0
3756076 1943856 1943856 defendant Prestgrave Richard mercer 590356 590356 Prestgrave, Richard, of Oundell, mercer 0
3756080 1943858 1943858 defendant Emlen Thomas butcher 590356 590356 Emlen, Thomas, of Oundell, butcher 0
3783906 1952741 1952741 defendant Godewyn Henry tanner 590356 590356 Godewyn, Henry, of Oundell, tanner 0
3797031 1956951 1956951 plaintiff Fraunces Robert mercer 590356 590356 Fraunces, Robert, of Oundell, mercer 0
3800886 1958186 1958186 defendant Tego William draper 590356 590356 Tego, William, of Oundell, draper 0
3802733 1958752 1958752 defendant Baroth William gent 590356 590356 Baroth, William, of Oundell, gent 0
3813344 1962084 1962084 defendant Aphoell Philip gent 590356 590356 Aphoell, Philip, of Oundell, gent 0
3815275 1962693 1962693 defendant Rusheton John glover 590356 590356 Rusheton, John, of Oundell, glover 1
3819347 1963937 1963937 defendant Stokwell William yeoman 590356 590356 Stokwell, William, of Oundell, yeoman 0
3819348 1963937 1963937 defendant Nycoll John smith 590356 590356 Nycoll, John, of Oundell, smith 1
3820402 1964261 1964261 defendant Grene John shoemaker 590356 590356 Grene, John, of Oundell, shoemaker 0
3827823 1966567 1966567 defendant Dobbys Peter mercer 590356 590356 Dobbys, Peter, of Oundell, mercer 1
3865594 1978710 1978710 plaintiff Newbye James   590356 590356 Newbye, James, of Oundell 0
3891253 1987340 1987340 defendant Emlyn Thomas butcher 590356 590356 Emlyn, Thomas, of Oundell, butcher 2
3954782 2008740 2008740 plaintiff Loftes John   590356 590356 Loftes, John, of Oundell 2
3975747 2016079 2016079 plaintiff Hylton Henry glover 590356 590356 Hylton, Henry, of Oundell, glover 0
3975863 2016121 2016121 plaintiff Ives John   590356 590356 Ives, John, of Oundell 0
3996795 2023618 2023618 defendant Daye Thomas husbandman 590356 590356 Daye, Thomas, of Oundell, husbandman 0
4013886 2029696 2029696 plaintiff Rysley Robert (legal representative) 590356 590356 Rysley, Robert, of Oundell, draper, executor of 0
4091734 2057334 2057334 defendant Dytchefeld William innholder 590356 590356 Dytchefeld, William, of Oundell, innholder 0
4098130 2059658 2059658 defendant Pratte Thomas yeoman 590356 590356 Pratte, Thomas, of Oundell, yeoman 0
4274019 2120856 2120856 defendant Lawe Thomas tailor 590356 590356 Lawe, Thomas, of Oundell, tailor 0
4275689 2121443 2121443 defendant Crawthorn Henry yeoman 590356 590356 Crawthorn, Henry, of Oundell, yeoman 1
4309016 2133308 2133308 defendant Warriner Thomas yeoman 590356 590356 Warriner, Thomas, of Oundell, yeoman 0
4461463 2188665 2188665 plaintiff Staunford Robert   590356 590356 Staunford, Robert, of Oundell 0
4464506 2189567 2189567 defendant Waryn William   590356 590356 Waryn, William, of Oundell 0
4464508 2189568 2189568 defendant Waryn William   590356 590356 Waryn, William, of Oundell 0
4482595 2195258 2195258 defendant Saundres Richard   590356 590356 Saundres, Richard, of Oundell 1
4497537 2199874 2199874 plaintiff Draper William   590356 590356 Draper, William, of Oundell, on his own account 0
4498645 2200217 2200217 plaintiff Fysshere Thomas   590356 590356 Fysshere, Thomas, of Oundell 0
4498646 2200217 2200217 defendant Dod John milner 590356 590356 Dod, John, of Oundell, milner 0
4504252 2201884 2201884 defendant Sawere Emma   590356 590356 Sawere, Emma, of Oundell 0
4520543 2206775 2206775 defendant Chaloner Robert   590356 590356 Chaloner, Robert, of Oundell 0
4532727 2210504 2210504 plaintiff Pymour John   590356 590356 Pymour, John, of Oundell 0
4532728 2210504 2210504 defendant Barbour John   590356 590356 Barbour, John, of Oundell 0
4552603 2216768 2216768 defendant Chaloner Robert   590356 590356 Chaloner, Robert, of Oundell 0
4557242 2218198 2218198 defendant Waryn William   590356 590356 Waryn, William, of Oundell 0
4563125 2220034 2220034 defendant Reynold Athelmanus   590356 590356 Reynold, Athelmanus, of Oundell 0
4569106 2221927 2221927 plaintiff Waryn William   590356 590356 Waryn, William, of Oundell 0
4569107 2221927 2221927 defendant Draper John   590356 590356 Draper, John, of Oundell 0
4569108 2221927 2221927 defendant Lyve William   590356 590356 Lyve, William, of Oundell 1
4569109 2221927 2221927 defendant Shepherd Robert   590356 590356 Shepherd, Robert, of Oundell 2
4570201 2222249 2222249 defendant Draper William   590356 590356 Draper, William, of Oundell 0
4574004 2223391 2223391 defendant Yong Robert   590356 590356 Yong, Robert, of Oundell 0
4574005 2223391 2223391 defendant Yonge Agnes   590356 590356 Yonge, Agnes, of Oundell 1
4574006 2223391 2223391 defendant Brymboll (illegible)   590356 590356 Brymboll, _, of Oundell 2
4585379 2226849 2226849 defendant Sponer John   590356 590356 Sponer, John, of Oundell 0
4595623 2229897 2229897 defendant Sawer William   590356 590356 Sawer, William, of Oundell 1
4596978 2230298 2230298 plaintiff Sawere William   590356 590356 Sawere, William, of Oundell 0
4597160 2230352 2230352 defendant Sawer William   590356 590356 Sawer, William, of Oundell 0
4598025 2230637 2230637 defendant Catour Walter   590356 590356 Catour, Walter, of Oundell 5
4599199 2230961 2230961 plaintiff Stoke John   590356 590356 Stoke, John, of Oundell 0
4601701 2231749 2231749 plaintiff Walker John   590356 590356 Walker, John, of Oundell 0
4608889 2233882 2233882 defendant Pyamour John smith 590356 590356 Pyamour, John, of Oundell, smith 3
4611663 2234708 2234708 defendant Cotour Robert butcher 590356 590356 Cotour, Robert, of Oundell, butcher 0
4621119 2237588 2237588 plaintiff Knyght Richard   590356 590356 Knyght, Richard, of Oundell 0
4625043 2238796 2238796 defendant Knyght William   590356 590356 Knyght, William, of Oundell 1
4625047 2238797 2238797 defendant Knyght William   590356 590356 Knyght, William, of Oundell 1
4626854 2239341 2239341 defendant Milner John   590356 590356 Milner, John, of Oundell 0
4631029 2240598 2240598 defendant Grene William   590356 590356 Grene, William, of Oundell 1
4634589 2241671 2241671 defendant Bocher John   590356 590356 Bocher, John, of Oundell 0
4640489 2243330 2243330 defendant Catour Robert   590356 590356 Catour, Robert, of Oundell 1
4640492 2243331 2243331 defendant Catour Robert   590356 590356 Catour, Robert, of Oundell 1
4646591 2245069 2245069 defendant Wryght Walter   590356 590356 Wryght, Walter, of Oundell 0
4650619 2246200 2246200 defendant Bocher alias Bartlot John   590356 590356 Bocher alias Bartlot, John, of Oundell 0
4654952 2247432 2247432 defendant Chery John tailor 590356 590356 Chery, John, of Oundell, tailor 0
4667134 2255456 2255456 defendant Gryndell Stephen yeoman 590356 590356 Gryndell, Stephen, of Oundell, yeoman 0
4667135 2255456 2255456 defendant Couper Robert cooper 590356 590356 Couper, Robert, of Oundell, cooper 1
4671752 2256810 2256810 defendant Bocher John butcher 590356 590356 Bocher, John, of Oundell, butcher 0
4686449 2261366 2261366 defendant Katour Walter butcher 590356 590356 Katour, Walter, of Oundell, butcher 0
4691226 2262775 2262775 defendant Skynner Philip skinner 590356 590356 Skynner, Philip, of Oundell, skinner 0
4691227 2262775 2262775 defendant Sponer William glover 590356 590356 Sponer, William, of Oundell, glover 1
4697754 2264791 2264791 defendant Catour Walter butcher 590356 590356 Catour, Walter, of Oundell, butcher 0
4699331 2265256 2265256 plaintiff Drake Thomas   590356 590356 Drake, Thomas, of Oundell 0
4705265 2267017 2267017 defendant Bocher John butcher 590356 590356 Bocher, John, of Oundell, butcher 0
4709593 2268360 2268360 defendant Gryndyll Stephen yeoman 590356 590356 Gryndyll, Stephen, of Oundell, yeoman 0
4709597 2268362 2268362 defendant Gryndyll Stephen husbandman 590356 590356 Gryndyll, Stephen, of Oundell, husbandman 0
4713607 2269579 2269579 defendant Pebworth John husbandman 590356 590356 Pebworth, John, of Oundell, husbandman 0
4713608 2269579 2269579 defendant Stoke John husbandman 590356 590356 Stoke, John, of Oundell, husbandman 1
4716116 2270346 2270346 defendant Catour Walter butcher 590356 590356 Catour, Walter, of Oundell, butcher 0
4719950 2271586 2271586 defendant Chaundeler William chandler 590356 590356 Chaundeler, William, of Oundell, chandler 0
4727859 2273955 2273955 defendant Catour Walter husbandman 590356 590356 Catour, Walter, of Oundell, husbandman 0
4727860 2273955 2273955 defendant Cherye John tailor 590356 590356 Cherye, John, of Oundell, tailor 1
4741860 2278115 2278115 defendant Catour Walter butcher 590356 590356 Catour, Walter, of Oundell, butcher 1
4743073 2278493 2278493 defendant Garland John shoemaker 590356 590356 Garland, John, of Oundell, shoemaker 0
4753701 2281531 2281531 defendant Sawer William husbandman 590356 590356 Sawer, William, of Oundell, husbandman 2
4754468 2281777 2281777 defendant Sponer William glover 590356 590356 Sponer, William, of Oundell, glover 1
4755293 2282043 2282043 defendant Sponer William husbandman 590356 590356 Sponer, William, of Oundell, husbandman 0
4756937 2282537 2282537 defendant Couper Roger husbandman 590356 590356 Couper, Roger, of Oundell, husbandman 0
4757535 2282737 2282737 defendant Cranehowe Thomas husbandman 590356 590356 Cranehowe, Thomas, of Oundell, husbandman 0
4761304 2283882 2283882 defendant Sawyer William yeoman 590356 590356 Sawyer, William, of Oundell, yeoman 0
4767690 2285874 2285874 defendant Catour Walter yeoman 590356 590356 Catour, Walter, of Oundell, yeoman 0
4774935 2288156 2288156 defendant Sawer William husbandman 590356 590356 Sawer, William, of Oundell, husbandman 2
4778924 2289385 2289385 defendant Canowe Thomas husbandman 590356 590356 Canowe, Thomas, of Oundell, husbandman 0
4778925 2289385 2289385 defendant Thirnyng John skinner 590356 590356 Thirnyng, John, of Oundell, skinner 1

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