names

64 rows where place_id = 589988

✎ 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
3599484 1867479 1867479 defendant Furner or Furver Robert laborer 589988 589988 Furner or Furver, Robert, of Aldyngton, laborer 3
3624649 1875243 1875243 defendant Knot John laborer 589988 589988 Knot, John, of Aldyngton, laborer 4
3702310 1926981 1926981 defendant Stacy John husbandman 589988 589988 Stacy, John, of Aldyngton, husbandman 1
3704565 1927720 1927720 defendant Wareham John gent 589988 589988 Wareham, John, of Aldyngton, gent 0
3707136 1928518 1928518 defendant Hall Alice widow 589988 589988 Hall, Alice, of Aldyngton, widow 0
3790348 1954798 1954798 defendant Dod Thomas yeoman 589988 589988 Dod, Thomas, of Aldyngton, yeoman 0
4214297 2100517 2100517 defendant Yardley John yeoman 589988 589988 Yardley, John, of Aldyngton, yeoman 2
4231988 2106688 2106688 defendant Yardley John yeoman 589988 589988 Yardley, John, of Aldyngton, yeoman 2
4361488 2151270 2151270 defendant Yardley John yeoman 589988 589988 Yardley, John, of Aldyngton, yeoman 0
4361489 2151270 2151270 defendant Ashwyn William husbandman 589988 589988 Ashwyn, William, of Aldyngton, yeoman, or of Church Homborne, husbandman 1
4444027 2183100 2183100 plaintiff Chilton Robert   589988 589988 Chilton, Robert, of Aldyngton, parson 0
4446764 2183904 2183904 defendant Hobbes Robert   589988 589988 Hobbes, Robert, of Aldyngton 0
4449192 2184695 2184695 defendant Pedworth Thomas   589988 589988 Pedworth, Thomas, of Aldyngton 0
4492771 2198440 2198440 defendant Shephurd Robert   589988 589988 Shephurd, Robert, of Aldyngton 0
4523007 2207527 2207527 defendant Hamden John   589988 589988 Hamden, John, of Aldyngton 0
4523009 2207527 2207527 defendant Frensshe John   589988 589988 Frensshe, John, of Aldyngton 2
4535868 2211495 2211495 defendant Symmyel John   589988 589988 Symmyel, John, of Aldyngton 0
4542644 2213585 2213585 defendant Loudare Richard   589988 589988 Loudare, Richard, of Aldyngton 0
4572612 2222971 2222971 plaintiff atte Mede John   589988 589988 atte Mede, John, of Aldyngton 0
4572618 2222971 2222971 defendant Turnour John   589988 589988 Turnour, John, of Aldyngton 5
4573695 2223288 2223288 defendant Hayne Richard   589988 589988 Hayne, Richard, of Aldyngton 0
4614565 2235562 2235562 defendant atte Meed John   589988 589988 atte Meed, John, of Aldyngton, son of William 0
4652703 2246783 2246783 defendant Bokkeham John husbandman 589988 589988 Bokkeham, John, of Aldyngton, husbandman 18
4652704 2246783 2246783 defendant Godyn Benedict husbandman 589988 589988 Godyn, Benedict, of Aldyngton, husbandman 19
4662601 2249772 2249772 defendant Ram or Rain John husbandman 589988 589988 Ram or Rain, John, of Aldyngton, husbandman 1
4666054 2250852 2250852 defendant Ecton Richard gent 589988 589988 Ecton, Richard, of Aldyngton, gent 0
4683173 2260354 2260354 defendant Proutyng John husbandman 589988 589988 Proutyng, John, of Aldyngton, husbandman 0
4683174 2260354 2260354 defendant Proutyng William llaborer 589988 589988 Proutyng, William, of Aldyngton, llaborer 1
4683175 2260354 2260354 defendant Pryuse John laborer 589988 589988 Pryuse, John, of Aldyngton, laborer 2
4705582 2267115 2267115 defendant Alysaundre John   589988 589988 Alysaundre, John, of Aldyngton, franklin 0
4709027 2268191 2268191 defendant Prenty_ William laborer 589988 589988 Prenty_, William, of Aldyngton, laborer 1
4709028 2268191 2268191 defendant Prynse John laborer 589988 589988 Prynse, John, of Aldyngton, laborer 2
4717611 2270845 2270845 defendant Alysaundre John   589988 589988 Alysaundre, John, of Aldyngton, franklin 0
4721162 2271953 2271953 defendant Erl John potter 589988 589988 Erl, John, of Aldyngton, potter 0
4737908 2276960 2276960 defendant Alysaundre John husbandman 589988 589988 Alysaundre, John, of Aldyngton, husbandman 0
4773351 2287639 2287639 plaintiff Symenel Robert   589988 589988 Symenel, Robert, of Aldyngton 0
4773352 2287639 2287639 defendant atte Mede John husbandman 589988 589988 atte Mede, John, of Aldyngton, husbandman 0
4798664 2295758 2295758 plaintiff Symenel Robert   589988 589988 Symenel, Robert, of Aldyngton 0
4848203 2310909 2310909 defendant Helbyng William miller 589988 589988 Helbyng, William, of Aldyngton, miller 3
4859801 2314435 2314435 defendant Graunt William laborer 589988 589988 Graunt, William, of Aldyngton, laborer 0
4887390 2322892 2322892 defendant Breketappe John laborer 589988 589988 Breketappe, John, of Aldyngton, laborer 0
4983710 2352056 2352056 defendant Warner John husbandman 589988 589988 Warner, John, of Aldyngton, husbandman 0
5000510 2357020 2357020 defendant Holte Thomas husbandman 589988 589988 Holte, Thomas, of Aldyngton, husbandman 3
5025966 2364489 2364489 defendant William Simon laborer 589988 589988 William, Simon, of Aldyngton, laborer 2
5025967 2364489 2364489 defendant Elys Thomas laborer 589988 589988 Elys, Thomas, of Aldyngton, laborer 3
5088379 2382976 2382976 defendant Egger Richard husbandman 589988 589988 Egger, Richard, of Aldyngton, husbandman 0
5088380 2382976 2382976 defendant Godfrey Thomas husbandman 589988 589988 Godfrey, Thomas, of Aldyngton, husbandman 1
5181809 2410424 2410424 plaintiff Castellake John   589988 589988 Castellake, John, of Aldyngton 0
5212205 2419308 2419308 defendant Wyggemore John husbandman 589988 589988 Wyggemore, John, of Aldyngton, husbandman 1
5233429 2425368 2425368 defendant Halle William husbandman 589988 589988 Halle, William, of Aldyngton, husbandman 0
5236810 2426350 2426350 defendant Jakson Robert tailor 589988 589988 Jakson, Robert, of Aldyngton, tailor 2
5242560 2428031 2428031 defendant Aven Robert husbndman 589988 589988 Aven, Robert, of Aldyngton, husbndman 0
5242561 2428031 2428031 defendant Ferrour William husbandman 589988 589988 Ferrour, William, of Aldyngton, husbandman 1
5242562 2428031 2428031 defendant Ferrour Robert husbandman 589988 589988 Ferrour, Robert, of Aldyngton, husbandman 2
5302888 2445850 2445850 defendant Baker John husbandman 589988 589988 Baker, John, of Aldyngton, husbandman 0
5385514 2470928 2470928 defendant Smert John yeoman 589988 589988 (Smert, John, of Aldyngton, yeoman 2
5388162 2471667 2471667 plaintiff Godfrey Thomas yeoman 589988 589988 Godfrey, Thomas, of Aldyngton, yeoman 0
5400761 2475282 2475282 plaintiff Godfrey Thomas yeoman 589988 589988 Godfrey, Thomas, of Aldyngton, yeoman 0
5405646 2476688 2476688 defendant Smert John yeoman 589988 589988 Smert, John, of Aldyngton, yeoman 2
5490263 2501975 2501975 defendant Wyb- Simon husbandman 589988 589988 Wyb-, Simon, of Aldyngton, husbandman 1
5530590 2514084 2514084 defendant Wynfeld Richard husbandman 589988 589988 Wynfeld, Richard, of Aldyngton, husbandman 2
5601311 2535303 2535303 defendant Wygge Joan, senior widow 589988 589988 Wygge, Joan, senior, of Aldyngton, widow 0
5601312 2535303 2535303 defendant Wygge Joan, junior spinster 589988 589988 Wygge, Joan, junior, of Aldyngton, spinster 1
5614067 2548176 2548176 defendant Simenel John   589988 589988 Simenel, John, of Aldyngton 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);