names

42 rows where place_id = 613197

✎ 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
3697102 1925312 1925312 defendant Smyth Thomas husbandman 613197 613197 Smyth, Thomas, of Bayford, husbandman 1
3910749 1993914 1993914 defendant Smyth Thomas husbandman 613197 613197 Smyth, Thomas, of Bayford, husbandman 0
4448221 2184361 2184361 defendant West William   613197 613197 West, William, of Bayford 1
4500280 2200716 2200716 plaintiff Dekene William   613197 613197 Dekene, William, of Bayford, parson 2
4615620 2235885 2235885 defendant Grace Nicholas   613197 613197 Grace, Nicholas, of Bayford 0
4718034 2270980 2270980 defendant Martyn Walter collier 613197 613197 Martyn, Walter, of Bayford, collier 0
4751029 2280782 2280782 defendant Martyn Walter collier 613197 613197 Martyn, Walter, of Bayford, collier 0
4755342 2282062 2282062 defendant Pere Gilbert husbandman 613197 613197 Pere, Gilbert, of Bayford, husbandman 0
4755344 2282062 2282062 defendant Maleman Thomas yeoman 613197 613197 Maleman, Thomas, of Bayford, yeoman 2
4755345 2282062 2282062 defendant West Robert carpenter 613197 613197 West, Robert, of Bayford, carpenter 3
4755346 2282062 2282062 defendant Bowellis Gilbert carpenter 613197 613197 Bowellis, Gilbert, of Bayford, carpenter 4
4755347 2282062 2282062 defendant Burton John tailor 613197 613197 Burton, John, of Bayford, tailor 5
4761610 2283977 2283977 defendant Bonell Gilbert carpenter 613197 613197 Bonell, Gilbert, of Bayford, carpenter 0
4777252 2288875 2288875 defendant Pere Gilbert husbandman 613197 613197 Pere, Gilbert, of Bayford, husbandman 0
4777254 2288875 2288875 defendant Maltman Thomas yeoman 613197 613197 Maltman, Thomas, of Bayford, yeoman 2
4777255 2288875 2288875 defendant West Robert carpenter 613197 613197 West, Robert, of Bayford, carpenter 3
4777256 2288875 2288875 defendant Boweles Gilbert carpenter 613197 613197 Boweles, Gilbert, of Bayford, carpenter 4
4777257 2288875 2288875 defendant Burton John tailor 613197 613197 Burton, John, of Bayford, tailor 5
4821822 2302899 2302899 defendant Bukberd William husbandman 613197 613197 Bukberd, William, of Bayford, husbandman 0
4821824 2302900 2302900 defendant Mysterton William gent 613197 613197 Mysterton, William, of Bayford, gent 0
4822828 2303223 2303223 defendant atte Halle William husbandman 613197 613197 atte Halle, William, of Bayford, husbandman 1
4897581 2325905 2325905 defendant Smyth Thomas yeoman 613197 613197 Smyth, Thomas, of Bayford, yeoman 0
4899693 2326537 2326537 defendant Fairefax John husbandman 613197 613197 Fairefax, John, of Bayford, husbandman 0
4955592 2343638 2343638 defendant Parker Richard husbandman 613197 613197 Parker, Richard, of Bayford, husbandman 0
4962659 2345739 2345739 defendant Clement Philip husbandman 613197 613197 Clement, Philip, of Bayford, husbandman 3
4972114 2348598 2348598 defendant Fayrfax Richard yeoman 613197 613197 Fayrfax, Richard, of Bayford, yeoman 0
5021357 2363152 2363152 defendant Foster William laborer 613197 613197 Foster, William, of Bayford, laborer 0
5022404 2363452 2363452 defendant Vycary Thomas husbandman 613197 613197 Vycary, Thomas, of Bayford, husbandman 0
5045398 2370253 2370253 defendant atte Hille William laborer 613197 613197 atte Hille, William, of Bayford, laborer 2
5085478 2382144 2382144 defendant Weste John yeoman 613197 613197 Weste, John, of Bayford, yeoman 0
5116310 2391201 2391201 defendant Louthe Robert gent 613197 613197 Louthe, Robert, of Bayford, gent 0
5150073 2401158 2401158 defendant Knyghton John gent 613197 613197 Knyghton, John, of Bayford, gent 1
5264370 2434612 2434612 defendant Smyth William husbandman 613197 613197 Smyth, William, of Bayford, husbandman 0
5284164 2440389 2440389 defendant Fairfax Richard gent 613197 613197 Fairfax, Richard, of Bayford, gent 0
5292950 2442930 2442930 defendant Smyth William husbandman 613197 613197 Smyth, William, of Bayford, husbandman 0
5486722 2500929 2500929 defendant Fulk John laborer 613197 613197 Fulk, John, of Bayford, laborer 1
5493769 2503043 2503043 defendant Bardall William gent 613197 613197 Bardall, William, of Bayford, gent 0
5493770 2503043 2503043 defendant Godfrey John husbandman 613197 613197 Godfrey, John, of Bayford, husbandman 1
5493771 2503043 2503043 defendant Penred Richard husbandman 613197 613197 Penred, Richard, of Bayford, husbandman 2
5515944 2509834 2509834 defendant Bardell William husbandman 613197 613197 Bardell, William, of Bayford, husbandman 3
5515951 2509835 2509835 defendant Bardell William husbandman 613197 613197 Bardell, William, of Bayford, husbandman 3
5538970 2516676 2516676 defendant Vynyng John yeoman 613197 613197 Vynyng, John, of Bayford, 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);