names

90 rows where place_id = 590563

✎ 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
3601636 1868167 1868167 defendant Manfeld Arnold yeoman 590563 590563 Manfeld, Arnold, of Badyngham, yeoman 2
3622953 1874708 1874708 plaintiff Rous Edward esq 590563 590563 Rous, Edward, of Badyngham, esq 0
3636757 1906290 1906290 defendant Russhe Henry (legal representative) 590563 590563 Russhe, Henry, of Badyngham, tailor, executors of 0
3696126 1925012 1925012 defendant Artheys Robert carpenter 590563 590563 Artheys, Robert, of Badyngham, carpenter 0
3696127 1925012 1925012 defendant Smyth John laborer 590563 590563 Smyth, John, of Badyngham, laborer 1
3806353 1959900 1959900 defendant Ederiche John carver 590563 590563 Ederiche, John, of Badyngham, carver 4
3810322 1961120 1961120 defendant Russhe John tailor 590563 590563 Russhe, John, of Badyngham, tailor 1
3860658 1977057 1977057 defendant Free Robert husbandman 590563 590563 Free, Robert, of Badyngham, husbandman 0
3872142 1980914 1980914 defendant Rous Anthony   590563 590563 Rous, Anthony, of Badyngham 0
3879694 1983464 1983464 defendant Artes Robert husbandman 590563 590563 Artes, Robert, of Badyngham, husbandman 0
3881058 1983936 1983936 plaintiff Rous Anthony   590563 590563 Rous, Anthony, of Badyngham 0
3886335 1985684 1985684 defendant Harwar Thomas carpenter 590563 590563 Harwar, Thomas, of Badyngham, carpenter 0
3915452 1995536 1995536 defendant Jurdon Edward husbandman 590563 590563 Jurdon, Edward, of Badyngham, husbandman 0
3918903 1996642 1996642 defendant Free Robert husbandman 590563 590563 Free, Robert, of Badyngham, husbandman 0
3919752 1996946 1996946 defendant Artes Robert yeoman 590563 590563 Artes, Robert, of Badyngham, yeoman 0
3925172 1998730 1998730 defendant Arteys William husbandman 590563 590563 Arteys, William, of Badyngham, husbandman 0
3927420 1999517 1999517 plaintiff Arteys Robert husbandman 590563 590563 Arteys, Robert, of Badyngham, junior, husbandman 1
3967504 2013270 2013270 defendant Rushe John   590563 590563 Rushe, John, of Badyngham, mason 1
3981916 2018292 2018292 defendant Borrett John yeoman 590563 590563 Borrett, John, of Badyngham, yeoman 0
3981917 2018292 2018292 defendant Whyte Thomas carpenter 590563 590563 Whyte, Thomas, of Badyngham, carpenter 1
3981918 2018292 2018292 defendant Whyte James yeoman 590563 590563 Whyte, James, of Badyngham, yeoman 2
3984094 2019077 2019077 defendant Whyte Thomas carpenter 590563 590563 Whyte, Thomas, of Badyngham, carpenter 1
3985550 2019596 2019596 defendant Artys Henry yeoman 590563 590563 Artys, Henry, of Badyngham, yeoman 0
3985830 2019695 2019695 defendant Borett John yeoman 590563 590563 Borett, John, of Badyngham, yeoman 1
3985833 2019696 2019696 defendant Borett John yeoman 590563 590563 Borett, John, of Badyngham, yeoman 1
4020056 2031902 2031902 defendant Whyte Jamers yeoman 590563 590563 Whyte, Jamers, of Badyngham, yeoman 3
4032247 2036207 2036207 plaintiff Gardener or Garner William yeoman 590563 590563 Gardener or Garner, William, of Badyngham, yeoman 0
4137223 2073660 2073660 defendant Deddam Anthony cooper 590563 590563 Deddam, Anthony, of Badyngham, cooper 1
4424433 2172481 2172481 plaintiff Ingham Ralph de   590563 590563 Ingham, Ralph de, of Badyngham, parson 0
4599172 2230954 2230954 defendant Bocher Richard   590563 590563 Bocher, Richard, of Badyngham 0
4725161 2273166 2273166 defendant Gerard John butcher 590563 590563 Gerard, John, of Badyngham, butcher 0
4725167 2273167 2273167 defendant Gerard John butcher 590563 590563 Gerard, John, of Badyngham, butcher 0
4742403 2278271 2278271 defendant Stork William husbandman 590563 590563 Stork, William, of Badyngham, husbandman 0
4742404 2278271 2278271 defendant Holdelond Walter   590563 590563 Holdelond, Walter, of Badyngham, wheel wright 1
4742405 2278271 2278271 defendant Gerard John butcher 590563 590563 Gerard, John, of Badyngham, butcher 2
4765075 2285053 2285053 defendant Berton Thomas   590563 590563 Berton, Thomas, of Badyngham, parson 0
4782692 2290600 2290600 defendant Rook William yeoman 590563 590563 Rook, William, of Badyngham, yeoman 0
4810343 2299379 2299379 defendant Stork William husbandman 590563 590563 Stork, William, of Badyngham, husbandman 0
4845840 2310208 2310208 defendant Colston John yeoman 590563 590563 Colston, John, of Badyngham, yeoman 0
4847451 2310705 2310705 defendant Banham Robert yeoman 590563 590563 Banham, Robert, of Badyngham, yeoman 0
4847452 2310705 2310705 defendant Joye John smith 590563 590563 Joye, John, of Badyngham, smith 1
4873445 2318653 2318653 defendant Colston John yeoman 590563 590563 Colston, John, of Badyngham, yeoman 0
4875142 2319180 2319180 defendant Banham Robert yeoman 590563 590563 Banham, Robert, of Badyngham, yeoman 0
4875143 2319180 2319180 defendant Joy John smith 590563 590563 together with Joy, John, of Badyngham, smith 1
4885600 2322374 2322374 defendant Ederyche John yeoman 590563 590563 Ederyche, John, of Badyngham, yeoman 0
4896810 2325660 2325660 defendant Colston John yeoman 590563 590563 Colston, John, of Badyngham, yeoman 0
4896811 2325660 2325660 defendant Roysshe Henry yeoman 590563 590563 Roysshe, Henry, of Badyngham, yeoman 1
4898273 2326121 2326121 defendant Gyrlyng Richard husbandman 590563 590563 Gyrlyng, Richard, of Badyngham, husbandman 0
4927424 2335009 2335009 plaintiff Russell John   590563 590563 Russell, John, of Badyngham, parson 0
4927425 2335009 2335009 defendant Russell John   590563 590563 Russell, John, of Badyngham, parson 0
4999827 2356827 2356827 defendant Rysshe Henry husbandman 590563 590563 Rysshe, Henry, of Badyngham, husbandman 0
5013797 2360883 2360883 defendant Grene Thomas husbandman 590563 590563 Grene, Thomas, of Badyngham, husbandman 0
5040244 2368681 2368681 defendant Russhe Thomas husbandman 590563 590563 Russhe, Thomas, of Badyngham, husbandman 1
5059845 2374512 2374512 defendant Potell William clerk 590563 590563 Potell, William, of Badyngham, clerk 2
5059847 2374512 2374512 defendant Symond Margaret widow 590563 590563 Symond, Margaret, of Badyngham, widow 4
5097099 2385584 2385584 defendant Holond Robert husbandman 590563 590563 Holond, Robert, of Badyngham, husbandman 2
5097103 2385585 2385585 defendant Holond Robert husbandman 590563 590563 Holond, Robert, of Badyngham, husbandman 2
5098064 2385866 2385866 defendant Banham Robert yeoman 590563 590563 Banham, Robert, of Badyngham, yeoman 3
5118496 2391846 2391846 defendant Grellyng Anne widow 590563 590563 Grellyng, Anne, of Badyngham, widow 0
5118921 2391965 2391965 defendant Pye John, junior husbandman 590563 590563 Pye, John, junior, of Badyngham, husbandman 1
5124165 2393527 2393527 plaintiff Manfeld John   590563 590563 Manfeld, John, of Badyngham 1
5125442 2393925 2393925 defendant (illegible) (illegible) husbandman 590563 590563 --,--, of Badyngham, husbandman 1
5135101 2396764 2396764 defendant Pye William husbandman 590563 590563 Pye, William, of Badyngham, husbandman 0
5135537 2396907 2396907 defendant Manffelde John yeoman 590563 590563 Manffelde, John, of Badyngham, yeoman 0
5135538 2396907 2396907 defendant Bannam Robert yeoman 590563 590563 Bannam, Robert, of Badyngham, yeoman 1
5135810 2396987 2396987 plaintiff Burnam Robert   590563 590563 Burnam, Robert, of Badyngham 1
5144071 2399415 2399415 defendant Russh Thomas husbandman 590563 590563 Russh, Thomas, of Badyngham, husbandman 1
5155358 2402717 2402717 plaintiff Banman Robert   590563 590563 Banman, Robert, of Badyngham 1
5155803 2402861 2402861 defendant Mansfelde John yeoman 590563 590563 Mansfelde, John, of Badyngham, yeoman 0
5155804 2402861 2402861 defendant Banman Robert yeoman 590563 590563 Banman, Robert, of Badyngham, yeoman 1
5171925 2407504 2407504 defendant Pye William husbandman 590563 590563 Pye, William, of Badyngham, husbandman 0
5171992 2407523 2407523 plaintiff Bannam Robert   590563 590563 Bannam, Robert, of Badyngham 1
5179134 2409631 2409631 defendant Pye Thomas chaplain 590563 590563 Pye, Thomas, of Badyngham, chaplain 0
5179135 2409631 2409631 defendant Pye John yeoman 590563 590563 Pye, John, of Badyngham, yeoman 1
5201777 2416286 2416286 defendant Pye Thomas chaplain 590563 590563 Pye, Thomas, of Badyngham, chaplain 0
5201778 2416286 2416286 defendant Pye John yeoman 590563 590563 Pye, John, of Badyngham, yeoman 1
5222108 2422169 2422169 plaintiff Bannam Robert   590563 590563 Bannam, Robert, of Badyngham 1
5242068 2427882 2427882 plaintiff Bannam Robert   590563 590563 Bannam, Robert, of Badyngham 1
5251392 2430533 2430533 defendant Stanhowe John husbandman 590563 590563 Stanhowe, John, of Badyngham, husbandman 4
5263936 2434480 2434480 defendant Seferey or Seserey Robert chaplain 590563 590563 Seferey or Seserey, Robert, of Badyngham, chaplain 0
5266556 2435290 2435290 defendant Manfald William weaver 590563 590563 Manfald, William, of Badyngham, weaver 1
5266557 2435290 2435290 defendant Denk John smith 590563 590563 Denk, John, of Badyngham, smith 2
5303420 2446019 2446019 plaintiff Grene Thomas   590563 590563 Grene, Thomas, of Badyngham 0
5338033 2456462 2456462 defendant Whyte Thomas carpenter 590563 590563 Whyte, Thomas, of Badyngham, carpenter 0
5356561 2462122 2462122 plaintiff Lyston Isabel   590563 590563 Lyston, Isabel, of Badyngham 0
5356563 2462122 2462122 defendant Artes Robert husbandman 590563 590563 Artes, Robert, of Badyngham, husbandman 1
5420169 2480950 2480950 defendant Trace Robert gent 590563 590563 Trace, Robert, of Badyngham, gent 3
5438903 2486558 2486558 defendant Trewe Robert gent 590563 590563 Trewe, Robert, of Badyngham, gent 3
5452782 2490711 2490711 defendant Trace Robert gent 590563 590563 Trace, Robert, of Badyngham, gent 3
5568606 2525367 2525367 defendant Dernford William yeoman 590563 590563 Dernford, William, of Badyngham, yeoman 2

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