names

108 rows where place_id = 593647

✎ 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
3612782 1871649 1871649 plaintiff Abbot Thomas yeoman 593647 593647 Abbot, Thomas, of Stebbyng, yeoman 0
3612783 1871649 1871649 plaintiff Frenche Thomas yeoman 593647 593647 Frenche, Thomas, of Stebbyng, yeoman 1
3626549 1903155 1903155 defendant Holynden Arnold husbandman 593647 593647 Holynden, Arnold, of Stebbyng, husbandman 0
3651767 1910907 1910907 defendant Polley John yeoman 593647 593647 Polley, John, of Stebbyng, yeoman 1
3668116 1915973 1915973 defendant Elys John yeoman 593647 593647 Elys, John, of Stebbyng, yeoman 0
3704531 1927711 1927711 defendant Reynold William yeoman 593647 593647 Reynold, William, of Stebbyng, yeoman 0
3717702 1931833 1931833 defendant Wenden John miller 593647 593647 Wenden, John, of Stebbyng, miller 0
3772518 1949096 1949096 defendant Pratte John husbandman 593647 593647 Pratte, John, of Stebbyng, husbandman 1
3779247 1951233 1951233 defendant Cornewall Thomas gent 593647 593647 Cornewall, Thomas, of Stebbyng, gent 0
3779250 1951233 1951233 defendant Abbott Richard yeoman 593647 593647 Abbott, Richard, of Stebbyng, yeoman 3
3789960 1954685 1954685 defendant Carre John shoemaker 593647 593647 Carre, John, of Stebbyng, shoemaker 0
3790183 1954748 1954748 plaintiff Kyng William   593647 593647 Kyng, William, of Stebbyng 3
3790188 1954749 1954749 plaintiff Kyng William   593647 593647 Kyng, William, of Stebbyng 3
3820632 1964338 1964338 defendant Ultyng John smith 593647 593647 Ultyng, John, of Stebbyng, smith 0
3861697 1977373 1977373 defendant Cornewalle John gent 593647 593647 Cornewalle, John, of Stebbyng, gent 0
3867319 1979301 1979301 defendant Kyng William   593647 593647 Kyng, William, of Stebbyng, whyte tawyer 1
3885018 1985249 1985249 defendant Ellys John   593647 593647 Ellys, John, of Stebbyng, yeoman, servant of Mordaunt, John, knight 0
3952070 2007793 2007793 plaintiff Hatche Lawrence husbandman 593647 593647 Hatche, Lawrence, of Stebbyng, husbandman 0
3952072 2007794 2007794 plaintiff Hatche Lawrence husbandman 593647 593647 Hatche, Lawrence, of Stebbyng, husbandman 0
4093228 2057896 2057896 defendant Hull John singleman 593647 593647 Hull, John, of Stebbyng, husbandman, singleman 0
4180421 2088628 2088628 defendant Marshe Thomas butcher 593647 593647 Marshe, Thomas, of Stebbyng, butcher 1
4281871 2123566 2123566 defendant Smyth Richard   593647 593647 Smyth, Richard, of Stebbyng, yeoman, son of John Smyth, of Stebbing 0
4282063 2123626 2123626 defendant Hull Thomas husbandman 593647 593647 Hull, Thomas, of Stebbyng, husbandman 2
4317588 2136266 2136266 defendant Stocke John yeoman 593647 593647 Stocke, John, of Stebbyng, yeoman 3
4441688 2182340 2182340 plaintiff Brakell John   593647 593647 Brakell, John, of Stebbyng, vicar 0
4449527 2184799 2184799 defendant Flemyng John weaver 593647 593647 Flemyng, John, of Stebbyng, weaver 1
4465578 2189906 2189906 plaintiff Wryght John draper 593647 593647 Wryght, John, of Stebbyng, draper 0
4480528 2194574 2194574 defendant Wryght John draper 593647 593647 Wryght, John, of Stebbyng, draper 0
4495916 2199402 2199402 defendant Rynger Richard   593647 593647 Rynger, Richard, of Stebbyng 2
4512360 2204307 2204307 defendant Norfolk John   593647 593647 Norfolk, John, of Stebbyng 0
4538765 2212397 2212397 defendant Bradewey Nicholas   593647 593647 Bradewey, Nicholas, of Stebbyng 0
4605754 2232916 2232916 defendant Grene Thomas   593647 593647 Grene, Thomas, of Stebbyng 3
4662857 2249844 2249844 defendant Grene Thomas yeoman 593647 593647 Grene, Thomas, of Stebbyng, yeoman 0
4670982 2256593 2256593 defendant Awedre John yeoman 593647 593647 Awedre, John, of Stebbyng, yeoman 0
4722985 2272500 2272500 defendant Purye William husbandman 593647 593647 Purye, William, of Stebbyng, husbandman 0
4722986 2272500 2272500 defendant Grene Thomas yeoman 593647 593647 Grene, Thomas, of Stebbyng, yeoman 1
4726192 2273474 2273474 plaintiff Grene Thomas   593647 593647 Grene, Thomas, of Stebbyng 1
4726193 2273474 2273474 defendant Drane John butcher 593647 593647 Drane, John, of Stebbyng, butcher 0
4734765 2276028 2276028 defendant Drane John butcher 593647 593647 Drane, John, of Stebbyng, butcher 4
4768782 2286215 2286215 defendant Hastiler John tanner 593647 593647 Hastiler, John, of Stebbyng, tanner 0
4768783 2286215 2286215 defendant Broun Richard fuller 593647 593647 Broun, Richard, of Stebbyng, fuller 1
4789456 2292768 2292768 defendant Hasteler John barker 593647 593647 Hasteler, John, of Stebbyng, barker 3
4800174 2296229 2296229 defendant Drane or Drave John butcher 593647 593647 Drane or Drave, John, of Stebbyng, butcher 4
4816341 2301199 2301199 defendant Perkyn John husbandman 593647 593647 Perkyn, John, of Stebbyng, husbandman 0
4849232 2311235 2311235 defendant Hasteler John tanner 593647 593647 Hasteler, John, of Stebbyng, tanner 0
4856468 2313405 2313405 defendant Drane John butcher 593647 593647 Drane, John, of Stebbyng, butcher 0
4856471 2313405 2313405 defendant Perkyn alias Watevyle John husbandman 593647 593647 Perkyn alias Watevyle, John, of Stebbyng, husbandman 3
4892339 2324340 2324340 defendant Brithman Thomas husbandman 593647 593647 Brithman, Thomas, of Stebbyng, husbandman 0
4902143 2327281 2327281 defendant Cok Richard fuller 593647 593647 Cok, Richard, of Stebbyng, fuller 4
4905666 2328373 2328373 defendant Durant John husbandman 593647 593647 Durant, John, of Stebbyng, husbandman 0
4954129 2343202 2343202 defendant Crooke John wooder 593647 593647 Crooke, John, of Stebbyng, wooder 0
4969275 2347770 2347770 defendant Ponde John husbandman 593647 593647 Ponde, John, of Stebbyng, husbandman 1
4969279 2347771 2347771 defendant Ponde John husbandman 593647 593647 Ponde, John, of Stebbyng, husbandman 1
5024232 2364001 2364001 defendant Rolf John diker 593647 593647 Rolf, John, of Stebbyng, diker 3
5081880 2381076 2381076 defendant Pykenot John laborer 593647 593647 Pykenot, John, of Stebbyng, laborer 4
5081881 2381076 2381076 defendant Godfrey Geoffrey   593647 593647 Godfrey, Geoffrey, of Stebbyng, servant 5
5086091 2382324 2382324 defendant Goudyng John butcher 593647 593647 Goudyng, John, of Stebbyng, butcher 0
5092804 2384273 2384273 defendant Algore John, junior husbandman 593647 593647 Algore, John, junior, of Stebbyng, husbandman 0
5094049 2384656 2384656 defendant Fuller William yeoman 593647 593647 Fuller, William, of Stebbyng, yeoman 0
5103005 2387300 2387300 defendant Scot William husbandman 593647 593647 Scot, William, of Stebbyng, husbandman 0
5108595 2388951 2388951 defendant Fuller William yeoman 593647 593647 Fuller, William, of Stebbyng, yeoman 1
5109218 2389121 2389121 plaintiff Fuller William   593647 593647 Fuller, William, of Stebbyng 0
5114683 2390707 2390707 defendant Motte John smith 593647 593647 Motte, John, of Stebbyng, smith 4
5121149 2392611 2392611 defendant Beelt John husbandman 593647 593647 Beelt, John, of Stebbyng, husbandman 0
5131149 2395601 2395601 defendant Grene Richard husbandman 593647 593647 Grene, Richard, of Stebbyng, husbandman 0
5131150 2395601 2395601 defendant (illegible) John husbandman 593647 593647 ---, John, of Stebbyng, husbandman 1
5131151 2395601 2395601 defendant Mitte John smith 593647 593647 Mitte, John, of Stebbyng, smith 2
5131155 2395602 2395602 defendant Motte John smith 593647 593647 Motte, John, of Stebbyng, smith 0
5150635 2401335 2401335 defendant Grene Richard smith 593647 593647 Grene, Richard, of Stebbyng, smith 0
5150636 2401335 2401335 defendant Godyng John husbandman 593647 593647 Godyng, John, of Stebbyng, husbandman 1
5150637 2401335 2401335 defendant Motte John smith 593647 593647 Motte, John, of Stebbyng, smith 2
5150640 2401336 2401336 defendant Motte John smith 593647 593647 Motte, John, of Stebbyng, smith 0
5257667 2432519 2432519 defendant Munde Hugh butcher 593647 593647 Munde, Hugh, of Stebbyng, butcher 2
5258106 2432651 2432651 defendant Bultell John clerk 593647 593647 Bultell, John, of Stebbyng, clerk 1
5258109 2432652 2432652 defendant Bultell John clerk 593647 593647 Bultell, John, of Stebbyng, clerk 1
5262399 2433983 2433983 defendant Fuller William yeoman 593647 593647 Fuller, William, of Stebbyng, yeoman 4
5272692 2437090 2437090 defendant Bultek--- John   593647 593647 Bultek---, John, of Stebbyng, parson 2
5273270 2437250 2437250 defendant Grene Thomas smith 593647 593647 Grene, Thomas, of Stebbyng, smith 0
5334625 2455424 2455424 defendant Abbot Thomas husbandman 593647 593647 Abbot, Thomas, of Stebbyng, husbandman 0
5334627 2455424 2455424 defendant Michell John husbandman 593647 593647 Michell, John, of Stebbyng, husbandman 2
5334628 2455424 2455424 defendant Parker John husbandman 593647 593647 Parker, John, of Stebbyng, husbandman 3
5334629 2455424 2455424 defendant Holt John husbandman 593647 593647 Holt, John, of Stebbyng, husbandman 4
5334630 2455424 2455424 defendant Wallyng John husbandman 593647 593647 Wallyng, John, of Stebbyng, husbandman 5
5334631 2455424 2455424 defendant Glover John husbandman 593647 593647 Glover, John, of Stebbyng, husbandman 6
5334632 2455424 2455424 defendant Byote John husbandman 593647 593647 Byote, John, of Stebbyng, husbandman 7
5334633 2455424 2455424 defendant Hasteler John husbandman 593647 593647 Hasteler, John, of Stebbyng, husbandman 8
5334634 2455424 2455424 defendant Hasteler Thomas husbandman 593647 593647 Hasteler, Thomas, of Stebbyng, husbandman 9
5335039 2455548 2455548 plaintiff Fuller William   593647 593647 Fuller, William, of Stebbyng 0
5335040 2455548 2455548 defendant Cokke John husbandman 593647 593647 Cokke, John, of Stebbyng, husbandman 0
5400396 2475187 2475187 plaintiff Fuller alias Lyghtfote William (legal representative) 593647 593647 Fuller alias Lyghtfote, William, of Stebbyng, yeoman, executors of 0
5402893 2475910 2475910 plaintiff Lyghtfote alias Fuller William (legal representative) 593647 593647 Lyghtfote alias Fuller, William, of Stebbyng, executors of 0
5415847 2479676 2479676 plaintiff Lyghtfote alias Fuller William (legal representative) 593647 593647 Lyghtfote alias Fuller, William, of Stebbyng, yeoman, executors of 0
5415859 2479678 2479678 plaintiff Lyghtfote William (legal representative) 593647 593647 Lyghtfote, William, of Stebbyng, yeoman, executors of 0
5428681 2483494 2483494 plaintiff Fuller alias Lyghtfote William (legal representative) 593647 593647 Fuller alias Lyghtfote, William, of Stebbyng, yeoman, executors of 0
5445637 2488583 2488583 defendant Coke John husbandman 593647 593647 Coke, John, of Stebbyng, husbandman 4
5445944 2488675 2488675 plaintiff Fuller Henry   593647 593647 Fuller, Henry, of Stebbyng 1
5445972 2488683 2488683 plaintiff Fuller William (legal representative) 593647 593647 Fuller, William, of Stebbyng, yeoman, executors of 0
5448524 2489456 2489456 plaintiff Lyghtfote alias Fuller William (legal representative) 593647 593647 Lyghtfote alias Fuller, William, of Stebbyng, yeoman, executors of: (Fuller, Richard 0
5452982 2490772 2490772 defendant Hendon William yeoman 593647 593647 Hendon, William, of Stebbyng, yeoman 0
5460823 2493184 2493184 plaintiff Lyghtfote William (legal representative) 593647 593647 Lyghtfote, William, of Stebbyng, yeoman, executors of 0

Next page

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