names

66 rows where place_id = 601937

✎ 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
3647750 1909688 1909688 plaintiff Manshyppe Richard   601937 601937 Manshyppe, Richard, of Ersham 0
3647751 1909688 1909688 defendant Daldy Robert husbandman 601937 601937 Daldy, Robert, of Ersham, husbandman 0
3664891 1914965 1914965 defendant Clerke John husbandman 601937 601937 Clerke, John, of Ersham, husbandman 1
3664903 1914969 1914969 defendant Clerke John husbandman 601937 601937 Clerke, John, of Ersham, husbandman 1
3674688 1918131 1918131 defendant Legge Robert clerk 601937 601937 Legge, Robert, of Ersham, clerk 1
3679574 1919680 1919680 defendant Leg Robert clerk 601937 601937 Leg, Robert, of Ersham, clerk 0
3789440 1954523 1954523 defendant Jay Thomas, junior laborer 601937 601937 Jay, Thomas, junior, of Ersham, laborer 0
3789441 1954523 1954523 defendant Aldewyn John husbandman 601937 601937 Aldewyn, John, of Ersham, husbandman 1
3916114 1995774 1995774 defendant Beamond John husbandman 601937 601937 Beamond, John, of Ersham, husbandman 1
3922226 1997742 1997742 defendant Jaye John tanner 601937 601937 Jaye, John, of Ersham, tanner 1
3922230 1997743 1997743 defendant Jaye John tanner 601937 601937 Jaye, John, of Ersham, tanner 2
3943925 2004986 2004986 defendant Blande James tanner 601937 601937 Blande, James, of Ersham, tanner 0
3947409 2006168 2006168 defendant More Thomas tailor 601937 601937 More, Thomas, of Ersham, tailor 0
3959044 2010245 2010245 plaintiff Sawer John husbandman 601937 601937 Sawer, John, of Ersham, husbandman 0
3959046 2010245 2010245 defendant Sperhall John husbandman 601937 601937 Sperhall, John, of Ersham, husbandman 1
3971731 2014674 2014674 defendant Walker Edmund   601937 601937 Walker, Edmund, of Ersham. Yeoman 0
4191096 2092449 2092449 defendant Cobbe Richard tanner 601937 601937 Cobbe, Richard, of Ersham, tanner 2
4194374 2093582 2093582 defendant Chynglewood Thomas yeoman 601937 601937 Chynglewood, Thomas, of Ersham, yeoman 1
4214546 2100594 2100594 defendant Smyth Thomas miller 601937 601937 Smyth, Thomas, of Ersham, miller 0
4221445 2102992 2102992 defendant Nicolson Michael clerk 601937 601937 Nicolson, Michael, of Ersham, clerk 1
4224076 2103908 2103908 defendant Smyth Thomas miller 601937 601937 Smyth, Thomas, of Ersham, miller 0
4247281 2112067 2112067 defendant Nicolson Michael clerk 601937 601937 Nicolson, Michael, of Ersham, clerk 1
4274589 2121056 2121056 defendant Leyton Henry miller 601937 601937 Leyton, Henry, of Ersham, miller 1
4291722 2127116 2127116 defendant Story Richard beer brewer 601937 601937 Story, Richard, of Ersham, beer brewer 0
4312451 2134492 2134492 defendant Goodwyn Henry husbandman 601937 601937 Goodwyn, Henry, of Ersham, husbandman 0
4320231 2137177 2137177 defendant Shinglewoode Thomas yeoman 601937 601937 Shinglewoode, Thomas, of Ersham, yeoman 0
4323074 2138131 2138131 defendant Drewrye John cooper 601937 601937 Drewrye, John, of Ersham, cooper 1
4324934 2138724 2138724 defendant Story Richard yeoman 601937 601937 Story, Richard, of Ersham, yeoman 0
4337726 2142942 2142942 defendant Neave John husbandman 601937 601937 Neave, John, of Ersham, husbandman 0
4386220 2160070 2160070 defendant Leighton Henry husbandman 601937 601937 Leighton, Henry, of Ersham, husbandman 3
4386226 2160071 2160071 defendant Leighton Henry husbandman 601937 601937 Leighton, Henry, of Ersham, husbandman 3
4516094 2205447 2205447 defendant Chittok John   601937 601937 Chittok, John, of Ersham 2
4516102 2205449 2205449 defendant Chyttok John   601937 601937 Chyttok, John, of Ersham 2
4593936 2229379 2229379 defendant Gardener John   601937 601937 Gardener, John, of Ersham 3
4753554 2281484 2281484 defendant Feton John yeoman 601937 601937 Feton, John, of Ersham, yeoman 0
4838808 2308067 2308067 defendant Thurleton John husbandman 601937 601937 Thurleton, John, of Ersham, husbandman 0
4897893 2326000 2326000 plaintiff Thoryngton Robert   601937 601937 Thoryngton, Robert, of Ersham, freemason 0
4911675 2330152 2330152 defendant Bradfeld Henry   601937 601937 Bradfeld, Henry, of Ersham, parson 0
4987166 2353109 2353109 defendant Ayldre Robert sawer 601937 601937 Ayldre, Robert, of Ersham, sawer 0
4987167 2353109 2353109 defendant Hyrdeler John husbandman 601937 601937 Hyrdeler, John, of Ersham, husbandman 1
4987169 2353109 2353109 defendant Manschepe Thomas carpenter 601937 601937 Manschepe, Thomas, of Ersham, carpenter 3
4987170 2353109 2353109 defendant Horn John, sen husbandman 601937 601937 Horn, John, sen, of Ersham, husbandman 4
4987171 2353109 2353109 defendant Belward John husbandman 601937 601937 Belward, John, of Ersham, husbandman 5
5035950 2367369 2367369 defendant Baxtere Richard yeoman 601937 601937 Baxtere, Richard, of Ersham, yeoman 1
5055733 2373285 2373285 defendant Baxter Richard yeoman 601937 601937 Baxter, Richard, of Ersham, yeoman 0
5076696 2379529 2379529 defendant Latchecold Thomas husbandman 601937 601937 Latchecold, Thomas, of Ersham, husbandman 0
5076697 2379529 2379529 defendant Herdeler John sawyer 601937 601937 Herdeler, John, of Ersham, sawyer 1
5084982 2382016 2382016 defendant Clyfton Robert gent 601937 601937 Clyfton, Robert, of Ersham, gent 0
5095260 2385031 2385031 defendant Clyfton Robert esq 601937 601937 Clyfton, Robert, of Ersham, esq 1
5098479 2385986 2385986 defendant Baxter Richard yeoman 601937 601937 Baxter, Richard, of Ersham, yeoman 0
5122531 2393020 2393020 defendant Baxter Richard yeoman 601937 601937 Baxter, Richard, of Ersham, yeoman 0
5124268 2393545 2393545 defendant Bolytout or Bolytont Walter chaplain 601937 601937 Bolytout or Bolytont, Walter, of Ersham, or of Manytre, Essex, chaplain 1
5162723 2404818 2404818 defendant Baxter Richard yeoman 601937 601937 Baxter, Richard, of Ersham, yeoman 0
5241785 2427799 2427799 defendant Wynchecombe William clerk 601937 601937 Wynchecombe, William, of Ersham, clerk 2
5251244 2430491 2430491 defendant Goodwyn John husbandman 601937 601937 Goodwyn, John, of Ersham, husbandman 3
5253757 2431288 2431288 defendant Pyke Adam (legal representative) 601937 601937 Pyke, Adam, of Ersham, carpenter, executor of 0
5253758 2431288 2431288 defendant Pyke William yeoman 601937 601937 Pyke, William, of Ersham, yeoman 1
5270092 2436359 2436359 defendant Pyke John yeoman 601937 601937 Pyke, John, of Ersham, yeoman 1
5281912 2439787 2439787 defendant Pyke William yeoman 601937 601937 Pyke, William, of Ersham, yeoman 0
5315018 2449545 2449545 defendant Perkyn Robert husbandman 601937 601937 Perkyn, Robert, of Ersham, husbandman 0
5412271 2478620 2478620 defendant Elden Thomas miller 601937 601937 Elden, Thomas, of Ersham, miller 8
5426968 2483004 2483004 defendant Elam Thomas miller 601937 601937 Elam, Thomas, of Ersham, miller 7
5454486 2491254 2491254 defendant Elam Thomas miller 601937 601937 Elam, Thomas, of Ersham, miller 3
5457936 2492274 2492274 plaintiff Eleham Thomas   601937 601937 Eleham, Thomas, of Ersham 0
5466374 2494878 2494878 defendant Elam Thomas miller 601937 601937 Elam, Thomas, of Ersham, miller 3
5607413 2537212 2537212 defendant Parke John laborer 601937 601937 Parke, John, of Ersham, laborer 4

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