names

47 rows where place_id = 594981

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618355 1873372 1873372 defendant Clerk John husbandman 594981 594981 Clerk, John, of Seggeford, husbandman 1
3618356 1873372 1873372 defendant Fynch Robert husbandman 594981 594981 Fynch, Robert, of Seggeford, husbandman 2
3618358 1873372 1873372 defendant Orwell Thomas husbandman 594981 594981 Orwell, Thomas, of Seggeford, husbandman 4
3728868 1935277 1935277 defendant Elger John yeoman 594981 594981 Elger, John, of Seggeford, yeoman 0
3740509 1938890 1938890 defendant Drake Henry chaplain 594981 594981 Drake, Henry, of Seggeford, chaplain 0
3746901 1940947 1940947 defendant Smyth Nicholas husbandman 594981 594981 Smyth, Nicholas, of Seggeford, husbandman 0
3760327 1945233 1945233 defendant Smyth Nicholas husbandman 594981 594981 Smyth, Nicholas, of Seggeford, husbandman 0
3770561 1948476 1948476 defendant Broke Thomas husbandman 594981 594981 Broke, Thomas, of Seggeford, husbandman 0
3789847 1954652 1954652 defendant Blakeberd Robert husbandman 594981 594981 Blakeberd, Robert, of Seggeford, husbandman 1
3862956 1977806 1977806 defendant Russell Henry gent 594981 594981 Russell, Henry, of Seggeford, gent 0
3881112 1983953 1983953 defendant Akers John husbandman 594981 594981 Akers, John, of Seggeford, husbandman 1
3881113 1983953 1983953 defendant Elgare Robert husbandman 594981 594981 Elgare, Robert, of Seggeford, husbandman 2
4660974 2249257 2249257 defendant Barkere Thomas barker 594981 594981 Barkere, Thomas, of Seggeford, barker 0
4798468 2295703 2295703 defendant Bocher Robert yeoman 594981 594981 Bocher, Robert, of Seggeford, yeoman 3
4878593 2320249 2320249 defendant Hicche John yeoman 594981 594981 Hicche, John, of Seggeford, yeoman 1
4878596 2320249 2320249 defendant Bastard Thomas laborer 594981 594981 Bastard, Thomas, of Seggeford, laborer 4
4940679 2339115 2339115 defendant Hycche Robert husbandman 594981 594981 Hycche, Robert, of Seggeford, husbandman 0
4967096 2347090 2347090 defendant Bulwer Alan husbandman 594981 594981 Bulwer, Alan, of Seggeford, husbandman 4
5062433 2375330 2375330 defendant Cosyn Richard husbandman 594981 594981 Cosyn, Richard, of Seggeford, husbandman 1
5070455 2377655 2377655 defendant Sherman John husbandman 594981 594981 Sherman, John, of Seggeford, husbandman 1
5070456 2377655 2377655 defendant Bryghmere John husbandman 594981 594981 Bryghmere, John, of Seggeford, husbandman 2
5070457 2377655 2377655 defendant Brokke Thomas husbandman 594981 594981 Brokke, Thomas, of Seggeford, husbandman 3
5123144 2393203 2393203 defendant Smyth Thomas husbandman 594981 594981 Smyth, Thomas, of Seggeford, husbandman 0
5153050 2402037 2402037 defendant Smyth Giles smith 594981 594981 Smyth, Giles, of Seggeford, smith 0
5170608 2407127 2407127 defendant Smyth Giles smith 594981 594981 Smyth, Giles, of Seggeford, smith 0
5263383 2434296 2434296 defendant Derham Richard husbandman 594981 594981 Derham, Richard, of Seggeford, husbandman 0
5263384 2434296 2434296 defendant Brocke Thomas husbandman 594981 594981 Brocke, Thomas, of Seggeford, husbandman 1
5263387 2434296 2434296 defendant Burnham Thomas (legal representative) 594981 594981 Burnham, Thomas, of Seggeford, yeoman, executors of 4
5263388 2434296 2434296 defendant Burnham Robert husbandman 594981 594981 (Burnham, Robert, of Seggeford, husbandman 5
5273512 2437327 2437327 defendant Derham Richard yeoman 594981 594981 Derham, Richard, of Seggeford, yeoman 1
5278648 2438861 2438861 defendant Brikke Thomas yeoman 594981 594981 Brikke, Thomas, of Seggeford, yeoman 0
5278649 2438861 2438861 defendant Colyn William husbandman 594981 594981 Colyn, William, of Seggeford, husbandman 1
5325345 2452667 2452667 defendant Geyton Thomas gent 594981 594981 Geyton, Thomas, of Seggeford, gent 1
5417128 2480028 2480028 defendant Dynne Gilbert yeoman 594981 594981 Dynne, Gilbert, of Seggeford, yeoman 1
5442588 2487699 2487699 defendant Browester William clerk 594981 594981 Browester, William, of Seggeford, clerk 0
5442590 2487699 2487699 defendant Clerk Thomas husbandman 594981 594981 Clerk, Thomas, of Seggeford, husbandman 2
5449685 2489794 2489794 defendant Dynne Gilbert yeoman 594981 594981 Dynne, Gilbert, of Seggeford, yeoman 1
5467539 2495223 2495223 defendant Adnrewe John husbandman 594981 594981 Adnrewe, John, of Seggeford, husbandman 0
5467540 2495223 2495223 defendant Thompson John husbandman 594981 594981 Thompson, John, of Seggeford, husbandman 1
5478479 2498592 2498592 defendant Dynne Gilbert husbandman 594981 594981 Dynne, Gilbert, of Seggeford, husbandman 0
5478480 2498592 2498592 defendant Acre Robert husbandman 594981 594981 Acre, Robert, of Seggeford, husbandman 1
5478486 2498594 2498594 defendant Derham Richard yeoman 594981 594981 Derham, Richard, of Seggeford, yeoman 1
5478487 2498594 2498594 defendant Thompson John husbandman 594981 594981 Thompson, John, of Seggeford, husbandman 2
5478831 2498689 2498689 defendant Andrewe John husbandman 594981 594981 Andrewe, John, of Seggeford, husbandman 1
5478832 2498689 2498689 defendant Tompson John husbandman 594981 594981 Tompson, John, of Seggeford, husbandman 2
5567555 2525084 2525084 defendant Elger John   594981 594981 Elger, John, of Seggeford 0
5567556 2525084 2525084 defendant Clerke John weaver 594981 594981 Clerke, John, of Seggeford, weaver 1

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);