names

63 rows where place_id = 587645

✎ 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
3592032 1865122 1865122 defendant Symmys John husbandman 587645 587645 Symmys, John, of Cherde, husbandman 0
4454119 2186306 2186306 defendant Workeman Nicholas   587645 587645 Workeman, Nicholas, of Cherde 0
4487763 2196891 2196891 defendant Carpenter Walter   587645 587645 Carpenter, Walter, of Cherde 0
4508386 2203108 2203108 plaintiff Adekyns William   587645 587645 Adekyns, William, of Cherde 0
4512976 2204493 2204493 defendant Bremel Robert   587645 587645 Bremel, Robert, of Cherde 0
4534055 2210920 2210920 defendant Attekyn William   587645 587645 Attekyn, William, of Cherde 0
4546716 2214898 2214898 defendant Baker William   587645 587645 Baker, William, of Cherde 0
4600131 2231265 2231265 defendant atte Werthe Walter   587645 587645 atte Werthe, Walter, of Cherde 0
4604838 2232685 2232685 plaintiff Adekyns William   587645 587645 Adekyns, William, of Cherde 0
4606930 2233275 2233275 plaintiff Bassat Richard   587645 587645 Bassat, Richard, of Cherde 0
4620798 2237487 2237487 defendant Foxdych John   587645 587645 Foxdych, John, of Cherde 0
4666779 2255339 2255339 defendant Mone or Move John husbandman 587645 587645 Mone or Move, John, of Cherde, husbandman 1
4671951 2256874 2256874 defendant Tanner Simon husbandman 587645 587645 Tanner, Simon, of Cherde, husbandman 1
4671952 2256874 2256874 defendant Shakelok Walter butcher 587645 587645 Shakelok, Walter, of Cherde, butcher 2
4671953 2256874 2256874 defendant Noreys William butcher 587645 587645 Noreys, William, of Cherde, butcher 3
4671955 2256874 2256874 defendant Deen Robert smith 587645 587645 Deen, Robert, of Cherde, smith 5
4673354 2257305 2257305 defendant Kerver John laborer 587645 587645 Kerver, John, of Cherde, laborer 0
4685745 2261131 2261131 defendant Bondeche William husbandman 587645 587645 Bondeche, William, of Cherde, husbandman 0
4690764 2262651 2262651 defendant Biggenman John husbandman 587645 587645 Biggenman, John, of Cherde, husbandman 3
4690765 2262651 2262651 defendant Adam Thomas laborer 587645 587645 Adam, Thomas, of Cherde, laborer 4
4720360 2271706 2271706 defendant Byggemynam John skinner 587645 587645 Byggemynam, John, of Cherde, skinner 0
4720362 2271707 2271707 defendant Byggemynam John skinner 587645 587645 Byggemynam, John, of Cherde, skinner 0
4730226 2274656 2274656 defendant Webber Walter husbandman 587645 587645 Webber, Walter, of Cherde, husbandman 0
4730227 2274656 2274656 defendant Sadlere Walter husbandman 587645 587645 Sadlere, Walter, of Cherde, husbandman 1
4777956 2289090 2289090 defendant Ekerdon Joan   587645 587645 Ekerdon, Joan, of Cherde, widow of Ekerdon, of Ekerdon, daughter of Noreys, Nicholas 0
4781404 2290192 2290192 defendant Kerver John carpenter 587645 587645 Kerver, John, of Cherde, carpenter 0
4793406 2294043 2294043 defendant Codryngton Geoffrey chaplain 587645 587645 Codryngton, Geoffrey, of Cherde, chaplain 0
4805903 2298055 2298055 defendant Gaunt Peter husbandman 587645 587645 Gaunt, Peter, of Cherde, husbandman 0
4806825 2298345 2298345 defendant Kerver John husbandman 587645 587645 Kerver, John, of Cherde, husbandman 0
4818546 2301880 2301880 defendant Gaunt Peter chapman 587645 587645 Gaunt, Peter, of Cherde, chapman 0
4822516 2303116 2303116 defendant Swayn Henry dyer 587645 587645 Swayn, Henry, of Cherde, dyer 1
4875094 2319164 2319164 defendant Bolter John dyer 587645 587645 Bolter, John, of Cherde, dyer 1
4907334 2328856 2328856 defendant Russell Walter merchant 587645 587645 Russell, Walter, of Cherde, merchant 0
4909566 2329528 2329528 defendant Russell Walter merchant 587645 587645 Russell, Walter, of Cherde, merchant 1
4968643 2347589 2347589 defendant Durke William weaver 587645 587645 Durke, William, of Cherde, weaver 0
5014493 2361101 2361101 defendant Busshell John husbandman 587645 587645 Busshell, John, of Cherde, husbandman 0
5014494 2361101 2361101 defendant Purvyour Richard husbandman 587645 587645 Purvyour, Richard, of Cherde, husbandman 1
5014495 2361101 2361101 defendant Russell Walter merchant 587645 587645 Russell, Walter, of Cherde, merchant 2
5014496 2361101 2361101 defendant Bolt John dyer 587645 587645 Bolt, John, of Cherde, dyer 3
5014497 2361101 2361101 defendant Harrys John husbandman 587645 587645 Harrys, John, of Cherde, husbandman 4
5031622 2366112 2366112 defendant Byrke William yeoman 587645 587645 Byrke, William, of Cherde, yeoman 2
5109240 2389129 2389129 defendant Wolle John husbandman 587645 587645 Wolle, John, of Cherde, husbandman 0
5120807 2392516 2392516 plaintiff Wyseman William glasier 587645 587645 Wyseman, William, of Cherde, glasier 1
5143011 2399080 2399080 defendant Parys William husbandman 587645 587645 Parys, William, of Cherde, husbandman 0
5143013 2399081 2399081 defendant Parys William husbandman 587645 587645 Parys, William, of Cherde, husbandman 0
5212829 2419496 2419496 defendant Godewyn John yeoman 587645 587645 Godewyn, John, of Cherde, yeoman 0
5214004 2419826 2419826 defendant Roucestre William yeoman 587645 587645 Roucestre, William, of Cherde, yeoman 0
5214006 2419827 2419827 defendant Roucestre William yeoman 587645 587645 Roucestre, William, of Cherde, yeoman 0
5218356 2421101 2421101 defendant Sadeler William ostler 587645 587645 Sadeler, William, of Cherde, ostler 0
5232179 2424986 2424986 defendant Roucestre William yeoman 587645 587645 Roucestre, William, of Cherde, yeoman 0
5235260 2425889 2425889 defendant Barbour William yeoman 587645 587645 Barbour, William, of Cherde, yeoman 2
5248303 2429638 2429638 plaintiff Wyseman William glasier 587645 587645 Wyseman, William, of Cherde, glasier 1
5307269 2447176 2447176 defendant Sadeler William sadler 587645 587645 Sadeler, William, of Cherde, sadler 3
5307270 2447176 2447176 defendant Samwise John yeoman 587645 587645 Samwise, John, of Cherde, yeoman 4
5380360 2469432 2469432 defendant Bondyche John hostiller 587645 587645 Bondyche, John, of Cherde, hostiller 1
5380364 2469433 2469433 defendant Tybbe William shoemaker 587645 587645 Tybbe, William, of Cherde, shoemaker 0
5405666 2476696 2476696 plaintiff Selwode Nicholas   587645 587645 Selwode, Nicholas, of Cherde 0
5418695 2480516 2480516 plaintiff Selwode Nicholas   587645 587645 Selwode, Nicholas, of Cherde 0
5436708 2485908 2485908 plaintiff Selwode Nicholas   587645 587645 Selwode, Nicholas, of Cherde 0
5523262 2512105 2512105 defendant Straunge Robert yeoman 587645 587645 Straunge, Robert, of Cherde, yeoman 0
5523263 2512105 2512105 defendant Parys Edward husbandman 587645 587645 Parys, Edward, of Cherde, husbandman 1
5616551 2548975 2548975 plaintiff Hornesbowe Thomas   587645 587645 Hornesbowe, Thomas, of Cherde, vicar 0
5629076 2553064 2553064 defendant Gybbys Walter shoemaker 587645 587645 Gybbys, Walter, of Cherde, shoemaker 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);