names

57 rows where place_id = 607898

✎ 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
3671358 1917018 1917018 defendant Pake Robert laborer 607898 607898 Pake, Robert, of Hatfeld Regis, laborer 1
3758593 1944684 1944684 defendant Taverner Walter butcher 607898 607898 Taverner, Walter, of Hatfeld Regis, butcher 2
3769246 1948037 1948037 plaintiff Ray George   607898 607898 Ray, George, of Hatfeld Regis 0
3769247 1948037 1948037 plaintiff Churche Stephen   607898 607898 Churche, Stephen, of Hatfeld Regis 1
3769248 1948037 1948037 defendant Lyttell John yeoman 607898 607898 Lyttell, John, of Hatfeld Regis, yeoman 0
3787058 1953746 1953746 defendant Lyttell Roger husbandman 607898 607898 Lyttell, Roger, of Hatfeld Regis, husbandman 0
3787061 1953747 1953747 defendant Lyttell John smith 607898 607898 Lyttell, John, of Hatfeld Regis, smith 0
3787064 1953748 1953748 defendant Lyttell Roger husbandman 607898 607898 Lyttell, Roger, of Hatfeld Regis, husbandman 0
3801929 1958502 1958502 defendant Glascok Thomas butcher 607898 607898 Glascok, Thomas, of Hatfeld Regis, butcher 0
3836870 1969431 1969431 defendant Glascok Thomas yeoman 607898 607898 Glascok, Thomas, of Hatfeld Regis, yeoman 0
3838085 1969826 1969826 defendant Baryngton John esq 607898 607898 Baryngton, John, of Hatfeld Regis, esq 0
3848584 1973140 1973140 defendant Glascok Thomas yeoman 607898 607898 Glascok, Thomas, of Hatfeld Regis, yeoman 1
3848585 1973140 1973140 defendant Strete William shoemaker 607898 607898 Strete, William, of Hatfeld Regis, shoemaker 2
3848586 1973140 1973140 defendant Hasylwode Richard shoemaker 607898 607898 Hasylwode, Richard, of Hatfeld Regis, shoemaker 3
3853246 1974633 1974633 defendant Launcey William grocer 607898 607898 Launcey, William, of Hatfeld Regis, grocer 0
3878009 1982888 1982888 defendant Knolles Godfrey laborer 607898 607898 Knolles, Godfrey, of Hatfeld Regis, laborer 5
3886762 1985831 1985831 defendant Hubberd Robert husbandman 607898 607898 Hubberd, Robert, of Hatfeld Regis, husbandman 0
3894671 1988423 1988423 defendant Avurye Thomas butcher 607898 607898 Avurye, Thomas, of Hatfeld Regis, butcher 0
3920861 1997321 1997321 defendant Lukyn Thomas husbandman 607898 607898 Lukyn, Thomas, of Hatfeld Regis, husbandman 0
4458103 2187565 2187565 defendant Smyth William   607898 607898 Smyth, William, of Hatfeld Regis 0
4466874 2190307 2190307 defendant Leget John   607898 607898 Leget, John, of Hatfeld Regis 0
4487461 2196793 2196793 defendant Eppyng John   607898 607898 Eppyng, John, of Hatfeld Regis 0
4512006 2204194 2204194 defendant Frenssh Thomas   607898 607898 Frenssh, Thomas, of Hatfeld Regis 0
4562735 2219902 2219902 defendant Crede Thomas   607898 607898 Crede, Thomas, of Hatfeld Regis 0
4574523 2223562 2223562 defendant Lancastre Gunnor   607898 607898 Lancastre, Gunnor, of Hatfeld Regis 1
4625972 2239078 2239078 defendant Doucehed John   607898 607898 Doucehed, John, of Hatfeld Regis 2
4662416 2249719 2249719 defendant Caumpe John fisher 607898 607898 Caumpe, John, of Hatfeld Regis, fisher 2
4678609 2258915 2258915 defendant Smyth John husbandman 607898 607898 Smyth, John, of Hatfeld Regis, husbandman 2
4700851 2265668 2265668 plaintiff Forde William   607898 607898 Forde, William, of Hatfeld Regis 0
4751429 2280900 2280900 defendant Speller Willliam laborer 607898 607898 Speller, Willliam, of Hatfeld Regis, laborer 1
4785204 2291390 2291390 plaintiff Eppyng John (legal representative) 607898 607898 Eppyng, John, of Hatfeld Regis, executrix of 0
4791079 2293308 2293308 defendant Burton John husbandman 607898 607898 Burton, John, of Hatfeld Regis, husbandman 0
4797856 2295508 2295508 defendant Whithed Thomas husbandman 607898 607898 Whithed, Thomas, of Hatfeld Regis, husbandman 0
4897385 2325841 2325841 plaintiff House John gent 607898 607898 House, John, of Hatfeld Regis, gent 0
4899696 2326538 2326538 defendant Taillour John yeoman 607898 607898 Taillour, John, of Hatfeld Regis, yeoman 0
4962693 2345748 2345748 defendant Tanfeld William, junior yeoman 607898 607898 Tanfeld, William, junior, of Hatfeld Regis, yeoman 2
4962699 2345749 2345749 defendant Tanfeld William, junior yeoman 607898 607898 Tanfeld, William, junior, of Hatfeld Regis, yeoman 2
4979833 2350923 2350923 defendant Clerk Thomas husbandman 607898 607898 Clerk, Thomas, of Hatfeld Regis, husbandman 3
4979839 2350924 2350924 defendant Clerk Thomas husbandman 607898 607898 Clerk, Thomas, of Hatfeld Regis, husbandman 3
5112162 2389942 2389942 plaintiff House John, senior   607898 607898 House, John, senior, of Hatfeld Regis, administrators of 0
5112165 2389942 2389942 plaintiff Barbour William, junior   607898 607898 Barbour, William, junior, of Hatfeld Regis 3
5112174 2389943 2389943 plaintiff Barbour William, junior   607898 607898 Barbour, William, junior, of Hatfeld Regis 3
5183063 2410790 2410790 defendant House John gent 607898 607898 House, John, of Hatfeld Regis, gent 0
5207171 2417837 2417837 defendant Bradshawe Thomas gent 607898 607898 Bradshawe, Thomas, of Hatfeld Regis, gent 2
5207173 2417837 2417837 defendant Harre John fishmonger 607898 607898 Harre, John, of Hatfeld Regis, fishmonger 4
5223807 2422648 2422648 plaintiff Hoke Richard   607898 607898 Hoke, Richard, of Hatfeld Regis 1
5223811 2422649 2422649 plaintiff Hoke Richard   607898 607898 Hoke, Richard, of Hatfeld Regis 1
5278773 2438901 2438901 defendant Palmere John husbandman 607898 607898 Palmere, John, of Hatfeld Regis, husbandman 0
5359001 2462864 2462864 defendant Pryour Eleanor (legal representative) 607898 607898 Pryour, Eleanor, of Hatfeld Regis, executor of 0
5359002 2462864 2462864 defendant Chalk John gent 607898 607898 Chalk, John, of Hatfeld Regis, gent 1
5482337 2499661 2499661 defendant Skete John baker 607898 607898 Skete, John, of Hatfeld Regis, baker 0
5482338 2499661 2499661 defendant Pery Thomas smith 607898 607898 Pery, Thomas, of Hatfeld Regis, smith 1
5482341 2499661 2499661 defendant Crusshe John husbandman 607898 607898 Crusshe, John, of Hatfeld Regis, husbandman 4
5510392 2508091 2508091 defendant Pery Thomas smith 607898 607898 Pery, Thomas, of Hatfeld Regis, smith 0
5510394 2508091 2508091 defendant Crusse John husbandman 607898 607898 Crusse, John, of Hatfeld Regis, husbandman 2
5610699 2547066 2547066 plaintiff Barynton John   607898 607898 Barynton, John, of Hatfeld Regis, on his own account 0
5615995 2548799 2548799 defendant atte Water Robert   607898 607898 atte Water, Robert, of Hatfeld Regis 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);