names

87 rows where place_id = 595602

✎ 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
3621143 1874162 1874162 defendant London Thomas yeoman 595602 595602 London, Thomas, of Raundes, yeoman 26
3914813 1995300 1995300 defendant Dyall William yeoman 595602 595602 Dyall, William, of Raundes, yeoman 0
3914815 1995301 1995301 defendant Plowryght Thomas clerk 595602 595602 Plowryght, Thomas, of Raundes, clerk 0
3914817 1995302 1995302 defendant Tawer Thomas gent 595602 595602 Tawer, Thomas, of Raundes, gent 0
4270652 2119764 2119764 defendant Silbye John husbandman 595602 595602 Silbye, John, of Raundes, husbandman 0
4281936 2123584 2123584 defendant Sylbye Francis husbandman 595602 595602 Sylbye, Francis, of Raundes, husbandman 0
4332437 2141138 2141138 defendant Dolton or Daulton Peter tailor 595602 595602 Dolton or Daulton, Peter, of Raundes, tailor 0
4426863 2173222 2173222 plaintiff Portereve John le   595602 595602 Portereve, John le, of Raundes 0
4460391 2188310 2188310 plaintiff Shirlok William   595602 595602 Shirlok, William, of Raundes 0
4548450 2215454 2215454 plaintiff Chishull Robert   595602 595602 Chishull, Robert, of Raundes 0
4566281 2221019 2221019 defendant Arnold John   595602 595602 Arnold, John, of Raundes 0
4575968 2223977 2223977 defendant Chyshull Robert   595602 595602 Chyshull, Robert, of Raundes 0
4575969 2223977 2223977 defendant Maryot William   595602 595602 Maryot, William, of Raundes, vicar 1
4589200 2228004 2228004 defendant Ekton William de   595602 595602 Ekton, William de, of Raundes, vicar 0
4589201 2228004 2228004 defendant Petre John   595602 595602 Petre, John, of Raundes 1
4591442 2228678 2228678 defendant Eketon William   595602 595602 Eketon, William, of Raundes, vicar 0
4593952 2229382 2229382 defendant Bocher Robert   595602 595602 Bocher, Robert, of Raundes 0
4618288 2236729 2236729 defendant Gardlond William   595602 595602 Gardlond, William, of Raundes 0
4640354 2243293 2243293 defendant Clenche John   595602 595602 Clenche, John, of Raundes 5
4652881 2246837 2246837 defendant Fissher Gilbert fisher 595602 595602 Fissher, Gilbert, of Raundes, fisher 1
4657077 2248106 2248106 plaintiff Chyshull Robert   595602 595602 Chyshull, Robert, of Raundes 0
4663852 2250179 2250179 plaintiff Chysell Robert   595602 595602 Chysell, Robert, of Raundes 1
4685399 2261029 2261029 plaintiff Russall John   595602 595602 Russall, John, of Raundes, vicar 0
4745937 2279315 2279315 defendant Lenche John husbandman 595602 595602 Lenche, John, of Raundes, husbandman 3
4757520 2282731 2282731 defendant Brewes Richard tailor 595602 595602 Brewes, Richard, of Raundes, tailor 0
4761305 2283882 2283882 defendant Clenche John husbandman 595602 595602 Clenche, John, of Raundes, husbandman 1
4765454 2285182 2285182 defendant Reyner William laborer 595602 595602 Reyner, William, of Raundes, laborer 0
4767519 2285819 2285819 defendant Russell John clerk 595602 595602 Russell, John, of Raundes, clerk 0
4771096 2286942 2286942 defendant Taillour Thomas chaplain 595602 595602 Taillour, Thomas, of Raundes, chaplain 0
4775062 2288192 2288192 defendant Houden Thomas   595602 595602 Houden, Thomas, of Raundes, shoe maker 0
4775063 2288192 2288192 defendant Petyr Thomas husbandman 595602 595602 Petyr, Thomas, of Raundes, husbandman 1
4779616 2289610 2289610 defendant Brewes Richard tailor 595602 595602 Brewes, Richard, of Raundes, tailor 0
4822978 2303269 2303269 defendant Spornell John yeoman 595602 595602 Spornell, John, of Raundes, yeoman 3
4863155 2315454 2315454 defendant Byworthe John husbandman 595602 595602 Byworthe, John, of Raundes, husbandman 0
4863156 2315454 2315454 defendant Spylwater John husbandman 595602 595602 Spylwater, John, of Raundes, husbandman 1
4983924 2352122 2352122 defendant Catelyn John husbandman 595602 595602 Catelyn, John, of Raundes, husbandman 0
5027540 2364934 2364934 defendant Chapman John mercer 595602 595602 Chapman, John, of Raundes, mercer 0
5027544 2364934 2364934 defendant Rawer John husbandman 595602 595602 Rawer, John, of Raundes, husbandman 4
5031482 2366067 2366067 plaintiff Raundesson William   595602 595602 Raundesson, William, of Raundes 0
5036917 2367673 2367673 defendant Katelyn John husbandman 595602 595602 Katelyn, John, of Raundes, husbandman 0
5047754 2370943 2370943 defendant Knewe alias C--yst-- William smith 595602 595602 Knewe alias C--yst--, William, of Raundes, smith 0
5057899 2373933 2373933 defendant Alnoth William cordwainer 595602 595602 Alnoth, William, of Raundes, cordwainer 2
5065856 2376309 2376309 defendant Tawer John husbandman 595602 595602 Tawer, John, of Raundes, husbandman 1
5065857 2376309 2376309 defendant Smyth Thomas chapman 595602 595602 Smyth, Thomas, of Raundes, chapman 2
5065858 2376309 2376309 defendant Dekyn Thomas husbandman 595602 595602 Dekyn, Thomas, of Raundes, husbandman 3
5067892 2376896 2376896 defendant Howden John husbandman 595602 595602 Howden, John, of Raundes, husbandman 0
5067895 2376896 2376896 defendant Alnote William cordwainer 595602 595602 Alnote, William, of Raundes, cordwainer 3
5087114 2382612 2382612 defendant Harryson Thomas husbandman 595602 595602 Harryson, Thomas, of Raundes, husbandman 0
5087115 2382612 2382612 defendant Waterson John husbandman 595602 595602 Waterson, John, of Raundes, husbandman 1
5094119 2384682 2384682 defendant Croxton William smith 595602 595602 Croxton, William, of Raundes, smith 0
5098637 2386033 2386033 defendant Croftun William smith 595602 595602 Croftun, William, of Raundes, smith 0
5114785 2390736 2390736 defendant Gybbysson Richard husbandman 595602 595602 Gybbysson, Richard, of Raundes, husbandman 2
5114786 2390736 2390736 defendant Croxston Richard husbandman 595602 595602 Croxston, Richard, of Raundes, husbandman 3
5135499 2396895 2396895 defendant Gibson Richard husbandman 595602 595602 Gibson, Richard, of Raundes, husbandman 3
5135501 2396895 2396895 defendant Howedon John husbandman 595602 595602 Howedon, John, of Raundes, husbandman 5
5172234 2407604 2407604 defendant Howden John husbandman 595602 595602 Howden, John, of Raundes, husbandman 5
5191187 2413163 2413163 defendant Howedon John husbandman 595602 595602 Howedon, John, of Raundes, husbandman 5
5191195 2413164 2413164 defendant Rode William husbandman 595602 595602 Rode, William, of Raundes, husbandman 5
5194983 2414284 2414284 defendant Robyns Richard shoemaker 595602 595602 Robyns, Richard, of Raundes, shoemaker 0
5194987 2414284 2414284 defendant Croxton William smith 595602 595602 Croxton, William, of Raundes, smith 4
5207245 2417858 2417858 defendant Howeden John husbandman 595602 595602 Howeden, John, of Raundes, husbandman 5
5207253 2417859 2417859 defendant Rode William husbandman 595602 595602 Rode, William, of Raundes, husbandman 4
5209045 2418377 2418377 defendant Robyns Richard   595602 595602 Robyns, Richard, of Raundes, shoe maker 0
5209049 2418377 2418377 defendant Croxton William smith 595602 595602 Croxton, William, of Raundes, smith 4
5214021 2419832 2419832 defendant Robyns John husbandman 595602 595602 Robyns, John, of Raundes, husbandman 0
5222262 2422218 2422218 defendant Judde William husbandman 595602 595602 Judde, William, of Raundes, husbandman 0
5249972 2430102 2430102 defendant Laurens William husbandman 595602 595602 Laurens, William, of Raundes, husbandman 0
5250164 2430163 2430163 defendant Robyn John husbandman 595602 595602 Robyn, John, of Raundes, husbandman 1
5273366 2437279 2437279 defendant Fyssher John chapman 595602 595602 Fyssher, John, of Raundes, chapman 1
5276296 2438139 2438139 defendant Staunton John husbandman 595602 595602 Staunton, John, of Raundes, husbandman 0
5276297 2438139 2438139 defendant Smyth John husbandman 595602 595602 Smyth, John, of Raundes, husbandman 1
5276299 2438139 2438139 defendant Clenceh Henry butcher 595602 595602 Clenceh, Henry, of Raundes, butcher 3
5278079 2438679 2438679 defendant Howedon John husbandman 595602 595602 Howedon, John, of Raundes, husbandman 4
5327799 2453385 2453385 defendant White Thomas yeoman 595602 595602 White, Thomas, of Raundes, yeoman 0
5327975 2453435 2453435 defendant Thornton John butcher 595602 595602 Thornton, John, of Raundes, butcher 0
5327976 2453435 2453435 defendant White Thomas butcher 595602 595602 White, Thomas, of Raundes, butcher 1
5347152 2459271 2459271 defendant Yeken Thomas husbandman 595602 595602 Yeken, Thomas, of Raundes, husbandman 0
5347153 2459271 2459271 defendant Catelen Thomas husbandman 595602 595602 Catelen, Thomas, of Raundes, husbandman 1
5347154 2459271 2459271 defendant Catelen Henry husbandman 595602 595602 Catelen, Henry, of Raundes, husbandman 2
5347155 2459271 2459271 defendant Sole John husbandman 595602 595602 Sole, John, of Raundes, husbandman 3
5360359 2463275 2463275 defendant Heyward John husbandman 595602 595602 Heyward, John, of Raundes, husbandman 0
5377684 2468602 2468602 defendant Peyntoure John   595602 595602 Peyntoure, John, of Raundes, mason 0
5377685 2468602 2468602 defendant Peyntoure Richard   595602 595602 Peyntoure, Richard, of Raundes, mason 1
5377686 2468602 2468602 defendant Grombalde John   595602 595602 Grombalde, John, of Raundes, mason 2
5425227 2482516 2482516 defendant Barker Francis husbandman 595602 595602 Barker, Francis, of Raundes, husbandman 0
5456491 2491866 2491866 defendant Baker Francis husbandman 595602 595602 Baker, Francis, of Raundes, husbandman 0
5482651 2499755 2499755 defendant Mey Gerard husbandman 595602 595602 Mey, Gerard, of Raundes, husbandman 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);