names

46 rows where place_id = 633723

✎ 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
3698914 1925874 1925874 defendant Blakehede Thomas   633723 633723 Blakehede, Thomas, of Tame, administrators of 0
3727585 1934910 1934910 defendant Blakhede Thomas (legal representative) 633723 633723 Blakhede, Thomas, of Tame, chapman, executors of 0
3791302 1955114 1955114 defendant Elys Isabel (legal representative) 633723 633723 Elys, Isabel, of Tame, widow, executrix of Elys, Richard, of Tame, yeoman, executor of 0
3791305 1955115 1955115 defendant Elys Isabel (legal representative) 633723 633723 Elys, Isabel, of Tame, widow, executrix of Elys, Richard, of Tame, yeoman, executor of 0
3814458 1962436 1962436 defendant Osburn alias Blakegrove Richard miller 633723 633723 Osburn alias Blakegrove, Richard, of Tame, miller 0
3849300 1973374 1973374 defendant Couper John yeoman 633723 633723 Couper, John, of Tame, yeoman 0
4242901 2110617 2110617 defendant Yeate Leonard smith 633723 633723 Yeate, Leonard, of Tame, smith 1
4504275 2201891 2201891 defendant Roper Richard   633723 633723 Roper, Richard, of Tame 0
4504947 2202089 2202089 defendant Godeman William   633723 633723 Godeman, William, of Tame 0
4510572 2203769 2203769 defendant Harewell William   633723 633723 Harewell, William, of Tame 2
4512217 2204262 2204262 defendant atte More Richard   633723 633723 atte More, Richard, of Tame 1
4520374 2206717 2206717 defendant Glover Thomas   633723 633723 Glover, Thomas, of Tame 0
4551532 2216419 2216419 defendant More Richard   633723 633723 More, Richard, of Tame 0
4586204 2227109 2227109 defendant Horner John   633723 633723 Horner, John, of Tame 0
4586209 2227110 2227110 defendant Horner John   633723 633723 Horner, John, of Tame 0
4602034 2231858 2231858 defendant Palmere Adam   633723 633723 Palmere, Adam, of Tame 0
4609596 2234099 2234099 defendant Falley Thomas tailor 633723 633723 Falley, Thomas, of Tame, tailor 1
4609600 2234100 2234100 defendant Falley Thomas tailor 633723 633723 Falley, Thomas, of Tame, tailor 1
4659114 2248722 2248722 defendant Grynder Agnes widow 633723 633723 Grynder, Agnes, of Tame, widow 0
4747581 2279800 2279800 defendant Bolour John, senior husbandman 633723 633723 Bolour, John, senior, of Tame, husbandman 0
4767315 2285766 2285766 plaintiff Mapulderham Peter   633723 633723 Mapulderham, Peter, of Tame 0
4795570 2294766 2294766 defendant Horsendon Nicholas tailor 633723 633723 Horsendon, Nicholas, of Tame, tailor 0
4795571 2294766 2294766 defendant Falley Thomas tailor 633723 633723 Falley, Thomas, of Tame, tailor 1
4842590 2309218 2309218 defendant Fryday John husbandman 633723 633723 Fryday, John, of Tame, husbandman 0
4856343 2313356 2313356 defendant Wellys Thomas husbandman 633723 633723 Wellys, Thomas, of Tame, husbandman 4
4885774 2322421 2322421 defendant Peyntour Henry painter 633723 633723 Peyntour, Henry, of Tame, painter 0
4919834 2332710 2332710 defendant Longe Thomas husbandman 633723 633723 Longe, Thomas, of Tame, husbandman 1
4932090 2336430 2336430 defendant Glyn Thomas husbandman 633723 633723 Glyn, Thomas, of Tame, husbandman 0
4936821 2337897 2337897 defendant Mucche John husbandman 633723 633723 Mucche, John, of Tame, husbandman 1
5002873 2357743 2357743 defendant Bates William gent 633723 633723 (Bates, William, of Tame, gent 1
5002874 2357743 2357743 defendant Stone Richard ostler 633723 633723 Stone, Richard, of Tame, ostler 2
5076730 2379538 2379538 defendant Benet John yeoman 633723 633723 Benet, John, of Tame, yeoman 0
5498405 2504483 2504483 defendant Glyn alias Boteler John yeoman 633723 633723 Glyn alias Boteler, John, of Tame, yeoman 0
5505146 2506518 2506518 plaintiff Benet John   633723 633723 Benet, John, of Tame 0
5505147 2506518 2506518 defendant Bocher Geoffrey butcher 633723 633723 Bocher, Geoffrey, of Tame, butcher 0
5547909 2519415 2519415 defendant Hyll Thomas butcher 633723 633723 Hyll, Thomas, of Tame, butcher 0
5547910 2519415 2519415 defendant Bartylmewe William butcher 633723 633723 Bartylmewe, William, of Tame, butcher 1
5551687 2520534 2520534 defendant Benet Peter innholder 633723 633723 Benet, Peter, of Tame, innholder 1
5573502 2526810 2526810 defendant Pede William miller 633723 633723 Pede, William, of Tame, miller 0
5579892 2528792 2528792 defendant Cokke Nicholas laborer 633723 633723 Cokke, Nicholas, of Tame, laborer 0
5580396 2528952 2528952 defendant Toursey Henry husbandman 633723 633723 Toursey, Henry, of Tame, husbandman 1
5584058 2530087 2530087 defendant Crest Thomas butcher 633723 633723 Crest, Thomas, of Tame, butcher 0
5584060 2530088 2530088 defendant Croft Thomas butcher 633723 633723 Croft, Thomas, of Tame, butcher 0
5588651 2531459 2531459 defendant Stribilhill Thomas yeoman 633723 633723 Stribilhill, Thomas, of Tame, yeoman 0
5608092 2537437 2537437 defendant Benson Simon barber 633723 633723 Benson, Simon, of Tame, barber 2
5627049 2552429 2552429 defendant Skynner William baker 633723 633723 Skynner, William, of Tame, baker 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);