names

60 rows where place_id = 592341

✎ 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
3607400 1869975 1869975 defendant Debenham John, senior husbandman 592341 592341 Debenham, John, senior, of Bergh, husbandman 3
3607405 1869976 1869976 defendant Debenham John, senior husbandman 592341 592341 Debenham, John, senior, of Bergh, husbandman 2
3622934 1874701 1874701 defendant Debenham John, senior husbandman 592341 592341 Debenham, John, senior, of Bergh, husbandman 2
3709874 1929403 1929403 plaintiff Rokett John (legal representative) 592341 592341 Rokett, John, of Bergh, clerk, executor of 0
3709878 1929404 1929404 plaintiff Rokett John (legal representative) 592341 592341 Rokett, John, of Bergh, clerk, executor of 0
3709881 1929405 1929405 plaintiff Rokett John (legal representative) 592341 592341 Rokett, John, of Bergh, clerk, executor of 0
3715560 1931152 1931152 defendant Turnour William carpenter 592341 592341 Turnour, William, of Bergh, carpenter 0
3715562 1931153 1931153 defendant Turnour William carpenter 592341 592341 Turnour, William, of Bergh, carpenter 0
3739194 1938475 1938475 defendant Turnor William carpenter 592341 592341 Turnor, William, of Bergh, carpenter 0
3807579 1960277 1960277 defendant Clerke Robert husbandman 592341 592341 Clerke, Robert, of Bergh, husbandman 0
3807580 1960277 1960277 defendant Belcounger William husbandman 592341 592341 Belcounger, William, of Bergh, husbandman 1
3807581 1960277 1960277 defendant Bransby William husbandman 592341 592341 Bransby, William, of Bergh, husbandman 2
3807582 1960277 1960277 defendant Wodyard Richard husbandman 592341 592341 Wodyard, Richard, of Bergh, husbandman 3
3807583 1960277 1960277 defendant Sewall Robert husbandman 592341 592341 Sewall, Robert, of Bergh, husbandman 4
3954735 2008721 2008721 defendant Cooke John (legal representative) 592341 592341 Cooke, John, of Bergh, husbandman, executors of 0
3954736 2008721 2008721 defendant Turnor Richard husbandman 592341 592341 (Turnor, Richard, of Bergh, husbandman 1
3961494 2011118 2011118 defendant Thrower Robert husbandman 592341 592341 Thrower, Robert, of Bergh, husbandman 0
3961496 2011119 2011119 defendant Thrower Robert husbandman 592341 592341 Thrower, Robert, of Bergh, husbandman 0
4042005 2039628 2039628 defendant Ives John carpenter 592341 592341 Ives, John, of Bergh, carpenter 0
4444280 2183198 2183198 defendant Draycote John   592341 592341 Draycote, John, of Bergh 0
4455779 2186823 2186823 defendant Broughton Thomas de   592341 592341 Broughton, Thomas de, of Bergh 3
4455780 2186823 2186823 defendant Michel Thomas   592341 592341 Michel, Thomas, of Bergh 4
4485479 2196166 2196166 plaintiff Randolf John   592341 592341 Randolf, John, of Bergh 0
4492314 2198272 2198272 defendant Clerk John   592341 592341 Clerk, John, of Bergh 3
4497499 2199862 2199862 defendant Tournour Robert   592341 592341 Tournour, Robert, of Bergh 1
4525726 2208348 2208348 plaintiff Joye Robert   592341 592341 Joye, Robert, of Bergh 0
4541806 2213326 2213326 defendant turnour Nicholas   592341 592341 turnour, Nicholas, of Bergh 3
4564751 2220538 2220538 defendant Roblard Robert   592341 592341 Roblard, Robert, of Bergh 2
4582356 2225924 2225924 defendant Austyn John   592341 592341 Austyn, John, of Bergh 0
4630679 2240500 2240500 defendant Turnour Robert   592341 592341 Turnour, Robert, of Bergh 1
4630788 2240520 2240520 defendant Barkere Roger   592341 592341 Barkere, Roger, of Bergh 1
4649352 2245861 2245861 defendant Wryght Robert   592341 592341 Wryght, Robert, of Bergh 0
4660387 2249075 2249075 defendant Dodworth William yeoman 592341 592341 Dodworth, William, of Bergh, yeoman 0
4661562 2249448 2249448 defendant Bergh Geoffrey husbandman 592341 592341 Bergh, Geoffrey, of Bergh, husbandman 0
4759747 2283390 2283390 defendant Kirkeby Thomas yeoman 592341 592341 Kirkeby, Thomas, of Bergh, yeoman 1
4762799 2284345 2284345 defendant Pottere Robert   592341 592341 Pottere, Robert, of Bergh, parson 0
4767514 2285818 2285818 plaintiff Marten Thomas   592341 592341 Marten, Thomas, of Bergh 0
4776235 2288558 2288558 defendant Jakson John husbandman 592341 592341 Jakson, John, of Bergh, husbandman 1
4798904 2295831 2295831 defendant Busshop Thomas clerk 592341 592341 Busshop, Thomas, of Bergh, clerk 5
4801275 2296586 2296586 defendant Pottere Robert clerk 592341 592341 Pottere, Robert, of Bergh, clerk 0
4808965 2298977 2298977 defendant Goldyngham Henry husbandman 592341 592341 Goldyngham, Henry, of Bergh, husbandman 0
4877858 2320035 2320035 defendant Deye Richard yeoman 592341 592341 Deye, Richard, of Bergh, yeoman 4
4932599 2336587 2336587 defendant Wilbys Willam yeoman 592341 592341 Wilbys, Willam, of Bergh, yeoman 2
4954292 2343255 2343255 defendant Wodward John husbandman 592341 592341 Wodward, John, of Bergh, husbandman 3
4954293 2343255 2343255 defendant Aubray Thomas husbandman 592341 592341 Aubray, Thomas, of Bergh, husbandman 4
4979718 2350890 2350890 plaintiff Skelton Richard   592341 592341 Skelton, Richard, of Bergh 0
4985175 2352496 2352496 defendant Halle John clerk 592341 592341 Halle, John, of Bergh, clerk 0
5028222 2365128 2365128 defendant Milner John yeoman 592341 592341 Milner, John, of Bergh, yeoman 0
5034425 2366929 2366929 defendant Skelton Richard yeoman 592341 592341 Skelton, Richard, of Bergh, yeoman 0
5073898 2378685 2378685 defendant Salvan John   592341 592341 Salvan, John, of Bergh, knight 0
5338967 2456759 2456759 plaintiff Lyncolne William   592341 592341 Lyncolne, William, of Bergh 0
5390918 2472469 2472469 plaintiff Neweman Agnes   592341 592341 Neweman, Agnes, of Bergh 7
5447191 2489047 2489047 defendant Arbery Thomas husbandman 592341 592341 Arbery, Thomas, of Bergh, husbandman 0
5554369 2521315 2521315 plaintiff Herdyngham John   592341 592341 Herdyngham, John, of Bergh 0
5574633 2527140 2527140 defendant Merssh Robert nailer 592341 592341 Merssh, Robert, of Bergh, nailer 0
5574634 2527140 2527140 defendant Merssh Richard husbandman 592341 592341 Merssh, Richard, of Bergh, husbandman 1
5574635 2527140 2527140 defendant Skelton William laborer 592341 592341 Skelton, William, of Bergh, laborer 2
5616921 2549102 2549102 plaintiff Kay Roger   592341 592341 Kay, Roger, of Bergh 0
5618789 2549714 2549714 defendant Godwyn William chaplain 592341 592341 Godwyn, William, of Bergh, chaplain 1
5636887 2555479 2555479 defendant Dodworth William yeoman 592341 592341 Dodworth, William, of Bergh, 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);