names

126 rows where place_id = 622173

✎ 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
3745619 1940536 1940536 defendant Smyth William clerk 622173 622173 Smyth, William, of Palgrave, clerk 0
3749134 1941660 1941660 defendant Fordham Thomas carpenter 622173 622173 Fordham, Thomas, of Palgrave, carpenter 0
3749135 1941660 1941660 defendant Fucher Thomas carpenter 622173 622173 Fucher, Thomas, of Palgrave, carpenter 1
3749136 1941660 1941660 defendant Coo William laborer 622173 622173 Coo, William, of Palgrave, laborer 2
3749137 1941660 1941660 defendant Fucher Simon laborer 622173 622173 Fucher, Simon, of Palgrave, laborer 3
3749138 1941660 1941660 defendant Crane Nicholas carpenter 622173 622173 Crane, Nicholas, of Palgrave, carpenter 4
3749148 1941663 1941663 defendant Fordham Thomas carpenter 622173 622173 Fordham, Thomas, of Palgrave, carpenter 0
3749149 1941663 1941663 defendant Fulcher Thomas carpenter 622173 622173 Fulcher, Thomas, of Palgrave, carpenter 1
3749150 1941663 1941663 defendant Coo William laborer 622173 622173 Coo, William, of Palgrave, laborer 2
3749151 1941663 1941663 defendant Fulcher Simon laborer 622173 622173 Fulcher, Simon, of Palgrave, laborer 3
3749152 1941663 1941663 defendant Crane Nicholas carpenter 622173 622173 Crane, Nicholas, of Palgrave, carpenter 4
3763824 1946331 1946331 defendant Smyth William clerk 622173 622173 Smyth, William, of Palgrave, clerk 0
3763825 1946331 1946331 defendant Seyve Walter laborer 622173 622173 Seyve, Walter, of Palgrave, laborer 1
3763826 1946331 1946331 defendant Seyve Simon husbandman 622173 622173 Seyve, Simon, of Palgrave, husbandman 2
3763827 1946331 1946331 defendant Coo William laborer 622173 622173 Coo, William, of Palgrave, laborer 3
3775194 1949975 1949975 defendant Prentyce John husbandman 622173 622173 Prentyce, John, of Palgrave, husbandman 0
3783151 1952488 1952488 defendant Smyth William clerk 622173 622173 Smyth, William, of Palgrave, clerk 0
3785179 1953155 1953155 defendant Herne Henry husbandman 622173 622173 Herne, Henry, of Palgrave, husbandman 0
3788346 1954155 1954155 defendant Hern Henry husbandman 622173 622173 Hern, Henry, of Palgrave, husbandman 0
3799715 1957831 1957831 defendant Smyth William clerk 622173 622173 Smyth, William, of Palgrave, clerk 0
3825556 1965846 1965846 defendant Penyng William roper 622173 622173 Penyng, William, of Palgrave, roper 3
3850212 1973658 1973658 defendant Gold John weaver 622173 622173 Gold, John, of Palgrave, weaver 4
3867707 1979436 1979436 defendant Homorsley Henry butcher 622173 622173 Homorsley, Henry, of Palgrave, butcher 1
3887262 1986005 1986005 defendant Gold John weaver 622173 622173 Gold, John, of Palgrave, weaver 1
3925320 1998779 1998779 defendant Prentyse John husbandman 622173 622173 Prentyse, John, of Palgrave, husbandman 2
3963747 2011923 2011923 defendant Fette George shoemaker 622173 622173 together with Fette, George, of Palgrave, shoemaker 1
3963748 2011923 2011923 defendant Fette John shoemaker 622173 622173 Fette, John, of Palgrave, shoemaker 2
4019239 2031615 2031615 defendant Aldred Roger yeoman 622173 622173 Aldred, Roger, of Palgrave, yeoman 0
4059946 2045953 2045953 plaintiff Crane Robert   622173 622173 Crane, Robert, of Palgrave 0
4060171 2046037 2046037 defendant Buckenham George tanner 622173 622173 Buckenham, George, of Palgrave, tanner 2
4080499 2053338 2053338 defendant Aldred Roger yeoman 622173 622173 Aldred, Roger, of Palgrave, yeoman 0
4141832 2075307 2075307 defendant Workman John   622173 622173 Workman, John, of Palgrave, surgeon 0
4155392 2079978 2079978 defendant Bowde alias Palmer John yeoman 622173 622173 Bowde alias Palmer, John, of Palgrave, yeoman 0
4155807 2080111 2080111 defendant Bowde alias Palmer John yeoman 622173 622173 Bowde alias Palmer, John, of Palgrave, yeoman 0
4160977 2081912 2081912 defendant Pulleyne Nicholas clerk 622173 622173 Pulleyne, Nicholas, of Palgrave, clerk 0
4175406 2086867 2086867 defendant Smyth William cooper 622173 622173 Smyth, William, of Palgrave, cooper 0
4177974 2087770 2087770 defendant Workman John   622173 622173 Workman, John, of Palgrave, surgeon 0
4177975 2087770 2087770 defendant Bowle William husbandman 622173 622173 Bowle, William, of Palgrave, husbandman 1
4193576 2093321 2093321 defendant Bowde alias Tayler John   622173 622173 Bowde alias Tayler, John, of Palgrave, Suff, sailor 1
4202315 2096352 2096352 defendant Austen William weaver 622173 622173 Austen, William, of Palgrave, weaver 0
4202781 2096517 2096517 defendant Skete John yeoman 622173 622173 Skete, John, of Palgrave, or of Harliston, Redenhall, Norf, yeoman 0
4204754 2097209 2097209 defendant Daynes Thomas sherman 622173 622173 Daynes, Thomas, of Palgrave, sherman 0
4204756 2097209 2097209 defendant Bowle William husbandman 622173 622173 Bowle, William, of Palgrave, husbandman 2
4205613 2097516 2097516 defendant Goslynge William yeoman 622173 622173 Goslynge, William, of Palgrave, yeoman 0
4209579 2098901 2098901 defendant Goddard Amos butcher 622173 622173 Goddard, Amos, of Palgrave, butcher 1
4209580 2098901 2098901 defendant Bowle William husbandman 622173 622173 Bowle, William, of Palgrave, husbandman 2
4214594 2100610 2100610 defendant Hendrye Thomas butcher 622173 622173 Hendrye, Thomas, of Palgrave, butcher 1
4218787 2102069 2102069 defendant Buckenham William, senior yeoman 622173 622173 Buckenham, William, senior, of Palgrave, yeoman 1
4218788 2102069 2102069 defendant Buckenham William, junior gent 622173 622173 Buckenham, William, junior, of Palgrave, gent 2
4232374 2106832 2106832 defendant Ryxe Edmund yeoman 622173 622173 Ryxe, Edmund, of Palgrave, yeoman 0
4232379 2106833 2106833 defendant Taylor alias Bowde John yeoman 622173 622173 Taylor alias Bowde, John, of Palgrave, yeoman 0
4244872 2111272 2111272 defendant Buckingham William, senior yeoman 622173 622173 Buckingham, William, senior, of Palgrave, yeoman 1
4244873 2111272 2111272 defendant Buckingham William, junior gent 622173 622173 Buckingham, William, junior, of Palgrave, gent 2
4259604 2116189 2116189 defendant Holmes Robert husbandman 622173 622173 Holmes, Robert, of Palgrave, husbandman 1
4259605 2116189 2116189 defendant Bache John cooper 622173 622173 Bache, John, of Palgrave, cooper 2
4277675 2122116 2122116 defendant Allen Daniel carpenter 622173 622173 Allen, Daniel, of Palgrave, carpenter 1
4283912 2124284 2124284 defendant Hendry Thomas butcher 622173 622173 Hendry, Thomas, of Palgrave, butcher 0
4288194 2125824 2125824 defendant Prentyse Thomas   622173 622173 Prentyse, Thomas, of Palgrave, wheelwright 0
4303941 2131512 2131512 defendant Buckenham William, junior yeoman 622173 622173 Buckenham, William, junior, of Palgrave, yeoman 1
4314132 2135048 2135048 defendant Awdley Edmund gent 622173 622173 Awdley, Edmund, of Palgrave, gent 0
4314135 2135049 2135049 defendant Awdley Edmund gent 622173 622173 Awdley, Edmund, of Palgrave, gent 1
4327755 2139608 2139608 defendant Buckenham William, junior yeoman 622173 622173 Buckenham, William, junior, of Palgrave, yeoman 1
4334015 2141657 2141657 defendant Hendry Thomas butcher 622173 622173 Hendry, Thomas, of Palgrave, butcher 0
4387246 2160382 2160382 defendant Multon John cordwainer 622173 622173 Multon, John, of Palgrave, cordwainer 0
4393214 2162337 2162337 defendant Whytte John husbandman 622173 622173 Whytte, John, of Palgrave, husbandman 0
4394475 2162748 2162748 defendant Gowen Nicholas husbandman 622173 622173 Gowen, Nicholas, of Palgrave, husbandman 3
4404052 2165926 2165926 defendant Deye Robert   622173 622173 Deye, Robert, of Palgrave, mason 1
4404054 2165926 2165926 defendant Martyn Elizabeth spinster 622173 622173 Martyn, Elizabeth, of Palgrave, spinster 3
4514962 2205087 2205087 defendant Edward John   622173 622173 Edward, John, of Palgrave 1
4521601 2207088 2207088 defendant Lek Nicholas   622173 622173 Lek, Nicholas, of Palgrave 4
4521610 2207089 2207089 defendant Lek Nicholas   622173 622173 Lek, Nicholas, of Palgrave 4
4532697 2210496 2210496 defendant Bernard John   622173 622173 Bernard, John, of Palgrave 0
4551674 2216472 2216472 plaintiff Edward John   622173 622173 Edward, John, of Palgrave 0
4554888 2217457 2217457 plaintiff Hare Reginald   622173 622173 Hare, Reginald, of Palgrave 0
4562593 2219859 2219859 plaintiff Prentys Mary   622173 622173 Prentys, Mary, of Palgrave 0
4562596 2219860 2219860 plaintiff Prentys Mary   622173 622173 Prentys, Mary, of Palgrave 0
4585179 2226787 2226787 defendant Canon Robert   622173 622173 Canon, Robert, of Palgrave 0
4599842 2231179 2231179 plaintiff Taillour Robert   622173 622173 Taillour, Robert, of Palgrave 0
4679392 2259170 2259170 defendant Bernarde John husbandman 622173 622173 Bernarde, John, of Palgrave, husbandman 0
4679393 2259171 2259171 plaintiff Kempe Robert   622173 622173 Kempe, Robert, of Palgrave, on his own account 0
4722716 2272422 2272422 defendant Copildych John   622173 622173 Copildych, John, of Palgrave, formerly parson 0
4749534 2280344 2280344 defendant Shepherd Seamus   622173 622173 Shepherd, Seamus, of Palgrave, parson 0
4787939 2292295 2292295 plaintiff Hare Agnes widow 622173 622173 Hare, Agnes, of Palgrave, widow 0
4787940 2292295 2292295 defendant Ketylbergh Seman clerk 622173 622173 Ketylbergh, Seman, of Palgrave, clerk 0
4790089 2292976 2292976 defendant Bladewyn John yeoman 622173 622173 Bladewyn, John, of Palgrave, yeoman 0
4808955 2298975 2298975 defendant Ketylbergh Seamus clerk 622173 622173 Ketylbergh, Seamus, of Palgrave, clerk 0
4835241 2307022 2307022 defendant Ketilbergh Seamus clerk 622173 622173 Ketilbergh, Seamus, of Palgrave, clerk 0
4846796 2310506 2310506 defendant Kyng Richard yeoman 622173 622173 Kyng, Richard, of Palgrave, yeoman 0
4847461 2310706 2310706 defendant Ketelbergh alias Shepherd Seamus   622173 622173 Ketelbergh alias Shepherd, Seamus, of Palgrave, parson & clerk 3
4882172 2321326 2321326 defendant Ketilberghe Seman clerk 622173 622173 Ketilberghe, Seman, of Palgrave, clerk 0
4912393 2330379 2330379 defendant Fulcher Robert yeoman 622173 622173 Fulcher, Robert, of Palgrave, yeoman 0
4917860 2332097 2332097 defendant Burdewas John chapman 622173 622173 Burdewas, John, of Palgrave, chapman 0
4976400 2349904 2349904 defendant Trayles Thomas chaplain 622173 622173 Trayles, Thomas, of Palgrave, chaplain 0
5023953 2363918 2363918 defendant Eve John yeoman 622173 622173 Eve, John, of Palgrave, yeoman 1
5068550 2377084 2377084 defendant Toly Walter yeoman 622173 622173 Toly, Walter, of Palgrave, yeoman 6
5085368 2382117 2382117 defendant Toly Walter husbandman 622173 622173 Toly, Walter, of Palgrave, husbandman 0
5090734 2383677 2383677 defendant Rese John pedder 622173 622173 Rese, John, of Palgrave, pedder 1
5100359 2386546 2386546 defendant Carke Thomas husbandman 622173 622173 Carke, Thomas, of Palgrave, husbandman 2
5121651 2392762 2392762 defendant Coteler William cutler 622173 622173 Coteler, William, of Palgrave, cutler 0
5123847 2393431 2393431 defendant Ketylberghe Seman clerk 622173 622173 Ketylberghe, Seman, of Palgrave, clerk 0

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