names

88 rows where place_id = 597305

✎ 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
3628021 1903617 1903617 defendant Lemyng Robert yeoman 597305 597305 Lemyng, Robert, of Oxton, yeoman 0
3637598 1906570 1906570 plaintiff Soothorn or Scothorn William husbandman 597305 597305 Soothorn or Scothorn, William, of Oxton, husbandman 0
3667108 1915644 1915644 defendant Sturton Thomas husbandman 597305 597305 Sturton, Thomas, of Oxton, husbandman 0
3682474 1920620 1920620 plaintiff Tayllour Richard clerk 597305 597305 Tayllour, Richard, of Oxton, clerk 0
3703811 1927471 1927471 defendant Styrton alias Asturton Thomas yeoman 597305 597305 Styrton alias Asturton, Thomas, of Oxton, yeoman 0
3733375 1936672 1936672 defendant Styrton Thomas yeoman 597305 597305 Styrton, Thomas, of Oxton, yeoman 0
3761055 1945459 1945459 defendant Styrton Thomas yeoman 597305 597305 Styrton, Thomas, of Oxton, yeoman 0
3799084 1957622 1957622 defendant Bylley Reginald husbandman 597305 597305 Bylley, Reginald, of Oxton, husbandman 2
3838046 1969811 1969811 defendant Aveson Thomas tailor 597305 597305 Aveson, Thomas, of Oxton, tailor 1
3902585 1991096 1991096 defendant Samon Anthony mercer 597305 597305 Samon, Anthony, of Oxton, mercer 1
4057677 2045129 2045129 defendant Sherbrooke Thomas, junior yeoman 597305 597305 Sherbrooke, Thomas, junior, of Oxton, yeoman 0
4057678 2045129 2045129 defendant Sherbrooke John yeoman 597305 597305 Sherbrooke, John, of Oxton, yeoman 1
4057679 2045129 2045129 defendant Lupton William husbandman 597305 597305 Lupton, William, of Oxton, husbandman 2
4076297 2051815 2051815 defendant Treves Edmund yeoman 597305 597305 Treves, Edmund, of Oxton, yeoman 0
4076298 2051815 2051815 defendant Blythe John husbandman 597305 597305 Blythe, John, of Oxton, husbandman 1
4085075 2054943 2054943 defendant Myers Mathew yeoman 597305 597305 Myers, Mathew, of Oxton, yeoman 1
4085076 2054943 2054943 defendant Marshall Alexander yeoman 597305 597305 Marshall, Alexander, of Oxton, yeoman 2
4114648 2065528 2065528 defendant Bacon John husbandman 597305 597305 Bacon, John, of Oxton, or of Swanwicke, Derbs, husbandman 0
4150648 2078364 2078364 defendant Melton William husbandman 597305 597305 Melton, William, of Oxton, husbandman 0
4217416 2101585 2101585 defendant Samon Edward esq 597305 597305 Samon, Edward, of Oxton, or of Darton Graunge, esq 0
4218956 2102124 2102124 defendant Hynchlyff Mabel widow 597305 597305 Hynchlyff, Mabel, of Oxton, widow 1
4228040 2105285 2105285 defendant Hynchlyff Mabel   597305 597305 Hynchlyff, Mabel, of Oxton widow 1
4229521 2105812 2105812 defendant Samon Edward husbandman 597305 597305 Samon, Edward, of Oxton, husbandman 0
4282654 2123837 2123837 defendant Samon Edward gent 597305 597305 Samon, Edward, of Oxton, or of Darton Grange, gent 0
4438188 2181243 2181243 defendant Haukerkes William   597305 597305 Haukerkes, William, of Oxton, vicar 0
4438189 2181243 2181243 defendant Rede Richard   597305 597305 Rede, Richard, of Oxton 1
4438190 2181243 2181243 defendant Geffrey Roger   597305 597305 Geffrey, Roger, of Oxton 2
4438191 2181243 2181243 defendant Bollessover Thomas de   597305 597305 Bollessover, Thomas de, of Oxton 3
4439214 2181543 2181543 defendant Hauberk William   597305 597305 Hauberk, William, of Oxton, vicar 0
4439215 2181543 2181543 defendant Rede Richard   597305 597305 Rede, Richard, of Oxton 1
4439216 2181543 2181543 defendant Geffrey Roger   597305 597305 Geffrey, Roger, of Oxton 2
4439217 2181543 2181543 defendant Bellesgure Thomas de   597305 597305 Bellesgure, Thomas de, of Oxton 3
4453466 2186090 2186090 defendant Geffra Roger   597305 597305 Geffra, Roger, of Oxton 0
4453467 2186090 2186090 defendant Rede Richard   597305 597305 Rede, Richard, of Oxton 1
4453468 2186090 2186090 defendant Mayster William   597305 597305 Mayster, William, of Oxton 2
4461265 2188608 2188608 defendant Dobson Thomas chaplain 597305 597305 Dobson, Thomas, of Oxton, chaplain 0
4505894 2202353 2202353 defendant Spenser Richard   597305 597305 Spenser, Richard, of Oxton 0
4505895 2202353 2202353 defendant Northumburlond William   597305 597305 Northumburlond, William, of Oxton 1
4533480 2210739 2210739 defendant Geffrey Roger   597305 597305 Geffrey, Roger, of Oxton 1
4562642 2219875 2219875 defendant Thakker Richard   597305 597305 Thakker, Richard, of Oxton 2
4594983 2229686 2229686 defendant Bocher Richard   597305 597305 Bocher, Richard, of Oxton 0
4666310 2250935 2250935 defendant Fores- Thurstan yeoman 597305 597305 Fores-, Thurstan, of Oxton, yeoman 1
4685281 2260992 2260992 defendant Jeke Ivan or Ivo esq 597305 597305 Jeke, Ivan or Ivo, of Oxton, esq 0
4723807 2272749 2272749 defendant Neweton Ralph gent 597305 597305 Neweton, Ralph, of Oxton, gent 0
4766778 2285602 2285602 defendant Eland William gent 597305 597305 Eland, William, of Oxton, gent 0
4769399 2286402 2286402 defendant Norton William gent 597305 597305 Norton, William, of Oxton, gent 0
4772306 2287303 2287303 defendant Norton William husbandman 597305 597305 Norton, William, of Oxton, husbandman 1
4772959 2287514 2287514 defendant Taillour Nicholas tailor 597305 597305 Taillour, Nicholas, of Oxton, tailor 0
4791117 2293321 2293321 defendant Eland William gent 597305 597305 Eland, William, of Oxton, gent 0
4793860 2294202 2294202 defendant Norton William gent 597305 597305 Norton, William, of Oxton, gent 0
4796049 2294915 2294915 defendant Bailly William husbandman 597305 597305 Bailly, William, of Oxton, husbandman 0
4796050 2294915 2294915 defendant Clerk John husbandman 597305 597305 Clerk, John, of Oxton, husbandman 1
4797338 2295340 2295340 defendant Bailly William husbandman 597305 597305 Bailly, William, of Oxton, husbandman 1
4797339 2295340 2295340 defendant Helbek Robert husbandman 597305 597305 Helbek, Robert, of Oxton, husbandman 2
4910420 2329774 2329774 defendant Spencer John husbandman 597305 597305 Spencer, John, of Oxton, husbandman 3
4912069 2330276 2330276 defendant Martyn Richard   597305 597305 Martyn, Richard, of Oxton, cart wright 0
4950332 2342069 2342069 defendant Mabele William husbandman 597305 597305 Mabele, William, of Oxton, husbandman 0
4965162 2346505 2346505 defendant Rosell John gent 597305 597305 Rosell, John, of Oxton, gent 0
4965165 2346506 2346506 defendant Rosell John gent 597305 597305 Rosell, John, of Oxton, gent 0
5005850 2358610 2358610 plaintiff Strelle Sampson   597305 597305 Strelle, Sampson, of Oxton 2
5005854 2358611 2358611 plaintiff Strelley Sampson   597305 597305 Strelley, Sampson, of Oxton 2
5068515 2377076 2377076 plaintiff Stelley Sampson   597305 597305 Stelley, Sampson, of Oxton 1
5092326 2384134 2384134 defendant Walker John husbandman 597305 597305 Walker, John, of Oxton, husbandman 0
5120243 2392358 2392358 defendant Jacson Thomas husbandman 597305 597305 Jacson, Thomas, of Oxton, husbandman 1
5120244 2392358 2392358 defendant Graunge William husbandman 597305 597305 Graunge, William, of Oxton, husbandman 2
5120246 2392358 2392358 defendant Henryson John husbandman 597305 597305 Henryson, John, of Oxton, husbandman 4
5122898 2393131 2393131 defendant Sewall Thomas husbandman 597305 597305 Sewall, Thomas, of Oxton, husbandman 5
5176810 2408903 2408903 defendant Robard William husbandman 597305 597305 Robard, William, of Oxton, husbandman 4
5247638 2429468 2429468 defendant Kyrton Robert gent 597305 597305 Kyrton, Robert, of Oxton, gent 3
5248404 2429662 2429662 plaintiff Strelley Sampson   597305 597305 Strelley, Sampson, of Oxton 0
5251095 2430445 2430445 defendant Kyrton Henry husbandman 597305 597305 Kyrton, Henry, of Oxton, husbandman 0
5265367 2434925 2434925 plaintiff Strelley Sampson gent 597305 597305 Strelley, Sampson, of Oxton, gent 0
5335866 2455796 2455796 defendant Strelley John gent 597305 597305 Strelley, John, of Oxton, gent 0
5335867 2455796 2455796 defendant Balle Robert yeoman 597305 597305 Balle, Robert, of Oxton, yeoman 1
5335868 2455796 2455796 defendant Campyon Lawrence yeoman 597305 597305 Campyon, Lawrence, of Oxton, yeoman 2
5335870 2455796 2455796 defendant Pele John smith 597305 597305 Pele, John, of Oxton, smith 4
5335872 2455796 2455796 defendant Gunthorp William husbandman 597305 597305 Gunthorp, William, of Oxton, husbandman 6
5336979 2456132 2456132 defendant Adee John yeoman 597305 597305 Adee, John, of Oxton, yeoman 1
5354348 2461426 2461426 defendant Graunge John husbandman 597305 597305 Graunge, John, of Oxton, husbandman 2
5354349 2461426 2461426 defendant Graunge Alan laborer 597305 597305 Graunge, Alan, of Oxton, laborer 3
5393369 2473161 2473161 plaintiff Strelley John esq 597305 597305 Strelley, John, of Oxton, esq 0
5436648 2485889 2485889 defendant Wymondeswold William gent 597305 597305 Wymondeswold, William, of Oxton, gent 0
5464196 2494199 2494199 defendant Wymeswold William gent 597305 597305 Wymeswold, William, of Oxton, gent 0
5464197 2494199 2494199 defendant Creswell Thomas yeoman 597305 597305 Creswell, Thomas, of Oxton, yeoman 1
5496092 2503726 2503726 defendant Mason Robert yeoman 597305 597305 Mason, Robert, of Oxton, yeoman 0
5605461 2536589 2536589 defendant Broun Thomas husbandman 597305 597305 Broun, Thomas, of Oxton, husbandman 0
5627069 2552434 2552434 defendant Cresy John husbandman 597305 597305 Cresy, John, of Oxton, husbandman 2
5630032 2553395 2553395 defendant Sels Ivo esq 597305 597305 Sels, Ivo, of Oxton, esq 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);