names

53 rows where place_id = 606557

✎ 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
3665662 1915210 1915210 defendant Michell John husbandman 606557 606557 Michell, John, of Wynkelegh Keynes, husbandman 0
4585215 2226799 2226799 defendant Michell William   606557 606557 Michell, William, of Wynkelegh Keynes 0
4724478 2272950 2272950 defendant Adelard William shoemaker 606557 606557 Adelard, William, of Wynkelegh Keynes, shoemaker 0
4796188 2294959 2294959 defendant Forde John tailor 606557 606557 Forde, John, of Wynkelegh Keynes, tailor 1
4913007 2330564 2330564 defendant Boure William laborer 606557 606557 Boure, William, of Wynkelegh Keynes, laborer 4
4913008 2330564 2330564 defendant Toker Thomas weaver 606557 606557 Toker, Thomas, of Wynkelegh Keynes, weaver 5
4913009 2330564 2330564 defendant Callerd Richard smith 606557 606557 Callerd, Richard, of Wynkelegh Keynes, smith 6
4913010 2330564 2330564 defendant Bourne John husbandman 606557 606557 Bourne, John, of Wynkelegh Keynes, husbandman 7
4946308 2340834 2340834 defendant Bysshop John husbandman 606557 606557 Bysshop, John, of Wynkelegh Keynes, husbandman 0
4957956 2344349 2344349 defendant Neweton John mercer 606557 606557 Neweton, John, of Wynkelegh Keynes, mercer 0
4957958 2344349 2344349 defendant Grete Walter husbandman 606557 606557 Grete, Walter, of Wynkelegh Keynes, husbandman 2
4959917 2344926 2344926 defendant Weye John yeoman 606557 606557 Weye, John, of Wynkelegh Keynes, yeoman 0
4962998 2345845 2345845 defendant Kyngedon Nicholas   606557 606557 Kyngedon, Nicholas, of Wynkelegh Keynes, bailiff 10
4967740 2347296 2347296 defendant Weye William butcher 606557 606557 Weye, William, of Wynkelegh Keynes, butcher 0
4972406 2348677 2348677 defendant Fox William weaver 606557 606557 Fox, William, of Wynkelegh Keynes, husbandman, together with Touker, Thomas, of Wynkelegh Keynes, weaver 0
4972408 2348678 2348678 defendant Touker John shoemaker 606557 606557 Touker, John, of Wynkelegh Keynes, shoemaker 0
4972409 2348678 2348678 defendant Michell William husbandman 606557 606557 together with Michell, William, of Wynkelegh Keynes, husbandman 1
4972410 2348678 2348678 defendant Adeler Roger pardoner 606557 606557 Adeler, Roger, of Wynkelegh Keynes, pardoner 2
4988302 2353471 2353471 defendant Galdesore Thomas husbandman 606557 606557 Galdesore, Thomas, of Wynkelegh Keynes, husbandman 0
4988303 2353471 2353471 defendant Badecok Henry husbandman 606557 606557 Badecok, Henry, of Wynkelegh Keynes, husbandman 1
5005917 2358632 2358632 defendant Toker Thomas weaver 606557 606557 Toker, Thomas, of Wynkelegh Keynes, weaver 0
5021579 2363210 2363210 defendant Badecok William tailor 606557 606557 Badecok, William, of Wynkelegh Keynes, tailor 0
5027791 2365006 2365006 defendant Skynner John clerk 606557 606557 Skynner, John, of Wynkelegh Keynes, clerk 0
5063966 2375753 2375753 defendant Michell William, junior husbandman 606557 606557 Michell, William, junior, of Wynkelegh Keynes, husbandman 0
5063967 2375753 2375753 defendant Gay John husbandman 606557 606557 Gay, John, of Wynkelegh Keynes, husbandman 1
5063968 2375753 2375753 defendant Wannak Thomas husbandman 606557 606557 Wannak, Thomas, of Wynkelegh Keynes, husbandman 2
5070093 2377549 2377549 defendant Michell William, junior husbandman 606557 606557 Michell, William, junior, of Wynkelegh Keynes, husbandman 1
5077032 2379628 2379628 defendant Culme John husbandman 606557 606557 Culme, John, of Wynkelegh Keynes, husbandman 0
5079727 2380422 2380422 defendant Skynner John clerk 606557 606557 Skynner, John, of Wynkelegh Keynes, clerk 0
5079728 2380423 2380423 plaintiff Caylewey Jón clerk 606557 606557 Caylewey, Jón, of Wynkelegh Keynes, clerk 0
5079729 2380423 2380423 defendant Skynner John clerk 606557 606557 Skynner, John, of Wynkelegh Keynes, clerk 0
5188285 2412284 2412284 defendant Michell William husbandman 606557 606557 Michell, William, of Wynkelegh Keynes, husbandman 3
5199438 2415585 2415585 plaintiff Way John   606557 606557 Way, John, of Wynkelegh Keynes 0
5199440 2415585 2415585 defendant Moys Roger husbandman 606557 606557 Moys, Roger, of Wynkelegh Keynes, husbandman 0
5199442 2415585 2415585 defendant Touker Thomas weaver 606557 606557 Touker, Thomas, of Wynkelegh Keynes, weaver 2
5205979 2417480 2417480 defendant Michell William husbandman 606557 606557 Michell, William, of Wynkelegh Keynes, husbandman 5
5206738 2417706 2417706 defendant Kaynes Christine widow 606557 606557 Kaynes, Christine, of Wynkelegh Keynes, widow 5
5254890 2431645 2431645 defendant Fox Thomas clerk 606557 606557 Fox, Thomas, of Wynkelegh Keynes, clerk 0
5254891 2431645 2431645 defendant Skynner Thomas husbandman 606557 606557 Skynner, Thomas, of Wynkelegh Keynes, husbandman 1
5254892 2431645 2431645 defendant Michell Nicholas yeoman 606557 606557 Michell, Nicholas, of Wynkelegh Keynes, yeoman 2
5254893 2431645 2431645 defendant Toker John husbandman 606557 606557 Toker, John, of Wynkelegh Keynes, husbandman 3
5260652 2433458 2433458 defendant Brigman John yeoman 606557 606557 Brigman, John, of Wynkelegh Keynes, yeoman 3
5272880 2437143 2437143 defendant Skynner John clerk 606557 606557 Skynner, John, of Wynkelegh Keynes, clerk 3
5280820 2439462 2439462 defendant Michell Nicholas yeoman 606557 606557 Michell, Nicholas, of Wynkelegh Keynes, yeoman 4
5280821 2439462 2439462 defendant Toker Thomas shoemaker 606557 606557 Toker, Thomas, of Wynkelegh Keynes, shoemaker 5
5420757 2481133 2481133 defendant Pytford John yeoman 606557 606557 Pytford, John, of Wynkelegh Keynes, yeoman 0
5425769 2482674 2482674 defendant Holwyll William husbandman 606557 606557 Holwyll, William, of Wynkelegh Keynes, husbandman 2
5425770 2482674 2482674 defendant Makesho Richard husbandman 606557 606557 Makesho, Richard, of Wynkelegh Keynes, husbandman 3
5429119 2483634 2483634 defendant Holywyll Nicholas husbandman 606557 606557 Holywyll, Nicholas, of Wynkelegh Keynes, husbandman 0
5444153 2488155 2488155 defendant Holwyll William husbandman 606557 606557 Holwyll, William, of Wynkelegh Keynes, husbandman 2
5448160 2489340 2489340 defendant Cranbury William   606557 606557 Cranbury, William, of Wynkelegh Keynes 0
5448161 2489340 2489340 defendant Davy John shoemaker 606557 606557 Davy, John, of Wynkelegh Keynes, shoemaker 1
5536386 2515868 2515868 defendant Luxston William yeoman 606557 606557 Luxston, William, of Wynkelegh Keynes, 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);