names

95 rows where place_id = 593865

✎ 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
3613671 1871922 1871922 defendant Roigger William husbandman 593865 593865 Roigger, William, of Uggeburgh, husbandman 2
3628133 1903655 1903655 defendant Moryng John husbandman 593865 593865 Moryng, John, of Uggeburgh, husbandman 0
3672511 1917404 1917404 defendant Lapthorn John   593865 593865 Lapthorn, John, of Uggeburgh 0
3680976 1920129 1920129 defendant Lapthorne John   593865 593865 Lapthorne, John, of Uggeburgh 0
3745628 1940540 1940540 plaintiff Bury John, senior   593865 593865 Bury, John, senior, of Uggeburgh 0
3786681 1953628 1953628 defendant Toker Simon husbandman 593865 593865 Toker, Simon, of Uggeburgh, husbandman 3
3786684 1953629 1953629 defendant Flaccher Thomas tinner 593865 593865 Flaccher, Thomas, of Uggeburgh, tinner 0
3877755 1982798 1982798 defendant Legh Robert butcher 593865 593865 Legh, Robert, of Uggeburgh, butcher 2
3890400 1987044 1987044 defendant Founteyn Hugh yeoman 593865 593865 Founteyn, Hugh, of Uggeburgh, yeoman 0
3923822 1998274 1998274 defendant Cone John husbandman 593865 593865 Cone, John, of Uggeburgh, husbandman 3
3929894 2000340 2000340 plaintiff Chubb John   593865 593865 Chubb, John, of Uggeburgh 0
3939851 2003628 2003628 defendant Wode John, junior gent 593865 593865 Wode, John, junior, of Uggeburgh, gent 0
3993811 2022538 2022538 plaintiff Chubbe John   593865 593865 Chubbe, John, of Uggeburgh 0
3993814 2022539 2022539 plaintiff Chubbe John   593865 593865 Chubbe, John, of Uggeburgh 0
3993817 2022540 2022540 plaintiff Chubbe John   593865 593865 Chubbe, John, of Uggeburgh 0
3995189 2023023 2023023 defendant Gybbe James yeoman 593865 593865 Gybbe, James, of Uggeburgh, yeoman 0
4020576 2032087 2032087 defendant Byckford William husbandman 593865 593865 Byckford, William, of Uggeburgh, husbandman 0
4020720 2032139 2032139 plaintiff Wood Philip   593865 593865 Wood, Philip, of Uggeburgh 0
4027417 2034453 2034453 plaintiff Chubbe John   593865 593865 Chubbe, John, of Uggeburgh 0
4027418 2034453 2034453 defendant Bury William gent 593865 593865 Bury, William, of Uggeburgh, gent 0
4027419 2034454 2034454 plaintiff Chubbe John husbandman 593865 593865 Chubbe, John, of Uggeburgh, husbandman 0
4081908 2053832 2053832 plaintiff Wood Philip gent 593865 593865 Wood, Philip, of Uggeburgh, gent 0
4081910 2053832 2053832 defendant Burye Robert gent 593865 593865 Burye, Robert, of Uggeburgh, gent 1
4560099 2219101 2219101 defendant Symeston Richard   593865 593865 Symeston, Richard, of Uggeburgh 0
4679980 2259341 2259341 defendant Waryn John laborer 593865 593865 Waryn, John, of Uggeburgh, laborer 3
4683114 2260334 2260334 plaintiff Palmer Richard   593865 593865 Palmer, Richard, of Uggeburgh, parson 0
4690016 2262429 2262429 defendant Waryn John husbandman 593865 593865 Waryn, John, of Uggeburgh, husbandman 1
4704241 2266702 2266702 defendant Waterman Thomas husbandman 593865 593865 Waterman, Thomas, of Uggeburgh, husbandman 0
4737664 2276888 2276888 defendant Wode Richard husbandman 593865 593865 Wode, Richard, of Uggeburgh, husbandman 0
4755865 2282217 2282217 defendant Waterman Thomas husbandman 593865 593865 Waterman, Thomas, of Uggeburgh, husbandman 0
4757083 2282585 2282585 defendant Monke Roger chaplain 593865 593865 Monke, Roger, of Uggeburgh, chaplain 0
4762199 2284156 2284156 defendant Monk Roger chaplain 593865 593865 Monk, Roger, of Uggeburgh, chaplain 5
4764760 2284962 2284962 defendant Sqwypere Walter husbandman 593865 593865 Sqwypere, Walter, of Uggeburgh, husbandman 0
4773519 2287686 2287686 defendant Mersshe Geoffrey tailor 593865 593865 Mersshe, Geoffrey, of Uggeburgh, tailor 1
4777835 2289058 2289058 defendant Symon John drover 593865 593865 Symon, John, of Uggeburgh, drover 0
4806003 2298088 2298088 defendant Bancombe James gent 593865 593865 Bancombe, James, of Uggeburgh, gent 2
4829459 2305255 2305255 defendant Lappe William yeoman 593865 593865 Lappe, William, of Uggeburgh, yeoman 1
4845610 2310137 2310137 defendant Smyth Robert husbandman 593865 593865 Smyth, Robert, of Uggeburgh, husbandman 1
4848526 2311015 2311015 defendant Stoddon William husbandman 593865 593865 Stoddon, William, of Uggeburgh, husbandman 0
4858686 2314091 2314091 defendant Chubbe William smith 593865 593865 Chubbe, William, of Uggeburgh, smith 0
4858687 2314091 2314091 defendant Porter William husbandman 593865 593865 Porter, William, of Uggeburgh, husbandman 1
4890210 2323708 2323708 defendant Chubbe William smith 593865 593865 Chubbe, William, of Uggeburgh, smith 0
4890211 2323708 2323708 defendant Porter William husbandman 593865 593865 Porter, William, of Uggeburgh, husbandman 1
4895630 2325304 2325304 defendant Symond John merchant 593865 593865 Symond, John, of Uggeburgh, merchant 0
4902120 2327273 2327273 defendant Porter William husbandman 593865 593865 Porter, William, of Uggeburgh, husbandman 1
4908914 2329333 2329333 defendant Ritte John butcher 593865 593865 Ritte, John, of Uggeburgh, butcher 4
4908915 2329333 2329333 defendant Gontyfford William husbandman 593865 593865 Gontyfford, William, of Uggeburgh, husbandman 5
4909122 2329394 2329394 defendant Dunnewill John shoemaker 593865 593865 Dunnewill, John, of Uggeburgh, shoemaker 0
4909335 2329460 2329460 defendant Mersshe Geoffrey tailor 593865 593865 Mersshe, Geoffrey, of Uggeburgh, tailor 4
4910690 2329852 2329852 defendant Simon John husbandman 593865 593865 Simon, John, of Uggeburgh, husbandman 1
4929780 2335726 2335726 defendant Toser John husbandman 593865 593865 Toser, John, of Uggeburgh, husbandman 4
4954894 2343420 2343420 defendant Croft Richard yeoman 593865 593865 Croft, Richard, of Uggeburgh, yeoman 1
4962577 2345713 2345713 defendant Pede Stephen carpenter 593865 593865 Pede, Stephen, of Uggeburgh, carpenter 0
4962578 2345713 2345713 defendant Pede Richard carpenter 593865 593865 Pede, Richard, of Uggeburgh, carpenter 1
4962579 2345713 2345713 defendant Monke William laborer 593865 593865 Monke, William, of Uggeburgh, laborer 2
4962580 2345713 2345713 defendant Monke John butcher 593865 593865 Monke, John, of Uggeburgh, butcher 3
4962581 2345713 2345713 defendant Were William weaver 593865 593865 Were, William, of Uggeburgh, weaver 4
4962582 2345713 2345713 defendant Donnewyll John cordwainer 593865 593865 Donnewyll, John, of Uggeburgh, cordwainer 5
4962583 2345713 2345713 defendant Gyldon John cordwainer 593865 593865 Gyldon, John, of Uggeburgh, cordwainer 6
4962584 2345713 2345713 defendant Dusteyn John, junior butcher 593865 593865 Dusteyn, John, junior, of Uggeburgh, butcher 7
4962585 2345713 2345713 defendant Stoddon William weaver 593865 593865 Stoddon, William, of Uggeburgh, weaver 8
4989063 2353667 2353667 defendant Were William husbandman 593865 593865 Were, William, of Uggeburgh, husbandman 0
5006290 2358736 2358736 defendant Chubbe Roger smith 593865 593865 Chubbe, Roger, of Uggeburgh, smith 1
5007806 2359177 2359177 defendant Smyth Robert husbandman 593865 593865 Smyth, Robert, of Uggeburgh, husbandman 0
5016191 2361622 2361622 defendant Founteyn William husbandman 593865 593865 Founteyn, William, of Uggeburgh, husbandman 0
5029285 2365444 2365444 defendant Davy John husbandman 593865 593865 Davy, John, of Uggeburgh, husbandman 0
5034978 2367089 2367089 plaintiff Symon John   593865 593865 Symon, John, of Uggeburgh 0
5034980 2367090 2367090 plaintiff Symon John   593865 593865 Symon, John, of Uggeburgh 0
5034981 2367090 2367090 defendant Wode Richard husbandman 593865 593865 Wode, Richard, of Uggeburgh, husbandman 0
5034982 2367090 2367090 defendant Wode Stephen husbandman 593865 593865 Wode, Stephen, of Uggeburgh, husbandman 1
5034983 2367090 2367090 defendant Wode John husbandman 593865 593865 Wode, John, of Uggeburgh, husbandman 2
5054602 2372950 2372950 defendant Lewer Simon husbandman 593865 593865 Lewer, Simon, of Uggeburgh, husbandman 1
5055504 2373226 2373226 defendant Bristowe William husbandman 593865 593865 Bristowe, William, of Uggeburgh, husbandman 0
5091644 2383946 2383946 defendant Pyke Walter husbandman 593865 593865 Pyke, Walter, of Uggeburgh, husbandman 0
5091645 2383946 2383946 defendant Pyke John husbandman 593865 593865 Pyke, John, of Uggeburgh, husbandman 1
5095838 2385210 2385210 defendant Davy John husbandman 593865 593865 Davy, John, of Uggeburgh, husbandman 0
5101521 2386857 2386857 defendant Gnatton John shoemaker 593865 593865 Gnatton, John, of Uggeburgh, shoemaker 0
5101523 2386858 2386858 defendant Guatton or Quatton John shoemaker 593865 593865 Guatton or Quatton, John, of Uggeburgh, shoemaker 0
5125339 2393893 2393893 defendant Evatton or Gnatton John   593865 593865 Evatton or Gnatton, John, of Uggeburgh, shoe maker 0
5132810 2396090 2396090 defendant Clerk John butcher 593865 593865 Clerk, John, of Uggeburgh, butcher 0
5152599 2401901 2401901 defendant Clerk John butcher 593865 593865 Clerk, John, of Uggeburgh, butcher 0
5152602 2401902 2401902 defendant Clerk John butcher 593865 593865 Clerk, John, of Uggeburgh, butcher 0
5200203 2415818 2415818 defendant Dunwyll John, sen laborer 593865 593865 Dunwyll, John, sen, of Uggeburgh, laborer 0
5200207 2415818 2415818 defendant Waterman Hugh husbandman 593865 593865 Waterman, Hugh, of Uggeburgh, husbandman 4
5203813 2416866 2416866 defendant Luyssh William husbandman 593865 593865 Luyssh, William, of Uggeburgh, husbandman 0
5204296 2417009 2417009 defendant Haradon Thomas husbandman 593865 593865 Haradon, Thomas, of Uggeburgh, husbandman 0
5208554 2418230 2418230 defendant Laury Henry laborer 593865 593865 Laury, Henry, of Uggeburgh, laborer 2
5211389 2419065 2419065 defendant Dunwyll John, sen laborer 593865 593865 Dunwyll, John, sen, of Uggeburgh, laborer 0
5211390 2419065 2419065 defendant Dunwyll John shoemaker 593865 593865 Dunwyll, John, of Uggeburgh, shoemaker 1
5211393 2419065 2419065 defendant Waterman Hugh husbandman 593865 593865 Waterman, Hugh, of Uggeburgh, husbandman 4
5250727 2430336 2430336 defendant Martyn Thomas mercer 593865 593865 Martyn, Thomas, of Uggeburgh, mercer 0
5259585 2433117 2433117 defendant Monke John butcher 593865 593865 Monke, John, of Uggeburgh, butcher 4
5520738 2511307 2511307 defendant Rogger Thomas husbandman 593865 593865 Rogger, Thomas, of Uggeburgh, husbandman 0
5520739 2511307 2511307 defendant Adam William husbandman 593865 593865 Adam, William, of Uggeburgh, husbandman 1
5569654 2525694 2525694 defendant Revyll William yeoman 593865 593865 Revyll, William, of Uggeburgh, yeoman 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);