names

67 rows where place_id = 586993

✎ 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
3590175 1864565 1864565 defendant Glover Richard husbandman 586993 586993 Glover, Richard, of Wenlok, husbandman 1
3650264 1910456 1910456 defendant Legge Agnes widow 586993 586993 Legge, Agnes, of Wenlok, widow 0
3650266 1910457 1910457 defendant Stone John husbandman 586993 586993 Stone, John, of Wenlok, husbandman 0
3664527 1914857 1914857 defendant Stone John   586993 586993 Stone, John, of Wenlok, shoe maker 0
3664529 1914858 1914858 defendant Stone John shoemaker 586993 586993 Stone, John, of Wenlok, shoemaker 0
3816195 1962971 1962971 defendant Wever alias Ford William   586993 586993 Wever alias Ford, William, of Wenlok 0
4419801 2171089 2171089 defendant Neuton Robert de   586993 586993 Neuton, Robert de, of Wenlok 0
4465589 2189911 2189911 plaintiff Wryghte Adam le   586993 586993 Wryghte, Adam le, of Wenlok 0
4499445 2200478 2200478 defendant Harryotes John weaver 586993 586993 Harryotes, John, of Wenlok, weaver 0
4541295 2213175 2213175 defendant Leye Roger de   586993 586993 Leye, Roger de, of Wenlok, vicar 0
4541301 2213177 2213177 defendant London William tailor 586993 586993 London, William, of Wenlok, tailor 0
4561936 2219666 2219666 defendant Turnour John   586993 586993 Turnour, John, of Wenlok 0
4562332 2219780 2219780 plaintiff Pope John   586993 586993 Pope, John, of Wenlok 0
4570705 2222406 2222406 defendant Lygh William butcher 586993 586993 Lygh, William, of Wenlok, butcher 0
4612269 2234902 2234902 defendant Smyth John   586993 586993 Smyth, John, of Wenlok 2
4623438 2238305 2238305 plaintiff Tonge John   586993 586993 Tonge, John, of Wenlok 1
4667304 2255503 2255503 defendant Herper William butcher 586993 586993 Herper, William, of Wenlok, butcher 0
4674776 2257724 2257724 defendant Harper William butcher 586993 586993 Harper, William, of Wenlok, butcher 0
4690223 2262498 2262498 defendant Reymond Richard tailor 586993 586993 Reymond, Richard, of Wenlok, tailor 0
4729377 2274405 2274405 plaintiff Laweley Thomas   586993 586993 Laweley, Thomas, of Wenlok 0
4737205 2276756 2276756 defendant Lokyer Thomas husbandman 586993 586993 Lokyer, Thomas, of Wenlok, husbandman 2
4751777 2281010 2281010 plaintiff Stafford John   586993 586993 Stafford, John, of Wenlok, prior 0
4751779 2281011 2281011 plaintiff Stafford John   586993 586993 Stafford, John, of Wenlok, prior 0
4757784 2282810 2282810 defendant Reymond Richard husbandman 586993 586993 Reymond, Richard, of Wenlok, husbandman 0
4760204 2283543 2283543 plaintiff Corffe Richard   586993 586993 Corffe, Richard, of Wenlok 0
4782530 2290546 2290546 plaintiff Corffe Richard   586993 586993 Corffe, Richard, of Wenlok 0
4799199 2295931 2295931 plaintiff Tiler Richard   586993 586993 Tiler, Richard, of Wenlok 0
4818949 2302009 2302009 defendant Bourne William butcher 586993 586993 Bourne, William, of Wenlok, butcher 0
4823197 2303344 2303344 plaintiff Stafford John   586993 586993 Stafford, John, of Wenlok, prior 0
4823199 2303345 2303345 plaintiff Stafford John   586993 586993 Stafford, John, of Wenlok, prior 0
4823201 2303346 2303346 plaintiff Stafford John   586993 586993 Stafford, John, of Wenlok, prior 0
4823204 2303347 2303347 plaintiff Stafford John   586993 586993 Stafford, John, of Wenlok, prior 0
4877373 2319877 2319877 defendant Laweley Thomas yeoman 586993 586993 Laweley, Thomas, of Wenlok, yeoman 0
4905539 2328330 2328330 defendant Pyper Thomas butcher 586993 586993 Pyper, Thomas, of Wenlok, butcher 0
4905540 2328330 2328330 defendant Corveser Henry cordwainer 586993 586993 Corveser, Henry, of Wenlok, cordwainer 1
4905541 2328330 2328330 defendant Charles William cordwainer 586993 586993 Charles, William, of Wenlok, cordwainer 2
4905542 2328330 2328330 defendant Man John laborer 586993 586993 Man, John, of Wenlok, laborer 3
4905543 2328330 2328330 defendant Pyper Thomas Thomasservant laborer 586993 586993 Pyper, Thomas Thomasservant, of Wenlok, laborer 4
4962409 2345662 2345662 defendant Fryser Thomas sherman 586993 586993 Fryser, Thomas, of Wenlok, sherman 0
4964426 2346273 2346273 plaintiff Clerk Thomas   586993 586993 Clerk, Thomas, of Wenlok 0
4964428 2346274 2346274 plaintiff Clerk Thomas   586993 586993 Clerk, Thomas, of Wenlok 0
4964494 2346286 2346286 plaintiff Clerke Thomas clerk 586993 586993 Clerke, Thomas, of Wenlok, clerk 0
4981779 2351468 2351468 defendant Taillour John yeoman 586993 586993 Taillour, John, of Wenlok, yeoman 0
4984141 2352189 2352189 defendant Clenchard John butcher 586993 586993 Clenchard, John, of Wenlok, butcher 1
4989525 2353800 2353800 defendant Maylard David carpenter 586993 586993 Maylard, David, of Wenlok, carpenter 0
4999043 2356593 2356593 defendant Clenchard Nicholas husbandman 586993 586993 Clenchard, Nicholas, of Wenlok, husbandman 1
4999044 2356593 2356593 defendant Clenchard John husbandman 586993 586993 Clenchard, John, of Wenlok, husbandman 2
4999047 2356594 2356594 defendant Clenchard Nicholas husbandman 586993 586993 Clenchard, Nicholas, of Wenlok, husbandman 1
4999048 2356594 2356594 defendant Clenchard John husbandman 586993 586993 Clenchard, John, of Wenlok, husbandman 2
5028781 2365294 2365294 defendant Taillour John butcher 586993 586993 Taillour, John, of Wenlok, butcher 0
5028782 2365294 2365294 defendant Atkys Richard chaplain 586993 586993 Atkys, Richard, of Wenlok, chaplain 1
5028783 2365294 2365294 defendant Smyth William yeoman 586993 586993 Smyth, William, of Wenlok, yeoman 2
5067863 2376888 2376888 defendant Lanley John gent 586993 586993 Lanley, John, of Wenlok, gent 0
5110911 2389587 2389587 defendant Clenchard Philip butcher 586993 586993 Clenchard, Philip, of Wenlok, butcher 1
5110918 2389588 2389588 defendant Clenchard Philip butcher 586993 586993 Clenchard, Philip, of Wenlok, butcher 2
5143123 2399124 2399124 defendant Barrey Roger   586993 586993 Barrey, Roger, of Wenlok, prior 0
5144893 2399654 2399654 defendant Barrey Roger   586993 586993 Barrey, Roger, of Wenlok, prior 0
5178820 2409529 2409529 plaintiff Barrey Roger   586993 586993 Barrey, Roger, of Wenlok, prior 0
5178822 2409530 2409530 plaintiff Barrey Roger   586993 586993 Barrey, Roger, of Wenlok, prior 0
5232164 2424982 2424982 defendant Chamberleyn Thomas (legal representative) 586993 586993 Chamberleyn, Thomas, of Wenlok, yeoman, executrix of 2
5470655 2496142 2496142 defendant Sudbury Thomas   586993 586993 Sudbury, Thomas, of Wenlok, prior 0
5527492 2513180 2513180 defendant Tayllour Thomas yeoman 586993 586993 Tayllour, Thomas, of Wenlok, yeoman 2
5527496 2513180 2513180 defendant Bradley John husbandman 586993 586993 Bradley, John, of Wenlok, husbandman 6
5549319 2519850 2519850 defendant Legge John chaplain 586993 586993 Legge, John, of Wenlok, chaplain 0
5616643 2549007 2549007 defendant Tonge John tailor 586993 586993 Tonge, John, of Wenlok, tailor 1
5616644 2549007 2549007 defendant Knyght Richard   586993 586993 Knyght, Richard, of Wenlok 2
5619741 2550033 2550033 defendant Ballard Richard   586993 586993 Ballard, Richard, of Wenlok 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);